From 059f19e02c94691d4fd32a0dc5b706632adb548d Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Thu, 05 Jun 2025 17:14:17 +0800
Subject: [PATCH] feat(mall): 添加年排行功能并优化积分查询性能

---
 src/main/java/cc/mrbird/febs/mall/service/impl/ApiHappySocialCircleServiceImpl.java |   25 +++++++++++++++++++++----
 1 files changed, 21 insertions(+), 4 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiHappySocialCircleServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiHappySocialCircleServiceImpl.java
index f2c5f5f..0cbbe04 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiHappySocialCircleServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiHappySocialCircleServiceImpl.java
@@ -24,10 +24,7 @@
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.stereotype.Service;
 
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Map;
-import java.util.Set;
+import java.util.*;
 import java.util.stream.Collectors;
 
 @Slf4j
@@ -105,6 +102,26 @@
             apiScInfoVo.setIndexFile(happySocialCircle.getIndexFile());
             apiScInfoVo.setContent(happySocialCircle.getContent());
             apiScInfoVo.setCreatedTime(happySocialCircle.getCreatedTime());
+
+            List<HappyFollow> happyFollows = happyFollowMapper.selectList(
+                    new LambdaQueryWrapper<HappyFollow>()
+                            .select(HappyFollow::getId, HappyFollow::getType)
+                            .eq(HappyFollow::getSourceType, StateUpDownEnum.SOURCE_TYPE_SOCIAL_CIRCLE.getCode())
+                            .eq(HappyFollow::getSourceId, happySocialCircle.getId())
+                            .in(HappyFollow::getType, Arrays.asList(StateUpDownEnum.FOLLOW.getCode(), StateUpDownEnum.LIKE.getCode(), StateUpDownEnum.SHARE.getCode()))
+                            .eq(HappyFollow::getDeleteFlag, StateUpDownEnum.DOWN.getCode())
+            );
+            if(CollUtil.isNotEmpty(happyFollows)){
+                //  使用Stream流操作happyFollows,按照type分类,返回每一个不同type的总数量,并返回一个Map
+                Map<Integer, Long> typeCountMap = happyFollows.stream()
+                        .collect(Collectors.groupingBy(HappyFollow::getType, Collectors.counting()));
+                Long zanCnt = ObjectUtil.defaultIfNull(typeCountMap.get(StateUpDownEnum.LIKE.getCode()), 0L);
+                apiScInfoVo.setZanCnt(Math.toIntExact(zanCnt));
+                Long sendCnt = ObjectUtil.defaultIfNull(typeCountMap.get(StateUpDownEnum.SHARE.getCode()), 0L);
+                apiScInfoVo.setSendCnt(Math.toIntExact(sendCnt));
+                Long followCnt = ObjectUtil.defaultIfNull(typeCountMap.get(StateUpDownEnum.FOLLOW.getCode()), 0L);
+                apiScInfoVo.setFollowCnt(Math.toIntExact(followCnt));
+            }
         }
         return new FebsResponse().success().data(apiScInfoVo);
     }

--
Gitblit v1.9.1