From f4ebbc7557f3d97ef5fd25c9a7052532e33a7470 Mon Sep 17 00:00:00 2001
From: cos <cos>
Date: Sat, 10 Jan 2015 20:23:17 +0100
Subject: Order inventory by preparation date.

---
 mat | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mat b/mat
index 45ce51d..8e86cc2 100755
--- a/mat
+++ b/mat
@@ -185,7 +185,7 @@ sub cmd_inventory {
 
   my $sql = "SELECT recipe_id, count(recipe_id), storage FROM inventory";
   $sql .= " WHERE storage='$storage'" if ( $storage );
-  $sql .= " GROUP BY storage, recipe_id";
+  $sql .= " GROUP BY storage, preparation_date, recipe_id";
 
   my $all = $db->selectall_arrayref($sql);
   foreach my $row (@$all) {
-- 
cgit v1.2.3