java-insagent-pc/src/main/java/com/ydtech/modules/fnc/dao/InsPlyMainMapper.java

package com.ydtech.modules.fnc.dao;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydtech.modules.fnc.entity.InsPlyMain;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydtech.modules.fnc.entity.InsPlySettle;
import com.ydtech.modules.fnc.vo.InsPlySettleVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author gws
 * @since 2024-01-23
 */
@Mapper
public interface InsPlyMainMapper extends BaseMapper<InsPlyMain> {

    @Select("select (select b.`name` from sys_dept b where a.dept_id=b.id) deptName,c.`name` companyName, (select d.`name` from sys_user d where a.user_id=d.id ) userName,a.* from ins_ply_main a " +
            "left join esm_ins_company c on a.company_id=c.id  " +
            " ${ew.customSqlSegment}")
    List<InsPlyMain> selectByCondition( @Param(Constants.WRAPPER) LambdaQueryWrapper<InsPlyMain> wrapper);

}