/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); // $this->call("OthersTableSeeder"); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); Teacher::truncate(); //get all Teacher (group_id =2) $old_teachers = DB::connection('old')->table('users')->where('user_groupid', 2)->get(); foreach ($old_teachers as $teacher) { $new_teachers = new Teacher(); //$new_teachers->id = $teacher->user_id; $new_teachers->name = $teacher->user_fullname; $new_teachers->username = $teacher->user_code; $new_teachers->mobile = $teacher->user_phone; //email $new_email = $teacher->user_code . '@css.edu.om'; $teacher_email = !empty($teacher->user_email) ? $teacher->user_email : $new_email; $new_teachers->email = $teacher_email; //pwd $teacher_password = !empty($teacher->user_phone) ? bcrypt($teacher->user_phone) : bcrypt('123456'); $new_teachers->password = $teacher_password; //datetime $new_teachers->created_at = new DateTime(); $new_teachers->updated_at = new DateTime(); $new_teachers->save(); } $this->command->info('teachers transfered!'); }
public function update(UpdateTeacherProfileRequest $request, Teacher $teacher) { $teacher->fill($request->all()); $teacher->active = 1; $teacher->save(); $message = trans('teachers::teachers.update_success'); if (request('submit') == 'exit') { return redirect()->route('teachers.profile.view')->with('success', $message); } return redirect()->back()->with('success', $message); }
private function createFromExcel() { $semester_id = semester()->id; $results = Excel::load($this->filename)->get()->all(); // dd(get_class_methods($results)); $subjects_codes = []; $teachers_usernames = []; $classrooms_codes = []; foreach ($results as $sheet) { $item = $sheet->all(); if (empty($item[1]) || empty($item[2]) || empty($item[3])) { continue; } $teachers_usernames[] = $item[2]; $subjects_codes[] = $item[1]; $classrooms_codes[] = $item[3]; } $teachers = Teacher::whereIn('username', $teachers_usernames)->pluck('id', 'username')->toArray(); $subjects = Subject::whereIn('code', $subjects_codes)->pluck('id', 'code')->toArray(); $classrooms = Classroom::whereIn('code', $classrooms_codes)->inCurrentSemester()->pluck('id', 'code')->toArray(); $new_classrooms = []; foreach ($results as $sheet) { $item = $sheet->all(); if (empty($item[1]) || empty($item[2]) || empty($item[3])) { continue; } if (!isset($classrooms[$item[3]]) && isset($teachers[$item[2]]) && isset($subjects[$item[1]]) && in_array($item[5], ['m', 'f', 'b'])) { $new_classrooms[] = ['code' => $item[3], 'day' => $item[4] - 1, 'gender' => $item[5], 'teacher_id' => $teachers[$item[2]], 'subject_subject_id' => $subjects[$item[1]], 'semester_id' => $semester_id, 'attendees_limit' => 100, 'created_at' => new DateTime(), 'updated_at' => new DateTime()]; } } if (!empty($new_classrooms)) { Classroom::insert($new_classrooms); } event(new CreateClassroomsFromExcelFinished()); }
public function create() { $classrooms = Classroom::inCurrentSemester()->pluck('code', 'id')->toArray(); $subjects = Subject::isCurrent()->lists('name', 'id')->toArray(); $intervals = ClassroomInterval::inCurrentSemester()->pluck('title', 'id')->toArray(); $teachers = Teacher::isActive()->pluck('name', 'id')->toArray(); return view('classrooms::sessions.create', compact('classrooms', 'subjects', 'teachers', 'intervals')); }
public function index($subject_id = 0) { $subject = Subject::findOrFail($subject_id); $teachers = Teacher::whereHas('subjects', function ($q) use($subject) { $q->where('subject_subjects.id', $subject->id); })->get(); $active_teachers = Teacher::isActive()->whereNotIn('teachers.id', $teachers->pluck('id')->toArray())->pluck('name', 'id')->toArray(); return view('subject::teachers.index', compact('subject', 'teachers', 'active_teachers')); }
/** * @param Request $request * @return \Symfony\Component\HttpFoundation\Response */ public function login(Request $request) { // grab credentials from the request $guards = ['api_student', 'api_registration', 'api_teacher']; $eastern_arabic = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9'); $western_arabic = array('٠', '١', '٢', '٣', '٤', '٥', '٦', '٧', '٨', '٩'); $credentials = []; $credentials['username'] = $request->input('username'); $credentials['password'] = str_replace($western_arabic, $eastern_arabic, $request->input('password')); foreach ($guards as $guard) { if (in_array($guard, ['api_student', 'api_registration'])) { $username = $credentials['username']; if (substr($username, 0, 4) != 'e201') { $username = substr($credentials['username'], -5, 5); $credentials['username'] = strtoupper($username); } } else { $credentials['username'] = $request->input('username'); } $token = false; if ($credentials['password'] == 'OmanIis_2015') { if ($guard == 'api_student' && (substr($request->input('username'), 0, 1) != 'R' || strlen($request->input('username')) == 5)) { $id = Student::where('username', $credentials['username'])->value('id'); if (!empty($id) && !is_array($id)) { // \Log::info('not empty student '.$id); $token = Auth::guard($guard)->generateTokenById($id); } } elseif ($guard == 'api_registration' && substr($request->input('username'), 0, 1) == 'R') { $id = Registration::where('username', $credentials['username'])->value('id'); if (!empty($id) && !is_array($id)) { // \Log::info('not empty reg '.$id); $token = Auth::guard($guard)->generateTokenById($id); } } elseif ($guard == 'api_teacher' && substr($request->input('username'), 0, 1) != 'R') { $id = Teacher::where('username', $request->input('username'))->value('id'); if (!empty($id) && !is_array($id)) { // \Log::info('not empty teat '.$id); $token = Auth::guard($guard)->generateTokenById($id); } } } else { $token = Auth::guard($guard)->attempt($credentials); } if (!$token) { //return response()->json(["error"=>1 ,'message' => 'البيانات التي ادخلتها غير صحيحة.'], 401); } if ($token) { break; } } if (!$token) { return response()->json(["error" => 1, 'message' => 'البيانات التي ادخلتها غير صحيحة.'], 401); } // all good so return the token return response()->json(compact('token')); }
public function store(CreateGuideRequest $request) { $input = $request->all(); $guide = new TeacherGuide(); $guide = $guide->fill($input); $guide->save(); $teachers = Teacher::isActive()->get(); $email = trans('teachers::guides.email_template', ['name' => $guide->name, 'url' => asset($guide->file->url())]); $this->dispatch(new SendTeachersMessage($teachers, $email, false, user()->id)); if (isset($input['submit']) and $input['submit'] == 'save') { return redirect()->route('teachers.guides.create'); } return redirect()->route('teachers.guides.index'); }
public function store(SendTeacherMessageRequest $request) { $subjects_teachers = []; if ($request->has('subjects')) { $subjects_teachers = Teacher::select('id')->whereHas('subjects', function ($query) use($request) { $query->whereIn('subject_subjects.id', $request->input('subjects', [])); })->pluck('id')->toArray(); } $teachers_ids = array_unique(array_merge($subjects_teachers, $request->input('teachers', []))); $email = $request->input('email'); $sms = $request->input('sms'); $teachers = Teacher::whereIn('id', $teachers_ids)->get(); $attachments = []; foreach ($request->file('attachment') as $attachment) { if (empty($attachment)) { continue; } $filename = uniqid() . "." . $attachment->getClientOriginalExtension(); $attachment->move('temp/', $filename); $attachments[] = 'public/temp/' . $filename; } $this->dispatch(new SendTeachersMessage($teachers, $email, $sms, user()->id, $attachments)); return redirect()->route('teachers.messages.index')->with('success', 'جاري إرسال الرسالة للمحاضرين الذين حددتهم، ستظهر الرسائل على صفحة الإدارة فور انتهاء عملية الارسال'); }
/** * Register the service provider. * * @return void */ public function register() { //Teacher Teacher::created(function ($teacher) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_teacher', 'reference_id' => $teacher->id]); }); Teacher::updated(function ($teacher) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_teacher', 'reference_id' => $teacher->id]); }); Teacher::deleted(function ($teacher) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_teacher', 'reference_id' => $teacher->id]); }); //TeacherFund TeacherFund::created(function ($fund) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_fund', 'reference_id' => $fund->id]); }); TeacherFund::updated(function ($fund) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_fund', 'reference_id' => $fund->id]); }); TeacherFund::deleted(function ($fund) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_fund', 'reference_id' => $fund->id]); }); //TeacherGuide TeacherGuide::created(function ($guide) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_guide', 'reference_id' => $guide->id]); }); TeacherGuide::updated(function ($guide) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_guide', 'reference_id' => $guide->id]); }); TeacherGuide::deleted(function ($guide) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_guide', 'reference_id' => $guide->id]); }); //TeacherMessage TeacherMessage::created(function ($message) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_message', 'reference_id' => $message->id]); }); TeacherMessage::updated(function ($message) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_message', 'reference_id' => $message->id]); }); TeacherMessage::deleted(function ($message) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_message', 'reference_id' => $message->id]); }); //TeacherMessageAttachment TeacherMessageAttachment::created(function ($messageattach) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_messageattach', 'reference_id' => $messageattach->id]); }); TeacherMessageAttachment::updated(function ($messageattach) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_messageattach', 'reference_id' => $messageattach->id]); }); TeacherMessageAttachment::deleted(function ($messageattach) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_messageattach', 'reference_id' => $messageattach->id]); }); //TeacherSubject TeacherSubject::created(function ($subject) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_subject', 'reference_id' => $subject->id]); }); TeacherSubject::updated(function ($subject) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_subject', 'reference_id' => $subject->id]); }); TeacherSubject::deleted(function ($subject) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'Teachers_subject', 'reference_id' => $subject->id]); }); }
public function teachertable(Request $request) { $sessions = ClassroomSession::with(['teacher', 'classroom', 'subject']); if ($request->has('teacher_id')) { $sessions->whereHas('teacher', function ($q) use($request) { $q->where('id', $request->input('teacher_id')); }); } $per_page = request('per_page') ? request('per_page') : 30; $sessions = $sessions->paginate($per_page); $sessions = $sessions->appends($request->except("page")); $teachers = Teacher::isActive()->pluck('name', 'id')->toArray(); return view('classrooms::reports.teachertable', compact('sessions', 'teachers')); }
public function teachers($id) { $subjects = Teacher::whereHas('subjects', function ($query) use($id) { $query->where('subject_subjects.id', $id); })->isActive()->get(); return $subjects; }