Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/buldhanaupdates.com/public_html/app/Views/dashboard/admin

Free Space:

8.19 TB

🔧 Quick Actions

✏️ Editing: users.php

<?php
/**
 * Admin Users Management
 */
$activeMenu = 'users';
$pageTitle = 'वापरकर्ते व्यवस्थापन';

// Pagination
$page = $_GET['page'] ?? 1;
$perPage = 20;
$offset = ($page - 1) * $perPage;

// Filters
$roleFilter = $_GET['role'] ?? '';
$statusFilter = $_GET['status'] ?? '';
$search = $_GET['search'] ?? '';
$usersColumnsData = $db->fetchAll("SHOW COLUMNS FROM users");
$userColumns = is_array($usersColumnsData) ? array_column($usersColumnsData, 'Field') : [];
$statusExpression = in_array('status', $userColumns, true)
    ? 'u.status'
    : (in_array('is_active', $userColumns, true) ? "CASE WHEN u.is_active = 1 THEN 'active' ELSE 'inactive' END" : "'active'");

// Build query
$whereConditions = ['1=1'];
$params = [];

if ($roleFilter) {
    $whereConditions[] = 'u.role_id = ?';
    $params[] = $roleFilter;
}

if ($statusFilter !== '') {
    $whereConditions[] = $statusExpression . ' = ?';
    $params[] = $statusFilter;
}

if ($search) {
    $whereConditions[] = '(u.first_name LIKE ? OR u.last_name LIKE ? OR u.email LIKE ?)';
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

$whereClause = implode(' AND ', $whereConditions);
$rolesColumnsData = $db->fetchAll("SHOW COLUMNS FROM roles");
$rolesColumns = is_array($rolesColumnsData) ? array_column($rolesColumnsData, 'Field') : [];
$roleNameExpression = in_array('slug', $rolesColumns, true) ? 'r.slug' : "REPLACE(REPLACE(LOWER(r.name), ' ', '_'), '-', '_')";

// Get users
$users = [];
$totalUsers = 0;
$totalPages = 1;
$roles = [];

try {
    $users = $db->fetchAll(
        "SELECT u.*, $roleNameExpression as role_name, r.name as role_display,
                $statusExpression as effective_status,
                (SELECT COUNT(*) FROM news_articles WHERE reporter_id = u.id) as article_count
         FROM users u
         JOIN roles r ON u.role_id = r.id
         WHERE $whereClause
         ORDER BY u.created_at DESC
         LIMIT $perPage OFFSET $offset",
        $params
    );

foreach ($users as &$user) {
        $user['status'] = $user['effective_status'];
    }
    unset($user);

$totalUsers = (int) $db->fetchColumn("SELECT COUNT(*) FROM users u WHERE $whereClause", $params);
    $totalPages = max(1, ceil($totalUsers / $perPage));
    $roles = $db->fetchAll("SELECT * FROM roles ORDER BY id");
} catch (\Throwable $e) {
    error_log('Admin users fallback: ' . $e->getMessage());
}

ob_start();
?>

<div class="flex justify-between items-center mb-6">
    <h1 class="text-2xl font-bold">वापरकर्ते व्यवस्थापन</h1>
    <a href="/dashboard/admin/users/create" class="bg-blue-600 text-white px-4 py-2 rounded-lg hover:bg-blue-700">
        <i class="fas fa-plus mr-2"></i>नवीन वापरकर्ता
    </a>
</div>

<div class="bg-white rounded-xl shadow-sm p-4 mb-6">
    <form method="GET" class="flex flex-wrap gap-4">
        <div class="flex-1 min-w-64">
            <input type="text" name="search" value="<?php echo $search; ?>" 
                   placeholder="नाव किंवा ईमेल शोधा..." 
                   class="w-full px-4 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500">
        </div>
        <select name="role" class="px-4 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500">
            <option value="">सर्व भूमिका</option>
            <?php foreach ($roles as $role): ?>
            <option value="<?php echo $role['id']; ?>" <?php echo $roleFilter == $role['id'] ? 'selected' : ''; ?>>
                <?php echo $role['name']; ?>
            </option>
            <?php endforeach; ?>
        </select>
        <select name="status" class="px-4 py-2 border rounded-lg focus:ring-2 focus:ring-blue-500">
            <option value="">सर्व स्थिती</option>
            <option value="active" <?php echo $statusFilter === 'active' ? 'selected' : ''; ?>>सक्रिय</option>
            <option value="inactive" <?php echo $statusFilter === 'inactive' ? 'selected' : ''; ?>>निष्क्रिय</option>
            <option value="banned" <?php echo $statusFilter === 'banned' ? 'selected' : ''; ?>>प्रतिबंधित</option>
        </select>
        <button type="submit" class="bg-blue-600 text-white px-6 py-2 rounded-lg hover:bg-blue-700">
            <i class="fas fa-search mr-2"></i>शोधा
        </button>
        <?php if ($search || $roleFilter || $statusFilter): ?>
        <a href="/dashboard/admin/users" class="bg-gray-200 text-gray-700 px-4 py-2 rounded-lg hover:bg-gray-300">
            साफ करा
        </a>
        <?php endif; ?>
    </form>
</div>

<div class="bg-white rounded-xl shadow-sm overflow-hidden">
    <div class="overflow-x-auto">
        <table class="w-full">
            <thead class="bg-gray-50">
                <tr>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">वापरकर्ता</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">भूमिका</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">बातम्या</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">स्थिती</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">सामील</th>
                    <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">क्रिया</th>
                </tr>
            </thead>
            <tbody class="divide-y divide-gray-200">
                <?php foreach ($users as $user): ?>
                <tr class="hover:bg-gray-50">
                    <td class="px-6 py-4">
                        <div class="flex items-center">
                            <img src="<?php echo !empty($user['avatar']) ? UPLOADS_URL . '/' . $user['avatar'] : ASSETS_URL . '/images/default-avatar.png'; ?>" 
                                 class="w-10 h-10 rounded-full bg-gray-200">
                            <div class="ml-3">
                                <p class="font-medium text-gray-900">
                                    <?php echo $user['first_name'] . ' ' . $user['last_name']; ?>
                                    <?php if ($user['id'] == $_SESSION['user_id']): ?>
                                    <span class="text-xs bg-blue-100 text-blue-700 px-2 py-0.5 rounded-full ml-2">तुम्ही</span>
                                    <?php endif; ?>
                                </p>
                                <p class="text-sm text-gray-500"><?php echo $user['email']; ?></p>
                            </div>
                        </div>
                    </td>
                    <td class="px-6 py-4">
                        <span class="px-2 py-1 rounded-full text-xs font-medium <?php 
                            echo in_array($user['role_name'], ['admin', 'super_admin'], true) ? 'bg-red-100 text-red-700' : 
                                 ($user['role_name'] === 'reporter' ? 'bg-blue-100 text-blue-700' : 'bg-gray-100 text-gray-700'); 
                        ?>">
                            <?php echo $user['role_display']; ?>
                        </span>
                    </td>
                    <td class="px-6 py-4">
                        <?php if ($user['role_name'] === 'reporter'): ?>
                        <span class="text-sm"><?php echo $user['article_count']; ?> बातम्या</span>
                        <?php else: ?>
                        <span class="text-gray-400">-</span>
                        <?php endif; ?>
                    </td>
                    <td class="px-6 py-4">
                        <span class="px-2 py-1 rounded-full text-xs font-medium <?php 
                            echo $user['effective_status'] === 'active' ? 'bg-green-100 text-green-700' : 
                                 ($user['effective_status'] === 'banned' ? 'bg-red-100 text-red-700' : 'bg-yellow-100 text-yellow-700'); 
                        ?>">
                            <?php 
                            echo $user['status'] === 'active' ? 'सक्रिय' : 
                                 ($user['status'] === 'banned' ? 'प्रतिबंधित' : 'निष्क्रिय'); 
                            ?>
                        </span>
                    </td>
                    <td class="px-6 py-4 text-sm text-gray-500">
                        <?php echo timeAgo($user['created_at']); ?>
                    </td>
                    <td class="px-6 py-4">
                        <div class="flex items-center space-x-2">
                            <a href="/dashboard/admin/users/edit/<?php echo $user['id']; ?>" 
                               class="text-blue-600 hover:text-blue-800" title="संपादन">
                                <i class="fas fa-edit"></i>
                            </a>
                            <?php if ($user['id'] != $_SESSION['user_id']): ?>
                            <button onclick="toggleStatus(<?php echo $user['id']; ?>)" 
                                    class="text-yellow-600 hover:text-yellow-800" title="स्थिती बदला">
                                <i class="fas fa-ban"></i>
                            </button>
                            <button onclick="deleteUser(<?php echo $user['id']; ?>)" 
                                    class="text-red-600 hover:text-red-800" title="हटवा">
                                <i class="fas fa-trash"></i>
                            </button>
                            <?php endif; ?>
                        </div>
                    </td>
                </tr>
                <?php endforeach; ?>
                <?php if (empty($users)): ?>
                <tr>
                    <td colspan="6" class="px-6 py-8 text-center text-gray-500">
                        कोणतेही वापरकर्ते सापडले नाहीत
                    </td>
                </tr>
                <?php endif; ?>
            </tbody>
        </table>
    </div>
    
    
    <?php if ($totalPages > 1): ?>
    <div class="px-6 py-4 border-t flex justify-between items-center">
        <p class="text-sm text-gray-500">
            <?php echo (($page - 1) * $perPage) + 1; ?> - <?php echo min($page * $perPage, $totalUsers); ?> 
            of <?php echo $totalUsers; ?> वापरकर्ते
        </p>
        <div class="flex space-x-2">
            <?php if ($page > 1): ?>
            <a href="?page=<?php echo $page - 1; ?>&search=<?php echo $search; ?>&role=<?php echo $roleFilter; ?>&status=<?php echo $statusFilter; ?>" 
               class="px-3 py-1 border rounded hover:bg-gray-50">← मागील</a>
            <?php endif; ?>
            <?php if ($page < $totalPages): ?>
            <a href="?page=<?php echo $page + 1; ?>&search=<?php echo $search; ?>&role=<?php echo $roleFilter; ?>&status=<?php echo $statusFilter; ?>" 
               class="px-3 py-1 border rounded hover:bg-gray-50">पुढील →</a>
            <?php endif; ?>
        </div>
    </div>
    <?php endif; ?>
</div>

<?php
$content = ob_get_clean();
require VIEWS_PATH . '/layouts/dashboard.php';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: users.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation