<?php
 include_once("../../../cfg/conn.php"); 
 include ("../functions/users.php");
 //error_reporting(0);
if(isset($_POST['savePEF'])){
    $evaluatorID = $_POST['userID'];
    $approverCount = $_POST['pefApproverCount'];    
    $pefEntryCount = $_POST['pefApproverEntry']; 
    $compID = 0;
    $dealID = 0;
    $msgSave = "";
    $startRow=0;
    $rateeImprovement = $_POST['rateeImprovement'];
    $rateeStrength = $_POST['rateeStrength'];

    $wpPartOne = $_POST['wpPartOne'];
    $wpPartOnePercentile = $_POST['wpPartOnePercentile'];
    $wpPartOneAdjectival = $_POST['wpPartOneAdjectival'];
    $wpPartOneWP = $_POST['wpPartOneWP'];
    
    $partTwoNR = $_POST['partTwoNR'];
    $perCentilePTwo = $_POST['perCentilePTwo'];
    $adjPTow = $_POST['adjPTow'];
    $wpPartTwo = $_POST['wpPartTwo'];
    $wpPartOneTwoWP = $_POST['wpPartOneTwoWP'];
    $wpPartTwoAdj = $_POST['wpPartTwoAdj'];
    $facA = $_POST['facA'];
    $facB = $_POST['facB'];
    $facC = $_POST['facC'];
    $facD = $_POST['facD'];
    $facE = $_POST['facE'];
    $facF = $_POST['facF'];
    $facG = $_POST['facG'];
    $facH = $_POST['facH'];
    $facI = $_POST['facI'];
    $facJ = $_POST['facJ'];
    $facK = $_POST['facK'];
    
    $nCodeA = $_POST['nCodeA'];
    $nCodeB = $_POST['nCodeB'];
    $nCodeC = $_POST['nCodeC'];
    $nCodeD = $_POST['nCodeD'];
    $nCodeE = $_POST['nCodeE'];
    $nCodeF = $_POST['nCodeF'];
    $nCodeG = $_POST['nCodeG'];
    $nCodeH = $_POST['nCodeH'];
    $nCodeI = $_POST['nCodeI'];
    $nCodeJ = $_POST['nCodeJ'];
    $nCodeK = $_POST['nCodeK'];
    
    $wCodeA = $_POST['wCodeA'];
    $wCodeB = $_POST['wCodeB'];
    $wCodeC = $_POST['wCodeC'];
    $wCodeD = $_POST['wCodeD'];
    $wCodeE = $_POST['wCodeE'];
    $wCodeF = $_POST['wCodeF'];
    $wCodeG = $_POST['wCodeG'];
    $wCodeH = $_POST['wCodeH'];
    $wCodeI = $_POST['wCodeI'];
    $wCodeJ = $_POST['wCodeJ'];
    $wCodeK = $_POST['wCodeK'];
   
    $ncNoteA = $_POST['ncNoteA'];
    $ncNoteB = $_POST['ncNoteB'];
    $ncNoteC = $_POST['ncNoteC'];
    $ncNoteD = $_POST['ncNoteD'];
    $ncNoteE = $_POST['ncNoteE'];
    $ncNoteF = $_POST['ncNoteF'];
    $ncNoteG = $_POST['ncNoteG'];
    $ncNoteH = $_POST['ncNoteH'];
    $ncNoteI = $_POST['ncNoteI'];
    $ncNoteJ = $_POST['ncNoteJ'];
    $ncNoteK = $_POST['ncNoteK'];
    
    $pcpID = $_POST['pcpID'];
    $userID = $_POST['userID']; // last approver
    $dateFinal = $myTimeStamp;
    
    $empRecordID = $_POST['empRecordID'];                  
    $SelectedEmployeeID = $_POST['SelectedEmployeeID'];
    $GetPCPYear = $_POST['GetPCPYear'];
    $GetPCPSemester = $_POST['GetPCPSemester'];   
   

    $rateeCompetencies = $_POST['rateeCompetencies'];
    $rateeCompetenciesNotes = $_POST['rateeCompetenciesNotes'];
    $rateeSuitability = $_POST['rateeSuitability'];
    $rateeSuitabilityNotes = $_POST['rateeSuitabilityNotes'];
    $rateePotential = $_POST['rateePotential'];
    $rateePotentialNotes = $_POST['rateePotentialNotes'];
    
    $compID = 1;//getEmployeeEmpInformationB($empRecordID)[6];
    $dealID = 1;//getEmployeeEmpInformationB($empRecordID)[4];
    // UPDATE PCPC

    $pcpUp = "UPDATE `pcp_headers` SET `pef_status`=2 WHERE `id`='$pcpID' ";
    $qUp = mysqli_query($conn,$pcpUp);
    if ($conn->query($qUp) === TRUE) {
         
    } 
    //save Performance Factor data
    $getFac = "SELECT * FROM `performance_factors` WHERE deleted = 0 ORDER BY `factors_order` ASC";
    $qFac = mysqli_query($conn,$getFac);
    while($row=mysqli_fetch_array($qFac)){
        $factorID = $row['id'];
        $factorCode = $row['code_name'];
        
            switch($factorCode){
                case 'facA':
                    $fac = $facA;
                    $nCode = $nCodeA; 
                    $wCode = $wCodeA;
                    $ncNote  = $ncNoteA;
                    break;
                case 'facB':
                    $fac = $facB;
                    $nCode = $nCodeB; 
                    $wCode = $wCodeB;
                    $ncNote  = $ncNoteB;
                    break;
                case 'facC':
                    $fac = $facC;
                    $nCode = $nCodeC; 
                    $wCode = $wCodeC;
                    $ncNote  = $ncNoteC;
                    break;
                case 'facD':
                    $fac = $facD;
                    $nCode = $nCodeD; 
                    $wCode = $wCodeD;
                    $ncNote  = $ncNoteD;
                    break;
                case 'facE':
                    $fac = $facE;
                    $nCode = $nCodeE; 
                    $wCode = $wCodeE;
                    $ncNote  = $ncNoteE;
                    break;
                case 'facF':
                    $fac = $facF;
                    $nCode = $nCodeF; 
                    $wCode = $wCodeF;
                    $ncNote  = $ncNoteF;
                    break;
                case 'facG':
                    $fac = $facG;
                    $nCode = $nCodeG; 
                    $wCode = $wCodeG;
                    $ncNote  = $ncNoteG;
                    break;
                case 'facH':
                    $fac = $facH;
                    $nCode = $nCodeH; 
                    $wCode = $wCodeH;
                    $ncNote  = $ncNoteH;
                    break;
                case 'facI':
                    $fac = $facI;
                    $nCode = $nCodeI; 
                    $wCode = $wCodeI;
                    $ncNote  = $ncNoteI;
                    break;
                case 'facJ':
                    $fac = $facJ;
                    $nCode = $nCodeJ; 
                    $wCode = $wCodeJ;
                    $ncNote  = $ncNoteJ;
                    break;
                case 'facK':
                    $fac = $facK;
                    $nCode = $nCodeK; 
                    $wCode = $wCodeK;
                    $ncNote  = $ncNoteK;
                    break;
            }       
            $sqlF = "INSERT INTO pef_evaluation_behavioral(`id`,
                `pcp_id`,
                `emp_record_id`,
                `factor_id`,
                `assigned_weight`,
                `assigned_score`,
                `assigned_wp`,
                `notes`,
                `factor_code_name`,
                `rater_id`,
                `emp_strength`,
                `emp_improvement`,
                `emp_competency_id`,
                `emp_competency_notes`,
                `emp_suitability_id`,
                `emp_suitability_notes`,
                `emp_potenial_id`,
                `emp_potenial_notes`,
                `evaluator_id`)
                VALUES('',
                '$pcpID',  
                '$empRecordID',   
                '$factorID',
                '$wCode',
                '$fac',
                '$nCode',
                '$ncNote',
                '$factorCode',
                '$userID',
                '$rateeStrength',
                '$rateeImprovement',
                '$rateeCompetencies',
                '$rateeCompetenciesNotes',
                '$rateeSuitability',
                '$rateeSuitabilityNotes',
                '$rateePotential',
                '$rateePotentialNotes',
                '$evaluatorID')";
            if ($conn->query($sqlF) === TRUE) {
                $msgSave =  "PEF Part I, II & III data has been saved successfully";
            } 
    }

    //insert new data
    $sql = "INSERT INTO  pef_evaluation_data (
        `id`,
        `pcp_id`,
        `emp_record_id`,
        `pef_year`,
        `pef_semester`,
        `evaluated_by`,
        `comp_id`,
        `dealer_id`,        
        `part_one_nr`,
        `part_one_percent`,
        `part_one_adj`,
        `part_one_wp`,
        `part_two_nr`,
        `part_two_percent`,
        `part_two_adj`,
        `part_two_wp`,
        `per_overall_wp`,
        `per_overall_adj`,
        `part_three_strength`,
        `part_three_improvement`,
        `part_three_competency`,
        `part_three_competency_notes`,
        `part_three_suitability`,
        `part_three_suitability_notes`,
        `part_three_potential`,
        `part_three_potential_notes`,
        `rated_date`)
        VALUES ('',
        '$pcpID',  
        '$empRecordID',               
        '$GetPCPYear',
        '$GetPCPSemester',               
        '$userID',
        '$compID',                
        '$dealID',                 
        '$wpPartOne',
        '$wpPartOnePercentile', 
        '$wpPartOneAdjectival',
        '$wpPartOneWP',
        '$partTwoNR',
        '$perCentilePTwo',
        '$adjPTow',
        '$wpPartTwo',
        '$wpPartOneTwoWP',
        '$wpPartTwoAdj',
        '$rateeStrength',
        '$rateeImprovement',
        '$rateeCompetencies',
        '$rateeCompetenciesNotes',
        '$rateeSuitability',
        '$rateeSuitabilityNotes',
        '$rateePotential',
        '$rateePotentialNotes',
        '$dateFinal')";        
        if ($conn->query($sql) === TRUE) {
            $msgSave =  "PEF Part II data has been saved.";
        } 
    echo $startRow;//$msgSave;
    $conn->close();  
}