File manager

File manager - Edit - /home/autoph/public_html/pms_v1/pef/saveEmployeeApprovedPEFinal.php

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

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings