Sp_Bd_bi19.md 1.87 KB

Edit Raw Blame History Permalink



Sp_Bd_bi19 (procedure)


@author:zhucx
                            @date:20211224 
                            @describe: 糊盒车间


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL


Parameters


#
Mode
Name
Type


1
IN
iFlag
int


2
IN
iTmpCheck
int


3
IN
sFormGuid
varchar(100)


4
IN
sGuid
varchar(100)


5
IN
sLoginId
varchar(100)


6
OUT
sReturn
varchar(4000)


7
IN
sBrId
varchar(100)


8
IN
sSuId
varchar(100)


9
OUT
sCode
int


Body

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


Narrative

Business context: 糊盒车间 workshop dashboard (kanban) — board procedure for the 糊盒 (carton-gluing/boxing) workshop in the Sp_Bd_bi<n> workshop-board family. Returns the per-machine current-shift status block consumed by the 看板/dashboard page.

What it does: Same shape as siblings Sp_Bd_bi16/Sp_Bd_bi17/Sp_Bd_bi18 — seeds p_Bd_PlcNo_No with seven 糊盒 machine PLC numbers (25,29,14,15,16,17,28,...), cursor-iterates per machine, reads current 工单 / 班组 / 设备状态 via viw_plc_machine, joins mftworkordermaster+mftworkorderprocess, computes 实际/标准/偏差 调机时间 + 当前色号 + 完成版数/模数 from plc_machinedata, aggregates into p_Bd_workshop5 and emits a {"data":[...]} JSON.

Invocation: Installed by xly-src/script/标版/30100101/kanban/Sp_Bd_bi19-糊盒.sql. No form-master sSqlStr, no gdsmodule hook, no other-routine caller, no Java caller. Status: appears reachable only via an external dashboard HTTP endpoint that invokes the proc by name. Per wiki scope, kanban dashboard procs sit outside the routine call-graph wiring tracked in this catalog.

Tenant note: iPlcNo literals are deployment-specific.