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