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

[..hidden..]

Revision: 3351
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3351&view=rev
Author:   einhverfr
Date:     2011-06-27 03:32:12 +0000 (Mon, 27 Jun 2011)

Log Message:
-----------
removing some dependencies on customer/vendor/employee views

Modified Paths:
--------------
    trunk/LedgerSMB/Form.pm
    trunk/sql/Pg-database.sql

Modified: trunk/LedgerSMB/Form.pm
===================================================================
--- trunk/LedgerSMB/Form.pm	2011-06-27 03:02:38 UTC (rev 3350)
+++ trunk/LedgerSMB/Form.pm	2011-06-27 03:32:12 UTC (rev 3351)
@@ -2057,7 +2057,7 @@
     my $query = qq|
 		SELECT id, name
 		FROM entity
-		WHERE id IN (SELECT entity_id FROM employee
+		WHERE id IN (SELECT entity_id FROM entity_employee
 					WHERE|;
 
     if ($transdate) {
@@ -2594,13 +2594,14 @@
     }
     $where = "AND $where " if $where;
     my $inv_notes;
-    $inv_notes = "ct.invoice_notes," if $vc eq 'customer';
+    # $inv_notes = "ct.invoice_notes," if $vc eq 'customer'; 
+    # $inv_notes apparently not implemented at present.  --CT
     my $query = qq|
 		SELECT entity.name, ct.curr AS currency, entity_id AS ${vc}_id,
 			current_date + ct.terms AS duedate, 
 			$inv_notes 
 			ct.curr AS currency
-		FROM $vc ct
+		FROM entity_credit_account ct
 		JOIN entity ON (ct.entity_id = entity.id)
 		WHERE entity.id = (select entity_id from $arap 
 		                    where entity_id IS NOT NULL $where 

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-06-27 03:02:38 UTC (rev 3350)
+++ trunk/sql/Pg-database.sql	2011-06-27 03:32:12 UTC (rev 3351)
@@ -886,6 +886,10 @@
   make text,
   model text
 );
+
+COMMENT ON TABLE makemodel IS
+$$ A single parts entry can have multiple make/model entries.  These
+store manufacturer/model number info.$$;
 --
 CREATE TABLE gl (
   id int DEFAULT nextval ( 'id' ) PRIMARY KEY REFERENCES transactions(id),


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