SP_GetlogisticsPrice (procedure)
- Type: PROCEDURE
- Deterministic: NO
- SQL data access: CONTAINS SQL
Parameters
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | spId |
varchar(100) |
| 2 | IN | spCity |
varchar(100) |
| 3 | IN | spTon |
varchar(100) |
| 4 | IN | spLogType |
varchar(100) |
| 5 | IN | spTaxId |
varchar(100) |
| 6 | IN | spTime |
varchar(100) |
Body
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESPGetlogisticsPrice'._
Narrative
Business context: Quote-time logistics price lookup — given a destination city + truck tonnage (1.5T/2T/.../7T) + 运输费/等时费 mode + time slot, populate a one-row tbPriceMoney temp table with the matching rate from sislogisticsaddprice (city-based) or sislogisticstimeprice (time-based). The rate column (iOne/iTwo/.../iSeven) is selected by the tonnage parameter.
What it does: Drops and recreates tbPriceMoney, then dispatches into one of fourteen INSERT branches based on the spLogType/spTon pair. Each branch SELECTs a single i<Tonnage> literal column out of the price source table and writes it identically into eight money/price slots on the temp row.
Invocation: Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines, xly-src grep across all extensions) — candidate for maintainer audit. Stray -- select aa from bb; debug-echo comment confirms scratchpad lineage.