";
}else{
echo "
";
}
echo"| REC ID. | "; echo "COMPANY | "; echo "EMP. ID. | "; echo "EMPLOYEE NAME | "; echo "POSITION | "; echo "CLEARANCE DATE | "; echo "RECEIVED 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`='LASTPAY COMPUTATION' ORDER BY `search_ref_lname` ASC"); //$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='LASTPAY COMPUTATION' AND `cl_h_comp_id` = '$comID' 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); //$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; ?>
|---|---|---|---|---|---|---|---|---|---|
| ".$userCompanyCode." | "; echo "".strtoupper($uEMPID)." | "; echo "".strtoupper($uLName).", ".strtoupper($uFName)." | "; echo "".strtoupper($uPosition)." | "; echo "".strtoupper($row['cl_h_date_created'])." | "; echo ""; $apprDate = $row['cl_approver_id_timestamp']; $exAprDate = explode(" ",$apprDate); echo $exAprDate[0]; echo" | "; 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 'LASTPAY COMPUTATION': // echo "✅"; echo "⬜"; echo "⬜"; echo "⬜"; echo "⬜"; echo "⬜"; echo "⬜"; echo "⬜"; break; case 'LASTPAY 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 "
--No Record Found--
"; } //echo '';s exit(); } ?>