";
echo "";
echo "| NO. | ";
echo "DATE RECEIVED | ";
echo "DATE SIGNED | ";
echo "EMPLOYEE NAME | ";
echo "CREATED BY | ";
echo "AUTHORIZED BY | ";
echo "ENDORSED BY #1 | ";
echo "ENDORSED BY #2 | ";
echo "APPROVED BY | ";
echo "STATUS | ";
//echo "Action | ";
echo "";
//$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_hr_approval_id` ='$userID' || `cl_recommender_a_id` ='$userID' || `cl_approver_id` ='$userID' || `cl_recommender_b_id` ='$userID' ORDER BY `h_id` DESC");
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_data` WHERE `cl_approved_by_id` ='$userID' ORDER BY `cl_id` DESC");
while($row=mysql_fetch_array($getActiveClearance)){
$uID = $row['cl_h_emp_id'];
$kCode=$row['key_code'];
$pID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$createdBy = mysql_result(mysql_query("SELECT `cl_created_by` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$AuthorizedBy = mysql_result(mysql_query("SELECT `cl_hr_approval_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$AuthorizedTS = mysql_result(mysql_query("SELECT `cl_hr_approval_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$EndorsedByA = mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$EndorsedByATS = mysql_result(mysql_query("SELECT `cl_recommender_a_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$EndorsedByB = mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$EndorsedByBTS = mysql_result(mysql_query("SELECT `cl_recommender_b_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$clHDateCreated= mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$clhStatus= mysql_result(mysql_query("SELECT `cl_h_hr_approval` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$ApprovedB = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$ApprovedBTS = mysql_result(mysql_query("SELECT `cl_approver_id_timestamp` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$uEMPID= mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$kCode'"),0);
$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uEMPID'"),0);
$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uEMPID'"),0);
$createdByF=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$createdBy'"),0);
$createdByL=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$createdBy'"),0);
$authFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0);
$authLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0);
$endaFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$EndorsedByA'"),0);
$endaLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$EndorsedByA'"),0);
$endbFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$EndorsedByB'"),0);
$endbLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$EndorsedByB'"),0);
$apprFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$ApprovedB'"),0);
$apprLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$ApprovedB'"),0);
$count = $count + 1;
?>
".$count."";
echo "| ".$clHDateCreated." | ";
echo "".$row['cl_approved_date']." | ";
//echo "".strtoupper($uEMPID)." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "".strtoupper($createdByF)." ".strtoupper($createdByL)." | ";
echo "".strtoupper($authLName).", ".strtoupper($authFName);
echo "
".$AuthorizedTS."";
echo" | ";
echo "".strtoupper($endaLName).", ".strtoupper($endaFName);
echo "
".$EndorsedByATS."";
echo" | ";
echo "".strtoupper($endbLName).", ".strtoupper($endbFName);
echo "
".$EndorsedByBTS."";
echo" | ";
echo "".strtoupper($apprLName).", ".strtoupper($apprFName);
echo "
".$ApprovedBTS."";
echo" | ";
echo "".strtoupper($clhStatus)." | ";
echo "
";
}
echo "";
?>