@extends('layouts.admin', ['title' => 'Silc Records'])

@section('content')
    <div class="main-content">

        <div class="page-content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header d-flex justify-content-between">
                                <h5 class="card-title mb-0">Silc Records</h5>
                                {{--<a href="{{url('/partners/create')}}" class="btn btn-primary">
                                    Add Partner
                                </a>--}}
                                <a href="/export-data?type=silc&{{$query_string}}" class="btn btn-outline-dark"><span class="ri ri-download-2-line"></span> Download</a>
                            </div>
                            <div class="card-body">
                                <div class="row py-3 mb-2 d-flex align-items-center bg-light">
                                    <div class="col-auto"><h5>Filters</h5></div>
                                    <form class="row align-items-end">
                                        <div class="col-auto">
                                            <label>Start Date</label>
                                            <input type="date" name="start_date" class="form-control" placeholder="start date" value="{{request()->get('start_date')}}">
                                        </div>
                                        <div class="col-auto">
                                            <label>End Date</label>
                                            <input type="date" name="end_date" class="form-control" placeholder="end date" value="{{request()->get('end_date')}}">
                                        </div>
                                        <div class="col-auto">
                                            <label>Districts</label>
                                            <select name="district" class="form-control" id="districts_filter">
                                                <option value="">All</option>
                                                @foreach($districts as $item)
                                                    @if(request()->get('district') == $item->id)
                                                        <option value="{{$item->id}}" selected>{{$item->district}}</option>
                                                    @else
                                                        <option value="{{$item->id}}">{{$item->district}}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-auto" id="subcounties-filter-div" style="display: none;">
                                            <label>Subcounties</label>
                                            <select name="subcounty" id="subcounties_filter">
                                                <option value=""></option>
                                            </select>
                                        </div>
                                        <div class="col-auto">
                                            <label>Download Year</label>
                                            <select name="year" class="form-control" id="year_filter">
                                                <option value="">Current</option>
                                                @foreach(range(2023,\Illuminate\Support\Carbon::now()->year,1) as $item)
                                                    @if(request()->get('year') == $item)
                                                        <option value="{{$item}}" selected>{{$item}}</option>
                                                    @else
                                                        <option value="{{$item}}">{{$item}}</option>
                                                    @endif
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-auto pt-3">
                                            <button type="submit" class="btn btn-dark">Apply</button>
                                        </div>
                                        <div class="col-auto pt-3">
                                            <a href="{{url()->current()}}" type="button" class="btn btn-danger">Clear</a>
                                        </div>
                                    </form>
                                </div>
                                <table id="silc_" class="table table-bordered dt-responsive nowrap table-striped align-middle" style="width:100%">
                                    <thead>
                                    <tr>
                                        <th>No.</th>
                                        <th>Farmer Group</th>
                                        <th>Meeting time</th>
                                        <th>Month Savings</th>
                                        <th>Month Loans</th>
                                        <th>Subcounty</th>
                                        <th>Approval Status</th>
                                        <th>Action</th>
                                    </tr>
                                    </thead>

                                </table>
                            </div>
                        </div>
                    </div><!--end col-->
                </div><!--end row-->
            </div>
            <!-- container-fluid -->
        </div>

        <!-- End Page-content -->

        @endsection

        @push('scripts')

            <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
            <script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>
            <script src="https://cdn.datatables.net/responsive/2.2.9/js/dataTables.responsive.min.js"></script>
            <script src="//cdn.jsdelivr.net/npm/sweetalert2@11"></script>

            <script>


                ////////////////////////////////INITIALISATION OF DATATABLE ///////////////////////////
                $(document).ready(function(){

                    $('#year_filter').select2();
                    ///////////////////////////AJAX CSRF SET UP //////////////////////////////////////////////

                    $.ajaxSetup({
                        headers: {
                            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                        }
                    });


                    var table = $('#silc_').DataTable({
                        processing: true,
                        serverSide: true,
                        ajax: `/silc?${createQueryString()}`,
                        columns: [
                            { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable:false, searchable:false},
                            { data: 'farmer_group', name: 'farmer_group'},
                            { data: 'meeting_time', name: 'meeting_time'},
                            { data: 'monthly_savings', name: 'monthly_savings',},
                            { data: 'month_loan_amount', name: 'month_loan_amount'},
                            { data: 'sub_county', name: 's.sub_county'},
                            { data: 'approval', name: 'approval'},
                            { data: 'actions', name: 'actions'},
                        ]
                    });

                    $(document).on('click', '.btn-delete', function() {

                        var id = $(this).attr('id');

                        Swal.fire({
                            title: 'Are you sure?',
                            text: "This Role will be deleted",
                            icon: 'warning',
                            showCancelButton: true,
                            confirmButtonColor: '#3085d6',
                            cancelButtonColor: '#d33',
                            confirmButtonText: 'Yes, delete it!'
                        }).then((result) => {

                            if (result.isConfirmed) {

                                $.ajax({
                                    type:'post',
                                    url: '/delete-village-agent/'+id,
                                    success:function(response){
                                        Swal.fire(
                                            'Deleted!',
                                            'Village agent has been deleted.',
                                            'success'
                                        )
                                        table.ajax.reload();
                                    }
                                });
                            }

                        });

                    });
                });
            </script>
    @endpush