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 #======================================================================
39 require "$form->{path}/arap.pl";
46 $lxdebug->enter_sub();
48 $form->{ARAP} = ($form->{type} eq 'receipt') ? "AR" : "AP";
49 $form->{arap} = lc $form->{ARAP};
51 # setup customer/vendor selection for open invoices
52 if ($form->{all_vc}) {
53 $form->all_vc(\%myconfig, $form->{vc}, $form->{ARAP});
55 CP->get_openvc(\%myconfig, \%$form);
58 $form->{"select$form->{vc}"} = "";
60 if ($form->{"all_$form->{vc}"}) {
61 $form->{"$form->{vc}_id"} = $form->{"all_$form->{vc}"}->[0]->{id};
62 map { $form->{"select$form->{vc}"} .= "<option>$_->{name}--$_->{id}\n" }
63 @{ $form->{"all_$form->{vc}"} };
67 if (@{ $form->{all_departments} }) {
68 $form->{selectdepartment} = "<option>\n";
69 $form->{department} = "$form->{department}--$form->{department_id}";
72 $form->{selectdepartment} .=
73 "<option>$_->{description}--$_->{id}\n"
74 } (@{ $form->{all_departments} });
77 CP->paymentaccounts(\%myconfig, \%$form);
79 $form->{selectaccount} = "";
80 $form->{"select$form->{ARAP}"} = "";
82 map { $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n" }
83 @{ $form->{PR}{"$form->{ARAP}_paid"} };
85 $form->{"select$form->{ARAP}"} .=
86 "<option>$_->{accno}--$_->{description}\n"
87 } @{ $form->{PR}{ $form->{ARAP} } };
90 @curr = split /:/, $form->{currencies};
92 $form->{defaultcurrency} = $form->{currency} = $form->{oldcurrency} =
95 $form->{selectcurrency} = "";
96 map { $form->{selectcurrency} .= "<option>$_\n" } @curr;
98 $form->{media} = "screen";
103 $lxdebug->leave_sub();
107 $lxdebug->enter_sub();
109 $vclabel = ucfirst $form->{vc};
110 $vclabel = $locale->text($vclabel);
112 if ($form->{type} eq 'receipt') {
113 $form->{title} = $locale->text('Receipt');
114 $form->{origtitle} = "Receipt";
116 if ($form->{type} eq 'check') {
117 $form->{title} = $locale->text('Payment');
118 $form->{origtitle} = "Payment";
121 # $locale->text('Customer')
122 # $locale->text('Vendor')
124 if ($form->{ $form->{vc} } eq "") {
125 map { $form->{"addr$_"} = "" } (1 .. 4);
128 if ($form->{currency} ne $form->{defaultcurrency}) {
129 $form->{exchangerate} =
130 $form->format_amount(\%myconfig, $form->{exchangerate});
131 if ($form->{forex}) {
134 <th align=right nowrap>| . $locale->text('Exchangerate') . qq|</th>
135 <td colspan=3><input type=hidden name=exchangerate size=10 value=$form->{exchangerate}>$form->{exchangerate}</td>
141 <th align=right nowrap>| . $locale->text('Exchangerate') . qq|</th>
142 <td colspan=3><input name=exchangerate size=10 value=$form->{exchangerate}></td>
148 foreach $item ($form->{vc}, account, currency, $form->{ARAP}, department) {
149 $form->{"select$item"} =~ s/ selected//;
150 $form->{"select$item"} =~
151 s/option>\Q$form->{$item}\E/option selected>$form->{$item}/;
155 ($form->{"select$form->{vc}"})
156 ? qq|<select name=$form->{vc}>$form->{"select$form->{vc}"}\n</select>|
157 : qq|<input name=$form->{vc} size=35 value="$form->{$form->{vc}}">|;
159 if ($form->{all_vc}) {
161 $form->{openinvoices} = "";
164 $form->{openinvoices} = 1;
167 # $locale->text('AR')
168 # $locale->text('AP')
172 <th align="right" nowrap>| . $locale->text('Department') . qq|</th>
173 <td><select name=department>$form->{selectdepartment}</select>
174 <input type=hidden name=selectdepartment value="$form->{selectdepartment}">
178 | if $form->{selectdepartment};
180 $form->{jsscript} = $jscalendar;
182 if ($form->{jsscript}) {
184 # with JavaScript Calendar
186 <td><input name=datepaid id=datepaid size=11 title="$myconfig{dateformat}" value="$form->{datepaid}">
187 <input type=button name=datepaid id="trigger1" value=|
188 . $locale->text('button')
194 Form->write_trigger(\%myconfig, "1", "datepaid", "BL", "trigger1");
197 # without JavaScript Calendar
199 <td><input name=transdatefrom id=transdatefrom size=11 title="$myconfig{dateformat}"></td>|;
204 $arap = lc $form->{ARAP};
209 <form method=post action=$form->{script}>
211 <input type=hidden name=defaultcurrency value=$form->{defaultcurrency}>
212 <input type=hidden name=closedto value=$form->{closedto}>
213 <input type=hidden name=vc value=$form->{vc}>
214 <input type=hidden name=type value=$form->{type}>
215 <input type=hidden name=formname value=$form->{type}>
216 <input type=hidden name=queued value="$form->{queued}">
217 <input type=hidden name=arap value=$arap>
218 <input type=hidden name=ARAP value=$form->{ARAP}>
219 <input type=hidden name=openinvoices value=$form->{openinvoices}>
220 <input type=hidden name=title value="$form->{title}">
221 <input type=hidden name=origtitle value="$form->{origtitle}">
225 <th class=listtop>$form->{title}</th>
236 <input name=all_vc type=checkbox style=checkbox value=Y $allvc>
237 <input type=hidden name="oldall_vc" value="$form->{all_vc}"></td>
238 <th align=left>| . $locale->text('All') . qq|</th>
241 <th align=right>$vclabel</th>
243 <input type=hidden name="select$form->{vc}" value="$form->{"select$form->{vc}"}">
244 <input type=hidden name="$form->{vc}_id" value=$form->{"$form->{vc}_id"}>
245 <input type=hidden name="old$form->{vc}" value="$form->{"old$form->{vc}"}">
248 <th align=right nowrap>| . $locale->text('Address') . qq|</th>
252 <td>$form->{street}</td>
255 <td>$form->{zipcode}</td>
258 <td>$form->{city}</td>
261 <td>$form->{country}</td>
265 <input type=hidden name=street value="$form->{street}">
266 <input type=hidden name=zipcode value="$form->{zipcode}">
267 <input type=hidden name=city value="$form->{city}">
268 <input type=hidden name=country value="$form->{country}">
271 <th align=right>| . $locale->text('Memo') . qq|</th>
272 <td colspan=2><input name="memo" size=30 value="$form->{memo}"></td>
280 <th align=right nowrap>| . $locale->text($form->{ARAP}) . qq|</th>
281 <td colspan=3><select name=$form->{ARAP}>$form->{"select$form->{ARAP}"}</select>
283 <input type=hidden name="select$form->{ARAP}" value="$form->{"select$form->{ARAP}"}">
286 <th align=right nowrap>| . $locale->text('Account') . qq|</th>
287 <td colspan=3><select name=account>$form->{selectaccount}</select>
288 <input type=hidden name=selectaccount value="$form->{selectaccount}">
292 <th align=right nowrap>| . $locale->text('Date') . qq|</th>
296 <th align=right nowrap>| . $locale->text('Currency') . qq|</th>
297 <td><select name=currency>$form->{selectcurrency}</select></td>
298 <input type=hidden name=selectcurrency value="$form->{selectcurrency}">
299 <input type=hidden name=oldcurrency value=$form->{oldcurrency}>
303 <th align=right nowrap>| . $locale->text('Source') . qq|</th>
304 <td colspan=3><input name=source value="$form->{source}" size=10></td>
307 <th align=right nowrap>| . $locale->text('Amount') . qq|</th>
308 <td colspan=3><input name=amount size=10 value=|
309 . $form->format_amount(\%myconfig, $form->{amount}, 2)
322 $lxdebug->leave_sub();
326 $lxdebug->enter_sub();
328 @column_index = qw(invnumber transdate amount due checked paid);
330 $colspan = $#column_index + 1;
332 $invoice = $locale->text('Invoices');
335 <input type=hidden name=column_index value="id @column_index">
340 <th class=listheading colspan=$colspan>$invoice</th>
344 $column_data{invnumber} =
345 qq|<th nowrap class=listheading>| . $locale->text('Invoice') . "</th>";
346 $column_data{transdate} =
347 qq|<th nowrap class=listheading>| . $locale->text('Date') . "</th>";
348 $column_data{amount} =
349 qq|<th nowrap class=listheading>| . $locale->text('Amount') . "</th>";
351 qq|<th nowrap class=listheading>| . $locale->text('Due') . "</th>";
353 qq|<th nowrap class=listheading>| . $locale->text('Amount') . "</th>";
354 $column_data{checked} =
355 qq|<th nowrap class=listheading>| . $locale->text('Select') . "</th>";
360 map { print "$column_data{$_}\n" } @column_index;
365 for $i (1 .. $form->{rowcount}) {
368 $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"})
369 } qw(amount due paid);
371 $totalamount += $form->{"amount_$i"};
372 $totaldue += $form->{"due_$i"};
373 $totalpaid += $form->{"paid_$i"};
377 $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
378 } qw(amount due paid);
380 $column_data{invnumber} = qq|<td>$form->{"invnumber_$i"}</td>
381 <input type=hidden name="invnumber_$i" value="$form->{"invnumber_$i"}">
382 <input type=hidden name="id_$i" value=$form->{"id_$i"}>|;
383 $column_data{transdate} = qq|<td width=15%>$form->{"transdate_$i"}</td>
384 <input type=hidden name="transdate_$i" value=$form->{"transdate_$i"}>|;
385 $column_data{amount} =
386 qq|<td align=right width=15%>$form->{"amount_$i"}</td>
387 <input type=hidden name="amount_$i" value=$form->{"amount_$i"}>|;
388 $column_data{due} = qq|<td align=right width=15%>$form->{"due_$i"}</td>
389 <input type=hidden name="due_$i" value=$form->{"due_$i"}>|;
392 qq|<td align=right width=15%><input name="paid_$i" size=10 value=$form->{"paid_$i"}></td>|;
394 $form->{"checked_$i"} = ($form->{"checked_$i"}) ? "checked" : "";
395 $column_data{checked} =
396 qq|<td align=center width=10%><input name="checked_$i" type=checkbox style=checkbox $form->{"checked_$i"}></td>|;
403 map { print "$column_data{$_}\n" } @column_index;
409 map { $column_data{$_} = "<td> </td>" } @column_index;
411 $column_data{amount} =
412 qq|<th class=listtotal align=right>|
413 . $form->format_amount(\%myconfig, $totalamount, 2, " ")
416 qq|<th class=listtotal align=right>|
417 . $form->format_amount(\%myconfig, $totaldue, 2, " ")
420 qq|<th class=listtotal align=right>|
421 . $form->format_amount(\%myconfig, $totalpaid, 2, " ")
427 map { print "$column_data{$_}\n" } @column_index;
435 $lxdebug->leave_sub();
439 $lxdebug->enter_sub();
441 $form->{DF}{ $form->{format} } = "selected";
442 $form->{OP}{ $form->{media} } = "selected";
445 <option value=screen $form->{OP}{screen}>| . $locale->text('Screen');
447 if ($myconfig{printer} && $latex) {
449 <option value=printer $form->{OP}{printer}>|
450 . $locale->text('Printer');
454 <option value=queue $form->{OP}{queue}>| . $locale->text('Queue');
456 <option value=postscript $form->{DF}{postscript}>|
457 . $locale->text('Postscript') . qq|
458 <option value=pdf $form->{DF}{pdf}>| . $locale->text('PDF');
463 <td><hr size=3 noshade></td>
466 <input type=hidden name=rowcount value=$form->{rowcount}>
468 <input type=hidden name=path value=$form->{path}>
469 <input type=hidden name=login value=$form->{login}>
470 <input type=hidden name=password value=$form->{password}>
473 <input class=submit type=submit name=action value="|
474 . $locale->text('Update') . qq|">
475 <input class=submit type=submit name=action value="|
476 . $locale->text('Post') . qq|">|;
480 <input class=submit type=submit name=action value="|
481 . $locale->text('Print') . qq|">|;
485 <select name=format>$format</select>
486 <select name=media>$media</select>
489 if ($form->{menubar}) {
490 require "$form->{path}/menu.pl";
501 $lxdebug->leave_sub();
505 $lxdebug->enter_sub();
507 my ($new_name_selected) = @_;
509 if ($form->{vc} eq 'customer') {
515 # if we switched to all_vc
516 if ($form->{all_vc} ne $form->{oldall_vc}) {
518 $form->{openinvoices} = ($form->{all_vc}) ? 0 : 1;
520 $form->{"select$form->{vc}"} = "";
522 if ($form->{all_vc}) {
523 $form->all_vc(\%myconfig, $form->{vc}, $form->{ARAP});
525 if ($form->{"all_$form->{vc}"}) {
527 $form->{"select$form->{vc}"} .=
528 "<option>$_->{name}--$_->{id}\n"
529 } @{ $form->{"all_$form->{vc}"} };
532 CP->get_openvc(\%myconfig, \%$form);
534 if ($form->{"all_$form->{vc}"}) {
536 qq|$form->{"all_$form->{vc}"}[0]->{name}--$form->{"all_$form->{vc}"}[0]->{id}|;
538 $form->{"select$form->{vc}"} .=
539 "<option>$_->{name}--$_->{id}\n"
540 } @{ $form->{"all_$form->{vc}"} };
543 # if the name is not the same
544 if ($form->{"select$form->{vc}"} !~ /$form->{$form->{vc}}/) {
545 $form->{ $form->{vc} } = $newvc;
550 # get customer and invoices
551 $updated = &check_name($form->{vc});
553 if ($new_name_selected || $updated) {
554 CP->get_openinvoices(\%myconfig, \%$form);
555 ($newvc) = split /--/, $form->{ $form->{vc} };
556 $form->{"old$form->{vc}"} = qq|$newvc--$form->{"$form->{vc}_id"}|;
560 if ($form->{currency} ne $form->{oldcurrency}) {
561 $form->{oldcurrency} = $form->{currency};
563 CP->get_openinvoices(\%myconfig, \%$form);
568 $form->{exchangerate} = $exchangerate
572 $form->check_exchangerate(
573 \%myconfig, $form->{currency}, $form->{datepaid}, $buysell
576 $amount = $form->{amount} = $form->parse_amount(\%myconfig, $form->{amount});
579 $form->{rowcount} = 0;
581 $form->{queued} = "";
584 foreach $ref (@{ $form->{PR} }) {
586 $form->{"id_$i"} = $ref->{id};
587 $form->{"invnumber_$i"} = $ref->{invnumber};
588 $form->{"transdate_$i"} = $ref->{transdate};
589 $ref->{exchangerate} = 1 unless $ref->{exchangerate};
590 $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate};
592 ($ref->{amount} - $ref->{paid}) / $ref->{exchangerate};
593 $form->{"checked_$i"} = "";
594 $form->{"paid_$i"} = "";
599 $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
603 $form->{rowcount} = $i;
607 $amount = $form->{amount};
608 for $i (1 .. $form->{rowcount}) {
611 $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"})
612 } qw(amount due paid);
614 if ($form->{"checked_$i"}) {
617 if (!$form->{"paid_$i"}) {
618 $form->{"paid_$i"} = $form->{"due_$i"};
621 $amount -= $form->{"paid_$i"};
623 $form->{"paid_$i"} = "";
628 $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2)
629 } qw(amount due paid);
637 $lxdebug->leave_sub();
641 $lxdebug->enter_sub();
645 if ($form->{currency} ne $form->{defaultcurrency}) {
646 $form->error($locale->text('Exchangerate missing!'))
647 unless $form->{exchangerate};
650 $msg1 = "$form->{origtitle} posted!";
651 $msg2 = "Cannot post $form->{origtitle}!";
653 # $locale->text('Payment posted!')
654 # $locale->text('Receipt posted!')
655 # $locale->text('Cannot post Payment!')
656 # $locale->text('Cannot post Receipt!')
658 $form->redirect($locale->text($msg1))
659 if (CP->process_payment(\%myconfig, \%$form));
660 $form->error($locale->text($msg2));
662 $lxdebug->leave_sub();
666 $lxdebug->enter_sub();
670 ($whole, $form->{decimal}) = split /\./, $form->{amount};
672 $form->{amount} = $form->format_amount(\%myconfig, $form->{amount}, 2);
674 $form->{decimal} .= "00";
675 $form->{decimal} = substr($form->{decimal}, 0, 2);
677 $check = new CP $myconfig{countrycode};
679 $form->{text_amount} = $check->num2text($whole);
681 &{"$form->{vc}_details"};
683 $form->{callback} = "";
685 $form->{templates} = "$myconfig{templates}";
686 $form->{IN} = "$form->{formname}.tex";
688 if ($form->{format} eq 'postscript') {
689 $form->{postscript} = 1;
691 if ($form->{format} eq 'pdf') {
695 if ($form->{media} eq 'printer') {
696 $form->{OUT} = "| $myconfig{printer}";
698 if ($form->{media} eq 'queue') {
699 %queued = split / /, $form->{queued};
701 if ($filename = $queued{ $form->{formname} }) {
702 unlink "$spool/$filename";
703 $filename =~ s/\..*$//g;
708 $filename .= ($form->{postscript}) ? '.ps' : '.pdf';
709 $form->{queued} = "$form->{formname} $filename";
710 $form->{OUT} = ">$spool/$filename";
712 $form->update_status(\%myconfig);
716 $form->{company} = $myconfig{company};
717 $form->{address} = $myconfig{address};
720 qw(name invnumber company address text_amount street zipcode city country memo);
721 $form->format_string(@a);
723 $form->parse_template(\%myconfig, $userspath);
725 if ($form->{media} ne 'screen') {
727 "$form->{script}?action=payment&vc=$form->{vc}&path=$form->{path}&login=$form->{login}&password=$form->{password}&all_vc=$form->{all_vc}";
729 $form->redirect if (CP->process_payment(\%myconfig, \%$form));
730 $form->error($locale->text('Cannot post payment!'));
733 $lxdebug->leave_sub();
736 sub customer_details { IS->customer_details(\%myconfig, \%$form) }
737 sub vendor_details { IR->vendor_details(\%myconfig, \%$form) }
740 $lxdebug->enter_sub();
742 &check_name($form->{vc});
744 if ($form->{currency} ne $form->{oldcurrency}) {
749 $form->error($locale->text('Date missing!')) unless $form->{datepaid};
751 $closedto = $form->datetonum($form->{closedto}, \%myconfig);
752 $datepaid = $form->datetonum($form->{datepaid}, \%myconfig);
754 $form->error($locale->text('Cannot process payment for a closed period!'))
755 if ($datepaid <= $closedto);
757 $amount = $form->parse_amount(\%myconfig, $form->{amount});
758 $form->{amount} = $amount;
760 for $i (1 .. $form->{rowcount}) {
761 if ($form->{"paid_$i"}) {
762 $amount -= $form->parse_amount($myconfig, $form->{"paid_$i"});
764 push(@{ $form->{paid} }, $form->{"paid_$i"});
765 push(@{ $form->{due} }, $form->{"due_$i"});
766 push(@{ $form->{invnumber} }, $form->{"invnumber_$i"});
767 push(@{ $form->{invdate} }, $form->{"transdate_$i"});
771 if ($form->round_amount($amount, 2) != 0) {
772 push(@{ $form->{paid} }, $form->format_amount(\%myconfig, $amount, 2));
773 push(@{ $form->{due} }, $form->format_amount(\%myconfig, 0, "0"));
774 push(@{ $form->{invnumber} },
775 ($form->{ARAP} eq 'AR')
776 ? $locale->text('Deposit')
777 : $locale->text('Prepayment'));
778 push(@{ $form->{invdate} }, $form->{datepaid});
781 $lxdebug->leave_sub();