+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;
+}
+
+