format("Y-m-d"); if(isset($_POST['done'])){ $SearchText = mysql_escape_string($_POST['SearchText']); $NewCLRecordEmpID = mysql_escape_string($_POST['NewCLRecordEmpID']); $addByUID = mysql_escape_string($_POST['addByUID']); $NewCLRecordID = mysql_escape_string($_POST['NewCLRecordID']); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_hr_approval_id` = '$addByUID' AND `search_ref_fname` LIKE '%SearchText%' || `cl_recommender_a_id` ='$addByUID' AND `search_ref_lname` LIKE '%SearchText%' || `cl_approver_id` ='$addByUID' AND `search_ref_emp_id` LIKE '%SearchText%' || `cl_recommender_b_id` ='$addByUID' ORDER BY `h_id` DESC"); $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `search_ref_fname` LIKE '%$SearchText%' || `search_ref_lname` LIKE '%$SearchText%' || `search_ref_emp_id` LIKE '%$SearchText%' ORDER BY `h_id` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $createdBy = $row['cl_created_by']; $AuthorizedBy = $row['cl_hr_approval_id']; $AuthorizedTS = $row['cl_hr_approval_timestamp']; $EndorsedByA = $row['cl_recommender_a_id']; $EndorsedByATS = $row['cl_recommender_a_timestamp']; $EndorsedByB = $row['cl_recommender_b_id']; $EndorsedByBTS = $row['cl_recommender_b_timestamp']; $ApprovedB = $row['cl_approver_id']; $ApprovedBTS = $row['cl_approver_id_timestamp']; $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); $createdBy=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`='$AuthorizedBy'"),0); $endaLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endbFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $endbLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $apprFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $apprLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$AuthorizedBy'"),0); $count = $count + 1; ?>".$row['h_id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO.	DATE	EMP. ID.	EMPLOYEE NAME	CREATED BY	AUTHORIZED BY	ENDORSED BY #1	ENDORSED BY #2	APPROVED BY	STATUS	Action
".strtoupper($row['cl_h_date_created'])."	".strtoupper($uEMPID)."	".strtoupper($uLName).", ".strtoupper($uFName)."	".strtoupper($createdBy)."	".strtoupper($authLName).", ".strtoupper($authFName); echo " ".$AuthorizedTS.""; echo"	".strtoupper($endaLName).", ".strtoupper($endaFName); echo " ".$EndorsedByATS.""; echo"	".strtoupper($endbLName).", ".strtoupper($endbFName); echo " ".$EndorsedByBTS.""; echo"	".strtoupper($apprLName).", ".strtoupper($apprFName); echo " ".$ApprovedBTS.""; echo"	".strtoupper($row['cl_h_hr_approval'])."

"; //echo ''; exit(); } ?>