From cb9c7650145abce31fab4564ad6e50754ee93242 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期五, 05 三月 2021 15:16:40 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 25 +++++++++++++++++++++++++
1 files changed, 25 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..c0898c1 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -20,12 +20,37 @@
@Autowired
private JdbcTemplate jdbcTemplate;
+ /**
+ * 褰撳ぉ鏁版嵁锛歴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);
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)) // 閮ㄩ棬鏁伴噺
);
--
Gitblit v1.9.1