From 9ec6ec4d545607b0e54b3e66d27911ecc67ea1f7 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 三月 2021 14:13:56 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 11 +++++++++++
1 files changed, 11 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 ac158ae..04d1e6e 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -112,12 +112,23 @@
"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");
+ for (int i=0;i<retentionList.size();i++) {
+ 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
.add("combList", combList) // 缁勬墭鏈�鏂板姩鎬�
.add("pakoutList", pakoutList) // 鏈�鏂版嫞璐у崟
.add("safeQuaList", safeQuaList) // 瀹夊叏搴撳瓨璀﹀憡
+ .add("retentionList", retentionList) // 搴撳瓨婊炵暀鏁版嵁
);
}
--
Gitblit v1.9.1