SF.net SVN: ledger-smb:[6590] trunk/LedgerSMB/AA.pm

[..hidden..]

Revision: 6590
          http://sourceforge.net/p/ledger-smb/code/6590
Author:   tshvr
Date:     2014-01-21 13:38:36 +0000 (Tue, 21 Jan 2014)
Log Message:
-----------
tshvr4 trunk svn-revison 6589,$form->login seems to contain id instead of name,person_id not found,reports with join on person_id not working

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

Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2014-01-21 13:05:18 UTC (rev 6589)
+++ trunk/LedgerSMB/AA.pm	2014-01-21 13:38:36 UTC (rev 6590)
@@ -350,12 +350,15 @@
         # are using the current username as the "person" inserting the new 
         # AR/AP Transaction.
         # ~A
+
+    #tshvr4 trunk svn-revison 6589,$form->login seems to contain id instead of name,person_id not found,reports with join on person_id not working
     $query = qq|
 			INSERT INTO $table (invnumber, person_id, 
 				entity_credit_account)
 			     VALUES (?,    (select  u.entity_id from users u
                  join entity e on(e.id = u.entity_id)
-                 where u.username=? and u.entity_id in(select p.entity_id from person p) ), ?)|;
+                 where u.id=? and u.entity_id in(select p.entity_id from person p) ), ?)|;
+                 #where u.username=? and u.entity_id in(select p.entity_id from person p) ), ?)|;
 
         # the second param is undef, as the DBI api expects a hashref of
         # attributes to pass to $dbh->prepare. This is not used here.

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits