MonitorInfoController.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. package com.huaxu.controller;
  2. import com.huaxu.dto.*;
  3. import com.huaxu.entity.*;
  4. import com.huaxu.model.AjaxMessage;
  5. import com.huaxu.model.LoginUser;
  6. import com.huaxu.model.ResultStatus;
  7. import com.huaxu.service.*;
  8. import com.huaxu.util.ByteArrayUtils;
  9. import com.huaxu.util.RedisUtil;
  10. import com.huaxu.util.UserUtil;
  11. import io.swagger.annotations.Api;
  12. import io.swagger.annotations.ApiOperation;
  13. import io.swagger.annotations.ApiParam;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.stereotype.Controller;
  16. import org.springframework.validation.annotation.Validated;
  17. import org.springframework.ui.ModelMap;
  18. import java.time.LocalDateTime;
  19. import java.util.*;
  20. import java.util.stream.Collectors;
  21. import org.springframework.web.bind.annotation.*;
  22. import javax.jws.Oneway;
  23. /**
  24. * 标签信息页面控制器
  25. * @author WYY
  26. * @date 2020-12-02 09:29
  27. */
  28. @RestController
  29. @RequestMapping("/monitorinfo")
  30. @Api(tags = "标签信息")
  31. public class MonitorInfoController {
  32. @Autowired
  33. private MonitorInfoService monitorInfoService;
  34. @Autowired
  35. private DeviceParmService deviceParmService;
  36. @Autowired
  37. private RedisUtil redisUtil;
  38. @Autowired
  39. private SceneService sceneService;
  40. @Autowired
  41. private DeviceService deviceService;
  42. @Autowired
  43. private AlarmDetailsService alarmDetailsService;
  44. @ApiOperation(value = "按场景ID查询供水量出水量耗药量耗电量")
  45. @RequestMapping(value = "/findTotalUsageBySceneId",method = RequestMethod.GET)
  46. @ResponseBody
  47. public AjaxMessage<SceneUsageDto> findTotalUsageBySceneId(@ApiParam(value = "场景ID", required = true) @RequestParam Long id) {
  48. SceneUsageDto sceneUsageDto = new SceneUsageDto();
  49. //查询场景下的所有设备信息
  50. List<DeviceDto> devices = new ArrayList<>();
  51. DeviceDto deviceDto = new DeviceDto();
  52. deviceDto.setSceneIds(sceneService.findByParentIdsLike(id));
  53. devices.addAll(deviceService.selectList(deviceDto));
  54. //取前一个小时的时间
  55. LocalDateTime dateTime = LocalDateTime.now().plusDays(-1);
  56. for (DeviceDto item : devices) {
  57. //设备的几个参数值
  58. SceneDeviceAttributeDto sceneDeviceAttributeDto = new SceneDeviceAttributeDto();
  59. sceneDeviceAttributeDto.setDeviceId(item.getId());
  60. sceneDeviceAttributeDto.setYear(dateTime.getYear());
  61. sceneDeviceAttributeDto.setMonth(dateTime.getMonthValue());
  62. sceneDeviceAttributeDto.setDay(dateTime.getDayOfMonth());
  63. List<SceneDeviceAttributeDto> sceneDeviceAttributeDtos = monitorInfoService.findAttributeList(sceneDeviceAttributeDto);
  64. //取缓存里的数据
  65. byte[] bytes = redisUtil.get(("sms_water_" + item.getDeviceCode()).getBytes());
  66. if (bytes != null && bytes.length > 0) {
  67. MonitorDataEntity monitorDataEntity = (MonitorDataEntity) ByteArrayUtils.bytesToObject(bytes).get();
  68. //筛选该设备相同属性的值
  69. Map<Long, MonitorDataValueEntity> map = new HashMap<>();
  70. //将缓存中的实时数据放到map中方便进行遍历
  71. for (MonitorDataValueEntity dateValue : monitorDataEntity.getDataValues()) {
  72. map.put(dateValue.getAttributeId(), dateValue);
  73. }
  74. for (SceneDeviceAttributeDto itemAttribute : sceneDeviceAttributeDtos) {
  75. Double attributeDiffValue = 0d;
  76. if(!map.containsKey(itemAttribute.getAttributeId()))
  77. continue;
  78. if (map.get(itemAttribute.getAttributeId()).getDataValue() != null && itemAttribute.getLatestValue() != null) {
  79. attributeDiffValue = map.get(itemAttribute.getAttributeId()).getDataValue() - itemAttribute.getLatestValue();
  80. } else if (map.get(itemAttribute.getAttributeId()).getDataValue() != null && itemAttribute.getLatestValue() == null) {
  81. attributeDiffValue = map.get(itemAttribute.getAttributeId()).getDataValue();
  82. }
  83. switch (itemAttribute.getAttributeType()) {
  84. case "3":
  85. sceneUsageDto.setYieldWaterUsage(sceneUsageDto.getYieldWaterUsage() != null ? sceneUsageDto.getYieldWaterUsage() + attributeDiffValue : attributeDiffValue);
  86. break;
  87. case "4":
  88. sceneUsageDto.setIntakeWaterUsage(sceneUsageDto.getIntakeWaterUsage() != null ? sceneUsageDto.getIntakeWaterUsage() + attributeDiffValue : attributeDiffValue);
  89. break;
  90. case "5":
  91. sceneUsageDto.setPowerUsage(sceneUsageDto.getPowerUsage() != null ? sceneUsageDto.getPowerUsage() + attributeDiffValue : attributeDiffValue);
  92. break;
  93. case "6":
  94. sceneUsageDto.setDrugUsage(sceneUsageDto.getDrugUsage() != null ? sceneUsageDto.getDrugUsage() + attributeDiffValue : attributeDiffValue);
  95. break;
  96. }
  97. }
  98. }
  99. }
  100. return new AjaxMessage<>(ResultStatus.OK);
  101. }
  102. @ApiOperation(value = "按场景ID查询所有标签信息")
  103. @RequestMapping(value = "/findBySceneId",method = RequestMethod.GET)
  104. @ResponseBody
  105. public AjaxMessage<List<MonitorInfoEntity>> findBySceneId(
  106. @ApiParam(value = "场景ID", required = true) @RequestParam Long id,
  107. @ApiParam(value = "图片类型(0鸟瞰图 1工艺图)", required = false) @RequestParam(required = false) Integer imageType,
  108. @ApiParam(value = "设备ID", required = false) @RequestParam(required = false) Long deviceId
  109. ) {
  110. MonitorInfoEntity monitorInfoEntity = new MonitorInfoEntity();
  111. monitorInfoEntity.setSceneId(id);
  112. if (imageType != null) {
  113. monitorInfoEntity.setImageType(imageType);
  114. }
  115. if (deviceId != null) {
  116. monitorInfoEntity.setDeviceId(deviceId);
  117. }
  118. List<MonitorInfoEntity> page = monitorInfoService.findList(monitorInfoEntity);
  119. for (MonitorInfoEntity item : page) {
  120. if (item.getMonitorType().equals(0L)) {
  121. //查询报警信息
  122. List<AlarmDetailsDto> alarmDetailsDtos = alarmDetailsService.selectByDeviceId(item.getDeviceId().intValue());
  123. Map<Integer, AlarmDetailsDto> mapAlarm = new HashMap<>();
  124. //将缓存中的实时数据放到map中方便进行遍历
  125. for (AlarmDetailsDto alarmDetailsDto : alarmDetailsDtos) {
  126. mapAlarm.put(alarmDetailsDto.getAttributeId(), alarmDetailsDto);
  127. }
  128. byte[] bytes = redisUtil.get(("sms_water_" + item.getDeviceCode()).getBytes());
  129. if (bytes != null && bytes.length > 0) {
  130. MonitorDataEntity monitorDataEntity = (MonitorDataEntity) ByteArrayUtils.bytesToObject(bytes).get();
  131. Map<Long, MonitorDataValueEntity> map = new HashMap<>();
  132. //将缓存中的实时数据放到map中方便进行遍历
  133. for (MonitorDataValueEntity dateValue : monitorDataEntity.getDataValues()) {
  134. map.put(dateValue.getAttributeId(), dateValue);
  135. }
  136. //判断如果是标签则进行map中取值
  137. if (item.getMonitorType().equals(0L))//标签
  138. {
  139. item.setMonitorValue(map.get(item.getAttributeId()).getDataValue() + map.get(item.getAttributeId()).getUnit());
  140. //判断是否报警
  141. if (mapAlarm.containsKey(item.getAttributeId()))
  142. item.setIsAlarm(1);
  143. else
  144. item.setIsAlarm(0);
  145. }
  146. }
  147. }
  148. }
  149. return new AjaxMessage<>(ResultStatus.OK, page);
  150. }
  151. @RequestMapping(value="getDeviceParmByDeviceId" , method = RequestMethod.GET)
  152. @ApiOperation(value = "查询单个设备参数信息(标签设置)")
  153. public AjaxMessage<List<DeviceParmEntity>> getByDeviceId(@ApiParam(value = "设备id") @RequestParam Integer id){
  154. return new AjaxMessage<>(ResultStatus.OK, deviceParmService.selectByDeviceIdForGis(id));
  155. }
  156. /**
  157. * 新增
  158. */
  159. @ApiOperation(value = "单个新增")
  160. @RequestMapping(value = "/add", method = RequestMethod.POST)
  161. @ResponseBody
  162. public AjaxMessage<Integer> addMonitorInfo(@ApiParam(value = "标签信息", required = true) @RequestBody MonitorInfoEntity monitorInfo) {
  163. //校验参数
  164. int result = monitorInfoService.addMonitorInfo(monitorInfo) ? 1 : 0;
  165. return new AjaxMessage<>(ResultStatus.OK, result);
  166. }
  167. /**
  168. * 批量新增
  169. */
  170. @RequestMapping(value = "/batchAdd", method = RequestMethod.POST)
  171. @ResponseBody
  172. @ApiOperation(value = "批量新增或修改(按设备)")
  173. public AjaxMessage<Integer> addMonitorInfo(@ApiParam(value = "标签信息", required = true) @RequestBody ArrayList<MonitorInfoEntity> monitorInfos) {
  174. LoginUser currentUser = UserUtil.getCurrentUser();
  175. for (MonitorInfoEntity item : monitorInfos) {
  176. item.setTenantId(currentUser.getTenantId());
  177. item.setStatus(1);
  178. item.setDateCreate(new Date());
  179. item.setDateUpdate(new Date());
  180. item.setCreateBy(currentUser.getName());
  181. item.setUpdateBy(currentUser.getName());
  182. }
  183. int result = monitorInfoService.saveOrUpdateBatch(monitorInfos) ? 1 : 0;
  184. return new AjaxMessage<>(ResultStatus.OK, result);
  185. }
  186. /**
  187. * 修改
  188. */
  189. @ApiOperation(value = "按ID查询标签")
  190. @RequestMapping(value = "/selectById", method = RequestMethod.GET)
  191. public AjaxMessage<MonitorInfoEntity> selectById(@ApiParam(value = "ID", required = true) @RequestParam Long id) {
  192. MonitorInfoEntity monitorInfo = monitorInfoService.findMonitorInfoById(id);
  193. return new AjaxMessage<>(ResultStatus.OK, monitorInfo);
  194. }
  195. /**
  196. * 修改保存标签信息
  197. */
  198. @ApiOperation(value = "单个编辑")
  199. @RequestMapping(value = "/edit", method = RequestMethod.POST)
  200. @ResponseBody
  201. public AjaxMessage<Integer> editMonitorInfo(@ApiParam(value = "标签信息", required = true) @RequestBody MonitorInfoEntity monitorInfo) {
  202. int result = monitorInfoService.updateMonitorInfoById(monitorInfo) ? 1 : 0;
  203. return new AjaxMessage<>(ResultStatus.OK, result);
  204. }
  205. /**
  206. * 删除
  207. */
  208. @ApiOperation(value = "批量删除")
  209. @RequestMapping(value = "/deleteByIds", method = RequestMethod.POST)
  210. @ResponseBody
  211. public AjaxMessage<Integer> del(@ApiParam(value = "场景类型ID", required = true) @RequestBody Long[] ids) {
  212. int result = monitorInfoService.delMonitorInfoByIds(ids) ? 1 : 0;
  213. return new AjaxMessage<>(ResultStatus.OK, result);
  214. }
  215. }