public function actionDashboard() { if (Yii::app()->user->agreeToTerms == 0) { $this->redirect(Yii::app()->createUrl('company/terms')); } $criteria = new CDbCriteria(); //$criteria->condition = 'Candidate.CompanyID = :CompanyID'; $criteria->params = array(':CompanyID' => Yii::app()->user->companyID); $candidatesModels = Candidate::model()->findAllByAttributes(array(), $criteria); $candidates = array(); foreach (array_keys($candidatesModels) as $key) { $candidate = $candidatesModels[$key]; $candidates[$key] = new stdClass(); $candidates[$key]->ID = $candidate->CandidateID; $candidates[$key]->Name = sprintf('%s, %s', $candidate->LastName, $candidate->FirstName); $candidates[$key]->Email = $candidate->Email; $candidates[$key]->UserProfileID = $candidate->UserProfileID; $UserProfile = userProfile::model()->findbypk($candidate->UserProfileID); if (!isset($UserProfile)) { $candidates[$key]->RatingManager = "Rating Manager"; } else { $candidates[$key]->RatingManager = $UserProfile->FirstName . " " . $UserProfile->LastName; } $candidates[$key]->Title = $candidate->Title; $candidates[$key]->HireDate = $candidate->HireDate; $candidates[$key]->EmployeeID = $candidate->EmployeeID; } $this->render('dashboard', array('candidates' => $candidates)); }