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/hifi11.in/public_html/ems/intern

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: leave-requests.php

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

<head>
    <title>Admin | Leave Requests</title>
    <?php include('links/head.php'); ?>
</head>

<h2 class="card-title mb-4">Leave Requests</h2>

<table id="datatable" class="table table-bordered dt-responsive nowrap" style="width: 100%;">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Employee</th>
                                                <th>Role</th>
                                                <th>Leave Type</th>
                                                <th>Start Date</th>
                                                <th>End Date</th>
                                                <th>Reason</th>
                                                <th>Manager Approval</th>
                                                <th>Admin Approval</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $query = "SELECT lr.*, e.name AS employee_name 
                                                      FROM leave_requests lr 
                                                      JOIN employees e ON lr.employee_id = e.id 
                                                      ORDER BY lr.id DESC";
                                            $result = mysqli_query($conn, $query);
                                            $serial = 1;
while ($row = mysqli_fetch_assoc($result)) {
    // Determine the status color based on final status
    if ($row['status_admin'] === 'Approved' && $row['status_manager'] === 'Approved') {
        $finalStatus = 'Approved';
        $statusColor = 'badge bg-success'; // Green for Approved
    } else {
        $finalStatus = 'Rejected';
        $statusColor = 'badge bg-danger'; // Red for Rejected
    }

echo "<tr>";
    echo "<td>" . $serial++ . "</td>";
    echo "<td>" . htmlspecialchars($row['employee_name']) . "</td>";
    echo "<td>" . htmlspecialchars($row['emp_role']) . "</td>";
    echo "<td>" . htmlspecialchars($row['leave_type']) . "</td>";
    echo "<td>" . htmlspecialchars($row['start_date']) . "</td>";
    echo "<td>" . htmlspecialchars($row['end_date']) . "</td>";
    echo "<td>" . htmlspecialchars($row['reason']) . "</td>";
    echo "<td><span class='badge bg-info'>" . $row['status_manager'] . "</span></td>";
    echo "<td><span class='badge bg-primary'>" . $row['status_admin'] . "</span></td>";
    echo "<td><span class='{$statusColor}'>" . $finalStatus . "</span></td>";

// Action buttons for Admin
    if ($row['status_admin'] === 'Pending') {
        echo "<td>
            <a href='leave-action.php?id={$row['id']}&action=approve' class='btn btn-sm btn-success'>Approve</a>
            <a href='leave-action.php?id={$row['id']}&action=reject' class='btn btn-sm btn-danger'>Reject</a>
        </td>";
    } else {
        echo "<td><em>No Action</em></td>";
    }

echo "</tr>";
}
                                            ?>
                                        </tbody>
                                    </table>

</div>
                            </div>
                        </div>
                    </div>

</div> 
            </div>

<?php include('includes/footer.php'); ?>
        </div>
    </div>

<?php include('includes/rightbar.php'); ?>
    <div class="rightbar-overlay"></div>
    <?php include('links/scripts.php'); ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: leave-requests.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation