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

🔧 Quick Actions

✏️ Editing: hr-attendance.php

<?php
include '../db.php';
include 'auth.php';

if (!isset($_SESSION['user_id']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: /ems/superadmin/index.php");
    exit();
}

// Handle attendance update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_attendance'])) {
    $attendance_id = intval($_POST['attendance_id']);
    $login_time = $_POST['login_time'];
    $logout_time = $_POST['logout_time'];
    
    // Convert 12-hour format to 24-hour format for database
    $login_time_24 = date("H:i:s", strtotime($login_time));
    $logout_time_24 = date("H:i:s", strtotime($logout_time));
    
    // Calculate total hours
    $login = new DateTime($login_time);
    $logout = new DateTime($logout_time);
    
    // Handle case where logout is next day (after midnight)
    if ($logout < $login) {
        $logout->modify('+1 day');
    }
    
    $interval = $login->diff($logout);
    $total_hours = ($interval->days * 24) + $interval->h + ($interval->i / 60);
    $total_hours = number_format($total_hours, 2);
    
    $stmt = $conn->prepare("UPDATE attendance SET login_time = ?, logout_time = ?, total_hours = ? WHERE id = ?");
    $stmt->bind_param("ssdi", $login_time_24, $logout_time_24, $total_hours, $attendance_id);
    
    if ($stmt->execute()) {
        $_SESSION['success_msg'] = "Attendance updated successfully!";
    } else {
        $_SESSION['error_msg'] = "Error updating attendance: " . $conn->error;
    }
    
    $stmt->close();
    header("Location: ".$_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING']);
    exit();
}

$userId = $_SESSION['user_id'] ?? 0;
$designation = '';

if ($userId) {
    $u = $conn->query("SELECT designation FROM users WHERE id = " . intval($userId));
    if ($u && $row = $u->fetch_assoc()) {
        $designation = !empty($row['designation']) ? strtolower($row['designation']) : '';
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>CRM | Decconz Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="shortcut icon" href="../images/dec.jpeg">

<?php include 'super-sidebar.php'; ?>
<?php include 'super-nav.php'; ?>

<div class="d-flex justify-content-between align-items-center mt-3 mb-3">
        <h4 class="page-title">HR Attendance Tracking</h4>
        <div class="d-flex gap-2 align-items-center">
            <a href="mark-attendance.php" class="btn btn-success btn-sm">
                <i class="ri-time-line"></i> Mark My Attendance
            </a>
            <a href="recent-attendance.php" class="btn btn-info btn-sm">
                <i class="ri-file-list-3-line"></i> View My Recent Attendance
            </a>
            <a href="raise-ticket.php" class="btn btn-warning btn-sm">
                <i class="ri-error-warning-line"></i> Raise Ticket
            </a>
        </div>
    </div>

<?php if (isset($_SESSION['success_msg'])): ?>
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <?= $_SESSION['success_msg'] ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
        <?php unset($_SESSION['success_msg']); ?>
    <?php endif; ?>

<?php if (isset($_SESSION['error_msg'])): ?>
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <?= $_SESSION['error_msg'] ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
        <?php unset($_SESSION['error_msg']); ?>
    <?php endif; ?>

<form method="GET" class="row g-2 mb-3">
        <div class="col-md-3">
          <input type="month" name="month" class="form-control"
            value="<?= htmlspecialchars($_GET['month'] ?? date('Y-m')) ?>">
        </div>
        <div class="col-md-3">
          <select name="emp" class="form-control">
            <option value="">All Employees</option>
            <?php
              $u = $conn->query("SELECT id,name FROM users WHERE role='employee' ORDER BY name");
              while ($r = $u->fetch_assoc()) {
                $sel = ($_GET['emp'] ?? '') == $r['id'] ? 'selected' : '';
                echo "<option value='{$r['id']}' $sel>" . htmlspecialchars($r['name']) . "</option>";
              }
            ?>
          </select>
        </div>
        <div class="col-md-2">
          <button class="btn btn-primary w-100" name="apply" value="1">Apply Filter</button>
        </div>
      </form>

<?php
        $mon = $_GET['month'] ?? date('Y-m');
        $emp_filter = !empty($_GET['emp']) ? "AND a.employee_id=" . intval($_GET['emp']) : '';
        $first = "$mon-01";
        $last = date('Y-m-t', strtotime($first));
      ?>

<div class="card">
        <div class="card-body table-responsive">
          <table id="attendanceTable" class="table table-bordered table-hover nowrap w-100">
            <thead>
              <tr>
                <th>Employee</th><th>Date</th><th>Login</th><th>Logout</th><th>Total Hrs</th><th>Status</th><th>Action</th>
              </tr>
            </thead>
            <tbody>
            <?php 
if (isset($_GET['apply'])):
    $sql = "SELECT a.*, u.name 
            FROM attendance a
            LEFT JOIN users u ON a.employee_id = u.id
            WHERE a.date BETWEEN '$first' AND '$last' $emp_filter
            ORDER BY a.date DESC, a.login_time DESC";

$res = $conn->query($sql);
    if ($res && $res->num_rows > 0):
        while ($r = $res->fetch_assoc()):
            $hours = floatval($r['total_hours']);
            $login_time = $r['login_time'];
            $logout_time = $r['logout_time'];

// ✅ Improved Status Logic
            if (!empty($login_time) && empty($logout_time)) {
                $status = 'In Progress';
                $cls = 'bg-info';
            } elseif ($hours >= 6) {
                $status = 'Present';
                $cls = 'bg-success';
            } elseif ($hours > 0 && $hours < 6) {
                $status = 'Half Day';
                $cls = 'bg-warning';
            } else {
                $status = 'Absent';
                $cls = 'bg-danger';
            }

$empName = $r['name'] ?? 'Unknown';
            $login = $login_time ? date('h:i A', strtotime($login_time)) : '-';
            $logout = $logout_time ? date('h:i A', strtotime($logout_time)) : '-';
            $total = $r['total_hours'] ?? '0';
?>
                <tr>
                  <td><?= htmlspecialchars($empName) ?></td>
                  <td><?= date('M d, Y', strtotime($r['date'])) ?></td>
                  <td><?= htmlspecialchars($login) ?></td>
                  <td><?= htmlspecialchars($logout) ?></td>
                  <td><?= htmlspecialchars($total) ?></td>
                  <td><span class="badge <?= $cls ?>"><?= $status ?></span></td>
                  <td>
                    <button class="btn btn-sm btn-outline-primary edit-btn" 
                            data-id="<?= $r['id'] ?>"
                            data-date="<?= date('Y-m-d', strtotime($r['date'])) ?>"
                            data-login="<?= htmlspecialchars($login) ?>"
                            data-logout="<?= htmlspecialchars($logout) ?>">
                        <i class="ri-edit-line"></i> Edit
                    </button>
                  </td>
                </tr>
              <?php endwhile; else: ?>
                <tr><td colspan="7" class="text-center">No data available in table</td></tr>
              <?php endif; else: ?>
                <tr><td colspan="7" class="text-center">Please apply a filter to see attendance records.</td></tr>
              <?php endif; ?>
            </tbody>
          </table>
        </div>
      </div>

<div class="card mt-4 mb-4">
        <div class="card-body">
          <h5>Monthly Summary (<?= htmlspecialchars($mon) ?>)</h5>
          <table class="table table-bordered">
            <thead>
              <tr><th>Employee</th><th>Hours</th><th>Days Attended</th><th>Attendance %</th></tr>
            </thead>
            <tbody>
              <?php if (isset($_GET['apply'])):
                $summary = $conn->query("
                  SELECT u.name, SUM(a.total_hours) hrs, COUNT(DISTINCT a.date) days_present
                  FROM attendance a
                  JOIN users u ON a.employee_id = u.id
                  WHERE a.date BETWEEN '$first' AND '$last' $emp_filter
                  GROUP BY a.employee_id
                ");
                if ($summary && $summary->num_rows > 0):
                  while ($s = $summary->fetch_assoc()):
                    $percent = round($s['days_present'] / date('t', strtotime($first)) * 100, 1);
                    $badge = $percent >= 75 ? 'bg-success' : ($percent >= 50 ? 'bg-warning' : 'bg-danger');
              ?>
              <tr>
                <td><?= htmlspecialchars($s['name']) ?></td>
                <td><?= htmlspecialchars($s['hrs']) ?></td>
                <td><?= htmlspecialchars($s['days_present']) ?></td>
                <td><span class="badge <?= $badge ?>"><?= $percent ?>%</span></td>
              </tr>
              <?php endwhile; else: ?>
                <tr><td colspan="4" class="text-center">No data found</td></tr>
              <?php endif; else: ?>
                <tr><td colspan="4" class="text-center">Please apply a filter to view summary.</td></tr>
              <?php endif; ?>
            </tbody>
          </table>
        </div>
      </div>

</div>
  </div>
</div>
</div>

<div class="modal fade" id="editAttendanceModal" tabindex="-1" aria-labelledby="editAttendanceModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editAttendanceModalLabel">Edit Attendance Record</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <input type="hidden" name="attendance_id" id="attendance_id">
                    <div class="mb-3">
                        <label class="form-label">Date</label>
                        <input type="text" class="form-control" id="attendance_date" readonly>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Login Time</label>
                        <input type="time" class="form-control time-input" name="login_time" id="login_time" step="1" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Logout Time</label>
                        <input type="time" class="form-control time-input" name="logout_time" id="logout_time" step="1" required>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Total Hours</label>
                        <input type="text" class="form-control" id="total_hours" readonly>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" name="update_attendance" class="btn btn-primary">Save changes</button>
                </div>
            </form>
        </div>
    </div>
</div>

if (isTableValid) {
      $('#attendanceTable').DataTable({
        pageLength: 10,
        order: [[1, 'desc']],
        responsive: true,
        dom: 'Bfrtip',
        buttons: [
          { extend: 'excelHtml5', className: 'btn btn-outline-success btn-sm' },
          { extend: 'pdfHtml5', className: 'btn btn-outline-danger btn-sm' },
          { extend: 'print', className: 'btn btn-outline-dark btn-sm' }
        ]
      });
    }
    
    // Handle edit button click
    $('.edit-btn').click(function() {
        const id = $(this).data('id');
        const date = $(this).data('date');
        const login = $(this).data('login');
        const logout = $(this).data('logout');
        
        $('#attendance_id').val(id);
        $('#attendance_date').val(new Date(date).toLocaleDateString('en-US', {
            year: 'numeric', month: 'short', day: 'numeric'
        }));
        $('#login_time').val(login === '-' ? '' : login);
        $('#logout_time').val(logout === '-' ? '' : logout);
        
        // Calculate initial total hours
        calculateTotalHours();
        
        const modal = new bootstrap.Modal(document.getElementById('editAttendanceModal'));
        modal.show();
    });
    
    // Calculate total hours when time inputs change
    $('#login_time, #logout_time').on('change', function() {
        calculateTotalHours();
    });
    
    function calculateTotalHours() {
        const loginTime = $('#login_time').val();
        const logoutTime = $('#logout_time').val();
        
        if (loginTime && logoutTime) {
            // Convert 12-hour format to 24-hour format for calculation
            const loginDate = new Date(`2000-01-01 ${loginTime}`);
            let logoutDate = new Date(`2000-01-01 ${logoutTime}`);
            
            // If logout time is earlier than login time, assume next day
            if (logoutDate <= loginDate) {
                logoutDate.setDate(logoutDate.getDate() + 1);
            }
            
            const diffMs = logoutDate - loginDate;
            const diffHrs = diffMs / (1000 * 60 * 60);
            const totalHours = Math.max(0, diffHrs).toFixed(2);
            
            $('#total_hours').val(totalHours + ' hours');
        } else {
            $('#total_hours').val('0 hours');
        }
    }
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: hr-attendance.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation