From ac4341ea6b66ae02427d39d35f41d42d78b2eb2e Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 14 二月 2025 10:08:32 +0800
Subject: [PATCH] #

---
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java |  125 ++++++++++++++++++++++++++++++++++-------
 1 files changed, 104 insertions(+), 21 deletions(-)

diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java
index 26147cd..984a684 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocDetlController.java
@@ -1,14 +1,20 @@
 package com.zy.asrs.wms.asrs.controller;
 
 import com.alibaba.fastjson.JSON;
-import com.alibaba.fastjson.JSONObject;
+import com.alibaba.fastjson.parser.Feature;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.zy.asrs.framework.common.Cools;
 import com.zy.asrs.framework.common.R;
+import com.zy.asrs.framework.exception.CoolException;
 import com.zy.asrs.wms.asrs.entity.*;
+import com.zy.asrs.wms.asrs.entity.enums.LocStsType;
+import com.zy.asrs.wms.asrs.entity.param.LocDetlFreezeParam;
 import com.zy.asrs.wms.asrs.service.LocDetlFieldService;
+import com.zy.asrs.wms.asrs.service.LocService;
 import com.zy.asrs.wms.asrs.service.MatFieldService;
+import com.zy.asrs.wms.common.annotation.CacheData;
 import com.zy.asrs.wms.common.annotation.OperationLog;
 import com.zy.asrs.wms.common.domain.BaseParam;
 import com.zy.asrs.wms.common.domain.KeyValVo;
@@ -21,15 +27,14 @@
 import org.springframework.web.bind.annotation.*;
 
 import javax.servlet.http.HttpServletResponse;
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 
 @RestController
 @RequestMapping("/api")
 public class LocDetlController extends BaseController {
 
+    @Autowired
+    private LocService locService;
     @Autowired
     private LocDetlService locDetlService;
     @Autowired
@@ -39,20 +44,8 @@
 
     @PreAuthorize("hasAuthority('asrs:locDetl:list')")
     @PostMapping("/locDetl/page")
+    @CacheData(tableName = {"man_loc_detl"})
     public R page(@RequestBody Map<String, Object> map) {
-//        BaseParam baseParam = buildParam(map, BaseParam.class);
-//        PageParam<LocDetl, BaseParam> pageParam = new PageParam<>(baseParam, LocDetl.class);
-//
-//        PageParam<LocDetl, BaseParam> page = locDetlService.page(pageParam, pageParam.buildWrapper(true));
-//        JSONObject data = JSON.parseObject(JSON.toJSONString(page));
-//
-//        List<LocDetl> records = page.getRecords();
-//        data.put("records", records);
-//        for (LocDetl locDetl : records) {
-//            List<LocDetlField> list = locDetlFieldService.list(new LambdaQueryWrapper<LocDetlField>().eq(LocDetlField::getDetlId, locDetl.getId()));
-//            locDetl.syncField(list);
-//        }
-
         BaseParam baseParam = buildParam(map, BaseParam.class);
         PageParam<ViewLocDetl, BaseParam> pageParam = new PageParam<>(baseParam, ViewLocDetl.class);
         PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, pageParam.buildWrapper(true));
@@ -60,14 +53,64 @@
     }
 
     @PreAuthorize("hasAuthority('asrs:locDetl:list')")
+    @PostMapping("/locDetl/outPage")
+    @CacheData(tableName = {"man_loc_detl"})
+    public R outPage(@RequestBody Map<String, Object> map) {
+        BaseParam baseParam = buildParam(map, BaseParam.class);
+        PageParam<ViewLocDetl, BaseParam> pageParam = new PageParam<>(baseParam, ViewLocDetl.class);
+
+        QueryWrapper<ViewLocDetl> queryWrapper = pageParam.buildWrapper(true);
+        List<Long> locIds = locService.listBySts(LocStsType.F.val());
+        if (locIds.isEmpty()) {
+            locIds.add(-1L);
+        }
+        queryWrapper.in("loc_id", locIds);
+        PageParam<ViewLocDetl, BaseParam> data = locDetlService.getPage(pageParam, queryWrapper);
+        return R.ok().add(data);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locDetl:list')")
     @PostMapping("/locDetl/list")
+    @CacheData(tableName = {"man_loc_detl"})
     public R list(@RequestBody Map<String, Object> map) {
         List<LocDetl> list = locDetlService.getLocDetlList(map);
         return R.ok().add(list);
     }
 
     @PreAuthorize("hasAuthority('asrs:locDetl:list')")
+    @PostMapping("/locDetl/listByIds")
+    @CacheData(tableName = {"man_loc_detl"})
+    public R listByIds(@RequestBody List<Long> ids) {
+        List<LocDetl> list = locDetlService.listByIds(ids);
+        List<LocDetl> locDetls = locDetlService.parseLocDetl(list);
+        return R.ok().add(locDetls);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locDetl:list')")
+    @GetMapping("/locDetl/locId/{locId}")
+    @CacheData(tableName = {"man_loc_detl"})
+    public R list(@PathVariable("locId") Long locId) {
+        List<LocDetl> list = locDetlService.list(new LambdaQueryWrapper<LocDetl>().eq(LocDetl::getLocId, locId));
+        List<LocDetl> locDetls = locDetlService.parseLocDetl(list);
+        return R.ok().add(locDetls);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locDetl:list')")
+    @GetMapping("/locDetl/locNo/{locNo}")
+    @CacheData(tableName = {"man_loc_detl"})
+    public R list(@PathVariable("locNo") String locNo) {
+        Loc loc = locService.getOne(new LambdaQueryWrapper<Loc>().eq(Loc::getLocNo, locNo));
+        if (loc == null) {
+            return R.error("搴撲綅涓嶅瓨鍦�");
+        }
+        List<LocDetl> list = locDetlService.list(new LambdaQueryWrapper<LocDetl>().eq(LocDetl::getLocId, loc.getId()));
+        List<LocDetl> locDetls = locDetlService.parseLocDetl(list);
+        return R.ok().add(locDetls);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locDetl:list')")
     @GetMapping("/locDetl/{id}")
+    @CacheData(tableName = {"man_loc_detl"})
     public R get(@PathVariable("id") Long id) {
         return R.ok().add(locDetlService.getById(id));
     }
@@ -97,14 +140,17 @@
             locDetlField.setName(matField.getName());
             locDetlFieldService.save(locDetlField);
         }
-
         return R.ok("娣诲姞鎴愬姛");
     }
 
     @PreAuthorize("hasAuthority('asrs:locDetl:update')")
     @OperationLog("淇敼搴撳瓨鏄庣粏")
     @PostMapping("/locDetl/update")
-    public R update(@RequestBody LocDetl locDetl) {
+    public R update(@RequestBody HashMap<String,Object> param) {
+        LocDetl locDetl = JSON.parseObject(JSON.toJSONString(param), LocDetl.class, Feature.DisableCircularReferenceDetect);
+        //璁剧疆鎵╁睍瀛楁
+        setLocDetlField(param, locDetl);
+
         if (!locDetlService.updateById(locDetl)) {
             return R.error("淇敼澶辫触");
         }
@@ -138,7 +184,44 @@
     @PreAuthorize("hasAuthority('asrs:locDetl:list')")
     @PostMapping("/locDetl/export")
     public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
-        ExcelUtil.build(ExcelUtil.create(locDetlService.list(), LocDetl.class), response);
+        BaseParam baseParam = buildParam(map, BaseParam.class);
+        PageParam<LocDetl, BaseParam> pageParam = new PageParam<>(baseParam, LocDetl.class);
+        List<LocDetl> data = locDetlService.list(pageParam.buildWrapper(true));
+
+        List<LocDetl> locDetls = locDetlService.parseLocDetl(data);
+        List<MatField> locFields = matFieldService.getLocFields();
+        ExcelUtil.build(ExcelUtil.create(locDetls, LocDetl.class, locFields), response);
+    }
+
+    private void setLocDetlField(HashMap<String, Object> param, LocDetl locDetl) {
+        //鑾峰彇鎵╁睍瀛楁
+        List<MatField> matFields = matFieldService.list(new LambdaQueryWrapper<MatField>().eq(MatField::getFieldType, 1));
+        for (MatField matField : matFields) {
+            if (param.containsKey(matField.getName())) {
+                LocDetlField fieldValue = locDetlFieldService.getOne(new LambdaQueryWrapper<LocDetlField>()
+                        .eq(LocDetlField::getDetlId, locDetl.getId())
+                        .eq(LocDetlField::getFieldId, matField.getId()));
+                if (fieldValue == null) {
+                    fieldValue = new LocDetlField();
+                    fieldValue.setDetlId(locDetl.getId());
+                    fieldValue.setFieldId(matField.getId());
+                    fieldValue.setName(matField.getName());
+                    fieldValue.setValue(param.get(matField.getName()).toString());
+                    locDetlFieldService.save(fieldValue);
+                }else {
+                    fieldValue.setValue(param.get(matField.getName()).toString());
+                    locDetlFieldService.updateById(fieldValue);
+                }
+            }
+        }
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locDetl:update')")
+    @OperationLog("搴撳瓨鍐荤粨")
+    @PostMapping("/locDetl/freeze")
+    public R freeze(@RequestBody LocDetlFreezeParam param) {
+        locDetlService.locDetlFreeze(param);
+        return R.ok();
     }
 
 }

--
Gitblit v1.9.1