@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">Monthly Advice Generate</h4>
                    </div>
                </div>
                <div class="pt-3">
                    @if($canGenerate)
                        <a href="{{ route('generate-monthly-advice', ['year'=>$year,'month'=>$month]) }}"
                        class="btn btn-success mb-2"
                        onclick="return confirm('Generate Monthly Advice for {{ $months[str_pad($month,2,'0',STR_PAD_LEFT)] }} {{ $year }}?');">
                            <i class="mdi mdi-plus-circle me-2"></i> Generate
                        </a>
                    @endif

                    @if($canExport)
                        <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>
                    @endif
                </div>
            </div>
            <!-- end page title -->
            {{--<form method="GET" action="{{ route('monthly-advice') }}">
                <div class="row mb-3 align-items-end">
                    <div class="col-md-3">
                        <label for="year" class="form-label">Year</label>
                        <select name="year" id="year" class="form-control" required>
                            <option value="">Select Year</option>
                            @for ($y = date('Y'); $y >= date('Y') - 5; $y--)
                                <option value="{{ $y }}" {{ request('year') == $y ? 'selected' : '' }}>
                                    {{ $y }}
                                </option>
                            @endfor
                        </select>
                    </div>

                    <div class="col-md-3">
                        <label for="month" class="form-label">Month</label>
                        <select name="month" id="month" class="form-control" required>
                            <option value="">Select Month</option>
                            @foreach ($months as $key => $value)
                                <option value="{{ $key }}" {{ request('month') == $key ? 'selected' : '' }}>
                                    {{ $value }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3 d-flex gap-2">
                        <button type="submit" class="btn btn-primary w-50">Search</button>
                        <!-- <a href="{{ route('generate-monthly-advice') }}" class="btn btn-secondary w-50">Reset</a> -->
                    </div>
                </div>
            </form>--}}

            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">

                            <div class="table-responsive">
                                
								@csrf
                                <table class="table table-centered w-100 dt-responsive nowrap" id="banner-datatable">
                                    <thead>
                                        <tr>
                                        <th>#</th>
                                            <th>Time Period</th>
                                            <th>Loan</th>
                                            <th>Emi Start Form</th>
                                            <th>Installment</th>
                                            <th>Loan Amount</th>
                                            <th>Fund Deduction</th>
                                            <!-- <th>Extra Amount</th> -->
                                            <th>Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($advice as $emp)
                                        <tr>
                                        <td>{{ $loop->iteration }}</td>
                                            <td>
                                                <strong><i class="fa fa-user"></i> </strong>{{ $emp->employee_name }}<br>
                                                <strong>Year:</strong>{{ $emp->year }}<br>
                                                <strong>Month:</strong>{{ $months[str_pad($month,2,'0',STR_PAD_LEFT)] }}
                                            </td>
                                            <td><span class="badge {{ $emp->type=='New'?'badge-info':''}} {{ $emp->type=='Top-up'?'badge-warning':''}}">{{ $emp->type }}</span><br>
                                                <strong>OutStanding :</strong>₹ {{ number_format($emp->os_loan, 2) }}<br>
                                                <strong>New Loan :</strong>₹ {{ number_format($emp->new_loan, 2) }}<br>
                                                <strong>Current Loan :</strong>₹ {{ number_format($emp->current_loan, 2) }}<br>
                                                <strong>Loan Intesert:</strong>₹ {{ number_format($emp->loan_interest, 2) }}<br>
                                                <strong>Loan Recovery:</strong>₹ {{ number_format($emp->loan_recovary, 2) }}<br>
                                                <strong>Due Loan & Interest:</strong>₹ {{ number_format($emp->due_loan_interest, 2) }}<br>
                                                <strong>After Recovary:</strong>₹ {{ number_format($emp->os_loan_after_recovary, 2) }}<br>
                                            </td>
                                            <td>{{ $emp->emi_start_from ? date('d-m-Y', strtotime($emp->emi_start_from)) : '-' }}</td>
                                            <td>
                                                <strong>Total Instalment:</strong>{{ $emp->total_intallment }}<br>
                                                <strong>Current Instalment No.:</strong>{{ $emp->current_inst_no }}<br>
                                        
                                            </td>
                                            <td>
                                                <strong>Principal:</strong>₹ {{ number_format($emp->principal,2) }}</br>
                                               <strong>Interest:</strong>₹  {{ number_format($emp->interest,2) }}</br>
                                                <strong>EMI:</strong>₹ {{ number_format($emp->emi, 2) }}
                                                
                                                </td>
                                            <td><strong>ThriftFund:</strong> ₹ {{ number_format($emp->thrift_fund_deduction, 2) }}<br>
                                                <strong>WellfareFund:</strong>₹ {{ number_format($emp->wellfare_fund, 2) }}

                                            </td>
                                            {{--<td>{{ number_format($emp->extra_deduction, 2) }}</td>--}}
                                            <td><b>₹ {{ number_format($emp->total_deduction, 2) }}</b></td>
                                        </tr>
                                        @endforeach
                                        @if($advice->isEmpty())
                                        <tr>
                                            <td colspan="8" class="text-center text-muted">
                                                No Monthly Advice generated for this period.
                                            </td>
                                        </tr>
                                        @endif
                                    </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> -->