WaterImmersionDevInfoServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323
  1. package com.welampiot.service.impl;
  2. import com.welampiot.dao.WaterImmersionDevInfoDao;
  3. import com.welampiot.dto.WaterImmersionDevInfoDTO;
  4. import com.welampiot.dto.WaterImmersionDevInfoLogDTO;
  5. import com.welampiot.service.WaterImmersionDevInfoService;
  6. import com.welampiot.vo.WaterImmersionDevInfoLogVO;
  7. import com.welampiot.vo.WaterImmersionDevInfoVO;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Service;
  10. import java.text.ParseException;
  11. import java.text.SimpleDateFormat;
  12. import java.util.ArrayList;
  13. import java.util.Date;
  14. import java.util.HashMap;
  15. import java.util.List;
  16. /**
  17. * ClassName: WaterImmersionDevInfoServiceImpl
  18. * Package: com.welampiot.service.impl
  19. * Description:
  20. *
  21. * @Author: zhj_Start
  22. * @Create: 2023/4/19 - 12:45
  23. * @Version: v1.0
  24. */
  25. @Service
  26. public class WaterImmersionDevInfoServiceImpl implements WaterImmersionDevInfoService {
  27. @Autowired
  28. private WaterImmersionDevInfoDao waterImmersionDevInfoDao;
  29. @Override
  30. public WaterImmersionDevInfoVO getWaterImmersionList(WaterImmersionDevInfoDTO dto, Integer version) {
  31. WaterImmersionDevInfoVO vo = new WaterImmersionDevInfoVO();
  32. vo.setTotal(waterImmersionDevInfoDao.getDeviceTotalByDTO(dto));
  33. List<WaterImmersionDevInfoDTO> waterImmersionList = waterImmersionDevInfoDao.getWaterImmersionListByDTO(dto);
  34. List<WaterImmersionDevInfoDTO> list = new ArrayList<>();
  35. SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  36. waterImmersionList.forEach(waterImmersionDTO ->{
  37. //灯杆名
  38. if (waterImmersionDTO.getLampPoleName() == null){
  39. waterImmersionDTO.setLampPoleName("");
  40. }
  41. //区域名
  42. if (version == 0){
  43. if (waterImmersionDTO.getChArea() != null){
  44. waterImmersionDTO.setArea(waterImmersionDTO.getChArea());
  45. }else {
  46. waterImmersionDTO.setArea("");
  47. }
  48. }else if (version == 1){
  49. if (waterImmersionDTO.getEnArea() != null){
  50. waterImmersionDTO.setArea(waterImmersionDTO.getEnArea());
  51. }else {
  52. waterImmersionDTO.setArea("");
  53. }
  54. }else {
  55. if (waterImmersionDTO.getRuArea() != null){
  56. waterImmersionDTO.setArea(waterImmersionDTO.getRuArea());
  57. }else {
  58. waterImmersionDTO.setArea("");
  59. }
  60. }
  61. //路段名
  62. if (waterImmersionDTO.getSection() == null){
  63. waterImmersionDTO.setSection("");
  64. }
  65. //设备型号(0 RS-SJ-R01-4,1 RS485-WT10)
  66. if (waterImmersionDTO.getModel() != null && waterImmersionDTO.getModel() == 1){
  67. waterImmersionDTO.setModel(1);
  68. }else {
  69. waterImmersionDTO.setModel(0);
  70. }
  71. //网络状态(0:离线,1:在线)
  72. if (waterImmersionDTO.getStatus() != null && waterImmersionDTO.getStatus() == 1){
  73. waterImmersionDTO.setStatus(1);
  74. }else {
  75. waterImmersionDTO.setStatus(0);
  76. }
  77. //水浸探针1(0 正常,1 浸水)
  78. if (waterImmersionDTO.getProbe1() != null && waterImmersionDTO.getProbe1() == 1){
  79. waterImmersionDTO.setProbe1(1);
  80. }else {
  81. waterImmersionDTO.setProbe1(0);
  82. }
  83. //水浸探针2(0 正常,1 浸水)
  84. if (waterImmersionDTO.getProbe2() != null && waterImmersionDTO.getProbe2() == 1){
  85. waterImmersionDTO.setProbe2(1);
  86. }else {
  87. waterImmersionDTO.setProbe2(0);
  88. }
  89. //报警等级(0: 一级,1: 二级,2: 三级)
  90. if (waterImmersionDTO.getLevel() != null && waterImmersionDTO.getLevel() == 2){
  91. waterImmersionDTO.setLevel(2);
  92. }else if (waterImmersionDTO.getLevel() != null && waterImmersionDTO.getLevel() == 1){
  93. waterImmersionDTO.setLevel(1);
  94. }else {
  95. waterImmersionDTO.setLevel(0);
  96. }
  97. //关联设备是否要断电(0: 否,1:是)
  98. if (waterImmersionDTO.getPowerStatus() != null && waterImmersionDTO.getPowerStatus() == 1){
  99. waterImmersionDTO.setPowerStatus(1);
  100. }else {
  101. waterImmersionDTO.setPowerStatus(0);
  102. }
  103. //厂家(0:建大仁科,1:红斯迈科技,2:云之声)
  104. if (waterImmersionDTO.getFactory() != null && waterImmersionDTO.getFactory() == 2){
  105. waterImmersionDTO.setFactory(2);
  106. }else if (waterImmersionDTO.getFactory() != null && waterImmersionDTO.getFactory() == 1){
  107. waterImmersionDTO.setFactory(1);
  108. }else {
  109. waterImmersionDTO.setFactory(0);
  110. }
  111. //云盒的型号(0 G100,1 G200,2 G300)
  112. if (waterImmersionDTO.getCloudBoxModel() != null && waterImmersionDTO.getCloudBoxModel() == 2){
  113. waterImmersionDTO.setCloudBoxModel(2);
  114. }else if (waterImmersionDTO.getCloudBoxModel() != null && waterImmersionDTO.getCloudBoxModel() == 1){
  115. waterImmersionDTO.setCloudBoxModel(1);
  116. }else {
  117. waterImmersionDTO.setCloudBoxModel(0);
  118. }
  119. //创建时间
  120. if (waterImmersionDTO.getCreateTime() != null && !waterImmersionDTO.getCreateTime().equals("")){
  121. try {
  122. waterImmersionDTO.setCreateTime(simpleDateFormat.format(simpleDateFormat.parse(waterImmersionDTO.getCreateTime())));
  123. } catch (ParseException e) {
  124. throw new RuntimeException(e);
  125. }
  126. }else {
  127. waterImmersionDTO.setCreateTime("");
  128. }
  129. //安装时间
  130. if (waterImmersionDTO.getInstallDate() != null && !waterImmersionDTO.getInstallDate().equals("")){
  131. try {
  132. waterImmersionDTO.setInstallDate(simpleDateFormat.format(simpleDateFormat.parse(waterImmersionDTO.getInstallDate())));
  133. } catch (ParseException e) {
  134. throw new RuntimeException(e);
  135. }
  136. }else {
  137. waterImmersionDTO.setInstallDate("");
  138. }
  139. //过期时间
  140. if (waterImmersionDTO.getExpirationDate() != null && !waterImmersionDTO.getExpirationDate().equals("")){
  141. try {
  142. waterImmersionDTO.setExpirationDate(simpleDateFormat.format(simpleDateFormat.parse(waterImmersionDTO.getExpirationDate())));
  143. } catch (ParseException e) {
  144. throw new RuntimeException(e);
  145. }
  146. }else {
  147. waterImmersionDTO.setExpirationDate("");
  148. }
  149. //更新时间
  150. if (waterImmersionDTO.getUpdateTime() != null && !waterImmersionDTO.getUpdateTime().equals("")){
  151. Date cmdTime;
  152. try {
  153. cmdTime = simpleDateFormat.parse(waterImmersionDTO.getUpdateTime());
  154. } catch (ParseException e) {
  155. throw new RuntimeException(e);
  156. }
  157. //判断时区,为null默认东八区
  158. long timezone = waterImmersionDTO.getTimezone() == null ? 8 : waterImmersionDTO.getTimezone();
  159. long l = cmdTime.getTime() + timezone * 3600 * 1000;
  160. cmdTime = new Date(l);
  161. waterImmersionDTO.setUpdateTime(simpleDateFormat.format(cmdTime));
  162. }else {
  163. waterImmersionDTO.setUpdateTime("");
  164. }
  165. list.add(waterImmersionDTO);
  166. });
  167. vo.setList(list);
  168. return vo;
  169. }
  170. @Override
  171. public WaterImmersionDevInfoLogVO getLogList(WaterImmersionDevInfoLogDTO dto) {
  172. WaterImmersionDevInfoLogVO vo = new WaterImmersionDevInfoLogVO();
  173. vo.setTotal(waterImmersionDevInfoDao.getDeviceTotalByDTO(dto));
  174. SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  175. //开始时间
  176. if (dto.getBeginTime() != null && !dto.getBeginTime().equals("")){
  177. Date cmdTime;
  178. try {
  179. cmdTime = simpleDateFormat.parse(dto.getBeginTime());
  180. } catch (ParseException e) {
  181. throw new RuntimeException(e);
  182. }
  183. //判断时区,为null默认东八区
  184. long timezone = waterImmersionDevInfoDao.getTimezoneById(dto) == null ? 8 : waterImmersionDevInfoDao.getTimezoneById(dto);
  185. long l = cmdTime.getTime() - timezone * 3600 * 1000;
  186. cmdTime = new Date(l);
  187. dto.setBeginTime(simpleDateFormat.format(cmdTime));
  188. }else {
  189. dto.setBeginTime("");
  190. }
  191. //结束时间
  192. if (dto.getEndTime() != null && !dto.getEndTime().equals("")){
  193. Date cmdTime;
  194. try {
  195. cmdTime = simpleDateFormat.parse(dto.getEndTime());
  196. } catch (ParseException e) {
  197. throw new RuntimeException(e);
  198. }
  199. //判断时区,为null默认东八区
  200. long timezone = waterImmersionDevInfoDao.getTimezoneById(dto) == null ? 8 : waterImmersionDevInfoDao.getTimezoneById(dto);
  201. long l = cmdTime.getTime() - timezone * 3600 * 1000;
  202. cmdTime = new Date(l);
  203. dto.setEndTime(simpleDateFormat.format(cmdTime));
  204. }else {
  205. dto.setEndTime("");
  206. }
  207. List<WaterImmersionDevInfoLogDTO> logList = waterImmersionDevInfoDao.getLogListByDTO(dto);
  208. List<WaterImmersionDevInfoLogDTO> list = new ArrayList<>();
  209. logList.forEach(logDTO ->{
  210. if (logDTO.getProbe1() != null && logDTO.getProbe1() == 1){
  211. logDTO.setProbe1(1);
  212. }else {
  213. logDTO.setProbe1(0);
  214. }
  215. if (logDTO.getProbe2() != null && logDTO.getProbe2() == 2){
  216. logDTO.setProbe2(1);
  217. }else {
  218. logDTO.setProbe2(0);
  219. }
  220. if (logDTO.getLevel() != null && logDTO.getLevel() == 2){
  221. logDTO.setLevel(2);
  222. }else if (logDTO.getLevel() != null && logDTO.getLevel() == 1){
  223. logDTO.setLevel(1);
  224. }else {
  225. logDTO.setLevel(0);
  226. }
  227. if (logDTO.getPowerStatus() != null && logDTO.getPowerStatus() == 1){
  228. logDTO.setPowerStatus(1);
  229. }else {
  230. logDTO.setPowerStatus(0);
  231. }
  232. //更新时间
  233. if (logDTO.getUpdateTime() != null && !logDTO.getUpdateTime().equals("")){
  234. Date cmdTime;
  235. try {
  236. cmdTime = simpleDateFormat.parse(logDTO.getUpdateTime());
  237. } catch (ParseException e) {
  238. throw new RuntimeException(e);
  239. }
  240. //判断时区,为null默认东八区
  241. long timezone = logDTO.getTimezone() == null ? 8 : logDTO.getTimezone();
  242. long l = cmdTime.getTime() + timezone * 3600 * 1000;
  243. cmdTime = new Date(l);
  244. logDTO.setUpdateTime(simpleDateFormat.format(cmdTime));
  245. }else {
  246. logDTO.setUpdateTime("");
  247. }
  248. list.add(logDTO);
  249. });
  250. vo.setList(list);
  251. return vo;
  252. }
  253. @Override
  254. public void updateWaterImmersionDataByDTO(WaterImmersionDevInfoDTO dto) {
  255. waterImmersionDevInfoDao.updateWaterImmersionDataByDTO(dto);
  256. }
  257. @Override
  258. public Integer findByWaterImmersionDTO(WaterImmersionDevInfoDTO dto) {
  259. return waterImmersionDevInfoDao.findByWaterImmersionDTO(dto);
  260. }
  261. @Override
  262. public Integer findSectionIdById(Integer id) {
  263. return waterImmersionDevInfoDao.findSectionIdById(id);
  264. }
  265. @Override
  266. public void deleteWaterImmersionDataByDTO(Integer id) {
  267. waterImmersionDevInfoDao.deleteWaterImmersionDataByDTO(id);
  268. this.deleteWaterImmersionLogDataByDTO(id);
  269. }
  270. @Override
  271. public void deleteWaterImmersionLogDataByDTO(Integer id) {
  272. waterImmersionDevInfoDao.deleteWaterImmersionLogDataByDTO(id);
  273. }
  274. @Override
  275. public WaterImmersionDevInfoDTO getWaterDTOById(Integer id) {
  276. return waterImmersionDevInfoDao.getWaterDTOById(id);
  277. }
  278. @Override
  279. public Integer getWaterImmersionTotal(WaterImmersionDevInfoDTO dto) {
  280. return waterImmersionDevInfoDao.getWaterImmersionTotal(dto);
  281. }
  282. @Override
  283. public Integer getWaterImmersionOnlineCount(WaterImmersionDevInfoDTO dto) {
  284. return waterImmersionDevInfoDao.getWaterImmersionOnlineCount(dto);
  285. }
  286. @Override
  287. public Integer getWaterImmersionAlarmCount(WaterImmersionDevInfoDTO dto) {
  288. return waterImmersionDevInfoDao.getWaterImmersionAlarmCount(dto);
  289. }
  290. @Override
  291. public Integer getWaterImmersionNewCount(WaterImmersionDevInfoDTO dto) {
  292. return waterImmersionDevInfoDao.getWaterImmersionNewCount(dto);
  293. }
  294. @Override
  295. public void updateDelayTimeByDto(WaterImmersionDevInfoDTO dto) {
  296. waterImmersionDevInfoDao.updateDelayTimeByDto(dto);
  297. }
  298. @Override
  299. public int getTotalBySectionList(WaterImmersionDevInfoDTO dto) {
  300. return waterImmersionDevInfoDao.getTotalBySectionList(dto);
  301. }
  302. @Override
  303. public WaterImmersionDevInfoDTO getOneWaterImmersion(HashMap<String,Object> map){
  304. return waterImmersionDevInfoDao.getOneWaterImmersion(map);
  305. }
  306. }