查询当前会员的订单情况-待支付-待发货-待收货

OrderController

    /**
     * 查询会员订单各状态数量
     * @return
     */
    @ApiOperation("查询会员订单各状态数量")
    @GetMapping("orderCount")
    public Result<OrderStatusCount> loadMemberOrderStatusCount() {
        OrderStatusCount orderStatusCount = orderService.queryMemberOrderStatusCount();
        return Result.success(orderStatusCount);
    }

创建一个实体类OrderStatusCount

package com.powernode.vo;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * 订单状态数量对象
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@ApiModel("订单状态数量对象")
public class OrderStatusCount {

    @ApiModelProperty("待支付数量")
    private Long unPay;

    @ApiModelProperty("待发货数量")
    private Long payed;

    @ApiModelProperty("待收货数量")
    private Long consignment;
}

OrderServiceImpl

 @Override
    public OrderStatusCount queryMemberOrderStatusCount() {
        // 获取会员openid
        String openId = AuthUtils.getMemberOpenId();
        // 根据会员openid查询待支付订单数量
        Long unPay = orderMapper.selectCount(new LambdaQueryWrapper<Order>()
                .eq(Order::getOpenId, openId)
                .eq(Order::getStatus, 1)
        );

        // 根据会员openid查询待发货订单数量
        Long payed = orderMapper.selectCount(new LambdaQueryWrapper<Order>()
                .eq(Order::getOpenId, openId)
                .eq(Order::getStatus, 2)
        );

        // 根据会员openid查询待收货订单数量
        Long consignment = orderMapper.selectCount(new LambdaQueryWrapper<Order>()
                .eq(Order::getOpenId, openId)
                .eq(Order::getStatus, 3)
        );
        return OrderStatusCount.builder()
                .unPay(unPay).payed(payed).consignment(consignment)
                .build();
    }