Finanzcontrollingbericht: ungültige und inaktive Projekte herausfiltern

diff --git a/SL/Controller/FinancialControllingReport.pm b/SL/Controller/FinancialControllingReport.pm
index 8cfb3c7314495b35de4bdee60ba207580c4b9332..e57599aceb69bb503b39644b9662fbef8ba6bbe5 100644 (file)
--- a/SL/Controller/FinancialControllingReport.pm
+++ b/SL/Controller/FinancialControllingReport.pm
@@ -70,6 +70,12 @@ sub setup_db_args_for_list {
   $args{query} = [
     @{ $args{query} || [] },
     SL::DB::Manager::Order->type_filter('sales_order'),
+    or => [
+      globalproject_id => undef,
+      and              => [
+        'globalproject.active' => 1,
+        'globalproject.valid'  => 1,
+      ]],
   ];
 
   return \%args;