@extends('master')
@section('content')
    <style>
        /* Tables */
        table {
            width: 100%;
            font-size: 14px;
        }

        th,
        td {
            border: 1px solid #aaa !important;
            padding: 8px;
        }

        th {
            background-color: #fafafa;
            font-weight: 500;
            text-align: center;
        }
    </style>

    @php
        $startYearMonth = $loans['fiscalYearStartMonth'];
        $endYearMonth = $loans['fiscalYearEndMonth'];

        $start = new DateTime($startYearMonth . '-01');
        $end = new DateTime($endYearMonth . '-01');
        $end->modify('+1 month'); // Include the end month in the loop
    @endphp

    <section class="w-100">
        <div class="container-fluid">
            <div class="card mb-4">
                <div class="card-header with-border">
                    <h3 class="card-title text-center">{{ __('Yearly Loan Ledger') }}</h3>
                    <h4 class="card-title text-center">
                        {{ __('Fiscal Year: ') . '' . $start->format('Y') . '-' . $end->format('Y') }}</h4>
                </div>

                <div class="card-body">
                    <div class="row mb-5">
                        <div class="col-md-6">
                            <h5>Employee ID: <span class="fw-normal">{{ $employeeInfo->employee_no }}</span></h5>
                            <h5>Name: <span class="fw-normal">{{ $employeeInfo->employee_name }}</span></h5>
                            <h5>Department: <span class="fw-normal">{{ $employeeInfo->department->department_name }}</span>
                            </h5>
                            <h5>Designation: <span
                                    class="fw-normal">{{ $employeeInfo->designation->designation_name }}</span>
                            </h5>
                        </div>
                    </div>


                    <table>
                        <thead>
                            <th>Month Year</th>
                            <th>Loan Amount</th>
                            <th>Paid Amount</th>
                            <th>Remaining Amount</th>
                        </thead>

                        <tbody>
                            @while ($start < $end)
                                @php
                                    $yearMonth = $start->format('Y-m');
                                @endphp
                                <tr>
                                    <td>
                                        {{ $start->format('F') }}
                                    </td>
                                    <td style="text-align: end;">
                                        {{ isset($loans[$yearMonth . '_debit_amount']) ? $loans[$yearMonth . '_debit_amount'] : '' }}
                                    </td>
                                    <td style="text-align: end;">
                                        {{ isset($loans[$yearMonth . '_credit_amount']) ? $loans[$yearMonth . '_credit_amount'] : '' }}
                                    </td>
                                    <td style="text-align: end;">
                                        {{ isset($loans[$yearMonth . '_remaining_amount']) ? $loans[$yearMonth . '_remaining_amount'] : '' }}
                                    </td>
                                </tr>
                                @php $start->modify('+1 month'); @endphp
                            @endwhile

                            <tr style="text-align: end; font-weight: 600;">
                                <td>Total</td>
                                <td>
                                    {{ isset($loans['debit_total']) ? $loans['debit_total'] : '' }}
                                </td>
                                <td>
                                    {{ isset($loans['credit_total']) ? $loans['credit_total'] : '' }}
                                </td>
                                <td>
                                    {{ isset($loans['remaining_total']) ? $loans['remaining_total'] : '' }}
                                </td>
                            </tr>

                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </section>
@endsection

@section('page_script')
    <script nonce="{{ $cspNonce }}"></script>
@endsection