From 71a4444510d9067654705f0c5803d5f12a21a092 Mon Sep 17 00:00:00 2001
From: guoyujie <guoyujie@ng.com>
Date: 星期二, 11 十一月 2025 09:17:34 +0800
Subject: [PATCH] 添加流程卡进度接口信息
---
north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java | 31 +++++++++++++++++++++++++++----
1 files changed, 27 insertions(+), 4 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java b/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java
index 696f099..8b49f36 100644
--- a/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java
+++ b/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java
@@ -29,6 +29,8 @@
import java.math.BigDecimal;
import java.math.RoundingMode;
+import java.sql.SQLOutput;
+import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.util.*;
@@ -1024,7 +1026,8 @@
return true;
}
- public Map<String,Object> appGetOrderList(List<LocalDate> dates) {
+ public Map<String,Object> appGetOrderList(List<String> dates) {
+ //璁剧疆褰撳墠鏃堕棿
String endDate = LocalDate.now().toString();
String startDate = LocalDate.now().minusDays(30).toString();
if(dates !=null && dates.size()==2){
@@ -1035,15 +1038,35 @@
endDate = String.valueOf(dates.get(1));
}
}
+ List<String> date = new ArrayList<>();
+ date.add(startDate);
+ date.add(endDate);
+
List<Order> list = orderMapper.selectList(new LambdaQueryWrapper<Order>()
- .gt(Order::getCreateOrder,0)
- .between(Order::getCreateTime,startDate, endDate)
+ .apply("create_order > 0")
+ .apply("date(create_time) between {0} and {1}",startDate, endDate)
);
+ Integer quantity = 0;
+ Double area = 0.00;
+ Double perimeter = 0.00;
+ for(Order order:list){
+ quantity += Integer.parseInt(String.valueOf(order.getQuantity()));
+ area += Double.parseDouble(String.valueOf(order.getArea()));
+ perimeter += order.getPerimeter();
+ }
+ Map<String, Object> totalSum = new HashMap<>();
+ DecimalFormat df = new DecimalFormat("#.00");
+ totalSum.put("quantity",quantity);
+ totalSum.put("area", df.format(area));
+ totalSum.put("perimeter", df.format(perimeter));
+ totalSum.put("count", list.size());
+
Map<String,Object> map = new HashMap<>();
map.put("data",list);
+ map.put("date",date);
+ map.put("totalSum",totalSum);
return map;
- //return orderMapper.
}
}
--
Gitblit v1.8.0