From ec34bee74e62cd7aee25c8a207e183572d37454e Mon Sep 17 00:00:00 2001
From: 野心家 <1051256694@qq.com>
Date: 星期二, 17 十二月 2024 15:16:29 +0800
Subject: [PATCH] 1.订单出库,优先出一筐的货 2.订单打印,制令号从Mat表中拿

---
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/OrderController.java |   98 +++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 79 insertions(+), 19 deletions(-)

diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/OrderController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/OrderController.java
index d8fbe6f..4dd8f89 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/OrderController.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/controller/OrderController.java
@@ -3,11 +3,14 @@
 import com.alibaba.fastjson.JSONArray;
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.Query;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.zy.asrs.common.domain.dto.DetlDto;
 import com.zy.asrs.common.domain.dto.WrkTraceVo;
 import com.zy.asrs.common.domain.param.OrderDomainParam;
 import com.zy.asrs.common.wms.entity.*;
+import com.zy.asrs.common.wms.mapper.OrderDetlMapper;
 import com.zy.asrs.common.wms.service.*;
 import com.zy.asrs.framework.annotations.ManagerAuth;
 import com.zy.asrs.framework.common.Cools;
@@ -17,13 +20,17 @@
 import com.zy.asrs.framework.common.DateUtils;
 import com.zy.asrs.common.web.BaseController;
 import com.zy.asrs.framework.exception.CoolException;
+import org.apache.ibatis.annotations.Param;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.jdbc.core.JdbcTemplate;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.transaction.interceptor.TransactionAspectSupport;
 import org.springframework.web.bind.annotation.*;
 
+import java.io.UnsupportedEncodingException;
 import java.math.BigDecimal;
+import java.net.URLDecoder;
 import java.util.*;
 
 @RestController
@@ -47,15 +54,22 @@
     private SnowflakeIdWorker snowflakeIdWorker;
     @Autowired
     private DocTypeService docTypeService;
+    @Autowired
+    private LocInPrintMatService locInPrintMatService;
+    @Autowired
+    private MatService matService;
 
     @RequestMapping(value = "/order/list/orderNo")
     public R orderListorderNo(@RequestParam String orderNo) {
         //鏁伴噺淇敼鎴愪负瀹屾垚鏁伴噺
-        List<OrderDetl> orderDetl1=orderDetlService.list(new LambdaQueryWrapper<OrderDetl>().eq(OrderDetl::getOrderNo,orderNo));
+        List<OrderDetl> orderDetl1 = orderDetlService.list(new LambdaQueryWrapper<OrderDetl>().eq(OrderDetl::getOrderNo, orderNo));
         List<OrderDetl> orderDetls= new ArrayList<OrderDetl>();
         for (OrderDetl o: orderDetl1) {
             BigDecimal c1 = new BigDecimal(o.getEnableQty()).setScale(2,BigDecimal.ROUND_HALF_UP);
             o.setAnfme(c1.doubleValue());
+            if (o.getAnfme().equals(0.0)){
+                continue;
+            }
             orderDetls.add(o);
         }
         return R.ok(orderDetls);
@@ -67,10 +81,22 @@
         return R.ok(orderService.selectAllorderNo(getHostId()));
     }
 
+    @RequestMapping(value = "/order/comb/list/all")
+    @ManagerAuth
+    public R orderListComb() {
+        return R.ok(orderService.selectAllCombOrderNo(getHostId()));
+    }
+
+//    @RequestMapping(value = "/outOrder/list/all")
+//    @ManagerAuth
+//    public R orderOutList() {
+//        return R.ok(orderService.selectAllOutOrderNo(getHostId()));
+//    }
+
     @RequestMapping(value = "/outOrder/list/all")
     @ManagerAuth
-    public R orderOutList() {
-        return R.ok(orderService.selectAllOutOrderNo(getHostId()));
+    public R orderOutListOrder(@RequestBody String orderNo) {
+        return R.ok(orderService.selectAllOutOrderNo(orderNo,getHostId()));
     }
 
     @RequestMapping(value = "/order/{id}/auth")
@@ -86,16 +112,17 @@
                   @RequestParam(required = false) String condition,
                   @RequestParam(required = false) String timeRange,
                   @RequestParam Map<String, Object> param) {
-        LambdaQueryWrapper<Order> wrapper = new LambdaQueryWrapper<>();
-        wrapper.eq(Order::getHostId, getHostId());
+        QueryWrapper<Order> wrapper = new QueryWrapper<>();
+        wrapper.eq("host_id", getHostId());
         if (!Cools.isEmpty(condition)) {
-            wrapper.like(Order::getId, condition);
+            wrapper.like("id", condition);
         }
         if (!Cools.isEmpty(timeRange)) {
             String[] range = timeRange.split(RANGE_TIME_LINK);
-            wrapper.ge(Order::getCreateTime, DateUtils.convert(range[0]));
-            wrapper.le(Order::getCreateTime, DateUtils.convert(range[1]));
+            wrapper.ge("create_time", DateUtils.convert(range[0]));
+            wrapper.le("create_time", DateUtils.convert(range[1]));
         }
+        allLike(Order.class, param.keySet(), wrapper, condition);
         return R.ok(orderService.page(new Page<>(curr, limit), wrapper));
     }
 
@@ -103,31 +130,40 @@
     @ManagerAuth
     public R head(@RequestParam(defaultValue = "1")Integer curr,
                   @RequestParam(defaultValue = "10")Integer limit,
+                  @RequestParam(required = false) String condition,
                   @RequestParam(required = false)String orderByField,
                   @RequestParam(required = false)String orderByType,
-                  @RequestParam Map<String, Object> param){
-        LambdaQueryWrapper<Order> wrapper = new LambdaQueryWrapper<>();
+                  @RequestParam Map<String, Object> param) throws UnsupportedEncodingException {
+        if(!Cools.isEmpty(condition)){
+            condition = condition.trim();
+        }
+        QueryWrapper<Order> wrapper = new QueryWrapper<>();
         excludeTrash(param);
-        wrapper.eq(Order::getStatus, 1);
-        wrapper.eq(Order::getHostId, getHostId());
+        wrapper.eq("status", 1);
+        wrapper.eq("host_id", getHostId());
         if (!Cools.isEmpty(param.get("order_no"))) {
-            wrapper.eq(Order::getOrderNo, param.get("order_no"));
+            wrapper.eq("order_no", param.get("order_no"));
         }
         if (!Cools.isEmpty(param.get("create_time"))) {
             String[] range = param.get("create_time").toString().split(RANGE_TIME_LINK);
-            wrapper.ge(Order::getCreateTime, DateUtils.convert(range[0]));
-            wrapper.le(Order::getCreateTime, DateUtils.convert(range[1]));
+            wrapper.ge("create_time", DateUtils.convert(range[0]));
+            wrapper.le("create_time", DateUtils.convert(range[1]));
         }
         if (!Cools.isEmpty(param.get("doc_type"))) {
-            wrapper.eq(Order::getDocType, param.get("doc_type"));
+            wrapper.eq("doc_type", param.get("doc_type"));
         }
         if (!Cools.isEmpty(param.get("docName"))) {
-            DocType docType = docTypeService.getOne(new LambdaQueryWrapper<DocType>().eq(DocType::getDocName, param.get("docName")));
-            wrapper.eq(Order::getDocType, docType.getDocId());
+            String docName = URLDecoder.decode(param.get("docName").toString(), "UTF-8");
+            DocType docType = docTypeService.getOne(new LambdaQueryWrapper<DocType>().eq(DocType::getDocName, docName));
+            wrapper.eq("doc_type", docType.getDocId());
         }
         if (!Cools.isEmpty(param.get("settle"))) {
-            wrapper.eq(Order::getSettle, param.get("settle"));
+            wrapper.eq("settle", param.get("settle"));
         }
+
+        param.remove("order_no");
+        allLike(Order.class, param.keySet(), wrapper, condition);
+        wrapper.orderByDesc("create_time");
         return R.ok(orderService.page(new Page<>(curr, limit), wrapper));
     }
 
@@ -168,6 +204,30 @@
         return R.ok();
     }
 
+    @RequestMapping(value = "/order/dy")
+    @ManagerAuth(memo = "鎵嬪姩鍒犻櫎璁㈠崟")
+    @Transactional
+    public R dy(@RequestParam Long orderId){
+        List<OrderDetl> list = orderDetlService.list(new LambdaQueryWrapper<OrderDetl>().eq(OrderDetl::getOrderId, orderId));
+        for (OrderDetl orderDetl : list) {
+            Mat mat = matService.getOne(new LambdaQueryWrapper<Mat>().eq(Mat::getMatnr, orderDetl.getMatnr()));
+            LocInPrintMat locInPrintMat = new LocInPrintMat();
+            locInPrintMat.setMatnr(orderDetl.getMatnr());
+            locInPrintMat.setMaktx(orderDetl.getMaktx());
+            locInPrintMat.setStatus(1);
+            locInPrintMat.setOrderNo(orderDetl.getOrderNo());
+            locInPrintMat.setBatch(orderDetl.getBatch());
+            locInPrintMat.setCreateBy(getUserId());
+            locInPrintMat.setCreateTime(new Date());
+            locInPrintMat.setUpdateTime(new Date());
+            if(!Cools.isEmpty(mat)){
+                locInPrintMat.setDecrees(mat.getDecrees());
+            }
+            locInPrintMatService.save(locInPrintMat);
+        }
+        return R.ok();
+    }
+
     @RequestMapping(value = "/orderQuery/auth")
     @ManagerAuth
     public R query(String condition) {

--
Gitblit v1.9.1