异步导出(CompletableFuture异步任务+阿里云)

​
//控制层代码
@ApiOperation("技术咨询单-导出")
@RequestMapping(path = "exportDlrTechnicalAdvice",method = RequestMethod.POST)
public EntityResult exportDlrTechnicalAdvice(@RequestBody TechnicalAdviceQueryDTO dto,HttpServletRequest request,HttpServletResponse response) throws IOException, ExecutionException, InterruptedException {
	return technicalAdviceService.exportToOss(dto,request,response);
}

​

//异步导出 给前端返回提示去下载中心查看下载记录,同时异步执行把excel导出 该项目使用的是阿里云,把文件上传到阿里云 ,成功后返回附件路径
    @Override
    public EntityResult exportToOss(TechnicalAdviceQueryDTO dto, HttpServletRequest request, HttpServletResponse response) {
        EntityResult result = new EntityResult<>();
        UserEntity userInfo = ContextHelper.getUserInfo();
        List<String> roleTypes = userInfo.getRoleTypes();
         //构建传参
        Map<String, Object> mapParam = buildQueryParam(dto, userInfo);
        mapParam.put("language", language);
        mapParam.put("language2", language2);
        List<TechnicalAdviceExportVO> list = tsAdvisoryOrderDao.queryTechnicalAdviceForExport(mapParam);
        if (CollectionUtils.isEmpty(list)) {
            //数据为空
            result.setMsg("40000000011");
            result.setResult("0");
            return result;
        }

        //添加记录表
        DownloadCenterRecord record = new DownloadCenterRecord();
        record.setIsDown(0);
        record.setOperType(1); //操作类型
        record.setDownNum(0);
        //record.setStatus(0);
        record.setScenCode(CommonConstant.TS_ORDER_TYPE_1);
        record.setCreatedBy(userInfo.getUserId());
        record.setCreatedOn(new Date());
        //record.setModifiedBy(userInfo.getUserId());
        //record.setModifiedOn(new Date());
        downloadCenterRecordDao.insert(record);

        //异步执行导出
        CompletableFuture.runAsync(()->{
            self.exportDlrTechnicalAdvice2(list,mapParam,record,userInfo,response);
        },AsyncTaskManager.getThreadPoolExecutor()).whenComplete((v,throwable)->{
            if (throwable != null) {
                log.error("exportToOss Exception: ", throwable);
            } else {
                log.info("exportToOss completed successfully.");
            }
        });
        //正在导出中,请到下载中心查看
        result.setMsg("1400000000249");
        result.setRows(record.getId());
        return result;

    @Override
    public void exportDlrTechnicalAdvice2(List<TechnicalAdviceExportVO> list,Map<String, Object> mapParam, DownloadCenterRecord record, UserEntity userInfo, HttpServletResponse response) {
        try {
 //此处省略拼接数据逻辑
 //返回文件上传Oss
            MultipartFile file = ExcelUtils.export2("导出", exportList, col, keys);
            String uuid = RandomUtil.randomString(8);
            String dateStr = DateUtil.format(new Date(), "yyyyMd");
            //自定义名称
            String fileName = "导出.xlsx";
            String directory = "techAdvice";
            String objectName = directory + "/" + dateStr + "-" + uuid + "/" + fileName;
            aliyunOSSService.uploadOssObject(objectName,file.getInputStream());

            record.setOssUrl(objectName);
            record.setOssFileName(fileName);
            record.setStatus(1);
            record.setModifiedBy(userInfo.getUserId());
            record.setModifiedOn(new Date());
            downloadCenterRecordDao.updateById(record);

            log.info("--10000000000100000000000000000000000000000000000000000");
        } catch (Exception e) {
            record.setStatus(0);
            record.setRemark(e.getMessage());
            record.setOssFileName("导出失败");
            downloadCenterRecordDao.updateById(record);
            log.error("exportDlrTechnicalAdvice, {}", e);
            throw new RuntimeException(e);
        }
    }