/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = MatchEvent::find();
$match = new Match();
$matchEventTable = MatchEvent::tableName();
$matchTable = Match::tableName();
$query->joinWith(['match' => function ($query) use($matchTable) {
$query->from(['match' => $matchTable]);
}]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 100]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(["{$matchEventTable}.id" => $this->id, 'match_id' => $this->match_id, 'match_event_type_id' => $this->match_event_type_id, 'composition_id' => $this->composition_id, 'minute' => $this->minute, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'substitution_id' => $this->substitution_id, 'additional_minute' => $this->additional_minute, 'is_hidden' => $this->is_hidden, 'position' => $this->position]);
$query->andFilterWhere(['like', "notes", $this->notes]);
return $dataProvider;
}
/**
* Vote for selected float answer
* @param $matchID int
* @return mixed Json
*/
public function actionAutogen($matchID)
{
$match = \common\models\Match::findOne($matchID);
if (!isset($match)) {
throw new NotFoundHttpException('Страница не найдена.');
}
if (in_array($match->teamHome->id, \common\models\Team::getTeamsConstants())) {
$ourTeam = $match->teamHome;
$opponentTeam = $match->teamGuest;
} else {
$ourTeam = $match->teamGuest;
$opponentTeam = $match->teamHome;
}
$basisPlayers = \common\models\Composition::find()->where(['match_id' => $match->id, 'command_id' => $ourTeam->id, 'is_basis' => 1])->all();
$compositionTable = \common\models\Composition::tableName();
$matchEventTable = \common\models\MatchEvent::tableName();
$substitutionPlayers = \common\models\Composition::find()->innerJoin($matchEventTable, "{$matchEventTable}.substitution_id = {$compositionTable}.id")->where([$compositionTable . '.match_id' => $match->id, 'command_id' => $ourTeam->id])->all();
$teamPlayers = array_merge($basisPlayers, $substitutionPlayers);
$question = new Question();
$question->title = 'Оценки игрокам ' . $ourTeam->name . ' в матче с ' . $opponentTeam->name;
$question->voutes = 0;
$question->is_active = 1;
$question->is_float = 1;
$question->is_multipart = 0;
$question->mark = 0;
if ($question->save()) {
foreach ($teamPlayers as $teamPlayer) {
$answer = new Question();
$answer->parent_id = $question->id;
$answer->title = $teamPlayer->name;
$answer->mark = 0;
$answer->save();
}
}
return $this->redirect(['view', 'id' => $question->id]);
}
