ScanController.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411
  1. package com.bofeng.wx.controller;
  2. import com.bofeng.dao.*;
  3. import com.bofeng.entity.*;
  4. import com.bofeng.service.HomeService;
  5. import com.bofeng.service.ScanService;
  6. import com.google.zxing.BarcodeFormat;
  7. import com.google.zxing.MultiFormatWriter;
  8. import com.google.zxing.WriterException;
  9. import com.google.zxing.client.j2se.MatrixToImageConfig;
  10. import com.google.zxing.client.j2se.MatrixToImageWriter;
  11. import com.google.zxing.common.BitMatrix;
  12. import com.yvan.mvc.Pd;
  13. import io.swagger.annotations.Api;
  14. import io.swagger.annotations.ApiOperation;
  15. import lombok.Cleanup;
  16. import org.joda.time.DateTime;
  17. import org.springframework.beans.factory.annotation.Autowired;
  18. import org.springframework.beans.factory.annotation.Value;
  19. import org.springframework.http.MediaType;
  20. import org.springframework.ui.ModelMap;
  21. import org.springframework.web.bind.annotation.GetMapping;
  22. import org.springframework.web.bind.annotation.RequestParam;
  23. import org.springframework.web.bind.annotation.RestController;
  24. import org.springframework.web.servlet.ModelAndView;
  25. import javax.servlet.ServletOutputStream;
  26. import javax.servlet.http.HttpServletRequest;
  27. import javax.servlet.http.HttpServletResponse;
  28. import java.io.IOException;
  29. import java.net.URLEncoder;
  30. import java.text.ParseException;
  31. import java.text.SimpleDateFormat;
  32. import java.util.Date;
  33. import java.util.List;
  34. @Api("进出扫码")
  35. @RestController
  36. public class ScanController {
  37. // 获取code
  38. private static final String oauth2 = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=";
  39. private static final String moreUrl = "&response_type=code&scope=snsapi_userinfo&state=STATE#wechat_redirect";
  40. @Value("${yvan.wechat.appID}")
  41. private String appId;
  42. @Value("${yvan.wechat.domain}")
  43. private String domain;
  44. @Autowired
  45. private HomeService homeService;
  46. @Autowired
  47. private UserRoleMapper userRoleMapper;
  48. @Autowired
  49. private UserOpenMapper userOpenMapper;
  50. @Autowired
  51. private UptownHomeMapper uptownHomeMapper;
  52. @Autowired
  53. private UptownUnitMapper uptownUnitMapper;
  54. @Autowired
  55. private UptownDoorMapper uptownDoorMapper;
  56. @Autowired
  57. private OutScanMapper outScanMapper;
  58. @Autowired
  59. private OutScanConfMapper outScanConfMapper;
  60. @Autowired
  61. private MsReportMapper msReportMapper;
  62. @Autowired
  63. private ScanService scanService;
  64. @Autowired
  65. private OutScanEstateMapper outScanEstateMapper;
  66. @Autowired
  67. private OutUserMapper outUserMapper;
  68. /**
  69. * @param doorId 小区大门ID
  70. * @param inType 1进入;2外出
  71. * @param request
  72. * @param model
  73. * @return
  74. */
  75. @ApiOperation("进出扫码页面")
  76. @GetMapping("/user/scan.html")
  77. public ModelAndView scan(HttpServletRequest request, ModelMap model, @RequestParam(value = "doorId", required = false, defaultValue = "0") Long doorId,
  78. @RequestParam(value = "inType", required = false, defaultValue = "0") Integer inType) {
  79. UserOpen userOpen = homeService.getUserOpenByCode(request.getParameter("code"));
  80. List<UserRole> list = userRoleMapper.getUserRoleByUserId(userOpen.getUserId());
  81. // List<UserRole> list = userRoleMapper.getUserRoleByUserId(1L);
  82. // UserOpen userOpen = userOpenMapper.selectByUserId(1L);
  83. model.put("user", userOpen);
  84. model.put("user_id", "\"" + userOpen.getUserId() + "\"");
  85. if (list.size() == 0) {
  86. return new ModelAndView("/user/home.ftl", model);
  87. } else {
  88. UptownDoor uptownDoor = uptownDoorMapper.getUptownDoorById(doorId);
  89. List<UptownHome> uptownHomes = uptownHomeMapper.getUptownHomeByUserId(userOpen.getUserId());
  90. UptownUnit unit = uptownUnitMapper.getUptownUnitByUser(userOpen.getUserId());
  91. model.put("door", uptownDoor.getUptownName() + uptownDoor.getDoorName());
  92. model.put("doorplate", unit.getRidgepole() + "栋" + unit.getUnit() + "单元" +unit.getDoorplate() + "号");
  93. model.put("name", uptownHomes.get(0).getLinkman());
  94. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  95. model.put("now", sdf.format(new Date()));
  96. model.put("inType", inType);
  97. if (!unit.getUptownId().equals(uptownDoor.getUptownId())) {
  98. model.put("into", "禁止" + getMsg(inType));
  99. model.put("collor", "red");
  100. model.put("errorMsg", "非本小区居民,禁止" + getMsg(inType) + "。");
  101. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), -1, model.get("errorMsg").toString());
  102. return new ModelAndView("/user/scan.ftl", model);
  103. }
  104. OutScan o = outScanMapper.getOutScanLately(userOpen.getUserId(), inType);
  105. if (o != null && compareTime(o.getDate(),1)) {
  106. model.put("collor", "orange");
  107. model.put("into", "允许" + getMsg(inType));
  108. model.put("errorMsg", "您最近一分钟已经扫码,本次扫码重复。");
  109. return new ModelAndView("/user/scan.ftl", model);
  110. }
  111. if (inType == 1) {
  112. OutScan outScan = outScanMapper.getOutScanByUserlimit(userOpen.getUserId());
  113. if (outScan != null && new Date(outScan.getDate().getMillis() + 3600L * 1000 * 24).compareTo(new Date()) == -1) {
  114. model.put("collor", "orange");
  115. model.put("into", "允许进入");
  116. model.put("errorMsg", "您在外驻留时间超过1日,请尽快上报您的健康状况,防止在外长时间逗留。");
  117. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), 1, "");
  118. return new ModelAndView("/user/scan.ftl", model);
  119. }
  120. }
  121. if (inType == 2) {
  122. OutUser outUser = outUserMapper.getOutUserByPhone(uptownHomes.get(0).getLinkman(), Long.parseLong(uptownHomes.get(0).getPhone()));
  123. if (outUser != null) {
  124. model.put("collor", "green");
  125. model.put("into", "允许通行");
  126. model.put("errorMsg", "外出请佩戴口罩,避免近距离接触,保生产同时注意自身安全。");
  127. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), 1, "");
  128. return new ModelAndView("/user/scan.ftl", model);
  129. }
  130. OutScanConf outScanConf = outScanConfMapper.getOutScanConfByUptown(uptownDoor.getUptownId());
  131. if (outScanConf.getGoOutFre() == 0) {
  132. model.put("collor", "red");
  133. model.put("into", "禁止外出");
  134. model.put("errorMsg", "根据武汉市小区封闭管理规定,非特殊人员禁止出行!");
  135. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), -1, model.get("errorMsg").toString());
  136. return new ModelAndView("/user/goOut.ftl", model);
  137. }
  138. OutScan outScan = outScanMapper.getOutScanThreeday(userOpen.getUserId(), 2, outScanConf.getGoOutFre());
  139. if (outScan != null) {
  140. model.put("collor", "red");
  141. model.put("into", "禁止" + getMsg(inType));
  142. model.put("errorMsg", "距您上次外出时间未满"+outScanConf.getGoOutFre()+"日,禁止外出,请配合。上次外出登记时间 "+sdf.format(new Date(outScan.getDate().getMillis()))+"。");
  143. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), -1, model.get("errorMsg").toString());
  144. return new ModelAndView("/user/scan.ftl", model);
  145. }
  146. MsReport msReport = msReportMapper.selectMsReportToday(userOpen.getUserId());
  147. if (msReport != null && msReport.getMsStatus() == 2) {
  148. model.put("collor", "red");
  149. model.put("into", "禁止通行");
  150. model.put("errorMsg", "健康日报提示您存在健康问题,禁止外出,请配合。");
  151. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), -1, model.get("errorMsg").toString());
  152. return new ModelAndView("/user/scan.ftl", model);
  153. }
  154. List<MsReport> msReports = msReportMapper.selectMsReportLate(userOpen.getUserId());
  155. if (msReports.size() == 0) {
  156. model.put("collor", "red");
  157. model.put("into", "禁止" + getMsg(inType));
  158. model.put("errorMsg", "您最近三日未上报健康日报,请说明原因,配合监测人员。");
  159. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), -1, model.get("errorMsg").toString());
  160. return new ModelAndView("/user/scan.ftl", model);
  161. } else if (msReports.size() < 3) {
  162. model.put("collor", "orange");
  163. model.put("into", "可以" + getMsg(inType));
  164. model.put("errorMsg", "您最近三日健康日报漏报,请说明原因并及时填报,配合监测人员。");
  165. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), 1, "");
  166. return new ModelAndView("/user/scan.ftl", model);
  167. }
  168. }
  169. model.put("collor", "green");
  170. model.put("into", "允许" + getMsg(inType));
  171. if (inType == 2) {
  172. model.put("errorMsg", "外出请佩戴口罩,避免近距离接触,保生产同时注意自身安全。");
  173. } else if (inType == 1) {
  174. model.put("errorMsg", "欢迎归来,注意防护。");
  175. }
  176. scanService.saveOutScan(userOpen.getUserId(), inType, uptownDoor.getUptownId(), uptownDoor.getDoorId(), 1, "");
  177. return new ModelAndView("/user/scan.ftl", model);
  178. }
  179. }
  180. @ApiOperation("巡检人员检查扫码信息")
  181. @GetMapping("/user/scanEstate.html")
  182. public ModelAndView scanEstate(HttpServletRequest request, ModelMap model) {
  183. UserOpen userOpen = homeService.getUserOpenByCode(request.getParameter("code"));
  184. List<UserRole> list = userRoleMapper.getUserRoleByUserId(userOpen.getUserId());
  185. // List<UserRole> list = userRoleMapper.getUserRoleByUserId(1L);
  186. // UserOpen userOpen = userOpenMapper.selectByUserId(1L);
  187. model.put("user", userOpen);
  188. model.put("user_id", "\"" + userOpen.getUserId() + "\"");
  189. if (list.size() == 0) {
  190. return new ModelAndView("/user/home.ftl", model);
  191. } else {
  192. List<UptownHome> uptownHomes = uptownHomeMapper.getUptownHomeByUserId(userOpen.getUserId());
  193. UptownUnit unit = uptownUnitMapper.getUptownUnitByUser(userOpen.getUserId());
  194. OutScanConf outScanConf = outScanConfMapper.getOutScanConfByUptown(unit.getUptownId());
  195. model.put("doorplate", unit.getUptownName() + "小区" +unit.getRidgepole() + "栋" + unit.getUnit() + "单元" +unit.getDoorplate() + "号");
  196. model.put("name", uptownHomes.get(0).getLinkman());
  197. SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  198. model.put("now", format.format(new Date()));
  199. OutScanEstate o = outScanEstateMapper.getOutScanEstatLately(userOpen.getUserId());
  200. if (o != null && compareTime(o.getScanDate(),1)) {
  201. model.put("collor", "orange");
  202. model.put("into", "允许通行");
  203. model.put("errorMsg", "您最近一分钟已经扫码,本次扫码重复。");
  204. return new ModelAndView("/user/scanEstate.ftl", model);
  205. }
  206. OutUser outUser = outUserMapper.getOutUserByPhone(uptownHomes.get(0).getLinkman(), Long.parseLong(uptownHomes.get(0).getPhone()));
  207. if (outUser != null) {
  208. model.put("collor", "green");
  209. model.put("into", "允许通行");
  210. model.put("errorMsg", "外出请佩戴口罩,避免近距离接触,保生产同时注意自身安全。");
  211. scanService.saveOutScanEstate(userOpen.getUserId(), 1, "");
  212. return new ModelAndView("/user/scanEstate.ftl", model);
  213. }
  214. if (outScanConf.getGoOutFre() == 0) {
  215. model.put("collor", "red");
  216. model.put("into", "禁止外出");
  217. model.put("errorMsg", "根据武汉市小区封闭管理规定,非特殊人员禁止出行!");
  218. scanService.saveOutScanEstate(userOpen.getUserId(), -1, model.get("errorMsg").toString());
  219. return new ModelAndView("/user/goOut.ftl", model);
  220. }
  221. List<MsReport> msReports = msReportMapper.selectMsReportLate(userOpen.getUserId());
  222. if (msReports.size() != 3) {
  223. model.put("collor", "red");
  224. model.put("into", "禁止通行");
  225. model.put("errorMsg", "您近期有漏报健康日报,无法判断您健康状态,请尽快返回住处。");
  226. scanService.saveOutScanEstate(userOpen.getUserId(), -1, model.get("errorMsg").toString());
  227. return new ModelAndView("/user/scanEstate.ftl", model);
  228. }
  229. MsReport msReport = msReportMapper.selectMsReportToday(userOpen.getUserId());
  230. if (msReport != null && msReport.getMsStatus() == 2) {
  231. model.put("collor", "red");
  232. model.put("into", "禁止通行");
  233. model.put("errorMsg", "您近日提交的健康日报显示您健康存在问题,请尽快返回住处。");
  234. scanService.saveOutScanEstate(userOpen.getUserId(), -1, model.get("errorMsg").toString());
  235. return new ModelAndView("/user/scanEstate.ftl", model);
  236. }
  237. OutScan outScan = outScanMapper.getOutScanToday(userOpen.getUserId());
  238. if (outScan == null) {
  239. model.put("collor", "red");
  240. model.put("into", "禁止通行");
  241. model.put("errorMsg", "您今日没有正常出门记录,为自身及家人安全,请赶紧回家。");
  242. scanService.saveOutScanEstate(userOpen.getUserId(), -1, model.get("errorMsg").toString());
  243. return new ModelAndView("/user/scanEstate.ftl", model);
  244. }
  245. List<OutScanEstate> list1 = outScanEstateMapper.getOutScanEstateTodayByUser(userOpen.getUserId());
  246. int conut = list1.size() + 1;
  247. if (list1.size() < 2) {
  248. model.put("collor", "green");
  249. model.put("into", "允许通行");
  250. if (list1.size() == 0) {
  251. model.put("errorMsg", "您今日已"+conut+"次被问讯,请说明外出原因,尽快回家。");
  252. } else {
  253. model.put("errorMsg", "您今日已"+conut+"次被问讯,请说明外出原因,尽快回家。问询时间:"+queryTime(list1)+"。");
  254. }
  255. scanService.saveOutScanEstate(userOpen.getUserId(), 1, "");
  256. } else {
  257. model.put("collor", "red");
  258. model.put("into", "禁止通行");
  259. model.put("errorMsg", "您今日已被巡检人员问讯超过2次,为自身及家人安全,请赶紧回家。问询时间:"+queryTime(list1)+"。");
  260. scanService.saveOutScanEstate(userOpen.getUserId(), -1, model.get("errorMsg").toString());
  261. }
  262. // model.put("img", "/scan/scanEstate_qr.png");
  263. return new ModelAndView("/user/scanEstate.ftl", model);
  264. }
  265. }
  266. @ApiOperation("外出查询")
  267. @GetMapping("/user/goOut.html")
  268. public ModelAndView goOut(HttpServletRequest request, ModelMap model) throws ParseException {
  269. UserOpen userOpen = homeService.getUserOpen();
  270. List<UserRole> list = userRoleMapper.getUserRoleByUserId(userOpen.getUserId());
  271. // List<UserRole> list = userRoleMapper.getUserRoleByUserId(1L);
  272. // UserOpen userOpen = userOpenMapper.selectByUserId(1L);
  273. model.put("user", userOpen);
  274. model.put("user_id", "\"" + userOpen.getUserId() + "\"");
  275. if (list.size() == 0) {
  276. return new ModelAndView("/user/home.ftl", model);
  277. } else {
  278. List<UptownHome> uptownHomes = uptownHomeMapper.getUptownHomeByUserId(userOpen.getUserId());
  279. UptownUnit unit = uptownUnitMapper.getUptownUnitByUser(userOpen.getUserId());
  280. model.put("doorplate", unit.getUptownName() + "小区" +unit.getRidgepole() + "栋" + unit.getUnit() + "单元" +unit.getDoorplate() + "号");
  281. model.put("name", uptownHomes.get(0).getLinkman());
  282. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  283. model.put("now", sdf.format(new Date()));
  284. OutUser outUser = outUserMapper.getOutUserByPhone(uptownHomes.get(0).getLinkman(), Long.parseLong(uptownHomes.get(0).getPhone()));
  285. if (outUser != null) {
  286. model.put("collor", "green");
  287. model.put("into", "允许外出");
  288. model.put("errorMsg", "外出请佩戴口罩,避免近距离接触,保生产同时注意自身安全。");
  289. return new ModelAndView("/user/goOut.ftl", model);
  290. }
  291. OutScanConf outScanConf = outScanConfMapper.getOutScanConfByUptown(unit.getUptownId());
  292. if (outScanConf.getGoOutFre() == 0) {
  293. model.put("collor", "red");
  294. model.put("into", "禁止外出");
  295. model.put("errorMsg", "根据武汉市小区封闭管理规定,非特殊人员禁止出行!");
  296. return new ModelAndView("/user/goOut.ftl", model);
  297. }
  298. List<MsReport> msReports = msReportMapper.selectMsReportLate(userOpen.getUserId());
  299. if (msReports.size() == 0) {
  300. model.put("collor", "red");
  301. model.put("into", "禁止外出");
  302. model.put("errorMsg", "您近期未提交健康日报,无法判断您健康状态,请提交健康日报。");
  303. return new ModelAndView("/user/goOut.ftl", model);
  304. }
  305. MsReport msReport = msReportMapper.selectMsReportToday(userOpen.getUserId());
  306. if (msReport != null && msReport.getMsStatus() == 2) {
  307. model.put("collor", "red");
  308. model.put("into", "禁止外出");
  309. model.put("errorMsg", "健康日报提示您存在健康问题,禁止外出,请配合。");
  310. return new ModelAndView("/user/goOut.ftl", model);
  311. }
  312. OutScan outScan = outScanMapper.getOutScanThreeday(userOpen.getUserId(), 2, outScanConf.getGoOutFre());
  313. if (outScan != null) {
  314. model.put("collor", "red");
  315. model.put("into", "禁止外出");
  316. model.put("errorMsg", "您今日健康状态评估正常,最近可外出时间"+sdf.format(new Date(outScan.getDayDate().getTime() + 1000L *3600*24 * outScanConf.getGoOutFre()))+
  317. ",距今日还差"+differentDays(outScan.getDayDate(), sdf.parse(sdf.format(new Date())), outScanConf.getGoOutFre())+"天。");
  318. return new ModelAndView("/user/goOut.ftl", model);
  319. }
  320. model.put("collor", "green");
  321. model.put("into", "允许外出");
  322. model.put("errorMsg", "外出请佩戴口罩,避免近距离接触,不得长时间在外逗留。");
  323. return new ModelAndView("/user/goOut.ftl", model);
  324. }
  325. }
  326. /**
  327. * 通过时间秒毫秒数判断两个时间的间隔
  328. * @param date1
  329. * @param i
  330. * @return
  331. */
  332. public static int differentDays(Date date1, Date date2, Integer i) {
  333. int days = (int) ((date1.getTime() - date2.getTime()) / (1000*3600*24)) + i;
  334. return days;
  335. }
  336. /**
  337. * 判断传入的时间和现在相差是否在i分钟内
  338. * @param date
  339. * @param i
  340. * @return
  341. */
  342. public Boolean compareTime(DateTime date, Integer i) {
  343. Date date1 = new Date(date.getMillis());
  344. if ((date1.getTime() + 1000L * 60 * i) > System.currentTimeMillis()) {
  345. return true;
  346. } else {
  347. return false;
  348. }
  349. }
  350. public String getMsg(Integer inType) {
  351. if (inType == 1) {
  352. return "进入";
  353. } else if (inType == 2) {
  354. return "外出";
  355. }
  356. return "";
  357. }
  358. public String queryTime (List<OutScanEstate> list) {
  359. SimpleDateFormat format = new SimpleDateFormat("HH:mm");
  360. String time = "";
  361. for (OutScanEstate o : list) {
  362. String date = format.format(new Date(o.getScanDate().getMillis()));
  363. time += date + "、";
  364. }
  365. return time.substring(0, time.length() - 1);
  366. }
  367. // /**
  368. // * 生成进出门二维码
  369. // * @param doorId 小区大门ID
  370. // * @param inType 1进入;2外出
  371. // * @param response
  372. // * @throws IOException
  373. // * @throws WriterException
  374. // */
  375. // @GetMapping(value = "/scan/scan_qr.png", produces = MediaType.IMAGE_PNG_VALUE)
  376. // public void scanQrImg(@Pd(name = "doorId") Long doorId, @Pd(name = "inType") Integer inType,
  377. // HttpServletResponse response) throws IOException, WriterException {
  378. // @Cleanup ServletOutputStream outputStream = response.getOutputStream();
  379. // String msg = URLEncoder.encode( domain + "user/scan.html?doorId=" + doorId + "&inType=" + inType,"utf-8");
  380. // BitMatrix matrix = new MultiFormatWriter().encode(oauth2 + appId + "&redirect_uri=" +
  381. // msg + moreUrl, BarcodeFormat.QR_CODE, 256, 256);
  382. // MatrixToImageWriter.writeToStream(matrix, MediaType.IMAGE_PNG.getSubtype(), outputStream, new MatrixToImageConfig());
  383. // }
  384. //
  385. // /**
  386. // * 生成校园巡逻二维码
  387. // * @throws IOException
  388. // * @throws WriterException
  389. // */
  390. // @GetMapping(value = "/scan/scanEstate_qr.png", produces = MediaType.IMAGE_PNG_VALUE)
  391. // public void scanEstateQrImg(HttpServletResponse response) throws IOException, WriterException {
  392. // @Cleanup ServletOutputStream outputStream = response.getOutputStream();
  393. // String msg = URLEncoder.encode( domain + "user/scanEstate.html","utf-8");
  394. // BitMatrix matrix = new MultiFormatWriter().encode(oauth2 + appId + "&redirect_uri=" +
  395. // msg + moreUrl, BarcodeFormat.QR_CODE, 256, 256);
  396. // MatrixToImageWriter.writeToStream(matrix, MediaType.IMAGE_PNG.getSubtype(), outputStream, new MatrixToImageConfig());
  397. // }
  398. }