Пример #1
0
 public static function getCompanyPositions($companyID)
 {
     $companyPositionModel = new CompanyPosition();
     $criteria = new CDbCriteria();
     $criteria->condition = 'CompanyID = :CompanyID';
     $criteria->params = array(':CompanyID' => $companyID);
     $companyPositions = $companyPositionModel->findAllByAttributes(array(), $criteria);
     foreach ($companyPositions as $companyPosition) {
         $companyPositionSelect[$companyPosition['Order']] = $companyPosition['Description'];
         //$companyPositionSelect[] = $companyPosition['Description'];
     }
     return $companyPositionSelect;
 }
Пример #2
0
      $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="";
  }

  if ($candidate_potential[$i] > $matrix_minimum_x-.05 && $candidate_potential[$i] < $matrix_maximum_x+.05 && $candidate_performance[$i] > $matrix_minimum_y-.05 && $candidate_performance[$i] < $matrix_maximum_y+.05){

    $initials = substr($matrix->FirstName, 0, 1) . substr($matrix->MiddleName, 0, 1) . substr($matrix->LastName, 0, 1);

    $datapoints .= '{ tip:dp'.$loopCount.', y: '.$candidate_performance[$i].', x: '. $candidate_potential[$i] .', indexLabel: "' . $initials . '", indexLabelFontColor: "white", indexLabelBackgroundColor: "#000000" },'."\r\n";
    $tips .='var dp'. $loopCount .'="<div class=\'matrix_popup\' class=\'hover\'><span style=\'font-weight:bold; font-size:14px; width:100%; display:block; padding:5px; margin-bottom:5px; background-color:#cccccc;\'>' . $matrix->FirstName . '<br>'. $matrix->LastName . '<!-- Display' . $display . '--></span>';
Пример #3
0
 public function actionEditCompanyPositions()
 {
     $companyPositionModel = new CompanyPosition();
     if (isset($_POST['CompanyPosition'])) {
         //echo '<pre>';
         //            print_r($_POST['CompanyPosition']);
         //            die();
         foreach ($_POST['CompanyPosition']['CompanyPositionID'] as $key => $companyPositionID) {
             //echo $_POST['CompanyPosition']['Description'][$key];
             //print_r($companyPositionID);
             $companyPosition = $companyPositionModel->findByPk($companyPositionID);
             $companyPosition->Description = $_POST['CompanyPosition']['Description'][$key];
             $companyPosition->update();
         }
         $this->redirect(Yii::app()->createUrl('admin/position', array('id' => Yii::app()->user->companyID)));
     }
     $criteria = new CDbCriteria();
     $criteria->condition = 'CompanyID = :CompanyID';
     $criteria->params = array(':CompanyID' => Yii::app()->user->companyID);
     $companyPositions = $companyPositionModel->findAllByAttributes(array(), $criteria);
     $this->render('edit-company-positions', array('companyPositions' => $companyPositions, 'companyPositionModel' => $companyPositionModel));
 }
Пример #4
0
    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');
        }
    }