/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = UserSpecialistProjects::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public static function getSpecialistProjectsByUserId($userId)
{
$criteria = new CDbCriteria();
$criteria->distinct = true;
$criteria->condition = 'user_id=:userId';
$criteria->params = array(':userId' => $userId);
$projects = UserSpecialistProjects::model()->findAll($criteria);
if ($projects) {
return $projects;
} else {
return false;
}
}