From 872dd98f359f6d6ff45dac82fe925a5abf4faa83 Mon Sep 17 00:00:00 2001
From: zwl <1051256694@qq.com>
Date: 星期二, 21 四月 2026 10:47:09 +0800
Subject: [PATCH] 1.订单累计入库件数改成改站点入库所以总和。从早上8点开始计算

---
 src/main/java/com/zy/asrs/controller/OpenController.java |  169 ++++++++++----------------------------------------------
 1 files changed, 30 insertions(+), 139 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OpenController.java b/src/main/java/com/zy/asrs/controller/OpenController.java
index 4e1f501..1b25813 100644
--- a/src/main/java/com/zy/asrs/controller/OpenController.java
+++ b/src/main/java/com/zy/asrs/controller/OpenController.java
@@ -25,7 +25,6 @@
 import javax.servlet.http.HttpServletRequest;
 import java.text.SimpleDateFormat;
 import java.util.*;
-import java.util.concurrent.TimeUnit;
 
 /**
  * Created by vincent on 2022/4/8
@@ -50,8 +49,6 @@
     private WaitPakinService waitPakinService;
     @Autowired
     private WrkDetlService wrkDetlService;
-    @Autowired
-    private WrkDetlLogService wrkDetlLogService;
     @Autowired
     private WrkMastService wrkMastService;
     @Autowired
@@ -935,7 +932,7 @@
 
         // 鎬诲簱浣嶆暟
         Integer total1 = (int) Arith.add(0, locUseRate.getFqty(), locUseRate.getOqty(), locUseRate.getUqty(), locUseRate.getXqty());
-        Integer total = total1>40000?40000:total1;
+        Integer total = total1>40000?6528:total1;
         // 浣跨敤涓�
         Integer used = locUseRate.getFqty() + locUseRate.getUqty();
         // 搴撲綅浣跨敤鐜�
@@ -982,167 +979,61 @@
         Integer count = 0;
         String supp = "";
         //璇ヨ鍗曠疮璁″叆鍑哄簱浠舵暟
-        List<WrkMast> orderNo = wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("user_no", wrkMast.getUserNo()));
-        List<WrkMastLog> userNo = wrkMastLogService.selectList(new EntityWrapper<WrkMastLog>().eq("user_no", wrkMast.getUserNo()).eq("wrk_sts",15L));
         Integer ioType = wrkMast.getIoType();
         if (ioType != null && ioType < 100) {
-            if (orderNo != null && orderNo.size() > 0) {
-                count = orderNo.size();
-            }
-            if (userNo != null && userNo.size() > 0) {
-                count = userNo.size()+count+1;
-            }
-            supp = count + "";
+            Date endTime = new Date();
+            Date startTime = resolveBusinessDayStart(endTime);
+            Long inboundCount = wrkMastLogService.countInboundHistoryBySourceStaNo(startTime, endTime, resolveInboundStationNo(wrkMast));
+            supp = String.valueOf(inboundCount);
         }else {
+            List<WrkMast> orderNo = wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("user_no", wrkMast.getUserNo()));
+            List<WrkMastLog> userNo = wrkMastLogService.selectList(new EntityWrapper<WrkMastLog>().eq("user_no", wrkMast.getUserNo()).eq("wrk_sts",15L));
             if (userNo != null && userNo.size() > 0) {
                 count = userNo.size()+1;
+            }
+            if (orderNo != null && orderNo.size() > 0) {
+                count=orderNo.size()+count;
             }
             supp = count + "";
         }
         map.put("supp", supp);
 
         //鑰楁椂
-        String costTime = resolveCostTime(wrkMast, wrkDetls);
-        map.put("costTime", costTime);
+        Long costTime = resolveCostTime(wrkMast);
+        map.put("costTime", String.valueOf(costTime));
 
         return R.ok().add(map);
     }
 
-    private String resolveCostTime(WrkMast wrkMast, List<WrkDetl> wrkDetls) {
+    private Long resolveCostTime(WrkMast wrkMast) {
         if (wrkMast == null || wrkMast.getIoType() == null) {
-            return "0";
+            return 0L;
         }
 
-        Date createTime;
-        if (wrkMast.getIoType() < 100) {
-            createTime = resolveInboundTaskCreateTime(wrkMast, wrkDetls);
-        } else {
-            createTime = resolveTaskCreateTime(wrkMast);
-        }
-
-        if (createTime == null) {
-            return "0";
-        }
-
-        long minutes = TimeUnit.MILLISECONDS.toMinutes(System.currentTimeMillis() - createTime.getTime());
-        if (minutes < 0L) {
-            minutes = 0L;
-        }
-        return String.valueOf(minutes);
+        Date endTime = new Date();
+        Date startTime = resolveBusinessDayStart(endTime);
+        Integer wrkSts = wrkMast.getIoType() < 100 ? 5 : 15;
+        return wrkMastLogService.sumCostTimeByWrkSts(startTime, endTime, wrkSts);
     }
 
-    private Date resolveInboundTaskCreateTime(WrkMast wrkMast, List<WrkDetl> wrkDetls) {
+    private Integer resolveInboundStationNo(WrkMast wrkMast) {
         if (wrkMast == null) {
             return null;
         }
-
-        if (!Cools.isEmpty(wrkMast.getUserNo())) {
-            Date userNoCreateTime = resolveUserNoCreateTime(wrkMast.getUserNo());
-            if (userNoCreateTime != null) {
-                return userNoCreateTime;
-            }
-        }
-
-        String orderNo = resolveOrderNo(wrkMast, wrkDetls);
-        if (Cools.isEmpty(orderNo)) {
-            return null;
-        }
-        return resolveOrderCreateTime(orderNo);
+        return wrkMast.getSourceStaNo() == null ? wrkMast.getStaNo() : wrkMast.getSourceStaNo();
     }
 
-    private Date resolveUserNoCreateTime(String userNo) {
-        if (Cools.isEmpty(userNo)) {
-            return null;
+    private Date resolveBusinessDayStart(Date now) {
+        Calendar calendar = Calendar.getInstance();
+        calendar.setTime(now);
+        calendar.set(Calendar.HOUR_OF_DAY, 8);
+        calendar.set(Calendar.MINUTE, 0);
+        calendar.set(Calendar.SECOND, 0);
+        calendar.set(Calendar.MILLISECOND, 0);
+        if (now.before(calendar.getTime())) {
+            calendar.add(Calendar.DATE, -1);
         }
-        return minDate(
-                minCreateTime(wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("user_no", userNo))),
-                minCreateTime(wrkMastLogService.selectList(new EntityWrapper<WrkMastLog>().eq("user_no", userNo)))
-        );
-    }
-
-    private String resolveOrderNo(WrkMast wrkMast, List<WrkDetl> wrkDetls) {
-        if (wrkMast != null && !Cools.isEmpty(wrkMast.getUserNo())) {
-            return wrkMast.getUserNo();
-        }
-        if (Cools.isEmpty(wrkDetls)) {
-            return null;
-        }
-        for (WrkDetl wrkDetl : wrkDetls) {
-            if (wrkDetl != null && !Cools.isEmpty(wrkDetl.getOrderNo())) {
-                return wrkDetl.getOrderNo();
-            }
-        }
-        return null;
-    }
-
-    private Date resolveOrderCreateTime(String orderNo) {
-        if (Cools.isEmpty(orderNo)) {
-            return null;
-        }
-
-        Date historyCreateTime = minDate(
-                minCreateTime(wrkMastLogService.selectList(new EntityWrapper<WrkMastLog>().eq("user_no", orderNo))),
-                minCreateTime(wrkDetlLogService.selectList(new EntityWrapper<WrkDetlLog>().eq("order_no", orderNo)))
-        );
-        Date currentCreateTime = minDate(
-                minCreateTime(wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("user_no", orderNo))),
-                minCreateTime(wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("order_no", orderNo)))
-        );
-        return minDate(historyCreateTime, currentCreateTime);
-    }
-
-    private Date minDate(Date first, Date second) {
-        if (first == null) {
-            return second;
-        }
-        if (second == null) {
-            return first;
-        }
-        return first.before(second) ? first : second;
-    }
-
-    private Date resolveTaskCreateTime(WrkMast wrkMast) {
-        if (wrkMast == null) {
-            return null;
-        }
-        return minDate(minDate(wrkMast.getAppeTime(), wrkMast.getIoTime()), wrkMast.getModiTime());
-    }
-
-    private Date minCreateTime(List<?> list) {
-        if (Cools.isEmpty(list)) {
-            return null;
-        }
-        Date min = null;
-        for (Object item : list) {
-            Date createTime = resolveCreateTime(item);
-            if (createTime == null) {
-                continue;
-            }
-            if (min == null || createTime.before(min)) {
-                min = createTime;
-            }
-        }
-        return min;
-    }
-
-    private Date resolveCreateTime(Object item) {
-        if (item instanceof WrkMast) {
-            WrkMast wrkMast = (WrkMast) item;
-            return minDate(minDate(wrkMast.getAppeTime(), wrkMast.getIoTime()), wrkMast.getModiTime());
-        }
-        if (item instanceof WrkMastLog) {
-            WrkMastLog wrkMastLog = (WrkMastLog) item;
-            return minDate(minDate(wrkMastLog.getAppeTime(), wrkMastLog.getIoTime()), wrkMastLog.getModiTime());
-        }
-        if (item instanceof WrkDetl) {
-            WrkDetl wrkDetl = (WrkDetl) item;
-            return minDate(minDate(wrkDetl.getAppeTime(), wrkDetl.getIoTime()), wrkDetl.getModiTime());
-        }
-        if (item instanceof WrkDetlLog) {
-            WrkDetlLog wrkDetlLog = (WrkDetlLog) item;
-            return minDate(minDate(wrkDetlLog.getAppeTime(), wrkDetlLog.getIoTime()), wrkDetlLog.getModiTime());
-        }
-        return null;
+        return calendar.getTime();
     }
 }
 

--
Gitblit v1.9.1