package org.jeecg.modules.eam.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.eam.entity.DailyInspectionStandardDetail;
|
import org.jeecg.modules.eam.entity.MaintenanceStandardDetail;
|
import org.jeecg.modules.eam.model.MaintenanceCycleVo;
|
import org.jeecg.modules.eam.model.MaintenanceModeVo;
|
import org.jeecg.modules.eam.model.TreatmentMeasureVo;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Description: mom_eam_daily_inspection_standard_detail
|
* @Author: jeecg-boot
|
* @Date: 2023-03-10
|
* @Version: V1.0
|
*/
|
public interface MaintenanceStandardDetailMapper extends BaseMapper<MaintenanceStandardDetail> {
|
|
List<Map<String, Object>> getMaintenanceStandardDetailList(@Param("maintenanceStandardId")String maintenanceStandardId);
|
|
List<Map<String, Object>> getMaintenanceStandardDetailListByIds(@Param("ids")List<String> ids);
|
|
IPage<Map<String, Object>> getMaintenanceStandardDetailById(IPage<Map> pageData, @Param("params") Map<String,Object> params);
|
|
@Select("select t1.id as value,concat(t1.code, '/', t1.name) as text,concat(t1.code, '/', t1.name) as title from mom_eam_maintenance_cycle t1 where t1.del_flag = '0' and t1.version_status = '2'")
|
List<MaintenanceCycleVo> getMaintenanceCycle();
|
|
@Select("select t1.id as value,t1.name as text,t1.name as title from mom_eam_maintenance_cycle t1 where t1.del_flag = '0' and t1.version_status = '2' and t1.equipment_importance_id = #{importanceFlag}")
|
List<MaintenanceCycleVo> getPeriodicMaintenanceCycle(String importanceFlag);
|
|
@Select(" SELECT item_value as value, item_text as text,item_text as title FROM v_sys_dict WHERE dict_code = 'maintenance_method'")
|
List<MaintenanceModeVo> getMaintenanceMode();
|
|
@Delete("delete from mom_eam_maintenance_standard_detail where maintenance_standard_id is null")
|
boolean realDelete();
|
}
|
