ScreenMapper.java
2.7 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
package com.skua.modules.threedimensional.mapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;
/**
* @author sonin
* @date 2021/10/28 19:16
*/
@Mapper
public interface ScreenMapper {
List<Map<String, Object>> factorySLQS(@Param("departId") String departId, @Param("startTime") String startTime, @Param("endTime") String endTime,
@Param("TbstartTime") String TbstartTime, @Param("TbendTime") String TbendTime,
@Param("timeType") String timeType);
List<Map<String, Object>> getYhdlqs(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("departIds") String departIds,
@Param("dataViewName3a24") String dataViewName3a24, @Param("dataViewName2119") String dataViewName2119);
List<Map<String, Object>> getYhylqs(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("departIds") String departIds,
@Param("dataViewName3a24") String dataViewName3a24, @Param("dataViewName2119") String dataViewName2119,
@Param("startMonth") String startMonth, @Param("endMonth") String endMonth,
@Param("dataViewName4411") String dataViewName4411);
@Select(" select sd.depart_name,( SELECT depart_name from sys_depart WHERE id = sd.parent_id )parent_depart_name,sd.depart_type,smd.metricd_name, smmi.id,smmi.metric_name,smmi.metric_type,smmi.metric_uid_tag ,g.group_name groupName,g.group_type groupType , COALESCE(smmi.metric_unit,smd.metric_unit) metric_unit,smmi.depart_id ,COALESCE(g.sort_num,smmi.sort_num) sort_num from sys_monitor_metric_info smmi left join sys_metric_dict smd on smd.id =smmi.metric_uid_tag " +
"inner join sys_depart sd on smmi.depart_id =sd.id left join sys_metric_dict_group g on g.dict_id =smmi.metric_uid_tag " +
" ${ew.customSqlSegment}")
List<Map<String, Object>> getDictGroupData(@Param(Constants.WRAPPER) QueryWrapper dictGroupQueryWrapper);
/**
* 水厂档案相关查询
* @param queryWrapper
*/
@Select("select sd.id depart_id,sd.parent_id,sd.depart_name,( SELECT depart_name from sys_depart WHERE id = sd.parent_id )parent_depart_name,sd.depart_type,sf.* from sys_depart sd left join sys_factory_info sf on sd.id =sf.depart_id ${ew.customSqlSegment}")
List<Map<String, Object>> factoryDesign(@Param(Constants.WRAPPER) QueryWrapper queryWrapper);
}