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/ecommer.in/public_html/billing/NEET_Academy/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: myattendance.php

<?php
// Include authentication check
require_once '../auth_check.php';

// Verify user is admin
if (!isAdmin()) {
    header("Location: ../unauthorized.php");
    exit();
}
// myattendance.php
require_once 'config/database.php';

// Start session only if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Get logged-in tutor ID
$logged_in_tutor_id = $_SESSION['tutor_id'] ?? null;

// Get tutor data
$tutor = null;
try {
    $tutor_sql = "SELECT * FROM tutors WHERE id = ?";
    $tutor_stmt = $pdo->prepare($tutor_sql);
    $tutor_stmt->execute([$logged_in_tutor_id]);
    $tutor = $tutor_stmt->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    $tutor = null;
}

// Get filter parameters
$month = $_GET['month'] ?? date('Y-m');
$year = $_GET['year'] ?? date('Y');

// Get attendance data for the selected month
$attendance_data = [];
$monthly_summary = [
    'total_days' => 0,
    'present_days' => 0,
    'late_days' => 0,
    'absent_days' => 0,
    'half_days' => 0,
    'total_hours' => '00:00',
    'avg_hours_per_day' => 0
];
$current_month = date('Y-m');

try {
    // Get start and end dates for the selected month
    $start_date = $month . '-01';
    $end_date = date('Y-m-t', strtotime($start_date));
    
    // Get attendance data
    $attendance_sql = "SELECT * FROM tutor_attendance 
                      WHERE tutor_id = ? 
                      AND attendance_date BETWEEN ? AND ?
                      ORDER BY attendance_date DESC";
    $attendance_stmt = $pdo->prepare($attendance_sql);
    $attendance_stmt->execute([$logged_in_tutor_id, $start_date, $end_date]);
    $attendance_data = $attendance_stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Get monthly summary
    $summary_sql = "SELECT 
        COUNT(*) as total_days,
        SUM(CASE WHEN status = 'present' THEN 1 ELSE 0 END) as present_days,
        SUM(CASE WHEN status = 'late' THEN 1 ELSE 0 END) as late_days,
        SUM(CASE WHEN status = 'absent' THEN 1 ELSE 0 END) as absent_days,
        SUM(CASE WHEN status = 'half_day' THEN 1 ELSE 0 END) as half_days,
        SEC_TO_TIME(SUM(TIME_TO_SEC(working_hours))) as total_hours,
        AVG(TIME_TO_SEC(working_hours)/3600) as avg_hours_per_day
        FROM tutor_attendance 
        WHERE tutor_id = ? 
        AND attendance_date BETWEEN ? AND ?";
    
    $summary_stmt = $pdo->prepare($summary_sql);
    $summary_stmt->execute([$logged_in_tutor_id, $start_date, $end_date]);
    $monthly_summary_db = $summary_stmt->fetch(PDO::FETCH_ASSOC);
    
    // Merge with default values to avoid undefined index warnings
    if ($monthly_summary_db) {
        $monthly_summary = array_merge($monthly_summary, $monthly_summary_db);
        
        // Convert NULL values to defaults
        foreach ($monthly_summary as $key => $value) {
            if ($value === null) {
                if ($key === 'total_hours') {
                    $monthly_summary[$key] = '00:00';
                } else {
                    $monthly_summary[$key] = 0;
                }
            }
        }
    }
    
    // Get current month's summary for comparison
    $current_start = date('Y-m-01');
    $current_end = date('Y-m-t');
    
    $current_summary_sql = "SELECT 
        COUNT(*) as total_days,
        SUM(CASE WHEN status = 'present' THEN 1 ELSE 0 END) as present_days,
        SEC_TO_TIME(SUM(TIME_TO_SEC(working_hours))) as total_hours
        FROM tutor_attendance 
        WHERE tutor_id = ? 
        AND attendance_date BETWEEN ? AND ?";
    
    $current_summary_stmt = $pdo->prepare($current_summary_sql);
    $current_summary_stmt->execute([$logged_in_tutor_id, $current_start, $current_end]);
    $current_month_summary = $current_summary_stmt->fetch(PDO::FETCH_ASSOC);
    
} catch (PDOException $e) {
    $attendance_data = [];
    $monthly_summary = [
        'total_days' => 0,
        'present_days' => 0,
        'late_days' => 0,
        'absent_days' => 0,
        'half_days' => 0,
        'total_hours' => '00:00',
        'avg_hours_per_day' => 0
    ];
    $current_month_summary = [
        'total_days' => 0,
        'present_days' => 0,
        'total_hours' => '00:00'
    ];
}

// Get months for filter dropdown
$months = [];
for ($i = 0; $i < 12; $i++) {
    $date = date('Y-m', strtotime("-$i months"));
    $months[] = $date;
}
?>

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

<head>
    <meta charset="utf-8">
    <title>My Attendance - NEET Academy</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="My Attendance Records" name="description">
    
    
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    
    
    <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css">
    
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css">
    
    <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css">
    
    
    <style>
        :root {
            --primary-color: #4e73df;
            --success-color: #1cc88a;
            --danger-color: #e74a3b;
            --warning-color: #f6c23e;
            --info-color: #36b9cc;
            --dark-color: #5a5c69;
            --light-color: #f8f9fc;
            --border-color: #e3e6f0;
        }
        
        .stat-card {
            background: white;
            border-radius: 8px;
            padding: 15px;
            margin-bottom: 15px;
            box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.1);
            border-left: 4px solid var(--primary-color);
        }
        
        .stat-card.success {
            border-left-color: var(--success-color);
        }
        
        .stat-card.warning {
            border-left-color: var(--warning-color);
        }
        
        .stat-card.danger {
            border-left-color: var(--danger-color);
        }
        
        .stat-card.info {
            border-left-color: var(--info-color);
        }
        
        .stat-number {
            font-size: 24px;
            font-weight: 700;
            color: var(--dark-color);
            margin-bottom: 5px;
        }
        
        .stat-label {
            font-size: 13px;
            color: var(--dark-color);
            opacity: 0.8;
        }
        
        .attendance-table th {
            background: var(--light-color);
            color: var(--primary-color);
            font-weight: 600;
            font-size: 13px;
            padding: 10px 12px;
        }
        
        .attendance-table td {
            font-size: 13px;
            padding: 10px 12px;
            vertical-align: middle;
        }
        
        .badge {
            padding: 4px 10px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }
        
        .badge-present {
            background: #d1e7dd;
            color: #0f5132;
        }
        
        .badge-late {
            background: #fff3cd;
            color: #664d03;
        }
        
        .badge-absent {
            background: #f8d7da;
            color: #842029;
        }
        
        .badge-half_day {
            background: #cff4fc;
            color: #055160;
        }
        
        .attendance-day {
            width: 40px;
            height: 40px;
            display: flex;
            align-items: center;
            justify-content: center;
            border-radius: 50%;
            font-weight: 600;
            margin: 0 auto;
        }
        
        .day-present {
            background: var(--success-color);
            color: white;
        }
        
        .day-late {
            background: var(--warning-color);
            color: #000;
        }
        
        .day-absent {
            background: var(--danger-color);
            color: white;
        }
        
        .day-half_day {
            background: var(--info-color);
            color: white;
        }
        
        .day-weekend {
            background: #f8f9fa;
            color: #adb5bd;
        }
        
        .calendar-grid {
            display: grid;
            grid-template-columns: repeat(7, 1fr);
            gap: 5px;
            margin-top: 15px;
        }
        
        .calendar-header {
            text-align: center;
            font-weight: 600;
            color: var(--primary-color);
            padding: 8px 0;
            font-size: 12px;
            background: var(--light-color);
            border-radius: 4px;
        }
        
        .no-data {
            text-align: center;
            padding: 40px;
            color: #adb5bd;
        }
        
        .no-data i {
            font-size: 48px;
            margin-bottom: 15px;
            opacity: 0.5;
        }
        
        @media print {
            .no-print {
                display: none !important;
            }
            
            .card {
                border: none !important;
                box-shadow: none !important;
            }
        }
    </style>
</head>

<?php include('includes/pre-loader.php') ?>

<div id="layout-wrapper">

<?php include('includes/topbar.php') ?>

<div class="vertical-menu">

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

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">

<div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                <h4 class="mb-sm-0">My Attendance Records</h4>
                                <div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">Attendance</a></li>
                                        <li class="breadcrumb-item"><a href="tutor-attendance.php">Tutor Panel</a></li>
                                        <li class="breadcrumb-item active">My Attendance</li>
                                    </ol>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row mb-3">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <div class="row align-items-center">
                                        <div class="col-md-3">
                                            <h5 class="card-title mb-0">
                                                <?php echo date('F Y', strtotime($month . '-01')); ?>
                                            </h5>
                                        </div>
                                        <div class="col-md-6">
                                            <form method="GET" class="row g-2">
                                                <div class="col-md-5">
                                                    <select class="form-select form-select-sm" name="month" onchange="this.form.submit()">
                                                        <?php foreach ($months as $m): ?>
                                                        <option value="<?php echo $m; ?>" <?php echo $month == $m ? 'selected' : ''; ?>>
                                                            <?php echo date('F Y', strtotime($m . '-01')); ?>
                                                        </option>
                                                        <?php endforeach; ?>
                                                    </select>
                                                </div>
                                                <div class="col-md-7">
                                                    <div class="d-flex gap-2">
                                                        <button type="button" class="btn btn-primary btn-sm" onclick="window.print()">
                                                            <i class="ri-printer-line"></i> Print
                                                        </button>
                                                        <a href="tutor-attendance.php" class="btn btn-secondary btn-sm">
                                                            <i class="ri-arrow-left-line"></i> Back to Panel
                                                        </a>
                                                    </div>
                                                </div>
                                            </form>
                                        </div>
                                        <div class="col-md-3 text-end">
                                            <div class="text-muted">
                                                <small>Showing <?php echo count($attendance_data); ?> records</small>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-md-3">
                            <div class="stat-card success">
                                <div class="stat-number">
                                    <?php echo $monthly_summary['present_days']; ?>
                                </div>
                                <div class="stat-label">Present Days</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stat-card warning">
                                <div class="stat-number">
                                    <?php echo $monthly_summary['late_days']; ?>
                                </div>
                                <div class="stat-label">Late Days</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stat-card danger">
                                <div class="stat-number">
                                    <?php echo $monthly_summary['absent_days']; ?>
                                </div>
                                <div class="stat-label">Absent Days</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stat-card info">
                                <div class="stat-number">
                                    <?php echo $monthly_summary['total_hours']; ?>
                                </div>
                                <div class="stat-label">Total Hours</div>
                            </div>
                        </div>
                    </div>

<div class="row mb-4">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Monthly Calendar View</h5>
                                    <div class="calendar-grid">
                                        
                                        <div class="calendar-header">Sun</div>
                                        <div class="calendar-header">Mon</div>
                                        <div class="calendar-header">Tue</div>
                                        <div class="calendar-header">Wed</div>
                                        <div class="calendar-header">Thu</div>
                                        <div class="calendar-header">Fri</div>
                                        <div class="calendar-header">Sat</div>
                                        
                                        <?php
                                        // Create calendar
                                        $first_day = date('N', strtotime($start_date)); // 1=Monday, 7=Sunday
                                        $days_in_month = date('t', strtotime($start_date));
                                        $current_day = 1;
                                        
                                        // Adjust for starting day (convert to Sunday-start)
                                        $start_offset = ($first_day % 7); // 0=Sunday, 1=Monday, etc.
                                        
                                        // Empty cells before the first day
                                        for ($i = 0; $i < $start_offset; $i++) {
                                            echo '<div class="attendance-day day-weekend">&nbsp;</div>';
                                        }
                                        
                                        // Days of the month
                                        for ($day = 1; $day <= $days_in_month; $day++) {
                                            $current_date = $month . '-' . str_pad($day, 2, '0', STR_PAD_LEFT);
                                            $attendance_for_day = null;
                                            
                                            // Find attendance for this day
                                            foreach ($attendance_data as $record) {
                                                if ($record['attendance_date'] == $current_date) {
                                                    $attendance_for_day = $record;
                                                    break;
                                                }
                                            }
                                            
                                            $day_class = 'day-weekend';
                                            $day_title = date('l', strtotime($current_date));
                                            
                                            if ($attendance_for_day) {
                                                $day_class = 'day-' . $attendance_for_day['status'];
                                                $day_title .= "\nStatus: " . ucfirst($attendance_for_day['status']);
                                                if ($attendance_for_day['punch_in']) {
                                                    $day_title .= "\nIn: " . date('h:i A', strtotime($attendance_for_day['punch_in']));
                                                }
                                                if ($attendance_for_day['punch_out']) {
                                                    $day_title .= "\nOut: " . date('h:i A', strtotime($attendance_for_day['punch_out']));
                                                }
                                            } elseif (date('N', strtotime($current_date)) >= 6) {
                                                $day_class = 'day-weekend';
                                                $day_title .= "\nWeekend";
                                            } else {
                                                $day_class = '';
                                                $day_title .= "\nNo record";
                                            }
                                            
                                            echo '<div class="attendance-day ' . $day_class . '" title="' . htmlspecialchars($day_title) . '">' . $day . '</div>';
                                            
                                            // Move to next row after 7 days
                                            if (($start_offset + $day) % 7 == 0 && $day < $days_in_month) {
                                                echo '</div><div class="calendar-grid">';
                                            }
                                        }
                                        
                                        // Empty cells after the last day
                                        $remaining_cells = 7 - (($start_offset + $days_in_month) % 7);
                                        if ($remaining_cells < 7) {
                                            for ($i = 0; $i < $remaining_cells; $i++) {
                                                echo '<div class="attendance-day day-weekend">&nbsp;</div>';
                                            }
                                        }
                                        ?>
                                    </div>
                                    
                                    <div class="row mt-4">
                                        <div class="col-12">
                                            <div class="d-flex flex-wrap gap-3">
                                                <div class="d-flex align-items-center">
                                                    <div class="attendance-day day-present me-2"></div>
                                                    <small>Present</small>
                                                </div>
                                                <div class="d-flex align-items-center">
                                                    <div class="attendance-day day-late me-2"></div>
                                                    <small>Late</small>
                                                </div>
                                                <div class="d-flex align-items-center">
                                                    <div class="attendance-day day-absent me-2"></div>
                                                    <small>Absent</small>
                                                </div>
                                                <div class="d-flex align-items-center">
                                                    <div class="attendance-day day-half_day me-2"></div>
                                                    <small>Half Day</small>
                                                </div>
                                                <div class="d-flex align-items-center">
                                                    <div class="attendance-day day-weekend me-2"></div>
                                                    <small>Weekend/No Record</small>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Detailed Attendance Records</h5>
                                    
                                    <?php if (empty($attendance_data)): ?>
                                    <div class="no-data">
                                        <i class="ri-calendar-line"></i>
                                        <h5>No attendance records found for <?php echo date('F Y', strtotime($month . '-01')); ?></h5>
                                        <p>Your attendance records will appear here once you start using the system.</p>
                                    </div>
                                    <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-hover table-centered attendance-table mb-0">
                                            <thead>
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Day</th>
                                                    <th>Punch In</th>
                                                    <th>Punch Out</th>
                                                    <th>Working Hours</th>
                                                    <th>Status</th>
                                                    <th>Notes</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($attendance_data as $record): ?>
                                                <tr>
                                                    <td><?php echo date('d-m-Y', strtotime($record['attendance_date'])); ?></td>
                                                    <td><?php echo date('l', strtotime($record['attendance_date'])); ?></td>
                                                    <td>
                                                        <?php if ($record['punch_in']): ?>
                                                            <span class="text-success">
                                                                <i class="ri-login-box-line"></i> 
                                                                <?php echo date('h:i A', strtotime($record['punch_in'])); ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="text-muted">-</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <?php if ($record['punch_out']): ?>
                                                            <span class="text-danger">
                                                                <i class="ri-logout-box-line"></i> 
                                                                <?php echo date('h:i A', strtotime($record['punch_out'])); ?>
                                                            </span>
                                                        <?php else: ?>
                                                            <span class="text-muted">-</span>
                                                        <?php endif; ?>
                                                    </td>
                                                    <td>
                                                        <strong><?php echo $record['working_hours'] ?: '-'; ?></strong>
                                                    </td>
                                                    <td>
                                                        <?php 
                                                        $status_badge = [
                                                            'present' => 'badge-present',
                                                            'late' => 'badge-late',
                                                            'absent' => 'badge-absent',
                                                            'half_day' => 'badge-half_day'
                                                        ][$record['status']] ?? 'badge-present';
                                                        ?>
                                                        <span class="badge <?php echo $status_badge; ?>">
                                                            <?php echo ucfirst($record['status']); ?>
                                                        </span>
                                                    </td>
                                                    <td>
                                                        <?php if ($record['notes']): ?>
                                                            <small class="text-muted" title="<?php echo htmlspecialchars($record['notes']); ?>">
                                                                <?php echo substr($record['notes'], 0, 30) . (strlen($record['notes']) > 30 ? '...' : ''); ?>
                                                            </small>
                                                        <?php else: ?>
                                                            <span class="text-muted">-</span>
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row mt-3">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Attendance Summary</h5>
                                    <div class="row">
                                        <div class="col-md-4">
                                            <div class="mb-2">
                                                <small class="text-muted">Total Working Days:</small>
                                                <div class="fw-semibold"><?php echo $monthly_summary['total_days']; ?></div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-2">
                                                <small class="text-muted">Attendance Rate:</small>
                                                <div class="fw-semibold">
                                                    <?php 
                                                    if ($monthly_summary['total_days'] > 0) {
                                                        $present_late_days = $monthly_summary['present_days'] + $monthly_summary['late_days'];
                                                        $attendance_rate = ($present_late_days / $monthly_summary['total_days']) * 100;
                                                        echo number_format($attendance_rate, 1) . '%';
                                                    } else {
                                                        echo '0%';
                                                    }
                                                    ?>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-2">
                                                <small class="text-muted">Average Hours/Day:</small>
                                                <div class="fw-semibold">
                                                    <?php 
                                                    if ($monthly_summary['avg_hours_per_day'] > 0) {
                                                        echo number_format($monthly_summary['avg_hours_per_day'], 2) . ' hours';
                                                    } else {
                                                        echo '0 hours';
                                                    }
                                                    ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div>
                
            </div>

<?php include('includes/footer.php') ?>
        </div>

</div>

<?php include('includes/rightbar.php') ?>

<?php include('includes/scripts.php') ?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: myattendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation