- #=====================================================================
- # 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 {
- if ($form->{type} eq 'debit_invoice'){
- $form->{title} = $locale->text('Add Debit Invoice');
- $form->{subtype} = 'debit_invoice';
- $form->{reverse} = 1;
- } else {
- $form->{title} = $locale->text('Add Vendor Invoice');
- $form->{reverse} = 0;
- }
- $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 {
- if ($form->{reverse}){
- $form->{title} = $locale->text('Add Debit Invoice');
- $form->{subtype} = 'debit_invoice';
- } else {
- $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 reverse batch_id subtype)
- );
- 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 {
- _calc_taxes();
- $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>|;
- $tax = "";
- $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 (keys %{$form->{taxes}}) {
- my $taccno = $item;
- $form->{invtotal} += $form->round_amount($form->{taxes}{$item}, 2);
- $form->{"${taccno}_total"} =
- $form->round_amount($form->{taxes}{$item}, 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 );
-
- my $hold;
-
- if ($form->{on_hold}) {
-
- $hold = qq| <font size="17"><b> This invoice is On Hold </b></font> |;
- }
- print qq|
- <tr>
- <td>
- <table width=100%>
- <tr valign=bottom>
- | . $hold . qq|
-
- <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') },
- 'on_hold' =>
- { ndx => 9, key=> 'O', value => $locale->text('On Hold') },
- );
- if ( $form->{id} ) {
- if ( $form->{locked} ) {
- for ( "post", "delete", 'on_hold' ) { 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"},
- $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->{"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!') );
- }
- }
- sub on_hold {
-
- if ($form->{id}) {
-
- my $toggled = IS->toggle_on_old($form);
-
- #&invoice_links(); # is that it?
- &edit(); # it was already IN edit for this to be reached.
- }
- }
|