82186c58d3da35291079f99e2940ed40f4fb612c.svn-base 3.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
  1. package org.jeecg.modules.system.controller;
  2. import java.util.ArrayList;
  3. import java.util.List;
  4. import javax.servlet.http.HttpServletRequest;
  5. import org.jeecg.common.api.vo.Result;
  6. import org.jeecg.common.system.query.QueryGenerator;
  7. import org.jeecg.common.util.oConvertUtils;
  8. import org.jeecg.modules.system.entity.SysDataLog;
  9. import org.jeecg.modules.system.service.ISysDataLogService;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.RequestMethod;
  13. import org.springframework.web.bind.annotation.RequestParam;
  14. import org.springframework.web.bind.annotation.RestController;
  15. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  16. import com.baomidou.mybatisplus.core.metadata.IPage;
  17. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  18. import lombok.extern.slf4j.Slf4j;
  19. @RestController
  20. @RequestMapping("/sys/dataLog")
  21. @Slf4j
  22. public class SysDataLogController {
  23. @Autowired
  24. private ISysDataLogService service;
  25. @RequestMapping(value = "/list", method = RequestMethod.GET)
  26. public Result<IPage<SysDataLog>> queryPageList(SysDataLog dataLog,@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
  27. @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,HttpServletRequest req) {
  28. Result<IPage<SysDataLog>> result = new Result<IPage<SysDataLog>>();
  29. QueryWrapper<SysDataLog> queryWrapper = QueryGenerator.initQueryWrapper(dataLog, req.getParameterMap());
  30. Page<SysDataLog> page = new Page<SysDataLog>(pageNo, pageSize);
  31. IPage<SysDataLog> pageList = service.page(page, queryWrapper);
  32. log.info("查询当前页:"+pageList.getCurrent());
  33. log.info("查询当前页数量:"+pageList.getSize());
  34. log.info("查询结果数量:"+pageList.getRecords().size());
  35. log.info("数据总数:"+pageList.getTotal());
  36. result.setSuccess(true);
  37. result.setResult(pageList);
  38. return result;
  39. }
  40. /**
  41. * 查询对比数据
  42. * @param req
  43. * @return
  44. */
  45. @RequestMapping(value = "/queryCompareList", method = RequestMethod.GET)
  46. public Result<List<SysDataLog>> queryCompareList(HttpServletRequest req) {
  47. Result<List<SysDataLog>> result = new Result<>();
  48. String dataId1 = req.getParameter("dataId1");
  49. String dataId2 = req.getParameter("dataId2");
  50. List<String> idList = new ArrayList<String>();
  51. idList.add(dataId1);
  52. idList.add(dataId2);
  53. try {
  54. List<SysDataLog> list = (List<SysDataLog>) service.listByIds(idList);
  55. result.setResult(list);
  56. result.setSuccess(true);
  57. } catch (Exception e) {
  58. log.error(e.getMessage(),e);
  59. }
  60. return result;
  61. }
  62. /**
  63. * 查询版本信息
  64. * @param req
  65. * @return
  66. */
  67. @RequestMapping(value = "/queryDataVerList", method = RequestMethod.GET)
  68. public Result<List<SysDataLog>> queryDataVerList(HttpServletRequest req) {
  69. Result<List<SysDataLog>> result = new Result<>();
  70. String dataTable = req.getParameter("dataTable");
  71. String dataId = req.getParameter("dataId");
  72. QueryWrapper<SysDataLog> queryWrapper = new QueryWrapper<SysDataLog>();
  73. queryWrapper.eq("data_table", dataTable);
  74. queryWrapper.eq("data_id", dataId);
  75. List<SysDataLog> list = service.list(queryWrapper);
  76. if(list==null||list.size()<=0) {
  77. result.error500("未找到版本信息");
  78. }else {
  79. result.setResult(list);
  80. result.setSuccess(true);
  81. }
  82. return result;
  83. }
  84. }