Sp_Calc_sQtt (procedure)
报价单
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | iFlag |
int |
| 2 | IN | iTmpCheck |
int |
| 3 | IN | sFormGuid |
varchar(100) |
| 4 | IN | sGuid |
varchar(100) |
| 5 | IN | sLoginId |
varchar(100) |
| 6 | OUT | sReturn |
text |
| 7 | IN | sBrId |
varchar(100) |
| 8 | IN | sSuId |
varchar(100) |
| 9 | OUT | sCode |
int |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpCalc_sQtt'._
Narrative
Business context: 销售管理 → 报价&估计管理 / 销售单据 — audit / un-audit of a 报价单 (sales quotation) on quoquotationmaster/quoquotationslave. The most widely-bound Sp_Calc_s* in this snapshot — it serves the regular 报价单, the 卷筒 / 膜类 / 书刊 / 盒型 / 套装 product variants, the compatibility-suspended generic forms, the new 17/05 quote form, the self-service quote, and the quote-approval (报价审批) module. On approval it locks the quote, snapshots customer-product pricing, optionally posts KPI rows, and triggers the configured approval workflow.
What it does: Validates sGuid/bInvalid, CALL Sp_Bill_Used to verify the quote is not consumed downstream; on iFlag=1 flips quoquotationmaster.bCheck=1, sStatus=1, stamps sCheckPerson/tCheckDate; writes a price snapshot row to eleproductcustomer (per-customer-product pricing table) from each quoquotationslave; updates salsaleschanceproduct so the linked 销售机会 picks up the approved price; logs to syslog/syslogdetail; CALL Sp_System_CheckFlow per slave to launch the configured workflow when CkxDefineCheck=1. iFlag=0 reverses the flags.
Invocation: Bound to gdsmodule.sProcName on a large fleet of 报价单 modules — 卷筒/书刊/膜类/盒型/套装 variants, the 自助报价 self-service form, 报价审批, the new 17/05 form, 01/04 新增新报价单, plus several 兼容停用 (compatibility-suspended) rows. Dispatched by Java BusinessBaseServiceImpl.getPrcName(sFormGuid, …) on the audit/un-audit button — the standard Sp_Calc_s<Code> slot. Install scripts: script/标版/30100101/Sp_Calc_sQtt.sql.