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