SF.net SVN: ledger-smb: [1917] trunk

[..hidden..]

Revision: 1917
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1917&view=rev
Author:   einhverfr
Date:     2007-11-28 23:37:44 -0800 (Wed, 28 Nov 2007)

Log Message:
-----------
Removing duplicate drawer open

Modified Paths:
--------------
    trunk/bin/pos.pl
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Payment.sql

Modified: trunk/bin/pos.pl
===================================================================
--- trunk/bin/pos.pl	2007-11-29 07:36:52 UTC (rev 1916)
+++ trunk/bin/pos.pl	2007-11-29 07:37:44 UTC (rev 1917)
@@ -65,11 +65,6 @@
   close SOCK;
 }
 
-sub on_update{
-   &custom_send_to_pd;
-   &custom_check_alert;
-}
-
 sub open_drawer{
    require "pos.conf.pl";
    open (PRINTER, "|-", ${'LedgerSMB::Sysconfig::printer'}{Printer});
@@ -947,7 +942,6 @@
 
 sub print_form {
     my $old_form = shift;
-    &open_drawer;
 
     # if oldcustomer ne customer redo form
     $customer = $form->{customer};

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-11-29 07:36:52 UTC (rev 1916)
+++ trunk/sql/Pg-database.sql	2007-11-29 07:37:44 UTC (rev 1917)
@@ -614,6 +614,7 @@
   on_hold bool default false,
   reverse bool default false,
   approved bool default true,
+  credit_account int references entity_credit_account(id) not null,
   description text
 );
 
@@ -649,7 +650,7 @@
   reverse bool default false,
   terms int2 DEFAULT 0,
   description text,
-  credit_account int
+  credit_account int references entity_credit_account(id)
 );
 
 COMMENT ON COLUMN ap.entity_id IS $$ Used to be customer_id, but customer is now metadata. You need to push to entity $$;

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2007-11-29 07:36:52 UTC (rev 1916)
+++ trunk/sql/modules/Payment.sql	2007-11-29 07:37:44 UTC (rev 1917)
@@ -61,7 +61,7 @@
 );
 
 CREATE OR REPLACE FUNCTION payment_get_open_invoices
-(in_account_class int, in_entity_id int, in_curr char(3))
+(in_account_class int, in_entity_credit_id int, in_curr char(3))
 RETURNS SETOF payment_invoice AS
 $$
 DECLARE payment_inv payment_invoice;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.