From 930d29f39d115fe76c305af4320c2acbcb30c445 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期四, 12 六月 2025 10:37:37 +0800
Subject: [PATCH] 优化SQL
---
igds-inout/src/main/java/com/ld/igds/inout/service/JInoutReportService.java | 24 ++++++++++++------------
1 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/igds-inout/src/main/java/com/ld/igds/inout/service/JInoutReportService.java b/igds-inout/src/main/java/com/ld/igds/inout/service/JInoutReportService.java
index 71102a3..85235bd 100644
--- a/igds-inout/src/main/java/com/ld/igds/inout/service/JInoutReportService.java
+++ b/igds-inout/src/main/java/com/ld/igds/inout/service/JInoutReportService.java
@@ -142,12 +142,12 @@
sql = new StringBuffer();
args = new HashMap<>();
sql.append("SELECT ");
- sql.append("DEPOT_ID_, ");
- sql.append("SETTLE_WEIGHT_, ");
- sql.append("TYPE_, ");
- sql.append("CUR_STORAGE_, ");
- sql.append("FOOD_VARIETY_, ");
- sql.append("COMPLETE_TIME_ ");
+ sql.append("a.DEPOT_ID_, ");
+ sql.append("a.SETTLE_WEIGHT_, ");
+ sql.append("a.TYPE_, ");
+ sql.append("a.CUR_STORAGE_, ");
+ sql.append("a.FOOD_VARIETY_, ");
+ sql.append("a.COMPLETE_TIME_ ");
sql.append("FROM ");
sql.append("( ");
sql.append("SELECT ");
@@ -192,12 +192,12 @@
sql = new StringBuffer();
args = new HashMap<>();
sql.append("SELECT ");
- sql.append("DEPOT_ID_, ");
- sql.append("SETTLE_WEIGHT_, ");
- sql.append("TYPE_, ");
- sql.append("CUR_STORAGE_, ");
- sql.append("FOOD_VARIETY_, ");
- sql.append("COMPLETE_TIME_ ");
+ sql.append("a.DEPOT_ID_, ");
+ sql.append("a.SETTLE_WEIGHT_, ");
+ sql.append("a.TYPE_, ");
+ sql.append("a.CUR_STORAGE_, ");
+ sql.append("a.FOOD_VARIETY_, ");
+ sql.append("a.COMPLETE_TIME_ ");
sql.append("FROM ");
sql.append("( ");
sql.append("SELECT ");
--
Gitblit v1.9.3