SiteServiceImpl.java 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217
  1. package com.bizmatics.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
  4. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  5. import com.bizmatics.common.core.exception.BusinessException;
  6. import com.bizmatics.common.core.util.BeanMapperUtils;
  7. import com.bizmatics.common.mvc.base.AbstractCrudService;
  8. import com.bizmatics.model.*;
  9. import com.bizmatics.persistence.mapper.AlarmPowerMapper;
  10. import com.bizmatics.persistence.mapper.DeviceMapper;
  11. import com.bizmatics.persistence.mapper.SiteMapper;
  12. import com.bizmatics.service.DeviceService;
  13. import com.bizmatics.service.SiteService;
  14. import com.bizmatics.service.UserSiteService;
  15. import com.bizmatics.service.enums.DeviceStatusCode;
  16. import com.bizmatics.service.util.SessionLocal;
  17. import com.bizmatics.service.vo.DeviceCountVO;
  18. import com.bizmatics.service.vo.SiteVO;
  19. import lombok.extern.slf4j.Slf4j;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.stereotype.Service;
  22. import java.util.*;
  23. import java.util.stream.Collectors;
  24. /**
  25. * <p>
  26. * 服务实现类
  27. * </p>
  28. *
  29. * @author ya
  30. * @since 2021-07-07
  31. */
  32. @Slf4j
  33. @Service
  34. public class SiteServiceImpl extends AbstractCrudService<SiteMapper, Site> implements SiteService {
  35. @Autowired
  36. private DeviceMapper deviceMapper;
  37. @Autowired
  38. private DeviceService deviceService;
  39. @Autowired
  40. private AlarmPowerMapper alarmPowerMapper;
  41. @Autowired
  42. private UserSiteService userSiteService;
  43. @Override
  44. public DeviceCountVO selectCount() {
  45. // Integer userId = UserUtil.getUserId();
  46. Integer userId = SessionLocal.getUserId();
  47. DeviceCountVO deviceCountVO = new DeviceCountVO();
  48. deviceCountVO.setNormalCount(baseMapper.selectCount(userId, null, DeviceStatusCode.NORMAL.getValue()));
  49. deviceCountVO.setOffLineCount(baseMapper.selectCount(userId, null, DeviceStatusCode.OFFLINE.getValue()));
  50. deviceCountVO.setDeviceCount(baseMapper.selectCount(userId, null, DeviceStatusCode.DEVICE.getValue()));
  51. deviceCountVO.setFaultCount(baseMapper.selectCount(userId, null, DeviceStatusCode.FAULT.getValue()));
  52. deviceCountVO.setCount(userSiteService.count(userId));
  53. return deviceCountVO;
  54. }
  55. @Override
  56. public List<Site> list(String name) {
  57. return baseMapper.list(SessionLocal.getUserId(), name);
  58. }
  59. @Override
  60. public List<Map<String, Object>> Sitelist(String name) {
  61. List<Map<String, Object>> list = new ArrayList<>();
  62. List<SiteList> site_list = null;
  63. List<GroupingList> grouping_list = null;
  64. List<SiteList> site_grouping_list = null;
  65. grouping_list = baseMapper.GroupingList(name,SessionLocal.getUser().getUserName());
  66. site_list = baseMapper.Sitelist(SessionLocal.getUserId(), name);
  67. site_grouping_list = baseMapper.SiteGroupinglist(SessionLocal.getUserId(), name);
  68. List<Map<String, Object>> list1 = new ArrayList<>();
  69. if (grouping_list.size() > 0) {
  70. for (int i = 0; i < grouping_list.size(); i++) {
  71. GroupingList grouping_list_one = (GroupingList) grouping_list.get(i);
  72. Map<String, Object> map1 = new HashMap<>();
  73. List<Map<String, Object>> list2 = new ArrayList<>();
  74. map1.put("id", grouping_list_one.getId());
  75. map1.put("grouping_id", grouping_list_one.getId());
  76. map1.put("grouping_name", grouping_list_one.getGroupingName());
  77. if (site_list.size() > 0) {
  78. for (int j = 0; j < site_list.size(); j++) {
  79. SiteList site_list_one = (SiteList) site_list.get(j);
  80. Map<String, Object> map2 = new HashMap<>();
  81. if (grouping_list_one.getId().equals(site_list_one.getGroupingId())) {
  82. map2.put("site_id", site_list_one.getId());
  83. map2.put("site_name", site_list_one.getSiteName());
  84. // map2.put("grouping_id",site_list_one.getGroupingId());
  85. list2.add(map2);
  86. }
  87. }
  88. map1.put("site_list", list2);
  89. }else {
  90. map1.put("site_list", list2);
  91. }
  92. list1.add(map1);
  93. }
  94. }
  95. if (site_grouping_list.size() > 0) {
  96. List<Map<String, Object>> list3 = new ArrayList<>();
  97. for (int i = 0; i < site_grouping_list.size(); i++) {
  98. SiteList site_grouping_list_one = (SiteList) site_grouping_list.get(i);
  99. Map<String, Object> map3 = new HashMap<>();
  100. map3.put("id", site_grouping_list_one.getId());
  101. map3.put("grouping_id", 0);
  102. map3.put("grouping_name", site_grouping_list_one.getSiteName());
  103. map3.put("site_list", list3);
  104. list1.add(map3);
  105. }
  106. }
  107. return list1;
  108. }
  109. @Override
  110. public List<SiteVO> siteAndStatusList(String name) {
  111. List<SiteVO> list = new ArrayList<>();
  112. // Integer userId = UserUtil.getUserId();
  113. Integer userId = SessionLocal.getUserId();
  114. List<Site> sites = baseMapper.list(SessionLocal.getUserId(), name);
  115. List<Device> deviceList = deviceMapper.list(userId, null, null, null, null, null);
  116. List<AlarmPower> alarmPowers = alarmPowerMapper.list(userId, null, null, null, null, null, 1);
  117. sites.forEach(site -> list.add(enhanceSite(deviceList, site, alarmPowers)));
  118. return list;
  119. }
  120. @Override
  121. public SiteVO getOne(Long siteId) {
  122. Site site = baseMapper.selectOne(Wrappers.lambdaQuery(Site.class).eq(Site::getId, siteId));
  123. return Optional.ofNullable(site)
  124. .map(st -> {
  125. LambdaQueryWrapper<Device> deviceLambdaQueryWrapper = Wrappers.lambdaQuery();
  126. deviceLambdaQueryWrapper.eq(Device::getSiteId, site.getId());
  127. List<Device> list = deviceService.list(deviceLambdaQueryWrapper);
  128. Integer count = alarmPowerMapper.selectCount(null, site.getId(), null, null, null, null, 1);
  129. SiteVO siteVO = enhanceSite(list, site, null);
  130. siteVO.setAlarmPowerCount(count);
  131. return siteVO;
  132. })
  133. .orElseThrow(() -> new BusinessException("站点信息不存在"));
  134. }
  135. public SiteVO enhanceSite(List<Device> list, Site site, List<AlarmPower> alarmPowers) {
  136. SiteVO siteVo = BeanMapperUtils.map(site, SiteVO.class);
  137. siteVo.setDeviceCount(list.size());
  138. long deviceCount = list.stream()
  139. .filter(device -> device.getSiteId().equals(site.getId()))
  140. .filter(device -> DeviceStatusCode.DEVICE.getValue().equals(device.getDeviceStatus()))
  141. .count();
  142. long faultCount = list.stream()
  143. .filter(device -> device.getSiteId().equals(site.getId()))
  144. .filter(device -> DeviceStatusCode.FAULT.getValue().equals(device.getDeviceStatus()))
  145. .count();
  146. long offCount = list.stream()
  147. .filter(device -> device.getSiteId().equals(site.getId()))
  148. .filter(device -> DeviceStatusCode.OFFLINE.getValue().equals(device.getDeviceStatus()))
  149. .count();
  150. if (CollectionUtils.isNotEmpty(alarmPowers)) {
  151. siteVo.setAlarmPowerCount((int) alarmPowers.stream().filter(alarmPower -> alarmPower.getSiteId().equals(site.getId())).count());
  152. } else {
  153. siteVo.setAlarmPowerCount(0);
  154. }
  155. if (deviceCount > 0) {
  156. siteVo.setStatus(DeviceStatusCode.FAULT.getDescribe());
  157. } else if (offCount > 0) {
  158. siteVo.setStatus(DeviceStatusCode.OFFLINE.getDescribe());
  159. } else if (faultCount > 0) {
  160. siteVo.setStatus(DeviceStatusCode.FAULT.getDescribe());
  161. } else {
  162. siteVo.setStatus(DeviceStatusCode.NORMAL.getDescribe());
  163. }
  164. List<String> deviceTypes = list.stream()
  165. .filter(device -> device.getSiteId().equals(site.getId()))
  166. .map(Device::getDeviceType).collect(Collectors.toList());
  167. siteVo.setDeviceType(deviceTypes);
  168. return siteVo;
  169. }
  170. public void SiteAdd(String site_name,String site_address,String company_code,String user_name,String phone,
  171. String station_area_id,String route_id,String installed_capacity,String rheological_change,String longitude,
  172. String latitude,String region,String grouping_id){
  173. Site site=new Site();
  174. site.setSiteName(site_name);
  175. site.setSiteAddress(site_address);
  176. site.setCompanyCode(Integer.parseInt(company_code));
  177. site.setUserName(user_name);
  178. site.setPhone(phone);
  179. site.setStationAreaId(Integer.parseInt(station_area_id));
  180. site.setRouteId(Integer.parseInt(route_id));
  181. site.setInstalledCapacity(installed_capacity);
  182. site.setRheologicalChange(rheological_change);
  183. site.setLongitude(longitude);
  184. site.setLatitude(latitude);
  185. site.setRegion(Integer.parseInt(region));
  186. site.setCreateTime(new Date());
  187. site.setCreator(SessionLocal.getUser().getUserName());
  188. site.setEnable(1);
  189. site.setGroupingId(Integer.parseInt(grouping_id));
  190. this.save(site);
  191. int ID = site.getId();
  192. this.save(site);
  193. userSiteService.UserSiteAdd(ID);
  194. }
  195. public void SiteUpdate(String groupingName){
  196. }
  197. }