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

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

}