[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[3364] trunk/LedgerSMB/OE.pm



Revision: 3364
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3364&view=rev
Author:   einhverfr
Date:     2011-06-28 06:17:28 +0000 (Tue, 28 Jun 2011)

Log Message:
-----------
One more dependency on employee view found

Modified Paths:
--------------
    trunk/LedgerSMB/OE.pm

Modified: trunk/LedgerSMB/OE.pm
===================================================================
--- trunk/LedgerSMB/OE.pm	2011-06-28 06:14:48 UTC (rev 3363)
+++ trunk/LedgerSMB/OE.pm	2011-06-28 06:17:28 UTC (rev 3364)
@@ -87,9 +87,9 @@
 		JOIN entity_credit_account ct ON (o.entity_credit_account = ct.id)
 		JOIN company c ON (c.entity_id = ct.entity_id)
 		LEFT JOIN person pe ON (o.person_id = pe.id)
-		LEFT JOIN employee e ON (pe.entity_id = e.entity_id)
+		LEFT JOIN entity_employee e ON (pe.entity_id = e.entity_id)
 		LEFT JOIN person pm ON (e.manager_id = pm.id)
-		LEFT JOIN employee m ON (pm.entity_id = m.entity_id)
+		LEFT JOIN entity_employee m ON (pm.entity_id = m.entity_id)
 		LEFT JOIN exchangerate ex 
 			ON (ex.curr = o.curr AND ex.transdate = o.transdate)
 		WHERE o.quotation = ?
@@ -788,7 +788,8 @@
 			JOIN company c ON (cr.entity_id = c.entity_id)
 			JOIN entity vc ON (c.entity_id = vc.id)
 			LEFT JOIN person pe ON (o.person_id = pe.id)
-			LEFT JOIN employee e ON (pe.entity_id = e.entity_id)
+			LEFT JOIN entity_employee e 
+                                  ON (pe.entity_id = e.entity_id)
 			LEFT JOIN department d ON (o.department_id = d.id)
 			WHERE o.id = ?|;
         $sth = $dbh->prepare($query);


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