From 98d0e65ddbb42e7c5fab436f45dde3a4b051c77f Mon Sep 17 00:00:00 2001
From: zhanghl <253316343@qq.com>
Date: 星期五, 25 四月 2025 14:22:20 +0800
Subject: [PATCH] 气柜和管路物料用量-接口提交
---
aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java | 83 +++++++++++++++++++++++++++++++----------
1 files changed, 63 insertions(+), 20 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java
index c627314..0129a0a 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsPlateProcessShopStatServiceImpl.java
@@ -1,5 +1,6 @@
package com.aps.core.service.impl;
+import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;
@@ -130,7 +131,7 @@
// 瀹氫箟璇ュ姛鑳戒娇鐢ㄦ暟鎹簮涓哄崡閫氱殑宸ュ巶
final String plant = "FORTUNA";
-
+ final String major="閽ｉ噾";
// 鏌ヨ鐩稿叧鏁版嵁
ApsPlatePlan platePlan = new ApsPlatePlan();
platePlan.setPlant(plant);
@@ -144,6 +145,7 @@
ApsStandardProcess process = new ApsStandardProcess();
process.setPlant(plant);
+ process.setMajor(major);
List<ApsStandardProcess> shopProcesses = standardProcessMapper.selectApsStandardProcessList(process);
if (planList.isEmpty() || shopList.isEmpty() || shopProcesses.isEmpty()) {
log.warn("璁″垝鍒楄〃銆佽溅闂村垪琛ㄦ垨宸ュ簭鍒楄〃涓虹┖锛屾棤娉曠敓鎴愮粺璁′俊鎭�");
@@ -190,7 +192,8 @@
stat.setDelFlag("0");
stat.setCreateBy(SecurityUtils.getUsername());
stat.setCreateTime(DateUtils.getNowDate());
-
+ stat.setWorkCenter(plan.getWorkCenter());
+ stat.setProcessNumber(plan.getProcessNumber());
try {
@@ -342,45 +345,56 @@
workCenterTitle.setCellValue("褰撳墠宸ュ簭");
workCenterTitle.setCellStyle(title);
- SXSSFCell itemNumberTitle = rowTitle.createCell(6);
+ SXSSFCell departmentTitle = rowTitle.createCell(6);
+ departmentTitle.setCellValue("褰撳墠宸ュ簭璐熻矗浜�");
+ departmentTitle.setCellStyle(title);
+
+ SXSSFCell nextProcessDeparmentTitle = rowTitle.createCell(7);
+ nextProcessDeparmentTitle.setCellValue("涓嬩竴宸ュ簭璐熻矗浜�");
+ nextProcessDeparmentTitle.setCellStyle(title);
+
+ SXSSFCell itemNumberTitle = rowTitle.createCell(8);
itemNumberTitle.setCellValue("鏂欏彿");
itemNumberTitle.setCellStyle(title);
- SXSSFCell drawingNoTitle = rowTitle.createCell(7);
+ SXSSFCell drawingNoTitle = rowTitle.createCell(9);
drawingNoTitle.setCellValue("鍥惧彿");
drawingNoTitle.setCellStyle(title);
- SXSSFCell versionNumberTitle = rowTitle.createCell(8);
+ SXSSFCell versionNumberTitle = rowTitle.createCell(10);
versionNumberTitle.setCellValue("鐗堟湰鍙�");
versionNumberTitle.setCellStyle(title);
- SXSSFCell productionQuantityTitle = rowTitle.createCell(9);
+ SXSSFCell productionQuantityTitle = rowTitle.createCell(11);
productionQuantityTitle.setCellValue("鐢熶骇鏁伴噺");
productionQuantityTitle.setCellStyle(title);
- SXSSFCell planEndDayTitle = rowTitle.createCell(10);
+ SXSSFCell planEndDayTitle = rowTitle.createCell(12);
planEndDayTitle.setCellValue("璁″垝瀹屽伐鏃�");
planEndDayTitle.setCellStyle(title);
+
+
+ int i1 = 13;
for (int i = 0; i < shopNames.size(); i++) {
String shopName = shopNames.get(i);
- SXSSFCell beginDateCell = rowTitle.createCell(i * 2 + 11);
- SXSSFCell endDateCell = rowTitle.createCell(i * 2 + 12);
+ SXSSFCell beginDateCell = rowTitle.createCell(i * 2 + i1);
+ SXSSFCell endDateCell = rowTitle.createCell(i * 2 + i1+1);
beginDateCell.setCellValue(shopName+"寮�宸ユ椂闂�");
endDateCell.setCellValue(shopName+"瀹屽伐鏃堕棿");
beginDateCell.setCellStyle(title);
endDateCell.setCellStyle(title);
}
-
-
+ SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
for (int i = 0; i < table.size(); i++) {
ApsPlateProcessShopPlanStat plan = table.get(i);
- /*鍒涘缓鏁版嵁琛�*/
+
SXSSFRow dataRow = sheet.createRow(i+1);
SXSSFCell mainPartNumberCell = dataRow.createCell(0);
- mainPartNumberTitle.setCellValue(plan.getMainPartNumber());
- //mainPartNumberTitle.setCellStyle(title);
+ mainPartNumberCell.setCellValue(plan.getMainPartNumber());
+
+ //mainPartNumberCell.setCellStyle(title);
SXSSFCell businessTypeCell= dataRow.createCell(1);
businessTypeCell.setCellValue(plan.getBusinessType());
@@ -402,26 +416,51 @@
workCenterCell.setCellValue(plan.getWorkCenter());
// workCenterCell.setCellStyle(title);
- SXSSFCell itemNumberCell = dataRow.createCell(6);
+ SXSSFCell departmentCell = dataRow.createCell(6);
+ departmentCell.setCellValue(plan.getDepartment());
+
+ SXSSFCell nextProcessDeparmentCell = dataRow.createCell(7);
+ nextProcessDeparmentCell.setCellValue(plan.getNextProcessDeparment());
+
+
+ SXSSFCell itemNumberCell = dataRow.createCell(8);
itemNumberCell.setCellValue(plan.getItemNumber());
// itemNumberCell.setCellStyle(title);
- SXSSFCell drawingNoCell = dataRow.createCell(7);
+ SXSSFCell drawingNoCell = dataRow.createCell(9);
drawingNoCell.setCellValue(plan.getDrawingNo());
// drawingNoCell.setCellStyle(title);
- SXSSFCell versionNumberCell = dataRow.createCell(8);
+ SXSSFCell versionNumberCell = dataRow.createCell(10);
versionNumberCell.setCellValue(plan.getVersionNumber());
// versionNumberCell.setCellStyle(title);
- SXSSFCell productionQuantityCell = dataRow.createCell(9);
+ SXSSFCell productionQuantityCell = dataRow.createCell(11);
productionQuantityCell.setCellValue(plan.getProductionQuantity().toString());
// productionQuantityCell.setCellStyle(title);
- SXSSFCell planEndDayCell = dataRow.createCell(10);
- planEndDayCell.setCellValue(plan.getPlanEndDay());
+ SXSSFCell planEndDayCell = dataRow.createCell(12);
+ planEndDayCell.setCellValue(dateFormat.format(plan.getPlanEndDay()));
// planEndDayCell.setCellStyle(title);
+
+ for (int j = 0; j< shopNames.size(); j++) {
+ String shopName = shopNames.get(j);
+ SXSSFCell beginDateCell = dataRow.createCell(j * 2 + i1);
+ SXSSFCell endDateCell = dataRow.createCell(j * 2 + i1+1);
+ plan.getDeptPlans().stream().filter(x->x.getShopName().equals(shopName)).findFirst().ifPresent(x->{
+ beginDateCell.setCellValue(x.getPlanStartDate());
+ endDateCell.setCellValue(x.getPlanEndDate());
+ });
+ }
+
+
}
+
+ for (int i = 0; i < 24; i++) {
+
+ sheet.setColumnWidth(i, 20 * 256);
+ }
+
wb.write(response.getOutputStream());
}
catch (Exception e)
@@ -447,6 +486,10 @@
style.setFont(titleFont);
DataFormat dataFormat = wb.createDataFormat();
style.setDataFormat(dataFormat.getFormat("@"));
+
+
+
+
styles.put("title", style);
return styles;
}
--
Gitblit v1.9.3