<?php
$janDateS= '01/01/'.$mycYear;
$janDateE= '01/31/'.$mycYear;
$febDateS= '02/01/'.$mycYear;
$febDateE= '02/29/'.$mycYear;
$marDateS= '03/01/'.$mycYear;
$marDateE= '03/31/'.$mycYear;
$aprDateS= '04/01/'.$mycYear;
$aprDateE= '04/30/'.$mycYear;
$mayDateS= '05/01/'.$mycYear;
$mayDateE= '05/31/'.$mycYear;
$junDateS= '06/01/'.$mycYear;
$junDateE= '06/30/'.$mycYear;
$julDateS= '07/01/'.$mycYear;
$julDateE= '07/31/'.$mycYear;
$augDateS= '08/01/'.$mycYear;
$augDateE= '08/31/'.$mycYear;
$sepDateS= '09/01/'.$mycYear;
$sepDateE= '09/31/'.$mycYear;
$octDateS= '10/01/'.$mycYear;
$octDateE= '10/31/'.$mycYear;
$novDateS= '11/01/'.$mycYear;
$novDateE= '11/31/'.$mycYear;
$decDateS= '12/01/'.$mycYear;
$decDateE= '12/31/'.$mycYear;


$janPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$janDateS' AND '$janDateE'"),0);
$janPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$janDateS' AND '$janDateE'"),0);

$febPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$febDateS' AND '$febDateE'"),0);
$febPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$febDateS' AND '$febDateE'"),0);

$marPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$marDateS' AND '$marDateE'"),0);
$marPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$marDateS' AND '$marDateE'"),0);

$aprPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$aprDateS' AND '$aprDateE'"),0);
$aprPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$aprDateS' AND '$aprDateE'"),0);

$mayPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$mayDateS' AND '$mayDateE'"),0);
$mayPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$mayDateS' AND '$mayDateE'"),0);

$junPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$junDateS' AND '$junDateE'"),0);
$junPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$junDateS' AND '$junDateE'"),0);

$julPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$julDateS' AND '$julDateE'"),0);
$julPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$julDateS' AND '$julDateE'"),0);

$augPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$augDateS' AND '$augDateE'"),0);
$augPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$augDateS' AND '$augDateE'"),0);

$sepPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$sepDateS' AND '$sepDateE'"),0);
$sepPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$sepDateS' AND '$sepDateE'"),0);

$octPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$octDateS' AND '$octDateE'"),0);
$octPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$octDateS' AND '$octDateE'"),0);

$novPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$novDateS' AND '$novDateE'"),0);
$novPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$novDateS' AND '$novDateE'"),0);

$decPre = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='PRE' AND `employee_id`='$empID' AND `date` BETWEEN '$decDateS' AND '$decDateE'"),0);
$decPOST = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `ex_type`='POST' AND `employee_id`='$empID' AND `date` BETWEEN '$decDateS' AND '$decDateE'"),0);
 
 
?>
  <div id="piechart"   style="width: 800px; height: 250px;border:0px solid red;padding:0px"> 
    <table style='width:100%'>
		<tr>
			<td valign='bottom' style="width: 100%; height: 200px;border:0px solid red;background:white">
				<?php 
					 
							$passed = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `ratings`='VERY SATISFACTORY' AND `year`='$mycYear' || `routed_to`='$empID' AND  `ratings`='EXCELLENT' AND `year`='$mycYear'  || `routed_to`='$empID' AND `ratings`='SATISFACTORY' AND `year`='$mycYear' "),0); 
							$failed = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `ratings`='BELOW SATISFACTORY'  AND `year`='$mycYear' || `routed_to`='$empID' AND  `ratings`='POOR' AND `year`='$mycYear' "),0); 
							$passPercent = $passed + $failed;
							$passRate = ($passed / $passPercent) * 100;
							$failRate = ($failed / $passPercent) * 100;
							echo "<div style='margin:3px;float:left;text-align:center;width:60%;height:100%;position;relative;font-family:Calibri Light;font-size:30px;color:#0431B4;font-weight:normal;border:1px solid #fafafa;padding:0px;border-radius:0px;border:1px solid #F2F2F2'>";
								echo "<div align='center' class='lightGradient' style='padding:3px;width:100%;top:0px;left:0px;position:relative;z-index:2;margin-bottom:5px'>AVERAGE RATING</div>"; 	
								 echo "<b style='font-family:Calibri;font-size:50px;color:#088A08;margin-right:10px;text-shadow:1px 1px 2px black'>".$passRate . " %</b><img src='images/icon/tup_big.png'  style='margin-right:40px'></img>";
								  echo "<b style='font-family:Calibri;font-size:50px;color:#f00;margin-right:10px;text-shadow:1px 1px 2px black'>".$failRate . " %</b><img src='images/icon/tud_big.png' ></img>";
							echo "</div>"; 
							
							echo "<div style='margin:3px;float:left;text-align:left;width:38%;height:100%;position;relative;font-family:Calibri Light;font-size:40px;color:#0431B4;font-weight:normal;border:1px solid #fafafa;padding:0px;border-radius:0px;border:1px solid #F2F2F2'>";
								echo "<div class='lightGradient' style='padding:3px;width:100%;top:0px;left:0px;position:relative;z-index:2;margin-bottom:5px'>YOUR TICKET SUMMARY</div>"; 	
								 $assignedTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' "),0);
								 $closedTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `current_status`='CLOSED'"),0);
								 $pendingTicket = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `current_status`!='CLOSED'"),0);
								 $slaCompliance = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `ticket_sla` >= '0' AND `ticket_sla` != ''"),0);
								 $slaNonCompliance = mysql_result(mysql_query("SELECT COUNT('id') FROM `pms_tickets` WHERE `routed_to`='$empID' AND `year`='$mycYear' AND `ticket_sla` < '0'  AND `ticket_sla` != ''"),0);
								 
								 echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>
								 <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$assignedTicket."</b> Total Assigned Tickets</p>";
								  echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>
								 <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$closedTicket."</b> Total Closed Tickets</p>";
								  echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>
								 <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$pendingTicket."</b> Total Pending Tickets</p>";
								 echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>
								 <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$slaCompliance."</b> SLA Compliant</p>";
								  echo "<p style='padding-left:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>
								 <b style='margin-right:10px;font-family:Calibri;font-size:16px;color:blue;font-weight:normal'>".$slaNonCompliance."</b> SLA NON-Compliant</p>";
							echo "</div>";
				?>
			</td>
		</tr>
	</table>
 </div>