Sp_chart_expenses (procedure)
PLC数据同步
- 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_expenses'._
Narrative
Business context: 财务 / 仪表盘 — today's-expenses pie/bar tile. Sums payment-master dTotalMoney for today, grouped by 费用类别 (sisexpense.sName), and emits the JSON envelope a front-end chart tile expects (unit "元", legend on, ordered by total descending).
What it does: Single aggregation over cahpaymentmaster joined to sisexpense (by sExpenseId), restricted to checked rows where tCreateDate falls on today's date and tenant matches sBrId/sSuId. Wraps the GROUP_CONCAT('{"x":"<name>","y":<money>}') output into {"data":[...], "hasLegend":true, "subTitle":"单位:元", "valueFormat":false, "lineWidth":5} and assigns to OUT sReturn.
Invocation: Status: appears orphaned. No form-master, gdsmodule hook, other-routine caller, or Java caller — only its install script script/标版/30100101/Sp_chart_expenses.sql. Belongs to the dashboard-tile family whose bindings, if any, live in front-end config; the caption "PLC数据同步" shown above (auto-pulled from a sibling proc's sChinese) is misleading.