@extends('layout.default')

@section('content')
    <!--begin::Content-->
    <!--Begin::Row-->

    @php
        use App\Helpers\Helper;
        $uid = Auth::user()->id;

    $school_id = \App\Models\Teacher::where('user_id',$uid)->first()->school_id;
    $students_count   = \App\Models\Student::join('users','users.id','students.school_id')
                        ->where('school_id',$school_id)->count();
    $teachers_count   =  \App\Models\Teacher::join('schools','schools.id','teachers.school_id')
                       ->where('school_id',$school_id)->count();

        $classes_count  = \App\Models\Classes::join('schools','schools.id','classes.school_id')
                            ->join('users','users.id','schools.user_id')
                            ->where('schools.user_id',$uid)->count();
         $quiz_count     = \App\Models\CustomQuiz::join('teachers','teachers.id','custom_quiz.teacher_id')
                        ->join('schools','schools.id','teachers.school_id')
                            ->join('users','users.id','schools.user_id')
                            ->where('schools.user_id',$uid)->count();
        $task_count     = \App\Models\Task::join('teachers','teachers.user_id','tasks.assigned_by')
                            ->join('schools','schools.id','teachers.school_id')
                            ->join('users','users.id','schools.user_id')
                            ->where('schools.id',$school_id)
                            ->count();
        $is_plan = Helper::checkSchoolAdsPlan();
    @endphp


    <div class="row">
        @include('layout.left-ads')
        <div class="col-lg-{{ !$is_plan?8:12 }} my-5">
            <div class="row">
                <div class="col-lg-3">
                    <!--begin::Stats Widget 30-->
                    <a href="{{ url('teacher/teacher') }}" class="card card-custom bg-kay card-stretch gutter-b">
                        <!--begin::Body-->
                        <div class="card-body">
                    <span
                        class="card-title font-weight-bolder text-white card-h-size mb-0 d-block">{{ $teachers_count }}</span>
                            <span
                                class="font-weight-bold text-white font-size-h6 font-size-sm">Teacher List</span>
                        </div>
                        <!--end::Body-->
                    </a>
                    <!--end::Stats Widget 30-->
                </div>
                <div class="col-lg-3">
                    <!--begin::Stats Widget 32-->
                    <a href="{{ url('teacher/student') }}" class="card card-custom bg-kay card-stretch gutter-b">
                        <!--begin::Body-->
                        <div class="card-body">
                    <span
                        class="card-title font-weight-bolder text-white card-h-size mb-0 d-block">{{ $students_count }}</span>
                            <span
                                class="font-weight-bold text-white font-size-h6 font-size-sm">Student List </span>
                        </div>
                        <!--end::Body-->
                    </a>
                    <!--end::Stats Widget 32-->
                </div>
                <div class="col-lg-3">
                    <!--begin::Stats Widget 25-->
                    <a href="{{ url('teacher/tasks/all') }}" class="card card-custom bg-kay card-stretch gutter-b">
                        <!--begin::Body-->
                        <div class="card-body">
                    <span
                        class="card-title font-weight-bolder text-white card-h-size mb-0 d-block">{{$task_count}}</span>
                            <span
                                class="font-weight-bold text-white font-size-h6 font-size-sm">Tasks Set By Teachers</span>
                        </div>
                        <!--end::Body-->
                    </a>
                    <!--end::Stats Widget 25-->
                </div>
                <div class="col-lg-3">
                    <!--begin::Stats Widget 26-->
                    <a href="{{ url('teacher/class') }}" class="card card-custom bg-kay card-stretch gutter-b">
                        <!--begin::ody-->
                        <div class="card-body">
                    <span
                        class="card-title font-weight-bolder text-white card-h-size mb-0 d-block">{{$classes_count}}</span>
                            <span class="font-weight-bold text-white font-size-h6 font-size-sm">Total Classes</span>
                        </div>
                        <!--end::Body-->
                    </a>
                    <!--end::Stats Widget 26-->
                </div>
            </div>
            <div class="card card-custom gutter-b">
                <div class="card-body">
                    <h4>Teacher List</h4>
                    <table class="table table-hover display" id="teacherdataTables" style="width:100%">
                        <thead>
                        <tr>
                            <th>Name</th>
                            <th>Account Created</th>
                            <th>Last Logged In</th>
                            <th>User Level</th>
                            <th>Total Tasks Set</th>
                        </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>

            <div class="card card-custom gutter-b">
                <div class="card-body">
                    <h4>Student List</h4>
                    <table class="table table-hover display" id="studentdataTables" style="width:100%">
                        <thead>
                        <tr>
                            <th>Name</th>
                            <th>Username</th>
                            <th>Email</th>
                            <th>Year</th>
                            <th>Class</th>
                        </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        @include('layout.right-ads')
    </div>
@endsection
@section('styles')
    <link href="{{ url('plugins/custom/datatables/datatables.bundle.css?v=7.0.6')}}" rel="stylesheet" type="text/css"/>
@endsection

@section('scripts')
    <script src="{{ url('assets/js/pages/widgets.js?v=7.0.6') }}"></script>
    <script src="{{ url('plugins/custom/datatables/datatables.bundle.js?v=7.0.6')}}"></script>
    <!-- <script src="assets/js/pages/features/charts/apexcharts.js?v=7.0.6"></script> -->
    <script>
        const primary = '#6993FF';
        const success = '#1BC5BD';
        const info = '#8950FC';
        const warning = '#FFA800';
        const danger = '#F64E60';

        var teachertable;
        var studenttable;

        //Generate List
        teachertable = $('#teacherdataTables').DataTable({
            bSearchable: true,
            pagination: true,
            // pageLength: 10,
            responsive: true,
            searchDelay: 500,
            processing: !0,
            serverSide: !0,
            "aLengthMenu": [[50, 100, 500, -1], [50, 100, 500, "All"]],
            "pageLength": 50,
            ajax: {
                url: '{{ url('teacher/teacher/lists') }}',
            },
            columns: [
                {data: 'name', name: 'name'},
                // {data: 'subjects', name: 'subjects'},
                {data: 'account_created', name: 'account_created'},
                {data: 'last_logged_in', name: 'last_logged_in'},
                // {data: 'studentCount', name: 'studentCount'},
                {data: 'teacher_type', name: 'teacher_type'},
        {data: 'total_task_set', name: 'total_task_set'},

            ]
        });


        //Generate List
        studenttable = $('#studentdataTables').DataTable({
            bSearchable: true,
            pagination: true,
            // pageLength: 10,
            responsive: true,
            searchDelay: 500,
            processing: !0,
            serverSide: !0,
            "aLengthMenu": [[50, 100, 500, -1], [50, 100, 500, "All"]],
            "pageLength": 50,
            ajax: {
                url: '{{ url('teacher/student/lists') }}',
            },
            columns: [
                // {data: 8, name: "checkrows", orderable: false, searchable: !1},
                {data: 'fname', name: 'fname'},
                {data: 'username', name: 'username'},
                {data: 'email', name: 'email'},
                {data: 'year', name: 'year'},
                {data: 'class', name: 'class'},

            ]
        });

        $(".search").keyup(function () {
            table.draw();
            deltable.draw();
        });

        function search(value) {
            value.search_name = $('input[name=name]').val();
            value.country = $("#country").val();
            value.curriculum = $("#curriculum").val();
            value.region = $("#region").val();
            value.subject = $("#subject").val();
            value.teacher_type = $("#teacher_type_hidden").val();
        }

        var KTApexChartsDemo = function () {
            var _demo4 = function () {
                const apexChart = "#chart_4";

                var curriculam = [{
                    name: 'AQA',
                    data: [41, 55, 41, 37, 22, 43, 21, 30, 25, 61, 29, 43]
                }, {
                    name: 'EDEX',
                    data: [53, 32, 33, 52, 13, 43, 32, 44, 56, 23, 50, 69]
                }];


                var options = {
                    series: curriculam,
                    chart: {
                        type: 'bar',
                        height: 450,
                        stacked: true,
                    },
                    plotOptions: {
                        bar: {
                            horizontal: true,
                        },
                    },
                    stroke: {
                        width: 1,
                        colors: ['#fff']
                    },
                    title: {
                        text: 'Curriculum Sales Report - 2020'
                    },
                    xaxis: {
                        categories: ['Jan', 'Feb', 'March', 'Aprin', 'May', 'June', 'July', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'],
                        labels: {
                            formatter: function (val) {
                                return val + "K"
                            }
                        }
                    },
                    yaxis: {
                        title: {
                            text: undefined
                        },
                    },
                    tooltip: {
                        y: {
                            formatter: function (val) {
                                return val + " K Users"
                            }
                        }
                    },
                    fill: {
                        opacity: 1
                    },
                    legend: {
                        position: 'top',
                        horizontalAlign: 'left',
                        offsetX: 40
                    },
                    colors: [primary, success, warning, danger, info]
                };

                var chart = new ApexCharts(document.querySelector(apexChart), options);
                chart.render();
            }

            return {
                // public functions
                init: function () {
                    _demo4();
                }
            };

        }();

        jQuery(document).ready(function () {
            KTApexChartsDemo.init();
        });


    </script>
@endsection