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/manager

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: leave_request.php

<?php
include 'db.php';
session_start(); // Must be the first thing in the script

// Safely get session value
$user_id = $_SESSION['user_id'] ?? null;

if (!$user_id) {
    header("Location: /ems/index.php");
    exit();
}

// Fetch current user
$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();
$stmt->close();

// Check if user exists and has proper permissions
// Uncomment and adjust based on your role requirements
// if (!$user || $user['role'] !== 'manager') {
//     header("Location: unauthorized.php");
//     exit();
// }
?>
<?php
$employee_id = $_SESSION['user_id'];

// Handle leave request submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['submit_leave'])) {
    $start_date = $_POST['start_date'] ?? '';
    $end_date = $_POST['end_date'] ?? '';
    $reason = trim($_POST['reason'] ?? '');
    
    // Validate inputs
    if (empty($start_date) || empty($end_date) || empty($reason)) {
        $_SESSION['error'] = 'All fields are required';
    } elseif (strtotime($start_date) > strtotime($end_date)) {
        $_SESSION['error'] = 'End date must be after start date';
    } else {
        try {
            $query = "INSERT INTO leave_requests 
                     (employee_id, start_date, end_date, reason, status) 
                     VALUES (?, ?, ?, ?, 'pending')";
            $stmt = $conn->prepare($query);
            $stmt->bind_param("isss", $employee_id, $start_date, $end_date, $reason);
            
            if ($stmt->execute()) {
                $_SESSION['success'] = 'Leave request submitted successfully';
            } else {
                throw new Exception("Failed to submit leave request");
            }
        } catch (Exception $e) {
            $_SESSION['error'] = 'Error: ' . $e->getMessage();
        }
    }
    header("Location: leave_management.php");
    exit();
}

// Get all leave requests for this employee
$leave_requests = [];
$query = "SELECT * FROM leave_requests WHERE employee_id = ? ORDER BY start_date DESC";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $employee_id);
$stmt->execute();
$result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
    $leave_requests[] = $row;
}

// Get employee details
$query = "SELECT name, employee_id FROM users WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $employee_id);
$stmt->execute();
$employee = $stmt->get_result()->fetch_assoc();
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>CRM | rutzo Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="Employee leave request system" name="description">
    <meta content="Coderthemes" name="author">

<link rel="shortcut icon" href="images/favicon.ico">

<script src="js/hyper-config.js"></script>

<link href="css/vendor.min.css" rel="stylesheet" type="text/css">

<link href="css/app.min.css" rel="stylesheet" type="text/css" id="app-style">

<link href="css/unicons.css" rel="stylesheet" type="text/css">
    <link href="css/remixicon.css" rel="stylesheet" type="text/css">
    <link href="css/materialdesignicons.min.css" rel="stylesheet" type="text/css">
    
    <style>
        .leave-status {
            padding: 5px 10px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
            text-transform: uppercase;
        }
        .status-pending {
            background-color: #fff3cd;
            color: #856404;
        }
        .status-approved {
            background-color: #d4edda;
            color: #155724;
        }
        .status-rejected {
            background-color: #f8d7da;
            color: #721c24;
        }
        .leave-card {
            border-left: 4px solid;
            transition: all 0.3s;
        }
        .leave-card:hover {
            transform: translateY(-3px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
        .leave-card.pending {
            border-left-color: #ffc107;
        }
        .leave-card.approved {
            border-left-color: #28a745;
        }
        .leave-card.rejected {
            border-left-color: #dc3545;
        }
        .leave-days {
            font-size: 24px;
            font-weight: 700;
            color: #727cf5;
        }
        #leaveCalendar {
            min-height: 300px;
        }
    </style>
</head>

<div class="container-fluid">

<div class="row">
                        <div class="col-12">
                            <div class="page-title-box">
                                <div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">Employee</a></li>
                                        <li class="breadcrumb-item active">Leave Requests</li>
                                    </ol>
                                </div>
                                <h4 class="page-title">Leave Management</h4>
                            </div>
                        </div>
                    </div>

<?php if (isset($_SESSION['success'])): ?>
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="uil uil-check-circle me-2"></i><?= htmlspecialchars($_SESSION['success']) ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['success']); ?>
                    <?php endif; ?>
                    
                    <?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="uil uil-exclamation-octagon me-2"></i><?= htmlspecialchars($_SESSION['error']) ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>

<div class="row">
                        <div class="col-lg-4">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-3">Request Leave</h4>
                                    
                                    <form method="post" id="leaveRequestForm">
                                        <div class="mb-3">
                                            <label for="employee_name" class="form-label">Employee Name</label>
                                            <input type="text" class="form-control" id="employee_name" 
                                                   value="<?= htmlspecialchars($employee['name']) ?>" disabled>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="employee_id" class="form-label">Employee ID</label>
                                            <input type="text" class="form-control" id="employee_id" 
                                                   value="<?= htmlspecialchars($employee['employee_id']) ?>" disabled>
                                        </div>
                                        
                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="mb-3">
                                                    <label for="start_date" class="form-label">Start Date</label>
                                                    <input type="date" class="form-control" id="start_date" name="start_date" required>
                                                </div>
                                            </div>
                                            <div class="col-md-6">
                                                <div class="mb-3">
                                                    <label for="end_date" class="form-label">End Date</label>
                                                    <input type="date" class="form-control" id="end_date" name="end_date" required>
                                                </div>
                                            </div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label for="reason" class="form-label">Reason for Leave</label>
                                            <textarea class="form-control" id="reason" name="reason" rows="3" required></textarea>
                                        </div>
                                        
                                        <div class="text-end">
                                            <button type="submit" name="submit_leave" class="btn btn-primary">Submit Request</button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                            
                            <div class="card mt-3">
                                <div class="card-body">
                                    <h4 class="header-title mb-3">Leave Balance</h4>
                                    
                                    <div class="text-center">
                                        <div class="leave-days">18</div>
                                        <p class="text-muted">Days Remaining</p>
                                    </div>
                                    
                                    <div class="mt-3">
                                        <h5 class="font-13">Leave Policy:</h5>
                                        <ul class="ps-3">
                                            <li>Annual Leave: 20 days per year</li>
                                            <li>Sick Leave: 10 days per year</li>
                                            <li>Leave must be requested at least 3 days in advance</li>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-lg-8">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title mb-3">My Leave Requests</h4>
                                    
                                    <?php if (empty($leave_requests)): ?>
                                        <div class="alert alert-info">No leave requests found</div>
                                    <?php else: ?>
                                        <div class="table-responsive">
                                            <table class="table table-centered mb-0">
                                                <thead class="table-light">
                                                    <tr>
                                                        <th>Request ID</th>
                                                        <th>Period</th>
                                                        <th>Days</th>
                                                        <th>Reason</th>
                                                        <th>Status</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php foreach ($leave_requests as $request): 
                                                        $start = new DateTime($request['start_date']);
                                                        $end = new DateTime($request['end_date']);
                                                        $days = $start->diff($end)->days + 1; // Inclusive of both dates
                                                        
                                                        $status_class = '';
                                                        if ($request['status'] === 'approved') {
                                                            $status_class = 'status-approved';
                                                        } elseif ($request['status'] === 'rejected') {
                                                            $status_class = 'status-rejected';
                                                        } else {
                                                            $status_class = 'status-pending';
                                                        }
                                                    ?>
                                                        <tr>
                                                            <td>LR-<?= $request['id'] ?></td>
                                                            <td>
                                                                <?= $start->format('M d, Y') ?> - <?= $end->format('M d, Y') ?>
                                                            </td>
                                                            <td><?= $days ?></td>
                                                            <td><?= htmlspecialchars(substr($request['reason'], 0, 30)) . (strlen($request['reason']) > 30 ? '...' : '') ?></td>
                                                            <td>
                                                                <span class="leave-status <?= $status_class ?>">
                                                                    <?= ucfirst($request['status']) ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <button type="button" class="btn btn-xs btn-light" 
                                                                        data-bs-toggle="modal" data-bs-target="#leaveDetailsModal"
                                                                        data-start="<?= $start->format('Y-m-d') ?>"
                                                                        data-end="<?= $end->format('Y-m-d') ?>"
                                                                        data-reason="<?= htmlspecialchars($request['reason']) ?>"
                                                                        data-status="<?= $request['status'] ?>"
                                                                        data-days="<?= $days ?>">
                                                                    View
                                                                </button>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                            
                            <div class="card mt-3">
                                <div class="card-body">
                                    <h4 class="header-title mb-3">Leave Calendar</h4>
                                    <div id="leaveCalendar"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<div class="modal fade" id="leaveDetailsModal" tabindex="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title">Leave Request Details</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <p class="mb-1"><strong>Start Date:</strong></p>
                            <p id="modalStartDate"></p>
                        </div>
                        <div class="col-md-6">
                            <p class="mb-1"><strong>End Date:</strong></p>
                            <p id="modalEndDate"></p>
                        </div>
                    </div>
                    <div class="row mb-3">
                        <div class="col-md-6">
                            <p class="mb-1"><strong>Duration:</strong></p>
                            <p id="modalDays"></p>
                        </div>
                        <div class="col-md-6">
                            <p class="mb-1"><strong>Status:</strong></p>
                            <p id="modalStatus"></p>
                        </div>
                    </div>
                    <div class="mb-3">
                        <p class="mb-1"><strong>Reason:</strong></p>
                        <p id="modalReason" class="text-muted"></p>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

<script src="js/vendor.min.js"></script>

<script src="js/app.js"></script>

<script src="https://cdn.jsdelivr.net/npm/fullcalendar@5.11.3/main.min.js"></script>
    <link href="https://cdn.jsdelivr.net/npm/fullcalendar@5.11.3/main.min.css" rel="stylesheet">

// Initialize calendar
        document.addEventListener('DOMContentLoaded', function() {
            var calendarEl = document.getElementById('leaveCalendar');
            var calendar = new FullCalendar.Calendar(calendarEl, {
                initialView: 'dayGridMonth',
                headerToolbar: {
                    left: 'prev,next today',
                    center: 'title',
                    right: 'dayGridMonth,timeGridWeek,timeGridDay'
                },
                events: [
                    <?php foreach ($leave_requests as $request): 
                        $start = new DateTime($request['start_date']);
                        $end = new DateTime($request['end_date']);
                        $end->modify('+1 day'); // FullCalendar end date is exclusive
                        
                        $color = '';
                        if ($request['status'] === 'approved') {
                            $color = '#28a745';
                        } elseif ($request['status'] === 'rejected') {
                            $color = '#dc3545';
                        } else {
                            $color = '#ffc107';
                        }
                    ?>
                    {
                        title: 'Leave (<?= ucfirst($request['status']) ?>)',
                        start: '<?= $start->format('Y-m-d') ?>',
                        end: '<?= $end->format('Y-m-d') ?>',
                        color: '<?= $color ?>'
                    },
                    <?php endforeach; ?>
                ],
                eventClick: function(info) {
                    info.jsEvent.preventDefault();
                    // You can add more detailed view here if needed
                }
            });
            calendar.render();
        });

// Form validation
        document.getElementById('leaveRequestForm').addEventListener('submit', function(e) {
            const startDate = new Date(document.getElementById('start_date').value);
            const endDate = new Date(document.getElementById('end_date').value);
            const today = new Date();
            today.setHours(0, 0, 0, 0);
            
            // Check if start date is in the past
            if (startDate < today) {
                e.preventDefault();
                alert('Start date cannot be in the past');
                return false;
            }
            
            // Check if end date is before start date
            if (endDate < startDate) {
                e.preventDefault();
                alert('End date must be after start date');
                return false;
            }
            
            // Check if leave is requested at least 3 days in advance
            const threeDaysFromNow = new Date();
            threeDaysFromNow.setDate(threeDaysFromNow.getDate() + 3);
            threeDaysFromNow.setHours(0, 0, 0, 0);
            
            if (startDate < threeDaysFromNow) {
                if (!confirm('Leave should be requested at least 3 days in advance. Do you want to proceed anyway?')) {
                    e.preventDefault();
                    return false;
                }
            }
            
            return true;
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: leave_request.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation