LONX — Complete CRM System

Total Customers

—

Registered clients

👥

Active Subscriptions

—

Valid & not expired

✅

Expired Subscriptions

—

Need renewal action

⚠️

Total Debt Amount

—

SAR — unpaid orders

💰

📊 Status Distribution

🏢 Service Provider Distribution

📈 New Customers per Month (2024–2026)

📅 Expiration Schedule (Monthly)

⚡ Subscriptions Expiring Soon (≤ 30 days)

#	Customer	Domain	Expire Date	Days Left	Renewal (SAR)	Phone	Action

🔍

ID	Customer	Domain	Email	Expiry	Days	Renew SAR	Total Debt	Phone	Employee	Contact	Actions

🔍

#	Employee	Title	Email	Phone	Total Orders	Status	Contact	Actions

🔍

#	Partner	Title	Services	Website	Date Added	Employee	Status	Contact	Actions

🔍

🔍

#	Platform	Services	Login	Subscribe	Expiry	Days	Renewal	Employee	Actions

Total Orders

—

Total Revenue

—

SAR receipts

Total Payments

—

SAR outgoing

Uncollected

—

To Be Paid

—

🔍

#	Date & Time	Type	Beneficiary	Details	Amount SAR	Status	Employee	Actions

Total Subscriptions

—

Expired

—

Active (> 30 days)

—

Expiring Soon (≤ 30d)

—

🔍

Customer	Service	Type	Start	Renew Date	Days Left	Qty	Total SAR	Other Debts	Login	Renew	Actions

#	Username / Email	Role	Permissions	Last Login	Status	Actions

prepare($sql); $stmt->execute([$data['name'], $data['company'], $data['amount']]); } elseif ($action === 'save_invoice') { $sql = "INSERT INTO invoices (inv_num, total) VALUES (?, ?)"; $stmt = $pdo->prepare($sql); $stmt->execute([$data['inv_num'], $data['total']]); } elseif ($action === 'save_task') { $sql = "INSERT INTO tasks (task_name, deadline) VALUES (?, ?)"; $stmt = $pdo->prepare($sql); $stmt->execute([$data['task'], $data['date']]); } echo json_encode(['status' => 'success']); } catch (Exception $e) { echo json_encode(['status' => 'error', 'message' => $e->getMessage()]); } } // ثانياً: جلب البيانات لعرضها (GET) if ($method === 'GET' && isset($_GET['type'])) { $type = $_GET['type']; $allowed_tables = ['clients', 'invoices', 'tasks']; if (in_array($type, $allowed_tables)) { $stmt = $pdo->query("SELECT * FROM $type ORDER BY id DESC"); echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC)); } } ?>