DeviceInfoServiceImpl.java 35 KB

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