SF.net SVN: ledger-smb: [1181] branches/1.2/LedgerSMB/AA.pm

[..hidden..]

Revision: 1181
          http://svn.sourceforge.net/ledger-smb/?rev=1181&view=rev
Author:   einhverfr
Date:     2007-05-13 19:07:33 -0700 (Sun, 13 May 2007)

Log Message:
-----------
Applying performance patch

Modified Paths:
--------------
    branches/1.2/LedgerSMB/AA.pm

Modified: branches/1.2/LedgerSMB/AA.pm
===================================================================
--- branches/1.2/LedgerSMB/AA.pm	2007-05-10 23:53:48 UTC (rev 1180)
+++ branches/1.2/LedgerSMB/AA.pm	2007-05-14 02:07:33 UTC (rev 1181)
@@ -1122,16 +1122,15 @@
     if ( !$form->{id} && $form->{type} !~ /_(order|quotation)/ ) {
 
         $query = qq|
-			   SELECT c.accno, c.description, c.link, c.category,
-			          ac.project_id, p.projectnumber, 
-			          a.department_id, d.description AS department
+			   SELECT c.accno, c.description, c.link, 
+                                  c.category,
+			          ac.project_id
+			          a.department_id
 			     FROM chart c
 			     JOIN acc_trans ac ON (ac.chart_id = c.id)
 			     JOIN $arap a ON (a.id = ac.trans_id)
-			LEFT JOIN project p ON (ac.project_id = p.id)
-			LEFT JOIN department d ON (d.id = a.department_id)
 			    WHERE a.$form->{vc}_id = ?
-			          AND a.id IN (SELECT max(id) 
+			          AND a.id = (SELECT max(id) 
 			                         FROM $arap
 			                        WHERE $form->{vc}_id = 
 			                              ?)
@@ -1144,9 +1143,7 @@
         my $i = 0;
 
         while ( $ref = $sth->fetchrow_hashref(NAME_lc) ) {
-            $form->{department}    = $ref->{department};
             $form->{department_id} = $ref->{department_id};
-
             if ( $ref->{link} =~ /_amount/ ) {
                 $i++;
                 $form->{"$form->{ARAP}_amount_$i"} =
@@ -1165,6 +1162,10 @@
         }
 
         $sth->finish;
+        $query = "select description from department where id = ?";
+        $sth = $dbh->prepare($query);
+        $sth->execute($form->{department_id});
+        ($form->{department}) = $sth->fetchrow_array;
         $form->{rowcount} = $i if ( $i && !$form->{type} );
     }
 


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