TempController.java 4.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. package com.bowintek.practice.controller;
  2. import com.bowintek.practice.filter.exception.BaseErrorEnum;
  3. import com.bowintek.practice.filter.exception.BaseException;
  4. import com.bowintek.practice.filter.exception.BaseResponse;
  5. import com.bowintek.practice.filter.exception.RespGenerstor;
  6. import com.bowintek.practice.model.SrSaerchtemp;
  7. import com.bowintek.practice.model.SrSubject;
  8. import com.bowintek.practice.services.service.AccountService;
  9. import com.bowintek.practice.services.service.GenSqlStringService;
  10. import com.bowintek.practice.services.service.TempService;
  11. import com.bowintek.practice.services.service.system.RoleService;
  12. import com.bowintek.practice.vo.SaerchtempVo;
  13. import com.bowintek.practice.vo.system.FunctionCodeModel;
  14. import com.bowintek.practice.vo.system.RoleFunctionCodeModel;
  15. import com.bowintek.practice.vo.system.RoleModel;
  16. import com.bowintek.practice.vo.temp.GenSqlStringResult;
  17. import com.bowintek.practice.vo.temp.TempObjectModel;
  18. import com.bowintek.practice.vo.user.UserInfoModel;
  19. import com.github.pagehelper.PageInfo;
  20. import lombok.Data;
  21. import org.springframework.beans.factory.annotation.Autowired;
  22. import org.springframework.web.bind.annotation.*;
  23. import java.util.HashMap;
  24. import java.util.List;
  25. import java.util.Map;
  26. import java.util.UUID;
  27. @RestController
  28. @RequestMapping("/api/temp")
  29. public class TempController {
  30. @Autowired
  31. private TempService tempService;
  32. @Autowired
  33. private GenSqlStringService genSqlStringService;
  34. @Autowired
  35. private AccountService accountService;
  36. @ResponseBody
  37. @GetMapping("/getList")
  38. public BaseResponse<PageInfo<SaerchtempVo>> getList(@RequestParam("page") int page, @RequestParam("rows") int rows,
  39. String tempNo, String tempName, String beiginDate,
  40. String endDate) throws Exception {
  41. PageInfo<SaerchtempVo> result = tempService.getList(page, rows, tempNo, tempName, beiginDate, endDate, null);
  42. return RespGenerstor.success(result);
  43. }
  44. @ResponseBody
  45. @GetMapping("/getSubjectTree")
  46. public BaseResponse<List<HashMap<String, Object>>> getSubjectTree(@RequestParam(required = false) String tabName) {
  47. return RespGenerstor.success(tempService.getSubjectTree(tabName));
  48. }
  49. @GetMapping("get")
  50. public BaseResponse<RoleModel> get(String tempId) {
  51. return RespGenerstor.success(tempService.getTemp(tempId));
  52. }
  53. @PostMapping("/save")
  54. public BaseResponse<TempObjectModel> saveTemp(@RequestBody TempObjectModel data) {
  55. return RespGenerstor.success(tempService.saveTemp(data, accountService.getLoginUserID()));
  56. }
  57. @PostMapping("/genQuery")
  58. public BaseResponse<TempObjectModel> genTest(@RequestBody TempObjectModel data) {
  59. HashMap<String, Object> rtnObject = new HashMap<>();
  60. try {
  61. GenSqlStringResult sqlStringResult = genSqlStringService.Generation(data, accountService.getLoginUserID());
  62. rtnObject.put("sqlString", sqlStringResult.getMainSqlString());
  63. rtnObject.put("cntString", sqlStringResult.getCountSqlStrimg());
  64. List<Map<String, Object>> rows = genSqlStringService.getListBySqlString(sqlStringResult.getMainSqlString());
  65. rtnObject.put("rows", rows);
  66. int total = genSqlStringService.getIntBySqlString(sqlStringResult.getCountSqlStrimg(), "CNT");
  67. rtnObject.put("total", total);
  68. rtnObject.put("code", 0);
  69. } catch (Exception ex) {
  70. rtnObject.put("errString", "生成查询语句错误:" + ex.getMessage());
  71. rtnObject.put("code", -1);
  72. ex.printStackTrace();
  73. }
  74. return RespGenerstor.success(rtnObject);
  75. }
  76. @ResponseBody
  77. @PostMapping("/deletes")
  78. public BaseResponse delete(@RequestBody List<String> idList) {
  79. Integer result = tempService.deleteTemp(idList);
  80. return RespGenerstor.success(result);
  81. }
  82. @PostMapping("/getDictionaryList")
  83. public BaseResponse getDictionaryList(@RequestBody List<String> codeList) {
  84. return RespGenerstor.success(tempService.getDictionaryToHashMap(codeList));
  85. }
  86. }