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