View Code - 20260921

monthly_recon.php | 20260921_175631.php Initial Domain Snapshot

<?php
// monthly_recon.php - reconcile monthly salary batches
require_once __DIR__ . '/../../auth/page_acl.php';
require_once __DIR__ . '/recon_lib.php';
$ctx = page_require_access('expense_recon');
$pdo = $ctx['pdo'] ?? null;
header('Content-Type: application/json; charset=utf-8');

$raw = $GLOBALS['__recon_payload'] ?? file_get_contents('php://input');
$in = json_decode($raw,true); if (!is_array($in)) { echo json_encode(['error'=>'invalid_json']); exit; }
$company_id = (int)($in['company_id'] ?? $ctx['company_id'] ?? 0);
$start = $in['pay_period_start'] ?? null; $end = $in['pay_period_end'] ?? null;
$bank_rows = $in['bank_rows'] ?? [];

if (!$start || !$end) { echo json_encode(['error'=>'missing_period']); exit; }

// try saved monthly table first: monthly_salary_report
$deptTotals=[]; try {
    $st = $pdo->prepare("SELECT COALESCE(department_name,'Monthly') AS department, SUM(net_pay) AS amount FROM monthly_salary_report WHERE company_id=:cid AND date BETWEEN :from AND :to GROUP BY department");
    $st->execute([':cid'=>$company_id, ':from'=>$start, ':to'=>$end]);
    foreach ($st->fetchAll(PDO::FETCH_ASSOC) as $r) $deptTotals[$r['department']]= (float)$r['amount'];
} catch (Throwable $e) {}

// fallback: compute from company_employee_master similar to semi but for full month
if (empty($deptTotals)) {
    // simple fallback: aggregate net_pay from semi_monthly_salary_report with matching month_key maybe present, else leave empty
    try {
        $st = $pdo->prepare("SELECT COALESCE(department_name,'Monthly') AS department, SUM(net_pay) AS amount FROM semi_monthly_salary_report WHERE company_id=:cid AND month_key BETWEEN :from AND :to GROUP BY department");
        $st->execute([':cid'=>$company_id, ':from'=>$start, ':to'=>$end]);
        foreach ($st->fetchAll(PDO::FETCH_ASSOC) as $r) $deptTotals[$r['department']]= (float)$r['amount'];
    } catch (Throwable $e) {}
}

$grandTotal = array_sum($deptTotals);
$results=[]; $alloc_rules=['folding'=>['repair_pct'=>30,'loom_pct'=>70],'dept_map'=>[],'default_to'=>'loom_expense'];
foreach($bank_rows as $b) {
    $bAmt = (float)$b['amount'];
    $matched=false;$match_details=[];$suggested_allocs=[];
    foreach ($deptTotals as $dept=>$dAmt) {
        if (abs($dAmt - $bAmt) <= 0.5) { $match_details[]=['reason'=>'matched_dept_exact','dept'=>$dept]; $suggested_allocs=array_merge($suggested_allocs,allocate_dept_amount_generic($dept,$dAmt,$alloc_rules)); $matched=true; break; }
    }
    if (!$matched && abs($grandTotal-$bAmt)<=0.5) { foreach($deptTotals as $dept=>$dAmt) $suggested_allocs=array_merge($suggested_allocs,allocate_dept_amount_generic($dept,$dAmt,$alloc_rules)); $match_details[]=['reason'=>'matched_grand_total']; $matched=true; }
    if (!$matched && $grandTotal>0) { foreach($deptTotals as $dept=>$dAmt) { $share=($dAmt/$grandTotal)*$bAmt; $suggested_allocs=array_merge($suggested_allocs,allocate_dept_amount_generic($dept,$share,$alloc_rules)); } $match_details[]=['reason'=>'proportional_fallback']; $matched=true; }
    $id = persist_recon_result($pdo,$b,$match_details,$suggested_allocs,$company_id,$ctx['user']['id'],'monthly');
    $results[]=['id'=>$id,'bank_row'=>$b,'matched'=>$matched,'alloc'=>$suggested_allocs];
}

echo json_encode(['company_id'=>$company_id,'dept_totals'=>$deptTotals,'grand_total'=>$grandTotal,'results'=>$results], JSON_PRETTY_PRINT|JSON_UNESCAPED_UNICODE);
exit;