Merge remote-tracking branch 'origin/master'
| | |
| | | @PostMapping("/editAppUserById") |
| | | public R<Void> editAppUserById(@RequestBody AppUser appUser) { |
| | | appUserService.updateById(appUser); |
| | | appUserService.update(new LambdaUpdateWrapper<AppUser>().eq(AppUser::getId, appUser.getId()) |
| | | .set(AppUser::getLastShopTime, appUser.getLastShopTime())); |
| | | return R.ok(); |
| | | |
| | | } |
| | |
| | | @GetMapping("/user/list") |
| | | @ApiOperation(value = "积分管理-用户积分明细(必传用户id)", tags = "后台") |
| | | public R<Page<UserPoint>> userlist(UserPoint userPoint) { |
| | | Page<UserPoint> page = userPointService.lambdaQuery().eq(UserPoint::getAppUserId, userPoint.getAppUserId()).orderByDesc(UserPoint::getCreateTime).page(Page.of(userPoint.getPageNum(), userPoint.getPageSize())); |
| | | Page<UserPoint> page = userPointService.lambdaQuery() |
| | | .eq(UserPoint::getType, userPoint.getType()) |
| | | .eq(UserPoint::getAppUserId, userPoint.getAppUserId()) |
| | | .orderByDesc(UserPoint::getCreateTime) |
| | | .page(Page.of(userPoint.getPageNum(), userPoint.getPageSize())); |
| | | for (UserPoint record : page.getRecords()) { |
| | | int i = record.getHistoricalPoint() - record.getBalance(); |
| | | if (i>0){ |
| | |
| | | @Data |
| | | public class WithQuery { |
| | | @ApiModelProperty("用户名称") |
| | | private String name; |
| | | private String userName; |
| | | |
| | | @ApiModelProperty("电话") |
| | | private String phone; |
| | |
| | | <if test="withQuery.phone != null and withQuery.phone != ''"> |
| | | AND t2.phone LIKE concat('%',#{withQuery.phone},'%') |
| | | </if> |
| | | <if test="withQuery.name != null and withQuery.name != ''"> |
| | | AND t2.phone LIKE concat('%',#{withQuery.name},'%') |
| | | <if test="withQuery.userName != null and withQuery.userName != ''"> |
| | | AND t2.name LIKE concat('%',#{withQuery.userName},'%') |
| | | </if> |
| | | order by t1.create_time desc |
| | | </select> |
| | |
| | | appUser.setBalance(balance.add(paymentAmount).setScale(2, RoundingMode.HALF_EVEN)); |
| | | appUser.setShopAmount(appUser.getShopAmount().subtract(paymentAmount).setScale(2, RoundingMode.HALF_EVEN)); |
| | | //查询最后一次的消费订单 |
| | | Order order1 = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getAppUserId, order.getAppUserId()).eq(Order::getPayStatus, 2).eq(Order::getDelFlag, 0).in(Order::getOrderStatus, Arrays.asList(2, 3, 4, 8)).ne(Order::getId, order.getId()).last(" order by create_time desc limit 0, 1")); |
| | | Order order1 = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getAppUserId, order.getAppUserId()).eq(Order::getPayStatus, 2) |
| | | .eq(Order::getDelFlag, 0).in(Order::getOrderStatus, Arrays.asList(1, 2, 3, 4, 8)).ne(Order::getId, order.getId()).last(" order by create_time desc limit 0, 1")); |
| | | if(null != order1){ |
| | | appUser.setLastShopTime(order1.getCreateTime()); |
| | | }else{ |
| | | appUser.setLastShopTime(LocalDateTime.MIN); |
| | | appUser.setLastShopTime(null); |
| | | } |
| | | |
| | | //构建账户余额流水明细 |