From 58fdbd07beae496c4c3b0744efe86a7d82e382b7 Mon Sep 17 00:00:00 2001
From: cjl <276999030@qq.com>
Date: Tue, 22 Aug 2023 16:59:34 +0800
Subject: [PATCH] fix:部分功能优化
---
screen-api/src/main/java/com/moral/api/controller/HistoryFiveMinutelyController.java | 10
screen-api/src/main/java/com/moral/api/service/HistoryFiveMinutelyService.java | 2
screen-api/src/main/java/com/moral/api/service/impl/HistoryFiveMinutelyServiceImpl.java | 19 +-
screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml | 18 ++
screen-api/src/main/java/com/moral/api/mapper/CityAqiDailyMapper.java | 9 +
screen-api/src/main/java/com/moral/api/dto/CityAqiDailyListDTO.java | 27 +++
screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java | 7
screen-api/src/main/java/com/moral/api/mapper/DeviceMapper.java | 12 +
screen-api/src/main/java/com/moral/api/mapper/CityAqiMapper.java | 10 +
screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java | 86 ++++++---
screen-api/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java | 23 +-
screen-api/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java | 3
screen-api/src/main/java/com/moral/api/service/impl/SysAreaServiceImpl.java | 8
screen-api/src/main/resources/mapper/AlarmInfoMapper.xml | 89 ++++++++++
screen-api/src/main/resources/mapper/CityAqiMapper.xml | 12 +
screen-api/src/main/resources/mapper/DeviceMapper.xml | 144 ++++++++++++++++-
16 files changed, 402 insertions(+), 77 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/controller/HistoryFiveMinutelyController.java b/screen-api/src/main/java/com/moral/api/controller/HistoryFiveMinutelyController.java
index 38a1a71..c1a60d8 100644
--- a/screen-api/src/main/java/com/moral/api/controller/HistoryFiveMinutelyController.java
+++ b/screen-api/src/main/java/com/moral/api/controller/HistoryFiveMinutelyController.java
@@ -17,6 +17,7 @@
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -55,12 +56,13 @@
ResponseCodeEnum.PARAMETERS_IS_MISSING.getMsg());
//������������������
- List<DeviceAndFiveMinuteDataDTO> dto = historyFiveMinutelyService.queryDeviceAndFiveMinuteData(form);
-
+ List<Map<String, Object>> dto = historyFiveMinutelyService.queryDeviceAndFiveMinuteData(form);
+ Map<String,List<Map<String, Object>>> dtoResult = new HashMap<>();
+ dtoResult.put("devices",dto);
//������������������
- DeviceAndFiveMinuteDataVO vo = DeviceAndFiveMinuteDataVO.convert(dto);
+ //DeviceAndFiveMinuteDataVO vo = DeviceAndFiveMinuteDataVO.convert(dto);
- return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), vo);
+ return new ResultMessage(ResponseCodeEnum.SUCCESS.getCode(), ResponseCodeEnum.SUCCESS.getMsg(), dtoResult);
}
/**
diff --git a/screen-api/src/main/java/com/moral/api/dto/CityAqiDailyListDTO.java b/screen-api/src/main/java/com/moral/api/dto/CityAqiDailyListDTO.java
new file mode 100644
index 0000000..55a691c
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/dto/CityAqiDailyListDTO.java
@@ -0,0 +1,27 @@
+package com.moral.api.dto;
+
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+import java.math.BigDecimal;
+
+/**
+ * @ClassName CityAqiDailyListDTO
+ * @Description TODO
+ * @Author @lizijie
+ * @Date 2023-08-22 15:19
+ * @Version 1.0
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+public class CityAqiDailyListDTO {
+
+ private String cityCode;
+
+ private BigDecimal aqi;
+
+ private BigDecimal comp;
+
+ private BigDecimal nums;
+
+}
diff --git a/screen-api/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java b/screen-api/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
index 3771d92..30512db 100644
--- a/screen-api/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
+++ b/screen-api/src/main/java/com/moral/api/mapper/AlarmInfoMapper.java
@@ -2,6 +2,7 @@
import com.moral.api.entity.AlarmInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import io.lettuce.core.dynamic.annotation.Param;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@@ -23,4 +24,6 @@
List<Map<String,Object>> selectNewestData(Map<String, Object> map);
+ int numNews(@Param("organizationId") int organizationId);
+
}
diff --git a/screen-api/src/main/java/com/moral/api/mapper/CityAqiDailyMapper.java b/screen-api/src/main/java/com/moral/api/mapper/CityAqiDailyMapper.java
index 886cbb0..91515ec 100644
--- a/screen-api/src/main/java/com/moral/api/mapper/CityAqiDailyMapper.java
+++ b/screen-api/src/main/java/com/moral/api/mapper/CityAqiDailyMapper.java
@@ -1,7 +1,11 @@
package com.moral.api.mapper;
+import com.moral.api.dto.CityAqiDailyListDTO;
import com.moral.api.entity.CityAqiDaily;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -13,4 +17,9 @@
*/
public interface CityAqiDailyMapper extends BaseMapper<CityAqiDaily> {
+
+ /**
+ * ���������������������api ��� ������������
+ * */
+ List<CityAqiDailyListDTO> CityAqiDailyMap(Map<String, Object> params);
}
diff --git a/screen-api/src/main/java/com/moral/api/mapper/CityAqiMapper.java b/screen-api/src/main/java/com/moral/api/mapper/CityAqiMapper.java
index e1d19a7..f7aa655 100644
--- a/screen-api/src/main/java/com/moral/api/mapper/CityAqiMapper.java
+++ b/screen-api/src/main/java/com/moral/api/mapper/CityAqiMapper.java
@@ -2,6 +2,10 @@
import com.moral.api.entity.CityAqi;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import io.lettuce.core.dynamic.annotation.Param;
+
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -13,4 +17,10 @@
*/
public interface CityAqiMapper extends BaseMapper<CityAqi> {
+ /**
+ *
+ *������24������������api
+ * */
+ List<CityAqi> listCity(@Param("cityCode") Integer cityCode);
+
}
diff --git a/screen-api/src/main/java/com/moral/api/mapper/DeviceMapper.java b/screen-api/src/main/java/com/moral/api/mapper/DeviceMapper.java
index a40f6ba..0f56b49 100644
--- a/screen-api/src/main/java/com/moral/api/mapper/DeviceMapper.java
+++ b/screen-api/src/main/java/com/moral/api/mapper/DeviceMapper.java
@@ -20,6 +20,16 @@
/*���������������������������*/
List<Map<String, Object>> getTrendChartData(Map<String, Object> params);
- List<Device> deviceList(@Param("organizationId") int organizationId,@Param("regionCode") int regionCode,@Param("region") String region);
+ List<Map<String, Object>> deviceList(@Param("organizationId") int organizationId,
+ @Param("regionCode") int regionCode,
+ @Param("region") String region,
+ @Param("type") String type,
+ @Param("sensorCode") String sensorCode,
+ @Param("times") String times,
+ @Param("endHourlyTime") String endHourlyTime);
+
+ List<Integer> deviceIdList(@Param("organizationId") int organizationId);
+
+ List<Integer> deviceOrgIdList(@Param("organizationId") int organizationId);
}
diff --git a/screen-api/src/main/java/com/moral/api/service/HistoryFiveMinutelyService.java b/screen-api/src/main/java/com/moral/api/service/HistoryFiveMinutelyService.java
index d107d5c..5ad395a 100644
--- a/screen-api/src/main/java/com/moral/api/service/HistoryFiveMinutelyService.java
+++ b/screen-api/src/main/java/com/moral/api/service/HistoryFiveMinutelyService.java
@@ -26,7 +26,7 @@
* @Author: ���������
* @Date: 2021/7/16
*/
- List<DeviceAndFiveMinuteDataDTO> queryDeviceAndFiveMinuteData(QueryDeviceAndFiveMinuteDataForm form);
+ List<Map<String, Object>> queryDeviceAndFiveMinuteData(QueryDeviceAndFiveMinuteDataForm form);
/**
* @Description: ������������������������������������������
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
index 1c2620a..7950927 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/AlarmInfoServiceImpl.java
@@ -143,7 +143,7 @@
public Map<String, Object> getDataByConditionWithoutPage(Map<String, Object> parameters) {
Map<String, Object> resultMap = new HashMap<>();
int orgId = Integer.parseInt(parameters.get("organization_id").toString());
- //���������������������������������id
+ /* //���������������������������������id
List<Integer> allOrgId = new ArrayList<>();
allOrgId.add(orgId);
//������������
@@ -172,7 +172,8 @@
}else {
continue;
}
- }
+ }*/
+ List<Integer> deviceIdList = deviceMapper.deviceIdList(orgId);
if (deviceIdList.size()>0){
Map<String, Object> map = new HashMap<>();
QueryWrapper<AlarmInfo> alarmInfoQueryWrapper = new QueryWrapper<>();
@@ -230,7 +231,7 @@
public Map<String, Object> alarmReminder(Map<String, Object> parameters) {
Map<String,Object> resultMap = new HashMap<>();
int orgId = Integer.parseInt(parameters.get("organization_id").toString());
- //���������������������������������id
+ /*//���������������������������������id
List<Integer> allOrgId = new ArrayList<>();
allOrgId.add(orgId);
//������������
@@ -259,12 +260,13 @@
}else {
continue;
}
- }
- if (deviceIdList.size()>0){
+ }*/
+ // if (deviceIdList.size()>0){
Map<String, Object> map = new HashMap<>();
- map.put("deviceIds",deviceIdList);
+ //map.put("deviceIds",deviceIdList);
int size = Integer.parseInt(parameters.get("size").toString());
map.put("size",size);
+ map.put("orgId",orgId);
List<Map<String, Object>> resultList = alarmInfoMapper.selectNewestData(map);
SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
for (Map<String, Object> alarmInfo:resultList) {
@@ -272,13 +274,14 @@
alarmInfo.put("alarm_time",alarm_time);
}
resultMap.put("alarmInfors",resultList);
- QueryWrapper<AlarmInfo> alarmInfoQueryWrapper = new QueryWrapper<>();
+ Integer totalNumber = alarmInfoMapper.numNews(orgId);
+ /*QueryWrapper<AlarmInfo> alarmInfoQueryWrapper = new QueryWrapper<>();
alarmInfoQueryWrapper.in("device_id",deviceIdList);
- Integer totalNumber = alarmInfoMapper.selectCount(alarmInfoQueryWrapper);
+ Integer totalNumber = alarmInfoMapper.selectCount(alarmInfoQueryWrapper);*/
resultMap.put("totalNumber",totalNumber);
return resultMap;
- }
- return null;
+ // }
+ // return null;
}
@Override
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
index 10d5f6d..ccfb212 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java
@@ -6,11 +6,9 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.moral.api.config.properties.SpecialCitiesProperties;
+import com.moral.api.dto.CityAqiDailyListDTO;
import com.moral.api.entity.*;
-import com.moral.api.mapper.CityAqiMapper;
-import com.moral.api.mapper.DeviceMapper;
-import com.moral.api.mapper.ForecastMapper;
-import com.moral.api.mapper.SysAreaMapper;
+import com.moral.api.mapper.*;
import com.moral.api.pojo.dto.cityAQI.CityPollutionLevel;
import com.moral.api.pojo.dto.cityAQI.ConcentrationAndPercent;
import com.moral.api.pojo.form.aqi.AirQualityComparisonForm;
@@ -28,6 +26,7 @@
import com.moral.util.MathUtils;
+import org.apache.commons.collections4.CollectionUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
@@ -52,6 +51,8 @@
@Autowired
private CityAqiMapper cityAqiMapper;
+ @Autowired
+ private CityAqiDailyMapper cityAqiDailyMapper;
@Autowired
private ForecastMapper forecastMapper;
@@ -208,7 +209,7 @@
@Override
public Map<String, Object> query24HoursAqiByRegionCode(Integer regionCode) {
//������������������������������������������������������
- QueryWrapper<CityAqi> lastDataWrapper = new QueryWrapper<>();
+ /*QueryWrapper<CityAqi> lastDataWrapper = new QueryWrapper<>();
lastDataWrapper.eq("city_code", regionCode);
lastDataWrapper.orderByDesc("time");
lastDataWrapper.last(true, "limit 1");
@@ -221,39 +222,33 @@
//������������
QueryWrapper<CityAqi> wrapper = new QueryWrapper<>();
wrapper.between("time", startDate, endDate);
- wrapper.eq("city_code", regionCode);
- List<CityAqi> cityAqis = cityAqiMapper.selectList(wrapper);
+ wrapper.eq("city_code", regionCode);*/
+ List<CityAqi> cityAqis = cityAqiMapper.listCity(regionCode);
//������������������24���������������
- if (cityAqis.size() != 24) {
- Map<Date, CityAqi> dateCityAqiMap = new HashMap<>();
- cityAqis.forEach(value -> dateCityAqiMap.put(value.getTime(), value));
+ if(CollectionUtils.isEmpty(cityAqis)){
+ return new HashMap<>();
+ }
+ Date startDate = cityAqis.get(0).getTime();
+ if(cityAqis.size()<24){
for (int i = 0; i < 24; i++) {
- Date date = DateUtils.addHours(startDate, i);
- CityAqi cityAqi1 = dateCityAqiMap.get(date);
- if (cityAqi1 == null) {
+ Date dateTime = DateUtils.addHours(startDate, i);
+ if(cityAqis.size()-1 <i){
CityAqi newCityAqi = new CityAqi();
- newCityAqi.setTime(date);
+ newCityAqi.setTime(dateTime);
+ newCityAqi.setValue("0");
cityAqis.add(newCityAqi);
+ continue;
}
}
- //������������������������
- cityAqis.sort(Comparator.comparing(CityAqi::getTime));
}
+ //������������������������
+ cityAqis.sort(Comparator.comparing(CityAqi::getTime));
+
//������������������,map���key���yyyy-MM-dd HH:mm������������������value���aqi���������
Map<String, Object> result = new LinkedHashMap<>();
for (CityAqi aqi : cityAqis) {
String key = DateUtils.dateToDateString(aqi.getTime(), "yyyy-MM-dd HH:mm");
- String allDataJson = aqi.getValue();
- if (allDataJson == null) {
- result.put(key, "");
- continue;
- }
- Map<String, Object> allDataMap = JSON.parseObject(allDataJson, Map.class);
- Object aqiData = allDataMap.get("AQI");
- if (aqiData == null)
- result.put(key, "");
- else
- result.put(key, aqiData);
+ result.put(key,aqi.getValue());
}
return result;
}
@@ -691,14 +686,35 @@
Date now = new Date();
//������
- Date yesterday = DateUtils.dataToTimeStampTime(DateUtils.getDateOfDay(now, -1), DateUtils.yyyy_MM_dd_EN);
- String dateString = DateUtils.dateToDateString(yesterday, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
+ Date yesterday = DateUtils.dataToTimeStampTime(DateUtils.getDateOfDay(now, 0), DateUtils.yyyy_MM_dd_EN);
+ String dateString = DateUtils.dateToDateString(yesterday, DateUtils.yyyy_MM_dd_EN);
String s = String.valueOf(regionCode);
//���������,���code
Integer provinceCode = Integer.parseInt(s.substring(0, 2) + "0000");
Integer cityCode = Integer.parseInt(s.substring(0, 4) + "00");
- //������������������city_code
+ Map<String,Object> params = new HashMap<>();
+ params.put("cityCode",provinceCode);
+ params.put("start",dateString);
+ params.put("end",dateString);
+ params.put("type",1);
+ List<CityAqiDailyListDTO> dayList = cityAqiDailyMapper.CityAqiDailyMap(params);
+ String start = DateUtils.dateToDateString(DateUtils.addMonths(DateUtils.getFirstDayOfLastMonth(), 1));
+ params.put("start",start);
+ params.put("type",2);
+ List<CityAqiDailyListDTO> monList = cityAqiDailyMapper.CityAqiDailyMap(params);
+ start =DateUtils.dateToDateString(now, DateUtils.yyyy);
+ params.put("start",start);
+ params.put("end",start);
+ params.put("type",3);
+ List<CityAqiDailyListDTO> yearList = cityAqiDailyMapper.CityAqiDailyMap(params);
+ int indexDay = dayList.stream().map(CityAqiDailyListDTO::getCityCode).collect(Collectors.toList()).indexOf(cityCode.toString());
+ int indexMon = monList.stream().map(CityAqiDailyListDTO::getCityCode).collect(Collectors.toList()).indexOf(cityCode.toString());
+ int indexYear = yearList.stream().map(CityAqiDailyListDTO::getCityCode).collect(Collectors.toList()).indexOf(cityCode.toString());
+ result.put("day",mapResult(dayList,indexDay));
+ result.put("month",mapResult(monList,indexMon));
+ result.put("year",mapResult(yearList,indexYear));
+ /* //������������������city_code
QueryWrapper<SysArea> wrapper = new QueryWrapper<>();
wrapper.select("area_code").eq("parent_code", provinceCode);
List<Object> cityCodes = sysAreaService.listObjs(wrapper);
@@ -786,13 +802,21 @@
yearMap.put("size", null);
}
yearMap.put("compositeIndex", yearMap.remove("value"));
- result.put("year", yearMap);
+ result.put("year", yearMap);*/
//���������������
result.put("time", DateUtils.dateToDateString(yesterday, DateUtils.yyyy_MM_dd_EN));
return result;
}
+ private Map<String,Object> mapResult(List<CityAqiDailyListDTO> list, int length){
+ Map<String,Object> map = new HashMap<>();
+ map.put("AQI",CollectionUtils.isNotEmpty(list)&&length>0&&Objects.nonNull(list.get(length-1))?list.get(length-1).getAqi():0);
+ map.put("rank",CollectionUtils.isNotEmpty(list)&&length>0?length:0);
+ map.put("size",CollectionUtils.isNotEmpty(list)&&length>0?list.size():0);
+ return map;
+ }
+
@Override
public List<AirQualityComparisonVO> queryAirQualityComparison(AirQualityComparisonForm form) {
//������
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistoryFiveMinutelyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistoryFiveMinutelyServiceImpl.java
index 5a43e82..130fa2e 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistoryFiveMinutelyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistoryFiveMinutelyServiceImpl.java
@@ -59,19 +59,22 @@
DeviceMapper deviceMapper;
@Override
- public List<DeviceAndFiveMinuteDataDTO> queryDeviceAndFiveMinuteData(QueryDeviceAndFiveMinuteDataForm form) {
+ public List<Map<String, Object>> queryDeviceAndFiveMinuteData(QueryDeviceAndFiveMinuteDataForm form) {
//������
+ String times = DateUtils.dateToDateString(new Date(),DateUtils.yyyyMM_EN);
Integer organizationId = form.getOrganizationId();
Integer regionCode = form.getRegionCode();
String sensorCode = form.getSensorCode();
- Map<String, Object> params = new HashMap<>();
+ String type = "$."+ sensorCode;
String region = null;
+ String endHourlyTime = null;
if (regionCode != null && organizationId!=24) {
region = RegionCodeUtils.regionCodeConvertToName(regionCode);
- params.put("region",region);
- params.put("regionCode",regionCode);
}
- params.put("organizationId",organizationId);
+ if (form.getChooseTime().equals("true")) {
+ endHourlyTime = form.getTime();
+ }
+ List<Map<String, Object>> listAll = deviceMapper.deviceList(organizationId,regionCode,region,type,sensorCode,times,endHourlyTime);
//���������������������������������������������������
/*List<MonitorPoint> monitorPoints = monitorPointService.queryByOrgIdAndRegionCode(new MonitorPointQueryForm(organizationId, regionCode));
List<Device> devices = new ArrayList<>();
@@ -87,7 +90,7 @@
}*/
//���������������������������������
- List<Device> devices = deviceMapper.deviceList(organizationId,regionCode,region);
+ /*List<Device> devices = new ArrayList<>();
List<DeviceAndFiveMinuteDataDTO> dtos = new ArrayList<>();
if (form.getChooseTime().equals("true")) {
String time = form.getTime();
@@ -125,8 +128,8 @@
dto.setDevice(device);
dto.setSensorValue(sensorValue);
dtos.add(dto);
- }
- return dtos;
+ }*/
+ return listAll;
}
@Override
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
index da9ea5e..26353e6 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/MonitorPointServiceImpl.java
@@ -78,18 +78,19 @@
// region = RegionCodeUtils.regionCodeConvertToName(regionCode);
// }
- //���������������
+ /* //���������������
List<Organization> childrenOrganization = organizationService.getChildrenOrganizationsById(organizationId);
- List<Integer> organizationIds = new ArrayList<>();
+
for (Organization organization : childrenOrganization) {
organizationIds.add(organization.getId());
}
- organizationIds.add(organizationId);
+ organizationIds.add(organizationId);*/
//������������
QueryWrapper<MonitorPoint> queryMonitorPointsWrapper = new QueryWrapper<>();
//������region������������������������������������������������������������������������������
//������region���������������������������������������������������������
+ List<Integer> organizationIds = deviceMapper.deviceOrgIdList(organizationId);
if (region != null){
queryMonitorPointsWrapper.eq(region, regionCode);
}
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/SysAreaServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/SysAreaServiceImpl.java
index d5b32bc..c7c0438 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/SysAreaServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/SysAreaServiceImpl.java
@@ -5,6 +5,7 @@
import com.moral.api.entity.MonitorPoint;
import com.moral.api.entity.Organization;
import com.moral.api.entity.SysArea;
+import com.moral.api.mapper.DeviceMapper;
import com.moral.api.mapper.MonitorPointMapper;
import com.moral.api.mapper.SysAreaMapper;
import com.moral.api.service.OrganizationService;
@@ -43,13 +44,16 @@
@Autowired
private OrganizationService organizationService;
+ @Autowired
+ private DeviceMapper deviceMapper;
@Override
public List<Map<String, Object>> getMapPath(Integer orgId) {
//������������������������������
- List<Organization> organizations = organizationService.getChildrenOrganizationsById(orgId);
+ /*List<Organization> organizations = organizationService.getChildrenOrganizationsById(orgId);
List<Integer> orgIds = organizations.stream().map(Organization::getId).collect(Collectors.toList());
- orgIds.add(orgId);
+ orgIds.add(orgId);*/
+ List<Integer> orgIds = deviceMapper.deviceOrgIdList(orgId);
QueryWrapper<MonitorPoint> queryWrapper = new QueryWrapper<>();
queryWrapper.select("province_code", "city_code", "area_code")
.eq("is_delete", Constants.NOT_DELETE)
diff --git a/screen-api/src/main/resources/mapper/AlarmInfoMapper.xml b/screen-api/src/main/resources/mapper/AlarmInfoMapper.xml
index d49905f..3388435 100644
--- a/screen-api/src/main/resources/mapper/AlarmInfoMapper.xml
+++ b/screen-api/src/main/resources/mapper/AlarmInfoMapper.xml
@@ -53,12 +53,87 @@
<select id="selectNewestData" resultType="java.util.Map">
select ai.id alarmInfoId,ai.alarm_time,ai.index,ai.alarm_type,ai.alarm_information,d.id deviceId,d.name deviceName,d.longitude,d.latitude
from alarm_info ai, device d
- where ai.device_id in
- <foreach collection="deviceIds" item="deviceId" index="index" open="(" close=")" separator=",">
- #{deviceId}
- </foreach>
- and d.id = ai.device_id
- ORDER by ai.create_time DESC
- limit 0,#{size}
+ where ai.alarm_time = (SELECT max(alarm_time) from alarm_info limit 1) and d.id = ai.device_id and ai.device_id in
+ (select t.id from device t
+ inner JOIN monitor_point p on p.id = t.monitor_point_id and p.is_delete = 0
+
+ and p.organization_id in ( SELECT id FROM (
+ SELECT id, parent_id, name FROM organization WHERE id = #{orgId}
+ UNION ALL
+ SELECT i.id, i.parent_id, i.name
+ FROM organization i
+ INNER JOIN (
+ SELECT * FROM (
+ SELECT id, parent_id, name FROM organization WHERE id = #{orgId}
+ UNION ALL
+ SELECT id, parent_id, name FROM organization WHERE parent_id = #{orgId}
+ ) t1
+ ) t2 ON i.parent_id = t2.id
+ where i.is_delete = 0
+ ) t3)
+ WHERE
+ t.is_delete = 0
+ )
+ ORDER by ai.id DESC
+ limit #{size}
</select>
+ <select id="numNews" resultType="java.lang.Integer">
+ select count(1) from alarm_info
+ where alarm_time >= date_format(NOW(),'%Y-%m-%d')
+ and device_id in (SELECT
+ t.id
+ FROM
+ device t
+ INNER JOIN monitor_point p ON p.id = t.monitor_point_id
+ AND p.is_delete = 0
+ AND p.organization_id IN (
+ SELECT
+ id
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ i.id,
+ i.parent_id,
+ i.NAME
+ FROM
+ organization i
+ INNER JOIN (
+ SELECT
+ *
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ parent_id = #{organizationId}
+ ) t1
+ ) t2 ON i.parent_id = t2.id
+ WHERE
+ i.is_delete = 0
+ ) t3
+ )
+ WHERE
+ t.is_delete = 0 )
+ </select>
+
</mapper>
\ No newline at end of file
diff --git a/screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml b/screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml
index 212653b..1489dcf 100644
--- a/screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml
+++ b/screen-api/src/main/resources/mapper/CityAqiDailyMapper.xml
@@ -9,4 +9,22 @@
<result column="value" property="value"/>
</resultMap>
+ <select id="CityAqiDailyMap" resultType="com.moral.api.dto.CityAqiDailyListDTO">
+ SELECT c.city_code, avg(c.value ->'$.AQI')as aqi,avg(c.value ->'$.compositeIndex')
+ as comp,sum(c.value ->'$.compositeIndex') as nums FROM city_aqi_daily c
+ INNER JOIN sys_area s on s.area_code = c.city_code and parent_code = #{cityCode}
+ where 1 =1
+ <if test="type == 1">
+ and c.time <![CDATA[=]]> #{start}
+ GROUP BY c.city_code order by aqi
+ </if>
+ <if test=" type == 2 ">
+ and c.time <![CDATA[>=]]> #{start} and c.time <![CDATA[<=]]> #{end}
+ GROUP BY c.city_code order by nums
+ </if>
+ <if test="type == 3 ">
+ and c.time <![CDATA[>=]]> #{start}
+ GROUP BY c.city_code order by nums
+ </if>
+ </select>
</mapper>
\ No newline at end of file
diff --git a/screen-api/src/main/resources/mapper/CityAqiMapper.xml b/screen-api/src/main/resources/mapper/CityAqiMapper.xml
index 7e8763e..0ea0277 100644
--- a/screen-api/src/main/resources/mapper/CityAqiMapper.xml
+++ b/screen-api/src/main/resources/mapper/CityAqiMapper.xml
@@ -8,5 +8,15 @@
<result column="time" property="time"/>
<result column="value" property="value"/>
</resultMap>
-
+ <select id="listCity" resultMap="BaseResultMap">
+ SELECT
+ time,value ->> '$.AQI' as value
+ FROM
+ `city_aqi`
+ WHERE
+ time >= DATE_SUB( date_format(NOW(),'%Y-%m-%d %H'), INTERVAL 1 DAY )
+ AND city_code = #{cityCode}
+ ORDER BY
+ time
+ </select>
</mapper>
\ No newline at end of file
diff --git a/screen-api/src/main/resources/mapper/DeviceMapper.xml b/screen-api/src/main/resources/mapper/DeviceMapper.xml
index 5f47265..48c7c3a 100644
--- a/screen-api/src/main/resources/mapper/DeviceMapper.xml
+++ b/screen-api/src/main/resources/mapper/DeviceMapper.xml
@@ -43,23 +43,149 @@
AND `time` <![CDATA[<]]> #{end}
ORDER BY `time`
</select>
- <select id="deviceList" resultMap="BaseResultMap">
+ <select id="deviceList" resultType="java.util.Map">
SELECT
- t.latitude,
- t.longitude,
- t.mac,
- t.state
+ t.latitude as latitude,
+ t.longitude as longitude,
+ t.mac as mac,
+ t.state,(hf.value ->> #{type} )+0 as ${sensorCode}
FROM
device t
- inner JOIN monitor_point p on p.id = t.monitor_point_id and p.is_delete = 0
+ inner JOIN monitor_point p on p.id = t.monitor_point_id and p.is_delete = 0
and p.organization_id in (
- SELECT t1.id FROM organization t1
- where t1.id = #{organizationId} or t1.parent_id = #{organizationId})
+ SELECT id FROM (
+ SELECT id, parent_id, name FROM organization WHERE id = #{organizationId}
+ UNION ALL
+ SELECT i.id, i.parent_id, i.name
+ FROM organization i
+ INNER JOIN (
+ SELECT * FROM (
+ SELECT id, parent_id, name FROM organization WHERE id = #{organizationId}
+ UNION ALL
+ SELECT id, parent_id, name FROM organization WHERE parent_id = #{organizationId}
+ ) t1
+ ) t2 ON i.parent_id = t2.id
+ where i.is_delete = 0
+ ) t3
+ )
<if test="region != null">
- and ${region} = #{regionCode}
+ and p.${region} = #{regionCode}
</if>
+ <if test="endHourlyTime !=null and endHourlyTime != ''">
+ left join history_hourly_${times} hf on hf.time =#{endHourlyTime} and t.mac = hf.mac
+ </if>
+ <if test="endHourlyTime ==null">
+ left join history_five_minutely_${times} hf on hf.time = (select max(time) from history_five_minutely_${times} LIMIT 1
+ ) and t.mac = hf.mac
+ </if>
+
+
WHERE
t.state <![CDATA[ <> ]]> '0' and t.is_delete = 0
order by t.id desc
</select>
+
+ <select id="deviceIdList" resultType="java.lang.Integer">
+ SELECT
+ t.id
+ FROM
+ device t
+ INNER JOIN monitor_point p ON p.id = t.monitor_point_id
+ AND p.is_delete = 0
+ AND p.organization_id IN (
+ SELECT
+ id
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ i.id,
+ i.parent_id,
+ i.NAME
+ FROM
+ organization i
+ INNER JOIN (
+ SELECT
+ *
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ parent_id = #{organizationId}
+ ) t1
+ ) t2 ON i.parent_id = t2.id
+ WHERE
+ i.is_delete = 0
+ ) t3
+ )
+ WHERE
+ t.is_delete = 0
+ </select>
+
+ <select id="deviceOrgIdList" resultType="java.lang.Integer">
+ SELECT
+ id
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ i.id,
+ i.parent_id,
+ i.NAME
+ FROM
+ organization i
+ INNER JOIN (
+ SELECT
+ *
+ FROM
+ (
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ id = #{organizationId} UNION ALL
+ SELECT
+ id,
+ parent_id,
+ NAME
+ FROM
+ organization
+ WHERE
+ parent_id = #{organizationId}
+ ) t1
+ ) t2 ON i.parent_id = t2.id
+ WHERE
+ i.is_delete = 0
+ ) t3
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0