summaryrefslogtreecommitdiff
path: root/LedgerSMB
diff options
context:
space:
mode:
authortetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-28 18:01:47 +0000
committertetragon <tetragon@4979c152-3d1c-0410-bac9-87ea11338e46>2006-10-28 18:01:47 +0000
commit13b44be1961be124c44ecc6fccfc4d5b73ed516f (patch)
tree045fe7e988ea6b17b46bdee22d4aa3a6e2ef1de1 /LedgerSMB
parentf4fbdc21cd69328f49c54128fb29f16f9504b602 (diff)
Fix spelling of query column names
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@359 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'LedgerSMB')
-rw-r--r--LedgerSMB/PriceMatrix.pm7
1 files changed, 4 insertions, 3 deletions
diff --git a/LedgerSMB/PriceMatrix.pm b/LedgerSMB/PriceMatrix.pm
index a2de4baf..0a92562c 100644
--- a/LedgerSMB/PriceMatrix.pm
+++ b/LedgerSMB/PriceMatrix.pm
@@ -59,7 +59,7 @@ sub price_matrix_query {
SELECT p.parts_id, p.customer_id, p.pricegroup_id,
p.pricebreak, p.sellprice, p.validfrom,
- p.valid_to, p.curr, g.pricegroup
+ p.validto, p.curr, g.pricegroup
FROM partscustomer p
LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
WHERE p.parts_id = ?
@@ -69,7 +69,7 @@ sub price_matrix_query {
SELECT p.parts_id, p.customer_id, p.pricegroup_id,
p.pricebreak, p.sellprice, p.validfrom,
- p.valid_to, p.curr, g.pricegroup
+ p.validto, 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)
@@ -80,8 +80,9 @@ sub price_matrix_query {
SELECT p.parts_id, p.customer_id, p.pricegroup_id,
p.pricebreak, p.sellprice, p.validfrom,
- p.valid_to, p.curr, g.pricegroup
+ p.validto, p.curr, g.pricegroup
FROM partscustomer p
+ LEFT JOIN pricegroup g ON (g.id = p.pricegroup_id)
WHERE p.customer_id = 0
AND p.pricegroup_id = 0
AND p.parts_id = ?