/** * @param null|integer $EventID * @param null|integer $LeagueID * @param null|integer $CategoryID * * @return array */ public static function getForDropdown($EventID = null, $LeagueID = null, $CategoryID = null) { $query = static::find()->andFilterWhere([self::tableName() . '.EventID' => $EventID])->orderBy('BetGroupName')->groupBy('BetGroupName'); if (!is_null($LeagueID) && $LeagueID != '') { $query->innerJoinWith('event')->andWhere([BetssonLeagueEvent::tableName() . '.LeagueID' => $LeagueID]); } if (!is_null($CategoryID) && $CategoryID != '') { $query->innerJoinWith('event.league')->andWhere([BetssonCategoryLeague::tableName() . '.CategoryID' => $CategoryID]); } $models = $query->all(); return ArrayHelper::map($models, 'BetGroupID', 'BetGroupName'); }