X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FController%2FRecordLinks.pm;h=49661cbe030b4a60f33cc0ca9cf39b63a5b6a85f;hb=968c9d8f19707313ef55e58b3955209b9b841da8;hp=fd424b9678b0ae5dc7b5b104f2f00a49ce59d5b6;hpb=6061749dc0ece2873ef61a0c14af1b8a9e46034a;p=kivitendo-erp.git diff --git a/SL/Controller/RecordLinks.pm b/SL/Controller/RecordLinks.pm index fd424b967..49661cbe0 100644 --- a/SL/Controller/RecordLinks.pm +++ b/SL/Controller/RecordLinks.pm @@ -4,11 +4,61 @@ use strict; use parent qw(SL::Controller::Base); +use List::Util qw(first); + +use SL::DB::Helper::Mappings; use SL::DB::Order; use SL::DB::DeliveryOrder; use SL::DB::Invoice; +use SL::DB::Letter; use SL::DB::PurchaseInvoice; +use SL::DB::RecordLink; +use SL::DB::RequirementSpec; +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 +( + scalar => [ qw(object object_model object_id link_type link_direction link_type_desc) ], +); + +__PACKAGE__->run_before('check_auth'); +__PACKAGE__->run_before('check_object_params', only => [ qw(ajax_list ajax_delete ajax_add_select_type ajax_add_filter ajax_add_list ajax_add_do) ]); +__PACKAGE__->run_before('check_link_params', only => [ qw( ajax_add_list ajax_add_do) ]); + +my %link_type_defaults = ( + filter => 'type_filter', + project => 'globalproject', + description => 'transaction_description', + description_title => t8('Transaction description'), + date => 'transdate', +); + +my @link_type_specifics = ( + { title => t8('Requirement spec'), type => 'requirement_spec', model => 'RequirementSpec', number => 'id', project => 'project', description => 'title', date => undef, filter => 'working_copy_filter', }, + { title => t8('Shop Order'), type => 'shop_order', model => 'ShopOrder', number => 'shop_ordernumber', date => 'order_date', project => undef, }, + { 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; # # actions @@ -18,12 +68,19 @@ sub action_ajax_list { my ($self) = @_; eval { - die $::locale->text("Invalid parameters") if (!$::form->{object_id} || ($::form->{object_model} !~ m/^(?:Order|DeliveryOrder|Invoice|PurchaseInvoice)$/)); + 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 $model = 'SL::DB::' . $::form->{object_model}; - my $object = $model->new(id => $::form->{object_id})->load || die $::locale->text("Record not found"); - my $linked_records = $object->linked_records(direction => 'both'); - my $output = SL::Presenter->get->grouped_record_list($linked_records); + my $output = grouped_record_list( + $linked_records, + with_columns => [ qw(record_link_direction) ], + edit_record_links => 1, + object_model => $self->object_model, + object_id => $self->object_id, + ); $self->render(\$output, { layout => 0, process => 0 }); 1; @@ -32,4 +89,183 @@ sub action_ajax_list { }; } +sub action_ajax_delete { + my ($self) = @_; + + foreach my $str (@{ $::form->{record_links_delete} || [] }) { + my ($from_table, $from_id, $to_table, $to_id) = split m/__/, $str, 4; + $from_id *= 1; + $to_id *= 1; + + next if !$from_table || !$from_id || !$to_table || !$to_id; + + SL::DB::Manager::RecordLink->delete_all(where => [ + from_table => $from_table, + from_id => $from_id, + to_table => $to_table, + to_id => $to_id, + ]); + } + + $self->action_ajax_list; +} + +sub action_ajax_add_filter { + my ($self) = @_; + + 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 $is_sales = $self->object->can('customer_id') && $self->object->customer_id; + + $self->render( + 'record_links/add_filter', + { layout => 0 }, + is_sales => $is_sales, + DEFAULT_LINK_TYPE => $is_sales ? 'sales_quotation' : 'request_quotation', + LINK_TYPES => \@link_type_select, + PROJECTS => \@projects, + ); +} + +sub action_ajax_add_list { + my ($self) = @_; + + my $manager = 'SL::DB::Manager::' . $self->link_type_desc->{model}; + 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}; + push @where, ("${vc}.name" => { ilike => like($::form->{vc_name}) }) if $::form->{vc_name}; + 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); + + # show the newest records first (should be better for 80% of the cases TODO sortable click + my $objects = $manager->get_all_sorted(where => \@where, with_objects => \@with_objects, sort_by => 'itime', sort_dir => 'ASC'); + my $output = $self->render( + 'record_links/add_list', + { output => 0 }, + OBJECTS => $objects, + vc => $vc, + number_column => $self->link_type_desc->{number}, + description_column => $description, + description_title => $self->link_type_desc->{description_title}, + project_column => $project, + date_column => $self->link_type_desc->{date}, + ); + + my %result = ( count => scalar(@{ $objects }), html => $output ); + + $self->render(\to_json(\%result), { type => 'json', process => 0 }); +} + +sub action_ajax_add_do { + my ($self, %params) = @_; + + my $object_side = $self->link_direction eq 'from' ? 'from' : 'to'; + my $link_side = $object_side eq 'from' ? 'to' : 'from'; + my $link_table = SL::DB::Helper::Mappings::get_table_for_package($self->link_type_desc->{model}); + + foreach my $link_id (@{ $::form->{link_id} || [] }) { + # Check for existing reverse connections in order to avoid loops. + my @props = ( + "${link_side}_table" => $self->object->meta->table, + "${link_side}_id" => $self->object_id, + "${object_side}_table" => $link_table, + "${object_side}_id" => $link_id, + ); + + my $existing = SL::DB::Manager::RecordLink->get_all(where => \@props, limit => 1)->[0]; + next if $existing; + + # Check for existing connections in order to avoid duplicates. + @props = ( + "${object_side}_table" => $self->object->meta->table, + "${object_side}_id" => $self->object_id, + "${link_side}_table" => $link_table, + "${link_side}_id" => $link_id, + ); + + $existing = SL::DB::Manager::RecordLink->get_all(where => \@props, limit => 1)->[0]; + + SL::DB::RecordLink->new(@props)->save if !$existing; + } + + $self->action_ajax_list; +} + + +# +# filters +# + +sub check_object_params { + my ($self) = @_; + + my %models = map { ($_->{model} => 1 ) } @link_types; + + $self->object_id( $::form->{object_id}); + $self->object_model($::form->{object_model}); + + die "Invalid object_model or object_id" if !$self->object_id || !$models{$self->object_model}; + + my $model = 'SL::DB::' . $self->object_model; + $self->object($model->new(id => $self->object_id)->load || die "Record not found"); + + return 1; +} + +sub check_link_params { + my ($self) = @_; + + $self->link_type( $::form->{link_type}); + $self->link_type_desc((first { $_->{type} eq $::form->{link_type} } @link_types) || die "Invalid link_type"); + $self->link_direction($::form->{link_direction} =~ m/^(?:from|to)$/ ? $::form->{link_direction} : die "Invalid link_direction"); + + return 1; +} + +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;