+sub init_project_types { SL::DB::Manager::ProjectType->get_all_sorted }
+
+sub init_models {
+ my ($self) = @_;
+
+ SL::Controller::Helper::GetModels->new(
+ controller => $self,
+ model => 'Order',
+ sorted => {
+ _default => {
+ by => 'globalprojectnumber',
+ dir => 1,
+ },
+ %sort_columns,
+ },
+ query => [
+ SL::DB::Manager::Order->type_filter('sales_order'),
+ '!closed' => 1,
+ (salesman_id => SL::DB::Manager::Employee->current->id) x !$::auth->assert('sales_all_edit', 1),
+ or => [
+ globalproject_id => undef,
+ and => [
+ 'globalproject.active' => 1,
+ 'globalproject.valid' => 1,
+ ]],
+ # keine WR
+ # oder aber (WR aktiv und (kein enddatum oder enddatum noch nicht überschritten))
+ or => [
+ 'periodic_invoices_config.id' => undef,
+ # and => [
+ 'periodic_invoices_config.active' => 1,
+ # or => [
+ # 'periodic_invoices_config.end_date' => undef,
+ # 'periodic_invoices_config.end_date' => { le => DateTime->today_local },
+ # ]
+ # ]
+ ],
+ ],
+ with_objects => [ 'customer', 'globalproject', 'globalproject.project_type', 'periodic_invoices_config' ],
+ );
+}
+