IsMaterialsController.java 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180
  1. package com.ktg.iscs.controller;
  2. import cn.hutool.core.lang.Assert;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.fasterxml.jackson.core.JsonProcessingException;
  5. import com.ktg.common.annotation.Log;
  6. import com.ktg.common.core.controller.BaseController;
  7. import com.ktg.common.core.domain.AjaxResult;
  8. import com.ktg.common.enums.BusinessType;
  9. import com.ktg.common.pojo.CommonResult;
  10. import com.ktg.common.utils.poi.ExcelUtil;
  11. import com.ktg.iscs.domain.IsMaterials;
  12. import com.ktg.iscs.domain.dto.hardwareApi.LoanParamDTO;
  13. import com.ktg.iscs.domain.dto.materials.MaterialBindingDTO;
  14. import com.ktg.iscs.domain.dto.materials.MaterialsPageDTO;
  15. import com.ktg.iscs.domain.vo.materials.ImportMaterialsVO;
  16. import com.ktg.iscs.domain.vo.materials.MaterialsPageVO;
  17. import com.ktg.iscs.service.IIsMaterialsService;
  18. import io.swagger.annotations.Api;
  19. import io.swagger.annotations.ApiOperation;
  20. import io.swagger.v3.oas.annotations.Parameter;
  21. import io.swagger.v3.oas.annotations.Parameters;
  22. import org.apache.commons.io.FilenameUtils;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.security.access.prepost.PreAuthorize;
  25. import org.springframework.web.bind.annotation.*;
  26. import org.springframework.web.multipart.MultipartFile;
  27. import javax.servlet.http.HttpServletResponse;
  28. import java.util.ArrayList;
  29. import java.util.Date;
  30. import java.util.List;
  31. /**
  32. * 物资Controller
  33. *
  34. * @author cgj
  35. * @date 2024-11-08
  36. */
  37. @Api(tags = "物资")
  38. @RestController
  39. @RequestMapping("/iscs/materials")
  40. public class IsMaterialsController extends BaseController {
  41. @Autowired
  42. private IIsMaterialsService isMaterialsService;
  43. /**
  44. * 查询物资分页
  45. */
  46. @ApiOperation("查询物资-分页")
  47. @Parameters({
  48. @Parameter(name = "page", description = "Page"),
  49. @Parameter(name = "dto", description = "实体参数")
  50. })
  51. @PreAuthorize("@ss.hasPermi('iscs:materials:list')")
  52. @GetMapping("/getIsMaterialsPage")
  53. public CommonResult<Page<MaterialsPageVO>> getIsMaterialsPage(Page<IsMaterials> page, MaterialsPageDTO dto) throws JsonProcessingException {
  54. Page<MaterialsPageVO> result = isMaterialsService.getIsMaterialsPage(page, dto);
  55. return CommonResult.success(result);
  56. }
  57. @ApiOperation("查询异常还错柜子的物资")
  58. @Parameters({
  59. @Parameter(name = "dto", description = "实体参数")
  60. })
  61. @PreAuthorize("@ss.hasPermi('iscs:materials:list')")
  62. @GetMapping("/getExMaterials")
  63. public CommonResult<List<MaterialsPageVO>> getExMaterials(MaterialsPageDTO dto) {
  64. List<MaterialsPageVO> result = isMaterialsService.getExMaterials(dto);
  65. return CommonResult.success(result);
  66. }
  67. /**
  68. * 导出物资列表
  69. */
  70. @ApiOperation("导出物资列表")
  71. @Parameter(name = "isMaterials", description = "实体参数")
  72. @PreAuthorize("@ss.hasPermi('iscs:materials:export')")
  73. @Log(title = "物资", businessType = BusinessType.EXPORT)
  74. @PostMapping("/exportIsMaterials")
  75. public void exportIsMaterials(HttpServletResponse response, IsMaterials isMaterials) {
  76. List<IsMaterials> list = isMaterialsService.selectIsMaterialsList(isMaterials);
  77. ExcelUtil<IsMaterials> util = new ExcelUtil<IsMaterials>(IsMaterials.class);
  78. util.exportExcel(response, list, "物资数据");
  79. }
  80. /**
  81. * 获取物资详细信息
  82. */
  83. @ApiOperation("获取物资详细信息")
  84. @Parameter(name = "materialsId", description = "materialsId")
  85. @PreAuthorize("@ss.hasPermi('iscs:materials:query')")
  86. @GetMapping(value = "/selectIsMaterialsById")
  87. public CommonResult<IsMaterials> selectIsMaterialsById(Long materialsId) {
  88. return CommonResult.success(isMaterialsService.selectIsMaterialsByMaterialsId(materialsId));
  89. }
  90. /**
  91. * 新增物资
  92. */
  93. @ApiOperation("新增物资")
  94. @PreAuthorize("@ss.hasPermi('iscs:materials:add')")
  95. @Log(title = "物资", businessType = BusinessType.INSERT)
  96. @PostMapping("/insertIsMaterials")
  97. public CommonResult<Boolean> insertIsMaterials(@RequestBody @Parameter(name = "isMaterials", description = "新增数据类,放到body") IsMaterials isMaterials) {
  98. return CommonResult.success(isMaterialsService.insertIsMaterials(isMaterials) == 1);
  99. }
  100. /**
  101. * 修改物资
  102. */
  103. @ApiOperation("修改物资")
  104. @PreAuthorize("@ss.hasPermi('iscs:materials:edit')")
  105. @Log(title = "物资", businessType = BusinessType.UPDATE)
  106. @PostMapping("/updateIsMaterials")
  107. public CommonResult<Boolean> updateIsMaterials(@RequestBody @Parameter(name = "isMaterials", description = "修改数据类,放到body") IsMaterials isMaterials) {
  108. return CommonResult.success(isMaterialsService.updateIsMaterials(isMaterials) == 1);
  109. }
  110. @ApiOperation("借出/归还物资")
  111. @PreAuthorize("@ss.hasPermi('iscs:materials:loan')")
  112. @Log(title = "借出/归还物资", businessType = BusinessType.UPDATE)
  113. @PostMapping("/updateIsMaterialById")
  114. public CommonResult<Boolean> updateIsMaterialById(@RequestBody @Parameter(name = "dto", description = "修改数据类,放到body") LoanParamDTO dto) {
  115. return CommonResult.success(isMaterialsService.updateIsMaterialById(dto));
  116. }
  117. /**
  118. * 删除物资
  119. */
  120. @ApiOperation("删除物资")
  121. @PreAuthorize("@ss.hasPermi('iscs:materials:remove')")
  122. @Log(title = "物资", businessType = BusinessType.DELETE)
  123. @PostMapping("/deleteIsMaterialsByMaterialsIds")
  124. public CommonResult<Boolean> deleteIsMaterialsByMaterialsIds(String materialsIds) {
  125. return CommonResult.success(isMaterialsService.deleteIsMaterialsByMaterialsIds(materialsIds) != 0);
  126. }
  127. @ApiOperation("导入模板-物资")
  128. @Log(title = "导入模板-物资")
  129. @PostMapping("/importTemplate")
  130. public void importTemplate(HttpServletResponse response) {
  131. ExcelUtil<ImportMaterialsVO> util = new ExcelUtil<>(ImportMaterialsVO.class);
  132. ImportMaterialsVO importMaterialsVO = new ImportMaterialsVO();
  133. importMaterialsVO.setCabinetName("一号物资柜");
  134. importMaterialsVO.setMaterialsName("实验室白大褂K380");
  135. importMaterialsVO.setMaterialsTypeName("白大褂");
  136. importMaterialsVO.setValueName("s");
  137. importMaterialsVO.setMaterialsRfid("7418965826");
  138. importMaterialsVO.setSupplier("零号实验室");
  139. importMaterialsVO.setExpirationDate(new Date());
  140. ArrayList<ImportMaterialsVO> importMaterialsVOS = new ArrayList<>();
  141. importMaterialsVOS.add(importMaterialsVO);
  142. util.importTempExcelWithDate(response, "物资数据", importMaterialsVOS);
  143. }
  144. @ApiOperation("导入-物资")
  145. @Log(title = "导入-物资", businessType = BusinessType.IMPORT)
  146. @PreAuthorize("@ss.hasPermi('iscs:materials:import')")
  147. @PostMapping("/importMaterials")
  148. public AjaxResult importMaterials(MultipartFile file, boolean updateSupport) throws Exception {
  149. String filename = file.getOriginalFilename();
  150. String extension = FilenameUtils.getExtension(filename);
  151. // 文件不是 .xlsx 或 .xls
  152. Assert.isFalse(!"xls".equalsIgnoreCase(extension) && !"xlsx".equalsIgnoreCase(extension), "文件不是xls或xlsx,请重新上传!");
  153. ExcelUtil<ImportMaterialsVO> util = new ExcelUtil<>(ImportMaterialsVO.class);
  154. List<ImportMaterialsVO> itemList = util.importExcel(file.getInputStream());
  155. String operName = getUsername();
  156. String message = isMaterialsService.importMaterials(itemList, updateSupport, operName);
  157. return AjaxResult.success(message);
  158. }
  159. @ApiOperation("绑定物资-物资柜绑定物资")
  160. @PreAuthorize("@ss.hasPermi('iscs:materials:binding')")
  161. @Log(title = "物资", businessType = BusinessType.UPDATE)
  162. @PostMapping("/updateMaterialsBinding")
  163. public CommonResult<Boolean> updateMaterialsBinding(@RequestBody @Parameter(name = "dto", description = "修改数据类,放到body") MaterialBindingDTO dto) {
  164. return CommonResult.success(isMaterialsService.updateMaterialsBinding(dto));
  165. }
  166. }