From c5947256b22f2283214258827f61af09966cf490 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Tue, 31 Dec 2024 17:25:37 +0800
Subject: [PATCH] feat(mall): 添加会员列表直推、团队、业绩统计功能 - 在 MallMember 实体中添加直推数、团队数、业绩金额等字段 - 修改 getMallMemberList 方法,异步计算每个会员的直推、团队和业绩数据 - 在前端列表中显示直推、团队、业绩等列 - 优化数据查询效率,使用 LambdaQueryWrapper 和 CompletableFuture

---
 src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
index 2fb2f54..7dc7f9f 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
@@ -1,7 +1,32 @@
 package cc.mrbird.febs.mall.mapper;
 
 import cc.mrbird.febs.mall.entity.MallGoodsSku;
+import cc.mrbird.febs.mall.vo.AdminMailGoodsSkuDetailVo;
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import org.apache.ibatis.annotations.Param;
 
 public interface MallGoodsSkuMapper extends BaseMapper<MallGoodsSku> {
+
+    void deleteByGoodsId(@Param("id")Long id);
+
+    List<AdminMailGoodsSkuDetailVo> selectByGoodId(@Param("id")Long id);
+
+    List<MallGoodsSku> selectSkuByGoodsId(@Param("id") Long id);
+
+    MallGoodsSku selectSkuInfoById(@Param("id") Long id);
+
+    int delSkuByIds(@Param("list") List<Long> ids);
+
+    Integer upDateStockAndVolumeBySkuId(@Param("id")Long id, @Param("cnt")Integer cnt);
+
+    Integer updateStockAndVolumeBySkuId(@Param("id")Long id, @Param("cnt")Integer cnt);
+
+    List<Long> selectGoodsIdBySkuIds(@Param("list")List<Long> skuIds);
+
+    List<MallGoodsSku> selectSkuIdsByGoodsId(@Param("list")List<Long> goodsIdsAll);
+
+    List<MallGoodsSku> selectByIds(@Param("list")List<Long> skuIds);
 }

--
Gitblit v1.9.1