package com.boying.service.impl;

import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.boying.entity.OutPark;
import com.boying.entity.Statistic;
import com.boying.mapper.OutParkMapper;
import com.boying.mapper.StatisticMapper;
import com.boying.service.OutParkService;
import com.boying.service.StatisticService;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

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

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName OutParkServiceImpl.java
 * @Description TODO
 * @createTime 2022年11月20日 10:20:00
 */
@Service
@AllArgsConstructor
public class OutParkServiceImpl extends ServiceImpl<OutParkMapper, OutPark> implements OutParkService {
    private final OutParkMapper outParkMapper;

    @Override
    public int count1() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
                .eq(OutPark::getStatus,1);
        return outParkMapper.selectCount(wrapper);
    }

    @Override
    public int count2() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
                .ge(OutPark::getPrice,0);
        return outParkMapper.selectCount(wrapper);
    }

    @Override
    public int count5() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()));
        return outParkMapper.selectCount(wrapper);
    }

    @Override
    public double sumByPrice() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfDay(new Date()),DateUtil.endOfDay(new Date()))
                        .eq(OutPark::getStatus,1);
        wrapper.select("IFNULL(ROUND(SUM(price)),0) as num");
        Map<String, Object> map = getMap(wrapper);
        String a = map.get("num").toString();
        if(a!=null){
            return Double.parseDouble(a);
        }else{
            return 0.0;
        }
    }

    @Override
    public int count3() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfMonth(new Date()),DateUtil.endOfMonth(new Date()));
        return outParkMapper.selectCount(wrapper);
    }

    @Override
    public double sumByPrice2() {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .between(OutPark::getCreateTime, DateUtil.beginOfMonth(new Date()),DateUtil.endOfMonth(new Date()))
                        .eq(OutPark::getStatus,1);
        wrapper.select("IFNULL(ROUND(SUM(price)),0) as num");
        Map<String, Object> map = getMap(wrapper);
        String a = map.get("num").toString();
        if(a!=null){
            return Double.parseDouble(a);
        }else{
            return 0.0;
        }
    }

    @Override
    public OutPark findByCarNo(String serialno) {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(OutPark::getCarNo,serialno);
        List<OutPark> outParks = outParkMapper.selectList(wrapper);
        if(outParks.size()>0){
            return outParks.get(0);
        }else{
            return null;
        }
    }

    @Override
    public OutPark count4(Integer bId) {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(OutPark::getBarrierId,bId)
                .eq(OutPark::getStatus,1)
                .eq(OutPark::getStatus2,0)
                .orderByDesc(OutPark::getCreateTime);
        List<OutPark> outParks = outParkMapper.selectList(wrapper);
        if(outParks.size()>0){
            return outParks.get(0);
        }else{
            return null;
        }
    }

    @Override
    public OutPark findByCarNoAndBarrierId(String carNo, Integer id) {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(OutPark::getBarrierId,id)
                .eq(OutPark::getCarNo,carNo)
                .orderByDesc(OutPark::getCreateTime);
        List<OutPark> outParks = outParkMapper.selectList(wrapper);
        if(outParks.size()>0){
            return outParks.get(0);
        }else{
            return null;
        }
    }

    @Override
    public OutPark findByPayCode(String payCode) {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(OutPark::getCode2,payCode)
                .orderByDesc(OutPark::getCreateTime);
        List<OutPark> outParks = outParkMapper.selectList(wrapper);
        if(outParks.size()>0){
            return outParks.get(0);
        }else{
            return null;
        }
    }

    @Override
    public OutPark findByOrderId(String txnOrderId) {
        QueryWrapper<OutPark> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(OutPark::getTxnOrderId,txnOrderId)
                .orderByDesc(OutPark::getCreateTime);
        List<OutPark> outParks = outParkMapper.selectList(wrapper);
        if(outParks.size()>0){
            return outParks.get(0);
        }else{
            return null;
        }
    }

    @Override
    public List<OutPark> getList(long current, long size, String carNo, Long parkId, String payCode, String date) {
       // return outParkMapper.getList((current-1)*size,size,carNo,parkId,payCode,date);
        return null;
    }

    @Override
    public long getCount(String carNo, Long parkId, String payCode, String date) {
       // return outParkMapper.getCount(carNo,parkId,payCode,date);
        return 0;
    }
}