Cakephp Search Plugin filterArgs (if else in array)

Question

I want to make an if else in filterArgs (in Model) as follow:

public $filterArgs = array(
            array('name' => 'to', 'type' => 'value' => 'Product.regular_price' ),
        );

I want the field to change base on the condition.

if sale = 1, field is promo_price, else field is regular_price

I already try below code (but unsuccessful):

'field'=> 'Product.sale' => 1 ? 'Product.promo_price >=' : 'Product.regular_price >='

Can someone please help me. Thanks alot in advance!

arilia · Accepted Answer · 2014-04-01 07:01:15Z

1

I would create a virtualField in my Product Model

$virtualFields = array 
(
    'my_price' => 'IF(Product.sale = 1, Product.promo_price, Product.regular_price)';
)

public $filterArgs = array
(
    'my_price' => array('type' => 'value'),
);

answered Apr 1, 2014 at 7:01

arilia

9,3982 gold badges24 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dancingAngel Over a year ago

Hi, can you explain 'from' => 'IF(Product.sale = 1, Product.promo_price, Product.regular_price)', so far, no error. but the result somehow wrong.

arilia Over a year ago

Instead of creating the IF in php I created it in mysql using virtualFields. I created a new column named my_price wich value is promo_price rather than regular_price based on sale column vale. Then I filter results by my_price value

Collectives™ on Stack Overflow

Cakephp Search Plugin filterArgs (if else in array)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related