1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 |
- package com.bowintek.practice.controller;
- import com.bowintek.practice.filter.exception.BaseErrorEnum;
- import com.bowintek.practice.filter.exception.BaseException;
- import com.bowintek.practice.filter.exception.BaseResponse;
- import com.bowintek.practice.filter.exception.RespGenerstor;
- import com.bowintek.practice.model.SrSaerchtemp;
- import com.bowintek.practice.model.SrSubject;
- import com.bowintek.practice.services.service.AccountService;
- import com.bowintek.practice.services.service.GenSqlStringService;
- import com.bowintek.practice.services.service.TempService;
- import com.bowintek.practice.services.service.system.RoleService;
- import com.bowintek.practice.vo.SaerchtempVo;
- import com.bowintek.practice.vo.system.FunctionCodeModel;
- import com.bowintek.practice.vo.system.RoleFunctionCodeModel;
- import com.bowintek.practice.vo.system.RoleModel;
- import com.bowintek.practice.vo.temp.GenSqlStringResult;
- import com.bowintek.practice.vo.temp.TempObjectModel;
- import com.bowintek.practice.vo.user.UserInfoModel;
- import com.github.pagehelper.PageInfo;
- import lombok.Data;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.web.bind.annotation.*;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
- import java.util.UUID;
- @RestController
- @RequestMapping("/api/temp")
- public class TempController {
- @Autowired
- private TempService tempService;
- @Autowired
- private GenSqlStringService genSqlStringService;
- @Autowired
- private AccountService accountService;
- @ResponseBody
- @GetMapping("/getList")
- public BaseResponse<PageInfo<SaerchtempVo>> getList(@RequestParam("page") int page, @RequestParam("rows") int rows,
- String tempNo, String tempName, String beiginDate,
- String endDate) throws Exception {
- PageInfo<SaerchtempVo> result = tempService.getList(page, rows, tempNo, tempName, beiginDate, endDate, null);
- return RespGenerstor.success(result);
- }
- @ResponseBody
- @GetMapping("/getSubjectTree")
- public BaseResponse<List<HashMap<String, Object>>> getSubjectTree(@RequestParam(required = false) String tabName) {
- return RespGenerstor.success(tempService.getSubjectTree(tabName));
- }
- @GetMapping("get")
- public BaseResponse<RoleModel> get(String tempId) {
- return RespGenerstor.success(tempService.getTemp(tempId));
- }
- @PostMapping("/save")
- public BaseResponse<TempObjectModel> saveTemp(@RequestBody TempObjectModel data) {
- return RespGenerstor.success(tempService.saveTemp(data, accountService.getLoginUserID()));
- }
- @PostMapping("/genQuery")
- public BaseResponse<TempObjectModel> genTest(@RequestBody TempObjectModel data) {
- HashMap<String, Object> rtnObject = new HashMap<>();
- try {
- GenSqlStringResult sqlStringResult = genSqlStringService.Generation(data, accountService.getLoginUserID());
- rtnObject.put("sqlString", sqlStringResult.getMainSqlString());
- rtnObject.put("cntString", sqlStringResult.getCountSqlStrimg());
- List<Map<String, Object>> rows = genSqlStringService.getListBySqlString(sqlStringResult.getMainSqlString());
- rtnObject.put("rows", rows);
- int total = genSqlStringService.getIntBySqlString(sqlStringResult.getCountSqlStrimg(), "CNT");
- rtnObject.put("total", total);
- rtnObject.put("code", 0);
- } catch (Exception ex) {
- rtnObject.put("errString", "生成查询语句错误:" + ex.getMessage());
- rtnObject.put("code", -1);
- ex.printStackTrace();
- }
- return RespGenerstor.success(rtnObject);
- }
- @ResponseBody
- @PostMapping("/deletes")
- public BaseResponse delete(@RequestBody List<String> idList) {
- Integer result = tempService.deleteTemp(idList);
- return RespGenerstor.success(result);
- }
- @PostMapping("/getDictionaryList")
- public BaseResponse getDictionaryList(@RequestBody List<String> codeList) {
- return RespGenerstor.success(tempService.getDictionaryToHashMap(codeList));
- }
- }
|