format("Y-m-d");
if(isset($_GET['Display'])){
$sYear = explode("-",$_GET['startYear']);
$eYear = explode("-",$_GET['endYear']);
$SactiveYear = $sYear[0];
$EactiveYear = $eYear[0];
$SactiveMon = $sYear[1];
$EactiveMon = $eYear[1];
$SactiveDay = $sYear[2];
$EactiveDay = $eYear[2];
$startDate = $_GET['startDate'];
$endDate = $_GET['endDate'];
$myLabel =$startDate. " - ".$endDate;
$getserviceData = mysql_query("SELECT * FROM `fgp_survey_db` WHERE `date` BETWEEN '$startDate' AND '$endDate'");
$getLoungeData = mysql_query("SELECT * FROM `fgp_lounge_db` WHERE `date` BETWEEN '$startDate' AND '$endDate'");
//echo "AB";
}else{
//echo "A";
$cYear = explode("-",$toDate);
$activeYear = $cYear[0];
$startDate = $activeYear.'-01-01';
$endDate = $activeYear.'-12-31';
$myLabel =$startDate. " - ".$endDate;
$getserviceData = mysql_query("SELECT * FROM `fgp_survey_db` WHERE `date` BETWEEN '$startDate' AND '$endDate'");
$getLoungeData = mysql_query("SELECT * FROM `fgp_lounge_db` WHERE `date` BETWEEN '$startDate' AND '$endDate'");
}
//echo $myLabel;
while($row=mysql_fetch_array($getserviceData)){
$counter = $counter + 1;
$Qa = $row['Qa'];
$Qb = $row['Qb'];
$Qc = $row['Qc'];
$Qd = $row['Qd'];
$Qe = $row['Qe'];
$Qf = $row['Qf'];
$Qg = $row['Qg'];
$Qh = $row['Qh'];
$Qi = $row['Qi'];
$Qave = ($Qa + $Qb + $Qc + $Qd + $Qe + $Qf + $Qg + $Qh + $Qi) / 9;
if($Qave < 5 ){
$Poor = $Poor + 1;
}
if($Qave > 5 && $Qave < 6){
$Fair = $Fair + 1;
}
if($Qave >= 6 && $Qave < 8){
$Good = $Good + 1;
}
if($Qave > 8 && $Qave < 9){
$VeryGood = $VeryGood + 1;
}
if($Qave > 9){
$Outstanding = $Outstanding + 1;
}
}
$pooRating = number_format(($Poor / $counter * 100),2,'.',',');
$fairRating = number_format(($Fair / $counter * 100),2,'.',',');
$goodRating = number_format(($Good / $counter * 100),2,'.',',');
$vsRating = number_format(($VeryGood / $counter * 100),2,'.',',');
$outRating = number_format(($Outstanding / $counter * 100),2,'.',',');
//######################################################################################################
while($row=mysql_fetch_array($getLoungeData)){
$counter = $counter + 1;
$Qa = $row['Qa'];
$Qb = $row['Qb'];
$Qc = $row['Qc'];
$Qd = $row['Qd'];
$Qave = ($Qa + $Qb + $Qc + $Qd ) / 4;
if($LQave < 5 ){
$LPoor = $LPoor + 1;
}
if($LQave > 5 && $LQave < 6){
$LFair = $LFair + 1;
}
if($LQave >= 6 && $LQave < 8){
$LGood = $LGood + 1;
}
if($LQave > 8 && $LQave < 9){
$LVeryGood = $LVeryGood + 1;
}
if($LQave > 9){
$LOutstanding = $LOutstanding + 1;
}
}
$LpooRating = number_format(($LPoor / $counter * 100),2,'.',',');
$LfairRating = number_format(($LFair / $counter * 100),2,'.',',');
$LgoodRating = number_format(($LGood / $counter * 100),2,'.',',');
$LvsRating = number_format(($LVeryGood / $counter * 100),2,'.',',');
$LoutRating = number_format(($LOutstanding / $counter * 100),2,'.',',');
?>