1 package SL::Controller::RecordLinks;
5 use parent qw(SL::Controller::Base);
7 use List::Util qw(first);
9 use SL::DB::Helper::Mappings;
11 use SL::DB::DeliveryOrder;
14 use SL::DB::PurchaseInvoice;
15 use SL::DB::RecordLink;
16 use SL::DB::RequirementSpec;
17 use SL::DBUtils qw(like);
18 use SL::DB::ShopOrder;
20 use SL::Locale::String;
21 use SL::Presenter::Record qw(grouped_record_list);
23 use Rose::Object::MakeMethods::Generic
25 scalar => [ qw(object object_model object_id link_type link_direction link_type_desc) ],
28 __PACKAGE__->run_before('check_auth');
29 __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) ]);
30 __PACKAGE__->run_before('check_link_params', only => [ qw( ajax_add_list ajax_add_do) ]);
32 my %link_type_defaults = (
33 filter => 'type_filter',
34 project => 'globalproject',
35 description => 'transaction_description',
36 description_title => t8('Transaction description'),
40 my @link_type_specifics = (
41 { title => t8('Requirement spec'), type => 'requirement_spec', model => 'RequirementSpec', number => 'id', project => 'project', description => 'title', date => undef, filter => 'working_copy_filter', },
42 { title => t8('Shop Order'), type => 'shop_order', model => 'ShopOrder', number => 'shop_ordernumber', date => 'order_date', project => undef, },
43 { title => t8('Sales quotation'), type => 'sales_quotation', model => 'Order', number => 'quonumber', },
44 { title => t8('Sales Order'), type => 'sales_order', model => 'Order', number => 'ordnumber', },
45 { title => t8('Sales delivery order'), type => 'sales_delivery_order', model => 'DeliveryOrder', number => 'donumber', },
46 { title => t8('Sales Invoice'), type => 'invoice', model => 'Invoice', number => 'invnumber', },
47 { title => t8('Request for Quotation'), type => 'request_quotation', model => 'Order', number => 'quonumber', },
48 { title => t8('Purchase Order'), type => 'purchase_order', model => 'Order', number => 'ordnumber', },
49 { title => t8('Purchase delivery order'), type => 'purchase_delivery_order', model => 'DeliveryOrder', number => 'donumber', },
50 { title => t8('Purchase Invoice'), type => 'purchase_invoice', model => 'PurchaseInvoice', number => 'invnumber', },
51 { title => t8('Letter'), type => 'letter', model => 'Letter', number => 'letternumber', description => 'subject', description_title => t8('Subject'), date => 'date', project => undef },
54 my @link_types = map { +{ %link_type_defaults, %{ $_ } } } @link_type_specifics;
60 sub action_ajax_list {
64 my $linked_records = $self->object->linked_records(direction => 'both', recursive => 1, save_path => 1);
65 push @{ $linked_records }, $self->object->sepa_export_items if $self->object->can('sepa_export_items');
67 my $output = grouped_record_list(
69 with_columns => [ qw(record_link_direction) ],
70 edit_record_links => 1,
71 object_model => $self->object_model,
72 object_id => $self->object_id,
74 $self->render(\$output, { layout => 0, process => 0 });
78 $self->render('generic/error', { layout => 0 }, label_error => $@);
82 sub action_ajax_delete {
85 foreach my $str (@{ $::form->{record_links_delete} || [] }) {
86 my ($from_table, $from_id, $to_table, $to_id) = split m/__/, $str, 4;
90 next if !$from_table || !$from_id || !$to_table || !$to_id;
92 SL::DB::Manager::RecordLink->delete_all(where => [
93 from_table => $from_table,
95 to_table => $to_table,
100 $self->action_ajax_list;
103 sub action_ajax_add_filter {
106 my $presenter = $self->presenter;
108 my @link_type_select = map { [ $_->{type}, $_->{title} ] } @link_types;
109 my @projects = map { [ $_->id, $presenter->project($_, display => 'inline', style => 'both', no_link => 1) ] } @{ SL::DB::Manager::Project->get_all_sorted };
110 my $is_sales = $self->object->can('customer_id') && $self->object->customer_id;
113 'record_links/add_filter',
115 is_sales => $is_sales,
116 DEFAULT_LINK_TYPE => $is_sales ? 'sales_quotation' : 'request_quotation',
117 LINK_TYPES => \@link_type_select,
118 PROJECTS => \@projects,
122 sub action_ajax_add_list {
125 my $manager = 'SL::DB::Manager::' . $self->link_type_desc->{model};
126 my $vc = $self->link_type =~ m/shop|sales_|^invoice|requirement_spec|letter/ ? 'customer' : 'vendor';
127 my $project = $self->link_type_desc->{project};
128 my $project_id = "${project}_id";
129 my $description = $self->link_type_desc->{description};
130 my $filter = $self->link_type_desc->{filter};
132 my @where = $filter && $manager->can($filter) ? $manager->$filter($self->link_type) : ();
133 push @where, ("${vc}.${vc}number" => { ilike => like($::form->{vc_number}) }) if $::form->{vc_number};
134 push @where, ("${vc}.name" => { ilike => like($::form->{vc_name}) }) if $::form->{vc_name};
135 push @where, ($description => { ilike => like($::form->{transaction_description}) }) if $::form->{transaction_description};
136 push @where, ($project_id => $::form->{globalproject_id}) if $::form->{globalproject_id} && $manager->can($project_id);
138 my @with_objects = ($vc);
139 push @with_objects, $project if $manager->can($project_id);
141 # show the newest records first (should be better for 80% of the cases TODO sortable click
142 my $objects = $manager->get_all_sorted(where => \@where, with_objects => \@with_objects, sort_by => 'itime', sort_dir => 'ASC');
143 my $output = $self->render(
144 'record_links/add_list',
148 number_column => $self->link_type_desc->{number},
149 description_column => $description,
150 description_title => $self->link_type_desc->{description_title},
151 project_column => $project,
152 date_column => $self->link_type_desc->{date},
155 my %result = ( count => scalar(@{ $objects }), html => $output );
157 $self->render(\to_json(\%result), { type => 'json', process => 0 });
160 sub action_ajax_add_do {
161 my ($self, %params) = @_;
163 my $object_side = $self->link_direction eq 'from' ? 'from' : 'to';
164 my $link_side = $object_side eq 'from' ? 'to' : 'from';
165 my $link_table = SL::DB::Helper::Mappings::get_table_for_package($self->link_type_desc->{model});
167 foreach my $link_id (@{ $::form->{link_id} || [] }) {
168 # Check for existing reverse connections in order to avoid loops.
170 "${link_side}_table" => $self->object->meta->table,
171 "${link_side}_id" => $self->object_id,
172 "${object_side}_table" => $link_table,
173 "${object_side}_id" => $link_id,
176 my $existing = SL::DB::Manager::RecordLink->get_all(where => \@props, limit => 1)->[0];
179 # Check for existing connections in order to avoid duplicates.
181 "${object_side}_table" => $self->object->meta->table,
182 "${object_side}_id" => $self->object_id,
183 "${link_side}_table" => $link_table,
184 "${link_side}_id" => $link_id,
187 $existing = SL::DB::Manager::RecordLink->get_all(where => \@props, limit => 1)->[0];
189 SL::DB::RecordLink->new(@props)->save if !$existing;
192 $self->action_ajax_list;
200 sub check_object_params {
203 my %models = map { ($_->{model} => 1 ) } @link_types;
205 $self->object_id( $::form->{object_id});
206 $self->object_model($::form->{object_model});
208 die "Invalid object_model or object_id" if !$self->object_id || !$models{$self->object_model};
210 my $model = 'SL::DB::' . $self->object_model;
211 $self->object($model->new(id => $self->object_id)->load || die "Record not found");
216 sub check_link_params {
219 $self->link_type( $::form->{link_type});
220 $self->link_type_desc((first { $_->{type} eq $::form->{link_type} } @link_types) || die "Invalid link_type");
221 $self->link_direction($::form->{link_direction} =~ m/^(?:from|to)$/ ? $::form->{link_direction} : die "Invalid link_direction");
227 $::auth->assert('record_links');