@php
    $months = [
        '1' => 'January',
        '2' => 'February',
        '3' => 'March',
        '4' => 'April',
        '5' => 'May',
        '6' => 'June',
        '7' => 'July',
        '8' => 'August',
        '9' => 'September',
        '10' => 'October',
        '11' => 'November',
        '12' => 'December'
    ];
@endphp
<x-header />
<x-menu />
<x-sidebar />
<div class="content-page">
    <div class="content">

        <!-- Start Content-->
        <div class="container-fluid">

            <!-- start page title -->
            <div class="d-flex justify-content-between">
                <div>
                    <div class="page-title-box">
                        <h4 class="page-title">Statement as on {{$months[$month]}} {{$year}}</h4>
                    </div>
                </div>
                <div class="pt-3">
                    <!-- <a href="{{ route('export-monthly-advice', ['year'=>$year,'month'=>$month]) }}"
                    class="btn btn-warning mb-2">
                        <i class="mdi mdi-download me-2"></i> Export Excel
                    </a> -->
                </div>
            </div>
            <!-- end page title -->
            
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <form method="GET" class="row mb-3">
                                <div class="col-md-3">
                                    <select name="member_id" class="form-control">
                                        <option value="">All Members</option>
                                        @foreach($members as $m)
                                            <option value="{{ $m->id }}" {{ request('member_id') == $m->id ? 'selected' : '' }}>
                                                {{ $m->employee_id }} - {{ $m->employee_name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-3">
                                    <select name="designation_id" class="form-control">
                                        <option value="">All Designations</option>
                                        @foreach($designations as $d)
                                            <option value="{{ $d->id }}" {{ request('designation_id') == $d->id ? 'selected' : '' }}>
                                                {{ $d->designation_name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-2">
                                    <select name="year" class="form-control">
                                        @for($y = date('Y'); $y >= date('Y') - 5; $y--)
                                            <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>{{ $y }}</option>
                                        @endfor
                                    </select>
                                </div>

                                <div class="col-md-2">
                                    <select name="month" class="form-control">
                                        @for($m = 1; $m <= 12; $m++)
                                            <option value="{{ $m }}" {{ (int)$month == $m ? 'selected' : '' }}>
                                                {{ date('F', mktime(0,0,0,$m,1)) }}
                                            </option>
                                        @endfor
                                    </select>
                                </div>

                                <div class="col-md-2">
                                    <button class="btn btn-primary w-100">Search</button>
                                </div>
                            </form>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">

								<table class="table table-bordered table-sm">
                                    <thead>
                                        <tr class="text-center">
                                            <th>Employee</th>
                                            <th>Loan</th>
                                            <th>EMI</th>
                                            <th>Funds</th>
                                            <!-- <th>Total Deduction</th> -->
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($ledger as $row)
                                            <tr>
                                                <td>
                                                    <strong>{{ $row->employee_name }}</strong><br>
                                                    {{ $row->department_name }}<br>
                                                    {{ $row->designation_name }}
                                                </td>

                                                <td>
                                                    Type: {{ $row->loan_type == '1' ? 'Topup' : 'New' }}<br>
                                                    Loan: ₹{{ number_format($row->loan_amount,2) }}<br>
                                                    Outstanding: ₹{{ number_format($row->outstanding_loan_amount,2) }}
                                                </td>

                                                <td>
                                                    EMI: ₹{{ number_format($row->loan_emi,2) }}<br>
                                                    Paid: {{ $row->number_of_emi_paid }} / {{ $row->total_emi }}
                                                </td>

                                                <td>
                                                    Total Thrift: ₹{{ number_format($row->total_thrift_amount,2) }}<br>
                                                    Total Welfare: ₹{{ number_format($row->total_welfare_amount,2) }}
                                                </td>

                                                <!-- <td>
                                                    <strong>₹{{ number_format($row->total_deduction,2) }}</strong>
                                                </td> -->
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="4" class="text-center">No data found</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>

                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div> <!-- container -->

    </div> <!-- content -->

    <!-- Footer Start -->
    <x-footer-top />
    <!-- end Footer -->

</div>
<x-footer />

<!-- Banner Datatable js -->
<!-- <script src="assets/js/pages/banner.js"></script> -->