<?php include('_mod_security.php'); ?>
<?php
	//exit;
	$sql = "SELECT YEAR(pmt_date) AS year, MONTH(pmt_date) AS month, COUNT(id) AS sale_count, SUM(pmt_amt) AS sale_total, AVG(pmt_amt) AS sale_average FROM payments ".
			"GROUP BY YEAR(pmt_date), MONTH(pmt_date) ".
			"ORDER BY YEAR(pmt_date) DESC, MONTH(pmt_date) DESC";
	$result = mysqli_query($GLOBALS['con'], $sql) or die(mysqli_error($GLOBALS['con']));
	$xls_sql = $sql;
?>
<script>
	// ****** Prepare popup form settings *****
	var win_page = '';
	var xls_sql = '<?php echo $xls_sql; ?>';
	var win_width = 600;
	var win_height = 400;
</script>

<?php include('mod/_db_navigator_bar.php'); ?>

<div class="db-grid" id="div_db_grid">

<table class="dbgrid" align="center" cellpadding="0" cellspacing="2" border="0" >
	<tr>
		<td width="60" align="center" class="data-grid-label">
			Year
		</td>
		<td width="60" align="center" class="data-grid-label">
			Month
		</td>
		<td width="120" align="center" class="data-grid-label">
			Total Sales
		</td>
		<td width="140" align="center" class="data-grid-label">
			Total Sale Amount
		</td>
		<td width="140" align="center" class="data-grid-label">
			Average Sale Amount
		</td>
	</tr>
	<?php
		while($row = mysqli_fetch_object($result))
		{
	?>
			<tr>
				<td align="right" class="data-grid-var">
					<?php echo $row->year; ?>
				</td>
				<td align="right" class="data-grid-var">
					<?php echo $row->month; ?>
				</td>
				<td align="right" class="data-grid-var">
					<?php echo $row->sale_count; ?>
				</td>
				<td align="right" class="data-grid-var">
					<?php echo number_format($row->sale_total, 2); ?>
				</td>
				<td align="right" class="data-grid-var">
					<?php echo number_format($row->sale_average, 2); ?>
				</td>
			</tr>
	<?php
		}
	?>
	
</table>

</div>