Merge remote-tracking branch 'origin/yagwly_fa_master' into yagwly_fa_master

zhangback

2026-03-10 68b27795ae929f5300fc6fb301b31aada74a2e2f

 tms/src/main/java/com/ruoyi/tms/service/impl/TmsDispatchOrderServiceImpl.java

@@ -8,13 +8,20 @@
import cn.hutool.core.util.IdUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.SysUserImport;
import com.ruoyi.common.core.redis.RedisCache;
import com.ruoyi.common.enums.SystemDataNoEnum;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.DateUtils;
import javax.annotation.Resource;

import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.file.DownloadExportUtil;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.system.service.ISysDictDataService;
import com.ruoyi.system.service.ISysUserService;
import com.ruoyi.system.service.ISystemDataNoService;
@@ -61,6 +68,8 @@
    @Resource
    private TmsQuotePlanMapper tmsQuotePlanMapper;

    @Autowired
    private RedisCache redisCache;

    @Autowired
    ITmsFinanceService tmsFinanceService;
@@ -90,6 +99,29 @@
    private TmsPayableFeeMapper tmsPayableFeeMapper;
    @Resource
    private TmsPayableFeeItemMapper tmsPayableFeeItemMapper;
    @Resource
    private TmsProjectMapper tmsProjectMapper;

    @Resource
    TransportRouteViMapper transportRouteViMapper;

    @Resource
    private TmsDriverMapper tmsDriverMapper;
    @Resource
    private TmsVehicleMapper tmsVehicleMapper;
    @Resource
    private TmsConsignorMapper tmsConsignorMapper;

    @Resource
    private TmsContainerMapper tmsContainerMapper;

    @Resource
    private TmsShelfMapper tmsShelfMapper;

    @Autowired
    private ITmsDispatchOrderImportLogService tmsDispatchOrderImportLogService;


    /**
     * 查询调度单管理
     *
@@ -401,6 +433,342 @@
        });
    }

    @Override
    public void importTemplate(String exportKey) {
        String fileName = ExcelUtil.encodeFileName("tmsDispatchOrderDataTemplate");
        DownloadExportUtil.deleteDownloadFile(redisCache, exportKey, "0");

        try {

            ExcelUtil<TmsDispatchOrderImport> excelUtil = new ExcelUtil<>(TmsDispatchOrderImport.class);
            excelUtil.initialize("tmsDispatchOrderDataTemplate", null, Excel.Type.EXPORT);

            TmsDispatchOrderImport tmsDispatchOrderImport = new TmsDispatchOrderImport();
            tmsDispatchOrderImport.setProjectName("XXX项目");
            tmsDispatchOrderImport.setTransportLine("广东省/珠海市/香洲区->香港特别行政区");
            tmsDispatchOrderImport.setRequiredVehicleTypes("10T");
            tmsDispatchOrderImport.setOrderType("基础订单");
            tmsDispatchOrderImport.setIsCustoms("是");
            tmsDispatchOrderImport.setIsLoad("是");
            tmsDispatchOrderImport.setIsUrgent("是");
            tmsDispatchOrderImport.setOrderTime(DateUtils.getNowDate());
            tmsDispatchOrderImport.setLatestDeparture(DateUtils.getNowDate());
            tmsDispatchOrderImport.setLatestArrival(DateUtils.getNowDate());
            tmsDispatchOrderImport.setOperationMode("是");
            tmsDispatchOrderImport.setCommissionModel("一日游");
            tmsDispatchOrderImport.setMainDriverName("张三");
            tmsDispatchOrderImport.setLicensePlate("粤C12345");
            tmsDispatchOrderImport.setShipperRegionLabel("ZXH202512110002");
            tmsDispatchOrderImport.setReceiverRegionLabel("ZXH202512110001");

            excelUtil.exportExcel(Collections.singletonList(tmsDispatchOrderImport));
            excelUtil.finishExport(fileName);

            // 设置下载完成状态
            DownloadExportUtil.setDownloadFile(redisCache, exportKey, fileName);
            logger.info("Export completed for key: {}, file: {}", exportKey, fileName);
        } catch (Exception e) {
            logger.error("Export failed for key: {}, error: {}", exportKey, e.getMessage(), e);
            DownloadExportUtil.deleteDownloadFile(redisCache, exportKey, "1"); // 设置失败状态
            throw e;
        }
    }

    private String verRequired(int line,TmsDispatchOrderImport tmsDispatchOrderImport){
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getProjectName())){
            return "第 "+line+" 行 项目名称 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getTransportLine())){
            return "第 "+line+" 行 运输线路 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getRequiredVehicleTypes())){
            return "第 "+line+" 行 下单车型 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getOrderType())){
            return "第 "+line+" 行 订单类型 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getIsCustoms())){
            return "第 "+line+" 行 委托报关 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getIsLoad())){
            return "第 "+line+" 行 委托装卸 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getIsUrgent())){
            return "第 "+line+" 行 是否紧急 不能为空！";
        }

        if (tmsDispatchOrderImport.getOrderTime() == null){
            return "第 "+line+" 行 下单时间 不能为空！";
        }
        if (tmsDispatchOrderImport.getLatestArrival() == null){
            return "第 "+line+" 行 要求最晚到达时间 不能为空！";
        }


        if (StringUtils.isEmpty(tmsDispatchOrderImport.getOperationMode())){
            return "第 "+line+" 行 是否是自营车队 不能为空！";
        }
        if ("0".equals(tmsDispatchOrderImport.getOperationMode())){
            if (StringUtils.isEmpty(tmsDispatchOrderImport.getCommissionModel())){
                throw new ServiceException("第"+line+"行自营车队必填提成模式！");
            }
        }
        if ("1".equals(tmsDispatchOrderImport.getOperationMode())){
            if (StringUtils.isEmpty(tmsDispatchOrderImport.getVehicleProviderName())){
                throw new ServiceException("第"+line+"行 非自营车队 必填车辆服务商名称！");
            }
        }


        if ( StringUtils.isEmpty(tmsDispatchOrderImport.getProjectName())){
            return "第 "+line+" 行 下单时间 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getMainDriverName())){
            return "第 "+line+" 行 主驾驶员 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getLicensePlate())){
            return "第 "+line+" 行 车牌号 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getShipperRegionLabel())){
            return "第 "+line+" 行 装货点编码 不能为空！";
        }
        if (StringUtils.isEmpty(tmsDispatchOrderImport.getReceiverRegionLabel())){
            return "第 "+line+" 行 卸货地编码 不能为空！";
        }

        return null;

    }


    @Override
    public String importData(List<TmsDispatchOrderImport> list) {

        if (StringUtils.isNull(list) || list.isEmpty())
        {
            throw new ServiceException("导入调度单数据不能为空！");
        }
        int failureNum = 0;
        StringBuilder successMsg = new StringBuilder();
        StringBuilder failureMsg = new StringBuilder();
        StringBuilder failureDescription = new StringBuilder();
        int line = 1;
        
        // 创建导入日志对象
        TmsDispatchOrderImportLog importLog = new TmsDispatchOrderImportLog();
        importLog.setImportTime(DateUtils.getNowDate());
        importLog.setFileName("调度单导入文件"); // 这里需要根据实际情况获取文件名
        importLog.setOperator(SecurityUtils.getUsername());
        importLog.setCreateBy(SecurityUtils.getUsername());
        importLog.setCreateTime(DateUtils.getNowDate());
        
        for (TmsDispatchOrderImport tmsDispatchOrderImport : list){
            try
            {
                String s = verRequired(line, tmsDispatchOrderImport);
                if (s != null){
                    throw new ServiceException(s);
                }
                TmsDispatchOrder tmsDispatchOrder = new TmsDispatchOrder();
                String projectName = tmsDispatchOrderImport.getProjectName();

                TmsProject tmsProject = tmsProjectMapper.selectOne(new LambdaQueryWrapper<TmsProject>().
                        eq(TmsProject::getProjectName, projectName)
                        .last("limit 1"));
                if (tmsProject == null){
                    throw new ServiceException("第"+line+"行项目不存在！");
                }

                TransportRouteVi transportRouteVi = transportRouteViMapper.selectOne(new LambdaQueryWrapper<TransportRouteVi>()
                        .eq(TransportRouteVi::getTransportRoute, tmsDispatchOrderImport.getTransportLine())
                        .eq(TransportRouteVi::getProjectId, tmsProject.getId())
                        .eq(TransportRouteVi::getCustomerId, tmsProject.getRelatedCustomerId())
                        .eq(TransportRouteVi::getVehicleType, tmsDispatchOrderImport.getRequiredVehicleTypes())
                        .last("limit 1")
                );

                if (transportRouteVi == null){
                    throw new ServiceException("第"+line+"行线路信息不存在！");
                }

                tmsDispatchOrder.setQuoteDetailId(transportRouteVi.getQuoteDetailId());
                tmsDispatchOrder.setTransportLine(transportRouteVi.getTransportRoute());
                tmsDispatchOrder.setStartRegionCode(transportRouteVi.getStartRegionCode());
                tmsDispatchOrder.setEndRegionCode(transportRouteVi.getEndRegionCode());
                tmsDispatchOrder.setProjectName(transportRouteVi.getProjectName());
                tmsDispatchOrder.setProjectId(transportRouteVi.getProjectId());

                // 关联客户
                tmsDispatchOrder.setCustomerId(transportRouteVi.getCustomerId());
                tmsDispatchOrder.setCustomerName(transportRouteVi.getCustomerFullName());
                tmsDispatchOrder.setCustomerCode(transportRouteVi.getCustomerCode());

                tmsDispatchOrder.setContractId(transportRouteVi.getContractId());
                tmsDispatchOrder.setContractName(transportRouteVi.getContractName());

                tmsDispatchOrder.setRequiredVehicleTypes(tmsDispatchOrderImport.getRequiredVehicleTypes());
                tmsDispatchOrder.setQuotePlanId(transportRouteVi.getQuotePlanId());

                tmsDispatchOrder.setOrderType(Integer.valueOf(tmsDispatchOrderImport.getOrderType()));
                tmsDispatchOrder.setIsCustoms(Integer.valueOf(tmsDispatchOrderImport.getIsCustoms()));
                tmsDispatchOrder.setIsLoad(Integer.valueOf(tmsDispatchOrderImport.getIsLoad()));
                tmsDispatchOrder.setIsUrgent(Integer.valueOf(tmsDispatchOrderImport.getIsUrgent()));
                tmsDispatchOrder.setOrderTime(tmsDispatchOrderImport.getOrderTime());
                tmsDispatchOrder.setLatestDeparture(tmsDispatchOrderImport.getLatestDeparture());
                tmsDispatchOrder.setLatestArrival(tmsDispatchOrderImport.getLatestArrival());
                tmsDispatchOrder.setOperationMode(Integer.valueOf(tmsDispatchOrderImport.getOperationMode()));
                if (tmsDispatchOrder.getOperationMode() == 0){
                   tmsDispatchOrder.setCommissionModel(Integer.valueOf(tmsDispatchOrderImport.getCommissionModel()));
                } else {

                    TmsServiceProvider tmsServiceProvider = tmsServiceProviderMapper.selectOne(new LambdaQueryWrapper<TmsServiceProvider>().
                            eq(TmsServiceProvider::getServiceName,
                                    tmsDispatchOrderImport.getVehicleProviderName())
                            .last("limit 1")
                    );
                    if (tmsServiceProvider == null){
                        throw new ServiceException("第"+line+"行车辆服务商不存在！");
                    }
                    tmsDispatchOrder.setVehicleProviderId(tmsServiceProvider.getId());
                    tmsDispatchOrder.setVehicleProviderName(tmsServiceProvider.getServiceName());
                }
                TmsDriver tmsDriver = tmsDriverMapper.selectOne(new LambdaQueryWrapper<TmsDriver>().
                        eq(TmsDriver::getDriverName, tmsDispatchOrderImport.getMainDriverName())
                        .last("limit 1")
                );
                if (tmsDriver == null){
                    throw new ServiceException("第"+line+"行主驾驶员不存在！");
                }

                tmsDispatchOrder.setMainDriverId(tmsDriver.getId());
                tmsDispatchOrder.setMainDriverName(tmsDriver.getDriverName());
                if (!StringUtils.isEmpty(tmsDispatchOrderImport.getAssistantDriverName())){

                    TmsDriver tmsDriver1 = tmsDriverMapper.selectOne(new LambdaQueryWrapper<TmsDriver>().
                        eq(TmsDriver::getDriverName, tmsDispatchOrderImport.getAssistantDriverName())
                        .last("limit 1")
                    );
                    if (tmsDriver1 != null){
                        tmsDispatchOrder.setAssistantDriverId(tmsDriver1.getId());
                        tmsDispatchOrder.setAssistantDriverName(tmsDriver1.getDriverName());
                    }

                }


                TmsVehicle tmsVehicle = tmsVehicleMapper.selectOne(new LambdaQueryWrapper<TmsVehicle>()
                        .eq(TmsVehicle::getLicensePlate, tmsDispatchOrderImport.getLicensePlate())
                        .last("limit 1")
                );
                if (tmsVehicle == null){
                    throw new ServiceException("第"+line+"行车牌号不存在！");
                }

                tmsDispatchOrder.setVehicleId(tmsVehicle.getId());
                tmsDispatchOrder.setLicensePlate(tmsVehicle.getLicensePlate());
                tmsDispatchOrder.setActualVehicleType(tmsVehicle.getVehicleType());

                TmsConsignor shipper = tmsConsignorMapper.selectOne(new LambdaQueryWrapper<TmsConsignor>()
                        .eq(TmsConsignor::getConsignorCode,
                                tmsDispatchOrderImport.getShipperRegionLabel())
                        .eq(TmsConsignor::getCustomerId, tmsDispatchOrder.getCustomerId())
                        .last("limit 1")
                );

                if (shipper == null){
                    throw new ServiceException("第"+line+"行装货点不存在！");
                }
                tmsDispatchOrder.setShipperId(shipper.getId());
                tmsDispatchOrder.setShipperName(shipper.getConsignorName());
                tmsDispatchOrder.setShipperRegionLabel(shipper.getRegionLabel());
                tmsDispatchOrder.setShipperAddress(shipper.getAddressDetail());
                tmsDispatchOrder.setShipperMobile(shipper.getContactPhone());
                tmsDispatchOrder.setShipperRegionCode(shipper.getRegion());


                TmsConsignor receiver = tmsConsignorMapper.selectOne(new LambdaQueryWrapper<TmsConsignor>()
                        .eq(TmsConsignor::getConsignorCode,
                                tmsDispatchOrderImport.getReceiverRegionLabel())
                        .eq(TmsConsignor::getCustomerId, tmsDispatchOrder.getCustomerId())
                        .last("limit 1")
                );
                if (receiver == null){
                    throw new ServiceException("第"+line+"行卸货地不存在！");
                }
                tmsDispatchOrder.setReceiverId(receiver.getId());
                tmsDispatchOrder.setReceiverName(receiver.getConsignorName());
                tmsDispatchOrder.setReceiverRegionLabel(receiver.getRegionLabel());
                tmsDispatchOrder.setReceiverAddress(receiver.getAddressDetail());
                tmsDispatchOrder.setReceiverMobile(receiver.getContactPhone());
                tmsDispatchOrder.setReceiverRegionCode(receiver.getRegion());

                if (!StringUtils.isEmpty(tmsDispatchOrderImport.getContainerNo())){
                    TmsContainer tmsContainer = tmsContainerMapper.selectOne(new LambdaQueryWrapper<TmsContainer>()
                            .eq(TmsContainer::getContainerCode, tmsDispatchOrderImport.getContainerNo())
                            .last("limit 1")
                    );
                    if (tmsContainer == null){
                        throw new ServiceException("第"+line+"行集装箱不存在！");
                    }
                    tmsDispatchOrder.setContainerId(tmsContainer.getId());
                    tmsDispatchOrder.setContainerNo(tmsContainer.getContainerCode());
                }

                if (!StringUtils.isEmpty(tmsDispatchOrderImport.getShelfCode())){
                    TmsShelf tmsShelf = tmsShelfMapper.selectOne(new LambdaQueryWrapper<TmsShelf>()
                        .eq(TmsShelf::getShelfCode, tmsDispatchOrderImport.getShelfCode())
                        .last("limit 1")
                    );
                    if (tmsShelf == null){
                        throw new ServiceException("第"+line+"行托架不存在！");
                    }
                    tmsDispatchOrder.setShelfId(tmsShelf.getId());
                    tmsDispatchOrder.setShelfCode(tmsShelf.getShelfCode());
                }
                String noByKey = systemDataNoService.getNoByKey(SystemDataNoEnum.DL);
                tmsDispatchOrder.setDispatchNo(noByKey);

                tmsDispatchOrder.setCreateBy(SecurityUtils.getUsername());
                tmsDispatchOrder.setCreateTime(DateUtils.getNowDate());
                tmsDispatchOrderMapper.insertTmsDispatchOrder(tmsDispatchOrder);
            }catch (Exception e) {
                failureNum++;
                String msg = "<br/>" +  "调度单第"+line+"行导入失败：";
                failureMsg.append(msg + e.getMessage());
                
                // 记录失败说明，包含行号和失败原因
                failureDescription.append("第" + line + "行：" + e.getMessage()).append("\n");
                
                log.error(msg, e);
            }finally {
                line++;
            }
        }

        // 设置导入日志的统计信息
        importLog.setSuccessCount(list.size() - failureNum);
        importLog.setFailureCount(failureNum);
        importLog.setFailureDescription(failureDescription.toString());
        
        // 保存导入日志
        try {
            tmsDispatchOrderImportLogService.insertTmsDispatchOrderImportLog(importLog);
        } catch (Exception e) {
            log.error("保存导入日志失败：", e);
        }

        if (failureNum > 0)
        {
            failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下：");
            throw new ServiceException(failureMsg.toString());
        }
        else
        {
            successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + list.size() + " 条");
        }

        return successMsg.toString() ;
    }

    /**
     * 新增调度单管理
@@ -448,6 +816,31 @@
    }

    @Override
    public int updateTmsDispatchOrder(YpdddjDispatchOrderVo dispatchOrderVo)
    {
        return tmsDispatchOrderMapper.update(new LambdaUpdateWrapper<TmsDispatchOrder>()
                .in(TmsDispatchOrder::getDispatchNo,dispatchOrderVo.getDispatchNos())
                .set(dispatchOrderVo.getShipperId()!=null,TmsDispatchOrder::getShipperId,dispatchOrderVo.getShipperId())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getShipperName()),TmsDispatchOrder::getShipperName,dispatchOrderVo.getShipperName())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getShipperRegionLabel()),TmsDispatchOrder::getShipperRegionLabel,dispatchOrderVo.getShipperRegionLabel())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getShipperAddress()),TmsDispatchOrder::getShipperAddress,dispatchOrderVo.getShipperAddress())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getShipperMobile()),TmsDispatchOrder::getShipperMobile,dispatchOrderVo.getShipperMobile())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getShipperRegionCode()),TmsDispatchOrder::getShipperRegionCode,dispatchOrderVo.getShipperRegionCode())

                .set(dispatchOrderVo.getReceiverId()!=null,TmsDispatchOrder::getReceiverId,dispatchOrderVo.getReceiverId())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getReceiverName()),TmsDispatchOrder::getReceiverName,dispatchOrderVo.getReceiverName())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getReceiverRegionLabel()),TmsDispatchOrder::getReceiverRegionLabel,dispatchOrderVo.getReceiverRegionLabel())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getReceiverAddress()),TmsDispatchOrder::getReceiverAddress,dispatchOrderVo.getReceiverAddress())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getReceiverMobile()),TmsDispatchOrder::getReceiverMobile,dispatchOrderVo.getReceiverMobile())
                .set(StringUtils.isNotEmpty(dispatchOrderVo.getReceiverRegionCode()),TmsDispatchOrder::getReceiverRegionCode,dispatchOrderVo.getReceiverRegionCode())

                .set(TmsDispatchOrder::getUpdateBy,SecurityUtils.getUsername())
                .set(TmsDispatchOrder::getUpdateTime,DateUtils.getNowDate())
        );

    }

    @Override
    public int printDispatchOrder(TmsDispatchOrder tmsDispatchOrder)
    {
        return tmsDispatchOrderMapper.update(null,new LambdaUpdateWrapper<TmsDispatchOrder>()