#===================================================================== # LedgerSMB Small Medium Business Accounting # http://www.ledgersmb.org/ # # Copyright (C) 2006 # This work contains copyrighted information from a number of sources all used # with permission. # # This file contains source code included with or based on SQL-Ledger which # is Copyright Dieter Simader and DWS Systems Inc. 2000-2005 and licensed # under the GNU General Public License version 2 or, at your option, any later # version. For a full list including contact information of contributors, # maintainers, and copyright holders, see the CONTRIBUTORS file. # # Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork): # Copyright (c) 2002 # # Author: DWS Systems Inc. # Web: http://www.sql-ledger.org # # Contributors: # # # Author: DWS Systems Inc. # Web: http://www.ledgersmb.org/ # # Contributors: # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. #====================================================================== # # Payment module # #====================================================================== use LedgerSMB::CP; use LedgerSMB::OP; use LedgerSMB::IS; use LedgerSMB::IR; require "bin/arap.pl"; 1; # end of main # This may need to get more sophisticated in the future # Anyway, it provides one point of control for date handling. sub default_date { $form->{date} ||= 'current_date'; } sub payment { if ( $form->{type} eq 'receipt' ) { $form->{ARAP} = "AR"; $form->{arap} = "ar"; $form->{vc} = "customer"; $form->{formname} = "receipt"; } if ( $form->{type} eq 'check' ) { $form->{ARAP} = "AP"; $form->{arap} = "ap"; $form->{vc} = "vendor"; $form->{formname} = "check"; } $form->{payment} = "payment"; $form->{callback} = "$form->{script}?action=payment&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&all_vc=$form->{all_vc}&type=$form->{type}"; # setup customer/vendor selection for open invoices if ( $form->{all_vc} ) { $form->all_vc( \%myconfig, $form->{vc}, $form->{ARAP}, undef, $form->{datepaid} ); } else { CP->get_openvc( \%myconfig, \%$form ); if ( $myconfig{vclimit} > 0 ) { $form->{"all_$form->{vc}"} = $form->{name_list}; } } $form->{"select$form->{vc}"} = ""; if ( @{ $form->{"all_$form->{vc}"} } ) { $form->{"$form->{vc}_id"} = $form->{"all_$form->{vc}"}->[0]->{id}; for ( @{ $form->{"all_$form->{vc}"} } ) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|; } } # departments if ( @{ $form->{all_department} } ) { $form->{selectdepartment} = "<option>\n"; $form->{department} = "$form->{department}--$form->{department_id}" if $form->{department}; for ( @{ $form->{all_department} } ) { $form->{selectdepartment} .= qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|; } } if ( @{ $form->{all_language} } ) { $form->{selectlanguage} = "<option>\n"; for ( @{ $form->{all_language} } ) { $form->{selectlanguage} .= qq|<option value="$_->{code}">$_->{description}\n|; } } CP->paymentaccounts( \%myconfig, \%$form ); $form->{selectaccount} = ""; $form->{"select$form->{ARAP}"} = ""; for ( @{ $form->{PR}{"$form->{ARAP}_paid"} } ) { $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n"; } for ( @{ $form->{PR}{ $form->{ARAP} } } ) { $form->{"select$form->{ARAP}"} .= "<option>$_->{accno}--$_->{description}\n"; } # currencies @curr = split /:/, $form->{currencies}; $form->{defaultcurrency} = $curr[0]; chomp $form->{defaultcurrency}; $form->{selectcurrency} = ""; for (@curr) { $form->{selectcurrency} .= "<option>$_\n" } $form->{currency} = $form->{defaultcurrency}; $form->{oldcurrency} = $form->{currency}; if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->{forex} = $form->{exchangerate} = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{datepaid}, ( $form->{vc} eq 'customer' ) ? "buy" : "sell" ); } $form->{olddatepaid} = $form->{datepaid}; $form->{media} = $myconfig{printer}; $form->{format} = "pdf" unless $myconfig{printer}; &payment_header; &payment_footer; } sub payments { if ( $form->{type} eq 'receipt' ) { $form->{ARAP} = "AR"; $form->{arap} = "ar"; $form->{vc} = "customer"; $form->{formname} = "receipt"; } if ( $form->{type} eq 'check' ) { $form->{ARAP} = "AP"; $form->{arap} = "ap"; $form->{vc} = "vendor"; $form->{formname} = "check"; } $form->{payment} = "payments"; $form->{callback} = "$form->{script}?action=$form->{action}"; for (qw(path login sessionid type)) { $form->{callback} .= "&$_=$form->{$_}"; } CP->paymentaccounts( \%myconfig, \%$form ); if ( @{ $form->{all_language} } ) { $form->{selectlanguage} = "<option>\n"; for ( @{ $form->{all_language} } ) { $form->{selectlanguage} .= qq|<option value="$_->{code}">$_->{description}\n|; } } # departments if ( @{ $form->{all_department} } ) { $form->{selectdepartment} = "<option>\n"; $form->{department} = "$form->{department}--$form->{department_id}" if $form->{department}; for ( @{ $form->{all_department} } ) { $form->{selectdepartment} .= qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|; } } $form->{selectaccount} = ""; $form->{"select$form->{ARAP}"} = ""; for ( @{ $form->{PR}{"$form->{ARAP}_paid"} } ) { $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n"; } for ( @{ $form->{PR}{ $form->{ARAP} } } ) { $form->{"select$form->{ARAP}"} .= "<option>$_->{accno}--$_->{description}\n"; } # currencies @curr = split /:/, $form->{currencies}; $form->{defaultcurrency} = $curr[0]; chomp $form->{defaultcurrency}; $form->{selectcurrency} = ""; for (@curr) { $form->{selectcurrency} .= "<option>$_\n" } $form->{oldcurrency} = $form->{currency} = $form->{defaultcurrency}; $form->{oldduedateto} = $form->{datepaid}; $form->{media} = $myconfig{printer}; $form->{format} = "pdf" unless $myconfig{printer}; &payments_header; &invoices_due; &payments_footer; } sub payments_header { if ( $form->{type} eq 'receipt' ) { $form->{title} = $locale->text('Receipts'); } if ( $form->{type} eq 'check' ) { $form->{title} = $locale->text('Payments'); } for ("department") { $form->{"select$_"} = $form->unescape( $form->{"select$_"} ); $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/; } for ( "account", "currency", "$form->{ARAP}" ) { $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/option>\Q$form->{$_}\E/option selected>$form->{$_}/; } if ( $form->{defaultcurrency} ) { $exchangerate = qq| <tr> <th align=right nowrap>| . $locale->text('Currency') . qq|</th> <td><select name=currency>$form->{selectcurrency}</select></td> <input type=hidden name=selectcurrency value="$form->{selectcurrency}"> <input type=hidden name=oldcurrency value=$form->{oldcurrency}> </tr> |; } if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->{exchangerate} = $form->format_amount( \%myconfig, $form->{exchangerate} ); if ( $form->{forex} ) { $exchangerate .= qq| <tr> <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td colspan=3><input type=hidden name=exchangerate size=10 value=$form->{exchangerate}>$form->{exchangerate}</td> </tr> |; } else { $exchangerate .= qq| <tr> <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td colspan=3><input name=exchangerate size=10 value=$form->{exchangerate}></td> </tr> |; } } $department = qq| <tr> <th align="right" nowrap>| . $locale->text('Department') . qq|</th> <td><select name=department>$form->{selectdepartment}</select> <input type=hidden name=selectdepartment value="| . $form->escape( $form->{selectdepartment}, 1 ) . qq|"> </td> </tr> | if $form->{selectdepartment}; $form->header; print qq| <body> <form method=post action=$form->{script}> |; $form->hide_form( qw(defaultcurrency closedto vc type formname arap ARAP title oldduedatefrom oldduedateto payment olddepartment) ); print qq| <table width=100%> <tr> <th class=listtop>$form->{title}</th> </tr> <tr height="5"></tr> <tr> <td> <table width=100%> <tr valign=top> <td> <table> <tr> <th align=right>| . $locale->text('Due Date') . qq| | . $locale->text('From') . qq|</th> <td><input name=duedatefrom value="$form->{duedatefrom}" title="$myconfig{dateformat}" size=11></td> <th align=right>| . $locale->text('To') . qq|</th> <td><input name=duedateto value="$form->{duedateto}" title="$myconfig{dateformat}" size=11></td> </tr> </table> </td> </td> <td align=right> <table> $department <tr> <th align=right nowrap>| . $locale->text( $form->{ARAP} ) . qq|</th> <td colspan=3><select name=$form->{ARAP}>$form->{"select$form->{ARAP}"}</select> </td> <input type=hidden name="select$form->{ARAP}" value="$form->{"select$form->{ARAP}"}"> </tr> <tr> <th align=right nowrap>| . $locale->text('Account') . qq|</th> <td colspan=3><select name=account>$form->{selectaccount}</select> <input type=hidden name=selectaccount value="$form->{selectaccount}"> </td> </tr> <tr> <th align=right nowrap>| . $locale->text('Date') . qq|</th> <td><input name=datepaid value="$form->{datepaid}" title="$myconfig{dateformat}" size=11></td> </tr> $exchangerate </table> </td> </tr> </table> </td> </tr> |; } sub invoices_due { @column_index = qw(name invnumber transdate amount due checked paid memo source); push @column_index, "language" if $form->{selectlanguage}; $colspan = $#column_index + 1; $invoice = $locale->text('Invoices'); $vclabel = ucfirst $form->{vc}; $vclabel = $locale->text($vclabel); print qq| <input type=hidden name=column_index value="id @column_index"> <tr> <td> <table width=100%> <tr> <th class=listheading colspan=$colspan>$invoice</th> </tr> |; $column_data{name} = qq|<th nowrap>$vclabel</th>|; $column_data{invnumber} = qq|<th nowrap>| . $locale->text('Invoice') . "</th>"; $column_data{transdate} = qq|<th nowrap>| . $locale->text('Date') . "</th>"; $column_data{amount} = qq|<th nowrap>| . $locale->text('Amount') . "</th>"; $column_data{due} = qq|<th nowrap>| . $locale->text('Amount Due') . "</th>"; $column_data{paid} = qq|<th nowrap>| . $locale->text('Amount') . "</th>"; $column_data{checked} = qq|<th nowrap>| . $locale->text('Select') . "</th>"; $column_data{memo} = qq|<th nowrap>| . $locale->text('Memo') . "</th>"; $column_data{source} = qq|<th nowrap>| . $locale->text('Source') . "</th>"; $column_data{language} = qq|<th nowrap>| . $locale->text('Language') . "</th>"; print qq| <tr> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; $form->{selectlanguage} = $form->unescape( $form->{selectlanguage} ); for $i ( 1 .. $form->{rowcount} ) { for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->parse_amount( \%myconfig, $form->{"${_}_$i"} ); } $totalamount += $form->{"amount_$i"}; $totaldue += $form->{"due_$i"}; if ( $form->{"paid_$i"} =~ /NaN/ ) { $form->{"paid_$i"} = ''; } else { $totalpaid += $form->{"paid_$i"}; } for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } $column_data{invnumber} = qq|<td>$form->{"invnumber_$i"}</td> <input type=hidden name="invnumber_$i" value="$form->{"invnumber_$i"}"> <input type=hidden name="id_$i" value=$form->{"id_$i"}>|; $column_data{transdate} = qq|<td>$form->{"transdate_$i"}</td> <input type=hidden name="transdate_$i" value=$form->{"transdate_$i"}>|; $column_data{amount} = qq|<td align=right>$form->{"amount_$i"}</td> <input type=hidden name="amount_$i" value=$form->{"amount_$i"}>|; $column_data{due} = qq|<td align=right>$form->{"due_$i"}</td> <input type=hidden name="due_$i" value=$form->{"due_$i"}>|; if ( $form->{"paid_$i"} =~ /NaN/ ) { $form->{"paid_$i"} = ''; } $column_data{paid} = qq|<td align=right><input name="paid_$i" size=10 value=$form->{"paid_$i"}></td>|; if ( $same_id eq $form->{"$form->{vc}_id_$i"} ) { for (qw(name memo source language)) { $column_data{$_} = qq|<td> </td>|; } } else { $column_data{name} = qq|<td>$form->{"name_$i"}</td>|; $column_data{memo} = qq|<td align=right><input name="memo_$i" size=10 value="$form->{"memo_$i"}"></td>|; $column_data{source} = qq|<td align=right><input name="source_$i" size=10 value="$form->{"source_$i"}"></td>|; if ( $form->{selectlanguage} ) { $selectlanguage = $form->{selectlanguage}; $selectlanguage =~ s/(<option value="\Q$form->{"language_code_$i"}\E")/$1 selected/; $column_data{language} = qq|<td><select name="language_code_$i">$selectlanguage</select></td>|; } } $column_data{name} .= qq| <input type=hidden name="name_$i" value="$form->{"name_$i"}"> <input type=hidden name="$form->{vc}_id_$i" value="$form->{"$form->{vc}_id_$i"}">|; $form->{"checked_$i"} = ( $form->{"checked_$i"} ) ? "checked" : ""; $column_data{checked} = qq|<td align=center><input name="checked_$i" type=checkbox class=checkbox $form->{"checked_$i"}></td>|; $j++; $j %= 2; print qq| <tr class=listrow$j> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; $same_id = $form->{"$form->{vc}_id_$i"}; } for (@column_index) { $column_data{$_} = "<td> </td>" } $column_data{amount} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totalamount, 2, " " ) . qq|</th>|; $column_data{due} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totaldue, 2, " " ) . qq|</th>|; $column_data{paid} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totalpaid, 2, " " ) . qq|</th>|; print qq| <tr class=listtotal> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> </table> </td> </tr> <input type=hidden name=selectlanguage value="| . $form->escape( $form->{selectlanguage}, 1 ) . qq|"> |; } sub payments_footer { $form->{DF}{ $form->{format} } = "selected"; $transdate = $form->datetonum( \%myconfig, $form->{datepaid} ); $closedto = $form->datetonum( \%myconfig, $form->{closedto} ); if ( ${LedgerSMB::Sysconfig::latex} ) { $media = qq|<select name=media> <option value=screen>| . $locale->text('Screen'); if ( %{LedgerSMB::Sysconfig::printer} ) { for ( sort keys %{LedgerSMB::Sysconfig::printer} ) { $media .= qq| <option value="$_">$_|; } } $media .= qq|</select>|; $format = qq|<select name=format> <option value=postscript $form->{DF}{postscript}>| . $locale->text('Postscript') . qq| <option value=pdf $form->{DF}{pdf}>| . $locale->text('PDF') . qq|</select>|; } print qq| <tr> <td><hr size=3 noshade></td> </tr> </table> |; # type=submit $locale->text('Update') # type=submit $locale->text('Post') # type=submit $locale->text('Print') # type=submit $locale->text('Select all') %button = ( 'update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, 'select_all' => { ndx => 2, key => 'A', value => $locale->text('Select all') }, 'print' => { ndx => 3, key => 'P', value => $locale->text('Print') }, 'post' => { ndx => 4, key => 'O', value => $locale->text('Post') }, ); if ( !${LedgerSMB::Sysconfig::latex} ) { delete $button{'print'}; } if ( $transdate <= $closedto ) { for ( 'post', 'print' ) { delete $button{$_} } $media = $format = ""; } for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button ) { $form->print_button( \%button, $_ ); } $media =~ s/(<option value="\Q$form->{media}\E")/$1 selected/; print qq| $format $media |; $form->hide_form(qw(callback rowcount path login sessionid)); if ( $form->{lynx} ) { require "bin/menu.pl"; &menubar; } print qq| </form> </body> </html> |; } sub select_all { for ( 1 .. $form->{rowcount} ) { $form->{"checked_$_"} = 1 } &{"update_$form->{payment}"} } sub update { my ($new_name_selected) = @_; &{"update_$form->{payment}"}; } sub update_payments { if ( $form->{ARAP} eq 'AR' ) { $buysell = "buy"; } else { $buysell = "sell"; } if ( ( $form->{oldduedatefrom} ne $form->{duedatefrom} ) || ( $form->{oldduedateto} ne $form->{duedateto} ) || ( $form->{department} ne $form->{olddepartment} ) ) { CP->get_openinvoices( \%myconfig, \%$form ); $form->{redo} = 1; } if ( $form->{currency} ne $form->{oldcurrency} ) { $form->{oldcurrency} = $form->{currency}; if ( !$form->{redo} ) { CP->get_openinvoices( \%myconfig, \%$form ); $form->{redo} = 1; } } for (qw(duedatefrom duedateto department)) { $form->{"old$_"} = $form->{$_}; } $form->{exchangerate} = $exchangerate if ( $form->{forex} = ( $exchangerate = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{datepaid}, $buysell ) ) ); if ( $form->{redo} ) { $form->{rowcount} = 0; $i = 0; foreach $ref ( @{ $form->{PR} } ) { $i++; for (qw(id name invnumber transdate)) { $form->{"${_}_$i"} = $ref->{$_}; } $form->{"$form->{vc}_id_$i"} = $ref->{"$form->{vc}_id"}; $ref->{exchangerate} = 1 unless $ref->{exchangerate}; $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate}; $form->{"due_$i"} = ( $ref->{amount} - $ref->{paid} ) / $ref->{exchangerate}; $form->{"checked_$i"} = ""; $form->{"paid_$i"} = ""; # need to format for (qw(amount due)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } } $form->{rowcount} = $i; } $form->{amount} = $form->parse_amount( \%myconfig, $form->{amount} ); # recalculate $amount = 0; for $i ( 1 .. $form->{rowcount} ) { for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->parse_amount( \%myconfig, $form->{"${_}_$i"} ); } if ( $form->{"checked_$i"} ) { # calculate paid_$i if ( !$form->{"paid_$i"} ) { $form->{"paid_$i"} = $form->{"due_$i"}; } $amount += $form->{"paid_$i"}; $form->{redo} = 1; } else { $form->{"paid_$i"} = ""; } for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } } $form->{amount} += ( $amount - $form->{oldamount} ) if $form->{redo}; &payments_header; &invoices_due; &payments_footer; } sub update_payment { if ( $form->{vc} eq 'customer' ) { $buysell = "buy"; } else { $buysell = "sell"; } $department = $form->{department}; # get customer/vendor &check_openvc; $form->{department} = $department; if ( $form->{datepaid} ne $form->{olddatepaid} ) { $form->{olddatepaid} = $form->{datepaid}; $form->{oldall_vc} = !$form->{oldall_vc} if $form->{all_vc}; } if ( $form->{department} ne $form->{olddepartment} ) { $form->{olddepartment} = $form->{department}; $form->{redo} = 1; } # if we switched to all_vc if ( $form->{all_vc} ne $form->{oldall_vc} ) { if ( $form->{"select$form->{vc}"} ) { $form->{redo} = ( $form->{"old$name"} ne $form->{$name} ); } else { $form->{redo} = ( $form->{"old$name"} ne qq|$form->{$name}--$form->{"${name}_id"}| ); } $form->{"select$form->{vc}"} = ""; if ( $form->{all_vc} ) { $form->all_vc( \%myconfig, $form->{vc}, $form->{ARAP}, undef, $form->{datepaid} ); if ( @{ $form->{"all_$form->{vc}"} } ) { for ( @{ $form->{"all_$form->{vc}"} } ) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|; } } } else { if ( ( $myconfig{vclimit} * 1 ) > 0 ) { $form->{ $form->{vc} } = ""; } CP->get_openvc( \%myconfig, \%$form ); if ( ( $myconfig{vclimit} * 1 ) > 0 ) { $form->{"all_$form->{vc}"} = $form->{name_list}; } if ( @{ $form->{"all_$form->{vc}"} } ) { $newvc = qq|$form->{"all_$form->{vc}"}[0]->{name}--$form->{"all_$form->{vc}"}[0]->{id}|; for ( @{ $form->{"all_$form->{vc}"} } ) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|; } # if the name is not the same if ( $form->{"select$form->{vc}"} !~ /$form->{$form->{vc}}/ ) { $form->{ $form->{vc} } = $newvc; &check_openvc; } } } if ( @{ $form->{all_language} } ) { $form->{selectlanguage} = "<option>\n"; for ( @{ $form->{all_language} } ) { $form->{selectlanguage} .= qq|<option value="$_->{code}">$_->{description}\n|; } } } if ( $new_name_selected || $form->{redo} ) { CP->get_openinvoices( \%myconfig, \%$form ); ($newvc) = split /--/, $form->{ $form->{vc} }; $form->{"old$form->{vc}"} = qq|$newvc--$form->{"$form->{vc}_id"}|; $form->{redo} = 1; } if ( $form->{currency} ne $form->{oldcurrency} ) { $form->{oldcurrency} = $form->{currency}; if ( !$form->{redo} ) { CP->get_openinvoices( \%myconfig, \%$form ); $form->{redo} = 1; } } $form->{exchangerate} = $exchangerate if ( $form->{forex} = ( $exchangerate = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{datepaid}, $buysell ) ) ); if ( $form->{redo} ) { $form->{rowcount} = 0; $i = 0; foreach $ref ( @{ $form->{PR} } ) { $i++; $form->{"id_$i"} = $ref->{id}; $form->{"invnumber_$i"} = $ref->{invnumber}; $form->{"transdate_$i"} = $ref->{transdate}; $ref->{exchangerate} = 1 unless $ref->{exchangerate}; $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate}; $form->{"due_$i"} = ( $ref->{amount} - $ref->{paid} ) / $ref->{exchangerate}; $form->{"checked_$i"} = ""; $form->{"paid_$i"} = ""; # need to format for (qw(amount due)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } } $form->{rowcount} = $i; } $form->{amount} = $form->parse_amount( \%myconfig, $form->{amount} ); # recalculate $amount = 0; for $i ( 1 .. $form->{rowcount} ) { for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->parse_amount( \%myconfig, $form->{"${_}_$i"} ); } if ( $form->{"checked_$i"} ) { # calculate paid_$i if ( !$form->{"paid_$i"} ) { $form->{"paid_$i"} = $form->{"due_$i"}; } $amount += $form->{"paid_$i"}; $form->{redo} = 1; } else { $form->{"paid_$i"} = ""; } for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } } $form->{amount} += ( $amount - $form->{oldamount} ) if $form->{redo}; &payment_header; &list_invoices; &payment_footer; } sub payment_header { $vclabel = ucfirst $form->{vc}; $vclabel = $locale->text($vclabel); if ( $form->{type} eq 'receipt' ) { $form->{title} = $locale->text('Receipt'); } if ( $form->{type} eq 'check' ) { $form->{title} = $locale->text('Payment'); } # $locale->text('Customer') # $locale->text('Vendor') if ( $form->{ $form->{vc} } eq "" ) { for (qw(address1 address2 city zipcode state country)) { $form->{$_} = ""; } } for ( "$form->{vc}", "department" ) { $form->{"select$_"} = $form->unescape( $form->{"select$_"} ); $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/; } for ( "account", "currency", "$form->{ARAP}" ) { $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/option>\Q$form->{$_}\E/option selected>$form->{$_}/; } if ( $form->{defaultcurrency} ) { $exchangerate = qq| <tr> <th align=right nowrap>| . $locale->text('Currency') . qq|</th> <td><select name=currency>$form->{selectcurrency}</select></td> <input type=hidden name=selectcurrency value="$form->{selectcurrency}"> <input type=hidden name=oldcurrency value=$form->{oldcurrency}> </tr> |; } if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->{exchangerate} = $form->format_amount( \%myconfig, $form->{exchangerate} ); if ( $form->{forex} ) { $exchangerate .= qq| <tr> <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td colspan=3><input type=hidden name=exchangerate size=10 value=$form->{exchangerate}>$form->{exchangerate}</td> </tr> |; } else { $exchangerate .= qq| <tr> <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td colspan=3><input name=exchangerate size=10 value=$form->{exchangerate}></td> </tr> |; } } $vc = ( $form->{"select$form->{vc}"} ) ? qq|<select name=$form->{vc}>$form->{"select$form->{vc}"}\n</select>| : qq|<input name=$form->{vc} size=35 value="$form->{$form->{vc}}">|; if ( $form->{all_vc} ) { $allvc = "checked"; } else { $allvc = ""; } # $locale->text('AR') # $locale->text('AP') $department = qq| <tr> <th align="right" nowrap>| . $locale->text('Department') . qq|</th> <td><select name=department>$form->{selectdepartment}</select> <input type=hidden name=selectdepartment value="| . $form->escape( $form->{selectdepartment}, 1 ) . qq|"> </td> </tr> | if $form->{selectdepartment}; $form->header; print qq| <body> <form method=post action=$form->{script}> |; $form->hide_form( qw(defaultcurrency closedto vc type ARAP arap title formname payment olddepartment) ); print qq| <table width=100%> <tr> <th class=listtop>$form->{title}</th> </tr> <tr height="5"></tr> <tr> <td> <table width=100%> <tr valign=top> <td> <table> <tr> <td align=right> <input name=all_vc type=checkbox class=checkbox value=Y $allvc> <input type=hidden name="oldall_vc" value="$form->{all_vc}"></td> <th align=left>| . $locale->text('All') . qq|</th> </tr> <tr> <th align=right>$vclabel</th> <td>$vc</td> <input type=hidden name="select$form->{vc}" value="| . $form->escape( $form->{"select$form->{vc}"}, 1 ) . qq|"> <input type=hidden name="$form->{vc}_id" value=$form->{"$form->{vc}_id"}> <input type=hidden name="old$form->{vc}" value="$form->{"old$form->{vc}"}"> </tr> <tr valign=top> <th align=right nowrap>| . $locale->text('Address') . qq|</th> <td colspan=2> <table> <tr> <td>$form->{address1}</td> </tr> <tr> <td>$form->{address2}</td> </tr> <td>$form->{city}</td> </tr> </tr> <td>$form->{state}</td> </tr> </tr> <td>$form->{zipcode}</td> </tr> <tr> <td>$form->{country}</td> </tr> </table> </td> <input type=hidden name=address1 value="$form->{address1}"> <input type=hidden name=address2 value="$form->{address2}"> <input type=hidden name=city value="$form->{city}"> <input type=hidden name=state value="$form->{state}"> <input type=hidden name=zipcode value="$form->{zipcode}"> <input type=hidden name=country value="$form->{country}"> </tr> <tr> <th align=right>| . $locale->text('Memo') . qq|</th> <td colspan=2><input name="memo" size=30 value="$form->{memo}"></td> </tr> </table> </td> <td align=right> <table> $department <tr> <th align=right nowrap>| . $locale->text( $form->{ARAP} ) . qq|</th> <td colspan=3><select name=$form->{ARAP}>$form->{"select$form->{ARAP}"}</select> </td> <input type=hidden name="select$form->{ARAP}" value="$form->{"select$form->{ARAP}"}"> </tr> <tr> <th align=right nowrap>| . $locale->text('Account') . qq|</th> <td colspan=3><select name=account>$form->{selectaccount}</select> <input type=hidden name=selectaccount value="$form->{selectaccount}"> </td> </tr> <tr> <th align=right nowrap>| . $locale->text('Date') . qq|</th> <td><input name=datepaid value="$form->{datepaid}" title="$myconfig{dateformat}" size=11></td> <input type=hidden name=olddatepaid value=$form->{olddatepaid}> </tr> $exchangerate <tr> <th align=right nowrap>| . $locale->text('Source') . qq|</th> <td colspan=3><input name=source value="$form->{source}" size=10></td> </tr> <tr> <th align=right nowrap>| . $locale->text('Amount') . qq|</th> <td colspan=3><input name=amount size=10 value=| . $form->format_amount( \%myconfig, $form->{amount}, 2 ) . qq|></td> <input type=hidden name=oldamount value=$form->{amount}> </tr> </table> </td> </tr> </table> </td> </tr> |; } sub list_invoices { @column_index = qw(invnumber transdate amount due checked paid); $colspan = $#column_index + 1; $invoice = $locale->text('Invoices'); print qq| <input type=hidden name=column_index value="id @column_index"> <tr> <td> <table width=100%> <tr> <th class=listheading colspan=$colspan>$invoice</th> </tr> |; $column_data{invnumber} = qq|<th nowrap>| . $locale->text('Invoice') . "</th>"; $column_data{transdate} = qq|<th nowrap>| . $locale->text('Date') . "</th>"; $column_data{amount} = qq|<th nowrap>| . $locale->text('Amount') . "</th>"; $column_data{due} = qq|<th nowrap>| . $locale->text('Amount Due') . "</th>"; $column_data{paid} = qq|<th nowrap>| . $locale->text('Amount') . "</th>"; $column_data{checked} = qq|<th nowrap>| . $locale->text('Select') . "</th>"; print qq| <tr> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; for $i ( 1 .. $form->{rowcount} ) { for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->parse_amount( \%myconfig, $form->{"${_}_$i"} ); } $totalamount += $form->{"amount_$i"}; $totaldue += $form->{"due_$i"}; if ( $form->{"paid_$i"} !~ /NaN/ ) { $totalpaid += $form->{"paid_$i"}; } for (qw(amount due paid)) { $form->{"${_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 ); } $column_data{invnumber} = qq|<td>$form->{"invnumber_$i"}</td> <input type=hidden name="invnumber_$i" value="$form->{"invnumber_$i"}"> <input type=hidden name="id_$i" value=$form->{"id_$i"}>|; $column_data{transdate} = qq|<td width=15%>$form->{"transdate_$i"}</td> <input type=hidden name="transdate_$i" value=$form->{"transdate_$i"}>|; $column_data{amount} = qq|<td align=right width=15%>$form->{"amount_$i"}</td> <input type=hidden name="amount_$i" value=$form->{"amount_$i"}>|; $column_data{due} = qq|<td align=right width=15%>$form->{"due_$i"}</td> <input type=hidden name="due_$i" value=$form->{"due_$i"}>|; if ( $form->{"paid_$i"} =~ /NaN/ ) { $form->{"paid_$i"} = ''; } $column_data{paid} = qq|<td align=right width=15%><input name="paid_$i" size=10 value=$form->{"paid_$i"}></td>|; $form->{"checked_$i"} = ( $form->{"checked_$i"} ) ? "checked" : ""; $column_data{checked} = qq|<td align=center width=10%><input name="checked_$i" type=checkbox class=checkbox $form->{"checked_$i"}></td>|; $j++; $j %= 2; print qq| <tr class=listrow$j> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; } for (@column_index) { $column_data{$_} = "<td> </td>" } $column_data{amount} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totalamount, 2, " " ) . qq|</th>|; $column_data{due} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totaldue, 2, " " ) . qq|</th>|; $column_data{paid} = qq|<th class=listtotal align=right>| . $form->format_amount( \%myconfig, $totalpaid, 2, " " ) . qq|</th>|; print qq| <tr class=listtotal> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> </table> </td> </tr> |; } sub payment_footer { $form->{DF}{ $form->{format} } = "selected"; $transdate = $form->datetonum( \%myconfig, $form->{datepaid} ); $closedto = $form->datetonum( \%myconfig, $form->{closedto} ); if ( ${LedgerSMB::Sysconfig::latex} ) { if ( $form->{selectlanguage} ) { $form->{"selectlanguage"} = $form->unescape( $form->{"selectlanguage"} ); $form->{"selectlanguage"} =~ s/ selected//; $form->{"selectlanguage"} =~ s/(<option value="\Q$form->{language_code}\E")/$1 selected/; $lang = qq|<select name=language_code>$form->{selectlanguage}</select> <input type=hidden name=selectlanguage value="| . $form->escape( $form->{selectlanguage}, 1 ) . qq|">|; } $media = qq|<select name=media> <option value=screen>| . $locale->text('Screen'); if ( %{LedgerSMB::Sysconfig::printer} ) { for ( sort keys %{LedgerSMB::Sysconfig::printer} ) { $media .= qq| <option value="$_">$_|; } } $media .= qq|</select>|; $format = qq|<select name=format> <option value=postscript $form->{DF}{postscript}>| . $locale->text('Postscript') . qq| <option value=pdf $form->{DF}{pdf}>| . $locale->text('PDF') . qq|</select>|; } print qq| <tr> <td><hr size=3 noshade></td> </tr> </table> |; %button = ( 'update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, 'select_all' => { ndx => 2, key => 'A', value => $locale->text('Select all') }, 'print' => { ndx => 3, key => 'P', value => $locale->text('Print') }, 'post' => { ndx => 4, key => 'O', value => $locale->text('Post') }, ); if ( !${LedgerSMB::Sysconfig::latex} ) { delete $button{'print'}; } if ( $transdate <= $closedto ) { for ( 'post', 'print' ) { delete $button{$_} } $media = $format = ""; } for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button ) { $form->print_button( \%button, $_ ); } $media =~ s/(<option value="\Q$form->{media}\E")/$1 selected/; print qq| $lang $format $media |; $form->hide_form(qw(callback rowcount path login sessionid)); if ( $form->{lynx} ) { require "bin/menu.pl"; &menubar; } print qq| </form> </body> </html> |; } sub post { &default_date; &{"post_$form->{payment}"}; } sub post_payments { if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->error( $locale->text('Exchange rate missing!') ) unless $form->{exchangerate}; } if ( CP->post_payments( \%myconfig, \%$form ) ) { $form->redirect( $locale->text('Payments posted!') ); } else { $form->error( $locale->text('Posting failed!') ); } } sub post_payment { &check_form; if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->error( $locale->text('Exchange rate missing!') ) unless $form->{exchangerate}; } $msg1 = "$form->{title} posted!"; $msg2 = "Cannot post $form->{title}!"; # $locale->text('Payment posted!') # $locale->text('Receipt posted!') # $locale->text('Cannot post Payment!') # $locale->text('Cannot post Receipt!') $form->{amount} = $form->format_amount( \%myconfig, $form->{amount}, 2 ); $source = $form->{source}; $source =~ s/(\d+)/$1 + 1/e; if ( $form->{callback} ) { $form->{callback} .= "&source=$source"; } if ( CP->post_payment( \%myconfig, \%$form ) ) { $form->redirect( $locale->text($msg1) ); } else { $form->error( $locale->text($msg2) ); } } sub print { &{"print_$form->{payment}"}; &update if $form->{media} ne 'screen'; } sub print_payments { $form->error( $locale->text('Select postscript or PDF!') ) if ( $form->{format} !~ /(postscript|pdf)/ ); $SIG{INT} = 'IGNORE'; for (qw(company address)) { $form->{$_} = $myconfig{$_} } $form->{address} =~ s/\\n/\n/g; %oldform = (); for ( keys %$form ) { $oldform{$_} = $form->{$_} } @a = qw(name company address text_amount text_decimal address1 address2 city state zipcode country memo); for (@a) { $temp{$_} = $form->{$_} } $form->format_string(@a); $ok = 0; $j = 0; $temp{rowcount} = $form->{rowcount}; for $i ( 1 .. $temp{rowcount} ) { if ( $form->{"$form->{vc}_id_$i"} ne $form->{"$form->{vc}_id"} ) { $form->{rowcount} = $j; for ( 1 .. $j ) { $form->{"id_$_"} = $temp{"id_$_"} } &print_form if $ok; $ok = 0; $j = 0; $form->{amount} = 0; for (qw(invnumber invdate due paid)) { @{ $form->{$_} } = () } for (qw(language_code source memo)) { $form->{$_} = $form->{"${_}_$i"}; } } if ( $form->{"checked_$i"} ) { $j++; $ok = 1; $temp{"id_$j"} = $form->{"id_$i"}; $form->{"invdate_$i"} = $form->{"transdate_$i"}; for (qw(invnumber invdate due paid)) { push @{ $form->{$_} }, $form->{"${_}_$i"}; } $form->{amount} += $form->parse_amount( \%myconfig, $form->{"paid_$i"} ); $form->{"$form->{vc}_id"} = $form->{"$form->{vc}_id_$i"}; } } $form->{rowcount} = $j; for ( 1 .. $j ) { $form->{"id_$_"} = $temp{"id_$_"} } &print_form if $ok; for ( keys %oldform ) { $form->{$_} = $oldform{$_} } } sub print_form { $c = CP->new( ( $form->{language_code} ) ? $form->{language_code} : $myconfig{countrycode} ); $c->init; ( $whole, $form->{decimal} ) = split /\./, $form->{amount}; $form->{amount} = $form->format_amount( \%myconfig, $form->{amount}, 2 ); $form->{decimal} .= "00"; $form->{decimal} = substr( $form->{decimal}, 0, 2 ); $form->{text_decimal} = $c->num2text( $form->{decimal} * 1 ); $form->{text_amount} = $c->num2text($whole); $form->{integer_amount} = $form->format_amount( $myconfig, $whole ); $datepaid = $form->datetonum( \%myconfig, $form->{datepaid} ); ( $form->{yyyy}, $form->{mm}, $form->{dd} ) = $datepaid =~ /(....)(..)(..)/; &{"$form->{vc}_details"}; $form->{templates} = "$myconfig{templates}"; $form->{IN} = "$form->{formname}.tex"; if ( $form->{media} ne 'screen' ) { $form->{OUT} = ${LedgerSMB::Sysconfig::printer}{ $form->{media} }; $form->{printmode} = '|-'; } $form->parse_template( \%myconfig, ${LedgerSMB::Sysconfig::userspath} ); } sub print_payment { &check_form; for (qw(company address)) { $form->{$_} = $myconfig{$_} } $form->{address} =~ s/\\n/\n/g; @a = qw(rowcount name company address text_amount text_decimal address1 address2 city state zipcode country memo); %temp = (); for (@a) { $temp{$_} = $form->{$_} } if ( scalar @{ $form->{invnumber} } > ${LedgerSMB::Sysconfig::check_max_invoices} ) { $#{ $form->{invnumber} } = ${LedgerSMB::Sysconfig::check_max_invoices} - 1; $form->{invnumbers_maxed} = 1; $form->{message} = $locale->text( "Please see attatched report for list of invoices paid."); } $form->format_string(@a); &print_form; for ( keys %temp ) { $form->{$_} = $temp{$_} } } sub customer_details { IS->customer_details( \%myconfig, \%$form ) } sub vendor_details { IR->vendor_details( \%myconfig, \%$form ) } sub check_form { &check_openvc; if ( $form->{currency} ne $form->{oldcurrency} ) { &update; exit; } $form->error( $locale->text('Date missing!') ) unless $form->{datepaid}; $closedto = $form->datetonum( \%myconfig, $form->{closedto} ); $datepaid = $form->datetonum( \%myconfig, $form->{datepaid} ); $form->error( $locale->text('Cannot post payment for a closed period!') ) if ( $datepaid <= $closedto ); $form->{datepaid} = $locale->date( \%myconfig, $form->{datepaid} ); $amount = $form->parse_amount( \%myconfig, $form->{amount} ); $form->{amount} = $amount; for $i ( 1 .. $form->{rowcount} ) { if ( $form->{"paid_$i"} ) { $amount -= $form->parse_amount( \%myconfig, $form->{"paid_$i"} ); push( @{ $form->{paid} }, $form->{"paid_$i"} ); push( @{ $form->{due} }, $form->{"due_$i"} ); push( @{ $form->{invnumber} }, $form->{"invnumber_$i"} ); push( @{ $form->{invdate} }, $form->{"transdate_$i"} ); } } if ( $form->round_amount( $amount, 2 ) != 0 ) { push( @{ $form->{paid} }, $form->format_amount( \%myconfig, $amount, 2 ) ); push( @{ $form->{due} }, $form->format_amount( \%myconfig, 0, "0" ) ); push( @{ $form->{invnumber} }, ( $form->{ARAP} eq 'AR' ) ? $locale->text('Deposit') : $locale->text('Prepayment') ); push( @{ $form->{invdate} }, $form->{datepaid} ); } } sub check_openvc { $name = $form->{vc}; ( $new_name, $new_id ) = split /--/, $form->{$name}; if ( $form->{all_vc} ) { if ( $form->{"select$name"} ) { $ok = ( $form->{"old$name"} ne $form->{$name} ); } else { $ok = ( $form->{"old$name"} ne qq|$form->{$name}--$form->{"${name}_id"}| ); } if ($ok) { $form->{redo} = 1; if ( $form->{"select$name"} ) { $form->{"${name}_id"} = $new_id; AA->get_name( \%myconfig, \%$form ); $form->{$name} = $form->{"old$name"} = "$new_name--$new_id"; } else { &check_name( $form->{vc} ); } } } else { # if we use a selection if ( $form->{"select$name"} ) { if ( $form->{"old$name"} ne $form->{$name} ) { $form->{"${name}_id"} = $new_id; AA->get_name( \%myconfig, \%$form ); $form->{$name} = $form->{"old$name"} = "$new_name--$new_id"; $form->{redo} = 1; } } else { # check name, combine name and id if ( $form->{"old$name"} ne qq|$form->{$name}--$form->{"${name}_id"}| ) { # return one name or a list of names in $form->{name_list} if ( ( $rv = CP->get_openvc( \%myconfig, \%$form ) ) > 1 ) { $form->{redo} = 1; &select_name($name); exit; } if ( $rv == 1 ) { # we got one name $form->{"${name}_id"} = $form->{name_list}[0]->{id}; $form->{$name} = $form->{name_list}[0]->{name}; $form->{"old$name"} = qq|$form->{$name}--$form->{"${name}_id"}|; AA->get_name( \%myconfig, \%$form ); } else { # nothing open $form->error( $locale->text('Nothing open!') ); } $form->{redo} = 1; } } } }