#===================================================================== # 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) 2001 # # Author: DWS Systems Inc. # Web: http://www.sql-ledger.org # # # 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. #====================================================================== # # Inventory received module # #====================================================================== use LedgerSMB::IR; use LedgerSMB::PE; use LedgerSMB::Tax; require "bin/io.pl"; require "bin/arap.pl"; 1; # end of main sub add { $form->{title} = $locale->text('Add Vendor Invoice'); $form->{callback} = "$form->{script}?action=add&type=$form->{type}&login=$form->{login}&path=$form->{path}&sessionid=$form->{sessionid}" unless $form->{callback}; &invoice_links; &prepare_invoice; &display_form; } sub edit { $form->{title} = $locale->text('Edit Vendor Invoice'); &invoice_links; &prepare_invoice; &display_form; } sub invoice_links { $form->{vc} = "vendor"; $form->{type} = "invoice"; # create links $form->create_links("AP", \%myconfig, "vendor", 1); # currencies @curr = split /:/, $form->{currencies}; $form->{defaultcurrency} = $curr[0]; chomp $form->{defaultcurrency}; for (@curr) { $form->{selectcurrency} .= "<option>$_\n" } if (@{ $form->{all_vendor} }) { unless ($form->{vendor_id}) { $form->{vendor_id} = $form->{all_vendor}->[0]->{id}; } } AA->get_name(\%myconfig, \%$form); delete $form->{notes}; IR->retrieve_invoice(\%myconfig, \%$form); $form->{oldlanguage_code} = $form->{language_code}; $form->get_partsgroup(\%myconfig, { language_code => $form->{language_code} }); if (@ { $form->{all_partsgroup} }) { $form->{selectpartsgroup} = "<option>\n"; foreach $ref (@ { $form->{all_partsgroup} }) { if ($ref->{translation}) { $form->{selectpartsgroup} .= qq|<option value="$ref->{partsgroup}--$ref->{id}">$ref->{translation}\n|; } else { $form->{selectpartsgroup} .= qq|<option value="$ref->{partsgroup}--$ref->{id}">$ref->{partsgroup}\n|; } } } if (@{ $form->{all_project} }) { $form->{selectprojectnumber} = "<option>\n"; for (@{ $form->{all_project} }) { $form->{selectprojectnumber} .= qq|<option value="$_->{projectnumber}--$_->{id}">$_->{projectnumber}\n| } } $form->{oldvendor} = "$form->{vendor}--$form->{vendor_id}"; $form->{oldtransdate} = $form->{transdate}; # vendors $form->{selectvendor} = ""; if (@{ $form->{all_vendor} }) { $form->{vendor} = "$form->{vendor}--$form->{vendor_id}"; for (@{ $form->{all_vendor} }) { $form->{selectvendor} .= 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_id}; 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| } } # forex $form->{forex} = $form->{exchangerate}; $exchangerate = ($form->{exchangerate}) ? $form->{exchangerate} : 1; foreach $key (keys %{ $form->{AP_links} }) { $form->{"select$key"} = ""; foreach $ref (@{ $form->{AP_links}{$key} }) { $form->{"select$key"} .= "<option>$ref->{accno}--$ref->{description}\n"; } if ($key eq "AP_paid") { for $i (1 .. scalar @{ $form->{acc_trans}{$key} }) { $form->{"AP_paid_$i"} = "$form->{acc_trans}{$key}->[$i-1]->{accno}--$form->{acc_trans}{$key}->[$i-1]->{description}"; # reverse paid $form->{"paid_$i"} = $form->{acc_trans}{$key}->[$i-1]->{amount}; $form->{"datepaid_$i"} = $form->{acc_trans}{$key}->[$i-1]->{transdate}; $form->{"forex_$i"} = $form->{"exchangerate_$i"} = $form->{acc_trans}{$key}->[$i-1]->{exchangerate}; $form->{"source_$i"} = $form->{acc_trans}{$key}->[$i-1]->{source}; $form->{"memo_$i"} = $form->{acc_trans}{$key}->[$i-1]->{memo}; $form->{"cleared_$i"} = $form->{acc_trans}{$key}->[$i-1]->{cleared}; $form->{paidaccounts} = $i; } } else { $form->{$key} = "$form->{acc_trans}{$key}->[0]->{accno}--$form->{acc_trans}{$key}->[0]->{description}" if $form->{acc_trans}{$key}->[0]->{accno}; } } $form->{paidaccounts} = 1 unless (exists $form->{paidaccounts}); $form->{AP} = $form->{AP_1} unless $form->{id}; $form->{locked} = ($form->{revtrans}) ? '1' : ($form->datetonum(\%myconfig, $form->{transdate}) <= $form->datetonum(\%myconfig, $form->{closedto})); if (! $form->{readonly}) { $form->{readonly} = 1 if $myconfig{acs} =~ /AP--Vendor Invoice/; } } sub prepare_invoice { $form->{type} = "invoice"; $form->{currency} =~ s/ //g; $form->{oldcurrency} = $form->{currency}; if ($form->{id}) { for (qw(invnumber ordnumber ponumber quonumber)) { $form->{$_} = $form->quote($form->{$_}) } foreach $ref (@{ $form->{invoice_details} }) { $i++; for (keys %$ref) { $form->{"${_}_$i"} = $ref->{$_} } $form->{"projectnumber_$i"} = qq|$ref->{projectnumber}--$ref->{project_id}| if $ref->{project_id}; $form->{"partsgroup_$i"} = qq|$ref->{partsgroup}--$ref->{partsgroup_id}| if $ref->{partsgroup_id}; $form->{"discount_$i"} = $form->format_amount(\%myconfig, $form->{"discount_$i"} * 100); ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); $form->{"oldqty_$i"} = $form->{"qty_$i"}; for (qw(partnumber sku description unit)) { $form->{"${_}_$i"} = $form->quote($form->{"${_}_$i"}) } $form->{rowcount} = $i; } } } sub form_header { # set option selected for (qw(AP currency)) { $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/option>\Q$form->{$_}\E/option selected>$form->{$_}/; } for (qw(vendor department)) { $form->{"select$_"} = $form->unescape($form->{"select$_"}); $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/; } 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| <tr> <th align=right nowrap>|.$locale->text('Language').qq|</th> <td><select name=language_code>$form->{selectlanguage}</select></td> <input type=hidden name=oldlanguage_code value=$form->{oldlanguage_code}> <input type=hidden name="selectlanguage" value="|. $form->escape($form->{selectlanguage},1).qq|"> </tr> |; } $form->{exchangerate} = $form->format_amount(\%myconfig, $form->{exchangerate}); $exchangerate = qq|<tr>|; $exchangerate .= qq| <th align=right nowrap>|.$locale->text('Currency').qq|</th> <td><select name=currency>$form->{selectcurrency}</select></td> | if $form->{defaultcurrency}; $exchangerate .= qq| <input type=hidden name=selectcurrency value="$form->{selectcurrency}"> <input type=hidden name=defaultcurrency value=$form->{defaultcurrency}> |; if ($form->{defaultcurrency} && $form->{currency} ne $form->{defaultcurrency}) { if ($form->{forex}) { $exchangerate .= qq| <th align=right nowrap>|.$locale->text('Exchange Rate').qq|</th> <td>$form->{exchangerate}<input type=hidden name=exchangerate value=$form->{exchangerate}></td> |; } else { $exchangerate .= qq| <th align=right nowrap>|.$locale->text('Exchange Rate').qq|</th> <td><input name=exchangerate size=10 value=$form->{exchangerate}></td> |; } } $exchangerate .= qq| <input type=hidden name=forex value=$form->{forex}> </tr> |; if ($form->{selectvendor}) { $vendor = qq|<select name=vendor>$form->{selectvendor}</select> <input type=hidden name="selectvendor" value="|. $form->escape($form->{selectvendor},1).qq|">|; } else { $vendor = qq|<input name=vendor value="$form->{vendor}" size=35>|; } $department = qq| <tr> <th align="right" nowrap>|.$locale->text('Department').qq|</th> <td colspan=3><select name=department>$form->{selectdepartment}</select> <input type=hidden name=selectdepartment value="|. $form->escape($form->{selectdepartment},1).qq|"> </td> </tr> | if $form->{selectdepartment}; $n = ($form->{creditremaining} < 0) ? "0" : "1"; $i = $form->{rowcount} + 1; $focus = "partnumber_$i"; $form->header; print qq| <body onLoad="document.forms[0].${focus}.focus()" /> <form method=post action="$form->{script}"> |; $form->{vc} = "vendor"; $form->hide_form(qw(id title vc type terms creditlimit creditremaining closedto locked shipped oldtransdate recurring)); print qq| <table width=100%> <tr class=listtop> <th>$form->{title}</th> </tr> <tr height="5"></tr> <tr> <td> <table width=100%> <tr valign=top> <td> <table> <tr> <th align=right nowrap>|.$locale->text('Vendor').qq|</th> <td colspan=3>$vendor</td> <input type=hidden name=vendor_id value=$form->{vendor_id}> <input type=hidden name=oldvendor value="$form->{oldvendor}"> </tr> <tr> <td></td> <td colspan=3> <table> <tr> <th nowrap>|.$locale->text('Credit Limit').qq|</th> <td>|.$form->format_amount(\%myconfig, $form->{creditlimit}, 0, "0").qq|</td> <td width=20%></td> <th nowrap>|.$locale->text('Remaining').qq|</th> <td class="plus$n" nowrap>|.$form->format_amount(\%myconfig, $form->{creditremaining}, 0, "0").qq|</td> </tr> </table> </td> <tr> <th align=right>|.$locale->text('Record in').qq|</th> <td colspan=3><select name=AP>$form->{selectAP}</select></td> <input type=hidden name=selectAP value="$form->{selectAP}"> </tr> $department $exchangerate </table> </td> <td align=right> <table> <tr> <th align=right nowrap>|.$locale->text('Invoice Number').qq|</th> <td><input name=invnumber size=20 value="$form->{invnumber}"></td> </tr> <tr> <th align=right nowrap>|.$locale->text('Order Number').qq|</th> <td><input name=ordnumber size=20 value="$form->{ordnumber}"></td> <input type=hidden name=quonumber value="$form->{quonumber}"> </tr> <tr> <th align=right nowrap>|.$locale->text('Invoice Date').qq|</th> <td><input name=transdate size=11 title="$myconfig{dateformat}" value=$form->{transdate}></td> </tr> <tr> <th align=right nowrap>|.$locale->text('Due Date').qq|</th> <td><input name=duedate size=11 title="$myconfig{dateformat}" value=$form->{duedate}></td> </tr> <tr> <th align=right nowrap>|.$locale->text('PO Number').qq|</th> <td><input name=ponumber size=20 value="$form->{ponumber}"></td> </tr> $lang </table> </td> </tr> </table> </td> </tr> |; $form->hide_form(qw(selectcurrency defaultcurrency taxaccounts)); for (split / /, $form->{taxaccounts}) { $form->hide_form("${_}_rate", "${_}_description") } } sub form_footer { $form->{invtotal} = $form->{invsubtotal}; if (($rows = $form->numtextrows($form->{notes}, 35, 8)) < 2) { $rows = 2; } if (($introws = $form->numtextrows($form->{intnotes}, 35, 8)) < 2) { $introws = 2; } $rows = ($rows > $introws) ? $rows : $introws; $notes = qq|<textarea name=notes rows=$rows cols=35 wrap=soft>$form->{notes}</textarea>|; $intnotes = qq|<textarea name=intnotes rows=$rows cols=35 wrap=soft>$form->{intnotes}</textarea>|; $form->{taxincluded} = ($form->{taxincluded}) ? "checked" : ""; $taxincluded = ""; if ($form->{taxaccounts}) { $taxincluded = qq| <input name=taxincluded class=checkbox type=checkbox value=1 $form->{taxincluded}> <b>|.$locale->text('Tax Included').qq|</b> |; } if (!$form->{taxincluded}) { my @taxset = Tax::init_taxes($form, $form->{taxaccounts}); $form->{invtotal} += $form->round_amount( Tax::calculate_taxes(\@taxset, $form, $form->{invsubtotal}, 0), 2); foreach $taxobj (@taxset) { $item = $taxobj->account; if ($form->{"${item}_base"}) { $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->round_amount($taxobj->value, 2), 2); $tax .= qq| <tr> <th align=right>$form->{"${item}_description"}</th> <td align=right>$form->{"${item}_total"}</td> </tr> |; } } $form->{invsubtotal} = $form->format_amount(\%myconfig, $form->{invsubtotal}, 2, 0); $subtotal = qq| <tr> <th align=right>|.$locale->text('Subtotal').qq|</th> <td align=right>$form->{invsubtotal}</td> </tr> |; } $form->{oldinvtotal} = $form->{invtotal}; $form->{invtotal} = $form->format_amount(\%myconfig, $form->{invtotal}, 2, 0); print qq| <tr> <td> <table width=100%> <tr valign=bottom> <td> <table> <tr> <th align=left>|.$locale->text('Notes').qq|</th> <th align=left>|.$locale->text('Internal Notes').qq|</th> <th align=left>|.$locale->text('Import Text').qq|</th> </tr> <tr valign=top> <td>$notes</td> <td>$intnotes</td> <td><textarea name=import_text rows=$rows cols=25></textarea> </tr> </table> </td> <td align=right> $taxincluded <br> <table> $subtotal $tax <tr> <th align=right>|.$locale->text('Total').qq|</th> <td align=right>$form->{invtotal}</td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td> <table width=100%> <tr> <th colspan=6 class=listheading>|.$locale->text('Payments').qq|</th> </tr> |; if ($form->{currency} eq $form->{defaultcurrency}) { @column_index = qw(datepaid source memo paid AP_paid); } else { @column_index = qw(datepaid source memo paid exchangerate AP_paid); } $column_data{datepaid} = "<th>".$locale->text('Date')."</th>"; $column_data{paid} = "<th>".$locale->text('Amount')."</th>"; $column_data{exchangerate} = "<th>".$locale->text('Exch')."</th>"; $column_data{AP_paid} = "<th>".$locale->text('Account')."</th>"; $column_data{source} = "<th>".$locale->text('Source')."</th>"; $column_data{memo} = "<th>".$locale->text('Memo')."</th>"; print qq| <tr> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; $form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"}); for $i (1 .. $form->{paidaccounts}) { $form->hide_form("cleared_$i"); print qq| <tr> |; $form->{"selectAP_paid_$i"} = $form->{selectAP_paid}; $form->{"selectAP_paid_$i"} =~ s/option>\Q$form->{"AP_paid_$i"}\E/option selected>$form->{"AP_paid_$i"}/; # format amounts $totalpaid += $form->{"paid_$i"}; $form->{"paid_$i"} = $form->format_amount(\%myconfig, $form->{"paid_$i"}, 2); $form->{"exchangerate_$i"} = $form->format_amount(\%myconfig, $form->{"exchangerate_$i"}); $exchangerate = qq| |; if ($form->{currency} ne $form->{defaultcurrency}) { if ($form->{"forex_$i"}) { $exchangerate = qq|<input type=hidden name="exchangerate_$i" value=$form->{"exchangerate_$i"}>$form->{"exchangerate_$i"}|; } else { $exchangerate = qq|<input name="exchangerate_$i" size=10 value=$form->{"exchangerate_$i"}>|; } } $exchangerate .= qq| <input type=hidden name="forex_$i" value=$form->{"forex_$i"}> |; $column_data{"paid_$i"} = qq|<td align=center><input name="paid_$i" size=11 value=$form->{"paid_$i"}></td>|; $column_data{"exchangerate_$i"} = qq|<td align=center>$exchangerate</td>|; $column_data{"AP_paid_$i"} = qq|<td align=center><select name="AP_paid_$i">$form->{"selectAP_paid_$i"}</select></td>|; $column_data{"datepaid_$i"} = qq|<td align=center><input name="datepaid_$i" size=11 title="$myconfig{dateformat}" value=$form->{"datepaid_$i"}></td>|; $column_data{"source_$i"} = qq|<td align=center><input name="source_$i" size=11 value="$form->{"source_$i"}"></td>|; $column_data{"memo_$i"} = qq|<td align=center><input name="memo_$i" size=11 value="$form->{"memo_$i"}"></td>|; for (@column_index) { print qq|$column_data{"${_}_$i"}\n| } print qq| </tr> |; } $form->{oldtotalpaid} = $totalpaid; $form->hide_form(qw(paidaccounts selectAP_paid oldinvtotal oldtotalpaid)); print qq| </table> </td> </tr> <tr> <td><hr size=3 noshade></td> </tr> </table> <br> |; $transdate = $form->datetonum(\%myconfig, $form->{transdate}); $closedto = $form->datetonum(\%myconfig, $form->{closedto}); # type=submit $locale->text('Update') # type=submit $locale->text('Post') # type=submit $locale->text('Post as new') # type=submit $locale->text('Schedule') # type=submit $locale->text('Purchase Order') # type=submit $locale->text('Delete') if (! $form->{readonly}) { %button = ('update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, 'post' => { ndx => 3, key => 'O', value => $locale->text('Post') }, 'post_as_new' => { ndx => 5, key => 'N', value => $locale->text('Post as new') }, 'purchase_order' => { ndx => 6, key => 'L', value => $locale->text('Purchase Order') }, 'schedule' => { ndx => 7, key => 'H', value => $locale->text('Schedule') }, 'delete' => { ndx => 8, key => 'D', value => $locale->text('Delete') }, ); if ($form->{id}) { if ($form->{locked}) { for ("post", "delete") { delete $button{$_} } } } else { if ($transdate > $closedto) { for ('update', 'post', 'schedule') { $allowed{$_} = 1 } for (keys %button) { delete $button{$_} if ! $allowed{$_} } } elsif ($closedto){ %buttons = (); } } for (sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button) { $form->print_button(\%button, $_) } } if ($form->{lynx}) { require "bin/menu.pl"; &menubar; } $form->hide_form(qw(rowcount callback path login sessionid)); print qq| </form> </body> </html> |; } sub import_text { my @o_list; my @i_lines = split(/(\n|\r|\r\n)/, $form->{import_text}); foreach $i (@i_lines){ chomp($i); if ($i ne ""){ # Strip out blank lines push @o_list, $i; } } my $c = 1; my $linenumber = 0; foreach $l (@o_list){ if ($c % 2){ $linenumber += 1; $form->{"partnumber_$linenumber"} = $l; } else { $form->{"qty_$linenumber"} = $l; } $c += 1; $form->{rowcount}=$linenumber; IR->retrieve_item(\%myconfig, \%$form); $rows = scalar @{ $form->{item_list} }; $rows = 0 unless $rows; $i = $form->{rowcount}; if ($rows = 0){ $form->{"id_$i"} = 0; $form->{"unit_$i"} = $locale->text('ea'); &new_item; } elsif ($rows > 1){ &select_item; exit; } else { map { $form->{item_list}[$i]{$_} = $form->quote($form->{item_list}[$i]{$_}) } qw(partnumber description unit); map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; ($dec) = ($s =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * (1 - $form->{"discount_$i"} / 100); map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); if (!$form->{taxincluded}) { my @taxes = Tax::init_taxes($form, $form->{taxaccounts}); $amount += (Tax::calculate_taxes(\@taxes, $form, $amount, 0)); } $form->{creditremaining} -= $amount; $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); } $form->{item_list} = []; } ++$form->{rowcount} } sub update { if($form->{import_text}){ &import_text; } $form->{exchangerate} = $form->parse_amount(\%myconfig, $form->{exchangerate}); if ($newname = &check_name(vendor)) { &rebuild_vc(vendor, AP, $form->{transdate}, 1); } if ($form->{transdate} ne $form->{oldtransdate}) { $form->{duedate} = ($form->{terms}) ? $form->current_date(\%myconfig, $form->{transdate}, $form->{terms} * 1) : $form->{duedate}; $form->{oldtransdate} = $form->{transdate}; &rebuild_vc(vendor, AP, $form->{transdate}, 1) if ! $newname; if ($form->{currency} ne $form->{defaultcurrency}) { delete $form->{exchangerate}; $form->{exchangerate} = $exchangerate if ($form->{forex} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, 'sell'))); $form->{oldcurrency} = $form->{currency}; } } if ($form->{currency} ne $form->{oldcurrency}) { delete $form->{exchangerate}; $form->{exchangerate} = $exchangerate if ($form->{forex} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{transdate}, 'sell'))); } $j = 1; for $i (1 .. $form->{paidaccounts}) { if ($form->{"paid_$i"}) { for (qw(datepaid source memo cleared)) { $form->{"${_}_$j"} = $form->{"${_}_$i"} } for (qw(paid exchangerate)) { $form->{"${_}_$j"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) } $form->{"exchangerate_$j"} = $exchangerate if ($form->{"forex_$j"} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{"datepaid_$j"}, 'sell'))); if ($j++ != $i) { for (qw(datepaid source memo cleared paid exchangerate forex)) { delete $form->{"${_}_$i"} } } } else { for (qw(datepaid source memo cleared paid exchangerate forex)) { delete $form->{"${_}_$i"} } } $form->{paidaccounts} = $j; } $i = $form->{rowcount}; $exchangerate = ($form->{exchangerate}) ? $form->{exchangerate} : 1; for (qw(partsgroup projectnumber)) { $form->{"select$_"} = $form->unescape($form->{"select$_"}) if $form->{"select$_"}; } if (($form->{"partnumber_$i"} eq "") && ($form->{"description_$i"} eq "") && ($form->{"partsgroup_$i"} eq "")) { $form->{creditremaining} += ($form->{oldinvtotal} - $form->{oldtotalpaid}); &check_form; } else { IR->retrieve_item(\%myconfig, \%$form); my $rows = scalar @{ $form->{item_list} }; if ($form->{language_code} && $rows == 0) { $language_code = $form->{language_code}; $form->{language_code} = ""; IR->retrieve_item(\%myconfig, \%$form); $form->{language_code} = $language_code; $rows = scalar @{ $form->{item_list} }; } if ($rows) { if ($rows > 1) { &select_item; exit; } else { $form->{"qty_$i"} = ($form->{"qty_$i"} * 1) ? $form->{"qty_$i"} : 1; $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); for (qw(partnumber description unit)) { $form->{item_list}[$i]{$_} = $form->quote($form->{item_list}[$i]{$_}) } for (keys %{ $form->{item_list}[0] }) { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } $form->{"discount_$i"} = $form->{discount} * 100; if ($sellprice) { $form->{"sellprice_$i"} = $sellprice; ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; } else { ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; $form->{"sellprice_$i"} /= $exchangerate; } $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * (1 - $form->{"discount_$i"} / 100); for (split / /, $form->{taxaccounts}) { $form->{"${_}_base"} = 0 } for (split / /, $form->{"taxaccounts_$i"}) { $form->{"${_}_base"} += $amount } if (!$form->{taxincluded}) { my @taxes = Tax::init_taxes($form, $form->{"taxaccounts_$i"}); $amount += (Tax::calculate_taxes(\@taxes, $form, $amount, 0)); } $form->{creditremaining} -= $amount; $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); $form->{"oldqty_$i"} = $form->{"qty_$i"}; for (qw(qty discount)) { $form->{"{_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}) } } &display_form; } else { # ok, so this is a new part # ask if it is a part or service item if ($form->{"partsgroup_$i"} && ($form->{"partsnumber_$i"} eq "") && ($form->{"description_$i"} eq "")) { $form->{"discount_$i"} = ""; &display_form; } else { $form->{"id_$i"} = 0; $form->{"unit_$i"} = $locale->text('ea'); &new_item; } } } } sub post { $form->isblank("transdate", $locale->text('Invoice Date missing!')); $form->isblank("vendor", $locale->text('Vendor missing!')); # if the vendor changed get new values if (&check_name(vendor)) { &update; exit; } &validate_items; $closedto = $form->datetonum(\%myconfig, $form->{closedto}); $transdate = $form->datetonum(\%myconfig, $form->{transdate}); $form->error($locale->text('Cannot post invoice for a closed period!')) if ($transdate <= $closedto); $form->isblank("exchangerate", $locale->text('Exchange rate missing!')) if ($form->{currency} ne $form->{defaultcurrency}); for $i (1 .. $form->{paidaccounts}) { if ($form->{"paid_$i"}) { $datepaid = $form->datetonum(\%myconfig, $form->{"datepaid_$i"}); $form->isblank("datepaid_$i", $locale->text('Payment date missing!')); $form->error($locale->text('Cannot post payment for a closed period!')) if ($datepaid <= $closedto); if ($form->{currency} ne $form->{defaultcurrency}) { $form->{"exchangerate_$i"} = $form->{exchangerate} if ($transdate == $datepaid); $form->isblank("exchangerate_$i", $locale->text('Exchange rate for payment missing!')); } } } if (! $form->{repost}) { if ($form->{id}) { &repost; exit; } } ($form->{AP}) = split /--/, $form->{AP}; ($form->{AP_paid}) = split /--/, $form->{AP_paid}; if (IR->post_invoice(\%myconfig, \%$form)) { $form->redirect($locale->text('Invoice [_1] posted!', $form->{invnumber})); } else { $form->error($locale->text('Cannot post invoice!')); } } sub delete { $form->header; print qq| <body> <form method=post action=$form->{script}> |; $form->{action} = "yes"; $form->hide_form; print qq| <h2 class=confirm>|.$locale->text('Confirm!').qq|</h2> <h4>|.$locale->text('Are you sure you want to delete Invoice Number [_1]?', $form->{invnumber}).qq|</h4> <p> <button name="action" class="submit" type="submit" value="yes">|.$locale->text('Yes').qq|</button> </form> |; } sub yes { if (IR->delete_invoice(\%myconfig, \%$form)) { $form->redirect($locale->text('Invoice deleted!')); } else { $form->error($locale->text('Cannot delete invoice!')); } }