View Code - 20260721

employee_list.php | 20260721_154032.php Initial Bulk Import

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('employee_list');

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];

function h($s){
    return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8');
}

/* =========================
   FETCH EMPLOYEES
========================= */
$st = $pdo->prepare("
    SELECT id, employee_code, name, mobile, department_name, designation_name, payment_type, is_active
    FROM company_employee_master
    WHERE company_id = :cid
    ORDER BY name
");
$st->execute([':cid' => $company_id]);
$rows = $st->fetchAll(PDO::FETCH_ASSOC);
?>

<?php require_once __DIR__ . '/partials/header.php'; ?>

<div class="d-flex justify-content-between align-items-center mb-3">
        <h4 class="fw-bold mb-0">Employee List</h4>

<a href="employee_register_new.php" class="btn btn-success btn-sm">
            + Add Employee
        </a>
    </div>

<div class="table-responsive">
                <table class="table table-hover table-bordered align-middle table-sm mb-0">
                    <thead class="table-light text-center">
                        <tr>
                            <th>Code</th>
                            <th class="text-start">Name</th>
                            <th>Mobile</th>
                            <th>Department</th>
                            <th>Designation</th>
                            <th>Payment</th>
                            <th>Status</th>
                            <th style="width:90px">Action</th>
                        </tr>
                    </thead>

<td>
                                <?php if ($r['is_active']): ?>
                                    <span class="badge bg-success">Active</span>
                                <?php else: ?>
                                    <span class="badge bg-danger">Inactive</span>
                                <?php endif; ?>
                            </td>

<?php if (empty($rows)): ?>
                        <tr>
                            <td colspan="8" class="text-center text-muted py-4">
                                No employees found.
                            </td>
                        </tr>
                    <?php endif; ?>

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

</div>
    </div>

</div>

<?php require_once __DIR__ . '/partials/footer.php'; ?>