package com.ruoyi.web.controller.archive;
|
|
import com.itextpdf.text.*;
|
import com.itextpdf.text.Font;
|
import com.itextpdf.text.pdf.BaseFont;
|
import com.itextpdf.text.pdf.PdfPCell;
|
import com.itextpdf.text.pdf.PdfPTable;
|
import com.itextpdf.text.pdf.PdfWriter;
|
import com.ruoyi.common.config.RuoYiConfig;
|
import com.ruoyi.common.utils.file.FileUtils;
|
import com.ruoyi.common.utils.poi.ExcelExp;
|
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.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.framework.web.domain.server.Sys;
|
import com.ruoyi.service.IArchiveRecordsService;
|
import com.ruoyi.service.IDocumentMaterialsService;
|
import com.ruoyi.service.impl.BarcodeService;
|
import com.ruoyi.service.impl.pdfGenerateService;
|
import com.sun.xml.internal.messaging.saaj.util.ByteOutputStream;
|
import org.apache.poi.hssf.usermodel.HSSFCell;
|
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
|
import org.apache.poi.ss.usermodel.*;
|
import org.apache.poi.ss.util.CellUtil;
|
import org.apache.poi.xssf.usermodel.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.http.MediaType;
|
import org.springframework.web.bind.annotation.PostMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.*;
|
import java.lang.reflect.Field;
|
import java.net.URLEncoder;
|
import java.nio.file.Files;
|
import java.nio.file.Path;
|
import java.nio.file.Paths;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
import java.util.List;
|
import java.util.stream.Collectors;
|
import java.util.zip.ZipEntry;
|
import java.util.zip.ZipFile;
|
import java.util.zip.ZipInputStream;
|
import java.util.zip.ZipOutputStream;
|
|
import static org.apache.poi.hssf.usermodel.HSSFCell.*;
|
|
@RestController
|
@RequestMapping("/system/archiveAllExport")
|
public class archiveAllExportController {
|
|
@Autowired
|
private pdfGenerateService pdfGenerateService;
|
@Autowired
|
private BarcodeService barcodeService;
|
@Autowired
|
private IDocumentMaterialsService documentMaterialsService;
|
|
@Autowired
|
private IArchiveRecordsService iArchiveRecordsService;
|
|
|
|
|
|
@PostMapping("/importTemplate")
|
public void importTemplate(HttpServletResponse response) throws IOException
|
{
|
//导出卷面封面代码
|
|
ArchiveInfoVo aIV = iArchiveRecordsService.selectByRecordId(55L);
|
List<ArchiveInfoVo> arsi = new ArrayList<>();
|
arsi.add(aIV);
|
|
String recordId = aIV.getRecordId();
|
byte[] imgr = barcodeService.generateBarcodeImage(recordId);
|
byte[] sedcode = pdfGenerateService.createQrCodeN(recordId, 30, 30);
|
ExcelExp e1 = new ExcelExp("案卷封面数据",arsi, ArchiveInfoVo.class);
|
ExcelExp e2 = new ExcelExp("案卷封面", arsi, recordId, imgr,sedcode, ArchiveInfoVo.class);
|
List<ExcelExp> mysheet = new ArrayList<ExcelExp>();
|
mysheet.add(e1);
|
mysheet.add(e2);
|
ByteOutputStream bos1 = new ByteOutputStream();
|
ExcelUtilManySheetSecond<List<ExcelExp>> util2 = new ExcelUtilManySheetSecond<List<ExcelExp>>(mysheet);
|
|
// util2.exportExcelManySheet(response, mysheet);
|
|
|
|
//导出卷面目录代码
|
// DocumentMaterials documentMaterials = new DocumentMaterials();
|
// documentMaterials.setRecordId(55L);
|
// // List<DocumentMaterials> docs = documentMaterialsService.selectDocumentMaterialsList(documentMaterials);
|
// List<DocumentMaterialsVo> dsvs = documentMaterialsService.findArchMInfo("55");
|
// // dsvs.get(0).setUrl("/profile/upload/2025/08/14/30_20250814212128A031.jpg");
|
//
|
//
|
// // dsvs.stream().map()
|
// List<DocumentMaterialsVoSmall> list2 = dsvs.stream().map(res -> new DocumentMaterialsVoSmall(res.getNum(), res.getDocumentNumber(),res.getCreator(),
|
// res.getTitle(), res.getDate(), res.getPageNumber(), res.getRemarks())).collect(Collectors.toList());
|
//
|
// 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);
|
// util2.exportExcelManySheet(response, mysheet);
|
|
}
|
|
|
|
|
|
|
|
|
|
|
/**
|
* 打包下载
|
* @param response
|
* @param
|
*/
|
@PostMapping("/export")
|
|
public void packDownload(HttpServletResponse response, Long id) throws Exception {
|
// 获取文件的保存位置,读取数据库,
|
DocumentMaterials documentMaterials = new DocumentMaterials();
|
documentMaterials.setRecordId(id);
|
List<DocumentMaterialsVoLarge> docs = documentMaterialsService.selectDocumentMaterialsAllByRecordId(id);
|
System.out.println(docs.size()+"----009");
|
|
|
//.selectDocumentMaterialsList(documentMaterials);
|
List<DocumentMaterialsVo> dsvs = documentMaterialsService.findArchMInfo(id.toString());
|
ArchiveInfoVo aIV = iArchiveRecordsService.selectByRecordId(id);
|
|
List<String> paths = new ArrayList<>();
|
// System.out.println(docs);
|
if (docs.size() == 1) { // 直接下载
|
String filePath = paths.get(0);
|
filePath = filePath.replace("/profile/", RuoYiConfig.getProfile() + "/");
|
|
File file = new File(filePath);
|
if (!file.exists()) {
|
throw new Exception("文件不存在");
|
}
|
String suffix = filePath.substring(filePath.lastIndexOf("."));
|
// 输出文件流
|
writeFileToRes(response, "user" + "-" + new SimpleDateFormat("yyyyMMddHHmmss").format(new Date()) + suffix, file);
|
} else { // 压缩之后在进行下载
|
//压缩包名称（会拼上当前时间）
|
System.out.println(90);
|
String datumName = "user";
|
//压缩文件
|
List<String> filePathList = paths;
|
File file = compressedFileToZip(docs, dsvs, aIV, id);
|
System.out.println(file.getName());
|
|
String fileName =aIV.getRecordId()+".zip";
|
//输出文件流
|
writeFileToRes(response, file.getName(), file);
|
//删除压缩包
|
if(file.exists()){
|
file.delete();
|
}
|
}
|
}
|
// 输出文件流到response
|
private void writeFileToRes(HttpServletResponse response, String fileName, File file) throws IOException {
|
|
|
String realFileName = System.currentTimeMillis() + fileName.substring(fileName.indexOf("_") + 1);
|
String filePath = RuoYiConfig.getDownloadPath() + fileName;
|
|
|
response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
|
FileUtils.setAttachmentResponseHeader(response, realFileName);
|
FileUtils.writeBytes(filePath, response.getOutputStream());
|
|
}
|
public String frontCompWithZore(int formatLength,int formatNumber){
|
/**
|
* 0 指前面补充零
|
* formatLength 字符总长度为 formatLength
|
* inputNumber 格式化数字
|
* d 代表为正数。
|
*/
|
String newString = String.format("%0"+formatLength+"d", formatNumber);
|
return newString;
|
}
|
|
|
|
|
|
|
private PdfPCell ImageSet(int high) throws Exception {
|
// byte[] fileByte = toByteArray("D:\\project\\archive\\download\\12.jpg");
|
//
|
//
|
// FileInputStream fis = new FileInputStream("D:\\project\\archive\\download\\56.png");
|
// byte[] imageBytes = new byte[fis.available()];
|
// fis.read(imageBytes);
|
// fis.close();
|
// Jpeg jpeg = new Jpeg(imageBytes);
|
// jpeg.scaleAbsolute(70, 50);
|
byte[] imageBytes = barcodeService.generateBarcodeImage("D3.4.1-05-2024-0002");
|
// 加载PNG图片
|
Image img = Image.getInstance(imageBytes);
|
// 设置图片在PDF中的位置（可选）
|
img.setAbsolutePosition(100, 700);
|
// 将图片添加到PDF文档中
|
PdfPCell pdfPCell = new PdfPCell(img);
|
pdfPCell.setMinimumHeight(high);
|
pdfPCell.setUseAscender(true); // 设置可以居中
|
pdfPCell.setHorizontalAlignment(PdfPCell.ALIGN_CENTER); // 设置水平居中
|
pdfPCell.setVerticalAlignment(PdfPCell.ALIGN_MIDDLE); // 设置垂直居中
|
return pdfPCell;
|
}
|
|
|
// 压缩文件
|
private File compressedFileToZip(List<DocumentMaterialsVoLarge> docs, List<DocumentMaterialsVo> dsvs, ArchiveInfoVo aIV, Long id) throws Exception {
|
//压缩包具体名称（拼接时间戳防止重名）
|
String datumName = "";
|
String zipFileName =dsvs.get(0).getDocumentNumber()+aIV.getRecordId()+ ".zip";
|
//生成压缩包存储地址（最后会删掉）
|
String fileZip = RuoYiConfig.getProfile() + "/download/" + zipFileName;
|
OutputStream os=null;
|
ZipOutputStream zos = null ;
|
System.out.println("==============_______________");
|
File file = new File(fileZip);
|
try {
|
if (!file.getParentFile().exists()) {
|
file.getParentFile().mkdirs();
|
}
|
os=new FileOutputStream(file);
|
//压缩文件
|
zos = new ZipOutputStream(os);
|
|
//pdf目录封面
|
String pdfPathF = "07-卷面封面.pdf";
|
pdfGenerateService.generatePdf(pdfPathF);
|
// 2. 压缩PDF到ZIP文件
|
// 添加PDF文件到ZIP
|
ZipEntry zipEntry = new ZipEntry(pdfPathF);
|
zos.putNextEntry(zipEntry);
|
|
// 读取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;
|
pdfGenerateService.generateFileDirectoryPdf(pdf08Path, list3);
|
ZipEntry zipEntry2 = new ZipEntry(pdf08Path);
|
zos.putNextEntry(zipEntry2);
|
|
// 读取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(), id);
|
// 2. 压缩PDF到ZIP文件
|
// 添加PDF文件到ZIP
|
ZipEntry zipEntry1 = new ZipEntry(pdf09Path);
|
zos.putNextEntry(zipEntry1);
|
|
// 读取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("卷内封面" + ".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 entry = new ZipEntry("电子文件目录" + ".xls");
|
ExcelUtil<DocumentMaterialsVoLarge> util = new ExcelUtil<DocumentMaterialsVoLarge>(DocumentMaterialsVoLarge.class);
|
|
zos.putNextEntry(entry);
|
ByteOutputStream bos = new ByteOutputStream();
|
util.byteOutputStreamExcel(bos, docs,"电子文件目录", "");
|
bos.writeTo(zos);
|
|
//拿到卷内目录的excel
|
List<DocumentMaterialsVoSmall> list2 = dsvs.stream().map(res -> new DocumentMaterialsVoSmall(res.getNum(), res.getDocumentNumber(),res.getCreator(),
|
res.getTitle(), res.getDate(), res.getPageNumber(), res.getRemarks())).collect(Collectors.toList());
|
|
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("卷内目录" + ".xls");
|
ExcelUtil<DocumentMaterialsVo> util1 = new ExcelUtil<DocumentMaterialsVo>(DocumentMaterialsVo.class);
|
System.out.println(dsvs);
|
zos.putNextEntry(entr);
|
ByteOutputStream bos1 = new ByteOutputStream();
|
|
util2.exportExcelManySheet(bos1, mysheet);
|
|
// util1.byteOutputStreamExcel(bos1, dsvs,"Date List", "");
|
bos1.writeTo(zos);
|
//把excel转为pdf
|
|
|
|
|
boolean res = true;
|
|
byte[] buf = new byte[1024];
|
for (DocumentMaterialsVoLarge dc : docs) {
|
String filePath = dc.getUrl();
|
filePath = filePath.replace("/profile/", RuoYiConfig.getProfile() + "/");
|
|
System.out.println(filePath);
|
File tempFile = new File(filePath);
|
//在压缩包中添加文件夹
|
if(res) {
|
zos.putNextEntry(new ZipEntry("01-申请材料/"));
|
zos.putNextEntry(new ZipEntry("02-办案过程材料/"));
|
zos.putNextEntry(new ZipEntry("03-结论性文件/"));
|
zos.putNextEntry(new ZipEntry("04-其他材料/"));
|
zos.putNextEntry(new ZipEntry("05-档案变更材料/"));
|
zos.putNextEntry(new ZipEntry("06-业务数据/"));
|
res = false;
|
}
|
//得到文件名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("01-申请材料/"+fname));
|
else if(dc.getStage().equals("02-办案过程材料"))
|
zos.putNextEntry(new ZipEntry("02-办案过程材料/"+fname));
|
else if(dc.getStage().equals("03-结论性文件"))
|
zos.putNextEntry(new ZipEntry("03-结论性文件/"+fname));
|
else if(dc.getStage().equals("04-其他材料")) {
|
zos.putNextEntry(new ZipEntry("04-其他材料/" + fname));
|
}
|
else if(dc.getStage().equals("05-档案变更材料"))
|
zos.putNextEntry(new ZipEntry("05-档案变更材料/"+fname));
|
else if(dc.getStage().equals("06-业务数据"))
|
zos.putNextEntry(new ZipEntry("06-业务数据/"+fname));
|
else
|
zos.putNextEntry(new ZipEntry(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();
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
System.out.println(e.toString());
|
throw new Exception("文件打包:"+e.getMessage());
|
}finally {
|
//关闭流
|
if(zos != null){
|
try {
|
zos.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
//关闭流
|
if(os!= null){
|
try {
|
os.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
return file;
|
}
|
|
}
|
