diff options
Diffstat (limited to 'bin/pos.pl')
-rw-r--r-- | bin/pos.pl | 2341 |
1 files changed, 1245 insertions, 1096 deletions
@@ -1,1096 +1,1245 @@ -#=====================================================================
-# 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;
-
- $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 l_subtotal)) { $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, { language_code => $form->{language_code}, searchitems => 'nolabor'});
- $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 {
-
- $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}) {
-
- my @taxes = Tax::init_taxes($form, $form->{taxaccounts});
- $form->{invtotal} += Tax::calculate_taxes(\@taxes, $form,
- $form->{invsubtotal}, 0);
-
- foreach my $item (@taxes) {
- my $taccno = $item->account;
-
- $form->{"${taccno}_total"} = $form->format_amount(\%myconfig,
- $item->value, 2, 0);
-
- $tax .= qq|
- <tr>
- <th align=right>$form->{"${taccno}_description"}</th>
- <td align=right>$form->{"${taccno}_total"}</td>
- </tr>
- | if $item->value;
- }
-
- $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> </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};
-
- if (($form->{'media'} eq 'screen') and ($form->{'format'} eq 'html')) {
- my $template = LedgerSMB::Template->new(\%myconfig, $form->{'formname'}, 'HTML');
- try {
- $template->render($form);
- $form->header;
- print $template->{'output'};
- exit;
- } catch Error::Simple with {
- my $E = shift;
- $form->error($E->stacktrace);
- };
- }
- $form->parse_template(\%myconfig, ${LedgerSMB::Sysconfig::userspath});
-
- 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%> </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> |.$locale->text('Current').qq|
- <input name=interval class=radio type=radio value=1> |.$locale->text('Month').qq|
- <input name=interval class=radio type=radio value=3> |.$locale->text('Quarter').qq|
- <input name=interval class=radio type=radio value=12> |.$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>
-|;
-
-}
-
-
+#===================================================================== +# 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; + + $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 l_subtotal) + ) + { + $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, + { + language_code => $form->{language_code}, + searchitems => 'nolabor' + } + ); + $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 { + + $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} ) { + + my @taxes = Tax::init_taxes( $form, $form->{taxaccounts} ); + $form->{invtotal} += + Tax::calculate_taxes( \@taxes, $form, $form->{invsubtotal}, 0 ); + + foreach my $item (@taxes) { + my $taccno = $item->account; + + $form->{"${taccno}_total"} = + $form->format_amount( \%myconfig, $item->value, 2, 0 ); + + $tax .= qq| + <tr> + <th align=right>$form->{"${taccno}_description"}</th> + <td align=right>$form->{"${taccno}_total"}</td> + </tr> + | if $item->value; + } + + $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> </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}; + + if ( ( $form->{'media'} eq 'screen' ) and ( $form->{'format'} eq 'html' ) ) + { + my $template = + LedgerSMB::Template->new( \%myconfig, $form->{'formname'}, 'HTML' ); + try { + $template->render($form); + $form->header; + print $template->{'output'}; + exit; + } + catch Error::Simple with { + my $E = shift; + $form->error( $E->stacktrace ); + }; + } + $form->parse_template( \%myconfig, ${LedgerSMB::Sysconfig::userspath} ); + + 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%> </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> | + . $locale->text('Current') . qq| + <input name=interval class=radio type=radio value=1> | + . $locale->text('Month') . qq| + <input name=interval class=radio type=radio value=3> | + . $locale->text('Quarter') . qq| + <input name=interval class=radio type=radio value=12> | + . $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> +|; + +} + |