public function actionExportSelect($segment = false) { if (Yii::app()->user->agreeToTerms == 0) { $this->redirect(Yii::app()->createUrl('company/terms')); } $displayYear = date('Y'); $userProfileModel = new UserProfile(); $candidateModel = new Candidate(); $companyModel = new Company(); $managersArray = array(); $CandidateTotalArray = array(); $criteria = new CDbCriteria(); $criteria2 = new CDbCriteria(); $criteria3 = new CDbCriteria(); $criteria4 = new CDbCriteria(); $criteria->with = array('performances', 'ratings', 'plannings'); $selectmanagers = ""; if (Yii::app()->user->isFacilitator) { if (isset($_REQUEST['userselect'])) { $selectmanagers = $_REQUEST['userselected']; $session['selectmanagers'] = $selectmanagers; $criteria5 = new CDbCriteria(); //$criteria5->condition = 'UserProfileID = :UserProfileID'; $criteria5->addInCondition('UserProfileID', $selectmanagers); $level1 = $candidateModel->findAllByAttributes(array(), $criteria5); $CandidateTotalArray[] = $level1; $userlist = array(); $criteria->addInCondition("UserProfileID", $selectmanagers); $matrix = $candidateModel->findAllByAttributes(array(), $criteria); } else { $criteria->condition = 'RatingYear = :RatingYear AND CompanyID = :CompanyID AND IsActive = :IsActive'; $criteria->params = array(':RatingYear' => $displayYear, ':CompanyID' => Yii::app()->user->companyID, ':IsActive' => 1); $matrix = $candidateModel->findAllByAttributes(array(), $criteria); } $criteria3->condition = 'companyID = :companyID'; $criteria3->params = array(':companyID' => Yii::app()->user->companyID); $criteria3->order = 'Email'; // $userManagers = UserProfile::model()->findAllByAttributes(array('order' => 'Email'),$criteria3); $managersArray[0] = Yii::app()->user->companyName; $userManagers = UserProfile::model()->findAllByAttributes(array(), $criteria3); foreach ($userManagers as $UserManager) { $managersArray[$UserManager->UserProfileID] = $UserManager->Email; } $facil_matrix = true; } else { $facil_matrix = false; $criteria->condition = 'RatingYear = :RatingYear AND IsActive = :IsActive AND UserProfileID = :UserProfileID'; $criteria->params = array(':RatingYear' => $displayYear, ':IsActive' => 1, ':UserProfileID' => Yii::app()->user->userProfileID); $matrix = $candidateModel->findAllByAttributes(array(), $criteria); } $managerArray = $managersArray; //$criteria->condition = 'RatingYear = :RatingYear AND IsActive = :IsActive AND CompanyID = :CompanyID'; //$criteria->params = array(':RatingYear' => $displayYear, ':CompanyID' => Yii::app()->user->companyID, ':IsActive' => 1); //$matrix = $candidateModel->findAllByAttributes(array(), $criteria); $criteria2->with = array('companyPerformances', 'companyPotentials'); $companyPerformance = $companyModel->findByPk(Yii::app()->user->companyID, $criteria2); //$this->renderFile(Yii::app()->basePath.'/exportcandidate', array('companyPerformance' => $companyPerformance, 'matrix' => $matrix, 'segment' => $segment, 'managerArray' => $managerArray, 'selectmanagers' => $selectmanagers, 'facil_matrix' => $facil_matrix)); // Original PHP code by Chirp Internet: www.chirp.com.au // Please acknowledge use of this code by including this header. require_once dirname(__FILE__) . '/Classes/PHPExcel.php'; die(''); }