0){
//echo "";
$updateMARD = "UPDATE `mar_emp_data` SET
`mar_actual` = '$marActual',
`my_score` ='$marScore',
`mar_variance_no` = '$myVarianceNo',
`mar_variance_desc` = '$marAddVarianceDesc',
`mar_numerical_rating` = '$myNumericalRating',
`mar_modified_by` = '$userID',
`mar_date_modified` = '$myTimeStamp'
WHERE `emp_rec_id` ='$SelectedEmployeeID'
AND `pcp_id`='$pcpHeaderID'
AND `mar_header_id`='$marHeaderID'
AND `kra_id`='$activeKRAIDByKPI'
AND `kpi_id`='$getActiveMARKPI'";
if ($conn->query($updateMARD) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
}else{
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$sql = "INSERT INTO mar_emp_data (
`id`,
`emp_rec_id`,
`emp_id`,
`pcp_id`,
`mar_header_id`,
`kra_id`,
`kpi_id`,
`mar_weight`,
`mar_target`,
`mar_actual`,
`my_score`,
`mar_variance_no`,
`mar_variance_desc`,
`mar_numerical_rating`,
`mar_year_data`,
`mar_month_data`,
`mar_semester_data`,
`mar_created_by`,
`mar_date_created`,
`position`,
`unit_id`,
`department_id`,
`division_id`,
`sub_group_id`,
`branch_id`,
`comp_id`)
VALUES (
'',
'$SelectedRecordID',
'$SelectedEmployeeID',
'$pcpHeaderID',
'$marHeaderID',
'$activeKRAIDByKPI',
'$getActiveMARKPI',
'$pcpKPIWeight',
'$myTarget',
'$marActual',
'$marScore',
'$myVarianceNo',
'$marAddVarianceDesc',
'$myNumericalRating',
'$GetMARYear',
'$getMARMonth',
'$GetMARSemester',
'$userID',
'$myTimeStamp',
'$positionID',
'$SectionID',
'$DepartmentID',
'$DivisionID',
'$GroupID',
'$BranchID',
'$CompanyID')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
}
}else{
$marStatus = $_POST['marStatus'];
$SelectedRecordID = $_POST['SelectedRecordID'];
$marHeaderID = $_POST['marHeaderID'];
$pcpHeaderID = $_POST['groupKRAid'];
$GetMARYear = $_POST['GetMARYear'];
$GetMARSemester = $_POST['GetMARSemester'];
$getMARMonth = $_POST['getMARMonth'];
$userID = $_POST['userID'];
}
//$marStatus="POSTED";
// check if mar is posted or not
if($marStatus === "POSTED"){
}else{
}
//Check if posted and not yet approved and confirmed
$chkConfirmButton = "SELECT * FROM `mar_emp_header` WHERE `id` ='$marHeaderID' AND `deleted`=0 AND `mar_posted`=0 AND `mar_approved`=0 AND `ratee_agreement`=0 LIMIT 1";
$isButConfirmed = mysqli_query($conn,$chkConfirmButton);
$conButtonYesNo = mysqli_num_rows($isButConfirmed);
if($conButtonYesNo > 0){
$employeePostButton = "block";
$approverChkBox = "DISABLED";
$approverTargetDate = "";
$approveSaveButton = "none";
$approverButton="hidden";
$confirmRadioButton="DISABLED";
$confirmTextArea="DISABLED";
$viewConfirmButton="none";
}
//Check if Approved or note
$chkConfirmButton = "SELECT * FROM `mar_emp_header` WHERE `id` ='$marHeaderID' AND `deleted`=0 AND `mar_posted`=1 AND `mar_approved`=0 AND `ratee_agreement`=0 LIMIT 1";
$isButConfirmed = mysqli_query($conn,$chkConfirmButton);
$conButtonYesNo = mysqli_num_rows($isButConfirmed);
if($conButtonYesNo > 0){
$employeePostButton = "none";
$approverChkBox = "";
$approverTargetDate = "contenteditable";
$approveSaveButton = "block";
$approverButton="visible";
$LockNotes="block";
$confirmRadioButton="DISABLED";
$confirmTextArea="DISABLED";
$viewConfirmButton="none";
$marTag="Posted: Routed for Head Approval";
}
//Check if confirmed or not
$chkConfirmButton = "SELECT * FROM `mar_emp_header` WHERE `id` ='$marHeaderID' AND `deleted`=0 AND `mar_posted`=1 AND `mar_approved`=1 AND `ratee_agreement`=0 LIMIT 1";
$isButConfirmed = mysqli_query($conn,$chkConfirmButton);
$conButtonYesNo = mysqli_num_rows($isButConfirmed);
if($conButtonYesNo > 0){
while($not = mysqli_fetch_array($isButConfirmed)){
$rateeNotes= $not['ratee_notes'];
$rateeValue = $not['ratee_actionValue'];
}
$employeePostButton = "none";
$approverChkBox = "DISABLED";
$approverTargetDate = "";
$approveSaveButton = "none";
$approverButton="hidden";
$LockNotes="block";
$confirmRadioButton="";
$confirmTextArea="";
$viewConfirmButton="Block";
$marTag="Approved: Routed for user confirmation";
}
//Check if confirmed or not
$chkConfirmButton = "SELECT * FROM `mar_emp_header` WHERE `id` ='$marHeaderID' AND `deleted`=0 AND `mar_posted`=1 AND `mar_approved`=1 AND `ratee_agreement`=1 LIMIT 1";
$isButConfirmed = mysqli_query($conn,$chkConfirmButton);
$conButtonYesNo = mysqli_num_rows($isButConfirmed);
if($conButtonYesNo > 0){
while($not = mysqli_fetch_array($isButConfirmed)){
$rateeNotes= $not['ratee_notes'];
$rateeValue = $not['ratee_actionValue'];
}
$employeePostButton = "none";
$approverChkBox = "DISABLED";
$approverTargetDate = "";
$approveSaveButton = "none";
$approverButton="hidden";
$LockNotes="block";
$confirmRadioButton="DISABLED";
$confirmTextArea="DISABLED";
$viewConfirmButton="none";
$marTag="Approval complete: This record has been locked.";
}
//LOAD DATA
$getKRAList = "SELECT * FROM `pcp_employee_data` WHERE `deleted`=0 AND `pcp_header_id` ='$pcpHeaderID' GROUP BY `pcp_kra_id` ASC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$nmCount = 0;
$nmValue = 0;
$nmValueR = 0;
$count= $count + 1;
$kraID = $row['pcp_kra_id'];
$bgColor="#F7F7FA";
$bgColorB="#FBFBFB";
$border ="white";
$think= "0px";
$fontColor='gray';
//=============================================================================================
?>".$row['pcp_kra_id']."";
echo "| ";
$getKRAWeight = "SELECT * FROM `kra_employee_tbl` WHERE `id` ='$kraID'";
$qKRAW = mysqli_query($conn,$getKRAWeight);
while($kra = mysqli_fetch_array($qKRAW)){
echo $kra['kra_name'];
$kraWeight = $kra['weight'];
}
echo " | ";
echo "";
echo $kraWeight ;
echo " | ";
echo "";
$gtNMAverage = "SELECT * FROM `mar_emp_data` WHERE `kra_id` ='$kraID' AND `deleted`=0";
$nmAve = mysqli_query($conn,$gtNMAverage);
$nmAveRow = mysqli_num_rows($nmAve);
if($nmAveRow > 0){
while($nAve = mysqli_fetch_array($nmAve)){
$nmCount = $nmCount + 1;
$nmValue = $nmValue + $nAve['mar_numerical_rating'];
}
$nmValueR = number_format(($nmValue / $nmCount),2,'.','');
echo $nmValueR;
}
echo " | ";
echo "";
$weightMainKRA = (int)$kraWeight * $nmValueR;
echo number_format(($weightMainKRA / 100),3,'.','');
$totalWeightMainKRA = $totalWeightMainKRA + number_format(($weightMainKRA / 100),3,'.','');
echo " | ";
echo "
";
//==========================================================================================================================================
//==========================================================================================================================================
echo "";
echo "| ".$kra['id']." | ";
echo "";
$getKPIByKRA = "SELECT * FROM `pcp_employee_data` WHERE `deleted`=0 AND `pcp_kra_id` ='$kraID'AND `pcp_header_id` ='$pcpHeaderID' GROUP BY `pcp_kpi_id`";
$getKPI = mysqli_query($conn,$getKPIByKRA);
$statRow = mysqli_num_rows($getKPI);
if($statRow > 0){
while($rowK = mysqli_fetch_array($getKPI)){
$marScore = "";
$martarget = "";
$marActual = "";
$varianceNo ="";
$varianceDesc ="";
$marNumericalRating ="";
$marWeightedPoints ="";
$pcpKPIID = $rowK['pcp_kpi_id'];
?> |
".$rowK['pcp_kpi_id']."";
echo "| ";
$getKRAWeight = "SELECT * FROM `kpi_employee` WHERE `id` ='".$rowK['pcp_kpi_id']."'";
$qKRAW = mysqli_query($conn,$getKRAWeight);
while($kra = mysqli_fetch_array($qKRAW)){
echo $kra['kpi_name'];
$pcpKPITarget = $kra['kpi_target'];
}
echo " | ";
echo " | ";
echo "";
echo $pcpKPITarget;
$getMARData = "SELECT * FROM `mar_emp_data` WHERE `mar_header_id` ='$marHeaderID' AND `kra_id`='$kraID' AND `kpi_id`='$pcpKPIID' AND `emp_rec_id`='$SelectedRecordID'";
$mrData = mysqli_query($conn,$getMARData);
while($mar = mysqli_fetch_array($mrData)){
$marScore = $mar['my_score'];
$martarget = $mar['mar_target'];
$marActual = $mar['mar_actual'];
$varianceNo =$mar['mar_variance_no'];
$varianceDesc =$mar['mar_variance_desc'];
$marNumericalRating =$mar['mar_numerical_rating'];
$marWeightedPoints =$mar['mar_weighted_points'];
}
echo " | ";
//contenteditable
echo "";
echo $marActual;
echo " | ";
echo "";
echo $marScore;
echo " | ";
//contenteditable
echo "";
echo $varianceNo ." ".$varianceDesc;
echo " | ";
echo "";
echo $marNumericalRating;
echo " | ";
echo "";
echo " | ";
echo "
";
}
}
echo "";
echo "";
//==========================================================================================================================================
//==========================================================================================================================================
}
echo "";
echo "| PERFORMANCE RATING (sum of weighted points) | ";
echo "". $totalWeightMainKRA ." | ";
echo "
";
echo "";
echo "| PERCENTILE EQUIVALENT | ";
echo "";
$perCentile = 0;
$perCentile = (($totalWeightMainKRA/5)*0.5) + 0.5;
echo $perCentile * 100 . "%";
$adjEq = $perCentile * 100;
echo " | ";
echo "
";
echo "";
echo "| ADJECTIVAL EQUIVALENT | ";
echo "";
$adjE = "SELECT * FROM `gps_adjectival_eq` WHERE $adjEq BETWEEN eq_percentage_from AND eq_percentage_to";
$getAdj = mysqli_query($conn,$adjE);
while($nm = mysqli_fetch_array($getAdj)){
$eqAdjectival = $nm['eq_adjectival'];
echo strtoupper($eqAdjectival);
}
echo " | ";
echo "
";
//==========================================================================================================================================
echo "";
echo "| OVERALL MONTHLY ASSESSMENT / ACTION TO BE TAKEN | ";
echo "
";
//==========================================================================================================================================
//$marHeaderID
echo "";
echo "| ";
echo "";
if($approverButton ==="visible"){
echo "";
}
echo " | ";
echo "";
echo "";
echo "";
echo "| B.";
echo " | COMMENTS BY THE EMPLOYEE- RATEE: ";
echo " | ";
//=======================================================
?>
|
|
";
echo "";
echo "";
echo "";
echo "";
echo "| ";
echo "";
echo "";
echo "";
echo ""; //
echo "";
echo "";
?>
".$marTag."";
echo " | ";
echo " ";
}
$conn->close();
}
?>
|