From 71f44d71edeabfdcc83366127a2f1f40f5a8de3e Mon Sep 17 00:00:00 2001
From: 123456 <123456>
Date: 星期三, 17 七月 2024 16:08:32 +0800
Subject: [PATCH] 费用统计分页查询功能修改
---
inspect-server/src/main/java/com/yuanchu/mom/dto/CostStatisticsDto.java | 4 +---
inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java | 28 +++++++++++++++++++++++++++-
2 files changed, 28 insertions(+), 4 deletions(-)
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/dto/CostStatisticsDto.java b/inspect-server/src/main/java/com/yuanchu/mom/dto/CostStatisticsDto.java
index 42eb682..35b2b21 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/dto/CostStatisticsDto.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/dto/CostStatisticsDto.java
@@ -49,7 +49,5 @@
@TableField(exist = false,select = false)
private String dates;
- public Integer getNum() {
- return num = 1;
- }
+
}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
index 952e942..2e1b90b 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java
@@ -399,9 +399,35 @@
map.put("head", PrintChina.printChina(CostStatisticsDto.class));
Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("costStatistics");
if (map1.get("look") == 1) costStatisticsDto.setCreateUser(map1.get("userId"));
- map.put("body", insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59")));
+ IPage<CostStatisticsDto> costStatisticsDtoIPage = insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59"));
+ List<CostStatisticsDto> costStatisticsDtoList = costStatisticsDtoIPage.getRecords();
+ for (CostStatisticsDto statisticsDto : costStatisticsDtoList) {
+ statisticsDto.setNum(1);
+ }
+ List<CostStatisticsDto> costStatisticsDtoList1 = deduplicateAndSumCounts(costStatisticsDtoList);
+ costStatisticsDtoIPage.setRecords(costStatisticsDtoList1);
+ map.put("body", costStatisticsDtoIPage);
return map;
}
+ private static List<CostStatisticsDto> deduplicateAndSumCounts(List<CostStatisticsDto> list) {
+ // 浣跨敤涓�涓� Map 鏉ュ瓨鏀惧凡缁忓嚭鐜拌繃鐨� inspectionItem + entrustCode + sample 鐨勭粍鍚�
+ Map<String, CostStatisticsDto> map = new HashMap<>();
+ // 閬嶅巻鍒楄〃杩涜鍘婚噸鍜岃鏁�
+ for (CostStatisticsDto dto : list) {
+ String key = dto.getInspectionItem() + dto.getEntrustCode() + dto.getSample();
+ if (map.containsKey(key)) {
+ // 濡傛灉宸茬粡瀛樺湪锛屽垯绱姞鏁伴噺
+ CostStatisticsDto existingDto = map.get(key);
+ existingDto.setNum(existingDto.getNum() + dto.getNum());
+ existingDto.setPrice(existingDto.getPrice().add(dto.getPrice()));
+ } else {
+ // 濡傛灉涓嶅瓨鍦紝鍒欐斁鍏� Map 涓�
+ map.put(key, dto);
+ }
+ }
+ // 灏� Map 涓殑鍊艰浆涓� List 杩斿洖
+ return new ArrayList<>(map.values());
+ }
@Override
public Map<String, Object> costStatistics2(CostStatisticsDto costStatisticsDto) {
--
Gitblit v1.9.3