SaleClueInfoController.java 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. package com.ruixuan.salesLeads.controller;
  2. import com.alibaba.excel.EasyExcel;
  3. import com.ruixuan.common.core.controller.BaseController;
  4. import com.ruixuan.common.core.domain.ResultResponse;
  5. import com.ruixuan.common.utils.DateUtils;
  6. import com.ruixuan.common.utils.file.FileTypeUtils;
  7. import com.ruixuan.salesLeads.listener.ImportExcelListener;
  8. import com.ruixuan.salesLeads.pojo.TestPojo;
  9. import com.ruixuan.salesLeads.service.ISaleClueInfoService;
  10. import com.ruixuan.salesLeads.service.ITestService;
  11. import io.swagger.annotations.Api;
  12. import io.swagger.annotations.ApiOperation;
  13. import io.swagger.annotations.ApiParam;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.web.bind.annotation.*;
  16. import org.springframework.web.multipart.MultipartFile;
  17. import java.io.File;
  18. import java.util.List;
  19. import java.util.Map;
  20. /**
  21. * ***************************************************
  22. *
  23. * @Auther: zianY
  24. * @Descipion: 销售线索
  25. * @CreateDate: 2022-05-19
  26. * ****************************************************
  27. */
  28. @Api(tags = "销售线索",description = "saleClueInfoController")
  29. @RestController
  30. @RequestMapping("sale/saleClueInfoController")
  31. public class SaleClueInfoController extends BaseController {
  32. @Autowired
  33. private ISaleClueInfoService saleClueInfoServiceImpl;
  34. @ApiOperation(value = "导入",notes = "swagger不支持上传,请移步使用postman上传仅支持form-data。")
  35. @PostMapping(value = "/importExcel")
  36. public ResultResponse importExcel(
  37. @ApiParam("文件数组") @RequestParam("files") List<MultipartFile> files,
  38. @ApiParam("销售线索类型1:50W低潜;2:50W中高潜;3:200W高潜;4:200W-500w;5:500W") @RequestParam("salesLeadsType") int salesLeadsType,
  39. @ApiParam("年-月") @RequestParam("uploadDate") String uploadDate,
  40. @ApiParam("创建人") @RequestParam("createUserId") Long createUserId
  41. ) throws Exception{
  42. if (files.isEmpty()){
  43. return ResultResponse.error("文件不能为空,请选择文件!");
  44. }
  45. for (MultipartFile file : files) {
  46. if (!FileTypeUtils.fileNameSuffix(file)){
  47. return ResultResponse.error("请上传正确格式的文件,支持扩展名.xls;.xlsx;.csv");
  48. }
  49. }
  50. Long year = DateUtils.strDateToInt(uploadDate);
  51. return saleClueInfoServiceImpl.importSaleClueExcel(files,salesLeadsType,year,createUserId);
  52. }
  53. }