SF.net SVN: ledger-smb: [1206]

[..hidden..]

Revision: 1206
          http://svn.sourceforge.net/ledger-smb/?rev=1206&view=rev
Author:   einhverfr
Date:     2007-05-17 15:42:50 -0700 (Thu, 17 May 2007)

Log Message:
-----------
Tagging 1.2.5

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

Added Paths:
-----------
    tags/1.2.5/

Copied: tags/1.2.5 (from rev 1196, branches/1.2)

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2007-05-17 22:40:47 UTC (rev 1205)
+++ trunk/LedgerSMB/AA.pm	2007-05-17 22:42:50 UTC (rev 1206)
@@ -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.