/**
*
* @param string nefub name
* @return NefubType
*/
public static function getByNefubName($nefubName, $date, Gender $oGender)
{
return self::getSingle(array('nefub_name' => $nefubName, 'date' => $date, 'gender_id' => $oGender->getId()));
}
/**
* @deprecated
*/
public static function getGenderGames(Season $oSeason, Gender $oGender)
{
$query = "SELECT Game.*\r\n\t\t\t\t\tFROM Game \t\t\r\n\t\t\t\t\tLEFT JOIN Competition ON Game.competition_nefub_id = Competition.nefub_id\t\t\t\r\n\t\t\t\t\tWHERE Game.date >= CURDATE()\r\n\t\t\t\t\t\r\n\t\t\t\t\tAND Game.date IS NOT NULL\t\t\t\t\t\r\n\t\t\t\t\tAND Competition.season_nefub_id = '" . $oSeason->nefub_id . "'\t\t\t\t\t\r\n\t\t\t\t\tAND Competition.gender_id = '" . $oGender->getId() . "'\t\t\t\t\r\n\t\t\t\tORDER BY Game.date ASC,\r\n\t\t\t\t\tGame.time ASC\r\n\t\t\t\t\t";
return self::sortByDateAndLocation($query);
}
