青羊经侦大队-数据平台
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
wl
2022-07-21 48e1a3658117ebda9270d87092cfb0d31a634b92 
 src/main/java/com/example/jz/service/impl/ReportServiceImpl.java


@@ -3,31 +3,21 @@


import com.alibaba.excel.EasyExcel;


import com.alibaba.excel.metadata.data.ImageData;


import com.alibaba.excel.metadata.data.WriteCellData;


import com.alibaba.excel.support.ExcelTypeEnum;


import com.alibaba.excel.util.IoUtils;


import com.alibaba.excel.util.StringUtils;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.example.jz.dao.GroupDao;


import com.example.jz.dao.GroupUserDao;


import com.example.jz.dao.ReportDao;


import com.example.jz.dao.UserDao;


import com.example.jz.dao.*;


import com.example.jz.modle.dto.AddReportDto;


import com.example.jz.modle.dto.ReportParamDto;


import com.example.jz.modle.entity.Group;


import com.example.jz.modle.entity.GroupUser;


import com.example.jz.modle.entity.Report;


import com.example.jz.modle.entity.User;


import com.example.jz.modle.vo.ReportListVo;


import com.example.jz.dao.*;


import com.example.jz.modle.entity.*;


import com.example.jz.modle.vo.ExportExcelReportVo;


import com.example.jz.modle.vo.ReportListVo;


import com.example.jz.service.MinIOService;


import com.example.jz.service.ReportService;


import lombok.SneakyThrows;


import org.springframework.beans.BeanUtils;


import org.springframework.beans.BeanUtils;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;


@@ -35,13 +25,12 @@




import javax.annotation.Resource;


import javax.servlet.http.HttpServletResponse;


import java.io.Serializable;


import java.net.URL;


import java.net.URLEncoder;


import java.nio.charset.StandardCharsets;


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.ArrayList;


import java.io.Serializable;


import java.util.Date;


import java.util.List;




@@ -144,9 +133,9 @@


                }


        );


        String name = causeDao.selectOne(new QueryWrapper<Cause>().eq("id", id)).getName();


        response.setHeader("Content-disposition", "attachment;filename="+ LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))+URLEncoder.encode(name+".xlsx","utf-8"));


        response.setCharacterEncoding("utf-8");


        response.setContentType("application/vnd.ms-excel");


        response.setCharacterEncoding("utf-8");


        response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode(name + ".xlsx", "utf-8"));


        EasyExcel.write(response.getOutputStream(), ExportExcelReportVo.class).sheet("材料导出").doWrite(exportExcelReportVos);


    }




@@ -191,4 +180,3 @@


        return reportDao.insert(report) > 0;


    }


}