@extends('layouts.admin', ['title' => 'Participants 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">Participant 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/participants/create')}}" class="btn btn-primary">
                                        Add Linkage
                                    </a>
                                    <div>
                                        <a href="/export-data?type=participant_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="participants_bds" class="table table-bordered dt-responsive nowrap table-striped align-middle" style="width:100%">
                                    <thead>
                                    <tr>
                                        <th>No.</th>
                                        <th>Name</th>
                                        <th>Have Bank Account?</th>
                                        <th>Bank</th>
                                        <th>Got loan?</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 = $('#participants_bds').DataTable({
                        processing: true,
                        serverSide: true,
                        ajax: `/bds/participants?${createQueryString()}`,
                        columns: [
                            { data: 'DT_RowIndex', name: 'DT_RowIndex', orderable:false, searchable:false},
                            { data: 'name', name: 'name'},
                            { data: 'have_bank_account', name: 'have_bank_account'},
                            { data: 'bank', name: 'bank'},
                            { data: 'got_a_loan', name: 'got_a_loan'},
                            { 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