Fun_GetTestMaterialsCount (function)
获取字符串中数字
- Type: FUNCTION
-
Returns:
int - Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | tCreateDate |
datetime |
| 2 | IN | sMaterialsId |
varchar(100) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunGetTestMaterialsCount'._
Narrative
Business context: Per-material sample-order monthly counter — sibling of Fun_GetTestCount. Counts how many sample-order (sOrderType=5) line rows reference a given material sId within the calendar month of tCreateDate. Used to gauge per-material 打样 frequency. The header comment 获取字符串中数字 is wrong/copy-pasted from Fun_GetNum.
What it does: joins salsalesorderslave to salsalesordermaster, filters sOrderType=5, sMaterialsId=sMaterialsId, and the same [YYYY-MM-01, next-month-01) month window. Counts sId.
Invocation: no form-master sSqlStr, gdsmodule hook, other routine, or xly-src reference uses this function. Status: appears orphaned. No caller found in any channel — candidate for maintainer audit.