<?php
declare(strict_types=1);

/*
|--------------------------------------------------------------------------
| ASOVERIFY - IPE ADMIN STATUS CONTROL
|--------------------------------------------------------------------------
| File: admin_ipe5.php
|
| FIXES IN THIS VERSION
| - load_requests action name now matches the JavaScript (table loads again)
| - Unknown POST actions return JSON instead of the full HTML page
| - Retry counters now support retry_count / retried_at (your real columns)
|   as well as resend_count / last_retry
|--------------------------------------------------------------------------
*/

error_reporting(E_ALL);
ini_set('display_errors', '0');
ini_set('display_startup_errors', '0');

if (session_status() !== PHP_SESSION_ACTIVE) {
    session_start();
}

if (!isset($_SESSION['admin']) || trim((string)$_SESSION['admin']) === '') {
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        header('Content-Type: application/json; charset=utf-8');
        http_response_code(403);
        echo json_encode(['success' => false, 'message' => 'Admin authentication required.']);
        exit;
    }
    header('Location: admin_login.php');
    exit;
}

require_once __DIR__ . '/db.php';

if (!isset($conn) || !($conn instanceof mysqli)) {
    http_response_code(500);
    exit('Database connection was not found.');
}

$conn->set_charset('utf8mb4');

/* -------------------------------------------------------------------------
   MAIL CONFIG
   ------------------------------------------------------------------------- */

$mailHost = 'mail.asoverify.com.ng';
$mailUsername = 'noreply@asoverify.com.ng';
$mailPassword = getenv('ASOVERIFY_MAIL_PASSWORD') ?: 'Sabirata@273';

$smtpHost = $mailHost;
$smtpPort = 465;
$smtpUsername = $mailUsername;
$smtpPassword = $mailPassword;

$imapServer = $mailHost;
$imapPort = 993;
$mailboxEmail = $mailUsername;
$mailboxPassword = $mailPassword;

$fromEmail = $mailUsername;
$fromName = 'ASOVERIFY';
$nimcEmail = 'nimccustomercare@nimc.gov.ng';

$perPage = 10;

$allowedStatuses = [
    'PENDING',
    'PROCESSING',
    'SUCCESSFUL',
    'FAILED',
    'COMPLETED',
    'REFUNDED'
];

/* -------------------------------------------------------------------------
   HELPERS
   ------------------------------------------------------------------------- */

function e(mixed $value): string
{
    return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8');
}

function jsonResponse(
    bool $success,
    string $message,
    array $data = [],
    int $statusCode = 200
): never {
    http_response_code($statusCode);
    header('Content-Type: application/json; charset=utf-8');

    echo json_encode(
        array_merge(
            ['success' => $success, 'message' => $message],
            $data
        ),
        JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES
    );

    exit;
}

function columnExists(mysqli $conn, string $table, string $column): bool
{
    $stmt = $conn->prepare(
        "SELECT COUNT(*) FROM information_schema.columns
         WHERE table_schema = DATABASE()
           AND table_name = ?
           AND column_name = ?"
    );

    if (!$stmt) {
        return false;
    }

    $stmt->bind_param('ss', $table, $column);
    $stmt->execute();
    $stmt->bind_result($count);
    $stmt->fetch();
    $stmt->close();

    return (int)$count > 0;
}

/* -------------------------------------------------------------------------
   DETECT IPE COLUMNS
   ------------------------------------------------------------------------- */

$ipeColumns = [];

$ipeColumns['status'] = columnExists($conn, 'ipe_request', 'request_status')
    ? 'request_status'
    : (columnExists($conn, 'ipe_request', 'status') ? 'status' : 'request_status');

$ipeColumns['user_email'] = columnExists($conn, 'ipe_request', 'user_email')
    ? 'user_email'
    : (columnExists($conn, 'ipe_request', 'user') ? 'user' : 'user_email');

$ipeColumns['tracking_id'] = 'tracking_id';

$ipeColumns['amount'] = columnExists($conn, 'ipe_request', 'amount')
    ? 'amount'
    : (columnExists($conn, 'ipe_request', 'price') ? 'price' : 'amount');

$ipeColumns['deducted_amount'] = columnExists($conn, 'ipe_request', 'deducted_amount')
    ? 'deducted_amount'
    : '';

$ipeColumns['reply'] = 'reply';

$ipeColumns['reference'] = columnExists($conn, 'ipe_request', 'reference')
    ? 'reference'
    : '';

$ipeColumns['transaction_id'] = columnExists($conn, 'ipe_request', 'transaction_id')
    ? 'transaction_id'
    : '';

$ipeColumns['nin'] = columnExists($conn, 'ipe_request', 'nin')
    ? 'nin'
    : '';

$ipeColumns['created_at'] = 'created_at';

/* Retry counter columns (your table uses retry_count / retried_at) */
$ipeColumns['retry_count'] = columnExists($conn, 'ipe_request', 'retry_count')
    ? 'retry_count'
    : (columnExists($conn, 'ipe_request', 'resend_count') ? 'resend_count' : '');

$ipeColumns['retry_time'] = columnExists($conn, 'ipe_request', 'retried_at')
    ? 'retried_at'
    : (columnExists($conn, 'ipe_request', 'last_retry') ? 'last_retry' : '');

/*
 * Amount is taken from amount first. If amount is zero/null, deducted_amount
 * is used.
 */
$amountExpression = "
    COALESCE(
        NULLIF(`{$ipeColumns['amount']}`, 0),
        " . (
            $ipeColumns['deducted_amount'] !== ''
                ? "NULLIF(`{$ipeColumns['deducted_amount']}`, 0)"
                : "NULL"
        ) . ",
        0
    )
";

/* -------------------------------------------------------------------------
   REFUND TABLE
   ------------------------------------------------------------------------- */

$conn->query(
    "CREATE TABLE IF NOT EXISTS ipe_refunds (
        id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
        request_id BIGINT NOT NULL,
        user_email VARCHAR(255) NOT NULL,
        original_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00,
        refund_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00,
        refund_percent DECIMAL(5,2) NOT NULL DEFAULT 80.00,
        created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (id),
        UNIQUE KEY unique_request_refund (request_id),
        KEY idx_user_email (user_email),
        KEY idx_created_at (created_at)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"
);

/* -------------------------------------------------------------------------
   IMAP BODY DECODING
   ------------------------------------------------------------------------- */

function decodeImapTextPart(string $text, string $encoding): string
{
    switch ((int)$encoding) {
        case 3:
            $decoded = base64_decode($text, true);
            return $decoded !== false ? $decoded : $text;

        case 4:
            return quoted_printable_decode($text);

        default:
            return $text;
    }
}

function getImapMessageBody($imap, int $messageNumber): string
{
    $structure = @imap_fetchstructure($imap, $messageNumber);

    if (!$structure) {
        return trim((string)@imap_body($imap, $messageNumber));
    }

    if (empty($structure->parts)) {
        $body = @imap_fetchbody($imap, $messageNumber, '1');

        return trim(
            decodeImapTextPart(
                (string)$body,
                (string)($structure->encoding ?? 0)
            )
        );
    }

    $plainParts = [];
    $htmlParts = [];

    $walkParts = function (
        $parts,
        string $prefix = ''
    ) use (
        &$walkParts,
        $imap,
        $messageNumber,
        &$plainParts,
        &$htmlParts
    ): void {
        foreach ($parts as $index => $part) {
            $partNumber = $prefix === ''
                ? (string)($index + 1)
                : $prefix . '.' . ($index + 1);

            if (!empty($part->parts)) {
                $walkParts($part->parts, $partNumber);
                continue;
            }

            $body = @imap_fetchbody($imap, $messageNumber, $partNumber);

            $body = decodeImapTextPart(
                (string)$body,
                (string)($part->encoding ?? 0)
            );

            $subtype = strtolower((string)($part->subtype ?? ''));

            if ($subtype === 'plain') {
                $plainParts[] = $body;
            } elseif ($subtype === 'html') {
                $htmlParts[] = strip_tags($body);
            }
        }
    };

    $walkParts($structure->parts);

    if ($plainParts) {
        return trim(implode("\n\n", $plainParts));
    }

    if ($htmlParts) {
        return trim(implode("\n\n", $htmlParts));
    }

    return trim((string)@imap_body($imap, $messageNumber));
}

/* -------------------------------------------------------------------------
   SENT FOLDER
   ------------------------------------------------------------------------- */

function findSentFolder($imap): ?string
{
    $mailboxes = @imap_getmailboxes(
        $imap,
        '{mail.asoverify.com.ng:993/imap/ssl/novalidate-cert}',
        '*'
    );

    if (!is_array($mailboxes)) {
        return null;
    }

    foreach ($mailboxes as $box) {
        $name = isset($box->name) ? (string)$box->name : '';
        $decoded = @imap_utf7_decode($name);
        $lower = strtolower((string)$decoded);

        if (str_contains($lower, 'sent')) {
            return $name;
        }
    }

    return null;
}

/* -------------------------------------------------------------------------
   RAW EMAIL / SMTP
   ------------------------------------------------------------------------- */

function buildRawEmail(
    string $fromEmail,
    string $fromName,
    string $toEmail,
    string $subject,
    string $body
): string {
    $date = date('r');
    $messageId = '<' . bin2hex(random_bytes(12)) . '@asoverify.com.ng>';

    return
        'Date: ' . $date . "\r\n" .
        'From: ' . $fromName . ' <' . $fromEmail . ">\r\n" .
        'To: ' . $toEmail . "\r\n" .
        'Subject: ' . $subject . "\r\n" .
        'Message-ID: ' . $messageId . "\r\n" .
        'MIME-Version: 1.0' . "\r\n" .
        'Content-Type: text/plain; charset=UTF-8' . "\r\n" .
        'Content-Transfer-Encoding: 8bit' . "\r\n" .
        "\r\n" .
        $body .
        "\r\n";
}

function smtpRead($socket): string
{
    $response = '';

    while (!feof($socket)) {
        $line = fgets($socket, 515);

        if ($line === false) {
            break;
        }

        $response .= $line;

        if (strlen($line) >= 4 && $line[3] === ' ') {
            break;
        }
    }

    return $response;
}

function smtpCommand($socket, string $command, array $expectedCodes): array
{
    fwrite($socket, $command . "\r\n");

    $response = smtpRead($socket);
    $code = (int)substr(trim($response), 0, 3);

    return [
        'ok' => in_array($code, $expectedCodes, true),
        'response' => $response
    ];
}

function sendSMTPEmail(
    string $host,
    int $port,
    string $username,
    string $password,
    string $fromEmail,
    string $fromName,
    string $toEmail,
    string $subject,
    string $body
): array {
    $errno = 0;
    $errstr = '';

    $socket = @fsockopen('ssl://' . $host, $port, $errno, $errstr, 20);

    if (!$socket) {
        return ['success' => false, 'error' => 'SMTP connection failed: ' . $errstr];
    }

    stream_set_timeout($socket, 20);

    $greeting = smtpRead($socket);

    if (!str_starts_with(trim($greeting), '220')) {
        fclose($socket);
        return ['success' => false, 'error' => 'SMTP greeting failed: ' . trim($greeting)];
    }

    $steps = [
        ['EHLO asoverify.com.ng', [250], 'SMTP EHLO failed.'],
        ['AUTH LOGIN', [334], 'SMTP AUTH LOGIN failed.'],
        [base64_encode($username), [334], 'SMTP username authentication failed.'],
        [base64_encode($password), [235], 'SMTP password authentication failed.'],
        ['MAIL FROM:<' . $fromEmail . '>', [250], 'SMTP MAIL FROM failed.'],
        ['RCPT TO:<' . $toEmail . '>', [250, 251], 'SMTP recipient rejected.'],
        ['DATA', [354], 'SMTP DATA command failed.'],
    ];

    foreach ($steps as [$command, $codes, $errorMessage]) {
        $result = smtpCommand($socket, $command, $codes);

        if (!$result['ok']) {
            fclose($socket);
            return ['success' => false, 'error' => $errorMessage];
        }
    }

    $raw = buildRawEmail($fromEmail, $fromName, $toEmail, $subject, $body);
    $raw = preg_replace('/^\./m', '..', $raw) ?? $raw;

    fwrite($socket, $raw . "\r\n.\r\n");

    $response = smtpRead($socket);

    if (!str_starts_with(trim($response), '250')) {
        fclose($socket);
        return ['success' => false, 'error' => 'SMTP DATA rejected: ' . trim($response)];
    }

    smtpCommand($socket, 'QUIT', [221]);
    fclose($socket);

    return ['success' => true, 'error' => ''];
}

function saveEmailToSentFolder(
    string $imapServer,
    int $imapPort,
    string $mailboxEmail,
    string $mailboxPassword,
    string $fromEmail,
    string $fromName,
    string $toEmail,
    string $subject,
    string $body
): array {
    if (!function_exists('imap_open')) {
        return ['success' => false, 'error' => 'PHP IMAP extension is not available.'];
    }

    $inboxMailbox =
        '{' . $imapServer . ':' . $imapPort . '/imap/ssl/novalidate-cert}INBOX';

    $imap = @imap_open($inboxMailbox, $mailboxEmail, $mailboxPassword);

    if (!$imap) {
        return [
            'success' => false,
            'error' => imap_last_error() ?: 'Could not open mailbox.'
        ];
    }

    $sentFolder = findSentFolder($imap);

    @imap_close($imap);

    if (!$sentFolder) {
        return ['success' => false, 'error' => 'Sent folder could not be detected.'];
    }

    $raw = buildRawEmail($fromEmail, $fromName, $toEmail, $subject, $body);

    $sentMailbox =
        '{' . $imapServer . ':' . $imapPort . '/imap/ssl/novalidate-cert}' . $sentFolder;

    $connection = @imap_open($sentMailbox, $mailboxEmail, $mailboxPassword);

    if (!$connection) {
        return [
            'success' => false,
            'error' => imap_last_error() ?: 'Could not open Sent folder.'
        ];
    }

    $saved = @imap_append($connection, $sentMailbox, $raw, '\\Seen');

    $error = $saved
        ? ''
        : (imap_last_error() ?: 'Could not save Sent copy.');

    @imap_close($connection);

    return ['success' => (bool)$saved, 'error' => $error];
}

/* -------------------------------------------------------------------------
   OPEN INBOX
   ------------------------------------------------------------------------- */

function openInbox(string $server, int $port, string $email, string $password)
{
    if (!function_exists('imap_open')) {
        return false;
    }

    $mailbox = '{' . $server . ':' . $port . '/imap/ssl/novalidate-cert}INBOX';

    return @imap_open($mailbox, $email, $password);
}

function getHeaderAddress($addressObject): string
{
    if (!$addressObject) {
        return '';
    }

    $mailbox = isset($addressObject->mailbox) ? (string)$addressObject->mailbox : '';
    $host = isset($addressObject->host) ? (string)$addressObject->host : '';

    if ($mailbox === '' && $host === '') {
        return '';
    }

    return $mailbox . ($host !== '' ? '@' . $host : '');
}

function emptyEmailResult(): array
{
    return [
        'found' => false,
        'message_number' => 0,
        'subject' => '',
        'from' => '',
        'to' => '',
        'date' => '',
        'body' => ''
    ];
}

function findNimcReplyEmail($imap, string $trackingId): array
{
    $safeSearch = addcslashes($trackingId, "\\\"");

    $messages = @imap_search($imap, 'TEXT "' . $safeSearch . '"');

    if (!is_array($messages)) {
        return emptyEmailResult();
    }

    rsort($messages);

    $fallback = null;

    foreach ($messages as $messageNumber) {
        $messageNumber = (int)$messageNumber;

        $header = @imap_headerinfo($imap, $messageNumber);

        if (!$header) {
            continue;
        }

        $from = '';
        $senderEmail = '';

        if (!empty($header->from[0])) {
            $from = getHeaderAddress($header->from[0]);

            if (isset($header->from[0]->mailbox) && isset($header->from[0]->host)) {
                $senderEmail = strtolower(
                    (string)$header->from[0]->mailbox . '@' . (string)$header->from[0]->host
                );
            }
        }

        $subject = '';

        if (isset($header->subject)) {
            $subject = (string)$header->subject;

            if (function_exists('imap_utf8')) {
                $decoded = @imap_utf8($subject);

                if ($decoded !== false && $decoded !== '') {
                    $subject = $decoded;
                }
            }
        }

        $date = isset($header->date) ? (string)$header->date : '';

        $body = getImapMessageBody($imap, $messageNumber);

        if ($body === '') {
            continue;
        }

        $item = [
            'found' => true,
            'message_number' => $messageNumber,
            'subject' => trim($subject),
            'from' => $senderEmail !== '' ? $senderEmail : $from,
            'to' => '',
            'date' => $date,
            'body' => $body
        ];

        if ($fallback === null) {
            $fallback = $item;
        }

        if ($senderEmail === 'nimccustomercare@nimc.gov.ng') {
            return $item;
        }
    }

    return $fallback ?? emptyEmailResult();
}

/* =========================================================================
   AJAX: LOAD REQUESTS
   (accepts both "load_requests" and the old "load_request")
   ========================================================================= */

if (
    $_SERVER['REQUEST_METHOD'] === 'POST' &&
    in_array(($_POST['action'] ?? ''), ['load_requests', 'load_request'], true)
) {
    $search = trim((string)($_POST['search'] ?? ''));
    $statusFilter = strtoupper(trim((string)($_POST['status'] ?? '')));
    $page = max(1, (int)($_POST['page'] ?? 1));

    $where = [];
    $types = '';
    $params = [];

    $statusCol = '`' . $ipeColumns['status'] . '`';
    $userCol = '`' . $ipeColumns['user_email'] . '`';
    $trackingCol = '`' . $ipeColumns['tracking_id'] . '`';
    $replyCol = '`' . $ipeColumns['reply'] . '`';

    if ($search !== '') {
        $parts = [
            "{$userCol} LIKE ?",
            "{$trackingCol} LIKE ?"
        ];

        $values = [
            '%' . $search . '%',
            '%' . $search . '%'
        ];

        foreach (['nin', 'reference', 'transaction_id'] as $key) {
            if ($ipeColumns[$key] !== '') {
                $parts[] = '`' . $ipeColumns[$key] . '` LIKE ?';
                $values[] = '%' . $search . '%';
            }
        }

        $where[] = '(' . implode(' OR ', $parts) . ')';

        foreach ($values as $value) {
            $types .= 's';
            $params[] = $value;
        }
    }

    if ($statusFilter !== '' && in_array($statusFilter, $allowedStatuses, true)) {
        $where[] = "{$statusCol} = ?";
        $types .= 's';
        $params[] = $statusFilter;
    }

    $whereSql = $where ? 'WHERE ' . implode(' AND ', $where) : '';

    $countStmt = $conn->prepare("SELECT COUNT(*) FROM ipe_request {$whereSql}");

    if (!$countStmt) {
        jsonResponse(false, 'Could not prepare count query: ' . $conn->error, [], 500);
    }

    if ($types !== '') {
        $countStmt->bind_param($types, ...$params);
    }

    $countStmt->execute();
    $countStmt->bind_result($totalRows);
    $countStmt->fetch();
    $countStmt->close();

    $totalRows = (int)$totalRows;
    $totalPages = max(1, (int)ceil($totalRows / $perPage));

    if ($page > $totalPages) {
        $page = $totalPages;
    }

    $offset = ($page - 1) * $perPage;

    $ninSelect = $ipeColumns['nin'] !== ''
        ? '`' . $ipeColumns['nin'] . '` AS nin'
        : "'' AS nin";

    $referenceSelect = $ipeColumns['reference'] !== ''
        ? '`' . $ipeColumns['reference'] . '` AS reference'
        : "'' AS reference";

    $transactionSelect = $ipeColumns['transaction_id'] !== ''
        ? '`' . $ipeColumns['transaction_id'] . '` AS transaction_id'
        : "'' AS transaction_id";

    $sql =
        "SELECT
            id,
            {$userCol} AS user_email,
            {$trackingCol} AS tracking_id,
            {$statusCol} AS status,
            {$replyCol} AS reply,
            {$ninSelect},
            {$referenceSelect},
            {$transactionSelect},
            {$amountExpression} AS amount,
            created_at
         FROM ipe_request
         {$whereSql}
         ORDER BY id DESC
         LIMIT ? OFFSET ?";

    $stmt = $conn->prepare($sql);

    if (!$stmt) {
        jsonResponse(false, 'Could not prepare request query: ' . $conn->error, [], 500);
    }

    $bindTypes = $types . 'ii';
    $bindParams = $params;
    $bindParams[] = $perPage;
    $bindParams[] = $offset;

    $stmt->bind_param($bindTypes, ...$bindParams);
    $stmt->execute();

    $result = $stmt->get_result();
    $rows = [];

    while ($row = $result->fetch_assoc()) {
        $rows[] = [
            'id' => (int)$row['id'],
            'user_email' => (string)$row['user_email'],
            'tracking_id' => (string)$row['tracking_id'],
            'status' => strtoupper((string)$row['status']),
            'reply' => (string)$row['reply'],
            'nin' => (string)$row['nin'],
            'reference' => (string)$row['reference'],
            'transaction_id' => (string)$row['transaction_id'],
            'amount' => (float)$row['amount'],
            'created_at' => (string)$row['created_at']
        ];
    }

    $stmt->close();

    jsonResponse(
        true,
        'Requests loaded.',
        [
            'rows' => $rows,
            'page' => $page,
            'per_page' => $perPage,
            'total_rows' => $totalRows,
            'total_pages' => $totalPages
        ]
    );
}

/* =========================================================================
   AJAX: VIEW NIMC RETURNED EMAIL
   ========================================================================= */

if (
    $_SERVER['REQUEST_METHOD'] === 'POST' &&
    ($_POST['action'] ?? '') === 'view_email'
) {
    if (!function_exists('imap_open')) {
        jsonResponse(false, 'PHP IMAP extension is not available.', [], 500);
    }

    $id = (int)($_POST['id'] ?? 0);

    if ($id <= 0) {
        jsonResponse(false, 'Invalid request ID.', [], 400);
    }

    $trackingCol = '`' . $ipeColumns['tracking_id'] . '`';

    $stmt = $conn->prepare(
        "SELECT id, {$trackingCol} AS tracking_id
         FROM ipe_request
         WHERE id = ?
         LIMIT 1"
    );

    if (!$stmt) {
        jsonResponse(false, 'Could not prepare request query.', [], 500);
    }

    $stmt->bind_param('i', $id);
    $stmt->execute();

    $request = $stmt->get_result()->fetch_assoc();
    $stmt->close();

    if (!$request) {
        jsonResponse(false, 'Request not found.', [], 404);
    }

    $trackingId = trim((string)$request['tracking_id']);

    if ($trackingId === '') {
        jsonResponse(false, 'This request does not contain a tracking ID.', [], 400);
    }

    $imap = openInbox($imapServer, $imapPort, $mailboxEmail, $mailboxPassword);

    if (!$imap) {
        jsonResponse(
            false,
            'Could not open INBOX: ' . (imap_last_error() ?: 'Unknown IMAP error'),
            [],
            500
        );
    }

    $email = findNimcReplyEmail($imap, $trackingId);

    @imap_close($imap);

    if (!$email['found']) {
        jsonResponse(
            false,
            'No returned NIMC email was found for tracking ID ' . $trackingId . '.',
            [],
            404
        );
    }

    jsonResponse(
        true,
        'NIMC returned email found.',
        [
            'tracking_id' => $trackingId,
            'subject' => $email['subject'],
            'from' => $email['from'],
            'to' => $email['to'],
            'date' => $email['date'],
            'body' => $email['body']
        ]
    );
}

/* =========================================================================
   AJAX: UPDATE REQUEST
   ========================================================================= */

if (
    $_SERVER['REQUEST_METHOD'] === 'POST' &&
    ($_POST['action'] ?? '') === 'update_request'
) {
    $id = (int)($_POST['id'] ?? 0);
    $status = strtoupper(trim((string)($_POST['status'] ?? '')));
    $reply = trim((string)($_POST['reply'] ?? ''));

    if ($id <= 0) {
        jsonResponse(false, 'Invalid request ID.', [], 400);
    }

    if (!in_array($status, $allowedStatuses, true)) {
        jsonResponse(false, 'Invalid status.', [], 400);
    }

    $statusCol = '`' . $ipeColumns['status'] . '`';
    $replyCol = '`' . $ipeColumns['reply'] . '`';

    $stmt = $conn->prepare(
        "UPDATE ipe_request
         SET {$statusCol} = ?, {$replyCol} = ?
         WHERE id = ?
         LIMIT 1"
    );

    if (!$stmt) {
        jsonResponse(false, 'Could not prepare update: ' . $conn->error, [], 500);
    }

    $stmt->bind_param('ssi', $status, $reply, $id);

    if (!$stmt->execute()) {
        $error = $stmt->error;
        $stmt->close();

        jsonResponse(false, 'Could not update request: ' . $error, [], 500);
    }

    $stmt->close();

    jsonResponse(true, 'Request updated successfully.');
}

/* =========================================================================
   AJAX: SEND / RESEND EMAIL
   ========================================================================= */

if (
    $_SERVER['REQUEST_METHOD'] === 'POST' &&
    in_array(($_POST['action'] ?? ''), ['send_email', 'resend_email'], true)
) {
    $id = (int)($_POST['id'] ?? 0);

    if ($id <= 0) {
        jsonResponse(false, 'Invalid request ID.', [], 400);
    }

    $trackingCol = '`' . $ipeColumns['tracking_id'] . '`';

    $stmt = $conn->prepare(
        "SELECT id, {$trackingCol} AS tracking_id
         FROM ipe_request
         WHERE id = ?
         LIMIT 1"
    );

    if (!$stmt) {
        jsonResponse(false, 'Could not prepare request query.', [], 500);
    }

    $stmt->bind_param('i', $id);
    $stmt->execute();

    $request = $stmt->get_result()->fetch_assoc();
    $stmt->close();

    if (!$request) {
        jsonResponse(false, 'Request not found.', [], 404);
    }

    $trackingId = trim((string)$request['tracking_id']);

    if ($trackingId === '') {
        jsonResponse(false, 'This request does not contain a tracking ID.', [], 400);
    }

    /* No NIN is retrieved or included here. */
    $subject = 'IPE Processing Error - Request for New Tracking ID';

    $emailBody =
"Dear NIMC Customer Care,

Please help with this processing error and give me a new tracking ID.

TRACKING ID: {$trackingId}

Please assist with this request.

Regards,
BILYAN ASO";

    $smtpResult = sendSMTPEmail(
        $smtpHost,
        $smtpPort,
        $smtpUsername,
        $smtpPassword,
        $fromEmail,
        $fromName,
        $nimcEmail,
        $subject,
        $emailBody
    );

    if (!$smtpResult['success']) {
        jsonResponse(false, 'Email could not be sent: ' . $smtpResult['error'], [], 500);
    }

    $sentResult = saveEmailToSentFolder(
        $imapServer,
        $imapPort,
        $mailboxEmail,
        $mailboxPassword,
        $fromEmail,
        $fromName,
        $nimcEmail,
        $subject,
        $emailBody
    );

    /* Update retry counters using whichever columns exist */
    $setParts = [];

    if ($ipeColumns['retry_count'] !== '') {
        $c = '`' . $ipeColumns['retry_count'] . '`';
        $setParts[] = "{$c} = COALESCE({$c}, 0) + 1";
    }

    if ($ipeColumns['retry_time'] !== '') {
        $setParts[] = '`' . $ipeColumns['retry_time'] . '` = NOW()';
    }

    if ($setParts) {
        $update = $conn->prepare(
            'UPDATE ipe_request SET ' . implode(', ', $setParts) . ' WHERE id = ? LIMIT 1'
        );

        if ($update) {
            $update->bind_param('i', $id);
            $update->execute();
            $update->close();
        }
    }

    jsonResponse(
        true,
        $sentResult['success']
            ? 'Email sent successfully and a copy was saved to Sent.'
            : 'Email sent successfully, but the Sent copy could not be saved.',
        [
            'sent_saved' => (bool)$sentResult['success'],
            'sent_error' => $sentResult['success'] ? '' : $sentResult['error']
        ]
    );
}

/* =========================================================================
   AJAX: 80% REFUND
   ========================================================================= */

if (
    $_SERVER['REQUEST_METHOD'] === 'POST' &&
    ($_POST['action'] ?? '') === 'refund'
) {
    $id = (int)($_POST['id'] ?? 0);

    if ($id <= 0) {
        jsonResponse(false, 'Invalid request ID.', [], 400);
    }

    $statusCol = '`' . $ipeColumns['status'] . '`';
    $userCol = '`' . $ipeColumns['user_email'] . '`';

    $conn->begin_transaction();

    try {
        $stmt = $conn->prepare(
            "SELECT
                id,
                {$userCol} AS user_email,
                {$statusCol} AS status,
                {$amountExpression} AS amount
             FROM ipe_request
             WHERE id = ?
             LIMIT 1
             FOR UPDATE"
        );

        if (!$stmt) {
            throw new RuntimeException('Could not prepare refund query.');
        }

        $stmt->bind_param('i', $id);
        $stmt->execute();

        $request = $stmt->get_result()->fetch_assoc();
        $stmt->close();

        if (!$request) {
            throw new RuntimeException('Request not found.');
        }

        $status = strtoupper(trim((string)$request['status']));

        if ($status !== 'FAILED') {
            throw new RuntimeException('Only FAILED requests can be refunded.');
        }

        $refundCheck = $conn->prepare(
            "SELECT id FROM ipe_refunds WHERE request_id = ? LIMIT 1"
        );

        $refundCheck->bind_param('i', $id);
        $refundCheck->execute();

        $alreadyRefunded = $refundCheck->get_result()->fetch_assoc();

        $refundCheck->close();

        if ($alreadyRefunded) {
            throw new RuntimeException('This request has already been refunded.');
        }

        $email = trim((string)$request['user_email']);
        $originalAmount = (float)$request['amount'];

        if ($originalAmount <= 0) {
            throw new RuntimeException('The request amount is ₦0.00. Nothing can be refunded.');
        }

        $refundAmount = round($originalAmount * 0.80, 2);

        $balanceStmt = $conn->prepare(
            "SELECT amount FROM balance WHERE user = ? LIMIT 1 FOR UPDATE"
        );

        if (!$balanceStmt) {
            throw new RuntimeException('Could not prepare balance query.');
        }

        $balanceStmt->bind_param('s', $email);
        $balanceStmt->execute();

        $balanceRow = $balanceStmt->get_result()->fetch_assoc();

        $balanceStmt->close();

        if (!$balanceRow) {
            throw new RuntimeException('Customer balance record was not found.');
        }

        $credit = $conn->prepare(
            "UPDATE balance SET amount = amount + ? WHERE user = ? LIMIT 1"
        );

        if (!$credit) {
            throw new RuntimeException('Could not prepare balance credit.');
        }

        $credit->bind_param('ds', $refundAmount, $email);

        if (!$credit->execute()) {
            throw new RuntimeException('Could not credit customer balance.');
        }

        $credit->close();

        $insertRefund = $conn->prepare(
            "INSERT INTO ipe_refunds
            (request_id, user_email, original_amount, refund_amount, refund_percent, created_at)
            VALUES (?, ?, ?, ?, 80.00, NOW())"
        );

        if (!$insertRefund) {
            throw new RuntimeException('Could not prepare refund record.');
        }

        $insertRefund->bind_param('isdd', $id, $email, $originalAmount, $refundAmount);

        if (!$insertRefund->execute()) {
            throw new RuntimeException('Could not save refund record.');
        }

        $insertRefund->close();

        $markRefunded = $conn->prepare(
            "UPDATE ipe_request SET {$statusCol} = 'REFUNDED' WHERE id = ? LIMIT 1"
        );

        if (!$markRefunded) {
            throw new RuntimeException('Could not prepare request update.');
        }

        $markRefunded->bind_param('i', $id);

        if (!$markRefunded->execute()) {
            throw new RuntimeException('Could not mark request as refunded.');
        }

        $markRefunded->close();

        $conn->commit();

        jsonResponse(
            true,
            '80% refund completed successfully.',
            ['refund_amount' => $refundAmount]
        );
    } catch (Throwable $ex) {
        $conn->rollback();

        jsonResponse(false, $ex->getMessage(), [], 400);
    }
}

/* =========================================================================
   UNKNOWN POST ACTION -> JSON (never return the HTML page to AJAX)
   ========================================================================= */

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    jsonResponse(false, 'Unknown action.', [], 400);
}

/* =========================================================================
   STATISTICS
   ========================================================================= */

$todayStart = date('Y-m-d 00:00:00');
$tomorrowStart = date('Y-m-d 00:00:00', strtotime('+1 day'));

$weekStart = date('Y-m-d 00:00:00', strtotime('monday this week'));
$nextWeekStart = date('Y-m-d 00:00:00', strtotime('monday next week'));

$monthStart = date('Y-m-01 00:00:00');
$nextMonthStart = date('Y-m-d 00:00:00', strtotime('first day of next month'));

$lastMonthStart = date('Y-m-01 00:00:00', strtotime('first day of last month'));

function rangeStats(mysqli $conn, string $amountExpression, string $from, string $to): array
{
    $count = 0;
    $spent = 0.00;

    $stmt = $conn->prepare(
        "SELECT COUNT(*), COALESCE(SUM({$amountExpression}), 0)
         FROM ipe_request
         WHERE created_at >= ? AND created_at < ?"
    );

    if ($stmt) {
        $stmt->bind_param('ss', $from, $to);
        $stmt->execute();
        $stmt->bind_result($count, $spent);
        $stmt->fetch();
        $stmt->close();
    }

    return [(int)$count, (float)$spent];
}

[$todayCount, $todaySpent] = rangeStats($conn, $amountExpression, $todayStart, $tomorrowStart);
[$weeklyCount, $weeklySpent] = rangeStats($conn, $amountExpression, $weekStart, $nextWeekStart);
[$monthlyCount, $monthlySpent] = rangeStats($conn, $amountExpression, $monthStart, $nextMonthStart);
[, $lastMonthSpent] = rangeStats($conn, $amountExpression, $lastMonthStart, $monthStart);

$totalCount = 0;
$totalSpent = 0.00;

$result = $conn->query(
    "SELECT COUNT(*) AS cnt, COALESCE(SUM({$amountExpression}), 0) AS spent
     FROM ipe_request"
);

if ($result) {
    $row = $result->fetch_assoc();

    $totalCount = (int)($row['cnt'] ?? 0);
    $totalSpent = (float)($row['spent'] ?? 0);

    $result->free();
}

?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,initial-scale=1.0">
<meta name="theme-color" content="#071a31">
<title>ASOVERIFY - IPE Status Control</title>

<style>
*{box-sizing:border-box;margin:0;padding:0}
html,body{min-height:100%}
body{
    font-family:Inter,-apple-system,BlinkMacSystemFont,"Segoe UI",Arial,sans-serif;
    background:
        radial-gradient(circle at top right,rgba(0,191,255,.13),transparent 30%),
        linear-gradient(135deg,#03101f 0%,#071a31 48%,#09152a 100%);
    color:#fff;
    min-height:100vh;
    padding:22px;
}
.container{width:100%;max-width:1450px;margin:auto}
.topbar{
    display:flex;align-items:center;justify-content:space-between;gap:15px;
    padding:20px 24px;margin-bottom:20px;border-radius:22px;
    background:linear-gradient(135deg,rgba(12,54,87,.92),rgba(7,28,52,.94));
    border:1px solid rgba(0,191,255,.15);
    box-shadow:0 15px 50px rgba(0,0,0,.25)
}
.brand{display:flex;align-items:center;gap:14px}
.brand-icon{
    width:56px;height:56px;border-radius:17px;
    display:flex;align-items:center;justify-content:center;
    font-size:26px;background:linear-gradient(135deg,#00bfff,#087dff);
    box-shadow:0 8px 25px rgba(0,191,255,.30)
}
.brand h1{font-size:23px;letter-spacing:.3px}
.brand p{color:#7fc8e8;margin-top:3px;font-size:12px}
.admin-pill{
    padding:11px 16px;border-radius:30px;background:rgba(0,191,255,.10);
    border:1px solid rgba(0,191,255,.22);color:#7fdcff;font-size:12px;font-weight:700
}
.stats-grid{
    display:grid;grid-template-columns:repeat(4,minmax(0,1fr));
    gap:16px;margin-bottom:20px
}
.stat-card{
    position:relative;overflow:hidden;min-height:175px;padding:22px;border-radius:22px;
    background:linear-gradient(145deg,rgba(17,49,77,.94),rgba(10,28,51,.96));
    border:1px solid rgba(90,145,190,.13);box-shadow:0 15px 40px rgba(0,0,0,.20)
}
.stat-card:after{
    content:"";position:absolute;width:120px;height:120px;border-radius:50%;
    right:-50px;top:-50px;background:rgba(0,191,255,.10)
}
.stat-icon{
    width:43px;height:43px;border-radius:13px;display:flex;align-items:center;
    justify-content:center;background:rgba(0,191,255,.12);color:#00bfff;
    font-size:20px;margin-bottom:14px
}
.stat-title{font-size:12px;letter-spacing:1.2px;color:#76cce9;font-weight:800;margin-bottom:12px}
.stat-row{
    display:flex;align-items:center;justify-content:space-between;gap:10px;
    padding:8px 0;border-bottom:1px solid rgba(255,255,255,.045)
}
.stat-row:last-child{border-bottom:0}
.stat-label{color:#8294a9;font-size:13px}
.stat-value{color:#fff;font-size:14px;font-weight:800;white-space:nowrap}
.toolbar{
    display:grid;grid-template-columns:minmax(250px,1fr) 190px 95px 95px;
    gap:10px;padding:14px;border-radius:20px;background:rgba(9,27,48,.92);
    border:1px solid rgba(255,255,255,.06);margin-bottom:16px
}
.search-box{position:relative}
.search-box span{
    position:absolute;left:14px;top:50%;transform:translateY(-50%);
    color:#66819b;font-size:17px
}
input,select,textarea{
    width:100%;border:0;outline:none;color:#eaf7ff;background:#071a30;
    border:1px solid rgba(255,255,255,.07);border-radius:13px;font-family:inherit
}
.search-box input{height:48px;padding:0 15px 0 43px}
select{height:48px;padding:0 13px}
textarea{min-height:75px;padding:12px;resize:vertical}
input:focus,select:focus,textarea:focus{
    border-color:rgba(0,191,255,.55);box-shadow:0 0 0 3px rgba(0,191,255,.08)
}
.btn{
    height:48px;border:0;border-radius:13px;cursor:pointer;font-weight:800;color:#fff;
    transition:.2s ease
}
.btn:hover{transform:translateY(-1px)}
.btn-primary{background:linear-gradient(135deg,#00bfff,#0784ff);box-shadow:0 8px 22px rgba(0,160,255,.20)}
.btn-secondary{background:rgba(255,255,255,.045);border:1px solid rgba(255,255,255,.07)}
.table-card{
    overflow:hidden;border-radius:22px;background:rgba(9,27,48,.96);
    border:1px solid rgba(255,255,255,.055);box-shadow:0 18px 55px rgba(0,0,0,.22)
}
.table-scroll{width:100%;overflow-x:auto}
table{width:100%;min-width:1180px;border-collapse:collapse}
thead{background:linear-gradient(90deg,#0b3151,#103b5e)}
th{
    padding:15px 13px;text-align:left;color:#80d9f6;font-size:11px;
    letter-spacing:.7px;white-space:nowrap
}
td{
    padding:15px 13px;border-top:1px solid rgba(255,255,255,.045);
    font-size:12px;color:#d6e4ef;vertical-align:middle
}
tbody tr{transition:.2s ease}
tbody tr:hover{background:rgba(0,191,255,.035)}
.id-badge{
    display:inline-flex;padding:7px 9px;border-radius:9px;
    background:rgba(255,255,255,.06);color:#d7e5ef;font-weight:800
}
.customer{display:flex;align-items:center;gap:8px;max-width:210px;word-break:break-word}
.customer-icon{color:#00bfff;font-size:15px}
.tracking{color:#f0f7fb;font-weight:800;letter-spacing:.3px;word-break:break-all}
.amount{color:#00d7ff;font-weight:900;white-space:nowrap}
.reply-box{
    min-width:160px;max-width:220px;padding:11px;border-radius:10px;
    background:#06172b;border:1px solid rgba(255,255,255,.045);
    color:#bfe9f7;word-break:break-word;line-height:1.45
}
.no-reply{color:#526a80}
.status{
    display:inline-flex;align-items:center;gap:6px;padding:7px 10px;border-radius:30px;
    font-size:10px;font-weight:900;white-space:nowrap
}
.status:before{content:"";width:7px;height:7px;border-radius:50%;background:currentColor}
.status-pending{color:#ffc400;background:rgba(255,196,0,.10)}
.status-processing{color:#43baff;background:rgba(67,186,255,.10)}
.status-successful,.status-completed{color:#25df77;background:rgba(37,223,119,.10)}
.status-failed{color:#ff6470;background:rgba(255,100,112,.10)}
.status-refunded{color:#b78cff;background:rgba(183,140,255,.10)}
.actions{display:flex;flex-wrap:wrap;gap:6px;min-width:230px}
.action-btn{
    border:0;cursor:pointer;border-radius:9px;padding:8px 10px;color:#fff;
    font-size:10px;font-weight:800;transition:.2s ease
}
.action-btn:hover{transform:translateY(-1px)}
.action-btn:disabled{opacity:.45;cursor:not-allowed;transform:none}
.inbox-btn{background:rgba(0,191,255,.13);color:#69dfff}
.edit-btn{background:rgba(116,135,255,.12);color:#a9b6ff}
.mail-btn{background:rgba(53,211,126,.11);color:#65e99a}
.refund-btn{background:rgba(255,164,62,.12);color:#ffbc70}
.pagination{
    display:flex;align-items:center;justify-content:center;flex-wrap:wrap;
    gap:6px;padding:17px
}
.page-btn{
    min-width:38px;height:38px;padding:0 10px;border:1px solid rgba(255,255,255,.07);
    background:rgba(255,255,255,.035);color:#aac1d2;border-radius:10px;cursor:pointer;font-weight:800
}
.page-btn.active{background:#00aef0;color:#fff;border-color:#00aef0}
.page-info{color:#688198;font-size:11px;margin:0 8px}
.modal{
    position:fixed;inset:0;z-index:9999;display:none;align-items:center;justify-content:center;
    padding:20px;background:rgba(0,8,18,.78);backdrop-filter:blur(7px)
}
.modal.show{display:flex}
.modal-card{
    width:100%;max-width:520px;padding:22px;border-radius:22px;
    background:linear-gradient(145deg,#102c48,#07182c);
    border:1px solid rgba(0,191,255,.18);box-shadow:0 25px 80px rgba(0,0,0,.5)
}
.modal-header{display:flex;justify-content:space-between;align-items:center;margin-bottom:18px}
.modal-header h3{font-size:18px}
.close{
    width:36px;height:36px;border:0;border-radius:10px;background:rgba(255,255,255,.06);
    color:#fff;cursor:pointer;font-size:18px
}
.form-group{margin-bottom:14px}
.form-label{
    display:block;margin-bottom:7px;color:#80a0b8;font-size:11px;
    font-weight:800;text-transform:uppercase
}
.email-modal-card{max-width:850px;max-height:88vh;overflow:hidden}
.email-meta{display:grid;grid-template-columns:1fr 1fr;gap:10px;margin-bottom:10px}
.email-meta>div,.email-subject{
    background:#07182c;border:1px solid rgba(255,255,255,.06);
    border-radius:12px;padding:11px 13px;
}
.email-meta span,.email-subject span{
    display:block;color:#6e8aa1;font-size:9px;font-weight:900;
    letter-spacing:.8px;margin-bottom:5px;
}
.email-meta strong,.email-subject strong{
    display:block;color:#dcecf6;font-size:12px;word-break:break-word;
}
.returned-email-body{
    margin-top:10px;max-height:48vh;overflow:auto;padding:18px;border-radius:14px;
    background:#f7fafc;color:#182532;white-space:pre-wrap;word-break:break-word;
    line-height:1.65;font-size:13px;border:1px solid rgba(255,255,255,.10);
}
.modal-actions{display:flex;gap:8px;margin-top:18px}
.modal-actions .btn{flex:1}
.toast{
    position:fixed;z-index:10000;right:20px;bottom:20px;max-width:360px;padding:14px 17px;
    border-radius:13px;background:#102d47;border:1px solid rgba(0,191,255,.18);
    box-shadow:0 15px 40px rgba(0,0,0,.35);color:#fff;font-size:12px;font-weight:700;
    transform:translateY(100px);opacity:0;pointer-events:none;transition:.25s ease
}
.toast.show{transform:translateY(0);opacity:1}
.toast.success{border-color:rgba(37,223,119,.25)}
.toast.error{border-color:rgba(255,80,95,.25)}
.loading{text-align:center;padding:45px;color:#668198;font-size:13px}
.spinner{
    display:inline-block;width:24px;height:24px;border:3px solid rgba(255,255,255,.10);
    border-top-color:#00bfff;border-radius:50%;animation:spin .7s linear infinite;margin-bottom:10px
}
@keyframes spin{to{transform:rotate(360deg)}}
@media(max-width:1100px){
    .stats-grid{grid-template-columns:repeat(2,minmax(0,1fr))}
}
@media(max-width:760px){
    .email-modal-card{max-height:92vh}
    .email-meta{grid-template-columns:1fr}
    .returned-email-body{max-height:50vh;padding:14px}
    body{padding:10px}
    .topbar{padding:16px;border-radius:17px}
    .brand-icon{width:48px;height:48px}
    .brand h1{font-size:19px}
    .admin-pill{display:none}
    .stats-grid{grid-template-columns:1fr;gap:10px}
    .stat-card{min-height:150px;padding:18px}
    .toolbar{grid-template-columns:1fr;padding:10px}
    .table-card{border-radius:16px}
    .customer{max-width:170px}
    .toast{left:10px;right:10px;bottom:10px;max-width:none}
}
</style>
</head>

<body>

<div class="container">

    <div class="topbar">
        <div class="brand">
            <div class="brand-icon">🛡️</div>
            <div>
                <h1>ASOVERIFY</h1>
                <p>IPE Status Control</p>
            </div>
        </div>

        <div class="admin-pill">👥 ADMIN PANEL</div>
    </div>

    <div class="stats-grid">

        <div class="stat-card">
            <div class="stat-icon">📅</div>
            <div class="stat-title">TODAY</div>
            <div class="stat-row">
                <span class="stat-label">Today Count</span>
                <span class="stat-value"><?=number_format((int)$todayCount)?></span>
            </div>
            <div class="stat-row">
                <span class="stat-label">Today Spent</span>
                <span class="stat-value">₦<?=number_format((float)$todaySpent, 2)?></span>
            </div>
        </div>

        <div class="stat-card">
            <div class="stat-icon">🗓️</div>
            <div class="stat-title">WEEKLY</div>
            <div class="stat-row">
                <span class="stat-label">Weekly Count</span>
                <span class="stat-value"><?=number_format((int)$weeklyCount)?></span>
            </div>
            <div class="stat-row">
                <span class="stat-label">Weekly Spent</span>
                <span class="stat-value">₦<?=number_format((float)$weeklySpent, 2)?></span>
            </div>
        </div>

        <div class="stat-card">
            <div class="stat-icon">📊</div>
            <div class="stat-title">MONTHLY</div>
            <div class="stat-row">
                <span class="stat-label">Monthly Count</span>
                <span class="stat-value"><?=number_format((int)$monthlyCount)?></span>
            </div>
            <div class="stat-row">
                <span class="stat-label">Monthly Spent</span>
                <span class="stat-value">₦<?=number_format((float)$monthlySpent, 2)?></span>
            </div>
            <div class="stat-row">
                <span class="stat-label">Last Month Spent</span>
                <span class="stat-value">₦<?=number_format((float)$lastMonthSpent, 2)?></span>
            </div>
        </div>

        <div class="stat-card">
            <div class="stat-icon">📈</div>
            <div class="stat-title">TOTAL</div>
            <div class="stat-row">
                <span class="stat-label">Total Count</span>
                <span class="stat-value"><?=number_format((int)$totalCount)?></span>
            </div>
            <div class="stat-row">
                <span class="stat-label">Total Spent</span>
                <span class="stat-value">₦<?=number_format((float)$totalSpent, 2)?></span>
            </div>
        </div>

    </div>

    <div class="toolbar">

        <div class="search-box">
            <span>🔍</span>
            <input
                type="text"
                id="searchInput"
                placeholder="Search NIN, Tracking ID, Transaction ID or Email"
                autocomplete="off"
            >
        </div>

        <select id="statusFilter">
            <option value="">All Status</option>
            <option value="PENDING">Pending</option>
            <option value="PROCESSING">Processing</option>
            <option value="SUCCESSFUL">Successful</option>
            <option value="COMPLETED">Completed</option>
            <option value="FAILED">Failed</option>
            <option value="REFUNDED">Refunded</option>
        </select>

        <button class="btn btn-primary" type="button" onclick="searchRequests()">🔍 Search</button>
        <button class="btn btn-secondary" type="button" onclick="resetSearch()">↻ Reset</button>

    </div>

    <div class="table-card">

        <div class="table-scroll">
            <table>
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>CUSTOMER</th>
                        <th>TRACKING</th>
                        <th>NIN</th>
                        <th>AMOUNT</th>
                        <th>STATUS</th>
                        <th>REPLY</th>
                        <th>ACTIONS</th>
                    </tr>
                </thead>

                <tbody id="requestsBody">
                    <tr>
                        <td colspan="8" class="loading">
                            <div class="spinner"></div>
                            <br>
                            Loading requests...
                        </td>
                    </tr>
                </tbody>
            </table>
        </div>

        <div class="pagination" id="pagination"></div>

    </div>

</div>

<!-- NIMC RETURNED EMAIL MODAL -->
<div class="modal" id="emailModal">
    <div class="modal-card email-modal-card">

        <div class="modal-header">
            <div>
                <h3>📩 NIMC Returned Email</h3>
                <div style="margin-top:5px;color:#6f8ba2;font-size:11px;">
                    Tracking ID:
                    <strong id="emailTracking" style="color:#00bfff"></strong>
                </div>
            </div>
            <button class="close" type="button" onclick="closeEmailModal()">×</button>
        </div>

        <div class="email-meta">
            <div>
                <span>FROM</span>
                <strong id="emailFrom">—</strong>
            </div>
            <div>
                <span>DATE</span>
                <strong id="emailDate">—</strong>
            </div>
        </div>

        <div class="email-subject">
            <span>SUBJECT</span>
            <strong id="emailSubject">—</strong>
        </div>

        <div class="returned-email-body" id="emailBody"></div>

        <div class="modal-actions">
            <button class="btn btn-primary" type="button" onclick="closeEmailModal()">Close</button>
        </div>

    </div>
</div>

<!-- EDIT MODAL -->
<div class="modal" id="editModal">
    <div class="modal-card">

        <div class="modal-header">
            <h3>✏️ Edit IPE Request</h3>
            <button class="close" type="button" onclick="closeEditModal()">×</button>
        </div>

        <input type="hidden" id="editId">

        <div class="form-group">
            <label class="form-label">Status</label>
            <select id="editStatus">
                <option value="PENDING">PENDING</option>
                <option value="PROCESSING">PROCESSING</option>
                <option value="SUCCESSFUL">SUCCESSFUL</option>
                <option value="FAILED">FAILED</option>
                <option value="COMPLETED">COMPLETED</option>
                <option value="REFUNDED">REFUNDED</option>
            </select>
        </div>

        <div class="form-group">
            <label class="form-label">Admin Reply</label>
            <textarea id="editReply" placeholder="Enter admin reply..."></textarea>
        </div>

        <div class="modal-actions">
            <button class="btn btn-secondary" type="button" onclick="closeEditModal()">Cancel</button>
            <button class="btn btn-primary" type="button" onclick="saveEdit()">💾 Save Changes</button>
        </div>

    </div>
</div>

<div class="toast" id="toast"></div>

<script>
let currentPage = 1;
let currentSearch = '';
let currentStatus = '';
let loadingRequests = false;

function showToast(message, type = 'success') {
    const toast = document.getElementById('toast');

    toast.textContent = message;
    toast.className = 'toast show ' + type;

    clearTimeout(window.toastTimer);

    window.toastTimer = setTimeout(() => {
        toast.classList.remove('show');
    }, 3500);
}

function escapeHtml(value) {
    return String(value ?? '')
        .replace(/&/g, '&amp;')
        .replace(/</g, '&lt;')
        .replace(/>/g, '&gt;')
        .replace(/"/g, '&quot;')
        .replace(/'/g, '&#039;');
}

function formatMoney(value) {
    const number = Number(value || 0);

    return '₦' + number.toLocaleString('en-NG', {
        minimumFractionDigits: 2,
        maximumFractionDigits: 2
    });
}

function statusHtml(status) {
    const clean = String(status || '').toUpperCase();

    return `<span class="status status-${clean.toLowerCase()}">${escapeHtml(clean)}</span>`;
}

async function postAction(fd) {
    const response = await fetch(window.location.href, {
        method: 'POST',
        body: fd,
        credentials: 'same-origin',
        headers: {
            'X-Requested-With': 'XMLHttpRequest',
            'Accept': 'application/json'
        }
    });

    const text = await response.text();

    try {
        return JSON.parse(text);
    } catch (err) {
        throw new Error('Server returned an invalid response. Check PHP error log.');
    }
}

async function loadRequests(page = 1) {
    if (loadingRequests) {
        return;
    }

    loadingRequests = true;

    const body = document.getElementById('requestsBody');

    body.innerHTML = `
        <tr>
            <td colspan="8" class="loading">
                <div class="spinner"></div><br>Loading requests...
            </td>
        </tr>
    `;

    const fd = new FormData();

    fd.append('action', 'load_requests');
    fd.append('search', currentSearch);
    fd.append('status', currentStatus);
    fd.append('page', page);

    try {
        const data = await postAction(fd);

        if (!data.success) {
            throw new Error(data.message || 'Could not load requests.');
        }

        currentPage = Number(data.page || 1);

        renderRequests(data.rows || []);

        renderPagination(
            Number(data.total_pages || 1),
            currentPage,
            Number(data.total_rows || 0)
        );

    } catch (error) {
        body.innerHTML = `
            <tr>
                <td colspan="8" class="loading">❌ ${escapeHtml(error.message)}</td>
            </tr>
        `;

        showToast(error.message, 'error');

    } finally {
        loadingRequests = false;
    }
}

function renderRequests(rows) {
    const body = document.getElementById('requestsBody');

    if (!rows.length) {
        body.innerHTML = `
            <tr>
                <td colspan="8" class="loading">📭 No requests found.</td>
            </tr>
        `;

        return;
    }

    body.innerHTML = rows.map(row => {
        const reply = String(row.reply || '').trim();

        const replyHtml = reply !== ''
            ? escapeHtml(reply)
            : '<span class="no-reply">No reply</span>';

        const failed = String(row.status || '').toUpperCase() === 'FAILED';

        const refundButton = failed
            ? `<button class="action-btn refund-btn" onclick="refundRequest(${Number(row.id)})">💰 Refund 80%</button>`
            : '';

        const safeRow = encodeURIComponent(JSON.stringify(row));

        const subRef = row.reference || row.transaction_id
            ? `<div style="margin-top:5px;color:#5e768d;font-size:10px;">${escapeHtml(row.reference || row.transaction_id)}</div>`
            : '';

        return `
            <tr>
                <td><span class="id-badge">#${Number(row.id)}</span></td>

                <td>
                    <div class="customer">
                        <span class="customer-icon">👤</span>
                        <span>${escapeHtml(row.user_email)}</span>
                    </div>
                </td>

                <td>
                    <div class="tracking">${escapeHtml(row.tracking_id)}</div>
                    ${subRef}
                </td>

                <td>${row.nin ? escapeHtml(row.nin) : '<span style="color:#526a80">—</span>'}</td>

                <td><span class="amount">${formatMoney(row.amount)}</span></td>

                <td>${statusHtml(row.status)}</td>

                <td><div class="reply-box">${replyHtml}</div></td>

                <td>
                    <div class="actions">
                        <button class="action-btn inbox-btn" onclick="viewEmail(${Number(row.id)}, this)">👁️ View Email</button>
                        <button class="action-btn edit-btn" onclick="openEditModalEncoded('${safeRow}')">✏️ Edit</button>
                        <button class="action-btn mail-btn" onclick="sendEmail(${Number(row.id)}, this)">✉️ Send</button>
                        ${refundButton}
                    </div>
                </td>
            </tr>
        `;
    }).join('');
}

function openEditModalEncoded(encoded) {
    try {
        openEditModal(JSON.parse(decodeURIComponent(encoded)));
    } catch (e) {
        showToast('Could not open request editor.', 'error');
    }
}

function renderPagination(totalPages, page, totalRows) {
    const container = document.getElementById('pagination');

    if (totalPages <= 1) {
        container.innerHTML = `<span class="page-info">${totalRows} request(s)</span>`;
        return;
    }

    let html = '';

    if (page > 1) {
        html += `<button class="page-btn" onclick="goPage(${page - 1})">‹</button>`;
    }

    const start = Math.max(1, page - 2);
    const end = Math.min(totalPages, page + 2);

    for (let i = start; i <= end; i++) {
        html += `<button class="page-btn ${i === page ? 'active' : ''}" onclick="goPage(${i})">${i}</button>`;
    }

    if (page < totalPages) {
        html += `<button class="page-btn" onclick="goPage(${page + 1})">›</button>`;
    }

    html += `<span class="page-info">${totalRows} request(s)</span>`;

    container.innerHTML = html;
}

function goPage(page) {
    loadRequests(page);
}

function searchRequests() {
    currentSearch = document.getElementById('searchInput').value.trim();
    currentStatus = document.getElementById('statusFilter').value;

    loadRequests(1);
}

function resetSearch() {
    document.getElementById('searchInput').value = '';
    document.getElementById('statusFilter').value = '';

    currentSearch = '';
    currentStatus = '';

    loadRequests(1);
}

document.getElementById('searchInput').addEventListener('keydown', function (event) {
    if (event.key === 'Enter') {
        searchRequests();
    }
});

document.getElementById('statusFilter').addEventListener('change', function () {
    currentStatus = this.value;
    loadRequests(1);
});

async function viewEmail(id, button) {
    const original = button.innerHTML;

    button.disabled = true;
    button.innerHTML = '⏳ Opening...';

    const fd = new FormData();

    fd.append('action', 'view_email');
    fd.append('id', id);

    try {
        const data = await postAction(fd);

        if (!data.success) {
            throw new Error(data.message || 'Could not find returned email.');
        }

        openEmailModal(data);

    } catch (error) {
        showToast(error.message, 'error');

    } finally {
        button.disabled = false;
        button.innerHTML = original;
    }
}

function openEmailModal(data) {
    document.getElementById('emailTracking').textContent = data.tracking_id || '';
    document.getElementById('emailSubject').textContent = data.subject || '(No subject)';
    document.getElementById('emailFrom').textContent = data.from || 'Unknown sender';
    document.getElementById('emailDate').textContent = data.date || 'Unknown date';
    document.getElementById('emailBody').textContent = data.body || '(Empty email body)';

    document.getElementById('emailModal').classList.add('show');
}

function closeEmailModal() {
    document.getElementById('emailModal').classList.remove('show');
}

function openEditModal(row) {
    document.getElementById('editId').value = row.id;
    document.getElementById('editStatus').value = String(row.status || 'PENDING').toUpperCase();
    document.getElementById('editReply').value = row.reply || '';

    document.getElementById('editModal').classList.add('show');
}

function closeEditModal() {
    document.getElementById('editModal').classList.remove('show');
}

async function saveEdit() {
    const fd = new FormData();

    fd.append('action', 'update_request');
    fd.append('id', document.getElementById('editId').value);
    fd.append('status', document.getElementById('editStatus').value);
    fd.append('reply', document.getElementById('editReply').value);

    try {
        const data = await postAction(fd);

        if (!data.success) {
            throw new Error(data.message || 'Could not save changes.');
        }

        closeEditModal();
        showToast(data.message, 'success');

        await loadRequests(currentPage);

    } catch (error) {
        showToast(error.message, 'error');
    }
}

async function sendEmail(id, button) {
    const original = button.innerHTML;

    if (!confirm(
        'Send IPE processing error email to NIMC Customer Care?\n\n' +
        'The email will contain only the tracking ID and will not contain the NIN.'
    )) {
        return;
    }

    button.disabled = true;
    button.innerHTML = '⏳ Sending...';

    const fd = new FormData();

    fd.append('action', 'send_email');
    fd.append('id', id);

    try {
        const data = await postAction(fd);

        if (!data.success) {
            throw new Error(data.message || 'Email failed.');
        }

        showToast(data.message, 'success');

    } catch (error) {
        showToast(error.message, 'error');

    } finally {
        button.disabled = false;
        button.innerHTML = original;
    }
}

async function refundRequest(id) {
    if (!confirm(
        'Refund 80% of this FAILED request to the customer wallet?\n\n' +
        'This action cannot be reversed.'
    )) {
        return;
    }

    const fd = new FormData();

    fd.append('action', 'refund');
    fd.append('id', id);

    try {
        const data = await postAction(fd);

        if (!data.success) {
            throw new Error(data.message || 'Refund failed.');
        }

        showToast(
            data.message +
            (data.refund_amount !== undefined
                ? ' Refunded: ' + formatMoney(data.refund_amount)
                : ''),
            'success'
        );

        await loadRequests(currentPage);

    } catch (error) {
        showToast(error.message, 'error');
    }
}

document.getElementById('editModal').addEventListener('click', function (event) {
    if (event.target === this) {
        closeEditModal();
    }
});

document.getElementById('emailModal').addEventListener('click', function (event) {
    if (event.target === this) {
        closeEmailModal();
    }
});

loadRequests(1);
</script>

</body>
</html>
