public static function tableOverview($atts, $content, $tag)
{
global $kkl_twig;
$db = new KKL_DB();
$context = KKL::getContext();
$rankings = array();
foreach ($db->getActiveLeagues() as $league) {
$season = $db->getSeason($league->current_season);
$day = $db->getGameDay($season->current_game_day);
$ranking = new stdClass();
$ranking->league = $league;
$ranking->ranks = $db->getRankingForLeagueAndSeasonAndGameDay($league->id, $season->id, $day->number);
foreach ($ranking->ranks as $rank) {
$team = $db->getTeam($rank->team_id);
$club = $db->getClub($team->club_id);
$rank->team->link = KKL::getLink('club', array('club' => $club->short_name));
}
$ranking->league->link = KKL::getLink('league', array('league' => $league->code, 'season' => date('Y', strtotime($season->start_date)), 'game_day' => $day->number));
$rankings[] = $ranking;
}
return $kkl_twig->render('shortcodes/table.tpl', array('context' => $context, 'rankings' => $rankings));
}
function display_content()
{
$db = new KKL_DB();
$db_locations = $db->getLocations();
$locations = array();
$locations[0] = __('unknown location', 'kkl-ligatool');
foreach ($db_locations as $location) {
$locations[$location->id] = $location->title;
}
$match = $this->get_item();
$current_game_day = $this->get_game_day();
$db_game_days = $this->get_game_days();
$game_days = array();
foreach ($db_game_days as $game_day) {
$game_days[$game_day->id] = $game_day->number;
}
$db_teams = $db->getTeamsForSeason($current_game_day->season_id);
$teams = array();
foreach ($db_teams as $team) {
$teams[$team->id] = $team->name;
}
$db_games = $db->getMatchesByGameDay($current_game_day->id);
$games = array();
$games[0] = __('back to overview', 'kkl-ligatool');
$games[1] = __('create new game', 'kkl-ligatool');
foreach ($db_games as $game) {
$home = $db->getTeam($game->home_team);
$away = $db->getTeam($game->away_team);
$games[$game->id] = $home->name . " - " . $away->name;
}
$final_checked = $match->status == 3;
if ($this->errors && $_POST['final_score']) {
$final_checked = true;
}
$fixture = $this->cleanDate($match->fixture);
echo $this->form_table(array(array('type' => 'hidden', 'name' => 'id', 'value' => $match->id), array('title' => __('game_day', 'kkl-ligatool'), 'type' => 'select', 'name' => 'game_day', 'value' => $game_days, 'selected' => $this->errors ? $_POST['game_day'] : $current_game_day->id), array('title' => __('fixture', 'kkl-ligatool'), 'type' => 'text', 'name' => 'fixture', 'value' => $fixture, 'extra' => array('class' => "pickfixture")), array('title' => __('team_home', 'kkl-ligatool'), 'type' => 'select', 'name' => 'team_home', 'value' => $teams, 'selected' => $this->errors ? $_POST['team_home'] : $match->home_team), array('title' => __('team_away', 'kkl-ligatool'), 'type' => 'select', 'name' => 'team_away', 'value' => $teams, 'selected' => $this->errors ? $_POST['team_away'] : $match->away_team), array('title' => __('location', 'kkl-ligatool'), 'type' => 'select', 'name' => 'location', 'value' => $locations), array('title' => __('goals_home', 'kkl-ligatool'), 'type' => 'select', 'name' => 'goals_home', 'value' => $this->get_goals_array(), 'selected' => $this->errors ? $_POST['goals_home'] : $match->goals_home), array('title' => __('goals_away', 'kkl-ligatool'), 'type' => 'select', 'name' => 'goals_away', 'value' => $this->get_goals_array(), 'selected' => $this->errors ? $_POST['goals_away'] : $match->goals_away), array('title' => __('score_home', 'kkl-ligatool'), 'type' => 'select', 'name' => 'score_home', 'value' => $this->get_score_array(), 'selected' => $this->errors ? $_POST['score_home'] : $match->score_home), array('title' => __('score_away', 'kkl-ligatool'), 'type' => 'select', 'name' => 'score_away', 'value' => $this->get_score_array(), 'selected' => $this->errors ? $_POST['score_away'] : $match->score_away), array('title' => __('final_score', 'kkl-ligatool'), 'type' => 'checkbox', 'name' => 'final_score', 'checked' => $final_checked), array('title' => __('description', 'kkl-ligatool'), 'type' => 'textarea', 'name' => 'description', 'value' => $this->errors ? $_POST['description'] : $match->notes, 'extra' => array('rows' => 7, 'cols' => 100)), array('title' => __('next_game', 'kkl-ligatool'), 'type' => 'select', 'name' => 'next_game', 'value' => $games, 'selected' => $this->errors ? $_POST['next_game'] : null)));
}
function save()
{
$team = new stdClass();
$team->id = $_POST['id'];
$team->name = $_POST['name'];
$team->short_name = $_POST['short_name'];
$team->season_id = $_POST['season'];
$team->club_id = $_POST['club'];
$db = new KKL_DB();
$team = $db->createOrUpdateTeam($team);
$properties = array();
$properties['location'] = false;
$properties['current_league_winner'] = false;
$properties['current_cup_winner'] = false;
if ($_POST['location']) {
$properties['location'] = $_POST['location'];
}
if ($_POST['current_league_winner']) {
$properties['current_league_winner'] = "true";
}
if ($_POST['current_cup_winner']) {
$properties['current_cup_winner'] = "true";
}
if (!empty($properties)) {
$db->setTeamProperties($team, $properties);
}
return $db->getTeam($team->id);
}
}
}
$KKL->setContext($context);
if (isset($wp_query->query_vars['json'])) {
header('Content-Type: application/json');
global $kkl_twig;
$db = new KKL_DB();
$context = KKL::getContext();
$rankings = array();
$output = array();
if (!$overview) {
$ranking = new stdClass();
$ranking->league = $context['league'];
$ranking->ranks = $db->getRankingForLeagueAndSeasonAndGameDay($context['league']->id, $context['season']->id, $context['game_day']->number);
foreach ($ranking->ranks as $rank) {
$team = $db->getTeam($rank->team_id);
$club = $db->getClub($team->club_id);
$rank->team->link = get_site_url() . '/team/' . KKL::getLink('club', array('club' => $club->short_name));
}
$rankings[] = $ranking;
$output['rankings'] = $rankings;
$schedules = array();
$schedule = $db->getScheduleForGameDay($context['game_day']);
foreach ($schedule->matches as $match) {
$home_club = $db->getClub($match->home->club_id);
$away_club = $db->getClub($match->away->club_id);
$match->home->link = get_site_url() . '/team/' . KKL::getLink('club', array('club' => $home_club->short_name));
$match->away->link = get_site_url() . '/team/' . KKL::getLink('club', array('club' => $away_club->short_name));
}
$schedule->link = get_site_url() . '/spielplan/' . KKL::getLink('schedule', array('league' => $context['league']->code, 'season' => date('Y', strtotime($context['season']->start_date))));
$schedules[] = $schedule;
