@php
$uid = Auth::user()->id;
$count_students = \App\Models\Student::join('users','users.id','students.school_id')
->where('users.id',$uid)->count();
$count_teachers = \App\Models\Teacher::join('schools','schools.id','teachers.school_id')
->join('users','users.id','schools.user_id')
->where('schools.user_id',$uid)->count();
$count_classes = \App\Models\Classes::join('teachers','teachers.id','classes.teacher_id')
->join('schools','schools.id','teachers.school_id')
->join('users','users.id','schools.user_id')
->where('schools.user_id',$uid)->count();
$count_quiz = \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();
@endphp
{{ $count_students ?? 0 }}
Total Students
{{ $count_groups ?? 0 }}
Total Teachers
{{ $count_classes ?? 0 }}
Total Classes
{{ $count_quiz ?? 0 }}
Total Tasks