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/pennagaram.org/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: promotion-requests.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        if ($_POST['action'] === 'update_status') {
            $requestId = (int)$_POST['request_id'];
            $status = mysqli_real_escape_string($conn, $_POST['status']);
            $adminNotes = mysqli_real_escape_string($conn, $_POST['admin_notes']);
            
            // Fixed: Removed updated_at column
            $updateSql = "UPDATE promotion_requests SET status = ?, admin_notes = ? WHERE id = ?";
            $stmt = mysqli_prepare($conn, $updateSql);
            mysqli_stmt_bind_param($stmt, 'ssi', $status, $adminNotes, $requestId);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Promotion request status updated successfully!";
            } else {
                $errorMsg = "Error updating promotion request: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
            
        } elseif ($_POST['action'] === 'delete_request') {
            $requestId = (int)$_POST['request_id'];
            
            $deleteSql = "DELETE FROM promotion_requests WHERE id = ?";
            $stmt = mysqli_prepare($conn, $deleteSql);
            mysqli_stmt_bind_param($stmt, 'i', $requestId);
            
            if (mysqli_stmt_execute($stmt)) {
                $successMsg = "Promotion request deleted successfully!";
            } else {
                $errorMsg = "Error deleting promotion request: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        }
    }
}

// Fetch promotion requests
$requestsSql = "SELECT * FROM promotion_requests ORDER BY created_at DESC";
$requestsResult = mysqli_query($conn, $requestsSql);
$promotionRequests = [];
if ($requestsResult && mysqli_num_rows($requestsResult) > 0) {
    while ($row = mysqli_fetch_assoc($requestsResult)) {
        $promotionRequests[] = $row;
    }
}

// Count statistics
$totalRequests = count($promotionRequests);
$pendingRequests = count(array_filter($promotionRequests, function($request) {
    return $request['status'] === 'pending';
}));
$approvedRequests = count(array_filter($promotionRequests, function($request) {
    return $request['status'] === 'approved';
}));
$rejectedRequests = count(array_filter($promotionRequests, function($request) {
    return $request['status'] === 'rejected';
}));
?>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>
    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>
    
    
    
    
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Promotion Requests Management</h4>
                            <div class="d-flex gap-2">
                                <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                    <i class="fas fa-file-excel me-2"></i>Export to Excel
                                </button>
                                <button type="button" class="btn btn-info" onclick="printRequests()">
                                    <i class="fas fa-print me-2"></i>Print
                                </button>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <?php echo $successMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                <?php if (isset($errorMsg)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <?php echo $errorMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-primary mt-2"><?php echo $totalRequests; ?></h3> Total Requests
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-warning mt-2"><?php echo $pendingRequests; ?></h3> Pending
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-success mt-2"><?php echo $approvedRequests; ?></h3> Approved
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 col-sm-6">
                        <div class="card text-center">
                            <div class="mb-2 card-body text-muted">
                                <h3 class="text-danger mt-2"><?php echo $rejectedRequests; ?></h3> Rejected
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title mb-0">All Promotion Requests</h4>
                                    <div class="d-flex gap-2">
                                        <select class="form-select form-select-sm" id="statusFilter" style="width: auto;">
                                            <option value="">All Status</option>
                                            <option value="pending">Pending</option>
                                            <option value="approved">Approved</option>
                                            <option value="rejected">Rejected</option>
                                        </select>
                                        <input type="text" class="form-control form-control-sm" id="searchInput" placeholder="Search..." style="width: 200px;">
                                    </div>
                                </div>

<?php if (empty($promotionRequests)): ?>
                                    <div class="text-center py-5">
                                        <i class="fas fa-bullhorn fa-3x text-muted mb-3"></i>
                                        <h5>No Promotion Requests</h5>
                                        <p class="text-muted">No business promotion requests have been submitted yet.</p>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered mb-0" id="requestsTable">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Business Info</th>
                                                    <th>Contact Info</th>
                                                    <th>Business Details</th>
                                                    <th>Status</th>
                                                    <th>Submitted</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($promotionRequests as $index => $request): 
                                                    $statusClass = [
                                                        'pending' => 'warning',
                                                        'approved' => 'success',
                                                        'rejected' => 'danger'
                                                    ][$request['status']] ?? 'secondary';
                                                ?>
                                                    <tr data-status="<?php echo $request['status']; ?>">
                                                        <td><?php echo $index + 1; ?></td>
                                                        <td>
                                                            <div class="d-flex align-items-start">
                                                                <div class="flex-grow-1">
                                                                    <h6 class="mb-1"><?php echo htmlspecialchars($request['business_name']); ?></h6>
                                                                    <small class="text-muted">
                                                                        <i class="fas fa-building me-1"></i>
                                                                        <?php echo htmlspecialchars(ucfirst($request['business_type'])); ?>
                                                                    </small>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <div><i class="fas fa-user me-1"></i><?php echo htmlspecialchars($request['contact_name']); ?></div>
                                                                <div><i class="fas fa-phone me-1"></i><?php echo htmlspecialchars($request['phone']); ?></div>
                                                                <div><i class="fas fa-envelope me-1"></i><?php echo htmlspecialchars($request['email']); ?></div>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <div class="text-truncate" style="max-width: 200px;" title="<?php echo htmlspecialchars($request['business_description']); ?>">
                                                                    <strong>Description:</strong> <?php echo htmlspecialchars(substr($request['business_description'], 0, 50)); ?>...
                                                                </div>
                                                                <div class="text-truncate" style="max-width: 200px;" title="<?php echo htmlspecialchars($request['business_address']); ?>">
                                                                    <strong>Address:</strong> <?php echo htmlspecialchars(substr($request['business_address'], 0, 50)); ?>...
                                                                </div>
                                                                <?php if ($request['website']): ?>
                                                                    <div><strong>Website:</strong> <?php echo htmlspecialchars($request['website']); ?></div>
                                                                <?php endif; ?>
                                                                <?php if ($request['social_media']): ?>
                                                                    <div><strong>Social:</strong> <?php echo htmlspecialchars($request['social_media']); ?></div>
                                                                <?php endif; ?>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $statusClass; ?>">
                                                                <?php echo ucfirst($request['status']); ?>
                                                            </span>
                                                            <?php if ($request['admin_notes']): ?>
                                                                <br>
                                                                <small class="text-muted" title="<?php echo htmlspecialchars($request['admin_notes']); ?>">
                                                                    <i class="fas fa-sticky-note me-1"></i>Has notes
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <small>
                                                                <?php echo date('M j, Y', strtotime($request['created_at'])); ?><br>
                                                                <span class="text-muted"><?php echo date('g:i A', strtotime($request['created_at'])); ?></span>
                                                            </small>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm">
                                                                <button type="button" class="btn btn-primary view-request" 
                                                                        data-bs-toggle="modal" 
                                                                        data-bs-target="#viewRequestModal"
                                                                        data-request='<?php echo json_encode($request); ?>'>
                                                                    <i class="fas fa-eye"></i>
                                                                </button>
                                                                <button type="button" class="btn btn-warning edit-status" 
                                                                        data-bs-toggle="modal" 
                                                                        data-bs-target="#editStatusModal"
                                                                        data-request-id="<?php echo $request['id']; ?>"
                                                                        data-current-status="<?php echo $request['status']; ?>"
                                                                        data-current-notes="<?php echo htmlspecialchars($request['admin_notes']); ?>">
                                                                    <i class="fas fa-edit"></i>
                                                                </button>
                                                                <form method="post" class="d-inline" onsubmit="return confirm('Are you sure you want to delete this promotion request?')">
                                                                    <input type="hidden" name="action" value="delete_request">
                                                                    <input type="hidden" name="request_id" value="<?php echo $request['id']; ?>">
                                                                    <button type="submit" class="btn btn-danger">
                                                                        <i class="fas fa-trash"></i>
                                                                    </button>
                                                                </form>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>

<div class="modal fade" id="viewRequestModal" tabindex="-1" aria-labelledby="viewRequestModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="viewRequestModalLabel">Promotion Request Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="requestDetails">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="editStatusModal" tabindex="-1" aria-labelledby="editStatusModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editStatusModalLabel">Update Request Status</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="post">
                <div class="modal-body">
                    <input type="hidden" name="action" value="update_status">
                    <input type="hidden" name="request_id" id="editRequestId">
                    
                    <div class="mb-3">
                        <label for="status" class="form-label">Status</label>
                        <select class="form-select" id="status1" name="status" required>
                            <option value="pending">Pending</option>
                            <option value="approved">Approved</option>
                            <option value="rejected">Rejected</option>
                        </select>
                    </div>
                    
                    <div class="mb-3">
                        <label for="admin_notes" class="form-label">Admin Notes</label>
                        <textarea class="form-control" id="admin_notes" name="admin_notes" rows="4" 
                                  placeholder="Add any notes or comments about this request..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" class="btn btn-primary">Update Status</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Export to Excel function
function exportToExcel() {
    const table = document.getElementById('requestsTable');
    const html = table.outerHTML;
    const url = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(html);
    const link = document.createElement('a');
    link.download = 'promotion-requests-' + new Date().toISOString().split('T')[0] + '.xls';
    link.href = url;
    link.click();
}

// Print function
function printRequests() {
    const printContent = document.getElementById('requestsTable').cloneNode(true);
    const printWindow = window.open('', '_blank');
    
    printWindow.document.write(`
        <html>
            <head>
                <title>Promotion Requests - ${new Date().toLocaleDateString()}</title>
                <style>
                    body { font-family: Arial, sans-serif; margin: 20px; }
                    table { width: 100%; border-collapse: collapse; }
                    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                    th { background-color: #f8f9fa; }
                    .badge { padding: 4px 8px; border-radius: 4px; color: white; }
                    .bg-warning { background-color: #ffc107; }
                    .bg-success { background-color: #198754; }
                    .bg-danger { background-color: #dc3545; }
                </style>
            </head>
            <body>
                <h2>Promotion Requests - ${new Date().toLocaleDateString()}</h2>
                ${printContent.outerHTML}
            </body>
        </html>
    `);
    
    printWindow.document.close();
    printWindow.print();
}
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: promotion-requests.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation