| | |
| | | return new FebsResponse().success(); |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | System.out.print(AgentLevelEnum.ZERO_LEVEL.name()); |
| | | } |
| | | |
| | | } |
| | |
| | | b.sku_image, |
| | | b.cnt, |
| | | b.price, |
| | | b.amount, |
| | | c.name leader_name, |
| | | c.phone leader_phone, |
| | | c.address_pic, |
| | | c.address_area, |
| | | c.province, |
| | | c.city, |
| | | c.township, |
| | | c.detail_address |
| | | b.amount |
| | | from mall_order_info a |
| | | inner join mall_order_item b on a.id=b.order_id |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | <where> |
| | | a.del_flag=2 |
| | | <if test="record.status == 4 and record.status != 0"> |
| | |
| | | |
| | | <select id="selectApiOrderListInPage" resultType="cc.mrbird.febs.mall.entity.MallOrderInfo"> |
| | | select |
| | | a.*, |
| | | c.name leaderName, |
| | | c.phone leaderPhone, |
| | | c.address_pic addressPic, |
| | | c.address_area addressArea, |
| | | c.province, |
| | | c.city, |
| | | c.township, |
| | | c.detail_address detailAddress |
| | | a.* |
| | | from mall_order_info a |
| | | inner join mall_order_item b on a.id=b.order_id |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | <where> |
| | | a.del_flag=2 |
| | | <if test="record.memberId != null"> |
| | |
| | | b.cnt, |
| | | b.price, |
| | | b.amount, |
| | | b.is_normal, |
| | | c.name leader_name, |
| | | c.phone leader_phone, |
| | | c.address_pic, |
| | | c.address_area, |
| | | c.province, |
| | | c.city, |
| | | c.township, |
| | | c.longitude leaderLongitude, |
| | | c.latitude leaderLatitude, |
| | | c.detail_address |
| | | b.is_normal |
| | | from mall_order_info a |
| | | inner join mall_order_item b on a.id=b.order_id |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | where a.id=#{id} |
| | | </select> |
| | | |
| | |
| | | a.status, |
| | | count(1) cnt |
| | | from mall_order_info a |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | where a.del_flag=2 and a.member_id=#{memberId} |
| | | group by a.status |
| | | </select> |
| | |
| | | |
| | | <select id="selectNewApiOrderListInPage" resultMap="NewOrderInfoMap"> |
| | | select |
| | | a.*, |
| | | c.name leader_name, |
| | | c.phone leader_phone, |
| | | c.address_pic, |
| | | c.address_area, |
| | | c.province, |
| | | c.city, |
| | | c.township, |
| | | c.detail_address |
| | | a.* |
| | | from mall_order_info a |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | <where> |
| | | a.del_flag=2 |
| | | <if test="record.memberId != null"> |
| | |
| | | b.goods_name, |
| | | b.cnt, |
| | | b.price, |
| | | b.amount, |
| | | c.name leader_name, |
| | | c.phone leader_phone, |
| | | c.address_area, |
| | | c.detail_address |
| | | b.amount |
| | | from mall_order_info a |
| | | inner join mall_order_item b on a.id=b.order_id |
| | | inner join mall_team_leader c on a.take_unique_code=c.unique_code |
| | | where a.del_flag=2 and a.id = #{orderId} and a.take_unique_code = #{takeUniqueCode} |
| | | order by a.created_time desc |
| | | </select> |
| | |
| | | c.goods_name goodsName, |
| | | c.cnt, |
| | | d.name refundMemberName, |
| | | d.phone refundMemberPhone, |
| | | e.name leaderName, |
| | | e.phone leaderPhone |
| | | d.phone refundMemberPhone |
| | | from mall_refund a |
| | | inner join mall_order_info b on a.order_id = b.id |
| | | inner join mall_order_item c on a.item_id = c.id |
| | | inner join mall_member d on a.member_id = d.id |
| | | inner join mall_team_leader e on b.take_unique_code = e.unique_code |
| | | <where> |
| | | <if test="record != null" > |
| | | <if test="record.state!=null and record.state!=''"> |
| | |
| | | </if> |
| | | <if test="record.refundMemberPhone!=null and record.refundMemberPhone!=''"> |
| | | and d.phone like concat('%',#{record.refundMemberPhone},'%') |
| | | </if> |
| | | <if test="record.leaderName!=null and record.leaderName!=''"> |
| | | and e.name like concat('%',#{record.leaderName},'%') |
| | | </if> |
| | | <if test="record.leaderPhone!=null and record.leaderPhone!=''"> |
| | | and e.phone like concat('%',#{record.leaderPhone},'%') |
| | | </if> |
| | | </if> |
| | | </where> |
| | |
| | | package cc.mrbird.febs; |
| | | |
| | | import cc.mrbird.febs.common.entity.FebsResponse; |
| | | import cc.mrbird.febs.common.enumerates.AgentLevelEnum; |
| | | import cc.mrbird.febs.common.enumerates.DataDictionaryEnum; |
| | | import cc.mrbird.febs.common.exception.FebsException; |
| | | import cc.mrbird.febs.common.utils.LoginUserUtil; |
| | | import cc.mrbird.febs.mall.dto.AddOrderItemDto; |
| | | import cc.mrbird.febs.mall.dto.AgentLevelUpdateDto; |
| | | import cc.mrbird.febs.mall.dto.ApiCreateOrderVerifyDto; |
| | | import cc.mrbird.febs.mall.dto.ApiMallActWinDetailsDto; |
| | | import cc.mrbird.febs.mall.entity.*; |
| | | import cc.mrbird.febs.mall.mapper.*; |
| | |
| | | private MallMemberWalletMapper mallMemberWalletMapper; |
| | | @Autowired |
| | | private MallActSetMapper mallActSetMapper; |
| | | @Autowired |
| | | private MallGoodsSkuMapper mallGoodsSkuMapper; |
| | | @Autowired |
| | | private MallOrderItemMapper mallOrderItemMapper; |
| | | @Autowired |
| | | private MallGoodsMapper mallGoodsMapper; |
| | | @Test |
| | | public void levelTest(){ |
| | | ApiCreateOrderVerifyDto apiCreateOrderVerifyDto = new ApiCreateOrderVerifyDto(); |
| | | List<AddOrderItemDto> addOrderItemDtos = new ArrayList<>(); |
| | | AddOrderItemDto addOrderItemDto = new AddOrderItemDto(); |
| | | addOrderItemDto.setCnt(1); |
| | | addOrderItemDto.setSkuId(243L); |
| | | addOrderItemDtos.add(addOrderItemDto); |
| | | apiCreateOrderVerifyDto.setItems(addOrderItemDtos); |
| | | MallMember member = mallMemberMapper.selectById(401L); |
| | | List<AddOrderItemDto> items = apiCreateOrderVerifyDto.getItems(); |
| | | if(CollUtil.isEmpty(items)){ |
| | | System.out.println("请先挑选商品"); |
| | | } |
| | | for (AddOrderItemDto item : apiCreateOrderVerifyDto.getItems()) { |
| | | MallGoodsSku sku = mallGoodsSkuMapper.selectSkuInfoById(item.getSkuId()); |
| | | if (sku == null) { |
| | | System.out.println("购买商品或sku不存在"); |
| | | } |
| | | if("样品".equals(sku.getSample())){ |
| | | List<MallOrderItem> mallOrderItems = mallOrderItemMapper.selectItemBySkuIdUnCancel(sku.getId(), member.getId()); |
| | | if (CollUtil.isNotEmpty(mallOrderItems)) { |
| | | System.out.println("样品只能购买一次"); |
| | | } |
| | | Integer cnt = item.getCnt(); |
| | | if(1 < cnt){ |
| | | System.out.println("样品只能购买一件"); |
| | | } |
| | | }else{ |
| | | //验证用户的等级 |
| | | if(AgentLevelEnum.ZERO_LEVEL.name().equals(member.getLevel())){ |
| | | System.out.println(sku.getSkuName() + "请先申请成为代理人"); |
| | | } |
| | | } |
| | | |
| | | if (sku.getStock() < item.getCnt()) { |
| | | System.out.println(sku.getSkuName() + "库存不足"); |
| | | } |
| | | |
| | | MallGoods mallGoods = mallGoodsMapper.selectById(sku.getGoodsId()); |
| | | if (MallGoods.ISSALE_STATUS_DISABLED.equals(mallGoods.getIsSale())) { |
| | | System.out.println(mallGoods.getGoodsName() + "已下架"); |
| | | } |
| | | } |
| | | } |
| | | // @Test |
| | | // public void skusTest() { |
| | | // ApiMallAwardDetailsVo apiMallAwardDetailsVo = new ApiMallAwardDetailsVo(); |