products.php

<?php
$page_title = 'Products';
require_once 'includes/header.php';

// Clear selection if coming from browse products (no topic or category parameter)
if (!isset($_GET['topic']) && !isset($_GET['category'])) {
    unset($_SESSION['selected_topic']);
}

// Handle topic selection
if (isset($_GET['topic'])) {
    $_SESSION['selected_topic'] = $_GET['topic'];
}

// Handle category parameter from URL (for direct links from navbar)
if (isset($_GET['category'])) {
    $category_param = $_GET['category'];
    if (stripos($category_param, 'GTA') !== false || stripos($category_param, 'San Andreas') !== false) {
        $_SESSION['selected_topic'] = 'gta-sa';
    } elseif (stripos($category_param, 'Roblox') !== false) {
        $_SESSION['selected_topic'] = 'roblox';
    }
}

// Get selected topic (default: gta-sa)
$selected_topic = $_SESSION['selected_topic'] ?? 'gta-sa';

// Get search from URL (from navbar search)
$search = isset($_GET['search']) ? sanitize_input($_GET['search']) : '';

// Build query with game_category filter (exclude soft deleted products)
$query = "SELECT p.* FROM products p WHERE 1=1 AND p.is_sold = 0 AND p.deleted_at IS NULL";
$params = [];

// Filter by game_category only if selected
if ($selected_topic === 'gta-sa') {
    $query .= " AND p.game_category = 'gta-sa'";
} elseif ($selected_topic === 'roblox') {
    $query .= " AND p.game_category = 'roblox'";
}
// If $selected_topic is null, show all products

if ($search) {
    $query .= " AND (p.title LIKE ? OR p.description LIKE ? OR p.author LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

$query .= " ORDER BY p.created_at DESC";

$stmt = $pdo->prepare($query);
$stmt->execute($params);
$products = $stmt->fetchAll();

// Count total products
$total_products = count($products);
?>

<style>
/* ============================================
   PRODUCTS PAGE - DIAGONAL HERO DESIGN
   ============================================ */

/* Hero Section with Side-by-Side Diagonal */
.products-hero {
    position: relative;
    min-height: 350px;
    overflow: hidden;
    margin-bottom: 0;
    display: flex;
}

/* Make page background extend to footer */
#main-wrapper {
    background: var(--bg-secondary) !important;
}

body {
    background: var(--bg-secondary) !important;
}

/* Left: Solid Background + Text */
.hero-left {
    width: 50%;
    background: var(--bg-primary);
    display: flex;
    align-items: center;
    justify-content: flex-end;
    padding: 0 4rem 0 3rem;
    position: relative;
    z-index: 5;
}

.hero-text {
    position: relative;
    z-index: 2;
    max-width: 500px;
}

.hero-text h1 {
    font-size: 2.2rem;
    font-weight: 700;
    margin-bottom: 0.75rem;
    line-height: 1.1;
    color: var(--text-primary);
}

.hero-text h1 .gradient-text {
    color: var(--accent-primary);
}

.hero-text p {
    font-size: 0.9rem;
    color: var(--text-secondary);
    line-height: 1.6;
    margin-bottom: 0.75rem;
}

.hero-text .casual-text {
    font-size: 0.85rem;
    color: var(--text-muted);
    line-height: 1.5;
    margin-bottom: 1.25rem;
}

.hero-cta {
    display: flex;
    align-items: center;
    gap: 0.75rem;
    font-size: 0.9rem;
    color: var(--accent-primary);
    font-weight: 600;
}

.hero-cta svg {
    width: 20px;
    height: 20px;
    animation: bounceRight 1.5s ease-in-out infinite;
}

@keyframes bounceRight {
    0%, 100% {
        transform: translateX(0);
    }
    50% {
        transform: translateX(8px);
    }
}

/* Right: Category Images Side by Side with Overlap */
.hero-right {
    flex: 1;
    position: relative;
    display: flex;
    overflow: hidden;
}

/* Individual Category Image - Side by Side, No Overlap */
.hero-category-item {
    position: relative;
    flex: 1;
    height: 100%;
    cursor: pointer;
    transition: filter 0.4s ease, opacity 0.4s ease, transform 0.4s ease;
    text-decoration: none;
    overflow: hidden;
}

/* Left Category (GTA SA) - Diagonal cut on right edge */
.hero-category-left {
    clip-path: polygon(0 0, 100% 0, 88% 100%, 0 100%);
}

/* Right Category (Roblox) - Diagonal cut on left edge */
.hero-category-right {
    clip-path: polygon(12% 0, 100% 0, 100% 100%, 0 100%);
    margin-left: -6%;
}

/* Category Image */
.hero-category-item img {
    width: 100%;
    height: 100%;
    object-fit: cover;
    object-position: center;
    transition: filter 0.4s ease, opacity 0.4s ease;
}

/* Active State - Full color, on top */
.hero-category-item.active {
    z-index: 3;
}

.hero-category-item.active img {
    filter: grayscale(0%) brightness(1);
    opacity: 1;
}

/* Inactive State - Grayscale, dimmed, behind */
.hero-category-item.inactive {
    z-index: 2;
}

.hero-category-item.inactive img {
    filter: grayscale(100%) brightness(0.4);
    opacity: 0.6;
}

/* No Selection State - Both images grayscale */
.hero-category-item.no-selection {
    z-index: 2;
}

.hero-category-item.no-selection img {
    filter: grayscale(100%) brightness(0.5);
    opacity: 0.7;
}

/* Full Gradient Overlay - From center (50%) to right edge (100%) */
.hero-right::before {
    content: '';
    position: absolute;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    background: linear-gradient(
        to right,
        var(--bg-primary) 0%,
        transparent 100%
    );
    z-index: 4;
    pointer-events: none;
}

/* Category Label */
.hero-category-label {
    position: absolute;
    bottom: 2rem;
    right: 2rem;
    background: rgba(0, 0, 0, 0.8);
    backdrop-filter: blur(10px);
    padding: 0.75rem 1.5rem;
    border-radius: var(--radius-md);
    border: 1px solid var(--border-color);
    z-index: 2;
    transition: all 0.4s ease;
}

.hero-category-item.active .hero-category-label {
    border-color: var(--accent-primary);
    box-shadow: 0 0 20px rgba(250, 92, 92, 0.5);
}

.hero-category-label-name {
    font-size: 1rem;
    font-weight: 700;
    color: var(--text-primary);
}

/* Products Header - itch.io Style */
.products-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 2.5rem;
    flex-wrap: wrap;
    gap: 1.5rem;
}

.products-count {
    font-size: 1.1rem;
    color: var(--text-secondary);
    font-weight: 500;
}

.products-count strong {
    color: var(--accent-primary);
    font-weight: 700;
    font-size: 1.3rem;
}

.topic-indicator {
    display: inline-flex;
    align-items: center;
    gap: 0.75rem;
    background: var(--bg-secondary);
    color: var(--text-primary);
    padding: 0.75rem 1.5rem;
    border-radius: var(--radius-lg);
    font-weight: 600;
    font-size: 0.95rem;
    border: 1px solid var(--border-color);
}

.topic-indicator svg {
    width: 20px;
    height: 20px;
    color: var(--accent-primary);
}

/* Product Grid - Masonry Style (Independent Heights) */
.products-grid {
    display: flex;
    flex-wrap: wrap;
    gap: 1.25rem;
    max-width: 100%;
}

.product-card {
    background: transparent;
    border-radius: 0;
    overflow: visible;
    border: none;
    display: flex;
    flex-direction: column;
    width: calc(20% - 1rem); /* 5 columns */
    flex-shrink: 0;
}

.product-image-container {
    position: relative;
    width: 100%;
    padding-top: 133%;
    overflow: hidden;
    background: var(--bg-secondary);
    border-radius: 0;
    margin-bottom: 0.75rem;
    cursor: pointer;
}

.product-image {
    position: absolute;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    object-fit: cover;
}

.product-image-main {
    opacity: 1;
}

.product-image-hover {
    opacity: 0;
}

/* Hover effect only for products with second image */
.product-image-container.has-hover-image:hover .product-image-main {
    opacity: 0;
}

.product-image-container.has-hover-image:hover .product-image-hover {
    opacity: 1;
}

.product-image-placeholder {
    position: absolute;
    top: 0;
    left: 0;
    width: 100%;
    height: 100%;
    display: flex;
    align-items: center;
    justify-content: center;
    background: var(--bg-secondary);
}

.product-content {
    padding: 0;
    flex: 1;
    display: flex;
    flex-direction: column;
    gap: 0.15rem;
}

.product-price {
    font-size: 0.95rem;
    font-weight: 500;
    color: var(--text-primary);
    margin: 0;
}

.product-author {
    font-size: 0.75rem;
    color: var(--text-muted);
    margin: 0;
    order: 3;
}

.product-description {
    font-size: 0.8rem;
    color: var(--text-secondary);
    line-height: 1.3;
    margin: 0;
    display: -webkit-box;
    -webkit-line-clamp: 2;
    -webkit-box-orient: vertical;
    overflow: hidden;
    order: 2;
}

.product-link {
    text-decoration: none;
    color: inherit;
    display: flex;
    flex-direction: column;
    height: 100%;
}

/* Empty State - itch.io Style */
.empty-state {
    text-align: center;
    padding: 4rem 2rem;
    background: var(--bg-secondary);
    border-radius: var(--radius-lg);
    border: 2px dashed var(--border-color);
}

.empty-state svg {
    width: 80px;
    height: 80px;
    color: var(--text-muted);
    margin-bottom: 1.5rem;
    opacity: 0.5;
}

.empty-state h3 {
    font-size: 1.5rem;
    font-weight: 700;
    color: var(--text-primary);
    margin-bottom: 0.75rem;
}

.empty-state p {
    color: var(--text-secondary);
    font-size: 0.95rem;
    margin-bottom: 1.5rem;
    line-height: 1.6;
    max-width: 600px;
    margin-left: auto;
    margin-right: auto;
}

/* Search Result Info - itch.io Style */
.search-info {
    background: linear-gradient(135deg, rgba(52, 152, 219, 0.1) 0%, rgba(52, 152, 219, 0.05) 100%);
    border: 1px solid var(--color-info);
    border-radius: var(--radius-lg);
    padding: 1.25rem 1.75rem;
    margin-bottom: 2.5rem;
    display: flex;
    justify-content: space-between;
    align-items: center;
   
}

.search-info-text {
    color: var(--color-info);
    font-weight: 600;
    font-size: 1.05rem;
}

.search-info-text strong {
    background: var(--accent-primary);
    -webkit-background-clip: text;
    -webkit-text-fill-color: transparent;
    background-clip: text;
    font-weight: 700;
}

.clear-search {
    padding: 0.65rem 1.25rem;
    background: transparent;
    color: var(--accent-primary);
    border: 1px solid var(--accent-primary);
    border-radius: var(--radius-md);
    font-weight: 700;
    font-size: 0.9rem;
    cursor: pointer;
    transition: all var(--transition-base);
    text-decoration: none;
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    text-transform: uppercase;
    letter-spacing: 0.3px;
}

.clear-search:hover {
    background: var(--accent-primary);
    color: #ffffff;
    transform: translateY(-2px);
   
}

/* Responsive */
@media (max-width: 1024px) {
    .products-hero-grid {
        grid-template-columns: 1fr;
        gap: 2.5rem;
    }
    
    .hero-gradient {
        display: none;
    }
    
    .topic-selector {
        flex-direction: row;
        gap: 1.25rem;
    }
    
    .topic-card {
        width: 100%;
        height: 130px;
    }
    
    .hero-content h1 {
        font-size: 2.5rem;
    }
    
    .product-card {
        width: calc(25% - 1rem); /* 4 columns on tablet */
    }
}

@media (max-width: 768px) {
    .products-grid {
        gap: 1.5rem;
    }
    
    .product-card {
        width: calc(50% - 0.75rem); /* 2 columns on mobile */
    }
}

@media (max-width: 480px) {
    .product-card {
        width: 100%; /* 1 column on small mobile */
    }
}
</style>

<!-- Hero Section: Solid + Side-by-Side Images with Diagonal -->
<div class="products-hero">
    <!-- Left: Solid Background + Text -->
    <div class="hero-left">
        <div class="hero-text">
            <h1>
                <span class="gradient-text">Cari Asset yang</span><br>
                <span>Kamu Butuhin?</span>
            </h1>
            <p>
                Browse koleksi lengkap kami! Dari karakter, kendaraan, sampe custom request - 
                semuanya ada di sini. Pilih kategori game favoritmu dan temukan asset yang pas buat project kamu.
            </p>
            <p class="casual-text">
                Tinggal pilih dan langsung checkout! Semua asset berkualitas tinggi dan siap pakai.
                Gak perlu ribet, semua udah diatur buat kamu.
            </p>
            <div class="hero-cta">
                <span>Pilih kategori di samping</span>
                <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M13 7l5 5m0 0l-5 5m5-5H6" />
                </svg>
            </div>
        </div>
    </div>
    
    <!-- Right: Category Images Side by Side -->
    <div class="hero-right">
        <!-- GTA San Andreas (Left Image) -->
        <a href="?topic=gta-sa" class="hero-category-item hero-category-left <?php echo $selected_topic === 'gta-sa' ? 'active' : 'inactive'; ?>">
            <img src="<?php echo SITE_URL; ?>/assets/images/hero-gta-sa.jpg" alt="GTA San Andreas">
        </a>
        
        <!-- Roblox (Right Image) -->
        <a href="?topic=roblox" class="hero-category-item hero-category-right <?php echo $selected_topic === 'roblox' ? 'active' : 'inactive'; ?>">
            <img src="<?php echo SITE_URL; ?>/assets/images/hero-roblox.jpg" alt="Roblox">
        </a>
    </div>
</div>

<section class="section" style="padding-top: 3rem; padding-bottom: 0; background: var(--bg-secondary);">
    <div class="container">
        <!-- Search Result Info -->
        <?php if ($search): ?>
            <div class="search-info">
                <div class="search-info-text">
                    Search results for "<strong><?php echo htmlspecialchars($search); ?></strong>" - <?php echo $total_products; ?> product(s) found
                </div>
                <a href="products.php" class="clear-search">
                    <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" style="width: 16px; height: 16px;">
                        <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M6 18L18 6M6 6l12 12" />
                    </svg>
                    Clear Search
                </a>
            </div>
        <?php endif; ?>
        
        <!-- Products Header -->
        <div class="products-header" style="margin-bottom: 2.5rem;">
            <!-- Header removed for cleaner look -->
        </div>
        
        <!-- Products Grid -->
        <?php if (empty($products)): ?>
            <div class="empty-state">
                <svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor">
                    <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M20 13V6a2 2 0 00-2-2H6a2 2 0 00-2 2v7m16 0v5a2 2 0 01-2 2H6a2 2 0 01-2-2v-5m16 0h-2.586a1 1 0 00-.707.293l-2.414 2.414a1 1 0 01-.707.293h-3.172a1 1 0 01-.707-.293l-2.414-2.414A1 1 0 006.586 13H4" />
                </svg>
                <h3>No Products Found</h3>
                <p>We couldn't find any products matching your search. Try different keywords or browse all products.</p>
                <?php if ($search): ?>
                    <a href="products.php" class="btn btn-primary">View All Products</a>
                <?php endif; ?>
            </div>
        <?php else: ?>
            <div class="products-grid">
                <?php foreach ($products as $product): ?>
                    <?php 
                    // Get additional images
                    $additional_images = [];
                    if (!empty($product['additional_images'])) {
                        $additional_images = json_decode($product['additional_images'], true);
                    }
                    $second_image = !empty($additional_images) ? $additional_images[0] : null;
                    ?>
                    <div class="product-card">
                        <a href="product.php?slug=<?php echo htmlspecialchars($product['slug']); ?>" style="text-decoration: none;">
                            <div class="product-image-container <?php echo $second_image ? 'has-hover-image' : ''; ?>">
                                <?php if ($product['image']): ?>
                                    <img src="<?php echo UPLOAD_URL . htmlspecialchars($product['image']); ?>" 
                                         alt="<?php echo htmlspecialchars($product['title']); ?>" 
                                         class="product-image product-image-main">
                                    <?php if ($second_image): ?>
                                        <img src="<?php echo UPLOAD_URL . htmlspecialchars($second_image); ?>" 
                                             alt="<?php echo htmlspecialchars($product['title']); ?>" 
                                             class="product-image product-image-hover">
                                    <?php endif; ?>
                                <?php else: ?>
                                    <div class="product-image-placeholder">
                                        <svg style="width: 48px; height: 48px; color: #4a4a4a;" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor">
                                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="1.5" d="M4 16l4.586-4.586a2 2 0 012.828 0L16 16m-2-2l1.586-1.586a2 2 0 012.828 0L20 14m-6-6h.01M6 20h12a2 2 0 002-2V6a2 2 0 00-2-2H6a2 2 0 00-2 2v12a2 2 0 002 2z" />
                                        </svg>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </a>
                        
                        <a href="product.php?slug=<?php echo htmlspecialchars($product['slug']); ?>" class="product-link">
                            <div class="product-content">
                                <?php if ($product['game_category'] === 'roblox'): ?>
                                    <?php
                                    // Calculate total price (shirt + pants)
                                    $total_robux = ($product['price_robux_shirt'] ?? 0) + ($product['price_robux_pants'] ?? 0);
                                    ?>
                                    <div class="product-price" style="display: flex; align-items: center; gap: 0.4rem;">
                                        <img src="https://upload.wikimedia.org/wikipedia/commons/0/09/Robux_2019_Logo_Black.svg" 
                                             alt="Robux" 
                                             style="width: 18px; height: 18px; flex-shrink: 0; filter: invert(1); display: block;">
                                        <span style="line-height: 1;"><?php echo number_format($total_robux); ?></span>
                                    </div>
                                <?php else: ?>
                                    <div class="product-price"><?php echo format_price($product['price']); ?></div>
                                <?php endif; ?>
                                
                                <p class="product-description"><?php echo htmlspecialchars($product['title']); ?></p>
                                
                                <?php if ($product['author']): ?>
                                    <p class="product-author"><?php echo htmlspecialchars($product['author']); ?></p>
                                <?php endif; ?>
                            </div>
                        </a>
                    </div>
                <?php endforeach; ?>
            </div>
        <?php endif; ?>
    </div>
</section>

</div><!-- End #main-wrapper -->
</body>
</html>