SysDataLogController.java 3.3 KB

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