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/employee/hr

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: hr-employees.php

<?php include 'db.php';
session_start();

// Fetch current user
$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();
?> 
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Employee Management | Decconz Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="Advanced Employee Management System" name="description">
    <meta content="Decconz" name="author">

<link href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.bootstrap5.min.css" rel="stylesheet">
    
    
    <link href="https://cdn.jsdelivr.net/npm/sweetalert2@11/dist/sweetalert2.min.css" rel="stylesheet">
</head>

<div class="page-title-box d-flex justify-content-between align-items-center">
                <h4 class="page-title">Employee Management</h4>
                <a href="add-employee.php" class="btn btn-primary">
                    <i class="mdi mdi-account-plus"></i> Add Employee
                </a>
            </div>

<div class="card shadow-sm">
                <div class="card-body">
                    <div class="table-responsive">
                        <table id="employeeTable" class="table table-bordered dt-responsive nowrap w-100">
                            <thead class="table-light">
                                <tr>
                                    <th>Employee ID</th>
                                    <th>Name</th>
                                    <th>Role</th>
                                    <th>Designation</th>
                                    <th>Email</th>
                                    <th>Status</th>
                                    <th>Join Date</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                           <tbody>
    <?php
    // Fetch employees from database
$query = "SELECT id, name, role, designation, email, status, join_date, employee_id FROM users ";
    $result = $conn->query($query);

if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $statusClass = $row['status'] === 'active' ? 'success' : 'danger';

// Handle nulls safely
            $role = ucfirst($row['role'] ?? '');
            $status = ucfirst($row['status'] ?? '');
            $designation = $row['designation'] ?? '';
            $joinDate = !empty($row['join_date']) ? date('M d, Y', strtotime($row['join_date'])) : 'N/A';

echo "<tr>
                    <td>{$row['employee_id']}</td>
                    <td>{$row['name']}</td>
                    <td>$role</td>
                    <td>$designation</td>
                    <td>{$row['email']}</td>
                    <td><span class='badge bg-$statusClass'>$status</span></td>
                    <td>$joinDate</td>
                    <td>
                        <a href='view-employee.php?id={$row['id']}' class='btn btn-sm btn-info'><i class='mdi mdi-eye'></i></a>
                        <a href='edit-employee.php?id={$row['id']}' class='btn btn-sm btn-warning'><i class='mdi mdi-pencil'></i></a>
                        <button onclick='confirmDelete({$row['id']})' class='btn btn-sm btn-danger'><i class='mdi mdi-delete'></i></button>
                    </td>
                </tr>";
        }
    } else {
        echo "<tr><td colspan='8' class='text-center'>No employees found</td></tr>";
    }
    ?>
</tbody>

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

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

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

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

<script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.bootstrap5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.colVis.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.jsdelivr.net/npm/sweetalert2@11"></script>

<script>
    $(document).ready(function () {
        $('#employeeTable').DataTable({
            dom: 'Bfrtip',
            buttons: ['copy', 'csv', 'excel', 'pdf', 'print', 'colvis'],
            responsive: true,
            pageLength: 10
        });
    });

// Delete confirmation with SweetAlert2
    function confirmDelete(userId) {
        Swal.fire({
            title: 'Are you sure?',
            text: "You won't be able to revert this!",
            icon: 'warning',
            showCancelButton: true,
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33',
            confirmButtonText: 'Yes, delete it!'
        }).then((result) => {
            if (result.isConfirmed) {
                // AJAX request to delete employee
                fetch('delete-employee.php?id=' + userId)
                    .then(response => response.json())
                    .then(data => {
                        if (data.success) {
                            Swal.fire(
                                'Deleted!',
                                data.message,
                                'success'
                            ).then(() => {
                                location.reload();
                            });
                        } else {
                            Swal.fire(
                                'Error!',
                                data.message,
                                'error'
                            );
                        }
                    })
                    .catch(error => {
                        Swal.fire(
                            'Error!',
                            'An error occurred while deleting.',
                            'error'
                        );
                        console.error('Error:', error);
                    });
            }
        });
    }
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: hr-employees.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation