src/main/java/cc/mrbird/febs/mall/dto/MallGoodsQueryDto.java
@@ -40,4 +40,7 @@ @ApiModelProperty(value = "1-付费商品 2-积分商品") private Integer goodsType; @ApiModelProperty(hidden = true) private Long memberId; } src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java
@@ -3,6 +3,7 @@ import cc.mrbird.febs.common.enumerates.DataDictionaryEnum; import cc.mrbird.febs.common.exception.FebsException; import cc.mrbird.febs.common.utils.AppContants; import cc.mrbird.febs.common.utils.LoginUserUtil; import cc.mrbird.febs.mall.conversion.MallGoodsConversion; import cc.mrbird.febs.mall.conversion.MallMemberConversion; import cc.mrbird.febs.mall.dto.ApiMallGoodsCommentDto; @@ -47,6 +48,10 @@ @Override public IPage<MallGoodsListVo> findMallGoodsListInPage(MallGoodsQueryDto queryDto) { MallMember loginUser = LoginUserUtil.getLoginUser(); if (loginUser != null) { queryDto.setMemberId(loginUser.getId()); } Page<MallGoodsListVo> page = new Page<>(queryDto.getPageNow(), queryDto.getPageSize()); return this.baseMapper.selectMallGoodsListQueryInPage(queryDto, page); } src/main/resources/mapper/modules/MallGoodsMapper.xml
@@ -101,7 +101,9 @@ a.carriage_rule_id, a.goods_weight, a.order_number, <if test="record.memberId != null"> case when collection.id is null then 2 else 1 end hasCollect, </if> min(b.id) skuId, min(b.present_price) price, sum(b.stock) stock, @@ -109,7 +111,9 @@ from mall_goods a left join mall_goods_sku b on a.id=b.goods_id left join mall_goods_category c on a.category_id=c.id left join mall_member_collection collection on a.id=collection.goods_id <if test="record.memberId != null"> left join mall_member_collection collection on a.id=collection.goods_id and collection.member_id=#{record.memberId} </if> <where> a.is_sale=1 <if test="record != null">
