订单下发接口优化

zxl

2025-05-12 49067588d021a8dce13d9857c4a032daaa68f646

订单下发接口优化

 ycl-server/src/main/java/com/ycl/platform/mapper/WorkOrderMapper.java

@@ -124,5 +124,5 @@

    WorkOrderDetailVO detailByNoButNoDistributeRecord(String workOrderNo);

    List<WorkOrderVO> distributeList(Date startDate, Date endDate);
    List<WorkOrderVO> distributeList();
}

 ycl-server/src/main/java/com/ycl/platform/service/WorkOrderService.java

@@ -127,7 +127,7 @@
     */
    Result distributePage(DistributeWorkOrderQuery query);

    List<WorkOrderVO> distributeList(Date startDate, Date endDate);
    List<WorkOrderVO> distributeList();
    /**
     * 快速下发
     * @param data

 ycl-server/src/main/java/com/ycl/platform/service/impl/DataCenterServiceImpl.java

@@ -1374,10 +1374,11 @@
        resultCount.add(0, totalCount + "");

        BigDecimal onlineRate = BigDecimal.ZERO;


//        1：完整 0：间歇 -1：异常 |
        if (!StringUtils.isEmpty(resultCount.get(0)) && !"0".equals(resultCount.get(0))) {
            //resultCount.get(0)
            onlineRate = new BigDecimal(resultCount.get(1)).divide(new BigDecimal(uniqueDeviceIdCount), 3,RoundingMode.DOWN).multiply(new BigDecimal("100"));
            onlineRate = new BigDecimal(uniqueDeviceIdCount).divide(new BigDecimal(resultCount.get(0)), 3,RoundingMode.DOWN).multiply(new BigDecimal("100"));
        }
        resultCount.add(this.remove0(onlineRate));


 ycl-server/src/main/java/com/ycl/platform/service/impl/WorkOrderServiceImpl.java

@@ -807,8 +807,8 @@
    }

    @Override
    public List<WorkOrderVO> distributeList(Date startDate, Date endDate){
        return  baseMapper.distributeList(startDate,endDate);
    public List<WorkOrderVO> distributeList(){
        return  baseMapper.distributeList();
    }

    @Override

 ycl-server/src/main/java/com/ycl/task/WorkOrderTask.java

@@ -92,7 +92,7 @@
        Date startDate = DateUtils.getDayStart(now);
        Date endDate = DateUtils.getDayEnd(now);
        //获得今日工单
        List<WorkOrderVO> list = workOrderService.distributeList(startDate,endDate);
        List<WorkOrderVO> list = workOrderService.distributeList();
        log.error("获得工单:{}",list);
        List<String> workOrderNos = new ArrayList<>();
        for (WorkOrderVO workOrderVO : list){

 ycl-server/src/main/resources/mapper/zgyw/WorkOrderMapper.xml

@@ -187,7 +187,6 @@
                LEFT JOIN sys_user su ON su.user_id = odr.user_id
        WHERE
            wo.deleted = 0
          AND wo.create_time BETWEEN #{startDate} AND #{endDate}
          AND wo.status = 'WAIT_DISTRIBUTE'
        GROUP BY
            wo.id, wo.status, wo.work_order_no,wo.create_time, wo.unit_id, wo.yw_people_id, tm.name, wo.yw_handle_time,