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.php

<?php
include('config/db.php');

$userId = $_SESSION['user_id'];

// Handle leave request form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $leaveType = mysqli_real_escape_string($conn, $_POST['leave_type']);
    $fromDate = $_POST['from_date'];
    $toDate = $_POST['to_date'];
    $reason = mysqli_real_escape_string($conn, $_POST['reason']);

// Get intern's department
    $deptQuery = "SELECT department FROM interns WHERE id = '$userId'";
    $deptResult = mysqli_query($conn, $deptQuery);
    $internDept = mysqli_fetch_assoc($deptResult)['department'] ?? 'Intern';

$query = "INSERT INTO intern_leave_requests (intern_id, leave_type, start_date, end_date, reason, intern_department, status_manager, created_at)
              VALUES ('$userId', '$leaveType', '$fromDate', '$toDate', '$reason', '$internDept', 'Pending', NOW())";
    
    if (mysqli_query($conn, $query)) {
        $_SESSION['success'] = "Leave request submitted successfully.";
    } else {
        $_SESSION['error'] = "Error submitting leave request: " . mysqli_error($conn);
    }
    header("Location: intern-leave.php");
    exit();
}
?>

<!doctype html>
<html lang="en">

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

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                <?php
                if (isset($_SESSION['success'])) {
                    echo "<div class='alert alert-success'>" . $_SESSION['success'] . "</div>";
                    unset($_SESSION['success']);
                } elseif (isset($_SESSION['error'])) {
                    echo "<div class='alert alert-danger'>" . $_SESSION['error'] . "</div>";
                    unset($_SESSION['error']);
                }
                ?>

<div class="d-flex justify-content-between align-items-center mb-3">
                                        <h2 class="card-title">My Leave Requests <span class="intern-badge">INTERN</span></h2>
                                        <a href="apply-leave.php" class="btn btn-primary">+ Apply for Leave</a>
                                    </div>

<table id="datatable" class="table table-bordered dt-responsive nowrap"
                                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Leave Type</th>
                                                <th>Reason</th>
                                                <th>From</th>
                                                <th>To</th>
                                                <th>Department</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>

<tbody>
                                            <?php
                                            $userId = $_SESSION['user_id'];
                                            $query = "SELECT * FROM intern_leave_requests WHERE intern_id = '$userId' ORDER BY id DESC";
                                            $result = mysqli_query($conn, $query);
                                            $serial = 1;

if ($result && mysqli_num_rows($result) > 0) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    $status = $row['final_status'] === 'Pending' ? 
                                                        ($row['status_manager'] === 'Rejected' ? 'Rejected' : 'Pending') : 
                                                        $row['final_status'];
                                                    
                                                    echo "<tr>";
                                                    echo "<td>" . $serial++ . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['leave_type']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['reason']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['start_date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['end_date']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['intern_department']) . "</td>";
                                                    echo "<td><span class='badge bg-" . 
                                                        ($status === 'Approved' ? 'success' : 
                                                        ($status === 'Rejected' ? 'danger' : 'warning')) . 
                                                        "'>$status</span></td>";
                                                    echo "<td>
                                                            <a href='delete-leave.php?id={$row['id']}' class='btn btn-sm btn-danger' title='Delete' onclick=\"return confirm('Are you sure you want to delete this leave request?');\">
                                                                <i class='fas fa-trash'></i>
                                                            </a>
                                                        </td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='8' class='text-center'>No leave requests found.</td></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.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation