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/rutzotech.com/public_html/ems/employee/hr

Free Space:

10 TB

🔧 Quick Actions

✏️ Editing: leave-fetch.php

<?php
$pendingHtml = $processedHtml = '';
$where = "WHERE 1";

if (!empty($_GET['from'])) {
 $from = $conn->real_escape_string($_GET['from']);
 $where .= " AND lr.start_date >= '$from'";
}
if (!empty($_GET['to'])) {
 $to = $conn->real_escape_string($_GET['to']);
 $where .= " AND lr.end_date <= '$to'";
}
if (!empty($_GET['status'])) {
 $status = $conn->real_escape_string($_GET['status']);
 $where .= " AND lr.status = '$status'";
}
// Fetch current user
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
$sql = "SELECT lr.*, u.name, u.email, u.profile_pic,
 lb.total_leaves, lb.leaves_taken
 FROM leave_requests lr
 LEFT JOIN users u ON lr.employee_id = u.id
 LEFT JOIN leave_balances lb ON lr.employee_id = lb.user_id
 $where
 ORDER BY lr.id DESC";
$result = $conn->query($sql);

function buildRow($row, $isPending) {
    $profilePic = !empty($row['profile_pic']) && file_exists("uploads/{$row['profile_pic']}")
        ? "uploads/{$row['profile_pic']}" : "images/default-avatar.png";

$badgeClass = match ($row['status']) {
        'approved' => 'bg-success text-white',
        'rejected' => 'bg-danger text-white',
        'pending' => 'bg-warning text-dark',
        default => 'bg-secondary text-white'
    };

$total = (int)($row['total_leaves'] ?? 0);
    $taken = (int)($row['leaves_taken'] ?? 0);
    $balance = $total - $taken;

$actions = $isPending
 ? "<a href='leave-action.php?id={$row['id']}&action=approve' class='btn btn-success btn-sm'>Approve</a>
 <a href='leave-action.php?id={$row['id']}&action=reject' class='btn btn-danger btn-sm'>Reject</a>"
 : "No Action";

return "<tr>
 <td>
 <img src='" . htmlspecialchars($profilePic) . "' width='40' height='40' class='rounded-circle me-1'>
 " . htmlspecialchars($row['name']) . " 
 " . htmlspecialchars($row['email']) . "
 </td>
 <td>" . date('M d, Y', strtotime($row['start_date'])) . " - " . date('M d, Y', strtotime($row['end_date'])) . "</td>
 <td>" . nl2br(htmlspecialchars($row['reason'])) . "</td>
 <td>{$balance} days left</td>
 <td>" . ucfirst($row['status']) . "</td>
 <td>{$actions}</td>
 </tr>";
}

if ($result && $result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        if ($row['status'] === 'pending') {
            $pendingHtml .= buildRow($row, true);
        } else {
            $processedHtml .= buildRow($row, false);
        }
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: leave-fetch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation