- #=====================================================================
- # LedgerSMB Small Medium Business Accounting
- # Copyright (c) 2001
- #
- # Author: DWS Systems Inc.
- # Web: http://sourceforge.net/projects/ledger-smb/
- #
- #
- # 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 SL::IR;
- use SL::PE;
- require "$form->{path}/io.pl";
- require "$form->{path}/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}) {
-
- foreach $item (split / /, $form->{taxaccounts}) {
- if ($form->{"${item}_base"}) {
- $form->{invtotal} += $form->{"${item}_total"} = $form->round_amount($form->{"${item}_base"} * $form->{"${item}_rate"}, 2);
- $form->{"${item}_total"} = $form->format_amount(\%myconfig, $form->{"${item}_total"}, 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>
- </tr>
- <tr valign=top>
- <td>$notes</td>
- <td>$intnotes</td>
- </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') { $a{$_} = 1 }
- }
- for (keys %button) { delete $button{$_} if ! $a{$_} }
- }
- for (sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button) { $form->print_button(\%button, $_) }
-
- }
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
-
- $form->hide_form(qw(rowcount callback path login sessionid));
-
- print qq|
- </form>
- </body>
- </html>
- |;
- }
- sub update {
- $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}) {
- for (split / /, $form->{"taxaccounts_$i"}) { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) }
- }
- $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')." $form->{invnumber} ".$locale->text('posted!'));
- } 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').qq| $form->{invnumber}</h4>
- <p>
- <input name=action class=submit type=submit value="|.$locale->text('Yes').qq|">
- </form>
- |;
- }
- sub yes {
- if (IR->delete_invoice(\%myconfig, \%$form)) {
- $form->redirect($locale->text('Invoice deleted!'));
- } else {
- $form->error($locale->text('Cannot delete invoice!'));
- }
- }
|