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

Free Space:

10.25 TB

🔧 Quick Actions

✏️ Editing: attendance1.php

<?php
include '../db.php';
// Get current user data
$user_id = $_SESSION['user_id'];
$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();
if (!isset($_SESSION['user_id']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: /ems/superadmin/index.php");
    exit();
}

// Get all employees for dropdown
$employees = [];
$result = $conn->query("SELECT id, name, employee_id FROM users WHERE role = 'employee'");
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $employees[] = $row;
    }
}

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (isset($_POST['add_attendance'])) {
        $employee_id = $_POST['employee_id'];
        $date = $_POST['date'];
        $login_time = $_POST['login_time'];
        $logout_time = $_POST['logout_time'];
        
        // Calculate total hours
        $login = new DateTime($login_time);
        $logout = new DateTime($logout_time);
        $interval = $login->diff($logout);
        $total_hours = $interval->h + ($interval->i / 60);
        
        $stmt = $conn->prepare("INSERT INTO attendance (employee_id, date, login_time, logout_time, total_hours) VALUES (?, ?, ?, ?, ?)");
        $stmt->bind_param("isssd", $employee_id, $date, $login_time, $logout_time, $total_hours);
        $stmt->execute();
    } elseif (isset($_POST['update_attendance'])) {
        $id = $_POST['attendance_id'];
        $login_time = $_POST['login_time'];
        $logout_time = $_POST['logout_time'];
        
        // Calculate total hours
        $login = new DateTime($login_time);
        $logout = new DateTime($logout_time);
        $interval = $login->diff($logout);
        $total_hours = $interval->h + ($interval->i / 60);
        
        $stmt = $conn->prepare("UPDATE attendance SET login_time = ?, logout_time = ?, total_hours = ? WHERE id = ?");
        $stmt->bind_param("ssdi", $login_time, $logout_time, $total_hours, $id);
        $stmt->execute();
    } elseif (isset($_POST['delete_attendance'])) {
        $id = $_POST['attendance_id'];
        $stmt = $conn->prepare("DELETE FROM attendance WHERE id = ?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
    }
}

// Get attendance records with filters
$where = "1=1";
$params = [];
$types = "";

if (isset($_GET['filter'])) {
    if (!empty($_GET['employee_id'])) {
        $where .= " AND a.employee_id = ?";
        $params[] = $_GET['employee_id'];
        $types .= "i";
    }
    
    if (!empty($_GET['from_date'])) {
        $where .= " AND a.date >= ?";
        $params[] = $_GET['from_date'];
        $types .= "s";
    }
    
    if (!empty($_GET['to_date'])) {
        $where .= " AND a.date <= ?";
        $params[] = $_GET['to_date'];
        $types .= "s";
    }
    
    if (!empty($_GET['designation'])) {
        $where .= " AND u.designation = ?";
        $params[] = $_GET['designation'];
        $types .= "s";
    }
}

$query = "SELECT a.*, u.name, u.designation 
          FROM attendance a 
          JOIN users u ON a.employee_id = u.id 
          WHERE $where 
          ORDER BY a.date DESC, a.login_time DESC";

$stmt = $conn->prepare($query);
if (!empty($params)) {
    $stmt->bind_param($types, ...$params);
}
$stmt->execute();
$result = $stmt->get_result();
$attendance_records = $result->fetch_all(MYSQLI_ASSOC);

// Get unique designations for filter
$designations = [];
$result = $conn->query("SELECT DISTINCT designation FROM users WHERE role = 'employee' AND designation IS NOT NULL");
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $designations[] = $row['designation'];
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Employee Attendance | Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description">
    <meta content="Coderthemes" name="author">

<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">
    
    
    <link href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.bootstrap5.min.css" rel="stylesheet">
    
    <style>
        .time-input {
            max-width: 120px;
        }
        .total-hours {
            font-weight: bold;
        }
    </style>
</head>

<div class="content-page">
        <div class="content">
            
            <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);">Admin</a></li>
                                    <li class="breadcrumb-item active">Employee Attendance</li>
                                </ol>
                            </div>
                            <h4 class="page-title">Employee Attendance Management</h4>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row mb-2">
                                    
                                    <div class="col-md-6">
                                        <div class="text-md-end">
                                            <button class="btn btn-secondary" data-bs-toggle="modal" data-bs-target="#filter-modal">
                                                <i class="mdi mdi-filter me-1"></i> Filter
                                            </button>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table id="attendance-table" class="table table-centered dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Employee</th>
                                                <th>Designation</th>
                                                <th>Date</th>
                                                <th>Login Time</th>
                                                <th>Logout Time</th>
                                                <th>Total Hours</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php foreach ($attendance_records as $record): ?>
                                            <tr>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0 me-2">
                                                            <img src="<?php echo !empty($record['profile_pic']) ? '../uploads/'.$record['profile_pic'] : '../images/users/avatar-1.jpg'; ?>" class="rounded-circle avatar-xs" alt="user-pic">
                                                        </div>
                                                        <div class="flex-grow-1">
                                                            <span class="fw-semibold"><?php echo htmlspecialchars($record['name']); ?></span>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td><?php echo htmlspecialchars($record['designation']); ?></td>
                                                <td><?php echo date('M d, Y', strtotime($record['date'])); ?></td>
                                                <td><?php echo date('h:i A', strtotime($record['login_time'])); ?></td>
                                                <td><?php echo date('h:i A', strtotime($record['logout_time'])); ?></td>
                                                <td class="total-hours"><?php echo number_format($record['total_hours'], 2); ?> hrs</td>
                                                <td>
                                                    <button class="btn btn-sm btn-primary edit-btn" 
                                                            data-id="<?php echo $record['id']; ?>"
                                                            data-date="<?php echo $record['date']; ?>"
                                                            data-login="<?php echo $record['login_time']; ?>"
                                                            data-logout="<?php echo $record['logout_time']; ?>">
                                                        <i class="mdi mdi-pencil"></i>
                                                    </button>
                                                    <button class="btn btn-sm btn-danger delete-btn" data-id="<?php echo $record['id']; ?>">
                                                        <i class="mdi mdi-delete"></i>
                                                    </button>
                                                </td>
                                            </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div> 
                        </div> 
                    </div> 
                </div> 
            </div> 
        </div>

<footer class="footer">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-6">
                        <script>document.write(new Date().getFullYear())</script> © Hyper - Coderthemes.com
                    </div>
                    <div class="col-md-6">
                        <div class="text-md-end footer-links d-none d-md-block">
                            <a href="javascript: void(0);">About</a>
                            <a href="javascript: void(0);">Support</a>
                            <a href="javascript: void(0);">Contact Us</a>
                        </div>
                    </div>
                </div>
            </div>
        </footer>
        
    </div>

<div class="modal fade" id="add-attendance-modal" 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">Add Attendance Record</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form method="POST" action="">
                    <div class="modal-body">
                        <div class="mb-3">
                            <label for="employee_id" class="form-label">Employee</label>
                            <select class="form-select" id="employee_id" name="employee_id" required>
                                <option value="">Select Employee</option>
                                <?php foreach ($employees as $employee): ?>
                                <option value="<?php echo $employee['id']; ?>"><?php echo htmlspecialchars($employee['name']); ?> (<?php echo htmlspecialchars($employee['employee_id']); ?>)</option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="mb-3">
                            <label for="date" class="form-label">Date</label>
                            <input type="date" class="form-control" id="date" name="date" required>
                        </div>
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label for="login_time" class="form-label">Login Time</label>
                                <input type="time" class="form-control time-input" id="login_time" name="login_time" required>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label for="logout_time" class="form-label">Logout Time</label>
                                <input type="time" class="form-control time-input" id="logout_time" name="logout_time" required>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                        <button type="submit" name="add_attendance" class="btn btn-primary">Save</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<div class="modal fade" id="edit-attendance-modal" 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">Edit Attendance Record</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form method="POST" action="">
                    <input type="hidden" name="attendance_id" id="edit_attendance_id">
                    <div class="modal-body">
                        <div class="mb-3">
                            <label for="edit_date" class="form-label">Date</label>
                            <input type="date" class="form-control" id="edit_date" name="date" required>
                        </div>
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label for="edit_login_time" class="form-label">Login Time</label>
                                <input type="time" class="form-control time-input" id="edit_login_time" name="login_time" required>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label for="edit_logout_time" class="form-label">Logout Time</label>
                                <input type="time" class="form-control time-input" id="edit_logout_time" name="logout_time" required>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                        <button type="submit" name="update_attendance" class="btn btn-primary">Update</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<div class="modal fade" id="delete-confirm-modal" 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">Confirm Delete</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <p>Are you sure you want to delete this attendance record? This action cannot be undone.</p>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <form method="POST" action="" style="display: inline;">
                        <input type="hidden" name="attendance_id" id="delete_attendance_id">
                        <button type="submit" name="delete_attendance" class="btn btn-danger">Delete</button>
                    </form>
                </div>
            </div>
        </div>
    </div>

<div class="modal fade" id="filter-modal" 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">Filter Attendance Records</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form method="GET" action="">
                    <div class="modal-body">
                        <div class="mb-3">
                            <label for="filter_employee_id" class="form-label">Employee</label>
                            <select class="form-select" id="filter_employee_id" name="employee_id">
                                <option value="">All Employees</option>
                                <?php foreach ($employees as $employee): ?>
                                <option value="<?php echo $employee['id']; ?>" <?php echo isset($_GET['employee_id']) && $_GET['employee_id'] == $employee['id'] ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($employee['name']); ?> (<?php echo htmlspecialchars($employee['employee_id']); ?>)
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="mb-3">
                            <label for="filter_designation" class="form-label">Designation</label>
                            <select class="form-select" id="filter_designation" name="designation">
                                <option value="">All Designations</option>
                                <?php foreach ($designations as $designation): ?>
                                <option value="<?php echo htmlspecialchars($designation); ?>" <?php echo isset($_GET['designation']) && $_GET['designation'] == $designation ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($designation); ?>
                                </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label for="from_date" class="form-label">From Date</label>
                                <input type="date" class="form-control" id="from_date" name="from_date" value="<?php echo isset($_GET['from_date']) ? htmlspecialchars($_GET['from_date']) : ''; ?>">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label for="to_date" class="form-label">To Date</label>
                                <input type="date" class="form-control" id="to_date" name="to_date" value="<?php echo isset($_GET['to_date']) ? htmlspecialchars($_GET['to_date']) : ''; ?>">
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                        <button type="submit" name="filter" class="btn btn-primary">Apply Filter</button>
                        <?php if (isset($_GET['filter'])): ?>
                        <a href="attendance.php" class="btn btn-secondary">Clear Filter</a>
                        <?php endif; ?>
                    </div>
                </form>
            </div>
        </div>
    </div>
    </div>

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

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

<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.bootstrap5.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.print.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.colVis.min.js"></script>

// Edit button click handler
            $('.edit-btn').click(function() {
                var id = $(this).data('id');
                var date = $(this).data('date');
                var login = $(this).data('login');
                var logout = $(this).data('logout');
                
                $('#edit_attendance_id').val(id);
                $('#edit_date').val(date);
                $('#edit_login_time').val(login);
                $('#edit_logout_time').val(logout);
                
                $('#edit-attendance-modal').modal('show');
            });

// Delete button click handler
            $('.delete-btn').click(function() {
                var id = $(this).data('id');
                $('#delete_attendance_id').val(id);
                $('#delete-confirm-modal').modal('show');
            });

// Set today's date as default for add form
            $('#date').val(new Date().toISOString().substr(0, 10));
            
            // Set default times for add form
            $('#login_time').val('09:00');
            $('#logout_time').val('17:00');
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: attendance1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation