From 90b911dc30523c8511a8fb15695e1e78d1cce151 Mon Sep 17 00:00:00 2001
From: mrzhssss <pro6@qq.com>
Date: 星期二, 06 九月 2022 08:41:44 +0800
Subject: [PATCH] #
---
src/main/java/zy/cloud/wms/manager/service/impl/ItemReportServiceImpl.java | 138 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 138 insertions(+), 0 deletions(-)
diff --git a/src/main/java/zy/cloud/wms/manager/service/impl/ItemReportServiceImpl.java b/src/main/java/zy/cloud/wms/manager/service/impl/ItemReportServiceImpl.java
index 7618d0c..f3f7deb 100644
--- a/src/main/java/zy/cloud/wms/manager/service/impl/ItemReportServiceImpl.java
+++ b/src/main/java/zy/cloud/wms/manager/service/impl/ItemReportServiceImpl.java
@@ -2,7 +2,11 @@
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
+import com.core.common.R;
import com.core.exception.CoolException;
+import org.apache.poi.xssf.usermodel.XSSFRow;
+import org.apache.poi.xssf.usermodel.XSSFSheet;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import zy.cloud.wms.manager.entity.Item;
import zy.cloud.wms.manager.mapper.ItemReportMapper;
@@ -12,6 +16,10 @@
import org.springframework.stereotype.Service;
import zy.cloud.wms.manager.service.ItemService;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.*;
+import java.net.URLEncoder;
import java.util.Date;
@Service("itemReportService")
@@ -70,4 +78,134 @@
report.setCreateBy(userId);
insert(report);
}
+
+ @Override
+ public HttpServletResponse makeReport(Item item, ItemReport itemReport, HttpServletResponse response) {
+
+ FileInputStream in = null;
+ ServletOutputStream out = null;
+ try {
+ /**
+ * 涓�浜涘垵濮嬪寲
+ */
+ in = new FileInputStream("src/main/resources/excel/analysis_report.xlsx");
+
+ XSSFWorkbook wb = new XSSFWorkbook(in);
+ XSSFSheet mainSheet = wb.getSheet("鎶ュ憡");
+ /**
+ * 寮�濮嬭缃10鍜�11鍚堝苟琛岀殑鎵�鏈夊垪, 瑙掓爣浠�0寮�濮�,rownum9瀹為檯涓婄瓑浜�10
+ */
+ XSSFRow row10 = mainSheet.getRow(9);
+ row10.getCell(1).setCellValue(item.getUuid());
+ row10.getCell(3).setCellValue(item.getEndTime0$());
+ row10.getCell(5).setCellValue(item.getRealEndTime0$());
+
+ XSSFRow row1 = mainSheet.getRow(0);
+ row1.getCell(0).setCellValue(item.getName()+"璁㈠崟鎬荤粨鍒嗘瀽鎶ュ憡");
+
+ /**
+ * 寮�濮嬭缃12琛�
+ */
+ XSSFRow row12 = mainSheet.getRow(11);
+ row12.getCell(1).setCellValue(item.getUuid());
+ row12.getCell(3).setCellValue(item.getPlandeAmt());
+ row12.getCell(5).setCellValue(item.getRealdeAmt());
+
+ /**
+ *寮�濮嬭缃14琛�
+ */
+ XSSFRow row14 = mainSheet.getRow(13);
+ row14.getCell(1).setCellValue(item.getName());
+ row14.getCell(3).setCellValue(item.getPlaninAmt());
+ row14.getCell(5).setCellValue(item.getRealinAmt());
+
+ /**
+ * 绗�16琛�
+ */
+ XSSFRow row16 = mainSheet.getRow(15);
+ row16.getCell(1).setCellValue(item.getType$());
+
+ /**
+ * 绗�18琛�
+ */
+ XSSFRow row17 = mainSheet.getRow(17);
+ row17.getCell(1).setCellValue(item.getSalesman());
+ row17.getCell(2).setCellValue(itemReport.getIssue());
+
+
+ /**
+ * 绗�20琛�
+ */
+ XSSFRow row19 = mainSheet.getRow(19);
+ row19.getCell(1).setCellValue(item.getLeader());
+
+ /**
+ * 绗�22琛�
+ */
+ XSSFRow row22 = mainSheet.getRow(21);
+ row22.getCell(1).setCellValue(item.getOriginArea());
+
+ /**
+ * 绗�29琛�
+ */
+ XSSFRow row29 = mainSheet.getRow(28);
+ row29.getCell(1).setCellValue(itemReport.getDeliverIssue$());
+ row29.getCell(2).setCellValue(itemReport.getDeliverReason());
+
+ /**
+ * 绗�31琛�
+ */
+ XSSFRow row31 = mainSheet.getRow(30);
+ row31.getCell(1).setCellValue(itemReport.getQualityIssue$());
+ row31.getCell(2).setCellValue(itemReport.getQualityReason());
+
+ /**
+ * 33琛�
+ */
+
+ XSSFRow row33 = mainSheet.getRow(32);
+ row33.getCell(1).setCellValue(itemReport.getDesignIssue$());
+ row33.getCell(2).setCellValue(itemReport.getDesignReason());
+ /**
+ * 35琛�
+ */
+
+ XSSFRow row35 = mainSheet.getRow(34);
+ row35.getCell(1).setCellValue(itemReport.getInstallIssue$());
+ row35.getCell(2).setCellValue(itemReport.getInstallReason());
+ /**
+ * 绗�45琛�
+ */
+ XSSFRow row45 = mainSheet.getRow(44);
+ row45.getCell(1).setCellValue(itemReport.getConclusion());
+
+
+// wb.write(out);
+
+ out = response.getOutputStream();
+
+ response.setContentType("application/octet-stream; charset=utf-8");
+
+ response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(item.getName()+"鎶ュ憡.xlsx"));
+
+ ServletOutputStream outputStream = response.getOutputStream();
+ wb.write(outputStream);
+
+
+ } catch (FileNotFoundException e) {
+ e.printStackTrace();
+ } catch (IOException e) {
+ e.printStackTrace();
+ } finally {
+ try {
+ in.close();
+ out.close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+
+ return response;
+ }
+
}
--
Gitblit v1.9.1