format("Y-m-d");
$daDate = explode('-',$toDate);
$dasYear = $daDate[0]; //One
$janS = $dasYear."-01-01";
$janE = $dasYear."-01-31";
$febS = $dasYear."-01-01";
$febE = $dasYear."-02-28";
$marS = $dasYear."-03-01";
$marE = $dasYear."-03-31";
$aprS = $dasYear."-04-01";
$aprE = $dasYear."-04-30";
$mayS = $dasYear."-05-01";
$mayE = $dasYear."-05-31";
$junS = $dasYear."-06-01";
$junE = $dasYear."-06-30";
$julS = $dasYear."-07-01";
$julE = $dasYear."-07-31";
$augS = $dasYear."-08-01";
$augE = $dasYear."-08-31";
$sepS = $dasYear."-09-01";
$sepE = $dasYear."-09-30";
$octS = $dasYear."-10-01";
$octE = $dasYear."-10-31";
$novS = $dasYear."-11-01";
$novE = $dasYear."-11-30";
$decS = $dasYear."-12-01";
$decE = $dasYear."-12-31";
if(isset($_POST['done'])){
//GROUP WIDE
//$getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status` > 3");
$getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status`!='0' AND `date_created` BETWEEN '$janS' AND '$decE'");
while($row=mysql_fetch_array($getData)){
$olddate = $row['date_created'];
$endDate = $toDate;
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));
echo $totalCount."xxx
";
if($totalCount < 32){
$green = $green + 1;
}
if ($totalCount > 31 && $totalCount < 61){
$orange = $orange + 1;
}
if ($totalCount > 60 && $totalCount < 91){
$red = $red + 1;
}
if ($totalCount > 90){
$fullred = $fullred + 1;
}
$total = $green + $orange + $red + $fullred;
}
$EarlyCount = number_format(($green / $total * 100),2,'.',',');
$MidCount = number_format(($orange / $total * 100),2,'.',',');
$LateCount = number_format(($red / $total * 100),2,'.',',');
$SuperLateCount = number_format(($fullred / $total * 100),2,'.',',');
$forCanvass = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='4' AND `deleted` = 0"),0);
$forApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='8' AND `deleted` = 0 "),0); //PO APPROVAL
$userApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval`=1 AND `user_approval_ts`=''"),0);
$execomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='6' AND `deleted` = 0"),0);
$forDelivery = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='9' AND `deleted` = 0"),0);
$newIncoming = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`<4 AND `deleted` = 0"),0);
}else{
//GROUP WIDE
$getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status`!=0");
while($row=mysql_fetch_array($getData)){
$olddate = $row['date_created'];
$endDate = $toDate;
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));
//echo $totalCount."
";
if($totalCount < 30){
$green = $green + 1;
}
if ($totalCount > 30 && $totalCount < 61){
$orange = $orange + 1;
}
if ($totalCount > 60 && $totalCount < 91){
$red = $red + 1;
}
if ($totalCount > 90){
$fullred = $fullred + 1;
}
$total = $green + $orange + $red + $fullred;
}
//$EarlyCount = number_format(($green),0,'.','');
//$MidCount = number_format(($orange),0,'.','');
//$LateCount = number_format(($red),0,'.','');
//$SuperLateCount = number_format(($fullred),2,'.',',');
$EarlyCount = number_format(($green / $total * 100),2,'.',',');
$MidCount = number_format(($orange / $total * 100),2,'.',',');
$LateCount = number_format(($red / $total * 100),2,'.',',');
$SuperLateCount = number_format(($fullred / $total * 100),2,'.',',');
$forCanvass = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=4 AND `deleted` = 0"),0);
$forApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=8 AND `deleted` = 0"),0);
$userApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval`=1 AND `user_approval_ts`=''"),0);
$execomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='6' AND `deleted` = 0"),0);
$forDelivery = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=9 AND `deleted` = 0"),0);
$newIncoming = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`<4 AND `deleted` = 0"),0);
}
//echo $green. " | " .$orange. " | " .$red. " | " .$fullred;
?>
USER APPROVAL
View Details
EXECOM APPROVAL
View Details
FOR DELIVERY
View Details