From cfe822097221cb29ab54d2a06e0e0eca1b8225ad Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 三月 2021 15:08:06 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 7 +++++--
1 files changed, 5 insertions(+), 2 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 daebb99..5ec2f03 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -68,7 +68,7 @@
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(11, 16));
+ combList.get(i).put("time", String.valueOf(create_time).substring(5, 16));
combList.get(i).put("active", i<3?"active":"");
}
// 鎷ｈ揣鍗�
@@ -109,9 +109,13 @@
"left join \n" +
"(select SUM(anfme) as anfme, node_id from man_loc_detl where 1=1 group by node_id) mld on mp.node_id = mld.node_id\n" +
"where 1=1 \n" +
+ "and mp.safe_qua > mld.anfme\n" +
"order by (mp.safe_qua - mld.anfme) 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 6 CONVERT(decimal, DATEDIFF(second, man_loc_detl.create_time, GETDATE()) / 86400.0, 9) AS stayDays, * from man_loc_detl order by create_time desc");
@@ -119,7 +123,6 @@
retentionList.get(i).put("no", i+1);
Object create_time = combList.get(i).get("create_time");
retentionList.get(i).put("createTime", String.valueOf(create_time).substring(0, 11));
-
}
return R.ok().add(Cools
--
Gitblit v1.9.1