123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 |
- package com.ruixuan.salesLeads.controller;
- import com.alibaba.excel.EasyExcel;
- import com.ruixuan.common.core.controller.BaseController;
- import com.ruixuan.common.core.domain.ResultResponse;
- import com.ruixuan.common.utils.DateUtils;
- import com.ruixuan.common.utils.file.FileTypeUtils;
- import com.ruixuan.salesLeads.listener.ImportExcelListener;
- import com.ruixuan.salesLeads.pojo.TestPojo;
- import com.ruixuan.salesLeads.service.ISaleClueInfoService;
- import com.ruixuan.salesLeads.service.ITestService;
- import io.swagger.annotations.Api;
- import io.swagger.annotations.ApiOperation;
- import io.swagger.annotations.ApiParam;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.web.bind.annotation.*;
- import org.springframework.web.multipart.MultipartFile;
- import java.io.File;
- import java.util.List;
- import java.util.Map;
- /**
- * ***************************************************
- *
- * @Auther: zianY
- * @Descipion: 销售线索
- * @CreateDate: 2022-05-19
- * ****************************************************
- */
- @Api(tags = "销售线索",description = "saleClueInfoController")
- @RestController
- @RequestMapping("sale/saleClueInfoController")
- public class SaleClueInfoController extends BaseController {
- @Autowired
- private ISaleClueInfoService saleClueInfoServiceImpl;
- @ApiOperation(value = "导入",notes = "swagger不支持上传,请移步使用postman上传仅支持form-data。")
- @PostMapping(value = "/importExcel")
- public ResultResponse importExcel(
- @ApiParam("文件数组") @RequestParam("files") List<MultipartFile> files,
- @ApiParam("销售线索类型1:50W低潜;2:50W中高潜;3:200W高潜;4:200W-500w;5:500W") @RequestParam("salesLeadsType") int salesLeadsType,
- @ApiParam("年-月") @RequestParam("uploadDate") String uploadDate,
- @ApiParam("创建人") @RequestParam("createUserId") Long createUserId
- ) throws Exception{
- if (files.isEmpty()){
- return ResultResponse.error("文件不能为空,请选择文件!");
- }
- for (MultipartFile file : files) {
- if (!FileTypeUtils.fileNameSuffix(file)){
- return ResultResponse.error("请上传正确格式的文件,支持扩展名.xls;.xlsx;.csv");
- }
- }
- Long year = DateUtils.strDateToInt(uploadDate);
- return saleClueInfoServiceImpl.importSaleClueExcel(files,salesLeadsType,year,createUserId);
- }
- }
|