From 9c12e20237eb56bf2b53f3d751ba618b56954fad Mon Sep 17 00:00:00 2001
From: 石广澎 <shiguangpeng@163.com>
Date: 星期六, 02 十二月 2023 17:44:58 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java
index 67a3c85..349d435 100644
--- a/consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/LWhGoodsStatisticsServiceImpl.java
@@ -42,8 +42,9 @@
         HashMap<String, Object> paramts = new HashMap<>();
         //鏈烘瀯
         if (param.getAgencyId() != null) {
-            sqlCangKuWhere.append(" AND left(tenant.id, length(:lengthAgencyId)) = :agencyId");
-            paramts.put("lengthAgencyId", param.getAgencyId());
+//            sqlCangKuWhere.append(" AND left(tenant.id, length(:lengthAgencyId)) = :agencyId");
+            sqlCangKuWhere.append(" AND tenant.id = :agencyId");
+//            paramts.put("lengthAgencyId", param.getAgencyId());
             paramts.put("agencyId", param.getAgencyId());
         }
         // 閮ㄩ棬

--
Gitblit v1.9.1