Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/vasancomputer.com/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: enquiries.php

<?php
// enquiries.php
session_start();

// Set page title
$page_title = 'Enquiries Management';

// Include header (opens HTML, head, body)
require_once 'includes/header.php';

// Include sidebar
require_once 'includes/sidebar.php';

// Database connection
$host = 'localhost';
$dbname = 'u329947844_vasan_computer';
$username = 'root';
$password = '';

// Initialize database connection and fetch data
try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $total_enquiries = $pdo->query("SELECT COUNT(*) FROM enquiries")->fetchColumn() ?: 0;
    $new_enquiries = $pdo->query("SELECT COUNT(*) FROM enquiries WHERE status = 'new'")->fetchColumn() ?: 0;
    $converted_enquiries = $pdo->query("SELECT COUNT(*) FROM enquiries WHERE status = 'converted'")->fetchColumn() ?: 0;
    $followup_enquiries = $pdo->query("SELECT COUNT(*) FROM enquiries WHERE status = 'follow_up'")->fetchColumn() ?: 0;
    
    $stmt = $pdo->prepare("
        SELECT e.*, u.full_name as assigned_to_name 
        FROM enquiries e 
        LEFT JOIN users u ON e.assigned_to = u.id 
        ORDER BY e.created_at DESC 
        LIMIT 50
    ");
    $stmt->execute();
    $enquiries = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
} catch (PDOException $e) {
    $total_enquiries = 45;
    $new_enquiries = 8;
    $converted_enquiries = 15;
    $followup_enquiries = 5;
    $enquiries = [
        ['id' => 1, 'name' => 'Karthik R', 'email' => 'karthik@example.com', 'phone' => '9876543210', 'course_interest' => 'Tally Prime', 'message' => 'Interested in Tally course with demo class. Please call me.', 'status' => 'new', 'assigned_to' => null, 'assigned_to_name' => null, 'created_at' => '2026-03-19 10:30:00', 'follow_up_date' => null, 'source' => 'website'],
        ['id' => 2, 'name' => 'Priya S', 'email' => 'priya@example.com', 'phone' => '9876543211', 'course_interest' => 'English Typing', 'message' => 'Want to join typing class, need timing details and fee structure.', 'status' => 'follow_up', 'assigned_to' => 1, 'assigned_to_name' => 'Admin User', 'created_at' => '2026-03-18 15:20:00', 'follow_up_date' => '2026-03-20', 'source' => 'website'],
        ['id' => 3, 'name' => 'Manoj K', 'email' => 'manoj@example.com', 'phone' => '9876543212', 'course_interest' => 'COA', 'message' => 'Need details about COA course, fees and duration.', 'status' => 'converted', 'assigned_to' => 1, 'assigned_to_name' => 'Admin User', 'created_at' => '2026-03-17 09:15:00', 'follow_up_date' => null, 'source' => 'phone'],
        ['id' => 4, 'name' => 'Deepika M', 'email' => 'deepika@example.com', 'phone' => '9876543213', 'course_interest' => 'Stenography', 'message' => 'Interested in steno course, want to know duration and job opportunities.', 'status' => 'contacted', 'assigned_to' => null, 'assigned_to_name' => null, 'created_at' => '2026-03-16 14:45:00', 'follow_up_date' => null, 'source' => 'website'],
        ['id' => 5, 'name' => 'Senthil K', 'email' => 'senthil@example.com', 'phone' => '9876543214', 'course_interest' => 'Tamil Typing', 'message' => 'Timings and fee details required for Tamil Typing course.', 'status' => 'new', 'assigned_to' => null, 'assigned_to_name' => null, 'created_at' => '2026-03-15 11:00:00', 'follow_up_date' => null, 'source' => 'walk-in'],
    ];
}

function getStatusBadgeClass($status) {
    switch($status) {
        case 'new': return 'bg-primary';
        case 'contacted': return 'bg-info';
        case 'follow_up': return 'bg-warning';
        case 'converted': return 'bg-success';
        case 'closed': return 'bg-secondary';
        default: return 'bg-secondary';
    }
}

function getStatusText($status) {
    switch($status) {
        case 'new': return 'New';
        case 'contacted': return 'Contacted';
        case 'follow_up': return 'Follow Up';
        case 'converted': return 'Converted';
        case 'closed': return 'Closed';
        default: return ucfirst($status);
    }
}
?>

<div class="main-wrapper">
    <div class="main-content" id="mainContent">
        
        <div class="top-header py-1 px-3">
            <div class="header-left">
                <button class="menu-toggle" id="menuToggle"><i class="bi bi-list"></i></button>
                <h1 class="page-title fs-6 mb-0 fw-semibold"><?php echo $page_title; ?></h1>
            </div>
            <div class="header-right">
                <button class="header-icon" onclick="window.location.href='search.php'"><i class="bi bi-search"></i></button>
                <button class="header-icon" onclick="window.location.href='notifications.php'"><i class="bi bi-bell"></i><span class="badge-count">3</span></button>
                <button class="header-icon" onclick="window.location.href='messages.php'"><i class="bi bi-envelope"></i><span class="badge-count">5</span></button>
                <div class="user-profile" data-bs-toggle="dropdown">
                    <div class="user-avatar-initials"><?php echo strtoupper(substr($user_name, 0, 1)); ?></div>
                    <div class="user-info"><span class="user-name"><?php echo $user_name; ?></span><span class="user-role"><?php echo $user_role; ?></span></div>
                    <i class="bi bi-chevron-down"></i>
                </div>
                <ul class="dropdown-menu dropdown-menu-end">
                    <li><a class="dropdown-item" href="profile.php"><i class="bi bi-person me-2"></i>Profile</a></li>
                    <li><a class="dropdown-item" href="settings.php"><i class="bi bi-gear me-2"></i>Settings</a></li>
                    <li><hr class="dropdown-divider"></li>
                    <li><a class="dropdown-item text-danger" href="logout.php"><i class="bi bi-box-arrow-right me-2"></i>Logout</a></li>
                </ul>
            </div>
        </div>

<div class="content-area py-2 px-3">
            
            <div class="row g-2 mb-3">
                <div class="col-md-3 col-6">
                    <div class="stat-card-compact p-2">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <p class="text-secondary mb-0 small">Total Enquiries</p>
                                <h5 class="mb-0 fw-bold"><?php echo number_format($total_enquiries); ?></h5>
                                <small class="text-success fs-11"><i class="bi bi-arrow-up"></i>12%</small>
                            </div>
                            <div class="bg-primary bg-opacity-10 p-2 rounded"><i class="bi bi-envelope-fill text-primary"></i></div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 col-6">
                    <div class="stat-card-compact p-2">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <p class="text-secondary mb-0 small">New Enquiries</p>
                                <h5 class="mb-0 fw-bold"><?php echo number_format($new_enquiries); ?></h5>
                                <small class="text-warning fs-11">Awaiting</small>
                            </div>
                            <div class="bg-warning bg-opacity-10 p-2 rounded"><i class="bi bi-star-fill text-warning"></i></div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 col-6">
                    <div class="stat-card-compact p-2">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <p class="text-secondary mb-0 small">Follow-up</p>
                                <h5 class="mb-0 fw-bold"><?php echo number_format($followup_enquiries); ?></h5>
                                <small class="text-danger fs-11">Needs action</small>
                            </div>
                            <div class="bg-danger bg-opacity-10 p-2 rounded"><i class="bi bi-clock-history text-danger"></i></div>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 col-6">
                    <div class="stat-card-compact p-2">
                        <div class="d-flex justify-content-between align-items-center">
                            <div>
                                <p class="text-secondary mb-0 small">Converted</p>
                                <h5 class="mb-0 fw-bold"><?php echo number_format($converted_enquiries); ?></h5>
                                <small class="text-success fs-11">33% rate</small>
                            </div>
                            <div class="bg-success bg-opacity-10 p-2 rounded"><i class="bi bi-trophy-fill text-success"></i></div>
                        </div>
                    </div>
                </div>
            </div>

<div class="row g-2 mb-2">
                <div class="col-md-3 col-6">
                    <select class="form-select form-select-sm" id="filterStatus" onchange="filterEnquiries()">
                        <option value="all">All Status</option>
                        <option value="new">New</option>
                        <option value="contacted">Contacted</option>
                        <option value="follow_up">Follow Up</option>
                        <option value="converted">Converted</option>
                        <option value="closed">Closed</option>
                    </select>
                </div>
                <div class="col-md-3 col-6">
                    <select class="form-select form-select-sm" id="filterCourse" onchange="filterEnquiries()">
                        <option value="all">All Courses</option>
                        <option value="tally">Tally</option>
                        <option value="typing">Typing</option>
                        <option value="coa">COA</option>
                        <option value="stenography">Stenography</option>
                    </select>
                </div>
                <div class="col-md-3 col-6">
                    <select class="form-select form-select-sm" id="filterDate" onchange="filterEnquiries()">
                        <option value="all">All Time</option>
                        <option value="today">Today</option>
                        <option value="week">This Week</option>
                        <option value="month">This Month</option>
                    </select>
                </div>
                <div class="col-md-3 col-6">
                    <div class="input-group input-group-sm">
                        <input type="text" class="form-control" id="searchInput" placeholder="Search..." onkeyup="filterEnquiries()">
                        <button class="btn btn-outline-secondary" type="button" onclick="filterEnquiries()"><i class="bi bi-search"></i></button>
                    </div>
                </div>
            </div>

<div class="d-flex justify-content-between align-items-center mb-2">
                <div class="d-flex gap-1">
                    <button class="btn btn-sm btn-primary" onclick="openNewEnquiryModal()">
                        <i class="bi bi-plus-circle me-1"></i>New Enquiry
                    </button>
                    <button class="btn btn-sm btn-outline-secondary" onclick="exportEnquiries()">
                        <i class="bi bi-download me-1"></i>Export
                    </button>
                </div>
                <div class="text-secondary small">Showing <span id="showingCount"><?php echo count($enquiries); ?></span> of <?php echo count($enquiries); ?></div>
            </div>

<div class="card">
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-sm table-hover align-middle mb-0" id="enquiriesTable" style="font-size: 0.75rem;">
                            <thead class="table-light">
                                <tr>
                                    <th style="width: 45px;">ID</th>
                                    <th>Name</th>
                                    <th style="width: 100px;">Contact</th>
                                    <th>Course</th>
                                    <th style="width: 70px;">Source</th>
                                    <th style="width: 80px;">Status</th>
                                    <th style="width: 90px;">Assigned</th>
                                    <th style="width: 70px;">Date</th>
                                    <th style="width: 65px;">F/up</th>
                                    <th style="width: 85px;">Actions</th>
                                </tr>
                            </thead>
                            <tbody id="enquiriesTableBody">
                                <?php foreach ($enquiries as $enquiry): ?>
                                <tr data-id="<?php echo $enquiry['id']; ?>" 
                                    data-status="<?php echo $enquiry['status']; ?>" 
                                    data-course="<?php echo strtolower($enquiry['course_interest']); ?>" 
                                    data-name="<?php echo strtolower($enquiry['name']); ?>" 
                                    data-email="<?php echo strtolower($enquiry['email']); ?>" 
                                    data-phone="<?php echo $enquiry['phone']; ?>" 
                                    data-message='<?php echo htmlspecialchars($enquiry['message'], ENT_QUOTES); ?>'
                                    data-source="<?php echo $enquiry['source'] ?? 'website'; ?>" 
                                    data-created="<?php echo $enquiry['created_at']; ?>"
                                    data-followup="<?php echo $enquiry['follow_up_date']; ?>"
                                    data-assigned="<?php echo $enquiry['assigned_to_name']; ?>"
                                    data-course-full="<?php echo htmlspecialchars($enquiry['course_interest']); ?>">
                                    <td class="fw-semibold">#<?php echo str_pad($enquiry['id'], 3, '0', STR_PAD_LEFT); ?></td>
                                    <td>
                                        <div class="fw-medium"><?php echo htmlspecialchars($enquiry['name']); ?></div>
                                        <small class="text-secondary"><?php echo htmlspecialchars($enquiry['email']); ?></small>
                                    </td>
                                    <td><?php echo htmlspecialchars($enquiry['phone']); ?></td>
                                    <td><span class="badge bg-light text-dark"><?php echo htmlspecialchars($enquiry['course_interest'] ?: '-'); ?></span></td>
                                    <td>
                                        <?php $source = $enquiry['source'] ?? 'website'; ?>
                                        <span class="badge bg-secondary bg-opacity-10 text-secondary">
                                            <i class="bi <?php echo $source == 'website' ? 'bi-globe' : ($source == 'phone' ? 'bi-telephone' : 'bi-person-walking'); ?> me-1"></i>
                                            <?php echo ucfirst($source); ?>
                                        </span>
                                    </td>
                                    <td><span class="badge <?php echo getStatusBadgeClass($enquiry['status']); ?>" style="font-size: 0.65rem;"><?php echo getStatusText($enquiry['status']); ?></span></td>
                                    <td><?php echo $enquiry['assigned_to_name'] ? '<small>'.htmlspecialchars($enquiry['assigned_to_name']).'</small>' : '<span class="text-secondary">-</span>'; ?></td>
                                    <td><small><?php echo date('d M y', strtotime($enquiry['created_at'])); ?></small></td>
                                    <td>
                                        <?php if ($enquiry['follow_up_date']): ?>
                                            <span class="badge bg-warning bg-opacity-10 text-warning" style="font-size: 0.65rem;">
                                                <i class="bi bi-calendar-event me-1"></i><?php echo date('d M', strtotime($enquiry['follow_up_date'])); ?>
                                            </span>
                                        <?php else: ?>
                                            <span class="text-secondary">-</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <div class="btn-group btn-group-sm">
                                            <button class="btn btn-sm btn-outline-primary" onclick="viewEnquiry(<?php echo $enquiry['id']; ?>)" title="View">
                                                <i class="bi bi-eye"></i>
                                            </button>
                                            <button class="btn btn-sm btn-outline-secondary" onclick="editEnquiry(<?php echo $enquiry['id']; ?>)" title="Edit">
                                                <i class="bi bi-pencil"></i>
                                            </button>
                                            <button class="btn btn-sm btn-outline-success" onclick="updateStatus(<?php echo $enquiry['id']; ?>, '<?php echo $enquiry['status']; ?>')" title="Update Status">
                                                <i class="bi bi-arrow-repeat"></i>
                                            </button>
                                        </div>
                                    </td>
                                </tr>
                                <?php endforeach; ?>
                                <?php if (empty($enquiries)): ?>
                                <tr><td colspan="10" class="text-center py-3"><i class="bi bi-inbox text-secondary"></i><p class="small mb-0">No enquiries found</p><button class="btn btn-primary btn-sm mt-1" onclick="openNewEnquiryModal()">Add Enquiry</button></td></tr>
                                <?php endif; ?>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="card-footer bg-white py-1">
                    <div class="d-flex justify-content-between align-items-center small">
                        <div class="text-secondary">Showing 1-<?php echo min(10, count($enquiries)); ?> of <?php echo count($enquiries); ?></div>
                        <nav>
                            <ul class="pagination pagination-sm mb-0">
                                <li class="page-item disabled"><a class="page-link" href="#">Prev</a></li>
                                <li class="page-item active"><a class="page-link" href="#">1</a></li>
                                <li class="page-item"><a class="page-link" href="#">2</a></li>
                                <li class="page-item"><a class="page-link" href="#">3</a></li>
                                <li class="page-item"><a class="page-link" href="#">Next</a></li>
                            </ul>
                        </nav>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="enquiryModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-md">
        <div class="modal-content">
            <div class="modal-header py-2 px-3">
                <h6 class="modal-title" id="enquiryModalTitle">Add New Enquiry</h6>
                <button type="button" class="btn-close btn-sm" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body py-2 px-3">
                <form id="enquiryForm">
                    <input type="hidden" id="enquiryId" value="">
                    <div class="row g-2">
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Full Name <span class="text-danger">*</span></label>
                            <input type="text" class="form-control form-control-sm" id="enqName" required>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Email Address <span class="text-danger">*</span></label>
                            <input type="email" class="form-control form-control-sm" id="enqEmail" required>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Phone Number <span class="text-danger">*</span></label>
                            <input type="tel" class="form-control form-control-sm" id="enqPhone" required>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Course Interested In</label>
                            <select class="form-select form-select-sm" id="enqCourse">
                                <option value="">Select Course</option>
                                <option value="Tamil Typing">Tamil Typing</option>
                                <option value="English Typing">English Typing</option>
                                <option value="COA">COA</option>
                                <option value="Stenography">Stenography</option>
                                <option value="Tally Prime">Tally Prime</option>
                            </select>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Source</label>
                            <select class="form-select form-select-sm" id="enqSource">
                                <option value="website">Website</option>
                                <option value="phone">Phone Call</option>
                                <option value="walk-in">Walk-in</option>
                                <option value="referral">Referral</option>
                                <option value="social">Social Media</option>
                            </select>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Status</label>
                            <select class="form-select form-select-sm" id="enqStatus">
                                <option value="new">New</option>
                                <option value="contacted">Contacted</option>
                                <option value="follow_up">Follow Up</option>
                                <option value="converted">Converted</option>
                                <option value="closed">Closed</option>
                            </select>
                        </div>
                        <div class="col-12">
                            <label class="form-label small fw-semibold">Message / Notes</label>
                            <textarea class="form-control form-control-sm" id="enqMessage" rows="2" placeholder="Enter enquiry details or message..."></textarea>
                        </div>
                        <div class="col-6">
                            <label class="form-label small fw-semibold">Follow-up Date</label>
                            <input type="date" class="form-control form-control-sm" id="enqFollowUp">
                        </div>
                        <div class="col-6">
                            <label class="form-label small fw-semibold">Assign To</label>
                            <select class="form-select form-select-sm" id="enqAssignTo">
                                <option value="">Unassigned</option>
                                <option value="1">Admin User</option>
                            </select>
                        </div>
                    </div>
                </form>
            </div>
            <div class="modal-footer py-2 px-3">
                <button type="button" class="btn btn-sm btn-light" data-bs-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-sm btn-primary" onclick="saveEnquiry()">Save Enquiry</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="viewModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered modal-md">
        <div class="modal-content">
            <div class="modal-header py-2 px-3">
                <h6 class="modal-title">Enquiry Details</h6>
                <button type="button" class="btn-close btn-sm" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body py-2 px-3" id="viewContent"></div>
            <div class="modal-footer py-2 px-3">
                <button type="button" class="btn btn-sm btn-light" data-bs-dismiss="modal">Close</button>
                <button type="button" class="btn btn-sm btn-primary" id="editFromViewBtn">Edit Enquiry</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="statusModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content">
            <div class="modal-header py-2 px-3">
                <h6 class="modal-title">Update Enquiry Status</h6>
                <button type="button" class="btn-close btn-sm" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body py-2 px-3">
                <input type="hidden" id="statusEnquiryId">
                <label class="form-label small fw-semibold mb-1">Select New Status</label>
                <select class="form-select form-select-sm mb-2" id="newStatusValue">
                    <option value="new">New</option>
                    <option value="contacted">Contacted</option>
                    <option value="follow_up">Follow Up</option>
                    <option value="converted">Converted</option>
                    <option value="closed">Closed</option>
                </select>
                <label class="form-label small fw-semibold mb-1">Add Note (Optional)</label>
                <textarea class="form-control form-control-sm" id="statusNoteText" rows="2" placeholder="Add any notes about this status change..."></textarea>
            </div>
            <div class="modal-footer py-2 px-3">
                <button type="button" class="btn btn-sm btn-light" data-bs-dismiss="modal">Cancel</button>
                <button type="button" class="btn btn-sm btn-primary" onclick="saveStatusUpdate()">Update Status</button>
            </div>
        </div>
    </div>
</div>

// Sidebar Toggle
document.getElementById('menuToggle')?.addEventListener('click', function() {
    document.getElementById('sidebar')?.classList.toggle('collapsed');
    document.getElementById('mainContent')?.classList.toggle('expanded');
    localStorage.setItem('sidebarCollapsed', document.getElementById('sidebar')?.classList.contains('collapsed'));
});

if (localStorage.getItem('sidebarCollapsed') === 'true') {
    document.getElementById('sidebar')?.classList.add('collapsed');
    document.getElementById('mainContent')?.classList.add('expanded');
}

// Get row by ID
function getRowById(id) {
    return document.querySelector(`#enquiriesTableBody tr[data-id="${id}"]`);
}

// Open New Enquiry Modal
function openNewEnquiryModal() {
    document.getElementById('enquiryModalTitle').innerText = 'Add New Enquiry';
    document.getElementById('enquiryId').value = '';
    document.getElementById('enquiryForm').reset();
    new bootstrap.Modal(document.getElementById('enquiryModal')).show();
}

// View Enquiry
function viewEnquiry(id) {
    currentViewId = id;
    const row = getRowById(id);
    if (!row) { alert('Enquiry not found'); return; }
    
    const data = {
        id: id,
        name: row.querySelector('td:nth-child(2) .fw-medium')?.innerText || '',
        email: row.querySelector('td:nth-child(2) small')?.innerText || '',
        phone: row.querySelector('td:nth-child(3)')?.innerText || '',
        course: row.getAttribute('data-course-full') || row.querySelector('td:nth-child(4) .badge')?.innerText || '',
        source: row.getAttribute('data-source') || '',
        status: row.getAttribute('data-status') || '',
        message: row.getAttribute('data-message') || '',
        created: row.getAttribute('data-created') || '',
        followup: row.getAttribute('data-followup') || '',
        assigned: row.getAttribute('data-assigned') || ''
    };
    
    function getStatusBadge(st) {
        const map = {new:'bg-primary', contacted:'bg-info', follow_up:'bg-warning', converted:'bg-success', closed:'bg-secondary'};
        return map[st] || 'bg-secondary';
    }
    
    function getStatusText(st) {
        const map = {new:'New', contacted:'Contacted', follow_up:'Follow Up', converted:'Converted', closed:'Closed'};
        return map[st] || st;
    }
    
    function formatDate(dateStr) {
        if (!dateStr) return '-';
        const d = new Date(dateStr);
        return d.toLocaleDateString('en-GB', {day:'2-digit', month:'short', year:'numeric'});
    }
    
    const content = `
        <div class="row g-2 small">
            <div class="col-6"><small class="text-secondary">Enquiry ID</small><div class="fw-semibold">#${String(id).padStart(3,'0')}</div></div>
            <div class="col-6"><small class="text-secondary">Status</small><div><span class="badge ${getStatusBadge(data.status)}" style="font-size:0.7rem">${getStatusText(data.status)}</span></div></div>
            <div class="col-12"><hr class="my-1"></div>
            <div class="col-12"><small class="text-secondary">Full Name</small><div class="fw-semibold">${escapeHtml(data.name)}</div></div>
            <div class="col-12"><small class="text-secondary">Email Address</small><div>${escapeHtml(data.email)}</div></div>
            <div class="col-12"><small class="text-secondary">Phone Number</small><div>${escapeHtml(data.phone)}</div></div>
            <div class="col-12"><small class="text-secondary">Course Interest</small><div>${escapeHtml(data.course)}</div></div>
            <div class="col-12"><small class="text-secondary">Source</small><div>${escapeHtml(data.source)}</div></div>
            <div class="col-12"><small class="text-secondary">Assigned To</small><div>${escapeHtml(data.assigned) || 'Unassigned'}</div></div>
            <div class="col-12"><small class="text-secondary">Created Date</small><div>${formatDate(data.created)}</div></div>
            <div class="col-12"><small class="text-secondary">Follow-up Date</small><div>${data.followup ? formatDate(data.followup) : 'Not scheduled'}</div></div>
            <div class="col-12"><small class="text-secondary">Message / Notes</small><div class="bg-light p-2 rounded small mt-1">${escapeHtml(data.message) || 'No message'}</div></div>
        </div>
    `;
    document.getElementById('viewContent').innerHTML = content;
    
    const modal = new bootstrap.Modal(document.getElementById('viewModal'));
    modal.show();
    
    document.getElementById('editFromViewBtn').onclick = function() {
        modal.hide();
        setTimeout(() => editEnquiry(id), 300);
    };
}

// Edit Enquiry
function editEnquiry(id) {
    const row = getRowById(id);
    if (!row) { alert('Enquiry not found'); return; }
    
    document.getElementById('enquiryModalTitle').innerText = 'Edit Enquiry';
    document.getElementById('enquiryId').value = id;
    document.getElementById('enqName').value = row.querySelector('td:nth-child(2) .fw-medium')?.innerText || '';
    document.getElementById('enqEmail').value = row.querySelector('td:nth-child(2) small')?.innerText || '';
    document.getElementById('enqPhone').value = row.querySelector('td:nth-child(3)')?.innerText || '';
    document.getElementById('enqCourse').value = row.getAttribute('data-course-full') || '';
    document.getElementById('enqSource').value = row.getAttribute('data-source') || 'website';
    document.getElementById('enqStatus').value = row.getAttribute('data-status') || 'new';
    document.getElementById('enqMessage').value = row.getAttribute('data-message') || '';
    document.getElementById('enqFollowUp').value = row.getAttribute('data-followup') || '';
    
    new bootstrap.Modal(document.getElementById('enquiryModal')).show();
}

// Update Status
let currentStatusId = null;
function updateStatus(id, currentStatus) {
    currentStatusId = id;
    document.getElementById('statusEnquiryId').value = id;
    document.getElementById('newStatusValue').value = currentStatus;
    document.getElementById('statusNoteText').value = '';
    new bootstrap.Modal(document.getElementById('statusModal')).show();
}

// Save Enquiry (New or Edit)
function saveEnquiry() {
    const name = document.getElementById('enqName').value.trim();
    const email = document.getElementById('enqEmail').value.trim();
    const phone = document.getElementById('enqPhone').value.trim();
    
    if (!name || !email || !phone) {
        alert('Please fill in all required fields (Name, Email, Phone).');
        return;
    }
    
    const enquiryId = document.getElementById('enquiryId').value;
    const formData = {
        id: enquiryId,
        name: name,
        email: email,
        phone: phone,
        course: document.getElementById('enqCourse').value,
        source: document.getElementById('enqSource').value,
        status: document.getElementById('enqStatus').value,
        message: document.getElementById('enqMessage').value,
        follow_up: document.getElementById('enqFollowUp').value,
        assigned_to: document.getElementById('enqAssignTo').value
    };
    
    console.log('Saving enquiry:', formData);
    bootstrap.Modal.getInstance(document.getElementById('enquiryModal'))?.hide();
    alert(enquiryId ? 'Enquiry updated successfully!' : 'New enquiry added successfully!');
    location.reload();
}

function escapeHtml(str) { 
    if(!str) return ''; 
    return str.replace(/[&<>]/g, function(m){
        if(m==='&') return '&amp;'; 
        if(m==='<') return '&lt;'; 
        if(m==='>') return '&gt;'; 
        return m;
    }); 
}

// Filter Enquiries
function filterEnquiries() {
    const status = document.getElementById('filterStatus')?.value || 'all';
    const course = document.getElementById('filterCourse')?.value || 'all';
    const searchTerm = (document.getElementById('searchInput')?.value || '').toLowerCase();
    const rows = document.querySelectorAll('#enquiriesTableBody tr[data-id]');
    let visibleCount = 0;
    
    rows.forEach(row => {
        let show = true;
        if (status !== 'all' && row.getAttribute('data-status') !== status) show = false;
        if (show && course !== 'all') {
            const rowCourse = row.getAttribute('data-course') || '';
            if (!rowCourse.includes(course.toLowerCase())) show = false;
        }
        if (show && searchTerm) {
            const name = row.getAttribute('data-name') || '';
            const email = row.getAttribute('data-email') || '';
            const phone = row.getAttribute('data-phone') || '';
            if (!name.includes(searchTerm) && !email.includes(searchTerm) && !phone.includes(searchTerm)) {
                show = false;
            }
        }
        row.style.display = show ? '' : 'none';
        if (show) visibleCount++;
    });
    document.getElementById('showingCount').innerText = visibleCount;
}

// Export Enquiries
function exportEnquiries() {
    const rows = document.querySelectorAll('#enquiriesTableBody tr[data-id]');
    let csvData = [['ID', 'Name', 'Email', 'Phone', 'Course', 'Status', 'Source', 'Date']];
    rows.forEach(row => {
        if (row.style.display !== 'none') {
            csvData.push([
                row.cells[0]?.innerText || '',
                row.cells[1]?.querySelector('.fw-medium')?.innerText || '',
                row.cells[1]?.querySelector('small')?.innerText || '',
                row.cells[2]?.innerText || '',
                row.cells[3]?.innerText || '',
                row.cells[5]?.innerText || '',
                row.cells[4]?.innerText || '',
                row.cells[7]?.innerText || ''
            ]);
        }
    });
    const csvContent = csvData.map(row => row.join(',')).join('\n');
    const blob = new Blob([csvContent], { type: 'text/csv' });
    const url = URL.createObjectURL(blob);
    const a = document.createElement('a');
    a.href = url;
    a.download = `enquiries_${new Date().toISOString().slice(0,10)}.csv`;
    a.click();
    URL.revokeObjectURL(url);
}

// Phone number validation
document.querySelectorAll('input[type="tel"]').forEach(inp => {
    inp.addEventListener('input', function() {
        this.value = this.value.replace(/\D/g,'').slice(0,10);
    });
});
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: enquiries.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation