How to do use nested condition in AndWhere in yii2

Question

Before marking as duplicate question,kindly read it. I have different problem here. I want to generate this kind of Query using yii2 search model.

select * from t1 innerjoin t2 on (t1.id = t2.id) where ((t1.price >= '1000' and t1.price <= '5000') OR 
                   ( t2.price >= '1000' and t2.price <= '5000' ))

Joining is not a problem here. The main problem is the where clause. I tried this but not working.

$query->andFilterWhere([
                     'and',
                     ['>=', 't1.price', $this>start_price],
                     ['<=', 't1.price', $this->end_price]
                 ])
      ->orFilterWhere([
                      'and',
                       ['>=', 't2.price', $this->start_price],
                       ['<=', 't2.price', $this->end_price]
              ]);

score 18 · Accepted Answer · answered Jul 26 '16 at 10:21

18

Try

$query->andFilterWhere([
    'or',
    [
        'and',
        ['>=', 't1.price', $this>start_price],
        ['<=', 't1.price', $this->end_price]
    ],
    [
        'and',
        ['>=', 't2.price', $this->start_price],
        ['<=', 't2.price', $this->end_price]
    ]
]);

answered Jul 26 '16 at 10:21

Bizley

17,392
5
49
59

Thanks buddy.. :-) – uiTeam324 Jul 26 '16 at 10:43
Great, Worked For Me Tooo :) – Aman Deep Sep 07 '18 at 13:03
Thank you, your answer has also helped me. – Haku Kimura Jul 03 '20 at 08:12

How to do use nested condition in AndWhere in yii2

1 Answers1