@extends('layout.default')

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

@php 
    $uid = Auth::user()->id;
    $school_id = \App\Models\School::where('user_id',$uid)->first()->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();
@endphp


<div class="row mt-10">
    <div class="col-xl-3">
        <!--begin::Stats Widget 30-->
        <a href="{{ url('school/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">Registered Teachers </span>
            </div>
            <!--end::Body-->
        </a>
        <!--end::Stats Widget 30-->
    </div>
    <div class="col-xl-3">
        <!--begin::Stats Widget 32-->
        <a href="{{ url('school/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">Registered Students </span>
            </div>
            <!--end::Body-->
        </a>
        <!--end::Stats Widget 32-->
    </div>
    <div class="col-xl-3">
        <!--begin::Stats Widget 25-->
        <a 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-xl-3">
        <!--begin::Stats Widget 26-->
        <a href="{{ url('school/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="row">
    <div class="col-xl-12"> -->
        <!--begin::Content-->
        <div class="card card-custom gutter-b">
            <div class="card-body">
                <h4>Teachers List</h4>
                <table class="table table-hover display" id="teacherdataTables"  style="width:100%">
                    <thead>
                        <tr>
                            <th>Name</th>
                           <!--  <th>Subjects</th> -->
                            <th>Account Created</th>
                            <th>Last Logged In</th>
                            <!-- <th>Students Count</th> -->
                            <th>Type</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    <!-- </div>
</div> -->

<!-- <div class="row">
    <div class="col-xl-12"> -->
        <!--begin::Content-->
        <div class="card card-custom gutter-b">
            <div class="card-body">
                <h4>Students List</h4>
                <table class="table table-hover display" id="studentdataTables"  style="width:100%">
                    <thead>
                        <tr>
                            <!-- <th style="text-align:left"><input type="checkbox" name="selectall" id="selectall" /></th> -->
                            <th>Name</th>
                            <th>Username</th>
                            <th>Email</th>
                            <th>Year</th>
                            <th>Class</th>
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    <!-- </div>
</div> -->


<!--End::Row-->
<!--Begin::Row-->




@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,
    ajax: {
        url: '{{ url('school/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'},

    ]
});


//Generate List
studenttable = $('#studentdataTables').DataTable({       
    bSearchable: true,
    pagination: true,
    pageLength: 10,
    responsive: true,
    searchDelay: 500,
    processing: !0,
    serverSide: !0,
    ajax: {
        url: '{{ url('school/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