public function index()
{
$classes = StudyClass::all();
$teacher_ids = array();
$assist_ids = array();
foreach ($classes as $class) {
if ($class->teach != null) {
$teacher_ids[] = $class->teach->id;
}
if ($class->assist != null) {
$assist_ids[] = $class->assist->id;
}
}
$teachers = User::whereIn('id', $teacher_ids)->get();
foreach ($teachers as &$teacher) {
$class_ids = array();
foreach ($teacher->teach as $t) {
$class_ids[] = $t->id;
}
$teacher->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->count();
$teacher->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->avg('rating_teacher');
}
$assistants = User::whereIn('id', $assist_ids)->get();
foreach ($assistants as &$assistant) {
$class_ids = array();
foreach ($assistant->assist as $t) {
$class_ids[] = $t->id;
}
$assistant->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->count();
$assistant->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->avg('rating_ta');
}
$this->data['teachers'] = $teachers;
$this->data['assistants'] = $assistants;
return view('manage.personal_rating.all', $this->data);
}
public function attendance()
{
$currentGen = Gen::getCurrentGen();
$classes = StudyClass::all();
$this->data['classes'] = $classes;
$this->data['current_gen'] = $currentGen;
$this->data['current_tab'] = 18;
return view('manage.attendance', $this->data);
}
