--Unable to query database. Date field is empty--
"; exit(); }else{ $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $myLabel = $companyName; $getData = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$SearchTextStart' AND '$SearchTextEnd' AND `cl_status`= 1 AND `cl_h_comp_id`='$compID'"); while($row=mysql_fetch_array($getData)){ $olddate = $row['cl_sla_start']; $endDate = $row['cl_sla_end']; if($endDate != ""){ $myEndDate = strtotime($endDate); }else{ $myEndDate = time(); } $slaStart = strtotime($olddate); $datediff = $myEndDate - $slaStart; $totalCount = round($datediff / (60 * 60 * 24)); $totalCount= round($datediff / (60 * 60 * 24)); if($totalCount < 31){ $green = $green + 1; } if ($totalCount > 31 && $totalCount < 36){ $orange = $orange + 1; } if ($totalCount > 35 ){ $red = $red + 1; } $total = $green + $orange + $red; } $EarlyCount = number_format(($green / $total * 100),2,'.',','); $MidCount = number_format(($orange / $total * 100),2,'.',','); $LateCount = number_format(($red / $total * 100),2,'.',','); $getNew = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$SearchTextStart' AND '$SearchTextEnd' AND `hdr_status` = 1"),0); $getApproval = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$SearchTextStart' AND '$SearchTextEnd' AND `hdr_status` = 2 || `cl_h_date_created` BETWEEN '$SearchTextStart' AND '$SearchTextEnd' AND`hdr_status` = 3 "),0); $getFinal = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_date_created` BETWEEN '$SearchTextStart' AND '$SearchTextEnd' AND `hdr_status` = 4"),0); } }else{ //GROUP WIDE $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $myLabel = $companyName; $getData = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_status`= 1 AND `cl_h_comp_id`='$compID'"); while($row=mysql_fetch_array($getData)){ $olddate = $row['cl_sla_start']; $endDate = $row['cl_sla_end']; if($endDate != ""){ $myEndDate = strtotime($endDate); }else{ $myEndDate = time(); } $slaStart = strtotime($olddate); $datediff = $myEndDate - $slaStart; $totalCount = round($datediff / (60 * 60 * 24)); $totalCount= round($datediff / (60 * 60 * 24)); if($totalCount < 31){ $green = $green + 1; } if ($totalCount > 31 && $totalCount < 36){ $orange = $orange + 1; } if ($totalCount > 35 ){ $red = $red + 1; } $total = $green + $orange + $red; } $EarlyCount = number_format(($green / $total * 100),2,'.',','); $MidCount = number_format(($orange / $total * 100),2,'.',','); $LateCount = number_format(($red / $total * 100),2,'.',','); $getNew = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id`='$compID' AND `hdr_status` = 1"),0); $getApproval = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id`='$compID' AND `hdr_status` = 2 || `hdr_status` = 3 "),0); $getFinal = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id`='$compID' AND `hdr_status` = 4"),0); } ?>