# `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 PROCEDURE `Sp_chart_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` (移动端工作台 图表分析).