From c9d401e11bea0cc09bf6fbbe5ebf2e21a09c717c Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期三, 31 十二月 2025 15:23:21 +0800
Subject: [PATCH] 去重
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreCompanyMapper.java | 2 +-
fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreCompanyMapper.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreCompanyMapper.java
index 7363142..fd33841 100644
--- a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreCompanyMapper.java
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreCompanyMapper.java
@@ -24,7 +24,7 @@
* @param queryWrapper
* @return
*/
- @Select("SELECT d.* FROM d_pledge_contract c LEFT JOIN d_company d ON d.id = c.pledge_company ${ew.customSqlSegment}")
+ @Select("SELECT DISTINCT d.* FROM d_pledge_contract c LEFT JOIN d_company d ON d.id = c.pledge_company ${ew.customSqlSegment}")
List<Company> selectCompanyByBankId(@Param("ew") QueryWrapper<PledgeContract> queryWrapper);
}
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
index f536ee7..66ae630 100644
--- a/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java
@@ -23,7 +23,7 @@
* @param queryWrapper
* @return
*/
- @Select("SELECT d.* FROM d_pledge_contract c LEFT JOIN d_dept d ON d.id = c.pledge_dept ${ew.customSqlSegment}")
+ @Select("SELECT DISTINCT d.* FROM d_pledge_contract c LEFT JOIN d_dept d ON d.id = c.pledge_dept ${ew.customSqlSegment}")
List<Dept> selectDeptByBankId(@Param("ew") QueryWrapper<PledgeContract> queryWrapper);
}
--
Gitblit v1.9.3