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

🔧 Quick Actions

✏️ Editing: intern-attendance.php

<?php
include('config/db.php'); // $conn is the MySQLi connection

date_default_timezone_set('Asia/Kolkata');

// Redirect if not logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

// Check admin role
$is_admin = ($_SESSION['role'] === 'Manager');

// Get selected intern or default to logged-in user
$selected_intern_id = isset($_GET['intern_id']) ? (int)$_GET['intern_id'] : (int)$_SESSION['user_id'];

// Get month/year from query or use current
$month = isset($_GET['month']) ? (int)$_GET['month'] : (int)date('n');
$year = isset($_GET['year']) ? (int)$_GET['year'] : (int)date('Y');

// First and last day of selected month
$first_day = date('Y-m-01', strtotime("$year-$month-01"));
$last_day = date('Y-m-t', strtotime("$year-$month-01"));

// ===== 1. Fetch Interns List =====
$interns = [];
$intern_result = $conn->query("SELECT id, name, intern_id, role FROM interns ORDER BY name");
if ($intern_result && $intern_result->num_rows > 0) {
    while ($row = $intern_result->fetch_assoc()) {
        $interns[] = $row;
    }
}

// ===== 2. Fetch Selected Intern Info =====
$intern = null;
$intern_stmt = $conn->prepare("SELECT * FROM interns WHERE id = ?");
$intern_stmt->bind_param("i", $selected_intern_id);
$intern_stmt->execute();
$intern_result = $intern_stmt->get_result();
if ($intern_result->num_rows > 0) {
    $intern = $intern_result->fetch_assoc();
} else {
    die("❌ Intern not found.");
}

// ===== 3. Fetch Attendance Data =====
$attendance_data = [];
$att_stmt = $conn->prepare("
    SELECT date, status, check_in, check_out, notes 
    FROM intern_attendance 
    WHERE intern_id = ? AND date BETWEEN ? AND ?
    ORDER BY date
");
$att_stmt->bind_param("iss", $selected_intern_id, $first_day, $last_day);
$att_stmt->execute();
$att_result = $att_stmt->get_result();
while ($row = $att_result->fetch_assoc()) {
    $attendance_data[$row['date']] = $row;
}

// ===== 4. Fetch Holidays =====
$holidays = [];
$holiday_sql = "SELECT holiday_date, holiday_name FROM holidays WHERE holiday_date BETWEEN '$first_day' AND '$last_day'";
$holiday_result = $conn->query($holiday_sql);
if ($holiday_result && $holiday_result->num_rows > 0) {
    while ($row = $holiday_result->fetch_assoc()) {
        $holidays[$row['holiday_date']] = $row['holiday_name'];
    }
}

// ===== 5. Calculate Calendar Details =====
$days_in_month = (int)date('t', strtotime("$year-$month-01"));
$first_day_of_week = (int)date('w', strtotime("$year-$month-01"));

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Intern Attendance Management</title>
    <style>
        .calendar {
            width: 100%;
            border-collapse: collapse;
        }
        .calendar th {
            background-color: #f8f9fa;
            text-align: center;
            padding: 10px;
            border: 1px solid #dee2e6;
        }
        .calendar td {
            height: 100px;
            vertical-align: top;
            padding: 5px;
            border: 1px solid #dee2e6;
        }
        .day-number {
            font-weight: bold;
            margin-bottom: 5px;
        }
        .today {
            background-color: #e6f7ff;
        }
        .weekend {
            background-color: #f9f9f9;
        }
        .holiday {
            background-color: #fff3cd;
        }
        .attendance-status {
            font-size: 0.85rem;
            margin-top: 5px;
        }
        .present {
            color: #28a745;
        }
        .absent {
            color: #dc3545;
        }
        .half_day {
            color: #007bff;
        }
        .leave {
            color: #ffc107;
        }
        .month-nav {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 20px;
        }
        .intern-info {
            background-color: #f8f9fa;
            padding: 15px;
            border-radius: 5px;
            margin-bottom: 20px;
        }
        .intern-info-row {
            display: flex;
            flex-wrap: wrap;
            gap: 15px;
        }
        .intern-info-item {
            flex: 1;
            min-width: 200px;
        }
        .intern-card {
            border: 1px solid #dee2e6;
            border-radius: 5px;
            padding: 15px;
            margin-bottom: 20px;
            background-color: white;
        }
        .intern-photo {
            width: 100px;
            height: 100px;
            object-fit: cover;
            border-radius: 5px;
            margin-right: 15px;
        }
        .intern-badge {
            background-color: #20c997;
            color: white;
            padding: 3px 8px;
            border-radius: 4px;
            font-size: 0.8rem;
            margin-left: 5px;
        }
    </style>
</head>
<body data-sidebar="dark">

<?php include('links/head.php'); ?>
<div id="layout-wrapper">

<?php include('includes/nav.php'); ?>
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php'); ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="container bg-white p-3 rounded shadow my-4">
                    <h2 class="mb-4">Intern Attendance Management <span class="intern-badge">INTERN</span></h2>
                    
                    
                    <div class="card mb-4">
                        <div class="card-body">
                            <form method="GET" class="row g-3 align-items-end">
                                <?php if ($is_admin): ?>
                                <div class="col-md-4">
                                    <label for="intern_id" class="form-label">Select Intern</label>
                                    <select name="intern_id" id="intern_id" class="form-select" required>
                                        <?php foreach ($interns as $i): ?>
                                            <option value="<?= $i['id'] ?>" <?= $i['id'] == $selected_intern_id ? 'selected' : '' ?>>
                                                <?= htmlspecialchars($i['name']) ?> (<?= htmlspecialchars($i['intern_id']) ?>)
                                            </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <?php endif; ?>
                                
                                <div class="col-md-3">
                                    <label for="month" class="form-label">Month</label>
                                    <select name="month" id="month" class="form-select" required>
                                        <?php for ($m = 1; $m <= 12; $m++): ?>
                                            <option value="<?= $m ?>" <?= $m == $month ? 'selected' : '' ?>>
                                                <?= date('F', mktime(0, 0, 0, $m, 1)) ?>
                                            </option>
                                        <?php endfor; ?>
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label for="year" class="form-label">Year</label>
                                    <select name="year" id="year" class="form-select" required>
                                        <?php
                                        $current_year = date('Y');
                                        for ($y = $current_year - 1; $y <= $current_year + 1; $y++): ?>
                                            <option value="<?= $y ?>" <?= $y == $year ? 'selected' : '' ?>><?= $y ?></option>
                                        <?php endfor; ?>
                                    </select>
                                </div>
                                <div class="col-md-1">
                                    <button type="submit" class="btn btn-primary w-100">View</button>
                                </div>
                            </form>
                        </div>
                    </div>

<div class="intern-card">
                        <div class="d-flex align-items-start">
                            <?php if (!empty($intern['photo'])): ?>
                            <img src="<?= htmlspecialchars($intern['photo']) ?>" alt="Intern Photo" class="intern-photo">
                            <?php endif; ?>
                            <div class="flex-grow-1">
                                <h3><?= htmlspecialchars($intern['name']) ?></h3>
                                <div class="intern-info-row">
                                    <div class="intern-info-item">
                                        <strong>Intern ID:</strong> <?= htmlspecialchars($intern['intern_id']) ?>
                                    </div>
                                    <div class="intern-info-item">
                                        <strong>Department:</strong> <?= htmlspecialchars($intern['role']) ?>
                                    </div>
                                    
                                    <div class="intern-info-item">
                                        <strong>Mobile:</strong> <?= htmlspecialchars($intern['phone']) ?>
                                    </div>
                                    <div class="intern-info-item">
                                        <strong>Email:</strong> <?= htmlspecialchars($intern['email']) ?>
                                    </div>
                                    <div class="intern-info-item">
                                        <strong>Status:</strong> 
                                        <span class="badge bg-<?= $intern['status'] == 'active' ? 'success' : 'danger' ?>">
                                            <?= ucfirst($intern['status']) ?>
                                        </span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="month-nav">
                        <h3><?= date('F Y', strtotime("$year-$month-01")) ?></h3>
                    </div>

<div class="table-responsive">
                        <table class="calendar">
                            <thead>
                                <tr>
                                    <th>Sunday</th>
                                    <th>Monday</th>
                                    <th>Tuesday</th>
                                    <th>Wednesday</th>
                                    <th>Thursday</th>
                                    <th>Friday</th>
                                    <th>Saturday</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $day = 1;
                                $current_date = date('Y-m-d');
                                
                                for ($i = 0; $i < 6; $i++) {
                                    echo '<tr>';
                                    
                                    for ($j = 0; $j < 7; $j++) {
                                        if (($i === 0 && $j < $first_day_of_week) || $day > $days_in_month) {
                                            echo '<td></td>';
                                        } else {
                                            $date = sprintf("%04d-%02d-%02d", $year, $month, $day);
                                            $is_today = ($date === $current_date);
                                            $is_weekend = ($j === 0 || $j === 6); // Sunday (0) and Saturday (6)
                                            $is_holiday = isset($holidays[$date]);
                                            
                                            $classes = [];
                                            if ($is_today) $classes[] = 'today';
                                            if ($is_weekend) $classes[] = 'weekend';
                                            if ($is_holiday) $classes[] = 'holiday';
                                            
                                            echo '<td class="' . implode(' ', $classes) . '">';
                                            echo '<div class="day-number">' . $day . '</div>';
                                            
                                            if ($is_holiday) {
                                                echo '<div class="text-warning"><i class="fas fa-star"></i> ' . htmlspecialchars($holidays[$date]) . '</div>';
                                            }
                                            
                                            if (isset($attendance_data[$date])) {
                                                $record = $attendance_data[$date];
                                                $status = !empty($record['status']) ? $record['status'] : 'Absent';
                                            } elseif ($date <= $current_date && !$is_holiday && !$is_weekend) {
                                                $status = 'Absent';
                                                $record = null;
                                            } else {
                                                $status = '';
                                                $record = null;
                                            }
                                            
                                            if (!empty($status)) {
                                                $status_class = strtolower(str_replace(' ', '_', $status));
                                                echo '<div class="attendance-status ' . $status_class . '">';
                                                echo '<strong>' . ucfirst($status) . '</strong>';
                                            
                                                if ($record && !empty($record['check_in'])) {
                                                    echo '<br>In: ' . date('h:i A', strtotime($record['check_in']));
                                                }
                                            
                                                if ($record && !empty($record['check_out'])) {
                                                    echo '<br>Out: ' . date('h:i A', strtotime($record['check_out']));
                                                }
                                            
                                                if ($record && !empty($record['notes'])) {
                                                    echo '<br><small>' . htmlspecialchars($record['notes']) . '</small>';
                                                }
                                            
                                                echo '</div>';
                                            } else {
                                                echo '<div class="text-muted">No record</div>';
                                            }

echo '</td>';
                                            $day++;
                                        }
                                    }
                                    
                                    echo '</tr>';
                                    
                                    if ($day > $days_in_month) {
                                        break;
                                    }
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                    
                    
                    <div class="mt-4 card">
                        <div class="card-body">
                            <h4 class="card-title">Attendance Summary - <?= date('F Y', strtotime("$year-$month-01")) ?></h4>
                            <?php
                            // Calculate attendance summary
                            $summary = [
                                'present' => 0,
                                'Absent' => 0,
                                'Half Day' => 0,
                                'Leave' => 0,
                                'Holiday' => count($holidays),
                                'Weekend' => 0,
                                'Working Days' => 0
                            ];

for ($d = 1; $d <= $days_in_month; $d++) {
                                $date = sprintf("%04d-%02d-%02d", $year, $month, $d);
                                $day_of_week = date('w', strtotime($date));
                                $is_weekend = ($day_of_week === '0' || $day_of_week === '6');

if ($is_weekend) {
                                    $summary['Weekend']++;
                                } elseif (isset($holidays[$date])) {
                                    // Already counted in holidays
                                } else {
                                    $summary['Working Days']++;
                                    
                                    if (isset($attendance_data[$date])) {
                                        $status = $attendance_data[$date]['status'] ?? 'Absent';
                                        if (isset($summary[$status])) {
                                            $summary[$status]++;
                                        }
                                    } elseif ($date <= $current_date) {
                                        $summary['Absent']++;
                                    }
                                }
                            }
                            ?>
                            
                            <div class="row">
                                <?php foreach ($summary as $label => $count): ?>
                                    <div class="col-md-3 mb-2">
                                        <div class="d-flex justify-content-between border-bottom pb-1">
                                            <span style="text-transform: capitalize;"><?= $label ?>:</span>
                                            <strong><?= $count ?></strong>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mt-4">
                        <h4>Attendance Legend</h4>
                        <div class="d-flex flex-wrap gap-3">
                            <span class="present"><i class="fas fa-circle"></i> Present</span>
                            <span class="absent"><i class="fas fa-circle"></i> Absent</span>
                            <span class="half_day"><i class="fas fa-circle"></i> Half Day</span>
                            <span class="leave"><i class="fas fa-circle"></i> Leave</span>
                            <span class="text-warning"><i class="fas fa-star"></i> Holiday</span>
                            <span class="text-muted"><i class="fas fa-circle"></i> No Record</span>
                        </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: intern-attendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation