# from django.utils import timezone
from django.db.models import Sum
from Base.models import Professional
from Movement.models import Calendar

def metric(Day):
    professionals = Professional.objects.all()
    professionals_report = {}
    for professional in professionals:
        service = Calendar.objects.filter(
            professional__name=professional.name,
            date=Day
        ).aggregate(Sum('gross_value'))['gross_value__sum'] or 0
        professionals_report[professional.name] = service
    sum_of_professionals = sum(professionals_report.values()) or 0
    return {
        'professional':professionals_report,
        'sum_all_prof':sum_of_professionals,
    }