Sp_SalSalesCheck_1227 (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sLoginId |
varchar(100) |
| 2 | IN | sCustomerId |
varchar(100) |
| 3 | IN | sBrId |
varchar(100) |
| 4 | IN | sSuId |
varchar(100) |
| 5 | IN | bFilter |
text |
| 6 | IN | sUnTaskFormId |
varchar(100) |
| 7 | IN | pageNum |
int |
| 8 | IN | pageSize |
int |
| 9 | OUT | totalCount |
int |
| 10 | IN | countCloumn |
text |
| 11 | OUT | countMapJson |
longtext |
| 12 | IN | sFilterOrderBy |
text |
| 13 | IN | sGroupby_select_sql |
text |
| 14 | IN | sGroupby_group_sql |
text |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpSalSalesCheck_1227'._
Narrative
Business context: 销售管理 → 销售对账/开票流程 → 销售对账 (salsalescheckingmaster / salsalescheckingslave) — date-suffixed snapshot of the standard "未对账印件清单" data-source proc Sp_SalSalesCheck, kept around from a 12-27 (Dec 27) build. Same 14-parameter pager signature, same CbxSrcNoCheck / NetMoney / NetPrice / CkxWebNotInFinance setting reads, same branch on p_sBillType (delivergoods etc.) and same Viw_SalDeliverGoods join pattern as the production Sp_SalSalesCheck.
What it does: Reads SysSystemSettings (CbxSrcNoCheck to pick the 未对账来源 bill type, NetMoney/NetPrice for money/price rounding, CkxWebNotInFinance to exclude web-only customers). Computes Fun_GetLookCustomer(sLoginId,…) for the see-all-customers filter. Branches on the bill-type setting (送货单 / 工单 / 销售订单 / …) to build a dynamic SQL over Viw_SalDeliverGoods etc., projecting the un-checked qty (A.dProductQty - A.dCheckingQty) as dNoCheckingQty and returning a paged result via the standard Sp_Outstanding_Query-style pager glue.
Invocation: Status: appears orphaned — date-suffixed backup of Sp_SalSalesCheck. No gdsconfigformmaster.sSqlStr binds it, no gdsmodule.sProcName references it, no other proc in information_schema.ROUTINES mentions it, no xly-src script (30100101/, 客户/, optimize/, MyBatis mappers, Java) refers to it. The production form uses Sp_SalSalesCheck (the canonical version) — this _1227 snapshot is dead code retained for rollback. Per wiki convention, not expected to be called.