<?php
// Enable error reporting for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Your existing PHP code starts here
?>

<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=AW-17077756407"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'AW-17077756407');
</script>

<?php
	include 'constants.php';
	include 'classes/class.database.php';

	$db = new Database($config['db_host'], $config['db_user'], $config['db_pass'], $config['db_database']);

    if (!$db->connect())
    	exit;

    include 'login.php';

	if (isset($_POST['itemid'])) {
		include 'package.php';
	}
?>

<!DOCTYPE html>
<html lang="en">
<?php include 'templates/head.php'; ?>
<body>

	<div class="nav-wrapper">
		<div class="container">
			<?php include 'templates/page_header.php'; ?>
		</div>
	</div>

	<div class="container wrapper">

		<div class="col-xs-3 server-list">
        	<?php
				if (!$loggedIn) {
					include 'templates/login_form.php';
				} else {
					include 'templates/user_panel.php';
				}

				$categories = $db->getCategories();

				echo '<div class="panel panel-default"><div class="panel-heading">Categories</div><ul class="list-group">';

				foreach($categories as $cat) {
					echo '<li class="list-group-item">
							<span class="badge">'.$db->countProductsInCat($cat['cid']).'</span>
							<a href="?category='.$cat['cid'].'">'.$cat['cat_title'].'</a>
						</li>';
				}

				echo '</ul></div>';
			?>
        </div>

<div class="col-xs-9 server-list">
	<?php
		$products = null;
		if (isset($_GET['category'])) {
			$products = $db->getProducts(cleanInt($_GET['category']));
		} else {
			$products = $db->getAllProducts();
		}

		// ✅ Sort products by price after discount (lowest first)
		usort($products, function($a, $b) {
			$priceA = $a['item_price'] - $a['item_discount'];
			$priceB = $b['item_price'] - $b['item_discount'];
			return $priceA <=> $priceB;
		});

		for ($i = 0; $i < count($products); $i++) {
			$product = $products[$i];
			include 'templates/product.php';
		}
	?>
</div>



    </div>

    <?php include 'templates/footer.php'; ?>
</body>
<script type="text/javascript" src="assets/js/jquery-1.11.1.min.js"></script>
<script type="text/javascript" src="assets/js/bootstrap.js"></script>
<script type="text/javascript" src="assets/js/jquery.cookie.js"></script>
<script type="text/javascript" src="assets/js/custom.js"></script>
<script type="text/javascript" src="assets/js/sweetalert.min.js"></script>
</html>
