可以根据时间、订单号来分页查询

最新推荐文章于 2024-10-11 17:30:36 发布

A1916403680

最新推荐文章于 2024-10-11 17:30:36 发布

阅读量163

点赞数

文章标签： java mybatis 开发语言

本文链接：https://blog.csdn.net/A1916403680/article/details/126904714

版权

    /**
     * 客户端订单分页查询
     * @param page
     * @param pageSize
     * @param number
     * @return
     */
    @GetMapping("/page")
    public R<Page> page(int page, int pageSize, Long number,String beginTime,String endTime){
        Page<Orders> ordersPage = new Page<>(page, pageSize);
        Page<OrdersDto> ordersDtoPage = new Page<>();

        //当前登录用户id
        Long id = BaseContext.getCurrentId();

        LambdaQueryWrapper<Orders> eq = Wrappers.lambdaQuery(Orders.class)
                .eq(Orders::getUserId,id)
                .like(number != null, Orders::getNumber, number)
                .between(beginTime!=null&&endTime!=null,Orders::getCheckoutTime,beginTime,endTime)
                .orderByDesc(Orders::getOrderTime);

        BeanUtils.copyProperties(ordersPage,ordersDtoPage);

        ordersService.page(ordersPage,eq);

        List<Orders> records = ordersPage.getRecords();

        List<OrdersDto> list = records.stream().map((item) -> {
            OrdersDto ordersDto = new OrdersDto();

            //用户id
            Long userId = item.getUserId();

            LambdaQueryWrapper<OrderDetail> eq1 = Wrappers.lambdaQuery(OrderDetail.class)
                    .eq(OrderDetail::getOrderId, userId);

            List<OrderDetail> orderDetails = orderDetailService.list(eq1);
            ordersDto.setOrderDetails(orderDetails);
            BeanUtils.copyProperties(item,ordersDto);

            return ordersDto;
        }).collect(Collectors.toList());

        ordersDtoPage.setRecords(list);

        return R.success(ordersDtoPage);
    }