def get(self, request, *args, **kwargs):
# Now generate the first dashboard datastructure
months = get_months_header()
# Get enganche by Unidad
clients = Client.objects.all()
# Now separate by it's needed parameters
clients_by_status = (
clients.filter(payment__status="Actual").exclude(payment__status__in=("Pagado", "Vencido")).distinct()
)
# Now get the totals
total_pagados = clients.filter(payment__status="Pagado").distinct()
total_vencido = clients.filter(payment__status="Vencido").distinct()
print "total_pagados %d" % len(total_pagados)
print "total_vencido %d" % len(total_vencido)
object_list = SortedDict()
object_list["Actual"] = clients_by_status
ctx = {
"months": months,
"object_list": object_list,
"total_pagados": total_pagados,
"total_vencido": total_vencido,
}
return self.render_to_response(ctx)
def get_queryset(self):
date = self.request.GET.get("date", None)
status = self.request.GET.get("status", None)
query = Q()
if date and date != "NONE":
month, year = date.split(" ")
query = query & Q(payment__date_due__month=MONTHS_DICT[month], payment__date_due__year=year)
if status:
if not date and date != "NONE":
months_to_check = get_months_header()
query = query & self.get_date_query(months_to_check)
query = query & Q(payment__status=status)
return self.model.objects.filter(query).distinct()
