From 83b2c23efd1c1ba3d995193b3240f3d868f4d592 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期二, 22 八月 2023 16:28:34 +0800
Subject: [PATCH] AGV出入库作业 库存汇总页面 库存规则 分析页加上AGV数据 AGV库存明细统计 AGV库位地图

---
 src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java |   48 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 48 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
index 736601e..597f97d 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
 import com.baomidou.mybatisplus.mapper.Wrapper;
+import com.baomidou.mybatisplus.plugins.Page;
 import com.baomidou.mybatisplus.service.impl.ServiceImpl;
 import com.core.common.Cools;
 import com.zy.asrs.entity.AgvLocDetl;
@@ -80,6 +81,53 @@
 
     }
 
+    /*
+    鏇存柊搴撳瓨鏄庣粏
+     */
+    public void updateStock(String sourceLoc, String targetLoc) {
+        this.baseMapper.updateStock(sourceLoc,targetLoc);
+    }
+
+    public Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page) {
+        page.setRecords(baseMapper.getStockStatis(page.getCondition()));
+        page.setTotal(baseMapper.getStockStatisCount(page.getCondition()));
+        return page;
+    }
+
+    /*
+    鑾峰彇搴撳瓨鎬绘暟
+     */
+    public Integer sum() {
+        return this.baseMapper.sum();
+    }
+
+    public List<AgvLocDetl> getStockStatisExcel(){
+        return this.baseMapper.getStockStatisExcel();
+    }
+
+    public List<AgvLocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo) {
+        if (Cools.isEmpty(orderNo) && Cools.isEmpty(matnr) && Cools.isEmpty(maktx) && Cools.isEmpty(specs) && Cools.isEmpty(locNo)) {
+            return new ArrayList<AgvLocDetl>();
+        }
+        EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>();
+        if(Cools.isEmpty(orderNo)){
+            wrapper.like("order_no",orderNo);
+        }
+        if(Cools.isEmpty(matnr)){
+            wrapper.like("matnr",matnr);
+        }
+        if(Cools.isEmpty(maktx)){
+            wrapper.like("maktx",maktx);
+        }
+        if(Cools.isEmpty(specs)){
+            wrapper.like("specs",specs);
+        }
+        if(Cools.isEmpty()){
+            wrapper.like("loc_no",locNo);
+        }
+        return this.selectList(wrapper);
+    }
+
     private List<String> queryAgvStaNosByFloor(int floor){
         List<String> agvStaNos = new ArrayList<>();
         if(floor == 1){

--
Gitblit v1.9.1