package com.boying.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.boying.entity.OrderRecord;
import com.boying.mapper.OrderRecordMapper;
import com.boying.service.OrderRecordService;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.Map;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName OrderRecordServiceImpl.java
 * @Description TODO
 * @createTime 2022年11月21日 08:34:00
 */
@Service
public class OrderRecordServiceImpl extends ServiceImpl<OrderRecordMapper, OrderRecord> implements OrderRecordService {
    @Override
    public long countByYear(Date yearFirst, Date yearLast) {
        QueryWrapper<OrderRecord> wrapper =new QueryWrapper<>();
        wrapper.lambda()
                .eq(OrderRecord::getType,0)
                .between(OrderRecord::getCreateTime,yearFirst,yearLast);
        return count(wrapper);
    }

    @Override
    public Double sumByYear(Date yearFirst, Date yearLast) {
        QueryWrapper<OrderRecord> wrapper =new QueryWrapper<>();
        wrapper.select("IFNULL(SUM(money),0) as money");
        wrapper.lambda()
                .eq(OrderRecord::getType,0)
                .eq(OrderRecord::getStatus,1)
                .between(OrderRecord::getCreateTime,yearFirst,yearLast);
        Map<String, Object> map = getMap(wrapper);
        return Double.valueOf(map.get("money").toString());
    }
}