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("tdengine")
|
@InterceptorIgnore(tenantLine = FmsConstant.AUTOMATIC)
|
/* loaded from: blade-api.jar:BOOT-INF/classes/org/springblade/modules/mdc/mapper/SuperAlarmMapper.class */
|
public interface SuperAlarmMapper extends BaseMapper<SuperAlarm> {
|
List<AlarmAnalysisWorkstationVO> alarmByWorkstation(@Param("workstationId") String workstationId, @Param("start") Integer start, @Param("end") Integer end);
|
|
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);
|
|
List<SuperAlarm> selectListAlarm(@Param("vo") AlarmShiftSearchVO vo, @Param("queryTime") String queryTime);
|
|
List<SuperAlarm> queryAlarm(@Param("query") Query query, @Param("vo") AlarmShiftSearchVO vo, @Param("queryTime") String queryTime);
|
|
List<SuperAlarm> selectAllAlarm(@Param("vo") AlarmShiftSearchExcelVO vo, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("year") Integer year, @Param("list") List<Integer> list);
|
|
List<SuperAlarm> selectListAlarmByShift(@Param("startDate") String startDate, @Param("endDate") String endDate, @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);
|
}
|