| | |
|---|
| | | String receiverRegionCode = tmsDispatchOrder.getEndRegionCode(); |
|---|
| | | |
|---|
| | | // 查询应收规则 |
|---|
| | | TmsQuoteDetail tmsQuoteDetail = tmsQuoteDetailMapper.selectOne(new LambdaQueryWrapper<TmsQuoteDetail>() |
|---|
| | | .eq(TmsQuoteDetail::getVehicleProviderId, vehicleProviderId) |
|---|
| | | .eq(TmsQuoteDetail::getVehicleType, actualVehicleType) |
|---|
| | | .eq(TmsQuoteDetail::getStartRegionCode, shipperRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getEndRegionCode, receiverRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getPlanType, 1) |
|---|
| | | .last("limit 1") |
|---|
| | | ); |
|---|
| | | TmsQuoteDetail tmsQuoteDetail = |
|---|
| | | tmsQuoteDetailMapper.selectOne( |
|---|
| | | new LambdaQueryWrapper<TmsQuoteDetail>() |
|---|
| | | .eq(TmsQuoteDetail::getVehicleType, actualVehicleType) |
|---|
| | | .eq(TmsQuoteDetail::getStartRegionCode, shipperRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getEndRegionCode, receiverRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getPlanType, 1) |
|---|
| | | .exists( |
|---|
| | | "SELECT 1 " + |
|---|
| | | "FROM tms_quote_plan tqp " + |
|---|
| | | "WHERE tqp.id = tms_quote_detail.quote_plan_id " + |
|---|
| | | "AND tqp.provider_id = {0} " + |
|---|
| | | "AND tqp.plan_type = 1 " + |
|---|
| | | "AND tqp.provider_type = 0", |
|---|
| | | vehicleProviderId |
|---|
| | | ) |
|---|
| | | .last("LIMIT 1") |
|---|
| | | ); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
