prepare("UPDATE orders SET status = :status WHERE order_code = :order_code"); $stmt->execute([':status' => $newStatus, ':order_code' => $code]); $message = "የትዕዛዝ ቁጥር #$code ሁኔታ ወደ '$newStatus' ተቀይሯል!"; } } // Fetch orders with optional search $search = trim($_GET['q'] ?? ''); if ($search) { $stmt = $pdo->prepare(" SELECT * FROM orders WHERE order_code LIKE :q OR phone LIKE :q OR pickup LIKE :q OR dropoff LIKE :q ORDER BY id DESC "); $stmt->execute([':q' => "%$search%"]); } else { $stmt = $pdo->query("SELECT * FROM orders ORDER BY id DESC LIMIT 150"); } $orders = $stmt->fetchAll(); // Statistics $totalCount = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn(); $pendingCount = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'Pending'")->fetchColumn(); $inTransitCount = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'In Transit' OR status = 'Picked Up'")->fetchColumn(); $deliveredCount = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'Delivered'")->fetchColumn(); ?> Yellow Delivery — Admin Dashboard

Yellow Delivery — Admin Control

Shashemene HQ • Office No 12

🌐 ዋና ድረ-ገጽ (Main Site) 🔍 ትራኪንግ (Tracking) 📦 ትዕዛዝ መስጫ (Orders)

✅

ጠቅላላ ትዕዛዞች (Total)

አዲስ ያልተነሱ (Pending)

በመንገድ ላይ (In Transit)

የደረሱ (Delivered)

Tracking Code	አገልግሎት	መነሻ → መድረሻ	ስልክ ቁጥር	ዋጋ (Price)	ማስታወሻ	ቀን & ሰዓት	ሁኔታ (Status)	አስተዳድር
ምንም የተመዘገበ ትዕዛዝ አልተገኘም (No orders found).
		📍 መነሻ: 🏁 መድረሻ:	📞