from django import template
from django.db.models import Sum

from Vial.models import  InformeDetalle

register = template.Library()

@register.filter
def a_punto(value):
    return str(value).replace(",",".")

@register.simple_tag
def suma(color, id):
    det=InformeDetalle.objects.filter(informe_id=id, color=color).aggregate(Sum('total'))['total__sum']
    print(color, id, det)

    if det:
        return round(det,2)
    else:
        return 0.00

@register.simple_tag
def div40(color, id):
    det = InformeDetalle.objects.filter(informe_id=id, color=color).aggregate(Sum('total'))['total__sum']
    if det:
        return round((det/40),2)
    else:
        return 0.00

@register.filter
def div40_c(value):
    return value/40