From 4ee42556139749bf6f29d47b912da0be6c37da2a Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Thu, 15 May 2025 11:29:39 +0800
Subject: [PATCH] feat(mall): 添加商品 SKU静态属性价格字段
---
src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java | 46 ++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 44 insertions(+), 2 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java
index 6340e58..e4c99c5 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java
@@ -1,23 +1,65 @@
package cc.mrbird.febs.mall.mapper;
import cc.mrbird.febs.mall.dto.MallGoodsQueryDto;
+import cc.mrbird.febs.mall.entity.DataDictionaryCustom;
import cc.mrbird.febs.mall.entity.MallGoods;
-import cc.mrbird.febs.mall.vo.AdminMallGoodsVo;
-import cc.mrbird.febs.mall.vo.MallGoodsListVo;
+import cc.mrbird.febs.mall.entity.MallGoodsComment;
+import cc.mrbird.febs.mall.vo.*;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
+import java.math.BigDecimal;
+import java.util.Date;
import java.util.List;
+import java.util.Map;
public interface MallGoodsMapper extends BaseMapper<MallGoods> {
IPage<MallGoodsListVo> selectMallGoodsListQueryInPage(@Param("record") MallGoodsQueryDto queryDto, Page<MallGoodsListVo> page);
+ MallGoods selectGoodsDetailById(@Param("id") Long id);
+
IPage<AdminMallGoodsVo> selectMallGoodsInPage(Page<AdminMallGoodsVo> page, @Param("record")MallGoods mallGoods);
Integer selectMallGoodsCountByGoodsName(@Param("goodsName")String goodsName);
+ Integer selectMallGoodsCountByGoodsNameAndGoodId(@Param("goodsName")String goodsName,@Param("id")Long id);
+
Integer selectMallGoodsCountByGoodsNo(@Param("goodsNo")String goodsNo);
+
+ Integer selectMallGoodsCountByGoodsNoAndGoodId(@Param("goodsNo")String goodsNo,@Param("id")Long id);
+
+ AdminMailGoodsDetailVo selectMallGoodsInfoById(@Param("id")long id);
+
+ Map<String, BigDecimal> selectGoodsStockAndVolume(@Param("id") Long id);
+
+ List<MallGoods> selectMallGoodsByCategaryId(@Param("categaryId")Long id);
+
+ AdminMailGoodsUpdateVo getMallGoodsUpdateInfoById(@Param("id")long id);
+
+ List<AdminMallGoodsTreeVo> getAllGoodsTree();
+
+ List<MallGoods> selectOrderGoodsList(@Param("memberId") Long memberId, @Param("date") Date date);
+
+ IPage<MallGoodsCommentVo> selectMallGoodsCommentListQueryInPage(Page<MallGoodsCommentVo> page, @Param("record")MallGoodsComment mallGoodsComment);
+
+ IPage<DataDictionaryCustom> getDeliveryHomeListInPage(Page<DataDictionaryCustom> page, @Param("record")AdminHomeDeliverySettingVo adminHomeDeliverySettingVo);
+
+ MallGoodsCommentVo findMallGoodsCommentLevelByGoodsId(@Param("id")Long id);
+
+ Integer upDateStockAndVolumeByGoodsId(@Param("id")Long id,@Param("cnt")Integer cnt);
+
+ Integer updateStockAndVolumeByGoodsId(@Param("id")Long id,@Param("cnt")Integer cnt);
+
+ List<MallGoodsListVo> selectMallGoodsListQueryNoPage(@Param("record")MallGoodsQueryDto queryDto);
+
+ List<MallGoods> selectMallGoodsListQueryByRuleId(@Param("id")Long id);
+
+ List<MallGoods> selectMallGoodsListQueryByRuleIdAndIsSale(@Param("id")Long id, @Param("isSale")Integer ishotStateYes);
+
+ void updateCarriageRuleId(@Param("id")Long id);
+
+ void updateCarriageAmount(@Param("id")Long id);
}
--
Gitblit v1.9.1