BaseProfessionalController.java 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  1. package com.ozs.web.controller.base;
  2. import com.ozs.base.domain.BaseProfessional;
  3. import com.ozs.base.domain.vo.BaseProfessionalVo;
  4. import com.ozs.base.service.BaseProfessionalService;
  5. import com.ozs.common.config.PurchaseConfig;
  6. import com.ozs.common.core.controller.BaseController;
  7. import com.ozs.common.core.domain.AjaxResult;
  8. import com.ozs.common.core.domain.R;
  9. import com.ozs.common.core.domain.model.LoginUser;
  10. import com.ozs.common.exception.ServiceException;
  11. import com.ozs.common.utils.StringUtils;
  12. import com.ozs.common.utils.file.FileUtils;
  13. import com.ozs.common.utils.poi.ExcelUtil;
  14. import com.ozs.plan.doman.ProvisionalPlan;
  15. import com.ozs.plan.doman.vo.requestVo.ProvisionalPlanVo;
  16. import io.swagger.annotations.Api;
  17. import io.swagger.annotations.ApiOperation;
  18. import lombok.extern.slf4j.Slf4j;
  19. import org.apache.commons.lang3.exception.ExceptionUtils;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.http.MediaType;
  22. import org.springframework.web.bind.annotation.*;
  23. import org.springframework.web.multipart.MultipartFile;
  24. import javax.servlet.ServletOutputStream;
  25. import javax.servlet.http.HttpServletRequest;
  26. import javax.servlet.http.HttpServletResponse;
  27. import java.io.FileInputStream;
  28. import java.io.InputStream;
  29. import java.net.URLDecoder;
  30. import java.net.URLEncoder;
  31. import java.util.List;
  32. /**
  33. * 专业库管理
  34. *
  35. * @author sunhh
  36. */
  37. @Api(tags = "专业库管理")
  38. @RestController
  39. @RequestMapping("/base/professional")
  40. @Slf4j
  41. public class BaseProfessionalController extends BaseController {
  42. @Autowired
  43. private BaseProfessionalService baseProfessionalService;
  44. @ApiOperation(value = "新增专业库" , notes = "必传 专业库名称、一级分类、编码、父级编码;没有父级编码传0")
  45. @PostMapping("/insertProfessional")
  46. public AjaxResult insertProfessional(@RequestBody BaseProfessional baseProfessional) {
  47. if (StringUtils.isNull(baseProfessional)
  48. || StringUtils.isNull(baseProfessional.getProfessionalName())
  49. || StringUtils.isNull(baseProfessional.getProfessionalCode())
  50. || StringUtils.isNull(baseProfessional.getProfessionalGrade())
  51. || StringUtils.isNull(baseProfessional.getParentCode())) {
  52. return error("专业库名称、编码、一级分类、父级ID 不能为空");
  53. }
  54. return toAjax(baseProfessionalService.save(baseProfessional));
  55. }
  56. @ApiOperation(value = "删除专业库" , notes = "必传 id")
  57. @PostMapping("/deleteProfessional")
  58. public AjaxResult deleteProfessional(@RequestBody BaseProfessional baseProfessional) {
  59. if (StringUtils.isNull(baseProfessional) || StringUtils.isNull(baseProfessional.getId())) {
  60. return error("专业库id不能为空");
  61. }
  62. return toAjax(baseProfessionalService.removeById(baseProfessional.getId()));
  63. }
  64. @ApiOperation(value = "批量删除专业库" , notes = "必传 idList")
  65. @PostMapping("/deleteIds")
  66. public AjaxResult deleteByIdLIst(@RequestBody BaseProfessionalVo baseProfessionalVo) {
  67. baseProfessionalService.deleteIds(baseProfessionalVo.getDeleteIds());
  68. return success();
  69. }
  70. @ApiOperation(value = "修改专业库" , notes = "必传 id 及修改数据")
  71. @PostMapping("/updateProfessional")
  72. public AjaxResult updateProfessional(@RequestBody BaseProfessional baseProfessional) {
  73. if (StringUtils.isNull(baseProfessional) || StringUtils.isNull(baseProfessional.getId())) {
  74. return error("专业库id和修改数据不能为空");
  75. }
  76. return toAjax(baseProfessionalService.updateById(baseProfessional));
  77. }
  78. @ApiOperation(value = "查询专业库树结构" , notes = "非必传 查询条件:品目名称")
  79. @PostMapping("/selectBaseProfessional")
  80. public AjaxResult selectBaseProfessional(@RequestBody BaseProfessionalVo baseProfessionalVo) {
  81. List<BaseProfessionalVo> baseSupplierList = baseProfessionalService.selectBaseProfessionalVo(baseProfessionalVo);
  82. return success(baseSupplierList);
  83. }
  84. @ApiOperation(value = "导入专业库" , notes = "导入表格")
  85. @PostMapping("/importBaseProfessional")
  86. public AjaxResult importBaseProfessional(MultipartFile file, boolean updateSupport) throws Exception {
  87. ExcelUtil<BaseProfessional> util = new ExcelUtil<>(BaseProfessional.class);
  88. List<BaseProfessional> baseProfessionalList = util.importExcel(file.getInputStream());
  89. if (StringUtils.isNull(baseProfessionalList) || baseProfessionalList.size() == 0) {
  90. throw new ServiceException("导入专业库数据不能为空!");
  91. }
  92. // String operName = getUsername();
  93. String message = baseProfessionalService.importBaseProfessional(baseProfessionalList, updateSupport);
  94. return success(message);
  95. }
  96. @ApiOperation("导出专业库")
  97. @PostMapping("/exportBaseProfessional")
  98. public void exportBaseProfessional(HttpServletResponse response, @RequestBody BaseProfessionalVo baseProfessionalVo) {
  99. List<BaseProfessional> list = baseProfessionalService.selectBaseProfessional(baseProfessionalVo);
  100. ExcelUtil<BaseProfessional> util = new ExcelUtil<>(BaseProfessional.class);
  101. util.exportExcel(response, list, "专业库数据");
  102. }
  103. @ApiOperation("文件下载")
  104. @GetMapping("/downloaExcel")
  105. public void downloadZip(HttpServletRequest request, HttpServletResponse response) {
  106. try {
  107. // 文件路径
  108. // String downloadPath = this.getClass().getResource("/template/professional.xlsx").getPath();
  109. InputStream resourceAsStream = this.getClass().getResourceAsStream("/template/professional.xlsx");
  110. response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
  111. FileUtils.setAttachmentResponseHeader(response, "专业库模板.xlsx");
  112. FileUtils.writeBytesByInput(resourceAsStream, response.getOutputStream());
  113. } catch (Exception e) {
  114. log.error("下载文件失败" , e);
  115. }
  116. }
  117. }