From c12817442862a466d8219cbd0fce04f0695d76ee Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期三, 11 九月 2024 17:18:02 +0800
Subject: [PATCH] 1.粉丝数
---
src/main/resources/mapper/customer/FollowMapper.xml | 7 +++++++
src/main/java/com/mzl/flower/mapper/customer/FollowMapper.java | 2 ++
src/main/java/com/mzl/flower/service/customer/FollowService.java | 10 ++++++++--
src/main/java/com/mzl/flower/web/customer/FollowController.java | 12 +++++++-----
4 files changed, 24 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/mzl/flower/mapper/customer/FollowMapper.java b/src/main/java/com/mzl/flower/mapper/customer/FollowMapper.java
index a2d832d..13874dc 100644
--- a/src/main/java/com/mzl/flower/mapper/customer/FollowMapper.java
+++ b/src/main/java/com/mzl/flower/mapper/customer/FollowMapper.java
@@ -12,4 +12,6 @@
@Repository
public interface FollowMapper extends BaseMapper<Follow> {
List<FollowDTO> myFollow(Page page, @Param("userId") String userId);
+
+ Integer getStatisFansCount(@Param("supplierId") Long supplierId);
}
diff --git a/src/main/java/com/mzl/flower/service/customer/FollowService.java b/src/main/java/com/mzl/flower/service/customer/FollowService.java
index dc097c0..fb185a6 100644
--- a/src/main/java/com/mzl/flower/service/customer/FollowService.java
+++ b/src/main/java/com/mzl/flower/service/customer/FollowService.java
@@ -2,13 +2,11 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.mzl.flower.config.exception.ValidationException;
import com.mzl.flower.config.security.SecurityUtils;
import com.mzl.flower.dto.request.customer.CreateFollowDTO;
import com.mzl.flower.dto.response.customer.FollowDTO;
import com.mzl.flower.entity.customer.Follow;
import com.mzl.flower.mapper.customer.FollowMapper;
-import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -65,4 +63,12 @@
.eq(Follow::getSupplierId, supplierId));
return count;
}
+
+
+ public Integer getStatisFansCount(Long supplierId) {
+
+ Integer count = followMapper.getStatisFansCount(supplierId);
+
+ return count;
+ }
}
diff --git a/src/main/java/com/mzl/flower/web/customer/FollowController.java b/src/main/java/com/mzl/flower/web/customer/FollowController.java
index d318bb8..a4039ae 100644
--- a/src/main/java/com/mzl/flower/web/customer/FollowController.java
+++ b/src/main/java/com/mzl/flower/web/customer/FollowController.java
@@ -5,12 +5,8 @@
import com.mzl.flower.base.R;
import com.mzl.flower.base.ReturnDataDTO;
import com.mzl.flower.config.security.SecurityUtils;
-import com.mzl.flower.dto.request.customer.CreateAddressDTO;
import com.mzl.flower.dto.request.customer.CreateFollowDTO;
-import com.mzl.flower.dto.request.customer.UpdateAddressDTO;
import com.mzl.flower.dto.response.customer.FollowDTO;
-import com.mzl.flower.dto.response.supplier.SupplierDTO;
-import com.mzl.flower.entity.customer.Address;
import com.mzl.flower.service.customer.FollowService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -20,7 +16,6 @@
import org.springframework.web.bind.annotation.*;
import javax.validation.constraints.NotNull;
-import java.util.List;
@RestController
@RequestMapping("/api/follow")
@@ -56,4 +51,11 @@
public ResponseEntity<ReturnDataDTO<Page<FollowDTO>>> myFollow(Page page) {
return returnData(R.SUCCESS.getCode(),followService.myFollow(page,SecurityUtils.getUserId()));
}
+
+ @GetMapping("/fans/statis/{supplierId}")
+ @ApiOperation(value = "我的关注列表", notes = "我的关注列表")
+ public ResponseEntity<ReturnDataDTO<Integer>> myFansStatis(@NotNull(message = "supplierId不能为空") @PathVariable("supplierId") Long supplierId) {
+ return returnData(R.SUCCESS.getCode(),followService.getStatisFansCount(supplierId));
+ }
+
}
diff --git a/src/main/resources/mapper/customer/FollowMapper.xml b/src/main/resources/mapper/customer/FollowMapper.xml
index d0dad11..89f028d 100644
--- a/src/main/resources/mapper/customer/FollowMapper.xml
+++ b/src/main/resources/mapper/customer/FollowMapper.xml
@@ -21,4 +21,11 @@
</if>
ORDER BY f.create_time DESC
</select>
+
+ <select id="getStatisFansCount" resultType="java.lang.Integer">
+ SELECT IFNULL(COUNT(DISTINCT f.user_id), 0)
+ FROM t_follow_supplier f
+ WHERE f.deleted = 0
+ AND f.supplier_id = #{supplierId};
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3