<?php # Form to input player data onto golf leaderboard

# This form 

$page_title = "Rounds Input Page";

include ('includes/header.html');
include ('includes/validationfunctions/valid_date_MM_DD_YYYY.php'); // form input values validation function
include ('includes/validationfunctions/valid_name_last_first.php'); // form input values validation function
include ('includes/validationfunctions/valid_score_points.php'); // form input values validation function

include_once ('../../mysqli_connect.php'); // myaqli_database_connect finction, I have a password set

define('PAR', 36); // definition of PAR

$namequery = "SELECT golfers.golfer_id as 'id',CONCAT_WS(\", \",golfers.last_name,golfers.first_name) as 'name'FROM golfers ORDER BY name ASC"; // query to get all golfers id's and associated names in last name first alphabetical order for form select options 

$namerows = mysqli_query($dbc,$namequery); // querying the database for golfer id and nanes

// Initializing a bunch of variables **************************************
$numplayers = -1;
$playerid_name_alpha[-1][1]="bad choice"; 
$playerid_name_alpha[-1][2]="Last, First";
$lastcourse = "Choose Course";
$y= "";
$m= "";
$d= "";
$points = "";
$score = "";
//**************************************************************************

while ($playernames=mysqli_fetch_array($namerows,MYSQLI_ASSOC)){ // Populating the array used to hold player name and id's
	$numplayers++;
	$playerid_name_alpha[$numplayers][1]=$playernames[id];
	$playerid_name_alpha[$numplayers][2]=$playernames[name];
	$player_id_name[$playernames[id]]= $playernames[name];
}

if (!isset($_POST['submitted'])) // checking to see if form is submitted
{
	$formmessage = "Please input your data above"; // initial message to users
	$warningcolor = "nowarningcolor"; // no special features to message
}

else
{
	// Below:  checks for validation of data entered into form
	if (isset($_POST['submitted']) && 
	Valid_Date_MM_DD_YYYY($_POST['month'],$_POST['day'],$_POST['year']) && ($_POST['course']!= "Choose Course") &&
	($_POST['chosenplayer']!="bad choice") &&	Valid_Score_Points($_POST['score'],$_POST['points']))

	{
		// If inputted data met validation requirements put it into different variables
		$playerid_name_alpha[-1][1]=$_POST['chosenplayer'];
		$playerid_name_alpha[-1][2]=$player_id_name[$_POST['chosenplayer']];
		$lastcourse=$_POST['course'];
		$y= $_POST['year'];
		$m= $_POST['month'];
		$d= $_POST['day'];
		$date = $y . "-" . $m . "-" . $d;
		$points = $_POST['points'];
		$score = $_POST['score'];
		$handicap = (PAR - $_POST['score'])*0.8; // Calculate the handicap for the round just inputted
		
		$update_handicaps_query = "INSERT INTO handicaps (date, golfer_id, handicap) VALUES 
		('$date', {$playerid_name_alpha[-1][1]}, $handicap)"; // query to ipdate handicaps table, id is auto increment in table
			
		$run_insert_handicap = mysqli_query ($dbc,$update_handicaps_query); // inserts new handicap info into handicap table
		
		$find_max_handicap_id_query = "SELECT MAX(handicap_id) AS 'maxid' FROM handicaps"; // Querry that finds last handicap id to be used in rounds table
		$handicap_value = mysqli_query ($dbc, $find_max_handicap_id_query);
		while ($value=mysqli_fetch_array($handicap_value,MYSQLI_ASSOC)) $max_handicap[0]=$value[maxid];// getting the last handicap id value to be put into rounds table
		
		$update_rounds_query = "INSERT INTO rounds (golfer_id, date, handicap_id, course, score, points) VALUES
		({$playerid_name_alpha[-1][1]}, '$date', $max_handicap[0], '$lastcourse', $score, $points)";  // querry to input a new round including the new handicap id attained through the querry above
		
		$run_insert_rounds = mysqli_query ($dbc,$update_rounds_query); // inserting new round data
		
		$formmessage = "Your Data Has Been Accepted"; // message to user that all is OK
		$warningcolor = "nowarningcolor";
		
		
	}
	else
	{
		//If a form input error was made then we reinitialize all the default form choices
		$playerid_name_alpha[-1][1]="bad choice"; 
		$playerid_name_alpha[-1][2]="Last, First";
		$lastcourse = "Choose Course";
		$y= "";
		$m= "";
		$d= "";
		$points = "";
		$score = "";
		$formmessage = "DATA NOT ACCEPTED: Please Review Your Inputted Data for Errors"; // tell user ther is a problem
		$warningcolor = "warningcolor"; // make the message stand out using special formatting
	}
}
?>


<div id= "inputform"> <!-- form used to input player data -->

<h1> Player Rounds Input Form</h1>

	<form method="post" action="golfleaderboardinputform.php">
	
		<input type="hidden" name="submitted" value="1" />

		<label for="date">Date(MM DD YYYY):</label> 
			<input type="text" name="month" size="2" maxlength="2" 
			value="<?php echo $m;?>"/>
			
		<input type="text" name="day" size="2" maxlength="2" 
			value="<?php echo $d;?>"/>
		
		<input type="text" name="year" size="4" maxlength="4"
			value="<?php echo $y;?>"/>
		
		<label for ="last, first">Name (Last, First):</label> 
		
		<select name = "chosenplayer"> <!-- Drop down menue to choose player name -->
		
		<?php
		
			for ($i=-1; $i<= $numplayers; $i++){
			echo "<option value=\"{$playerid_name_alpha[$i][1]}\">{$playerid_name_alpha[$i][2]}</option>";	
			}
		?>
		</select>
		
		
		<label for="score">Score:</label>
		<input type="text" name="score" size="3" maxlength="3" 
			value="<?php if (isset($_POST['score'])) echo $_POST['score'];?>"/>
			
		<label for="points">Points:</label>
		<input type="text" name="points" size="3" maxlength="3"
			value="<?php if (isset($_POST['points'])) echo $_POST['points'];?>"/>
		
		<label for="course">Course: </label>	
		<select name = "course"> <!-- Drop down menue to choose which course was played -->
				<option <?php echo ("value=\"$lastcourse\">".$lastcourse."</option>");?>
				<option value="front">front</option>
				<option value="back">back</option>
		</select>
		
		<p><input type="submit"  name="submit" value="Enter Player Data" ></p>

	</form>
	<p><?php echo("<span class='". "$warningcolor" . "'>" . "$formmessage" . "</span>") ; ?></p>
	
</div>


<?php include ('includes/footer.html'); ?>