From 1286f6fd5625d3d058d1dcff11b8fda303d6c455 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期二, 11 三月 2025 10:28:43 +0800
Subject: [PATCH] 四期

---
 src/main/java/com/zy/asrs/controller/OrderController.java |   63 +++++++++++++++++++++++++++----
 1 files changed, 55 insertions(+), 8 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OrderController.java b/src/main/java/com/zy/asrs/controller/OrderController.java
index 496b16c..a0b3139 100644
--- a/src/main/java/com/zy/asrs/controller/OrderController.java
+++ b/src/main/java/com/zy/asrs/controller/OrderController.java
@@ -1,6 +1,7 @@
 package com.zy.asrs.controller;
 
 import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.enums.SqlLike;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.baomidou.mybatisplus.mapper.Wrapper;
 import com.baomidou.mybatisplus.plugins.Page;
@@ -220,15 +221,20 @@
     @RequestMapping(value = "/order/detls/pakin/page/auth/v2")
     @ManagerAuth
     public R orderDetlsV2(@RequestParam(defaultValue = "1") Integer curr,
-                        @RequestParam(defaultValue = "100") Integer limit,
-                        @RequestParam(required = false) String orderByField,
-                        @RequestParam(required = false) String orderByType,
-                        @RequestParam Map<String, Object> param) {
+                          @RequestParam(defaultValue = "100") Integer limit,
+                          @RequestParam(required = false) String orderByField,
+                          @RequestParam(required = false) String orderByType,
+                          @RequestParam Map<String, Object> param) {
         EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
         excludeTrash(param);
         Object o = param.get("orderType");
         if (o != null) {
-            wrapper.in("source", o);
+            String[] split = o.toString().split(",");
+            if (split[0].equals("39")) {
+                wrapper.andNew().like("matnr", "401", SqlLike.RIGHT).or().like("matnr", "402", SqlLike.RIGHT).andNew().in("source", split);
+            } else {
+                wrapper.in("source", split);
+            }
             param.remove("orderType");
         }
         convert(param, wrapper);
@@ -239,9 +245,9 @@
 //                docIds.add(pakin.getDocId());
 //            }
 //        }
-
         return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper));
     }
+
 
     @RequestMapping(value = "/order/detls/pakin")
     @ManagerAuth
@@ -297,10 +303,11 @@
         List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1));
         List<Long> docIds = new ArrayList<>();
         for (DocType pakin : pakins) {
-            if (pakin.getDocId() == 36||pakin.getDocId() == 39) {
+            if (pakin.getDocId() == 36 || pakin.getDocId() == 39) {
                 docIds.add(pakin.getDocId());
             }
         }
+        wrapper.like("matnr", "50", SqlLike.RIGHT);
         wrapper.in("source", docIds);
         return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper));
     }
@@ -346,10 +353,46 @@
                 docIds.add(pakin.getDocId());
             }
         }
+        wrapper.notLike("matnr", "401", SqlLike.RIGHT).notLike("matnr", "402", SqlLike.RIGHT);
         wrapper.in("source", docIds);
         Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper);
         for (OrderDetl record : page.getRecords()) {
             Double sumAnfme = agvLocDetlService.getSumAnfmeDb(record.getMatnr(), record.getThreeCode(), 1);
+            record.setStock(sumAnfme == null ? 0 : sumAnfme);
+        }
+        return R.ok(page);
+    }
+
+
+    @RequestMapping(value = "/order/bcpDb/detls/pakin/page/auth/v2")
+    @ManagerAuth
+    public R bcpDbOrderDetlsV2(@RequestParam(defaultValue = "1") Integer curr,
+                               @RequestParam(defaultValue = "100") Integer limit,
+                               @RequestParam(required = false) String orderByField,
+                               @RequestParam(required = false) String orderByType,
+                               @RequestParam Map<String, Object> param) {
+        EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
+        excludeTrash(param);
+        Object o = param.get("orderType");
+        if (o != null) {
+            String[] split = o.toString().split(",");
+            wrapper.in("source", split);
+            param.remove("orderType");
+        }
+        convert(param, wrapper);
+//        return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class)));
+//        List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1));
+//        List<Long> docIds = new ArrayList<>();
+//        for (DocType pakin : pakins) {
+//            if (pakin.getDocId() == 33) {
+//                docIds.add(pakin.getDocId());
+//            }
+//        }
+        wrapper.like("order_no", "DC", SqlLike.RIGHT);
+        //     wrapper.in("source", docIds);
+        Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper);
+        for (OrderDetl record : page.getRecords()) {
+            Double sumAnfme = agvLocDetlService.getSumAnfmeDb2(record.getMatnr(), record.getThreeCode(), 1);
             record.setStock(sumAnfme == null ? 0 : sumAnfme);
         }
         return R.ok(page);
@@ -905,13 +948,17 @@
     }
 
     @RequestMapping(value = "/order/update/auth")
-    @ManagerAuth
+    @ManagerAuth(memo = "淇敼璁㈠崟鐘舵��")
     public R update(Order order) {
         if (Cools.isEmpty(order) || null == order.getId()) {
             return R.error("鍙傛暟缂哄け");
         }
         order.setUpdateBy(getUserId());
         order.setUpdateTime(new Date());
+        Long settle = order.getSettle();
+        if (settle != null && settle == 6) {
+            order.setMemo(Cools.isEmpty(order.getMemo()) ? "鎵嬪姩瀹岀粨" : order.getMemo() + "鎵嬪姩瀹岀粨");
+        }
         if (!orderService.updateById(order)) {
             throw new CoolException("淇敼璁㈠崟澶辫触");
         }

--
Gitblit v1.9.1