getConnection(); // Create shipping_companies table if not exists $create_table = "CREATE TABLE IF NOT EXISTS shipping_companies ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, coverage ENUM('all', 'internal_only', 'gov_only') DEFAULT 'all', default_rate_internal DECIMAL(10, 2) DEFAULT 0, default_rate_gov DECIMAL(10, 2) DEFAULT 0, op_name VARCHAR(255), op_phone VARCHAR(20), is_active BOOLEAN DEFAULT TRUE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci"; $db->exec($create_table); // Get all shipping companies $query = "SELECT * FROM shipping_companies ORDER BY name"; $stmt = $db->prepare($query); $stmt->execute(); $companies = $stmt->fetchAll(PDO::FETCH_ASSOC); // Get orders ready for shipping (pending or processing) $query = "SELECT COUNT(*) as count FROM orders WHERE status IN ('pending', 'processing')"; $stmt = $db->prepare($query); $stmt->execute(); $ready_orders = $stmt->fetch(PDO::FETCH_ASSOC)['count']; } catch (Exception $e) { $error = "خطأ: " . $e->getMessage(); $companies = []; $ready_orders = 0; } $message = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { try { if (isset($_POST['add_company'])) { $name = $_POST['name']; $coverage = $_POST['coverage']; $rate_internal = $_POST['default_rate_internal']; $rate_gov = $_POST['default_rate_gov']; $op_name = $_POST['op_name']; $op_phone = $_POST['op_phone']; $query = "INSERT INTO shipping_companies (name, coverage, default_rate_internal, default_rate_gov, op_name, op_phone) VALUES (?, ?, ?, ?, ?, ?)"; $stmt = $db->prepare($query); $stmt->execute([$name, $coverage, $rate_internal, $rate_gov, $op_name, $op_phone]); header("Location: index.php?added=1"); exit; } elseif (isset($_POST['toggle_company'])) { $id = $_POST['company_id']; $query = "UPDATE shipping_companies SET is_active = NOT is_active WHERE id = ?"; $stmt = $db->prepare($query); $stmt->execute([$id]); header("Location: index.php?updated=1"); exit; } elseif (isset($_POST['delete_company'])) { $id = $_POST['company_id']; $query = "DELETE FROM shipping_companies WHERE id = ?"; $stmt = $db->prepare($query); $stmt->execute([$id]); header("Location: index.php?deleted=1"); exit; } } catch (Exception $e) { $message = "خطأ: " . $e->getMessage(); } } if (isset($_GET['added'])) { $message = 'تم إضافة شركة الشحن بنجاح!'; } elseif (isset($_GET['updated'])) { $message = 'تم تحديث شركة الشحن بنجاح!'; } elseif (isset($_GET['deleted'])) { $message = 'تم حذف شركة الشحن بنجاح!'; } ?> إدارة الشحن - Roz Skin

إدارة الشحن

تحديث الحالة المانيفستات

$c['is_active'])); ?>

شركات الشحن

الشركات النشطة

طلبات جاهزة للشحن

0): ?> إنشاء مانيفست

نشط معطل
التغطية:
شحن داخلي: EGP
شحن محافظات: EGP

مدير العمليات:

لا توجد شركات شحن

ابدأ بإضافة شركات الشحن التي تتعامل معها