MonitorDatasynch.java 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415
  1. package com.zksy.environmentHJ212.utils;
  2. import com.zksy.environmentHJ212.domain.po.MinuteDataInfo;
  3. import com.zksy.environmentHJ212.domain.po.PsMonitorSz;
  4. import com.zksy.environmentHJ212.service.DayDataInfoService;
  5. import com.zksy.environmentHJ212.service.HourDataInfoService;
  6. import com.zksy.environmentHJ212.service.MinuteDataInfoService;
  7. import com.zksy.environmentHJ212.service.PsMonitorSzService;
  8. import io.netty.channel.ChannelHandlerContext;
  9. import lombok.extern.slf4j.Slf4j;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.context.annotation.Scope;
  12. import org.springframework.stereotype.Service;
  13. import java.net.InetSocketAddress;
  14. import java.time.LocalDateTime;
  15. import java.util.*;
  16. import java.util.function.BiConsumer;
  17. import java.util.function.Consumer;
  18. import java.util.function.Function;
  19. import java.util.function.Supplier;
  20. import java.util.stream.Collectors;
  21. import static org.springframework.beans.factory.config.BeanDefinition.SCOPE_PROTOTYPE;
  22. /**
  23. * @Description
  24. * @Date 2021- 06-01-下午 14:37
  25. * @auther Javen
  26. */
  27. @Service
  28. @Slf4j
  29. @Scope(SCOPE_PROTOTYPE)
  30. public class MonitorDatasynch {
  31. private final PsMonitorSzService psMonitorSzService;
  32. private final MinuteDataInfoService minuteDataInfoService;
  33. private final HourDataInfoService hourDataInfoService;
  34. private final DayDataInfoService dayDataInfoService;
  35. @Autowired
  36. public MonitorDatasynch(PsMonitorSzService psMonitorSzService, MinuteDataInfoService minuteDataInfoService, HourDataInfoService hourDataInfoService, DayDataInfoService dayDataInfoService) {
  37. this.psMonitorSzService = psMonitorSzService;
  38. this.minuteDataInfoService = minuteDataInfoService;
  39. this.hourDataInfoService = hourDataInfoService;
  40. this.dayDataInfoService = dayDataInfoService;
  41. }
  42. private static LinkedHashMap<String, String> fieldMap = new LinkedHashMap<>();
  43. static {
  44. fieldMap.put("a01001", "TEMP");// 温度
  45. fieldMap.put("a01002", "HUMIDITY");// 湿度
  46. fieldMap.put("DataTime", "SAMPLETIME");// 采样时间
  47. fieldMap.put("CN", "CN");// 命令编码
  48. fieldMap.put("ST", "ST");// 系统编码
  49. fieldMap.put("MN", "MN");// 设备唯一标志
  50. }
  51. /**
  52. * 获取水质同步数据,数据有效性校验,解析
  53. */
  54. public String pushMonitorData(ChannelHandlerContext channelHandlerContext, String oldDataStr){
  55. log.info("==========接收到数据:" + oldDataStr + "==========");
  56. MinuteDataInfo monitordata = null;
  57. String response = null;
  58. if (oldDataStr.length() > 6) {
  59. String lenstr = oldDataStr.substring(2, 6);
  60. // 获取数据长度
  61. int codeLen = Integer.parseInt(lenstr);
  62. log.info("数据主体长度:" + codeLen);
  63. // 获取数据正文
  64. String dataStr = oldDataStr.substring(6, oldDataStr.length()-6);
  65. log.info("数据主体正文:" + dataStr);
  66. // 获取数据CRC16检验码
  67. String code = oldDataStr.substring(oldDataStr.length()-6, oldDataStr.length()-2);
  68. log.info(code);
  69. // 通过数据生成CRC16校验码
  70. String nowCode = DataCheckUtil.crc16_Checkout(dataStr, codeLen);
  71. log.info("==========自带的验证码:" + code + "新生成的验证码:" + nowCode);
  72. // 前后crc16校验码比对(true-数据传输无问题,false-数据传输出现问题)
  73. if (code.equals(nowCode)) {
  74. try {
  75. String[] dataArr = dataStr.split(";");
  76. List<String> collect = Arrays.asList(dataArr).stream().filter(item -> item.contains("CN=")).collect(Collectors.toList());
  77. String cn = "";
  78. if (collect != null && collect.size() > 0) {
  79. cn = collect.get(0);
  80. }
  81. // 判断是实时数据(2011)
  82. if ("2011".equals(cn.substring(3))) {
  83. String host = ((InetSocketAddress)channelHandlerContext.channel().remoteAddress()).getAddress().getHostAddress();
  84. int port = ((InetSocketAddress)channelHandlerContext.channel().remoteAddress()).getPort();
  85. String ipPort = host+":"+port;
  86. List<PsMonitorSz> psMonitorSzList = psMonitorSzService.pushMonitorData(oldDataStr,dataArr,ipPort);
  87. psMonitorSzService.saveBatch(psMonitorSzList);
  88. } else if ("2051".equals(cn.substring(3))){
  89. //分钟数据
  90. minuteDataInfoService.saveMonitordata(oldDataStr,dataArr);
  91. }else if ("2061".equals(cn.substring(3))){
  92. //小时数据
  93. hourDataInfoService.saveHourData(oldDataStr,dataArr);
  94. }else if ("2031".equals(cn.substring(3))){
  95. //日数据
  96. dayDataInfoService.saveDayData(oldDataStr,dataArr);
  97. }else {
  98. log.info("其它数据========", oldDataStr);
  99. }
  100. } catch (Exception e) {
  101. log.info("==========数据解析错误==========", oldDataStr);
  102. e.printStackTrace();
  103. }
  104. } else {
  105. log.info("==========数据传输错误,验证不匹配==========", oldDataStr);
  106. }
  107. } else {
  108. log.info("==========数据长度格式不正确==========");
  109. }
  110. return response;
  111. }
  112. /*public static List<MinuteDataInfo> minuteDataInfoData(String oldDataStr,String[] dataArr) {
  113. ArrayList<String> arrayList = new ArrayList<>();
  114. List<MinuteDataInfo> minuteDataInfolist = new ArrayList<>();
  115. for (String param : dataArr) {
  116. System.out.println("param = " + param);
  117. String String = "&&";
  118. boolean contains = param.contains(String);
  119. if (contains) {
  120. param = param.replace(String, ",");
  121. }
  122. if (param.contains(",")) {
  123. arrayList.add(param);
  124. }
  125. }
  126. ArrayList<String> objects = new ArrayList<>();
  127. for (String entity : arrayList) {
  128. String substring = null;
  129. if (entity.contains("-")) {
  130. substring = entity.substring(0, entity.indexOf("-"));
  131. }
  132. if (StringUtils.isBlank(substring)) {
  133. continue;
  134. }
  135. if (entity.startsWith(substring)) {
  136. objects.add(substring);
  137. String[] split = entity.split(",");
  138. MinuteDataInfo minuteDataInfo = new MinuteDataInfo();
  139. minuteDataInfo.setRemark(oldDataStr);
  140. for (String parameters : split) {
  141. String[] split1 = parameters.split("=");
  142. minuteDataInfo.setCode(substring);
  143. if (parameters.startsWith(substring + "-Cou=")) {
  144. minuteDataInfo.setDataCouValue(new BigDecimal(split1[1]));
  145. }
  146. if (parameters.startsWith(substring + "-Min=")) {
  147. minuteDataInfo.setDataMinValue(new BigDecimal(split1[1]));
  148. }
  149. if (parameters.startsWith(substring + "-Avg=")) {
  150. minuteDataInfo.setDataAvgValue(new BigDecimal(split1[1]));
  151. }
  152. if (parameters.startsWith(substring + "-Max=")) {
  153. minuteDataInfo.setDataMaxValue(new BigDecimal(split1[1]));
  154. }
  155. if (parameters.startsWith(substring + "-Flag=")) {
  156. minuteDataInfo.setDataFlag(split1[1]);
  157. }
  158. minuteDataInfo.setCreateTime(LocalDateTime.now());
  159. minuteDataInfo.setId(UUID.randomUUID().toString().replace("-", ""));
  160. for (String comParams : dataArr) {
  161. if (comParams.contains("&&") && !comParams.contains(",")) {
  162. String replace = comParams.replace("&&", ",");
  163. String[] split2 = replace.split(",");
  164. if (split2.length>1) {
  165. String dateString = split2[1];
  166. if (dateString.startsWith("DataTime=")) {
  167. minuteDataInfo.setDataTime(DateTimeUtil.parseDateTime(dateString.split("=")[1]));
  168. }
  169. }
  170. }
  171. String[] comsplit1 = comParams.split("=");
  172. String paraname = comsplit1[0];
  173. String value = comsplit1[1];
  174. if (paraname.equals("MN")) {
  175. minuteDataInfo.setMn(value);
  176. }
  177. if (paraname.equals("Flag")) {
  178. minuteDataInfo.setFlag(value);
  179. }
  180. }
  181. }
  182. minuteDataInfolist.add(minuteDataInfo);
  183. }
  184. }
  185. return minuteDataInfolist;
  186. }*/
  187. public static <T> List<T> parseData(String oldDataStr, String[] dataArr, Supplier<T> entitySupplier,
  188. Consumer<EntityFieldMapperBuilder<T>> configurer) {
  189. EntityFieldMapperBuilder<T> builder = new EntityFieldMapperBuilder<>(entitySupplier);
  190. configurer.accept(builder);
  191. EntityFieldMapper<T> mapper = builder.build();
  192. List<String> validParams = extractValidParams(dataArr);
  193. Map<String, String> commonParams = extractCommonParams(dataArr);
  194. List<T> entityList = new ArrayList<>();
  195. for (String entityParam : validParams) {
  196. String code = extractCode(entityParam);
  197. if (code == null) {
  198. continue;
  199. }
  200. T entity = mapper.createEntity();
  201. mapper.setCode(entity, code);
  202. mapper.setRemark(entity, oldDataStr);
  203. String[] parameters = entityParam.split(",");
  204. for (String param : parameters) {
  205. String[] keyValue = param.split("=", 2);
  206. if (keyValue.length != 2) {
  207. continue;
  208. }
  209. mapper.mapField(entity, code, keyValue[0], keyValue[1]);
  210. }
  211. mapper.setCommonFields(entity, commonParams);
  212. mapper.setCreateTime(entity);
  213. mapper.setId(entity);
  214. entityList.add(entity);
  215. }
  216. return entityList;
  217. }
  218. private static List<String> extractValidParams(String[] dataArr) {
  219. List<String> validParams = new ArrayList<>();
  220. for (String param : dataArr) {
  221. if (param.contains("&&")) {
  222. param = param.replace("&&", ",");
  223. }
  224. if (param.contains(",")) {
  225. validParams.add(param);
  226. }
  227. }
  228. return validParams;
  229. }
  230. private static Map<String, String> extractCommonParams(String[] dataArr) {
  231. Map<String, String> commonParams = new HashMap<>();
  232. for (String param : dataArr) {
  233. if (param.contains("&&") && !param.contains(",")) {
  234. String[] parts = param.replace("&&", ",").split(",");
  235. if (parts.length > 1 && parts[1].startsWith("DataTime=")) {
  236. commonParams.put("DataTime", parts[1].substring("DataTime=".length()));
  237. }
  238. }
  239. String[] keyValue = param.split("=", 2);
  240. if (keyValue.length == 2) {
  241. commonParams.put(keyValue[0], keyValue[1]);
  242. }
  243. }
  244. return commonParams;
  245. }
  246. private static String extractCode(String entityParam) {
  247. if (entityParam.contains("-")) {
  248. return entityParam.substring(0, entityParam.indexOf("-"));
  249. }
  250. return null;
  251. }
  252. public static class EntityFieldMapperBuilder<T> {
  253. private final Supplier<T> entitySupplier;
  254. private final Map<String, BiConsumer<T, Object>> fieldMappers = new HashMap<>();
  255. private BiConsumer<T, String> codeMapper;
  256. private BiConsumer<T, String> remarkMapper;
  257. private BiConsumer<T, String> mnMapper;
  258. private BiConsumer<T, String> flagMapper;
  259. private BiConsumer<T, String> dataTimeMapper;
  260. private BiConsumer<T, LocalDateTime> createTimeMapper;
  261. private BiConsumer<T, String> idMapper;
  262. public EntityFieldMapperBuilder(Supplier<T> entitySupplier) {
  263. this.entitySupplier = entitySupplier;
  264. }
  265. public <V> EntityFieldMapperBuilder<T> addFieldMapper(String suffix, BiConsumer<T, V> setter, Function<String, V> converter) {
  266. fieldMappers.put(suffix, (entity, value) -> setter.accept(entity, converter.apply((String) value)));
  267. return this;
  268. }
  269. public EntityFieldMapperBuilder<T> setCodeMapper(BiConsumer<T, String> codeMapper) {
  270. this.codeMapper = codeMapper;
  271. return this;
  272. }
  273. public EntityFieldMapperBuilder<T> setRemarkMapper(BiConsumer<T, String> remarkMapper) {
  274. this.remarkMapper = remarkMapper;
  275. return this;
  276. }
  277. public EntityFieldMapperBuilder<T> setMnMapper(BiConsumer<T, String> mnMapper) {
  278. this.mnMapper = mnMapper;
  279. return this;
  280. }
  281. public EntityFieldMapperBuilder<T> setFlagMapper(BiConsumer<T, String> flagMapper) {
  282. this.flagMapper = flagMapper;
  283. return this;
  284. }
  285. public EntityFieldMapperBuilder<T> setDataTimeMapper(BiConsumer<T, String> dataTimeMapper) {
  286. this.dataTimeMapper = dataTimeMapper;
  287. return this;
  288. }
  289. public EntityFieldMapperBuilder<T> setCreateTimeMapper(BiConsumer<T, LocalDateTime> createTimeMapper) {
  290. this.createTimeMapper = createTimeMapper;
  291. return this;
  292. }
  293. public EntityFieldMapperBuilder<T> setIdMapper(BiConsumer<T, String> idMapper) {
  294. this.idMapper = idMapper;
  295. return this;
  296. }
  297. public EntityFieldMapper<T> build() {
  298. return new EntityFieldMapper<>(
  299. entitySupplier, fieldMappers, codeMapper, remarkMapper,
  300. mnMapper, flagMapper, dataTimeMapper, createTimeMapper, idMapper
  301. );
  302. }
  303. }
  304. public static class EntityFieldMapper<T> {
  305. private final Supplier<T> entitySupplier;
  306. private final Map<String, BiConsumer<T, Object>> fieldMappers;
  307. private final BiConsumer<T, String> codeMapper;
  308. private final BiConsumer<T, String> remarkMapper;
  309. private final BiConsumer<T, String> mnMapper;
  310. private final BiConsumer<T, String> flagMapper;
  311. private final BiConsumer<T, String> dataTimeMapper;
  312. private final BiConsumer<T, LocalDateTime> createTimeMapper;
  313. private final BiConsumer<T, String> idMapper;
  314. public EntityFieldMapper(
  315. Supplier<T> entitySupplier, Map<String, BiConsumer<T, Object>> fieldMappers,
  316. BiConsumer<T, String> codeMapper, BiConsumer<T, String> remarkMapper,
  317. BiConsumer<T, String> mnMapper, BiConsumer<T, String> flagMapper,
  318. BiConsumer<T, String> dataTimeMapper, BiConsumer<T, LocalDateTime> createTimeMapper,
  319. BiConsumer<T, String> idMapper) {
  320. this.entitySupplier = entitySupplier;
  321. this.fieldMappers = fieldMappers;
  322. this.codeMapper = codeMapper;
  323. this.remarkMapper = remarkMapper;
  324. this.mnMapper = mnMapper;
  325. this.flagMapper = flagMapper;
  326. this.dataTimeMapper = dataTimeMapper;
  327. this.createTimeMapper = createTimeMapper;
  328. this.idMapper = idMapper;
  329. }
  330. public T createEntity() {
  331. return entitySupplier.get();
  332. }
  333. public void setCode(T entity, String code) {
  334. if (codeMapper != null) {
  335. codeMapper.accept(entity, code);
  336. }
  337. }
  338. public void setRemark(T entity, String remark) {
  339. if (remarkMapper != null) {
  340. remarkMapper.accept(entity, remark);
  341. }
  342. }
  343. public void mapField(T entity, String code, String key, String value) {
  344. for (Map.Entry<String, BiConsumer<T, Object>> entry : fieldMappers.entrySet()) {
  345. String suffix = entry.getKey();
  346. BiConsumer<T, Object> mapper = entry.getValue();
  347. if (key.equals(code + "-" + suffix)) {
  348. mapper.accept(entity, value);
  349. break;
  350. }
  351. }
  352. }
  353. public void setCommonFields(T entity, Map<String, String> commonParams) {
  354. if (mnMapper != null && commonParams.containsKey("MN")) {
  355. mnMapper.accept(entity, commonParams.get("MN"));
  356. }
  357. if (flagMapper != null && commonParams.containsKey("Flag")) {
  358. flagMapper.accept(entity, commonParams.get("Flag"));
  359. }
  360. if (dataTimeMapper != null && commonParams.containsKey("DataTime")) {
  361. dataTimeMapper.accept(entity, commonParams.get("DataTime"));
  362. }
  363. }
  364. public void setCreateTime(T entity) {
  365. if (createTimeMapper != null) {
  366. createTimeMapper.accept(entity, LocalDateTime.now());
  367. }
  368. }
  369. public void setId(T entity) {
  370. if (idMapper != null) {
  371. idMapper.accept(entity, UUID.randomUUID().toString().replace("-", ""));
  372. }
  373. }
  374. }
  375. }