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)); }
<?php $KKL = new KKL(); /* Template Name: Liga Übersicht (Teams) */ if (isset($wp_query->query_vars['json'])) { header('Content-Type: application/json'); global $kkl_twig; $db = new KKL_DB(); $context = KKL::getContext(); $all_leagues = $db->getActiveLeagues(); $leagues = array(); foreach ($all_leagues as $league) { $league->season = $db->getSeason($league->current_season); $league->teams = $db->getTeamsForSeason($league->season->id); foreach ($league->teams as $team) { $club = $db->getClub($team->club_id); if (!$team->logo) { $team->logo = $club->logo; if (!$club->logo) { $team->logo = "https://www.kickerligakoeln.de/wp-content/themes/kkl_2/img/kkl-logo_172x172.png"; } } else { $team->logo = "/images/team/" . $team->logo; } // HACK $team->link = KKL::getLink('club', array('club' => $club->short_name)); } $day = $db->getGameDay($league->season->current_game_day); $league->link = KKL::getLink('league', array('league' => $league->code, 'season' => date('Y', strtotime($league->season->start_date)), 'game_day' => $day->number));