去重

czt

2025-12-31 c9d401e11bea0cc09bf6fbbe5ebf2e21a09c717c

去重

 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);

}

 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);

}