From dd5a31d7eb01fa754a37f5cdcc7f7d2ba7397600 Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期二, 31 十二月 2024 09:25:53 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/controller/LocDetlController.java |   57 ++++++++++++++++++++++-----------------------------------
 1 files changed, 22 insertions(+), 35 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/LocDetlController.java b/src/main/java/com/zy/asrs/controller/LocDetlController.java
index 5cb0385..655e6f1 100644
--- a/src/main/java/com/zy/asrs/controller/LocDetlController.java
+++ b/src/main/java/com/zy/asrs/controller/LocDetlController.java
@@ -82,41 +82,11 @@
                 param.remove("modi_time");
             }
         }
-        param.remove("curr");
-        param.remove("limit");
-        EntityWrapper<LocDetl> wrapper = new EntityWrapper<>();
-        if (!Cools.isEmpty(param.get("crnNo"))) {
-            switch ((String) param.get("crnNo")) {
-                case "1": wrapper.le("SUBSTRING(loc_no, 1, 2)",4);
-                    break;
-                case "2":wrapper.ge("SUBSTRING(loc_no, 1, 2)",5).le("SUBSTRING(loc_no, 1, 2)",8);
-                    break;
-                case "3":wrapper.ge("SUBSTRING(loc_no, 1, 2)",9).le("SUBSTRING(loc_no, 1, 2)",12);
-                    break;
-                case "4":wrapper.ge("SUBSTRING(loc_no, 1, 2)",13).le("SUBSTRING(loc_no, 1, 2)",16);
-                    break;
-                case "5":
-                    break;
-                case "6":
-                    break;
-                case "7":wrapper.ge("SUBSTRING(loc_no, 1, 2)",17).le("SUBSTRING(loc_no, 1, 2)",37);
-                    break;
-                case "8":wrapper.ge("SUBSTRING(loc_no, 1, 2)",38).le("SUBSTRING(loc_no, 1, 2)",45);
-                    break;
-                case "9":wrapper.ge("SUBSTRING(loc_no, 1, 2)",46).le("SUBSTRING(loc_no, 1, 2)",53);
-                    break;
-                default:
-            }
-            param.remove("crnNo");
+        Page<LocDetl> stockOut = locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class));
+        if (stockOut.getRecords().size()==0){
+            stockOut = locDetlService.getStockOut(toPage(1, limit, param, LocDetl.class));
         }
-        convert(param, wrapper);
-        // 涓嶅悓缁ф壙瑙掕壊鏄剧ず涓嶅悓搴撲俊鎭�
-        RoleUtils.addRoleWrapperByLocNo(getUserId(),wrapper);
-        Page<LocDetl> locDetlPage = locDetlService.selectPage(new Page<>(curr, limit), wrapper);
-        if (locDetlPage.getRecords().size()==0){
-            locDetlPage = locDetlService.selectPage(new Page<>(1, limit), wrapper);
-        }
-        return R.ok(locDetlPage);
+        return R.ok(stockOut);
     }
 
     @RequestMapping(value = "/stock/out/crn/list/auth")
@@ -329,7 +299,24 @@
      */
     @RequestMapping("/locDetl/count")
     public R getAllCount(){
-        Integer sum = locDetlService.sum();
+        Double sum = locDetlService.sum();
+        return R.ok(sum);
+    }
+
+    /**
+     * 鑾峰彇搴撳瓨鎬绘暟
+     * @return
+     */
+    @RequestMapping("/locDetl/matnr/count")
+    public R getCount(@RequestBody Map<String, String> param){
+        String matnr = param.get("matnr");
+        Double sum = 0.0;
+        if (Cools.isEmpty(matnr)){
+            sum = locDetlService.sum();
+        }else {
+            sum = locDetlService.getSumAnfme(matnr);
+        }
+
         return R.ok(sum);
     }
 

--
Gitblit v1.9.1