统计 待发货 在售商品 待审核商品 待售后处理

Cui Zhi Feng

2024-10-23 c6908e1d2efd4f3a1fcfdb1af7f1b78156d07d91

 src/main/java/com/mzl/flower/service/statistics/StatisticsService.java

@@ -3,7 +3,10 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mzl.flower.config.exception.ValidationException;
import com.mzl.flower.constant.Constants;
import com.mzl.flower.dto.request.flower.FlowerQueryDTO;
import com.mzl.flower.dto.request.payment.OrderItemSalesQueryDTO;
import com.mzl.flower.dto.request.payment.OrderQueryDTO;
import com.mzl.flower.dto.response.flower.FlowerListDTO;
import com.mzl.flower.dto.response.statistics.FlowerStatisticsDTO;
import com.mzl.flower.dto.response.statistics.SaleStatisticsDTO;
@@ -22,6 +25,7 @@
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

@Slf4j
@@ -40,6 +44,9 @@

    @Autowired
    private SupplierMapper supplierMapper;

    @Autowired
    private OrderItemSalesMapper orderItemSalesMapper;

    public SaleStatisticsDTO getSaleStatistics(String date){
        if(StringUtils.isEmpty(date)){
@@ -68,6 +75,12 @@

        Page page = new Page(1, 1);
        FlowerQueryDTO q = new FlowerQueryDTO();
        List<String> statusList = new ArrayList<>();
        statusList.add(Constants.FLOWER_STATUS.PENDING.name());
        statusList.add(Constants.FLOWER_STATUS.UP.name());
        statusList.add(Constants.FLOWER_STATUS.OFF.name());
        statusList.add(Constants.FLOWER_STATUS.FORCE_OFF.name());
        q.setStatusList(statusList);
        flowerMapper.selectFlowerList(page, q);
        dto.setFlowerCount((int)page.getTotal());

@@ -84,6 +97,34 @@
                .isNull("refund_time"));
        dto.setOrderCount(oc);

        page = new Page(1, 1);
        OrderQueryDTO oq = new OrderQueryDTO();
        oq.setStatusBackend(Constants.ORDER_STATUS_BACKEND.SEND.name());
        orderMapper.selectOrderList(page, oq);
        dto.setOrderSendCount((int)page.getTotal());

        page = new Page(1, 1);
        q = new FlowerQueryDTO();
        statusList = new ArrayList<>();
        statusList.add(Constants.FLOWER_STATUS.UP.name());
        q.setStatusList(statusList);
        flowerMapper.selectFlowerList(page, q);
        dto.setFlowerUpCount((int)page.getTotal());

        page = new Page(1, 1);
        q = new FlowerQueryDTO();
        statusList = new ArrayList<>();
        statusList.add(Constants.FLOWER_STATUS.PENDING.name());
        q.setStatusList(statusList);
        flowerMapper.selectFlowerList(page, q);
        dto.setFlowerPendingCount((int)page.getTotal());

        page = new Page(1, 1);
        OrderItemSalesQueryDTO sq = new OrderItemSalesQueryDTO();
        sq.setStatus(Constants.ORDER_SALES_STATUS.PENDING.name());
        orderItemSalesMapper.selectItemSalesList(page, sq);
        dto.setOrderSalesCount((int)page.getTotal());

        return dto;
    }
}