BaseDeviceServiceImpl.java 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  1. package com.huimv.receive.service.impl;
  2. import com.alibaba.fastjson.JSONObject;
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
  5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  6. import com.huimv.receive.common.utils.DataUill;
  7. import com.huimv.receive.common.utils.Print;
  8. import com.huimv.receive.common.utils.Result;
  9. import com.huimv.receive.common.utils.ResultCode;
  10. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  11. import com.huimv.receive.common.utils.Result;
  12. import com.huimv.receive.entity.BaseDevice;
  13. import com.huimv.receive.entity.BillClean;
  14. import com.huimv.receive.entity.SysUser;
  15. import com.huimv.receive.mapper.BaseDeviceMapper;
  16. import com.huimv.receive.service.IBaseDeviceService;
  17. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  18. import org.springframework.beans.factory.annotation.Autowired;
  19. import org.springframework.stereotype.Service;
  20. import java.text.DecimalFormat;
  21. import java.util.Map;
  22. import javax.servlet.http.HttpServletRequest;
  23. import javax.servlet.http.HttpServletResponse;
  24. import java.time.LocalDateTime;
  25. import java.util.ArrayList;
  26. import java.util.Date;
  27. import java.util.List;
  28. import java.util.Map;
  29. /**
  30. * <p>
  31. * 服务实现类
  32. * </p>
  33. *
  34. * @author author
  35. * @since 2023-09-04
  36. */
  37. @Service
  38. public class BaseDeviceServiceImpl extends ServiceImpl<BaseDeviceMapper, BaseDevice> implements IBaseDeviceService {
  39. @Autowired
  40. private BaseDeviceMapper deviceMapper;
  41. @Override
  42. public void printDevice(HttpServletResponse httpServletRequest, Map<String, String> paramsMap) throws Exception {
  43. String ids = paramsMap.get("ids");
  44. String[] split = ids.split(",");
  45. List<BaseDevice> list = new ArrayList<>();
  46. for (String s : split) {
  47. BaseDevice admission = deviceMapper.selectById(s);
  48. list.add(admission);
  49. }
  50. Print.printDevice(list);
  51. }
  52. @Override
  53. public Result listCount(HttpServletRequest httpServletRequest, Map<String, String> paramsMap) {
  54. String farmId = paramsMap.get("farmId");
  55. QueryWrapper<BaseDevice> queryWrapper = new QueryWrapper<>();
  56. queryWrapper.eq("farm_id", farmId);
  57. queryWrapper.eq("device_status", 0);
  58. Integer count = deviceMapper.selectCount(queryWrapper);//在线
  59. QueryWrapper<BaseDevice> queryWrapper1 = new QueryWrapper<>();
  60. queryWrapper1.eq("farm_id", farmId);
  61. queryWrapper1.eq("device_status", 1);
  62. Integer count1 = deviceMapper.selectCount(queryWrapper1);//离线
  63. Integer allCount = count + count1;
  64. DecimalFormat def = new DecimalFormat("0.00");
  65. String rank;
  66. if (allCount == 0 || allCount == null) {
  67. Double ranks = Double.valueOf("0.00");
  68. rank = ranks.toString();
  69. } else {
  70. Double ranks = (Double.valueOf(count.toString()) / Double.valueOf(allCount.toString())) * 100;
  71. rank = def.format(ranks);
  72. }
  73. JSONObject jsonObject = new JSONObject();
  74. jsonObject.put("count", allCount);
  75. jsonObject.put("count1", count);
  76. jsonObject.put("count2", count1);
  77. jsonObject.put("rank", rank);
  78. return new Result(ResultCode.SUCCESS, jsonObject);
  79. }
  80. @Override
  81. public Result listSelect(HttpServletRequest httpServletRequest, Map<String, String> paramsMap) {
  82. String farmId = paramsMap.get("farmId");
  83. String word = paramsMap.get("word");
  84. String locationId = paramsMap.get("locationId");
  85. String pageNum = paramsMap.get("pageNum");
  86. String pageSize = paramsMap.get("pageSize");
  87. if ("".equals(pageNum) || null == pageNum) {
  88. pageNum = "1";
  89. }
  90. if ("".equals(pageSize) || null == pageSize) {
  91. pageSize = "10";
  92. }
  93. QueryWrapper<BaseDevice> queryWrapper = new QueryWrapper<>();
  94. queryWrapper.eq("farm_id", farmId);
  95. if (StringUtils.isNotBlank(word)) {
  96. queryWrapper.and(i -> i.like("device_code", word)
  97. .or().like( "device_name", word));
  98. }
  99. queryWrapper.eq(StringUtils.isNotBlank(locationId),"work_location_type", locationId);
  100. Page<BaseDevice> page = new Page<>(Integer.parseInt(pageNum), Integer.parseInt(pageSize));
  101. return new Result(ResultCode.SUCCESS, deviceMapper.selectPage(page, queryWrapper));
  102. }
  103. @Override
  104. public Result addDevice(BaseDevice baseDevice) {
  105. String deviceCode = baseDevice.getDeviceCode();
  106. int deviceCodeCount = this.count(new QueryWrapper<BaseDevice>().eq("device_code", deviceCode));
  107. if (deviceCodeCount>0){
  108. return new Result(10001,"设备编码已存在",false);
  109. }
  110. this.save(baseDevice);
  111. return new Result(10000,"添加成功",true);
  112. }
  113. @Override
  114. public Result updateDevice(BaseDevice baseDevice) {
  115. this.updateById(baseDevice);
  116. return new Result(10000,"修改成功",true);
  117. }
  118. }