اختبار المانيفست";
$manifest_id = $_GET['id'] ?? 0;
if (!$manifest_id) {
echo "الرجاء إضافة ?id=X في الرابط
";
// عرض المانيفستات المتاحة
try {
$database = new Database();
$db = $database->getConnection();
$stmt = $db->query("SELECT id, manifest_number FROM shipping_manifests ORDER BY id DESC LIMIT 5");
$manifests = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!empty($manifests)) {
echo "المانيفستات المتاحة:
";
} else {
echo "لا توجد مانيفستات
";
}
} catch (Exception $e) {
echo "خطأ: " . $e->getMessage() . "
";
}
exit;
}
try {
$database = new Database();
$db = $database->getConnection();
echo "1. جلب بيانات المانيفست #$manifest_id
";
$query = "SELECT sm.*, sc.name as company_name, sc.op_phone as company_phone
FROM shipping_manifests sm
LEFT JOIN shipping_companies sc ON sm.shipping_company_id = sc.id
WHERE sm.id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$manifest_id]);
$manifest = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$manifest) {
die("المانيفست غير موجود!
");
}
echo "";
print_r($manifest);
echo "";
echo "2. جلب الطلبات
";
$query = "SELECT o.*, CONCAT(o.first_name, ' ', o.last_name) as customer_name
FROM manifest_orders mo
JOIN orders o ON mo.order_id = o.id
WHERE mo.manifest_id = ?
ORDER BY o.id";
$stmt = $db->prepare($query);
$stmt->execute([$manifest_id]);
$orders = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo "عدد الطلبات: " . count($orders) . "
";
if (!empty($orders)) {
echo "";
print_r($orders);
echo "";
}
echo "
";
echo "✅ البيانات صحيحة!
";
echo "فتح صفحة الطباعة
";
} catch (Exception $e) {
echo "خطأ: " . $e->getMessage() . "
";
echo "" . $e->getTraceAsString() . "
";
}