/**
* 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'));
}
