connect_error) { die("Connection failed: " . $conn->connect_error); } // Function to display client data function displayClientData($client_id, $conn) { // Get client basic info $client_query = "SELECT * FROM clients WHERE client_id = ?"; $stmt = $conn->prepare($client_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $client_result = $stmt->get_result(); if ($client_result->num_rows == 0) { echo "

Client not found.

"; return; } $client = $client_result->fetch_assoc(); // Display client info echo "

Client Information

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Client ID	" . $client['client_id'] . "
Name	" . htmlspecialchars($client['name']) . "
Email	" . htmlspecialchars($client['email']) . "
Username	" . htmlspecialchars($client['username']) . "
Telephone	" . htmlspecialchars($client['telephone']) . "
Current Balance	" . $client['balance'] . "
Total Spent	" . $client['spent'] . "
Register Date	" . $client['register_date'] . "

"; // Get payment data $payment_query = "SELECT * FROM payments WHERE client_id = ? ORDER BY payment_create_date DESC"; $stmt = $conn->prepare($payment_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $payment_result = $stmt->get_result(); $total_payments = 0; $payment_count = $payment_result->num_rows; echo "

Payment History (Total: $payment_count)

"; if ($payment_count > 0) { echo ""; echo ""; while ($payment = $payment_result->fetch_assoc()) { $total_payments += $payment['payment_amount']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Payment ID	Amount	Method	Status	Date	Transaction ID
" . $payment['payment_id'] . "	" . $payment['payment_amount'] . "	" . $payment['payment_method'] . "	" . $payment['payment_status'] . "	" . $payment['payment_create_date'] . "	" . htmlspecialchars($payment['t_id']) . "

"; } else { echo "

No payment records found.

"; } // Get order data with service info $order_query = "SELECT o.*, s.service_name FROM orders o LEFT JOIN services s ON o.service_id = s.service_id WHERE o.client_id = ? ORDER BY o.order_create DESC"; $stmt = $conn->prepare($order_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $order_result = $stmt->get_result(); $total_orders = 0; $total_refunded = 0; $total_order_charge = 0; $total_api_charge = 0; $order_count = $order_result->num_rows; echo "

Order History (Total: $order_count)

"; if ($order_count > 0) { echo ""; echo ""; while ($order = $order_result->fetch_assoc()) { $total_order_charge += $order['order_charge']; $total_api_charge += $order['api_charge']; if ($order['refunded'] == 1) { $total_refunded += $order['refunded_amount']; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Order ID	Service	Quantity	Charge	API Charge	Status	Remains	Refunded	Refund Amt	Date
" . $order['order_id'] . "	" . htmlspecialchars($order['service_name']) . "	" . $order['order_quantity'] . "	" . $order['order_charge'] . "	" . $order['api_charge'] . "	" . $order['order_status'] . "	" . $order['order_remains'] . "	" . ($order['refunded'] == 1 ? 'Yes' : 'No') . "	" . $order['refunded_amount'] . "	" . $order['order_create'] . "

"; } else { echo "

No order records found.

"; } // Display calculations echo "

Financial Summary

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Total Payments Added	" . $total_payments . "
Total Order Charges	" . $total_order_charge . "
Total API Charges	" . $total_api_charge . "
Total Refunded Amount	" . $total_refunded . "
Current Balance	" . $client['balance'] . "
Total Spent	" . $client['spent'] . "

"; // Form to update balance and spent echo "

Update Client Balance

New Balance
New Spent

"; echo ""; } // Function to update client balance function updateClientBalance($client_id, $new_balance, $new_spent, $conn) { $update_query = "UPDATE clients SET balance = ?, spent = ? WHERE client_id = ?"; $stmt = $conn->prepare($update_query); $stmt->bind_param("ddi", $new_balance, $new_spent, $client_id); if ($stmt->execute()) { echo "

Client balance updated successfully.

"; } else { echo "

Error updating client balance: " . $conn->error . "

"; } } // Main program logic if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['update'])) { $client_id = $_POST['client_id']; $new_balance = $_POST['new_balance']; $new_spent = $_POST['new_spent']; updateClientBalance($client_id, $new_balance, $new_spent, $conn); displayClientData($client_id, $conn); } elseif (isset($_POST['search'])) { $client_id = $_POST['client_id']; displayClientData($client_id, $conn); } } else { // Display search form echo "

Client Data Management

"; echo ""; } $conn->close(); ?> connect_error) { die("Connection failed: " . $conn->connect_error); } // Set UTF-8 encoding $conn->set_charset("utf8mb4"); // Function to sanitize input function sanitizeInput($data) { return htmlspecialchars(strip_tags(trim($data))); } // Function to display and edit client data function manageClientData($client_id, $conn) { // Check if we're updating client info if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['update_client'])) { updateClientInfo($client_id, $conn); } // Check if we're updating balance if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['update_balance'])) { updateClientBalance($client_id, $conn); } // Check if we're adding a payment if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['add_payment'])) { addPayment($client_id, $conn); } // Check if we're refunding an order if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['process_refund'])) { processRefund($client_id, $conn); } // Get client basic info $client_query = "SELECT * FROM clients WHERE client_id = ?"; $stmt = $conn->prepare($client_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $client_result = $stmt->get_result(); if ($client_result->num_rows == 0) { echo "

Client not found.

"; return; } $client = $client_result->fetch_assoc(); // Display client info in editable form echo "

"; echo "

Client Information

"; echo ""; echo "

"; // Close client-container // Financial summary displayFinancialSummary($client_id, $conn, $client); // Payment management displayPaymentSection($client_id, $conn); // Order management displayOrderSection($client_id, $conn); } // Function to update client information function updateClientInfo($client_id, $conn) { $name = sanitizeInput($_POST['name']); $email = sanitizeInput($_POST['email']); $username = sanitizeInput($_POST['username']); $telephone = sanitizeInput($_POST['telephone']); $balance = floatval($_POST['balance']); $spent = floatval($_POST['spent']); $debit_limit = floatval($_POST['debit_limit']); $update_query = "UPDATE clients SET name = ?, email = ?, username = ?, telephone = ?, balance = ?, spent = ?, debit_limit = ? WHERE client_id = ?"; $stmt = $conn->prepare($update_query); $stmt->bind_param("ssssdddi", $name, $email, $username, $telephone, $balance, $spent, $debit_limit, $client_id); if ($stmt->execute()) { echo "

Client information updated successfully.

"; } else { echo "

Error updating client information: " . $conn->error . "

"; } } // Function to display financial summary function displayFinancialSummary($client_id, $conn, $client) { // Get payment totals $payment_query = "SELECT SUM(payment_amount) as total_payments, COUNT(*) as payment_count FROM payments WHERE client_id = ? AND payment_status = '2'"; $stmt = $conn->prepare($payment_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $payment_result = $stmt->get_result()->fetch_assoc(); // Get order totals $order_query = "SELECT SUM(order_charge) as total_order_charge, SUM(api_charge) as total_api_charge, SUM(CASE WHEN refunded = 1 THEN refunded_amount ELSE 0 END) as total_refunded, COUNT(*) as order_count FROM orders WHERE client_id = ?"; $stmt = $conn->prepare($order_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $order_result = $stmt->get_result()->fetch_assoc(); echo "

"; echo "

Financial Summary

"; echo "

Payments

"; echo "

Total Payments: " . number_format($payment_result['total_payments'] ?? 0, 5) . "

"; echo "

Payment Count: " . $payment_result['payment_count'] . "

"; echo "

Orders

"; echo "

Total Charges: " . number_format($order_result['total_order_charge'] ?? 0, 5) . "

"; echo "

API Charges: " . number_format($order_result['total_api_charge'] ?? 0, 5) . "

"; echo "

Order Count: " . $order_result['order_count'] . "

"; echo "

Refunds

"; echo "

Total Refunded: " . number_format($order_result['total_refunded'] ?? 0, 5) . "

"; echo "

Current Status

"; echo "

Current Balance: " . number_format($client['balance'], 5) . "

"; echo "

Total Spent: " . number_format($client['spent'], 5) . "

"; echo "

Available Credit: " . number_format($client['balance'] + $client['debit_limit'], 5) . "

"; echo "

"; // Close summary-grid // Quick balance adjustment form echo ""; echo "

"; // Close financial-summary } // Function to update client balance function updateClientBalance($client_id, $conn) { $action = $_POST['balance_action']; $amount = floatval($_POST['balance_amount']); // Get current balance $query = "SELECT balance FROM clients WHERE client_id = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("i", $client_id); $stmt->execute(); $current_balance = $stmt->get_result()->fetch_assoc()['balance']; // Calculate new balance switch ($action) { case 'add': $new_balance = $current_balance + $amount; break; case 'subtract': $new_balance = $current_balance - $amount; break; case 'set': $new_balance = $amount; break; default: $new_balance = $current_balance; } // Update balance $update_query = "UPDATE clients SET balance = ? WHERE client_id = ?"; $stmt = $conn->prepare($update_query); $stmt->bind_param("di", $new_balance, $client_id); if ($stmt->execute()) { echo "

Balance updated successfully. New balance: " . number_format($new_balance, 5) . "

"; // Record the transaction if not setting exact amount if ($action != 'set') { $payment_query = "INSERT INTO payments ( client_id, client_balance, payment_amount, payment_method, payment_status, payment_mode, payment_create_date, payment_update_date, payment_ip ) VALUES (?, ?, ?, 9, 2, 'Manual', NOW(), NOW(), ?)"; $payment_amount = ($action == 'add') ? $amount : -$amount; $ip = $_SERVER['REMOTE_ADDR']; $stmt = $conn->prepare($payment_query); $stmt->bind_param("idds", $client_id, $new_balance, $payment_amount, $ip); $stmt->execute(); } } else { echo "

Error updating balance: " . $conn->error . "

"; } } // Function to display payment section function displayPaymentSection($client_id, $conn) { echo "

"; echo "

Payment Management

"; // Add payment form echo "

"; echo ""; echo "

"; // Payment history $payment_query = "SELECT * FROM payments WHERE client_id = ? ORDER BY payment_create_date DESC LIMIT 50"; $stmt = $conn->prepare($payment_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $payment_result = $stmt->get_result(); echo "

Recent Payments (Last 50)

"; if ($payment_result->num_rows > 0) { echo "

"; echo ""; while ($payment = $payment_result->fetch_assoc()) { $status_class = ''; if ($payment['payment_status'] == '2') $status_class = 'status-completed'; elseif ($payment['payment_status'] == '3') $status_class = 'status-cancelled'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

ID	Date	Amount	Method	Status	Txn ID	Notes
" . $payment['payment_id'] . "	" . $payment['payment_create_date'] . "	" . number_format($payment['payment_amount'], 5) . "	" . getPaymentMethodName($payment['payment_method']) . "	" . getPaymentStatusName($payment['payment_status']) . "	" . htmlspecialchars($payment['t_id']) . "	" . htmlspecialchars($payment['payment_note']) . "

"; } else { echo "

No payment records found.

"; } echo "

"; // Close payment-section } // Function to add a payment function addPayment($client_id, $conn) { $amount = floatval($_POST['payment_amount']); $method = intval($_POST['payment_method']); $t_id = sanitizeInput($_POST['t_id']); $note = sanitizeInput($_POST['payment_note']); $ip = $_SERVER['REMOTE_ADDR']; // Get current balance $query = "SELECT balance FROM clients WHERE client_id = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("i", $client_id); $stmt->execute(); $current_balance = $stmt->get_result()->fetch_assoc()['balance']; $new_balance = $current_balance + $amount; // Insert payment record $payment_query = "INSERT INTO payments ( client_id, client_balance, payment_amount, payment_method, payment_status, payment_note, payment_mode, payment_create_date, payment_update_date, payment_ip, t_id ) VALUES (?, ?, ?, ?, 2, ?, 'Manual', NOW(), NOW(), ?, ?)"; $stmt = $conn->prepare($payment_query); $stmt->bind_param("iddiiss", $client_id, $new_balance, $amount, $method, $note, $ip, $t_id); if ($stmt->execute()) { // Update client balance $update_query = "UPDATE clients SET balance = ? WHERE client_id = ?"; $stmt = $conn->prepare($update_query); $stmt->bind_param("di", $new_balance, $client_id); if ($stmt->execute()) { echo "

Payment added successfully. New balance: " . number_format($new_balance, 5) . "

"; } else { echo "

Payment recorded but failed to update client balance: " . $conn->error . "

"; } } else { echo "

Error adding payment: " . $conn->error . "

"; } } // Function to display order section function displayOrderSection($client_id, $conn) { echo "

"; echo "

Order Management

"; // Order filter form echo ""; // Build order query based on filters $status_filter = isset($_GET['order_status']) ? $_GET['order_status'] : ''; $search_term = isset($_GET['search_term']) ? $_GET['search_term'] : ''; $order_query = "SELECT o.*, s.service_name FROM orders o LEFT JOIN services s ON o.service_id = s.service_id WHERE o.client_id = ?"; $params = array($client_id); $types = "i"; if (!empty($status_filter)) { $order_query .= " AND o.order_status = ?"; $params[] = $status_filter; $types .= "s"; } if (!empty($search_term)) { $order_query .= " AND (s.service_name LIKE ? OR o.order_id = ?)"; $params[] = "%$search_term%"; $params[] = $search_term; $types .= "si"; } $order_query .= " ORDER BY o.order_create DESC LIMIT 100"; $stmt = $conn->prepare($order_query); $stmt->bind_param($types, ...$params); $stmt->execute(); $order_result = $stmt->get_result(); if ($order_result->num_rows > 0) { echo "

"; echo ""; while ($order = $order_result->fetch_assoc()) { $status_class = 'status-' . strtolower($order['order_status']); $refunded = $order['refunded'] == 1 ? 'Yes' : 'No'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

ID	Service	Quantity	Charge	Status	Remains	Refunded	Date	Actions
" . $order['order_id'] . "	" . htmlspecialchars($order['service_name']) . "	" . $order['order_quantity'] . "	" . number_format($order['order_charge'], 5) . "	" . $order['order_status'] . "	" . $order['order_remains'] . "	" . $refunded . "	" . $order['order_create'] . "	"; // Refund button for non-refunded orders if ($order['refunded'] == 0 && in_array($order['order_status'], ['completed', 'partial'])) { echo ""; } echo "

"; } else { echo "

No order records found.

"; } // Refund modal (hidden by default) echo ""; echo "

"; // Close order-section } // Function to process refund function processRefund($client_id, $conn) { $order_id = intval($_POST['order_id']); $refund_amount = floatval($_POST['refund_amount']); $refund_reason = sanitizeInput($_POST['refund_reason']); // Get order details $order_query = "SELECT * FROM orders WHERE order_id = ? AND client_id = ?"; $stmt = $conn->prepare($order_query); $stmt->bind_param("ii", $order_id, $client_id); $stmt->execute(); $order = $stmt->get_result()->fetch_assoc(); if (!$order) { echo "

Order not found or doesn't belong to this client.

"; return; } if ($order['refunded'] == 1) { echo "

This order has already been refunded.

"; return; } if ($refund_amount <= 0 || $refund_amount > $order['order_charge']) { echo "

Invalid refund amount.

"; return; } // Get current client balance $client_query = "SELECT balance FROM clients WHERE client_id = ?"; $stmt = $conn->prepare($client_query); $stmt->bind_param("i", $client_id); $stmt->execute(); $current_balance = $stmt->get_result()->fetch_assoc()['balance']; $new_balance = $current_balance + $refund_amount; // Start transaction $conn->begin_transaction(); try { // Update order as refunded $update_order = "UPDATE orders SET refunded = 1, refunded_amount = ? WHERE order_id = ?"; $stmt = $conn->prepare($update_order); $stmt->bind_param("di", $refund_amount, $order_id); $stmt->execute(); // Update client balance $update_client = "UPDATE clients SET balance = ? WHERE client_id = ?"; $stmt = $conn->prepare($update_client); $stmt->bind_param("di", $new_balance, $client_id); $stmt->execute(); // Record refund transaction $payment_query = "INSERT INTO payments ( client_id, client_balance, payment_amount, payment_method, payment_status, payment_note, payment_mode, payment_create_date, payment_update_date, payment_ip ) VALUES (?, ?, ?, 5, 2, ?, 'Manual', NOW(), NOW(), ?)"; $ip = $_SERVER['REMOTE_ADDR']; $note = "Refund for order #$order_id. Reason: $refund_reason"; $stmt = $conn->prepare($payment_query); $stmt->bind_param("idsss", $client_id, $new_balance, $refund_amount, $note, $ip); $stmt->execute(); // Commit transaction $conn->commit(); echo "

Refund processed successfully. New balance: " . number_format($new_balance, 5) . "

"; } catch (Exception $e) { $conn->rollback(); echo "

Error processing refund: " . $e->getMessage() . "

"; } } // Helper functions function getPaymentMethodName($method_id) { $methods = [ 1 => 'Bank Transfer', 2 => 'Credit Card', 3 => 'PayPal', 4 => 'Crypto', 5 => 'Manual Adjustment', 9 => 'System Adjustment' ]; return $methods[$method_id] ?? 'Unknown'; } function getPaymentStatusName($status_id) { $statuses = [ '1' => 'Pending', '2' => 'Completed', '3' => 'Cancelled' ]; return $statuses[$status_id] ?? 'Unknown'; } // Main program logic ?> Client Management System

Client Management System

"; echo "

"; echo "Enter Client ID:"; echo ""; echo ""; echo "

"; echo ""; } ?>

close(); ?> HTML; } // Check authentication checkAuth(); // Connect to database $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); if ($conn->connect_error) { die("

Connection failed: " . $conn->connect_error . "

"); } // Set UTF-8 encoding $conn->set_charset("utf8mb4"); // Function to sanitize input function sanitizeInput($data) { return htmlspecialchars(strip_tags(trim($data))); } // Function to get client by ID, username, or email function getClientByIdentifier($identifier, $conn) { $identifier = $conn->real_escape_string($identifier); $query = "SELECT * FROM clients WHERE client_id = '$identifier' OR username = '$identifier' OR email LIKE '%$identifier%' LIMIT 1"; $result = $conn->query($query); return $result->num_rows > 0 ? $result->fetch_assoc() : null; } // Function to update client information function updateClientInfo($client_id, $conn) { $fields = [ 'name', 'email', 'username', 'telephone', 'balance', 'spent', 'debit_limit', 'admin_type', 'client_type', 'lang', 'currency' ]; $updates = []; foreach ($fields as $field) { if (isset($_POST[$field])) { $value = $conn->real_escape_string($_POST[$field]); $updates[] = "$field = '$value'"; } } if (!empty($updates)) { $update_query = "UPDATE clients SET " . implode(", ", $updates) . " WHERE client_id = $client_id"; return $conn->query($update_query); } return false; } // Function to add payment function addPayment($client_id, $conn) { $amount = floatval($_POST['payment_amount']); $method = intval($_POST['payment_method']); $t_id = $conn->real_escape_string($_POST['t_id']); $note = $conn->real_escape_string($_POST['payment_note']); $ip = $_SERVER['REMOTE_ADDR']; // Get current balance $query = "SELECT balance FROM clients WHERE client_id = $client_id"; $result = $conn->query($query); $current_balance = $result->fetch_assoc()['balance']; $new_balance = $current_balance + $amount; // Insert payment record $payment_query = "INSERT INTO payments ( client_id, client_balance, payment_amount, payment_method, payment_status, payment_note, payment_mode, payment_create_date, payment_update_date, payment_ip, t_id ) VALUES ( $client_id, $new_balance, $amount, $method, 2, '$note', 'Manual', NOW(), NOW(), '$ip', '$t_id' )"; if ($conn->query($payment_query)) { // Update client balance $update_query = "UPDATE clients SET balance = $new_balance WHERE client_id = $client_id"; $conn->query($update_query); return true; } return false; } // Function to process refund function processRefund($client_id, $conn) { $order_id = intval($_POST['order_id']); $refund_amount = floatval($_POST['refund_amount']); $refund_reason = $conn->real_escape_string($_POST['refund_reason']); // Get order details $order_query = "SELECT * FROM orders WHERE order_id = $order_id AND client_id = $client_id"; $order_result = $conn->query($order_query); $order = $order_result->fetch_assoc(); if (!$order || $order['refunded'] == 1) { return false; } // Get current client balance $client_query = "SELECT balance FROM clients WHERE client_id = $client_id"; $client_result = $conn->query($client_query); $current_balance = $client_result->fetch_assoc()['balance']; $new_balance = $current_balance + $refund_amount; // Start transaction $conn->begin_transaction(); try { // Update order as refunded $update_order = "UPDATE orders SET refunded = 1, refunded_amount = $refund_amount WHERE order_id = $order_id"; $conn->query($update_order); // Update client balance $update_client = "UPDATE clients SET balance = $new_balance WHERE client_id = $client_id"; $conn->query($update_client); // Record refund transaction $note = "Refund for order #$order_id. Reason: $refund_reason"; $payment_query = "INSERT INTO payments ( client_id, client_balance, payment_amount, payment_method, payment_status, payment_note, payment_mode, payment_create_date, payment_update_date, payment_ip ) VALUES ( $client_id, $new_balance, $refund_amount, 5, 2, '$note', 'Manual', NOW(), NOW(), '$ip' )"; $conn->query($payment_query); // Commit transaction $conn->commit(); return true; } catch (Exception $e) { $conn->rollback(); return false; } } // Function to get payment methods function getPaymentMethods() { return [ 1 => 'Bank Transfer', 2 => 'Credit Card', 3 => 'PayPal', 4 => 'Cryptocurrency', 5 => 'Manual Adjustment', 6 => 'Skrill', 7 => 'Neteller', 8 => 'WebMoney', 9 => 'System Adjustment' ]; } // Function to get order statuses function getOrderStatuses() { return [ 'pending' => 'Pending', 'inprogress' => 'In Progress', 'completed' => 'Completed', 'partial' => 'Partial', 'refunded' => 'Refunded', 'canceled' => 'Canceled' ]; } // Main processing $client = null; $success_message = ''; $error_message = ''; // Handle form submissions if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['search_client'])) { $identifier = $_POST['client_identifier']; $client = getClientByIdentifier($identifier, $conn); if (!$client) { $error_message = "No client found with that ID, username, or email."; } } elseif (isset($_POST['update_client'])) { $client_id = intval($_POST['client_id']); if (updateClientInfo($client_id, $conn)) { $success_message = "Client information updated successfully!"; $client = getClientByIdentifier($client_id, $conn); } else { $error_message = "Failed to update client information."; } } elseif (isset($_POST['add_payment'])) { $client_id = intval($_POST['client_id']); if (addPayment($client_id, $conn)) { $success_message = "Payment added successfully!"; $client = getClientByIdentifier($client_id, $conn); } else { $error_message = "Failed to add payment."; } } elseif (isset($_POST['process_refund'])) { $client_id = intval($_POST['client_id']); if (processRefund($client_id, $conn)) { $success_message = "Refund processed successfully!"; $client = getClientByIdentifier($client_id, $conn); } else { $error_message = "Failed to process refund."; } } } // Get payment history for client $payment_history = []; if ($client) { $client_id = $client['client_id']; $payment_query = "SELECT * FROM payments WHERE client_id = $client_id ORDER BY payment_create_date DESC LIMIT 50"; $payment_result = $conn->query($payment_query); while ($row = $payment_result->fetch_assoc()) { $payment_history[] = $row; } } // Get order history for client $order_history = []; if ($client) { $order_query = "SELECT o.*, s.service_name FROM orders o LEFT JOIN services s ON o.service_id = s.service_id WHERE o.client_id = $client_id ORDER BY o.order_create DESC LIMIT 100"; $order_result = $conn->query($order_query); while ($row = $order_result->fetch_assoc()) { $order_history[] = $row; } } // Calculate financial summary $financial_summary = [ 'total_payments' => 0, 'total_orders' => 0, 'total_refunds' => 0, 'total_spent' => 0 ]; if ($client) { // Total payments $query = "SELECT SUM(payment_amount) as total FROM payments WHERE client_id = $client_id AND payment_status = 2"; $result = $conn->query($query); $financial_summary['total_payments'] = $result->fetch_assoc()['total'] ?? 0; // Total orders $query = "SELECT SUM(order_charge) as total FROM orders WHERE client_id = $client_id"; $result = $conn->query($query); $financial_summary['total_orders'] = $result->fetch_assoc()['total'] ?? 0; // Total refunds $query = "SELECT SUM(refunded_amount) as total FROM orders WHERE client_id = $client_id AND refunded = 1"; $result = $conn->query($query); $financial_summary['total_refunds'] = $result->fetch_assoc()['total'] ?? 0; // Total spent $financial_summary['total_spent'] = $client['spent']; } ?> Ultimate Client Management System

Client Management System

Basic Info

Name

Username

Telephone

Admin Type

Client Type

Language

Currency

Financial Info

Balance:

Spent:

Debit Limit:

Total Payments

Total Orders

Total Refunds

Total Spent

Payment Actions

Add Payment

Process Refund

Amount

Payment Method

Transaction ID

Notes

Order ID

Refund Amount

Refund Reason

Payment History

ID	Date	Amount	Method	Balance	Status	Notes
					Completed

Order History

ID	Date	Service	Charge	Status	Refunded
					Yes () No

PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false ]); } catch (PDOException $e) { die("Database Connection Failed: " . $e->getMessage()); } // Authentication check function isAuthenticated() { return isset($_SESSION['authenticated']) && $_SESSION['authenticated'] === true; } // Handle login if (isset($_POST['login'])) { if ($_POST['password'] === LOCK_PASSWORD) { $_SESSION['authenticated'] = true; header('Location: ' . $_SERVER['PHP_SELF']); exit; } else { $login_error = 'Invalid password!'; } } // Handle logout if (isset($_GET['logout'])) { session_destroy(); header('Location: ' . $_SERVER['PHP_SELF']); exit; } // Handle AJAX requests if (isset($_POST['action']) && isAuthenticated()) { header('Content-Type: application/json'); switch ($_POST['action']) { case 'search_client': $search = $_POST['search']; $stmt = $pdo->prepare("SELECT * FROM clients WHERE client_id = ? OR username LIKE ? OR email LIKE ? LIMIT 1"); $stmt->execute([$search, "%$search%", "%$search%"]); $client = $stmt->fetch(); if ($client) { // Get payment history $stmt = $pdo->prepare("SELECT * FROM payments WHERE client_id = ? ORDER BY payment_create_date DESC"); $stmt->execute([$client['client_id']]); $payments = $stmt->fetchAll(); // Get order history $stmt = $pdo->prepare("SELECT o.*, s.service_name FROM orders o LEFT JOIN services s ON o.service_id = s.service_id WHERE o.client_id = ? ORDER BY o.order_create DESC"); $stmt->execute([$client['client_id']]); $orders = $stmt->fetchAll(); // Calculate totals $total_payments = array_sum(array_column($payments, 'payment_amount')); $total_orders_charge = array_sum(array_column($orders, 'order_charge')); $total_refunded = array_sum(array_column($orders, 'refunded_amount')); $pending_orders = count(array_filter($orders, function($o) { return $o['order_status'] === 'pending'; })); $completed_orders = count(array_filter($orders, function($o) { return $o['order_status'] === 'completed'; })); echo json_encode([ 'success' => true, 'client' => $client, 'payments' => $payments, 'orders' => $orders, 'totals' => [ 'total_payments' => $total_payments, 'total_orders_charge' => $total_orders_charge, 'total_refunded' => $total_refunded, 'pending_orders' => $pending_orders, 'completed_orders' => $completed_orders, 'available_balance' => $total_payments - $total_orders_charge ] ]); } else { echo json_encode(['success' => false, 'message' => 'Client not found']); } break; case 'update_client': $client_id = $_POST['client_id']; $field = $_POST['field']; $value = $_POST['value']; $allowed_fields = ['name', 'email', 'username', 'telephone', 'balance', 'spent', 'debit_limit']; if (in_array($field, $allowed_fields)) { $stmt = $pdo->prepare("UPDATE clients SET $field = ? WHERE client_id = ?"); $result = $stmt->execute([$value, $client_id]); echo json_encode(['success' => $result]); } else { echo json_encode(['success' => false, 'message' => 'Invalid field']); } break; case 'update_order': $order_id = $_POST['order_id']; $field = $_POST['field']; $value = $_POST['value']; $allowed_fields = ['order_status', 'order_quantity', 'order_charge', 'refunded_amount', 'order_url']; if (in_array($field, $allowed_fields)) { $stmt = $pdo->prepare("UPDATE orders SET $field = ? WHERE order_id = ?"); $result = $stmt->execute([$value, $order_id]); echo json_encode(['success' => $result]); } else { echo json_encode(['success' => false, 'message' => 'Invalid field']); } break; case 'get_services': $stmt = $pdo->prepare("SELECT * FROM services ORDER BY service_name"); $stmt->execute(); $services = $stmt->fetchAll(); echo json_encode(['success' => true, 'services' => $services]); break; case 'update_service': $service_id = $_POST['service_id']; $field = $_POST['field']; $value = $_POST['value']; $allowed_fields = ['service_name', 'service_price', 'service_min', 'service_max', 'service_description']; if (in_array($field, $allowed_fields)) { $stmt = $pdo->prepare("UPDATE services SET $field = ? WHERE service_id = ?"); $result = $stmt->execute([$value, $service_id]); echo json_encode(['success' => $result]); } else { echo json_encode(['success' => false, 'message' => 'Invalid field']); } break; case 'get_all_clients': $page = isset($_POST['page']) ? (int)$_POST['page'] : 1; $limit = 20; $offset = ($page - 1) * $limit; $filter = isset($_POST['filter']) ? $_POST['filter'] : ''; $where = ''; $params = []; if ($filter) { $where = "WHERE name LIKE ? OR email LIKE ? OR username LIKE ?"; $params = ["%$filter%", "%$filter%", "%$filter%"]; } $stmt = $pdo->prepare("SELECT * FROM clients $where ORDER BY register_date DESC LIMIT $limit OFFSET $offset"); $stmt->execute($params); $clients = $stmt->fetchAll(); $stmt = $pdo->prepare("SELECT COUNT(*) FROM clients $where"); $stmt->execute($params); $total = $stmt->fetchColumn(); echo json_encode([ 'success' => true, 'clients' => $clients, 'total' => $total, 'pages' => ceil($total / $limit), 'current_page' => $page ]); break; case 'export_data': $client_id = $_POST['client_id']; // Get client data $stmt = $pdo->prepare("SELECT * FROM clients WHERE client_id = ?"); $stmt->execute([$client_id]); $client = $stmt->fetch(); // Get payments $stmt = $pdo->prepare("SELECT * FROM payments WHERE client_id = ?"); $stmt->execute([$client_id]); $payments = $stmt->fetchAll(); // Get orders $stmt = $pdo->prepare("SELECT o.*, s.service_name FROM orders o LEFT JOIN services s ON o.service_id = s.service_id WHERE o.client_id = ?"); $stmt->execute([$client_id]); $orders = $stmt->fetchAll(); $export_data = [ 'client' => $client, 'payments' => $payments, 'orders' => $orders, 'export_date' => date('Y-m-d H:i:s') ]; echo json_encode(['success' => true, 'data' => $export_data]); break; } exit; } ?> Client Management System - Advanced Dashboard

Secure Access Required

Enter password to access the Client Management System

Advanced Client Management System v2.0

Client Search & Management

is sb code sa 1 acha sa best animation wala stylish code bnao

Client Information

Payment History (Total: $payment_count)

Order History (Total: $order_count)

Financial Summary

Update Client Balance

Client Data Management

Client Information

Financial Summary

Payments

Orders

Refunds

Current Status

Quick Balance Adjustment

Payment Management

Recent Payments (Last 50)

Order Management

Process Refund

Client Management System

Client Management System

Basic Info

Financial Info

Payment Actions

Payment History

Order History

Secure Access Required

Client Search & Management

All Clients Management

Services Management