SF.net SVN: ledger-smb:[3382] trunk/LedgerSMB

[..hidden..]

Revision: 3382
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3382&view=rev
Author:   einhverfr
Date:     2011-06-29 11:12:09 +0000 (Wed, 29 Jun 2011)

Log Message:
-----------
More dependencies on dropped views removed

Modified Paths:
--------------
    trunk/LedgerSMB/Form.pm
    trunk/LedgerSMB/IS.pm

Modified: trunk/LedgerSMB/Form.pm
===================================================================
--- trunk/LedgerSMB/Form.pm	2011-06-29 11:07:36 UTC (rev 3381)
+++ trunk/LedgerSMB/Form.pm	2011-06-29 11:12:09 UTC (rev 3382)
@@ -1001,7 +1001,7 @@
 
     # we got a connection, check the version
     my $query = qq|
-		SELECT employeenumber FROM employee 
+		SELECT employeenumber FROM entity_employee 
 		 WHERE entity_id = 
 			(SELECT entity_id FROM users WHERE username = ?)|;
     my $sth = $dbh->prepare($query);
@@ -2403,7 +2403,8 @@
 			JOIN entity_credit_account c 
 				ON (a.entity_credit_account = c.id)
 			JOIN entity ce ON (ce.id = c.entity_id)
-			LEFT JOIN employee er ON (er.entity_id = a.person_id)
+			LEFT JOIN entity_employee er 
+                                   ON (er.entity_id = a.person_id)
 			LEFT JOIN entity e ON (er.entity_id = e.id)
 			LEFT JOIN department d ON (d.id = a.department_id)
                         LEFT JOIN country_tax_form ctf 

Modified: trunk/LedgerSMB/IS.pm
===================================================================
--- trunk/LedgerSMB/IS.pm	2011-06-29 11:07:36 UTC (rev 3381)
+++ trunk/LedgerSMB/IS.pm	2011-06-29 11:12:09 UTC (rev 3382)
@@ -2026,7 +2026,7 @@
 			          a.language_code, a.ponumber,
 			          a.on_hold
 			     FROM ar a
-			LEFT JOIN employee em ON (em.entity_id = a.person_id)
+			LEFT JOIN entity_employee em ON (em.entity_id = a.person_id)
 			INNER JOIN entity e ON e.id = em.entity_id
 			    WHERE a.id = ?|;
 


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