diff options
author | Sebastian Reichel <sre@ring0.de> | 2012-07-27 02:16:37 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2012-07-27 02:16:37 +0200 |
commit | 298a58b55028a2901ea04817f72e2d9218c258a4 (patch) | |
tree | 89f39d0319c724a55342064ca13d215ff3feeb83 /inventory | |
parent | f07de9c031d7612b8ca656c34ebce57f6856b6b2 (diff) | |
download | ktt-inventory-system-298a58b55028a2901ea04817f72e2d9218c258a4.tar.bz2 |
blame item with most attached barcodes
Diffstat (limited to 'inventory')
-rw-r--r-- | inventory/views.py | 1 |
1 files changed, 1 insertions, 0 deletions
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], }) |