From 4d198cd78684d17c849b0bd7d323894009ca17f5 Mon Sep 17 00:00:00 2001
From: dhz <duhuizhe>
Date: 星期三, 22 六月 2022 09:59:44 +0800
Subject: [PATCH] 备件管理bug 修改
---
src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java b/src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java
index 4dab2f2..a8c4ae3 100644
--- a/src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java
+++ b/src/cn/ksource/web/facade/bpbj/StockTakingFacadeImpl.java
@@ -106,7 +106,7 @@
params.put("state", params.get("state"));
}
- sql.append(" group by a.ID order by a.GMT_CREATE desc");
+ sql.append(" group by a.id,a.ORDER_NAME,a.STATE,a.CREATE_NAME,a.GMT_CREATE,a.ORDER_CODE order by a.GMT_CREATE desc");
return sql.toString();
}
@@ -329,7 +329,7 @@
sql.setLength(0);
sql.append(" select inventory_order_id,sum(inventory_num) inventory_num,sum(book_num) book_num,sum(loss_num) loss_num,sum(overage_num) overage_num " +
- " from spare_part_detail where inventory_order_id=:orderId ");
+ " from spare_part_detail where inventory_order_id=:orderId group by inventory_order_id ");
Map sumInfo = baseDao.queryForMap(sql.toString(), param);
detail.put("inventory_num", ConvertUtil.obj2StrBlank(sumInfo.get("inventory_num")));
detail.put("book_num", ConvertUtil.obj2StrBlank(sumInfo.get("book_num")));
--
Gitblit v1.9.1