Fun_getMoneyFormart (function)
根据key值获取json字符串值
- Type: FUNCTION
-
Returns:
text - Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sMoney |
varchar(255) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFungetMoneyFormart'._
Narrative
Business context: Amount-in-words digit splitter for printed invoices / 收据 — pads sMoney to 9 integer digits + 2 decimal digits, then emits each position as a comma-separated cell value, substituting null for leading blanks. Lets a report template render the digit columns 亿/千万/百万/.../角/分 separately.
What it does: Floors sMoney to integer, LPADs to 9 chars with *, walks each char and appends either the digit or 'null'; repeats for the 2-digit fractional part; returns the comma-joined string, or 11 commas of null when sMoney <= 0.
Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep beyond the routine's own deployment SQL) — candidate for maintainer audit. The catalog header 根据key值获取json字符串值 was copy-pasted from a JSON helper and is wrong.