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);


}