Sp_Salesdevplan_CommonGtChar (procedure)
项目立项甘特图
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sLoginId |
varchar(100) |
| 2 | IN | sBrId |
varchar(100) |
| 3 | IN | sSuId |
varchar(100) |
| 4 | IN | bFilter |
varchar(5000) |
| 5 | IN | sFilterOrderBy |
varchar(5000) |
| 6 | IN | sGroupby_select_sql |
varchar(5000) |
| 7 | IN | sGroupby_group_sql |
varchar(5000) |
| 8 | OUT | sCode |
int |
| 9 | OUT | sReturn |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpSalesdevplan_CommonGtChar'._
Narrative
Business context: PLM管理 → 研发项目管理(雅昌) → 项目进度 → 项目进度甘特图 — Gantt-chart data feed for salsalesdevplanmaster/salsalesdevplanslave (项目立项 master/slave). Returns the JSON ({zoom,data,links}) consumed by the dhtmlxGantt-style front-end. The header constant on the wiki page (项目立项甘特图) is the proc's COMMENT; the actual form name in gdsconfigformmaster is 项目进度甘特图.
What it does: Builds a temporary table tmp_gt_PlanInfo from salsalesdevplanmaster joined to salsalesdevplanslave (filtered to bCheck=1, bInvalid=0 and tenant), translates the optional bFilter JSON to a WHERE-clause via Fun_bFilter_toWhere. Iterates the master rows with a cursor, emitting one data entry per master (id/text/start_date/end_date/parent) and then, for each child slave row, emits a second data entry plus a link joining successive slaves in iOrder sequence. Returns the assembled JSON in sReturn with zoom={scale:Minutes,step:30}.
Invocation: Bound as the data-source of the 项目进度甘特图 form gfm.sId=101251240115016149122423040 via gdsconfigformmaster.sSqlStr='Sp_Salesdevplan_CommonGtChar' — under module 项目进度 (parent: 研发项目管理(雅昌)). Loaded when the user opens the gantt board. Install script: script/标版/30100101/Sp_Salesdevplan_CommonGtChar.sql; form-master row in script/标版/20210323/gdsconfigformmaster.sql.