Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

phppickem/entry_form.php

Go to file
 
 
Cannot retrieve contributors at this time
273 lines (263 sloc) 11.4 KB
Raw Blame
Open in GitHub Desktop
<?php
require_once('includes/application_top.php');
require('includes/classes/team.php');
if ($_POST['action'] == 'Submit') {
$week = $_POST['week'];
$cutoffDateTime = getCutoffDateTime($week);
//update summary table
$sql = "delete from " . DB_PREFIX . "picksummary where weekNum = " . $_POST['week'] . " and userID = " . $user->userID . ";";
$mysqli->query($sql) or die('Error updating picks summary: ' . $mysqli->error);
$sql = "insert into " . DB_PREFIX . "picksummary (weekNum, userID, showPicks) values (" . $_POST['week'] . ", " . $user->userID . ", " . (int)$_POST['showPicks'] . ");";
$mysqli->query($sql) or die('Error updating picks summary: ' . $mysqli->error);
//loop through non-expire weeks and update picks
$sql = "select * from " . DB_PREFIX . "schedule where weekNum = " . $_POST['week'] . " and (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) < gameTimeEastern and DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) < '" . $cutoffDateTime . "');";
$query = $mysqli->query($sql);
if ($query->num_rows > 0) {
while ($row = $query->fetch_assoc()) {
$sql = "delete from " . DB_PREFIX . "picks where userID = " . $user->userID . " and gameID = " . $row['gameID'];
$mysqli->query($sql) or die('Error deleting picks: ' . $mysqli->error);
if (!empty($_POST['game' . $row['gameID']])) {
$sql = "insert into " . DB_PREFIX . "picks (userID, gameID, pickID) values (" . $user->userID . ", " . $row['gameID'] . ", '" . $_POST['game' . $row['gameID']] . "')";
$mysqli->query($sql) or die('Error inserting picks: ' . $mysqli->error);
}
}
}
$query->free;
header('Location: results.php?week=' . $_POST['week']);
exit;
} else {
$week = (int)$_GET['week'];
if (empty($week)) {
//get current week
$week = (int)getCurrentWeek();
}
$cutoffDateTime = getCutoffDateTime($week);
$firstGameTime = getFirstGameTime($week);
}
include('includes/header.php');
?>
<script type="text/javascript">
function checkform() {
//make sure all picks have a checked value
var f = document.entryForm;
var allChecked = true;
var allR = document.getElementsByTagName('input');
for (var i=0; i < allR.length; i++) {
if(allR[i].type == 'radio') {
if (!radioIsChecked(allR[i].name)) {
allChecked = false;
}
}
}
if (!allChecked) {
return confirm('One or more picks are missing for the current week. Do you wish to submit anyway?');
}
return true;
}
function radioIsChecked(elmName) {
var elements = document.getElementsByName(elmName);
for (var i = 0; i < elements.length; i++) {
if (elements[i].checked) {
return true;
}
}
return false;
}
function checkRadios() {
$('input[type=radio]').each(function(){
//alert($(this).attr('checked'));
var targetLabel = $('label[for="'+$(this).attr('id')+'"]');
console.log($(this).attr('id')+': '+$(this).is(':checked'));
if ($(this).is(':checked')) {
//console.log(targetLabel);
targetLabel.addClass('highlight');
} else {
targetLabel.removeClass('highlight');
}
});
}
$(function() {
checkRadios();
$('input[type=radio]').click(function(){
checkRadios();
});
$('label').click(function(){
checkRadios();
});
});
</script>
<?php
//display week nav
$sql = "select distinct weekNum from " . DB_PREFIX . "schedule order by weekNum;";
$query = $mysqli->query($sql);
$weekNav = '<div id="weekNav" class="row">';
$weekNav .= ' <div class="navbar3 col-xs-12"><b>Go to week:</b> ';
$i = 0;
if ($query->num_rows > 0) {
while ($row = $query->fetch_assoc()) {
if ($i > 0) $weekNav .= ' | ';
if ($week !== (int)$row['weekNum']) {
$weekNav .= '<a href="entry_form.php?week=' . $row['weekNum'] . '">' . $row['weekNum'] . '</a>';
} else {
$weekNav .= $row['weekNum'];
}
$i++;
}
}
$query->free;
$weekNav .= ' </div>' . "\n";
$weekNav .= '</div>' . "\n";
echo $weekNav;
?>
<div class="row">
<div class="col-md-4 col-xs-12 col-right">
<?php
include('includes/column_right.php');
?>
</div>
<div id="content" class="col-md-8 col-xs-12">
<h2>Week <?php echo $week; ?> - Make Your Picks:</h2>
<p>Please make your picks below for each game.</p>
<?php
//get existing picks
$picks = getUserPicks($week, $user->userID);
//get show picks status
$sql = "select * from " . DB_PREFIX . "picksummary where weekNum = " . $week . " and userID = " . $user->userID . ";";
$query = $mysqli->query($sql);
if ($query->num_rows > 0) {
$row = $query->fetch_assoc();
$showPicks = (int)$row['showPicks'];
} else {
$showPicks = 1;
}
$query->free;
//display schedule for week
$sql = "select s.*, (DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > gameTimeEastern or DATE_ADD(NOW(), INTERVAL " . SERVER_TIMEZONE_OFFSET . " HOUR) > '" . $cutoffDateTime . "') as expired ";
$sql .= "from " . DB_PREFIX . "schedule s ";
$sql .= "inner join " . DB_PREFIX . "teams ht on s.homeID = ht.teamID ";
$sql .= "inner join " . DB_PREFIX . "teams vt on s.visitorID = vt.teamID ";
$sql .= "where s.weekNum = " . $week . " ";
$sql .= "order by s.gameTimeEastern, s.gameID";
//echo $sql;
$query = $mysqli->query($sql) or die($mysqli->error);
if ($query->num_rows > 0) {
echo '<form name="entryForm" action="entry_form.php" method="post" onsubmit="return checkform();">' . "\n";
echo '<input type="hidden" name="week" value="' . $week . '" />' . "\n";
//echo '<table cellpadding="4" cellspacing="0" class="table1">' . "\n";
//echo ' <tr><th>Home</th><th>Visitor</th><th align="left">Game</th><th>Time / Result</th><th>Your Pick</th></tr>' . "\n";
echo ' <div class="row">'."\n";
echo ' <div class="col-xs-12">'."\n";
$i = 0;
while ($row = $query->fetch_assoc()) {
$scoreEntered = false;
$homeTeam = new team($row['homeID']);
$visitorTeam = new team($row['visitorID']);
$homeScore = (int)$row['homeScore'];
$visitorScore = (int)$row['visitorScore'];
$rowclass = (($i % 2 == 0) ? ' class="altrow"' : '');
echo ' <div class="matchup">' . "\n";
echo ' <div class="row bg-row1">'."\n";
if (!empty($homeScore) || !empty($visitorScore)) {
//if score is entered, show score
$scoreEntered = true;
if ($homeScore > $visitorScore) {
$winnerID = $row['homeID'];
} else if ($visitorScore > $homeScore) {
$winnerID = $row['visitorID'];
};
//$winnerID will be null if tie, which is ok
echo ' <div class="col-xs-12 center"><b>Final: ' . $row['visitorScore'] . ' - ' . $row['homeScore'] . '</b></div>' . "\n";
} else {
//else show time of game
echo ' <div class="col-xs-12 center">' . date('D n/j g:i a', strtotime($row['gameTimeEastern'])) . ' ET</div>' . "\n";
}
echo ' </div>'."\n";
echo ' <div class="row versus">' . "\n";
echo ' <div class="col-xs-1"></div>' . "\n";
echo ' <div class="col-xs-4">'."\n";
echo ' <label for="' . $row['gameID'] . $visitorTeam->teamID . '" class="label-for-check"><div class="team-logo"><img src="images/logos/'.$visitorTeam->teamID.'.svg" onclick="document.entryForm.game'.$row['gameID'].'[0].checked=true;" /></div></label>' . "\n";
echo ' </div>'."\n";
echo ' <div class="col-xs-2">@</div>' . "\n";
echo ' <div class="col-xs-4">'."\n";
echo ' <label for="' . $row['gameID'] . $homeTeam->teamID . '" class="label-for-check"><div class="team-logo"><img src="images/logos/'.$homeTeam->teamID.'.svg" onclick="document.entryForm.game' . $row['gameID'] . '[1].checked=true;" /></div></label>'."\n";
echo ' </div>' . "\n";
echo ' <div class="col-xs-1"></div>' . "\n";
echo ' </div>' . "\n";
if (!$row['expired']) {
echo ' <div class="row bg-row2">'."\n";
echo ' <div class="col-xs-1"></div>' . "\n";
echo ' <div class="col-xs-4 center">'."\n";
echo ' <input type="radio" class="check-with-label" name="game' . $row['gameID'] . '" value="' . $visitorTeam->teamID . '" id="' . $row['gameID'] . $visitorTeam->teamID . '"' . (($picks[$row['gameID']]['pickID'] == $visitorTeam->teamID) ? ' checked' : '') . ' />'."\n";
echo ' </div>'."\n";
//echo ' <div class="col-xs-2 center" style="font-size: 0.8em;">&#9664; Choose &#9654;</div>' . "\n";
echo ' <div class="col-xs-2"></div>' . "\n";
echo ' <div class="col-xs-4 center">'."\n";
echo ' <input type="radio" class="check-with-label" name="game' . $row['gameID'] . '" value="' . $homeTeam->teamID . '" id="' . $row['gameID'] . $homeTeam->teamID . '"' . (($picks[$row['gameID']]['pickID'] == $homeTeam->teamID) ? ' checked' : '') . ' />' . "\n";
echo ' </div>' . "\n";
echo ' <div class="col-xs-1"></div>' . "\n";
echo ' </div>' . "\n";
}
echo ' <div class="row bg-row3">'."\n";
echo ' <div class="col-xs-6 center">'."\n";
echo ' <div class="team">' . $visitorTeam->city . ' ' . $visitorTeam->team . '</div>'."\n";
$teamRecord = trim(getTeamRecord($visitorTeam->teamID));
if (!empty($teamRecord)) {
echo ' <div class="record">Record: ' . $teamRecord . '</div>'."\n";
}
$teamStreak = trim(getTeamStreak($visitorTeam->teamID));
if (!empty($teamStreak)) {
echo ' <div class="streak">Streak: ' . $teamStreak . '</div>'."\n";
}
echo ' </div>'."\n";
echo ' <div class="col-xs-6 center">' . "\n";
echo ' <div class="team">' . $homeTeam->city . ' ' . $homeTeam->team . '</div>'."\n";
$teamRecord = trim(getTeamRecord($homeTeam->teamID));
if (!empty($teamRecord)) {
echo ' <div class="record">Record: ' . $teamRecord . '</div>'."\n";
}
$teamStreak = trim(getTeamStreak($homeTeam->teamID));
if (!empty($teamStreak)) {
echo ' <div class="streak">Streak: ' . $teamStreak . '</div>'."\n";
}
echo ' </div>' . "\n";
echo ' </div>'."\n";
if ($row['expired']) {
//else show locked pick
echo ' <div class="row bg-row4">'."\n";
$pickID = getPickID($row['gameID'], $user->userID);
if (!empty($pickID)) {
$statusImg = '';
$pickTeam = new team($pickID);
$pickLabel = $pickTeam->teamName;
} else {
$statusImg = '<img src="images/cross_16x16.png" width="16" height="16" alt="" />';
$pickLabel = 'None Selected';
}
if ($scoreEntered) {
//set status of pick (correct, incorrect)
if ($pickID == $winnerID) {
$statusImg = '<img src="images/check_16x16.png" width="16" height="16" alt="" />';
} else {
$statusImg = '<img src="images/cross_16x16.png" width="16" height="16" alt="" />';
}
}
echo ' <div class="col-xs-12 center your-pick"><b>Your Pick:</b></br />';
echo $statusImg . ' ' . $pickLabel;
echo '</div>' . "\n";
echo ' </div>' . "\n";
}
echo ' </div>'."\n";
$i++;
}
echo ' </div>' . "\n";
echo ' </div>' . "\n";
echo '<p class="noprint"><input type="checkbox" name="showPicks" id="showPicks" value="1"' . (($showPicks) ? ' checked="checked"' : '') . ' /> <label for="showPicks">Allow others to see my picks</label></p>' . "\n";
echo '<p class="noprint"><input type="submit" name="action" value="Submit" /></p>' . "\n";
echo '</form>' . "\n";
}
echo ' </div>'."\n"; // end col
echo ' </div>'."\n"; // end entry-form row
//echo '<div id="comments" class="row">';
include('includes/comments.php');
//echo '</div>';
include('includes/footer.php');