Django: Show report earnings and expenses of a Django management system

Question

I have a management system in Jango and would like to save in one place the report of all winnings (Paid=True), defaults (Paid=False) and expenses of the month or period in Jango admin itself, in a template or in a PDF document.

class MovDiario(models.Model):
    cliente = models.ForeignKey('Cliente', on_delete=models.CASCADE)
    veiculo = models.ForeignKey('Veiculo', on_delete=models.CASCADE)
    placa = models.CharField(max_length=10)
    servico = models.ManyToManyField('Servico')
    valor = models.DecimalField(max_digits=6, decimal_places=2, blank=True, null=True)
    pagamento = models.ForeignKey('FormPagamento', on_delete=models.CASCADE, blank=True, null=True)
    pago = models.BooleanField(default=False)
    entregue = models.BooleanField(default=False)

I want to know mainly how I can access the sum of all amounts paid to make a financial statement

Answer 1

Hello live a way to get the sum, it’s like this:

In Python 2:

from django.db.models import Sum
total = MovDiario.objects.filter(pago=True).aggregate(Sum('valor')).values()[0]

In Python 3:

from django.db.models import Sum
valor_pago = list(MovDiario.objects.filter(pago=True).aggregate(Sum('valor')).values())[0]