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.32 TB

🔧 Quick Actions

✏️ Editing: holiday.php

<?php
include('config/db.php');  // Should set up $conn = new mysqli(...);

// Get year from query param or default to current year
$year = isset($_GET['year']) ? $_GET['year'] : date('Y');

// Fetch holidays for the selected year
$holidays = [];
$query = "SELECT * FROM holidays WHERE YEAR(holiday_date) = $year ORDER BY holiday_date";
$result = $conn->query($query);
if ($result && $result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $holidays[] = $row;
    }
}

<head>
    <title>Developer Pannel</title>
    <?php include('links/head.php'); ?>
   
</head>

<?php include('includes/nav.php'); ?>
        <?php include('includes/sidebar.php'); ?>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    <div class="container bg-white p-3 my-3">
                    <h1>Holiday Calendar</h1>

<p><strong>Today's Date:</strong> <?php echo date('F j, Y'); ?></p>

<?php
        // Set the start year to the current year
        $start_year = date('Y');
        // Set the end year as 3 years ahead from the current year (you can modify this value)
        $end_year = $start_year + 9;
        ?>
        
        <form method="GET" action="holiday.php" class="select-month">
            <label for="month">Month:</label>
            <select name="month" id="month" required>
                <option value="01" <?php echo (isset($_GET['month']) && $_GET['month'] == '01') ? 'selected' : ''; ?>>January</option>
                <option value="02" <?php echo (isset($_GET['month']) && $_GET['month'] == '02') ? 'selected' : ''; ?>>February</option>
                <option value="03" <?php echo (isset($_GET['month']) && $_GET['month'] == '03') ? 'selected' : ''; ?>>March</option>
                <option value="04" <?php echo (isset($_GET['month']) && $_GET['month'] == '04') ? 'selected' : ''; ?>>April</option>
                <option value="05" <?php echo (isset($_GET['month']) && $_GET['month'] == '05') ? 'selected' : ''; ?>>May</option>
                <option value="06" <?php echo (isset($_GET['month']) && $_GET['month'] == '06') ? 'selected' : ''; ?>>June</option>
                <option value="07" <?php echo (isset($_GET['month']) && $_GET['month'] == '07') ? 'selected' : ''; ?>>July</option>
                <option value="08" <?php echo (isset($_GET['month']) && $_GET['month'] == '08') ? 'selected' : ''; ?>>August</option>
                <option value="09" <?php echo (isset($_GET['month']) && $_GET['month'] == '09') ? 'selected' : ''; ?>>September</option>
                <option value="10" <?php echo (isset($_GET['month']) && $_GET['month'] == '10') ? 'selected' : ''; ?>>October</option>
                <option value="11" <?php echo (isset($_GET['month']) && $_GET['month'] == '11') ? 'selected' : ''; ?>>November</option>
                <option value="12" <?php echo (isset($_GET['month']) && $_GET['month'] == '12') ? 'selected' : ''; ?>>December</option>
            </select>
        
            <label for="year">Year:</label>
            <select name="year" id="year" required>
                <?php 
                // Generate years dynamically based on start and end year
                for ($year = $start_year; $year <= $end_year; $year++) {
                    echo "<option value='$year' " . (isset($_GET['year']) && $_GET['year'] == $year ? 'selected' : '') . ">$year</option>";
                }
                ?>
            </select>
        
            <button type="submit" class="btn btn-info">View Calendar</button>
        </form>

<?php
        // Get current month and year
        $month = isset($_GET['month']) ? $_GET['month'] : date('m');
        $year = isset($_GET['year']) ? $_GET['year'] : date('Y');

// Get number of days in the current month
        $days_in_month = cal_days_in_month(CAL_GREGORIAN, $month, $year);
        $first_day_of_month = strtotime("$year-$month-01");
        $start_day = date("w", $first_day_of_month); // Day of the week the month starts on

// Today's date for highlighting
        $today = date('Y-m-d');
        
        // Convert holiday dates into an associative array for easy comparison and name retrieval
        $holiday_data = [];
        foreach ($holidays as $holiday) {
            $holiday_data[$holiday['holiday_date']] = $holiday;
        }
        
        // Render the calendar
        echo "<table class='calendar'>";
        echo "<thead>";
        echo "<tr><th>Sun</th><th>Mon</th><th>Tue</th><th>Wed</th><th>Thu</th><th>Fri</th><th>Sat</th></tr>";
        echo "</thead><tbody><tr>";

// Empty spaces before the first day of the month
        for ($i = 0; $i < $start_day; $i++) {
            echo "<td></td>";
        }

// Fill the days of the month
        for ($day = 1; $day <= $days_in_month; $day++) {
            $current_date = "$year-$month-" . str_pad($day, 2, "0", STR_PAD_LEFT);
            $date_for_comparison = date('Y-m-d', strtotime($current_date));
            
            $cell_class = '';
            $title = '';
            
            if ($date_for_comparison == $today) {
                $cell_class = 'today';
                $title = 'Today';
            }
            
            if (array_key_exists($current_date, $holiday_data)) {
                $cell_class = 'holiday';
                $title = $holiday_data[$current_date]['holiday_name'];
            }
            
            echo "<td class='$cell_class' title='$title'>$day</td>";

// New row after Saturday (7th day)
            if (($start_day + $day) % 7 == 0) {
                echo "</tr><tr>";
            }
        }

// Close the last row
        echo "</tr></tbody></table>";
        ?>

<?php if ($_SESSION['role'] == 'Admin' || $_SESSION['role'] == 'Human Resources (HR)') { ?>
            <h2>All Holidays</h2>
            <table class="holidays-table">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Holiday Name</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($holidays as $holiday): ?>
                        <tr>
                            <td><?php echo date('F j, Y', strtotime($holiday['holiday_date'])); ?></td>
                            <td><?php echo htmlspecialchars($holiday['holiday_name']); ?></td>
                            <td class="action-btns">
                                <a href="holiday.php?delete_id=<?php echo $holiday['id']; ?>" 
                                   class="btn btn-danger" 
                                   onclick="return confirm('Are you sure you want to delete this holiday?')">Delete</a>
                            </td>
                        </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        <?php } ?>
                </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: holiday.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation