去掉dmpvar

yangys

2024-11-02 f69073b835f1a0c66590130e1830edcdd75ebb8a

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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
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);
}