/** * Display the specified resource. * * @param int $trainingId * @param int $id * @return Exam */ public function show($trainingId, $id) { /** @var Training $training */ $training = Training::findOrFail($trainingId); /** @var Exam $exam */ $exam = $training->exams()->with('attendees')->findOrFail($id); return $exam; }
/** * Finds the Training model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Training the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Training::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return array */ private function getSchulungen() { $schulungen = Training::all(); $menuItems = []; foreach ($schulungen as $schulung) { $menuItems[] = ['type' => 'link', 'url' => route('backend.trainings.show', ['id' => $schulung->id]), 'label' => $schulung->name, 'active' => false]; } return $menuItems; }
/** * Show the application dashboard to the user. * * @return Response */ public function index() { $images = Gallery::slide(); $news = News::latest(4); $pubs = Publication::latest(); $trainings = Training::latest(); $bio = Biography::orderBy('created_at', 'DESC')->first(); return view('index', compact('images', 'news', 'pubs', 'bio', 'trainings')); }
public function edit(Training $training) { $team = Team::find(config('mls.team_id')); $playerList = PlayerRepository::getListByTeamId($team->id); $dayList = Training::getDayOfWeekList(); $visitList = TrainingVisitRepository::getTrainingVisits($training->id); $visitList = $visitList->lists('visit', 'player_id'); return view('frontend.trainings.edit')->with('training', $training)->with('team', $team)->with('playerList', $playerList)->with('dayList', $dayList)->with('visitList', $visitList)->with('statusVisited', Stat::GAME_VISITED)->with('statusNotVisited', Stat::GAME_NOT_VISITED); }
/** * Remove the specified resource from storage. * * @param int $trainingId * @param int $examId * @param int $id * @return array */ public function destroy($trainingId, $examId, $id) { /** @var Training $training */ $training = Training::findOrFail($trainingId); /** @var Exam $exam */ $exam = $training->exams()->findOrFail($examId); /** @var Attendee $attendee */ $attendee = $exam->attendees()->findOrFail($id); return ['success' => $attendee->delete()]; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $this->addParam('categoryId', $params); $query = Training::find()->from(['t' => self::tableName()])->joinWith('category'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['attributes' => ['name', 'calories', 'categoryName' => ['asc' => ['c.name' => SORT_ASC], 'desc' => ['c.name' => SORT_DESC]]], 'defaultOrder' => ['name' => SORT_ASC]]]); $this->load($params); if (!$this->validate()) { return $dataProvider; } $query->andFilterWhere(['t.id' => $this->id, 't.calories' => $this->calories, 't.category_id' => $this->categoryId]); $query->andFilterWhere(['like', 't.name', $this->name])->andFilterWhere(['like', 't.description', $this->description])->andFilterWhere(['like', 'c.name', $this->categoryName]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $countQuery = Training::find()->select('COUNT(*)')->where('`category_id` = `c`.`id`')->createCommand()->sql; $query = TrainingCategory::find()->from(['c' => self::tableName()])->select(['c.*', 'trainingsCount' => "({$countQuery})"]); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['attributes' => ['name', 'trainingsCount'], 'defaultOrder' => ['name' => SORT_ASC]]]); $this->load($params); if (!$this->validate()) { return $dataProvider; } $query->andFilterWhere([]); $query->andFilterWhere(['like', 'c.name', $this->name]); return $dataProvider; }
/** * Execute the console command. * * @return mixed */ public function handle() { $this->info('Script start'); $daytime = Carbon::now(); $trainingList = Training::where('day_of_week', $daytime->dayOfWeek)->where('time', '<', $daytime->format('H:i:s'))->get(); if ($trainingList->count() < 1) { $this->error('No trainings to reset'); exit; } foreach ($trainingList as $training) { TrainingVisitRepository::clearVisists($training->id); } $this->info('Script end'); }
public function changeTraining(Request $request) { $rules = array('promotion' => 'required', 'select-students' => 'required'); $validator = \Validator::make(\Input::all(), $rules); if ($validator->fails()) { return redirect()->back()->withErrors($validator); } $t = Training::find($request->input('promotion')); foreach ($request->input('select-students') as $sid) { $s = User::find($sid); $s->trainings()->detach(); $s->trainings()->save($t); } return redirect()->back(); }
public static function saveQuickVisits($request) { if (!Training::find($request->get('training_id'))) { return; } self::removeVisits($request->get('training_id')); foreach ($request->all() as $key => $input) { if (strpos($key, 'player_') !== false && $input > 0) { $id = str_replace('player_', '', $key); if (Player::find($id)) { self::addVisit($request->get('training_id'), $id, $input); } } } }
/** * Handle the event. * * @param TrainingVisitChange $event * @return void */ public function handle(TrainingVisitChange $event) { $player = Player::find($event->playerId); $training = Training::find($event->trainingId); $users = \App\Models\User::whereNotNull('email')->where('email', '!=', '')->get(); $status = $event->visit; $visitList = TrainingVisit::getVisitList(); $subject = trans('email.training.subject') . ' ' . str_limit($player->name, 10) . ' ' . str_limit($training->name, 10) . ' ' . $visitList[$status]; Mail::send('emails.training_visit', ['player' => $player, 'training' => $training, 'status' => $status], function ($m) use($users, $subject) { foreach ($users as $user) { if ($user->isAdmin()) { $m->to($user->email); } } $m->subject($subject); }); }
/** * Execute the console command. * * @return mixed */ public function handle() { $this->startLog(); $dayOfWeek = Carbon::now()->addDays(self::PERIOD)->dayOfWeek; $trainingList = Training::where('day_of_week', $dayOfWeek)->where('status', Training::STATUS_ACITVE)->get(); if ($trainingList->count() < 1) { $this->error('No games to remind'); exit; } foreach ($trainingList as $training) { $msg = config('mls.chat_training_msg'); $msg = str_replace('%training%', $training->name, $msg); $msg = str_replace('%time%', $training->getTime(), $msg); $msg = str_replace('%url%', route('training.visit', ['id' => $training->id]), $msg); $result = sendVkMsg($msg); $this->comment($result); } $this->endLog(); }
public static function search($term) { $count = 0; $l = Session::get('locale'); $fields = "title_{$l},' ',content_{$l},' ',summary_{$l}"; $results['results']['news'] = News::select(DB::raw("*,concat('news/',slug) as link"))->where(DB::raw("concat({$fields})"), 'like', "%{$term}%")->get(); $count += count($results['results']['news']); $fields = "title_{$l},' ',content_{$l},' ',summary_{$l}"; $results['results']['pages'] = Page::select(DB::raw("*,concat('pages/',slug) as link"))->where(DB::raw("concat({$fields})"), 'like', "%{$term}%")->get(); $count += count($results['results']['pages']); $fields = "title_{$l}"; $results['results']['publications'] = Publication::select(DB::raw("*,file_{$l} as link"))->where(DB::raw("concat({$fields})"), 'like', "%{$term}%")->get(); $count += count($results['results']['publications']); $fields = "title_{$l},' ',content_{$l},' ',summary_{$l}"; $results['results']['trainings'] = Training::select(DB::raw("*,concat('trainings/',slug) as link"))->where(DB::raw("concat({$fields})"), 'like', "%{$term}%")->get(); $count += count($results['results']['trainings']); $fields = "title_{$l},' ',content_{$l},' ',summary_{$l}"; $results['results']['vacancies'] = Vacancy::select(DB::raw("*,concat('vacancies/',slug) as link"))->where(DB::raw("concat({$fields})"), 'like', "%{$term}%")->get(); $count += count($results['results']['vacancies']); $results['count'] = $count; return $results; }
public static function latest($n = 3) { return Training::orderBy('created_at', 'DESC')->limit($n)->get(); }
/** * Remove the specified resource from storage. * * @param int $trainingId * @param int $id * @return array */ public function destroy($trainingId, $id) { /** @var Training $training */ $training = Training::findOrFail($trainingId); /** @var Question $question */ $question = $training->questions()->findOrFail($id); return ['success' => $question->delete()]; }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function publish($slug) { $training = Training::findBySlug($slug); $training->update(['is_published' => $training->is_published ? 0 : 1]); return Redirect::route('trainings.admin'); }
public static function getActiveList($team_id) { return Training::where('team_id', $team_id)->where('status', Training::STATUS_ACITVE)->get(); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { Training::destroy($id); return \Redirect::back(); }
public function index() { return view('calendar', ['trainings' => \Auth::user()->isAdmin() ? Training::all() : \Auth::user()->trainings]); }
public function index() { $trainingList = Training::all(); return view('backend.training_visits.list')->with('trainingList', $trainingList); }
/** * Remove the specified resource from storage. * * @param int $id * @return array */ public function destroy($id) { /** @var Training $training */ $training = Training::findOrFail($id); return ['success' => $training->delete()]; }
/** * @return \yii\db\ActiveQuery */ public function getTrainings() { return $this->hasMany(Training::className(), ['category_id' => 'id'])->from(['t' => Training::tableName()]); }
public function destroy(Training $training) { $training->delete(); Flash::success(trans('general.delete_msg')); return redirect(route('admin.trainings')); }