From 26cdfa723406fc4cbb667401704d2cdd2547331b Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期六, 03 九月 2022 14:37:40 +0800
Subject: [PATCH] 下载替换件变红
---
src/main/java/com/whyc/service/ProductBomHistoryService.java | 153 ++++++++++++++++++++++++++++++++++++--------------
1 files changed, 109 insertions(+), 44 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomHistoryService.java b/src/main/java/com/whyc/service/ProductBomHistoryService.java
index 6fcfdf0..b4293f2 100644
--- a/src/main/java/com/whyc/service/ProductBomHistoryService.java
+++ b/src/main/java/com/whyc/service/ProductBomHistoryService.java
@@ -136,6 +136,7 @@
//澶勭悊瀛樺湪鍏宠仈鍏崇郴鐨勭墿鏂�
List<ProductBomHistory> endList=new ArrayList<>();
list.stream().forEach(bomHistory -> {
+ bomHistory.setConnFlag(0);
endList.add(bomHistory);
if(bomHistory.getMaterials()!=null&&bomHistory.getMaterials().size()>0){
for (Material m:bomHistory.getMaterials()) {
@@ -145,12 +146,6 @@
}
}
});
- HSSFWorkbook wb = new HSSFWorkbook();
- //瀛椾綋鏍煎紡-鍔犵矖
- HSSFCellStyle cellStyle = wb.createCellStyle();
- HSSFFont font = wb.createFont();
- font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
- cellStyle.setFont(font);
String withOutDwg="doc_file/product"+File.separator+pHistory.getParentModel();
if(pHistory.getCustomCode()!=null&&!pHistory.getCustomCode().isEmpty()){
withOutDwg+=File.separator+pHistory.getCustomCode()+File.separator+version;
@@ -158,7 +153,7 @@
withOutDwg+=File.separator+"standard"+File.separator+version;
}
//鐢熸垚excel骞跺皢dwg鏂囦欢鏀惧湪鍚屼竴鎶ヤ笅鍘嬬缉
- creatBomHsitoryExcel(req,resp,pHistory,endList,wb,withOutDwg);
+ creatBomHsitoryExcel(req,resp,pHistory,endList,withOutDwg);
//璁板綍鏃ュ織
DocUser docUser= ActionUtil.getUser();
String operationDetail="鍏蜂綋浜у搧涓�:"+pHistory.toString();
@@ -167,11 +162,21 @@
logService.recordOperationLog(docUser.getId(),docUser.getName(), UserOperation.TYPE_DOWNLOAD.getType(),new Date(),terminalIp,opreationMsg,operationDetail);
}
//鏍规嵁浜у搧淇℃伅鍒涘缓excel琛ㄦ牸骞跺瓨鏀惧湪鎸囧畾鐩綍
- public void creatBomHsitoryExcel(HttpServletRequest req, HttpServletResponse resp,ProductHistory pHistory,List<ProductBomHistory> list, HSSFWorkbook wb,String withOutDwg){
+ public void creatBomHsitoryExcel(HttpServletRequest req, HttpServletResponse resp,ProductHistory pHistory,List<ProductBomHistory> list,String withOutDwg){
String fileDirName = FileDirPath.getFileDirName();
String rootFace="";
String excelName="";
+ String[] titleNames=new String[]{"搴忓垪","姣嶇墿鏂欑紪鐮�","姣嶇墿鏂欏悕绉�","姣嶇墿鏂欏瀷鍙�","绫诲埆","瀛愪欢缂栫爜","瀛愪欢鍚嶇О","瀛愪欢鍨嬪彿"
+ ,"鍩烘湰鍗曚綅","瀛愪欢鏁伴噺","鐢熶骇鍟�","灏佽绫诲瀷/鏉愯川","鍏冧欢缂栧彿/鏂欏帤","琛ㄩ潰澶勭悊/鐗╂枡璇︽儏","澶囨敞","鍥剧墖"};
//鍒涘缓鍗曚釜sheet
+ HSSFWorkbook wb = new HSSFWorkbook();
+ //瀛椾綋鏍煎紡-鍔犵矖
+ HSSFCellStyle cellStyle = wb.createCellStyle();
+ HSSFFont font = wb.createFont();
+ font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
+ font.setColor(HSSFFont.COLOR_RED);
+ cellStyle.setFont(font);
+
HSSFSheet sheet = wb.createSheet("bom_"+pHistory.getVersion()+"淇℃伅");
sheet.setColumnWidth(1,5000);
sheet.setColumnWidth(2,5000);
@@ -185,24 +190,14 @@
//鍥剧墖鍏冪礌
HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
int rownum = 1;
- sheet.createRow(rownum);
- sheet.getRow(rownum).createCell(1).setCellValue("搴忓垪");
- sheet.getRow(rownum).createCell(2).setCellValue("姣嶇墿鏂欑紪鐮�");
- sheet.getRow(rownum).createCell(3).setCellValue("姣嶇墿鏂欏悕绉�");
- sheet.getRow(rownum).createCell(4).setCellValue("姣嶇墿鏂欏瀷鍙�");
- sheet.getRow(rownum).createCell(5).setCellValue("绫诲埆");
- sheet.getRow(rownum).createCell(6).setCellValue("瀛愪欢缂栫爜");
- sheet.getRow(rownum).createCell(7).setCellValue("瀛愪欢鍚嶇О");
- sheet.getRow(rownum).createCell(8).setCellValue("瀛愪欢鍨嬪彿");
- sheet.getRow(rownum).createCell(9).setCellValue("鍩烘湰鍗曚綅");
- sheet.getRow(rownum).createCell(10).setCellValue("瀛愪欢鏁伴噺");
- sheet.getRow(rownum).createCell(11).setCellValue("鐢熶骇鍟�");
- sheet.getRow(rownum).createCell(12).setCellValue("灏佽绫诲瀷/鏉愯川");
- sheet.getRow(rownum).createCell(13).setCellValue("鍏冧欢缂栧彿/鏂欏帤");
- sheet.getRow(rownum).createCell(14).setCellValue("琛ㄩ潰澶勭悊/鐗╂枡璇︽儏");
- sheet.getRow(rownum).createCell(15).setCellValue("澶囨敞");
- sheet.getRow(rownum).createCell(16).setCellValue("鍥剧墖");
-
+ HSSFRow row=sheet.createRow(rownum);
+ HSSFCell cell=row.createCell(0);
+ if(titleNames.length>0){
+ for (int i=0;i<titleNames.length;i++) {
+ cell=row.createCell(i+1);
+ cell.setCellValue(titleNames[i]);
+ }
+ }
excelName=pHistory.getParentCode()+"_"+pHistory.getParentModel()+"_"+pHistory.getVersion();
rootFace=fileDirName+ File.separator+excelName;
File destfile = new File(rootFace);
@@ -222,23 +217,93 @@
File sourceFile=new File(fileDirName+ File.separator+dwgUrl);
bomService.copyFile(sourceFile,rootFace);
}
- Row row=sheet.createRow(rownum+i+1);
- //row.setHeight((short)(1500));
- sheet.getRow(rownum+i+1).createCell(1).setCellValue(i+1);
- sheet.getRow(rownum+i+1).createCell(2).setCellValue(pHistory.getParentCode());
- sheet.getRow(rownum+i+1).createCell(3).setCellValue(pHistory.getParentName());
- sheet.getRow(rownum+i+1).createCell(4).setCellValue(pHistory.getParentModel());
- sheet.getRow(rownum+i+1).createCell(5).setCellValue(bomHistory.getCategory());
- sheet.getRow(rownum+i+1).createCell(6).setCellValue(bomHistory.getSubCode());
- sheet.getRow(rownum+i+1).createCell(7).setCellValue(bomHistory.getSubName());
- sheet.getRow(rownum+i+1).createCell(8).setCellValue(bomHistory.getSubModel());
- sheet.getRow(rownum+i+1).createCell(9).setCellValue(bomHistory.getUnit()==null?"":bomHistory.getUnit());
- sheet.getRow(rownum+i+1).createCell(10).setCellValue(bomHistory.getQuantity()==null?"":bomHistory.getQuantity().toString());
- sheet.getRow(rownum+i+1).createCell(11).setCellValue(bomHistory.getProducer()==null?"":bomHistory.getProducer());
- sheet.getRow(rownum+i+1).createCell(12).setCellValue(bomHistory.getMaterial());
- sheet.getRow(rownum+i+1).createCell(13).setCellValue(bomHistory.getThickness());
- sheet.getRow(rownum+i+1).createCell(14).setCellValue(bomHistory.getSurfaceDetail());
- sheet.getRow(rownum+i+1).createCell(15).setCellValue(bomHistory.getNotes());
+ rownum=rownum+1;
+ row=sheet.createRow(rownum);
+ if(bomHistory.getConnFlag()==1){
+ cell=row.createCell(0);
+ cell.setCellValue("鏇挎崲浠�");
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(1);
+ cell.setCellValue(i+1);
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(2);
+ cell.setCellValue(pHistory.getParentCode());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(3);
+ cell.setCellValue(pHistory.getParentName());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(4);
+ cell.setCellValue(pHistory.getParentModel());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(5);
+ cell.setCellValue(bomHistory.getCategory());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(6);
+ cell.setCellValue(bomHistory.getSubCode());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(7);
+ cell.setCellValue(bomHistory.getSubName());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(8);
+ cell.setCellValue(bomHistory.getSubModel());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(9);
+ cell.setCellValue(bomHistory.getUnit()==null?"":bomHistory.getUnit());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(10);
+ cell.setCellValue(bomHistory.getQuantity()==null?"": bomHistory.getQuantity().toString());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(11);
+ cell.setCellValue(bomHistory.getProducer()==null?"":bomHistory.getProducer());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(12);
+ cell.setCellValue(bomHistory.getMaterial());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(12);
+ cell.setCellValue(bomHistory.getThickness());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(13);
+ cell.setCellValue(bomHistory.getThickness());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(14);
+ cell.setCellValue(bomHistory.getSurfaceDetail());
+ cell.setCellStyle(cellStyle);
+
+ cell=row.createCell(15);
+ cell.setCellValue(bomHistory.getNotes());
+ cell.setCellStyle(cellStyle);
+ }else{
+ row.createCell(1).setCellValue(i+1);
+ row.createCell(2).setCellValue(pHistory.getParentCode());
+ row.createCell(3).setCellValue(pHistory.getParentName());
+ row.createCell(4).setCellValue(pHistory.getParentModel());
+ row.createCell(5).setCellValue(bomHistory.getCategory());
+ row.createCell(6).setCellValue(bomHistory.getSubCode());
+ row.createCell(7).setCellValue(bomHistory.getSubName());
+ row.createCell(8).setCellValue(bomHistory.getSubModel());
+ row.createCell(9).setCellValue(bomHistory.getUnit()==null?"":bomHistory.getUnit());
+ row.createCell(10).setCellValue(bomHistory.getQuantity()==null?"":bomHistory.getQuantity().toString());
+ row.createCell(11).setCellValue(bomHistory.getProducer()==null?"":bomHistory.getProducer());
+ row.createCell(12).setCellValue(bomHistory.getMaterial());
+ row.createCell(13).setCellValue(bomHistory.getThickness());
+ row.createCell(14).setCellValue(bomHistory.getSurfaceDetail());
+ row.createCell(15).setCellValue(bomHistory.getNotes());
+ }
if((bomHistory.getPictureUrl()!=null)&&(!bomHistory.getPictureUrl().isEmpty())){
ByteArrayOutputStream byteArrayOut = null;
try {
@@ -316,7 +381,6 @@
bomHis.setSubName(m.getSubName());
bomHis.setSubModel(m.getSubModel());
bomHis.setUnit(m.getUnit());
- //bomHis.setQuantity(m.getQuantity());
bomHis.setProducer(m.getProducer());
bomHis.setMaterial(m.getMaterial());
bomHis.setThickness(m.getThickness());
@@ -326,6 +390,7 @@
bomHis.setDwgUrl(m.getDwgUrl());
bomHis.setFileUrl(m.getFileUrl());
bomHis.setCreateDate(m.getCreateDate());
+ bomHis.setConnFlag(1);
return bomHis;
}
--
Gitblit v1.9.1