@extends('administrative.layouts.master')
@section('page-css')
    <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css">






@endsection
@section('content')
    <nav class="page-breadcrumb">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ route('administrative.dashboard') }}">Dashboard</a></li>
        @php
            $link = url('/');
        @endphp

        @foreach(request()->segments() as $segment)
            @php
                $link .= "/" . request()->segment($loop->iteration);
            @endphp
            @if(rtrim(request()->route()->getPrefix(), '/') != $segment && ! preg_match('/[0-9]/', $segment))
                @if($loop->last)
                    <li class="breadcrumb-item {{ $loop->last ? 'active' : '' }}" {{ $loop->last ? 'aria-current="page"' : '' }}>
                        @if($loop->last)
                            {{ $segment}}
                        @else
                            <a href="{{ $link }}">{{ $segment }}</a>
                        @endif
                    </li>
                @endif
            @endif
        @endforeach

        </ol>
    </nav>
    <div class="d-flex justify-content-between align-items-center flex-wrap grid-margin">
        <div>
            <h4 class="mb-3 mb-md-0">Student List</h4>
        </div>
        <div class="d-flex align-items-center flex-wrap text-nowrap">
            {{-- <a href="{{route('administrative.games.create')}}" class="btn btn-primary btn-icon-text mb-2 mb-md-0">
                <i class="btn-icon-prepend" data-feather="plus-square"></i>
                Add New
            </a> --}}
        </div>
    </div>
    <div class="row">
        <div class="col-md-12 grid-margin stretch-card">
            <div class="card">
                <div class="card-body">
                    <h6 class="card-title"> </h6>
                    <div class="table-responsive">
                        <table id="datatables" class="table">
                            <thead>
                            <tr>
                                <th> SL</th>
                                <th> Guardian ID</th>
                                <th> Guardian name</th>
                                <th> Guardian email </th>
                                <th> Guardian country </th>
                                <th>Registration Date</th>
                                <th>Student Name</th>
                                <th>Student Username</th>
                                <th>Student age (range)	</th>
                                <th>Student profile creation date	</th>

                                <th>Student's current position</th>
                                <th>Student's current score</th>
                                <th>Subscription purchased</th>
                                <th>Time spent in Bangla Iskool</th>
                                <th>No. of days since last used</th>
                                {{-- <th>City</th>
                                <th>Country</th> --}}
                                {{-- <th class="disabled-sorting text-right">Actions</th> --}}
                            </tr>
                            </thead>
                            <tbody></tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('page-js')

    <script src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js"></script>

    <script>
        $(document).ready(function() {
            $('#datatables').DataTable({
                "aLengthMenu": [
                    [10, 30, 50, -1],
                    [10, 30, 50, "All"]
                ],
                dom: 'Bfrtip',
                buttons: [

                    'excelHtml5',
                    'csvHtml5',
                    'pageLength'
                ],
                "iDisplayLength": 10,
                "language": {
                    search: ""
                },
                processing: true,
                serverSide: true,
                ajax: '{{route('administrative.user.data.student')}}',
                columns: [
                    {data: 'id', name: 'id'},
                    {data: 'parent.id', name: 'parent.id',"defaultContent": "",},
                    {data: 'parent_name', name: 'parent_name'},
                    {data: 'parent_email', name: 'parent_email'},
                    {data: 'parent_country', name: 'parent_country'},
                    {data: 'registration_date', name: 'registration_date'},
                    {data: 'name', name: 'name'},
                    {data: 'username', name: 'username'},
                    {data: 'age_range', name: 'age_range'},
                    {data: 'created_at', name: 'created_at'},

                    {data: 'current_position', name: 'current_position'},
                    {data: 'current_score', name: 'current_score'},
                    {data: 'purchased', name: 'purchased'},
                    {data: 'timeSpent', name: 'timeSpent'},
                    {data: 'lastUseDays', name: 'lastUseDays'},
                    // {data: 'city', name: 'city'},
                    // {data: 'country', name: 'country'},
                    // {data: 'action', name: 'action'}
                ]
            });
        });

        function deleteData(rowid) {
            let url = '{{ route("administrative.user.destroy", ":id") }}';
            url = url.replace(':id', rowid);
            swal.fire({
                title: "Are you sure?",
                text: "Once deleted, you will not be able to recover this imaginary file!",
                icon: "warning",
                buttons: true,
                dangerMode: true,
            })
                .then((willDelete) => {
                    if (willDelete) {
                        axios.delete(url).then(res => {
                            if(res.data == 'success'){
                                swal.fire({
                                    icon: "success",
                                    button: false,
                                    timer: 1000,
                                });
                                $('#datatables').DataTable().ajax.reload( null, false );
                            }
                        });
                    } else {
                        swal("Your imaginary file is safe!");
                    }
                });
        }
    </script>
@endsection