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;
|
}
|
}
|
