19 lines
689 B
Python
19 lines
689 B
Python
# 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,
|
|
} |