Searching Models Based On A Particular Criteria

Yii 1.1 General Discussion
1

I have the following in my model




	public function search()

	{

		// Warning: Please modify the following code to remove attributes that

		// should not be searched.


		$criteria=new CDbCriteria;


		$criteria->compare('id',$this->id);

[b]		$criteria->compare('year',2013);[/b]

		$criteria->compare('surname',$this->surname,true);

		$criteria->compare('name',$this->name,true);

	

		return new CActiveDataProvider(get_class($this), array(

			'criteria'=>$criteria,

			'pagination'=>array('pageSize'=>100),

			

			

		));

	}

I changed this line

$criteria->compare(‘year’,$this->year);

to

$criteria->compare(‘year’,2013);

in order to parse for this current year only… now, I would like to be able to call this data set for other years…

what would be the proper way to set up my model in order for that to happen?

it works as is but I can only access 2013 data this way

thanks

2

Hi

Have you store a


date (11-07-2013)

or only


Year(2013)

in your DB?

3

You need to go back to your previous solution and if You like change $this->year you just need to set it in the controller.

4

I think you should stuck with suggestion provided by mirunho

5

just stored as an integer for the four digit year,i.e 2013

6

Hi,

you can write a query on search function


if (isset($this->year) && !empty($this->year)) {

//write a between query here....


		}

hope it may be helpful…

7

Hey Pabs,

There is nothing wrong here.What you have to do is set this value dynamically from your controller action and keep that line as it is.Like this is model search method




$criteria->compare('year',$this->year);

So, the only thing you need to do in controller action is.




$model = new YOURMODEL('search');

$model->year = "2011"; //Or you can set it dynamically.

So, when you will access




$model->search();

Then it will return records from 2011 years.

i hope it gives you a clear picture.

8

And if you what to find out the results between two years. Then you have to write a between condition.




$criteria->addBetweenCondition('year','2011', '2012');
9

thanks guys

I ended up doing as you suggested

kept my model with this


		$criteria->compare('year',$this->year);  //this is hack!  must be a clea way of  doing this

set the year var in my controller




	public function actionIndex()

	{

		$model->year = date("Y");

	

		$dataProvider=new CActiveDataProvider('register', array(

		'pagination' => array(

            'pageSize' => 100,

        ),

		));

		$this->render('index',array(

			'dataProvider'=>$dataProvider,

			'model'=>$model,

		));

	}

works as it should…still getting used to this concept of controller/model :)

10

thats great ;)