From 0142e910dffd0255a4a4a1192cedd2ba0b0e71ab Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期三, 14 七月 2021 16:57:35 +0800
Subject: [PATCH] 下架正式接口： 当[(库存数量-出库通知档数量) < 下架数量]时不允许下架
---
src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java | 91 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 88 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java b/src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java
index 63e07ca..ea5773a 100644
--- a/src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java
+++ b/src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java
@@ -1,9 +1,15 @@
package com.slcf.service.impl;
+import java.io.IOException;
+import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
+import com.slcf.util.DateTimeUtil;
+import org.apache.poi.hssf.usermodel.HSSFRow;
+import org.apache.poi.hssf.usermodel.HSSFSheet;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -11,6 +17,8 @@
import com.slcf.dao.WaitPakInLogDao;
import com.slcf.pojo.WaitPakInLogBean;
import com.slcf.service.WaitPakInLogService;
+
+import javax.servlet.http.HttpServletResponse;
/**
* 鍏ュ簱閫氱煡鍘嗗彶妗ｆ帴鍙ｅ疄鐜�
@@ -22,7 +30,7 @@
@Autowired
WaitPakInLogDao waitPakInLogDao;
-
+
/**
* 鍒嗛〉鏌ヨ鎵�鏈�
*/
@@ -52,5 +60,82 @@
return null;
}
}
-
-}
\ No newline at end of file
+
+ public void ExportWaitPakInLogList(WaitPakInLogCondition condition, HttpServletResponse response) {
+ //杈撳嚭Excel鏂囦欢
+ try {
+ //HSSFWorkbook瀵硅薄(excel鐨勬枃妗ｅ璞�)
+ HSSFWorkbook workBook=new HSSFWorkbook();
+
+ //sheet瀵硅薄锛坋xcel鐨勮〃鍗曪級
+ HSSFSheet sheet=workBook.createSheet("鍏ュ簱閫氱煡鍘嗗彶妗�");
+
+ //琛屾暟锛屽弬鏁颁负琛岀储寮�(excel鐨勮)
+// HSSFRow rowHead=sheet.createRow(0);//绗竴琛� 鍙互鏄�0锝�65535涔嬮棿鐨勪换浣曚竴涓�
+
+// //鍒涘缓excel鐨勫崟鍏冩牸锛屽弬鏁颁负鍒楃储寮曪紝鍙互鏄�0锝�255涔嬮棿鐨勪换浣曚竴涓�
+// HSSFCell cellOne=rowHead.createCell(0);
+// cellOne.setCellValue("鐢ㄦ埛淇℃伅");//琛ㄥご
+
+ //鍚堝苟鍗曞厓鏍糃ellRangeAddress鏋勯�犲弬鏁颁緷娆¤〃绀鸿捣濮嬭锛屾埅鑷宠锛岃捣濮嬪垪锛� 鎴嚦鍒�
+// sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));
+
+ sheet.setColumnWidth(0, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(1, (int)((20 + 0.72) * 256));
+ sheet.setColumnWidth(2, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(3, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(4, (int)((15 + 0.72) * 256));
+ sheet.setColumnWidth(5, (int)((25 + 0.72) * 256));
+ sheet.setColumnWidth(6, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(7, (int)((8 + 0.72) * 256));
+ sheet.setColumnWidth(8, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(9, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(10, (int)((10 + 0.72) * 256));
+ sheet.setColumnWidth(11, (int)((25 + 0.72) * 256));
+
+ HSSFRow rows=sheet.createRow(0);//绗簩琛�
+ //鍒涘缓鍗曞厓鏍煎苟璁剧疆鍗曞厓鏍煎唴瀹�
+ rows.createCell(0).setCellValue("搴撲綅鍙�");
+ rows.createCell(1).setCellValue("鐗╂枡");
+ rows.createCell(2).setCellValue("鐗╂枡鎻忚堪");
+ rows.createCell(3).setCellValue("浠撳簱鍙�");
+ rows.createCell(4).setCellValue("璇锋眰缂栧彿");
+ rows.createCell(5).setCellValue("鐗╂枡鏍囩ID");
+ rows.createCell(6).setCellValue("宸ュ巶");
+ rows.createCell(7).setCellValue("鏁伴噺");
+ rows.createCell(8).setCellValue("鍗曚綅");
+ rows.createCell(9).setCellValue("鎵樼洏鐮�");
+ rows.createCell(10).setCellValue("鐢ㄦ埛ID");
+ rows.createCell(11).setCellValue("寮傚姩鏃堕棿");
+
+ List<WaitPakInLogBean> list=waitPakInLogDao.getWaitPakInLogAll(condition);
+ for(int i=0;i<list.size();i++){
+ HSSFRow row=sheet.createRow(i+1);//浠庣涓夎寮�濮�
+ //鍒涘缓鍗曞厓鏍煎苟璁剧疆鍗曞厓鏍煎唴瀹�
+ row.createCell(0).setCellValue(list.get(i).getLoc_no());
+ row.createCell(1).setCellValue(list.get(i).getMatnr());
+ row.createCell(2).setCellValue(list.get(i).getMaktx());
+ row.createCell(3).setCellValue(list.get(i).getLgnum());
+ row.createCell(4).setCellValue(list.get(i).getTbnum());
+ row.createCell(5).setCellValue(list.get(i).getZmatid());
+ row.createCell(6).setCellValue(list.get(i).getWerks());
+ row.createCell(7).setCellValue(list.get(i).getAnfme());
+ row.createCell(8).setCellValue(list.get(i).getAltme());
+ row.createCell(9).setCellValue(list.get(i).getZpallet());
+ row.createCell(10).setCellValue(list.get(i).getBname());
+ row.createCell(11).setCellValue(list.get(i).getModi_time());
+ }
+// //杈撳嚭Excel鏂囦欢
+// try {
+ OutputStream output=response.getOutputStream();
+ response.reset();
+ response.setHeader("Content-disposition", "attachment; filename=WaitPakInLog"+ DateTimeUtil.getStringDateTime(14)+".xls");
+ response.setContentType("application/msexcel");
+ workBook.write(output);
+ output.close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+
+}
--
Gitblit v1.9.1