package org.jeecg.modules.eam.mapper;

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

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.SpecialtyInspectionPlan;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.eam.model.DepartVo;

/**
 * @Description: mom_eam_specialty_inspection_plan
 * @Author: jeecg-boot
 * @Date:   2023-04-19
 * @Version: V1.0
 */
public interface SpecialtyInspectionPlanMapper extends BaseMapper<SpecialtyInspectionPlan> {

    IPage<Map<String, Object>> getSpecialtyInspectionStandard(IPage<Map> pageData, @Param("params") Map<String,Object> params);

    IPage<Map<String, Object>> getSpecialtyInspectionPlan(IPage<Map> pageData, @Param("params") Map<String,Object> params);

    @Select("SELECT t1.id AS value, t1.depart_name as text,t1.depart_name as title FROM sys_depart t1  WHERE t1.del_flag = '0'  and t1.id in (select DISTINCT use_id as useId from mom_eam_equipment WHERE del_flag = '0' and use_id IS NOT NULL)")
    List<DepartVo> getSysDeparts();

    /**
     *专业点检方案功能 获取设备台账下的所有对象部门
     * qsw 2023-8-5
     */
    IPage<Map<String, Object>> getSysDepartPages(IPage<Map> pageData, @Param("params") Map<String,Object> params);

}