Sp_SaleOrder_ProgressOfImplementationNew (procedure)
订单(工单)执行情况
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sBrId |
varchar(100) |
| 2 | IN | sSuId |
varchar(100) |
| 3 | IN | sLoginId |
varchar(100) |
| 4 | IN | bFilter |
longtext |
| 5 | IN | pageNum |
int |
| 6 | IN | pageSize |
int |
| 7 | OUT | totalCount |
int |
| 8 | IN | countCloumn |
longtext |
| 9 | OUT | countMapJson |
longtext |
| 10 | IN | sFilterOrderBy |
longtext |
| 11 | IN | sGroupby_select_sql |
longtext |
| 12 | IN | sGroupby_group_sql |
longtext |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpSaleOrder_ProgressOfImplementationNew'._
Narrative
Business context: 销售管理 → 订单(工单)执行情况 — paged lifecycle report that lays out, for each 销售订单 row, every downstream stage of production, delivery, settlement, invoicing and receipt. Updated/replacement variant of the legacy Sp_SaleOrder_ProgressOfImplementation proc.
What it does: Builds the temp table p_TmpTb keyed on order slave, then INSERT INTOs the base rows from Viw_SalSalesOrder filtered by bFilter (defaults to the last 6 months from tCreateDate). Successive UPDATEs fold in customer-visibility (Fun_GetLookCustomer), 工单下达 (viw_mftproductionreport), 委外入库 (Viw_opsoutsideinstore/opsoutsideinstoreslave), 成品入库 (Viw_PitProductInStore/PitProductInStoreSlave), 送货 (viw_saldelivergoods/SalDeliverGoodsSlave), 退货 (SalRejectGoodsSlave), 销售对账 (viw_salsaleschecking/SalSalesCheckingSlave), 发票 (viw_SalSalesInvoice/SalSalesInvoiceSlave) and 收款 (CahReceiptSlave). Final SELECT pages out of p_TmpTb using pageNum/pageSize, with countMapJson aggregating totals from countCloumn.
Invocation: No live form-master binding in gdsconfigformmaster and no Java/MyBatis hit in xly-src — only the install script script/标版/30100101/Sp_SaleOrder_ProgressOfImplementationNew.sql and customer override script/客户/千彩/Sp_SaleOrder_ProgressOfImplementationNew.sql. Likely wired through a form-master row not present in this database snapshot (or driven dynamically as a Sp_SalesQuery*-style report); maintainer audit recommended before pruning.