public function up() { $this->addColumn('{{%users_tournaments}}', 'points', $this->integer()->defaultValue(NULL)); $tournaments = UsersTournaments::find()->all(); foreach ($tournaments as $one) { $games = ArrayHelper::getColumn(Result::find()->select('id_game')->where(['id_tournament' => $one->id_tournament])->all(), 'id_game'); $points = Forecasts::find()->select(['sum(points) as points'])->joinWith('idUser')->where(['in', 'id_game', $games])->andWhere(['id_user' => $one->id_user])->scalar(); $one->points = $points; $one->save(false); } }
/** * Updates an existing tournaments model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { Yii::$app->user->returnUrl = Yii::$app->request->url; $model = $this->findModel($id); //getting standings with participants $participants = new ArrayDataProvider(['allModels' => Result::getStandings($id), 'pagination' => false]); //all teams(potential participants) for the current tournament $teams = Teams::getTeamCandidates($model->country0, TeamTournaments::getTournamentParticipantsID($id)); $forecasters = new ArrayDataProvider(['allModels' => $model->getForecastersListNew()]); //getting the next tour number $nextTour = Tournaments::getNextTour($id); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->goBack(); } else { return $this->render('update', compact('nextTour', 'model', 'teams', 'participants', 'forecasters')); } }
private static function sendReminder($tour, $tournament, $users) { $subject = "Напоминание: сделайте прогноз на матчи {$tour} тура турнира " . Tournaments::findOne($tournament)->tournament_name; $firstGameStarts = date('d-m-Y в H:i', ArrayHelper::getValue(Result::find()->select(['min(dtime) as dtime'])->where(['id_tournament' => $tournament, 'tour' => $tour])->all()[0], 'dtime')); $tours = Games::getNumberOfGamesPerTour($tournament); foreach ($users as $user) { if (Forecasts::getUserForecastTour($user->id, $tournament, $tours)[$tour] == 0) { $description = "Вы не сделали прогноз на матчи {$tour} тура турнира " . Tournaments::findOne($tournament)->tournament_name . ". Поторопитесь, первая игра тура начинается <strong>{$firstGameStarts}</strong>"; } else { $description = "Вы сделали прогноз не на все матчи: {$tour} тура турнира " . Tournaments::findOne($tournament)->tournament_name . ". Поторопитесь, первая игра тура начинается {$firstGameStarts}"; } $content = new ArrayDataProvider(['allModels' => Forecasts::getTourUserForecastStatus($tour, $tournament, $user->id), 'sort' => false, 'pagination' => false]); $messages[] = Yii::$app->mailer->compose('reminder', ['content' => $content, 'description' => $description, 'user' => $user])->setFrom([Yii::$app->params['adminEmail'] => 'Sportforecast'])->setTo($user->email)->setSubject($subject); //adding a record to the DB $reminder = self::getReminder($user->id, $tournament, $tour); $reminder->save(); } if (!empty($messages)) { Yii::$app->mailer->sendMultiple($messages); } return true; }
public static function getNumberOfGamesPerTour($tournament) { $games = ArrayHelper::getColumn(Result::find()->select('id_game')->where(['id_tournament' => $tournament])->all(), 'id_game'); $tours = (new Query())->select('tour')->from('sf_games')->where(['in', 'id_game', $games])->all(); if ($tours) { $tours = ArrayHelper::getColumn($tours, 'tour'); $tours = array_count_values($tours); ksort($tours); } return $tours; }
public static function setEventForTournament($id_tournament) { $winners = array_keys(ArrayHelper::index(Result::getWinners($id_tournament), 'participant')); foreach ($winners as $position => $team) { self::updateAll(['event' => self::TEAM_IN_TOP_3], ['and', ['id_participant_team' => $team], ['id_tournament' => $id_tournament], ['not', ['forecasted_position' => $position + 1]]]); self::updateAll(['event' => self::TEAM_POSITION], ['and', ['id_participant_team' => $team], ['id_tournament' => $id_tournament], ['forecasted_position' => $position + 1]]); self::updateAll(['event' => NULL], ['and', ['id_tournament' => $id_tournament], ['not in', 'id_participant_team', $winners]]); } }
public static function getForecastResultUserTourTournament($user, $tour, $tournament) { $games = Result::getGamesTourTournament($tour, $tournament); $forecasts = self::find()->where(['and', "id_user = {$user}", ['in', 'sf_forecasts.id_game', ArrayHelper::getColumn($games, 'id_game')]])->asArray()->all(); $forecasts = ArrayHelper::index($forecasts, 'id_game'); $games = ArrayHelper::toArray($games); foreach ($games as &$one) { if (array_key_exists($one['id_game'], $forecasts)) { $one['fscore_home'] = $forecasts[$one['id_game']]['fscore_home']; $one['fscore_guest'] = $forecasts[$one['id_game']]['fscore_guest']; $one['fpoints'] = $forecasts[$one['id_game']]['points']; $one['status'] = true; } else { $one['fscore_home'] = '-'; $one['fscore_guest'] = '-'; $one['fpoints'] = '-'; $one['status'] = false; } } ArrayHelper::multisort($games, 'dtime'); return $games; }
public function actionGames($id) { $games = new ArrayDataProvider(['allModels' => Result::getParticipantGames($id), 'pagination' => false]); $tournament = TeamTournaments::findOne($id); $team = TeamTournaments::findOne($id); return $this->render('gamesGuest', compact('games', 'tournament', 'team')); }
public static function generateFinalNews($tournament) { $trn = self::findOne($tournament); $forecasters = new ArrayDataProvider(['allModels' => UsersTournaments::topThreeForecastersForTournament($tournament)]); $standings = new ArrayDataProvider(['allModels' => Result::getStandings($tournament)]); return Yii::$app->controller->renderPartial('@app/mail/_tournamentFinishedNews', ['trn' => $trn, 'forecasters' => $forecasters, 'standings' => $standings]); }
public function afterSave($insert, $changedAttributes) { parent::afterSave($insert, $changedAttributes); //getting the tournament number $tournament = ArrayHelper::getValue(Result::find()->where(['id_game' => $this->id_game])->one(), 'id_tournament'); //updating the forecast points for the game if (!$insert) { Forecasts::setForecastPoints($this->id_game, $this->score_home, $this->score_guest, $tournament); } //if tour finished, need to send notifications (if not already sent) and put tournament as finished if it was last tour /** * @var $tournamentModel \app\models\tournaments\Tournaments */ if (self::isTourFinished($tournament, $this->tour)) { $tournamentModel = Tournaments::findOne($tournament); if ($tournamentModel->num_tours == $this->tour) { $tournamentModel->is_active = Tournaments::FINISHED; $tournamentModel->save(false); } if (!TourResultNotifications::ifExists($this->tour, $tournament)) { self::sendTourResults($this->tour, $tournament); $notification = new TourResultNotifications(); $notification->tour = $this->tour; $notification->tournament = $tournament; $notification->save(); } } }
public function actionAutoreminder() { $tournaments = Tournaments::find()->where(['not', ['is_active' => Tournaments::FINISHED]])->all(); foreach ($tournaments as &$tournament) { if ($tournament->is_active == Tournaments::NOT_STARTED && $tournament->startsOn - time() < 60 * 60 * 24 * 5) { $tournament->is_active = Tournaments::GOING; $tournament->save(false); } $nextTour = Tournaments::getNextTour($tournament->id_tournament); if ($nextTour != NULL) { $firstGameStarts = ArrayHelper::getValue(Result::find()->select(['min(dtime) as dtime'])->where(['id_tournament' => $tournament->id_tournament, 'tour' => $nextTour])->all()[0], 'dtime'); if ($firstGameStarts > time() + 60 * 60 * 24 * 4 && $firstGameStarts < time() + 60 * 60 * 24 * 5 || $firstGameStarts > time() + 60 * 60 * 24 * 2 && $firstGameStarts < time() + 60 * 60 * 24 * 3) { $sendReminders = Reminders::sendAutoReminder($nextTour, $tournament->id_tournament); Yii::info("Task Autoreminder for {$tournament->tournament_name} {$nextTour} tour has been executed", 'console'); } } } return 0; }
public function deleteForecasts() { $games = ArrayHelper::getColumn(Result::find()->where(['id_tournament' => $this->id_tournament])->all(), 'id_game'); return Forecasts::deleteAll(['and', ['in', 'id_game', $games], ['id_user' => $this->id_user]]); }