package com.qianwen.smartman.modules.mdc.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.qianwen.smartman.common.constant.FmsConstant;
import com.qianwen.core.mp.support.Query;
import com.qianwen.smartman.modules.mdc.entity.SuperAlarm;
import com.qianwen.smartman.modules.mdc.vo.AlarmAnalysisWorkstationVO;
import com.qianwen.smartman.modules.mdc.vo.AlarmShiftSearchExcelVO;
import com.qianwen.smartman.modules.mdc.vo.AlarmShiftSearchVO;
import com.qianwen.smartman.modules.report.vo.DrillWorkstationAlarmByShiftVO;
import com.qianwen.smartman.modules.report.vo.DrillWorkstationAlarmByTimeVO;
import com.qianwen.smartman.modules.report.vo.WorkstaionAlarmByShiftReportVO;
import com.qianwen.smartman.modules.report.vo.WorkstaionAlarmByTimeReportVO;

@DS("iotdb")
@InterceptorIgnore(tenantLine = FmsConstant.AUTOMATIC)
public interface SuperAlarmMapper extends BaseMapper<SuperAlarm> {
	/**
	 * 查询告警分页数据
	 * @param workstationId
	 * @param start
	 * @param end
	 * @return
	 */
    List<AlarmAnalysisWorkstationVO> alarmByWorkstation(@Param("workstationId") String workstationId, @Param("start") Integer start, @Param("end") Integer end);

    /**
     * 查询告警数据条数
     * @param workstationId
     * @return
     */
    Integer alarmByWorkstationTotal(@Param("workstationId") String workstationId);

    void createTable(Long workstationId);

    void insertData(@Param("workstationId") Long workstationId, @Param("sql") String sql);

    Long countAlarm(@Param("vo") AlarmShiftSearchVO vo, @Param("queryTime") String queryTime);

    /**
     * 报警的列表查询，按时间
     * @param vo 查询参数
     * @param queryTime
     * @return
     */
    List<SuperAlarm> selectListAlarm(@Param("vo") AlarmShiftSearchVO vo, @Param("factoryDate") int factoryDate);

    /**
     * 查询报警分页数据
     * @param query
     * @param vo
     * @param factoryDate
     * @return
     */
    List<SuperAlarm> queryAlarm(@Param("query") Query query, @Param("vo") AlarmShiftSearchVO vo, @Param("factoryDate") int factoryDate);

    List<SuperAlarm> selectAllAlarm(@Param("vo") AlarmShiftSearchExcelVO vo, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("year") Integer year, @Param("list") List<Integer> list);
    /**
     * 按班次查询报警数据
     * @param startDate
     * @param endDate
     * @param workstationId
     * @return
     */
    List<SuperAlarm> selectListAlarmByShift(@Param("startFactoryDate") int startFactoryDate, @Param("endFactoryDate") int endFactoryDate, @Param("workstationId") Long workstationId);

    List<WorkstaionAlarmByTimeReportVO> alarmReportByTime(@Param("ids") List<Long> workstationIds, @Param("beginTime") String startDate, @Param("endTime") String endDate);

    List<WorkstaionAlarmByShiftReportVO> alarmReportByShift(@Param("ids") List<Long> workstationIds, @Param("beginTime") String startDate, @Param("endTime") String endDate, @Param("filterType") Boolean filterType, @Param("filterShift") Boolean filterShift);

    List<DrillWorkstationAlarmByTimeVO> drillAlarmReportByTime(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize, @Param("workstationId") Long workstationId, @Param("beginTime") String startDate, @Param("endTime") String endDate, @Param("filterType") Boolean filterType, @Param("filterShift") Boolean filterShift);

    Long drillCountAlarmReport(@Param("workstationId") Long workstationId, @Param("beginTime") String startDate, @Param("endTime") String endDate, @Param("filterType") Boolean filterType, @Param("filterShift") Boolean filterShift);

    List<DrillWorkstationAlarmByShiftVO> drillAlarmReportByShift(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize, @Param("workstationId") Long workstationId, @Param("beginTime") String startDate, @Param("endTime") String endDate, @Param("filterType") Boolean filterType, @Param("filterShift") Boolean filterShift);

    List<SuperAlarm> pageAlarm(@Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize, @Param("workstationId") Long workstationId);

    Integer countAlarmByWorkstationId(@Param("workstationId") Long workstationId);
}