DeviceInfoServiceImpl.java 30 KB

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