<?php
// Season Selector
$my_points = getWeeklyPoints($db, $this_user_id, $this_group_id, $this_season_year, $this_season_type, $this_week);
// functions.php
$current_time = date("l h:iA T", time());
?>
<nav class="navbar navbar-inverse navbar-fixed-top weekSelector">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar2" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
</button>
</div><!--/.navbar-header -->
<p class="weekSelector-text">Your Picks for <?php
echo "{$this_season_year} {$this_season_type} Week {$this_week}";
?>
</p>
<div id="navbar2" class="navbar-collapse collapse weekSelector">
<ul class="nav navbar-nav weekSelector">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><?php
echo getGroupName($db, $this_group_id);
?>
<span class="caret"></span></a>
<ul class="dropdown-menu">
<li class="dropdown-header">Groups</li>
<?php
$groups = getGroups($db, $this_user_id);
function displayWeeklyStandings($db, $users, $season_year, $season_type, $week)
{
$num_games = getNumberOfGames($season_year, $season_type, $week);
$percentages = array();
//$monday_night = getMondayNight($season_year,$season_type,$week);
$monday_night_game_id = getMondayNightGame($season_year, $season_type, $week);
$monday_kickoff_time = getMondayNightKickoffTime($monday_night_game_id);
//echo 'Monday Night game '.$monday_night_game_id.' Kick Time '.$monday_kickoff_time;
foreach ($users as $user) {
$num_correct = getWeeklyPoints($db, $user['user_id'], $user['group_id'], $season_year, $season_type, $week);
$score = getWeeklyScore($db, $user['user_id'], $user['group_id'], $monday_night_game_id);
//returns array with score, gsis_id and winner
// $score = getGameScore($monday_night_game_id);
//$winner = getMondayNightWinner($monday_night_game_id);
$percentage = $num_correct / $num_games * 100;
//$percentages[$user['user_name']] = $percentage;
$this_key = $user['user_name'];
//$this_game_id = $score[0];
$totals[$this_key] = $num_correct;
$scores[$this_key] = $score[1];
$winners[$this_key] = $score[2];
}
/*
arsort($percentages);
$i=0;
foreach($percentages as $u => $p) {
echo "<div class=\"progress-label\">".$u."</div><div class=\"progress\">";
echo "<div class=\"progress-bar";
if($i==0 && $p > 0) { echo " progress-bar-success"; }
echo "\" role=\"progressbar\" aria-valuenow=\"$p\" aria-valuemin=\"0\" aria-valuemax=\"100\" style=\"min-width: 2em; width: $p%\">
$p%
</div>
</div>";
$i++;
}*/
arsort($totals);
$i = 0;
$last_total = 0;
echo '
<table class="progress-table">
<tr>';
if (strtotime($monday_kickoff_time) < time()) {
echo '<th class="winner">Monday Night Winner</th><th class="score">Score</th>';
echo '<th class="user">User</th><th class="points">Points</th></tr>';
}
foreach ($totals as $u => $n) {
$length = $n / $num_games * 100;
$length = round($length);
$total_str = "{$n} ({$n}/{$num_games}, {$length}%)";
echo '
<tr>';
if (strtotime($monday_kickoff_time) < time()) {
echo '
<td class="winner">' . $winners[$u] . '</td>
<td class="score">' . $scores[$u] . '</td>';
}
echo '
<td class="user">
<div class="progress-label">' . substr($u, 0, 12) . '</div>
</td>
<td class="points">
<div class="progress">
<div class="progress-bar';
if ($n > 0) {
if ($i == 0 || $n == $last_total) {
echo " progress-bar-success";
$last_total = $n;
}
}
echo '" role="progressbar" aria-valuenow="' . $length . '" aria-valuemin="0" aria-valuemax="100" style="min-width: 2em; width: ' . $length . '%;">' . $total_str . '</div>
</div>
</td>
</tr>';
$i++;
}
echo '</table>';
}
function updatePoints($db, $user_id, $group_id, $season_year, $season_type, $week, $verbose)
{
// check picks table for games that match season/week and sum them
//$sql = "SELECT SUM(points) AS points_sum FROM picks WHERE user_id='$user_id' AND season_year='$season_year' AND season_type='$season_type' AND week='$week'";
//$result = mysqli_query($db,$sql);
//$row = mysqli_fetch_assoc($result);
//$sum = $row['points_sum'];
//echo $sum;
$sum = getWeeklyPoints($db, $user_id, $group_id, $season_year, $season_type, $week);
$sql = "SELECT * FROM points WHERE user_id='{$user_id}' AND group_id='{$group_id}' AND season_year='{$season_year}' AND season_type='{$season_type}' AND week='{$week}'";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
// user has points for week in db so update
// update points total in points table for user
$sql = "UPDATE points SET points='{$sum}' WHERE user_id='{$user_id}' AND group_id='{$group_id}' AND season_year='{$season_year}' AND season_type='{$season_type}' AND week='{$week}'";
//$result = mysqli_query($db,$sql);
if (mysqli_query($db, $sql)) {
if ($verbose) {
echo "Point total for user_id {$user_id} in group_id {$group_id} for {$season_year} {$season_type} Week {$week} updated to {$sum}.<br>\n";
}
return mysqli_insert_id($db);
} else {
echo mysqli_error($db);
}
} else {
//no point total has been added so insert
$sql = "INSERT INTO points (points_id, user_id, group_id, season_year, season_type, week, points,winner) VALUES (NULL,'{$user_id}','{$group_id}','{$season_year}','{$season_type}','{$week}',{$sum},NULL)";
if (mysqli_query($db, $sql)) {
if ($verbose) {
echo "Point total for user_id {$user_id} in group_id {$group_id} for {$season_year} {$season_type} Week {$week} inserted as {$sum}.<br>\n";
}
return mysqli_insert_id($db);
} else {
echo mysqli_error($db);
}
}
}
