/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Stadium::find();
$country = new Country();
$stadiumTable = Stadium::tableName();
$countryTable = Country::tableName();
$query->joinWith(['country' => function ($query) use($countryTable) {
$query->from(['country' => $countryTable]);
}]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
// enable sorting for the related columns
$addSortAttributes = ["country.name"];
foreach ($addSortAttributes as $addSortAttribute) {
$dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]];
}
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(["{$stadiumTable}.id" => $this->id, 'spectators' => $this->spectators]);
$query->andFilterWhere(['like', "{$stadiumTable}.name", $this->name])->andFilterWhere(['like', 'country.name', $this->getAttribute('country.name')]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getStadium()
{
return $this->hasOne(Stadium::className(), ['id' => 'stadium_id']);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Match::find();
$championship = new Championship();
$teamHome = new Team();
$stadium = new Stadium();
$arbiter = new Arbiter();
$championshipPart = new ChampionshipPart();
$matchTable = Match::tableName();
$championshipTable = Championship::tableName();
$championshipPartTable = ChampionshipPart::tableName();
$teamTable = Team::tableName();
$stadiumTable = Stadium::tableName();
$arbiterTable = Arbiter::tableName();
$query->joinWith(['championship' => function ($query) use($championshipTable) {
$query->from(['championship' => $championshipTable]);
}]);
$query->joinWith(['teamHome' => function ($query) use($teamTable) {
$query->from(['teamHome' => $teamTable]);
}]);
$query->joinWith(['teamGuest' => function ($query) use($teamTable) {
$query->from(['teamGuest' => $teamTable]);
}]);
$query->joinWith(['arbiterMain' => function ($query) use($arbiterTable) {
$query->from(['arbiterMain' => $arbiterTable]);
}]);
$query->joinWith(['arbiterAssistant1' => function ($query) use($arbiterTable) {
$query->from(['arbiterAssistant1' => $arbiterTable]);
}]);
$query->joinWith(['arbiterAssistant2' => function ($query) use($arbiterTable) {
$query->from(['arbiterAssistant2' => $arbiterTable]);
}]);
$query->joinWith(['arbiterAssistant3' => function ($query) use($arbiterTable) {
$query->from(['arbiterAssistant3' => $arbiterTable]);
}]);
$query->joinWith(['arbiterAssistant4' => function ($query) use($arbiterTable) {
$query->from(['arbiterAssistant4' => $arbiterTable]);
}]);
$query->joinWith(['arbiterReserve' => function ($query) use($arbiterTable) {
$query->from(['arbiterReserve' => $arbiterTable]);
}]);
$query->joinWith(['championshipPart' => function ($query) use($championshipPartTable) {
$query->from(['championshipPart' => $championshipPartTable]);
}]);
$query->joinWith(['stadium' => function ($query) use($stadiumTable) {
$query->from(['stadium' => $stadiumTable]);
}]);
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['date' => SORT_DESC]]]);
// enable sorting for the related columns
$addSortAttributes = ["championship.name", "teamHome.name", "teamGuest.name", "arbiterMain.name", "arbiterAssistant1.name", "arbiterAssistant2.name", "arbiterAssistant3.name", "arbiterAssistant4.name", "arbiterReserve.name", "championshipPart.name", "stadium.name"];
foreach ($addSortAttributes as $addSortAttribute) {
$dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]];
}
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(["{$matchTable}.id" => $this->id, 'is_visible' => $this->is_visible, 'home_shots' => $this->home_shots, 'guest_shots' => $this->guest_shots, 'home_shots_in' => $this->home_shots_in, 'guest_shots_in' => $this->guest_shots_in, 'home_offsides' => $this->home_offsides, 'guest_offsides' => $this->guest_offsides, 'home_corners' => $this->home_corners, 'guest_corners' => $this->guest_corners, 'home_fouls' => $this->home_fouls, 'guest_fouls' => $this->guest_fouls, 'home_yellow_cards' => $this->home_yellow_cards, 'guest_yellow_cards' => $this->guest_yellow_cards, 'home_red_cards' => $this->home_red_cards, 'guest_red_cards' => $this->guest_red_cards, 'home_goals' => $this->home_goals, 'guest_goals' => $this->guest_goals, 'is_finished' => $this->is_finished, "{$matchTable}.championship_id" => $this->championship_id, "{$matchTable}.season_id" => $this->season_id, "{$matchTable}.league_id" => $this->league_id, "{$matchTable}.command_home_id" => $this->command_home_id, "{$matchTable}.command_guest_id" => $this->command_guest_id]);
$createdTime = strtotime($this->created_at);
$startDay = date("Y-m-d 00:00:00", $createdTime);
$endDay = date("Y-m-d 00:00:00", $createdTime + 60 * 60 * 24);
if ($this->created_at) {
$query->andFilterWhere(['between', 'created_at', $startDay, $endDay]);
}
$updatedTime = strtotime($this->updated_at);
$startDay = date("Y-m-d 00:00:00", $updatedTime);
$endDay = date("Y-m-d 00:00:00", $updatedTime + 60 * 60 * 24);
if ($this->updated_at) {
$query->andFilterWhere(['between', 'updated_at', $startDay, $endDay]);
}
$date = strtotime($this->date);
$startDay = date("Y-m-d 00:00:00", $date);
$endDay = date("Y-m-d 00:00:00", $date + 60 * 60 * 24);
if ($this->date) {
$query->andFilterWhere(['between', 'date', $startDay, $endDay]);
}
$query->andFilterWhere(['like', 'round', $this->round])->andFilterWhere(['like', 'announcement', $this->announcement])->andFilterWhere(['like', "teamHome.name", $this->getAttribute('teamHome.name')])->andFilterWhere(['like', "teamGuest.name", $this->getAttribute('teamGuest.name')])->andFilterWhere(['like', 'championship.name', $this->getAttribute('championship.name')])->andFilterWhere(['like', 'arbiterMain.name', $this->getAttribute('arbiterMain.name')])->andFilterWhere(['like', 'arbiterAssistant1.name', $this->getAttribute('arbiterAssistant1.name')])->andFilterWhere(['like', 'arbiterAssistant2.name', $this->getAttribute('arbiterAssistant2.name')])->andFilterWhere(['like', 'arbiterAssistant3.name', $this->getAttribute('arbiterAssistant3.name')])->andFilterWhere(['like', 'arbiterAssistant4.name', $this->getAttribute('arbiterAssistant4.name')])->andFilterWhere(['like', 'arbiterReserve.name', $this->getAttribute('arbiterReserve.name')])->andFilterWhere(['like', 'championshipPart.name', $this->getAttribute('championshipPart.name')])->andFilterWhere(['like', 'stadium.name', $this->getAttribute('stadium.name')]);
return $dataProvider;
}
/**
* Finds the Stadium model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Stadium the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Stadium::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
echo $form->field($model, 'season_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(Season::find()->orderBy(['id' => SORT_DESC])->all(), 'id', 'name'), 'language' => 'ru', 'options' => ['placeholder' => 'Выберите сезон...'], 'pluginOptions' => ['allowClear' => true]]);
?>
</div>
<div class="col-sm-6">
<?php
echo $form->field($model, 'championship_part_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(ChampionshipPart::find()->all(), 'id', 'name'), 'language' => 'ru', 'options' => ['placeholder' => 'Выберите этап турнира...'], 'pluginOptions' => ['allowClear' => true]]);
?>
</div>
</div>
<div class="row">
<div class="col-sm-6">
<?php
$availableStadiums = [];
if (!$model->isNewRecord) {
$stadium = Stadium::findOne($model->stadium_id);
if (isset($stadium->id)) {
$availableStadiums = [$stadium->id => $stadium->name];
}
}
echo $form->field($model, 'stadium_id')->widget(SelectizeDropDownList::classname(), ['loadUrl' => Url::to(['stadium/stadium-list']), 'items' => $availableStadiums, 'options' => ['multiple' => false], 'clientOptions' => ['valueField' => 'value', 'labelField' => 'text', 'persist' => false]]);
?>
</div>
<div class="col-sm-6">
<?php
echo $form->field($model, 'date')->widget(DateTimePicker::classname(), ['options' => ['placeholder' => 'Выберите дату матча'], 'removeButton' => false, 'language' => 'ru-RU', 'pluginOptions' => ['language' => 'ru', 'autoclose' => true, 'format' => 'dd.mm.yyyy hh:ii']]);
?>
</div>
</div>
