$pageTitle = 'AlexLuxuryGold — Fine Gold Jewellery & Luxury';
require_once __DIR__ . '/includes/functions.php';
$pdo = getDB();

// Get featured products
$featuredProducts = [];
$categories = [];
if ($pdo) {
    initDatabase();
    $stmt = $pdo->query("SELECT p.*, c.name as cat_name FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.status='active' AND p.featured=1 ORDER BY p.created_at DESC LIMIT 8");
    $featuredProducts = $stmt->fetchAll();
    $categories = $pdo->query("SELECT c.*, COUNT(p.id) as product_count FROM categories c LEFT JOIN products p ON p.category_id = c.id AND p.status='active' GROUP BY c.id ORDER BY product_count DESC")->fetchAll();
}

$categoryIcons = ['rings'=>'💍','necklaces'=>'📿','bracelets'=>'✨','earrings'=>'💎','watches'=>'⌚','pendants'=>'🏅'];
require_once __DIR__ . '/includes/header.php';
?>

<!-- HERO -->
<section class="hero">
  <div class="hero-bg"></div>
  <div class="hero-content">
    <div class="hero-text fade-in">
      <div class="hero-badge">
        <span>✦</span>
        <span>Est. 2008 · New York · GIA Certified</span>
      </div>
      <h1 class="hero-title">
        Where Gold<br>Meets
        <em>Eternity</em>
      </h1>
      <p class="hero-subtitle">
        Discover our curated collection of 24K and 18K gold jewellery, 
        handcrafted by master artisans. Every piece is a testament to 
        timeless luxury, exceptional craftsmanship, and enduring beauty.
      </p>
      <div class="hero-actions">
        <a href="/shop.php" class="btn-gold"><i class="fas fa-gem"></i> Explore Collection</a>
        <a href="/about.php" class="btn-outline-gold">Our Story</a>
      </div>
      <div class="hero-stats">
        <div class="hero-stat">
          <div class="hero-stat-num">2,400+</div>
          <div class="hero-stat-label">Pieces Crafted</div>
        </div>
        <div class="hero-stat">
          <div class="hero-stat-num">15+</div>
          <div class="hero-stat-label">Years Excellence</div>
        </div>
        <div class="hero-stat">
          <div class="hero-stat-num">98%</div>
          <div class="hero-stat-label">Satisfied Clients</div>
        </div>
      </div>
    </div>
    <div class="hero-visual">
      <div class="hero-ring-container">
        <div class="hero-ring-1"></div>
        <div class="hero-ring-2"></div>
        <div class="hero-ring-3"></div>
        <div class="hero-dots">
          <div class="hero-dot" style="top:10%;left:50%;animation-delay:0s"></div>
          <div class="hero-dot" style="top:25%;right:10%;animation-delay:0.7s"></div>
          <div class="hero-dot" style="bottom:20%;left:12%;animation-delay:1.4s"></div>
          <div class="hero-dot" style="bottom:10%;right:30%;animation-delay:2.1s"></div>
        </div>
        <div class="hero-center-gem">💍</div>
      </div>
    </div>
  </div>
</section>

<!-- CATEGORIES -->
<section class="section" style="background: var(--dark); border-top: 1px solid var(--border);">
  <div class="section-inner">
    <div class="section-header">
      <div class="section-tag">Browse</div>
      <h2 class="section-title">Shop by <em>Category</em></h2>
      <div class="section-divider"></div>
    </div>
    <div class="categories-grid stagger">
                              <a href="/shop.php?cat=rings" class="category-card" style="text-decoration:none;">
            <div class="category-icon">💍</div>
            <div class="category-name">Rings</div>
            <div class="category-count">Explore collection</div>
          </a>
                  <a href="/shop.php?cat=necklaces" class="category-card" style="text-decoration:none;">
            <div class="category-icon">📿</div>
            <div class="category-name">Necklaces</div>
            <div class="category-count">Explore collection</div>
          </a>
                  <a href="/shop.php?cat=bracelets" class="category-card" style="text-decoration:none;">
            <div class="category-icon">✨</div>
            <div class="category-name">Bracelets</div>
            <div class="category-count">Explore collection</div>
          </a>
                  <a href="/shop.php?cat=earrings" class="category-card" style="text-decoration:none;">
            <div class="category-icon">💎</div>
            <div class="category-name">Earrings</div>
            <div class="category-count">Explore collection</div>
          </a>
                  <a href="/shop.php?cat=watches" class="category-card" style="text-decoration:none;">
            <div class="category-icon">⌚</div>
            <div class="category-name">Watches</div>
            <div class="category-count">Explore collection</div>
          </a>
                  <a href="/shop.php?cat=pendants" class="category-card" style="text-decoration:none;">
            <div class="category-icon">🏅</div>
            <div class="category-name">Pendants</div>
            <div class="category-count">Explore collection</div>
          </a>
                  </div>
  </div>
</section>

<!-- FEATURED PRODUCTS -->

<!-- FEATURES -->
<section class="section" style="background: var(--dark); border-top: 1px solid var(--border);">
  <div class="section-inner">
    <div class="section-header">
      <div class="section-tag">Why Choose Us</div>
      <h2 class="section-title">The <em>AlexLuxuryGold</em> Promise</h2>
      <div class="section-divider"></div>
    </div>
    <div class="features-grid stagger">
      <div class="feature-item">
        <div class="feature-icon">🏆</div>
        <h3 class="feature-title">Certified Authenticity</h3>
        <p class="feature-desc">Every piece comes with a GIA certificate of authenticity, guaranteeing the purity and quality of your gold jewellery.</p>
      </div>
      <div class="feature-item">
        <div class="feature-icon">✋</div>
        <h3 class="feature-title">Master Craftsmanship</h3>
        <p class="feature-desc">Handcrafted by artisans with over 20 years of experience. Each piece is lovingly made with precision and dedication.</p>
      </div>
      <div class="feature-item">
        <div class="feature-icon">🚚</div>
        <h3 class="feature-title">Insured Delivery</h3>
        <p class="feature-desc">All orders are shipped fully insured with discreet packaging. Free shipping on orders over $500 within the US.</p>
      </div>
      <div class="feature-item">
        <div class="feature-icon">🔄</div>
        <h3 class="feature-title">30-Day Returns</h3>
        <p class="feature-desc">Not satisfied? Return your piece within 30 days for a full refund or exchange. No questions asked.</p>
      </div>
    </div>
  </div>
</section>

<!-- BANNER -->
<section style="background: linear-gradient(135deg, var(--gold-dark) 0%, var(--gold) 50%, var(--gold-dark) 100%); padding: 80px 30px; text-align: center;">
  <div style="max-width:700px;margin:0 auto;">
    <p style="font-size:11px;letter-spacing:4px;text-transform:uppercase;color:rgba(0,0,0,0.6);margin-bottom:16px;">Limited Time Offer</p>
    <h2 style="font-family:var(--font-display);font-size:clamp(36px,5vw,60px);font-weight:300;color:var(--black);line-height:1.15;margin-bottom:20px;">
      Custom Gold Jewellery<br>Made to Your Specifications
    </h2>
    <p style="color:rgba(0,0,0,0.7);font-size:15px;margin-bottom:36px;line-height:1.8;">
      Commission a bespoke piece crafted exclusively for you. Share your vision with our artisans and receive a one-of-a-kind creation.
    </p>
    <a href="/contact.php" style="display:inline-block;background:var(--black);color:var(--gold);padding:16px 40px;font-size:11px;font-weight:700;letter-spacing:3px;text-transform:uppercase;border-radius:4px;text-decoration:none;">
      Request Custom Piece
    </a>
  </div>
</section>

<!-- TESTIMONIALS -->
<section class="section">
  <div class="section-inner">
    <div class="section-header">
      <div class="section-tag">Client Stories</div>
      <h2 class="section-title">What Our <em>Clients Say</em></h2>
      <div class="section-divider"></div>
    </div>
    <div class="testimonials-grid stagger">
      <div class="testimonial-card">
        <div class="testimonial-stars">★★★★★</div>
        <p class="testimonial-text">The 18K gold ring I ordered for my anniversary exceeded every expectation. The craftsmanship is extraordinary and the packaging made it feel even more special.</p>
        <div class="testimonial-author">
          <div class="testimonial-avatar">S</div>
          <div><div class="testimonial-name">Sarah Mitchell</div><div class="testimonial-location">New York, NY</div></div>
        </div>
      </div>
      <div class="testimonial-card">
        <div class="testimonial-stars">★★★★★</div>
        <p class="testimonial-text">I've been a customer for 6 years. The quality is always impeccable and the customer service is second to none. My go-to destination for luxury gold jewellery.</p>
        <div class="testimonial-author">
          <div class="testimonial-avatar">J</div>
          <div><div class="testimonial-name">James Richardson</div><div class="testimonial-location">Beverly Hills, CA</div></div>
        </div>
      </div>
      <div class="testimonial-card">
        <div class="testimonial-stars">★★★★★</div>
        <p class="testimonial-text">The custom necklace they made for my mother's birthday brought her to tears. Truly one-of-a-kind artistry that will be treasured for generations.</p>
        <div class="testimonial-author">
          <div class="testimonial-avatar">A</div>
          <div><div class="testimonial-name">Amelia Johnson</div><div class="testimonial-location">Chicago, IL</div></div>
        </div>
      </div>
    </div>
  </div>
</section>

<!-- NEWSLETTER -->
<section class="newsletter-section">
  <div class="section-tag">Stay Updated</div>
  <h2 class="section-title" style="margin-top:10px;">Join the <em>Inner Circle</em></h2>
  <div class="section-divider"></div>
  <p style="color:var(--text-muted);font-size:14px;max-width:450px;margin:0 auto 20px;line-height:1.8;">
    Subscribe for exclusive access to new collections, private sales, and expert gold care tips.
  </p>
  <form class="newsletter-form" onsubmit="event.preventDefault(); this.innerHTML='<p style=\'color:var(--gold);font-family:var(--font-display);font-size:22px;\'>✦ Welcome to the Inner Circle!</p>'">
    <input class="newsletter-input" type="email" placeholder="Your email address" required>
    <button class="newsletter-btn" type="submit">Subscribe</button>
  </form>
</section>