« Back to History
department_totals.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php /* ============================================================ Department-wise Salary Aggregator Uses *_salary_report tables ONLY No assumptions, ERP-safe ============================================================ */ /* ---------------- SEMI-MONTHLY (BY DEPARTMENT) ---------------- */ function get_semi_monthly_salary_total_by_department( PDO $pdo, int $cid, string $month_key, string $period ): array { $sql = " SELECT department_name AS dept, SUM(attendance_days * per_day) AS total FROM semi_monthly_salary_report WHERE company_id = :cid AND month_key = :month_key AND period_label = :period GROUP BY department_id "; $st = $pdo->prepare($sql); $st->execute([ ':cid' => $cid, ':month_key' => $month_key, ':period' => $period ]); $out = []; foreach ($st as $r) { $out[$r['dept']] = (float)$r['total']; } return $out; } /* ---------------- MONTHLY (BY DEPARTMENT) ---------------- */ function get_monthly_salary_total_by_department( PDO $pdo, int $cid, string $month_key ): array { $sql = " SELECT department_name AS dept, SUM( CASE WHEN salary_type_name = 'Fixed' THEN basic_salary ELSE attendance_days * per_day END ) AS total FROM monthly_salary_report WHERE company_id = :cid AND month_key = :month_key GROUP BY department_id "; $st = $pdo->prepare($sql); $st->execute([ ':cid' => $cid, ':month_key' => $month_key ]); $out = []; foreach ($st as $r) { $out[$r['dept']] = (float)$r['total']; } return $out; } /* ---------------- MAIN AGGREGATOR ---------------- */ function get_department_salary_totals( PDO $pdo, int $cid, int $y, int $m, string $period, string $from, string $to ): array { $month_key = sprintf('%04d-%02d-01', $y, $m); $out = []; /* Monthly → ONLY H2 */ if ($period === 'H2') { foreach (get_monthly_salary_total_by_department($pdo,$cid,$month_key) as $d=>$v) { $out[$d] = ($out[$d] ?? 0) + $v; } } /* Semi-monthly → ALWAYS */ foreach (get_semi_monthly_salary_total_by_department($pdo,$cid,$month_key,$period) as $d=>$v) { $out[$d] = ($out[$d] ?? 0) + $v; } /* Other salary heads (already correct & trusted) */ $out['Loom Karigar Salary'] = get_loom_salary_total($pdo,$cid,$from,$to); $out['Warping'] = get_warper_salary_total($pdo,$cid,$month_key,$period); $out['Pissing'] = get_pissing_salary_total($pdo,$cid,$from,$to); /* ---------------- PASARIA (PERIOD-CORRECT) ---------------- */ $sql = " SELECT SUM(net_pay) AS total FROM pasaria_salary_report WHERE company_id = :cid AND month_key = :month_key AND period_label = :period "; $st = $pdo->prepare($sql); $st->execute([ ':cid' => $cid, ':month_key' => $month_key, ':period' => $period ]); $out['Pasaria'] = (float)($st->fetchColumn() ?: 0); return $out; }