[yadino]

Privet!
I have such code:

public function search($category='')
    {

$criteria->compare('luke',$this->luke);
        $criteria->compare('heatedSeats',$this->heatedSeats);
        $criteria->compare('akpp',$this->akpp);

        if(is_numeric($this->yearFrom)){
            $criteria2 = new CDbCriteria;
            $criteria2->condition='year>=:from';
            $criteria2->params=array(':from'=>$this->yearFrom);
            $criteria->mergeWith($criteria2);
        }

        if(is_numeric($this->yearTo)){
            $criteria2 = new CDbCriteria;
            $criteria2->condition='year<=:to';
            $criteria2->params=array(':to'=>$this->yearTo);
            $criteria->mergeWith($criteria2);
        }

        if(is_numeric($this->costFrom)){
            $criteria2 = new CDbCriteria;
            $criteria2->condition='cost>=:from';
            $criteria2->params=array(':from'=>$this->costFrom);
            $criteria->mergeWith($criteria2);
        }

        if(is_numeric($this->costTo)){
            $criteria2 = new CDbCriteria;
            $criteria2->condition='cost<=:to';
            $criteria2->params=array(':to'=>$this->costTo);
            $criteria->mergeWith($criteria2);
        }
        return new CActiveDataProvider($this, array(
            'criteria'=>$criteria,
            'pagination'=>array(
                'pageSize'=>30,
            ),
            'sort'=>array(
                'defaultOrder'=>'posttime DESC',
            )
        ));
    }
}

The problem is when I enter "yearFrom" and "yearTo" the search is done in the way I need, but when I add "cost to" and "costFrom", years are already paid no attention and there's no filtration by years. How can I fix it?

[wisp]

Maybe have a look in the logs so you know the query that is executed?

[yadino]

thx, i've already found and solved the problem!

[bennouna]

@yadino how please? I was curious when I saw your post. Maybe you forgot to declare costFrom and costTo in your model?

[yadino]

the problem was that for year and for the price was used :from , so i had :form switched from price to year.

Bad:

$criteria2->condition='year>=:from';
            $criteria2->params=array(':from'=>$this->yearFrom);

$criteria2->condition='cost>=:from';
            $criteria2->params=array(':from'=>$this->costFrom);

Solution:

$criteria2->condition='year>=:fromyear';
            $criteria2->params=array(':fromyear'=>$this->yearFrom);

$criteria2->condition='cost>=:fromcost';
            $criteria2->params=array(':fromcost'=>$this->costFrom);