From f543f2b2df318ce42111fbe9727a1fb7c7a588d6 Mon Sep 17 00:00:00 2001
From: lsh <lsh@163.com>
Date: 星期五, 26 十二月 2025 17:43:27 +0800
Subject: [PATCH] #getArmType$
---
src/main/java/com/zy/asrs/entity/ViewStockUseBeanDigitalTwin.java | 20 ++++++++++
src/main/java/com/zy/asrs/controller/OpenController.java | 12 ++++++
src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 32 ++++++++++++++++
src/main/java/com/zy/asrs/service/OpenService.java | 6 +++
4 files changed, 70 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 8b0604a..10e46eb 100644
--- a/src/main/java/com/zy/asrs/controller/OpenController.java
+++ b/src/main/java/com/zy/asrs/controller/OpenController.java
@@ -4,6 +4,7 @@
import com.core.annotations.AppAuth;
import com.core.common.*;
import com.core.exception.CoolException;
+import com.zy.asrs.entity.ViewStockUseBeanDigitalTwin;
import com.zy.asrs.entity.param.*;
import com.zy.asrs.service.OpenService;
import com.zy.common.model.DetlDto;
@@ -216,4 +217,15 @@
System.out.println(JSON.toJSONString(param1));
}
+
+ /**
+ * 鏁版嵁鎬昏
+ */
+ @RequestMapping("/digitalTwin/overview")
+ public R digitalTwinOverview(@RequestHeader(required = false) String appkey,
+ HttpServletRequest request) {
+ auth(appkey, null, request);
+ return R.ok().add(openService.digitalTwinOverview());
+ }
+
}
diff --git a/src/main/java/com/zy/asrs/entity/ViewStockUseBeanDigitalTwin.java b/src/main/java/com/zy/asrs/entity/ViewStockUseBeanDigitalTwin.java
new file mode 100644
index 0000000..cc67192
--- /dev/null
+++ b/src/main/java/com/zy/asrs/entity/ViewStockUseBeanDigitalTwin.java
@@ -0,0 +1,20 @@
+package com.zy.asrs.entity;
+
+import lombok.Data;
+
+/**
+ * 搴撲綅浣跨敤鐜囪鍥惧疄浣撶被
+ * @author admin
+ * @date 2018骞�11鏈�23鏃�
+ */
+@Data
+public class ViewStockUseBeanDigitalTwin {
+ private Long totalLoc; //搴撲綅鎬绘暟
+ private Long useLoc; //宸茬敤搴撲綅
+ private Long idleLoc; //鍓╀綑搴撲綅
+ private Long todayOutbound; //浠婃棩鍑哄簱
+ private Long todayWarehousing; //浠婃棩鍏ュ簱
+ private Long remainingStock; //鍓╀綑搴撳瓨
+ private String nowData; //鍓╀綑搴撳瓨
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/zy/asrs/service/OpenService.java b/src/main/java/com/zy/asrs/service/OpenService.java
index afd90b1..c794e02 100644
--- a/src/main/java/com/zy/asrs/service/OpenService.java
+++ b/src/main/java/com/zy/asrs/service/OpenService.java
@@ -1,5 +1,6 @@
package com.zy.asrs.service;
+import com.zy.asrs.entity.ViewStockUseBeanDigitalTwin;
import com.zy.asrs.entity.param.*;
import com.zy.asrs.entity.result.OpenOrderCompeteResult;
import com.zy.asrs.entity.result.StockVo;
@@ -43,4 +44,9 @@
* @param param
*/
void syncMat(MatSyncParam param);
+
+ /**
+ * 搴撳瓨缁熻
+ */
+ ViewStockUseBeanDigitalTwin digitalTwinOverview();
}
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 29dfc78..ddd2c06 100644
--- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java
@@ -9,6 +9,7 @@
import com.zy.asrs.entity.param.*;
import com.zy.asrs.entity.result.OpenOrderCompeteResult;
import com.zy.asrs.entity.result.StockVo;
+import com.zy.asrs.mapper.ReportQueryMapper;
import com.zy.asrs.mapper.TagMapper;
import com.zy.asrs.service.*;
import com.zy.asrs.utils.MatUtils;
@@ -20,6 +21,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -49,6 +51,10 @@
private TagService tagService;
@Autowired
private TagMapper tagMapper;
+ @Autowired
+ private LocMastServiceImpl locMastService;
+ @Autowired
+ private ReportQueryMapper reportQueryMapper;
@Override
@Transactional
@@ -589,4 +595,30 @@
}
+ @Override
+ @Transactional
+ public ViewStockUseBeanDigitalTwin digitalTwinOverview() {
+ ViewStockUseBeanDigitalTwin viewStockUseBeanDigitalTwin = new ViewStockUseBeanDigitalTwin();
+ int selectCountLocDetl = locDetlService.selectCount(new EntityWrapper<LocDetl>());
+ viewStockUseBeanDigitalTwin.setRemainingStock(Integer.toUnsignedLong(selectCountLocDetl));
+ int selectCountLocMast = locMastService.selectCount(new EntityWrapper<LocMast>());
+ viewStockUseBeanDigitalTwin.setTotalLoc(Integer.toUnsignedLong(selectCountLocMast));
+ int selectCountLocMastNEO = locMastService.selectCount(new EntityWrapper<LocMast>().ne("loc_sts","O").ne("loc_sts","X"));
+ viewStockUseBeanDigitalTwin.setUseLoc(Integer.toUnsignedLong(selectCountLocMastNEO));
+ int selectCountLocMastO = locMastService.selectCount(new EntityWrapper<LocMast>().eq("loc_sts","O"));
+ viewStockUseBeanDigitalTwin.setIdleLoc(Integer.toUnsignedLong(selectCountLocMastO));
+ List<ViewInOutBean> list = reportQueryMapper.getViewInOutAll(new ViewInOutBean());
+ Date date = new Date();
+ String format = new SimpleDateFormat("yyyy-MM-dd").format(date);
+ viewStockUseBeanDigitalTwin.setNowData(format);
+ for (ViewInOutBean view : list) {
+ if (view.getYmd().equals(format)) {
+ viewStockUseBeanDigitalTwin.setTodayOutbound(view.getRet_qty());
+ viewStockUseBeanDigitalTwin.setTodayWarehousing(view.getSto_qty());
+ break;
+ }
+ }
+ return viewStockUseBeanDigitalTwin;
+ }
+
}
--
Gitblit v1.9.1