
&lt;?php
// Check if installed
if (!file_exists(__DIR__ . '/install.lock')) {
    header('Location: install/index.php');
    exit;
}

require 'includes/config.php';

// Get ads
$stmt = $pdo-&gt;query("SELECT * FROM ads ORDER BY created_at DESC");
$ads = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);

// Get products
$stmt = $pdo-&gt;query("SELECT p.*, s.name as stall_name FROM products p JOIN stalls s ON p.stall_id = s.id ORDER BY p.created_at DESC");
$products = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);
?&gt;

&lt;!DOCTYPE html&gt;
&lt;html lang="en"&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt;meta name="viewport" content="width=device-width, initial-scale=1.0"&gt;
    &lt;title&gt;KOMPRA - Your Local E-Commerce Platform&lt;/title&gt;
    &lt;link rel="stylesheet" href="assets/style.css"&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;header&gt;
        &lt;nav&gt;
            &lt;div class="logo"&gt;KOMPRA&lt;/div&gt;
            &lt;ul&gt;
                &lt;?php if (isLoggedIn()): ?&gt;
                    &lt;li&gt;&lt;a href="&lt;?php echo BASE_URL; ?&gt;/&lt;?php echo $_SESSION['user_type']; ?&gt;/dashboard.php"&gt;Dashboard&lt;/a&gt;&lt;/li&gt;
                    &lt;li&gt;&lt;a href="&lt;?php echo BASE_URL; ?&gt;/logout.php"&gt;Logout&lt;/a&gt;&lt;/li&gt;
                &lt;?php else: ?&gt;
                    &lt;li&gt;&lt;a href="&lt;?php echo BASE_URL; ?&gt;/login.php"&gt;Login&lt;/a&gt;&lt;/li&gt;
                    &lt;li&gt;&lt;a href="&lt;?php echo BASE_URL; ?&gt;/register.php"&gt;Register&lt;/a&gt;&lt;/li&gt;
                &lt;?php endif; ?&gt;
            &lt;/ul&gt;
        &lt;/nav&gt;
    &lt;/header&gt;

    &lt;main&gt;
        &lt;!-- Ads Section --&gt;
        &lt;?php if ($ads): ?&gt;
            &lt;div class="container" style="margin-bottom: 2rem;"&gt;
                &lt;h2&gt;Latest Promotions&lt;/h2&gt;
                &lt;div class="grid"&gt;
                    &lt;?php foreach ($ads as $ad): ?&gt;
                        &lt;div class="card"&gt;
                            &lt;h3&gt;&lt;?php echo htmlspecialchars($ad['title']); ?&gt;&lt;/h3&gt;
                            &lt;p&gt;&lt;?php echo htmlspecialchars($ad['content']); ?&gt;&lt;/p&gt;
                        &lt;/div&gt;
                    &lt;?php endforeach; ?&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;?php endif; ?&gt;

        &lt;!-- Products Section --&gt;
        &lt;div class="container"&gt;
            &lt;h2&gt;Available Products&lt;/h2&gt;
            &lt;div class="grid"&gt;
                &lt;?php foreach ($products as $product): ?&gt;
                    &lt;div class="card"&gt;
                        &lt;h3&gt;&lt;?php echo htmlspecialchars($product['name']); ?&gt;&lt;/h3&gt;
                        &lt;p&gt;Stall: &lt;?php echo htmlspecialchars($product['stall_name']); ?&gt;&lt;/p&gt;
                        &lt;p&gt;&lt;?php echo htmlspecialchars($product['description']); ?&gt;&lt;/p&gt;
                        &lt;p style="color: var(--primary-green); font-weight: bold; font-size: 1.2rem;"&gt;
                            ₱&lt;?php echo number_format($product['price'], 2); ?&gt;
                        &lt;/p&gt;
                        &lt;p&gt;Stock: &lt;?php echo $product['stock']; ?&gt;&lt;/p&gt;
                        &lt;?php if (isLoggedIn() &amp;&amp; $_SESSION['user_type'] == 'customer'): ?&gt;
                            &lt;a href="&lt;?php echo BASE_URL; ?&gt;/customer/add_to_cart.php?product_id=&lt;?php echo $product['id']; ?&gt;" class="btn btn-primary"&gt;Add to Cart&lt;/a&gt;
                        &lt;?php endif; ?&gt;
                    &lt;/div&gt;
                &lt;?php endforeach; ?&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/main&gt;

    &lt;footer&gt;
        &lt;p&gt;&amp;copy; 2026 KOMPRA. All rights reserved.&lt;/p&gt;
    &lt;/footer&gt;
&lt;/body&gt;
&lt;/html&gt;