@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 />
<style>
.table td { vertical-align: middle; }
.badge { font-size: 12px; }
.sticky-bottom {
    position: sticky;
    bottom: 0;
    z-index: 10;
}
</style>
<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 align-items-center mb-3">
                <h4 class="page-title mb-0">
                    Monthly Advice Collection
                    <span class="badge bg-primary ms-2">
                        {{ $months[$month] }} {{ $year }}
                    </span>
                </h4>
            </div>
            
            {{-- <form method="GET" action="{{ route('monthly-advice-collect') }}">
                <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">
                            <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">
                            <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">
                <form method="POST" action="{{ route('monthly-advice-update') }}" id="advisory_collection_form">
                    <div class="card">
                        <div class="card-body">

                            <div class="table-responsive">
                                
								@csrf
                                <table class="table table-bordered table-hover align-middle" id="adviceCollection-datatable">
                                    <thead class="table-light">
                                        <tr>
                                            <th width="3%"></th>
                                            <th>Employee</th>
                                            <th>Loan Summary</th>
                                            <th>EMI</th>
                                            <th>Deductions</th>
                                            <th class="text-end">Total</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    @forelse($advice as $emp)
                                    <tr>
                                        <td class="text-center">
                                            <input type="checkbox" name="advice_id[]" value="{{ $emp->id }}" checked>
                                        </td>

                                        <td>
                                            <strong>{{ $emp->employee_name }}</strong><br>
                                            <small class="text-muted">
                                                {{ $months[$emp->month] }} {{ $emp->year }}
                                            </small>
                                        </td>

                                        <td>
                                            <span class="badge {{ $emp->type=='New'?'bg-info':'bg-warning' }}">
                                                {{ $emp->type }}
                                            </span>
                                            <div class="small mt-1">
                                                OS: ₹{{ number_format($emp->os_loan,2) }}<br>
                                                New: ₹{{ number_format($emp->new_loan,2) }}<br>
                                                After: ₹{{ number_format($emp->os_loan_after_recovary,2) }}
                                            </div>
                                        </td>

                                        <td>
                                            EMI: ₹{{ number_format($emp->emi,2) }}<br>
                                            <small class="text-muted">
                                                Start: {{ $emp->emi_start_from ? date('d-m-Y', strtotime($emp->emi_start_from)) : '-' }}
                                            </small>
                                        </td>

                                        <td>
                                            Thrift: ₹{{ number_format($emp->thrift_fund_deduction,2) }}<br>
                                            Welfare: ₹{{ number_format($emp->wellfare_fund,2) }}
                                        </td>

                                        <td class="text-end fw-bold text-success">
                                            ₹{{ number_format($emp->total_deduction,2) }}
                                        </td>
                                    </tr>
                                    @empty
                                    <tr>
                                        <td colspan="6" class="text-center text-muted">
                                            No unpaid advice found
                                        </td>
                                    </tr>
                                    @endforelse
                                    </tbody>

                                </table>

                            </div>
                        </div>
                        <div class="card-footer text-end bg-light sticky-bottom">
                            @if($canCollect && $advice->count())
                                <button id="collect-advice" class="btn btn-warning px-4">
                                    <i class="fa fa-money"></i> Collect Selected
                                </button>
                            @endif
                        </div>

                    </div>
                    </form>
                </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>

<script>
    $(document).ready(function() {
        $('#collect-advice').click(function(e){
            var isChecked = $('input[name="advice_id[]"]:checked').length > 0;
            if(isChecked){
                swal({
                    title: "Are you sure?",
                    text: "All selected advisory member amount are collected",
                    icon: "warning",
                    buttons: true,
                    dangerMode: true,
                    })
                .then((willDelete) => {
                    if (willDelete) {
                    
                            $('#advisory_collection_form').submit();
                        
                    // swal("Poof! Your imaginary file has been deleted!", {
                    //     icon: "success",
                    // });
                    }
                });
            }else{
                swal("No data found or no data selected", {
                icon: "info",
                });
            }
            e.preventDefault();
          
        })
    // $('#adviceCollection-datatable').DataTable({
    //     "paging": true,
    //     "lengthChange": true,
    //     "searching": true,
    //     "ordering": true,
    //     "info": true,
    //     "autoWidth": false,
    //     "responsive": true,
    // });

});
</script>