« Back to History
cash_manual_attendance_helper.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php /** * CASH SALARY FROM MANUAL ATTENDANCE ONLY * Source of truth: manual_attendance_data */ function get_cash_salary_from_manual_attendance( PDO $pdo, int $company_id, string $from, string $to ): array { $sql = " SELECT m.employee_id, m.employee_name, SUM(m.salary) AS amount FROM manual_attendance_data m INNER JOIN company_employee_master e ON e.id = m.employee_id WHERE m.company_id = :company_id AND e.payment_type = 'CASH' AND e.is_active = 1 AND m.period_start >= :from_date AND m.period_end <= :to_date GROUP BY m.employee_id, m.employee_name HAVING amount > 0 ORDER BY m.employee_name "; $st = $pdo->prepare($sql); $st->execute([ 'company_id' => $company_id, 'from_date' => $from, 'to_date' => $to, ]); return $st->fetchAll(PDO::FETCH_ASSOC); }