package com.skua.modules.inspection.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.inspection.entity.InspectionTaskFillContent;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 巡检任务-填报内容
 */
public interface InspectionTaskFillContentMapper extends BaseMapper<InspectionTaskFillContent> {

    @Select("SELECT\n" +
            "\titpfg.equip_info_id\n" +
            "FROM\n" +
            "\tinspection_task_fill_content isfc\n" +
            "\tINNER JOIN inspection_task_point_fill_group itpfg \n" +
            "\t\tON isfc.inspection_task_id = itpfg.inspection_task_id\n" +
            "\t\tand isfc.inspection_point_fill_group_id = itpfg.inspection_point_fill_group_id\n" +
            "\t\tleft join inspection_task it on isfc.inspection_task_id = it.id ${ew.customSqlSegment}")
    List<Map<String, Object>> getList(@Param(Constants.WRAPPER) QueryWrapper<InspectionTaskFillContent> inspectionTaskFillContentQueryWrapper);
}