From 4aad16fd01bed0070570bc2e4bf10e812a489976 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 19 Feb 2024 16:06:56 +0800
Subject: [PATCH] 文件上传服务器地址
---
src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java | 3 +++
src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java | 4 ++++
src/main/resources/mapper/modules/MallProductBuyMapper.xml | 5 +++++
src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java | 3 +++
4 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java
index 5fd4cd1..5c2bc58 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java
@@ -12,6 +12,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
+import java.math.BigDecimal;
import java.util.List;
public interface MallProductBuyMapper extends BaseMapper<MallProductBuy> {
@@ -33,4 +34,7 @@
IPage<ApiOrderSellVo> selectSellListInPage(IPage<ApiOrderSellVo> page, @Param("record")ApiOrderSellDto apiOrderBuyDto);
List<MallProductBuy> selectTotalPerk();
+
+ BigDecimal selectTotalPerkByMemberId(@Param("memberId")Long id);
+
}
diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
index 8efbeee..d24e716 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java
@@ -311,6 +311,9 @@
Integer pickCount = mallProductBuyMapper.selectListByMemberIdAndState(id);
mallMemberVo.setPickCount(pickCount);
+
+ BigDecimal totalPerk = mallProductBuyMapper.selectTotalPerkByMemberId(mallMember.getId());
+ mallMemberVo.setTotalPerk(totalPerk);
return new FebsResponse().success().data(mallMemberVo);
}
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java b/src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java
index 0480cf9..d51ca40 100644
--- a/src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java
+++ b/src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java
@@ -108,4 +108,7 @@
@ApiModelProperty(value = "支付后，确认倒计时的分钟数，60，为paytime开始计算60分钟的倒计时")
private Integer minuteCnt;
+ @ApiModelProperty(value = "收益总额")
+ private BigDecimal totalPerk;
+
}
diff --git a/src/main/resources/mapper/modules/MallProductBuyMapper.xml b/src/main/resources/mapper/modules/MallProductBuyMapper.xml
index d74e5ca..caebadc 100644
--- a/src/main/resources/mapper/modules/MallProductBuyMapper.xml
+++ b/src/main/resources/mapper/modules/MallProductBuyMapper.xml
@@ -68,4 +68,9 @@
GROUP BY member_id;
</select>
+ <select id="selectTotalPerkByMemberId" resultType="java.math.BigDecimal">
+ select SUM(total_perk) from mall_product_buy
+ where state = 3 and member_id = #{memberId}
+ </select>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1