☸     CLEARANCE FOR MY APPROVAL

✩   FOR ROUTING APPROVAL
"; 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_status`='1' AND `cl_h_comp_id` = '$comID' AND `cl_hr_approval_id` = '$userID' AND `cl_hr_approval_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 ""; ?>
✩   FOR ENDORSEMENT
"; 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_h_comp_id` = '$comID' AND `cl_recommender_a_id` = '$userID' AND `cl_recommender_a_timestamp`='' || `cl_h_hr_approval`='FOR ENDORSEMENT' AND `hdr_status`='2' AND `cl_h_comp_id` = '$comID' 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 ""; ?>
✩   FOR FINAL APPROVAL
"; 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' || `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id_b` = '$userID' 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 ""; ?>
"; echo ""; echo "NO."; echo "REC ID."; echo "DATE."; echo "EMP. ID."; echo "EMPLOYEE NAME"; echo "POSITION"; echo "TYPE"; echo "STATUS"; 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']; $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); $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); $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($uPosition).""; echo "".strtoupper($clRand).""; echo "".strtoupper($clStatus).""; echo "For clearing officer approval"; echo ""; } } echo ""; ?>