一个商品领取一张卷，

xiaoyong931011

2023-10-16 9967ee263f35bbc1a997e212fb0cd1a7ab6b1d91

一个商品领取一张卷，

 src/main/java/cc/mrbird/febs/mall/mapper/MallMemberCouponMapper.java

@@ -20,4 +20,8 @@
                                                                     @Param("goodsId")Long goodsId,
                                                                     @Param("couponId")Long couponId,
                                                                     @Param("inviteId")String inviteId);

    List<MallMemberCoupon> selectListByMemberIdAndGoodsIdAndCouponIdWithOutInviteId(@Param("memberId")Long memberId,
                                                                     @Param("goodsId")Long goodsId,
                                                                     @Param("couponId")Long couponId);
}

 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java

@@ -893,7 +893,8 @@
            if(ObjectUtil.isNotEmpty(salemanCoupon)){
                Long couponId = salemanCoupon.getCouponId();
                Long goodsId = getCouponDto.getGoodsId();
                List<MallMemberCoupon> mallMemberCoupons = mallMemberCouponMapper.selectListByMemberIdAndGoodsIdAndCouponId(memberId, goodsId, couponId,mallMember.getInviteId());
//                List<MallMemberCoupon> mallMemberCoupons = mallMemberCouponMapper.selectListByMemberIdAndGoodsIdAndCouponId(memberId, goodsId, couponId,mallMember.getInviteId());
                List<MallMemberCoupon> mallMemberCoupons = mallMemberCouponMapper.selectListByMemberIdAndGoodsIdAndCouponIdWithOutInviteId(memberId, goodsId, couponId);
                if(CollUtil.isEmpty(mallMemberCoupons)){
                    //商品优惠卷如果绑定了，那么当前登陆者获取一张卷
                    List<CouponGoods> couponGoodsList = couponGoodsMapper.selectByGoodIdAndCouponId(goodsId,couponId);

 src/main/resources/mapper/modules/MallMemberCouponMapper.xml

@@ -47,4 +47,14 @@
        and a.state = 1
    </select>

    <select id="selectListByMemberIdAndGoodsIdAndCouponIdWithOutInviteId" resultType="cc.mrbird.febs.mall.entity.MallMemberCoupon">
        select
            a.*
        from mall_member_coupon a
        where a.member_id = #{memberId}
        and a.goods_id = #{goodsId}
        and a.coupon_id = #{couponId}
        and a.state = 1
    </select>

</mapper>