public static function getCompanyReadiness($companyID)
{
$companyReadinessModel = new CompanyReadiness();
$criteria = new CDbCriteria();
$criteria->condition = 'CompanyID = :CompanyID';
$criteria->params = array(':CompanyID' => $companyID);
$companyReadiness = $companyReadinessModel->findAllByAttributes(array(), $criteria);
foreach ($companyReadiness as $companyReady) {
$companyReadinessSelect[$companyReady['Order']] = $companyReady['ReadinessDescription'];
//$companyPositionSelect[] = $companyPosition['Description'];
}
return $companyReadinessSelect;
}
{
$candidate_potential[$i]='2.92';
}
if (array_search($candidate_potential[$i], $candidate_potential)){
$candidate_potential[$i]=$candidate_potential[$i]-'.2';
}
if (array_search($candidate_performance[$i], $candidate_performance)){
$candidate_potential[$i]=$candidate_potential[$i]-'.2';
}
$readiness = CompanyReadiness::model()->findByAttributes(array('ReadinessID' => $matrix->plannings[0]->Readiness));
if ($readiness)
{
$readiness=$readiness->ReadinessDescription;
$ReadinessDescription= $readiness;
}
else
{
$readiness="";
$ReadinessDescription="";
}
$CurrentPositionlevel = CompanyPosition::model()->findByAttributes(array('CompanyPositionID' => $matrix->plannings[0]->CurrentPositionLevel));
if ($CurrentPositionlevel)
{
public function actionreportProduction($segment = false)
{
if (Yii::app()->user->agreeToTerms == 0) {
$this->redirect(Yii::app()->createUrl('company/terms'));
}
$displayYear = $_REQUEST['Year'];
$reporttype = $_REQUEST['reporttype'];
$userProfileModel = new UserProfile();
$candidateModel = new Candidate();
$companyModel = new Company();
$managersArray = array();
$CandidateTotalArray = array();
$fundamentalsModel = new CompanyFundamentals();
$competenciesModel = new CompanyCompetencies();
$learningagilityModel = new CompanyLearningAgility();
$criteria3 = new CDbCriteria();
$criteria3->condition = 'CompanyID = :CompanyID';
$criteria3->params = array(':CompanyID' => Yii::app()->user->companyID);
$fundamentals = $fundamentalsModel->findAllByAttributes(array(), $criteria3);
$competencies = $competenciesModel->findAllByAttributes(array(), $criteria3);
$learningagility = $learningagilityModel->findAllByAttributes(array(), $criteria3);
$exportarray = array();
$excelexport = 0;
$i = 0;
function array_to_csv_download($array, $filename = "export.csv", $delimiter = ",")
{
// open raw memory as file so no temp files needed, you might run out of memory though
$f = fopen('php://memory', 'w');
// loop over the input array
fputcsv($f, array('Candidate', 'Candidate Business Unit', 'Current Job Title', 'Time in Position', 'Readiness', 'Composite Rating'));
//Candidate Business Unit Current Job Title Time in Position Readiness Composite Rating
foreach ($array as $line) {
// generate csv lines from the inner arrays
fputcsv($f, $line, $delimiter);
}
// reset the file pointer to the start of the file
fseek($f, 0);
// tell the browser it's going to be a csv file
header('Content-Type: application/csv');
// tell the browser we want to save it instead of displaying it
header('Content-Disposition: attachment; filename="' . $filename . '";');
// make php send the generated csv lines to the browser
fpassthru($f);
}
$criteria = new CDbCriteria();
$criteria2 = new CDbCriteria();
$criteria3 = new CDbCriteria();
$criteria4 = new CDbCriteria();
$criteria->with = array('performances', 'ratings', 'plannings');
if (!isset($_REQUEST['userselected'])) {
$this->redirect(array('user/reportgenerate'));
}
if (isset($_REQUEST['matrixselect'])) {
$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->condition = 'RatingYear = :RatingYear AND PerformanceYear = :RatingYear AND PlanningYear = :RatingYear AND CompanyID = :CompanyID AND IsActive = :IsActive';
$criteria->params = array(':RatingYear' => $displayYear, ':CompanyID' => Yii::app()->user->companyID, ':IsActive' => 1);
$criteria->addInCondition("UserProfileID", $selectmanagers);
$matrix = $candidateModel->findAllByAttributes(array(), $criteria);
} else {
$criteria->condition = 'RatingYear = :RatingYear AND PerformanceYear = :RatingYear AND PerformanceYear = :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;
}
$managerArray = $managersArray;
$criteria2->with = array('companyPerformances', 'companyPotentials');
$companyPerformance = $companyModel->findByPk(Yii::app()->user->companyID, $criteria2);
//$this->render('matrix', array('companyPerformance' => $companyPerformance, 'matrix' => $matrix, 'segment' => $segment, 'managerArray' => $managerArray, 'selectmanagers' => $selectmanagers, 'facil_matrix' => $facil_matrix, 'filter' => $filter));
$candidate_performance = array();
$performance_weight = array();
$potential_weight = array();
$a = 0;
foreach ($companyPerformance->companyPerformances as $performance) {
// echo '<p>'.$performance->Category.': '.$performance->Weighting.'</p>';
$performance_weight[$a] = $performance->Weighting;
$a++;
}
$performance1_weight = $performance_weight[0] / 100;
//Contribution
$performance2_weight = $performance_weight[1] / 100;
//Conduct
$performance3_weight = $performance_weight[2] / 100;
//Effort
$a = 0;
$lastsection = 0;
foreach ($companyPerformance->companyPotentials as $potential) {
if ($lastsection != $potential->Section) {
//echo '<p>'.$potential->Section.': ' . $potential->Category.': '.$potential->SectionWeighting.'</p>';
$potential_weight[$a] = $potential->SectionWeighting;
$a++;
}
$lastsection = $potential->Section;
}
$potential1_weight = $potential_weight[0] / 100;
$potential2_weight = $potential_weight[1] / 100;
$potential3_weight = $potential_weight[2] / 100;
$i = 0;
$datapoints = "";
$tips = "";
//Per Candidate
$loopCount = 1;
$mmContent = "";
$content = "";
$lastUserProfileID = "";
$contentheader = '
<style type="text/css">
<!--
table { vertical-align: top; }
tr { vertical-align: top; }
td { vertical-align: top; }
.candidate {
padding:5px; width:96%;
font-size: 16px;
font-weight:bold;
}
.reportsectionheader {
background-color:#eeeeee;
padding:5px; width:100%;
border-bottom:1px solid black;
font-size: 14px;
font-weight:bold;
}
.reportheader {
background-color:#dddddd; padding:5px; width:12%;
border-bottom:1px solid black;
font-weight:bold;
}
.reportcontent {
width:20%; padding:5px;
border-bottom:1px solid black;
}
.footerheader {
font-size:11px;
font-weight: bold;
}
.footercontent {
font-size:14px
}
-->
</style>';
foreach ($matrix as $matrix) {
$display = true;
if ($display) {
$performance1 = $matrix->performances[0]->Contribution;
//Contribution
$performance2 = $matrix->performances[0]->Conduct;
//Conduct
$performance3 = $matrix->performances[0]->Effort;
//Effort
$performance1 = $performance1 * $performance1_weight;
$performance2 = $performance2 * $performance2_weight;
$performance3 = $performance3 * $performance3_weight;
$candidate_potential = array();
$candidate_performance = array();
$datapoint = "";
$potential1 = $matrix->ratings[0]->GeneralCognitiveCapability;
$potential2 = $matrix->ratings[0]->EnergyAchievementOrientation;
$potential3 = $matrix->ratings[0]->CulturalFit;
$potential4 = $matrix->ratings[0]->Execution;
$potential5 = $matrix->ratings[0]->Judgement;
$potential6 = $matrix->ratings[0]->Relationships;
$potential7 = $matrix->ratings[0]->Influences;
$potential8 = $matrix->ratings[0]->Inspiration;
$potential9 = $matrix->ratings[0]->Innovation;
$potential10 = $matrix->ratings[0]->Learning;
$potential11 = $matrix->ratings[0]->Ingenuity;
$potential12 = $matrix->ratings[0]->PeopleSmart;
$potential13 = $matrix->ratings[0]->ChangeLeader;
$potential14 = $matrix->ratings[0]->ComposedUnderPressure;
$potential15 = $matrix->ratings[0]->PersonalInsight;
$potential16 = $matrix->ratings[0]->AdaptsEasily;
if ($potential1 < 2 || $potential2 < 2 || $potential3 < 2) {
$potential1 = 0;
$potential2 = 0;
$potential3 = 0;
}
$potential_section1 = ($potential1 + $potential2 + $potential3) / 3 * $potential1_weight;
$potential_section2 = ($potential4 + $potential5 + $potential6 + $potential7 + $potential8 + $potential9 + $potential10) / 7 * $potential2_weight;
$potential_section3 = ($potential11 + $potential12 + $potential13 + $potential14 + $potential15 + $potential16) / 6 * $potential3_weight;
$candidate_potential[$i] = round($potential_section1 + $potential_section2 + $potential_section3, 1);
$candidate_performance[$i] = round($performance1 + $performance2 + $performance3, 1);
if ($candidate_performance[$i] > '2.92') {
$candidate_performance[$i] = '2.92';
}
if ($candidate_potential[$i] == '3') {
$candidate_potential[$i] = '2.98';
}
if ($candidate_performance[$i] == '2.92' && $candidate_potential[$i] > '2.96') {
$candidate_potential[$i] = '2.92';
}
if (array_search($candidate_potential[$i], $candidate_potential)) {
$candidate_potential[$i] = $candidate_potential[$i] - '.2';
}
if (array_search($candidate_performance[$i], $candidate_performance)) {
$candidate_potential[$i] = $candidate_potential[$i] - '.2';
}
$readiness = CompanyReadiness::model()->findByAttributes(array('ReadinessID' => $matrix->plannings[0]->Readiness));
if ($readiness) {
$readiness = $readiness->ReadinessDescription;
$ReadinessDescription = $readiness;
} else {
$readiness = "";
$ReadinessDescription = "";
}
$CurrentPositionlevel = CompanyPosition::model()->findByAttributes(array('CompanyPositionID' => $matrix->plannings[0]->CurrentPositionLevel));
if ($CurrentPositionlevel) {
$CurrentPosition = $CurrentPositionlevel->Description;
} else {
$CurrentPosition = "";
}
$NextStepPositionLevel = CompanyPosition::model()->findByAttributes(array('CompanyPositionID' => $matrix->plannings[0]->NextStepPositionLevel));
if ($NextStepPositionLevel) {
$NextPosition = $NextStepPositionLevel->Description;
} else {
$NextPosition = "";
}
$FutureStepPositionLevel = CompanyPosition::model()->findByAttributes(array('CompanyPositionID' => $matrix->plannings[0]->LongTermPositionLevel));
if ($FutureStepPositionLevel) {
$FuturePosition = $FutureStepPositionLevel->Description;
} else {
$FuturePosition = "";
}
$Competency[] = array('label' => $competencies[0]->Name, 'amount' => $matrix->ratings[0]->Execution);
$Competency[] = array('label' => $competencies[1]->Name, 'amount' => $matrix->ratings[0]->Judgement);
$Competency[] = array('label' => $competencies[2]->Name, 'amount' => $matrix->ratings[0]->Relationships);
$Competency[] = array('label' => $competencies[3]->Name, 'amount' => $matrix->ratings[0]->Influences);
$Competency[] = array('label' => $competencies[4]->Name, 'amount' => $matrix->ratings[0]->Inspiration);
$Competency[] = array('label' => $competencies[5]->Name, 'amount' => $matrix->ratings[0]->Innovation);
$Competency[] = array('label' => $competencies[6]->Name, 'amount' => $matrix->ratings[0]->Learning);
foreach ($Competency as $key => $row) {
$label[$key] = $row['label'];
$amount[$key] = $row['amount'];
}
array_multisort($amount, SORT_ASC, $label, SORT_DESC, $Competency);
$LearningAgility[] = array('lalabel' => $learningagility[0]->Name, 'laamount' => $matrix->ratings[0]->Ingenuity);
$LearningAgility[] = array('lalabel' => $learningagility[1]->Name, 'laamount' => $matrix->ratings[0]->PeopleSmart);
$LearningAgility[] = array('lalabel' => $learningagility[2]->Name, 'laamount' => $matrix->ratings[0]->ChangeLeader);
$LearningAgility[] = array('lalabel' => $learningagility[3]->Name, 'laamount' => $matrix->ratings[0]->ComposedUnderPressure);
$LearningAgility[] = array('lalabel' => $learningagility[4]->Name, 'laamount' => $matrix->ratings[0]->PersonalInsight);
$LearningAgility[] = array('lalabel' => $learningagility[5]->Name, 'laamount' => $matrix->ratings[0]->AdaptsEasily);
foreach ($LearningAgility as $key => $row) {
$lalabel[$key] = $row['lalabel'];
$laamount[$key] = $row['laamount'];
}
array_multisort($laamount, SORT_ASC, $lalabel, SORT_DESC, $LearningAgility);
if ($lastUserProfileID != $matrix->UserProfileID) {
$candidateManager = UserProfile::model()->findAllByPk($matrix->UserProfileID);
$candidateManagerEmail = $candidateManager[0]->Email;
$candidateManagerName = $candidateManager[0]->FirstName . " " . $candidateManager[0]->LastName;
}
$diff = time() - strtotime($matrix->PositionDate);
$years = floor($diff / (365 * 60 * 60 * 24));
$months = floor(($diff - $years * 365 * 60 * 60 * 24) / (30 * 60 * 60 * 24));
$days = floor(($diff - $years * 365 * 60 * 60 * 24 - $months * 30 * 60 * 60 * 24) / (60 * 60 * 24));
if ($reporttype == 'Export') {
//Candidate Business Unit Current Job Title Time in Position Readiness Composite Rating
$excelexport = 1;
$exportarray[$i] = array($matrix->FirstName . ' ' . $matrix->MiddleName, $matrix->BusinessUnit, $matrix->Title, $years . ' Year(s), ' . $months . ' months', $ReadinessDescription, $candidate_performance[$i] * $candidate_potential[$i]);
$i++;
} elseif ($reporttype == 'Planning') {
$content = $content . '
<page>
<table cellspacing="0" style="width: 96%;">
<tr>
<td style="width: 20%;">
<img src="http://inventivetalentreviews.com/themes/itr/assets/admin/layout3/img/itrlogo.png" style="width:240px">
</td>
<td style="width: 60%; text-align: left; font-weight: bold; font-size: 20pt;">
<span style="font-size: 10pt"><br></span>
<div style="margin-left:220px">Confidential</div>
</td>
<td style="width: 20%; text-align:right">
<br/><br/>
Date Prepared:<br/>
' . date("Y-m-d") . '
</td>
</tr>
</table>
<div class="candidate">' . $matrix->FirstName . ' ' . $matrix->MiddleName . ' ' . $matrix->LastName . '</div>
<table cellspacing="0" style="width: 100%;">
<tr >
<td class="reportheader">Employee ID</td>
<td class="reportcontent">' . $matrix->EmployeeID . '</td>
<td class="reportheader">Current Job Title</td>
<td class="reportcontent">' . $matrix->Title . '</td>
<td class="reportheader">Business Unit</td>
<td class="reportcontent">' . $matrix->BusinessUnit . '</td>
</tr>
</table>
<br/><br/>
<div class="candidate">Planning Year ' . $matrix->plannings[0]->PlanningYear . '</div>
<table cellspacing="0" style="width: 100%;">
<tr><td class="reportheader" style="width:300px">1<sup>st</sup> Competency Development Opportunity:</td>
<td class="reportcontent">' . $label[0] . '</td></tr>
<tr><td class="reportheader" style="width:300px">2<sup>nd</sup> Competency Development Opportunity:</td>
<td class="reportcontent">' . $label[1] . '</td></tr>
<tr><td class="reportheader" style="width:300px">3<sup>rd</sup> Competency Development Opportunity:</td>
<td class="reportcontent">' . $label[2] . '</td></tr>
<tr><td class="reportheader" style="width:300px">Learning Agility Development Opportunity:</td>
<td class="reportcontent">' . $lalabel[0] . '</td></tr>
<tr><td class="reportheader" style="width:300px">Suggestions for Enhancing Experience:</td>
<td class="reportcontent">' . $matrix->plannings[0]->MostImportantNeedForExperience . '</td></tr>
<tr><td class="reportheader" style="width:300px">Other Development Opportunities:</td>
<td class="reportcontent">' . $matrix->plannings[0]->OtherDevelopment . '</td></tr>
<tr><td class="reportheader" style="width:300px">Add Notes for Development Strategies:</td>
<td class="reportcontent">' . $matrix->plannings[0]->Notes . '</td></tr>
</table>
</page>';
} else {
$content = $content . '<page>
<table cellspacing="0" style="width: 96%;">
<tr>
<td style="width: 20%;">
<img src="http://inventivetalentreviews.com/themes/itr/assets/admin/layout3/img/itrlogo.png" style="width:240px">
</td>
<td style="width: 60%; text-align: left; font-weight: bold; font-size: 20pt;">
<span style="font-size: 10pt"><br></span>
<div style="margin-left:220px">Confidential</div>
</td>
<td style="width: 20%; text-align:right">
<br/><br/>
Date Prepared:<br/>
' . date("Y-m-d") . '
</td>
</tr>
</table>
<div class="candidate">' . $matrix->FirstName . ' ' . $matrix->MiddleName . ' ' . $matrix->LastName . '</div>
<table cellspacing="0" style="width: 100%; border:1px solid black">
<tr><td colspan=6 class="reportsectionheader">PROFILE</td></tr>
<tr >
<td class="reportheader">Employee ID</td>
<td class="reportcontent">' . $matrix->EmployeeID . '</td>
<td class="reportheader">Current Job Title</td>
<td class="reportcontent">' . $matrix->Title . '</td>
<td class="reportheader">Business Unit</td>
<td class="reportcontent">' . $matrix->BusinessUnit . '</td>
</tr>
<tr>
<td class="reportheader">Hire Date</td>
<td class="reportcontent">' . $matrix->HireDate . '</td>
<td class="reportheader">Start Date of Current Position</td>
<td class="reportcontent">' . $matrix->PositionDate . '</td>
<td class="reportheader">Time in Position</td>
<td class="reportcontent">' . $years . ' Year(s), ' . $months . ' months</td>
</tr>
<tr>
<td class="reportheader">Company Position Level</td>
<td class="reportcontent">' . $CurrentPosition . '</td>
<td class="reportheader">Career Path</td>
<td class="reportcontent">' . $matrix->CareerPath . '</td>
<td class="reportheader">Key Position</td>
<td class="reportcontent">' . $matrix->KeyPosition . '</td>
</tr>
<tr>
<td class="reportheader">Education</td>
<td class="reportcontent">' . $matrix->Education . '</td>
<td class="reportheader">Work Phone</td>
<td class="reportcontent">' . $matrix->WorkPhone . '</td>
<td class="reportheader">Candidate Email</td>
<td class="reportcontent">' . $matrix->Email . '</td>
</tr>
<tr>
<td class="reportheader">Direct Manager</td>
<td class="reportcontent">' . $candidateManagerEmail . '</td>
<td class="reportheader">Direct Manager Email</td>
<td class="reportcontent" colspan=3>' . $candidateManagerName . '</td>
</tr>
</table>
<br/>
<table cellspacing="0" style="width: 100%; border:1px solid black">
<tr><td colspan=6 class="reportsectionheader">PLANNING YEAR ' . $matrix->plannings[0]->PlanningYear . '</td></tr>
<tr >
<td class="reportheader">Next Step Position Level</td>
<td class="reportcontent">' . $NextPosition . '</td>
<td class="reportheader">Readiness for Next Step</td>
<td class="reportcontent">' . $ReadinessDescription . '</td>
<td class="reportheader">Long-Term Position Level</td>
<td class="reportcontent">' . $FuturePosition . '</td>
</tr>
<tr>
<td class="reportheader">Mobility</td>
<td class="reportcontent">' . $matrix->plannings[0]->Mobility . '</td>
<td class="reportheader">Engagement / Retention</td>
<td class="reportcontent">' . $matrix->plannings[0]->Engagement . '</td>
<td class="reportheader">Career Path</td>
<td class="reportcontent">' . $matrix->plannings[0]->CareerPath . '</td>
</tr>
<tr>
<td class="reportheader">1st Competency</td>
<td class="reportcontent">' . $label[0] . '</td>
<td class="reportheader">2nd Competency</td>
<td class="reportcontent">' . $label[1] . '</td>
<td class="reportheader">3rd Competency</td>
<td class="reportcontent">' . $label[2] . '</td>
</tr>
<tr>
<td class="reportheader">Learning Agility</td>
<td class="reportcontent">' . $lalabel[0] . '</td>
<td class="reportheader">Assessment and Coaching</td>
<td class="reportcontent" colspan=3>' . $matrix->plannings[0]->AssessmentAndCoaching . '</td>
</tr>
</table>
<span class="footerheader"><br/>Most Important Need for Experience:</span><br/>
<span class="footercontent">' . $matrix->plannings[0]->MostImportantNeedForExperience . '</span>
<span class="footerheader"><br/><br/>Other Development:</span><br/>
<span class="footercontent">' . $matrix->plannings[0]->OtherDevelopment . '</span>
<span class="footerheader"><br/><br/>Performance Notes:</span><br/>
<span class="footercontent">' . $matrix->performances[0]->Notes . '</span>
<span class="footerheader"><br/><br/>Potential Notes:</span><br/>
<span class="footercontent">' . $matrix->ratings[0]->Notes . '</span>
<span class="footerheader"><br/><br/>General Notes:</span><br/>
<span class="footercontent">' . $matrix->plannings[0]->Notes . '</span>
<table cellspacing="0" style="width: 98%;">
<tr>
<td style="width: 100%; text-align:right; font-size:8px">
Copyright © ' . date('Y') . ' by Inventive Talent Consulting
</td>
</tr>
</table>
</page>';
}
$loopCount++;
$lastUserProfileID = $matrix->UserProfileID;
}
}
//if EXCEL
if ($excelexport) {
array_to_csv_download($exportarray, Yii::app()->user->companyName . "_StackedCandidate_" . $displayYear . ".csv");
//Yii::app()->user->companyName . "_StackedCandidate_" . DATE('Y') . ".csv"
} else {
$html2pdf = Yii::app()->ePdf->HTML2PDF();
$html2pdf = new HTML2PDF('L', 'A4', 'en');
$html2pdf->WriteHTML($contentheader . $content);
// $html2pdf->Output($reporttype . date('Y') . ".pdf" );
//$html2pdf->Output($reporttype . date('Y') . ".pdf" , 'D');
$html2pdf->Output(Yii::app()->user->companyName . "_" . $reporttype . "_" . $displayYear . ".pdf", 'D');
}
}
