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.DailyMaintenanceOrder;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.jeecg.modules.eam.model.DepartVo;
|
import org.jeecg.modules.eam.model.MaintenanceCycleVo;
|
|
/**
|
* @Description: mom_eam_daily_maintenance_order
|
* @Author: jeecg-boot
|
* @Date: 2023-05-11
|
* @Version: V1.0
|
*/
|
public interface DailyMaintenanceOrderMapper extends BaseMapper<DailyMaintenanceOrder> {
|
|
//日常保养工单编辑时，回显保养项目 （手动生成日常保养工单）
|
List<Map<String, Object>> getDailyMaintenanceOrderDetailByOrderId(@Param("dailyMaintenanceOrderId")String dailyMaintenanceOrderId);
|
|
IPage<Map<String, Object>> getDailyMaintenanceOrderList(IPage<Map> pageData, @Param("params") Map<String,Object> params);
|
|
IPage<Map<String, Object>> getDailyMaintenanceOrder3List(IPage<Map> pageData, @Param("params") Map<String,Object> params);
|
|
List<MaintenanceCycleVo> getMaintenanceCycleByStandardId(@Param("maintenanceStandardId")String maintenanceStandardId);
|
|
//根据保养标准,保养周期获取保养标准下对应的保养项目 （手动生成日常保养工单）
|
List<Map<String, Object>> getMaintenanceProjectId(@Param("maintenanceStandardId")String maintenanceStandardId, @Param("maintenanceCycleId")String maintenanceCycleId);
|
|
/**
|
* 日常保养工单 获取设备台站已绑定的对象部门
|
* qsw 2023-7-11
|
*/
|
@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();
|
|
}
|
