yangys
2024-04-04 ed4a5236bab800094be4a8378f5098eebe3de6ac
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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);
}