| | |
| | | private String userName; |
| | | |
| | | @ApiModelProperty("电话") |
| | | private String phone; |
| | | private String userPhone; |
| | | private Integer pageNum; |
| | | private Integer pageSize; |
| | | |
| | |
| | | longitude, |
| | | latitude, |
| | | phone |
| | | from t_app_user where city_code = #{cityCode} and del_flag = 0 and status = 1 and vip_id >= 4 |
| | | from t_app_user where ((city_code = #{cityCode} and vip_id >= 4) or id = 1) and del_flag = 0 and status = 1 |
| | | <if test="null != nearbyReferrer.name and '' != nearbyReferrer.name"> |
| | | and `name` like CONCAT('%', #{nearbyReferrer.name}, '%') |
| | | </if> |
| | |
| | | tbcr.after_amount |
| | | FROM |
| | | t_balance_change_record tbcr |
| | | LEFT JOIN t_app_user tau ON tbcr.app_user_id = tau.id |
| | | LEFT JOIN t_app_user tau ON tbcr.app_user_id = tau.id |
| | | <where> |
| | | and tbcr.change_type = 4 |
| | | <if test="changeRecord.userName != null and changeRecord.userName != ''"> |
| | | and tau.name like concat('%',#{changeRecord.userName},'%') |
| | | </if> |
| | |
| | | select t1.*,t2.name as userName,t2.phone as userPhone |
| | | from t_withdrawal_requests t1 |
| | | left join t_app_user t2 on t1.app_user_id = t2.id |
| | | <if test="withQuery.phone != null and withQuery.phone != ''"> |
| | | AND t2.phone LIKE concat('%',#{withQuery.phone},'%') |
| | | where 1 = 1 |
| | | <if test="withQuery.userPhone != null and withQuery.userPhone != ''"> |
| | | AND t2.phone LIKE concat('%',#{withQuery.userPhone},'%') |
| | | </if> |
| | | <if test="withQuery.userName != null and withQuery.userName != ''"> |
| | | AND t2.name LIKE concat('%',#{withQuery.userName},'%') |
| | |
| | | } |
| | | }else{ |
| | | //部分商品适用 |
| | | BigDecimal goodsMoney = BigDecimal.ZERO; |
| | | BigDecimal goodsMoney = BigDecimal.ZERO; |
| | | for (MyShoppingCartVo myShoppingCartVo : goodsList) { |
| | | Integer goodsId = myShoppingCartVo.getGoodsId(); |
| | | BigDecimal cash = myShoppingCartVo.getCash(); |
| | | if(forGoodIds.contains(goodsId)){ |
| | | if(forGoodIds.contains(String.valueOf(goodsId))){ |
| | | goodsMoney = goodsMoney.add(cash); |
| | | } |
| | | } |
| | |
| | | public R<Page<GoodsCategory>> list(@ApiParam("页码") @RequestParam Integer pageNum,@ApiParam("每一页数据大小") Integer pageSize, GoodsCategory goodsCategory){ |
| | | Page<GoodsCategory> page = goodsCategoryService.lambdaQuery() |
| | | .like(StringUtils.isNotEmpty(goodsCategory.getName()),GoodsCategory::getName, goodsCategory.getName()) |
| | | .eq(GoodsCategory::getDelFlag,0) |
| | | .page(Page.of(pageNum, pageSize)); |
| | | return R.ok(page); |
| | | } |
| | |
| | | userShop.setShopId(shopId); |
| | | userShop.setRoleType(1); |
| | | userShop.setRoleId(2L); |
| | | userShop.setNickName(sysUser.getNickName()); |
| | | userShop.setNickName(user.getNickName()); |
| | | userShop.setCreateTime(LocalDateTime.now()); |
| | | userShopClient.saveUserShop(userShop); |
| | | } |