format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; $comID=$user_data['company']; if(isset($_POST['getData'])){ $start = mysql_real_escape_string($_POST['start']); $limit = mysql_real_escape_string($_POST['limit']); $infCanvass = mysql_real_escape_string($_POST['infCanvass']); if($infCanvass=='' || $infCanvass == null){ $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 LIMIT $start, $limit"); }else{ $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; ?>-"; 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 ""; $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; } } ?>