1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
8 # SQL-Ledger Accounting
11 # Author: Dieter Simader
12 # Email: dsimader@sql-ledger.org
13 # Web: http://www.sql-ledger.org
16 # This program is free software; you can redistribute it and/or modify
17 # it under the terms of the GNU General Public License as published by
18 # the Free Software Foundation; either version 2 of the License, or
19 # (at your option) any later version.
21 # This program is distributed in the hope that it will be useful,
22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 # GNU General Public License for more details.
25 # You should have received a copy of the GNU General Public License
26 # along with this program; if not, write to the Free Software
27 # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
28 #======================================================================
32 #======================================================================
36 use List::Util qw(first);
40 require "bin/mozilla/common.pl";
46 sub assert_bp_access {
47 my $form = $main::form;
50 'invoice' => 'invoice_edit',
51 'sales_order' => 'sales_order_edit',
52 'sales_quotation' => 'sales_quotation_edit',
53 'purchase_order' => 'purchase_order_edit',
54 'request_quotation' => 'request_quotation_edit',
59 if ($form->{type} && $access_map{$form->{type}}) {
60 $main::auth->assert($access_map{$form->{type}});
63 $main::auth->assert('DOES_NOT_EXIST');
68 $::lxdebug->enter_sub;
72 # setup customer/vendor selection
73 BP->get_vc(\%::myconfig, $::form);
76 invoice => { title => $::locale->text('Sales Invoices'), invnumber => 1, ordnumber => 1 },
77 sales_order => { title => $::locale->text('Sales Orders'), ordnumber => 1, },
78 purchase_order => { title => $::locale->text('Purchase Orders'), ordnumber => 1, },
79 sales_quotation => { title => $::locale->text('Quotations'), quonumber => 1, },
80 request_quotation => { title => $::locale->text('RFQs'), quonumber => 1, },
81 check => { title => $::locale->text('Checks'), chknumber => 1, },
82 receipt => { title => $::locale->text('Receipts'), rctnumber => 1, },
85 my $bp_accounts = $::form->{type} =~ /check|receipt/
86 && BP->payment_accounts(\%::myconfig, $::form);
89 print $::form->parse_html_template('bp/search', {
91 show_accounts => $bp_accounts,
92 account_sub => sub { ("$_[0]{accno}--$_[0]{description}")x2 },
93 vc_keys => sub { "$_[0]{name}--$_[0]{id}" },
96 $::lxdebug->leave_sub;
100 $main::lxdebug->enter_sub();
102 my $form = $main::form;
103 my $locale = $main::locale;
109 for my $i (1 .. $form->{rowcount}) {
110 if ($form->{"checked_$i"}) {
116 $form->error('Nothing selected!') unless $selected;
118 $form->{title} = $locale->text('Confirm!');
125 <form method=post action=bp.pl>
128 map { delete $form->{$_} } qw(action header);
130 foreach my $key (keys %$form) {
131 next if (($key eq 'login') || ($key eq 'password') || ('' ne ref $form->{$key}));
132 print qq|<input type=hidden name=$key value="$form->{$key}">\n|;
136 <h2 class=confirm>$form->{title}</h2>
140 'Are you sure you want to remove the marked entries from the queue?')
143 <input name=action class=submit type=submit value="|
144 . $locale->text('Yes') . qq|">
151 $main::lxdebug->leave_sub();
155 $main::lxdebug->enter_sub();
157 my $form = $main::form;
158 my %myconfig = %main::myconfig;
159 my $locale = $main::locale;
163 $form->info($locale->text('Removing marked entries from queue ...'));
164 $form->{callback} .= "&header=1" if $form->{callback};
166 $form->redirect($locale->text('Removed spoolfiles!'))
167 if (BP->delete_spool(\%myconfig, \%$form));
168 $form->error($locale->text('Cannot remove files!'));
170 $main::lxdebug->leave_sub();
174 $main::lxdebug->enter_sub();
176 my $form = $main::form;
177 my %myconfig = %main::myconfig;
178 my $locale = $main::locale;
182 $form->get_lists(printers => 'ALL_PRINTERS');
183 # use the command stored in the databse or fall back to $myconfig{printer}
184 my $selected_printer = first { $_ } map ({ $_ ->{printer_command} }
185 grep { $_->{id} eq $form->{printer} }
186 @{ $form->{ALL_PRINTERS} }),
189 if ($form->{callback}) {
190 map { $form->{callback} .= "&checked_$_=1" if $form->{"checked_$_"} }
191 (1 .. $form->{rowcount});
192 $form->{callback} .= "&header=1";
195 for my $i (1 .. $form->{rowcount}) {
196 if ($form->{"checked_$i"}) {
197 $form->info($locale->text('Printing ... '));
199 if (BP->print_spool(\%myconfig, \%$form, "| $selected_printer")) {
200 print $locale->text('done');
201 $form->redirect($locale->text('Marked entries printed!'));
207 $form->error('Nothing selected!');
209 $main::lxdebug->leave_sub();
213 $main::lxdebug->enter_sub();
215 my $form = $main::form;
216 my %myconfig = %main::myconfig;
217 my $locale = $main::locale;
221 $form->{ $form->{vc} } = $form->unescape($form->{ $form->{vc} });
222 ($form->{ $form->{vc} }, $form->{"$form->{vc}_id"}) =
223 split(/--/, $form->{ $form->{vc} });
225 BP->get_spoolfiles(\%myconfig, \%$form);
227 my $title = $form->escape($form->{title});
228 my $href = "bp.pl?action=list_spool&vc=$form->{vc}&type=$form->{type}&title=$title";
230 $title = $form->escape($form->{title}, 1);
232 "bp.pl?action=list_spool&vc=$form->{vc}&type=$form->{type}&title=$title";
235 if ($form->{ $form->{vc} }) {
236 $callback .= "&$form->{vc}=" . $form->escape($form->{ $form->{vc} }, 1);
237 $href .= "&$form->{vc}=" . $form->escape($form->{ $form->{vc} });
239 ($form->{vc} eq 'customer')
240 ? $locale->text('Customer')
241 : $locale->text('Vendor');
242 $option .= " : $form->{$form->{vc}}";
244 if ($form->{account}) {
245 $callback .= "&account=" . $form->escape($form->{account}, 1);
246 $href .= "&account=" . $form->escape($form->{account});
247 $option .= "\n<br>" if ($option);
248 $option .= $locale->text('Account') . " : $form->{account}";
250 if ($form->{invnumber}) {
251 $callback .= "&invnumber=" . $form->escape($form->{invnumber}, 1);
252 $href .= "&invnumber=" . $form->escape($form->{invnumber});
253 $option .= "\n<br>" if ($option);
254 $option .= $locale->text('Invoice Number') . " : $form->{invnumber}";
256 if ($form->{ordnumber}) {
257 $callback .= "&ordnumber=" . $form->escape($form->{ordnumber}, 1);
258 $href .= "&ordnumber=" . $form->escape($form->{ordnumber});
259 $option .= "\n<br>" if ($option);
260 $option .= $locale->text('Order Number') . " : $form->{ordnumber}";
262 if ($form->{quonumber}) {
263 $callback .= "&quonumber=" . $form->escape($form->{quonumber}, 1);
264 $href .= "&quonumber=" . $form->escape($form->{quonumber});
265 $option .= "\n<br>" if ($option);
266 $option .= $locale->text('Quotation Number') . " : $form->{quonumber}";
269 if ($form->{transdatefrom}) {
270 $callback .= "&transdatefrom=$form->{transdatefrom}";
271 $href .= "&transdatefrom=$form->{transdatefrom}";
272 $option .= "\n<br>" if ($option);
274 $locale->text('From') . " "
275 . $locale->date(\%myconfig, $form->{transdatefrom}, 1);
277 if ($form->{transdateto}) {
278 $callback .= "&transdateto=$form->{transdateto}";
279 $href .= "&transdateto=$form->{transdateto}";
280 $option .= "\n<br>" if ($option);
282 $locale->text('To') . " "
283 . $locale->date(\%myconfig, $form->{transdateto}, 1);
286 my $name = ucfirst $form->{vc};
288 my @columns = qw(transdate);
289 if ($form->{type} =~ /_order$/) {
290 push @columns, "ordnumber";
292 if ($form->{type} =~ /_quotation$/) {
293 push @columns, "quonumber";
296 push @columns, qw(name spoolfile);
297 my @column_index = $form->sort_columns(@columns);
298 unshift @column_index, "checked";
303 $column_header{checked} = "<th class=listheading> </th>";
304 $column_header{transdate} =
305 "<th><a class=listheading href=$href&sort=transdate>"
306 . $locale->text('Date')
308 $column_header{invnumber} =
309 "<th><a class=listheading href=$href&sort=invnumber>"
310 . $locale->text('Invoice')
312 $column_header{ordnumber} =
313 "<th><a class=listheading href=$href&sort=ordnumber>"
314 . $locale->text('Order')
316 $column_header{quonumber} =
317 "<th><a class=listheading href=$href&sort=quonumber>"
318 . $locale->text('Quotation')
320 $column_header{name} =
321 "<th><a class=listheading href=$href&sort=name>"
322 . $locale->text($name)
324 $column_header{spoolfile} =
325 "<th class=listheading>" . $locale->text('Spoolfile') . "</th>";
332 <form method=post action=bp.pl>
336 <th class=listtop>$form->{title}</th>
345 <tr class=listheading>
348 map { print "\n$column_header{$_}" } @column_index;
354 # add sort and escape callback, this one we use for the add sub
355 $form->{callback} = $callback .= "&sort=$form->{sort}";
357 # escape callback for href
358 $callback = $form->escape($callback);
363 my $spool = $::lx_office_conf{paths}->{spool};
365 foreach my $ref (@{ $form->{SPOOL} }) {
369 $form->{"checked_$i"} = "checked" if $form->{"checked_$i"};
371 if ($ref->{invoice}) {
372 $ref->{module} = ($ref->{module} eq 'ar') ? "is" : "ir";
374 my $module = "$ref->{module}.pl";
376 $column_data{transdate} = "<td>$ref->{transdate} </td>";
378 if ($spoolfile eq $ref->{spoolfile}) {
379 $column_data{checked} = qq|<td></td>|;
381 $column_data{checked} =
382 qq|<td><input name=checked_$i type=checkbox style=checkbox $form->{"checked_$i"} $form->{"checked_$i"}></td>|;
385 $column_data{invnumber} =
386 "<td><a href=$module?action=edit&id=$ref->{id}&type=$form->{type}&callback=$callback>$ref->{invnumber}</a></td>";
387 $column_data{ordnumber} =
388 "<td><a href=$module?action=edit&id=$ref->{id}&type=$form->{type}&callback=$callback>$ref->{ordnumber}</a></td>";
389 $column_data{quonumber} =
390 "<td><a href=$module?action=edit&id=$ref->{id}&type=$form->{type}&callback=$callback>$ref->{quonumber}</a></td>";
391 $column_data{name} = "<td>$ref->{name}</td>";
392 $column_data{spoolfile} =
393 qq|<td><a href=$spool/$ref->{spoolfile}>$ref->{spoolfile}</a></td>
394 <input type=hidden name="spoolfile_$i" value=$ref->{spoolfile}>
397 $spoolfile = $ref->{spoolfile};
405 map { print "\n$column_data{$_}" } @column_index;
414 <input type=hidden name=rowcount value=$i>
420 <td><hr size=3 noshade></td>
426 <input name=callback type=hidden value="$form->{callback}">
428 <input type=hidden name=title value="$form->{title}">
429 <input type=hidden name=vc value="$form->{vc}">
430 <input type=hidden name=type value="$form->{type}">
431 <input type=hidden name=sort value="$form->{sort}">
433 <input type=hidden name=account value="$form->{account}">
436 # if ($myconfig{printer}) {
438 <input type=hidden name=transdateto value=$form->{transdateto}>
439 <input type=hidden name=transdatefrom value=$form->{transdatefrom}>
440 <input type=hidden name=invnumber value=$form->{invnumber}>
441 <input type=hidden name=ordnumber value=$form->{ordnumber}>
442 <input type=hidden name=quonumber value=$form->{quonumber}>
443 <input type=hidden name=customer value=$form->{customer}>
444 <input type=hidden name=vendor value=$form->{vendor}>
445 <input class=submit type=submit name=action value="|
446 . $locale->text('Select all') . qq|">
447 <input class=submit type=submit name=action value="|
448 . $locale->text('Remove') . qq|">
449 <input class=submit type=submit name=action value="|
450 . $locale->text('Print') . qq|">
453 $form->get_lists(printers=>"ALL_PRINTERS");
454 print qq|<select name="printer">|;
455 print map(qq|<option value="$_->{id}">| . H($_->{printer_description}) . qq|</option>|, @{ $form->{ALL_PRINTERS} });
467 $main::lxdebug->leave_sub();
471 $main::lxdebug->enter_sub();
473 my $form = $main::form;
477 map { $form->{"checked_$_"} = 1 } (1 .. $form->{rowcount});
480 $main::lxdebug->leave_sub();
483 sub continue { call_sub($main::form->{"nextsub"}); }