❖ CLEARANCE INFORMATION:

$compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $addCompID = mysql_escape_string($_POST['addCompID']); $addByUID = mysql_escape_string($_POST['addByUID']); $ClearanceDataID = mysql_escape_string($_POST['ClearanceDataID']); $uID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceDataID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_emp_id` = '$addByUID' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $headerID = $row['h_id']; $keyCodeID = $row['key_code']; $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); //$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_hdr_id`='$headerID' AND `cl_approved_by_id`='0' || `cl_approver_id_b` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_hdr_id`='$headerID' AND `cl_approved_by_id` ='0' "),0); //if($chkIfIamApprover > 0){ $count = $count + 1; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //} } echo "

NO.	TRANS ID.	DATE.	EMP. ID.	LAST NAME	FIRST NAME	POSITION	TYPE	STATUS	INFO	Action
".strtoupper($row['h_id'])."	".strtoupper($row['cl_h_date_created'])."	".strtoupper($uEMPID)."	".strtoupper($uLName)."	".strtoupper($uFName)."	".strtoupper($uPosition)."	".strtoupper($row['cl_rank'])."	".strtoupper($row['cl_h_hr_approval'])."	"; $keyCode = $row['key_code']; $headerID = $row['h_id']; $countTotalApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_hdr_id`='$headerID' AND `key_code`='$keyCode' AND `cl_approver_id_a` != '0' \|\| `cl_hdr_id`='$headerID' AND `key_code`='$keyCode' AND `cl_approver_id_b` != 0"),0); $countApproved = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_hdr_id`='$headerID' AND `key_code`='$keyCode' AND `cl_approved_by_id` != '0' AND `cl_approved_date` !=''"),0); $compRate = number_format((($countApproved / $countTotalApprover) * 100),2) . "%"; if($row['cl_h_hr_approval']==='CLOSED'){ $status ='COMPLETED'; }else{ if($compRate != '100%'){ $status ='In-progress'; }else{ $status ='For Final Approval'; } } echo strtoupper($status)," (".$compRate.")"; echo " "; echo " "; echo " "; echo " "; echo"

"; } ?>