getConnection(); // Get abandoned carts (carts older than 24 hours with no orders) $query = "SELECT c.*, u.name as user_name, u.phone, p.name as product_name, p.price, p.image, (c.quantity * p.price) as subtotal FROM cart c JOIN users u ON c.user_id = u.id JOIN products p ON c.product_id = p.id WHERE c.created_at < DATE_SUB(NOW(), INTERVAL 24 HOUR) AND c.user_id NOT IN ( SELECT DISTINCT user_id FROM orders WHERE created_at > c.created_at ) ORDER BY c.created_at DESC"; $stmt = $db->prepare($query); $stmt->execute(); $abandoned_carts = $stmt->fetchAll(PDO::FETCH_ASSOC); // Group by user $carts_by_user = []; foreach ($abandoned_carts as $item) { $user_id = $item['user_id']; if (!isset($carts_by_user[$user_id])) { $carts_by_user[$user_id] = [ 'user_name' => $item['user_name'], 'phone' => $item['phone'], 'items' => [], 'total' => 0 ]; } $carts_by_user[$user_id]['items'][] = $item; $carts_by_user[$user_id]['total'] += $item['subtotal']; } } catch (Exception $e) { $error = "خطأ: " . $e->getMessage(); $carts_by_user = []; } ?> السلات المتروكة - Roz Skin

السلات المتروكة

عدد العملاء

عدد المنتجات

القيمة الإجمالية

EGP

$cart): ?>

إجمالي السلة

EGP

<?php echo htmlspecialchars($item['product_name']); ?>

الكمية: × EGP

EGP

لا توجد سلات متروكة

جميع العملاء أكملوا طلباتهم!