« Back to History
monthly_total.php
|
20260920_164915.php
Initial Domain Snapshot
Copy Code
<?php function get_monthly_salary_total(PDO $pdo, int $company_id, int $year, int $month, int $dept = 0): float { $FROM = date('Y-m-01', strtotime("$year-$month-01")); $TO = date('Y-m-t', strtotime($FROM)); $sql = " SELECT COALESCE(SUM(net_pay),0) FROM monthly_salary_report WHERE company_id = ? AND month_key = ? " . ($dept ? "AND department_id = ?" : ""); $st = $pdo->prepare($sql); $st->execute($dept ? [$company_id, $FROM, $dept] : [$company_id, $FROM]); return (float)$st->fetchColumn(); }