Sp_QuotationStatistics (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | tStartDate |
datetime |
| 2 | IN | tEndDate |
datetime |
| 3 | IN | sLoginId |
varchar(100) |
| 4 | IN | sBrId |
varchar(100) |
| 5 | IN | sSuId |
varchar(100) |
| 6 | IN | bFilter |
longtext |
| 7 | IN | pageNum |
int |
| 8 | IN | pageSize |
int |
| 9 | OUT | totalCount |
int |
| 10 | IN | countCloumn |
varchar(5000) |
| 11 | OUT | countMapJson |
longtext |
| 12 | IN | sFilterOrderBy |
varchar(5000) |
| 13 | IN | sGroupby_select_sql |
varchar(5000) |
| 14 | IN | sGroupby_group_sql |
varchar(5000) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpQuotationStatistics'._
Narrative
Business context: 销售管理 → 报价&估计管理 → 估价丢单原因统计 — paged "lost-quote reason" pivot. Groups approved quotations into reason buckets: every sType lost-reason that didn't become a sales order, plus a fixed bucket "已成交订单" (turned into a sales order) and the unconfigured "未走客户确认流程直接下单" (booked without customer confirmation).
What it does: Builds temp table Tmp_EleProduct from quoquotationmaster (filter: bCheck=1 and date range). First pass counts/sums quotes not in viw_salsalesorder.sSrcId grouped by sType; empty sType rows get re-labelled via Fun_Sis_GetConstNew('sNotCustomerConfirm', …). Second pass inserts the "已成交订单" row from quotes that do match viw_salsalesorder. Computes dPercentageQty = dQuotationMoney / sum * 100. Hands the result to Sp_Outstanding_Query for paging/bFilter splicing/total-count.
Invocation: Bound as data-source of form gfm.sId=15936608930005133957219822193000 via gdsconfigformmaster.sSqlStr — module 估价丢单原因统计 (sId 101251240115015878880530950). Install/optimize script script/标版/optimize/Sp_QuotationStatistics.sql.