public function scopeGetTotalCalled($scope)
{
$current_gen = Gen::getCurrentGen();
$classes = StudyClass::where('gen_id', $current_gen->id)->get();
$class_id_list = $classes->pluck('id')->all();
$count = Register::whereIn('class_id', $class_id_list)->select('user_id')->where('call_status', 1)->groupBy('user_id')->get()->count();
return $count;
}
public function classes($domain, $gen_id, $baseId, $couseId)
{
$base = Base::find($baseId);
$course = Course::find($couseId);
if (!$base) {
return response()->json(['error' => "Cơ sở không tồn tại"], 404);
}
if (!$course) {
return response()->json(['error' => "Môn học không tồn tại"], 404);
}
$classes = StudyClass::where('course_id', $couseId)->where('base_id', $baseId)->where('gen_id', $gen_id)->get();
return response()->json(['course' => ['name' => $course->name, 'avatar_url' => $course->icon_url], 'classes' => $classes]);
}
public function scopeGetClassByGen($scope, $gen_id)
{
$where_clause = ['gen_id' => $gen_id];
return StudyClass::where($where_clause)->orderBy('name', 'desc')->get();
}
