Sp_Manufacture_MftPlanPhase.md 1.63 KB

Edit Raw Blame History



Sp_Manufacture_MftPlanPhase (procedure)


@author:  zhucx                 @date:20220308  封存                @describe :               生产计划跟进(成品)                                            1.从计算表中取数据                                 2.按成品数据汇总，每个阶段取最后工序作为完结条件并显示


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL

Created: 2026-04-27 19:10:36

Last altered: 2026-04-27 19:10:36


Parameters


#
Mode
Name
Type


1
IN
sCustomerName
varchar(255)


2
IN
tStartDate
datetime


3
IN
tEndDate
datetime


4
IN
sWorkOrderNos
varchar(255)


5
IN
sPhase
varchar(255)


6
IN
sPhaseplanDate
varchar(255)


7
IN
iType
int


8
IN
sEmpty
varchar(255)


9
IN
sComplete
varchar(255)


10
IN
sLoginId
varchar(4000)


11
IN
sBrId
varchar(100)


12
IN
sSuId
varchar(100)


13
IN
bFilter
varchar(5000)


14
IN
pageNum
int


15
IN
pageSize
int


16
OUT
totalCount
int


17
OUT
billNum
int


18
IN
countCloumn
varchar(5000)


19
OUT
countMapJson
longtext


20
IN
sFilterOrderBy
varchar(5000)


21
IN
sGroupby_select_sql
varchar(5000)


22
IN
sGroupby_group_sql
varchar(5000)


Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpManufacture_MftPlanPhase'._


Narrative

No human-written narrative yet.