";
echo "
";
echo "REC ID. | ";
echo "COMPANY | ";
echo "EMP. ID. | ";
echo "EMPLOYEE NAME | ";
echo "POSITION | ";
echo "DATE | ";
echo "RELEASE DATE | ";
echo "STATUS | ";
echo "SLA RATING | ";
echo "FINAL PAY PROGRESS | ";
echo "ALERT | ";
echo "";
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='READY FOR RELEASE' ORDER BY `cl_h_date_created` DESC");
$dataCount == 0;
while($row=mysql_fetch_array($getActiveClearance)){
$dataCount = $dataCount + 1;
$hDI = $row['h_id'];
$chkComments = mysql_result(mysql_query("SELECT COUNT(id) FROM `cl_action_slip_data` WHERE `cl_hdr_id`='$hDI'"),0);
//$chkComments = mysql_result(mysql_query("SELECT COUNT(f_id) FROM `cl_final_pay_comments` WHERE `cl_id`='$hDI'"),0);
$uID = $row['cl_h_emp_id'];
$pID = $row['cl_emp_position'];
//START OF SLA CODE
$olddate = $row['cl_sla_start'];
$endDate = $row['cl_sla_end'];
if($endDate != ""){
$myEndDate = strtotime($endDate);
}else{
$myEndDate = time();
}
$your_date = strtotime($olddate);
$datediff = $myEndDate - $your_date;
$totalCount = round($datediff / (60 * 60 * 24));
if($totalCount == 1){
$MyDay="Day";
}else{
$MyDay="Days";
}
if($totalCount < 15 ){
$color = '#06561c';
}
if($totalCount > 14 && $totalCount < 25 ){
$color = '#cb5f04';
}
if($totalCount > 24 ){
$color = '#f50732 ';
}
//END OF SLA CODE
$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);
$uCompCode=mysql_result(mysql_query("SELECT `company` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$userCompanyCode=mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$uCompCode'"),0);
$count = $count + 1;
?>
".strtoupper($row['h_id'])."";
echo "| ".$userCompanyCode." | ";
echo "".strtoupper($uEMPID)." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "".strtoupper($uPosition)." | ";
echo "".strtoupper($row['cl_h_date_created'])." | ";
echo "".strtoupper($row['cl_date_of_release'])." | ";
echo "".strtoupper($row['cl_second_wave'])." | ";
echo "";
$chkSLA = 30 - $totalCount;
if($chkSLA < 0 ){
$consumedSLA = number_format((($chkSLA / 30) * 100),2);
if($consumedSLA < -100){
$mySLA = '0.00%';
}else{
$mySLA = (100 + $consumedSLA)."%";
}
}else{
$mySLA = '100%';
}
echo "".$totalCount ." ".$MyDay." | Rating:(" .$mySLA.")";
echo" | ";
echo "";
$snWave = $row['cl_second_wave'];
switch($snWave){
case 'POSTED':
// echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'LAST PAY COMPUTATION':
// echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'LAST PAY APPROVAL':
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'CHECK PREPARATION':
echo "✅";
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'CHECK CREATION':
echo "✅";
echo "✅";
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'CHECK RELEASING':
echo "✅";
echo "✅";
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'DOCUMENTS PREPARATION':
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'SCHEDULE OF RELEASE':
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "⬜";
break;
case 'READY FOR RELEASE':
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "✅";
echo "✅";
break;
}
echo" | ";
echo "";
if($chkComments > 0){
echo " ";
}else{
echo " ";
}
echo" | ";
echo "
";
$compRate=0;
}
echo "";
if($dataCount == 0){
echo "
--No Record Found--
";
}
//echo '';s
?>
