[TYPO3-shop] Problem with sql.where in pricecalc TS - working fine in discountprice TS

[Ulrik H. Kold]

Hi group,

I have an observation to make:

When I use the sql.where clause in my TS for discountprice, I get the 
results I want: If I select products with uid = 2, the discount works 
only for this product.

BUT, when I use the same clause with pricecalc, it appears that the 
clause is ignored totally.

Is anybody else able to confirm this?

I have taken a look at the source files

lib/class.tx_ttproducts_discountprice.php and
lib/class.tx_ttproducts_pricecalc.php

and it appears the support for sql.where is only in discountprice class 
file.

Is this intended? It sure ain't documented...

I have removed the pricecalc block all together. Perhaps the pricecalc 
TS is about to be replaced by graduated prices?

My full discountprice TS setup looks like the snippet below:

plugin.tt_products {
   getDiscountPrice = 1
   discountprice >
   discountprice {
     ## product name
     2 {
         type = count
         field = price
         additive = 0
         sql.where = uid=2
         prod.1 = 280.00
         prod.2 = 200.00
         prod.3 = 160.00
         prod.5 = 120.00
         prod.10 = 100.00
     }

## ... repeat these blocks as necesssary
}


-- 

Ulrik H. Kold
Ørskov Web - http://www.oerskovweb.dk