From 8bc35cc4f75cfb435577e34763002f69def6a1a2 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期六, 07 二月 2026 16:53:18 +0800
Subject: [PATCH] 调试

---
 src/main/java/com/zy/asrs/controller/LocMastController.java |   98 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 97 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/LocMastController.java b/src/main/java/com/zy/asrs/controller/LocMastController.java
index 2d82d5e..a6d80f3 100644
--- a/src/main/java/com/zy/asrs/controller/LocMastController.java
+++ b/src/main/java/com/zy/asrs/controller/LocMastController.java
@@ -23,7 +23,10 @@
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.web.bind.annotation.*;
 
+import javax.validation.constraints.Size;
+import java.math.BigDecimal;
 import java.util.*;
+import java.util.stream.Collectors;
 
 @RestController
 public class LocMastController extends BaseController {
@@ -116,6 +119,7 @@
                 locDetlService.delete(new EntityWrapper<LocDetl>().eq("loc_no", locMast.getLocNo()));
             }
         }
+        locMast.setBarcode("");
         locMast.setModiUser(getUserId());
         locMast.setModiTime(new Date());
         locMastService.updateById(locMast);
@@ -176,7 +180,7 @@
     @ManagerAuth(memo = "鍒濆鍖栧簱浣�")
 //    @Transactional
     public R init(LocMastInitParam param) {
-        List<LocMast> list = new ArrayList<>();
+       List<LocMast> list = new ArrayList<>();
         for (int r=param.getStartRow(); r<=param.getEndRow(); r++){
             for (int b=param.getStartBay(); b<=param.getEndBay(); b++) {
                 for (int l=param.getStartLev(); l<=param.getEndLev(); l++) {
@@ -222,4 +226,96 @@
         locMastService.insertBatch(list);
         return R.ok("鍒濆鍖栨垚鍔�");
     }
+
+    @RequestMapping(value = "/locMast/list/auth/lev")
+    @ManagerAuth
+    public R listLev(@RequestParam(defaultValue = "1")Integer curr,
+                  @RequestParam(defaultValue = "10")Integer limit,
+                  @RequestParam(required = false)String orderByField,
+                  @RequestParam(required = false)String orderByType,
+                  @RequestParam Map<String, Object> param){
+        excludeTrash(param);
+        EntityWrapper<LocMast> wrapper = new EntityWrapper<>();
+        convertLev(param, wrapper);
+        if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
+        return R.ok(locMastService.selectPage(new Page<>(curr, limit), wrapper));
+    }
+
+    @RequestMapping(value = "/locMast/list/auth/lev/clamp")
+    @ManagerAuth
+    public R listLevClamp(@RequestParam(defaultValue = "1")Integer curr,
+                     @RequestParam(defaultValue = "10")Integer limit,
+                     @RequestParam(required = false)String orderByField,
+                     @RequestParam(required = false)String orderByType,
+                     @RequestParam Map<String, Object> param){
+        excludeTrash(param);
+        EntityWrapper<LocMast> wrapper = new EntityWrapper<>();
+        convertLev(param, wrapper);
+        if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
+        Page<LocMast> pageResult = locMastService.selectPage(new Page<>(curr, limit), wrapper);
+        if (pageResult != null && pageResult.getRecords() != null && !pageResult.getRecords().isEmpty()) {
+            // 鑾峰彇鎵�鏈塴oc_no
+            List<String> locNos = pageResult.getRecords().stream()
+                    .map(LocMast::getLocNo) // 鍋囪鏈塯etLocNo鏂规硶
+                    .filter(Objects::nonNull)
+                    .distinct()
+                    .collect(Collectors.toList());
+            if (!Cools.isEmpty(locNos)) {
+                Map<String, Double> anfmeMap = locDetlService.getAnfmeByLocNos(locNos);
+                // 鏇存柊sc_weight瀛楁
+                for (LocMast locMast : pageResult.getRecords()) {
+                    if (locMast.getLocNo() != null && anfmeMap.containsKey(locMast.getLocNo())) {
+                        locMast.setScWeight(anfmeMap.get(locMast.getLocNo())); // 鍋囪鏈塻etScWeight鏂规硶
+                    } else {
+                        locMast.setScWeight(0.0); // 濡傛灉娌℃湁瀵瑰簲鏁版嵁锛岃涓�0鎴杗ull
+                    }
+                }
+            }
+        }
+        return R.ok(pageResult);
+    }
+
+    private <T> void convertLev(Map<String, Object> map, EntityWrapper<T> wrapper){
+        String sizeValue = null;
+
+        // 绗竴姝ワ細鍏堝鐞唖ize鍙傛暟
+        if (map.containsKey("size")) {
+            sizeValue = String.valueOf(map.get("size"));
+            map.remove("size");  // 浠巑ap涓Щ闄わ紝閬垮厤鍚庨潰閲嶅澶勭悊
+
+            if (sizeValue.equals("2000*1500*170")){
+                wrapper.in("lev1", Arrays.asList(4, 5)).andNew().eq("crn_no", 1);
+            }else if (sizeValue.equals("1500*1500*170")){
+                wrapper.in("lev1", Arrays.asList(1, 2, 3)).andNew().eq("crn_no", 1);
+            }else if (sizeValue.equals("2600*1500*160")){
+                wrapper.in("lev1", Arrays.asList(1, 2)).andNew().eq("crn_no", 2);
+            }else if (sizeValue.equals("1300*1500*160")){
+                wrapper.in("lev1", Arrays.asList(3, 4, 5, 6)).andNew().eq("crn_no", 2);
+            }
+        }
+
+        // 绗簩姝ワ細澶勭悊鍏朵粬鍙傛暟
+        for (Map.Entry<String, Object> entry : map.entrySet()){
+            String key = entry.getKey();
+            String val = String.valueOf(entry.getValue());
+
+            if (val.contains(RANGE_TIME_LINK)){
+                String[] dates = val.split(RANGE_TIME_LINK);
+                wrapper.ge(key, DateUtils.convert(dates[0]));
+                wrapper.le(key, DateUtils.convert(dates[1]));
+            } else if (key.equals("loc_no")){
+                wrapper.like(key, val);
+            } else {
+                wrapper.eq(key, val);
+            }
+        }
+
+        // 绗笁姝ワ細濡傛灉娌℃湁size鍙傛暟锛屽垯娣诲姞榛樿鏉′欢
+        if (sizeValue == null) {
+            wrapper.eq("loc_sts", map.get("loc_sts"));
+        } else {
+            // 濡傛灉鏈塻ize鍙傛暟锛屾坊鍔爈oc_sts != 'Y'鐨勬潯浠�
+            wrapper.and().ne("loc_sts", "Y");
+        }
+    }
 }

--
Gitblit v1.9.1