<?php

	session_start();
    include("function.php");

	dbConnect("db_seeview");

	$month = (isset($_GET['month'])) ? $_GET["month"] : "Sep";
	$year = (isset($_GET['year'])) ? $_GET["year"] : 2014;
	$date = date_parse($month);
	$monthID = $date['month'];


	$sql = "SELECT * FROM tbl_ma";
	$sql .= " WHERE month = '{$month}'";
	$rs = mysql_query($sql);
	$getRec = mysql_fetch_assoc($rs);


	$sql2 = "Select element,
	SUM(CASE WHEN Month = 'Jan' THEN total ELSE 0 END ) AS Jan,
	SUM(CASE WHEN Month = 'Feb' THEN total ELSE 0 END ) AS Feb,
	SUM(CASE WHEN Month = 'Mac' THEN total ELSE 0 END ) AS Mac,
	SUM(CASE WHEN Month = 'Apr' THEN total ELSE 0 END ) AS Apr,
	SUM(CASE WHEN Month = 'May' THEN total ELSE 0 END ) AS May,
	SUM(CASE WHEN Month = 'Jun' THEN total ELSE 0 END ) AS Jun,
	SUM(CASE WHEN Month = 'Jul' THEN total ELSE 0 END ) AS Jul,
	SUM(CASE WHEN Month = 'Aug' THEN total ELSE 0 END ) AS Aug,
	SUM(CASE WHEN Month = 'Sep' THEN total ELSE 0 END ) AS Sep,
	SUM(CASE WHEN Month = 'Oct' THEN total ELSE 0 END ) AS Oct,
	SUM(CASE WHEN Month = 'Nov' THEN total ELSE 0 END ) AS Nov,
	SUM(CASE WHEN Month = 'Dec' THEN total ELSE 0 END ) AS Dis
	from tbl_macscstate
	group by element";
	$rs2 = mysql_query($sql2);
	$getRec2 = mysql_fetch_assoc($rs2);
?>

//display table

<table class="table-condensed table-bordered table-hover table-striped" width="90%" align="center">
				<thead>
					<tr>
						<th style="color:black;background-color:#0a88ff"><div align="center"><b>KPI</b></div></th>

						<?php
						$start=( $year == '2014' ) ? 7 : 1;
						for($i=$start;$i<=$monthID;$i++){
								$monthName = date('M', mktime(0, 0, 0, $i, 10));
						?>
							<th style="color:black;background-color:#80c1ff"><div align="center"><b><?php echo $monthName; ?></b></div></th>
						<?php } ?>
						<th style="color:black;background-color:#e3a950"><div align="center"><b>YTD</b></div></th>
						<th style="color:black;background-color:#e3a950"><div align="center"><b>Rating</b></div></th>
					</tr>
				</thead>
				<tbody>

					<?php
					while ($row = mysql_fetch_assoc($rs2)) {
					?>
							<tr>
								<td style="color:black;background-color:#f5efef;width:15%"><div align="left"><?php echo $row['element']; ?></div></td>
								<?php if( $year != '2014' ){ ?>
								<?php if( 1 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jan']; ?></div></td><?php endif; ?>
								<?php if( 2 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Feb']; ?></div></td><?php endif; ?>
								<?php if( 3 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Mac']; ?></div></td><?php endif; ?>
								<?php if( 4 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Apr']; ?></div></td><?php endif; ?>
								<?php if( 5 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['May']; ?></div></td><?php endif; ?>
								<?php if( 6 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jun']; ?></div></td><?php endif; ?>
								<?php } ?>
								<?php if( 7 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Jul']; ?></div></td><?php endif; ?>
								<?php if( 8 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Aug']; ?></div></td><?php endif; ?>
								<?php if( 9 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Sep']; ?></div></td><?php endif; ?>
								<?php if( 10 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Oct']; ?></div></td><?php endif; ?>
								<?php if( 11 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Nov']; ?></div></td><?php endif; ?>
								<?php if( 12 <= $monthID ): ?><td><div align="center" style="color:black"><?php echo $row['Dis']; ?></div></td><?php endif; ?>
								<td><div align="center" style="color:black"><?php //echo YTD; ?></div></td>
								<td><div align="center" style="color:black"><?php //echo Rating; ?></div></td>
							</tr>
					<?php } ?>
				</tbody>
			</table>