31 lines
1.2 KiB
Python
31 lines
1.2 KiB
Python
from Base.models import Professional , ServiceList
|
|
from Movement.models import Calendar
|
|
# from django.utils import timezone
|
|
from django.db.models import Sum
|
|
|
|
def metric(Day):
|
|
professionals = Professional.objects.all()
|
|
services = ServiceList.objects.all()
|
|
service_movement = Calendar.objects.filter(date=Day).values()
|
|
professionals_report = {}
|
|
for professional in professionals:
|
|
professionals_report[professional.name] = {}
|
|
for service in services:
|
|
service_sum = service_movement.filter(
|
|
professional__name=professional.name,
|
|
service__name=service.name,
|
|
)
|
|
servSum =service_sum.aggregate(Sum('gross_value'))['gross_value__sum'] or 0
|
|
servCont = service_sum.count()
|
|
professionals_report[professional.name][service.name] = {
|
|
'servSum':servSum,
|
|
'servCont':servCont,
|
|
}
|
|
sum_of_prof = sum(
|
|
sum(service['servSum'] for service in services.values())
|
|
for services in professionals_report.values()
|
|
)
|
|
return {
|
|
'professionals_report':professionals_report,
|
|
'sum_of_prof':sum_of_prof,
|
|
} |