X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FRecordLinks.pm;h=49661cbe030b4a60f33cc0ca9cf39b63a5b6a85f;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=b477ba22e096ff9b4a58cd515e4a8ce2fc378ba5;hpb=255d89a0ff95321a926f15b963641750fe7d1c97;p=kivitendo-erp.git diff --git a/SL/Controller/RecordLinks.pm b/SL/Controller/RecordLinks.pm index b477ba22e..49661cbe0 100644 --- a/SL/Controller/RecordLinks.pm +++ b/SL/Controller/RecordLinks.pm @@ -18,6 +18,7 @@ use SL::DBUtils qw(like); use SL::DB::ShopOrder; use SL::JSON; use SL::Locale::String; +use SL::Presenter::Record qw(grouped_record_list); use Rose::Object::MakeMethods::Generic ( @@ -42,12 +43,19 @@ my @link_type_specifics = ( { title => t8('Sales quotation'), type => 'sales_quotation', model => 'Order', number => 'quonumber', }, { title => t8('Sales Order'), type => 'sales_order', model => 'Order', number => 'ordnumber', }, { title => t8('Sales delivery order'), type => 'sales_delivery_order', model => 'DeliveryOrder', number => 'donumber', }, + { title => t8('RMA delivery order'), type => 'rma_delivery_order', model => 'DeliveryOrder', number => 'rdonumber', }, { title => t8('Sales Invoice'), type => 'invoice', model => 'Invoice', number => 'invnumber', }, { title => t8('Request for Quotation'), type => 'request_quotation', model => 'Order', number => 'quonumber', }, { title => t8('Purchase Order'), type => 'purchase_order', model => 'Order', number => 'ordnumber', }, { title => t8('Purchase delivery order'), type => 'purchase_delivery_order', model => 'DeliveryOrder', number => 'donumber', }, + { title => t8('Supplier delivery order'), type => 'supplier_delivery_order', model => 'DeliveryOrder', number => 'sdonumber', }, { title => t8('Purchase Invoice'), type => 'purchase_invoice', model => 'PurchaseInvoice', number => 'invnumber', }, { title => t8('Letter'), type => 'letter', model => 'Letter', number => 'letternumber', description => 'subject', description_title => t8('Subject'), date => 'date', project => undef }, + { title => t8('Email'), type => 'email_journal', model => 'EmailJournal', number => 'id', description => 'subject', description_title => t8('Subject'), }, + { title => t8('AR Transaction'), type => 'ar_transaction', model => 'Invoice', number => 'invnumber', }, + { title => t8('AP Transaction'), type => 'ap_transaction', model => 'PurchaseInvoice', number => 'invnumber', }, + { title => t8('Dunning'), type => 'dunning', model => 'Dunning', number => 'dunning_id', }, + { title => t8('GL Transaction'), type => 'gl_transaction', model => 'GLTransaction', number => 'reference', }, ); my @link_types = map { +{ %link_type_defaults, %{ $_ } } } @link_type_specifics; @@ -60,10 +68,13 @@ sub action_ajax_list { my ($self) = @_; eval { - my $linked_records = $self->object->linked_records(direction => 'both', recursive => 1, save_path => 1); + my $linked_records = ($::instance_conf->get_always_record_links_from_order && ref $self->object ne 'SL::DB::Order') + ? $self->get_order_centric_linked_records + : $self->object->linked_records(direction => 'both', recursive => 1, save_path => 1); + push @{ $linked_records }, $self->object->sepa_export_items if $self->object->can('sepa_export_items'); - my $output = SL::Presenter->get->grouped_record_list( + my $output = grouped_record_list( $linked_records, with_columns => [ qw(record_link_direction) ], edit_record_links => 1, @@ -105,7 +116,7 @@ sub action_ajax_add_filter { my $presenter = $self->presenter; my @link_type_select = map { [ $_->{type}, $_->{title} ] } @link_types; - my @projects = map { [ $_->id, $presenter->project($_, display => 'inline', style => 'both', no_link => 1) ] } @{ SL::DB::Manager::Project->get_all_sorted }; + my @projects = map { [ $_->id, $_->presenter->project(display => 'inline', style => 'both', no_link => 1) ] } @{ SL::DB::Manager::Project->get_all_sorted }; my $is_sales = $self->object->can('customer_id') && $self->object->customer_id; $self->render( @@ -122,11 +133,12 @@ sub action_ajax_add_list { my ($self) = @_; my $manager = 'SL::DB::Manager::' . $self->link_type_desc->{model}; - my $vc = $self->link_type =~ m/sales_|^invoice|requirement_spec|letter/ ? 'customer' : 'vendor'; + my $vc = $self->link_type =~ m/shop|sales_|^invoice|requirement_spec|letter|^ar_/ ? 'customer' : 'vendor'; my $project = $self->link_type_desc->{project}; my $project_id = "${project}_id"; my $description = $self->link_type_desc->{description}; my $filter = $self->link_type_desc->{filter}; + my $number = $self->link_type_desc->{number}; my @where = $filter && $manager->can($filter) ? $manager->$filter($self->link_type) : (); push @where, ("${vc}.${vc}number" => { ilike => like($::form->{vc_number}) }) if $::form->{vc_number}; @@ -134,6 +146,16 @@ sub action_ajax_add_list { push @where, ($description => { ilike => like($::form->{transaction_description}) }) if $::form->{transaction_description}; push @where, ($project_id => $::form->{globalproject_id}) if $::form->{globalproject_id} && $manager->can($project_id); + if ($::form->{number}) { + my $class = 'SL::DB::' . $self->link_type_desc->{model}; + my $col_type = ref $class->meta->column($number); + if ($col_type =~ /^Rose::DB::Object::Metadata::Column::(?:Integer|Serial)$/) { + push @where, ($number => $::form->{number}); + } elsif ($col_type =~ /^Rose::DB::Object::Metadata::Column::Text$/) { + push @where, ($number => { ilike => like($::form->{number}) }); + } + } + my @with_objects = ($vc); push @with_objects, $project if $manager->can($project_id); @@ -226,4 +248,24 @@ sub check_auth { $::auth->assert('record_links'); } +# internal + +sub get_order_centric_linked_records { + my ($self) = @_; + + my $all_linked_records = $self->object->linked_records(direction => 'from', recursive => 1); + my $filtered_orders = [ grep { 'SL::DB::Order' eq ref $_ && $_->is_type('sales_order') } @$all_linked_records ]; + + # no orders no call to linked_records via batch mode + # but instead return default list + return $self->object->linked_records(direction => 'both', recursive => 1, save_path => 1) + unless scalar @$filtered_orders; + + # we have a order, therefore get the tree view from the top (order) + my $id_ref = [ map { $_->id } @$filtered_orders ]; + my $linked_records = SL::DB::Order->new->linked_records(direction => 'to', recursive => 1, batch => $id_ref); + push @{ $linked_records }, @$filtered_orders; + + return $linked_records; +} 1;