getConnection();
// جلب جميع المانيفستات
$query = "SELECT sm.*, sc.name as company_name,
(SELECT COUNT(*) FROM manifest_orders WHERE manifest_id = sm.id) as orders_count
FROM shipping_manifests sm
LEFT JOIN shipping_companies sc ON sm.shipping_company_id = sc.id
ORDER BY sm.created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$manifests = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
قائمة المانيفستات