EnergyDataController.java 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599
  1. package com.huimv.admin.controller;
  2. import cn.hutool.core.util.ObjectUtil;
  3. import cn.hutool.http.HttpRequest;
  4. import com.alibaba.fastjson.JSON;
  5. import com.alibaba.fastjson.JSONArray;
  6. import com.alibaba.fastjson.JSONObject;
  7. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  8. import com.huimv.admin.common.token.TokenSign;
  9. import com.huimv.admin.common.utils.Result;
  10. import com.huimv.admin.common.utils.ResultCode;
  11. import com.huimv.admin.entity.BaseFarm;
  12. import com.huimv.admin.entity.EnergyData;
  13. import com.huimv.admin.entity.EnergyEnvDevice;
  14. import com.huimv.admin.entity.vo.WaterAndElectricity;
  15. import com.huimv.admin.service.IBaseFarmService;
  16. import com.huimv.admin.service.IEnergyDataService;
  17. import com.huimv.admin.service.IEnergyEnvDeviceService;
  18. import org.springframework.beans.factory.annotation.Autowired;
  19. import org.springframework.web.bind.annotation.*;
  20. import org.springframework.web.multipart.MultipartFile;
  21. import javax.servlet.http.HttpServletRequest;
  22. import java.text.ParseException;
  23. import java.text.SimpleDateFormat;
  24. import java.util.*;
  25. /**
  26. * <p>
  27. * 耗能数据 前端控制器
  28. * </p>
  29. *
  30. * @author author
  31. * @since 2023-02-14
  32. */
  33. @RestController
  34. @RequestMapping("/energy-data")
  35. @CrossOrigin
  36. public class EnergyDataController {
  37. @Autowired
  38. private IEnergyDataService iEnergyDataService;
  39. @Autowired
  40. private IEnergyEnvDeviceService deviceService;
  41. @Autowired
  42. private IBaseFarmService farmService;
  43. @RequestMapping("/listCount")
  44. public Result listCount(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  45. return iEnergyDataService.listCount(httpServletRequest, paramsMap);
  46. }
  47. @RequestMapping("/listData")
  48. public Result listData(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  49. return iEnergyDataService.listData(httpServletRequest, paramsMap);
  50. }
  51. @RequestMapping("/listRank")
  52. public Result listRank(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  53. return iEnergyDataService.listRank(httpServletRequest, paramsMap);
  54. }
  55. //大屏
  56. @RequestMapping("/listDataScreen")
  57. public Result listDataScreen(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  58. return iEnergyDataService.listDataScreen(httpServletRequest, paramsMap);
  59. }
  60. @RequestMapping("/listRankScreen")
  61. public Result listRankScreen(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  62. return iEnergyDataService.listRankScreen(httpServletRequest, paramsMap);
  63. }
  64. @RequestMapping("/listDataAll")
  65. public Result listDataAll(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  66. return iEnergyDataService.listDataAll(httpServletRequest, paramsMap);
  67. }
  68. @PostMapping("/importData")
  69. public Result importData(HttpServletRequest httpServletRequest, @RequestParam(name = "file") MultipartFile file,
  70. @RequestParam(name = "farmId") String farmId,
  71. @RequestParam(name = "unitId") String unitId,
  72. @RequestParam(name = "farmName") String farmName) throws Exception {
  73. Map<String, String> map = new HashMap<>();
  74. map.put("farmId", farmId);
  75. map.put("unitId", unitId);
  76. map.put("farmName", farmName);
  77. return iEnergyDataService.importData(httpServletRequest, map, file);
  78. }
  79. //为了展示给别人好看一点
  80. @RequestMapping("/listDataWaterAndElc")
  81. public Result listDataAll2(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) throws ParseException {
  82. return iEnergyDataService.listDataAll2(httpServletRequest, paramsMap);
  83. }
  84. //给别人的接口,展示水电的实时数据
  85. @RequestMapping("/listDataTail")
  86. public Result listDataTail(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) throws ParseException {
  87. return iEnergyDataService.listDataTail(httpServletRequest, paramsMap);
  88. }
  89. //接收设备状态并修改
  90. @RequestMapping("/getDeviceStatus")
  91. public void getDeviceStatus(@RequestBody Map<String, List<EnergyEnvDevice>> paramsMap) {
  92. List<EnergyEnvDevice> result = (List) paramsMap.get("result");
  93. System.out.println("接受到的数据格式:" + result);
  94. for (EnergyEnvDevice envDevice : result) {
  95. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  96. queryWrapper.eq("device_code", envDevice.getDeviceCode());
  97. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  98. if (ObjectUtil.isNotEmpty(device)) {
  99. device.setDeviceStatus(envDevice.getDeviceStatus());
  100. }
  101. deviceService.updateById(device);
  102. }
  103. }
  104. /* @RequestMapping("/getData")
  105. public void getData(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  106. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  107. System.out.println("接受到的数据格式:" + result);
  108. for (WaterAndElectricity jsonObject : result) {
  109. EnergyData energyData = new EnergyData();
  110. energyData.setFeedValue("0.00");
  111. energyData.setWaterValue(jsonObject.getWater());
  112. energyData.setElectricityValue(jsonObject.getElectricity());
  113. energyData.setGasValue("0.00");
  114. energyData.setFarmId(26);
  115. energyData.setCreateDate(new Date());
  116. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  117. queryWrapper.eq("farm_id", 26).eq("device_code", jsonObject.getDeviceCode());
  118. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  119. if (ObjectUtil.isNotEmpty(device)) {
  120. energyData.setUnitId(device.getUnitId());
  121. }
  122. iEnergyDataService.save(energyData);
  123. }
  124. }
  125. @RequestMapping("/getData2")
  126. public void getData2(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  127. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  128. System.out.println("接受到的数据格式:" + result);
  129. for (WaterAndElectricity jsonObject : result) {
  130. EnergyData energyData = new EnergyData();
  131. energyData.setFeedValue("0.00");
  132. energyData.setWaterValue(jsonObject.getWater());
  133. energyData.setElectricityValue(jsonObject.getElectricity());
  134. energyData.setGasValue("0.00");
  135. energyData.setFarmId(29);
  136. energyData.setCreateDate(new Date());
  137. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  138. queryWrapper.eq("farm_id", 29).eq("device_code", jsonObject.getDeviceCode());
  139. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  140. if (ObjectUtil.isNotEmpty(device)) {
  141. energyData.setUnitId(device.getUnitId());
  142. }
  143. iEnergyDataService.save(energyData);
  144. }
  145. }
  146. @RequestMapping("/getData3")
  147. public void getData3(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  148. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  149. System.out.println("接受到的数据格式:" + result);
  150. for (WaterAndElectricity jsonObject : result) {
  151. EnergyData energyData = new EnergyData();
  152. energyData.setFeedValue("0.00");
  153. energyData.setWaterValue(jsonObject.getWater());
  154. energyData.setElectricityValue(jsonObject.getElectricity());
  155. energyData.setGasValue("0.00");
  156. energyData.setFarmId(22);
  157. energyData.setCreateDate(new Date());
  158. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  159. queryWrapper.eq("farm_id", 22).eq("device_code", jsonObject.getDeviceCode());
  160. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  161. if (ObjectUtil.isNotEmpty(device)) {
  162. energyData.setUnitId(device.getUnitId());
  163. }
  164. iEnergyDataService.save(energyData);
  165. }
  166. }
  167. @RequestMapping("/getData4")
  168. public void getData4(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  169. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  170. System.out.println("接受到的数据格式:" + result);
  171. for (WaterAndElectricity jsonObject : result) {
  172. EnergyData energyData = new EnergyData();
  173. energyData.setFeedValue("0.00");
  174. energyData.setWaterValue(jsonObject.getWater());
  175. energyData.setElectricityValue(jsonObject.getElectricity());
  176. energyData.setGasValue("0.00");
  177. energyData.setFarmId(28);
  178. energyData.setCreateDate(new Date());
  179. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  180. queryWrapper.eq("farm_id", 28).eq("device_code", jsonObject.getDeviceCode());
  181. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  182. if (ObjectUtil.isNotEmpty(device)) {
  183. energyData.setUnitId(device.getUnitId());
  184. }
  185. iEnergyDataService.save(energyData);
  186. }
  187. }
  188. @RequestMapping("/getData5")
  189. public void getData5(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  190. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  191. System.out.println("接受到的数据格式:" + result);
  192. for (WaterAndElectricity jsonObject : result) {
  193. EnergyData energyData = new EnergyData();
  194. energyData.setFeedValue("0.00");
  195. energyData.setWaterValue(jsonObject.getWater());
  196. energyData.setElectricityValue(jsonObject.getElectricity());
  197. energyData.setGasValue("0.00");
  198. energyData.setFarmId(21);
  199. energyData.setCreateDate(new Date());
  200. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  201. queryWrapper.eq("farm_id", 21).eq("device_code", jsonObject.getDeviceCode());
  202. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  203. if (ObjectUtil.isNotEmpty(device)) {
  204. energyData.setUnitId(device.getUnitId());
  205. }
  206. iEnergyDataService.save(energyData);
  207. }
  208. }
  209. @RequestMapping("/getData6")
  210. public void getData6(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  211. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  212. System.out.println("接受到的数据格式:" + result);
  213. for (WaterAndElectricity jsonObject : result) {
  214. EnergyData energyData = new EnergyData();
  215. energyData.setFeedValue("0.00");
  216. energyData.setWaterValue(jsonObject.getWater());
  217. energyData.setElectricityValue(jsonObject.getElectricity());
  218. energyData.setGasValue("0.00");
  219. energyData.setFarmId(33);
  220. energyData.setCreateDate(new Date());
  221. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  222. queryWrapper.eq("farm_id", 33).eq("device_code", jsonObject.getDeviceCode());
  223. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  224. if (ObjectUtil.isNotEmpty(device)) {
  225. energyData.setUnitId(device.getUnitId());
  226. }
  227. iEnergyDataService.save(energyData);
  228. }
  229. }
  230. @RequestMapping("/getData7")
  231. public void getData7(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  232. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  233. System.out.println("接受到的数据格式:" + result);
  234. for (WaterAndElectricity jsonObject : result) {
  235. EnergyData energyData = new EnergyData();
  236. energyData.setFeedValue("0.00");
  237. energyData.setWaterValue(jsonObject.getWater());
  238. energyData.setElectricityValue(jsonObject.getElectricity());
  239. energyData.setGasValue("0.00");
  240. energyData.setFarmId(34);
  241. energyData.setCreateDate(new Date());
  242. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  243. queryWrapper.eq("farm_id", 34).eq("device_code", jsonObject.getDeviceCode());
  244. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  245. if (ObjectUtil.isNotEmpty(device)) {
  246. energyData.setUnitId(device.getUnitId());
  247. }
  248. iEnergyDataService.save(energyData);
  249. }
  250. }
  251. @RequestMapping("/getData8")
  252. public void getData8(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  253. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  254. System.out.println("接受到的数据格式:" + result);
  255. for (WaterAndElectricity jsonObject : result) {
  256. EnergyData energyData = new EnergyData();
  257. energyData.setFeedValue("0.00");
  258. energyData.setWaterValue(jsonObject.getWater());
  259. energyData.setElectricityValue(jsonObject.getElectricity());
  260. energyData.setGasValue("0.00");
  261. energyData.setFarmId(35);
  262. energyData.setCreateDate(new Date());
  263. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  264. queryWrapper.eq("farm_id", 35).eq("device_code", jsonObject.getDeviceCode());
  265. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  266. if (ObjectUtil.isNotEmpty(device)) {
  267. energyData.setUnitId(device.getUnitId());
  268. }
  269. iEnergyDataService.save(energyData);
  270. }
  271. }
  272. @RequestMapping("/getData9")
  273. public void getData9(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  274. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  275. System.out.println("接受到的数据格式:" + result);
  276. for (WaterAndElectricity jsonObject : result) {
  277. EnergyData energyData = new EnergyData();
  278. energyData.setFeedValue("0.00");
  279. energyData.setWaterValue(jsonObject.getWater());
  280. energyData.setElectricityValue(jsonObject.getElectricity());
  281. energyData.setGasValue("0.00");
  282. energyData.setFarmId(23);
  283. energyData.setCreateDate(new Date());
  284. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  285. queryWrapper.eq("farm_id", 23).eq("device_code", jsonObject.getDeviceCode());
  286. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  287. if (ObjectUtil.isNotEmpty(device)) {
  288. energyData.setUnitId(device.getUnitId());
  289. }
  290. iEnergyDataService.save(energyData);
  291. }
  292. }
  293. @RequestMapping("/getData10")
  294. public void getData10(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  295. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  296. System.out.println("接受到的数据格式:" + result);
  297. for (WaterAndElectricity jsonObject : result) {
  298. EnergyData energyData = new EnergyData();
  299. energyData.setFeedValue("0.00");
  300. energyData.setWaterValue(jsonObject.getWater());
  301. energyData.setElectricityValue(jsonObject.getElectricity());
  302. energyData.setGasValue("0.00");
  303. energyData.setFarmId(36);
  304. energyData.setCreateDate(new Date());
  305. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  306. queryWrapper.eq("farm_id", 36).eq("device_code", jsonObject.getDeviceCode());
  307. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  308. if (ObjectUtil.isNotEmpty(device)) {
  309. energyData.setUnitId(device.getUnitId());
  310. }
  311. iEnergyDataService.save(energyData);
  312. }
  313. }
  314. @RequestMapping("/getData11")
  315. public void getData11(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  316. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  317. System.out.println("接受到的数据格式:" + result);
  318. for (WaterAndElectricity jsonObject : result) {
  319. EnergyData energyData = new EnergyData();
  320. energyData.setFeedValue("0.00");
  321. energyData.setWaterValue(jsonObject.getWater());
  322. energyData.setElectricityValue(jsonObject.getElectricity());
  323. energyData.setGasValue("0.00");
  324. energyData.setFarmId(37);
  325. energyData.setCreateDate(new Date());
  326. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  327. queryWrapper.eq("farm_id", 37).eq("device_code", jsonObject.getDeviceCode());
  328. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  329. if (ObjectUtil.isNotEmpty(device)) {
  330. energyData.setUnitId(device.getUnitId());
  331. }
  332. iEnergyDataService.save(energyData);
  333. }
  334. }
  335. @RequestMapping("/getData12")
  336. public void getData12(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  337. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  338. System.out.println("接受到的数据格式:" + result);
  339. for (WaterAndElectricity jsonObject : result) {
  340. EnergyData energyData = new EnergyData();
  341. energyData.setFeedValue("0.00");
  342. energyData.setWaterValue(jsonObject.getWater());
  343. energyData.setElectricityValue(jsonObject.getElectricity());
  344. energyData.setGasValue("0.00");
  345. energyData.setFarmId(38);
  346. energyData.setCreateDate(new Date());
  347. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  348. queryWrapper.eq("farm_id", 38).eq("device_code", jsonObject.getDeviceCode());
  349. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  350. if (ObjectUtil.isNotEmpty(device)) {
  351. energyData.setUnitId(device.getUnitId());
  352. }
  353. iEnergyDataService.save(energyData);
  354. }
  355. }
  356. @RequestMapping("/getData13")
  357. public void getData13(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  358. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  359. System.out.println("接受到的数据格式:" + result);
  360. for (WaterAndElectricity jsonObject : result) {
  361. EnergyData energyData = new EnergyData();
  362. energyData.setFeedValue("0.00");
  363. energyData.setWaterValue(jsonObject.getWater());
  364. energyData.setElectricityValue(jsonObject.getElectricity());
  365. energyData.setGasValue("0.00");
  366. energyData.setFarmId(27);
  367. energyData.setCreateDate(new Date());
  368. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  369. queryWrapper.eq("farm_id", 27).eq("device_code", jsonObject.getDeviceCode());
  370. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  371. if (ObjectUtil.isNotEmpty(device)) {
  372. energyData.setUnitId(device.getUnitId());
  373. }
  374. iEnergyDataService.save(energyData);
  375. }
  376. }
  377. @RequestMapping("/getData14")
  378. public void getData14(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  379. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  380. System.out.println("接受到的数据格式:" + result);
  381. for (WaterAndElectricity jsonObject : result) {
  382. EnergyData energyData = new EnergyData();
  383. energyData.setFeedValue("0.00");
  384. energyData.setWaterValue(jsonObject.getWater());
  385. energyData.setElectricityValue(jsonObject.getElectricity());
  386. energyData.setGasValue("0.00");
  387. energyData.setFarmId(40);
  388. energyData.setCreateDate(new Date());
  389. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  390. queryWrapper.eq("farm_id", 40).eq("device_code", jsonObject.getDeviceCode());
  391. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  392. if (ObjectUtil.isNotEmpty(device)) {
  393. energyData.setUnitId(device.getUnitId());
  394. }
  395. iEnergyDataService.save(energyData);
  396. }
  397. }
  398. @RequestMapping("/getData15")
  399. public void getData15(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  400. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  401. System.out.println("接受到的数据格式:" + result);
  402. for (WaterAndElectricity jsonObject : result) {
  403. EnergyData energyData = new EnergyData();
  404. energyData.setFeedValue("0.00");
  405. energyData.setWaterValue(jsonObject.getWater());
  406. energyData.setElectricityValue(jsonObject.getElectricity());
  407. energyData.setGasValue("0.00");
  408. energyData.setFarmId(41);
  409. energyData.setCreateDate(new Date());
  410. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  411. queryWrapper.eq("farm_id", 41).eq("device_code", jsonObject.getDeviceCode());
  412. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  413. if (ObjectUtil.isNotEmpty(device)) {
  414. energyData.setUnitId(device.getUnitId());
  415. }
  416. iEnergyDataService.save(energyData);
  417. }
  418. }
  419. @RequestMapping("/getData16")
  420. public void getData16(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  421. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  422. System.out.println("接受到的数据格式:" + result);
  423. for (WaterAndElectricity jsonObject : result) {
  424. EnergyData energyData = new EnergyData();
  425. energyData.setFeedValue("0.00");
  426. energyData.setWaterValue(jsonObject.getWater());
  427. energyData.setElectricityValue(jsonObject.getElectricity());
  428. energyData.setGasValue("0.00");
  429. energyData.setFarmId(39);
  430. energyData.setCreateDate(new Date());
  431. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  432. queryWrapper.eq("farm_id", 39).eq("device_code", jsonObject.getDeviceCode());
  433. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  434. if (ObjectUtil.isNotEmpty(device)) {
  435. energyData.setUnitId(device.getUnitId());
  436. }
  437. iEnergyDataService.save(energyData);
  438. }
  439. }
  440. @RequestMapping("/getData17")
  441. public void getData17(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  442. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  443. System.out.println("接受到的数据格式:" + result);
  444. for (WaterAndElectricity jsonObject : result) {
  445. EnergyData energyData = new EnergyData();
  446. energyData.setFeedValue("0.00");
  447. energyData.setWaterValue(jsonObject.getWater());
  448. energyData.setElectricityValue(jsonObject.getElectricity());
  449. energyData.setGasValue("0.00");
  450. energyData.setFarmId(42);
  451. energyData.setCreateDate(new Date());
  452. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  453. queryWrapper.eq("farm_id", 42).eq("device_code", jsonObject.getDeviceCode());
  454. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  455. if (ObjectUtil.isNotEmpty(device)) {
  456. energyData.setUnitId(device.getUnitId());
  457. }
  458. iEnergyDataService.save(energyData);
  459. }
  460. }
  461. @RequestMapping("/getData18")
  462. public void getData18(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  463. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  464. System.out.println("接受到的数据格式:" + result);
  465. for (WaterAndElectricity jsonObject : result) {
  466. EnergyData energyData = new EnergyData();
  467. energyData.setFeedValue("0.00");
  468. energyData.setWaterValue(jsonObject.getWater());
  469. energyData.setElectricityValue(jsonObject.getElectricity());
  470. energyData.setGasValue("0.00");
  471. energyData.setFarmId(24);
  472. energyData.setCreateDate(new Date());
  473. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  474. queryWrapper.eq("farm_id", 24).eq("device_code", jsonObject.getDeviceCode());
  475. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  476. if (ObjectUtil.isNotEmpty(device)) {
  477. energyData.setUnitId(device.getUnitId());
  478. }
  479. iEnergyDataService.save(energyData);
  480. }
  481. }*/
  482. @RequestMapping("/getData19")
  483. public void getData19(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  484. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  485. System.out.println("接受到的数据格式:" + result);
  486. for (WaterAndElectricity jsonObject : result) {
  487. EnergyData energyData = new EnergyData();
  488. energyData.setFeedValue("0.00");
  489. energyData.setWaterValue(jsonObject.getWater());
  490. energyData.setElectricityValue(jsonObject.getElectricity());
  491. energyData.setGasValue("0.00");
  492. energyData.setFarmId(28);
  493. energyData.setCreateDate(new Date());
  494. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  495. queryWrapper.eq("farm_id", 28).eq("device_code", jsonObject.getDeviceCode());
  496. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  497. if (ObjectUtil.isNotEmpty(device)) {
  498. energyData.setUnitId(device.getUnitId());
  499. }
  500. iEnergyDataService.save(energyData);
  501. }
  502. }
  503. @RequestMapping("/getData20")
  504. public void getData20(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  505. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  506. System.out.println("接受到的数据格式:" + result);
  507. for (WaterAndElectricity jsonObject : result) {
  508. EnergyData energyData = new EnergyData();
  509. energyData.setFeedValue("0.00");
  510. energyData.setWaterValue(jsonObject.getWater());
  511. energyData.setElectricityValue(jsonObject.getElectricity());
  512. energyData.setGasValue("0.00");
  513. energyData.setFarmId(29);
  514. energyData.setCreateDate(new Date());
  515. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  516. queryWrapper.eq("farm_id", 29).eq("device_code", jsonObject.getDeviceCode());
  517. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  518. if (ObjectUtil.isNotEmpty(device)) {
  519. energyData.setUnitId(device.getUnitId());
  520. }
  521. iEnergyDataService.save(energyData);
  522. }
  523. }
  524. @RequestMapping("/getData21")
  525. public void getData21(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  526. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  527. System.out.println("接受到的数据格式:" + result);
  528. for (WaterAndElectricity jsonObject : result) {
  529. EnergyData energyData = new EnergyData();
  530. energyData.setFeedValue("0.00");
  531. energyData.setWaterValue(jsonObject.getWater());
  532. energyData.setElectricityValue(jsonObject.getElectricity());
  533. energyData.setGasValue("0.00");
  534. energyData.setFarmId(30);
  535. energyData.setCreateDate(new Date());
  536. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  537. queryWrapper.eq("farm_id", 30).eq("device_code", jsonObject.getDeviceCode());
  538. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  539. if (ObjectUtil.isNotEmpty(device)) {
  540. energyData.setUnitId(device.getUnitId());
  541. }
  542. iEnergyDataService.save(energyData);
  543. }
  544. }
  545. @RequestMapping("/getData22")
  546. public void getData22(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  547. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  548. System.out.println("接受到的数据格式:" + result);
  549. for (WaterAndElectricity jsonObject : result) {
  550. EnergyData energyData = new EnergyData();
  551. energyData.setFeedValue("0.00");
  552. energyData.setWaterValue(jsonObject.getWater());
  553. energyData.setElectricityValue(jsonObject.getElectricity());
  554. energyData.setGasValue("0.00");
  555. energyData.setFarmId(31);
  556. energyData.setCreateDate(new Date());
  557. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  558. queryWrapper.eq("farm_id", 31).eq("device_code", jsonObject.getDeviceCode());
  559. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  560. if (ObjectUtil.isNotEmpty(device)) {
  561. energyData.setUnitId(device.getUnitId());
  562. }
  563. iEnergyDataService.save(energyData);
  564. }
  565. }
  566. @PostMapping("/add")
  567. public Result add(@RequestBody EnergyData energyData) {
  568. iEnergyDataService.save(energyData);
  569. return Result.SUCCESS();
  570. }
  571. @PostMapping("/listAll")
  572. public Result listAll(@RequestBody Map<String, String> paramsMap) {
  573. return iEnergyDataService.listAll(paramsMap);
  574. }
  575. @PostMapping("/removeById")
  576. public Result listAll(@RequestBody EnergyData energyData) {
  577. iEnergyDataService.removeById(energyData.getId());
  578. return Result.SUCCESS();
  579. }
  580. }