| | |
|---|
| | | 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.DepotConf; |
|---|
| | | 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 DepotConfMapper extends BaseMapper<DepotConf> { |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 自定义关联查询SQL |
|---|
| | | * 关联合同表，根据银行id查询库区配置列表 |
|---|
| | | * @param queryWrapper 查询条件 |
|---|
| | | * @return 库区配置列表 |
|---|
| | | */ |
|---|
| | | @Select("SELECT DISTINCT d.* FROM d_pledge_contract c LEFT JOIN d_depot_conf d ON d.dept_id = c.pledge_dept ${ew.customSqlSegment}") |
|---|
| | | List<DepotConf> selectByBank(@Param("ew") QueryWrapper<DepotConf> queryWrapper); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
