Sp_fstj_details (procedure)

放数统计明细-wx-12-17

• Type: PROCEDURE
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	tStartDate	datetime
2	IN	tEndDate	datetime
3	IN	iType	varchar(100)
4	IN	sLoginId	varchar(100)
5	IN	sBrId	varchar(100)
6	IN	sSuId	varchar(100)
7	IN	bFilter	longtext
8	IN	pageNum	int
9	IN	pageSize	int
10	OUT	totalCount	int
11	IN	countCloumn	longtext
12	OUT	countMapJson	longtext
13	IN	sFilterOrderBy	longtext
14	IN	sGroupby_select_sql	longtext
15	IN	sGroupby_group_sql	longtext

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpfstj_details'._

Narrative

Business context: Header banner 放数统计明细-wx-12-17 (放数 = 缩放/印刷放尺数量, "stretch/let-out quantity statistics detail" — production-report shape used on the printing shop floor). Reads from viw_mftworkorderafterqty (post-press work-order quantity view) joined to customer / sales-order / product / material masters. Parameter shape matches the standard form-master Sp_…_*details report dispatcher: pagination + bFilter + countCloumn + sFilterOrderBy.

What it does: Builds temp table TmpSalSalesCheck_sum with the 放数 columns (sBillNo, tCreateDate, sCustomerName, sBillType, sProductClassifyName0/Name, sProductName, sPartsName, sMaterialsStyle, dProductQty, dStretchQty, dSumMachineQty, dProductInStoreQty, dRemainderQty, dTotalMachineQty, dStretchRate, dMaterialsKQty, …). Composes a dynamic SQL INSERT that pulls from viw_mftworkorderafterqty A LEFT JOIN elecustomer EC / salsalesorderslave SA / eleproduct EP / sisproductclassify SIC,SIM / elematerials EM, applies Fun_bFilter_toWhere over bFilter (with column-alias remap A.sCustomerName→EC.sCustomerName, etc.), and pages via LIMIT (pageNum-1)*pageSize, pageSize. A second prepared statement computes SUM(dProductQty, dStretchQty, dSumMachineQty, dTotalMachineQty) and packs them into countMapJson via JSON_OBJECT. Finally returns SELECT A.* FROM TmpSalSalesCheck_sum.

Invocation: Status: appears orphaned. No caller found in any channel — no gdsmodule hook, no gdsconfigformmaster reference, no other proc CALLs it, no xly-src grep hit. The -wx-12-17 banner suggests a customer-named variant ("wx" = 微信 / a customer code, dated 12-17); likely a deprecated report. Candidate for maintainer audit.