优化

admin

2024-11-12 706d57aa682845cf1bc01cbfd1087c4c0f33093f

 jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java

@@ -85,7 +85,7 @@
                "    inbound_time,\n" +
                "    outbound_time,\n" +
                "    DATEDIFF(SECOND, inbound_time, outbound_time) AS beatTime");
        queryWrapper.eq("sfc_code","2408270000011");
        queryWrapper.eq("sfc_code",getLatestCompletedWorkpiece());
        queryWrapper.orderByDesc("location_code");
        List<DaPassingStationCollection> list = daPassingStationCollectionService.list(queryWrapper);
        for (DaPassingStationCollection daPassingStationCollection : list) {
@@ -173,6 +173,16 @@
        return AjaxResult.success(resultList);
    }

    // 获得最新完成工件状态为5
    public String getLatestCompletedWorkpiece(){
        QueryWrapper<OmProductionOrdeInfo> wrapper = new QueryWrapper<>();
        wrapper.select("TOP 1 *");
        wrapper.eq("order_status","5");
        wrapper.orderByDesc("actual_end_time");
        OmProductionOrdeInfo one = omProductionOrdeInfoService.getOne(wrapper);
        return one.getProductNum();
    }

    public static int locationPassRate(int passRate,int total) {
        double percentage = (double) passRate / total * 100;
        long roundedNumber = Math.round(percentage);