5 use List::Util qw(first);
12 $main::lxdebug->enter_sub();
17 my $myconfig = \%main::myconfig;
18 my $form = $main::form;
20 my $dbh = $params{dbh} || $form->get_standard_dbh($myconfig);
24 ($params{id}) = selectrow_query($form, $dbh, qq|SELECT nextval('follow_up_id')|);
26 $query = qq|INSERT INTO follow_ups (created_by, done, note_id, follow_up_date, created_for_user, id)
27 VALUES ((SELECT id FROM employee WHERE login = ?), ?, ?, ?, ?, ?)|;
29 push @values, $form->{login};
32 $query = qq|UPDATE follow_ups SET done = ?, note_id = ?, follow_up_date = ?, created_for_user = ? WHERE id = ?|;
35 $params{note_id} = Notes->save('id' => $params{note_id},
36 'trans_id' => $params{id},
37 'trans_module' => 'fu',
38 'subject' => $params{subject},
39 'body' => $params{body});
41 $params{done} = 1 if (!defined $params{done});
43 do_query($form, $dbh, $query, @values, $params{done} ? 't' : 'f', conv_i($params{note_id}), $params{follow_up_date}, conv_i($params{created_for_user}), conv_i($params{id}));
45 do_query($form, $dbh, qq|DELETE FROM follow_up_links WHERE follow_up_id = ?|, conv_i($params{id}));
47 my $query = qq|INSERT INTO follow_up_links (follow_up_id, trans_id, trans_type, trans_info) VALUES (?, ?, ?, ?)|;
48 my $sth = prepare_query($form, $dbh, $query);
50 foreach my $link (@{ $params{LINKS} }) {
51 do_statement($form, $sth, $query, conv_i($params{id}), conv_i($link->{trans_id}), $link->{trans_type}, $link->{trans_info});
56 $dbh->commit() unless ($params{dbh});
58 $main::lxdebug->leave_sub();
62 $main::lxdebug->enter_sub();
67 Common::check_params(\%params, 'id');
69 my $myconfig = \%main::myconfig;
70 my $form = $main::form;
72 my $dbh = $form->get_standard_dbh($myconfig);
74 do_query($form, $dbh, qq|UPDATE follow_ups SET done = TRUE WHERE id = ?|, conv_i($params{id}));
78 $main::lxdebug->leave_sub();
82 $main::lxdebug->enter_sub();
87 Common::check_params(\%params, 'id');
89 my $myconfig = \%main::myconfig;
90 my $form = $main::form;
92 my $dbh = $form->get_standard_dbh($myconfig);
94 my $id = conv_i($params{id});
96 do_query($form, $dbh, qq|DELETE FROM follow_up_links WHERE follow_up_id = ?|, $id);
97 do_query($form, $dbh, qq|DELETE FROM follow_ups WHERE id = ?|, $id);
98 do_query($form, $dbh, qq|DELETE FROM notes WHERE (trans_id = ?) AND (trans_module = 'fu')|, $id);
102 $main::lxdebug->leave_sub();
106 $main::lxdebug->enter_sub();
111 Common::check_params(\%params, 'id');
113 my $myconfig = \%main::myconfig;
114 my $form = $main::form;
116 my $dbh = $form->get_standard_dbh($myconfig);
117 my ($query, @values);
119 my ($employee_id) = selectrow_query($form, $dbh, qq|SELECT id FROM employee WHERE login = ?|, $form->{login});
120 $query = qq|SELECT fu.*, n.subject, n.body, n.created_by
122 LEFT JOIN notes n ON (fu.note_id = n.id)
124 AND ( (fu.created_by = ?) OR (fu.created_for_user = ?)
125 OR (fu.created_by IN (SELECT DISTINCT what FROM follow_up_access WHERE who = ?)))|;
126 my $ref = selectfirst_hashref_query($form, $dbh, $query, conv_i($params{id}), $employee_id, $employee_id, $employee_id);
129 $main::lxdebug->leave_sub();
133 $ref->{LINKS} = $self->retrieve_links(%{ $ref });
135 $main::lxdebug->leave_sub();
141 $main::lxdebug->enter_sub();
146 Common::check_params(\%params, qw(id));
148 my $myconfig = \%main::myconfig;
149 my $form = $main::form;
151 my $dbh = $form->get_standard_dbh($myconfig);
153 my $query = qq|SELECT ful.trans_id, ful.trans_type, ful.trans_info, fu.note_id
154 FROM follow_up_links ful
155 LEFT JOIN follow_ups fu ON (ful.follow_up_id = fu.id)
156 WHERE ful.follow_up_id = ?
159 my $links = selectall_hashref_query($form, $dbh, $query, conv_i($params{id}));
161 foreach my $link_ref (@{ $links }) {
162 my $link_details = FU->link_details(%{ $link_ref });
163 map { $link_ref->{$_} = $link_details->{$_} } keys %{ $link_details} if ($link_details);
166 $main::lxdebug->leave_sub();
172 $main::lxdebug->enter_sub();
177 my $myconfig = \%main::myconfig;
178 my $form = $main::form;
180 my $dbh = $form->get_standard_dbh($myconfig);
181 my ($query, $where, $where_user);
183 my ($employee_id) = selectrow_query($form, $dbh, qq|SELECT id FROM employee WHERE login = ?|, $form->{login});
185 my @values_user = ();
187 if ($params{trans_id}) {
188 $where .= qq| AND EXISTS (SELECT * FROM follow_up_links ful
189 WHERE (ful.follow_up_id = fu.id) AND (ful.trans_id = ?))|;
190 push @values, conv_i($params{trans_id});
193 if ($params{due_only}) {
194 $where .= qq| AND (fu.follow_up_date <= current_date)|;
197 if ($params{done} ne $params{not_done}) {
198 my $not = $params{not_done} ? 'NOT' : '';
199 $where .= qq| AND $not COALESCE(fu.done, FALSE)|;
202 if ($params{not_id}) {
203 $where .= qq| AND (fu.id <> ?)|;
204 push @values, conv_i($params{not_id});
207 foreach my $item (qw(subject body)) {
208 next unless ($params{$item});
209 $where .= qq| AND (n.${item} ILIKE ?)|;
210 push @values, '%' . $params{$item} . '%';
213 if ($params{reference}) {
214 $where .= qq| AND EXISTS (SELECT ful.follow_up_id
215 FROM follow_up_links ful
216 WHERE (ful.follow_up_id = fu.id)
217 AND (ful.trans_info ILIKE ?)
219 push @values, '%' . $params{reference} . '%';
222 if ($params{follow_up_date_from}) {
223 $where .= qq| AND (fu.follow_up_date >= ?)|;
224 push @values, conv_date($params{follow_up_date_from});
226 if ($params{follow_up_date_to}) {
227 $where .= qq| AND (fu.follow_up_date <= ?)|;
228 push @values, conv_date($params{follow_up_date_to});
231 if ($params{itime_from}) {
232 $where .= qq| AND (date_trunc('DAY', fu.itime) >= ?)|;
233 push @values, conv_date($params{itime_from});
235 if ($params{itime_to}) {
236 $where .= qq| AND (date_trunc('DAY', fu.itime) <= ?)|;
237 push @values, conv_date($params{itime_to});
240 if ($params{all_users}) {
241 $where_user = qq|OR (fu.created_by IN (SELECT DISTINCT what FROM follow_up_access WHERE who = ?))|;
242 push @values_user, $employee_id;
247 if ($form->{sort} ne 'title') {
249 'follow_up_date' => [ qw(fu.follow_up_date fu.id) ],
250 'created_on' => [ qw(created_on fu.id) ],
251 'subject' => [ qw(lower(n.subject)) ],
254 my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
255 my $sortkey = $sort_columns{$form->{sort}} ? $form->{sort} : 'follow_up_date';
256 $order_by = 'ORDER BY ' . join(', ', map { "$_ $sortdir" } @{ $sort_columns{$sortkey} });
259 $query = qq|SELECT fu.*, n.subject, n.body, n.created_by,
260 fu.follow_up_date <= current_date AS due,
261 fu.itime::DATE AS created_on,
262 COALESCE(eby.name, eby.login) AS created_by_name,
263 COALESCE(efor.name, efor.login) AS created_for_user_name
265 LEFT JOIN notes n ON (fu.note_id = n.id)
266 LEFT JOIN employee eby ON (n.created_by = eby.id)
267 LEFT JOIN employee efor ON (fu.created_for_user = efor.id)
268 WHERE ((fu.created_by = ?) OR (fu.created_for_user = ?)
273 my $follow_ups = selectall_hashref_query($form, $dbh, $query, $employee_id, $employee_id, @values_user, @values);
275 if (!scalar @{ $follow_ups }) {
276 $main::lxdebug->leave_sub();
280 foreach my $fu (@{ $follow_ups }) {
281 $fu->{LINKS} = $self->retrieve_links(%{ $fu });
284 if ($form->{sort} eq 'title') {
285 my $dir_factor = !defined $form->{sortdir} ? 1 : $form->{sortdir} ? 1 : -1;
286 $follow_ups = [ map { $_->[1] }
287 sort { ($a->[0] cmp $b->[0]) * $dir_factor }
288 map { my $fu = $follow_ups->[$_]; [ @{ $fu->{LINKS} } ? lc($fu->{LINKS}->[0]->{title}) : '', $fu ] }
289 (0 .. scalar(@{ $follow_ups }) - 1) ];
292 $main::lxdebug->leave_sub();
298 $main::lxdebug->enter_sub();
303 Common::check_params(\%params, qw(trans_id trans_type));
305 my $myconfig = \%main::myconfig;
306 my $form = $main::form;
307 my $locale = $main::locale;
309 my $q_id = $form->quote($params{trans_id});
312 if ($params{trans_type} eq 'customer') {
314 'url' => 'ct.pl?action=edit&db=customer&id=' . $form->quote($params{trans_id}) . '&edit_note_id=' . $form->quote($params{note_id}),
315 'title' => $locale->text('Customer') . " '$params{trans_info}'",
318 } elsif ($params{trans_type} eq 'vendor') {
320 'url' => 'ct.pl?action=edit&type=sales_quotation&id=' . $params{trans_id} . '&edit_note_id=' . $form->quote($params{note_id}),
321 'title' => $locale->text('Vendor') . " '$params{trans_info}'",
324 } elsif ($params{trans_type} eq 'sales_quotation') {
326 'url' => 'oe.pl?action=edit&type=sales_quotation&id=' . $params{trans_id},
327 'title' => $locale->text('Sales quotation') . " $params{trans_info}",
330 } elsif ($params{trans_type} eq 'sales_order') {
332 'url' => 'oe.pl?action=edit&type=sales_order&id=' . $params{trans_id},
333 'title' => $locale->text('Sales Order') . " $params{trans_info}",
336 } elsif ($params{trans_type} eq 'sales_invoice') {
338 'url' => 'is.pl?action=edit&type=invoice&id=' . $params{trans_id},
339 'title' => $locale->text('Sales Invoice') . " $params{trans_info}",
342 } elsif ($params{trans_type} eq 'credit_note') {
344 'url' => 'is.pl?action=edit&type=credit_note&id=' . $params{trans_id},
345 'title' => $locale->text('Credit Note') . " $params{trans_info}",
348 } elsif ($params{trans_type} eq 'dunning') {
350 'url' => 'dn.pl?action=print_dunning&format=pdf&media=screen&dunning_id=' . $params{trans_id},
351 'title' => $locale->text('Dunning') . " $params{trans_info}",
354 } elsif ($params{trans_type} eq 'request_quotation') {
356 'url' => 'oe.pl?action=edit&type=request_quotation&id=' . $params{trans_id},
357 'title' => $locale->text('Request quotation') . " $params{trans_info}",
360 } elsif ($params{trans_type} eq 'purchase_order') {
362 'url' => 'oe.pl?action=edit&type=purchase_order&id=' . $params{trans_id},
363 'title' => $locale->text('Purchase Order') . " $params{trans_info}",
366 } elsif ($params{trans_type} eq 'vendor_invoice') {
368 'url' => 'ir.pl?action=edit&type=invoice&id=' . $params{trans_id},
369 'title' => $locale->text('Vendor Invoice') . " $params{trans_info}",
372 } elsif ($params{trans_type} eq 'ar_transaction') {
374 'url' => 'ar.pl?action=editid=' . $params{trans_id},
375 'title' => $locale->text('AR Transaction') . " $params{trans_info}",
378 } elsif ($params{trans_type} eq 'ap_transaction') {
380 'url' => 'ap.pl?action=editid=' . $params{trans_id},
381 'title' => $locale->text('AP Transaction') . " $params{trans_info}",
384 } elsif ($params{trans_type} eq 'gl_transaction') {
386 'url' => 'gl.pl?action=edit&id=' . $params{trans_id},
387 'title' => $locale->text('GL Transaction') . " $params{trans_info}",
392 $main::lxdebug->leave_sub();
397 sub save_access_rights {
398 $main::lxdebug->enter_sub();
403 Common::check_params(\%params, 'access');
405 my $myconfig = \%main::myconfig;
406 my $form = $main::form;
408 my $dbh = $form->get_standard_dbh($myconfig);
410 my ($id) = selectrow_query($form, $dbh, qq|SELECT id FROM employee WHERE login = ?|, $form->{login});
412 my $query = qq|INSERT INTO follow_up_access (who, what) VALUES (?, ?)|;
413 my $sth = prepare_query($form, $dbh, $query);
415 do_query($form, $dbh, qq|DELETE FROM follow_up_access WHERE what = ?|, $id);
417 while (my ($who, $access_allowed) = each %{ $params{access} }) {
418 next unless ($access_allowed);
420 do_statement($form, $sth, $query, conv_i($who), $id);
427 $main::lxdebug->leave_sub();
430 sub retrieve_access_rights {
431 $main::lxdebug->enter_sub();
436 my $myconfig = \%main::myconfig;
437 my $form = $main::form;
439 my $dbh = $form->get_standard_dbh($myconfig);
441 my $sth = prepare_execute_query($form, $dbh, qq|SELECT who FROM follow_up_access WHERE what = (SELECT id FROM employee WHERE login = ?)|, $form->{login});
444 while (my $ref = $sth->fetchrow_hashref()) {
445 $access->{$ref->{who}} = 1;
450 $main::lxdebug->leave_sub();