SF.net SVN: ledger-smb: [283] trunk/LedgerSMB/PriceMatrix.pm

[..hidden..]

Revision: 283
          http://svn.sourceforge.net/ledger-smb/?rev=283&view=rev
Author:   einhverfr
Date:     2006-10-23 19:47:46 -0700 (Mon, 23 Oct 2006)

Log Message:
-----------
Fixed pricegroup query

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

Modified: trunk/LedgerSMB/PriceMatrix.pm
===================================================================
--- trunk/LedgerSMB/PriceMatrix.pm	2006-10-24 02:40:58 UTC (rev 282)
+++ trunk/LedgerSMB/PriceMatrix.pm	2006-10-24 02:47:46 UTC (rev 283)
@@ -57,7 +57,9 @@
 
 			UNION
 
-    			SELECT p.*, g.pricegroup
+    			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
+				p.pricebreak, p.sellprice, p.validfrom,
+				p.valid_to, p.curr, g.pricegroup
 			FROM partscustomer p
 			LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
 			WHERE p.parts_id = ?
@@ -65,7 +67,9 @@
 
 			UNION
 
-			SELECT p.*, g.pricegroup
+    			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
+				p.pricebreak, p.sellprice, p.validfrom,
+				p.valid_to, p.curr, g.pricegroup
 			FROM partscustomer p
 			LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
 			JOIN customer c ON (c.pricegroup_id = g.id)
@@ -74,7 +78,9 @@
 
 			UNION
 
-			SELECT p.*, '' AS pricegroup
+    			SELECT p.parts_id, p.customer_id, p.pricegroup_id, 
+				p.pricebreak, p.sellprice, p.validfrom,
+				p.valid_to, p.curr, g.pricegroup
 			FROM partscustomer p
 			WHERE p.customer_id = 0
 			AND p.pricegroup_id = 0


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