/**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = ChampionshipPart::find();
     $championship = new Championship();
     $championshipPartTable = ChampionshipPart::tableName();
     $championshipTable = Championship::tableName();
     $query->joinWith(['championship' => function ($query) use($championshipTable) {
         $query->from(['championship' => $championshipTable]);
     }]);
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
     // enable sorting for the related columns
     $addSortAttributes = ["championship.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(["{$championshipPartTable}.id" => $this->id]);
     $query->andFilterWhere(['like', "{$championshipPartTable}.name", $this->name])->andFilterWhere(['like', 'championship.name', $this->getAttribute('championship.name')]);
     return $dataProvider;
 }
示例#2
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getChampionshipPart()
 {
     return $this->hasOne(ChampionshipPart::className(), ['id' => 'championship_part_id']);
 }
示例#3
0
 /**
  * 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;
 }
示例#4
0
        <div class="col-sm-6">
            <?php 
echo $form->field($model, 'league_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(League::find()->all(), 'id', 'name'), 'language' => 'ru', 'options' => ['placeholder' => 'Выберите лигу...'], 'pluginOptions' => ['allowClear' => true]]);
?>
        </div>
    </div>

    <div class="row">
        <div class="col-sm-6">
            <?php 
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]]);
 /**
  * Finds the ChampionshipPart model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return ChampionshipPart the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = ChampionshipPart::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getChampionshipParts()
 {
     return $this->hasMany(ChampionshipPart::className(), ['championship_id' => 'id']);
 }