From fcd5ee36c7b5f42d557ca7b0ec8be997c0faaadb Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 3 Oct 2006 03:26:37 +0000 Subject: Merged SL-POS. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@185 4979c152-3d1c-0410-bac9-87ea11338e46 --- CONTRIBUTORS | 8 +- LedgerSMB/Form.pm | 21 +- LedgerSMB/IC.pm | 36 +-- LedgerSMB/RC.pm | 80 +++++- bin/mozilla/gl.pl | 21 +- bin/mozilla/ir.pl | 65 +++++ bin/mozilla/pos.pl | 122 ++++++++- bin/mozilla/ps.pl | 1 + bin/mozilla/rc.pl | 353 ++++++++++++++++++++++++++- drivers/pd3000.pl | 47 ++++ menu.ini | 13 + pos.conf.pl | 79 ++++++ utils/pos/directnet.pl | 20 ++ utils/pos/pos-hardware-client-startup-script | 11 + 14 files changed, 832 insertions(+), 45 deletions(-) create mode 100644 drivers/pd3000.pl create mode 100644 pos.conf.pl create mode 100755 utils/pos/directnet.pl create mode 100755 utils/pos/pos-hardware-client-startup-script diff --git a/CONTRIBUTORS b/CONTRIBUTORS index b6214f3c..c1ee262c 100644 --- a/CONTRIBUTORS +++ b/CONTRIBUTORS @@ -17,6 +17,9 @@ Contributed database fixes. Seneca Cunningham Contributed code fixes. +Jason Rodriguez provided the logic to force +the password change in the admin.pl. He maintains the Gentoo Ebuilds packages. + Other Contributors: ======================== Dave van Ginneken fixed many HTML errors and has patched @@ -25,11 +28,9 @@ the setup.diff. Angus Carr Has provided some corrections to the documentation. -Jason Rodriguez provided the logic to force -the password change in the admin.pl Christopher Browne provided some corrections to the -documentation, the Pg-tables.sql, and a setup file for replication +documentation, the Pg-tables.sql, and a setup file for replication. Original Authors of SQL-Ledger: @@ -39,4 +40,3 @@ Original author of SQL-Ledger, on which LedgerSMB is based. He also owns DWS Systems, Inc. Tony Fraser -Both of the above are mentioned as contributors to a single file in SQL-Ledger. diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm index 4865e198..cd30803b 100755 --- a/LedgerSMB/Form.pm +++ b/LedgerSMB/Form.pm @@ -523,6 +523,23 @@ sub callproc { @results; } +sub get_my_emp_num { + my ($self, $myconfig, $form) = @_; + %myconfig = %{$myconfig}; + my $dbh = $form->{dbh}; + # we got a connection, check the version + my $query = qq| + SELECT employeenumber FROM employee + WHERE login = ?|; + my $sth = $dbh->prepare($query); + $sth->execute($form->{login}) || $form->dberror($query); + $sth->execute; + + my ($id) = $sth->fetchrow_array; + $sth->finish; + $form->{'emp_num'} = $id; +} + sub parse_template { my ($self, $myconfig, $userspath) = @_; @@ -1297,8 +1314,8 @@ sub db_init { } sub run_custom_queries { - my $dbh = $self->{dbh}; my ($self, $tablename, $query_type, $linenum) = @_; + my $dbh = $self->{dbh}; if ($query_type !~ /^(select|insert|update)$/i){ $self->error($locale->text( "Passed incorrect query type to get_cutstom_queries." @@ -1379,7 +1396,7 @@ sub run_custom_queries { } elsif ($query_type eq 'SELECT'){ for (@rc){ $query = shift @{$_}; - $sth = $form->{dbh}->prepare($query); + $sth = $self->{dbh}->prepare($query); $sth->execute($form->{id}); $ref = $sth->fetchrow_hashref(NAME_lc); for (keys %{$ref}){ diff --git a/LedgerSMB/IC.pm b/LedgerSMB/IC.pm index ebf9f429..32c409ec 100755 --- a/LedgerSMB/IC.pm +++ b/LedgerSMB/IC.pm @@ -38,7 +38,7 @@ sub get_part { my ($self, $myconfig, $form) = @_; # connect to db - my $dbh = $form->dbconnect($myconfig); + my $dbh = $form->{dbh}; my $i; my $query = qq|SELECT p.*, @@ -80,11 +80,11 @@ sub get_part { FROM parts p JOIN assembly a ON (a.parts_id = p.id) LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) - WHERE a.id = $form->{id} + WHERE a.id = ? |; $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); + $sth->execute($form->{id}) || $form->dberror($query); $form->{assembly_rows} = 0; while (my $ref = $sth->fetchrow_hashref(NAME_lc)) { @@ -106,10 +106,10 @@ sub get_part { if ($form->{makemodel} ne "") { $query = qq|SELECT make, model FROM makemodel - WHERE parts_id = $form->{id}|; + WHERE parts_id = ?|; $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); + $sth->execute($form->{id}) || $form->dberror($query); while ($ref = $sth->fetchrow_hashref(NAME_lc)) { push @{ $form->{makemodels} }, $ref; @@ -122,10 +122,10 @@ sub get_part { $query = qq|SELECT c.accno FROM chart c, partstax pt WHERE pt.chart_id = c.id - AND pt.parts_id = $form->{id}|; + AND pt.parts_id = ?|; $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); + $sth->execute($form->{id}) || $form->dberror($query); while (($key) = $sth->fetchrow_array) { $form->{amount}{$key} = $key; @@ -133,22 +133,23 @@ sub get_part { $sth->finish; + my $id = $dbh->quote($form->{id}); # is it an orphan $query = qq|SELECT parts_id FROM invoice - WHERE parts_id = $form->{id} + WHERE parts_id = $id UNION SELECT parts_id FROM orderitems - WHERE parts_id = $form->{id} + WHERE parts_id = $id UNION SELECT parts_id FROM assembly - WHERE parts_id = $form->{id} + WHERE parts_id = $id UNION SELECT parts_id FROM jcitems - WHERE parts_id = $form->{id}|; + WHERE parts_id = $id ($form->{orphaned}) = $dbh->selectrow_array($query); $form->{orphaned} = !$form->{orphaned}; @@ -166,11 +167,11 @@ sub get_part { pv.lastcost, pv.leadtime, pv.curr AS vendorcurr FROM partsvendor pv JOIN vendor v ON (v.id = pv.vendor_id) - WHERE pv.parts_id = $form->{id} + WHERE pv.parts_id = ? ORDER BY 2|; $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); + $sth->execute($form->{id}) || $form->dberror($query); while ($ref = $sth->fetchrow_hashref(NAME_lc)) { push @{ $form->{vendormatrix} }, $ref; @@ -187,18 +188,18 @@ sub get_part { FROM partscustomer pc LEFT JOIN customer c ON (c.id = pc.customer_id) LEFT JOIN pricegroup g ON (g.id = pc.pricegroup_id) - WHERE pc.parts_id = $form->{id} + WHERE pc.parts_id = ? ORDER BY c.name, g.pricegroup, pc.pricebreak|; $sth = $dbh->prepare($query); - $sth->execute || $form->dberror($query); + $sth->execute($form->{id}) || $form->dberror($query); while ($ref = $sth->fetchrow_hashref(NAME_lc)) { push @{ $form->{customermatrix} }, $ref; } $sth->finish; } - - $dbh->disconnect; + + $form->get_custom_queries('parts', 'SELECT'); } @@ -492,6 +493,7 @@ sub save { my $rc = $dbh->commit; $dbh->disconnect; + $form->get_custom_queries('parts', 'UPDATE'); $rc; } diff --git a/LedgerSMB/RC.pm b/LedgerSMB/RC.pm index e1c3a144..47a8a4c4 100755 --- a/LedgerSMB/RC.pm +++ b/LedgerSMB/RC.pm @@ -33,12 +33,90 @@ package RC; + +sub getposlines{ + my ($self, $myconfig, $form) = @_; + %pos_config = %{$form->{pos_config}}; + %pos_sources = %{$form->{pos_sources}}; + my $sources = ''; + foreach $key (keys %pos_sources){ + $sources .= ", '$key'"; + } + $sources =~ s/^,\s*//; + my $dbh = $form->{dbh}; + + # Considering the query below to be safe since all variables are from config + # files rather than user input. + my $query = qq| + SELECT sum(amount) AS amount, source FROM acc_trans + WHERE chart_id = + (SELECT id FROM chart WHERE accno = '$pos_config{till_accno}') + AND transdate = date 'NOW' + AND cleared IS NOT TRUE + GROUP BY source + |; + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + while (my $ref = $sth->fetchrow_hashref(NAME_lc)) { + push @{$form->{TB}}, $ref; + } + $sth->finish; + my $query = qq| + SELECT sum(amount) AS sum FROM acc_trans + WHERE chart_id = + (SELECT id FROM chart WHERE accno = '$pos_config{till_accno}') + AND transdate = date 'NOW' + AND cleared IS NOT TRUE + |; + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + my $ref = $sth->fetchrow_hashref(NAME_lc); + $form->{sum} = $ref->{sum}; + $sth->finish; +} + +sub clear_till { + my ($self, $myconfig, $form) = @_; + %pos_config = %{$form->{pos_config}}; + %pos_sources = %{$form->{pos_sources}}; + my $sources = ''; + foreach $key (keys %pos_sources){ + $sources .= ", '$key'"; + } + $sources =~ s/^,\s//; + my $dbh = $form->{dbh}; + my $query = qq| + UPDATE acc_trans + SET cleared = TRUE + WHERE chart_id = + (SELECT id FROM chart WHERE accno = '$pos_config{till_accno}') + AND transdate = date 'NOW' + |; + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); +} + +sub getbalance{ + my ($self, $myconfig, $form) = @_; + my $dbh = $form->{dbh}; + + my $query = qq|SELECT sum(amount) AS balance + FROM acc_trans + WHERE chart_id = + (SELECT id FROM chart WHERE accno = '$form->{accno}')|; + + my $sth = $dbh->prepare($query); + $sth->execute || $form->dberror($query); + my $ref = $sth->fetchrow_hashref(NAME_lc); + $form->{balance} = $ref->{balance}; +} + sub paymentaccounts { my ($self, $myconfig, $form) = @_; # connect to database - my $dbh = $form->dbconnect($myconfig); + my $dbh = $form->{dbh}; my $query = qq|SELECT accno, description FROM chart diff --git a/bin/mozilla/gl.pl b/bin/mozilla/gl.pl index 3e238609..9a83675a 100755 --- a/bin/mozilla/gl.pl +++ b/bin/mozilla/gl.pl @@ -83,7 +83,23 @@ require "$form->{path}/arap.pl"; # $locale->text('Nov') # $locale->text('Dec') +sub pos_adjust { + $form->{rowcount} = 3; + require "pos.conf.pl"; + $form->{accno_1} = $pos_config{'close_cash_accno'}; + $form->{accno_2} = $pos_config{'coa_prefix'}; + $form->{accno_3} = $pos_config{'coa_prefix'}; +} +sub add_pos_adjust { + $form->{pos_adjust} = 1; + $form->{reference} = $locale->text("Adjusting Till: (till) Source: (source)"); + $form->{description} = + $locale->text("Adjusting till due to data entry error."); + $form->{callback} = "$form->{script}?action=add_pos_adjust&transfer=$form->{transfer}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + &add; +} + sub add { $form->{title} = "Add"; @@ -93,6 +109,9 @@ sub add { &create_links; $form->{rowcount} = ($form->{transfer}) ? 3 : 9; + if ($form->{pos_adjust}){ + &pos_adjust; + } $form->{oldtransdate} = $form->{transdate}; $form->{focus} = "reference"; @@ -856,7 +875,7 @@ sub display_rows { |; } - $form->hide_form(qw(rowcount selectaccno)); + $form->hide_form(qw(rowcount selectaccno pos_adjust)); print qq| |; diff --git a/bin/mozilla/ir.pl b/bin/mozilla/ir.pl index 1e77dce5..35f9975b 100755 --- a/bin/mozilla/ir.pl +++ b/bin/mozilla/ir.pl @@ -461,10 +461,12 @@ sub form_footer { |.$locale->text('Notes').qq| |.$locale->text('Internal Notes').qq| + |.$locale->text('Import Text').qq| $notes $intnotes + @@ -624,8 +626,71 @@ print qq| } +sub import_text { + my @o_list; + my @i_lines = split(/(\n|\r|\r\n)/, $form->{import_text}); + foreach $i (@i_lines){ + chomp($i); + if ($i != ""){ # Strip out blank lines + push @o_list, $i; + } + } + my $c = 1; + my $linenumber = 0; + foreach $l (@o_list){ + if ($c % 2){ + $linenumber += 1; + $form->{"partnumber_$linenumber"} = $l; + } + else { + $form->{"qty_$linenumber"} = $l; + } + $c += 1; + $form->{rowcount}=$linenumber; + IR->retrieve_item(\%myconfig, \%$form); + $rows = scalar @{ $form->{item_list} }; + $rows = 0 unless $rows; + $i = $form->{rowcount}; + if ($rows = 0){ + $form->{"id_$i"} = 0; + $form->{"unit_$i"} = $locale->text('ea'); + + &new_item; + } elsif ($rows > 1){ + &select_item; + exit; + } else { + map { $form->{item_list}[$i]{$_} = $form->quote($form->{item_list}[$i]{$_}) } qw(partnumber description unit); + + map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; + + $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; + + ($dec) = ($s =~ /\.(\d+)/); + $dec = length $dec; + $decimalplaces = ($dec > 2) ? $dec : 2; + + $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * (1 - $form->{"discount_$i"} / 100); + map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); + map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); + map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{"taxaccounts_$i"} if !$form->{taxincluded}; + + $form->{creditremaining} -= $amount; + + $form->{"sellprice_$i"} = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); + $form->{"qty_$i"} = $form->format_amount(\%myconfig, $form->{"qty_$i"}); + + } + $form->{item_list} = []; + } + ++$form->{rowcount} +} sub update { + if($form->{import_text}){ + &import_text; + } + $form->{exchangerate} = $form->parse_amount(\%myconfig, $form->{exchangerate}); diff --git a/bin/mozilla/pos.pl b/bin/mozilla/pos.pl index 53627496..f7f817ea 100755 --- a/bin/mozilla/pos.pl +++ b/bin/mozilla/pos.pl @@ -44,12 +44,55 @@ 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, "|-", $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}" unless $form->{callback}; + $form->{callback} = "$form->{script}?action=$form->{nextsub}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; &invoice_links; @@ -68,10 +111,14 @@ sub add { &display_form; + $form->{dontdisplayrows} = 1; + &openinvoices; } sub openinvoices { + undef %column_data; + undef %column_heading; $ENV{REMOTE_ADDR} =~ /(\d+)\.(\d+)\.(\d+)\.(\d+)/; $form->{till} = $4; @@ -94,7 +141,7 @@ 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}" unless $form->{callback}; + $form->{callback} = "$form->{script}?action=$form->{nextsub}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; &invoice_links; &prepare_invoice; @@ -115,6 +162,10 @@ sub edit { sub form_header { + if (!$form->{'check_id'}){ + &check_alert; + } + # set option selected for (qw(AR currency)) { $form->{"select$_"} =~ s/ selected//; @@ -228,7 +279,7 @@ sub form_header {
|; - $form->hide_form(qw(id till type format printed title discount creditlimit creditremaining tradediscount business closedto locked oldtransdate customer_id oldcustomer)); + $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| @@ -236,7 +287,15 @@ sub form_header { - + |; + if ($form->{'check_id'}){ + print qq| + + + |; + } + print qq| |; + if ($form->{"paid__$i"}){ + $column_data{paid} = qq||; + } else { + $column_data{paid} = qq||; + } + $column_data{source} = qq||; $column_data{memo} = qq||; - $column_data{AR_paid} = qq||; + 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||; + } else { + $column_data{AR_paid} = qq||; + } print qq| |; @@ -520,6 +592,7 @@ sub form_footer { sub post { + $form->{media} = 'Printer'; $form->isblank("customer", $locale->text('Customer missing!')); # if oldcustomer ne customer redo form @@ -532,6 +605,7 @@ sub post { } &validate_items; + &print; $form->isblank("exchangerate", $locale->text('Exchange rate missing!')) if ($form->{currency} ne $form->{defaultcurrency}); @@ -542,7 +616,16 @@ sub post { $total = $form->parse_amount(\%myconfig, $form->{invtotal}); # deduct change from first payment - $form->{"paid_1"} = $form->format_amount(\%myconfig, $form->parse_amount(\%myconfig, $form->{"paid_1"}) - ($paid - $total), 2) if $paid > $total; + #$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}; @@ -667,6 +750,22 @@ sub display_row { 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"); @@ -681,7 +780,8 @@ sub print { for (qw(employee department)) { $form->{$_} =~ s/--.*//g; } $form->{invdate} = $form->{transdate}; - $form->{dateprinted} = scalar localtime; + my @lt = localtime(); + $form->{dateprinted} = $lt[2].":".$lt[1].":".$lt[0]; &print_form($old_form); @@ -690,6 +790,7 @@ sub print { sub print_form { my $old_form = shift; + &open_drawer; # if oldcustomer ne customer redo form $customer = $form->{customer}; @@ -743,6 +844,7 @@ sub print_form { $form->{rowcount}--; $form->{pre} = "\n
";
   delete $form->{stylesheet};
+  $form->{cd_open} = $pos_config{rp_cash_drawer_open};
   
   $form->parse_template(\%myconfig, $userspath);
 
@@ -768,7 +870,7 @@ sub print_form {
 
     if (! $form->{printandpost}) {
       $form->{rowcount}--;
-      &display_form;
+      #&display_form;
     }
   }
 
diff --git a/bin/mozilla/ps.pl b/bin/mozilla/ps.pl
index d8a8bef9..7601fd7e 100755
--- a/bin/mozilla/ps.pl
+++ b/bin/mozilla/ps.pl
@@ -50,6 +50,7 @@ require "$form->{path}/ar.pl";
 require "$form->{path}/is.pl";
 require "$form->{path}/rp.pl";
 require "$form->{path}/pos.pl";
+require "pos.conf.pl";
 
 # customizations
 if (-f "$form->{path}/custom_pos.pl") {
diff --git a/bin/mozilla/rc.pl b/bin/mozilla/rc.pl
index c310f9e0..fc5ee24d 100755
--- a/bin/mozilla/rc.pl
+++ b/bin/mozilla/rc.pl
@@ -188,10 +188,299 @@ sub reconciliation {
 
 sub continue { &{ $form->{nextsub} } };
 
+sub till_closing {
+  $form->{callback} = "$form->{script}?path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}";
+
+  @colheadings = qw(Source Actual Expected Error);
+
+  $form->{title} = "Closing Till For $form->{login}";
+  require "pos.conf.pl"; 
+  RC->getposlines(\%myconfig, \%$form);
+  $form->header;
+  print qq|
+
+
+{script}>
+{path}>
+{login}>
+{sessionid}>
+
+
+
+
$form->{title}
|.$locale->text('Check ID').qq| +
@@ -378,12 +437,25 @@ sub form_footer { $form->{"paid_$i"} = $form->format_amount(\%myconfig, $form->{"paid_$i"}, 2); $form->{"exchangerate_$i"} = $form->format_amount(\%myconfig, $form->{"exchangerate_$i"}); - - $column_data{paid} = qq|{"paid_$i"}>{"paid_$i"}>{"paid_$i"}>
+ + + +
$form->{title}
+ +|; + + print ""; + map {print "";} @colheadings; + print ""; + my $j; + my $source; + foreach $source (sort keys %pos_sources){ + $amount = 0; + foreach $ref (@{$form->{TB}}){ + if ($ref->{source} eq $source){ + $amount = $ref->{amount} * -1; + last; + } + } + ++$j; + $j = $j % 2; + print qq| + + + |; + } + print qq| + + +
$_
|.$pos_sources{$source}.qq| + \$$amount 
++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
X \$100 =
X \$50 =
X \$20 =
X \$10 =
X \$5 =
X \$1 =
X \$0.50 =
X \$.25 =
X \$.10 =
X \$.05 =
X \$.01 =
 Subtotal:
+ +|; + print qq||; + print qq| +
+ + + +|; +} + + +sub close_till { + use SL::GL; + require 'pos.conf.pl'; + RC->clear_till(\%myconfig, \%$form); + my $amount = 0; + my $expected = 0; + my $difference = 0; + my $lines = ''; + $form->{rowcount} = 2; + foreach $key (keys %pos_sources){ + $amount = 0; + $expected = 0; + $amount = $form->parse_amount(\%myconfig, $form->{"amount_$key"}); + $expected = $form->parse_amount(\%myconfig, $form->{"expected_$key"}); + $gl_entry = "Closing Till $pos_config{till} source = $key"; + $accno1 = $pos_config{till_accno}; + if (${$pos_config{'source_accno_override'}{$key}}){ + $accno2 = ${$pos_config{'source_accno_override'}{$key}}; + } else { + $accno2 = $pos_config{'close_cash_accno'}; + } + $form->{reference} = $gl_entry; + $form->{accno_1} = $accno1; + $form->{credit_1} = $amount; + $form->{accno_2} = $accno2; + $form->{debit_2} = $amount; + $form->{transdate} = $form->current_date(\%myconfig); + GL->post_transaction(\%myconfig, \%$form); + delete $form->{id}; + $error = $amount - $expected; + $difference += $error; + $lines .= "Source: $key, Amount: $amount\nExpected: $expected. Error= $error\n\n"; + } + $gl_entry = "Closing Till: $pos_config{till} Over/Under"; + $amount = $difference * -1; + $form->{reference} = $gl_entry; + $form->{accno_1} = $accno1; + $form->{credit_1} = $amount; + $form->{accno_2} = $pos_config{coa_prefix}; + $form->{debit_2} = $amount; + $form->{transdate} = $form->current_date(\%myconfig); + GL->post_transaction(\%myconfig, \%$form); + delete $form->{id}; + $lines .= "Cumulative Error: $amount"; + $form->{accno} = $form->{accno_1}; + RC->getbalance(\%myconfig, \%$form); + $amount = $form->{balance} * -1; + $gl_entry = "Resetting Till: $pos_config{till}"; + $form->{reference} = $gl_entry; + $form->{accno_1} = $accno1; + $form->{credit_1} = $amount; + $form->{accno_2} = $pos_config{coa_prefix}; + $form->{debit_2} = $amount; + $form->{transdate} = $form->current_date(\%myconfig); + GL->post_transaction(\%myconfig, \%$form); + delete $form->{id}; + + $head = "Closing Till $pos_config{till} for $form->{login}\n". + "Date: $form->{transdate}\n\n\n"; + $cash = join ("\n", + ("Cash Breakdown:", + "$form->{calc_100} x 100 = $form->{sub_100}", + "$form->{calc_50} x 50 = $form->{sub_50}", + "$form->{calc_20} x 20 = $form->{sub_20}", + "$form->{calc_10} x 10 = $form->{sub_10}", + "$form->{calc_5} x 5 = $form->{sub_5}", + "$form->{calc_1} x 1 = $form->{sub_1}", + "$form->{calc_050} x 0.50 = $form->{sub_050}", + "$form->{calc_025} x 0.25 = $form->{sub_025}", + "$form->{calc_010} x 0.10 = $form->{sub_010}", + "$form->{calc_005} x 0.05 = $form->{sub_005}", + "$form->{calc_001} x 0.01 = $form->{sub_001}", + "Total Cash in Drawer: $form->{sub_sub}", + "Less Cash in Till At Start: $pos_config{till_cash}", + "\n")); + $foot = "Cumulative Error: $difference\n Reset Till By $amount\n\n\n\n\n\n\n\n\n\n"; + open (PRN, "|-", $printer{Printer}); + print PRN $head; + print PRN $lines; + print PRN $cash; + print PRN $cash; + print PRN $foot; + close PRN; + if ($difference > 0){ + $message = "You are over by ".$difference; + } elsif ($difference < 0){ + $message = "You are under by ".$difference * -1; + } + else { + $message = "Congradulations! Your till is exactly balanced."; + } + $form->info($message); +} sub get_payments { ($form->{accno}, $form->{account}) = split /--/, $form->{accno}; + if ($form->{'pos'}){ + require "pos.conf.pl"; + $form->{fromdate} = $form->current_date(\%myconfig); + unless ($form->{source}){ + $form->{source} = (sort keys(%pos_sources))[0]; + } + if ($form->{source} eq 'cash'){ + $form->{summary} = "true"; + } else { + $form->{summary} = ""; + } + $form->{accno} = $pos_config{'coa_prefix'} . "." . $pos_config{'till'}; + $form->{account} = $form->{source}; + } RC->payment_transactions(\%myconfig, \%$form); @@ -243,6 +532,8 @@ sub display_form {
{script}> + + @@ -359,12 +650,15 @@ sub display_form { $column_data{cleared} = qq|{cleared}> {oldcleared}> - |; + + |; } else { $cleared += $ref->{amount} * $ml if $checked; $clearfx = ($checked) ? 1 : 0; $column_data{cleared} = qq||; + + + |; } } @@ -402,6 +696,9 @@ sub display_form { $form->{statementbalance} = $form->parse_amount(\%myconfig, $form->{statementbalance}); $difference = $form->format_amount(\%myconfig, $form->{beginningbalance} + $cleared - $form->{statementbalance}, 2, 0); + if ($form->{source}){ + $difference = 0; + } $form->{statementbalance} = $form->format_amount(\%myconfig, $form->{statementbalance}, 2, 0); print qq| @@ -411,7 +708,46 @@ sub display_form { |; - + if ($form->{'pos'}){ + $close_next = qq||; + $done = ""; + } + else { + $close_next = ""; + $done = qq||; + } + if ($form->{'pos'}){ + $difference = qq| + + + + + + + |; + if ($form->{'over_under'}){ + $o_u = $form->{'over_under'}; + $difference =~ s/(value=$o_u)/SELECTED $1/g; + } + } else { + $difference = qq| + + + + + + |; + } + + if ($form->{report}) { print qq| @@ -434,12 +770,7 @@ sub display_form { - - - - - - + $difference
$form->{title}* -
+
|.$locale->text('Difference').qq|
{statementbalance}>
|.$locale->text('Difference').qq|
@@ -458,7 +789,8 @@ sub display_form {
-|; + $done + $close_next |; } if ($form->{menubar}) { @@ -477,6 +809,7 @@ sub display_form { sub update { + $form->{null2} = $form->{null}; RC->payment_transactions(\%myconfig, \%$form); diff --git a/drivers/pd3000.pl b/drivers/pd3000.pl new file mode 100644 index 00000000..a73ae932 --- /dev/null +++ b/drivers/pd3000.pl @@ -0,0 +1,47 @@ +# +###################################################################### +# LedgerSMB Accounting and ERP +# 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. +# Driver for Logic Controls PD-3000 Pole Display. +# As with all pole display drivers, the control codes are contained in a hash +# array called $pd_control. + +# THis pole display uses separate meanings for LF and CR. Both are included. +# LF moves the cursor to the other line (same position), while CR moves the +# cursor to the left-most spot (same line). Assume most PD's do this. +# Most of this is simple ASCII, but what to make things clear. + +# This first part is straight from the manual. +# Not including the bit about installing fonts. + +%pd_control = ( + 'mode_vscroll' => pack('C', 18), + 'mode_normal' => pack('C', 17), + 'bright_full' => pack('CC', 4, 0xFF), + 'bright_high' => pack('CC', 4, 0x60), + 'bright_med' => pack('CC', 4, 0x40), + 'bright_low' => pack('CC', 4, 0x20), + 'backspace' => pack('C', 8), + 'htab' => pack('C', 9), # Functions like cursor movement + 'lf' => pack('C', 0x0A), + 'cr' => pack('C', 0x0D), + 'digit_select' => pack('C', 0x10), # Pack followed by a number 0-39 + 'cursor_on' => pack('C', 0x13), + 'cursor_off' => pack('C', 0x14), + 'reset' => pack('C', 0x1F), + 'scroll_message' => pack ('C', 0x05), # Followed by up to 45 chars. +); + +# A few more useful control sequences: +$pd_control{'new_line'} = $pd_control{'cr'}.$pd_control{'lf'}; + diff --git a/menu.ini b/menu.ini index 02485adc..1611cf1f 100644 --- a/menu.ini +++ b/menu.ini @@ -83,6 +83,11 @@ action=openinvoices module=ps.pl action=receipts +[POS--Close Till] +module=rc.pl +action=till_closing +pos=true + [AP] [AP--Add Transaction] @@ -332,6 +337,14 @@ action=add module=gl.pl action=search +[General Ledger--Adjust Till] +module=gl.pl +action=add_pos_adjust +reference=Adjusting Till: (till) Source: (source) +rowcount=3 +pos_adjust=1 +description=Adjusting till due to data entry error. + [Goods & Services] [Goods & Services--Add Part] diff --git a/pos.conf.pl b/pos.conf.pl new file mode 100644 index 00000000..f0981aa0 --- /dev/null +++ b/pos.conf.pl @@ -0,0 +1,79 @@ + +# This sets up the settings for the POS hardware. You can use it to override +# printing commands etc. as well. + +# Chris Travers +# Chris@metatrontech.com +# 2004-02-07 + +# Begin Editing Here + +$pos_config{'rem_host'}=$ENV{'REMOTE_ADDR'}; + +$pos_config{'pd_host'} = $pos_config{'rem_host'}; +$pos_config{'pd_port'} = 6601; +$pos_config{'pd_proto'} = 'tcp'; + +require "drivers/pd3000.pl"; # Use the PD3000 driver + +# Some businesses may want to Override this for custom apps +$pos_config{'pd_host'} = $pos_config{'rem_host'}; + +$pos_config{'rp_port'} = 6602; +$pos_config{'rp_proto'} = 'tcp'; + +$pos_config{'rp_netdirect'} = 'yes'; + +# Some businesses may want to Override this for custom apps +$pos_config{'rp_host'} = $pos_config{'rem_host'}; +$pos_config{'rp_cash_open'} = pack("CCCCC",27,112,0,25,250); + +$pos_config{'coa_prefix'} = 1300; + +$pos_config{'close_cash_accno'} = 1060; +$pos_config{till_cash} = 200; +# Add your sources here. + +$pos_sources{'visa'} = "Visa/MC"; +$pos_sources{'disc'} = "Discover"; +$pos_sources{'check'} = 'Check'; +$pos_sources{'cash'} = 'Cash'; +$pos_sources{'gcert'} = 'Gift Cert'; + +${$pos_config{'source_accno_override'}{'gcert'}} = '2105'; +# Define your till accno scheme here. Current supported values are 'termina' +# and 'cashier' + +$pos_config{'till_type'} = 'cashier'; + +# FLAGS: 1 = projects, 2 = departments +$pos_config{'disable_tables'} = 3; +# Stop Editing Here + +if (lc($pos_config{'till_type'}) eq 'terminal'){ + $pos_config{'till'} = (split(/\./, $pos_config{'rem_host'}))[3]; +} +elsif (lc($pos_config{'till_type'}) eq 'cashier'){ + use LedgerSMB::User; + $pos_config{'till'} = $form->get_my_emp_num(\%myconfig, \%$form); +} +else { + $form->error("No till type defined in pos.conf.pl!"); +} +$pos_config{till_accno} = "$pos_config{coa_prefix}.$pos_config{till}"; +$pos_config{'pd_dest'}=pack( + 's n a4 x8', 2, $pos_config{'pd_port'}, + pack('CCCC', split(/\./, $pos_config{'pd_host'})) +); + + +$form->{pos_config} = \%pos_config; +$form->{pos_sources} = \%pos_sources; + +# Due to the architecture of SL, we need to use netcat to print. +# Otherwise the document gets spooled twice and this interferes with timeliness. + +%printer = ( + 'Printer' => "utils/pos/directnet.pl $pos_config{rp_host} $pos_config{rp_proto} $pos_config{rp_port}" +); +1; diff --git a/utils/pos/directnet.pl b/utils/pos/directnet.pl new file mode 100755 index 00000000..3bdd2e51 --- /dev/null +++ b/utils/pos/directnet.pl @@ -0,0 +1,20 @@ +#!/usr/bin/perl + +($host, $proto, $port) = @ARGV; + +socket(SOCK, 2, 1, getprotobynumber($proto)); + +$dest=pack( + 's n a4 x8', 2, $port, + pack('CCCC', split(/\./, $host)) +); + +connect (SOCK, $dest); + +open ('STD', '-'); +while ($line = ){ + print SOCK $line; +} +close STD; +close SOCK; + diff --git a/utils/pos/pos-hardware-client-startup-script b/utils/pos/pos-hardware-client-startup-script new file mode 100755 index 00000000..bcb3240a --- /dev/null +++ b/utils/pos/pos-hardware-client-startup-script @@ -0,0 +1,11 @@ +#!/bin/bash +netcat=/usr/local/bin/netcat +while((1)) +do + $netcat -lp6601 > /dev/ttyS0 +done& + +while((1)) +do + $netcat -lp6602 > /dev/lp0 +done& -- cgit v1.2.3