diff options
-rw-r--r-- | inventar/templates/stats.html | 9 | ||||
-rw-r--r-- | inventory/views.py | 1 |
2 files changed, 6 insertions, 4 deletions
diff --git a/inventar/templates/stats.html b/inventar/templates/stats.html index 10829a7..32444f1 100644 --- a/inventar/templates/stats.html +++ b/inventar/templates/stats.html @@ -5,12 +5,13 @@ <h2>Statistics:</h2> <ul> - <li>Number of codes: {{ number_of_codes }} + <li>Number of codes: {{ number_of_codes }}</li> <li>Number of items: {{ number_of_items }} <ul> - <li>with parent: {{ number_of_items_with_parent }} - <li>without parent: {{ number_of_items_without_parent }} - </ul> + <li>with parent: {{ number_of_items_with_parent }}</li> + <li>without parent: {{ number_of_items_without_parent }}</li> + </ul></li> + <li>Item with most barcodes: {{ max_barcodes_item.name }} [<b>{{max_barcodes_item.number_of_attached_barcodes}}</b> Barcodes]</li> </ul> Work in Progress... diff --git a/inventory/views.py b/inventory/views.py index 9f20d06..43ea76d 100644 --- a/inventory/views.py +++ b/inventory/views.py @@ -78,4 +78,5 @@ def stats(request): "number_of_items": models.Item.objects.count(), "number_of_items_with_parent": models.Item.objects.filter(parent__isnull=False).count(), "number_of_items_without_parent": models.Item.objects.filter(parent__isnull=True).count(), + "max_barcodes_item": models.Item.objects.raw('SELECT inventory_item.*, COUNT(inventory_barcode.item_id) AS number_of_attached_barcodes FROM inventory_item INNER JOIN inventory_barcode ON inventory_barcode.item_id = inventory_item.id GROUP BY inventory_barcode.item_id ORDER BY COUNT(inventory_barcode.item_id) DESC LIMIT 1;')[0], }) |