From 6aeb5730b008eda9f9b6797f457f7a257ec5ed14 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期五, 18 六月 2021 15:44:47 +0800
Subject: [PATCH] # pda入库时自动查找推荐货位
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 4 ++--
1 files changed, 2 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 3bc2464..e07d7cb 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -127,10 +127,10 @@
}
}
// 搴撳瓨婊炵暀
- 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");
+ 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 = combList.get(i).get("create_time");
+ Object create_time = retentionList.get(i).get("create_time");
retentionList.get(i).put("createTime", String.valueOf(create_time).substring(0, 11));
}
--
Gitblit v1.9.1