From 1d3bb76d19961a6e165a7e234ccf17b5eb3a84d9 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期二, 01 六月 2021 13:02:57 +0800
Subject: [PATCH] 宏挺补仓功能（未完
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 111 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 111 insertions(+), 0 deletions(-)
diff --git a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
index 01f1ec8..e07d7cb 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -7,7 +7,11 @@
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import zy.cloud.wms.common.web.BaseController;
+import zy.cloud.wms.manager.entity.WrkSts;
+import zy.cloud.wms.manager.service.WrkStsService;
+import java.util.List;
+import java.util.Map;
import java.util.Optional;
/**
@@ -19,15 +23,122 @@
@Autowired
private JdbcTemplate jdbcTemplate;
+ @Autowired
+ private WrkStsService wrkStsService;
+ /**
+ * 褰撳ぉ鏁版嵁锛歴elect * from tableName where datediff(day, 瀛楁鍚�,getdate())=0
+ * 鏈懆鏁版嵁锛歴elect * from tableName where datediff(week, 瀛楁鍚�,getdate())=0
+ * 鏈湀锛歴elect * from tableName where datediff(month, 瀛楁鍚�,getdate())=0
+ * 鏈搴︼細鍐卻elect * from tableName where datediff(quarter, 瀛楁鍚�,getdate())=0
+ * 鏈勾锛歴elect * from tableName where datediff(year, 瀛楁鍚�,getdate())=0
+ */
@RequestMapping(value = "/header/auth")
public R header() {
+ Integer combQtyDay = jdbcTemplate.queryForObject("select count(*) from man_comb where datediff(day, create_time, getdate())=0", Integer.class);
+ Integer combQty = jdbcTemplate.queryForObject("select count(*) from man_comb", Integer.class);
+
+ Integer matQty = jdbcTemplate.queryForObject("select count(*) from man_mat", Integer.class);
+ Integer nodeQty = jdbcTemplate.queryForObject("select count(*) from man_node where type = 3", Integer.class);
+
+ Integer pakoutQty = jdbcTemplate.queryForObject("select count(*) from man_pakout", Integer.class);
+ Integer pakoutQtyMonth = jdbcTemplate.queryForObject("select count(*) from man_pakout where datediff(month, create_time, getdate())=0", Integer.class);
+
Integer usersQty = jdbcTemplate.queryForObject("select count(*) from sys_user", Integer.class);
Integer deptQty = jdbcTemplate.queryForObject("select count(*) from sys_dept", Integer.class);
+ Integer optQty = jdbcTemplate.queryForObject("select count(*) from sys_operate_log", Integer.class);
return R.ok().add(Cools
+ .add("combQtyDay", Optional.ofNullable(combQtyDay).orElse(0)) // 缁勬墭鏁伴噺(褰撳ぉ锛�
+ .add("combQty", Optional.ofNullable(combQty).orElse(0)) // 缁勬墭鏁伴噺
+
+ .add("matQty", Optional.ofNullable(matQty).orElse(0)) // 鐗╂枡鏁伴噺
+ .add("nodeQty", Optional.ofNullable(nodeQty).orElse(0)) // 璐т綅鏁伴噺
+
+ .add("pakoutQty", Optional.ofNullable(pakoutQty).orElse(0)) // 鎬诲嚭搴撳崟鏁�
+ .add("pakoutQtyMonth", Optional.ofNullable(pakoutQtyMonth).orElse(0)) // 鍑哄簱鍗曟暟锛堝綋鏈�)
+
.add("usersQty", Optional.ofNullable(usersQty).orElse(0)) // 鐢ㄦ埛鏁伴噺
.add("deptQty", Optional.ofNullable(deptQty).orElse(0)) // 閮ㄩ棬鏁伴噺
+ .add("optQty", Optional.ofNullable(optQty).orElse(0)) // 鎿嶄綔娆℃暟
+ );
+ }
+
+ @RequestMapping(value = "/body/auth")
+ public R body() {
+ // 缁勬墭
+ List<Map<String, Object>> combList = jdbcTemplate.queryForList("select top 10 * from man_comb where 1=1 order by create_time desc");
+ for (int i=0;i<combList.size();i++) {
+ Object create_time = combList.get(i).get("create_time");
+ combList.get(i).put("time", String.valueOf(create_time).substring(5, 16));
+ combList.get(i).put("active", String.valueOf(combList.get(i).get("io_status")).equals("4")?"":"active");
+ }
+ // 鎷ｈ揣鍗�
+ List<Map<String, Object>> pakoutList = jdbcTemplate.queryForList("select top 5 * from man_pakout where 1=1 order by create_time desc");
+ for (int i=0;i<pakoutList.size();i++) {
+ pakoutList.get(i).put("no", i+1);
+ String wrk_sts = String.valueOf(pakoutList.get(i).get("wrk_sts"));
+ switch (wrk_sts) {
+ case "1":
+ pakoutList.get(i).put("style", "text-warning");
+ break;
+ case "2":
+ pakoutList.get(i).put("style", "text-danger");
+ break;
+ case "3":
+ pakoutList.get(i).put("style", "text-success");
+ break;
+ default:
+ pakoutList.get(i).put("style", "text-info");
+ break;
+ }
+ WrkSts wrkSts = wrkStsService.selectById(Integer.parseInt(wrk_sts));
+ if (null != wrkSts) {
+ pakoutList.get(i).put("wrkStsName", wrkSts.getStsName());
+ }
+ }
+ // 瀹夊叏搴撳瓨璀﹀憡
+ List<Map<String, Object>> safeQuaList = jdbcTemplate.queryForList("select\n" +
+ "top 5\n" +
+ "mp.node_id,\n" +
+ "mp.node_name,\n" +
+ "mp.matnr,\n" +
+ "mp.maktx,\n" +
+ "mp.safe_qua,\n" +
+ "ISNULL(ls.amount, 0) as amount,\n" +
+ "(mp.safe_qua - isnull(ls.amount, 0)) as dValue\n" +
+ "from man_prior mp\n" +
+ "left join\n" +
+ "(\n" +
+ " select\n" +
+ " node_id,\n" +
+ " matnr,\n" +
+ " sum(anfme) as amount\n" +
+ " from man_loc_detl\n" +
+ " group by node_id, matnr\n" +
+ ") as ls on ls.node_id = mp.node_id and ls.matnr = mp.matnr\n" +
+ "where 1=1\n" +
+ "and mp.safe_qua > ls.amount or ls.amount is null\n" +
+ "order by (mp.safe_qua - isnull(ls.amount, 0)) desc");
+ for (int i=0;i<safeQuaList.size();i++) {
+ safeQuaList.get(i).put("no", i+1);
+ if (Cools.isEmpty(safeQuaList.get(i).get("dValue"))){
+ safeQuaList.get(i).put("dValue", safeQuaList.get(i).get("safe_qua"));
+ }
+ }
+ // 搴撳瓨婊炵暀
+ List<Map<String, Object>> retentionList = jdbcTemplate.queryForList("select top 7 CONVERT(decimal, DATEDIFF(second, man_loc_detl.create_time, GETDATE()) / 86400.0, 9) AS stayDays, * from man_loc_detl order by create_time desc");
+ for (int i=0;i<retentionList.size();i++) {
+ retentionList.get(i).put("no", i+1);
+ Object create_time = retentionList.get(i).get("create_time");
+ retentionList.get(i).put("createTime", String.valueOf(create_time).substring(0, 11));
+ }
+
+ return R.ok().add(Cools
+ .add("combList", combList) // 缁勬墭鏈�鏂板姩鎬�
+ .add("pakoutList", pakoutList) // 鏈�鏂版嫞璐у崟
+ .add("safeQuaList", safeQuaList) // 瀹夊叏搴撳瓨璀﹀憡
+ .add("retentionList", retentionList) // 搴撳瓨婊炵暀鏁版嵁
);
}
--
Gitblit v1.9.1