format("Y/m/d"); ?>
Scanning. Please wait....
LIST OF OPEN CLEARANCE FORM
Search...
Create New
"; echo "
"; echo "
NO
"; echo "
DATE CREATED
"; echo "
COMPANY
"; echo "
NAME
"; echo "
POSITION
"; echo "
DEPARTMENT
"; echo "
REASON
"; echo "
STATUS
"; echo "
COMPLETION
"; echo "
ACTION
"; echo "
"; while($row=mysql_fetch_array($getNewC)){ $empID = $row['emp_id']; $checkClearingDept = mysql_result(mysql_query("SELECT COUNT(id) FROM emp_clearance_data WHERE `emp_id`='$empID'"),0); $checkApproved = mysql_result(mysql_query("SELECT COUNT(id) FROM emp_clearance_data WHERE `emp_id`='$empID' AND `approved_by`!=0 AND `date_approved`!=''"),0); $comRate =($checkApproved / $checkClearingDept) * 100; $comRate=number_format($comRate,1,'.','').'%' ; $dateC = $row['date_created']; $dc = explode(".",$dateC); $dateCreated = $dc[0]; $isPosted = $row['posted']; if ($isPosted == 1){ $tColor='black'; $posted = "POSTED"; }else{ $posted = "UNPOSTED"; $tColor='red'; } $count=$count + 1; ?>
".$count.""; echo "
".$dateCreated."
"; echo "
".$row['comp_id']."
"; echo "
".$row['emp_name']."
"; echo "
".$row['position_title']."
"; echo "
".$row['department']."
"; echo "
".$row['reason_of_clearance']."
"; echo "
".$posted."
"; echo "
".$comRate."
"; echo "
View Edit Post
"; echo "
"; } echo ""; ?>
CREATE NEW CLEARANCE FORM
✕
NEW CLREANCE FORM
NAME/SIGNATURE OF EMPLOYEE:
ID NO:
EMPLOYMENT STATUS:
DATE HIRED :
POSITION TITLE:
DESIGNATED/WORKING TITLE :
CURRENT UNIT ASSIGNMENT :
COMPANY:
".$row['comp_name'].""; } ?>
SHARED SERVICES :
REASON FOR SECURING CLEARANCE :
Leave of absence
Reassignment
Transfer
Detail
Suspension
Reemployment
Resignation
Involuntary Separation
Retirement
OTHER COMMENTS:
FROM:
TO:
INCLUSIVE PERIOD/EFFECTIVITY DATE:
Rank & File Employee
Manager
Executive
