";
echo "
";
echo "NO | ";
echo "EMP. ID | ";
echo "DATE RECEIVED | ";
echo "COMPANY | ";
echo "NAME | ";
echo "POSITION | ";
echo "POSITION STEATUS | ";
echo "DEPARTMENT | ";
echo "REASON | ";
echo "FROM | ";
echo "TO | ";
echo "EFFECTIVITY | ";
echo "NOTE | ";
echo "COMPLETION | ";
echo "";
while($row=mysql_fetch_array($getNewC)){
$chkIfExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `emp_clearance_data` WHERE `approving_officer_A`='$myEmpID' || `approving_officer_B`='$myEmpID' "),0);
//echo $myEmpID;
if($chkIfExist > 0){
$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 "| ".$row['emp_id']." | ";
echo "".$row['posted_date']." | ";
echo "".$row['comp_id']." | ";
echo "".$row['emp_name']." | ";
echo "".$row['position_title']." | ";
echo "".$row['emp_status']." | ";
echo "".$row['department']." | ";
echo "".$row['reason_of_clearance']." | ";
echo "".$row['from_origin']." | ";
echo "".$row['to_origin']." | ";
echo "".$row['effectivity_date']." | ";
echo "".$row['reason_notes']." | ";
echo " | ";
echo "
";
}
}
echo "";
?>
📍 MY CLEARANCE
";
echo "
";
echo "NO | ";
echo "EMP. ID | ";
echo "DATE CREATED | ";
echo "COMPANY | ";
echo "NAME | ";
echo "POSITION | ";
echo "COMPLETION | ";
echo "";
while($row=mysql_fetch_array($getNewC)){
$chkIfExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `emp_clearance_data` WHERE `approving_officer_A`='$myEmpID' || `approving_officer_B`='$myEmpID' "),0);
//echo $myEmpID;
if($chkIfExist > 0){
$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 "| ".$row['emp_id']." | ";
echo "".$row['posted_date']." | ";
echo "".$row['comp_id']." | ";
echo "".$row['emp_name']." | ";
echo "".$row['position_title']." | ";
echo " | ";
echo "
";
}
}
echo "";
?>
