# `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 PROCEDURE `Sp_fstj_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.