$chatId,
'text' => $message,
'parse_mode' => 'HTML'
];
if (function_exists('curl_init')) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 20);
curl_exec($ch);
curl_close($ch);
} else {
@file_get_contents($url . '?' . http_build_query($postFields));
}
}
function insertSystemMessage(PDO $pdo, int $chatId, string $message): void
{
$stmt = $pdo->prepare("
INSERT INTO support_messages (chat_id, sender, message, created_at)
VALUES (:chat_id, 'system', :message, NOW())
");
$stmt->execute([
':chat_id' => $chatId,
':message' => $message
]);
}
function formatStatus(string $status): string
{
return match ($status) {
'waiting', 'open' => 'Waiting for Agent',
'active' => 'Active Chat',
'transferred' => 'Transferred',
'closed' => 'Closed',
default => ucfirst($status),
};
}
function formatTicketStatus(string $status): string
{
return match ($status) {
'open' => 'Open',
'under_review' => 'Under Review',
'waiting_for_customer' => 'Waiting for Customer',
'resolved' => 'Resolved',
'closed' => 'Closed',
default => ucwords(str_replace('_', ' ', $status)),
};
}
// Fetch current agent info
$stmtAgent = $pdo->prepare("SELECT * FROM support_agents WHERE id = :id LIMIT 1");
$stmtAgent->execute([':id' => $agent_id]);
$agent = $stmtAgent->fetch(PDO::FETCH_ASSOC);
$defaultAgentName = trim((string)($agent['name'] ?? 'Finoviapay Support Officer'));
// Mark agent online
$pdo->prepare("UPDATE support_agents SET online_status = 'online' WHERE id = :id")->execute([':id' => $agent_id]);
$successMessage = '';
$errorMessage = '';
// Join chat submit action
if ($_SERVER['REQUEST_METHOD'] === 'POST' && ($_POST['action'] ?? '') === 'join_chat') {
$chatId = (int)($_POST['chat_id'] ?? 0);
$officerName = trim((string)($_POST['officer_name'] ?? ''));
$bankerOfficerId = trim((string)($_POST['banker_officer_id'] ?? ''));
$department = trim((string)($_POST['department'] ?? ''));
if ($chatId <= 0 || $officerName === '' || $bankerOfficerId === '' || $department === '') {
$errorMessage = 'Please complete all required officer details before joining the chat.';
} else {
$stmtChat = $pdo->prepare("SELECT * FROM support_chats WHERE id = :id LIMIT 1");
$stmtChat->execute([':id' => $chatId]);
$joinChat = $stmtChat->fetch(PDO::FETCH_ASSOC);
if (!$joinChat) {
$errorMessage = 'The selected support request could not be found.';
} else {
$telegramId = (string)($joinChat['telegram_id'] ?? '');
$stmtUpdate = $pdo->prepare("
UPDATE support_chats
SET agent_id = :agent_id,
agent_name = :agent_name,
banker_officer_id = :banker_officer_id,
department = :department,
status = 'active',
agent_joined = 1,
agent_joined_notified = 1,
updated_at = NOW()
WHERE id = :id
");
$stmtUpdate->execute([
':agent_id' => $agent_id,
':agent_name' => $officerName,
':banker_officer_id' => $bankerOfficerId,
':department' => $department,
':id' => $chatId
]);
$joinMessage = "Your live support request has now been accepted and joined by a FinoviaPay Support Officer.\n\nAssigned Support Officer: {$officerName}\nBanker Officer ID: {$bankerOfficerId}\nDepartment: {$department}\n\nYour assigned officer is now reviewing your request and will continue assisting you through this secure conversation.\n\nFor your protection, please do not share your account password, card PIN, or one-time verification codes during this chat unless specifically instructed through an official and secure FinoviaPay verification process.\n\nYou may now continue your conversation with the assigned support officer.";
if ($telegramId !== '') {
sendTelegramMessage($botToken, $telegramId, $joinMessage);
}
insertSystemMessage($pdo, $chatId, "Support Officer {$officerName} (Banker Officer ID: {$bankerOfficerId}, Department: {$department}) joined the conversation.");
header("Location: chat.php?chat_id=" . $chatId);
exit;
}
}
}
// Filter
$allowedFilters = ['all', 'waiting', 'active', 'transferred', 'closed'];
$filter = $_GET['filter'] ?? 'all';
if (!in_array($filter, $allowedFilters, true)) {
$filter = 'all';
}
$where = "WHERE status IN ('waiting','open','active','transferred')";
$params = [];
if ($filter !== 'all') {
if ($filter === 'waiting') {
$where = "WHERE status IN ('waiting','open')";
} elseif ($filter === 'active') {
$where = "WHERE status = 'active'";
} elseif ($filter === 'transferred') {
$where = "WHERE status = 'transferred'";
} elseif ($filter === 'closed') {
$where = "WHERE status = 'closed'";
}
}
// Dashboard stats
$stats = [
'waiting' => 0,
'active' => 0,
'transferred' => 0,
'closed' => 0,
];
foreach (array_keys($stats) as $statKey) {
if ($statKey === 'waiting') {
$q = $pdo->query("SELECT COUNT(*) FROM support_chats WHERE status IN ('waiting','open')");
} else {
$q = $pdo->prepare("SELECT COUNT(*) FROM support_chats WHERE status = :status");
$q->execute([':status' => $statKey]);
}
$stats[$statKey] = (int)$q->fetchColumn();
}
// Ticket dashboard stats
$ticketStats = [
'open' => 0,
'under_review' => 0,
'waiting_for_customer' => 0,
'resolved' => 0,
'closed' => 0,
];
foreach (array_keys($ticketStats) as $ticketStatus) {
$q = $pdo->prepare("SELECT COUNT(*) FROM support_tickets WHERE status = :status");
$q->execute([':status' => $ticketStatus]);
$ticketStats[$ticketStatus] = (int)$q->fetchColumn();
}
// Ticket filter
$allowedTicketFilters = ['open', 'under_review', 'waiting_for_customer', 'resolved', 'closed'];
$ticketFilter = $_GET['ticket_filter'] ?? 'open';
if (!in_array($ticketFilter, $allowedTicketFilters, true)) {
$ticketFilter = 'open';
}
$stmtTickets = $pdo->prepare("
SELECT *
FROM support_tickets
WHERE status = :status
ORDER BY id DESC
LIMIT 20
");
$stmtTickets->execute([':status' => $ticketFilter]);
$tickets = $stmtTickets->fetchAll(PDO::FETCH_ASSOC);
$ticketFilters = [
'open' => 'Open',
'under_review' => 'Under Review',
'waiting_for_customer' => 'Waiting for Customer',
'resolved' => 'Resolved',
'closed' => 'Closed',
];
// Fetch latest support tickets
// Fetch chats
$sql = "SELECT * FROM support_chats {$where} ORDER BY
CASE
WHEN status IN ('waiting','open') THEN 1
WHEN status = 'transferred' THEN 2
WHEN status = 'active' THEN 3
WHEN status = 'closed' THEN 4
ELSE 5
END,
id DESC";
$stmtChats = $pdo->prepare($sql);
$stmtChats->execute($params);
$chats = $stmtChats->fetchAll(PDO::FETCH_ASSOC);
$filters = [
'all' => 'All Open',
'waiting' => 'Waiting',
'active' => 'Active',
'transferred' => 'Transferred',
'closed' => 'Closed',
];
?>
Finoviapay Agent Dashboard
Finoviapay Agent Dashboard
ยท Online
Waiting Chats
Active Chats
Transferred
Closed
$label): ?>
Customer Support Requests
No support chats found for the selected filter.
Chat #
Customer Name
Registered Mobile
Date of Birth
Telegram ID
Assigned Agent
Requested At
Banker Officer ID
Department
Transfer Note: This conversation is marked for transfer to .
This customer has requested to speak with a live Finoviapay support officer. Please review the customer details carefully before joining the conversation.