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('');
}
