";
echo "
";
echo "NO. | ";
echo "TRANS ID. | ";
echo "DATE CREATED. | ";
echo "EMP. ID. | ";
echo "EMPLOYEE NAME | ";
echo "POSITION | ";
echo "STATUS | ";
echo "COMPLETION RATE | ";
echo "SLA RATING | ";
echo "FINAL PAY PROGRESS | ";
echo "ALERT | ";
echo "";
$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='FOR HR APPROVAL' AND `cl_h_hr_approval`!='CLOSED' AND `cl_h_comp_id` = '$comID' AND `cl_h_hr_approval`!='DISAPPROVED' ORDER BY `cl_h_date_created` DESC");
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);
$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);
$count = $count + 1;
?>
".$count."";
echo "| ".strtoupper($row['h_id'])." | ";
echo "".strtoupper($row['cl_h_date_created'])." | ";
echo "".strtoupper($uEMPID)." | ";
echo "".strtoupper($uLName).", ".strtoupper($uFName)." | ";
echo "".strtoupper($uPosition)." | ";
echo "";
if($row['cl_h_hr_approval']==='APPROVED'){
echo strtoupper($row['cl_second_wave']);
}else{
echo strtoupper($row['cl_h_hr_approval']);
}
echo" | ";
echo "";
$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) . "%";
echo "(".$compRate.")";
echo "";
echo " ";
echo " ";
echo " | ";
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." | Ratings:(" .$mySLA.")";
echo" | ";
echo "";
$snWave = $row['cl_second_wave'];
switch($snWave){
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 RELEASING':
echo "✅";
echo "✅";
echo "✅";
echo "⬜";
echo "⬜";
echo "⬜";
echo "⬜";
break;
case 'CHECK CREATION':
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;
case '':
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--
";
}
?>
