ComprehensiveSupervisionMapper.java
3.9 KB
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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
package com.skua.modules.equipment.mapper;
import com.skua.modules.equipment.dto.*;
import com.skua.modules.equipment.vo.AlarmVo;
import com.skua.modules.equipment.vo.MetricVo;
import com.skua.modules.equipment.vo.StructDictVo;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
public interface ComprehensiveSupervisionMapper {
String selectDeviceName(@Param("factoryId") String factoryId);
MetricVo selectMetric(@Param("metricUidTag") String metricUidTag,@Param("factoryId") String factoryId);
String selectSJGM(@Param("factoryId") String factoryId);
List<AlarmVo> selectAlarms();
List<AlarmVo> selectInAlarms();
List<AlarmDto> selectDhByMonths(@Param("list") List<String> months, @Param("factoryId") String factoryId);
List<AlarmDto> selectAllDh(@Param("factoryId") String factoryId);
List<AlarmDto> selectDhByStartAndEnd(@Param("startTime") String startTime, @Param("endTime") String endTime,@Param("factoryId") String factoryId);
AlarmDto selectDhByYear(String year);
List<String> selectDataIdsByMonth( @Param("month") String month ,@Param("departId")String departId);
List<ReportItemCustomDto> selectItemCustom();
List<ReportItemCustomDto> selectValueByDataId(@Param("list") List<String> dataIds);
ReportItemCustomDto selectVByDataIdAndPid(@Param("list") List<String> dataIds, @Param("id") String id);
String selectZyhByDataIds(@Param("list") List<String> dataIds);
List<AlarmDto> selectAllYh();
//总药耗趋势
List<AlarmDto> selectYhByStartTimeAndEndTime(@Param("startTime") String startTime, @Param("endTime") String endTime , @Param("departId") String departId);
List<ReportItemCustomValueDto> selectItemDetail(@Param("list") List<String> dataIds);
String selectXnjByDataIds(@Param("list") List<String> dataIds);
String selectGwnByTime(String s);
String selectTyByDataIds(@Param("list")List<String> dataIds);
String selectBodByTime(String s);
String selectTnByTime(String s);
String selectClByDataIds(@Param("list")List<String> dataIds);
List<String> selectDataIdsByDay(String seven);
List<ReportItemCustomValueDetailDto> selectVByDay(@Param("list") List<String> dataIds);
List<ReportItemCustomValueDetailDto> selectVByMonth(@Param("list") List<String> dataIds);
List<ReportItemCustomValueDto> selectDetailVByMonth(@Param("list")List<String> dataIds, @Param("id") String s);
List<StructDictVo> structDictList();
List<StructDictVo> metricList(String id);
String selectMetricNameById(String id);
/**
* 月度电耗水耗统计
*
* @return
*/
ConsumptionDto selectMonthlyPowerConsumption(@Param("dataStr") String dataStr, @Param("departIds") List<String> departIds);
/**
* 月度药耗统计
*
* @return
*/
DrugConsumptionDto selectMonthlyDrugConsumptionStatistics(@Param("dataStr") String dataStr, @Param("departIds") List<String> departIds);
/**
* 天出水量统计
*
* @return
*/
Integer selectShByDay(@Param("date") String date, @Param("departIds") List<String> departIds);
/**
* 查询某年 每日警告的次数列表
*
* @param year
* @returnt
*/
List<AlarmCountDto> selectCountAlarmByYearForDay(@Param("year") String year, @Param("departIds") List<String> departIds);
/**
* 根据时间查询水质变化
*
* @return
*/
List<QualityChangeDto> qualityChange(List<String> days, String code, @Param("departIds") List<String> departIds);
/**
* 获取月度处理水量
* @param list
* @param factoryId
* @return
*/
List<Map<String, Object>> selectClslByMonths(List<String> list, String factoryId);
/**
* 获取所有月份处理水量
* @param factoryId
* @return
*/
List<AlarmDto> selectAllClsl(String factoryId);
}