@php
use App\Models\Payroll;
use App\Models\EmployeeHead;
use App\Models\SalaryPayment;

// Resolve month number (01–12) from key like "july"
$monthNum = str_pad((string)(array_search(strtolower($monthKey), array_map('strtolower', months())) + 1), 2, '0', STR_PAD_LEFT);

// Often payments.month is stored as "YYYY-MM"; support both patterns:
$monthToken = $year . '-' . $monthNum;

// Helper to compute additions/deductions from payroll rows for this FY + month
function computeMonthTotals($employeeId, $financial_year, $monthKey) {
    $rows = Payroll::where('employee_id', $employeeId)
        ->where('financial_year', $financial_year)
        ->get();

    $add = 0.0; $ded = 0.0;

    foreach ($rows as $row) {
        $data = is_array($row->data_column) ? $row->data_column : (json_decode($row->data_column, true) ?: []);
        $amount = (float) ($data[$monthKey] ?? 0);

        // decide operation_type from EmployeeHead
        $op = optional(EmployeeHead::find($row->head_id))->operation_type ?? 'pay';
        if ($op === 'pay') $add += $amount;
        else               $ded += $amount;
    }

    return [$add, $ded];
}
@endphp

<table class="table table-bordered" border="1">
    <thead>
        <tr>
            <th>SL</th>
            <th>Employee ID</th>
            <th>Employee Name</th>
            <th>Department</th>
            <th>Designation</th>
            <th>Start Working Date</th>
            <th>Last Working Day</th>
            <th>Status</th>
            <th class="text-end">Gross</th>
            <th class="text-end">Addition ({{ ucfirst($monthKey) }})</th>
            <th class="text-end">Deduction ({{ ucfirst($monthKey) }})</th>
            <th class="text-end">Net Salary</th>
            <th class="text-end">Paid</th>
            <th class="text-end">Balance</th>
            <th>@lang('Created By')</th>
            <th>@lang('Created Date')</th>
            <th>@lang('Modify By')</th>
            <th>@lang('Modify Date')</th>
        </tr>
    </thead>
    <tbody>
    @forelse ($items as $idx => $item)
        @php
            // compute addition & deduction for selected month
            [$addition, $deduction] = computeMonthTotals($item->id, $financial_year, $monthKey);
            $net = $addition - $deduction;

            // payment sum for the month
            $paid = SalaryPayment::where('employee_id', $item->id)
                ->where(function($q) use ($monthToken, $monthKey, $year) {
                    // Support either "YYYY-MM" format or separate month/year storage
                    $q->where('month', $monthToken)
                      ->orWhere(function($q2) use ($monthKey, $year) {
                          $q2->where('month', $monthKey)->where('year', $year);
                      });
                })
                ->sum('payment');

            $balance = $net - $paid;
        @endphp
        <tr>
            <td>{{ ($items->currentPage() - 1) * $items->perPage() + $idx + 1 }}</td>
            <td>{{ $item->employee_id }}</td>
            <td>{{ $item->name }}</td>
            <td>{{ $item->department }}</td>
            <td>{{ $item->designation }}</td>
            <td>{{ $item->joining_date }}</td>
            <td>{{ $item->lastworkingdate }}</td>
            <td>
                <span class="badge rounded-pill {{ $item->status === 'Active' ? 'text-bg-success' : 'text-bg-secondary' }}">
                    {{ $item->status }}
                </span>
            </td>
            <td class="text-end">{{ number_format($item->gross_salary, 2) }}</td>
            <td class="text-end">{{ $addition ? number_format($addition, 2) : '-' }}</td>
            <td class="text-end">{{ $deduction ? number_format($deduction, 2) : '-' }}</td>
            <td class="text-end fw-semibold">{{ $net ? number_format($net, 2) : '0.00' }}</td>
            <td class="text-end">{{ $paid ? number_format($paid, 2) : '-' }}</td>
            <td class="text-end {{ $balance > 0 ? 'text-danger' : 'text-success' }}">
                {{ number_format($balance, 2) }}
            </td>
            <td>{{ $item->created_user ?? '-' }}</td>
            <td>{{ $item->created_date ?? '-' }}</td>
            <td>{{ $item->updated_user ?? '-' }}</td>
            <td>{{ $item->updated_date ?? '-' }}</td>
        </tr>
    @empty
        <tr><td colspan="18" class="text-center">No data</td></tr>
    @endforelse
    </tbody>
</table>

@if ($items instanceof \Illuminate\Pagination\LengthAwarePaginator)
    {{ $items->links('layouts.paginate') }}
@endif