// Cart functions
function addToCart($product_id, $quantity = 1) {
    if (!isset($_SESSION['cart'])) {
        $_SESSION['cart'] = array();
    }
    
    // Check if product exists and has stock
    $stmt = $GLOBALS['pdo']->prepare("SELECT * FROM products WHERE id = ? AND status = 'active'");
    $stmt->execute([$product_id]);
    $product = $stmt->fetch();
    
    if (!$product) {
        return false;
    }
    
    // Check stock
    $current_quantity = $_SESSION['cart'][$product_id] ?? 0;
    $new_quantity = $current_quantity + $quantity;
    
    if ($new_quantity > $product['stock_quantity']) {
        return false;
    }
    
    $_SESSION['cart'][$product_id] = $new_quantity;
    return true;
}

function removeFromCart($product_id) {
    if (isset($_SESSION['cart'][$product_id])) {
        unset($_SESSION['cart'][$product_id]);
    }
}

function updateCartQuantity($product_id, $quantity) {
    if ($quantity <= 0) {
        removeFromCart($product_id);
        return;
    }
    
    // Check stock
    $stmt = $GLOBALS['pdo']->prepare("SELECT stock_quantity FROM products WHERE id = ?");
    $stmt->execute([$product_id]);
    $product = $stmt->fetch();
    
    if ($product && $quantity <= $product['stock_quantity']) {
        $_SESSION['cart'][$product_id] = $quantity;
    }
}

function clearCart() {
    $_SESSION['cart'] = array();
}

function getCartItems() {
    if (empty($_SESSION['cart'])) {
        return array();
    }
    
    $product_ids = array_keys($_SESSION['cart']);
    $placeholders = str_repeat('?,', count($product_ids) - 1) . '?';
    
    $stmt = $GLOBALS['pdo']->prepare("
        SELECT p.*, c.name as category_name 
        FROM products p 
        LEFT JOIN categories c ON p.category_id = c.id 
        WHERE p.id IN ($placeholders) AND p.status = 'active'
    ");
    $stmt->execute($product_ids);
    $products = $stmt->fetchAll();
    
    $cart_items = array();
    foreach ($products as $product) {
        $product['quantity'] = $_SESSION['cart'][$product['id']];
        $cart_items[] = $product;
    }
    
    return $cart_items;
}

function getCartTotal() {
    $cart_items = getCartItems();
    $total = 0;
    
    foreach ($cart_items as $item) {
        $total += $item['price'] * $item['quantity'];
    }
    
    return $total;
}

function getCartCount() {
    if (empty($_SESSION['cart'])) {
        return 0;
    }
    
    return array_sum($_SESSION['cart']);
}

function getCartItemCount($product_id) {
    return $_SESSION['cart'][$product_id] ?? 0;
}

// Order functions
function createOrder($customer_data, $shipping_data, $payment_method) {
    $cart_items = getCartItems();
    if (empty($cart_items)) {
        return false;
    }
    
    $pdo = $GLOBALS['pdo'];
    
    try {
        $pdo->beginTransaction();
        
        // Calculate totals
        $subtotal = getCartTotal();
        $shipping_cost = $subtotal >= 500 ? 0 : 29.90;
        $total = $subtotal + $shipping_cost;
        
        // Create order
        $order_number = 'ODS' . date('Ymd') . rand(1000, 9999);
        
        $stmt = $pdo->prepare("
            INSERT INTO orders (
                order_number, customer_name, customer_email, customer_phone,
                shipping_address, shipping_city, shipping_district, shipping_postal_code,
                subtotal, shipping_cost, total, payment_method, status, created_at
            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending', NOW())
        ");
        
        $stmt->execute([
            $order_number,
            $customer_data['name'],
            $customer_data['email'],
            $customer_data['phone'],
            $shipping_data['address'],
            $shipping_data['city'],
            $shipping_data['district'],
            $shipping_data['postal_code'],
            $subtotal,
            $shipping_cost,
            $total,
            $payment_method
        ]);
        
        $order_id = $pdo->lastInsertId();
        
        // Add order items
        $stmt = $pdo->prepare("
            INSERT INTO order_items (order_id, product_id, product_name, product_sku, quantity, price, total)
            VALUES (?, ?, ?, ?, ?, ?, ?)
        ");
        
        foreach ($cart_items as $item) {
            $item_total = $item['price'] * $item['quantity'];
            $stmt->execute([
                $order_id,
                $item['id'],
                $item['name'],
                $item['sku'],
                $item['quantity'],
                $item['price'],
                $item_total
            ]);
            
            // Update stock
            $update_stock = $pdo->prepare("UPDATE products SET stock_quantity = stock_quantity - ? WHERE id = ?");
            $update_stock->execute([$item['quantity'], $item['id']]);
        }
        
        $pdo->commit();
        
        // Clear cart
        clearCart();
        
        return [
            'order_id' => $order_id,
            'order_number' => $order_number,
            'total' => $total
        ];
        
    } catch (Exception $e) {
        $pdo->rollBack();
        error_log("Order creation failed: " . $e->getMessage());
        return false;
    }
}

// Email functions
function sendOrderConfirmationEmail($order_id) {
    // This would integrate with your email service
    // For now, just log the action
    error_log("Order confirmation email should be sent for order ID: " . $order_id);
}

// Utility functions
function formatPrice($price) {
    return number_format($price, 2, ',', '.') . ' TL';
}

function generateOrderNumber() {
    return 'ODS' . date('Ymd') . rand(1000, 9999);
}

function validateEmail($email) {
    return filter_var($email, FILTER_VALIDATE_EMAIL);
}

function validatePhone($phone) {
    // Turkish phone number validation
    $phone = preg_replace('/[^0-9]/', '', $phone);
    return preg_match('/^(5[0-9]{9}|0?5[0-9]{9})$/', $phone);
}

function sanitizeInput($input) {
    return htmlspecialchars(trim($input), ENT_QUOTES, 'UTF-8');
}

function redirectWithMessage($url, $message, $type = 'success') {
    $_SESSION['flash_message'] = $message;
    $_SESSION['flash_type'] = $type;
    header("Location: $url");
    exit;
}

function getFlashMessage() {
    if (isset($_SESSION['flash_message'])) {
        $message = $_SESSION['flash_message'];
        $type = $_SESSION['flash_type'] ?? 'info';
        unset($_SESSION['flash_message'], $_SESSION['flash_type']);
        return ['message' => $message, 'type' => $type];
    }
    return null;
}

<!DOCTYPE html>
<html lang="tr">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Odesan Otomotiv - BMW Yedek Parça</title>
    <link rel="stylesheet" href="assets/css/style.css">
</head>
<body>
    <!-- Header -->
    <header class="header">
        <div class="container">
            <div class="header-top">
                <div class="contact-info">
                    <span>WhatsApp Destek</span>
                    <span>Kargo Takip</span>
                    <span>Bize Ulaşın</span>
                    <span>Yardım</span>
                </div>
            </div>
            
            <div class="header-main">
                <div class="logo">
                    <img src="assets/images/logo.png" alt="Odesan Otomotiv">
                </div>
                
                <div class="search-bar">
                    <input type="text" placeholder="BMW Yedek Parça, Aksesuar, Ara...">
                    <button type="submit">Ara</button>
                </div>
                
                <div class="header-actions">
                    <a href="login.php">Üye Girişi</a>
                    <a href="cart.php">Sepetim</a>
                </div>
            </div>
            
            <nav class="main-nav">
                <ul>
                                            <li><a href="category.php?slug=aksesuarlar">Aksesuarlar</a></li>
                                            <li><a href="category.php?slug=bakim-setleri">Bakım Setleri</a></li>
                                            <li><a href="category.php?slug=bmw-yedek-parca">BMW Yedek Parça</a></li>
                                            <li><a href="category.php?slug=madeni-yag">Madeni Yağ</a></li>
                                        <li><a href="new-products.php">Yeni Ürünler</a></li>
                    <li><a href="campaigns.php">Kampanyalar</a></li>
                </ul>
            </nav>
        </div>
    </header>

    <!-- Main Content -->
    <main class="main-content">
        <!-- Hero Slider -->
        <section class="hero-slider">
            <div class="container">
                <div class="slider">
                    <div class="slide active">
                        <h2>HIZLI TESLİMAT</h2>
                        <p>Saat 15.00'a kadar verilen siparişler aynı gün faturalı olarak kargoya verilir.</p>
                        <a href="#" class="btn">SİPARİŞ VER</a>
                    </div>
                </div>
            </div>
        </section>

        <!-- Featured Products -->
        <section class="featured-products">
            <div class="container">
                <h2>ÇOK SATANLAR</h2>
                <div class="products-grid">
                                            <div class="product-card">
                            <div class="product-image">
                                <img src="https://www.parcamark.com.tr/Uploads/UrunResimleri/buyuk/bmw-e92--lci-e93--lci-onun-onu-camur-9031.jpg" alt="BMW E92 + LCI E93 + LCI Önün Önü Çamurluk Davlumbazı - Sol">
                            </div>
                            <div class="product-info">
                                <h3><a href="product.php?slug=bmw-e92-lci-e93-lci-onun-onu-camurluk-davlumbazi-sol">BMW E92 + LCI E93 + LCI Önün Önü Çamurluk Davlumbazı - Sol</a></h3>
                                <div class="product-price">799,90 TL</div>
                                <button class="add-to-cart" data-product-id="1">Sepete Ekle</button>
                            </div>
                        </div>
                                            <div class="product-card">
                            <div class="product-image">
                                <img src="https://www.parcamark.com.tr/Uploads/UrunResimleri/buyuk/bmw-f10--lci-kurek-bakaliti--m-tech--s-742a.jpg" alt="BMW F10 + LCI Kürek Bakaliti ( M Tech ) - Sağ">
                            </div>
                            <div class="product-info">
                                <h3><a href="product.php?slug=bmw-f10-lci-kurek-bakaliti-m-tech-sag">BMW F10 + LCI Kürek Bakaliti ( M Tech ) - Sağ</a></h3>
                                <div class="product-price">999,90 TL</div>
                                <button class="add-to-cart" data-product-id="2">Sepete Ekle</button>
                            </div>
                        </div>
                                            <div class="product-card">
                            <div class="product-image">
                                <img src="https://www.parcamark.com.tr/Uploads/UrunResimleri/buyuk/bmw-e46-sol-onun-arkasi-davlumbaz---s-827a.jpg" alt="BMW E46 Sol Önün Arkası Davlumbaz - Sedan">
                            </div>
                            <div class="product-info">
                                <h3><a href="product.php?slug=bmw-e46-sol-onun-arkasi-davlumbaz-sedan">BMW E46 Sol Önün Arkası Davlumbaz - Sedan</a></h3>
                                <div class="product-price">749,90 TL</div>
                                <button class="add-to-cart" data-product-id="3">Sepete Ekle</button>
                            </div>
                        </div>
                                    </div>
            </div>
        </section>

        <!-- Service Features -->
        <section class="service-features">
            <div class="container">
                <div class="features-grid">
                    <div class="feature">
                        <h3>HIZLI KARGO</h3>
                        <p>Aynı gün kargo imkanı</p>
                    </div>
                    <div class="feature">
                        <h3>TAKSİT İMKANI</h3>
                        <p>Kredi kartına taksit seçenekleri</p>
                    </div>
                    <div class="feature">
                        <h3>GÜVENLİ ÖDEME</h3>
                        <p>SSL sertifikalı güvenli ödeme</p>
                    </div>
                    <div class="feature">
                        <h3>KOLAY İADE</h3>
                        <p>14 gün içerisinde koşulsuz iade</p>
                    </div>
                </div>
            </div>
        </section>
    </main>

    <!-- Footer -->
    <footer class="footer">
        <div class="container">
            <div class="footer-content">
                <div class="footer-section">
                    <h3>KURUMSAL</h3>
                    <ul>
                        <li><a href="about.php">Hakkımızda</a></li>
                        <li><a href="contact.php">İletişim</a></li>
                        <li><a href="return-policy.php">İade ve Değişim</a></li>
                    </ul>
                </div>
                
                <div class="footer-section">
                    <h3>KATEGORİLER</h3>
                    <ul>
                                                    <li><a href="category.php?slug=aksesuarlar">Aksesuarlar</a></li>
                                                    <li><a href="category.php?slug=bakim-setleri">Bakım Setleri</a></li>
                                                    <li><a href="category.php?slug=bmw-yedek-parca">BMW Yedek Parça</a></li>
                                                    <li><a href="category.php?slug=madeni-yag">Madeni Yağ</a></li>
                                            </ul>
                </div>
                
                <div class="footer-section">
                    <h3>İLETİŞİM</h3>
                    <p>Odesan Otomotiv Sanayi LTD ŞTİ</p>
                    <p>İzmir, Türkiye</p>
                    <p>Tel: 0232 XXX XX XX</p>
                    <p>Email: info@odesan.com.tr</p>
                </div>
            </div>
            
            <div class="footer-bottom">
                <p>&copy; 2025 Odesan Otomotiv. Tüm hakları saklıdır.</p>
            </div>
        </div>
    </footer>

    <script src="assets/js/script.js"></script>
</body>
<script>'undefined'=== typeof _trfq || (window._trfq = []);'undefined'=== typeof _trfd && (window._trfd=[]),_trfd.push({'tccl.baseHost':'secureserver.net'},{'ap':'cpsh-oh'},{'server':'sxb1plzcpnl504039'},{'dcenter':'sxb1'},{'cp_id':'9848921'},{'cp_cache':''},{'cp_cl':'8'}) // Monitoring performance to make your website faster. If you want to opt-out, please contact web hosting support.</script><script src='https://img1.wsimg.com/traffic-assets/js/tccl.min.js'></script></html>