TestDemoController.java 5.3 KB

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