From 5ffc5c22b0833d8f569e99eb775d08ca28676c7d Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期一, 19 一月 2026 14:37:16 +0800
Subject: [PATCH] 细节调整2
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/mapper/CoreDeptMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
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 b089ea2..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
@@ -1,8 +1,13 @@
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.Dept;
+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
@@ -12,4 +17,13 @@
@Mapper
public interface CoreDeptMapper extends BaseMapper<Dept> {
+ /**
+ * 鑷畾涔夊叧鑱旀煡璇QL
+ * 鍏宠仈鍚堝悓琛紝鏍规嵁閾惰id鏌ヨ搴撳尯鍒楄〃
+ * @param queryWrapper
+ * @return
+ */
+ @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