View Code - 20260722

cash_employee_extra_helper.php | 20260722_120325.php Initial Domain Snapshot

<?php
/**
 * Get EXTRA amount for CASH employees within period
 *
 * @return array [employee_id => extra_amount]
 */
function get_cash_employee_extras(
    PDO $pdo,
    int $company_id,
    array $cashEmployees,   // from get_active_cash_employees()
    string $from_date,      // YYYY-MM-DD
    string $to_date         // YYYY-MM-DD
): array {

$out = [];

$sql = "
        SELECT
            employee_id,
            SUM(amount) AS extra_amount
        FROM employee_extra
        WHERE company_id = ?
          AND employee_id = ?
          AND entry_date BETWEEN ? AND ?
        GROUP BY employee_id
    ";

$st = $pdo->prepare($sql);

foreach ($cashEmployees as $emp) {

$st->execute([
            $company_id,
            $emp['employee_id'],
            $from_date,
            $to_date
        ]);

$row = $st->fetch(PDO::FETCH_ASSOC);

if ($row && (float)$row['extra_amount'] > 0) {
            $out[(int)$emp['employee_id']] = (float)$row['extra_amount'];
        }
    }

return $out;
}