TEquipmentController.java 90 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917
  1. package com.szwl.controller;
  2. import cn.com.crbank.ommo.bean.ResultMessage;
  3. import cn.com.crbank.ommo.esUtil.BeanUtils;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  6. import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
  7. import com.baomidou.mybatisplus.core.metadata.IPage;
  8. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  9. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  10. import com.gexin.fastjson.JSON;
  11. import com.qiniu.common.QiniuException;
  12. import com.qiniu.storage.BucketManager;
  13. import com.qiniu.storage.Configuration;
  14. import com.qiniu.storage.Region;
  15. import com.qiniu.storage.model.FileInfo;
  16. import com.qiniu.util.Auth;
  17. import com.szwl.annotation.Audit;
  18. import com.szwl.constant.AuditEnum;
  19. import com.szwl.constant.ConfigConsts;
  20. import com.szwl.constant.ResponseCodesEnum;
  21. import com.szwl.exception.BizException;
  22. import com.szwl.manager.TokenManager;
  23. import com.szwl.model.bean.*;
  24. import com.szwl.model.bo.R;
  25. import com.szwl.model.bo.ResponseModel;
  26. import com.szwl.model.bo.UserDetailBO;
  27. import com.szwl.model.entity.*;
  28. import com.szwl.model.param.PasswordParam;
  29. import com.szwl.model.query.StatisticsParam;
  30. import com.szwl.model.utils.DateUtils;
  31. import com.szwl.model.utils.PushUtils;
  32. import com.szwl.model.vo.EquipmentVO;
  33. import com.szwl.service.*;
  34. import com.szwl.util.DownloadUtils;
  35. import io.swagger.annotations.Api;
  36. import io.swagger.annotations.ApiOperation;
  37. import org.apache.commons.lang.StringUtils;
  38. import org.springframework.beans.factory.annotation.Autowired;
  39. import org.springframework.http.HttpStatus;
  40. import org.springframework.http.ResponseEntity;
  41. import org.springframework.web.bind.annotation.*;
  42. import javax.servlet.http.HttpServletResponse;
  43. import java.io.IOException;
  44. import java.net.URL;
  45. import java.net.URLConnection;
  46. import java.nio.file.Files;
  47. import java.nio.file.Paths;
  48. import java.text.SimpleDateFormat;
  49. import java.time.LocalDateTime;
  50. import java.time.LocalTime;
  51. import java.util.*;
  52. import java.util.concurrent.Executors;
  53. import java.util.concurrent.ScheduledExecutorService;
  54. import java.util.concurrent.ScheduledFuture;
  55. import java.util.concurrent.TimeUnit;
  56. import java.util.stream.Collectors;
  57. import static com.szwl.constant.ResponseCodesEnum.*;
  58. /**
  59. * <p>
  60. * 前端控制器
  61. * </p>
  62. *
  63. * @author wuhs
  64. * @since 2023-10-25
  65. */
  66. @Api(value = "/tEquipment", tags = {"设备控制器"})
  67. @RestController
  68. @RequestMapping("/tEquipment")
  69. public class TEquipmentController {
  70. @Autowired
  71. TEquipmentService tEquipmentService;
  72. @Autowired
  73. TEquipmentDescService equipmentDescService;
  74. @Autowired
  75. TAdminService tAdminService;
  76. @Autowired
  77. TParametersService parametersService;
  78. @Autowired
  79. TAlarmRecordService tAlarmRecordService;
  80. @Autowired
  81. TAreaService tAreaService;
  82. @Autowired
  83. TOrderService tOrderService;
  84. @Autowired
  85. TAdminEquipmentService tAdminEquipmentService;
  86. @Autowired
  87. TDiyFlowerService tDiyFlowerService;
  88. @Autowired
  89. TLabelService labelService;
  90. @Autowired
  91. TokenManager tokenManager;
  92. /**
  93. * 超时时间为30秒
  94. */
  95. private static final int TIMEOUT = 30000;
  96. @ApiOperation(value = "根据经纬度获取区域内设备信息")
  97. @GetMapping("/getEquipmentByLatLon")
  98. public ResponseModel<List<TEquipment>> getEquipmentByLatLon(String lat1, String lat2, String lon1, String lon2) {
  99. LambdaQueryWrapper<TEquipment> lqw = Wrappers.lambdaQuery();
  100. lqw.between(TEquipment::getLatitude, lat1, lat2)
  101. .between(TEquipment::getLongitude, lon1, lon2)
  102. .notLike(TEquipment::getClientId, "%xxx");
  103. List<TEquipment> equipmentList = tEquipmentService.list(lqw);
  104. return R.ok(equipmentList);
  105. }
  106. @ApiOperation(value = "设备是否存在")
  107. @GetMapping("/getEquipmentBool")
  108. public ResponseModel<Boolean> getEquipmentBool(String clientId) {
  109. if (StringUtils.isEmpty(clientId)) {
  110. return R.fail("clientId参数不能为空");
  111. }
  112. LambdaQueryWrapper<TEquipment> lqw = Wrappers.lambdaQuery();
  113. lqw.eq(TEquipment::getClientId, clientId);
  114. List<TEquipment> equipmentList = tEquipmentService.list(lqw);
  115. if (equipmentList.isEmpty()) {
  116. return R.fail("设备clientId不存在");
  117. } else if (equipmentList.size() > 1) {
  118. return R.fail("设备clientId不唯一");
  119. } else {
  120. return R.ok(true);
  121. }
  122. }
  123. /**
  124. * @param adminName 商户的登录名
  125. * @param equipmentName 机器名称
  126. * @param areaName 地址名-fullName
  127. */
  128. @ApiOperation(value = "查找机器列表")
  129. @PostMapping("/findList")
  130. public ResponseModel<IPage<?>> findList(Long id, String clientId, String adminName, String equipmentName,
  131. String areaName, String eqeStatus, String machineType, String equimentType,
  132. String channel, String companyType, String labelId, String todayDate, Long current, Long size) {
  133. UserDetailBO userDetailBO = Optional.ofNullable(tokenManager.getLoginUserDetails())
  134. .orElseThrow(() -> new BizException(ResponseCodesEnum.L0001));
  135. String adminId = userDetailBO.getId().toString();
  136. int authId = Integer.parseInt(adminId);
  137. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  138. TAdmin admin = tAdminService.getById(authId);
  139. // 申泽管理员
  140. if (authId == 2738) {
  141. companyType = "0";
  142. }
  143. // 七云管理员
  144. if (authId == 2739) {
  145. companyType = "1";
  146. }
  147. Integer type = admin.getType();
  148. if (type > 1) {
  149. if (type == 2) {
  150. query.eq(TEquipment::getAdminId, authId);
  151. }
  152. if (type == 3) {
  153. // TODO:
  154. // 查找该商家的所有子账户,一层一层寻找,一个账户只能关联一个账户,
  155. // t_admin,
  156. // parent_id 指的是子商家的上级 admin_id,
  157. // relation_id 指的是关联上级账户的 admin_id,
  158. // 需要增加一个下级账户的admin_id, sub_account
  159. // child_account 孩子账户有多个,不能这样
  160. //查找属于这个商家子账户的设备 todo
  161. TAdminEquipment adminEquipment = tAdminEquipmentService.getById(admin.getId());
  162. if (adminEquipment.getType().equals("0")) {
  163. //全部机器
  164. query.eq(TEquipment::getAdminId, admin.getParentId());
  165. } else {
  166. String equipmentIds = adminEquipment.getEquipmentIds();
  167. String[] strings = equipmentIds.split(",");
  168. query.in(TEquipment::getId, strings);
  169. }
  170. }
  171. }
  172. if (StringUtils.isNotEmpty(clientId)) {
  173. query.like(TEquipment::getClientId, clientId);
  174. }
  175. if (StringUtils.isNotEmpty(adminName) && !"admin".equals(adminName)) {
  176. LambdaQueryWrapper<TAdmin> adminQuery = Wrappers.lambdaQuery();
  177. adminQuery.eq(TAdmin::getUsername, adminName);
  178. List<TAdmin> list = tAdminService.list(adminQuery);
  179. if (!list.isEmpty()) {
  180. query.eq(TEquipment::getAdminId, list.get(0).getId());
  181. }
  182. }
  183. if (StringUtils.isNotEmpty(equipmentName)) {
  184. query.like(TEquipment::getName, equipmentName);
  185. }
  186. if (StringUtils.isNotEmpty(areaName)) {
  187. query.like(TEquipment::getFullName, areaName);
  188. }
  189. if (StringUtils.isNotEmpty(eqeStatus)) {
  190. query.eq(TEquipment::getEqeStatus, eqeStatus);
  191. }
  192. if (StringUtils.isNotEmpty(machineType)) {
  193. query.eq(TEquipment::getMachineType, machineType);
  194. }
  195. if (StringUtils.isNotEmpty(equimentType)) {
  196. query.eq(TEquipment::getEquimentType, equimentType);
  197. }
  198. if (StringUtils.isNotEmpty(channel)) {
  199. query.eq(TEquipment::getChannel, channel);
  200. }
  201. // 公司平台
  202. if (StringUtils.isNotEmpty(companyType)) {
  203. if (companyType.equals("0")) {
  204. query.isNull(TEquipment::getCompanyType)
  205. .or().eq(TEquipment::getCompanyType, companyType);
  206. } else {
  207. query.eq(TEquipment::getCompanyType, companyType);
  208. }
  209. }
  210. // 分组ID
  211. if (StringUtils.isNotEmpty(labelId)) {
  212. TLabel label = labelService.getById(labelId);
  213. String equipmentIds = label.getEquipmentIds();
  214. equipmentIds = equipmentIds.replace("\"", "").replace("[", "").replace("]", "");
  215. String[] split = equipmentIds.split(",");
  216. query.in(TEquipment::getId, split);
  217. }
  218. query.orderByDesc(TEquipment::getCreateDate);
  219. Page<TEquipment> page = new Page<>(current, size, true);
  220. IPage<TEquipment> iPage = tEquipmentService.page(page, query);
  221. Page<TEquipmentDTO> pageDTO = new Page<>(current, size, true);
  222. IPage<TEquipmentDTO> iPageDTO = pageDTO;
  223. iPageDTO.setCurrent(iPage.getCurrent());
  224. iPageDTO.setPages(iPage.getPages());
  225. iPageDTO.setSize(iPage.getSize());
  226. iPageDTO.setTotal(iPage.getTotal());
  227. List<TEquipment> list = iPage.getRecords();
  228. List<TEquipmentDTO> equipmentDTOList = list.stream().map(equipment -> {
  229. TEquipmentDTO equipmentDTO = new TEquipmentDTO();
  230. BeanUtils.copyPropertiesIgnoreNull(equipment, equipmentDTO, true);
  231. return equipmentDTO;
  232. }).collect(Collectors.toList());
  233. for (TEquipmentDTO equipmentDTO : equipmentDTOList) {
  234. // Date date = new Date();
  235. // SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  236. // Date date = null;
  237. // try {
  238. // date = sdf.parse(todayDate);
  239. // } catch (ParseException e) {
  240. // e.printStackTrace();
  241. // }
  242. LocalDateTime dateTime = LocalDateTime.parse(todayDate + "T00:00:00");
  243. // 获取前一天的0点时间
  244. LocalDateTime startDateTime = dateTime.minusDays(1).with(LocalTime.MIN);
  245. // 获取当天的24点时间
  246. LocalDateTime endDateTime = dateTime.with(LocalTime.MAX);
  247. // Calendar calendar = new GregorianCalendar();
  248. // Calendar calendarEnd = new GregorianCalendar();
  249. // calendar.setTime(date);
  250. // calendarEnd.setTime(date);
  251. //
  252. // calendar.set(Calendar.HOUR_OF_DAY, 0);
  253. // calendar.set(Calendar.MINUTE, 0);
  254. // calendar.set(Calendar.SECOND, 0);
  255. // calendar.set(Calendar.MILLISECOND, 0);
  256. //
  257. // calendarEnd.set(Calendar.HOUR_OF_DAY, 23);
  258. // calendarEnd.set(Calendar.MINUTE, 59);
  259. // calendarEnd.set(Calendar.SECOND, 59);
  260. // calendarEnd.set(Calendar.MILLISECOND, 999);
  261. // Date date_start = calendar.getTime();
  262. // Date date_end = calendarEnd.getTime();
  263. LambdaQueryWrapper<TAlarmRecord> query1 = Wrappers.lambdaQuery();
  264. query1.eq(TAlarmRecord::getEquipmentId, equipmentDTO.getId());
  265. query1.eq(TAlarmRecord::getIsEliminate, 0);
  266. query1.gt(TAlarmRecord::getOccurrenceTime, startDateTime);
  267. query1.le(TAlarmRecord::getOccurrenceTime, endDateTime);
  268. // query1.gt(TAlarmRecord::getCreateDate, date_start);
  269. // query1.le(TAlarmRecord::getCreateDate, date_end);
  270. query1.orderByDesc(TAlarmRecord::getLevel).orderByDesc(TAlarmRecord::getOccurrenceTime);
  271. List<TAlarmRecord> alarmRecordList = tAlarmRecordService.list(query1);
  272. if (alarmRecordList.size() > 0) {
  273. equipmentDTO.setHasTodayAlarm(true);
  274. equipmentDTO.setAlarmList(alarmRecordList);
  275. } else {
  276. equipmentDTO.setHasTodayAlarm(false);
  277. }
  278. TEquipmentDesc equipmentDesc = equipmentDescService.getById(equipmentDTO.getId());
  279. if (equipmentDesc != null) {
  280. equipmentDTO.setRedSugar(equipmentDesc.getRedSugar());
  281. equipmentDTO.setWasteWater(equipmentDesc.getWasteWater());
  282. equipmentDTO.setWater(equipmentDesc.getWater());
  283. equipmentDTO.setYellowSugar(equipmentDesc.getYellowSugar());
  284. equipmentDTO.setBlueSugar(equipmentDesc.getBlueSugar());
  285. equipmentDTO.setIsMaterialUse(equipmentDesc.getIsMaterialUse());
  286. equipmentDTO.setStick(equipmentDesc.getStick());
  287. equipmentDTO.setWhiteSugar(equipmentDesc.getWhiteSugar());
  288. equipmentDTO.setSleepDesc(equipmentDesc.getSleepDesc());
  289. equipmentDTO.setOutDoor(equipmentDesc.getOutDoor());
  290. equipmentDTO.setInDoor(equipmentDesc.getInDoor());
  291. equipmentDTO.setCupQuantity(equipmentDesc.getCupQuantity());
  292. equipmentDTO.setStirTm(equipmentDesc.getStirTm());
  293. equipmentDTO.setCornGeneratorTm(equipmentDesc.getCornGeneratorTm());
  294. equipmentDTO.setNumberOne(equipmentDesc.getNumberOne());
  295. equipmentDTO.setCandyGeneratorTm(equipmentDesc.getCandyGeneratorTm());
  296. equipmentDTO.setOutsideHd(equipmentDesc.getOutsideHd());
  297. equipmentDTO.setOutsideTm(equipmentDesc.getOutsideTm());
  298. equipmentDTO.setDiyFlowerStatus(equipmentDesc.getDiyFlowerStatus());
  299. equipmentDTO.setWorkingMode(equipmentDesc.getWorkingMode());
  300. }
  301. }
  302. iPageDTO.setRecords(equipmentDTOList);
  303. return R.ok(iPageDTO);
  304. }
  305. @ApiOperation(value = "id查找机器详情")
  306. @PostMapping("/findById")
  307. public ResponseModel<?> findById(@RequestParam Long id) {
  308. TEquipment equipment = tEquipmentService.getById(id);
  309. TEquipmentDTO equipmentDTO = new TEquipmentDTO();
  310. BeanUtils.copyPropertiesIgnoreNull(equipment, equipmentDTO, true);
  311. TEquipmentDesc equipmentDesc = equipmentDescService.getById(id);
  312. if (equipmentDesc != null) {
  313. equipmentDTO.setCouponStatus(equipmentDesc.getCouponStatus());
  314. equipmentDTO.setInDoor(equipmentDesc.getInDoor());
  315. equipmentDTO.setOutDoor(equipmentDesc.getOutDoor());
  316. if (equipmentDesc.getFlowers() != null) {
  317. equipmentDTO.setFlowers(equipmentDesc.getFlowers());
  318. }
  319. equipmentDTO.setNumberOne(equipmentDesc.getNumberOne());
  320. equipmentDTO.setCandyGeneratorTm(equipmentDesc.getCandyGeneratorTm());
  321. equipmentDTO.setOutsideHd(equipmentDesc.getOutsideHd());
  322. equipmentDTO.setOutsideTm(equipmentDesc.getOutsideTm());
  323. equipmentDTO.setDiyFlowerStatus(equipmentDesc.getDiyFlowerStatus());
  324. }
  325. String messageReceiver = equipment.getMessageReceiver();
  326. if (StringUtils.isNotEmpty(messageReceiver)) {
  327. String[] message = messageReceiver.split(",");
  328. int i = message.length;
  329. if (i > 0) {
  330. equipmentDTO.setMessageReceiver1(message[0]);
  331. }
  332. if (i > 1) {
  333. equipmentDTO.setMessageReceiver2(message[1]);
  334. }
  335. if (i > 2) {
  336. equipmentDTO.setMessageReceiver3(message[2]);
  337. }
  338. }
  339. return R.ok(equipmentDTO);
  340. }
  341. @ApiOperation(value = "id查找机器详情")
  342. @PostMapping("/findById2")
  343. public ResponseModel<TEquipment> findById2(@RequestParam Long id) {
  344. TEquipment equipment = tEquipmentService.getById(id);
  345. return R.ok(equipment);
  346. }
  347. @ApiOperation(value = "id查找机器详情")
  348. @GetMapping("/findEquipmentById")
  349. public ResponseModel<TEquipment> findEquipmentById(@RequestParam String id) {
  350. TEquipment equipment = tEquipmentService.getById(id);
  351. return R.ok(equipment);
  352. }
  353. @ApiOperation(value = "ClientId查找设备")
  354. @GetMapping("/findEquipmentByClientId")
  355. public ResponseModel<TEquipment> findEquipmentByClientId(@RequestParam String clientId) {
  356. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  357. query.eq(TEquipment::getClientId, clientId);
  358. TEquipment equipment = tEquipmentService.getOnly(query);
  359. return R.ok(equipment);
  360. }
  361. @ApiOperation(value = "获取对应的机器id")
  362. @GetMapping("/getClientIdList")
  363. public ResponseModel<TAdminEquipment> getClientIdList(@RequestParam String adminId) {
  364. //查找属于这个商家子账户的设备
  365. TAdminEquipment adminEquipment = tAdminEquipmentService.getById(adminId);
  366. return R.ok(adminEquipment);
  367. }
  368. @ApiOperation(value = "获取对应的机器编号")
  369. @GetMapping("/getClientIds")
  370. public ResponseModel<List<String>> getClientIds(@RequestParam String adminId) {
  371. //查找属于这个商家子账户的设备
  372. TAdminEquipment adminEquipment = tAdminEquipmentService.getById(adminId);
  373. String equipmentIds = adminEquipment.getEquipmentIds();
  374. // 分割保存在设备ID保存在list
  375. String[] tEquipmentIds = equipmentIds.split(",");
  376. List<String> list = Arrays.asList(tEquipmentIds);
  377. List<String> returnList = new ArrayList<>();
  378. if (list.size() > 0) {
  379. for (String id : list) {
  380. TEquipment equipment = tEquipmentService.getById(id);
  381. returnList.add(equipment.getClientId());
  382. }
  383. }
  384. return R.ok(returnList);
  385. }
  386. @ApiOperation(value = "获取机器列表 分页")
  387. @GetMapping("/pageEquipment2")
  388. public ResponseModel<IPage<TEquipment>> pageEquipment2(@RequestParam(value = "current") long current, @RequestParam(value = "size") long size) {
  389. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  390. Page<TEquipment> page = new Page<>(current, size, true);
  391. IPage<TEquipment> iPage = tEquipmentService.page(page, query);
  392. return R.ok(iPage);
  393. }
  394. @ApiOperation(value = "adminId查找设备")
  395. @GetMapping("/listEquipment")
  396. public ResponseModel<?> listEquipment(String adminId) {
  397. UserDetailBO userDetailBO = Optional.ofNullable(tokenManager.getLoginUserDetails())
  398. .orElseThrow(() -> new BizException(ResponseCodesEnum.L0001));
  399. String authId = userDetailBO.getId().toString();
  400. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  401. TAdmin admin = tAdminService.getById(authId);
  402. Integer type = admin.getType();
  403. if (type < 2) {
  404. query.eq(TEquipment::getAdminId, 238);
  405. }
  406. if (type == 2) {
  407. query.eq(TEquipment::getAdminId, authId);
  408. }
  409. if (type == 3) {
  410. //查找属于这个商家子账户的设备
  411. TAdminEquipment adminEquipment = tAdminEquipmentService.getById(admin.getId());
  412. if (adminEquipment.getType().equals("0")) {
  413. //全部机器
  414. query.eq(TEquipment::getAdminId, admin.getParentId());
  415. } else {
  416. String equipmentIds = adminEquipment.getEquipmentIds();
  417. String[] strings = equipmentIds.split(",");
  418. query.in(TEquipment::getId, strings);
  419. }
  420. }
  421. List<TEquipment> list = tEquipmentService.list(query);
  422. List<EquipmentVO> equipmentVOs = new ArrayList<>();
  423. Map<String, String> duplicateNames = new HashMap<>();
  424. for (TEquipment equipment : list) {
  425. String name = StringUtils.isEmpty(equipment.getName()) ? equipment.getClientId() : equipment.getName();
  426. String clientId = equipment.getClientId();
  427. if (duplicateNames.containsValue(name)) {
  428. name = clientId;
  429. }
  430. duplicateNames.put(String.valueOf(equipment.getId()), name);
  431. EquipmentVO equipmentVO = new EquipmentVO();
  432. equipmentVO.setId(equipment.getId());
  433. equipmentVO.setName(name);
  434. equipmentVO.setClientId(clientId);
  435. equipmentVOs.add(equipmentVO);
  436. }
  437. return R.ok(equipmentVOs);
  438. }
  439. @ApiOperation(value = "查找设备")
  440. @PostMapping("/getEquipmentByNameAndId")
  441. public ResponseModel<TEquipment> getEquipmentByNameAndId(@RequestBody TEquipment equipment) {
  442. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  443. TAdmin admin = tAdminService.getById(equipment.getId());
  444. if (admin.getType() == 3) {
  445. //子账户
  446. TAdmin parentAdmin = tAdminService.getById(admin.getParentId());
  447. LambdaQueryWrapper<TEquipment> query1 = Wrappers.lambdaQuery();
  448. query1.eq(TEquipment::getAdminId, parentAdmin.getId());
  449. List<TEquipment> list1 = tEquipmentService.list(query1);
  450. if (list1.size() > 0) {
  451. for (TEquipment tEquipment : list1) {
  452. if (equipment.getName().equals(tEquipment.getName())) {
  453. return R.ok(tEquipment);
  454. }
  455. }
  456. }
  457. }
  458. if (admin.getType() < 2) {
  459. query.eq(TEquipment::getName, equipment.getName());
  460. }
  461. if (admin.getType() == 2) {
  462. query.eq(TEquipment::getAdminId, equipment.getAdminId());
  463. query.eq(TEquipment::getName, equipment.getName());
  464. }
  465. List<TEquipment> list = tEquipmentService.list(query);
  466. TEquipment tEquipment = list.get(0);
  467. return R.ok(tEquipment);
  468. }
  469. /**
  470. * 更新
  471. */
  472. @ApiOperation(value = "更新机器")
  473. @RequestMapping(value = "/update", method = RequestMethod.POST)
  474. public ResponseModel<?> update(@RequestBody TEquipmentDTO equipment) {
  475. //获取修改前的设备
  476. TEquipment oldEquipment = tEquipmentService.getById(equipment.getId());
  477. if (StringUtils.isNotEmpty(equipment.getSn())) {
  478. oldEquipment.setSn(equipment.getSn());
  479. }
  480. String name = equipment.getName();
  481. if (StringUtils.isNotEmpty(name) && !name.equals(oldEquipment.getName())) {
  482. LambdaQueryWrapper<TEquipment> queryWrapper = new LambdaQueryWrapper<>();
  483. queryWrapper.eq(TEquipment::getAdminId, oldEquipment.getAdminId());
  484. queryWrapper.eq(TEquipment::getName, name);
  485. TEquipment tEquipment = tEquipmentService.getOne(queryWrapper);
  486. if (tEquipment != null) {
  487. return R.fail(A0001);
  488. }
  489. oldEquipment.setName(equipment.getName());
  490. }
  491. if (StringUtils.isNotEmpty(equipment.getSelfName())) {
  492. oldEquipment.setSelfName(equipment.getSelfName());
  493. }
  494. if (equipment.getAreaId() != null) {
  495. oldEquipment.setAreaId(equipment.getAreaId());
  496. }
  497. if (StringUtils.isNotEmpty(equipment.getContactName())) {
  498. oldEquipment.setContactName(equipment.getContactName());
  499. }
  500. if (StringUtils.isNotEmpty(equipment.getContactPhone())) {
  501. oldEquipment.setContactPhone(equipment.getContactPhone());
  502. }
  503. if (StringUtils.isNotEmpty(equipment.getOperationalName())) {
  504. oldEquipment.setOperationalName(equipment.getOperationalName());
  505. }
  506. if (StringUtils.isNotEmpty(equipment.getOperationalPhone())) {
  507. oldEquipment.setOperationalPhone(equipment.getOperationalPhone());
  508. }
  509. if (StringUtils.isNotEmpty(equipment.getOperator())) {
  510. oldEquipment.setOperator(equipment.getOperator());
  511. }
  512. if (StringUtils.isNotEmpty(equipment.getSimNo())) {
  513. oldEquipment.setSimNo(equipment.getSimNo());
  514. }
  515. if (equipment.getTimeRuleId() != null) {
  516. oldEquipment.setTimeRuleId(equipment.getTimeRuleId());
  517. }
  518. if (StringUtils.isNotEmpty(equipment.getPlcVersion())) {
  519. oldEquipment.setPlcVersion(equipment.getPlcVersion());
  520. }
  521. if (StringUtils.isNotEmpty(equipment.getChannel())) {
  522. oldEquipment.setChannel(equipment.getChannel());
  523. }
  524. if (equipment.getPayType() != null) {
  525. oldEquipment.setPayType(equipment.getPayType());
  526. }
  527. if (equipment.getEndDate() != null) {
  528. oldEquipment.setEndDate(equipment.getEndDate());
  529. }
  530. if (equipment.getAreaId() != null) {
  531. oldEquipment.setFullName(tAreaService.getById(equipment.getAreaId()).getFullName());
  532. }
  533. if (StringUtils.isNotEmpty(equipment.getFlowers())) {
  534. if (StringUtils.isEmpty(oldEquipment.getFlowers())) {
  535. //发信息
  536. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("flowers", equipment.getFlowers()).toString());
  537. }
  538. if (StringUtils.isNotEmpty(oldEquipment.getFlowers()) && !oldEquipment.getFlowers().equals(equipment.getFlowers())) {
  539. //发信息
  540. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("flowers", equipment.getFlowers()).toString());
  541. // 通知客户
  542. tEquipmentService.informClient(oldEquipment.getAdminId(), oldEquipment.getClientId());
  543. }
  544. // oldEquipment.setFlowers(equipment.getFlowers());
  545. }
  546. String[] message = new String[3];
  547. message[0] = equipment.getMessageReceiver1();
  548. message[1] = equipment.getMessageReceiver2();
  549. message[2] = equipment.getMessageReceiver3();
  550. if (message.length > 0) {
  551. oldEquipment.setMessageReceiver(message[0] + "," + message[1] + "," + message[2]);
  552. }
  553. tEquipmentService.updateById(oldEquipment);
  554. if (equipment.getPayType() != null) {
  555. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("payType", oldEquipment.getPayType().toString() + ":" + oldEquipment.getTimeRuleId()).toString());
  556. }
  557. if (StringUtils.isNotEmpty(oldEquipment.getContactName()) && StringUtils.isNotEmpty(oldEquipment.getContactPhone())) {
  558. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("phone", oldEquipment.getContactName() + ":" + oldEquipment.getContactPhone()).toString());
  559. }
  560. if (StringUtils.isNotEmpty(oldEquipment.getCompanyPhone())) {
  561. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("companyPhone", oldEquipment.getCompanyPhone()).toString());
  562. }
  563. if (StringUtils.isNotEmpty(oldEquipment.getPlcVersion())) {
  564. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("plcVersion", oldEquipment.getPlcVersion()).toString());
  565. }
  566. if (StringUtils.isNotEmpty(oldEquipment.getSelfName())) {
  567. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("selfName", oldEquipment.getSelfName()).toString());
  568. }
  569. if (oldEquipment.getTimeRuleId() != null) {
  570. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("pushTimeRule", oldEquipment.getTimeRuleId() + "").toString());
  571. }
  572. if (StringUtils.isNotEmpty(oldEquipment.getOperationalName())) {
  573. tEquipmentService.sentMessage(oldEquipment.getClientId(), PushUtils.buildJson("operational", oldEquipment.getOperationalName() + ":" + oldEquipment.getOperationalPhone()).toString());
  574. }
  575. return R.ok("null", "更新成功!");
  576. }
  577. @ApiOperation(value = "更新机器 整体")
  578. @PostMapping("/updateByEquipment")
  579. public ResponseModel<?> updateByEquipment(@RequestBody TEquipment equipment) {
  580. if (equipment != null && equipment.getId() != null) {
  581. equipment.setModifyDate(new Date());
  582. tEquipmentService.updateById(equipment);
  583. }
  584. return R.ok();
  585. }
  586. @ApiOperation(value = "查找机器")
  587. @PostMapping("/getEquipmentListByUser")
  588. public ResponseEntity<?> getEquipmentListByUser(@RequestBody TAdmin param) {
  589. List<TAdminDTO> resultList = new ArrayList<>();
  590. if ("admin".equals(param.getUsername())) { // 管理员查所有商家
  591. List<TAdmin> adminList = tAdminService.list();
  592. List<TEquipment> equipmentList = tEquipmentService.list();
  593. List<TAlarmRecord> alarmRecordList = tAlarmRecordService.list();
  594. //获取当前用户今天所有机器的所以警报信息
  595. List<TAlarmRecord> alarmList = tAlarmRecordService.getAlarmList(null);
  596. resultList = adminList.stream().map(e -> {
  597. TAdminDTO dto = new TAdminDTO();
  598. BeanUtils.copyPropertiesIgnoreNull(e, dto, true);
  599. List<TEquipmentDTO> selList = equipmentList.stream()
  600. .filter(equipment -> e.getId().equals(equipment.getAdminId())) // 查对应的设备
  601. .map(equipment -> {
  602. TEquipmentDTO equipmentDTO = new TEquipmentDTO();
  603. BeanUtils.copyPropertiesIgnoreNull(equipment, equipmentDTO, true);
  604. Optional<TAlarmRecord> op = alarmRecordList.stream().filter(alarm -> equipment.getClientId().equals(alarm.getClientId())).findFirst();
  605. if (op.isPresent()) {
  606. equipmentDTO.setAlarmContent(op.get().getAlarmContent());
  607. equipmentDTO.setOccurrenceTime(op.get().getOccurrenceTime());
  608. }
  609. //获取该机器的所有警报信息
  610. List<TAlarmRecord> eqAlarmList = alarmList.stream().filter(alarm -> equipment.getClientId().equals(alarm.getClientId())).collect(Collectors.toList());
  611. equipmentDTO.setAlarmList(eqAlarmList);
  612. if (eqAlarmList.size() > 0) {
  613. int i = 0;
  614. for (TAlarmRecord alarmRecord : eqAlarmList) {
  615. if (DateUtils.isSameDay(new Date(), alarmRecord.getOccurrenceTime())) {
  616. if (alarmRecord.getIsEliminate() == null || alarmRecord.getIsEliminate() == 0) {
  617. i++;
  618. }
  619. }
  620. }
  621. if (i > 0) {
  622. equipmentDTO.setHasTodayAlarm(true);
  623. } else {
  624. equipmentDTO.setHasTodayAlarm(false);
  625. }
  626. }
  627. return equipmentDTO;
  628. }).collect(Collectors.toList());
  629. dto.setEquipmentList(selList);
  630. return dto;
  631. }).collect(Collectors.toList());
  632. } else { // 只查当前商家的设备列表
  633. TAdminDTO dto = new TAdminDTO();
  634. BeanUtils.copyPropertiesIgnoreNull(param, dto, true);
  635. // 需要区分是否商家子账户
  636. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  637. query.eq(TEquipment::getAdminId, param.getId());
  638. List<TEquipment> equipmentList = tEquipmentService.list(query);
  639. List<TAlarmRecord> alarmRecordList = tAlarmRecordService.getLastAlarmRecord(param.getId());
  640. //获取当前用户今天所有机器的所以警报信息
  641. List<TAlarmRecord> alarmList = tAlarmRecordService.getAlarmList(param.getId());
  642. List<TEquipmentDTO> equipmentDTOList = equipmentList.stream().map(equipment -> {
  643. TEquipmentDTO equipmentDTO = new TEquipmentDTO();
  644. BeanUtils.copyPropertiesIgnoreNull(equipment, equipmentDTO, true);
  645. Optional<TAlarmRecord> op = alarmRecordList.stream().filter(alarm -> equipment.getClientId().equals(alarm.getClientId())).findFirst();
  646. if (op.isPresent()) {
  647. equipmentDTO.setAlarmContent(op.get().getAlarmContent());
  648. equipmentDTO.setOccurrenceTime(op.get().getOccurrenceTime());
  649. }
  650. //获取该机器的所有警报信息
  651. List<TAlarmRecord> eqAlarmList = alarmList.stream().filter(alarm -> equipment.getClientId().equals(alarm.getClientId())).collect(Collectors.toList());
  652. equipmentDTO.setAlarmList(eqAlarmList);
  653. if (eqAlarmList.size() > 0) {
  654. int i = 0;
  655. for (TAlarmRecord alarmRecord : eqAlarmList) {
  656. if (DateUtils.isSameDay(new Date(), alarmRecord.getOccurrenceTime())) {
  657. if (alarmRecord.getIsEliminate() == null || alarmRecord.getIsEliminate() == 0) {
  658. i++;
  659. }
  660. }
  661. }
  662. equipmentDTO.setHasTodayAlarm(i > 0);
  663. }
  664. return equipmentDTO;
  665. }).collect(Collectors.toList());
  666. dto.setEquipmentList(equipmentDTOList);
  667. resultList.add(dto);
  668. }
  669. return ResponseEntity.status(HttpStatus.OK)
  670. .body(new ResultMessage().setCode(true).setData(resultList).setMessage("SUCCESS"));
  671. }
  672. @ApiOperation(value = "消除报警")
  673. @PostMapping("/eliminate")
  674. public ResponseModel<?> eliminate(@RequestBody TAlarmRecord param) {
  675. TAlarmRecord tAlarmRecord = tAlarmRecordService.getById(param.getId());
  676. TEquipment equipment = tEquipmentService.getById(tAlarmRecord.getEquipmentId());
  677. if (equipment == null) {
  678. return R.fail(A0001, "设备不存在");
  679. }
  680. String machineType = equipment.getMachineType();
  681. if (StringUtils.isNotEmpty(machineType) && machineType.equals("2")) {
  682. // tAlarmRecord.setIsEliminate(1);
  683. // tAlarmRecordService.updateById(tAlarmRecord);
  684. // 消除过往的报警
  685. LambdaUpdateWrapper<TAlarmRecord> wrapper = Wrappers.lambdaUpdate();
  686. wrapper.eq(TAlarmRecord::getClientId, tAlarmRecord.getClientId());
  687. wrapper.eq(TAlarmRecord::getIsEliminate, 0);
  688. wrapper.le(TAlarmRecord::getCreateDate, new Date());
  689. wrapper.set(TAlarmRecord::getIsEliminate, 1);
  690. tAlarmRecordService.update(wrapper);
  691. } else {
  692. JSONObject kindData = new JSONObject();
  693. kindData.put("id", param.getId());
  694. kindData.put("content", tAlarmRecord.getAlarmContent());
  695. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("eliminate", kindData.toString()).toString());
  696. }
  697. return R.ok();
  698. }
  699. @ApiOperation(value = "修改机器音量")
  700. @PostMapping("/updateVolume")
  701. public ResponseEntity<?> updateVolume(@RequestBody TEquipment equipment) {
  702. if (!StringUtils.isEmpty(equipment.getVolume())) {
  703. TEquipment tEquipment = tEquipmentService.getById(equipment.getId());
  704. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("volume", equipment.getVolume()).toString());
  705. }
  706. return ResponseEntity.status(HttpStatus.OK)
  707. .body(new ResultMessage().setCode(true).setData(true).setMessage("修改成功"));
  708. }
  709. @ApiOperation(value = "修改机器信息")
  710. @PostMapping("/updateEquipment")
  711. public ResponseEntity<?> updateEquipment(@RequestBody TEquipment equipment) {
  712. TEquipment equipment1 = tEquipmentService.getById(equipment.getId());
  713. Integer type = equipment.getType();
  714. //修改基本信息
  715. if (type == 0) {
  716. equipment1.setName(equipment.getName());
  717. equipment1.setSimNo(equipment.getSimNo());
  718. equipment1.setOperator(equipment.getOperator());
  719. }
  720. //修改后台密码
  721. if (type == 1) {
  722. equipment1.setAdminPwd(equipment.getAdminPwd());
  723. equipment1.setGuestPwd(equipment.getGuestPwd());
  724. tEquipmentService.sentMessage(equipment1.getClientId(), PushUtils.buildJson("guestPwd", equipment1.getGuestPwd()).toString());
  725. tEquipmentService.sentMessage(equipment1.getClientId(), PushUtils.buildJson("adminPwd", equipment1.getAdminPwd()).toString());
  726. // PushUtils.push(equipment1.getGtClientId(), "【棉花糖】设备管理-更改密码", "修改guest密码", PushUtils.buildJson("guestPwd", equipment1.getGuestPwd()).toString());
  727. // PushUtils.push(equipment1.getGtClientId(), "【棉花糖】设备管理-更改密码", "修改admin密码", PushUtils.buildJson("adminPwd", equipment1.getAdminPwd()).toString());
  728. }
  729. //定时开机
  730. // if (type == 3) {
  731. // equipment1.setBootTime(equipment.getBootTime());
  732. // tEquipmentService.sentMessage(equipment1.getClientId(),PushUtils.buildJson("updateBootTime", equipment.getBootTime()).toString());
  733. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("updateBootTime", equipment.getBootTime()).toString());
  734. // }
  735. //定时关机
  736. // if (type == 4) {
  737. // equipment1.setOffTime(equipment.getOffTime());
  738. // tEquipmentService.sentMessage(equipment1.getClientId(), PushUtils.buildJson("updateOffTime", equipment.getBootTime()).toString());
  739. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("updateOffTime", equipment.getBootTime()).toString());
  740. // }
  741. if (type == 5) {
  742. equipment1.setMessageReceiver(equipment.getMessageReceiver());
  743. }
  744. Boolean t = tEquipmentService.updateById(equipment1);
  745. if (t) {
  746. return ResponseEntity.status(HttpStatus.OK)
  747. .body(new ResultMessage().setCode(true).setData(equipment1).setMessage("修改成功"));
  748. } else {
  749. return ResponseEntity.status(HttpStatus.OK)
  750. .body(new ResultMessage().setCode(false).setData(t).setMessage("修改失败"));
  751. }
  752. }
  753. @ApiOperation(value = "根据机器id获取用户信息")
  754. @PostMapping("/findByEquipment")
  755. public ResponseEntity<?> findByEquipment(@RequestBody TEquipment equipment) {
  756. TEquipment tEquipment = tEquipmentService.getById(equipment.getId());
  757. TAdmin tAdmin = tAdminService.getById(tEquipment.getAdminId());
  758. return ResponseEntity.status(HttpStatus.OK)
  759. .body(new ResultMessage().setCode(false).setData(tAdmin).setMessage(""));
  760. }
  761. @ApiOperation(value = "根据机器编号获取用户信息")
  762. @PostMapping("/getEquipmentListLikeClientId")
  763. public ResponseEntity<?> getEquipmentListLikeClientId(@RequestBody TEquipment equipment) {
  764. if (StringUtils.isEmpty(equipment.getClientId())) {
  765. return ResponseEntity.status(HttpStatus.OK)
  766. .body(new ResultMessage().setCode(false).setData("").setMessage("设备编号为空"));
  767. }
  768. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  769. query.like(TEquipment::getClientId, equipment.getClientId());
  770. List<TEquipment> list = tEquipmentService.list(query);
  771. return ResponseEntity.status(HttpStatus.OK)
  772. .body(new ResultMessage().setCode(true).setData(list).setMessage(""));
  773. }
  774. @ApiOperation(value = "脱机")
  775. @PostMapping("/tuoji")
  776. @Audit(type = AuditEnum.OFFLINE, content = "#equipment.adminUserName + '对设备' + #equipment.clientId + '进行了脱机操作'")
  777. public ResponseEntity<?> tuoji(@RequestBody TEquipment equipment) {
  778. if (equipment.getId() == null) {
  779. return ResponseEntity.status(HttpStatus.OK)
  780. .body(new ResultMessage().setCode(false).setData("").setMessage(""));
  781. }
  782. TEquipment tEquipment = tEquipmentService.getById(equipment.getId());
  783. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("tuoji", "0").toString());
  784. if ("xxx".equals(tEquipment.getClientId().substring(tEquipment.getClientId().length() - 3))) {
  785. return ResponseEntity.status(HttpStatus.OK)
  786. .body(new ResultMessage().setCode(true).setData("").setMessage("发送成功!"));
  787. }
  788. tEquipment.setClientId(tEquipment.getClientId() + "xxx");
  789. tEquipmentService.updateById(tEquipment);
  790. return ResponseEntity.status(HttpStatus.OK)
  791. .body(new ResultMessage().setCode(true).setData("").setMessage("发送成功!"));
  792. }
  793. @ApiOperation(value = "一键补料")
  794. @GetMapping("/buliao")
  795. public ResponseModel<?> buliao(String equipmentId) {
  796. TEquipment equipment = tEquipmentService.getById(equipmentId);
  797. if (equipment == null || equipment.getId() == null) {
  798. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  799. }
  800. TEquipmentDesc tEquipmentDesc = equipmentDescService.getById(equipment.getId());
  801. if (tEquipmentDesc != null) {
  802. tEquipmentDesc.setBlueSugar("100");
  803. tEquipmentDesc.setRedSugar("100");
  804. tEquipmentDesc.setStick("100");
  805. tEquipmentDesc.setWhiteSugar("100");
  806. tEquipmentDesc.setYellowSugar("100");
  807. tEquipmentDesc.setWater("100");
  808. tEquipmentDesc.setWasteWater("0");
  809. equipmentDescService.updateById(tEquipmentDesc);
  810. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("buliao", "buliao").toString());
  811. } else {
  812. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  813. }
  814. return R.ok(null, "发送请求成功");
  815. }
  816. @ApiOperation(value = "修改优惠券开关状态")
  817. @GetMapping("/updateCouponStatus")
  818. public ResponseModel<?> updateCouponStatus(String equipmentId, String couponStatus) {
  819. if (StringUtils.isEmpty(couponStatus) || StringUtils.isEmpty(equipmentId)) {
  820. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  821. }
  822. TEquipment equipment = tEquipmentService.getById(equipmentId);
  823. if (equipment == null || equipment.getId() == null) {
  824. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  825. }
  826. TEquipmentDesc tEquipmentDesc = equipmentDescService.getById(equipment.getId());
  827. if (tEquipmentDesc != null) {
  828. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("couponStatus", couponStatus).toString());
  829. } else {
  830. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  831. }
  832. return R.ok(null, "修改成功");
  833. }
  834. @ApiOperation(value = "查找设备")
  835. @PostMapping("/findEquipment")
  836. public ResponseEntity<?> findEquipment(@RequestBody TEquipment equipment) {
  837. TEquipment tEquipment = tEquipmentService.getById(equipment.getId());
  838. return ResponseEntity.status(HttpStatus.OK)
  839. .body(new ResultMessage().setCode(false).setData(tEquipment).setMessage(""));
  840. }
  841. @ApiOperation(value = "获取机器数量")
  842. @PostMapping("/getMachineNum")
  843. public ResponseModel<?> getMachineNum(@RequestBody StatisticsParam param) {
  844. UserDetailBO userDetailBO = Optional.ofNullable(tokenManager.getLoginUserDetails())
  845. .orElseThrow(() -> new BizException(ResponseCodesEnum.L0001));
  846. String machineTotalNum;
  847. String machineUseNum;
  848. String equipmentId = param.getEquipmentId();
  849. String paramAdminId = userDetailBO.getId().toString();
  850. // String paramAdminId = param.getAdminId();
  851. TAdmin admin = tAdminService.getById(paramAdminId);
  852. Integer type = admin.getType();
  853. if (type < 2) {
  854. param.setAdminId(null);
  855. }
  856. // 公司平台
  857. // 申泽平台管理员
  858. if (admin.getId() == 2738) {
  859. param.setCompanyType("0");
  860. }
  861. // 七云平台管理员
  862. if (admin.getId() == 2739) {
  863. param.setCompanyType("1");
  864. }
  865. //判断是否有机器id传入
  866. if (equipmentId != null && !equipmentId.equals("")) {
  867. Long id = Long.valueOf(equipmentId);
  868. TEquipment equipment = tEquipmentService.getById(id);
  869. Long adminId = equipment.getAdminId();
  870. String dminId = String.valueOf(adminId);
  871. param.setAdminId(dminId);
  872. // 需要区分是否商家子账户
  873. }
  874. // 如果是子账户商家
  875. if (type == 3) {
  876. // 查找属于这个子账户的设备
  877. TAdminEquipment adminEquipment = tAdminEquipmentService.getById(paramAdminId);
  878. if (!adminEquipment.getType().equals("0")) {
  879. //全部机器
  880. // } else {
  881. String adminEquipmentIds = adminEquipment.getEquipmentIds();
  882. List<String> equipmentIds = Arrays.asList(adminEquipmentIds.split(","));
  883. param.setEquipmentIds(equipmentIds);
  884. }
  885. param.setAdminId(String.valueOf(admin.getParentId()));
  886. }
  887. machineTotalNum = tEquipmentService.findMachineTotalNum(param);
  888. // machineUseNum = tEquipmentService.findMachineUseNum(param);
  889. switch (type) {
  890. case 0:
  891. case 1:
  892. machineUseNum = tEquipmentService.findMachineUseNumAdmin(param);
  893. break;
  894. case 2:
  895. case 3:
  896. machineUseNum = tEquipmentService.findMachineUseNum(param);
  897. break;
  898. default:
  899. throw new IllegalArgumentException("未知等级");
  900. }
  901. Map<String, String> map = new HashMap<>();
  902. map.put("machineTotalNum", machineTotalNum);
  903. map.put("machineUseNum", machineUseNum);
  904. List<String> list = new ArrayList<>();
  905. list.add(machineTotalNum);
  906. list.add(machineUseNum);
  907. return R.ok(map, "获取成功");
  908. }
  909. @ApiOperation(value = "推送设备密码")
  910. @PostMapping("/updatePassword")
  911. public ResponseModel<?> updatePassword(@RequestBody PasswordParam passwordParam) {
  912. String equipmentId = passwordParam.getEquipmentId();
  913. String adminPwd = passwordParam.getAdminPwd();
  914. String guestPwd = passwordParam.getGuestPwd();
  915. TEquipment tEquipment = tEquipmentService.getById(equipmentId);
  916. if (tEquipment == null) {
  917. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  918. }
  919. if (StringUtils.isNotEmpty(guestPwd)) {
  920. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("guestPwd", guestPwd).toString());
  921. tEquipment.setGuestPwd(guestPwd);
  922. }
  923. if (StringUtils.isNotEmpty(adminPwd)) {
  924. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("adminPwd", adminPwd).toString());
  925. tEquipment.setAdminPwd(adminPwd);
  926. }
  927. tEquipmentService.updateById(tEquipment);
  928. return R.ok(null, "修改成功");
  929. }
  930. @ApiOperation(value = "远程开门")
  931. @PostMapping("/openDoor")
  932. public ResponseEntity<?> openDoor(@RequestBody StatisticsParam param) {
  933. String equipmentId = param.getEquipmentId();
  934. Long id = Long.valueOf(equipmentId);
  935. TEquipment equipment = tEquipmentService.getById(id);
  936. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("openDoor", "0").toString());
  937. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("openDoor", "0").toString());
  938. return ResponseEntity
  939. .status(HttpStatus.OK)
  940. .body(new ResultMessage()
  941. .setCode(true)
  942. .setData("SUCCESS")
  943. .setMessage("SUCCESS"));
  944. }
  945. //修改机器状态 type(类型,0:外门,1:内门), status(状态:0:关闭,1:开启)
  946. @ApiOperation(value = "远程开门")
  947. @GetMapping("/openDoors")
  948. public ResponseModel<?> openDoor(String equipmentId, String type, String status) {
  949. if (StringUtils.isEmpty(equipmentId) || StringUtils.isEmpty(type) || StringUtils.isEmpty(status)) {
  950. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  951. }
  952. TEquipment equipment = tEquipmentService.getById(equipmentId);
  953. if (equipment == null || equipment.getId() == null) {
  954. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  955. }
  956. if (type.equals("0")) {
  957. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("outdoor", status).toString());
  958. } else if (type.equals("1")) {
  959. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("indoor", status).toString());
  960. }
  961. return R.ok(null, "修改成功");
  962. }
  963. @ApiOperation(value = "查看是否远程来关机成功")
  964. @PostMapping("/checkStatus")
  965. public ResponseEntity<?> checkStatus(@RequestBody StatisticsParam param) {
  966. String equipmentId = param.getEquipmentId();
  967. Long id = Long.valueOf(equipmentId);
  968. TEquipment equipment = tEquipmentService.getById(id);
  969. String network = equipment.getNetwork();
  970. Long nowTime2 = getNetworkTime();
  971. // Long nowTime2 = new Date().getTime();
  972. if (network != null) {
  973. Long old = Long.valueOf(network);
  974. if (nowTime2 == null) {
  975. nowTime2 = getNetworkTime();
  976. }
  977. if (nowTime2 == null) {
  978. nowTime2 = System.currentTimeMillis();
  979. }
  980. if (nowTime2 - old < 15000) {
  981. return ResponseEntity
  982. .status(HttpStatus.OK)
  983. .body(new ResultMessage()
  984. .setCode(true)
  985. .setData("SUCCESS")
  986. .setMessage("网络良好"));
  987. } else {
  988. // if(equipment.getEqeStatus()==0){
  989. // equipment.setEqeStatus(1);
  990. // tEquipmentService.updateById(equipment);
  991. // }else {
  992. // equipment.setEqeStatus(0);
  993. // tEquipmentService.updateById(equipment);
  994. // }
  995. return ResponseEntity
  996. .status(HttpStatus.OK)
  997. .body(new ResultMessage()
  998. .setCode(true)
  999. .setData("fail")
  1000. .setMessage("网络不好,操作失败"));
  1001. }
  1002. } else {
  1003. return ResponseEntity
  1004. .status(HttpStatus.OK)
  1005. .body(new ResultMessage()
  1006. .setCode(true)
  1007. .setData("SUCCESS")
  1008. .setMessage("该机器尚未更新系统"));
  1009. }
  1010. }
  1011. public static Long getNetworkTime() {
  1012. Long time = null;
  1013. URL url;//取得资源对象http://time.tianqi.com/
  1014. try {
  1015. url = new URL("http://time.tianqi.com");
  1016. URLConnection uc = url.openConnection();//生成连接对象
  1017. uc.connect(); //发出连接
  1018. long ld = uc.getDate(); //取得网站日期时间
  1019. Date date = new Date(ld); //转换为标准时间对象
  1020. time = date.getTime();
  1021. } catch (Exception e) {
  1022. e.printStackTrace();
  1023. }
  1024. return time;
  1025. }
  1026. @ApiOperation(value = "机器睡眠")
  1027. @PostMapping("/sleep")
  1028. public ResponseEntity<?> sleep(@RequestBody StatisticsParam param) {
  1029. String equipmentId = param.getEquipmentId();
  1030. Long id = Long.valueOf(equipmentId);
  1031. TEquipment equipment = tEquipmentService.getById(id);
  1032. // if (equipment == null) {
  1033. // return ERROR_MESSAGE;
  1034. // }
  1035. String eqeStatus = "0";
  1036. String code = param.getEqeStatus();
  1037. if (code.equals("1")) {
  1038. eqeStatus = "1";
  1039. equipment.setIsSleep(true);
  1040. } else {
  1041. equipment.setIsSleep(false);
  1042. }
  1043. tEquipmentService.updateById(equipment);
  1044. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("is_sleep", eqeStatus).toString());
  1045. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("is_sleep", eqeStatus).toString());
  1046. return ResponseEntity
  1047. .status(HttpStatus.OK)
  1048. .body(new ResultMessage()
  1049. .setCode(true)
  1050. .setData("SUCCESS")
  1051. .setMessage("SUCCESS"));
  1052. }
  1053. @ApiOperation(value = "获取机器开关机状态")
  1054. @PostMapping("/onOffStatus")
  1055. public ResponseModel<?> onOffStatus(@RequestBody StatisticsParam param) {
  1056. String equipmentId = param.getEquipmentId();
  1057. Long id = Long.valueOf(equipmentId);
  1058. TEquipment equipments = tEquipmentService.getById(id);
  1059. tEquipmentService.sentMessage(equipments.getClientId(), PushUtils.buildJson("onoffstatus", "0").toString());
  1060. return R.ok();
  1061. }
  1062. @ApiOperation(value = "获取所有机器开关机状态")
  1063. @PostMapping("/equipmentStatus")
  1064. public ResponseModel<?> equipmentStatus(@RequestBody StatisticsParam param) {
  1065. String adminId = param.getAdminId();
  1066. //碧桂园的机器太多,不查
  1067. if (adminId.equals("236") || adminId.equals("31")) {
  1068. return R.ok();
  1069. }
  1070. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  1071. query.eq(TEquipment::getAdminId, Long.valueOf(adminId));
  1072. List<TEquipment> equipmentList = tEquipmentService.list(query);
  1073. if (equipmentList.size() > 0) {
  1074. for (TEquipment equipment : equipmentList) {
  1075. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("onoffstatus", "0").toString());
  1076. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("onoffstatus", "0").toString());
  1077. }
  1078. }
  1079. return R.ok();
  1080. }
  1081. @ApiOperation(value = "检验所有机器是否开机")
  1082. @PostMapping("/checkEquipmentStatus")
  1083. public ResponseModel<?> checkEquipmentStatus(@RequestBody StatisticsParam param) {
  1084. // 通过管理员ID查询所有设备
  1085. String adminId = param.getAdminId();
  1086. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  1087. query.eq(TEquipment::getAdminId, Long.valueOf(adminId));
  1088. List<TEquipment> equipmentList = tEquipmentService.list(query);
  1089. // 获取当前时间,并检查设备状态是否过期
  1090. long nowTime = System.currentTimeMillis();
  1091. if (equipmentList.size() > 0) {
  1092. for (TEquipment equipment : equipmentList) {
  1093. // 如果设备的最后修改时间超过310秒前,则清除设备状态信息
  1094. long modifyTime = equipment.getModifyDate().getTime();
  1095. if (nowTime > modifyTime && (nowTime - modifyTime) > 310000) {
  1096. equipment.setCabinetTm("");
  1097. equipment.setCabinetHd("");
  1098. equipment.setFurnaceTm("");
  1099. equipment.setFurnaceSp("");
  1100. tEquipmentService.updateById(equipment);
  1101. }
  1102. }
  1103. }
  1104. // 返回操作成功的响应
  1105. return R.ok();
  1106. }
  1107. @ApiOperation(value = "雪糕机机器复位")
  1108. @PostMapping("/machineReset")
  1109. public ResponseModel<?> machineReset(@RequestBody StatisticsParam param) {
  1110. String equipmentId = param.getEquipmentId();
  1111. Long id = Long.valueOf(equipmentId);
  1112. TEquipment equipment = tEquipmentService.getById(id);
  1113. if (equipment == null) {
  1114. return R.fail(F0002,"设备不存在");
  1115. }
  1116. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("machineReset", "machineReset").toString());
  1117. return R.ok();
  1118. }
  1119. @ApiOperation(value = "机器开关机")
  1120. @PostMapping("/onOff")
  1121. public ResponseEntity<?> onOff(@RequestBody StatisticsParam param) {
  1122. String equipmentId = param.getEquipmentId();
  1123. Long id = Long.valueOf(equipmentId);
  1124. TEquipment equipment = tEquipmentService.getById(id);
  1125. String eqeStatus = "1";
  1126. String code = param.getEqeStatus();
  1127. //开机为1,关机为0
  1128. if (code.equals("0")) {
  1129. eqeStatus = "0";
  1130. equipment.setEqeStatus(0);
  1131. } else {
  1132. equipment.setEqeStatus(1);
  1133. }
  1134. Long time = getNetworkTime();
  1135. if (time == null) {
  1136. time = getNetworkTime();
  1137. }
  1138. if (time == null) {
  1139. time = System.currentTimeMillis();
  1140. }
  1141. if (time != null) {
  1142. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("eqeStatus", eqeStatus, String.valueOf(time), "http://time.tianqi.com").toString());
  1143. } else {
  1144. return ResponseEntity
  1145. .status(HttpStatus.OK)
  1146. .body(new ResultMessage()
  1147. .setCode(false)
  1148. .setData("error")
  1149. .setMessage("error"));
  1150. }
  1151. return ResponseEntity
  1152. .status(HttpStatus.OK)
  1153. .body(new ResultMessage()
  1154. .setCode(true)
  1155. .setData("SUCCESS")
  1156. .setMessage("SUCCESS"));
  1157. }
  1158. @ApiOperation(value = "获取各省份机器销售情况")
  1159. @PostMapping("/getEquipmentListByProvince")
  1160. public ResponseEntity<?> getEquipmentListByProvince(@RequestBody TAdmin param) {
  1161. List<TAdminDTO> resultList = new ArrayList<>();
  1162. if ("admin".equals(param.getUsername())) { // 管理员查所有商家
  1163. //获取有多少个省份
  1164. List<TArea> list1 = tAreaService.getProvinceList();
  1165. Map<Long, String> map1 = new HashMap<>();
  1166. for (TArea area : list1) {
  1167. String fullname = area.getFullName();
  1168. String provinceName = fullname.substring(0, 3);
  1169. String treePath = area.getTreePath();
  1170. String[] str = treePath.split(",");
  1171. Long s = null;
  1172. if (str.length > 1) {
  1173. s = Long.valueOf(str[1]);
  1174. }
  1175. if (str.length <= 1) {
  1176. s = area.getId();
  1177. }
  1178. map1.put(s, provinceName);
  1179. }
  1180. List<Children3> children3List = new ArrayList<>();
  1181. for (Long key : map1.keySet()) {
  1182. Children3 children3 = new Children3();
  1183. children3.setId(key);
  1184. // children3.setName(map1.get(key));
  1185. int pday = 0;
  1186. int pweek = 0;
  1187. int pmonth = 0;
  1188. int pyear = 0;
  1189. Set<Long> province = new HashSet<>();
  1190. //本省有多少个市
  1191. Map<Long, String> cityMap = new HashMap<>();
  1192. for (TArea carea : list1) {
  1193. String fullName = carea.getFullName();
  1194. if (fullName.substring(0, 3).equals(map1.get(key))) {
  1195. province.add(carea.getId());
  1196. if (key.equals(carea.getParent())) {
  1197. cityMap.put(carea.getId(), carea.getName());
  1198. } else {
  1199. TArea cityArea = tAreaService.getById(carea.getParent());
  1200. cityMap.put(cityArea.getId(), cityArea.getName());
  1201. }
  1202. }
  1203. }
  1204. List<Children2> children2List = new ArrayList<>();
  1205. //有多少个市,市有多少个商家
  1206. for (Long citykey : cityMap.keySet()) {
  1207. for (TArea area : list1) {
  1208. String fullName = area.getFullName();
  1209. if (fullName.substring(0, 3).equals(map1.get(key))) {
  1210. //市级
  1211. Children2 children2 = new Children2();
  1212. //市级下所有商家集合
  1213. List<Child> Children = new ArrayList<>();
  1214. //属于这个市的所以设备的areaid
  1215. Set<Long> city = new HashSet<>();
  1216. //添加市级
  1217. if ((area.getId()).equals(citykey) || (area.getParent()).equals(citykey)) {
  1218. children2.setId(citykey);
  1219. for (TArea cityArea2 : list1) {
  1220. if ((cityArea2.getId()).equals(citykey) || (cityArea2.getParent()).equals(citykey)) {
  1221. city.add(cityArea2.getId());
  1222. }
  1223. }
  1224. children2.setCity(city);
  1225. int i = 0;
  1226. for (Children2 children21 : children2List) {
  1227. if (children21.getId().equals(citykey)) {
  1228. i++;
  1229. }
  1230. }
  1231. if (i == 0) {
  1232. for (Long id : city) {
  1233. // List<Childlast> childlasts = new ArrayList<>();
  1234. Set<Long> adminIds = new HashSet<>();
  1235. // List<TEquipment> equipments = tEquipmentService.findByArea(id);
  1236. LambdaQueryWrapper<TEquipment> query = Wrappers.lambdaQuery();
  1237. query.eq(TEquipment::getAreaId, id);
  1238. List<TEquipment> equipments = tEquipmentService.list(query);
  1239. for (TEquipment tEquipment : equipments) {
  1240. adminIds.add(tEquipment.getAdminId());
  1241. }
  1242. for (Long adminId3 : adminIds) {
  1243. TAdmin tAdmin = tAdminService.getById(adminId3);
  1244. int k = 0;
  1245. for (Child child : Children) {
  1246. if (child.getId().equals(tAdmin.getId())) {
  1247. k++;
  1248. }
  1249. }
  1250. if (k == 0) {
  1251. //new
  1252. Child child = new Child();
  1253. child.setId(adminId3);
  1254. child.setName(tAdmin.getName());
  1255. List<Childlast> children = new ArrayList<>();
  1256. Childlast childlast1 = new Childlast();
  1257. childlast1.setId(adminId3);
  1258. childlast1.setName("总销售情况");
  1259. children.add(0, childlast1);
  1260. // List<TEquipment> tEquipmentList = tEquipmentService.findByAdmin(adminId3);
  1261. LambdaQueryWrapper<TEquipment> query1 = Wrappers.lambdaQuery();
  1262. query1.eq(TEquipment::getAdminId, adminId3);
  1263. List<TEquipment> tEquipmentList = tEquipmentService.list(query1);
  1264. for (TEquipment tEquipment : tEquipmentList) {
  1265. Long areaId = tEquipment.getAreaId();
  1266. for (Long idd : city) {
  1267. if (idd.equals(areaId)) {
  1268. Childlast childlast2 = new Childlast();
  1269. childlast2.setId(tEquipment.getId());
  1270. childlast2.setName(tEquipment.getName());
  1271. children.add(childlast2);
  1272. }
  1273. }
  1274. }
  1275. child.setChildren(children);
  1276. Children.add(child);
  1277. }
  1278. }
  1279. }
  1280. children2.setChildren(Children);
  1281. //这个市的销售数据 日 周 月 年
  1282. List<Long> cityIds = new ArrayList();
  1283. for (Long cityid : city) {
  1284. cityIds.add(cityid);
  1285. }
  1286. StringBuffer namelast = new StringBuffer();
  1287. namelast.append(cityMap.get(citykey)).append(" ");
  1288. String day;
  1289. String week;
  1290. String month;
  1291. String year;
  1292. //数据为空时要处理
  1293. for (int s = 1; s < 5; s++) {
  1294. String startDate;
  1295. String endDate;
  1296. if (s == 1) {
  1297. //日
  1298. Date date = new Date();
  1299. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
  1300. String format = dateFormat.format(date);
  1301. startDate = format;
  1302. endDate = format;
  1303. Map<String, Object> params = new HashMap<>();
  1304. params.put("areaIds", cityIds);
  1305. params.put("startDate", startDate);
  1306. params.put("endDate", endDate);
  1307. Double day1 = tOrderService.getAreaPrice(params);
  1308. if (day1 != null) {
  1309. double ceil = Math.ceil(day1);
  1310. int ceil1 = (int) ceil;
  1311. pday += ceil1;
  1312. day = String.valueOf(ceil1);
  1313. namelast.append("-----日:").append(day);
  1314. } else {
  1315. namelast.append("-----日:0 ");
  1316. }
  1317. }
  1318. if (s == 2) {
  1319. //周
  1320. Map<String, String> weekDate = getWeekDate();
  1321. startDate = weekDate.get("mondayDate");
  1322. endDate = weekDate.get("sundayDate");
  1323. Map<String, Object> params = new HashMap<>();
  1324. params.put("areaIds", cityIds);
  1325. params.put("startDate", startDate);
  1326. params.put("endDate", endDate);
  1327. Double day1 = tOrderService.getAreaPrice(params);
  1328. if (day1 != null) {
  1329. double ceil = Math.ceil(day1);
  1330. int ceil1 = (int) ceil;
  1331. pweek += ceil1;
  1332. week = String.valueOf(ceil1);
  1333. namelast.append(" 周:").append(week);
  1334. } else {
  1335. namelast.append(" 周:0 ");
  1336. }
  1337. }
  1338. if (s == 3) {
  1339. //月
  1340. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
  1341. //获取当前月第一天:
  1342. Calendar c = Calendar.getInstance();
  1343. c.add(Calendar.MONTH, 0);
  1344. c.set(Calendar.DAY_OF_MONTH, 1);//设置为1号,当前日期既为本月第一天
  1345. String first = dateFormat.format(c.getTime());
  1346. //获取当前月最后一天
  1347. Calendar ca = Calendar.getInstance();
  1348. ca.set(Calendar.DAY_OF_MONTH, ca.getActualMaximum(Calendar.DAY_OF_MONTH));
  1349. String last = dateFormat.format(ca.getTime());
  1350. startDate = first;
  1351. endDate = last;
  1352. Map<String, Object> params = new HashMap<>();
  1353. params.put("areaIds", cityIds);
  1354. params.put("startDate", startDate);
  1355. params.put("endDate", endDate);
  1356. Double day1 = tOrderService.getAreaPrice(params);
  1357. if (day1 != null) {
  1358. double ceil = Math.ceil(day1);
  1359. int ceil1 = (int) ceil;
  1360. pmonth += ceil1;
  1361. month = String.valueOf(ceil1);
  1362. namelast.append(" 月:").append(month);
  1363. } else {
  1364. namelast.append(" 月:0 ");
  1365. }
  1366. }
  1367. if (s == 4) {
  1368. //年
  1369. // SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
  1370. Calendar cale = Calendar.getInstance();
  1371. int year1 = cale.get(Calendar.YEAR);
  1372. String y = String.valueOf(year1);
  1373. StringBuffer st = new StringBuffer();
  1374. st.append(y).append("/01/01");
  1375. startDate = st.toString();
  1376. StringBuffer e = new StringBuffer();
  1377. e.append(y).append("/12/30");
  1378. endDate = e.toString();
  1379. Map<String, Object> params = new HashMap<>();
  1380. params.put("areaIds", cityIds);
  1381. params.put("startDate", startDate);
  1382. params.put("endDate", endDate);
  1383. Double day1 = tOrderService.getAreaPrice(params);
  1384. if (day1 != null) {
  1385. double ceil = Math.ceil(day1);
  1386. int ceil1 = (int) ceil;
  1387. pyear += ceil1;
  1388. year = String.valueOf(ceil1);
  1389. namelast.append(" 年:").append(year);
  1390. } else {
  1391. namelast.append(" 年:0 ");
  1392. }
  1393. }
  1394. }
  1395. children2.setName(namelast.toString());
  1396. children2List.add(children2);
  1397. } else {
  1398. i = 0;
  1399. }
  1400. }
  1401. }
  1402. }
  1403. }
  1404. children3.setChildren(children2List);
  1405. children3.setProvince(province);
  1406. StringBuffer pnameLast = new StringBuffer();
  1407. pnameLast.append(map1.get(key)).append("-----日:").append(pday).append(" 周:").append(pweek).append(" 月:").append(pmonth).append(" 年:").append(pyear);
  1408. children3.setName(pnameLast.toString());
  1409. children3List.add(children3);
  1410. }
  1411. return ResponseEntity.status(HttpStatus.OK)
  1412. .body(new ResultMessage().setCode(true).setData(children3List).setMessage("SUCCESS"));
  1413. } else { // 只查当前商家的设备列表
  1414. return ResponseEntity.status(HttpStatus.OK)
  1415. .body(new ResultMessage().setCode(true).setData(resultList).setMessage("SUCCESS"));
  1416. }
  1417. // return ResponseEntity.status(HttpStatus.OK)
  1418. // .body(new ResultMessage().setCode(true).setData(resultList).setMessage("SUCCESS"));
  1419. }
  1420. public static Map<String, String> getWeekDate() {
  1421. Map<String, String> map = new HashMap();
  1422. SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
  1423. Calendar cal = Calendar.getInstance();
  1424. cal.setFirstDayOfWeek(Calendar.MONDAY);// 设置一个星期的第一天,按中国的习惯一个星期的第一天是星期一
  1425. int dayWeek = cal.get(Calendar.DAY_OF_WEEK);// 获得当前日期是一个星期的第几天
  1426. if (dayWeek == 1) {
  1427. dayWeek = 8;
  1428. }
  1429. // System.out.println("要计算日期为:" + sdf.format(cal.getTime())); // 输出要计算日期
  1430. cal.add(Calendar.DATE, cal.getFirstDayOfWeek() - dayWeek);// 根据日历的规则,给当前日期减去星期几与一个星期第一天的差值
  1431. Date mondayDate = cal.getTime();
  1432. String weekBegin = sdf.format(mondayDate);
  1433. // System.out.println("所在周星期一的日期:" + weekBegin);
  1434. cal.add(Calendar.DATE, 4 + cal.getFirstDayOfWeek());
  1435. Date sundayDate = cal.getTime();
  1436. String weekEnd = sdf.format(sundayDate);
  1437. // System.out.println("所在周星期日的日期:" + weekEnd);
  1438. map.put("mondayDate", weekBegin);
  1439. map.put("sundayDate", weekEnd);
  1440. return map;
  1441. }
  1442. /**
  1443. * 推送设备共同以及/设备参数
  1444. *
  1445. * @param
  1446. * @return
  1447. */
  1448. @PostMapping("/updateParameters")
  1449. public ResponseEntity<?> updateCommonParam(@RequestBody CommonParamVo commonParamVo) {
  1450. String equipmentId = commonParamVo.getId();
  1451. TEquipment equipment = tEquipmentService.getById(Long.valueOf(equipmentId));
  1452. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("Param", commonParamVo.getName() + ":" + commonParamVo.getVal()).toString());
  1453. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("Param", commonParamVo.getName() + ":" + commonParamVo.getVal()).toString());
  1454. return ResponseEntity
  1455. .status(HttpStatus.OK)
  1456. .body(new ResultMessage()
  1457. .setCode(true)
  1458. .setData("SUCCESS")
  1459. .setMessage("SUCCESS"));
  1460. }
  1461. /**
  1462. * 推送设备共同以及/设备参数 湿度
  1463. *
  1464. * @param
  1465. * @return
  1466. */
  1467. @PostMapping("/humidityParameters")
  1468. public ResponseEntity<?> humidityParameters(@RequestBody CommonParamVo commonParamVo) {
  1469. String equipmentId = commonParamVo.getId();
  1470. TEquipment equipment = tEquipmentService.getById(equipmentId);
  1471. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("humidityParameters", commonParamVo.getName() + ":" + commonParamVo.getVal()).toString());
  1472. // PushUtils.push(equipment.getGtClientId(), "", "", PushUtils.buildJson("Param", commonParamVo.getName() + ":" + commonParamVo.getVal()).toString());
  1473. return ResponseEntity
  1474. .status(HttpStatus.OK)
  1475. .body(new ResultMessage()
  1476. .setCode(true)
  1477. .setData("SUCCESS")
  1478. .setMessage("SUCCESS"));
  1479. }
  1480. /**
  1481. * 下载日志
  1482. *
  1483. * @param equipmentId 设备id
  1484. * @param day 日期
  1485. * @param response 响应
  1486. */
  1487. @ApiOperation(value = "下载日志")
  1488. @GetMapping("/downloadLog")
  1489. public ResponseModel<?> downloadLog(String equipmentId, String day, HttpServletResponse response) throws IOException, InterruptedException {
  1490. // 1、发送MQ到安卓端上传日志
  1491. /* if(day.length()!=8){
  1492. return R.fail(A0001,"日期格式有误");
  1493. }*/
  1494. if (StringUtils.isEmpty(equipmentId)) {
  1495. return R.fail(A0001);
  1496. }
  1497. TEquipment tEquipment = tEquipmentService.getById(equipmentId);
  1498. if (tEquipment == null) {
  1499. return R.fail(A0001, "该设备不存在");
  1500. }
  1501. String clientId = tEquipment.getClientId();
  1502. String kind = day + "-" + clientId;
  1503. String filepath = "/home/hboxs/log/" + kind + ".txt";
  1504. // 1.1 如果文件已存在,直接下载
  1505. if (Files.exists(Paths.get(filepath))) {
  1506. // DownloadUtils.downloadFile(filepath, response);
  1507. // return R.ok();
  1508. try {
  1509. Files.delete(Paths.get(filepath));
  1510. return R.ok();
  1511. } catch (IOException e) {
  1512. e.printStackTrace();
  1513. return R.fail(B0004, "请重试");
  1514. }
  1515. }
  1516. String channel = tEquipment.getChannel();
  1517. String equimentType = tEquipment.getEquimentType();
  1518. if (StringUtils.isEmpty(channel) || channel.equals("1") || StringUtils.isEmpty(equimentType)) {
  1519. //用个推
  1520. PushUtils.push(tEquipment.getGtClientId(), "", "", PushUtils.buildJson("log", kind).toString());
  1521. }
  1522. if (StringUtils.isNotEmpty(channel) && channel.equals("2") && StringUtils.isNotEmpty(equimentType)) {
  1523. //用Mq
  1524. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("log", kind).toString());
  1525. }
  1526. // 2、设置定时器查看日志是否已上传
  1527. ScheduledExecutorService exec = Executors.newScheduledThreadPool(1);
  1528. long startTime = System.currentTimeMillis();
  1529. ScheduledFuture<?> future = exec.schedule(() -> {
  1530. // 超时处理逻辑
  1531. if (Files.exists(Paths.get(filepath))) {
  1532. return null;
  1533. } else {
  1534. throw new RuntimeException("找不到日志");
  1535. }
  1536. }, TIMEOUT, TimeUnit.MILLISECONDS);
  1537. while (true) {
  1538. if (Files.exists(Paths.get(filepath))) {
  1539. // 文件存在,取消定时器
  1540. future.cancel(false);
  1541. break;
  1542. } else {
  1543. Thread.sleep(1000);
  1544. if (System.currentTimeMillis() - startTime >= TIMEOUT) {
  1545. // 超过最大等待时间,抛出异常
  1546. future.cancel(false);
  1547. throw new RuntimeException("等待文件生成超时");
  1548. }
  1549. }
  1550. }
  1551. // 3、从服务器下载文件
  1552. DownloadUtils.downloadFile(filepath, response);
  1553. return R.ok();
  1554. }
  1555. // 从服务器下载文件
  1556. // public void downloadFile(String filepath, HttpServletResponse response) throws IOException {
  1557. // File logFile = new File(filepath);
  1558. // response.setHeader("Content-Disposition", "attachment; filename=\"" + logFile.getName() + "\"");
  1559. //
  1560. // FileInputStream fis = new FileInputStream(logFile);
  1561. // OutputStream os = response.getOutputStream();
  1562. //
  1563. // byte[] buffer = new byte[4096];
  1564. // int length;
  1565. // while ((length = fis.read(buffer)) > 0) {
  1566. // os.write(buffer, 0, length);
  1567. // os.flush();
  1568. // }
  1569. // os.close();
  1570. // fis.close();
  1571. // response.flushBuffer();
  1572. // }
  1573. //查找设备
  1574. @ApiOperation(value = "获取对应的机器编号")
  1575. @GetMapping("/findEquipmentByClientIds")
  1576. public ResponseModel<List<TEquipment>> findEquipmentByClientIds(@RequestParam("clientIds") List<String> clientIds) {
  1577. LambdaQueryWrapper<TEquipment> wrapper = new LambdaQueryWrapper<>();
  1578. wrapper.in(TEquipment::getClientId, clientIds);
  1579. List<TEquipment> list = tEquipmentService.list(wrapper);
  1580. return R.ok(list);
  1581. }
  1582. @ApiOperation(value = "修改DIY花型功能开关状态")
  1583. @GetMapping("/updateDIYFlowerStatus")
  1584. public ResponseModel<?> updateDIYFlowerStatus(String equipmentId, String DIYFlowerStatus) {
  1585. if (StringUtils.isEmpty(DIYFlowerStatus) || StringUtils.isEmpty(equipmentId)) {
  1586. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  1587. }
  1588. TEquipment equipment = tEquipmentService.getById(equipmentId);
  1589. if (equipment == null || equipment.getId() == null) {
  1590. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  1591. }
  1592. TEquipmentDesc tEquipmentDesc = equipmentDescService.getById(equipment.getId());
  1593. if (tEquipmentDesc != null) {
  1594. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("DIYFlowerStatus", DIYFlowerStatus).toString());
  1595. } else {
  1596. return R.fail(ResponseCodesEnum.A0001, "找不到设备");
  1597. }
  1598. return R.ok(null, "发送成功");
  1599. }
  1600. @ApiOperation(value = "修改DIY花型的形状或是否显示")
  1601. @PostMapping("/updateDIYProductShow")
  1602. public ResponseModel<?> updateDIYProductShow(@RequestBody String productList) {
  1603. JSONObject jsonObject = JSONObject.parseObject(productList);
  1604. List<TDiyFlower> products = JSONObject.parseArray(jsonObject.get("productList").toString(), TDiyFlower.class);
  1605. if (products.size() > 0) {
  1606. TDiyFlower diyFlower = products.get(0);
  1607. if (diyFlower == null && diyFlower.getEquipmentId() == null) {
  1608. return R.fail(ResponseCodesEnum.A0001, "找不到当前设备");
  1609. }
  1610. }
  1611. TEquipment equipment = tEquipmentService.getById(products.get(0).getEquipmentId());
  1612. if (equipment == null) {
  1613. return R.fail(ResponseCodesEnum.A0001, "请退出重试");
  1614. }
  1615. List<TProductBean> list = new ArrayList<>();
  1616. for (TDiyFlower product : products) {
  1617. TProductBean productBean = new TProductBean();
  1618. if (product != null && product.getId() != null) {
  1619. productBean.setShowType(product.getShowType());
  1620. if (StringUtils.isEmpty(product.getShowType())) {
  1621. productBean.setShowType("1");
  1622. }
  1623. productBean.setProductName(product.getName());
  1624. list.add(productBean);
  1625. }
  1626. }
  1627. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("updateDIYProductShow", JSON.toJSONString(list)).toString());
  1628. // tDiyFlowerService.updateBatchById(products);
  1629. return R.ok(null, "修改请求发送成功");
  1630. }
  1631. @ApiOperation(value = "查询DIY花型列表信息")
  1632. @GetMapping("/selectDIYFlowers")
  1633. public ResponseModel<?> selectDIYFlowers(String equipmentId) {
  1634. if (StringUtils.isEmpty(equipmentId)) {
  1635. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  1636. }
  1637. LambdaQueryWrapper<TDiyFlower> query = Wrappers.lambdaQuery();
  1638. query.eq(TDiyFlower::getEquipmentId, Long.valueOf(equipmentId));
  1639. List<TDiyFlower> list = tDiyFlowerService.list(query);
  1640. return R.ok(list);
  1641. }
  1642. @ApiOperation(value = "远程修改锁机状态,锁机:1,解锁:0")
  1643. @GetMapping("/updateLockStatus")
  1644. public ResponseModel<?> updateLockStatus(String equipmentId, String status) {
  1645. if (StringUtils.isEmpty(equipmentId) || StringUtils.isEmpty(status)) {
  1646. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  1647. }
  1648. TEquipment equipment = tEquipmentService.getById(equipmentId);
  1649. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("block", status).toString());
  1650. return R.ok();
  1651. }
  1652. /**
  1653. * 上传日志
  1654. *
  1655. * @param equipmentId 设备ID,用于标识上传日志的设备
  1656. * @param day 日期,指定要上传日志的日期
  1657. * @return 返回操作结果,成功则返回成功信息,失败则返回失败原因
  1658. */
  1659. @ApiOperation(value = "上传日志")
  1660. @GetMapping("/uploadLog")
  1661. public ResponseModel<?> uploadLog(String equipmentId, String day) {
  1662. // 检查设备ID是否为空
  1663. if (StringUtils.isEmpty(equipmentId)) {
  1664. return R.fail(A0001);
  1665. }
  1666. // 根据设备ID查询设备信息
  1667. TEquipment tEquipment = tEquipmentService.getById(equipmentId);
  1668. // 检查设备信息是否存在
  1669. if (tEquipment == null) {
  1670. return R.fail(A0001, "该设备不存在");
  1671. }
  1672. // 组装日志信息的标识
  1673. String clientId = tEquipment.getClientId();
  1674. String kind = day + "-" + clientId;
  1675. // 获取设备的渠道号和类型
  1676. String channel = tEquipment.getChannel();
  1677. String equimentType = tEquipment.getEquimentType();
  1678. // 如果渠道号为空或为"1",或设备类型为空,则使用个推推送日志
  1679. if (StringUtils.isEmpty(channel) || channel.equals("1") || StringUtils.isEmpty(equimentType)) {
  1680. PushUtils.push(tEquipment.getGtClientId(), "", "", PushUtils.buildJson("log", kind).toString());
  1681. }
  1682. // 如果渠道号为"2"且设备类型不为空,则使用MQ发送日志
  1683. if (StringUtils.isNotEmpty(channel) && channel.equals("2") && StringUtils.isNotEmpty(equimentType)) {
  1684. tEquipmentService.sentMessage(tEquipment.getClientId(), PushUtils.buildJson("log", kind).toString());
  1685. }
  1686. // 返回操作成功信息
  1687. return R.ok();
  1688. }
  1689. /**
  1690. * 查询指定设备在指定日期的日志是否已上传至七牛云。
  1691. *
  1692. * @param equipmentId 设备ID,用于查询日志所属设备。
  1693. * @param day 日期,格式为"yyyy-MM-dd",用于指定要查询的日志日期。
  1694. * @return 返回一个响应模型对象,如果日志已上传则返回成功信息和日志文件名,否则返回失败信息。
  1695. */
  1696. @ApiOperation(value = "查询日志是否上传成功")
  1697. @GetMapping("/queryLog")
  1698. public ResponseModel<?> queryLog(String equipmentId, String day) {
  1699. // 检查设备ID是否为空
  1700. if (StringUtils.isEmpty(equipmentId)) {
  1701. return R.fail(A0001);
  1702. }
  1703. // 根据设备ID查询设备信息
  1704. TEquipment tEquipment = tEquipmentService.getById(equipmentId);
  1705. if (tEquipment == null) {
  1706. return R.fail(A0001, "该设备不存在");
  1707. }
  1708. // 根据设备ID和日期构造日志文件名
  1709. String clientId = tEquipment.getClientId();
  1710. String key = "log/" + day + "-" + clientId + ".txt";
  1711. // 配置七牛云连接
  1712. Configuration cfg = new Configuration(Region.region2());
  1713. Auth auth = Auth.create(ConfigConsts.QINIU_CLOUD_ACCESS_KEY, ConfigConsts.QINIU_CLOUD_SECRET_KEY);
  1714. BucketManager bucketManager = new BucketManager(auth, cfg);
  1715. boolean flag = true;
  1716. try {
  1717. // 尝试获取指定文件信息,判断文件是否存在
  1718. FileInfo fileInfo = bucketManager.stat(ConfigConsts.QINIU_CLOUD_BUCKET, key);
  1719. } catch (QiniuException ex) {
  1720. System.err.println(ex.response.error);
  1721. flag = false;
  1722. }
  1723. // 根据文件是否存在返回相应结果
  1724. if (flag) {
  1725. return R.ok(key);
  1726. }
  1727. return R.fail(F0002);
  1728. }
  1729. /**
  1730. * 修改DIY功能使用的密码
  1731. *
  1732. * @param diyPassword 新的DIY功能密码
  1733. * @return 返回操作结果,成功返回成功标志,失败返回错误代码
  1734. */
  1735. @ApiOperation(value = "修改diy功能使用密码")
  1736. @GetMapping("/updateDIYPassword")
  1737. public ResponseModel<?> updateDIYPassword(String diyPassword) {
  1738. // 检查传入的DIY密码是否为空
  1739. if (StringUtils.isEmpty(diyPassword)) {
  1740. return R.fail(A0001);
  1741. }
  1742. // 获取管理员对象
  1743. TAdmin admin = tAdminService.getById(1L);
  1744. // 设置新的DIY密码
  1745. admin.setDiyPassword(diyPassword);
  1746. // 更新管理员信息
  1747. tAdminService.updateById(admin);
  1748. // 返回操作成功标志
  1749. return R.ok();
  1750. }
  1751. @ApiOperation(value = "远程开启触摸屏")
  1752. @GetMapping("/openScreen")
  1753. public ResponseModel<?> openScreen(String equipmentId) {
  1754. // 检查设备ID是否为空
  1755. if (StringUtils.isEmpty(equipmentId)) {
  1756. return R.fail(A0001);
  1757. }
  1758. // 根据设备ID查询设备信息
  1759. TEquipment equipment = tEquipmentService.getById(equipmentId);
  1760. if (equipment == null) {
  1761. return R.fail(A0001, "该设备不存在");
  1762. }
  1763. // 远程开启触摸屏
  1764. String clientId = equipment.getClientId();
  1765. tEquipmentService.sentMessage(clientId, PushUtils.buildJson("restartAndroid", "restartAndroid").toString());
  1766. return R.ok();
  1767. }
  1768. @ApiOperation(value = "远程切换雪糕机工作模式")
  1769. @GetMapping("/updateWorkingMode")
  1770. public ResponseModel<?> updateWorkingMode(String equipmentId, Integer workingMode) {
  1771. if (StringUtils.isEmpty(equipmentId) || workingMode == null) {
  1772. return R.fail(ResponseCodesEnum.A0001, "参数有空");
  1773. }
  1774. TEquipment equipment = tEquipmentService.getById(equipmentId);
  1775. TEquipmentDesc equipmentDesc = equipmentDescService.getById(equipmentId);
  1776. if (equipmentDesc == null || equipment == null) {
  1777. return R.fail(ResponseCodesEnum.A0001, "设备不存在");
  1778. }
  1779. equipmentDesc.setWorkingMode(workingMode);
  1780. equipmentDescService.updateById(equipmentDesc);
  1781. // 发送消息给设备
  1782. tEquipmentService.sentMessage(equipment.getClientId(), PushUtils.buildJson("workingMode", workingMode.toString()).toString());
  1783. return R.ok();
  1784. }
  1785. }