@extends('layouts.admin')

@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <x-page.header>External Students</x-page.header>
        @include('admin.errors.form-errors')
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Add New External Student</h3>
                    </div>
                    <div class="card-body">
                            <div class="tab-menu-heading  d-flex justify-content-center">
                                <div class="tabs-menu ">
                                    <!-- Tabs -->
                                    <ul class="nav panel-tabs">
                                        <li class="">
                                            <a href="#tab1" class="active" data-bs-toggle="tab">
                                                Manual
                                                <i class="fa fa-hand-paper-o ms-1"></i>
                                            </a>
                                        </li>
                                        <li>
                                            <a href="#tab2" data-bs-toggle="tab" class="">
                                                From CSV
                                                <i class="fa fa-file-excel-o ms-1"></i>
                                            </a>
                                        </li>
                                    </ul>
                                </div>
                            </div>
                            <div class="panel-body tabs-menu-body">
                                <div class="tab-content">
                                    <div class="tab-pane active py-6" id="tab1">
                                        <form enctype="multipart/form-data" method="POST" action="{{route('staff.external_students.store')}}"
                                        class="form-horizontal" id="create_form">
                                        @csrf
                                            <div class="form-group ">
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <label class="form-label mt-2" for="name">Name <i
                                                                class="text-danger">(required)</i></label>
                                                    </div>
                                                    <div class="col-md-9">
                                                        <input type="text" value="{{ old('name') }}" name="name" id="name" required class="form-control">
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="form-group ">
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <label class="form-label mt-2" for="email">Email <i
                                                                class="text-danger">(required)</i></label>
                                                    </div>
                                                    <div class="col-md-9">
                                                        <input type="email" name="email" value="{{ old('email') }}" class="form-control" id="email"
                                                            required>
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="form-group ">
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <label class="form-label mt-2" for="course">Course</label>
                                                    </div>
                                                    <div class="col-md-9">
                                                        <select name="course" id="manual_course" class="form-control select2-show-search" required>
                                                            @foreach ($offered_courses as $course)
                                                                <option value="{{$course->coffid}}">
                                                                    {{$course->has_label ? ' ( '.$course->label.' ) ':''}}
                                                                    {{$course->acyname.'_'
                                                                    .$course->cname.' ( '
                                                                    .$course->lshort_name.' ) '.'_ '
                                                                    .$course->ttname
                                                                    }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-group ">
                                                <div class="row">
                                                    <label class="form-swich">
                                                        <input type="checkbox" name="is_active" class="form-switch-input status-checkbox" checked>
                                                        <span class="form-switch-indicator"></span>
                                                        <span class="form-switch-description">is_active</span>
                                                    </label>
                                                </div>
                                            </div>
                                            <div class="form-group mb-3 d-flex justify-content-center">
                                                <div class="">
                                                    <button type="submit" class="btn btn-primary waves-effect waves-light">Add New
                                                        External Student</button>
                                                </div>
                                            </div>
                                        </form>
                                    </div>
                                    <div class="tab-pane" id="tab2">
                                        <div class="alert alert-primary">
                                            <div class="d-flex">
                                                <form method="get" action="{{route('staff.external_students.downloadExcelTemplate')}}">
                                                    <b>*Please download this template file in order to be able to upload the data properly</b>
                                                    <button type="submit" class="btn btn-sm text-light ms-3" style="background:#8c2828">
                                                        Download
                                                        <i class="fa fa-cloud-download ms-1"></i>
                                                    </button>
                                                </form>
                                            </div>
                                        </div>
                                        <form id="upload_form" enctype="multipart/form-data" method="POST" action="{{route('staff.external_students.uploadExcel')}}">
                                        @csrf
                                        <div id="loading_section" class="d-none" style="background:#ef9230;z-index:100;opacity:.5;position:absolute;top:0;left:0;width:100%;height:100%">
                                            <div class="dimmer active m-0">
                                                <div class="lds-ring"><div></div><div></div><div></div><div></div></div>
                                            </div>
                                        </div>
                                            <div class="form-group ">
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <label class="form-label mt-2" for="course">Course</label>
                                                    </div>
                                                    <div class="col-md-9">
                                                        <select name="course" id="upload_course" class="form-control select2-show-search" required>
                                                            @foreach ($offered_courses as $course)
                                                                <option value="{{$course->coffid}}">
                                                                    {{$course->has_label ? ' ( '.$course->label.' ) ':''}}
                                                                    {{$course->acyname.'_'
                                                                    .$course->cname.' ( '
                                                                    .$course->lshort_name.' ) '.'_ '
                                                                    .$course->ttname
                                                                    }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-group ">
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <label class="form-label mt-2" for="file">File <i
                                                                class="text-danger">(required)</i></label>
                                                    </div>
                                                    <div class="col-md-9">
                                                        <div class="control-group form-group">
                                                            <div class="input-group file-browser">
                                                                <input type="text" class="form-control border-end-0 browse-file bg-transparent" placeholder="Upload CSV" readonly="" required>
                                                                <label class="input-group-btn mb-0">
                                                                   <span class="btn btn-primary br-bs-0 br-ts-0">
                                                                    Browse <input type="file" name="file" style="display: none;" required accept=".csv">
                                                                  </span>
                                                               </label>
                                                            </div>
                                                        </div>
                                                        <div class="text-muted">
                                                            <span>*max allowed number of students are 500 per upload</span><br>
                                                            <span>*allowed format is csv only</span><br>
                                                            <span>*student email is unique per course</span><br>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="form-group mb-3 d-flex justify-content-center">
                                                <div class="">
                                                    <button type="submit" class="btn btn-primary waves-effect waves-light" id="upload_btn">
                                                        Upload
                                                        <i class="fa fa-cloud-upload ms-1"></i>
                                                    </button>
                                                </div>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                    </div>
                </div>
            </div>
        </div>
         <!-- Search Section -->
         <form action="{{ route('staff.external_students.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" name="course">

                                        </select>
                                    </div>
                                    <div class="col-md-6">
                                        <label class=" mt-3 mb-sm-1"> Student: </label>
                                        <select class="form-control select2-show-search" id="external_student" name="student">
                                            {{-- <option value="0" disabled selected>Select</option> --}}
                                        </select>
                                    </div>

                                </div>

                            </div>
                            <div class="mt-5 d-flex">
                                <div class="mx-auto">
                                    <input type="submit" id="submit" class="btn btn-primary"
                                        value="Apply Filter">
                                    {{-- <button href="{{route($unposted_transactions ? 'admin.unpostedPayment-transactions' : 'admin.postedPayment-transactions')}}" id="reset" class="btn btn-danger">Reset</button> --}}
                                </div>
                                @if ($request->query('acysid') > 0 && $request->query('course') > 0)
                                <div class="mx-auto" id="export_div">
                                    {{-- <a href="{{ route('staff.external_students.exportExcel', []) }}" class="btn btn-success">Export Excel</a> --}}
                                    {{-- <button href="{{route($unposted_transactions ? 'admin.unpostedPayment-transactions' : 'admin.postedPayment-transactions')}}" id="reset" class="btn btn-danger">Reset</button> --}}
                                    <a id="export_external_student" class="btn btn-success" style="color:white">Export Excell <i class="fa fa-file-excel-o ms-1"></i></a>
                                </div>
                                @else

                                @endif

                            </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">External Students List</h3>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <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;">name</th>
                                        <th style="text-align: center;">email</th>
                                        <th style="text-align: center;">course</th>
                                        <th style="text-align: center;">added by</th>
                                        <th style="text-align: center;">status</th>
                                        <th></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $count=0
                                    @endphp
                                    @foreach ($external_students as $student )
                                    <tr>
                                        <td style="text-align: center;">{{++$count}}</td>
                                        <td>{{$student->name}}</td>
                                        <td>{{$student->email}}</td>
                                        <td style="text-align: center;">
                                        {{$student->has_label ? ' ( '.$student->label.' ) ':''}}
                                         {{$student->acyname.'_'
                                         .$student->cname.' ( '
                                         .$student->lshort_name.' ) '.'_'
                                         .$student->ttname

                                        }}
                                        </td>
                                        <td style="text-align: center;">{{{$student->added_by_fname.' '.$student->added_by_mname.' '.$student->added_by_lname}}}</td>
                                        <td style="text-align: center;">
                                            <span class="badge badge-{{$student->is_active ? 'success':'danger'}}">{{$student->is_active ? 'active':'inactive'}}</span>
                                        </td>
                                        <td style="text-align: center;">
                                            <div data-bs-toggle="tooltip"  data-bs-original-title="Edit">
                                                <a
                                                    href="{{route('staff.external_students.edit',$student->id)}}"
                                                    class="btn btn-outline-light btn-sm waves-effect waves-light edit"
                                                    data-bs-original-title="Edit"><i
                                                        class="fa fa-edit fs-16"></i></a>
                                            </div>
                                        </td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <div class="mt-4">
                                {{ $external_students->appends(Request::except('page'))->render('inc.paginate') }}
                            </div>
                            <p class="mt-3">
                                Displaying {{$external_students->count()}} of {{ $external_students->total() }} student(s).
                            </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('admin-js')
<script>
    var urlParams = window.location.href;

    document.getElementById("export_external_student").addEventListener("click", function() {
        var query = urlParams.split('?')[1].split('#')[0];

        var acysid = query.split('&')[0].split('=')[1];
        var course = query.split('&')[1].split('=')[1];
        var link = "{{ route('staff.external_students.exportExcel') }}?acysid=" + acysid + "&course=" + course;
        // console.log(acysid);
        // console.log(link);
        window.location.href = link;
    });
</script>

{{-- draw all data tables --}}
<script>
    $(document).ready(function(){
        $('#students_table').dataTable( {
            "drawCallback": function( settings ) {
            },
            "bPaginate": false,
            "searching": true,
            "ordering": true,
            "info": false,
        })
    })
</script>

<script>
    // course session filter
    $('#session').on('change', function() {
        var $course = $('#course_name');
        $('#course_name').empty();
        $('#course_name').append(`<option value="0" disabled selected>Processing...</option>`);
        $.ajax({
            url: "{{ route('sessionFilter') }}",
            type: 'GET',
            data: {
                acysid: $(this).val()
            },
            success: function(data) {
                $('#course_name').empty();
                $('#course_name').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>');
                    })

                });
            }
        });
    });

     // course session filter
     $('#course_name').on('change', function() {
        var $student = $('#external_student');
        $('#external_student').empty();
        $('#external_student').append(`<option value="0" disabled selected>Processing...</option>`);
        $.ajax({
            url: "{{ route('courseExternalStudentsFilter') }}",
            type: 'GET',
            data: {
                course: $(this).val()
            },
            success: function(data) {
                $('#external_student').empty();
                $('#external_student').append(
                    `<option value="0" disabled selected>Select Student*</option>`);

                $.each(data, function(id, value) {
                    $student.append('<option value="' + value.email + '">' +
                    value.name+' _ '+value.email
                    +'</option>');
                });
            }
        });
    });

    $('#upload_form').on('submit',function(){
        $('#upload_btn').attr('disabled',true)
        $('#upload_btn').html(
            `
            Uploading
            <div class="progress progress-md mb-3">
                <div class="progress-bar progress-bar-indeterminate progress-bar-striped " style="background:#8c2828"></div>
            </div>
            `
        )
        $('#loading_section').removeClass('d-none')
    })



</script>

@endsection