EnergyDataController.java 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359
  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 javax.servlet.http.HttpServletRequest;
  21. import java.text.ParseException;
  22. import java.text.SimpleDateFormat;
  23. import java.util.*;
  24. /**
  25. * <p>
  26. * 耗能数据 前端控制器
  27. * </p>
  28. *
  29. * @author author
  30. * @since 2023-02-14
  31. */
  32. @RestController
  33. @RequestMapping("/energy-data")
  34. @CrossOrigin
  35. public class EnergyDataController {
  36. @Autowired
  37. private IEnergyDataService iEnergyDataService;
  38. @Autowired
  39. private IEnergyEnvDeviceService deviceService;
  40. @Autowired
  41. private IBaseFarmService farmService;
  42. @RequestMapping("/listCount")
  43. public Result listCount(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  44. return iEnergyDataService.listCount(httpServletRequest, paramsMap);
  45. }
  46. @RequestMapping("/listData")
  47. public Result listData(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  48. return iEnergyDataService.listData(httpServletRequest, paramsMap);
  49. }
  50. @RequestMapping("/listRank")
  51. public Result listRank(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  52. return iEnergyDataService.listRank(httpServletRequest, paramsMap);
  53. }
  54. //大屏
  55. @RequestMapping("/listDataScreen")
  56. public Result listDataScreen(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  57. return iEnergyDataService.listDataScreen(httpServletRequest, paramsMap);
  58. }
  59. @RequestMapping("/listRankScreen")
  60. public Result listRankScreen(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  61. return iEnergyDataService.listRankScreen(httpServletRequest, paramsMap);
  62. }
  63. @RequestMapping("/listDataAll")
  64. public Result listDataAll(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) {
  65. return iEnergyDataService.listDataAll(httpServletRequest, paramsMap);
  66. }
  67. //为了展示给别人好看一点
  68. @RequestMapping("/listDataWaterAndElc")
  69. public Result listDataAll2(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) throws ParseException {
  70. return iEnergyDataService.listDataAll2(httpServletRequest, paramsMap);
  71. }
  72. //给别人的接口,展示水电的实时数据
  73. @RequestMapping("/listDataTail")
  74. public Result listDataTail(HttpServletRequest httpServletRequest, @RequestBody Map<String, String> paramsMap) throws ParseException {
  75. return iEnergyDataService.listDataTail(httpServletRequest, paramsMap);
  76. }
  77. @RequestMapping("/getData")
  78. public void getData(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  79. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  80. System.out.println("接受到的数据格式:" + result);
  81. for (WaterAndElectricity jsonObject : result) {
  82. EnergyData energyData = new EnergyData();
  83. energyData.setFeedValue("0.00");
  84. energyData.setWaterValue(jsonObject.getWater());
  85. energyData.setElectricityValue(jsonObject.getElectricity());
  86. energyData.setGasValue("0.00");
  87. energyData.setFarmId(26);
  88. energyData.setCreateDate(new Date());
  89. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  90. queryWrapper.eq("farm_id", 26).eq("device_code", jsonObject.getDeviceCode());
  91. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  92. if (ObjectUtil.isNotEmpty(device)) {
  93. energyData.setUnitId(device.getUnitId());
  94. }
  95. iEnergyDataService.save(energyData);
  96. }
  97. }
  98. @RequestMapping("/getData2")
  99. public void getData2(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  100. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  101. System.out.println("接受到的数据格式:" + result);
  102. for (WaterAndElectricity jsonObject : result) {
  103. EnergyData energyData = new EnergyData();
  104. energyData.setFeedValue("0.00");
  105. energyData.setWaterValue(jsonObject.getWater());
  106. energyData.setElectricityValue(jsonObject.getElectricity());
  107. energyData.setGasValue("0.00");
  108. energyData.setFarmId(29);
  109. energyData.setCreateDate(new Date());
  110. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  111. queryWrapper.eq("farm_id", 29).eq("device_code", jsonObject.getDeviceCode());
  112. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  113. if (ObjectUtil.isNotEmpty(device)) {
  114. energyData.setUnitId(device.getUnitId());
  115. }
  116. iEnergyDataService.save(energyData);
  117. }
  118. }
  119. @RequestMapping("/getData3")
  120. public void getData3(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  121. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  122. System.out.println("接受到的数据格式:" + result);
  123. for (WaterAndElectricity jsonObject : result) {
  124. EnergyData energyData = new EnergyData();
  125. energyData.setFeedValue("0.00");
  126. energyData.setWaterValue(jsonObject.getWater());
  127. energyData.setElectricityValue(jsonObject.getElectricity());
  128. energyData.setGasValue("0.00");
  129. energyData.setFarmId(22);
  130. energyData.setCreateDate(new Date());
  131. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  132. queryWrapper.eq("farm_id", 22).eq("device_code", jsonObject.getDeviceCode());
  133. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  134. if (ObjectUtil.isNotEmpty(device)) {
  135. energyData.setUnitId(device.getUnitId());
  136. }
  137. iEnergyDataService.save(energyData);
  138. }
  139. }
  140. @RequestMapping("/getData4")
  141. public void getData4(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  142. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  143. System.out.println("接受到的数据格式:" + result);
  144. for (WaterAndElectricity jsonObject : result) {
  145. EnergyData energyData = new EnergyData();
  146. energyData.setFeedValue("0.00");
  147. energyData.setWaterValue(jsonObject.getWater());
  148. energyData.setElectricityValue(jsonObject.getElectricity());
  149. energyData.setGasValue("0.00");
  150. energyData.setFarmId(28);
  151. energyData.setCreateDate(new Date());
  152. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  153. queryWrapper.eq("farm_id", 28).eq("device_code", jsonObject.getDeviceCode());
  154. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  155. if (ObjectUtil.isNotEmpty(device)) {
  156. energyData.setUnitId(device.getUnitId());
  157. }
  158. iEnergyDataService.save(energyData);
  159. }
  160. }
  161. @RequestMapping("/getData5")
  162. public void getData5(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  163. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  164. System.out.println("接受到的数据格式:" + result);
  165. for (WaterAndElectricity jsonObject : result) {
  166. EnergyData energyData = new EnergyData();
  167. energyData.setFeedValue("0.00");
  168. energyData.setWaterValue(jsonObject.getWater());
  169. energyData.setElectricityValue(jsonObject.getElectricity());
  170. energyData.setGasValue("0.00");
  171. energyData.setFarmId(21);
  172. energyData.setCreateDate(new Date());
  173. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  174. queryWrapper.eq("farm_id", 21).eq("device_code", jsonObject.getDeviceCode());
  175. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  176. if (ObjectUtil.isNotEmpty(device)) {
  177. energyData.setUnitId(device.getUnitId());
  178. }
  179. iEnergyDataService.save(energyData);
  180. }
  181. }
  182. @RequestMapping("/getData6")
  183. public void getData6(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  184. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  185. System.out.println("接受到的数据格式:" + result);
  186. for (WaterAndElectricity jsonObject : result) {
  187. EnergyData energyData = new EnergyData();
  188. energyData.setFeedValue("0.00");
  189. energyData.setWaterValue(jsonObject.getWater());
  190. energyData.setElectricityValue(jsonObject.getElectricity());
  191. energyData.setGasValue("0.00");
  192. energyData.setFarmId(33);
  193. energyData.setCreateDate(new Date());
  194. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  195. queryWrapper.eq("farm_id", 33).eq("device_code", jsonObject.getDeviceCode());
  196. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  197. if (ObjectUtil.isNotEmpty(device)) {
  198. energyData.setUnitId(device.getUnitId());
  199. }
  200. iEnergyDataService.save(energyData);
  201. }
  202. }
  203. @RequestMapping("/getData7")
  204. public void getData7(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  205. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  206. System.out.println("接受到的数据格式:" + result);
  207. for (WaterAndElectricity jsonObject : result) {
  208. EnergyData energyData = new EnergyData();
  209. energyData.setFeedValue("0.00");
  210. energyData.setWaterValue(jsonObject.getWater());
  211. energyData.setElectricityValue(jsonObject.getElectricity());
  212. energyData.setGasValue("0.00");
  213. energyData.setFarmId(34);
  214. energyData.setCreateDate(new Date());
  215. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  216. queryWrapper.eq("farm_id", 34).eq("device_code", jsonObject.getDeviceCode());
  217. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  218. if (ObjectUtil.isNotEmpty(device)) {
  219. energyData.setUnitId(device.getUnitId());
  220. }
  221. iEnergyDataService.save(energyData);
  222. }
  223. }
  224. @RequestMapping("/getData8")
  225. public void getData8(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  226. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  227. System.out.println("接受到的数据格式:" + result);
  228. for (WaterAndElectricity jsonObject : result) {
  229. EnergyData energyData = new EnergyData();
  230. energyData.setFeedValue("0.00");
  231. energyData.setWaterValue(jsonObject.getWater());
  232. energyData.setElectricityValue(jsonObject.getElectricity());
  233. energyData.setGasValue("0.00");
  234. energyData.setFarmId(35);
  235. energyData.setCreateDate(new Date());
  236. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  237. queryWrapper.eq("farm_id", 35).eq("device_code", jsonObject.getDeviceCode());
  238. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  239. if (ObjectUtil.isNotEmpty(device)) {
  240. energyData.setUnitId(device.getUnitId());
  241. }
  242. iEnergyDataService.save(energyData);
  243. }
  244. }
  245. @RequestMapping("/getData9")
  246. public void getData9(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  247. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  248. System.out.println("接受到的数据格式:" + result);
  249. for (WaterAndElectricity jsonObject : result) {
  250. EnergyData energyData = new EnergyData();
  251. energyData.setFeedValue("0.00");
  252. energyData.setWaterValue(jsonObject.getWater());
  253. energyData.setElectricityValue(jsonObject.getElectricity());
  254. energyData.setGasValue("0.00");
  255. energyData.setFarmId(23);
  256. energyData.setCreateDate(new Date());
  257. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  258. queryWrapper.eq("farm_id", 23).eq("device_code", jsonObject.getDeviceCode());
  259. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  260. if (ObjectUtil.isNotEmpty(device)) {
  261. energyData.setUnitId(device.getUnitId());
  262. }
  263. iEnergyDataService.save(energyData);
  264. }
  265. }
  266. @RequestMapping("/getData10")
  267. public void getData10(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  268. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  269. System.out.println("接受到的数据格式:" + result);
  270. for (WaterAndElectricity jsonObject : result) {
  271. EnergyData energyData = new EnergyData();
  272. energyData.setFeedValue("0.00");
  273. energyData.setWaterValue(jsonObject.getWater());
  274. energyData.setElectricityValue(jsonObject.getElectricity());
  275. energyData.setGasValue("0.00");
  276. energyData.setFarmId(36);
  277. energyData.setCreateDate(new Date());
  278. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  279. queryWrapper.eq("farm_id", 36).eq("device_code", jsonObject.getDeviceCode());
  280. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  281. if (ObjectUtil.isNotEmpty(device)) {
  282. energyData.setUnitId(device.getUnitId());
  283. }
  284. iEnergyDataService.save(energyData);
  285. }
  286. }
  287. @RequestMapping("/getData11")
  288. public void getData11(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  289. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  290. System.out.println("接受到的数据格式:" + result);
  291. for (WaterAndElectricity jsonObject : result) {
  292. EnergyData energyData = new EnergyData();
  293. energyData.setFeedValue("0.00");
  294. energyData.setWaterValue(jsonObject.getWater());
  295. energyData.setElectricityValue(jsonObject.getElectricity());
  296. energyData.setGasValue("0.00");
  297. energyData.setFarmId(37);
  298. energyData.setCreateDate(new Date());
  299. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  300. queryWrapper.eq("farm_id", 37).eq("device_code", jsonObject.getDeviceCode());
  301. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  302. if (ObjectUtil.isNotEmpty(device)) {
  303. energyData.setUnitId(device.getUnitId());
  304. }
  305. iEnergyDataService.save(energyData);
  306. }
  307. }
  308. @RequestMapping("/getData12")
  309. public void getData12(@RequestBody Map<String, List<WaterAndElectricity>> paramsMap) {
  310. List<WaterAndElectricity> result = (List) paramsMap.get("result");
  311. System.out.println("接受到的数据格式:" + result);
  312. for (WaterAndElectricity jsonObject : result) {
  313. EnergyData energyData = new EnergyData();
  314. energyData.setFeedValue("0.00");
  315. energyData.setWaterValue(jsonObject.getWater());
  316. energyData.setElectricityValue(jsonObject.getElectricity());
  317. energyData.setGasValue("0.00");
  318. energyData.setFarmId(38);
  319. energyData.setCreateDate(new Date());
  320. QueryWrapper<EnergyEnvDevice> queryWrapper = new QueryWrapper<>();
  321. queryWrapper.eq("farm_id", 38).eq("device_code", jsonObject.getDeviceCode());
  322. EnergyEnvDevice device = deviceService.getOne(queryWrapper);
  323. if (ObjectUtil.isNotEmpty(device)) {
  324. energyData.setUnitId(device.getUnitId());
  325. }
  326. iEnergyDataService.save(energyData);
  327. }
  328. }
  329. @PostMapping("/add")
  330. public Result add(@RequestBody EnergyData energyData) {
  331. iEnergyDataService.save(energyData);
  332. return Result.SUCCESS();
  333. }
  334. @PostMapping("/listAll")
  335. public Result listAll(@RequestBody Map<String, String> paramsMap) {
  336. return iEnergyDataService.listAll(paramsMap);
  337. }
  338. @PostMapping("/removeById")
  339. public Result listAll(@RequestBody EnergyData energyData) {
  340. iEnergyDataService.removeById(energyData.getId());
  341. return Result.SUCCESS();
  342. }
  343. }