From 0d59d664b3b81e9264df6ad513d06b1b2c84c931 Mon Sep 17 00:00:00 2001
From: sgj <1442489573@qq.com>
Date: 星期五, 27 三月 2026 11:43:34 +0800
Subject: [PATCH] 大屏首页储量数量展示，仅展示散粮；抓拍跟踪图片展示业务逻辑调整
---
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