| | |
| | | import com.ruoyi.system.service.ISysUserService; |
| | | import com.ruoyi.system.service.ISystemDataNoService; |
| | | import com.ruoyi.tms.domain.*; |
| | | import com.ruoyi.tms.domain.vo.DpDriverDispatchVo; |
| | | import com.ruoyi.tms.domain.vo.DriverDispatchVo; |
| | | import com.ruoyi.tms.domain.vo.ServiceProviderVo; |
| | | import com.ruoyi.tms.mapper.*; |
| | |
| | | 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") |
| | | ); |
| | | |
| | | |
| | | |
| | | |
| | |
| | | } |
| | | return AjaxResult.success(); |
| | | } |
| | | |
| | | @Override |
| | | public List<DpDriverDispatchVo> selectDpData() { |
| | | return tmsDispatchOrderMapper.selectselectDpData(); |
| | | } |
| | | } |