From b6373daa40c3dc17ca107f3666fd252f3b6b0778 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期五, 03 一月 2025 18:34:52 +0800
Subject: [PATCH] 代码
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOrderController.java | 23 ++++++++++++++++++++---
1 files changed, 20 insertions(+), 3 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOrderController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOrderController.java
index 274815b..1a13061 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOrderController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TOrderController.java
@@ -21,6 +21,7 @@
import io.swagger.annotations.ApiOperation;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.security.core.parameters.P;
+import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
@@ -226,10 +227,26 @@
@PostMapping(value = "/export")
public void mealGeneratorExport(@RequestBody OrderQuery orderQuery) {
- List<TOrder> tOrders = orderService.listExport(orderQuery);
+
+ int pageSize = 100;
+ int currentPage = 0;
+ List<TOrder> page = new ArrayList<>();
+
+ while (true) {
+ orderQuery.setPageNum(currentPage * pageSize);
+ orderQuery.setPageSize(pageSize);
+ PageInfo<TOrder> tOrderPageInfo = orderService.pageList(orderQuery);
+ List<TOrder> records = tOrderPageInfo.getRecords();
+ if (CollectionUtils.isEmpty(records)) {
+ break; // 没有更多数据，退出循环
+ }
+ page.addAll(records); // 累加当前页数据
+ currentPage++; // 进入下一页
+ }
+
List<TCourse> courses = courseService.lambdaQuery().list();
List<TInformation> informations = informationService.lambdaQuery().list();
- for (TOrder record : tOrders) {
+ for (TOrder record : page) {
record.getFormattedCreateTime();
if (record.getGoodType()==1){
TCourse course = courses.stream().filter(e -> e.getId().equals(record.getGoodId())).findFirst().orElse(null);
@@ -243,7 +260,7 @@
}
- Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TOrder.class,tOrders );
+ Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TOrder.class,page);
HttpServletResponse response = WebUtils.response();
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
--
Gitblit v1.7.1