@extends('layout.default') @section('content') @php $students_count = \App\Models\User::where('role','student')->count(); $teachers_count = \App\Models\User::where('role','teacher')->count(); $schools_count = \App\Models\User::where('role','school')->count(); $tutors_count = \App\Models\User::where('role','tutor')->count(); $quiz_count = \App\Models\Quiz::count(); $videos_count = \App\Models\Video::count(); $school_students_count = \App\Models\User::join('students','students.user_id','users.id')->where('role','student')->whereIn('students.type',['Teacher','School'])->count(); $ind_students_count = \App\Models\User::join('students','students.user_id','users.id')->where('role','student')->where('students.is_individual',1)->count(); $new_reg_schools = \App\Models\User::join('schools','schools.user_id','users.id')->where('users.role','school')->where('schools.status',0)->get(); @endphp