| | |
| | | */ |
| | | public interface ShopcartMapper extends BaseMapper<Shopcart> { |
| | | |
| | | @Select(" select s.id as shopCartId , s.GOODS_SKU_ID as goodsSkuId , s.PRODUCT_ID as goodsId , g.name as goodsName , gs.`NAME` as skuName , s.num , gs.PRICE , ifnull(gs.STATUS,1) as status ," + |
| | | @Select(" select s.id as shopCartId , s.GOODS_SKU_ID as goodsSkuId , s.PRODUCT_ID as goodsId , g.name as goodsName , gs.`NAME` as skuName , s.num , gs.PRICE ," + |
| | | " CASE WHEN ( g.ISDELETED = 1 || g.`STATUS` = 1 || gs.ISDELETED = 1 ) THEN 1 ELSE 0 END status," + |
| | | "case when gs.IMGURL = '' then g.IMGURL when gs.IMGURL is null then g.IMGURL else gs.IMGURL end imgUrl " + |
| | | " from shopcart s left join goods g on s.PRODUCT_ID = g.ID left join goods_sku gs ON s.GOODS_SKU_ID = gs.id " + |
| | | " where 1 = 1 and s.member_id = #{memberId} order by s.CREATE_DATE desc ") |
| | |
| | | continue; |
| | | } |
| | | MemberCoupon memberCoupon = MemberCoupon.couponToBean(coupon,inviteMember,new Date(),Constants.ONE,null); |
| | | if(Constants.equalsInteger(memberCoupon.getCouponType(),Constants.ZERO)){ |
| | | memberCoupon.setMaxPrice(memberCoupon.getPrice()); |
| | | }else if(Constants.equalsInteger(memberCoupon.getCouponType(),Constants.ONE)){ |
| | | memberCoupon.setMaxPrice(memberCoupon.getLimitPrice().subtract(memberCoupon.getLimitPrice().multiply(memberCoupon.getPrice()).divide(new BigDecimal("100"),2, RoundingMode.HALF_UP))); |
| | | }else{ |
| | | memberCoupon.setMaxPrice(BigDecimal.ZERO); |
| | | } |
| | | for (int i = 0; i < num; i++) { |
| | | memberCouponList.add(memberCoupon); |
| | | } |
| | |
| | | if(coupon == null){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起,第【"+index+"】个优惠券查询无效,请刷新页面重新!"); |
| | | } |
| | | BigDecimal maxPrice = BigDecimal.ZERO; |
| | | if(Constants.equalsInteger(coupon.getCouponType(),Constants.ZERO)){ |
| | | maxPrice = coupon.getPrice(); |
| | | }else if(Constants.equalsInteger(coupon.getCouponType(),Constants.ONE)){ |
| | | maxPrice = coupon.getLimitPrice().subtract(coupon.getLimitPrice().multiply(coupon.getPrice()).divide(new BigDecimal("100"),2, RoundingMode.HALF_UP)); |
| | | } |
| | | for(Member member : memberList){ |
| | | for (int i = 0; i < Constants.formatLongNum(param.getNum()); i++) { |
| | | MemberCoupon memberCoupon = MemberCoupon.couponToBean(coupon,member,now,Constants.TWO,loginUserInfo); |
| | | memberCoupon.setMaxPrice(maxPrice); |
| | | //挨个送 |
| | | addList.add(memberCoupon); |
| | | } |