« Back to History
cash_employee_list_helper.php
|
20260723_000646.php
Initial Domain Snapshot
Copy Code
<?php /** * Get ACTIVE employees whose payment type is CASH * Source of truth: company_employee_master * * @return array[] */ function get_active_cash_employees(PDO $pdo, int $company_id): array { $sql = " SELECT e.id AS employee_id, e.name AS employee_name, e.department_name, e.designation_name, e.payroll_period_name, e.payment_type FROM company_employee_master e WHERE e.company_id = ? AND e.payment_type = 'CASH' AND e.is_active = 1 ORDER BY e.name "; $st = $pdo->prepare($sql); $st->execute([$company_id]); return $st->fetchAll(PDO::FETCH_ASSOC); }