# `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 PROCEDURE `SP_GetlogisticsPrice`'`._

## 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.