/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Transfer::find(); $transferTable = Transfer::tableName(); // set up query with relation to `player.lastname` $playerTable = Player::tableName(); // set up query with relation to `teamFrom.name` and `teamTo.name` $teamTable = Team::tableName(); $query->joinWith(['player' => function ($query) use($playerTable) { $query->from(['player' => $playerTable]); }]); $query->joinWith(['teamFrom' => function ($query) use($teamTable) { $query->from(['teamFrom' => $teamTable]); }]); $query->joinWith(['teamTo' => function ($query) use($teamTable) { $query->from(['teamTo' => $teamTable]); }]); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); // enable sorting for the related columns $addSortAttributes = ["player.lastname", "teamFrom.name", "teamTo.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(["{$transferTable}.id" => $this->id, 'season_id' => $this->season_id, 'transfer_type_id' => $this->transfer_type_id, 'player_id' => $this->player_id, 'probability' => $this->probability, 'command_from_id' => $this->command_from_id, 'command_to_id' => $this->command_to_id, 'is_active' => $this->is_active, 'contract_date' => $this->contract_date, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'sum', $this->sum])->andFilterWhere(['like', 'clubs', $this->clubs])->andFilterWhere(['like', 'others', $this->others])->andFilterWhere(['like', 'teamFrom.name', $this->getAttribute('teamFrom.name')])->andFilterWhere(['like', 'teamTo.name', $this->getAttribute('teamTo.name')])->andFilterWhere(['like', 'player.lastname', $this->getAttribute('player.lastname')]); return $dataProvider; }
/** * Url: /transfers * @return mixed */ public function actionTransfers() { // transfer type select $transferTypes = TransferType::find()->orderBy(['id' => SORT_DESC])->all(); $activeTransferType = 'all-types'; if (isset($_GET['transfer-type'])) { foreach ($transferTypes as $transferType) { if ($_GET['transfer-type'] == $transferType->id) { $activeTransferType = $_GET['transfer-type']; } } } $transferTypesData = ['all-types' => ['value' => 'all-types', 'text' => 'Все трансферы', 'active' => false]]; foreach ($transferTypes as $transferType) { $transferTypesData[$transferType->id] = ['value' => $transferType->id, 'text' => $transferType->name, 'active' => false]; } $transferTypesData[$activeTransferType]['active'] = true; foreach ($transferTypesData as $key => $transferType) { $transferTypesData[$key] = (object) $transferType; } // season select $seasons = Season::find()->innerJoinWith('transfers')->orderBy(['id' => SORT_DESC])->all(); $firstSeasonObj = array_values($seasons)[0]; $firstSeasonId = $firstSeasonObj->id; $activeSeason = $firstSeasonId; if (isset($_GET['season'])) { foreach ($seasons as $season) { if ($_GET['season'] == $season->id) { $activeSeason = $_GET['season']; } } } $seasonsData = []; foreach ($seasons as $season) { $seasonName = $season->name; if ($season->window == $season::WINDOW_WINTER) { $seasonName .= ' Зимнее окно'; } else { $seasonName .= ' Летнее окно'; } $seasonsData[$season->id] = ['value' => $season->id, 'text' => $seasonName, 'active' => false]; } $seasonsData[$activeSeason]['active'] = true; foreach ($seasonsData as $key => $season) { $seasonsData[$key] = (object) $season; } // transfers tables $transferQuery = Transfer::find()->where(['season_id' => $activeSeason])->orderBy(['created_at' => SORT_ASC]); if ($activeTransferType != 'all-types') { $transferQuery->andWhere(['transfer_type_id' => $activeTransferType]); } $transfers = $transferQuery->all(); return $this->render('@frontend/views/site/index', ['templateType' => 'col2', 'title' => 'Dynamomania.com | Трансферы', 'columnFirst' => ['transfers' => ['view' => '@frontend/views/transfers/transfers', 'data' => compact('transferTypesData', 'seasonsData', 'transfers')]], 'columnSecond' => ['short_news' => SiteBlock::getShortNews()]]); }