";
echo "";
echo "| DATE | ";
echo "REC ID. | ";
echo "EMPLOYEE NAME | ";
echo "STATUS | ";
//echo "Action | ";
echo "";
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR HR APPROVAL' AND `cl_hr_approval_id` = '$userID' AND `cl_hr_approval_timestamp`='' AND `delete_date_time`='' ORDER BY `cl_h_date_created` DESC");
//$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR HR APPROVAL' AND `cl_h_comp_id` = '$comID' AND `cl_hr_approval_id` = '$userID' AND `cl_hr_approval_timestamp`='' AND `delete_date_time`='' ORDER BY `cl_h_date_created` DESC");
//$forAuthorization = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR HR APPROVAL' AND `cl_h_comp_id`='$comID' AND `cl_hr_approval_id` ='$userID' AND `cl_hr_approval_timestamp`='' AND `hdr_status` = 0"),0);
while($row=mysql_fetch_array($getActiveClearance)){
$uID = $row['cl_h_emp_id'];
$pID = $row['cl_emp_position'];
$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0);
$count = $count + 1;
?>
".strtoupper($row['cl_h_date_created'])."";
echo "| ".strtoupper($row['h_id'])." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "";
if($row['cl_h_hr_approval']==='FOR HR APPROVAL'){ echo "UNPOSTED"; }
if($row['cl_h_hr_approval']==='FOR ENDORSEMENT'){ echo "CLEARED"; }
if($row['cl_h_hr_approval']==='FINAL APPROVAL'){ echo "GM APPROVAL"; }
echo " | ";
echo "
";
}
echo "";
?>
";
echo "";
echo "| DATE | ";
echo "REC ID. | ";
echo "EMPLOYEE NAME | ";
echo "STATUS | ";
//echo "Action | ";
echo "";
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FOR ENDORSEMENT' AND `hdr_status`='2' AND `cl_recommender_a_id` = '$userID' AND `cl_recommender_a_timestamp`='' || `cl_h_hr_approval`='FOR ENDORSEMENT' AND `hdr_status`='2' AND `cl_recommender_b_id` = '$userID' AND `cl_recommender_b_timestamp`='' ORDER BY `cl_h_date_created` DESC");
while($row=mysql_fetch_array($getActiveClearance)){
$uID = $row['cl_h_emp_id'];
$pID = $row['cl_emp_position'];
$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0);
$count = $count + 1;
?>
".strtoupper($row['cl_h_date_created'])."";
echo "| ".strtoupper($row['h_id'])." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "";
if($row['cl_h_hr_approval']=='For HR Approval'){ echo "UNPOSTED"; }
if($row['cl_h_hr_approval']=='FOR ENDORSEMENT'){ echo "CLEARED"; }
if($row['cl_h_hr_approval']=='FINAL APPROVAL'){ echo "GM APPROVAL"; }
echo " | ";
echo "
";
}
echo "";
?>
";
echo "";
echo "| DATE | ";
echo "REC ID. | ";
echo "EMPLOYEE NAME | ";
echo "STATUS | ";
//echo "Action | ";
echo "";
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id` = '$userID' AND `cl_approver_id_timestamp`='' || `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id_b` = '$userID' AND `cl_approver_id_b_timestamp`='' ORDER BY `cl_h_date_created` DESC");
//$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id` = '$userID' ORDER BY `cl_h_date_created` DESC");
while($row=mysql_fetch_array($getActiveClearance)){
$uID = $row['cl_h_emp_id'];
$pID = $row['cl_emp_position'];
$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0);
$count = $count + 1;
?>
".strtoupper($row['cl_h_date_created'])."";
echo "| ".strtoupper($row['h_id'])." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "";
if($row['cl_h_hr_approval']=='For HR Approval'){ echo "UNPOSTED"; }
if($row['cl_h_hr_approval']=='FOR ENDORSEMENT'){ echo "CLEARED"; }
if($row['cl_h_hr_approval']=='FINAL APPROVAL'){ echo "FOR APPROVAL"; }
echo " | ";
echo "
";
}
echo "";
?>
✩ PENDING CLEARANCE
";
echo "";
echo "| NO. | ";
echo "REC ID. | ";
echo "DATE. | ";
echo "EMP. ID. | ";
echo "EMPLOYEE NAME | ";
echo "COMPANY | ";
echo "POSITION | ";
echo "TYPE | ";
echo "CLEARING UNIT | ";
echo "INSTRUCTION | ";
//echo "Action | ";
echo "";
//$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='For HR Approval' AND `cl_status`='1' AND `cl_h_comp_id` = '$comID' ORDER BY `cl_h_date_created` DESC"); 090434218-96
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' || `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' ORDER BY `cl_id` DESC");
while($row=mysql_fetch_array($getActiveClearance)){
$keyCodeID = $row['key_code'];
$clCompID = $row['cl_comp_id'];
$headerID = mysql_result(mysql_query("SELECT `h_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$empID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$pID = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$clCreatedDate = mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$clRand = mysql_result(mysql_query("SELECT `cl_rank` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$clStatus = mysql_result(mysql_query("SELECT `cl_h_hr_approval` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0);
$deptName = mysql_result(mysql_query("SELECT `cl_unit_name` FROM `cl_approving_unit` WHERE `id`='".$row['cl_unit_id']."'"),0);
$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$empID'"),0);
$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$empID'"),0);
$uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$empID'"),0);
$uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0);
$uComp=mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$clCompID'"),0);
$chkIfIamApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_approver_id_a` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id`='0' || `cl_approver_id_b` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id` ='0'"),0);
if($chkIfIamApprover > 0){
$count = $count + 1;
?>
".$headerID."";
echo "| ".strtoupper($row['cl_id'])." | ";
echo "".$clCreatedDate." | ";
echo "".strtoupper($uEMPID)." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "".strtoupper($uComp)." | ";
echo "".strtoupper($uPosition)." | ";
echo "".strtoupper($clRand)." | ";
echo "".strtoupper($deptName)." | ";
echo "For clearing officer approval | ";
echo "
";
}
}
echo "";
?>
