From 8e13b1cf8fd11809837fa2c958d608a1c38732db Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 三月 2021 11:26:32 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 20 +++++++++++++++++++-
1 files changed, 19 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 84d2c52..ac158ae 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -95,11 +95,29 @@
pakoutList.get(i).put("wrkStsName", wrkSts.getStsName());
}
}
-
+ // 瀹夊叏搴撳瓨璀﹀憡
+ List<Map<String, Object>> safeQuaList = jdbcTemplate.queryForList("select \n" +
+ "top 10\n" +
+ "mp.node_id,\n" +
+ "mp.node_name,\n" +
+ "mp.matnr,\n" +
+ "mp.maktx,\n" +
+ "mp.safe_qua,\n" +
+ "mld.anfme,\n" +
+ "(mp.safe_qua - mld.anfme) as dValue\n" +
+ "from man_prior mp\n" +
+ "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" +
+ "order by (mp.safe_qua - mld.anfme) desc");
+ for (int i=0;i<safeQuaList.size();i++) {
+ safeQuaList.get(i).put("no", i+1);
+ }
return R.ok().add(Cools
.add("combList", combList) // 缁勬墭鏈�鏂板姩鎬�
.add("pakoutList", pakoutList) // 鏈�鏂版嫞璐у崟
+ .add("safeQuaList", safeQuaList) // 瀹夊叏搴撳瓨璀﹀憡
);
}
--
Gitblit v1.9.1