| | |
|---|
| | | 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 |
|---|
| | |
|---|
| | | @Mapper |
|---|
| | | public interface CoreDeptMapper extends BaseMapper<Dept> { |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 自定义关联查询SQL |
|---|
| | | * 关联合同表，根据银行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); |
|---|
| | | |
|---|
| | | } |
|---|
