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 | 16 +++++++++++++++-
1 files changed, 15 insertions(+), 1 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 0b6d531..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
@@ -1,9 +1,14 @@
package com.fzzy.igds.mapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.fzzy.igds.domain.Camera;
import com.fzzy.igds.domain.Company;
+import com.fzzy.igds.domain.PledgeContract;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
/**
* @Description
@@ -13,4 +18,13 @@
@Mapper
public interface CoreCompanyMapper extends BaseMapper<Company> {
+ /**
+ * 鑷畾涔夊叧鑱旀煡璇QL
+ * 鍏宠仈鍚堝悓琛紝鏍规嵁閾惰id鏌ヨ鍏徃鍒楄〃
+ * @param queryWrapper
+ * @return
+ */
+ @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);
+
}
--
Gitblit v1.9.3