package com.boying.service;

import com.boying.common.BaseDao;
import com.boying.common.BaseService;
import com.boying.common.util.DateUtil;
import com.boying.dao.TicketDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.util.Date;

@Service
@Transactional(readOnly = true)
public class TicketService extends BaseService{

    @Autowired
    private TicketDao ticketDao;

    @Override
    @Resource(name="ticketDao")
    protected void setBaseDao(BaseDao baseDao) {
        this.baseDao = baseDao;
    }

    public int count1() {
        long a = ticketDao.count1(DateUtil.getStartTime(),DateUtil.getEndTime());
        return (int)a;
    }

    public int count2() {
        long a = ticketDao.count2(DateUtil.getStartTime(),DateUtil.getEndTime());
        return (int)a;
    }

    public int sumByPrice() {
        Double a = ticketDao.sumByPrice(DateUtil.getStartTime(),DateUtil.getEndTime());
        if(a==null){
            return 0;
        }else{
            return a.intValue();
        }
    }

    public int count3() {
        long a = ticketDao.count1(DateUtil.getMonthStartTime(),DateUtil.getMonthEndTime());
        return (int)a;
    }

    public int sumByPrice2() {
        Double a = ticketDao.sumByPrice(DateUtil.getMonthStartTime(),DateUtil.getMonthEndTime());
        if(a==null){
            return 0;
        }else{
            return a.intValue();
        }
    }

    public int count4() {
        long a = ticketDao.count4()*100;
        long b = ticketDao.count5();
        return (int)(a/b);
    }

    public int count5(int type) {
        if(type==1){
            return (int)ticketDao.count6(DateUtil.getStartTime(),DateUtil.getEndTime());
        }else{
            return (int)ticketDao.count7(DateUtil.getStartTime(),DateUtil.getEndTime());
        }
    }

    public int count6() {
        return (int)ticketDao.count8(DateUtil.getStartTime(),DateUtil.getEndTime());
    }

    public int sumByPrice3() {
        Double a = ticketDao.sumByPrice2(DateUtil.getStartTime(),DateUtil.getEndTime());
        if(a==null){
            return 0;
        }else{
            return a.intValue();
        }
    }
}