@extends('layouts.admin', ['title' => 'FarmerGroup BDS Linkages'])

@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">
                                <h5 class="card-title mb-0">Farmer Groups BDS Linkages</h5>
                            </div>
                            <div class="col-sm-12">
                                <div class="card-body btn-showcase d-flex justify-content-between align-content-center">
                                    <a href="{{url('/bds/farmer-groups/create')}}" class="btn btn-primary">
                                        Add Linkage
                                    </a>
                                    <div>
                                        <a href="/export-data?type=farmergroup_bds&{{$query_string}}" class="btn btn-outline-dark"><span class="ri ri-download-2-line"></span> Download</a>
                                    </div>
                                </div>
                            </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 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="farmer_groups_bds"
                                       class="table table-bordered dt-responsive nowrap table-striped align-middle"
                                       style="width:100%">
                                    <thead>
                                    <tr>
                                        <th>No.</th>
                                        <th>Name</th>
                                        <th>Type</th>
                                        <th>Bank Account?</th>
                                        <th>Completed Constitution?</th>
                                        <th>Accessed Inputs?</th>
                                        <th>Financial training?</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 () {

                    ///////////////////////////AJAX CSRF SET UP //////////////////////////////////////////////

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


                    var table = $('#farmer_groups_bds').DataTable({
                        processing: true,
                        serverSide: true,
                        ajax: `/bds/farmer-groups?${createQueryString()}`,
                        columns: [
                            {data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false},
                            {data: 'name', name: 'name'},
                            {data: 'type', name: 'type'},
                            {data: 'have_bank_account', name: 'have_bank_account'},
                            {data: 'have_completed_constitution', name: 'have_completed_constitution'},
                            {data: 'accessed_inputs', name: 'accessed_inputs'},
                            {data: 'received_financial_training', name: 'received_financial_training'},
                            {data: 'actions', name: 'actions'},
                        ]
                    });
                });
            </script>
    @endpush