Hello Softark,
Please find below the details regarding my query. Hope this will be useful
Table strucutre :
leads : id(PK),leadname,assignedto(FK->users) has model name "Leads";
users : user_id(PK), firstname, lastname has model name "Users";
clients : id(PK),lead_id(FK->leads),firstname,lastname,phone_number (multiple entries for leads) has model name "ClientContacts";
My Relation in model Leads :
public function relations()
{
return array(
'assignedRel'=>array(self::BELONGS_TO,'Users','assigned_to','joinType'=>'LEFT JOIN','select'=>'assignedRel.lastname,assignedRel.firstname'),
'contactRel'=>array(self::HAS_ONE,'ClientContacts','lead_id','joinType'=>'LEFT JOIN','select'=>'contactRel.firstname,contactRel.phone_number,contactRel.lastname'),
);
}
/Function for retriving data DataProvider/
public function search()
{
$criteria = new CDbCriteria;
$criteria->together = true;
$criteria->with = array("contactRel","assignedRel");
return new CActiveDataProvider($this, array(
'criteria' => $criteria,
'pagination'=>array('pageSize'=>50)
));
}