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
|
* @Author CZT
|
* @Date 2025/11/28 10:48
|
*/
|
@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);
|
|
|
}
|
