From b7b7c0a641c7bf53d3d31449dc8c31efba58ea97 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期三, 22 四月 2026 17:58:34 +0800
Subject: [PATCH] 导出销售台账送货单
---
src/main/java/com/ruoyi/sales/vo/ShippingNoteVo.java | 35 +++++++++++
src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java | 16 +++++
src/main/resources/static/shipping-note.xlsx | 0
src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java | 6 ++
src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java | 115 +++++++++++++++++++++++++++++++++++++-
src/main/java/com/ruoyi/sales/pojo/SalesLedger.java | 4 +
src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java | 2
7 files changed, 174 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java b/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
index cbef46f..c04f901 100644
--- a/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
+++ b/src/main/java/com/ruoyi/sales/controller/SalesLedgerController.java
@@ -189,6 +189,20 @@
}
/**
+ * 瀵煎嚭閿�鍞彴璐﹀彂璐у崟
+ */
+ @Log(title = "瀵煎嚭閿�鍞彴璐﹀彂璐у崟", businessType = BusinessType.EXPORT)
+ @PostMapping("/exportShippingNote")
+ public void exportShippingNote(HttpServletResponse response, @RequestParam("ids") String idsStr) {
+ // 灏嗛�楀彿鍒嗛殧鐨勫瓧绗︿覆杞崲涓篖ist<Long>
+ List<Long> ids = Arrays.stream(idsStr.split(","))
+ .map(Long::parseLong)
+ .collect(Collectors.toList());
+ System.out.println("瀵煎嚭閿�鍞彴璐﹀彂璐у崟锛孖D鍒楄〃: " + ids);
+ salesLedgerService.exportShippingNote(response, ids);
+ }
+
+ /**
* 鍒犻櫎閿�鍞彴璐�
*/
@Log(title = "閿�鍞彴璐�", businessType = BusinessType.DELETE)
@@ -349,4 +363,4 @@
public R getSalesLedgerWithProductsLoss(Long salesLedgerId) {
return R.ok(salesLedgerService.getSalesLedgerWithProductsLoss(salesLedgerId));
}
-}
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java b/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
index 4d7dd5e..519fd8a 100644
--- a/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
+++ b/src/main/java/com/ruoyi/sales/pojo/SalesLedger.java
@@ -10,6 +10,7 @@
import java.math.BigDecimal;
import java.time.LocalDate;
import java.util.Date;
+import java.util.List;
/**
* 閿�鍞彴璐﹀璞� sales_ledger
@@ -172,6 +173,9 @@
@TableField(exist = false)
private String companyPhone;
+ @TableField(exist = false)
+ private List<SalesLedgerProduct> productList;
+
/**
* 鏄惁鐢熶骇
*/
diff --git a/src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java b/src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java
index a93ee5e..551f8bd 100644
--- a/src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java
+++ b/src/main/java/com/ruoyi/sales/pojo/SalesLedgerProduct.java
@@ -13,6 +13,7 @@
import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.Date;
+import java.util.List;
/**
* 浜у搧淇℃伅瀵硅薄 sales_ledger_product
@@ -248,6 +249,11 @@
@TableField(exist = false)
private Integer hasSufficientStock;
+ @ApiModelProperty("搴忓彿")
+ @TableField(exist = false)
+ @Excel(name = "搴忓彿")
+ private Integer serialNumber;
+
@ApiModelProperty("鎵瑰彿")
private String batchNo;
}
diff --git a/src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java b/src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java
index 8c973b3..87a7a89 100644
--- a/src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java
+++ b/src/main/java/com/ruoyi/sales/service/ISalesLedgerService.java
@@ -10,6 +10,7 @@
import com.ruoyi.sales.pojo.SalesLedger;
import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletResponse;
import java.math.BigDecimal;
import java.util.List;
@@ -43,4 +44,5 @@
List<LossProductModelDto> getSalesLedgerWithProductsLoss(Long salesLedgerId);
+ void exportShippingNote(HttpServletResponse response, List<Long> ids);
}
diff --git a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
index 1e29d05..c09ccd0 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java
@@ -1,5 +1,8 @@
package com.ruoyi.sales.service.impl;
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.ExcelWriter;
+import com.alibaba.excel.write.metadata.WriteSheet;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -8,6 +11,9 @@
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.deepoove.poi.XWPFTemplate;
+import com.deepoove.poi.config.Configure;
+import com.ruoyi.account.pojo.AccountIncome;
import com.ruoyi.account.service.AccountIncomeService;
import com.ruoyi.basic.mapper.CustomerMapper;
import com.ruoyi.basic.mapper.ProductMapper;
@@ -17,9 +23,11 @@
import com.ruoyi.common.enums.FileNameType;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.DateUtils;
+import com.ruoyi.common.utils.HackLoopTableRenderPolicy;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.device.execl.DeviceMaintenanceExeclDto;
import com.ruoyi.framework.security.LoginUser;
import com.ruoyi.framework.web.domain.AjaxResult;
import com.ruoyi.other.mapper.TempFileMapper;
@@ -34,6 +42,7 @@
import com.ruoyi.sales.dto.*;
import com.ruoyi.sales.mapper.*;
import com.ruoyi.sales.pojo.*;
+import com.ruoyi.sales.service.ISalesLedgerProductService;
import com.ruoyi.sales.service.ISalesLedgerService;
import com.ruoyi.stock.mapper.StockInventoryMapper;
import lombok.RequiredArgsConstructor;
@@ -48,11 +57,13 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
-import java.io.IOException;
-import java.io.InputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.*;
import java.lang.reflect.Field;
import java.math.BigDecimal;
import java.math.RoundingMode;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
@@ -60,11 +71,14 @@
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.YearMonth;
+import java.time.ZoneId;
import java.time.format.DateTimeFormatter;
import java.util.*;
import java.util.concurrent.TimeUnit;
import java.util.function.Function;
import java.util.stream.Collectors;
+import java.util.zip.ZipEntry;
+import java.util.zip.ZipOutputStream;
/**
* 閿�鍞彴璐ervice涓氬姟灞傚鐞�
@@ -129,6 +143,8 @@
private final QualityInspectMapper qualityInspectMapper;
private final StockInventoryMapper stockInventoryMapper;
+
+ private ISalesLedgerProductService salesLedgerProductService;
@Autowired
@@ -206,6 +222,99 @@
resultDto.setSalesLedgerFiles(salesLedgerFiles);
}
return resultDto;
+ }
+
+ @Override
+ public void exportShippingNote(HttpServletResponse response, List<Long> ids) {
+ log.info("寮�濮嬪鍑洪�佽揣鍗曪紝鍙拌处ID鍒楄〃: {}", ids);
+
+ // 鍙傛暟鏍￠獙
+ if (ids == null || ids.isEmpty()) {
+ throw new BaseException("璇烽�夋嫨瑕佸鍑虹殑閿�鍞彴璐�");
+ }
+
+ List<SalesLedger> salesLedgerList = salesLedgerMapper.selectList(
+ Wrappers.<SalesLedger>lambdaQuery()
+ .in(SalesLedger::getId, ids)
+ );
+
+ if (salesLedgerList.isEmpty()) {
+ throw new BaseException("鏈壘鍒板搴旈攢鍞彴璐︽暟鎹�");
+ }
+
+ response.setContentType("application/zip");
+ response.setHeader("Content-Disposition", "attachment;filename=閫佽揣鍗�.zip");
+ response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
+
+ // 鐩存帴鍐呭瓨鎵撳寘锛屾姏寮冧复鏃舵枃浠�
+ try (ZipOutputStream zos = new ZipOutputStream(response.getOutputStream())) {
+
+ for (SalesLedger ledger : salesLedgerList) {
+ log.info("澶勭悊鍚堝悓鍙�: {}", ledger.getSalesContractNo());
+
+ // 鏌ヨ鏄庣粏
+ SalesLedgerProduct cond = new SalesLedgerProduct();
+ cond.setSalesLedgerId(ledger.getId());
+ List<SalesLedgerProduct> productList = salesLedgerProductServiceImpl.selectSalesLedgerProductList(cond);
+
+ // 鑷姩搴忓彿
+ for (int i = 0; i < productList.size(); i++) {
+ productList.get(i).setSerialNumber(i + 1);
+ }
+
+ // 鍏宠仈鏌ヨ瀹㈡埛淇℃伅
+ Customer customer = customerMapper.selectById(ledger.getCustomerId());
+ // 缁勮鏁版嵁
+ Map<String, Object> dataMap = new HashMap<>();
+ dataMap.put("customerName", ledger.getCustomerName());
+ dataMap.put("companyAddress", customer.getCompanyAddress());
+ dataMap.put("contactPerson", customer.getContactPerson());
+ dataMap.put("contactPhone", customer.getContactPhone());
+ dataMap.put("companyPhone", customer.getCompanyPhone());
+ dataMap.put("salesContractNo", ledger.getSalesContractNo());
+ dataMap.put("deliveryDate", formatDate(LocalDate.now()));
+ // 鏀惧叆鍟嗗搧闆嗗悎
+ dataMap.put("products", productList);
+
+ // 姣忔寰幆鍏ㄦ柊璇诲彇妯℃澘锛屽交搴曡В鍐虫祦闂
+ ByteArrayOutputStream bos = new ByteArrayOutputStream();
+ try (InputStream templateIs = this.getClass().getResourceAsStream("/static/shipping-note.xlsx")) {
+ if (templateIs == null) throw new BaseException("妯℃澘鏂囦欢涓嶅瓨鍦�");
+
+ // EasyExcel濉厖
+ ExcelWriter writer = EasyExcel.write(bos).withTemplate(templateIs).build();
+ WriteSheet sheet = EasyExcel.writerSheet().build();
+ writer.fill(dataMap, sheet);
+ writer.finish();
+ }
+
+ // 鎵撳寘杩沍IP
+ String excelName = String.format("閫佽揣鍗昣%s.xlsx",
+ Optional.ofNullable(ledger.getSalesContractNo()).orElse(String.valueOf(ledger.getId())));
+ ZipEntry entry = new ZipEntry(excelName);
+ zos.putNextEntry(entry);
+ zos.write(bos.toByteArray());
+ zos.closeEntry();
+ bos.close();
+ }
+
+ zos.finish();
+ log.info("鎵归噺瀵煎嚭瀹屾垚锛屽叡{}浠介�佽揣鍗�", salesLedgerList.size());
+
+ } catch (BaseException e) {
+ log.error("瀵煎嚭澶辫触:{}", e.getMessage(), e);
+ throw e;
+ } catch (Exception e) {
+ log.error("瀵煎嚭寮傚父", e);
+ throw new BaseException("瀵煎嚭澶辫触锛�" + e.getMessage());
+ }
+ }
+
+ public static String formatDate(LocalDate date) {
+ if (date == null) {
+ return null;
+ }
+ return date.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
}
@Override
@@ -868,4 +977,4 @@
throw new RuntimeException("鍔ㄦ�佹洿鏂颁富琛ㄩ噾棰濆け璐�", e);
}
}
-}
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/sales/vo/ShippingNoteVo.java b/src/main/java/com/ruoyi/sales/vo/ShippingNoteVo.java
new file mode 100644
index 0000000..fc22574
--- /dev/null
+++ b/src/main/java/com/ruoyi/sales/vo/ShippingNoteVo.java
@@ -0,0 +1,35 @@
+package com.ruoyi.sales.vo;
+
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import com.ruoyi.sales.pojo.SalesLedgerProduct;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+public class ShippingNoteVo {
+ @Excel(name = "瀹㈡埛鍚嶇О", cellType = Excel.ColumnType.STRING)
+ private String customerName;
+
+ @Excel(name = "閫佽揣鍦板潃", cellType = Excel.ColumnType.STRING)
+ private String companyAddress;
+
+ @Excel(name = "鑱旂郴浜�", cellType = Excel.ColumnType.STRING)
+ private String contactPerson;
+
+ @Excel(name = "鑱旂郴鐢佃瘽", cellType = Excel.ColumnType.STRING)
+ private String contactPhone;
+
+ @Excel(name = "鍏徃鐢佃瘽", cellType = Excel.ColumnType.STRING)
+ private String companyPhone;
+
+ @Excel(name = "鍗曟嵁缂栧彿", cellType = Excel.ColumnType.STRING)
+ private String salesContractNo;
+
+ @Excel(name = "閫佽揣鏃ユ湡", cellType = Excel.ColumnType.STRING)
+ private String deliveryDate;
+
+ @Excel(name = "浜у搧淇℃伅", type = Excel.Type.EXPORT)
+ private List<SalesLedgerProduct> products;
+
+}
diff --git a/src/main/resources/static/shipping-note.xlsx b/src/main/resources/static/shipping-note.xlsx
new file mode 100644
index 0000000..260d3b9
--- /dev/null
+++ b/src/main/resources/static/shipping-note.xlsx
Binary files differ
--
Gitblit v1.9.3