# `Sp_Task_TodayMoneySmallai` (procedure)

> 小ai保驾护航-当日货币资金报告


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | OUT | `cardTitle` | `varchar(255)` |
| 2 | OUT | `title` | `varchar(255)` |
| 3 | OUT | `sAbstract` | `varchar(255)` |
| 4 | OUT | `cardDate` | `varchar(255)` |
| 5 | OUT | `itemMemo` | `varchar(255)` |
| 6 | OUT | `sCode` | `int` |
| 7 | OUT | `sReturn` | `longtext` |
| 8 | OUT | `sUserList` | `longtext` |
| 9 | OUT | `sUserData` | `longtext` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Task_TodayMoneySmallai`'`._

## Narrative

**Business context:** 小ai保驾护航 — scheduled push of the 今日货币资金 (today's cash-on-hand) digest. Member of the `Sp_Task_*` quartz-scheduled message family.

**What it does:** Defaults `sBrId/sSuId/sCode`, sets the cash-position title, then `CALL Sp_Cashier_SumJournalTodayMoney` to load the `Cash` working set (`sBankName`, `dBalanceMoney`, `dInMoney`, `dOutMoney`). Composes `cardTitle` ("截至今天货币资金合计…万元"), inserts per-account rows into `Sp_Task_doTestMsg` (帐户余额 / 今日入账 / 今日支出 with conditional `color: #00ff21` for non-zero values).

**Invocation:** Dispatched by the Quartz scheduler — `QuartzTask` (xlyFlow) calls `TaskServiceImpl.doProOne()` with the scheduler-job config's `sProcedureName`; `sendMsgDoNew(...)` renders via the configured `sMestemplateId`. Install script `script/标版/30100101/Sp_Task_TodayMoneySmallai.sql`; no `gdsmodule`/form-master binding.