@extends('layouts.admin', ['title' => 'Farmer Groups'])

@push('stylesheets')

<!--datatable css-->
<link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css" />
<!--datatable responsive css-->
<link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.bootstrap.min.css" />

<meta name="csrf-token" content="{{ csrf_token() }}">

@endpush

@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</h5>
                            </div>
                            <div class="col-sm-12">
                                <div class="card-body btn-showcase d-flex justify-content-between align-content-center">
                                    <a href="/add-farmer-group">
                                        <button class="btn btn-primary" type="button">Add Farmer Group</button>
                                    </a>
                                    <div>
                                        <a target="_blank"
                                           href="/export-data?type=farmer_groups&{{$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>District</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>Active Status</label>
                                            <select name="active_status" class="form-control">
                                                <option value="">All</option>
                                                @foreach(Config::get('constants.group_statuses') as $item)
                                                    @if(request()->get('active_status') == $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="farmer-groups"
                                       class="table table-bordered dt-responsive nowrap table-striped align-middle"
                                       style="width:100%">
                                    <thead>
                                    <tr>
                                        <th>No.</th>
                                        <th>Group name</th>
                                        <th>Group Code</th>
                                        <th>Farmers</th>
                                        <th>Village</th>
                                        <th>Group representative</th>
                                        {{--<th>Group representative contact</th>
                                        <th>Group representative position</th>--}}
                                        <th>Created By</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>
                ///////////////////////////AJAX CSRF SET UP //////////////////////////////////////////////

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

                // get filters
                const start_date_filter = "{{request()->get('start_date','')}}";
                const end_date_filter = "{{request()->get('end_date','')}}";

                ////////////////////////////////INITIALISATION OF DATATABLE ///////////////////////////
                $(document).ready(function () {
                    $('#farmer-groups').DataTable({
                        processing: true,
                        serverSide: true,
                        ajax: `/view-farmer-groups?${createQueryString()}`,
                        columns: [
                            {data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false, searchable: false},
                            {data: 'farmer_group', name: 'farmer_groups.farmer_group'},
                            {data: 'farmer_group_code', name: 'farmer_groups.farmer_group_code'},
                            {data: 'farmers', name: 'farmers'},
                            {data: 'village', name: 'villages.village'},
                            {
                                data: 'group_representative',
                                name: 'farmer_groups.group_representative',
                                orderable: false,
                                searchable: false
                            },
                            // {data: 'group_representative_contact', name: 'farmer_groups.group_representative_contact'},
                            // {data: 'position', name: 'group_positions.position'},
                            {data: 'name', name: 'users.name'},
                            {data: 'actions', name: 'actions'},
                        ]
                    });
                });
            </script>


    @endpush