From d44598d72c02bc05227b64749ea017c1eb69c6a5 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 三月 2021 14:46:46 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java | 1 +
1 files changed, 1 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 1fd5337..5ec2f03 100644
--- a/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
+++ b/src/main/java/zy/cloud/wms/manager/controller/ConsoleController.java
@@ -109,6 +109,7 @@
"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);
--
Gitblit v1.9.1