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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: emp-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: logout.php");
    exit();
}

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

// Get selected employee or default to logged-in user
$selected_employee_id = isset($_GET['employee_id']) ? (int)$_GET['employee_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 Employees List =====
$employees = [];
$emp_result = $conn->query("SELECT id, name, emp_id, current_role FROM employees ORDER BY name");
if ($emp_result && $emp_result->num_rows > 0) {
    while ($row = $emp_result->fetch_assoc()) {
        $employees[] = $row;
    }
}

// ===== 2. Fetch Selected Employee Info =====
$employee = null;
$emp_stmt = $conn->prepare("SELECT * FROM employees WHERE id = ?");
$emp_stmt->bind_param("i", $selected_employee_id);
$emp_stmt->execute();
$emp_result = $emp_stmt->get_result();
if ($emp_result->num_rows > 0) {
    $employee = $emp_result->fetch_assoc();
} else {
    die("❌ Employee not found.");
}

// ===== 3. Fetch Attendance Data =====
$attendance_data = [];
$att_stmt = $conn->prepare("
    SELECT date, status, check_in, check_out, notes 
    FROM attendance 
    WHERE employee_id = ? AND date BETWEEN ? AND ?
    ORDER BY date
");
$att_stmt->bind_param("iss", $selected_employee_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">

<?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">Employee Attendance Management</h2>
                    
                    
                    <div class="employee-selector card mb-4">
                        <div class="card-body">
                            <form method="GET" class="row g-3 align-items-end">
                                
                                <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 - 5; $y <= $current_year + 2; $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="employee-card">
                        <div class="d-flex align-items-start">
                           
                            <div class="flex-grow-1">
                                <h3><?= htmlspecialchars($employee['name']) ?></h3>
                                <div class="employee-info-row">
                                    <div class="employee-info-item">
                                        <strong>Employee ID:</strong> <?= htmlspecialchars($employee['emp_id']) ?>
                                    </div>
                                    <div class="employee-info-item">
                                        <strong>Role:</strong> <?= htmlspecialchars($employee['current_role']) ?>
                                    </div>
                                    
                                
                                    <div class="employee-info-item">
                                        <strong>Mobile:</strong> <?= htmlspecialchars($employee['phone']) ?>
                                    </div>
                                    <div class="employee-info-item">
                                        <strong>Email:</strong> <?= htmlspecialchars($employee['email']) ?>
                                    </div>
                                    <div class="employee-info-item">
                                        <strong>Status:</strong> 
                                        <span class="badge bg-<?= $employee['status'] == 'active' ? 'success' : 'danger' ?>">
                                            <?= ucfirst($employee['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);
                                            $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
                            // Calculate attendance summary
$summary = [
    'present' => 0,
    'Absent' => 0,
    'Half Day' => 0,
    'Leave' => 0,
    'Holiday' => count($holidays),
    'Weekend' => 0,      // Initialize Weekend
    'Working Days' => 0  // Initialize Working Days
];

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');  // Sunday (0) and Saturday (6)

if ($is_weekend) {
        $summary['Weekend']++;
    } elseif (isset($holidays[$date])) {
        // Already counted in holidays
    } else {
        $summary['Working Days']++;  // Count 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: emp-attendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation