// OnlineShopReviews.com - Homepage

// Force error display for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Check current working directory
echo "<div style='background: purple; color: white; padding: 10px; margin: 10px; border: 2px solid black;'>";
echo "<strong>Current Working Directory:</strong> " . getcwd() . "<br>";
echo "<strong>Script Filename:</strong> " . __FILE__ . "<br>";
echo "<strong>Real Path:</strong> " . realpath(__FILE__) . "<br>";
echo "</div>\n";

require_once 'includes/config/app.php';

// Debug: Show database connection info
echo "<!-- DEBUG INFO:\n";
echo "ENVIRONMENT: " . ENVIRONMENT . "\n";
echo "DB_HOST: " . DB_HOST . "\n";
echo "DB_NAME: " . DB_NAME . "\n";
echo "DB_USERNAME: " . DB_USERNAME . "\n";
echo "-->\n";

// Test PHP execution
echo "<div style='background: yellow; color: black; padding: 20px; margin: 20px; border: 2px solid red;'>";
echo "<h2>🚨 PHP IS WORKING!</h2>";
echo "<p>If you can see this message, PHP is executing properly.</p>";
echo "<p>PHP Version: " . PHP_VERSION . "</p>";
echo "<p>Current Time: " . date('Y-m-d H:i:s') . "</p>";
echo "<p>Server Software: " . $_SERVER['SERVER_SOFTWARE'] . "</p>";
echo "<p>Document Root: " . $_SERVER['DOCUMENT_ROOT'] . "</p>";
echo "</div>";

// Check if files exist and show their status
echo "<div style='background: lightblue; color: black; padding: 15px; margin: 20px; border: 2px solid blue;'>";
echo "<h3>📁 FILE STATUS CHECK:</h3>";
$checkFiles = [
    'includes/config/database.php',
    'includes/core/Database.php',
    'includes/core/Auth.php',
    'includes/core/Session_simple.php'
];

foreach ($checkFiles as $file) {
    $exists = file_exists($file);
    $size = $exists ? filesize($file) : 0;
    echo "<div style='margin: 5px 0;'>";
    echo $exists ? "✅" : "❌";
    echo " $file - " . ($exists ? number_format($size) . " bytes" : "NOT FOUND");
    echo "</div>";
}
echo "</div>";
require_once 'includes/core/Database.php';
require_once 'includes/core/Auth.php';
require_once 'includes/core/Session_simple.php';

// Initialize systems
$auth = Auth::getInstance();
$session = SessionSimple::getInstance();

// Page data
$pageTitle = "OnlineShopReviews - Find Trustworthy Online Shops";
$currentUser = null;

// Load real statistics
try {
    $db = Database::getInstance();
    echo "<div style='background: lightgreen; color: black; padding: 10px; margin: 10px; border: 1px solid green;'>✅ Database connection successful</div>\n";

    // Test simple query first
    $testResult = $db->fetchOne("SELECT 1 as test");
    echo "<div style='background: lightcyan; color: black; padding: 10px; margin: 10px; border: 1px solid teal;'>🧪 Simple query test: " . json_encode($testResult) . "</div>\n";

    $statsResult = $db->fetchOne(
        "SELECT
            (SELECT COUNT(*) FROM shops WHERE verification_status != 'suspended') as total_shops,
            (SELECT COUNT(*) FROM reviews WHERE status = 'active') as total_reviews,
            (SELECT COUNT(*) FROM users WHERE status = 'active') as total_users"
    );
    echo "<div style='background: lightblue; color: black; padding: 10px; margin: 10px; border: 1px solid blue;'>📊 Stats query result: " . json_encode($statsResult) . "</div>\n";

    $stats = $statsResult ?: ['total_shops' => 0, 'total_reviews' => 0, 'total_users' => 0];
    echo "<div style='background: lightyellow; color: black; padding: 10px; margin: 10px; border: 1px solid orange;'>📈 Final stats: " . json_encode($stats) . "</div>\n";

} catch (Exception $e) {
    echo "<div style='background: pink; color: black; padding: 10px; margin: 10px; border: 1px solid red;'>❌ Database error: " . htmlspecialchars($e->getMessage()) . "</div>\n";
    echo "<div style='background: pink; color: black; padding: 10px; margin: 10px; border: 1px solid red;'>❌ Error code: " . $e->getCode() . "</div>\n";
    $stats = ['total_shops' => 0, 'total_reviews' => 0, 'total_users' => 0];
}

// Load featured shops
try {
    $featuredShops = $db->fetchAll(
        "SELECT s.id, s.name, s.slug, s.logo_url, s.average_rating, s.review_count
         FROM shops s
         WHERE s.verification_status IN ('verified', 'claimed')
         ORDER BY s.average_rating DESC, s.review_count DESC
         LIMIT 6"
    );
    echo "<div style='background: lightcyan; color: black; padding: 10px; margin: 10px; border: 1px solid teal;'>🏪 Featured shops loaded: " . count($featuredShops) . " shops</div>\n";
} catch (Exception $e) {
    echo "<div style='background: pink; color: black; padding: 10px; margin: 10px; border: 1px solid red;'>❌ Featured shops error: " . htmlspecialchars($e->getMessage()) . "</div>\n";
    $featuredShops = [];
}

// Load recent reviews
try {
    $recentReviews = $db->fetchAll(
        "SELECT r.id, r.title, r.rating, r.created_at,
                u.username, u.profile_image,
                s.name as shop_name, s.slug as shop_slug
         FROM reviews r
         JOIN users u ON r.user_id = u.id
         JOIN shops s ON r.shop_id = s.id
         WHERE r.status = 'active'
         ORDER BY r.created_at DESC
         LIMIT 5"
    );
    echo "<div style='background: lavender; color: black; padding: 10px; margin: 10px; border: 1px solid purple;'>📝 Recent reviews loaded: " . count($recentReviews) . " reviews</div>\n";
} catch (Exception $e) {
    echo "<div style='background: pink; color: black; padding: 10px; margin: 10px; border: 1px solid red;'>❌ Recent reviews error: " . htmlspecialchars($e->getMessage()) . "</div>\n";
    $recentReviews = [];
}

// Load categories
try {
    $categories = $db->fetchAll(
        "SELECT c.id, c.name, c.slug, c.icon,
                COUNT(sc.shop_id) as shop_count
         FROM categories c
         LEFT JOIN shop_categories sc ON c.id = sc.category_id
         LEFT JOIN shops s ON sc.shop_id = s.id AND s.verification_status != 'suspended'
         WHERE c.is_active = 1
         GROUP BY c.id
         ORDER BY c.sort_order, c.name
         LIMIT 8"
    );
    echo "<div style='background: lightgray; color: black; padding: 10px; margin: 10px; border: 1px solid gray;'>📂 Categories loaded: " . count($categories) . " categories</div>\n";
} catch (Exception $e) {
    echo "<div style='background: pink; color: black; padding: 10px; margin: 10px; border: 1px solid red;'>❌ Categories error: " . htmlspecialchars($e->getMessage()) . "</div>\n";
    $categories = [];
}

// Template variables
$templateVars = [
    'pageTitle' => $pageTitle,
    'currentUser' => $currentUser,
    'stats' => $stats,
    'featuredShops' => $featuredShops,
    'recentReviews' => $recentReviews,
    'categories' => $categories
];
?>

<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title></title>
    <meta name="description" content="Find trustworthy online shops through honest reviews and ratings. Join our community of shoppers sharing real experiences.">
    <meta name="keywords" content="online shopping reviews, e-commerce ratings, trustworthy shops, scam prevention">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <!-- Bootstrap Icons -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.8.1/font/bootstrap-icons.css" rel="stylesheet">

    <style>
        .hero-section {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            min-height: 60vh;
        }
        .feature-card {
            transition: transform 0.3s ease, box-shadow 0.3s ease;
            border: none;
            border-radius: 15px;
        }
        .feature-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 10px 30px rgba(0,0,0,0.1);
        }
        .stat-card {
            background: rgba(255,255,255,0.1);
            border-radius: 10px;
            padding: 20px;
            text-align: center;
            backdrop-filter: blur(10px);
        }
        .navbar-brand {
            font-weight: 700;
            font-size: 1.5rem;
        }
        .btn-custom {
            border-radius: 25px;
            padding: 12px 30px;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }
    </style>
</head>
<body>
    <!-- Navigation -->
    <nav class="navbar navbar-expand-lg navbar-dark bg-primary shadow">
        <div class="container">
            <a class="navbar-brand" href="#">
                🏪 OnlineShopReviews
            </a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse" id="navbarNav">
                <ul class="navbar-nav ms-auto">
                    <li class="nav-item">
                        <a class="nav-link active" href="#">Home</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#">Shops</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#">Reviews</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="#">Categories</a>
                    </li>
                    <li class="nav-item ms-2">
                        <a class="btn btn-outline-light btn-sm" href="#">Login</a>
                    </li>
                    <li class="nav-item ms-2">
                        <a class="btn btn-light btn-sm" href="#">Sign Up</a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>

    <!-- Hero Section -->
    <section class="hero-section d-flex align-items-center">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-lg-6">
                    <h1 class="display-4 fw-bold mb-3">
                        Find Trustworthy<br>
                        <span class="text-warning">Online Shops</span>
                    </h1>
                    <p class="lead mb-4 opacity-90">
                        Read honest reviews from real customers, discover hidden gems,
                        and avoid scams. Join our community of 8,500+ shoppers.
                    </p>
                    <!-- Debug Panel -->
                    <div style="background: rgba(255,255,255,0.95); color: black; padding: 15px; margin: 20px 0; border-radius: 10px; border: 2px solid #007bff;">
                        <h4 style="color: #007bff; margin-top: 0;">🔍 DEBUG PANEL</h4>
                        <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(150px, 1fr)); gap: 10px; margin-top: 10px;">
                            <div><strong>Shops:</strong> 0</div>
                            <div><strong>Reviews:</strong> 0</div>
                            <div><strong>Users:</strong> 0</div>
                            <div><strong>Featured:</strong>