<?php
 include_once("../../../cfg/conn.php"); 
 include ("../functions/users.php");
 //error_reporting(0);
if(isset($_POST['savePEF'])){     
    $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'];
    $pcpUp = "UPDATE `pcp_headers` SET `pef_status`=1 WHERE `id`='$pcpID' ";
    $qUp = mysqli_query($conn,$pcpUp);
    if ($conn->query($qUp) === TRUE) {
         
    } 
    //delete record if exist
   $csql = "SELECT * FROM `pef_evaluation_data` WHERE `pcp_id`='$pcpID' AND `emp_record_id`='$empRecordID'";
    $qCsql = mysqli_query($conn, $csql);
    while($srow = mysqli_fetch_array($qCsql)){
        $startRow = $startRow + 1;
    } 

    if($startRow > 0){
        $sqlUpdate = "UPDATE `pef_evaluation_data` SET `deleted`=1 WHERE `pcp_id`='$pcpID' AND `emp_record_id`='$empRecordID'";
        $qUpdate = mysqli_query($conn, $sqlUpdate);
        if ($conn->query($qUpdate) === 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',
                '$userID')";
            if ($conn->query($sqlF) === TRUE) {
                $msgSave =  "PEF Part I, II & III data has been saved successfully";
            } 
    }
    echo $startRow;//$msgSave;
    $conn->close();  
}