public function confirm_change_class(Request $request) { $registerId = $request->registerId; $classId = $request->classId; $register = Register::find($registerId); $oldClass = $register->studyClass; $class_lession_ids = $oldClass->classLessons->pluck('id'); $attendances = $register->attendances()->whereIn('class_lesson_id', $class_lession_ids)->get(); $register->class_id = $classId; $register->save(); $newClass = StudyClass::find($classId); $new_class_lession_ids = $newClass->classLessons->pluck('id'); $index = 0; foreach ($attendances as $attendance) { $attendance->class_lesson_id = $new_class_lession_ids[$index]; $attendance->save(); $index += 1; } $data['newClass'] = $newClass; $data['oldClass'] = $oldClass; $user = $register->user; $data['user'] = $user; $subject = "Xác nhận đã đổi thành công từ lớp {$oldClass->name} sang lớp {$newClass->name}"; $emailcc = ['*****@*****.**']; Mail::queue('emails.confirm_change_class', $data, function ($m) use($user, $subject, $emailcc) { $m->from('*****@*****.**', 'Color Me'); $m->to($user['email'], $user['name'])->bcc($emailcc)->subject($subject); }); $request->session()->flash('change_class_message', 'Bạn đã đổi thành công sang lớp ' . $newClass->name); return redirect('manage/registerlist'); }
public function all_rating(Request $request) { $class_id = $request->id; $role = $request->role; $class = StudyClass::find($class_id); $this->data['class'] = $class; $this->data['role'] = $role; return view('manage.personal_rating.all_rating', $this->data); }
public function studyClass($classId) { if ($classId) { $class = StudyClass::find($classId); if ($class) { return $this->respond($this->classTransformer->transform($class)); } else { return $this->responseNotFound("classId not found!"); } } else { return $this->responseBadRequest("no classId provide"); } }
public function students($classId) { $class = StudyClass::find($classId); $registers = $class->registers; $students = array(); foreach ($registers as $register) { $student = $register->user; $student->status = $register->status; $students[] = $student; } $this->data['class'] = $class; $this->data['students'] = $students; return view('manage.class.students', $this->data); }
function send_mail_confirm_registration($user, $class_id, $emailcc) { $class = \App\StudyClass::find($class_id); $course = \App\Course::find($class->course_id); $data['class'] = $class; $data['course'] = $course; $data['user'] = $user; $subject = "Xác nhận đăng kí khoá học " . $course->name; Mail::queue('emails.confirm_email_2', $data, function ($m) use($user, $subject, $emailcc) { $m->from('*****@*****.**', 'Color Me'); $m->to($user['email'], $user['name'])->bcc($emailcc)->subject($subject); }); }
public function ajax_send_rating(Request $request) { $class = StudyClass::find($request->class_id); $class->rating_sended = 1; $class->save(); foreach ($class->registers as $register) { $register->rated = 2; $register->save(); } return ' <i class=" teal-text material-icons">done</i>'; }
public function class_products($class_id) { $class = StudyClass::find($class_id); $this->data['products'] = $class->registers()->whereExists(function ($query) use($class_id) { $query->select(DB::raw(1))->from('registers')->whereRaw('registers.user_id = users.id and registers.class_id=' . $class_id); }); }
public function news_feed_load_more(Request $request) { $limit = 15; $page = $request->page; $class_name = $request->class_name; $category_id = $request->category_id; if ($class_name != null) { $class = DB::select("select * from classes where replace(name,' ','') like ?", [$class_name])[0]; $usersIdOfThisClass = StudyClass::find($class->id)->registers()->select(DB::raw('user_id'))->get()->pluck('user_id'); $products = Product::whereIn('author_id', $usersIdOfThisClass)->orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } else { if ($category_id != null) { $category = CategoryProduct::find($category_id); $products = $category->products()->orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } else { $type = $request->type; if ($type == 3) { $products = Product::orderBy('created_at', 'desc')->where('type', '=', 2)->skip($page * $limit)->take($limit)->get(); } else { if ($type == 2) { $products = Product::orderBy('rating', 'desc')->skip($page * $limit)->take($limit)->get(); } else { // $class = DB::select("select * from classes where replace(name,' ','') like ?", [$class_name])[0]; // $usersIdOfThisClass = StudyClass::find($class->id)->registers()->select(DB::raw('user_id'))->get()->pluck('user_id'); // $products = Product::whereIn('author_id', $usersIdOfThisClass)->orderBy('created_at', 'desc')->take($limit)->get(); $products = Product::orderBy('created_at', 'desc')->skip($page * $limit)->take($limit)->get(); } } } } $data['user'] = $this->user; $data['products'] = $products; return view('ajax.newsfeed_load_more', $data); }
public function activate_class(Request $request) { $class_id = $request->class_id; $class = StudyClass::find($class_id); foreach ($class->registers as $regis) { send_mail_activate_class($regis, ['*****@*****.**']); } $class->activated = 1; $class->status = 0; $class->save(); return "<strong class=\"cyan-text\">Đã kích hoạt</strong>"; }
public function students($classId) { if ($classId) { $class = StudyClass::find($classId); $registers = $this->registerToStudentTransformer->transformCollection($class->registers()->where('status', 1)->get()); if ($class) { return response()->json($registers, 200); } else { return response()->json(['error' => "classId not found!"], 404); } } else { return response()->json(['error' => "no classId provide"], 400); } }