path: root/bin/pos.pl

#=====================================================================
# 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) 2003
#
#  Author: DWS Systems Inc.
#     Web: http://www.sql-ledger.org
#
# Contributors: Steve Doerr <sdoerr907@everestkc.net>
#
#
# 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.
#=====================================================================
#
# POS
#
#=====================================================================

use Error qw(:try);

use LedgerSMB::Template;
use LedgerSMB::Tax;

1;

# end

sub check_alert {
    my $rc = $form->{'rowcount'};
    if ( !$form->{"partnumber_$rc"} ) {
        --$rc;  # Ensures that alert shows up when item is selected from a list;
    }
    for ( 1 .. $rc ) {
        $form->{'check_id'} = ( $form->{'check_id'} || $form->{"check_id_$_"} );
    }
}

sub send_to_pd {
    socket( SOCK, 2, 1, getprotobynumber( $pos_config{'pd_proto'} ) );
    connect( SOCK, $pos_config{'pd_dest'} );
    my $rn        = $numrows - 1;
    my $ds_string = sprintf(
        '%s%s @ $%-7.2f%s%s%s',
        $pd_control{'new_line'},
        $form->{"qty_$rn"},
        $form->{"sellprice_$rn"},
        $pd_control{'new_line'},
        "Subtotal: \$" . sprintf( '%-7.2f', $form->{'invtotal'} )
    );
    print SOCK $ds_string;
    close SOCK;
}

sub on_update {
    &send_to_pd;
    &check_alert;
}

sub open_drawer {
    open( PRINTER, "|-", ${LedgerSMB::Sysconfig::printer}{Printer} );
    print PRINTER $pos_config{'rp_cash_open'};
    close PRINTER;
    sleep 1;
}

sub open {
    &open_drawer;
    &update;
}

sub add {
    $form->{nextsub} = 'add';

    $form->{title} = $locale->text('Add POS Invoice');

    $form->{callback} =
"$form->{script}?action=$form->{nextsub}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}";

    &invoice_links;

    $form->{type}     = "pos_invoice";
    $form->{format}   = "txt";
    $form->{media}    = ( $myconfig{printer} ) ? $myconfig{printer} : "screen";
    $form->{rowcount} = 0;

    $form->{readonly} = ( $myconfig{acs} =~ /POS--Sale/ ) ? 1 : 0;

    $ENV{REMOTE_ADDR} =~ /(\d+)\.(\d+)\.(\d+)\.(\d+)/;
    $form->{till} = $4;

    $form->{partsgroup} = "";
    for ( @{ $form->{all_partsgroup} } ) {
        $form->{partsgroup} .= "$_->{partsgroup}--$_->{translation}\n";
    }

    $form->{dontdisplayend} = 1;

    &display_form;

    $form->{dontdisplayrows} = 1;
    $form->{dontdisplayend}  = 0;
    &openinvoices;
}

sub openinvoices {
    undef %column_data;
    undef %column_heading;
    $form->{customer}    = "";
    $form->{customer_id} = 0;
    delete $form->{l_subtotal};
    delete $form->{subtotal};

    $ENV{REMOTE_ADDR} =~ /(\d+)\.(\d+)\.(\d+)\.(\d+)/;
    $form->{till} = $4;

    $form->{sort} = 'transdate';

    for (qw(open l_invnumber l_transdate l_name l_amount l_curr l_till)) {
        $form->{$_} = 'Y';
    }

    if ( $myconfig{role} ne 'user' ) {
        $form->{l_employee} = 'Y';
    }

    $form->{title} = $locale->text('Open');
    &transactions;

}

sub edit {

    $form->{title} = $locale->text('Edit POS Invoice');

    $form->{callback} =
"$form->{script}?action=$form->{nextsub}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}";

    &invoice_links;
    &prepare_invoice;

    $form->{type}   = "pos_invoice";
    $form->{format} = "txt";
    $form->{media}  = ( $myconfig{printer} ) ? $myconfig{printer} : "screen";

    $form->{readonly} = ( $myconfig{acs} =~ /POS--Sale/ ) ? 1 : 0;

    $form->{partsgroup} = "";
    for ( @{ $form->{all_partsgroup} } ) {
        $form->{partsgroup} .= "$_->{partsgroup}--$_->{translation}\n";
    }

    &display_form;

}

sub form_header {

    if ( !$form->{'check_id'} ) {
        &check_alert;
    }

    # set option selected
    for (qw(AR currency)) {
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~
          s/option>\Q$form->{$_}\E/option selected>$form->{$_}/;
    }

    for (qw(customer department employee)) {
        $form->{"select$_"} = $form->unescape( $form->{"select$_"} );
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/;
    }

    $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>|
              . $locale->text('Exchange Rate')
              . qq|</th><td>$form->{exchangerate}<input type=hidden name=exchangerate value=$form->{exchangerate}></td>|;
        }
        else {
            $exchangerate .=
                qq|<th align=right>|
              . $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->{selectcustomer} ) {
        $customer = qq|<select name=customer>$form->{selectcustomer}</select>
                   <input type=hidden name="selectcustomer" value="|
          . $form->escape( $form->{selectcustomer}, 1 ) . qq|">|;
    }
    else {
        $customer = qq|<input name=customer value="$form->{customer}" 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};

    $employee = qq|
          <tr>
            <th align=right nowrap>| . $locale->text('Salesperson') . qq|</th>
        <td colspan=3><select name=employee>$form->{selectemployee}</select></td>
        <input type=hidden name=selectemployee value="|
      . $form->escape( $form->{selectemployee}, 1 ) . qq|">
          </tr>
| if $form->{selectemployee};

    if ( $form->{change} != $form->{oldchange} ) {
        $form->{creditremaining} -= $form->{oldchange};
    }
    $n = ( $form->{creditremaining} < 0 ) ? "0" : "1";

    if ( $form->{business} ) {
        $business = qq|
              <tr>
            <th align=right nowrap>| . $locale->text('Business') . qq|</th>
        <td>$form->{business}</td>
        <td width=10></td>
        <th align=right nowrap>| . $locale->text('Trade Discount') . qq|</th>
        <td>|
          . $form->format_amount( \%myconfig, $form->{tradediscount} * 100 )
          . qq| %</td>
          </tr>
|;
    }

    if ( $form->{selectlanguage} ) {
        if ( $form->{language_code} ne $form->{oldlanguage_code} ) {

            # rebuild partsgroup
            $form->get_partsgroup(\%myconfig, { all => 1 }); 
            $form->{partsgroup} = "";
            for ( @{ $form->{all_partsgroup} } ) {
                $form->{partsgroup} .= "$_->{partsgroup}--$_->{translation}\n";
            }
            $form->{oldlanguage_code} = $form->{language_code};
        }

        $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>| . $locale->text('Language') . qq|</th>
        <td colspan=3><select name=language_code>$form->{selectlanguage}</select></td>
          </tr>
    <input type=hidden name=oldlanguage_code value=$form->{oldlanguage_code}>
    <input type=hidden name=selectlanguage value="|
          . $form->escape( $form->{selectlanguage}, 1 ) . qq|">|;
    }

    $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->hide_form(
        qw(id till type format printed title discount creditlimit creditremaining tradediscount business closedto locked oldtransdate customer_id oldcustomer check_id)
    );

    print qq|
<input type=hidden name=vc value="customer">

<table width=100%>
  <tr class=listtop>
    <th class=listtop>$form->{title}</font></th>
  </tr>|;
    if ( $form->{'check_id'} ) {
        print qq|
    <tr class=listtop>
      <th class=listtop style="background-color: red">|
          . $locale->text('Check ID') . qq|
      </th>
    </tr>|;
    }
    print qq|
  <tr height="5"></tr>
  <tr>
    <td>
      <table width=100%>
    <tr valign=top>
      <td>
        <table>
          <tr>
        <th align=right nowrap>| . $locale->text('Customer') . qq|</th>
        <td colspan=3>$customer</td>
          </tr>
          <tr>
            <td></td>
        <td colspan=3>
          <table>
            <tr>
              <th align=right nowrap>| . $locale->text('Credit Limit') . qq|</th>
              <td>$form->{creditlimit}</td>
              <td width=10></td>
              <th align=right nowrap>| . $locale->text('Remaining') . qq|</th>
              <td class="plus$n">|
      . $form->format_amount( \%myconfig, $form->{creditremaining}, 0, "0" )
      . qq|</font></td>
            </tr>
            $business
          </table>
        </td>
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Record in') . qq|</th>
        <td colspan=3><select name=AR>$form->{selectAR}</select></td>
        <input type=hidden name=selectAR value="$form->{selectAR}">
          </tr>
          $department
        </table>
      </td>
      <td>
        <table>
          $employee
          $exchangerate
          $lang
        </table>
      </td>
    </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td>
    </td>
  </tr>
|;

    $form->hide_form(
        qw(taxaccounts duedate invnumber transdate selectcurrency defaultcurrency)
    );

    for ( split / /, $form->{taxaccounts} ) {
        $form->hide_form( "${_}_rate", "${_}_description", "${_}_taxnumber" );
    }

}

sub form_footer {
    _calc_taxes();
    $form->{invtotal} = $form->{invsubtotal};

    $form->{taxincluded} = ( $form->{taxincluded} ) ? "checked" : "";

    $taxincluded = "";
    if ( $form->{taxaccounts} ) {
        $taxincluded = qq|
              <tr height="5"></tr>
          <tr>
            <td align=right>
        <input name=taxincluded class=checkbox type=checkbox value=1 $form->{taxincluded}></td><th align=left>|
          . $locale->text('Tax Included')
          . qq|</th>
          </tr>
|;
    }

    if ( !$form->{taxincluded} ) {

        foreach $item (keys %{$form->{taxes}}) {
            my $taccno = $item;
        $form->{invtotal} += $form->round_amount($form->{taxes}{$item}, 2);
            $form->{"${taccno}_total"} =
                  $form->format_amount( \%myconfig,
                    $form->round_amount( $form->{taxes}{$item}, 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>
|;
    }

    @column_index = qw(paid memo source cctrack AR_paid);

    $column_data{paid}   = "<th>" . $locale->text('Amount') . "</th>";
    $column_data{source} = "<th>" . $locale->text('Source') . "</th>";
    $column_data{memo}   = "<th>" . $locale->text('Memo') . "</th>";
    $column_data{cctrack} =
      "<th>" . $locale->text('Credit Card Track') . "</th>";
    $column_data{AR_paid} = "<th>&nbsp;</th>";

    print qq|
  <tr>
    <td>
      <table width=100%>
    <tr valign=top>
      <td>
        <table>
          <tr>
|;

    for (@column_index) { print "$column_data{$_}\n"; }

    print qq|
          </tr>
|;

    $totalpaid = 0;

    $form->{paidaccounts}++ if ( $form->{"paid_$form->{paidaccounts}"} );

    my $memoselect = qq|<SELECT name="MEMONAME">|;
    for ( sort keys %pos_sources ) {
        $memoselect .= qq|<option value="$_">$pos_sources{$_}</option>|;
    }
    $memoselect .= qq|</SELECT>|;

    for $i ( 1 .. $form->{paidaccounts} ) {

        $form->{"selectAR_paid_$i"} = $form->{selectAR_paid};
        $form->{"selectAR_paid_$i"} =~
s/option>\Q$form->{"AR_paid_$i"}\E/option selected>$form->{"AR_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"} );

        if ( $form->{"paid__$i"} ) {
            $column_data{paid} =
qq|<td><input name="paid_$i" size=11 value=$form->{"paid_$i"}></td>|;
        }
        else {
            $column_data{paid} =
qq|<td><input accesskey='n' name="paid_$i" size=11 value=$form->{"paid_$i"}></td>|;
        }

        $column_data{source} =
qq|<td><input name="source_$i" size=10 value="$form->{"source_$i"}"></td>|;
        $column_data{memo} = qq|<td>$memoselect</td>|;
        $column_data{memo} =~ s/MEMONAME/memo_$i/;
        if ( !$form->{"memo_$i"} ) {
            $form->{"memo_$i"} = $pos_source_default;
        }
        my $memval = $form->{"memo_$i"};
        $column_data{memo} =~ s/(option value="$memval")/$1 SELECTED/;

        $column_data{cctrack} = qq|<td><input type="text" name="cctrack_$i"
    value="| . $form->{"cctrack_$i"} . qq|" size="3"></td>|;

        if ( $pos_config{"coa_prefix"} ) {
            if ( !$form->{"AR_paid_$i"} ) {
                $form->{"AR_paid_$i"} =
                  $pos_config{"coa_prefix"} . '.' . $pos_config{"till"};
            }
            $column_data{AR_paid} = qq|<input type=hidden name="AR_paid_$i" 
                  value='$form->{"AR_paid_$i"}'>|;
        }
        else {
            $column_data{AR_paid} =
qq|<td><select name="AR_paid_$i">$form->{"selectAR_paid_$i"}</select></td>|;
        }
        print qq|
          <tr>
|;
        for (@column_index) { print "$column_data{$_}\n"; }

        print qq|
          </tr>
|;

        $form->hide_form( "cleared_$i", "exchangerate_$i", "forex_$i" );

    }

    $form->{change} = 0;
    if ( $totalpaid > $form->{invtotal} ) {
        $form->{change} = $totalpaid - $form->{invtotal};
    }
    $form->{oldchange} = $form->{change};
    $form->{change} = $form->format_amount( \%myconfig, $form->{change}, 2, 0 );
    $form->{totalpaid} = $form->format_amount( \%myconfig, $totalpaid, 2 );

    $form->{oldinvtotal} = $form->{invtotal};
    $form->{invtotal} =
      $form->format_amount( \%myconfig, $form->{invtotal}, 2, 0 );

    print qq|
          <tr>
        <th align=right>| . $locale->text('Change') . qq|</th>
        <th>$form->{change}</th>
          </tr>
        </table>
      </td>
      <td align=right>
        <table>
          $subtotal
          $tax
          <tr>
        <th align=right>| . $locale->text('Total') . qq|</th>
        <td align=right>$form->{invtotal}</td>
          </tr>
          $taxincluded
        </table>
      </td>
    </tr>
      </table>
    </td>
  </tr>
 
<input type=hidden name=oldtotalpaid value=$totalpaid>
<input type=hidden name=datepaid value=$form->{transdate}>

<tr>
  <td>
|;

    $form->hide_form(
        qw(paidaccounts selectAR_paid oldinvtotal change oldchange invtotal));

    &print_options;

    print qq|
    </td>
  </tr>
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>
|;

    $transdate = $form->datetonum( \%myconfig, $form->{transdate} );
    $closedto  = $form->datetonum( \%myconfig, $form->{closedto} );

    # type=submit $locale->text('Update')
    # type=submit $locale->text('Print')
    # type=submit $locale->text('Post')
    # type=submit $locale->text('Print and Post')
    # type=submit $locale->text('Delete')

    if ( !$form->{readonly} ) {
        %button = (
            'update' =>
              { ndx => 1, key => 'U', value => $locale->text('Update') },
            'print' =>
              { ndx => 2, key => 'P', value => $locale->text('Print') },
            'post' => { ndx => 3, key => 'O', value => $locale->text('Post') },
            'print_and_post' => {
                ndx   => 4,
                key   => 'R',
                value => $locale->text('Print and Post')
            },
            'delete' =>
              { ndx => 5, key => 'D', value => $locale->text('Delete') },
        );

        if ( $transdate > $closedto ) {

            if ( !$form->{id} ) {
                delete $button{'delete'};
            }

            delete $button{'print_and_post'}
              unless ${LedgerSMB::Sysconfig::latex};
        }
        else {
            for ( 'print', 'post', 'print_and_post', 'delete' ) {
                delete $button{$_};
            }
        }

        for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button )
        {
            $form->print_button( \%button, $_ );
        }

        if ( $form->{partsgroup} ) {
            $form->{partsgroup} =~ s/\r//g;
            $form->{partsgroup} = $form->quote( $form->{partsgroup} );

            $spc = ( $form->{path} =~ /lynx/ ) ? "." : " ";
            print qq|
<input type=hidden name=nextsub value=lookup_partsgroup>
<input type=hidden name=partsgroup value="$form->{partsgroup}">|;

            foreach $item ( split /\n/, $form->{partsgroup} ) {
                ( $partsgroup, $translation ) = split /--/, $item;
                $item = ($translation) ? $translation : $partsgroup;
                print
qq| <button class="submit" type="submit" name="action" value="$spc$item">$spc$item</button>\n|
                  if $item;
            }
        }
    }

    if ( $form->{lynx} ) {
        require "bin/menu.pl";
        &menubar;
    }

    $form->hide_form(qw(rowcount callback path login sessionid));

    print qq|</form>|;

    if ( !$form->{dontdisplayend} ) {
        print qq|
</body>
</html>
|;
    }
}

sub post {

    $form->{media} = 'Printer';
    $form->isblank( "customer", $locale->text('Customer missing!') );

    # if oldcustomer ne customer redo form
    $customer = $form->{customer};
    $customer =~ s/--.*//g;
    $customer .= "--$form->{customer_id}";
    if ( $customer ne $form->{oldcustomer} ) {
        &update;
        exit;
    }

    &validate_items;
    &print;

    $form->isblank( "exchangerate", $locale->text('Exchange rate missing!') )
      if ( $form->{currency} ne $form->{defaultcurrency} );

    $paid = 0;
    for ( 1 .. $form->{paidaccounts} ) {
        $paid += $form->parse_amount( \%myconfig, $form->{"paid_$_"} );
    }
    delete $form->{datepaid} unless $paid;

    $total = $form->parse_amount( \%myconfig, $form->{invtotal} );

    # deduct change from first payment
    #$form->{"paid_1"} = $form->{invtotal} if $paid > $total;
    $form->{paid} = $paid;
    if ( $paid > $total ) {
        ++$form->{paidaccounts};
        my $pa = $form->{paidaccounts};
        $form->{"paid_$pa"}         = $total - $paid;
        $form->{"source_$pa"}       = 'cash';
        $form->{"exchangerate_$pa"} = 0;
        $form->{"AR_paid_$pa"}      = $form->{AR_paid_1};
    }

    ( $form->{AR} ) = split /--/, $form->{AR};

    if ( IS->post_invoice( \%myconfig, \%$form ) ) {
        $form->redirect( $locale->text('Posted!') );
    }
    else {
        $form->error( $locale->text('Cannot post transaction!') );
    }

}

sub display_row {
    my $numrows = shift;

    @column_index =
      qw(partnumber description partsgroup qty unit sellprice discount linetotal);

    $form->{invsubtotal} = 0;

    for ( split / /, $form->{taxaccounts} ) { $form->{"${_}_base"} = 0; }

    $column_data{partnumber} =
      qq|<th class=listheading nowrap>| . $locale->text('Number') . qq|</th>|;
    $column_data{description} =
        qq|<th class=listheading nowrap>|
      . $locale->text('Description')
      . qq|</th>|;
    $column_data{qty} =
      qq|<th class=listheading nowrap>| . $locale->text('Qty') . qq|</th>|;
    $column_data{unit} =
      qq|<th class=listheading nowrap>| . $locale->text('Unit') . qq|</th>|;
    $column_data{sellprice} =
      qq|<th class=listheading nowrap>| . $locale->text('Price') . qq|</th>|;
    $column_data{linetotal} =
      qq|<th class=listheading nowrap>| . $locale->text('Extended') . qq|</th>|;
    $column_data{discount} = qq|<th class=listheading nowrap>%</th>|;

    print qq|
  <tr>
    <td>
      <table width=100%>
    <tr class=listheading>|;

    for (@column_index) { print "\n$column_data{$_}"; }

    print qq|
        </tr>
|;

    $exchangerate = $form->parse_amount( \%myconfig, $form->{exchangerate} );
    $exchangerate = ($exchangerate) ? $exchangerate : 1;

    for $i ( 1 .. $numrows ) {

        # undo formatting
        for (qw(qty discount sellprice)) {
            $form->{"${_}_$i"} =
              $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
        }

        ($dec) = ( $form->{"sellprice_$i"} =~ /\.(\d+)/ );
        $dec = length $dec;
        $decimalplaces = ( $dec > 2 ) ? $dec : 2;

        if (   ( $form->{"qty_$i"} != $form->{"oldqty_$i"} )
            || ( $form->{currency} ne $form->{oldcurrency} ) )
        {

            # check for a pricematrix
            @a = split / /, $form->{"pricematrix_$i"};
            if ( scalar @a ) {
                foreach $item (@a) {
                    ( $q, $p ) = split /:/, $item;
                    if ( ( $p * 1 ) && ( $form->{"qty_$i"} >= ( $q * 1 ) ) ) {
                        ($dec) = ( $p =~ /\.(\d+)/ );
                        $dec = length $dec;
                        $decimalplaces = ( $dec > 2 ) ? $dec : 2;
                        $form->{"sellprice_$i"} =
                          $form->round_amount( $p / $exchangerate,
                            $decimalplaces );
                    }
                }
            }
        }

        if ( $i < $numrows ) {
            $column_data{discount} =
                qq|<td align=right><input name="discount_$i" size=3 value=|
              . $form->format_amount( \%myconfig, $form->{"discount_$i"} )
              . qq|></td>|;
        }
        else {
            $column_data{discount} = qq|<td></td>|;
        }

        $discount =
          $form->round_amount(
            $form->{"sellprice_$i"} * $form->{"discount_$i"} / 100,
            $decimalplaces );
        $linetotal = $form->round_amount( $form->{"sellprice_$i"} - $discount,
            $decimalplaces );
        $linetotal = $form->round_amount( $linetotal * $form->{"qty_$i"}, 2 );

        for (qw(partnumber sku description partsgroup unit)) {
            $form->{"${_}_$i"} = $form->quote( $form->{"${_}_$i"} );
        }

        $column_data{partnumber} =
qq|<td><input name="partnumber_$i" size=20 value="$form->{"partnumber_$i"}" accesskey="$i" title="[Alt-$i]"></td>|;

        if (
            ( $rows = $form->numtextrows( $form->{"description_$i"}, 40, 6 ) ) >
            1 )
        {
            $column_data{description} =
qq|<td><textarea name="description_$i" rows=$rows cols=46 wrap=soft>$form->{"description_$i"}</textarea></td>|;
        }
        else {
            $column_data{description} =
qq|<td><input name="description_$i" size=48 value="$form->{"description_$i"}"></td>|;
        }

        $column_data{qty} =
            qq|<td align=right><input name="qty_$i" size=5 value=|
          . $form->format_amount( \%myconfig, $form->{"qty_$i"} )
          . qq|></td>|;
        $column_data{unit} = qq|<td>$form->{"unit_$i"}</td>|;
        $column_data{sellprice} =
          qq|<td align=right><input name="sellprice_$i" size=9 value=|
          . $form->format_amount( \%myconfig, $form->{"sellprice_$i"},
            $decimalplaces )
          . qq|></td>|;
        $column_data{linetotal} =
            qq|<td align=right>|
          . $form->format_amount( \%myconfig, $linetotal, 2 )
          . qq|</td>|;

        print qq|
        <tr valign=top>|;

        for (@column_index) { print "\n$column_data{$_}"; }

        print qq|
        </tr>
|;

        $form->{"oldqty_$i"} = $form->{"qty_$i"};

        for (
            qw(id listprice lastcost taxaccounts pricematrix oldqty sku partsgroup unit inventory_accno_id income_accno_id expense_accno_id)
          )
        {
            $form->hide_form("${_}_$i");
        }

        for ( split / /, $form->{"taxaccounts_$i"} ) {
            $form->{"${_}_base"} += $linetotal;
        }

        $form->{invsubtotal} += $linetotal;
    }

    print qq|
      </table>
    </td>
  </tr>

<input type=hidden name=oldcurrency value=$form->{currency}>

|;

}

sub print {
    if ( !$form->{invnumber} ) {
        $form->{invnumber} = $form->update_defaults( \%myconfig, 'sinumber' );
    }
    $rc = $form->{'rowcount'};
    $pc = $form->{'paidaccounts'};
    if (   $form->{"partnumber_$rc"}
        || $form->{"description_$rc"}
        || $form->{"paid_$pc"} )
    {
        &update;
        exit;
    }
    for $i ( 1 .. $rc - 1 ) {
        if ( $form->{"qty_$i"} != $form->{"oldqty_$i"} ) {
            &update;
            exit;
        }
    }

    if ( !$form->{invnumber} ) {
        $form->{invnumber} = $form->update_defaults( \%myconfig, "sinumber" );
        if ( $form->{media} eq 'screen' ) {
            &update;
            exit;
        }
    }

    $old_form = new Form;
    for ( keys %$form ) { $old_form->{$_} = $form->{$_}; }

    for (qw(employee department)) { $form->{$_} =~ s/--.*//g; }
    $form->{invdate} = $form->{transdate};
    my @lt = localtime();
    $form->{dateprinted} = $lt[2] . ":" . $lt[1] . ":" . $lt[0];

    &print_form($old_form);

}

sub print_form {
    my $old_form = shift;
    &open_drawer;

    # if oldcustomer ne customer redo form
    $customer = $form->{customer};
    $customer =~ s/--.*//g;
    $customer .= "--$form->{customer_id}";
    if ( $customer ne $form->{oldcustomer} ) {
        &update;
        exit;
    }

    &validate_items;

    &{"$form->{vc}_details"};

    @a = ();
    for ( 1 .. $form->{rowcount} ) {
        push @a, ( "partnumber_$_", "description_$_" );
    }
    for ( split / /, $form->{taxaccounts} ) { push @a, "${_}_description"; }
    $form->format_string(@a);

    # format payment dates
    for ( 1 .. $form->{paidaccounts} ) {
        $form->{"datepaid_$_"} =
          $locale->date( \%myconfig, $form->{"datepaid_$_"} );
    }

    IS->invoice_details( \%myconfig, \%$form );

    if ( $form->parse_amount( \%myconfig, $form->{total} ) <= 0 ) {
        $form->{total} = 0;
    }
    else {
        $form->{change} = 0;
    }

    for (qw(company address tel fax businessnumber)) {
        $form->{$_} = $myconfig{$_};
    }
    $form->{username} = $myconfig{name};

    $form->{address} =~ s/\\n/\n/g;
    push @a, qw(company address tel fax businessnumber username);
    $form->format_string(@a);

    $form->{templates} = "$myconfig{templates}";
    $form->{IN}        = "$form->{type}.$form->{format}";

    if ( $form->{format} =~ /(postscript|pdf)/ ) {
        $form->{IN} =~ s/$&$/tex/;
    }

    if ( $form->{media} ne 'screen' ) {
        $form->{OUT}       = ${LedgerSMB::Sysconfig::printer}{ $form->{media} };
        $form->{printmode} = '|-';
    }

    $form->{discount} =
      $form->format_amount( \%myconfig, $form->{discount} * 100 );

    $form->{rowcount}--;
    $form->{pre} = "<body bgcolor=#ffffff>\n<pre>";
    delete $form->{stylesheet};
    $form->{cd_open} = $pos_config{rp_cash_drawer_open};

    my $template = LedgerSMB::Template->new(user => \%myconfig, 
        template => $form->{'formname'}, format => uc $form->{format} );
    try {
        $template->render($form);
        $template->output(%{$form});
    }
    catch Error::Simple with {
        my $E = shift;
        $form->error( $E->stacktrace );
    };

    if ( $form->{printed} !~ /$form->{formname}/ ) {
        $form->{printed} .= " $form->{formname}";
        $form->{printed} =~ s/^ //;

        $form->update_status( \%myconfig );
    }
    $old_form->{printed} = $form->{printed};

    # if we got back here restore the previous form
    if ( $form->{media} ne 'screen' ) {

        # restore and display form
        for ( keys %$old_form ) { $form->{$_} = $old_form->{$_}; }
        $form->{exchangerate} =
          $form->parse_amount( \%myconfig, $form->{exchangerate} );

        for $i ( 1 .. $form->{paidaccounts} ) {
            for (qw(paid exchangerate)) {
                $form->{"${_}_$i"} =
                  $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
            }
        }

        delete $form->{pre};

        if ( !$form->{printandpost} ) {
            $form->{rowcount}--;

            #&display_form;
        }
    }

}

sub print_and_post {

    $form->error( $locale->text('Select a Printer!') )
      if ( $form->{media} eq 'screen' );
    $form->{printandpost} = 1;
    &print;
    &post;

}

sub lookup_partsgroup {

    $form->{my_partsgroup} =~ s/\r//;
    $form->{action} = $form->{my_partsgroup};

    if ( $form->{language_code} ) {

        # get english
        foreach $item ( split /\n/, $form->{partsgroup} ) {
            if ( $item =~ /$form->{action}/ ) {
                ( $partsgroup, $translation ) = split /--/, $item;
                $form->{action} = $partsgroup;
                last;
            }
        }
    }

    $form->{"partsgroup_$form->{rowcount}"} = $form->{action};

    &update;

}

sub print_options {

    $form->{PD}{ $form->{type} } = "checked";

    print qq|
<input type=hidden name=format value=$form->{format}>
<input type=hidden name=formname value=$form->{type}>

<table width=100%>
  <tr>
|;

    $media = qq|
    <td><input class=radio type=radio name=media value="screen"></td>
    <td>| . $locale->text('Screen') . qq|</td>|;

    if ( %{LedgerSMB::Sysconfig::printer} ) {
        for ( keys %{LedgerSMB::Sysconfig::printer} ) {
            $media .= qq|
    <td><input class=radio type=radio name=media value="$_"></td>
    <td nowrap>$_</td>
|;
        }
    }

    $media =~ s/(value="\Q$form->{media}\E")/$1 checked/;

    print qq|
  $media
  
  <td width=99%>&nbsp;</td>|;

    if ( $form->{printed} =~ /$form->{type}/ ) {
        print qq|
    <th>\|| . $locale->text('Printed') . qq|\|</th>|;
    }

    print qq|
  </tr>
</table>
|;

}

sub receipts {

    $form->{title} = $locale->text('Receipts');

    $form->{db} = 'ar';
    RP->paymentaccounts( \%myconfig, \%$form );

    $paymentaccounts = "";
    for ( @{ $form->{PR} } ) { $paymentaccounts .= "$_->{accno} "; }

    if ( @{ $form->{all_years} } ) {

        # accounting years
        $form->{selectaccountingyear} = "<option>\n";
        for ( @{ $form->{all_years} } ) {
            $form->{selectaccountingyear} .= qq|<option>$_\n|;
        }
        $form->{selectaccountingmonth} = "<option>\n";
        for ( sort keys %{ $form->{all_month} } ) {
            $form->{selectaccountingmonth} .=
              qq|<option value=$_>|
              . $locale->text( $form->{all_month}{$_} ) . qq|\n|;
        }

        $selectfrom = qq|
        <tr>
    <th align=right>| . $locale->text('Period') . qq|</th>
    <td colspan=3>
    <select name=month>$form->{selectaccountingmonth}</select>
    <select name=year>$form->{selectaccountingyear}</select>
    <input name=interval class=radio type=radio value=0 checked>&nbsp;|
          . $locale->text('Current') . qq|
    <input name=interval class=radio type=radio value=1>&nbsp;|
          . $locale->text('Month') . qq|
    <input name=interval class=radio type=radio value=3>&nbsp;|
          . $locale->text('Quarter') . qq|
    <input name=interval class=radio type=radio value=12>&nbsp;|
          . $locale->text('Year') . qq|
    </td>
      </tr>
|;
    }

    $form->header;

    print qq|
<body>

<form method=post action=$form->{script}>

<input type=hidden name=title value="$form->{title}">
<input type=hidden name=paymentaccounts value="$paymentaccounts">

<input type=hidden name=till value=1>
<input type=hidden name=subtotal value=1>

<table width=100%>
  <tr>
    <th class=listtop>$form->{title}</th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table>
      
        <input type=hidden name=nextsub value=list_payments>
    
        <tr>
      <th align=right>| . $locale->text('From') . qq|</th>
      <td><input name=fromdate size=11 title="$myconfig{dateformat}" value=$form->{fromdate}></td>
      <th align=right>| . $locale->text('To') . qq|</th>
      <td><input name=todate size=11 title="$myconfig{dateformat}"></td>
    </tr>
    $selectfrom
      <input type=hidden name=sort value=transdate>
      <input type=hidden name=db value=$form->{db}>
      </table>
    </td>
  </tr>
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>

<br>
<input type="hidden" name="path" value="$form->{path}">
<input type="hidden" name="login" value="$form->{login}">
<input type="hidden" name="sessionid" value="$form->{sessionid}">

<button type="submit" class="submit" name="action" value="continue">|
      . $locale->text('Continue')
      . qq|</button>
|;

    if ( $form->{lynx} ) {
        require "bin/menu.pl";
        &menubar;
    }

    print qq|
 
</form>

</body>
</html>
|;

}