GasDataServiceImpl.java 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. package com.huimv.admin.service.impl;
  2. import cn.hutool.core.date.DateTime;
  3. import cn.hutool.core.date.DateUtil;
  4. import cn.hutool.core.util.ObjectUtil;
  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.utils.DataUill;
  9. import com.huimv.admin.common.utils.Result;
  10. import com.huimv.admin.common.utils.ResultCode;
  11. import com.huimv.admin.entity.GasData;
  12. import com.huimv.admin.entity.vo.GasDataVo;
  13. import com.huimv.admin.mapper.GasDataMapper;
  14. import com.huimv.admin.service.IGasDataService;
  15. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Service;
  18. import javax.servlet.http.HttpServletRequest;
  19. import java.util.Date;
  20. import java.util.LinkedList;
  21. import java.util.List;
  22. import java.util.Map;
  23. /**
  24. * <p>
  25. * 服务实现类
  26. * </p>
  27. *
  28. * @author author
  29. * @since 2023-02-21
  30. */
  31. @Service
  32. public class GasDataServiceImpl extends ServiceImpl<GasDataMapper, GasData> implements IGasDataService {
  33. @Autowired
  34. private GasDataMapper dataMapper;
  35. @Override
  36. public Result list(HttpServletRequest httpServletRequest, Map<String, String> paramsMap) {
  37. String farmId = paramsMap.get("farmId");
  38. String date = paramsMap.get("time");
  39. QueryWrapper<GasData> queryWrapper = new QueryWrapper<>();
  40. queryWrapper.eq("farm_id", farmId);
  41. if (date == null || date == "") {
  42. DateTime dateTime = DateUtil.beginOfDay(new Date());
  43. date = dateTime.toString();
  44. queryWrapper.ge("create_time", date).orderByAsc("create_time");
  45. } else {
  46. String startTime = date + " 00:00:00";
  47. String endTime = date + " 23:59:59";
  48. queryWrapper.between("create_time", startTime, endTime).orderByAsc("create_time");
  49. }
  50. List<GasData> gasData = dataMapper.selectList(queryWrapper);
  51. GasDataVo gasDataVo = new GasDataVo();
  52. List<GasData> gasDataList = new LinkedList<>();
  53. List<GasData> gasDataList1 = new LinkedList<>();
  54. List<GasData> gasDataList2 = new LinkedList<>();
  55. List<GasData> gasDataList3 = new LinkedList<>();
  56. for (GasData gasDatum : gasData) {
  57. if (gasDatum.getLoctionType() == 1) {
  58. gasDataList.add(gasDatum);
  59. } else if (gasDatum.getLoctionType() == 2) {
  60. gasDataList1.add(gasDatum);
  61. } else if (gasDatum.getLoctionType() == 3) {
  62. gasDataList2.add(gasDatum);
  63. } else if (gasDatum.getLoctionType() == 4) {
  64. gasDataList3.add(gasDatum);
  65. }
  66. }
  67. gasDataVo.setPigpen(gasDataList);
  68. gasDataVo.setAbove(gasDataList1);
  69. gasDataVo.setUnder(gasDataList2);
  70. gasDataVo.setPeople(gasDataList3);
  71. return new Result(ResultCode.SUCCESS,gasDataVo);
  72. }
  73. @Override
  74. public Result listArea(HttpServletRequest httpServletRequest, Map<String, String> paramsMap) {
  75. String farmId = paramsMap.get("farmId");
  76. JSONObject jsonObject = new JSONObject();
  77. QueryWrapper<GasData> queryWrapper = new QueryWrapper<>();
  78. queryWrapper.eq("farm_id", farmId).eq("loction_type", 1).orderByDesc("create_time")
  79. .last(" limit 1");
  80. GasData gasData = dataMapper.selectOne(queryWrapper);
  81. if (ObjectUtil.isEmpty(gasData)){
  82. jsonObject.put("pigpen", new GasData());
  83. }else {
  84. jsonObject.put("pigpen", gasData);
  85. }
  86. QueryWrapper<GasData> queryWrapper2 = new QueryWrapper<>();
  87. queryWrapper2.eq("farm_id", farmId).eq("loction_type", 2).orderByDesc("create_time")
  88. .last(" limit 1");
  89. GasData gasData2 = dataMapper.selectOne(queryWrapper2);
  90. if (ObjectUtil.isEmpty(gasData2)){
  91. jsonObject.put("above", new GasData());
  92. }else {
  93. jsonObject.put("above", gasData2);
  94. }
  95. QueryWrapper<GasData> queryWrapper3 = new QueryWrapper<>();
  96. queryWrapper3.eq("farm_id", farmId).eq("loction_type", 3).orderByDesc("create_time")
  97. .last(" limit 1");
  98. GasData gasData3 = dataMapper.selectOne(queryWrapper3);
  99. if (ObjectUtil.isEmpty(gasData3)){
  100. jsonObject.put("under", new GasData());
  101. }else {
  102. jsonObject.put("under", gasData3);
  103. }
  104. QueryWrapper<GasData> queryWrapper4 = new QueryWrapper<>();
  105. queryWrapper4.eq("farm_id", farmId).eq("loction_type", 4).orderByDesc("create_time")
  106. .last(" limit 1");
  107. GasData gasData4 = dataMapper.selectOne(queryWrapper4);
  108. if (ObjectUtil.isEmpty(gasData4)){
  109. jsonObject.put("people", new GasData());
  110. }else {
  111. jsonObject.put("people", gasData4);
  112. }
  113. return new Result(ResultCode.SUCCESS, jsonObject);
  114. }
  115. }