package com.skua.modules.inspection.mapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.inspection.entity.InspectionTask;
import com.skua.modules.inspection.vo.InspectionTaskVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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

/**
 * 巡检任务
 */
public interface InspectionTaskMapper extends BaseMapper<InspectionTask> {

    @Select({"select it.id,inspection_plan_id,task_start_time,task_end_time,task_state,task_start_user,task_end_user,plan_name,it.task_duration," +
            "ip.task_type,ip.plan_start_date,ip.plan_end_date,ip.plan_task_start_time,ip.continue_time,ip.depart_id,ip.inspection_working_group_id," +
            "inspection_cycle_start_date,inspection_cycle_index from inspection_task it left join inspection_plan ip on it.inspection_plan_id = ip.id ${ew.customSqlSegment}"})
    InspectionTaskVO getTaskByInspectionPlanId(@Param(Constants.WRAPPER) QueryWrapper<InspectionTask> inspectionTaskQueryWrapper);

    @Select({"select it.id,link_id,inspection_plan_id,task_start_time,task_end_time,task_state,task_start_user,task_end_user,plan_name," +
            "ip.task_type,ip.plan_start_date,ip.plan_end_date,ip.plan_task_start_time,ip.continue_time,ip.depart_id,ip.inspection_working_group_id," +
            "inspection_cycle_start_date,inspection_cycle_index,pro_longitude,pro_latitude  from inspection_task it left join  inspection_plan ip on " +
            " it.inspection_plan_id = ip.id left join sys_factory_info sfi on ip.depart_id = sfi.depart_id ${ew.customSqlSegment}"})
    List<InspectionTaskVO> getInspectionTask(@Param(Constants.WRAPPER) QueryWrapper<InspectionTaskVO> inspectionTaskVOQueryWrapper);

    Map<String,Object> getCompletionOfPersonal(@Param(value = "userId") String userId, @Param(value = "startTime") String startTime, @Param(value = "endTime") String endTime);

    @Select("select * from equipment_info ${ew.customSqlSegment}")
    Map<String, Object> getEquipmentInfo(@Param(Constants.WRAPPER)QueryWrapper queryWrapper);
}