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(); }