{{-- hidden month passed to store() --}}
<input type="hidden" name="month" value="{{ $month }}">

<div class="box-body mb-3 tableDive">
    <div class="box-title">
        <span><b>Month:</b> {{ ucfirst($monthname) }},</span>
        <span><b>Year:</b> {{ $year }}</span>
    </div>

    <div class="table-responsive">
        <table class="table">
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Note/Remark</th>
                </tr>
            </thead>
            <tr>
                <td>
                    <input type="date" class="form-control" name="date" value="{{ date('Y-m-d') }}" required>
                </td>
                <td>
                    {{-- fixed name (remark) --}}
                    <input type="text" class="form-control" name="remark" placeholder="Remark...">
                </td>
            </tr>
        </table>

        <table class="table table-bordered table-sm payrol_table form-table">
            <thead>
                <tr>
                    <th rowspan="2">Sl</th>
                    <th rowspan="2">Employee Name</th>
                    <th rowspan="2">Gross Salary</th>
                    <th colspan="{{ totalPaymenHead('pay') }}"></th>
                    <th rowspan="2">Pay Total</th>
                    <th colspan="{{ totalPaymenHead('deduction') }}">Deduction</th>
                    <th rowspan="2">Deduction Total</th>
                    <th rowspan="2">Net Salary</th>
                </tr>
                <tr>
                    @foreach ($payroll_heads as $details)
                        <th>{{ $details['head_name'] }}</th>
                    @endforeach
                </tr>
            </thead>

            <tbody>
                @php
                    $allTotal = 0;
                    $allTotal_net = 0;
                @endphp

                @foreach ($employees as $i => $employee)
                    <input type="hidden" name="employee_id[{{ $i }}]" value="{{ $employee->id }}">
                    @php
                        $total_payment = 0;
                        $total_deduction = 0;
                    @endphp
                    <tr>
                        <td>{{ $i + 1 }}</td>
                        <td>{{ $employee->name }}</td>
                        <td class="text-end">{{ number_format($employee->gross_salary, 2) }}</td>
                        {{-- Payment heads --}}
                        @foreach ($payroll_heads as $details)
                            @if ($details['operation_type'] === 'pay')
                                @php
                                    $payroll_head_id = $details['id'];
                                    $payment = round(
                                        (float) GetPayrollData(
                                            $payroll_head_id,
                                            $employee->salary_type_id,
                                            $employee->id,
                                            $month,
                                            $details['header_type'],
                                        ),
                                        2,
                                    );
                                    $total_payment += $payment;
                                @endphp
                                <td class="text-end">
                                    <input type="number" class="form-control income"
                                        name="row_payment[{{ $i }}][{{ $payroll_head_id }}]"
                                        value="{{ number_format($payment, 2, '.', '') }}" step="0.01"
                                        min="0">
                                </td>
                            @endif
                        @endforeach

                        <td class="text-end">
                            <span class="total_payment">{{ number_format($total_payment, 2) }}</span>
                            <input type="hidden" name="total_payment[{{ $i }}]" class="total_payment_input"
                                value="{{ number_format($total_payment, 2, '.', '') }}">
                        </td>

                        {{-- Deduction heads --}}
                        @foreach ($payroll_heads as $details)
                            @if ($details['operation_type'] === 'deduction')
                                @php
                                    $payroll_head_id = $details['id'];
                                    $deduction = round(
                                        (float) GetPayrollData(
                                            $payroll_head_id,
                                            $employee->salary_type_id,
                                            $employee->id,
                                            $month,
                                            $details['header_type'],
                                        ),
                                        2,
                                    );
                                    $total_deduction += $deduction;
                                @endphp
                                <td class="text-end">
                                    <input type="number" class="form-control deduction"
                                        name="row_deduction[{{ $i }}][{{ $payroll_head_id }}]"
                                        value="{{ number_format($deduction, 2, '.', '') }}" step="0.01"
                                        min="0">
                                </td>
                            @endif
                        @endforeach

                        <td class="text-end">
                            <span class="total_deduction">{{ number_format($total_deduction, 2) }}</span>
                            <input type="hidden" name="total_deduction[{{ $i }}]"
                                class="total_deduction_input"
                                value="{{ number_format($total_deduction, 2, '.', '') }}">
                        </td>

                        @php
                            $total_salary = $total_payment - $total_deduction;
                            $allTotal += $total_salary;
                            $employee_primary = employee_primary($employee->id);
                            $advance = (float) ($employee_primary['advanced'] ?? 0);
                            $adjusted = (float) ($employee_primary['adjusment'] ?? 0); // keeping existing helper key
                            $due = (float) ($employee_primary['advance_due'] ?? 0);
                            $net_salary = $total_salary; // adjustment input will change this on UI
                            $allTotal_net += $net_salary;
                        @endphp

                        <td class="text-end">
                            <span class="total_salary">{{ number_format($total_salary, 2) }}</span>
                            <input type="hidden" name="total_salary[{{ $i }}]" class="total_salary_input"
                                value="{{ number_format($total_salary, 2, '.', '') }}">
                        </td>

                        <td class="text-start">
                            @if ($advance > 0)
                                <div>
                                    <div>Total Advance: <span>{{ number_format($advance, 2) }}</span></div>
                                    <div>Total Adjustment: <span
                                            class="salary_adjustment">{{ number_format($adjusted, 2) }}</span></div>
                                    <div>Remain Advanced: <span
                                            class="remain_advance">{{ number_format($due, 2) }}</span></div>
                                </div>
                                <a href="{{ route('employee_advance.show', $employee->id) }}" class="btn_modal">View
                                    Details</a>
                                <input type="hidden" class="advanced_input"
                                    value="{{ number_format($advance, 2, '.', '') }}"
                                    name="advance[{{ $i }}]">
                            @else
                                <input type="hidden" class="advanced_input" value="0.00"
                                    name="advance[{{ $i }}]">
                            @endif
                        </td>

                        <td class="text-end">
                            @if ($due > 0)
                                <input type="number" class="form-control adjustment" value="0.00"
                                    max="{{ number_format(max($total_salary, 0), 2, '.', '') }}" min="0"
                                    step="0.01" name="adjustment[{{ $i }}]">
                            @else
                                <input type="hidden" value="0.00" name="adjustment[{{ $i }}]">
                                <span>-</span>
                            @endif
                        </td>

                        <td class="text-end">
                            <span class="net_salary">{{ number_format($total_salary, 2) }}</span>
                            <input type="hidden" class="net_salary_input" name="net_salary[{{ $i }}]"
                                value="{{ number_format($total_salary, 2, '.', '') }}">
                        </td>
                    </tr>
                @endforeach
            </tbody>

            <tfoot>
                <tr>
                    <th colspan="3">Net Total (Payment)</th>
                    <th colspan="{{ totalPaymenHead('pay') + totalPaymenHead('deduction') + 2 }}"></th>
                    <th class="text-end"><span id="alltotal">{{ number_format($allTotal, 2) }}</span></th>
                    <td></td>
                    <td></td>
                    <td class="text-end"><span id="net_salary_all">{{ number_format($allTotal_net, 2) }}</span></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>