DataViewController.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427
  1. package cn.com.usky.iot.controller;
  2. import javax.annotation.PostConstruct;
  3. import javax.annotation.Resource;
  4. import javax.servlet.http.HttpServletRequest;
  5. import cn.com.usky.iot.auth.TokenAuthBO;
  6. import cn.com.usky.iot.auth.TokenAuthService;
  7. import cn.com.usky.iot.controller.login.Constants;
  8. import cn.com.usky.iot.entity.YtiotTAdmin;
  9. import cn.com.usky.utils.HttpServletRequestUtils;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.stereotype.Controller;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13. import org.springframework.web.bind.annotation.RequestMethod;
  14. import org.springframework.web.bind.annotation.RequestParam;
  15. import org.springframework.web.servlet.ModelAndView;
  16. import cn.com.usky.iot.data.service.YtiotVDataService;
  17. @Controller
  18. @RequestMapping("/iot/data/view")
  19. public class DataViewController {
  20. @Resource
  21. private YtiotVDataService ytiotVDataService;
  22. private static DataViewController dataViewController;
  23. @PostConstruct
  24. public void init() {
  25. dataViewController = this;
  26. dataViewController.ytiotVDataService = this.ytiotVDataService;
  27. }
  28. @Autowired
  29. private TokenAuthService tokenAuthService;
  30. @RequestMapping(value = "/getSyncPointVList", method = {RequestMethod.GET, RequestMethod.POST})
  31. public ModelAndView getSyncPointVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  32. @RequestParam(value = "page", required = false) String page,
  33. @RequestParam(value = "start", required = false) String start,
  34. @RequestParam(value = "limit", required = false) String limit,
  35. @RequestParam(value = "sort", required = false) String sort,
  36. HttpServletRequest request) {
  37. ModelAndView mav = new ModelAndView();
  38. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  39. boolean isAuth = tokenAuthBO.isAuthState();
  40. if (!isAuth) {
  41. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  42. json.put("check", false);
  43. json.put("errMsg", "权限错误,请重新登录");
  44. mav.addObject("ret_str", json.toJSONString());
  45. }
  46. mav.setViewName("return");
  47. //通过获取用户信息
  48. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  49. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  50. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  51. jsonObject.put("V_PASSWORD", o.getVPassword());
  52. try {
  53. String ret = dataViewController.ytiotVDataService.getSyncPointVList(jsonObject.toString(), page, start, limit, sort);
  54. mav.addObject("ret_str", ret);
  55. } catch (Exception e) {
  56. // TODO Auto-generated catch block
  57. e.printStackTrace();
  58. }
  59. return mav;
  60. }
  61. @RequestMapping(value = "/getSyncDataVList", method = {RequestMethod.GET, RequestMethod.POST})
  62. public ModelAndView getSyncDataVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  63. @RequestParam(value = "page", required = false) String page,
  64. @RequestParam(value = "start", required = false) String start,
  65. @RequestParam(value = "limit", required = false) String limit,
  66. @RequestParam(value = "sort", required = false) String sort,
  67. HttpServletRequest request) {
  68. ModelAndView mav = new ModelAndView();
  69. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  70. boolean isAuth = tokenAuthBO.isAuthState();
  71. if (!isAuth) {
  72. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  73. json.put("check", false);
  74. json.put("errMsg", "权限错误,请重新登录");
  75. mav.addObject("ret_str", json.toJSONString());
  76. }
  77. mav.setViewName("return");
  78. //通过获取用户信息
  79. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  80. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  81. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  82. jsonObject.put("V_PASSWORD", o.getVPassword());
  83. try {
  84. String ret = dataViewController.ytiotVDataService.getSyncDataVList(jsonObject.toString(), page, start, limit, sort);
  85. mav.addObject("ret_str", ret);
  86. } catch (Exception e) {
  87. // TODO Auto-generated catch block
  88. e.printStackTrace();
  89. }
  90. return mav;
  91. }
  92. @RequestMapping(value = "/getSyncDataQList", method = {RequestMethod.GET, RequestMethod.POST})
  93. public ModelAndView getSyncDataQList(@RequestParam(value = "queryJson", required = false) String queryJson,
  94. @RequestParam(value = "page", required = false) String page,
  95. @RequestParam(value = "start", required = false) String start,
  96. @RequestParam(value = "limit", required = false) String limit,
  97. @RequestParam(value = "sort", required = false) String sort,
  98. HttpServletRequest request) {
  99. ModelAndView mav = new ModelAndView();
  100. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  101. boolean isAuth = tokenAuthBO.isAuthState();
  102. if (!isAuth) {
  103. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  104. json.put("check", false);
  105. json.put("errMsg", "权限错误,请重新登录");
  106. mav.addObject("ret_str", json.toJSONString());
  107. }
  108. mav.setViewName("return");
  109. //通过获取用户信息
  110. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  111. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  112. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  113. jsonObject.put("V_PASSWORD", o.getVPassword());
  114. try {
  115. String ret = dataViewController.ytiotVDataService.getSyncDataQList(jsonObject.toString(), page, start, limit, sort);
  116. mav.addObject("ret_str", ret);
  117. } catch (Exception e) {
  118. // TODO Auto-generated catch block
  119. e.printStackTrace();
  120. }
  121. return mav;
  122. }
  123. @RequestMapping(value = "/getSyncwaterDataVList", method = {RequestMethod.GET, RequestMethod.POST})
  124. public ModelAndView getSyncwaterDataVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  125. @RequestParam(value = "page", required = false) String page,
  126. @RequestParam(value = "start", required = false) String start,
  127. @RequestParam(value = "limit", required = false) String limit,
  128. @RequestParam(value = "sort", required = false) String sort,
  129. HttpServletRequest request) {
  130. ModelAndView mav = new ModelAndView();
  131. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  132. boolean isAuth = tokenAuthBO.isAuthState();
  133. if (!isAuth) {
  134. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  135. json.put("check", false);
  136. json.put("errMsg", "权限错误,请重新登录");
  137. mav.addObject("ret_str", json.toJSONString());
  138. }
  139. mav.setViewName("return");
  140. //通过获取用户信息
  141. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  142. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  143. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  144. jsonObject.put("V_PASSWORD", o.getVPassword());
  145. try {
  146. String ret = dataViewController.ytiotVDataService.getSyncwaterDataVList(jsonObject.toString(), page, start, limit, sort);
  147. mav.addObject("ret_str", ret);
  148. } catch (Exception e) {
  149. // TODO Auto-generated catch block
  150. e.printStackTrace();
  151. }
  152. return mav;
  153. }
  154. @RequestMapping(value = "/getSyncDataRList", method = {RequestMethod.GET, RequestMethod.POST})
  155. public ModelAndView getSyncDataRList(@RequestParam(value = "queryJson", required = false) String queryJson,
  156. @RequestParam(value = "page", required = false) String page,
  157. @RequestParam(value = "start", required = false) String start,
  158. @RequestParam(value = "limit", required = false) String limit,
  159. @RequestParam(value = "sort", required = false) String sort,
  160. HttpServletRequest request) {
  161. ModelAndView mav = new ModelAndView();
  162. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  163. boolean isAuth = tokenAuthBO.isAuthState();
  164. if (!isAuth) {
  165. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  166. json.put("check", false);
  167. json.put("errMsg", "权限错误,请重新登录");
  168. mav.addObject("ret_str", json.toJSONString());
  169. }
  170. mav.setViewName("return");
  171. //通过获取用户信息
  172. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  173. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  174. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  175. jsonObject.put("V_PASSWORD", o.getVPassword());
  176. try {
  177. String ret = dataViewController.ytiotVDataService.getSyncDataRList(jsonObject.toString(), page, start, limit, sort);
  178. mav.addObject("ret_str", ret);
  179. } catch (Exception e) {
  180. // TODO Auto-generated catch block
  181. e.printStackTrace();
  182. }
  183. return mav;
  184. }
  185. @RequestMapping(value = "/getSyncrtuDataVList", method = {RequestMethod.GET, RequestMethod.POST})
  186. public ModelAndView getSyncrtuDataVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  187. @RequestParam(value = "page", required = false) String page,
  188. @RequestParam(value = "start", required = false) String start,
  189. @RequestParam(value = "limit", required = false) String limit,
  190. @RequestParam(value = "sort", required = false) String sort,
  191. HttpServletRequest request) {
  192. ModelAndView mav = new ModelAndView();
  193. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  194. boolean isAuth = tokenAuthBO.isAuthState();
  195. if (!isAuth) {
  196. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  197. json.put("check", false);
  198. json.put("errMsg", "权限错误,请重新登录");
  199. mav.addObject("ret_str", json.toJSONString());
  200. }
  201. mav.setViewName("return");
  202. //通过获取用户信息
  203. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  204. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  205. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  206. jsonObject.put("V_PASSWORD", o.getVPassword());
  207. try {
  208. String ret = dataViewController.ytiotVDataService.getSyncrtuDataVList(jsonObject.toString(), page, start, limit, sort);
  209. mav.addObject("ret_str", ret);
  210. } catch (Exception e) {
  211. // TODO Auto-generated catch block
  212. e.printStackTrace();
  213. }
  214. return mav;
  215. }
  216. @RequestMapping(value = "/getSyncDataFList", method = {RequestMethod.GET, RequestMethod.POST})
  217. public ModelAndView getSyncDataFList(@RequestParam(value = "queryJson", required = false) String queryJson,
  218. @RequestParam(value = "page", required = false) String page,
  219. @RequestParam(value = "start", required = false) String start,
  220. @RequestParam(value = "limit", required = false) String limit,
  221. @RequestParam(value = "sort", required = false) String sort,
  222. HttpServletRequest request) {
  223. ModelAndView mav = new ModelAndView();
  224. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  225. boolean isAuth = tokenAuthBO.isAuthState();
  226. if (!isAuth) {
  227. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  228. json.put("check", false);
  229. json.put("errMsg", "权限错误,请重新登录");
  230. mav.addObject("ret_str", json.toJSONString());
  231. }
  232. mav.setViewName("return");
  233. //通过获取用户信息
  234. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  235. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  236. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  237. jsonObject.put("V_PASSWORD", o.getVPassword());
  238. try {
  239. String ret = dataViewController.ytiotVDataService.getSyncDataFList(jsonObject.toString(), page, start, limit, sort);
  240. mav.addObject("ret_str", ret);
  241. } catch (Exception e) {
  242. // TODO Auto-generated catch block
  243. e.printStackTrace();
  244. }
  245. return mav;
  246. }
  247. @RequestMapping(value = "/getSyncfireDataVList", method = {RequestMethod.GET, RequestMethod.POST})
  248. public ModelAndView getSyncfireDataVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  249. @RequestParam(value = "page", required = false) String page,
  250. @RequestParam(value = "start", required = false) String start,
  251. @RequestParam(value = "limit", required = false) String limit,
  252. @RequestParam(value = "sort", required = false) String sort,
  253. HttpServletRequest request) {
  254. ModelAndView mav = new ModelAndView();
  255. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  256. boolean isAuth = tokenAuthBO.isAuthState();
  257. if (!isAuth) {
  258. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  259. json.put("check", false);
  260. json.put("errMsg", "权限错误,请重新登录");
  261. mav.addObject("ret_str", json.toJSONString());
  262. }
  263. mav.setViewName("return");
  264. //通过获取用户信息
  265. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  266. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  267. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  268. jsonObject.put("V_PASSWORD", o.getVPassword());
  269. try {
  270. String ret = dataViewController.ytiotVDataService.getSyncfireDataVList(jsonObject.toString(), page, start, limit, sort);
  271. mav.addObject("ret_str", ret);
  272. } catch (Exception e) {
  273. // TODO Auto-generated catch block
  274. e.printStackTrace();
  275. }
  276. return mav;
  277. }
  278. @RequestMapping(value = "/getSyncDataVListByCompany", method = {RequestMethod.GET, RequestMethod.POST})
  279. public ModelAndView getSyncDataVListByCompany(@RequestParam(value = "queryJson", required = false) String queryJson,
  280. HttpServletRequest request) {
  281. ModelAndView mav = new ModelAndView();
  282. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  283. boolean isAuth = tokenAuthBO.isAuthState();
  284. if (!isAuth) {
  285. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  286. json.put("check", false);
  287. json.put("errMsg", "权限错误,请重新登录");
  288. mav.addObject("ret_str", json.toJSONString());
  289. }
  290. mav.setViewName("return");
  291. //通过获取用户信息
  292. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  293. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  294. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  295. jsonObject.put("V_PASSWORD", o.getVPassword());
  296. try {
  297. String ret = dataViewController.ytiotVDataService.getSyncDataVListByCompany(jsonObject.toString());
  298. mav.addObject("ret_str", ret);
  299. } catch (Exception e) {
  300. // TODO Auto-generated catch block
  301. e.printStackTrace();
  302. }
  303. return mav;
  304. }
  305. // @RequestMapping(value="/getSyncDataFexcelList",method= {RequestMethod.GET,RequestMethod.POST})
  306. // public static ModelAndView getSyncDataFexcelList(@RequestParam(value = "queryJson", required = false) String queryJson) {
  307. // ModelAndView mav = new ModelAndView();
  308. // mav.setViewName("return");
  309. // try {
  310. // String ret = dataViewController.ytiotVDataService.getSyncDataFexcelList(queryJson);
  311. // mav.addObject("ret_str", ret);
  312. // } catch (Exception e) {
  313. // // TODO Auto-generated catch block
  314. // e.printStackTrace();
  315. // }
  316. // return mav;
  317. // }
  318. @RequestMapping(value = "/getSyncDataByDays", method = {RequestMethod.GET, RequestMethod.POST})
  319. public ModelAndView getConfirmStatusByDays(@RequestParam(value = "queryJson", required = false) String queryJson,
  320. HttpServletRequest request) {
  321. // TODO Auto-generated constructor stub
  322. ModelAndView mav = new ModelAndView();
  323. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  324. boolean isAuth = tokenAuthBO.isAuthState();
  325. if (!isAuth) {
  326. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  327. json.put("check", false);
  328. json.put("errMsg", "权限错误,请重新登录");
  329. mav.addObject("ret_str", json.toJSONString());
  330. }
  331. mav.setViewName("return");
  332. //通过获取用户信息
  333. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  334. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  335. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  336. jsonObject.put("V_PASSWORD", o.getVPassword());
  337. try {
  338. String ret = dataViewController.ytiotVDataService.getSyncDataByDays(jsonObject.toString());
  339. // System.out.println(ret);
  340. mav.addObject("ret_str", ret);
  341. } catch (Exception e) {
  342. // TODO Auto-generated catch block
  343. e.printStackTrace();
  344. }
  345. return mav;
  346. }
  347. @RequestMapping(value = "/getSyncStatusVList", method = {RequestMethod.GET, RequestMethod.POST})
  348. public ModelAndView getSyncStatusVList(@RequestParam(value = "queryJson", required = false) String queryJson,
  349. @RequestParam(value = "page", required = false) String page,
  350. @RequestParam(value = "start", required = false) String start,
  351. @RequestParam(value = "limit", required = false) String limit,
  352. @RequestParam(value = "sort", required = false) String sort,
  353. HttpServletRequest request) {
  354. ModelAndView mav = new ModelAndView();
  355. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  356. boolean isAuth = tokenAuthBO.isAuthState();
  357. if (!isAuth) {
  358. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  359. json.put("check", false);
  360. json.put("errMsg", "权限错误,请重新登录");
  361. mav.addObject("ret_str", json.toJSONString());
  362. }
  363. mav.setViewName("return");
  364. //通过获取用户信息
  365. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  366. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  367. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  368. jsonObject.put("V_PASSWORD", o.getVPassword());
  369. try {
  370. String ret = dataViewController.ytiotVDataService.getSyncStatusVList(jsonObject.toString(), page, start, limit, sort);
  371. mav.addObject("ret_str", ret);
  372. } catch (Exception e) {
  373. // TODO Auto-generated catch block
  374. e.printStackTrace();
  375. }
  376. return mav;
  377. }
  378. @RequestMapping(value = "/getSyncStatusVListByCompany", method = {RequestMethod.GET, RequestMethod.POST})
  379. public ModelAndView getSyncStatusVListByCompany(@RequestParam(value = "queryJson", required = false) String queryJson,
  380. HttpServletRequest request) {
  381. ModelAndView mav = new ModelAndView();
  382. TokenAuthBO tokenAuthBO = HttpServletRequestUtils.tokenAuthForYT(request, tokenAuthService);
  383. boolean isAuth = tokenAuthBO.isAuthState();
  384. if (!isAuth) {
  385. com.alibaba.fastjson.JSONObject json = new com.alibaba.fastjson.JSONObject();
  386. json.put("check", false);
  387. json.put("errMsg", "权限错误,请重新登录");
  388. mav.addObject("ret_str", json.toJSONString());
  389. }
  390. mav.setViewName("return");
  391. //通过获取用户信息
  392. YtiotTAdmin o = (YtiotTAdmin) tokenAuthBO.getData().get(Constants.USER_INFO);
  393. com.alibaba.fastjson.JSONObject jsonObject = com.alibaba.fastjson.JSONObject.parseObject(queryJson);
  394. jsonObject.put("V_LOGINNAME", o.getVLoginname());
  395. jsonObject.put("V_PASSWORD", o.getVPassword());
  396. try {
  397. String ret = dataViewController.ytiotVDataService.getSyncStatusVListByCompany(jsonObject.toString());
  398. mav.addObject("ret_str", ret);
  399. } catch (Exception e) {
  400. // TODO Auto-generated catch block
  401. e.printStackTrace();
  402. }
  403. return mav;
  404. }
  405. }