Hi, I want to get the Volume subtotal of my "Contracts" field grouped in my
template.
I manage to display the total but not the subtotal.
*models.py*
class TransColisCgDlaDet(models.Model):
id_trans_colis = models.AutoField(primary_key=True)
essence = models.CharField(max_length=15, blank=True, null=True,
verbose_name='Essence')
num_colis = models.CharField(max_length=15, blank=True, null=True,
verbose_name='Numéro de Colis')
cubage = models.DecimalField(max_digits=6, decimal_places=3, blank=True,
null=True, verbose_name='Cubage')
num_contrat = models.CharField(max_length=15, blank=False, null=True,
verbose_name='Numéro de Contrat')
class Meta:
managed = True
db_table = 'TransColisCgDlaDet'
verbose_name = 'Transport de Colis Détaillé '
verbose_name_plural = 'Transports de Colis Détaillés'
ordering = ['num_colis']
def __str__(self):
return str(self.num_colis)
*views.py*
class TransportDetListView(LoginRequiredMixin,ListView):
login_url = 'admin:login'
model = TransColisCgDlaDet
template_name = "transports/trans_detail.html"
paginate_by = 15
def get_queryset(self):
queryset =
TransColisCgDlaDet.objects.filter(code_trans__contains=self.kwargs['code_trans']).order_by('num_contrat','essence','
'num_colis')
lstcolis = queryset.values(
'num_contrat'
).annotate(volcolis=Sum('cubage')).annotate(nb_elts=Sum('nbre_elts'))
return lstcolis
I would the subtotal for the contrats y the template:
Contrat: 2475
-----------------------------------------------------
*Essence / Num Colis / Cubage*
SIPO / 22 / 2,378
SIPO / 23 / 1.251
------------------------------------------------------
Subtotal : 3,629
Contrat: 2500
----------------------------------------------------
*Essence / Num Colis / Cubage*
SAPELLI / 572 / 3.001
SAPELLI / 573 / 1.501
------------------------------------------------------
Subtotal : 4.502
TOTAL: 8.131
Any ideas for how manage this?
Thanks
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9da7cce8-8512-497c-897c-4c35eb53102en%40googlegroups.com.
