From 8be136c5e451b623cec21e806bd30e6e2698587d Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期一, 17 二月 2025 16:42:40 +0800
Subject: [PATCH] 新增捡货单excel导出,销售用

---
 src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java |   44 +++++++++++++++++++++++++++++++++-----------
 1 files changed, 33 insertions(+), 11 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
index f90e61a..9eb8ebe 100644
--- a/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/PlaServiceImpl.java
@@ -5,6 +5,7 @@
 import com.baomidou.mybatisplus.plugins.Page;
 import com.baomidou.mybatisplus.service.impl.ServiceImpl;
 import com.core.common.Cools;
+import com.core.common.DateUtils;
 import com.core.exception.CoolException;
 import com.zy.asrs.entity.OrderDetl;
 import com.zy.asrs.entity.Pla;
@@ -28,8 +29,8 @@
     @Autowired
     private PlaQtyService plaQtyService;
 
-    public Pla selectByBatchAndPackageNo(String batch, Integer packageNo) {
-        return this.selectOne(new EntityWrapper<Pla>().eq("batch",batch).eq("package_no",packageNo));
+    public Pla selectByBatchAndPackageNo(String batch, Integer packageNo, String brand) {
+        return this.selectOne(new EntityWrapper<Pla>().eq("batch",batch).eq("package_no",packageNo).eq("brand",brand));
     }
 
     @Override
@@ -92,13 +93,15 @@
     }
 
     //閫�鍥�
+    @Transactional
     public void returned(List<PlaQty> plaQties, User user) {
         plaQties.forEach(plaQty -> {
             PlaQty plaQtyOut = plaQtyService.selectById(plaQty.getId());
-            if(Cools.isEmpty(plaQtyOut.getReturned())){
+            if(Cools.isEmpty(plaQtyOut.getReturned()) || plaQtyOut.getReturned() == 0){
                 plaQtyOut.setReturned(plaQty.getOrderWeight());
             }else {
-                plaQtyOut.setReturned(plaQty.getOrderWeight()+plaQtyOut.getReturned());
+                throw new CoolException("璇ュ寘鐗╂枡宸查��鍥�");
+                //plaQtyOut.setReturned(plaQty.getOrderWeight()+plaQtyOut.getReturned());
             }
             plaQtyService.updateById(plaQtyOut);
 
@@ -109,6 +112,7 @@
             plaQtyReturned.setLocNo(plaQtyOut.getLocNo());
             plaQtyReturned.setOrderNo(plaQtyOut.getOrderNo());
             plaQtyReturned.setPakoutTime(Utils.getDateStr(new Date()));
+            plaQtyReturned.setBrand(plaQty.getBrand());
             plaQtyReturned.setOrderWeight(plaQty.getOrderWeight());
             plaQtyReturned.setTransfer("閫�鍥炲叆搴�");
             plaQtyReturned.setHandlerBy(user.getUsername());
@@ -117,16 +121,23 @@
             plaQtyService.insert(plaQtyReturned);
 
             //鐩存帴鏇存柊pla鐨勫簱瀛�
-            Pla pla = this.selectByBatchAndPackageNo(plaQty.getBatch(), plaQty.getPackageNo());
+            Pla pla = this.selectByBatchAndPackageNo(plaQty.getBatch(), plaQty.getPackageNo(),plaQty.getBrand());
             //pla.setStatus(GlobleParameter.PLA_STATUS_0);
             pla.setModifyTime(new Date());
+
+            // 閫�璐т汉 modify_user锛岄��璐у娉� create_user锛岄��璐ф爣璇� transfer
+            pla.setModifyUser(user.getUsername());
+            pla.setCreateUser(plaQty.getMemo());
+            pla.setTransfer("閫�璐�");
+            pla.setStash(""); // 搴撳尯
+            pla.setLocNo(""); // 搴撲綅
 
             pla.setWeightAnfme(pla.getWeightAnfme() + plaQty.getOrderWeight());
             pla.setStatus(GlobleParameter.PLA_STATUS_1);
             this.updateById(pla);
 
-            SaasUtils.insertLog(0,pla.getLocNo(),pla.getBrand(),plaQty.getOrderWeight(),user.getUsername(),
-                    null,pla.getBatch(),pla.getPackageNo(),pla.getOwner(),pla.getWorkshop());
+            SaasUtils.insertLog(4,pla.getLocNo(),pla.getBrand(),plaQty.getOrderWeight(),user.getUsername(),
+                    null,pla.getBatch(),pla.getPackageNo(),pla.getOwner(),pla.getWorkshop(),null);
 
         });
     }
@@ -154,11 +165,22 @@
     public Page<Pla> getStockStatisAll(Page<Pla> page) {
 
         List<Pla> plaList;
-        if(Cools.isEmpty(page.getCondition().get("brand"))){
-            plaList=baseMapper.getStockStatisAll();
-        }else {
-            plaList = baseMapper.getStockStatisAllByBrand(page.getCondition().get("brand").toString());
+        Date stime = null;
+        Date etime = null;
+        Object create_time = page.getCondition().get("create_time");
+        Object brand = page.getCondition().get("brand");
+        Object status = page.getCondition().get("status");
+        String type = (String) page.getCondition().get("type");
+        String workshop = (String) page.getCondition().get("workshop");
+        String transfer = (String) page.getCondition().get("transfer");
+
+        String createTime = create_time == null ? null : create_time.toString();
+        if(!Cools.isEmpty(createTime)){
+            String[] dates = createTime.split(" - ");
+            stime = DateUtils.convert(dates[0]);
+            etime = DateUtils.convert(dates[1]);
         }
+        plaList=baseMapper.getStockStatisAll(brand == null ? null:brand.toString(), status == null ? null:status.toString(),  stime,etime, type, workshop, transfer);
 
         double weightSum = plaList.stream().mapToDouble(Pla::getWeight).sum();
 

--
Gitblit v1.9.1