blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
fei
2025-09-22 0fdd6b6113fe6e120ca5731fbab562f56eca8ae5 
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/archive/archiveAllExportController.java


@@ -12,11 +12,9 @@


import com.ruoyi.common.utils.poi.ExcelUtil;


import com.ruoyi.common.utils.poi.ExcelUtilManySheet;


import com.ruoyi.common.utils.poi.ExcelUtilManySheetSecond;


import com.ruoyi.domain.ArchiveRecords;


import com.ruoyi.domain.DocumentMaterials;


import com.ruoyi.domain.vo.ArchiveInfoVo;


import com.ruoyi.domain.vo.DocumentMaterialsVo;


import com.ruoyi.domain.vo.DocumentMaterialsVoLarge;


import com.ruoyi.domain.vo.DocumentMaterialsVoSmall;


import com.ruoyi.domain.vo.*;


import com.ruoyi.framework.web.domain.server.Sys;


import com.ruoyi.service.IArchiveRecordsService;


import com.ruoyi.service.IDocumentMaterialsService;


@@ -30,6 +28,7 @@


import org.apache.poi.xssf.usermodel.*;


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


import org.springframework.http.MediaType;


import org.springframework.web.bind.annotation.PathVariable;


import org.springframework.web.bind.annotation.PostMapping;


import org.springframework.web.bind.annotation.RequestMapping;


import org.springframework.web.bind.annotation.RestController;


@@ -43,6 +42,8 @@


import java.nio.file.Path;


import java.nio.file.Paths;


import java.text.SimpleDateFormat;


import java.time.LocalDate;


import java.time.format.DateTimeFormatter;


import java.util.*;


import java.util.List;


import java.util.stream.Collectors;


@@ -121,7 +122,278 @@








    @PostMapping("/exportChooseArchive/{ids}")


    public void exportChooseArchive(HttpServletResponse response,  @PathVariable Long[] ids)throws Exception


    {


        System.out.println("092939932");


        String zipFileName ="test" +".zip";


        //生成压缩包存储地址（最后会删掉）


        String fileZip = RuoYiConfig.getProfile() + "/download/" + zipFileName;


        OutputStream os=null;


        ZipOutputStream zos = null ;


        System.out.println("==============_______________");


        System.out.println(ids.length);


        File file = new File(fileZip);


        try {


            if (!file.getParentFile().exists()) {


                file.getParentFile().mkdirs();


            }


            os = new FileOutputStream(file);


            //压缩文件


            zos = new ZipOutputStream(os);


            //拿到当前的时间


            LocalDate date = LocalDate.now();


            System.out.println("当前日期: " + date);






            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd");


            String formattedDate = date.format(formatter);


            System.out.println(formattedDate);


            String fna = "GH"+20250908+"/";


            zos.putNextEntry(new ZipEntry(fna));






            //添加ids的全部数据到excel


            ArchiveRecords archiveRecords = new ArchiveRecords();


            archiveRecords.setIds(ids);


            List<ArchiveRecords> lis = iArchiveRecordsService.selectArchiveRecordsList(archiveRecords);


            //案卷目录导出


            ZipEntry entry = new ZipEntry("案卷目录" + ".xls");


            ExcelUtil<ArchiveRecords> util = new ExcelUtil<ArchiveRecords>(ArchiveRecords.class);




            zos.putNextEntry(entry);


            ByteOutputStream bos = new ByteOutputStream();


            util.byteOutputStreamExcel(bos, lis,"案卷目录", "");


            bos.writeTo(zos);




            //移交清单


            List<ArchiveRecordSmall> lrs = iArchiveRecordsService.findByIds(archiveRecords);


            System.out.println(lrs);


            ZipEntry entry1 = new ZipEntry("移交清单" + ".xls");


            ExcelUtil<ArchiveRecordSmall> util1 = new ExcelUtil<ArchiveRecordSmall>(ArchiveRecordSmall.class);




            zos.putNextEntry(entry1);


            ByteOutputStream bos1 = new ByteOutputStream();


            util1.byteOutputStreamExcel(bos1, lrs,"移交清单", "");


            bos1.writeTo(zos);


            for(int i = 0; i < ids.length; i++) {




                // 获取文件的保存位置,读取数据库,


                DocumentMaterials documentMaterials = new DocumentMaterials();


                documentMaterials.setRecordId(ids[i]);


                List<DocumentMaterialsVoLarge> docs = documentMaterialsService.selectDocumentMaterialsAllByRecordId(ids[i]);


                System.out.println(docs.size()+"----009");






                //.selectDocumentMaterialsList(documentMaterials);


                List<DocumentMaterialsVo> dsvs = documentMaterialsService.findArchMInfo(ids[i].toString());


                ArchiveInfoVo aIV = iArchiveRecordsService.selectByRecordId(ids[i]);




                String adir = aIV.getInquiryNumber() + " " + aIV.getRecordId();


                System.out.println(fna+adir);


                zos.putNextEntry(new ZipEntry(fna + adir + "/"));




                //在里面添加文件


                boolean res = true;


                if(res) {


                    zos.putNextEntry(new ZipEntry(fna + adir + "/01-申请材料/"));


                    zos.putNextEntry(new ZipEntry(fna + adir + "/02-办案过程材料/"));


                    zos.putNextEntry(new ZipEntry(fna + adir + "/03-结论性文件/"));


                    zos.putNextEntry(new ZipEntry(fna + adir + "/04-其他材料/"));


                    zos.putNextEntry(new ZipEntry(fna + adir + "/05-档案变更材料/"));


                    zos.putNextEntry(new ZipEntry(fna + adir + "/06-业务数据/"));


                    res = false;


                }


                //添加07  的pdf


                //pdf目录封面


                String pdfPathF = "07-案卷封面.pdf";


                pdfGenerateService.generatePdf(pdfPathF, ids[i]);


                // 2. 压缩PDF到ZIP文件


                // 添加PDF文件到ZIP


                ZipEntry zipEntry2 = new ZipEntry(fna + adir +"/"+pdfPathF);


                zos.putNextEntry(zipEntry2);




                // 读取PDF文件内容并写入ZIP


                try (FileInputStream fis = new FileInputStream(pdfPathF)) {


                    byte[] buffer = new byte[1024];


                    int len;


                    while ((len = fis.read(buffer)) > 0) {


                        zos.write(buffer, 0, len);


                    }


                }




                //08-卷内卷内目录的pdf


                String pdf08Path= "08-卷内目录.pdf";


                List<DocumentMaterialsVo> list3 = dsvs;


                if(list3.size()>0) {


                    pdfGenerateService.generateFileDirectoryPdf(pdf08Path, list3);


                    ZipEntry zipEntry3 = new ZipEntry(fna + adir +"/"+pdf08Path);


                    zos.putNextEntry(zipEntry3);




                    // 读取PDF文件内容并写入ZIP


                    try (FileInputStream fis = new FileInputStream(pdf08Path)) {


                        byte[] buffer = new byte[1024];


                        int len;


                        while ((len = fis.read(buffer)) > 0) {


                            zos.write(buffer, 0, len);


                        }


                    }


                }


                //09-备考表.pdf


                String pdf09Path = "09-备考表.pdf";


                pdfGenerateService.generateFileStyleInfo(pdf09Path, aIV.getRecordId(), ids[i]);


                // 2. 压缩PDF到ZIP文件


                // 添加PDF文件到ZIP


                ZipEntry zipEntry4 = new ZipEntry(fna + adir +"/"+pdf09Path);


                zos.putNextEntry(zipEntry4);




                // 读取PDF文件内容并写入ZIP


                try (FileInputStream fis = new FileInputStream(pdf09Path)) {


                    byte[] buffer = new byte[1024];


                    int len;


                    while ((len = fis.read(buffer)) > 0) {


                        zos.write(buffer, 0, len);


                    }


                }




                //excel 卷内封面导出zip


                ZipEntry entryiv = new ZipEntry(fna + adir +"/"+"案卷封面" + ".xls");




                List<ArchiveInfoVo> arsi = new ArrayList<>();


                arsi.add(aIV);




                String recordId1 = aIV.getRecordId();


                byte[] imgr1 = barcodeService.generateBarcodeImage(recordId1);


                byte[] sedcode = pdfGenerateService.createQrCodeN(recordId1, 30, 30);


                ExcelExp e3 = new ExcelExp("案卷封面数据",arsi, ArchiveInfoVo.class);


                ExcelExp e4 = new ExcelExp("案卷封面",  arsi, recordId1, imgr1,sedcode, ArchiveInfoVo.class);


                List<ExcelExp> mysheet1 = new ArrayList<ExcelExp>();


                mysheet1.add(e3);


                mysheet1.add(e4);


                ByteOutputStream bos2 = new ByteOutputStream();


                ExcelUtilManySheetSecond<List<ExcelExp>> util3 = new ExcelUtilManySheetSecond<List<ExcelExp>>(mysheet1);




                util3.exportExcelManySheet(bos2, mysheet1);




                //  System.out.println(bos2);


                zos.putNextEntry(entryiv);




//            ExcelUtil<ArchiveInfoVo> utilsv = new ExcelUtil<ArchiveInfoVo>(ArchiveInfoVo.class);


//


//


//            ByteOutputStream boss = new ByteOutputStream();


//            List<ArchiveInfoVo> aivs = new ArrayList<>();


//            aivs.add(aIV);


//            utilsv.byteOutputStreamExcel(boss, aivs,"Date List", "");


                bos2.writeTo(zos);








                //写入电子目录  xsxl




                ZipEntry entry5 = new ZipEntry(fna + adir +"/"+"电子文件目录" + ".xls");


                ExcelUtil<DocumentMaterialsVoLarge> util5 = new ExcelUtil<DocumentMaterialsVoLarge>(DocumentMaterialsVoLarge.class);




                zos.putNextEntry(entry5);


                ByteOutputStream bos5 = new ByteOutputStream();


                util5.byteOutputStreamExcel(bos5, docs,"电子文件目录", "");


                bos.writeTo(zos);




                //拿到卷内目录的excel


                List<DocumentMaterialsVoSmall> list2 = dsvs.stream().map(res1 -> new DocumentMaterialsVoSmall(res1.getNum(), res1.getDocumentNumber(),res1.getCreator(),


                        res1.getTitle(), res1.getDate(), res1.getPageNumber(), res1.getRemarks())).collect(Collectors.toList());


                if(!dsvs.isEmpty()) {


                    String recordId = dsvs.get(0).getRecordId();


                    byte[] imgr = barcodeService.generateBarcodeImage(recordId);


                    ExcelExp e1 = new ExcelExp("卷内目录数据", dsvs, DocumentMaterialsVo.class);


                    ExcelExp e2 = new ExcelExp("卷内数据", list2, recordId, imgr, DocumentMaterialsVoSmall.class);


                    List<ExcelExp> mysheet = new ArrayList<ExcelExp>();


                    mysheet.add(e1);


                    mysheet.add(e2);


                    ExcelUtilManySheet<List<ExcelExp>> util2 = new ExcelUtilManySheet<List<ExcelExp>>(mysheet);


                    ZipEntry entr = new ZipEntry(fna + adir + "/" + "卷内目录" + ".xls");


                    // ExcelUtil<DocumentMaterialsVo> util1 = new ExcelUtil<DocumentMaterialsVo>(DocumentMaterialsVo.class);


                    System.out.println(dsvs);


                    zos.putNextEntry(entr);


                    ByteOutputStream bos6 = new ByteOutputStream();




                    util2.exportExcelManySheet(bos6, mysheet);




                    //   util1.byteOutputStreamExcel(bos1, dsvs,"Date List", "");


                    bos6.writeTo(zos);


                }


                //把excel转为pdf








                byte[] buf = new byte[1024];


                for (DocumentMaterialsVoLarge dc : docs) {


                    String filePath = dc.getUrl();


                    if(filePath==null)


                        continue;


                    filePath = filePath.replace("/profile/", RuoYiConfig.getProfile() + "/");




                    System.out.println(filePath);


                    File tempFile = new File(filePath);




                    //在压缩包中添加文件夹




                    //得到文件名frontCompWithZore(4, dc.get)+


                    String fname = frontCompWithZore(4, dc.getFileNumber().intValue())+"-"+dc.getTitle()+"-"+frontCompWithZore(4,dc.getPageNumber().intValue())+"."


                            +dc.getUrl().split("\\.")[1];


                    if(dc.getStage().equals("01-申请材料"))


                        zos.putNextEntry(new ZipEntry(fna + adir + "/01-申请材料/"+fname));


                    else if(dc.getStage().equals("02-办案过程材料"))


                        zos.putNextEntry(new ZipEntry(fna + adir + "/02-办案过程材料/"+fname));


                    else if(dc.getStage().equals("03-结论性文件"))


                        zos.putNextEntry(new ZipEntry(fna + adir + "/03-结论性文件/"+fname));


                    else if(dc.getStage().equals("04-其他材料")) {


                        zos.putNextEntry(new ZipEntry(fna + adir + "/04-其他材料/" + fname));


                    }


                    else if(dc.getStage().equals("05-档案变更材料"))


                        zos.putNextEntry(new ZipEntry(fna + adir + "/05-档案变更材料/"+fname));


                    else if(dc.getStage().equals("06-业务数据"))


                        zos.putNextEntry(new ZipEntry(fna + adir + "/06-业务数据/"+fname));


                    else


                        zos.putNextEntry(new ZipEntry(fna + adir + "/"+fname));








                    int len;


                    FileInputStream in = new FileInputStream(tempFile);


                    while ((len = in.read(buf)) != -1){


                        zos.write(buf, 0, len);


                    }


                    //  zos.putNextEntry(new ZipEntry("04-其他材料"));


                    zos.closeEntry();


                    in.close();


                }


            }


            System.out.println(file.getName());


            writeFileToRes(response, file.getName(), file);




        } catch (Exception e) {


            throw new RuntimeException(e);


        }finally {


            //关闭流


            if(zos != null){


                try {


                    zos.close();


                } catch (IOException e) {


                    e.printStackTrace();


                }


            }


            //关闭流


            if(os!= null){


                try {


                    os.close();


                } catch (IOException e) {


                    e.printStackTrace();


                }


            }


        }




    }








@@ -133,9 +405,9 @@


     * @param response


     * @param


     */


    @PostMapping("/export")


    @PostMapping("/export/{id}")




    public void packDownload(HttpServletResponse response, Long id) throws Exception {


    public void packDownload(HttpServletResponse response,  @PathVariable Long id) throws Exception {


        // 获取文件的保存位置,读取数据库,


        DocumentMaterials documentMaterials = new DocumentMaterials();


        documentMaterials.setRecordId(id);


@@ -170,6 +442,7 @@


            System.out.println(file.getName());




            String fileName =aIV.getRecordId()+".zip";




            //输出文件流


            writeFileToRes(response, file.getName(), file);


            //删除压缩包


@@ -252,8 +525,8 @@


            zos = new ZipOutputStream(os);




            //pdf目录封面


            String pdfPathF = "07-卷面封面.pdf";


            pdfGenerateService.generatePdf(pdfPathF);


            String pdfPathF = "07-案卷封面.pdf";


            pdfGenerateService.generatePdf(pdfPathF, 55L);


            // 2. 压缩PDF到ZIP文件


                // 添加PDF文件到ZIP


                ZipEntry zipEntry = new ZipEntry(pdfPathF);


@@ -303,7 +576,7 @@






                //excel 卷内封面导出zip


            ZipEntry entryiv = new ZipEntry("卷内封面" + ".xls");


            ZipEntry entryiv = new ZipEntry("案卷封面" + ".xls");




            List<ArchiveInfoVo> arsi = new ArrayList<>();


            arsi.add(aIV);


@@ -374,6 +647,8 @@


            byte[] buf = new byte[1024];


            for (DocumentMaterialsVoLarge dc : docs) {


                String filePath = dc.getUrl();


                if(filePath==null)


                    continue;


                filePath = filePath.replace("/profile/", RuoYiConfig.getProfile() + "/");




                System.out.println(filePath);