Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
includes	[ DIR ]	drwxr-xr-x	2026-03-11 22:58
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
404.php	5.09 KB	-rw-r--r--	2026-03-12 12:29
admin-profile.php	4.68 KB	-rw-r--r--	2026-03-13 19:31
assignments.php	20.91 KB	-rw-r--r--	2026-03-30 15:12
deposits.php	8.48 KB	-rw-r--r--	2026-03-12 13:18
error_log	3.7 KB	-rw-r--r--	2026-03-23 09:01
index.php	137 B	-rw-r--r--	2026-03-12 12:26
index_real.php	3.95 KB	-rw-r--r--	2026-03-13 19:31
login.php	2.46 KB	-rw-r--r--	2026-03-13 19:32
logout.php	88 B	-rw-r--r--	2026-03-11 22:57
maintenance.php	3.68 KB	-rw-r--r--	2026-03-12 12:35
payment-methods.php	7.03 KB	-rw-r--r--	2026-03-12 12:35
plans.php	7.85 KB	-rw-r--r--	2026-03-12 12:35
referrals.php	4.91 KB	-rw-r--r--	2026-03-31 10:44
settings.php	17.83 KB	-rw-r--r--	2026-03-31 10:21
tickets.php	9.89 KB	-rw-r--r--	2026-03-12 13:15
users.php	19.8 KB	-rw-r--r--	2026-03-29 05:10
withdraw-methods.php	8.28 KB	-rw-r--r--	2026-03-12 15:17
withdrawals.php	6.26 KB	-rw-r--r--	2026-03-12 15:18
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
require_once '../includes/config.php';
$error = '';
$success = $_SESSION['success'] ?? '';
unset($_SESSION['success']);

// Handle Status Change
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['change_status'])) {
    $ticket_id = (int)$_POST['ticket_id'];
    $new_status = $_POST['status'] ?? $_POST['change_status'];
    $pdo->prepare("UPDATE tickets SET status = ? WHERE id = ?")->execute([$new_status, $ticket_id]);
    $_SESSION['success'] = "Ticket status updated to " . ucfirst(str_replace('_', ' ', $new_status));
    header("Location: " . $_SERVER['PHP_SELF'] . (isset($_GET['view']) ? "?view=" . $ticket_id : ""));
    exit;
}

// Handle Reply
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['reply_ticket'])) {
    $ticket_id = (int)$_POST['ticket_id'];
    $message = trim($_POST['message']);

if (!empty($message)) {
        $pdo->prepare("INSERT INTO ticket_replies (ticket_id, sender_role, message) VALUES (?, 'admin', ?)")->execute([$ticket_id, $message]);

// Auto mark as In Progress if it was Open
        $pdo->prepare("UPDATE tickets SET status = 'in_progress' WHERE id = ? AND status = 'open'")->execute([$ticket_id]);

$_SESSION['success'] = "Reply sent successfully.";
        header("Location: tickets.php?view=" . $ticket_id);
        exit;
    }
    else {
        $error = "Reply message cannot be empty.";
    }
}

// Now include header/sidebar before outputting HTML
require_once 'includes/header.php';
require_once 'includes/sidebar.php';

// Fetch all tickets
$stmt = $pdo->query("SELECT t.*, u.full_name, u.email, (SELECT COUNT(*) FROM ticket_replies WHERE ticket_id = t.id) as reply_count FROM tickets t JOIN users u ON t.user_id = u.id ORDER BY t.id DESC");
$tickets = $stmt->fetchAll();

// View specific ticket if requested
$view_ticket = null;
$replies = [];
if (isset($_GET['view'])) {
    $id = (int)$_GET['view'];
    $stmt = $pdo->prepare("SELECT t.*, u.full_name, u.email FROM tickets t JOIN users u ON t.user_id = u.id WHERE t.id = ?");
    $stmt->execute([$id]);
    $view_ticket = $stmt->fetch();

if ($view_ticket) {
        $rStmt = $pdo->prepare("SELECT * FROM ticket_replies WHERE ticket_id = ? ORDER BY id ASC");
        $rStmt->execute([$id]);
        $replies = $rStmt->fetchAll();
    }
}
?>

<h2 style="margin-bottom:30px;">Support Tickets</h2>

<?php if ($error): ?>
    <div class="badge badge-danger" style="display:block; margin-bottom:20px; text-align:center; padding:15px; border-radius:8px;"><?php echo htmlspecialchars($error); ?></div>
<?php
endif; ?>
<?php if ($success): ?>
    <div class="badge badge-success" style="display:block; margin-bottom:20px; text-align:center; padding:15px; border-radius:8px;"><?php echo htmlspecialchars($success); ?></div>
<?php
endif; ?>

<?php if ($view_ticket): ?>
    
    <a href="tickets.php" class="btn-outline" style="margin-bottom:20px; display:inline-block;"><i class="fas fa-arrow-left"></i> Back to All Tickets</a>
    
    <div class="card" style="padding:20px; margin-bottom:30px; text-align:left;">
        <div style="display:flex; justify-content:space-between; align-items:center;">
            <h3 style="color:var(--primary-color);">Subject: <?php echo htmlspecialchars($view_ticket['subject']); ?></h3>
            <span class="badge <?php echo $view_ticket['status'] == 'open' ? 'badge-danger' : ($view_ticket['status'] == 'in_progress' ? 'badge-pending' : 'badge-success'); ?>">
                <?php echo ucfirst(str_replace('_', ' ', $view_ticket['status'])); ?>
            </span>
        </div>
        
        <p style="color:var(--text-muted); font-size:0.9rem; margin-top:5px; border-bottom:1px solid rgba(255,255,255,0.1); padding-bottom:15px; margin-bottom:20px;">
            Submitted By: <?php echo htmlspecialchars($view_ticket['full_name']); ?> (<?php echo htmlspecialchars($view_ticket['email']); ?>) on <?php echo date('M d, Y h:i A', strtotime($view_ticket['created_at'])); ?>
        </p>

<div style="max-height: 450px; overflow-y: auto; padding-right: 15px; margin-bottom: 25px;" class="custom-scrollbar">
            
            <div style="background:rgba(255,255,255,0.05); padding:15px; border-radius:8px; margin-bottom:20px; border-left:4px solid #3498db;">
                <strong><?php echo htmlspecialchars($view_ticket['full_name']); ?> (User)</strong>
                <p style="margin-top:10px;"><?php echo nl2br(htmlspecialchars($view_ticket['message'])); ?></p>
            </div>

<?php foreach ($replies as $r): ?>
                <div style="background:rgba(255,255,255,0.05); padding:15px; border-radius:8px; margin-bottom:20px; <?php echo $r['sender_role'] == 'admin' ? 'border-left:4px solid var(--primary-color); background:rgba(0,210,106,0.05); margin-left:40px;' : 'border-left:4px solid #3498db; margin-right:40px;'; ?>">
                    <strong><?php echo $r['sender_role'] == 'admin' ? 'Admin Support Team' : htmlspecialchars($view_ticket['full_name']); ?></strong>
                    <span style="font-size:0.8rem; color:var(--text-muted); margin-left:10px;"><?php echo date('M d h:i A', strtotime($r['created_at'])); ?></span>
                    <p style="margin-top:10px;"><?php echo nl2br(htmlspecialchars($r['message'])); ?></p>
                </div>
            <?php
    endforeach; ?>
        </div>

<?php if ($view_ticket['status'] != 'resolved'): ?>
        <form method="POST" style="margin-top:30px;">
            <input type="hidden" name="ticket_id" value="<?php echo $view_ticket['id']; ?>">
            <div class="form-group">
                <label>Admin Reply</label>
                <textarea name="message" class="form-control" rows="4" required placeholder="Type your response here..."></textarea>
            </div>
            <div style="display:flex; justify-content:space-between; align-items:center;">
                <button type="submit" name="reply_ticket" class="btn-primary" style="padding:10px 30px;">Send Reply</button>
                
                
                <div style="display:flex; align-items:center; gap:10px;">
                    <span style="color:var(--text-muted); font-size:0.9rem;">Or mark as:</span>
                    <button type="submit" name="change_status" value="resolved" formaction="" class="btn-outline" style="border-color:#27ae60; color:#27ae60; padding:10px 20px;">Resolved</button>
                </div>
            </div>
        </form>
        <?php
    else: ?>
            <div class="badge badge-success" style="display:block; text-align:center; padding:15px; border-radius:8px;">This ticket is marked as Resolved. You can re-open it from the list.</div>
        <?php
    endif; ?>
    </div>

<?php
else: ?>
    
    <div class="card" style="padding:20px; overflow-x:auto;">
        <table class="admin-table">
            <thead>
                <tr>
                    <th>Ticket ID</th>
                    <th>User</th>
                    <th>Subject</th>
                    <th>Replies</th>
                    <th>Status</th>
                    <th>Actions</th>
                </tr>
            </thead>
            <tbody>
                <?php foreach ($tickets as $t): ?>
                    <tr>
                        <td style="font-weight:700;">#<?php echo $t['id']; ?></td>
                        <td>
                            <div style="font-weight:600;"><?php echo htmlspecialchars($t['full_name']); ?></div>
                            <div style="font-size:0.8rem; color:var(--text-muted);"><?php echo htmlspecialchars($t['email']); ?></div>
                        </td>
                        <td><?php echo htmlspecialchars($t['subject']); ?></td>
                        <td><span class="badge" style="background:#555; color:#fff;"><?php echo $t['reply_count']; ?></span></td>
                        <td>
                            <span class="badge <?php echo $t['status'] == 'open' ? 'badge-danger' : ($t['status'] == 'in_progress' ? 'badge-pending' : 'badge-success'); ?>">
                                <?php echo ucfirst(str_replace('_', ' ', $t['status'])); ?>
                            </span>
                        </td>
                        <td>
                            <a href="?view=<?php echo $t['id']; ?>" class="btn-primary" style="padding:5px 10px; font-size:0.8rem; box-shadow:none;"><i class="fas fa-eye"></i> View</a>
                            
                            <form method="POST" style="display:inline;">
                                <input type="hidden" name="ticket_id" value="<?php echo $t['id']; ?>">
                                <?php if ($t['status'] != 'resolved'): ?>
                                    <button type="submit" name="change_status" value="resolved" class="btn-outline" style="padding:5px 10px; font-size:0.8rem; border-color:#27ae60; color:#27ae60;" title="Mark Resolved"><i class="fas fa-check"></i></button>
                                <?php
        else: ?>
                                    <button type="submit" name="change_status" value="open" class="btn-outline" style="padding:5px 10px; font-size:0.8rem; border-color:#e74c3c; color:#e74c3c;" title="Re-open Ticket"><i class="fas fa-undo"></i></button>
                                <?php
        endif; ?>
                            </form>
                        </td>
                    </tr>
                <?php
    endforeach; ?>
                <?php if (empty($tickets)): ?>
                    <tr><td colspan="6" style="text-align:center;">No support tickets found.</td></tr>
                <?php
    endif; ?>
            </tbody>
        </table>
    </div>
<?php
endif; ?>

<?php require_once 'includes/footer.php'; ?>