« Back to History
cash_person_source.php
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
<?php function get_cash_person_rows( PDO $pdo, int $company_id, int $year, int $month, string $period_ui // '1-15' | '16-End' ): array { $rows = []; $month_key = sprintf('%04d-%02d-01', $year, $month); // UI period → semi table label $semi_label = ($period_ui === '1-15') ? 'H1' : 'H2'; /* ========== MONTHLY CASH ========== */ $st = $pdo->prepare(" SELECT employee_id, employee_name, net_pay FROM monthly_salary_report WHERE company_id = ? AND month_key = ? AND payment_type = 'CASH' AND net_pay > 0 "); $st->execute([$company_id, $month_key]); foreach ($st as $r) { $rows[] = [ 'head' => 'Monthly', 'person_type' => 'EMPLOYEE', 'person_id' => (int)$r['employee_id'], 'person_name' => $r['employee_name'], 'amount' => (int)$r['net_pay'] ]; } /* ========== SEMI MONTHLY CASH ========== */ $st = $pdo->prepare(" SELECT employee_id, employee_name, net_pay FROM semi_monthly_salary_report WHERE company_id = ? AND month_key = ? AND period_label = ? AND payment_type = 'CASH' AND net_pay > 0 "); $st->execute([$company_id, $month_key, $semi_label]); foreach ($st as $r) { $rows[] = [ 'head' => 'Semi Monthly', 'person_type' => 'EMPLOYEE', 'person_id' => (int)$r['employee_id'], 'person_name' => $r['employee_name'], 'amount' => (int)$r['net_pay'] ]; } /* ========== LOOM CASH ========== */ // yahan baad me loom helper add hoga (abhi skip) return $rows; }