DeviceInfoServiceImpl.java 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661
  1. package com.xy.service;
  2. import cn.hutool.core.bean.BeanUtil;
  3. import cn.hutool.core.collection.CollUtil;
  4. import cn.hutool.core.date.DatePattern;
  5. import cn.hutool.core.date.DateUtil;
  6. import cn.hutool.core.text.StrBuilder;
  7. import cn.hutool.core.util.BooleanUtil;
  8. import cn.hutool.core.util.StrUtil;
  9. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  10. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  11. import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
  12. import com.baomidou.mybatisplus.core.metadata.IPage;
  13. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  14. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  15. import com.xy.collections.list.JArrayList;
  16. import com.xy.collections.list.JList;
  17. import com.xy.config.DeviceThreadPoolConfig;
  18. import com.xy.consts.DictConsts;
  19. import com.xy.dto.*;
  20. import com.xy.entity.DeviceErrorsRecord;
  21. import com.xy.entity.DeviceInfo;
  22. import com.xy.entity.DeviceStatus;
  23. import com.xy.entity.SysDictRedis;
  24. import com.xy.error.CommRuntimeException;
  25. import com.xy.mapper.DeviceInfoMapper;
  26. import com.xy.mapper.entity.DeviceInfoQueryPage;
  27. import com.xy.util.ExcelUtils;
  28. import com.xy.utils.*;
  29. import com.xy.utils.enums.DictEnum;
  30. import com.xy.utils.enums.DictSonEnum;
  31. import io.swagger.annotations.Api;
  32. import io.swagger.annotations.ApiOperation;
  33. import jodd.introspector.MapperFunction;
  34. import lombok.RequiredArgsConstructor;
  35. import org.springframework.stereotype.Service;
  36. import org.springframework.transaction.annotation.Transactional;
  37. import org.springframework.validation.annotation.Validated;
  38. import org.springframework.web.bind.annotation.PostMapping;
  39. import org.springframework.web.bind.annotation.RequestBody;
  40. import javax.servlet.http.HttpServletResponse;
  41. import javax.validation.Valid;
  42. import java.io.IOException;
  43. import java.util.*;
  44. import java.util.stream.Collectors;
  45. import static com.xy.utils.PlusBeans.*;
  46. /**
  47. * <p>
  48. * 设备-信息 服务实现类
  49. * </p>
  50. *
  51. * @author lijin
  52. * @since 2022-12-23
  53. */
  54. @Service
  55. @RequiredArgsConstructor
  56. @Api(tags = "设备-信息")
  57. public class DeviceInfoServiceImpl extends ServiceImpl<DeviceInfoMapper, DeviceInfo> implements DeviceInfoService {
  58. private final DeviceSysinfoServiceImpl deviceSysinfoService;
  59. private final DeviceStatusServiceImpl deviceStatusService;
  60. private final DeviceRegisterServiceImpl deviceRegisterService;
  61. private final DeviceErrorsRecordServiceImpl deviceErrorsRecordService;
  62. private final DeviceDataServiceImpl deviceDataService;
  63. private final RedisService<String> redisService;
  64. private final String keyPrefix = "device:history:";
  65. @Override
  66. @ApiOperation("对象查询")
  67. public R<DeviceInfoDto.Vo> obj(DeviceInfoDto.Obj obj) {
  68. //设备信息
  69. LambdaQueryWrapper<DeviceInfo> lambdaQueryWrapper = new MybatisPlusQuery().eqWrapper(obj, DeviceInfo.class).build();
  70. List<DeviceInfo> list = list(lambdaQueryWrapper);
  71. if (!Emptys.check(list)) {
  72. return R.ok();
  73. }
  74. DeviceInfoDto.Vo deviceInfo = copy(DeviceInfoDto.Vo.class, list.get(0));
  75. ThreadPoolUtils.excPoll(DeviceThreadPoolConfig.DEVICE_COMMON_POLL, 3)
  76. .execute(() -> {
  77. //系统信息
  78. DeviceSysinfoDto.Vo deviceSysinfo = deviceSysinfoService.get(new DeviceSysinfoDto.Vo().setDeviceId(deviceInfo.getDeviceId())).getData();
  79. deviceInfo.setDeviceSysinfo(deviceSysinfo);
  80. })
  81. .execute(() -> {
  82. //状态信息
  83. DeviceStatusDto.Vo deviceStatus = deviceStatusService.obj(new DeviceStatusDto.Vo().setDeviceId(deviceInfo.getDeviceId())).getData();
  84. deviceInfo.setDeviceStatus(deviceStatus);
  85. })
  86. .execute(() -> {
  87. //注册信息
  88. DeviceRegisterDto.Vo deviceRegister = deviceRegisterService.obj(new DeviceRegisterDto.Vo().setDeviceId(deviceInfo.getDeviceId())).getData();
  89. deviceInfo.setDeviceRegister(deviceRegister);
  90. })
  91. .end();
  92. return R.ok(deviceInfo);
  93. }
  94. @Override
  95. @ApiOperation("设备访问历史添加")
  96. public R history(DeviceInfoDto.Obj obj) {
  97. //获取字典
  98. SysDictRedis sysDictRedis = SysDictUtils.get(DictEnum.DATA_CLEAR_SIZE.getKey(), "device_history_twig");
  99. Integer value = Integer.valueOf(sysDictRedis.getValue());
  100. //获取redis
  101. String key = keyPrefix + AuthorizeUtils.getLoginId(Long.class);
  102. List<String> list = redisService.getList(key);
  103. list.add(0, String.valueOf(obj.getDeviceId()));
  104. //去重
  105. List<String> redisList = new ArrayList<>();
  106. JList<String> comparing = new JArrayList<>(list).comparing();
  107. if (comparing.size() > value) {
  108. for (int i = 0; i < value; i++) {
  109. redisList.add(comparing.get(i));
  110. }
  111. } else {
  112. redisList = comparing;
  113. }
  114. redisService.removeList(key);
  115. redisService.setList(key, redisList);
  116. return R.ok();
  117. }
  118. @Override
  119. @ApiOperation("开门检测")
  120. public R checkOpenDoor(DeviceInfoDto.Obj obj) {
  121. DeviceInfoDto.Vo deviceInfo = obj(new DeviceInfoDto.Obj().setDeviceId(obj.getDeviceId())).getData();
  122. if (deviceInfo == null) {
  123. return R.fail("设备不存在");
  124. }
  125. DeviceStatusDto.Vo deviceStatus = deviceInfo.getDeviceStatus();
  126. check(deviceInfo.getFreezeStatus(), 2, "设备已冻结");
  127. SysDictRedis sysDictRedis = SysDictUtils.get(DictEnum.DEVICE_FAULT_LEVEL_PAY_THRESHOLD.getKey(), DictSonEnum.DEVICE_FAULT_LEVEL_PAY_THRESHOLD_NOT_PAY.getKey());
  128. if (deviceInfo.getFaultLevel() >= Integer.valueOf(sysDictRedis.getValue())) {
  129. return R.fail("设备故障");
  130. }
  131. check(deviceStatus.getNetState(), 2, "设备已离线");
  132. check(obj.getDoor() != null && obj.getDoor() == 1 ? deviceStatus.getDeviceStateR() : deviceStatus.getDeviceStateL(), 2, "设备已锁机");
  133. check(obj.getDoor() != null && obj.getDoor() == 1 ? deviceStatus.getLockStateR() : deviceStatus.getLockStateL(), 2, "设备正在使用中,请稍后");
  134. return R.ok();
  135. }
  136. @PostMapping("historyList")
  137. @ApiOperation("设备访问历史查询")
  138. public R<List<DeviceInfoDto.Vo>> historyList() {
  139. //获取redis
  140. String key = keyPrefix + AuthorizeUtils.getLoginId(Long.class);
  141. List<String> deviceIds = redisService.getList(key);
  142. if (!Emptys.check(deviceIds)) {
  143. return R.ok();
  144. }
  145. //查询数据库
  146. List<DeviceInfo> list = list(new LambdaQueryWrapper<DeviceInfo>().in(DeviceInfo::getDeviceId, deviceIds));
  147. return R.ok(copy(DeviceInfoDto.Vo.class, list));
  148. }
  149. @ApiOperation("修改")
  150. @PostMapping("update")
  151. public R update(@RequestBody @Validated DeviceInfoDto.Update update) {
  152. DeviceInfo deviceInfo = copy(DeviceInfo.class, update);
  153. updateById(deviceInfo);
  154. return R.ok();
  155. }
  156. @Override
  157. @ApiOperation("更新商户线路")
  158. public R updateLine(@RequestBody @Validated DeviceInfoDto.UpdateLine updateLine) {
  159. LambdaUpdateWrapper<DeviceInfo> luw = new LambdaUpdateWrapper<DeviceInfo>().eq(DeviceInfo::getMercId, updateLine.getMercId());
  160. //绑定线路,更换线路
  161. if (DeviceInfoDto.UPDATE.equals(updateLine.getType())) {
  162. DeviceInfo deviceInfo = new DeviceInfo();
  163. deviceInfo.setPlaceLineId(updateLine.getPlaceLineId());
  164. luw.in(DeviceInfo::getDeviceId, updateLine.getDeviceIds());
  165. baseMapper.update(deviceInfo, luw);
  166. }
  167. //删除线路
  168. if (DeviceInfoDto.DEL.equals(updateLine.getType())) {
  169. luw.eq(DeviceInfo::getPlaceLineId, updateLine.getWherePlaceLineId());
  170. luw.set(DeviceInfo::getPlaceLineId, null);
  171. baseMapper.update(null, luw);
  172. }
  173. //解绑线路 设置线路ID为null
  174. if (DeviceInfoDto.CLEAR.equals(updateLine.getType())) {
  175. luw.in(DeviceInfo::getDeviceId, updateLine.getDeviceIds());
  176. luw.set(DeviceInfo::getPlaceLineId, null);
  177. baseMapper.update(null, luw);
  178. }
  179. return R.ok();
  180. }
  181. @Override
  182. @ApiOperation("更新商户点位")
  183. public R updatePlace(@RequestBody @Validated DeviceInfoDto.UpdatePlace updatePlace) {
  184. LambdaUpdateWrapper<DeviceInfo> luw = new LambdaUpdateWrapper<DeviceInfo>().eq(DeviceInfo::getMercId, updatePlace.getMercId());
  185. //绑定点位,更换点位
  186. if (DeviceInfoDto.UPDATE.equals(updatePlace.getType())) {
  187. DeviceInfo deviceInfo = new DeviceInfo();
  188. deviceInfo.setPlaceId(updatePlace.getPlaceId());
  189. luw.in(DeviceInfo::getDeviceId, updatePlace.getDeviceIds());
  190. baseMapper.update(deviceInfo, luw);
  191. }
  192. //删除点位
  193. if (DeviceInfoDto.DEL.equals(updatePlace.getType())) {
  194. luw.eq(DeviceInfo::getPlaceId, updatePlace.getWherePlaceId());
  195. luw.set(DeviceInfo::getPlaceId, null);
  196. baseMapper.update(null, luw);
  197. }
  198. //解绑点位 设置点位ID为null
  199. if (DeviceInfoDto.CLEAR.equals(updatePlace.getType())) {
  200. luw.in(DeviceInfo::getDeviceId, updatePlace.getDeviceIds());
  201. luw.set(DeviceInfo::getPlaceId, null);
  202. baseMapper.update(null, luw);
  203. }
  204. return R.ok();
  205. }
  206. @PostMapping("page")
  207. @ApiOperation("分页查询")
  208. public R<PageBean<DeviceInfoDto.Vo2>> page(@RequestBody DeviceInfoDto.Page page) {
  209. return R.ok(queryPage(page));
  210. }
  211. @ApiOperation("导出设备列表")
  212. @PostMapping("exportDevices")
  213. public void exportDevices(HttpServletResponse response, @RequestBody @Valid DeviceInfoDto.Page page) throws IOException {
  214. PageBean<DeviceInfoDto.Vo2> pageBean = queryPage(page);
  215. List<DeviceInfoDto.Vo2> records = pageBean.getRecords();
  216. List<DeviceInfoDto.DeviceExcelVO> deviceExcelVOS = BeanUtil.copyToList(records, DeviceInfoDto.DeviceExcelVO.class);
  217. // 输出
  218. ExcelUtils.write(response, "设备列表.xls", "设备列表", DeviceInfoDto.DeviceExcelVO.class, deviceExcelVOS);
  219. }
  220. @PostMapping("nearbyPage")
  221. @ApiOperation("附近设备分页查询")
  222. public R<PageBean<DeviceInfoDto.Vo2>> nearbyPage(@RequestBody DeviceInfoDto.Page page) {
  223. if (!Emptys.check(page.getLon()) || !Emptys.check(page.getLat())) {
  224. throw new CommRuntimeException("经纬度不能为空");
  225. }
  226. return R.ok(queryPage(page));
  227. }
  228. @ApiOperation("商户设备授权")
  229. @Override
  230. @Transactional(rollbackFor = Exception.class)
  231. public R<Boolean> mercDeviceAuth(DeviceInfoDto.MercDeviceAuthDto auth) {
  232. Long mercId = auth.getMercId();
  233. Long parentId = auth.getParentId();
  234. String mercCode = auth.getMercCode();
  235. Long algorithmId = auth.getAlgorithmId();
  236. String mercName = auth.getMercName();
  237. //商户最终设备列表
  238. List<Long> deviceIds = auth.getDeviceIds();
  239. List<DeviceInfo> devices = getDevicesByMercId(mercId);
  240. //取消商户设备授权
  241. if (CollUtil.isEmpty(deviceIds)) {
  242. if (CollUtil.isEmpty(devices)) {
  243. return R.ok(Boolean.TRUE);
  244. }
  245. return R.ok(removeMerRefDevices(devices, parentId));
  246. }
  247. //更新商户设备授权
  248. List<DeviceInfo> deviceInfos = this.listByIds(deviceIds);
  249. for (DeviceInfo deviceInfo : deviceInfos) {
  250. int refMercId = deviceInfo.getMercId().intValue();
  251. // 只有解绑后,才能给顶级商户授权
  252. if (refMercId != -1 && refMercId != mercId.intValue()) {
  253. StrBuilder sb = StrBuilder.create();
  254. String errMsg = sb.append("设备[")
  255. .append(deviceInfo.getDeviceId())
  256. .append("]")
  257. .append("已被商户[")
  258. .append(deviceInfo.getMercName())
  259. .append("]绑定,请先进行解绑!")
  260. .toString();
  261. //已关联别商户
  262. return R.fail(errMsg, Boolean.FALSE);
  263. }
  264. //绑定关系
  265. deviceInfo.setMercId(mercId).setMercCode(mercCode).setAlgorithmId(algorithmId).setMercName(mercName);
  266. }
  267. updateBatchById(deviceInfos);
  268. //原来存在的设备关系,不在最终设备列表中的移除
  269. if (CollUtil.isNotEmpty(devices)) {
  270. List<Long> oldIds = new ArrayList<>();
  271. List<Long> removeIds = new ArrayList<>();
  272. devices.forEach(device -> oldIds.add(device.getDeviceId()));
  273. oldIds.forEach(deviceId -> {
  274. //不在最终设备列表中的待移除
  275. if (!deviceIds.contains(deviceId)) {
  276. removeIds.add(deviceId);
  277. }
  278. });
  279. if (CollUtil.isNotEmpty(removeIds)) {
  280. List<DeviceInfo> removeList = this.listByIds(removeIds);
  281. removeMerRefDevices(removeList, parentId);
  282. }
  283. }
  284. return R.ok(Boolean.TRUE);
  285. }
  286. /**
  287. * 批量移除商户设备绑定关系
  288. *
  289. * @param deviceInfos
  290. * @return
  291. */
  292. private Boolean removeMerRefDevices(List<DeviceInfo> deviceInfos, Long parentId) {
  293. deviceInfos.forEach(deviceInfo -> {
  294. //非顶级兴元商户,解绑后,机器归父商户
  295. if (parentId != 1) {
  296. deviceInfo.setMercId(parentId);
  297. }
  298. //一级商户,解绑后,直接释放
  299. if (parentId == 0) {
  300. //-1 释放关系
  301. deviceInfo.setMercId(-1L);
  302. }
  303. deviceInfo.setMercName(StrUtil.EMPTY);
  304. deviceInfo.setMercCode(StrUtil.EMPTY);
  305. });
  306. //批量更新
  307. return updateBatchById(deviceInfos);
  308. }
  309. @ApiOperation("集合查询")
  310. @Override
  311. public R<List<DeviceInfoDto.Vo>> list(DeviceInfoDto.ListDto dto) {
  312. List<DeviceInfo> list = list(new LambdaQueryWrapper<DeviceInfo>().in(CollUtil.isNotEmpty(dto.getDeviceIds()), DeviceInfo::getDeviceId, dto.getDeviceIds()));
  313. return R.ok(copy(DeviceInfoDto.Vo.class, list));
  314. }
  315. @Override
  316. @ApiOperation("通用集合查询")
  317. public R<List<DeviceInfoDto.Vo>> listCommon(DeviceInfoDto.ListCommon dto) {
  318. String deviceSearch = dto.getDeviceSearch();
  319. QueryWrapper<DeviceInfo> queryWrapper = new MybatisPlusQuery().eqWrapper(dto.getVo(), DeviceInfo.class).buildQW();
  320. List<Long> placeLineIds = dto.getPlaceLineIds();
  321. List<Long> deviceIds = dto.getDeviceIds();
  322. List<String> columnList = dto.getColumnList();
  323. if (CollUtil.isNotEmpty(placeLineIds)) {
  324. queryWrapper.in(LambdaUtils.getUnderlineCaseName(DeviceInfo::getPlaceLineId), placeLineIds);
  325. }
  326. if (StrUtil.isNotEmpty(deviceSearch)) {
  327. queryWrapper.and(wrapper -> wrapper.likeRight(LambdaUtils.getUnderlineCaseName(DeviceInfo::getDeviceName), deviceSearch).or()
  328. .eq(LambdaUtils.getUnderlineCaseName(DeviceInfo::getMercDeviceCode), deviceSearch));
  329. }
  330. if (CollUtil.isNotEmpty(columnList)) {
  331. queryWrapper.select(columnList.stream().toArray(String[]::new));
  332. }
  333. if (CollUtil.isNotEmpty(deviceIds)) {
  334. queryWrapper.eq(LambdaUtils.getUnderlineCaseName(DeviceInfo::getDeviceId), deviceIds);
  335. }
  336. return R.ok(copy(DeviceInfoDto.Vo.class, list(queryWrapper)));
  337. }
  338. @Override
  339. @ApiOperation("商户设备算法列表")
  340. public R<List<Long>> mercAlgorithmIdList(DeviceInfoDto.MercAlgorithmIdListDto dto) {
  341. String algorithmIdStr = LambdaUtils.getProperty(DeviceInfo::getAlgorithmId);
  342. String mercStr = StringTools.humpToLine(LambdaUtils.getProperty(DeviceInfo::getMercId));
  343. QueryWrapper<DeviceInfo> lqw = new QueryWrapper<DeviceInfo>()
  344. .isNotNull(StringTools.humpToLine(algorithmIdStr))
  345. .eq(mercStr, dto.getMercId())
  346. .select(String.format("DISTINCT (%s) as %s", StringTools.humpToLine(algorithmIdStr), algorithmIdStr));
  347. List<Long> list = listObjs(lqw, (MapperFunction<Object, Long>) o -> (Long) o);
  348. return R.ok(list);
  349. }
  350. @Override
  351. @ApiOperation("小程序-商户设备首页统计")
  352. public R<DeviceInfoDto.MercHomeStatisticalVO> mercHomeStatistical(DeviceInfoDto.MercHomeQueryDTO dto) {
  353. Long mercId = dto.getMercId();
  354. //初始化数据
  355. DeviceInfoDto.MercHomeStatisticalVO mercHomeStatisticalVO = new DeviceInfoDto.MercHomeStatisticalVO()
  356. .setClosedNum(0).setOfflineNum(0)
  357. .setOnlineNum(0).setOperatingNum(0).setNeedToFillNum(0);
  358. //获取商户机器
  359. List<DeviceInfo> mercDevices = getDevicesByMercId(mercId);
  360. if (CollUtil.isEmpty(mercDevices)) {
  361. return R.ok(mercHomeStatisticalVO);
  362. }
  363. List<Long> deviceIds = mercDevices.stream().map(DeviceInfo::getDeviceId).collect(Collectors.toList());
  364. //在线、离线
  365. List<DeviceStatus> deviceStatuses = deviceStatusService.listByIds(deviceIds);
  366. //分组统计
  367. Map<Integer, Long> countNetstateMap = deviceStatuses.stream().collect(Collectors
  368. .groupingBy(DeviceStatus::getNetState, Collectors.counting()));
  369. Integer onlineDictValue = SysDictUtils.getValue(DictEnum.DEVICE_ONLINE_STATUS.getKey(), DictSonEnum.DEVICE_ONLINE_STATUS_CONNECTED.getKey(), Integer.class);
  370. Integer offlineDictValue = SysDictUtils.getValue(DictEnum.DEVICE_ONLINE_STATUS.getKey(), DictSonEnum.DEVICE_ONLINE_STATUS_DISCONNECT.getKey(), Integer.class);
  371. int onlineNum = countNetstateMap.get(onlineDictValue) == null ? 0 : countNetstateMap.get(onlineDictValue).intValue();
  372. int offlineNum = countNetstateMap.get(offlineDictValue) == null ? 0 : countNetstateMap.get(offlineDictValue).intValue();
  373. mercHomeStatisticalVO.setOnlineNum(onlineNum);
  374. mercHomeStatisticalVO.setOfflineNum(offlineNum);
  375. //运营、停业
  376. Map<Integer, Long> countBusyStateMap = mercDevices.stream().collect(Collectors
  377. .groupingBy(DeviceInfo::getBusyState, Collectors.counting()));
  378. Integer busyState1 = SysDictUtils.getValue(DictEnum.DEVICE_BUSY_STATUS.getKey(), DictSonEnum.DEVICE_BUSY_STATUS1.getKey(), Integer.class);
  379. Integer busyState2 = SysDictUtils.getValue(DictEnum.DEVICE_BUSY_STATUS.getKey(), DictSonEnum.DEVICE_BUSY_STATUS2.getKey(), Integer.class);
  380. int operatingNum = countBusyStateMap.get(busyState1) == null ? 0 : countBusyStateMap.get(busyState1).intValue();
  381. int closedNum = countBusyStateMap.get(busyState2) == null ? 0 : countBusyStateMap.get(busyState2).intValue();
  382. mercHomeStatisticalVO.setOperatingNum(operatingNum);
  383. mercHomeStatisticalVO.setClosedNum(closedNum);
  384. //待补货
  385. //TODO: 此逻辑需要确认
  386. return R.ok(mercHomeStatisticalVO);
  387. }
  388. @Override
  389. @ApiOperation("小程序-商户设备首页列表")
  390. public R<List<DeviceInfoDto.MercHomeListVO>> mercHomeList(DeviceInfoDto.MercHomeQueryDTO dto) {
  391. Long mercId = dto.getMercId();
  392. String deviceName = dto.getDeviceName();
  393. Long deviceId = dto.getDeviceId();
  394. List<DeviceInfoDto.MercHomeCountVO> list = this.baseMapper.merHomeCountList(dto);
  395. if (CollUtil.isEmpty(list)) {
  396. return R.ok(Collections.emptyList());
  397. }
  398. List<DeviceInfoDto.MercHomeListVO> dataList = new ArrayList<>(list.size());
  399. LambdaQueryWrapper<DeviceInfo> lqw = new LambdaQueryWrapper<>();
  400. lqw.eq(mercId != null, DeviceInfo::getMercId, mercId);
  401. lqw.eq(deviceId != null, DeviceInfo::getDeviceId, deviceId);
  402. lqw.like(StrUtil.isNotEmpty(deviceName), DeviceInfo::getDeviceName, deviceName);
  403. List<DeviceInfo> deviceInfoList = this.list(lqw);
  404. //未分配线路的设置默认值
  405. deviceInfoList.stream().filter(s -> s.getPlaceLineId() == null).forEach(s -> s.setPlaceLineId(-1L));
  406. //根据线路id分组
  407. Map<Long, List<DeviceInfo>> deviceMap = deviceInfoList.stream().collect(Collectors.groupingBy(DeviceInfo::getPlaceLineId));
  408. list.forEach(v -> {
  409. DeviceInfoDto.MercHomeListVO vo = new DeviceInfoDto.MercHomeListVO();
  410. Long placeLineId = v.getPlaceLineId();
  411. vo.setDeviceNum(v.getDeviceNum());
  412. vo.setPlaceLineId(v.getPlaceLineId());
  413. //线路下的设备列表
  414. List<DeviceInfoDto.MercHomeDeviceVo> deviceInfos = Beans.copy(DeviceInfoDto.MercHomeDeviceVo.class, deviceMap.get(placeLineId));
  415. //设备销售统计
  416. String type = SysDictUtils.getValue(DictEnum.DEVICE_DATA_TYPE.getKey(), DictSonEnum.DEVICE_DATA_TYPE_DAY.getKey(), String.class);
  417. String todayDate = DateUtil.format(new Date(), DatePattern.PURE_DATE_PATTERN);
  418. List<Long> deviceIds = deviceInfos.stream().map(DeviceInfoDto.MercHomeDeviceVo::getDeviceId).collect(Collectors.toList());
  419. //统计条件:当天
  420. DeviceDataDto.ListDTO deviceDataListDTO = new DeviceDataDto.ListDTO()
  421. .setDeviceIds(deviceIds).setType(type).setDateValue(Integer.valueOf(todayDate)).setMercId(mercId);
  422. List<DeviceDataDto.Vo> deviceDataList = deviceDataService.list(deviceDataListDTO);
  423. Map<Long, DeviceDataDto.Vo> dataMap = new HashMap<>();
  424. if (CollUtil.isNotEmpty(deviceDataList)) {
  425. dataMap = deviceDataList.stream().collect(Collectors.toMap(DeviceDataDto.Vo::getDeviceId, d -> d));
  426. }
  427. //设备状态查询
  428. List<DeviceStatusDto.Vo> deviceStatusList = deviceStatusService.list(new DeviceStatusDto.SelectList().setDeviceIds(deviceIds)).getData();
  429. Map<Long, DeviceStatusDto.Vo> datdeviceStatusMap = new HashMap<>();
  430. if (CollUtil.isNotEmpty(deviceStatusList)) {
  431. datdeviceStatusMap = deviceStatusList.stream().collect(Collectors.toMap(DeviceStatusDto.Vo::getDeviceId, d -> d));
  432. }
  433. Map<Long, DeviceDataDto.Vo> finalDataMap = dataMap;
  434. Map<Long, DeviceStatusDto.Vo> finalDatdeviceStatusMap = datdeviceStatusMap;
  435. deviceInfos.forEach(device -> {
  436. Long dId = device.getDeviceId();
  437. //设备类型 反显
  438. SysDictRedis dictDeviceType = SysDictUtils.get(DictConsts.DEVICE_TYPE, String.valueOf(device.getDeviceType()));
  439. device.setDeviceTypeName(dictDeviceType.getMsg());
  440. //运营状态 反显
  441. SysDictRedis dictBusyState = SysDictUtils.get(DictConsts.DEVICE_BUSY_STATUS, String.valueOf(device.getBusyState()));
  442. device.setBusyStateName(dictBusyState.getMsg());
  443. DeviceDataDto.Vo deviceData = finalDataMap.get(dId);
  444. //今日销售、库存情况 反显
  445. device.setDayOrderNum(deviceData != null ? deviceData.getSalesCount() : 0);
  446. device.setDaySalesPrice(deviceData != null ? deviceData.getSalesMoney() : 0);
  447. DeviceStatusDto.Vo deviceStatus = finalDatdeviceStatusMap.get(deviceId);
  448. device.setOnSaleNum(deviceStatus != null ? deviceStatus.getStock() : 0);
  449. device.setFillNum(deviceStatus != null ? deviceStatus.getAfterFillStock() : 0);
  450. });
  451. vo.setDeviceInfos(deviceInfos);
  452. dataList.add(vo);
  453. });
  454. return R.ok(dataList);
  455. }
  456. /**
  457. * 获取商户设备列表
  458. *
  459. * @param mercId
  460. * @return
  461. */
  462. private List<DeviceInfo> getDevicesByMercId(Long mercId) {
  463. return list(Wrappers.<DeviceInfo>lambdaQuery().eq(DeviceInfo::getMercId, mercId));
  464. }
  465. @ApiOperation("小程序商户设备搜索")
  466. @Override
  467. public R<PageBean<DeviceInfoDto.Vo2>> mercDeviceSearchPage(@RequestBody DeviceInfoDto.Page page) {
  468. //小程序独有查询字段 缺货状态:stockStatus ,是否查故障设备:fault
  469. Boolean fault = page.getFault();
  470. Long mercId = page.getMercId();
  471. if (BooleanUtil.isTrue(fault)) {
  472. //查询故障设备
  473. List<DeviceErrorsRecord> deviceErrorsRecords = deviceErrorsRecordService.list(Wrappers.<DeviceErrorsRecord>lambdaQuery()
  474. .eq(mercId != null, DeviceErrorsRecord::getMercId, page.getMercId()));
  475. List<Long> deviceIdList = deviceErrorsRecords.stream().map(DeviceErrorsRecord::getDeviceId).collect(Collectors.toList());
  476. if (CollUtil.isEmpty(deviceIdList)) {
  477. return R.ok(new PageBean<>());
  478. }
  479. page.setDeviceIdList(deviceIdList);
  480. }
  481. PageBean<DeviceInfoDto.Vo2> pageBean = queryPage(page);
  482. List<DeviceInfoDto.Vo2> records = pageBean.getRecords();
  483. if (CollUtil.isNotEmpty(records)) {
  484. List<Long> deviceIds = records.stream().map(DeviceInfoDto.Vo2::getDeviceId).collect(Collectors.toList());
  485. String type = SysDictUtils.getValue(DictEnum.DEVICE_DATA_TYPE.getKey(), DictSonEnum.DEVICE_DATA_TYPE_DAY.getKey(), String.class);
  486. String todayDate = DateUtil.format(new Date(), DatePattern.PURE_DATE_PATTERN);
  487. //查询当天
  488. DeviceDataDto.ListDTO dto = new DeviceDataDto.ListDTO()
  489. .setDeviceIds(deviceIds).setType(type).setDateValue(Integer.valueOf(todayDate)).setMercId(mercId);
  490. List<DeviceDataDto.Vo> deviceDataList = deviceDataService.list(dto);
  491. if (CollUtil.isNotEmpty(deviceDataList)) {
  492. //统计数据反显
  493. Map<Long, DeviceDataDto.Vo> dataMap = deviceDataList.stream().collect(Collectors.toMap(DeviceDataDto.Vo::getDeviceId, d -> d));
  494. records.forEach(v -> {
  495. Long deviceId = v.getDeviceId();
  496. DeviceDataDto.Vo vo = dataMap.get(deviceId);
  497. //今日订单数
  498. v.setDayOrderNum(vo != null ? vo.getSalesCount() : 0);
  499. v.setDaySalesPrice(vo != null ? vo.getSalesMoney() : 0);
  500. });
  501. pageBean.setRecords(records);
  502. }
  503. }
  504. return R.ok(pageBean);
  505. }
  506. @ApiOperation("小程序商户设备详情-数据统计")
  507. @Override
  508. public R<DeviceInfoDto.DeviceDataCountVO> dataCount(@RequestBody DeviceInfoDto.DeviceDataCountDTO dto) {
  509. // 统计类型(1=经营数据,2=经营图表,3=温度图表,4=信号图表,5=商品管理)
  510. Integer type = dto.getType();
  511. switch (type) {
  512. case 1:
  513. //经营数据
  514. return R.ok(dataCount1(dto));
  515. case 2:
  516. //经营图表
  517. return R.ok(dataCount2(dto));
  518. case 3:
  519. //温度图表
  520. return R.ok(dataCount3(dto));
  521. case 4:
  522. //信号图表
  523. return R.ok(dataCount4(dto));
  524. case 5:
  525. //商品管理
  526. return R.ok(dataCount5(dto));
  527. default:
  528. break;
  529. }
  530. return R.ok();
  531. }
  532. /**
  533. * 经营数据
  534. *
  535. * @param dto
  536. * @return
  537. */
  538. private DeviceInfoDto.DeviceDataCountVO dataCount1(DeviceInfoDto.DeviceDataCountDTO dto) {
  539. Long deviceId = dto.getDeviceId();
  540. Long mercId = dto.getMercId();
  541. DeviceInfoDto.DeviceDataCountVO vo = new DeviceInfoDto.DeviceDataCountVO();
  542. //当天
  543. DeviceDataDto.Vo dayData = deviceDataService.getByDay(deviceId, mercId, DateUtil.format(new Date(), DatePattern.PURE_DATE_PATTERN));
  544. //当月
  545. DeviceDataDto.Vo monthData = deviceDataService.getByMonth(deviceId, mercId, DateUtil.format(new Date(), DatePattern.SIMPLE_MONTH_PATTERN));
  546. vo.setDayBusinessData(copy(DeviceInfoDto.BusinessData.class, dayData));
  547. vo.setMonthBusinessData(copy(DeviceInfoDto.BusinessData.class, monthData));
  548. return vo;
  549. }
  550. /**
  551. * 经营图表
  552. *
  553. * @param dto
  554. * @return
  555. */
  556. private DeviceInfoDto.DeviceDataCountVO dataCount2(DeviceInfoDto.DeviceDataCountDTO dto) {
  557. DeviceInfoDto.DeviceDataCountVO vo = new DeviceInfoDto.DeviceDataCountVO();
  558. return vo;
  559. }
  560. /**
  561. * 温度图表
  562. *
  563. * @param dto
  564. * @return
  565. */
  566. private DeviceInfoDto.DeviceDataCountVO dataCount3(DeviceInfoDto.DeviceDataCountDTO dto) {
  567. DeviceInfoDto.DeviceDataCountVO vo = new DeviceInfoDto.DeviceDataCountVO();
  568. return vo;
  569. }
  570. /**
  571. * 信号图表
  572. *
  573. * @param dto
  574. * @return
  575. */
  576. private DeviceInfoDto.DeviceDataCountVO dataCount4(DeviceInfoDto.DeviceDataCountDTO dto) {
  577. DeviceInfoDto.DeviceDataCountVO vo = new DeviceInfoDto.DeviceDataCountVO();
  578. return vo;
  579. }
  580. /**
  581. * 商品管理
  582. *
  583. * @param dto
  584. * @return
  585. */
  586. private DeviceInfoDto.DeviceDataCountVO dataCount5(DeviceInfoDto.DeviceDataCountDTO dto) {
  587. DeviceInfoDto.DeviceDataCountVO vo = new DeviceInfoDto.DeviceDataCountVO();
  588. return vo;
  589. }
  590. private PageBean<DeviceInfoDto.Vo2> queryPage(DeviceInfoDto.Page page) {
  591. IPage<DeviceInfoQueryPage> iPage = baseMapper.queryPage(toIPage(page.getPage()), page);
  592. return toPageBean(DeviceInfoDto.Vo2.class, iPage);
  593. }
  594. private <T> void check(T value, T value2, String msg) {
  595. if (value.toString().equals(value2.toString())) {
  596. throw new CommRuntimeException(msg);
  597. }
  598. }
  599. }