[ASK]Database Relational

I have 2 model now,

tbl_reim (Reim Model)

1.id_reim

2.id_emp

3.Status

blablabla

tbl_emp

1.id_emp

2.name




class Reim extends CActiveRecord

{

public function relations()

	{

		 

		return array(

			'idEmp' => array(self::BELONGS_TO, 'Emp', 'id_emp'),

			  

	 

		);

	}

}






class Emp extends CActiveRecord

{

public function relations()

	{

		 

		return array(

			 

			 

			'reims' => array(self::HAS_MANY, 'Reim', 'id_emp'),

			'numReims' => array(self::STAT, 'Reim', 'id_emp'),//it give me total reim for every id_emp

			'numReimsPend' => ///////<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/huh.gif' class='bbc_emoticon' alt='???' />???////

		);

	}

}



numReims Give me TOTAL DATA from tbl_reim.

how should i write in "numReimPend"? i want like numReim but i want where status = 0.

Hi Dear,

Please read-- Here you can manage this using relation condition.

http://www.yiiframework.com/doc/guide/1.1/en/database.arr

http://www.yiiframework.com/forum/index.php/topic/10185-using-relations-and-conditions/

Thanks