";
echo "
";
echo "NO. | ";
echo "TRANS ID. | ";
echo "DATE CREATED. | ";
echo "EMP. ID. | ";
echo "EMPLOYEE NAME | ";
echo "POSITION | ";
echo "TYPE | ";
echo "STATUS | ";
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' AND `hdr_status` = 0 ORDER BY `cl_h_date_created` DESC");
while($row=mysql_fetch_array($getActiveClearance)){
$dataCount = $dataCount + 1;
$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;
?>
".$count."";
echo "| ".strtoupper($row['h_id'])." | ";
echo "".strtoupper($row['cl_h_date_created'])." | ";
echo "".strtoupper($uEMPID)." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "".strtoupper($uPosition)." | ";
echo "".strtoupper($row['cl_rank'])." | ";
echo "".strtoupper($row['cl_h_hr_approval'])." | ";
echo "
";
}
echo "";
if($dataCount == 0){
echo "
--No Record Found--
";
}
?>
