TestDemoController.java 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148
  1. package com.ruoyi.demo.controller;
  2. import cn.dev33.satoken.annotation.SaCheckPermission;
  3. import cn.hutool.core.bean.BeanUtil;
  4. import com.ruoyi.common.annotation.Log;
  5. import com.ruoyi.common.annotation.RepeatSubmit;
  6. import com.ruoyi.common.core.controller.BaseController;
  7. import com.ruoyi.common.core.domain.PageQuery;
  8. import com.ruoyi.common.core.domain.R;
  9. import com.ruoyi.common.core.page.TableDataInfo;
  10. import com.ruoyi.common.core.validate.AddGroup;
  11. import com.ruoyi.common.core.validate.EditGroup;
  12. import com.ruoyi.common.core.validate.QueryGroup;
  13. import com.ruoyi.common.enums.BusinessType;
  14. import com.ruoyi.common.excel.ExcelResult;
  15. import com.ruoyi.common.utils.ValidatorUtils;
  16. import com.ruoyi.common.utils.poi.ExcelUtil;
  17. import com.ruoyi.demo.domain.TestDemo;
  18. import com.ruoyi.demo.domain.bo.TestDemoBo;
  19. import com.ruoyi.demo.domain.bo.TestDemoImportVo;
  20. import com.ruoyi.demo.domain.vo.TestDemoVo;
  21. import com.ruoyi.demo.service.ITestDemoService;
  22. import lombok.RequiredArgsConstructor;
  23. import org.springframework.http.MediaType;
  24. import org.springframework.validation.annotation.Validated;
  25. import org.springframework.web.bind.annotation.*;
  26. import org.springframework.web.multipart.MultipartFile;
  27. import javax.servlet.http.HttpServletResponse;
  28. import javax.validation.constraints.NotEmpty;
  29. import javax.validation.constraints.NotNull;
  30. import java.util.Arrays;
  31. import java.util.List;
  32. import java.util.concurrent.TimeUnit;
  33. /**
  34. * 测试单表Controller
  35. *
  36. * @author Lion Li
  37. * @date 2021-07-26
  38. */
  39. @Validated
  40. @RequiredArgsConstructor
  41. @RestController
  42. @RequestMapping("/demo/demo")
  43. public class TestDemoController extends BaseController {
  44. private final ITestDemoService iTestDemoService;
  45. /**
  46. * 查询测试单表列表
  47. */
  48. @SaCheckPermission("demo:demo:list")
  49. @GetMapping("/list")
  50. public TableDataInfo<TestDemoVo> list(@Validated(QueryGroup.class) TestDemoBo bo, PageQuery pageQuery) {
  51. return iTestDemoService.queryPageList(bo, pageQuery);
  52. }
  53. /**
  54. * 自定义分页查询
  55. */
  56. @SaCheckPermission("demo:demo:list")
  57. @GetMapping("/page")
  58. public TableDataInfo<TestDemoVo> page(@Validated(QueryGroup.class) TestDemoBo bo, PageQuery pageQuery) {
  59. return iTestDemoService.customPageList(bo, pageQuery);
  60. }
  61. /**
  62. * 导入数据
  63. *
  64. * @param file 导入文件
  65. */
  66. @Log(title = "测试单表", businessType = BusinessType.IMPORT)
  67. @SaCheckPermission("demo:demo:import")
  68. @PostMapping(value = "/importData", consumes = MediaType.MULTIPART_FORM_DATA_VALUE)
  69. public R<Void> importData(@RequestPart("file") MultipartFile file) throws Exception {
  70. ExcelResult<TestDemoImportVo> excelResult = ExcelUtil.importExcel(file.getInputStream(), TestDemoImportVo.class, true);
  71. List<TestDemoImportVo> volist = excelResult.getList();
  72. List<TestDemo> list = BeanUtil.copyToList(volist, TestDemo.class);
  73. iTestDemoService.saveBatch(list);
  74. return R.ok(excelResult.getAnalysis());
  75. }
  76. /**
  77. * 导出测试单表列表
  78. */
  79. @SaCheckPermission("demo:demo:export")
  80. @Log(title = "测试单表", businessType = BusinessType.EXPORT)
  81. @PostMapping("/export")
  82. public void export(@Validated TestDemoBo bo, HttpServletResponse response) {
  83. List<TestDemoVo> list = iTestDemoService.queryList(bo);
  84. // 测试雪花id导出
  85. // for (TestDemoVo vo : list) {
  86. // vo.setId(1234567891234567893L);
  87. // }
  88. ExcelUtil.exportExcel(list, "测试单表", TestDemoVo.class, response);
  89. }
  90. /**
  91. * 获取测试单表详细信息
  92. *
  93. * @param id 测试ID
  94. */
  95. @SaCheckPermission("demo:demo:query")
  96. @GetMapping("/{id}")
  97. public R<TestDemoVo> getInfo(@NotNull(message = "主键不能为空")
  98. @PathVariable("id") Long id) {
  99. return R.ok(iTestDemoService.queryById(id));
  100. }
  101. /**
  102. * 新增测试单表
  103. */
  104. @SaCheckPermission("demo:demo:add")
  105. @Log(title = "测试单表", businessType = BusinessType.INSERT)
  106. @RepeatSubmit(interval = 2, timeUnit = TimeUnit.SECONDS, message = "{repeat.submit.message}")
  107. @PostMapping()
  108. public R<Void> add(@RequestBody TestDemoBo bo) {
  109. // 使用校验工具对标 @Validated(AddGroup.class) 注解
  110. // 用于在非 Controller 的地方校验对象
  111. ValidatorUtils.validate(bo, AddGroup.class);
  112. return toAjax(iTestDemoService.insertByBo(bo) ? 1 : 0);
  113. }
  114. /**
  115. * 修改测试单表
  116. */
  117. @SaCheckPermission("demo:demo:edit")
  118. @Log(title = "测试单表", businessType = BusinessType.UPDATE)
  119. @RepeatSubmit
  120. @PutMapping()
  121. public R<Void> edit(@Validated(EditGroup.class) @RequestBody TestDemoBo bo) {
  122. return toAjax(iTestDemoService.updateByBo(bo) ? 1 : 0);
  123. }
  124. /**
  125. * 删除测试单表
  126. *
  127. * @param ids 测试ID串
  128. */
  129. @SaCheckPermission("demo:demo:remove")
  130. @Log(title = "测试单表", businessType = BusinessType.DELETE)
  131. @DeleteMapping("/{ids}")
  132. public R<Void> remove(@NotEmpty(message = "主键不能为空")
  133. @PathVariable Long[] ids) {
  134. return toAjax(iTestDemoService.deleteWithValidByIds(Arrays.asList(ids), true) ? 1 : 0);
  135. }
  136. }