From 535c81a311bcd54b7ef5aa3f02b3cddc19b854d1 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Thu, 15 May 2025 16:06:14 +0800 Subject: [PATCH] feat(mall): 新增订单项的积分金额和积分价格字段- 在 MallOrderInfoMapper.xml 中添加了 item_score_amount 和 item_score_price 字段的映射 - 在 MallOrderItem 实体类中添加了 itemScorePrice 字段 - 更新了 selectNewApiOrderListInPage 查询,加入了积分金额和积分价格的计算 --- src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsMapper.java | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 50 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 30e3ed0..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,17 +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.entity.MallGoodsCategory; -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