From 43ff5a9617f0d2648bf987335d3e27d36cda6f60 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期五, 08 十二月 2023 13:20:11 +0800
Subject: [PATCH] #

---
 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java            |    1 +
 src/main/java/com/zy/asrs/service/LocDetlService.java          |    2 ++
 src/main/java/com/zy/asrs/controller/OpenController.java       |   10 ++++++++++
 src/main/resources/mapper/LocDetlMapper.xml                    |    4 ++++
 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java |    5 +++++
 src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java    |   11 +++++++++++
 src/main/java/com/zy/asrs/service/OpenService.java             |    1 +
 7 files changed, 34 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/OpenController.java b/src/main/java/com/zy/asrs/controller/OpenController.java
index 3b86a9c..d252ad8 100644
--- a/src/main/java/com/zy/asrs/controller/OpenController.java
+++ b/src/main/java/com/zy/asrs/controller/OpenController.java
@@ -17,6 +17,7 @@
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
+import java.util.Map;
 
 /**
  * Created by vincent on 2022/4/8
@@ -81,6 +82,15 @@
         auth(appkey, null, request);
         return R.ok(openService.inventoryQuantity());
     }
+    /*
+     * 閫熻吘鏁板瓧瀛敓璋冪敤鎺ュ彛
+     * */
+    @PostMapping("/digital/ownerAll/number/quantity")
+    public synchronized R ownerAllNumber(@RequestHeader(required = false) String appkey,
+                                           HttpServletRequest request) {
+        auth(appkey, null, request);
+        return openService.ownerAllNumber();
+    }
 
 
     /**
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index 3ecf455..a31b8bb 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -102,4 +102,5 @@
     String selectLocNoF(String locNo);
 
     List<LocDetl> queryStock3(String matnr, String batch, int owner);
+    List<LocDetlAll> selectOwnerAllAnfme();
 }
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index 597adbf..4d16f63 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -80,4 +80,6 @@
     int selectAllPymentcount(LocDetlDTO locDetlDTO);
 
     String selectLocNoF(String locNo);
+
+    List<LocDetlAll> selectOwnerAllAnfme();
 }
diff --git a/src/main/java/com/zy/asrs/service/OpenService.java b/src/main/java/com/zy/asrs/service/OpenService.java
index dba0277..ace06ba 100644
--- a/src/main/java/com/zy/asrs/service/OpenService.java
+++ b/src/main/java/com/zy/asrs/service/OpenService.java
@@ -47,4 +47,5 @@
 
     R getInOutDetl();
     DigitalTwin inventoryQuantity();
+    R ownerAllNumber();
 }
diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
index 98a75ba..7b1bbb0 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
@@ -201,4 +201,9 @@
     public String selectLocNoF(String locNo) {
         return this.baseMapper.selectLocNoF(locNo);
     }
+
+    @Override
+    public List<LocDetlAll> selectOwnerAllAnfme() {
+        return this.baseMapper.selectOwnerAllAnfme();
+    }
 }
diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
index 0d8cd22..76b6e81 100644
--- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
@@ -1,6 +1,7 @@
 package com.zy.asrs.service.impl;
 
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
+import com.baomidou.mybatisplus.plugins.Page;
 import com.core.common.Cools;
 import com.core.common.DateUtils;
 import com.core.common.R;
@@ -9,6 +10,7 @@
 import com.zy.asrs.entity.*;
 import com.zy.asrs.entity.param.*;
 import com.zy.asrs.entity.result.InOutCountDto;
+import com.zy.asrs.entity.result.LocDetlAll;
 import com.zy.asrs.entity.result.StockVo;
 import com.zy.asrs.mapper.ReportQueryMapper;
 import com.zy.asrs.mapper.TagMapper;
@@ -540,4 +542,13 @@
         return digitalTwin;
     }
 
+    /*
+     * 閫熻吘鏁板瓧瀛敓璋冪敤鎺ュ彛
+     * */
+    @Override
+    public synchronized R ownerAllNumber() {
+        List<LocDetlAll> locDetlAlls = locDetlService.selectOwnerAllAnfme();
+        return R.ok(locDetlAlls);
+    }
+
 }
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index aaba2f7..eda904e 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -722,5 +722,9 @@
         desc
     </select>
 
+    <select id="selectOwnerAllAnfme" resultType="com.zy.asrs.entity.result.LocDetlAll">
+        select SUM(anfme) as anfme,owner from asr_loc_detl_all GROUP BY owner ORDER BY anfme DESC
+    </select>
+
 
 </mapper>

--
Gitblit v1.9.1