/**
* @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');
}