From 1cb134a269b9e7a70481a875d61e288be47ca99f Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期三, 14 四月 2021 08:51:30 +0800 Subject: [PATCH] # --- src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 2 +- 1 files changed, 1 insertions(+), 1 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..4d1e4d2 100644 --- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java +++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java @@ -127,7 +127,7 @@ } } // 搴撳瓨婊炵暀 - 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"); -- Gitblit v1.9.1