function postStudentModal(Request $request, Student $student) { $student->user->email = $request->get('email'); $student->user->save(); $student->programme = $request->get('programme'); $student->active = $request->get('active'); $student->group_id = $request->get('group_id') ?: null; $student->remark = $request->get('remark'); $student->save(); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(StudentRequest $request) { $data = $request->all(); $student = new Student(); $student->fromArray($data); $student->save(); flash()->success("ADDED"); session(['attribute' => \Lang::get('general.STUDENT')]); return redirect($this->main_page); }
/** * Process the workshop application * @param $workshop_id int * @param Request $request * @return \Illuminate\View\View */ public function processApply($workshop_id, Request $request) { $this->validate($request, ['name' => 'required', 'email' => 'required|email', 'address' => 'required', 'phone' => 'required', 'age' => 'required']); $page_workshop = Workshop::findOrNew($workshop_id); if ($this->student->isRegistered($request->get('name'), $request->get('email'), $workshop_id)) { $student_class = $this->student->getByEmail($request->get('email')); $student = isset($student_class->name) ? $student_class->name : ''; return $this->getView('lessonregistered', compact('page_workshop', 'student')); } Event::fire(new WorkshopEvent($request, $page_workshop)); $student_class = $this->student->getByEmail($request->get('email')); $student = isset($student_class->name) ? $student_class->name : ''; $this->title = 'Yogaground Apply complete'; return $this->getView('lessondone', compact('page_workshop', 'student')); }
/** * @param $name * @param $email * @param $request * @param $workshop */ private function saveUser($name, $email, $request, $workshop) { $user = new Student(); if (!Student::isStudent($name, $email)) { $user->fill($request); $user->status = 'C'; $user->profile = $this->getUserProfileString($request); $user->save(); } else { $user = $user->getByEmailAndName($name, $email); } if (!$user->isRegistered($name, $email, $workshop->id)) { $user->workshops()->attach($workshop->id, ['sign_date' => date('Y-m-d H:i:s')]); } }
/** * Run the database seeds. * * @return void */ public function run() { User::truncate(); Staff::truncate(); Student::truncate(); StudentNumber::truncate(); StaffNumber::truncate(); $user = ['first_name' => 'Jose Antonio', 'last_name' => 'Sinadinse', 'fullname' => '', 'password' => \Hash::make('password'), 'email' => '*****@*****.**', 'address' => 'Pretoria', 'cellnumber' => '000000000', 'user_type_id' => 1, 'state_id' => 1]; if (StaffNumber::all()->count() == 0) { $stfnum = StaffNumber::create(["number" => 2000, "date" => date("Y-m-d")]); } else { $lateststfnum = StaffNumber::all()->last(); $stfnum = StaffNumber::create(["number" => $lateststfnum->number + 1, "date" => date("Y-m-d")]); } $staff = Staff::create(['staff_number' => $stfnum->number]); $user = $staff->user()->create($user); $user->addPermission('admin'); for ($i = 3; $i < 20; $i++) { $user = ['first_name' => 'Name' . $i, 'last_name' => 'Surname' . $i, 'fullname' => '', 'password' => \Hash::make('aleluia'), 'email' => 'josebarros' . $i . '@hotmail.com', 'address' => 'Pretoria', 'cellnumber' => '00000000' . $i, 'user_type_id' => 3, 'state_id' => 1]; if (StudentNumber::all()->count() == 0) { $stdnum = StudentNumber::create(["number" => 200000000, "date" => date("Y-m-d")]); } else { $lateststdnum = StudentNumber::all()->last(); $stdnum = StudentNumber::create(["number" => $lateststdnum->number + 1, "date" => date("Y-m-d")]); } $student = Student::create(['student_number' => $stdnum->number, "university_id" => 1, "faculty_id" => '', "department_id" => '', "course_id" => '']); $user = $student->user()->create($user); $user->addPermission('student'); } }
/** * @param $id * @return \yii\web\Response * @throws NotFoundHttpException * @throws \yii\db\Exception */ public function actionPreregister($id) { $model = $this->findModel($id); $user = User::find()->where("id=" . Yii::$app->user->id)->one(); $user_id = $user->id; $student = Student::find()->where("user_id=" . $user_id)->one(); $student_id = $student->id; $vacancy = ProjectVacancy::find()->where("project_id=" . $id)->one(); $vacancyValue = $vacancy->vacancy; if ($existe = StudentProfile::find()->where(['project_id' => $id, 'degree_id' => $student->degree_id])->one()) { if (Registration::find()->where(['student_id' => $student_id])->one()) { Yii::$app->getSession()->setFlash('danger', 'Ya te has pre-registrado a un proyecto'); return $this->redirect(['view', 'id' => $model->id]); } else { if ($vacancyValue > 0) { $newRegistration = new Registration(); $newRegistration->project_id = $id; $newRegistration->student_id = $student_id; $newRegistration->student_status = "preregistered"; $newRegistration->save(); Yii::$app->db->createCommand()->update('project_vacancy', ['vacancy' => $vacancy->vacancy - 1], 'project_id=' . $id)->execute(); Yii::$app->getSession()->setFlash('success', 'Te has pre-registrado al proyecto'); return $this->redirect(['view', 'id' => $model->id]); } else { Yii::$app->getSession()->setFlash('danger', 'No hay cupo para este proyecto. Escoge otro.'); return $this->redirect(['view', 'id' => $model->id]); } } } else { Yii::$app->getSession()->setFlash('danger', 'No cuentas con el perfil solicitado'); return $this->redirect(['view', 'id' => $model->id]); } }
public function run() { DB::table('students')->delete(); Student::create(['student_id' => 'M21132111002', 'batch' => '25', 'department' => 'CSE', 'user_id' => '2']); Student::create(['student_id' => 'M21132111009', 'batch' => '27', 'department' => 'BBA', 'user_id' => '3']); Student::create(['student_id' => 'M21132111003', 'batch' => '26', 'department' => 'English', 'user_id' => '4']); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(StudentsRequest $request) { $user = ['first_name' => $request->input('first_name'), 'last_name' => $request->input('last_name'), 'fullname' => '', 'password' => '0000', 'email' => $request->input('email'), 'address' => $request->input('address'), 'cellnumber' => $request->input('cellnumber'), 'user_type_id' => $request->input('user_type_id'), 'state_id' => 1]; $student = Student::create(['student_number' => '00000']); $user = $student->user()->create($user); $user->makeEmployee('student'); return redirect("/students"); }
public function getHome() { // $students = Student::getStudents(); $students = Student::getStudentsCheckedIn(); $notices = Notice::getNotices(); // print_r($notices); return view('home', ["students" => $students], ["notices" => $notices]); }
public function actionView($id = null) { if (!$id) { return $this->render('/site/error', ['name' => 'Bad request', 'message' => 'id is not defined']); } $dataProvider = Student::find()->where(['id' => (int) $id]); return $this->render('view', ['dataProvider' => $dataProvider]); }
/** * Execute the console command. * * @return mixed */ public function fire() { foreach (Student::all() as $student) { $picture = file_get_contents('http://local-sig.utt.fr/Pub/trombi/individu/' . $student->student_id . '.jpg'); file_put_contents(public_path() . '/uploads/students-trombi/' . $student->student_id . '.jpg', $picture); } $this->info('Done!'); }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { $users_list = Student::lists("student_number", "id"); if (Auth::user()->isStudent()) { $users_list = [Auth::user()->id => Auth::user()->student->student_number]; } $companies_list = Company::lists("name", "id"); return view("pages.sos_requests.create", compact("users_list", "companies_list")); }
public function actionRegistration($role = '') { if (!\Yii::$app->user->isGuest) { $this->redirect(\Yii::$app->user->getReturnUrl()); } if ($role == '') { return $this->render('registration'); } $model = new User(); $role_model = new Company(); $model->role = User::ROLE_COMPANY; if ($role != 'company') { //Student registration $role = 'student'; $role_model = new Student(); $model->role = User::ROLE_STUDENT; } if ($model->load(Yii::$app->request->post()) && $role_model->load(Yii::$app->request->post()) && $model->register()) { if ($role == 'student') { $role_model->idUser = $model->id; if ($role_model->save()) { return $this->render('registration_student_success', ['model' => $model]); } } else { $role_model->idUser = $model->id; //Upload logo if (isset($_FILES['Company']) && $_FILES['Company']['name']['logo_path'] != "") { if (!in_array($_FILES['Company']['type']['logo_path'], $this->image_array)) { $role_model->addError('logo_path', 'Доступные расширения для файла: jpg, gif, png.'); } else { $rnd = rand(0, 9999); $uploadedFile = UploadedFile::getInstance($role_model, 'logo_path'); $fileName = 'files/' . $rnd . '_' . $uploadedFile->name; $role_model->logo_path = $fileName; $uploadedFile->saveAs($fileName); } } if ($role_model->save()) { return $this->render('registration_company_success', ['model' => $model]); } } } return $this->render('registration_' . $role, ['model' => $model, 'role_model' => $role_model]); }
public function deleteStudent() { $stud_id = Input::get('stud_id'); $User = Student::find($stud_id); if (!$User->delete()) { return 0; } else { return 1; } }
/** * */ private function generateStudents() { $levels = array(Student::LEVEL_A1, Student::LEVEL_A2, Student::LEVEL_B1, Student::LEVEL_B2, Student::LEVEL_C1, Student::LEVEL_C2); $oldestMktime = mktime(0, 0, 0, 0, 0, date('Y') - $this->getConfig('student_max_age')); $newestMktime = mktime(0, 0, 0, 0, 0, date('Y') - $this->getConfig('student_min_age')); $prepareItemData = function ($itemNum) use($oldestMktime, $newestMktime, $levels) { return ['Student Name ' . $itemNum, "test{$itemNum}@email.com", date('Y-m-d', rand($oldestMktime, $newestMktime)), $levels[rand(0, count($levels) - 1)]]; }; $this->loadByPortion($prepareItemData, Student::tableName(), ['name', 'email', 'birthday', 'level'], $this->getConfig('students_num')); }
public function actionFilter2() { $teachers = []; $students = []; $teachers = Teacher::findBySql("\n select t.name, t.id from (\n select st2.teacher_id st2, st3.teacher_id st3, count(st3.student_id) cnt from teacher_student st2\n left join teacher_student st3 on st3.student_id = st2.student_id and st2.teacher_id != st3.teacher_id\n where st3.teacher_id is not null group by st3.teacher_id, st2.teacher_id\n ) res \n left join teacher t on t.id=st2\n left join teacher t2 on t2.id=st3\n order by cnt DESC limit 2\n ")->all(); if (count($teachers) == 2) { $students = Student::findBySql("\n select * from teacher_student st\n left join student t on t.id = st.student_id \n left join teacher_student st2 on st2.teacher_id = :teacher1 and st2.student_id = st.student_id\n where st.teacher_id = :teacher2 and st2.teacher_id is not null\n ", [':teacher1' => $teachers[0]->id, ':teacher2' => $teachers[1]->id])->all(); } return $this->render('filter2', ['teachers' => $teachers, 'students' => $students]); }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { if (Session::has('student_id') === false) { return Redirect::route('oauth.auth'); } $student = Student::find(Session::get('student_id')); if ($student) { View::share('student', $student); } return $next($request); }
public function __construct() { $this->middleware('auth'); $user_types = UserType::lists("name", "id"); $states = State::lists("name", "id"); $users_count = User::with("state")->latest()->get()->count(); $universities_count = University::latest()->get()->count(); $sos_count = SosModel::latest()->get()->count(); $students_count = Student::latest()->get()->count(); $companies_count = Company::latest()->get()->count(); \View::share(compact("users_count", "universities_count", "sos_count", "states", "user_types", "students_count", "companies_count")); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = StudentModel::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'name' => $this->name]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Student::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'faculty_id' => $this->faculty_id, 'current_semester' => $this->current_semester]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Student::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'classid' => $this->classid, 'created_dt' => $this->created_dt]); $query->andFilterWhere(['like', 'course_id', $this->course_id])->andFilterWhere(['like', 'stucode', $this->stucode])->andFilterWhere(['like', 'fname', $this->fname])->andFilterWhere(['like', 'lname', $this->lname])->andFilterWhere(['like', 'faculity', $this->faculity])->andFilterWhere(['like', 'major', $this->major])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'score', $this->score])->andFilterWhere(['like', 'past', $this->past])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Student::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['st_id' => $this->st_id, 'st_active' => $this->st_active]); $query->andFilterWhere(['like', 'st_fname', $this->st_fname])->andFilterWhere(['like', 'st_lname', $this->st_lname])->andFilterWhere(['like', 'st_address', $this->st_address])->andFilterWhere(['like', 'st_postcode', $this->st_postcode])->andFilterWhere(['like', 'st_mobile', $this->st_mobile])->andFilterWhere(['like', 'st_phone', $this->st_phone])->andFilterWhere(['like', 'st_email', $this->st_email])->andFilterWhere(['like', 'st_disp_id', $this->st_disp_id]); return $dataProvider; }
public function actionProfile($params = []) { if (Student::isAuthorized()) { $student = new Student(); $student->loadModelFromDb(['email' => $_COOKIE['email']]); if (isset($_POST) && !empty($_POST)) { // TODO: validate user input // TODO: replace 'on' value in $_POST["local"] $student->fetchSchema(); foreach ($_POST as $key => $attribute) { if ($student->{$key} !== $attribute) { $student->modifiedAttributes[$key] = $attribute; } } if (!empty($student->modifiedAttributes)) { $student->update(); } } $this->render('profile.php', ['student' => $student]); } else { Router::error('403'); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Student::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'dob' => $this->dob]); $query->andFilterWhere(['like', 'studentNum', $this->studentNum])->andFilterWhere(['like', 'firstName', $this->firstName])->andFilterWhere(['like', 'surname', $this->surname])->andFilterWhere(['like', 'email', $this->email]); return $dataProvider; }
/** * Handle a registration request for the application. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function postRegister(Request $request) { $validator = $this->validator($request->all()); $post = $request->all(); $value = $post['regNo']; $determiner = Student::where('studentNo', $value)->pluck('studentNo'); $determiner1 = Management::where('id', $value)->pluck('id'); if ($validator->fails()) { $this->throwValidationException($request, $validator); } elseif ($determiner == null && $determiner1 == null) { return 'The registration number (' . $value . ') that you have entered does not exist in our database'; } Auth::login($this->create($request->all())); return redirect($this->redirectPath()); }
public function search($input) { $query = Student::query(); $columns = Schema::getColumnListing('students'); $attributes = array(); foreach ($columns as $attribute) { if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } else { $attributes[$attribute] = null; } } return [$query->get(), $attributes]; }
/** * Updates an existing StudentPhone model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $studentId = $model->student_id; $student = Student::findOne($studentId); if (!user()->can('updateStudent', ['student' => $student])) { setError('Access denied.'); return $this->redirect(['/student/view', 'id' => $studentId], 403); } if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', ['student' => $student, 'model' => $model]); } }
public function search($params) { $query = Student::find()->joinWith('affiliations.handAnchor.day')->joinWith('affiliations.handAnchor.frequency')->joinWith('affiliations.school')->joinWith('phones')->joinWith('division')->joinWith('promotions.rank')->groupBy('student.id')->where(['affiliation.school_id' => user()->schoolId]); $dataProvider = new ActiveDataProvider(['query' => $query]); // load the search form data and validate if (!($this->load($params) && $this->validate())) { return $dataProvider; } // we only get here if there are filter params in the GET //dump($params); //dump('active=', $this->active); // adjust the query by adding the filters $query->andFilterWhere(['dob' => $this->dob, 'spar_auth' => $this->spar_auth, 'grapple_auth' => $this->grapple_auth, 'belt_size' => $this->belt_size, 'gi_size' => $this->gi_size]); $query->andFilterWhere(['student.active' => $this->active])->andFilterWhere(['like', 'prefix', $this->prefix])->andFilterWhere(['like', 'gender', $this->gender])->andFilterWhere(['like', 'fname', $this->fname])->andFilterWhere(['like', 'mname', $this->mname])->andFilterWhere(['like', 'lname', $this->lname])->andFilterWhere(['like', 'kai_number', $this->kai_number])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'notes', $this->notes])->andFilterWhere(['like', 'day.name', $this['handAnchor.name']])->andFilterWhere(['like', 'student_phone.number', $this->bestPhoneNumber])->andFilterWhere(['like', 'division.name', $this->division_id]); return $dataProvider; }
public function postEdit($id) { $student = Student::get($id); $student->studentName = Request::input('studentName'); $student->studentRank = Request::input('studentRank'); $student->studentPhone = Request::input('studentPhone'); $student->email = Request::input('email'); $student->img1 = Request::input('img1'); $student->img2 = Request::input('img2'); $student->img3 = Request::input('img3'); $student->img4 = Request::input('img4'); $student->img5 = Request::input('img5'); $student->save(); // print_r($student); return redirect("/students"); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Student::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 100], 'sort' => ['defaultOrder' => ['name' => SORT_ASC]]]); $this->load($params); /* if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } */ $query->andFilterWhere(['id' => $this->id, 'birth_dt' => $this->birth_dt]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'level', $this->level]); return $dataProvider; }