package com.mzl.flower.service.statistics; 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.response.statistics.SaleStatisticsDTO; import com.mzl.flower.mapper.payment.*; import com.mzl.flower.service.BaseService; import com.mzl.flower.utils.UUIDGenerator; import io.micrometer.core.instrument.util.StringUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.time.LocalDate; import java.time.LocalDateTime; @Slf4j @Service @Transactional public class StatisticsService extends BaseService { @Autowired private OrderMapper orderMapper; @Autowired private OrderItemMapper orderItemMapper; public SaleStatisticsDTO getSaleStatistics(String date){ if(StringUtils.isEmpty(date)){ throw new ValidationException("日期不能为空"); } LocalDate localDate = parseLocalDate(date); if(localDate == null){ throw new ValidationException("日期无效"); } LocalDateTime end = localDate.atTime(17, 0, 0); LocalDateTime begin = end.plusDays(-1); SaleStatisticsDTO dto = new SaleStatisticsDTO(); BigDecimal a = orderMapper.getOrderSaleAmount(begin, end); Integer c = orderItemMapper.getFlowerSaleNum(begin, end); dto.setSaleAmount(a); dto.setSaleFlowerCount(c); return dto; } }