ScreenCarController.java 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. package com.huimv.video.dhicc.ScreenController;
  2. import com.dahuatech.icc.exception.ClientException;
  3. import com.huimv.video.dhicc.result.R;
  4. import com.huimv.video.dhicc.util.GetResponse;
  5. import org.springframework.web.bind.annotation.RequestMapping;
  6. import org.springframework.web.bind.annotation.RestController;
  7. import javax.servlet.http.HttpServletRequest;
  8. import java.text.SimpleDateFormat;
  9. import java.util.*;
  10. @RestController
  11. @RequestMapping("/screen/car")
  12. //没有连接ICC的数据库 所以操作比较麻烦
  13. public class ScreenCarController {
  14. //过车的数据//这个是车辆闸机的过车数据
  15. /**
  16. * 应该优化一下放到表里面去 不然的话这样请求一整页的数据会很慢
  17. * 保存ntamade
  18. * 通过开始结束时间来查页数
  19. * &queryTimeBegin=2021-12-01+00%3A00%3A00&
  20. * queryTimeEnd=2021-12-01+23%3A59%3A59&
  21. */
  22. // https://36.26.62.70:447/evo-apigw/ipms/carcapture/find/conditions?pageNum=1&pageSize=10&queryTimeBegin=2021-12-01+00%3A00%3A00&queryTimeEnd=2021-12-01+23%3A59%3A59&_=1638356246174
  23. @RequestMapping("/count_car_record")
  24. public R ddgetCarRecord(HttpServletRequest request ) throws ClientException {
  25. GetResponse getResponse = new GetResponse();
  26. SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  27. Calendar c = Calendar.getInstance();
  28. Date date = new Date();
  29. c.setTime(date);
  30. c.set(Calendar.HOUR_OF_DAY, 0);
  31. c.set(Calendar.MINUTE, 0);
  32. c.set(Calendar.SECOND, 0);
  33. c.add(Calendar.DATE, +1);
  34. Date A = c.getTime();
  35. String formatA = format.format(A);
  36. c.add(Calendar.DATE, -1);
  37. Date B = c.getTime();
  38. String formatB = format.format(B);
  39. c.add(Calendar.DATE, -1);
  40. Date C = c.getTime();
  41. String formatC = format.format(C);
  42. c.add(Calendar.DATE, -1);
  43. Date D = c.getTime();
  44. String formatD = format.format(D);
  45. c.add(Calendar.DATE, -1);
  46. Date E = c.getTime();
  47. String formatE = format.format(E);
  48. c.add(Calendar.DATE, -1);
  49. Date F = c.getTime();
  50. String formatF = format.format(F);
  51. c.add(Calendar.DATE, -1);
  52. Date G = c.getTime();
  53. String formatG = format.format(G);
  54. c.add(Calendar.DATE, -1);
  55. Date H = c.getTime();
  56. String formatH = format.format(H);
  57. List result = new ArrayList();
  58. Map map1 = new HashMap();
  59. map1.put("time",splitTime(B));
  60. map1.put("value",getResponse.SendMassageGetPage( formatB , formatA ));
  61. Map map2 = new HashMap();
  62. map2.put("time",splitTime(C));
  63. map2.put("value",getResponse.SendMassageGetPage( formatC , formatB));
  64. Map map3 = new HashMap();
  65. map3.put("time",splitTime(D));
  66. map3.put("value",getResponse.SendMassageGetPage(formatD, formatC));
  67. Map map4 = new HashMap();
  68. map4.put("time",splitTime(E));
  69. map4.put("value",getResponse.SendMassageGetPage(formatE , formatD));
  70. Map map5 = new HashMap();
  71. map5.put("time",splitTime(F));
  72. map5.put("value",getResponse.SendMassageGetPage( formatF , formatE));
  73. Map map6 = new HashMap();
  74. map6.put("time",splitTime(G));
  75. map6.put("value",getResponse.SendMassageGetPage( formatG , formatF));
  76. Map map7 = new HashMap();
  77. map7.put("time",splitTime(H));
  78. map7.put("value",getResponse.SendMassageGetPage(formatH , formatG));
  79. result.add(map1);
  80. result.add(map2);
  81. result.add(map3);
  82. result.add(map4);
  83. result.add(map5);
  84. result.add(map6);
  85. result.add(map7);
  86. //翻转
  87. Collections.reverse(result);
  88. return R.ok("请求成功").put("data", result );
  89. }
  90. public String splitTime(Date date){
  91. Calendar calendar = Calendar.getInstance();
  92. calendar.setTime(date);
  93. String date1 = calendar.get(Calendar.MONTH)+1+"/"+calendar.get(Calendar.DATE);
  94. return date1;
  95. }
  96. }