SF.net SVN: ledger-smb:[4728] branches/1.3

[..hidden..]

Revision: 4728
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4728&view=rev
Author:   einhverfr
Date:     2012-05-19 07:11:40 +0000 (Sat, 19 May 2012)
Log Message:
-----------
finishing the fix for email addresses not populating when emailing statements

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/LedgerSMB/RP.pm

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2012-05-19 06:59:11 UTC (rev 4727)
+++ branches/1.3/Changelog	2012-05-19 07:11:40 UTC (rev 4728)
@@ -7,6 +7,7 @@
 * Added ODS pricelists (Chris T)
 * Better CSV escaping (Chris T, h/t Erik H)
 * Fixed menu errors preventing quote/rfq template editing (Chris T, 3524793)
+* Fixed customer email not showing emailing statements (Chris T and Erik H)
 
 
 Changelog for 1.3.17

Modified: branches/1.3/LedgerSMB/RP.pm
===================================================================
--- branches/1.3/LedgerSMB/RP.pm	2012-05-19 06:59:11 UTC (rev 4727)
+++ branches/1.3/LedgerSMB/RP.pm	2012-05-19 07:11:40 UTC (rev 4728)
@@ -1883,8 +1883,8 @@
     my $query = qq|
 		SELECT e.name, c.contact, cc.class 
                   FROM entity_credit_account eca
-                  JOIN entity USING (entity_id)
-                  JOIN eca_to_contact c ON (eca.credit_id = eca.id)
+                  JOIN entity e ON e.id = eca.entity_id
+                  JOIN eca_to_contact c ON (c.credit_id = eca.id)
                   JOIN contact_class cc ON (c.contact_class_id = cc.id)
 		 WHERE eca.id = ?
                        AND cc.id BETWEEN 12 AND 17|;
@@ -1895,6 +1895,7 @@
         $form->{ lc($ref->{class}) } .=
 	    ($form->{ lc($ref->{class}) } ? ", " : "") . $ref->{contact};
     }
+    
 
     $dbh->commit;
 

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