function generateForm()
{
// Grab data for pulldowns if we need an edit form
$teams = $this->league->teams_as_array();
if (!count($teams)) {
error_exit("There may be no teams in this league");
}
$teams[0] = "---";
$this->template_name = 'pages/schedule/view.tpl';
// get the game slots for this league and this day
$gameslots = $this->league->get_gameslots($this->day_id);
if (count($gameslots) <= 1) {
error_exit("There are no fields assigned to this league");
}
$sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
while ($game = $sth->fetchObject('Game')) {
$games[] = $game;
}
$this->smarty->assign('league', $this->league);
$this->smarty->assign('teams', $teams);
$this->smarty->assign('can_edit', 1);
$this->smarty->assign('edit_week', $this->day_id);
$this->smarty->assign('gameslots', $gameslots);
$this->smarty->assign('rounds', $this->league->rounds_as_array());
$this->smarty->assign('games', $games);
return true;
}
function render_schedule()
{
if ($this->league->schedule_type == 'none') {
error_exit("This league does not have a schedule or standings.");
}
$sth = Game::query(array('league_id' => $this->league->league_id, 'published' => 1, '_order' => 'g.game_date, g.game_start, field_code'));
$currentTime = time();
$games = array();
while ($game = $sth->fetchObject('Game')) {
$game->event_status = 'pre-event';
if ($currentTime > $game->timestamp) {
$game->event_status = 'post-event';
}
$games[] = $game;
}
$this->smarty->assign('games', $games);
}
function process()
{
$this->title = "{$this->league->fullname} » Status Report";
$this->template_name = 'pages/league/status.tpl';
// make sure the teams are loaded
$this->league->load_teams();
// TODO: we calculate_standings() here, but it's probably not necessary
list($order, $season, $round) = $this->league->calculate_standings(array('round' => $this->league->current_round));
$fields = array();
$sth = Field::query(array('_extra' => '1 = 1', '_order' => 'f.code'));
while ($field = $sth->fetchObject('Field')) {
$fields[$field->code] = $field->region;
}
// Parse the schedule and accumulate per-team stats
$sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
while ($g = $sth->fetchObject('Game')) {
$season[$g->home_team]->game_count++;
$season[$g->away_team]->game_count++;
list($code, $num) = explode(' ', $g->field_code);
$season[$g->home_team]->region_game_counts[$fields[$code]]++;
$season[$g->away_team]->region_game_counts[$fields[$code]]++;
$season[$g->home_team]->home_game_count++;
$season[$g->home_team]->opponent_counts[$g->away_name]++;
$season[$g->away_team]->opponent_counts[$g->home_name]++;
}
$teams = array();
while (list(, $tid) = each($order)) {
$team = $season[$tid];
$ratio = $team->preferred_field_ratio();
if ($ratio > 1) {
# If ratio is > 1, lower it to 1 for display purposes
$ratio = 1;
}
$ratio = sprintf("%.3f", $ratio);
$check_ratio = $ratio;
if ($team->game_count % 2) {
$check_ratio = ($ratio * $team->game_count + 1) / ($team->game_count + 1);
}
list($team->preferred_ratio, $team->preferred_ratio_bad) = array($ratio, $check_ratio < 0.5);
list($team->home_game_ratio, $team->home_game_ratio_bad) = _ratio_helper($team->home_game_count, $team->game_count);
$teams[] = $team;
}
$this->smarty->assign('teams', $teams);
return true;
}
function process()
{
global $lr_session;
$this->title = "{$this->league->fullname} » Schedule";
$this->template_name = 'pages/schedule/view.tpl';
// TODO: do load_many() and query using 'published'
$sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
$games = array();
while ($game = $sth->fetchObject('Game')) {
if (!($game->published || $lr_session->has_permission('league', 'edit schedule', $this->league->league_id))) {
continue;
}
$games[] = $game;
}
$this->smarty->assign('can_edit', $lr_session->has_permission('league', 'edit schedule', $this->league->league_id));
$this->smarty->assign('games', $games);
return true;
}
function process()
{
$this->title = "Daily Schedule";
list($year, $month, $day) = preg_split("/[\\/-]/", $_POST['edit']['date']);
$today = getdate();
$yyyy = is_numeric($year) ? $year : $today['year'];
$mm = is_numeric($month) ? $month : $today['mon'];
$dd = is_numeric($day) ? $day : $today['mday'];
if (!validate_date_input($yyyy, $mm, $dd)) {
error_exit('That date is not valid');
}
$this->smarty->assign('date', sprintf("%4d/%02d/%02d", $yyyy, $mm, $dd));
$formattedDay = strftime('%A %B %d %Y', mktime(6, 0, 0, $mm, $dd, $yyyy));
$this->title .= " » {$formattedDay}";
$this->template_name = 'pages/schedule/day.tpl';
$sth = Game::query(array('game_date' => sprintf('%d-%d-%d', $yyyy, $mm, $dd), 'published' => true, '_order' => 'g.game_start, field_code'));
while ($g = $sth->fetchObject('Game')) {
if (!($g->published || $lr_session->has_permission('league', 'edit schedule', $this->league->league_id))) {
continue;
}
$games[] = $g;
}
$this->smarty->assign('games', $games);
}
function generateStatusPage()
{
global $dbh;
// make sure the teams are loaded
$this->league->load_teams();
list($order, $season, $round) = $this->league->calculate_standings(array('round' => $this->league->current_round));
$fields = array();
$sth = Field::query(array('_order' => 'f.code'));
while ($field = $sth->fetchObject('Field')) {
$fields[$field->code] = $field->region;
}
$output = para("This is a general field scheduling balance report for the league. The first number in each cell is the number of games that team has played at a given site. The second number, in brackets, is the team's average ranking for that site. Zero represents an unranked field.");
$num_teams = sizeof($order);
$header[] = array('data' => "Rating", 'rowspan' => 2);
$header[] = array('data' => "Team", 'rowspan' => 2);
// now gather all possible fields this league can use
$sth = $dbh->prepare('SELECT
DISTINCT IF(f.parent_fid, pf.code, f.code) AS field_code,
TIME_FORMAT(g.game_start, "%H:%i") as game_start,
IF(f.parent_fid, pf.region, f.region) AS field_region,
IF(f.parent_fid, pf.fid, f.fid) AS fid,
IF(f.parent_fid, pf.name, f.name) AS name
FROM league_gameslot_availability a
INNER JOIN gameslot g ON (g.slot_id = a.slot_id)
LEFT JOIN field f ON (f.fid = g.fid)
LEFT JOIN field pf ON (pf.fid = f.parent_fid)
WHERE a.league_id = ?
ORDER BY field_region DESC, field_code, game_start');
$sth->execute(array($this->league->league_id));
$last_region = "";
$field_region_count = 0;
while ($row = $sth->fetch(PDO::FETCH_OBJ)) {
$field_list[] = "{$row->field_code} {$row->game_start}";
$subheader[] = array('data' => l($row->field_code, "field/view/{$row->fid}", array('title' => $row->name)) . " {$row->game_start}", 'class' => "subtitle");
if ($last_region == $row->field_region) {
$field_region_count++;
} else {
if ($field_region_count > 0) {
$header[] = array('data' => $last_region, 'colspan' => $field_region_count);
}
$last_region = $row->field_region;
$field_region_count = 1;
}
}
// and make the last region header too
if ($field_region_count > 0) {
$header[] = array('data' => $last_region, 'colspan' => $field_region_count);
}
$header[] = array('data' => "Games", 'rowspan' => 2);
$rows = array();
$rows[] = $subheader;
$rowstyle = "standings_light";
// get the schedule
$schedule = array();
$sth = Game::query(array('league_id' => $this->league->league_id, '_order' => 'g.game_date, g.game_start, field_code'));
while ($g = $sth->fetchObject('Game')) {
$schedule[] = $g;
}
// we'll cache these results, so we can compute avgs and highlight numbers too far from average
$cache_rows = array();
$total_at_field = array();
$sum_field_rankings = array();
while (list(, $tid) = each($order)) {
if ($rowstyle == "standings_light") {
$rowstyle = "standings_dark";
} else {
$rowstyle = "standings_light";
}
$row = array(array('data' => $season[$tid]->rating, 'class' => "{$rowstyle}"));
$row[] = array('data' => l($season[$tid]->name, "team/view/{$tid}"), 'class' => "{$rowstyle}");
// count number of games per field for this team:
$numgames = 0;
$count = array();
$site_ranks = array();
// parse the schedule
reset($schedule);
while (list(, $game) = each($schedule)) {
if ($game->home_team == $tid || $game->away_team == $tid) {
$numgames++;
list($code, $num) = explode(' ', $game->field_code);
$count["{$code} {$game->game_start}"]++;
$rank = $game->get_site_ranking($tid);
if ($rank != 'unranked') {
$site_ranks["{$code} {$game->game_start}"] += $rank;
}
}
}
foreach ($field_list as $f) {
$thisrow = array('data' => "0", 'class' => "{$rowstyle}", 'align' => 'center');
if ($count[$f]) {
$thisrow['data'] = $count[$f] . sprintf(' (%.3f)', $site_ranks[$f] / $count[$f]);
$total_at_field[$f] += $count[$f];
$sum_field_ranks[$f] += $site_ranks[$f];
}
$row[] = $thisrow;
}
$row[] = array('data' => $numgames, 'class' => "{$rowstyle}", 'align' => "center");
$cache_rows[] = $row;
}
// pass through cached rows and highlight entries far from avg
foreach ($cache_rows as $row) {
$i = 3;
// first data column
foreach ($field_list as $f) {
$avg = $total_at_field[$f] / $num_teams;
// we'll consider more than 1.5 game from avg too much
if ($avg - 1.5 > $row[$i]['data'] || $row[$i]['data'] > $avg + 1.5) {
$row[$i]['data'] = "<b><font color='red'>" . $row[$i]['data'] . "</font></b>";
}
$i++;
// move to next column in cached row
}
$rows[] = $row;
}
// output totals lines
$total_row = array(array('data' => "Total games:", 'colspan' => 2, 'align' => 'right'));
$avg_row = array(array('data' => "Avg num at site:", 'colspan' => 2, 'align' => 'right'));
$rank_row = array(array('data' => "Average Rank:", 'colspan' => 2, 'align' => 'right'));
$column_idx = 1;
foreach ($field_list as $f) {
$total_row[$column_idx] = array('data' => "0", 'align' => 'center');
$avg_row[$column_idx] = array('data' => "0", 'align' => 'center');
$rank_row[$column_idx] = array('data' => "0", 'align' => 'center');
if ($total_at_field[$f]) {
$total_row[$column_idx]['data'] = $total_at_field[$f];
$avg_row[$column_idx]['data'] = sprintf('%.1f', $total_at_field[$f] / $num_teams);
$rank_row[$column_idx]['data'] = sprintf("%.3f", $sum_field_ranks[$f] / $total_at_field[$f]);
}
$column_idx++;
}
$rows[] = $total_row;
$rows[] = $avg_row;
$rows[] = $rank_row;
$rows[] = array_merge(array(array('colspan' => 2, 'data' => '')), $subheader);
//$output .= table($header, $rows);
$output .= "<div class='listtable'>" . table($header, $rows) . "</div>";
return form($output);
}
static function getRelatedGames($id)
{
$games = array();
$result = Game::query('SELECT games.*, COUNT(*) FROM tbl_games as games
INNER JOIN tbl_tag_relations as game_tags ON game_tags.game_id = games.game_id
WHERE game_tags.tag_id IN (SELECT tag_id FROM tbl_tag_relations as game_tags WHERE game_id = ' . $id . ')
AND game_tags.game_id != ' . $id . '
GROUP BY games.game_id
Order by count(*) desc
');
$max = $result->num_rows;
$trak = 0;
while ($row = $result->fetch_assoc()) {
$data['id'] = $row['game_id'];
$data['file'] = Utils::TitleToFile($row['title']);
$data['image'] = Utils::FileToGameImageURL(Utils::TitleToFile($row['title']), "png");
$data['title'] = $row['title'];
$data['plays'] = Utils::nice_number($row['plays']);
$data['description'] = $row['desc'];
array_push($games, $data);
}
return $games;
}
