@extends('layouts.admin')

@section('content')
<!-- $posts->links('pagination::bootstrap-5') -->

<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <!-- Search Section -->
        <form action="{{ route('admin.inactive.search') }}" method="get">
            <div class="mb-5">
                <div class="">
                    <div class="p-5 bg-white">
                        <div class="mt-3 item2-gl-nav">
                            <div class="d-block ">
                                <h5 class="mb-2 mt-0">@lang('student.filter by')</h5>
                                <div class="row">
                                    <div class="col-md-6">
                                        <label class=" mt-3 mb-sm-1"> Sessions: </label>
                                        <select class="form-control select2-show-search" id="session" name="acysid">
                                            <option value="0" selected disabled>Select session</option>
                                            @foreach ($sessions as $session)
                                            <option value="{{$session->acysid}}">{{$session->acyname}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-6">
                                        <label class=" mt-3 mb-sm-1"> Course Name: </label>
                                        <select class="form-control select2-show-search" id="course" name="course">

                                        </select>
                                    </div>
                                    <div class="col-md-2 mt-6">
                                        <input type="submit" class="btn btn-primary br-te-7 br-be-7 " value="@lang('student.apply filter')">
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>
        <!--End Search Section -->
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Inactive Students List</h3>
                    </div>
                    <div class="card-body">
                        @if (count($inactive) > 0)
                        <form action="{{route('admin.inactive.export')}}" method="get">
                            <input type="hidden" name="course" value="{{request()->course}}">
                            <button type="submit" class="btn btn-primary mx-auto d-block w-25 my-6">Export</button>
                        </form>
                        @endif
                        <div class="table-responsive" id="students">
                            <table class="table table-striped table-bordered table-vcenter text-nowrap" id="students_table">
                                <thead>
                                    <tr>
                                        <th style="text-align: center;">ID</th>
                                        <th style="text-align: center;">enrollment method</th>
                                        <th style="text-align: center;">Student Name</th>
                                        <th style="text-align: center;">Email</th>
                                        <th style="text-align: center;">Phone</th>
                                        <th style="text-align: center;">Course</th>
                                        <th style="text-align: center;">Abscence Count</th>
                                        <th></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $count=0;
                                    @endphp
                                    @foreach ($inactive as $inactiveItem )
                                    <tr>
                                        <td style="text-align: center;">{{ ++$count }}</td>
                                        <td style="text-align: center;">
                                            <span class="badge badge-{{$inactiveItem->fees_by_lesson ? 'success':'info'}}">
                                                {{$inactiveItem->fees_by_lesson ? 'by lesson':'by course'}}
                                            </span>
                                        </td>
                                        <td style="text-align: center;">
                                            <a href="{{route('admin.students.show',[$inactiveItem->id])}}" target="_blank">
                                                {{$inactiveItem->first_name." ".$inactiveItem->middle_name." ".$inactiveItem->last_name}}
                                            </a>
                                        </td>
                                        <td style="text-align: center;">{{$inactiveItem->email}}</td>
                                        <td style="text-align: center;">{{$inactiveItem->phone}}</td>
                                        <td style="text-align: center;">
                                            {{ $inactiveItem->acyname }}_{{$inactiveItem->has_label ? ' ( '.$inactiveItem->label.' ) ':''}} {{ $inactiveItem->cname }}
                                            ( {{ $inactiveItem->lshort_name }} )
                                            {{ $inactiveItem->ttname }}
                                        </td>
                                        <td style="text-align: center;">{{$inactiveItem->attendance_count}}</td>
                                        <td style="text-align: center;">
                                            <a href="{{route('admin.inactive.details',[$inactiveItem->id,$inactiveItem->coffid])}}" target="_blank" class="btn btn-outline-primary btn-sm">View Attendance List</a>
                                        </td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <div class="mt-4">
                                {{ $inactive->appends(Request::except('page'))->render('inc.paginate') }}
                            </div>
                            <p class="mt-3">
                                Displaying {{$inactive->count()}} of {{ $inactive->total() }} transaction(s).
                            </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('admin-js')
<script>
    $(document).ready(function(){
        $('#students_table').dataTable( {
            "drawCallback": function( settings ) {
            },
        "bPaginate": false,
        "searching": true,
        "ordering": true,
        "info": false,
        })	
    })
</script>
<script>
    $(document).ready(function() {
        // course session filter
        $('#session').on('change', function() {
            var $course = $('#course');
            $('#course').empty();
            $('#course').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('sessionFilter') }}",
                type: 'GET',
                data: {
                    acysid: $(this).val()
                },
                success: function(data) {
                    console.log(data)
                    $('#course').empty();
                    $('#course').append(
                        `<option value="0" disabled selected>Select Course*</option>`);
                    // offered course
                    $.each(data, function(id, value) {

                        value.teaching_team.coaching_teachers.map((teacher) => {
                            $course.append('<option value="' + value.coffid + '">' +
                                (value.has_label ? '( ' + value.label + ' ) ' : '') + value.course.cname + ' ( ' + value.course.level.lshort_name + ' ) ' +
                                '_ ' + teacher.first_name + ' ' + teacher.middle_name + ' ' + teacher.last_name +
                                '_ ' + value.academic_year_session.acyname +
                                '</option>');
                        })

                    });
                }
            });
        });

    })
</script>
@endsection