public function form($instance)
{
$db = new KKL_DB();
$leagues = $db->getLeagues();
if (isset($instance['title'])) {
$title = $instance['title'];
} else {
$title = __('New title', 'text_domain');
}
?>
<p>
<label for="<?php
echo $this->get_field_id('title');
?>
"><?php
_e('Title:');
?>
</label>
<input class="widefat" id="<?php
echo $this->get_field_id('title');
?>
" name="<?php
echo $this->get_field_name('title');
?>
" type="text" value="<?php
echo esc_attr($title);
?>
" />
</p>
<?php
}
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);
}
function save()
{
$location = new stdClass();
$location->id = $_POST['id'];
$location->title = $_POST['title'];
$location->description = $_POST['description'];
$location->lat = $_POST['lat'];
$location->lng = $_POST['lng'];
$db = new KKL_DB();
return $db->createOrUpdateLocation($location);
}
function save()
{
$league = new stdClass();
$league->id = $_POST['id'];
$league->name = $_POST['name'];
$league->code = $_POST['url_code'];
$league->active = $_POST['active'] ? 1 : 0;
$league->current_season = $_POST['season'];
$db = new KKL_DB();
$league = $db->createOrUpdateLeague($league);
return $league;
}
function save()
{
$club = new stdClass();
$club->id = $_POST['id'];
$club->name = $_POST['name'];
$club->short_name = $_POST['short_name'];
$club->description = $_POST['description'];
if ($_FILES['logo']['name']) {
$club->logo = $this->handleLogoChange();
}
$db = new KKL_DB();
$club = $db->createOrUpdateClub($club);
return $club;
}
function save()
{
$start_date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['start_date'])));
$end_date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['end_date'])));
$day = new stdClass();
$day->id = $_POST['id'];
$day->number = $_POST['number'];
$day->start_date = $start_date;
$day->end_date = $end_date;
$day->season_id = $_POST['season'];
$db = new KKL_DB();
$day = $db->createOrUpdateGameDay($day);
return $day;
}
function save()
{
$start_date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['start_date'])));
$end_date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['end_date'])));
$season = new stdClass();
$season->id = $_POST['id'];
$season->name = $_POST['name'];
$season->start_date = $start_date;
$season->end_date = $end_date;
$season->active = $_POST['active'] ? 1 : 0;
$season->current_game_day = $_POST['current_game_day'];
$season->league_id = $_POST['league'];
$db = new KKL_DB();
$season = $db->createOrUpdateSeason($season);
return $season;
}
public static function execute()
{
error_log("RUNNING GAMEDAY CHECKER:");
$db = new KKL_DB();
$leagues = $db->getLeagues();
foreach ($leagues as $league) {
error_log("checking league: " . utf8_decode($league->name));
$current_season = $db->getSeason($league->current_season);
if ($current_season && $current_season->active) {
error_log("- current season is " . utf8_decode($current_season->name));
$current_day = $db->getGameDay($current_season->current_game_day);
if ($current_day) {
error_log("-- current day is " . $current_day->number);
$next_day = $db->getNextGameDay($current_day);
$now = time();
if ($next_day->fixture) {
error_log("-- next day is " . $next_day->number);
$fixture = strtotime($next_day->fixture);
error_log("--- now: " . $now);
error_log("--- fixture: " . $fixture);
error_log("--- diff: " . ($now - $fixture));
if ($fixture < $now) {
error_log("--- setting next day");
$db->setCurrentGameDay($current_season, $next_day);
}
}
}
}
}
}
<?php
$KKL = new KKL();
$db = new KKL_DB();
$currentGameDay = $db->getCurrentGameDayForLeague(1);
/*
Template Name: Spieltag Übersicht
*/
get_header();
?>
<section class="kkl-content">
<div class="container">
<div class="row">
<div class="col-sm-10 col-md-8 col-sm-offset-1 col-md-offset-2">
<?php
if (have_posts()) {
while (have_posts()) {
the_post();
?>
<article id="post-<?php
the_ID();
?>
" <?php
post_class();
?>
>
<header class="text-center">
<small class="entry-metadata">
function column_goals_away($item)
{
$db = new KKL_DB();
$match = $db->getMatch($item['id']);
return $match->goals_away;
}
function get_current_game_day()
{
if ($this->currentGameDay) {
return $this->currentGameDay;
}
$day = null;
$db = new KKL_DB();
if ($_GET['game_day_filter']) {
$day = $db->getGameday($_GET['game_day_filter']);
} elseif ($this->get_current_season()) {
$day = $db->getCurrentGameDayForSeason($this->get_current_season()->id);
} elseif ($this->get_current_league()) {
$day = $db->getCurrentGameDayForLeague($this->get_current_league()->id);
}
$this->currentGameDay = $day;
return $day;
}
public function form($instance)
{
$db = new KKL_DB();
$leagues = $db->getLeagues();
if (isset($instance['title'])) {
$title = $instance['title'];
} else {
$title = __('New title', 'text_domain');
}
if (isset($instance['league'])) {
$league = $instance['league'];
} else {
$league = __('Set League', 'text_domain');
}
?>
<p>
<label for="<?php
echo $this->get_field_id('title');
?>
"><?php
_e('Title:');
?>
</label>
<input class="widefat" id="<?php
echo $this->get_field_id('title');
?>
" name="<?php
echo $this->get_field_name('title');
?>
" type="text" value="<?php
echo esc_attr($title);
?>
" />
<br/><br/>
<label for="<?php
echo $this->get_field_id('league');
?>
"><?php
_e('League:');
?>
</label>
<select id="<?php
echo $this->get_field_id('league');
?>
" name="<?php
echo $this->get_field_name('league');
?>
">
<option value=""><?php
echo __('get from context', 'kkl-ligatool');
?>
</option>
<?php
foreach ($leagues as $l) {
$selected = false;
if ($l->id == $league) {
$selected = true;
}
echo "<option value=\"{$l->id}\"";
if ($selected) {
echo ' selected="selected"';
}
echo ">";
echo $l->name;
echo "</option>";
}
?>
</select>
</p>
<?php
}
public static function gameDayPager($atts, $content, $tag)
{
global $kkl_twig;
$db = new KKL_DB();
$context = KKL::getContext();
$day = $context['game_day'];
$league = $context['league'];
$season = $context['season'];
$prev = $db->getPreviousGameDay($day);
if (!$prev) {
$day->isFirst = true;
} else {
$prev->link = KKL::getLink('league', array('league' => $league->code, 'season' => date('Y', strtotime($season->start_date)), 'game_day' => $prev->number));
}
$next = $db->getNextGameDay($day);
if (!$next) {
$day->isLast = true;
} else {
$next->link = KKL::getLink('league', array('league' => $league->code, 'season' => date('Y', strtotime($season->start_date)), 'game_day' => $next->number));
}
return $kkl_twig->render('shortcodes/gameday_pager.tpl', array('context' => $context, 'prev' => $prev, 'day' => $day, 'next' => $next));
}
function save()
{
$match = new stdClass();
$match->id = $_POST['id'];
$match->game_day_id = $_POST['game_day'];
$match->fixture = $this->cleanDate($_POST['fixture']);
$match->home_team = $_POST['team_home'];
$match->away_team = $_POST['team_away'];
$match->location = $_POST['location'];
$match->goals_home = $_POST['goals_home'];
$match->goals_away = $_POST['goals_away'];
$match->score_home = $_POST['score_home'];
$match->score_away = $_POST['score_away'];
$match->notes = $_POST['description'];
if ($_POST['final_score']) {
$match->status = 3;
} else {
$match->status = -1;
}
$db = new KKL_DB();
$this->match = $db->createOrUpdateMatch($match);
return $this->match;
}
<?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));
if ($league && $season) {
$context = $KKL->getContextByLeagueAndSeason($league, $season, $game_day);
} else {
if ($league) {
$context = $KKL->getContextByLeague($league, $season, $game_day);
} else {
$context = null;
$overview = true;
}
}
}
$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();
