| | |
|---|
| | | String receiverRegionCode = tmsDispatchOrder.getEndRegionCode(); |
|---|
| | | |
|---|
| | | // 查询应收规则 |
|---|
| | | TmsQuoteDetail tmsQuoteDetail = tmsQuoteDetailMapper.selectOne(new LambdaQueryWrapper<TmsQuoteDetail>() |
|---|
| | | .eq(TmsQuoteDetail::getVehicleProviderId, vehicleProviderId) |
|---|
| | | TmsQuoteDetail tmsQuoteDetail = |
|---|
| | | tmsQuoteDetailMapper.selectOne( |
|---|
| | | new LambdaQueryWrapper<TmsQuoteDetail>() |
|---|
| | | .eq(TmsQuoteDetail::getVehicleType, actualVehicleType) |
|---|
| | | .eq(TmsQuoteDetail::getStartRegionCode, shipperRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getEndRegionCode, receiverRegionCode) |
|---|
| | | .eq(TmsQuoteDetail::getPlanType, 1) |
|---|
| | | .last("limit 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") |
|---|
| | | ); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | if (tmsQuoteDetail == null){ |
|---|
| | | throw new RuntimeException("调度单"+tmsDispatchOrder.getDispatchNo()+"未维护应付运费报价，请维护数据后再重新生成"); |
|---|
| | | } |
|---|
