Sp_chart_TodayOrder (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 | OUT | sCode |
int |
| 6 | OUT | sReturn |
varchar(5000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpchart_TodayOrder'._
Narrative
Business context: 财务图表分析 → 图表分析 → 决策支持 and 移动端工作台 → 图表分析 — the dashboard cards 本月订单 / 今日工单 break down today's checked work-order production value by product classification for a quick "where today's money is coming from" view.
What it does: Joins viw_mftworkorder to eleproduct and sisproductclassify, filters to today's tCheckDate (DATE_FORMAT(...,'%Y-%m-%d') = today), checked rows with dProductMoney > 0 for the current brand/subsidiary, sums by classification, and emits a JSON pie payload {data: [{x,y}…], hasLegend:true, subTitle:'单位:元'}.
Invocation: Bound via gdsconfigcharmaster.sProcedureName on chart cards 15934040990002317635045502862300 (财务图表分析) and 15948862530009779157993911986000 (移动端工作台 图表分析).