From 42bb7c4d621ce4ebe1c1d12203bf874f0b0b296e Mon Sep 17 00:00:00 2001
From: Administrator <1051256694@qq.com>
Date: 星期五, 24 四月 2026 14:37:20 +0800
Subject: [PATCH] 电视机入库托数修复

---
 src/main/java/com/zy/asrs/controller/OpenController.java |  260 +++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 227 insertions(+), 33 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OpenController.java b/src/main/java/com/zy/asrs/controller/OpenController.java
index 9cfad2a..f87265d 100644
--- a/src/main/java/com/zy/asrs/controller/OpenController.java
+++ b/src/main/java/com/zy/asrs/controller/OpenController.java
@@ -37,6 +37,7 @@
     private static final boolean auth = true;
     private static final String  sign_arm_order = "|s|LABEL_";
     private static final String  sign_arm_sku = "|sku|LABEL_";
+    private static final long MILLIS_PER_MINUTE = 60L * 1000L;
     public static final ArrayList<String> APP_KEY_LIST = new ArrayList<String>() {{
         add("ea1f0459efc02a79f046f982767939ae");
     }};
@@ -123,6 +124,23 @@
                                              HttpServletRequest request) {
         auth(appkey, param, request);
         return R.ok().add(openService.pakinOrderComplete(param));
+    }
+
+    /**
+     * 鎵樼洏鍏ュ簱鍘嗗彶璁板綍閲嶆姤ERP
+     */
+    @PostMapping("/order/pakin/erp/report/v1")
+//    @AppAuth(memo = "鍏ュ簱鍘嗗彶閲嶆姤ERP")
+    public synchronized R reportPakinHistoryToErp(@RequestBody(required = false) List<String> barcodes) {
+//        auth(appkey, barcodes, request);
+        if (Cools.isEmpty(barcodes)) {
+            return R.parse(BaseRes.PARAM);
+        }
+        try {
+            return openService.reportPakinHistoryToErp(barcodes);
+        } catch (Exception e) {
+            return R.error(e.getMessage());
+        }
     }
 
 
@@ -212,8 +230,8 @@
     @PostMapping("/arm/task/v1")
     @AppAuth(memo = "鍒嗘嫞绾夸笂鎶ユ帴鏀�")
     public synchronized R TaskArmReport(@RequestHeader(required = false) String appkey,
-                                           @RequestBody TaskArmReportParam param,
-                                           HttpServletRequest request) {
+                                        @RequestBody TaskArmReportParam param,
+                                        HttpServletRequest request) {
         auth(appkey, param, request);
         if (Cools.isEmpty(param)) {
             return R.parse(BaseRes.PARAM);
@@ -257,8 +275,8 @@
     @PostMapping("/arm/task/cycle_result")
     @AppAuth(memo = "鍗曠爜瀹屾垚")
     public synchronized R TaskArmCycleResult(@RequestHeader(required = false) String appkey,
-                                        @RequestBody TaskArmCycleResultParam param,
-                                        HttpServletRequest request) {
+                                             @RequestBody TaskArmCycleResultParam param,
+                                             HttpServletRequest request) {
         auth(appkey, param, request);
         if (Cools.isEmpty(param)) {
             return R.parse(BaseRes.PARAM);
@@ -289,8 +307,8 @@
     @PostMapping("/arm/task/workspace_status")
     @AppAuth(memo = "鎵樼洏瀹屾垚")
     public synchronized R TaskArmWorkspaceStatus(@RequestHeader(required = false) String appkey,
-                                             @RequestBody TaskArmWorkspaceStatusParam param,
-                                             HttpServletRequest request) {
+                                                 @RequestBody TaskArmWorkspaceStatusParam param,
+                                                 HttpServletRequest request) {
         auth(appkey, param, request);
         if (Cools.isEmpty(param)) {
             return R.parse(BaseRes.PARAM);
@@ -322,8 +340,8 @@
     @PostMapping("/arm/task/loc_status")
 //    @AppAuth(memo = "鎵樼洏灏辩华鐘舵�佹煡璇�")
     public synchronized R TaskArmLocStatus(@RequestHeader(required = false) String appkey,
-                                                 @RequestBody ArmOKParam param,
-                                                 HttpServletRequest request) {
+                                           @RequestBody ArmOKParam param,
+                                           HttpServletRequest request) {
         auth(appkey, param, request);
         if (Cools.isEmpty(param)) {
             return R.parse(BaseRes.PARAM);
@@ -349,8 +367,8 @@
     @PostMapping("/armAbnormalOperation")
 //    @AppAuth(memo = "寮傚父涓婃姤")
     public synchronized R ArmAbnormalOperation(@RequestHeader(required = false) String appkey,
-                                                 @RequestBody TaskArmErrorParam param,
-                                                 HttpServletRequest request) {
+                                               @RequestBody TaskArmErrorParam param,
+                                               HttpServletRequest request) {
         auth(appkey, param, request);
         if (Cools.isEmpty(param.getArm_no())) {
             return R.error("鏈烘鑷傜紪鍙穂Arm_no]涓嶈兘涓虹┖");
@@ -447,6 +465,26 @@
             log.info("[comb] cache: {}", param == null ? "null" : JSON.toJSONString(param));
             request.setAttribute("cache", param);
         }
+
+        if (Cools.isEmpty(param)) {
+            return R.error("娌℃湁鍏ュ簱鏁版嵁");
+        }
+        boolean boo =false;
+        for (MesToCombParam mesToCombParam : param) {
+            if (mesToCombParam.getOperateType()==2){
+                int countLoc = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet", mesToCombParam.getPalletId()));
+                int countWrk = wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("zpallet", mesToCombParam.getPalletId()));
+                int countwait = waitPakinService.selectCount(new EntityWrapper<WaitPakin>().eq("zpallet",mesToCombParam.getPalletId()).eq("io_status", "Y"));
+                if (countLoc > 0 || countWrk > 0 || countwait > 0) {
+                    return R.error(mesToCombParam.getPalletId()+"-宸ヤ綔妗�/搴撳瓨鏉$爜鏁版嵁宸插瓨鍦�,鏃犳硶鍒犻櫎");
+                }
+                waitPakinService.delete(new EntityWrapper<WaitPakin>().eq("zpallet",mesToCombParam.getPalletId()));
+                boo = true;
+            }
+        }
+        if (boo){
+            return R.ok();
+        }
         List<MesToCombParam> errorComb = Lists.newArrayList();
         List<MesToCombParam> validComb = Lists.newArrayList();
         for (MesToCombParam mesToCombParam : param) {
@@ -490,12 +528,13 @@
      */
     @PostMapping("/outOrder")
     public synchronized R outOrder(@RequestBody ArrayList<OutTaskParam> params, HttpServletRequest request) {
+        int count = params.size();
         if (Cools.isEmpty(params)) {
             return R.error("璇锋眰鍙傛暟涓嶈兘涓虹┖");
         }
         log.info("[outOrder] cache: {}", JSON.toJSONString(params));
         request.setAttribute("cache", params);
-        Map<String, List<OutTaskParam>> linesByBatch = new LinkedHashMap<>();
+        Map<String, List<OutTaskParam>> linesByBatchSeq = new LinkedHashMap<>();
         for (OutTaskParam outTaskParam : params) {
             if (Cools.isEmpty(outTaskParam) || Cools.isEmpty(outTaskParam.getOrderId())) {
                 return R.error("鍑哄簱鍗曞彿涓嶈兘涓虹┖");
@@ -506,10 +545,10 @@
             if (Cools.isEmpty(outTaskParam.getStationId())) {
                 return R.error("鎵樼洏銆�" + outTaskParam.getPalletId() + "銆嶅嚭搴撳彛缂栫爜涓嶈兘涓虹┖");
             }
-            linesByBatch.computeIfAbsent(outTaskParam.getBatchSeq(), k -> new ArrayList<>()).add(outTaskParam);
+            linesByBatchSeq.computeIfAbsent(outTaskParam.getBatchSeq(), k -> new ArrayList<>()).add(outTaskParam);
         }
 
-        for (Map.Entry<String, List<OutTaskParam>> entry : linesByBatch.entrySet()) {
+        for (Map.Entry<String, List<OutTaskParam>> entry : linesByBatchSeq.entrySet()) {
             List<OutTaskParam> lines = entry.getValue();
             OutTaskParam head = lines.get(0);
             String oid = head.getOrderId();
@@ -544,8 +583,13 @@
             }
         }
 
+        List<OutTaskParam> groupedParams = new ArrayList<>(params.size());
+        for (List<OutTaskParam> lines : linesByBatchSeq.values()) {
+            groupedParams.addAll(lines);
+        }
+
         Set<String> seenPallet = new LinkedHashSet<>();
-        for (OutTaskParam outTaskParam : params) {
+        for (OutTaskParam outTaskParam : groupedParams) {
             String pid = outTaskParam.getPalletId();
             String palletKey = pid == null ? "" : pid;
             if (!seenPallet.add(palletKey)) {
@@ -574,7 +618,7 @@
 
         List<OutTaskParam> missingStock = Lists.newArrayList();
         List<OutTaskParam> missingLoc = Lists.newArrayList();
-        for (OutTaskParam outTaskParam : params) {
+        for (OutTaskParam outTaskParam : groupedParams) {
             int countLoc = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet", outTaskParam.getPalletId()));
             if (countLoc == 0) {
                 missingStock.add(outTaskParam);
@@ -602,7 +646,7 @@
             return R.error("娌℃湁鎵惧埌鎵樼洏鐮佸搴斿簱浣嶏細" + String.join("锛�", badPalletIds)).add(missingLoc);
         }
 
-        return openService.outOrderBatch(params);
+        return openService.outOrderBatch(linesByBatchSeq,count);
     }
 
     /**
@@ -654,11 +698,20 @@
         return param.getOrderId() + "#" + param.getBatchSeq();
     }
 
+    /**
+     * 鎺ㄨ崘鍑哄簱绔欑偣
+     */
+    @PostMapping("/pakoutStaNo")
+    public synchronized R pakoutStaNo(@RequestBody List<String> barcodes) {
+        String StaNo = "1,2,3,4,5";
+        return R.ok().add(StaNo);
+    }
+
 
     /*************************************鐢佃鏈虹▼搴�***********************************************/
 
     @GetMapping("/locDetl/statistics")
-    public R locDetlStatistics(){
+    public synchronized R locDetlStatistics(){
         HashMap<String, Object> param = new HashMap<>();
         Page<LocDetl> stockStatis = locDetlService.getStockStatis(toPage(1, 100, param, LocDetl.class));
         for (LocDetl locDetl : stockStatis.getRecords()) {
@@ -671,15 +724,15 @@
     }
 
     @GetMapping("/line/charts")
-    public R locIoLineCharts(){
+    public synchronized R locIoLineCharts(){
         Map<String,Object> map=new HashMap<String, Object>();
         List<AxisBean> list = new ArrayList<AxisBean>();
 
         List<WorkChartAxis> listChart = reportQueryMapper.getChartAxis();
 
         if(listChart!=null) {
-            ArrayList<Integer> data1 = new ArrayList<Integer>();
-            ArrayList<Integer> data2 = new ArrayList<Integer>();
+            ArrayList<Number> data1 = new ArrayList<Number>();
+            ArrayList<Number> data2 = new ArrayList<Number>();
 
             SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
             Calendar calendar = Calendar.getInstance();
@@ -702,25 +755,61 @@
                 }
             }
             AxisBean inqty = new AxisBean();
-            inqty.setName("鍏ュ簱鏁伴噺");
-            Integer[] array1 = new Integer[data1.size()];
+            inqty.setName("鍏ュ簱鎵樼洏鏁�");
+            Number[] array1 = new Number[data1.size()];
             inqty.setData(data1.toArray(array1));
             list.add(inqty);
             AxisBean outqty = new AxisBean();
-            outqty.setName("鍑哄簱鏁伴噺");
-            Integer[] array2 = new Integer[data2.size()];
+            outqty.setName("鍑哄簱鎵樼洏鏁�");
+            Number[] array2 = new Number[data2.size()];
             outqty.setData(data2.toArray(array2));
             list.add(outqty);
+
+            AxisBean  teu= new AxisBean();
+            teu.setName("TEU");
+            List<WorkTeuTotalAxis> workTeuTotalAxes = reportQueryMapper.getteuTotal();
+            ArrayList<Number> data3 = new ArrayList<Number>();
+            for (WorkTeuTotalAxis w : workTeuTotalAxes) {
+                data3.add(w.getTeu_total());
+            }
+            Number[] array3 = new Number[data3.size()];
+            teu.setData(data3.toArray(array3));
+            list.add(teu);
+
+            AxisBean cube5 = new AxisBean();
+            cube5.setName("鍏ュ簱浣撶Н");
+            List<WorkCubeTotalAxis> workCubeTotalAxes = reportQueryMapper.getInboundCubeTotal();
+            Map<String, WorkCubeTotalAxis> cubeMap = new HashMap<String, WorkCubeTotalAxis>();
+            if (workCubeTotalAxes != null) {
+                for (WorkCubeTotalAxis w : workCubeTotalAxes) {
+                    if (w.getYmd() != null) {
+                        cubeMap.put(w.getYmd(), w);
+                    }
+                }
+            }
+            ArrayList<Number> data4 = new ArrayList<Number>();
+            SimpleDateFormat sfCube = new SimpleDateFormat("yyyy-MM-dd");
+            Calendar calendarCube = Calendar.getInstance();
+            calendarCube.add(Calendar.DATE, -12);
+            for (int i = 0; i < 12; i++) {
+                calendarCube.add(Calendar.DATE, 1);
+                String str = sfCube.format(calendarCube.getTime());
+                WorkCubeTotalAxis cubeAxis = cubeMap.get(str);
+                data4.add(cubeAxis == null || cubeAxis.getCube5Total() == null ? 0 : cubeAxis.getCube5Total());
+            }
+            Number[] array4 = new Number[data4.size()];
+            cube5.setData(data4.toArray(array4));
+            list.add(cube5);
         }
         map.put("rows",list);
         return R.ok(map);
     }
 
     /**
-     * 杩�24灏忔椂鍏ュ嚭搴撴姌绾匡紙妯酱灏忔椂锛夛紝涓庢寜鏃� {@link #locIoLineCharts()} 鏁版嵁鍙e緞涓嶅悓锛屼緵鐢佃鏈恒�屼綔涓氭晥鐜囥�嶄娇鐢�
+     * 鍏ュ嚭搴撴寜灏忔椂鎶樼嚎锛氭í杞翠负銆屽綋鍓嶆暣鐐硅捣鍚戝墠鍏� 12 灏忔椂銆嶆粴鍔ㄧ獥鍙o紝涓庡簱琛� ymd锛坹yyy-MM-dd HH锛夊榻�
      */
     @GetMapping("/line/charts/hourly")
-    public R locIoLineChartsHourly() {
+    public synchronized R locIoLineChartsHourly() {
         Map<String, Object> map = new HashMap<>();
         List<AxisBean> list = new ArrayList<>();
 
@@ -731,45 +820,82 @@
 
         ArrayList<Integer> data1 = new ArrayList<>();
         ArrayList<Integer> data2 = new ArrayList<>();
+        ArrayList<Double> data3 = new ArrayList<>();
+        ArrayList<Double> data4 = new ArrayList<>();
+        ArrayList<Double> data5 = new ArrayList<>();
         List<String> categories = new ArrayList<>();
 
+        final int n = 12;
         SimpleDateFormat sfKey = new SimpleDateFormat("yyyy-MM-dd HH");
-        SimpleDateFormat sfLabel = new SimpleDateFormat("HH:00");
         Calendar calendar = Calendar.getInstance();
         calendar.set(Calendar.MINUTE, 0);
         calendar.set(Calendar.SECOND, 0);
         calendar.set(Calendar.MILLISECOND, 0);
-        calendar.add(Calendar.HOUR_OF_DAY, -23);
+        calendar.add(Calendar.HOUR_OF_DAY, -(n - 1));
 
-        for (int i = 0; i < 24; i++) {
+        for (int i = 0; i < n; i++) {
             String key = sfKey.format(calendar.getTime());
-            categories.add(sfLabel.format(calendar.getTime()));
+            categories.add(String.valueOf(calendar.get(Calendar.HOUR_OF_DAY)));
 
             int inV = 0;
             int outV = 0;
+            double inC = 0;
+            double outC = 0;
+            double outD = 0;
             for (WorkChartAxis w : listChart) {
                 if (w.getYmd() != null && key.equals(w.getYmd().trim())) {
                     inV = w.getInqty();
                     outV = w.getOutqty();
+                    inC = w.getCubeInqty();
+                    outC = w.getCubeOutqty();
+                    outD = w.getOutTeu();
                     break;
                 }
             }
             data1.add(inV);
             data2.add(outV);
+            data3.add(inC);
+            data4.add(outC);
+            data5.add(outD);
             calendar.add(Calendar.HOUR_OF_DAY, 1);
         }
 
         AxisBean inqty = new AxisBean();
-        inqty.setName("鍏ュ簱鏁伴噺");
+        inqty.setName("鍏ュ簱鎵樼洏鏁�");
         Integer[] array1 = new Integer[data1.size()];
         inqty.setData(data1.toArray(array1));
         list.add(inqty);
 
         AxisBean outqty = new AxisBean();
-        outqty.setName("鍑哄簱鏁伴噺");
+        outqty.setName("鍑哄簱鎵樼洏鏁�");
         Integer[] array2 = new Integer[data2.size()];
         outqty.setData(data2.toArray(array2));
         list.add(outqty);
+
+        if (data3.size() >0) {
+            AxisBean cubeInqty = new AxisBean();
+            cubeInqty.setName("鍏ュ簱浣撶Н");
+            Double [] array3 = new Double[data3.size()];
+            cubeInqty.setData(data3.toArray(array3));
+            list.add(cubeInqty);
+        }
+
+        if (data4.size() >0) {
+            AxisBean cubeOutqty = new AxisBean();
+            cubeOutqty.setName("鍑哄簱浣撶Н");
+            Double[] array4 = new Double[data4.size()];
+            cubeOutqty.setData(data4.toArray(array4));
+            list.add(cubeOutqty);
+        }
+
+        if (data5.size() >0) {
+            AxisBean cubeOutqty = new AxisBean();
+            cubeOutqty.setName("鍑哄簱TEU");
+            Double[] array5 = new Double[data4.size()];
+            cubeOutqty.setData(data5.toArray(array5));
+            list.add(cubeOutqty);
+        }
+
 
         map.put("categories", categories);
         map.put("rows", list);
@@ -807,7 +933,8 @@
         }
 
         // 鎬诲簱浣嶆暟
-        Integer total = (int) Arith.add(0, locUseRate.getFqty(), locUseRate.getOqty(), locUseRate.getUqty(), locUseRate.getXqty());
+        Integer total1 = (int) Arith.add(0, locUseRate.getFqty(), locUseRate.getOqty(), locUseRate.getUqty(), locUseRate.getXqty());
+        Integer total = total1>40000?6528:total1;
         // 浣跨敤涓�
         Integer used = locUseRate.getFqty() + locUseRate.getUqty();
         // 搴撲綅浣跨敤鐜�
@@ -851,7 +978,74 @@
         map.put("taskNo", param.getTaskNo());
         map.put("ioType", wrkMast.getIoType());
         map.put("wrkDetls", wrkDetls);
+        Integer count = 0;
+        String supp = "";
+        //璇ヨ鍗曠疮璁″叆鍑哄簱浠舵暟
+        Integer ioType = wrkMast.getIoType();
+        Integer suppCount = 0;
+        Integer sum = 0;
+        if (ioType != null && ioType < 100) {
+            supp = String.valueOf(resolveInboundSupp(wrkMast));
+            map.put("supp", supp);
+        }else {
+            String[] split = wrkDetls.get(0).getSupp().split("/");
+            if (split != null && split.length > 0) {
+                sum = Integer.valueOf(split[split.length - 1]);
+            }else {
+                sum = Integer.valueOf(wrkDetls.get(0).getSupp());
+            }
+            List<WrkMast> userNo = wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("user_no", wrkMast.getUserNo()).in("wrk_sts",11,12,21,22,25));
+            suppCount = sum - userNo.size()+1;
+            map.put("supp", suppCount + "/" + sum);
+        }
+
+        //鑰楁椂
+        Long costTime = resolveCostTime(wrkMast);
+        map.put("costTime", String.valueOf(costTime));
+
         return R.ok().add(map);
     }
+
+    Long resolveCostTime(WrkMast wrkMast) {
+        return resolveCostTime(wrkMast, new Date());
+    }
+
+    Long resolveCostTime(WrkMast wrkMast, Date now) {
+        if (wrkMast == null || wrkMast.getIoType() == null) {
+            return 0L;
+        }
+        if (wrkMast.getIoType() < 100) {
+            if (Cools.isEmpty(wrkMast.getTrainNo())) {
+                return 0L;
+            }
+            return minutesBetween(wrkMastService.firstInboundCreateTimeByTrainNo(wrkMast.getTrainNo()), resolveTaskCreateTime(wrkMast));
+        }
+        return minutesBetween(resolveTaskCreateTime(wrkMast), now);
+    }
+
+    int resolveInboundSupp(WrkMast wrkMast) {
+        if (wrkMast == null || wrkMast.getIoType() == null || wrkMast.getIoType() >= 100 || Cools.isEmpty(wrkMast.getTrainNo())) {
+            return 0;
+        }
+        return wrkMastService.finishedInboundPalletCountByTrainNo(wrkMast.getTrainNo());
+    }
+
+    private Date resolveTaskCreateTime(WrkMast wrkMast) {
+        if (wrkMast == null) {
+            return null;
+        }
+        return wrkMast.getAppeTime() == null ? wrkMast.getIoTime() : wrkMast.getAppeTime();
+    }
+
+    private Long minutesBetween(Date startTime, Date endTime) {
+        if (startTime == null || endTime == null) {
+            return 0L;
+        }
+        long diff = endTime.getTime() - startTime.getTime();
+        if (diff <= 0) {
+            return 0L;
+        }
+        return diff / MILLIS_PER_MINUTE;
+    }
 }
 

--
Gitblit v1.9.1