From 2a64b537e8e3bce9ce030585a3da17d48379c0ad Mon Sep 17 00:00:00 2001
From: sfd <sun.sunshine@163.com>
Date: 星期一, 26 五月 2025 15:04:45 +0800
Subject: [PATCH] 修改json类型转换错误
---
aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java | 69 ++++++++++++++++++++++++----------
1 files changed, 49 insertions(+), 20 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java
index 9091533..761f9b4 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java
@@ -17,6 +17,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;
@@ -230,33 +231,29 @@
@Override
public List<List<String>> weldSeamEchartsList(ApsWeldSeam apsWeldSeam) {
+ List<ApsWeldSeam> queryDataList = new ArrayList<>();
Map<String, Object> params = apsWeldSeam.getParams();
if(ObjectUtils.isNotEmpty(params)){
String startDay = params.get("startDay").toString();
String endDay = params.get("endDay").toString();
- List<Long> produceYears = new ArrayList<>();
- List<Long> produceMonths = new ArrayList<>();
- String startQueryYear = startDay.substring(0,4);
- String endQueryYear = endDay.substring(0,4);
- String startQueryDay = startDay.substring(6,7);
- String endQueryDay = endDay.substring(6,7);
- produceYears.add(Long.valueOf(startQueryYear));
- produceYears.add(Long.valueOf(endQueryYear));
- produceMonths.add(Long.valueOf(startQueryDay));
- produceMonths.add(Long.valueOf(endQueryDay));
- apsWeldSeam.setProduceYears(produceYears);
- apsWeldSeam.setProduceMonths(produceMonths);
+ List<String> dateList = getMonthBetweenDate(startDay,endDay);
+ dateList.forEach(item->{
+ ApsWeldSeam weldSeam = new ApsWeldSeam();
+ String queryYear = item.substring(0,4);
+ String queryMonth = item.substring(6,7);
+ weldSeam.setProduceYear(Long.valueOf(queryYear));
+ weldSeam.setProduceMonth(Long.valueOf(queryMonth));
+ queryDataList.add(weldSeam);
+ });
}
- List<Map> mapList =apsWeldSeamMapper.weldSeamEcharts(apsWeldSeam);
- Set monthSet=mapList.stream().map(e->e.get("produce_month").toString()).collect(Collectors.toSet());
+ List<Map> mapList =apsWeldSeamMapper.weldSeamEcharts(queryDataList);
+ Set monthSet=mapList.stream().map(e->e.get("produce_month")).collect(Collectors.toSet());
List monthList = new ArrayList(monthSet);
Collections.sort(monthList);
List<List<String>> echartsList = new ArrayList<>();
Set<String> titleSet = new HashSet<>();
- List<String> title = new ArrayList<>(titleSet);
- title.add("product");
mapList.forEach(item->{
StringBuilder sb = new StringBuilder();
sb.append(item.get("production_base"));
@@ -264,11 +261,12 @@
sb.append(item.get("work_order_name"));
sb.append("-");
sb.append(item.get("classification_name"));
- title.add(sb.toString());
-
+ titleSet.add(sb.toString());
});
+ List<String> title = new ArrayList<>();
+ title.add("product");
+ title.addAll(titleSet);
echartsList.add(title);
- System.out.println(monthList);
monthList.forEach(month->{
List<String> table = new ArrayList<>();
table.add(month+"鏈�");
@@ -281,7 +279,7 @@
sb.append(value.get("work_order_name"));
sb.append("-");
sb.append(value.get("classification_name"));
- if(sb.toString().equals(title.get(i))){//鍒楁槑
+ if(sb.toString().equals(title.get(i)) && month==value.get("produce_month")){
table.add(value.get("total_weld_seam").toString());
}
}
@@ -290,4 +288,35 @@
});
return echartsList;
}
+
+ public static List<String> getMonthBetweenDate(String startTime, String endTime) {
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");
+ // 澹版槑淇濆瓨鏃ユ湡闆嗗悎
+ List<String> list = new ArrayList<>();
+ try {
+ // 杞寲鎴愭棩鏈熺被鍨�
+ Date startDate = sdf.parse(startTime);
+ Date endDate = sdf.parse(endTime);
+
+ //鐢–alendar 杩涜鏃ユ湡姣旇緝鍒ゆ柇
+ Calendar calendar = Calendar.getInstance();
+ while (startDate.getTime() <= endDate.getTime()) {
+
+ // 鎶婃棩鏈熸坊鍔犲埌闆嗗悎
+ list.add(sdf.format(startDate));
+
+ // 璁剧疆鏃ユ湡
+ calendar.setTime(startDate);
+
+ //鎶婃湀鏁板鍔� 1
+ calendar.add(Calendar.MONTH, 1);
+
+ // 鑾峰彇澧炲姞鍚庣殑鏃ユ湡
+ startDate = calendar.getTime();
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return list;
+ }
}
--
Gitblit v1.9.3