diff options
-rwxr-xr-x | mat | 5 |
1 files changed, 4 insertions, 1 deletions
@@ -409,7 +409,10 @@ sub cmd_shoppinglist { # } my $entries = $db->selectall_arrayref("SELECT recipe_id FROM plan WHERE date ". - "BETWEEN '".$startdate."' and '".$enddate."'", { Slice => {} }); + "BETWEEN '".$startdate."' and '".$enddate."' and ". + "IFNULL(state, 'null') != 'frozen' and ". + "IFNULL(state, 'null') != 'ready' and ". + "IFNULL(state, 'null') != 'sourced'", { Slice => {} }); my %recipe_count; for my $entry ( @$entries ) { $recipe_count{$entry->{recipe_id}}++; |