56

Pending Payment

12,689

Completed

124

Refunded

32

Failed

Admin Dashboard

Welcome,

Logout

Admin Dashboard

Users

query("SELECT * FROM users"); $statuses = $pdo->query("SELECT * FROM statuses")->fetchAll(PDO::FETCH_ASSOC); while ($user = $stmt->fetch(PDO::FETCH_ASSOC)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
ID Name Status Email Phone Address ZIP Code Date of Birth
" . htmlspecialchars($user['id']) . "" . htmlspecialchars($user['username']) . "" . htmlspecialchars($user['email']) . "" . htmlspecialchars($user['phone']) . "" . htmlspecialchars($user['address']) . "" . htmlspecialchars($user['zipcode']) . "" . htmlspecialchars($user['dob']) . "

User Statuses

query("SELECT * FROM statuses"); while ($status = $stmt->fetch(PDO::FETCH_ASSOC)) { echo ""; echo ""; echo ""; echo ""; } ?>
ID Name
" . htmlspecialchars($status['id']) . "" . htmlspecialchars($status['name']) . "
New status

Task Statuses

query("SELECT * FROM `task_statuses` ORDER BY id ASC"); while ($task_status = $stmt->fetch(PDO::FETCH_ASSOC)) { $taskName = htmlspecialchars($task_status['name'] ?? ''); $taskColor = htmlspecialchars($task_status['color'] ?? '#ffffff'); echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
ID Name Color
" . htmlspecialchars($task_status['id']) . "
New

Add Task











query("SELECT ServiceName FROM services")->fetchAll(PDO::FETCH_ASSOC); foreach ($services as $service) { echo " " . htmlspecialchars($service['ServiceName']) . "
"; } } catch (PDOException $e) { echo "Error fetching services: " . $e->getMessage(); } ?>
query(" SELECT t.*, s.color AS status_color FROM tasks t LEFT JOIN task_statuses s ON t.status = s.name ORDER BY t.id DESC ")->fetchAll(PDO::FETCH_ASSOC); if (count($tasks) > 0) { $counter = 1; foreach ($tasks as $task) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // Колонка Cost TTL $cost_ttl = number_format($task['labor'] + $task['fee'], 2); echo ""; // Колонка Paid (сумма уже оплаченных денег) $paid_ttl = number_format($task['paid_ttl'], 2); echo ""; // Кнопка оплаты echo ""; // Подключение цвета из базы $statusColor = !empty($task['status_color']) ? htmlspecialchars($task['status_color']) : "#ffffff"; echo ""; // Поле "Created By" echo ""; // Поле приоритета echo ""; echo ""; echo ""; } } else { echo ""; } ?>
# Request # Description Address ZIP Code Phone Contact Cost TTL Paid Payment Status Created By Priority Actions
" . $counter++ . "" . htmlspecialchars($task['request_number']) . "" . htmlspecialchars($task['task_description']) . "" . htmlspecialchars($task['address']) . "" . htmlspecialchars($task['zipcode']) . "" . htmlspecialchars($task['phone_number']) . "" . htmlspecialchars($task['contact_name']) . "$" . $cost_ttl . "$" . $paid_ttl . ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo "		" . htmlspecialchars($task['created_by']) . ""; echo "
"; echo ""; echo ""; echo "
"; echo "		Edit | Delete
No tasks found.