<?php
$thisCheckID	= 45;
include "globalVars.php";

if (!isset($_POST["eventID"])) {
	header("Location:/admin/forthcomingEdit.html");
} else {
	$eventID	= $_POST["eventID"];
	$eventQuery = mysqli_query($conn, "SELECT pageURL, eventRegType FROM forthcomingEvents WHERE id = '$eventID'");
	while ($eQ = mysqli_fetch_array($eventQuery)) {
		$eventURL		= $eQ["pageURL"];
		$eventRegType	= $eQ["eventRegType"];
	}
	if ($eventRegType == 1) {
		$submitBtnType	= "Bowlers";
	} elseif ($eventRegType == 2) {
		$submitBtnType	= "Pairs";
	} elseif ($eventRegType == 3) {
		$submitBtnType	= "Triples";
	} elseif ($eventRegType == 4) {
		$submitBtnType	= "Teams";
	}
}

include "header.php";
?>

				<h2>Update an Event for Registration - Registered <?php echo $submitBtnType ?></h2>

				<div class="formContainer">
					<div class="functionButtons">
						<form action="forthcomingEdit-1.html" method="post">
							<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="submit" name="getEvent" value="Event Details" />
						</form>
						<form action="forthcomingEdit-2.html" method="post">
							<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="submit" class="functionSelected" name="getEvent" value="Registered <?php echo $submitBtnType ?>" />
						</form>
					</div>
				</div>
				<a href="/pdf/<?php echo $eventURL ?>-registrants.pdf" class="submitButton" target="_blank">Print Registrants</a>

<?php
if (isset($_POST["regID"])) {
	/////	FORM POSTED	\\\\\
	$registrationID	= $_POST["regID"];
	$firstName		= $_POST["firstName"];
	$leadTel		= $_POST["leadTel"];
	$leadEmail		= $_POST["leadEmail"];
	$clubName		= $_POST["clubName"];
	$teamName		= "";
	$secondName		= "";
	$thirdName		= "";
	$displayName	= $firstName;
	if ($eventRegType == 4) {
		$teamName	= $_POST["teamName"];
		$displayName	= $teamName;
	} elseif ($eventRegType == 2 || $eventRegType == 3) {
		$secondName		= $_POST["secondName"];
		if ($eventRegType == 3) {
			$thirdName	= $_POST["thirdName"];
		}
	}

	if (isset($_POST["saveReg"])) {
		/////	UPDATE THE POSTED REGISTRANT	\\\\\
		mysqli_query($conn, "UPDATE forthcomingRegistrations SET firstName = '". addslashes($firstName) ."', secondName = '". addslashes($secondName) ."', thirdName = '". addslashes($thirdName) ."', teamName = '". addslashes($teamName) ."', leadTel = '". addslashes($leadTel) ."', leadEmail = '". addslashes($leadEmail) ."', clubName = '". addslashes($clubName) ."' WHERE id = '$registrationID'");

		echo "<p>Success! The registration for $displayName has been updated.</p>";

	} elseif (isset($_POST["deleteReg"])) {
		/////	DELETE THE POSTED REGISTRANT	\\\\\
		mysqli_query($conn, "DELETE FROM forthcomingRegistrations WHERE id = '$registrationID'");

		echo "<p>Success! The registration for $displayName has been deleted.</p>";

	}
}
?>


				<div class="descStTab">
				<?php
				$registeredQuery = mysqli_query($conn, "SELECT * FROM forthcomingRegistrations WHERE eventID = '$eventID' ORDER BY id ASC") or die (mysqli_error($conn));
				if (mysqli_num_rows($registeredQuery) == 0) {
					echo "<p>No $submitBtnType registered yet.</p>";
				} else {
					while ($rQ = mysqli_fetch_array($registeredQuery)) {
						?>
					<div class="pFormRow" style="margin-bottom:15px;">
						<form action="forthcomingEdit-2.html" method="post">
							<input type="hidden" name="eventID" value="<?php echo $eventID ?>" />
							<input type="hidden" name="regID" value="<?php echo $rQ["id"] ?>" />
							<div class="pFormEditTitle">
							<?php
							if ($eventRegType == 4) {
								?>
								<div class="pFormRow">
									<div class="pFormTitle">Registered by:</div>
									<div class="pFormInput">
										<input type="text" name="firstName" value="<?php echo $rQ["firstName"] ?>">
										<div class="pFormLabel">
											<label class="labelName">Registered by:</label>
										</div>
									</div>
								</div>
								<div class="pFormRow">
									<div class="pFormTitle">Team Name:</div>
									<div class="pFormInput">
										<input type="text" name="teamName" value="<?php echo $rQ["teamName"] ?>">
										<div class="pFormLabel">
											<label class="labelName">Team Name:</label>
										</div>
									</div>
								</div>
								<?php
							} else {
								?>
								<div class="pFormRow">
									<div class="pFormTitle"><?php if ($eventRegType == 1) {?>Player<?php } else {?>1st Player<?php } ?>:</div>
									<div class="pFormInput">
										<input type="text" name="firstName" placeholder="<?php if ($eventRegType == 1) {?>Player Name<?php } else {?>1st Player Name<?php } ?>" value="<?php echo $rQ["firstName"] ?>">
										<div class="pFormLabel">
											<label class="labelName"><?php if ($eventRegType == 1) {?>Player<?php } else {?>1st Player<?php } ?>:</label>
										</div>
									</div>
								</div>
								<?php
								if ($eventRegType == 2 || $eventRegType == 3) {
									?>
								<div class="pFormRow">
									<div class="pFormTitle">2nd Player:</div>
									<div class="pFormInput">
										<input type="text" name="secondName" placeholder="2nd Player" value="<?php echo $rQ["secondName"] ?>">
										<div class="pFormLabel">
											<label class="labelName">2nd Player:</label>
										</div>
									</div>
								</div>
									<?php
								}
								if ($eventRegType == 3) {
									?>
								<div class="pFormRow">
									<div class="pFormTitle">3rd Player:</div>
									<div class="pFormInput">
										<input type="text" name="thirdName" placeholder="3rd Player" value="<?php echo $rQ["thirdName"] ?>">
										<div class="pFormLabel">
											<label class="labelName">3rd Player:</label>
										</div>
									</div>
								</div>
									<?php
								}
							}
							?>
								<div class="pFormRow">
									<div class="pFormTitle">Telephone N&ordm;:</div>
									<div class="pFormInput">
										<input type="text" name="leadTel" value="<?php echo $rQ["leadTel"] ?>">
										<div class="pFormLabel">
											<label class="labelName">Telephone N&ordm;:</label>
										</div>
									</div>
								</div>
								<div class="pFormRow">
									<div class="pFormTitle">Email Address:</div>
									<div class="pFormInput">
										<input type="text" name="leadEmail" value="<?php echo $rQ["leadEmail"] ?>">
										<div class="pFormLabel">
											<label class="labelName">Email Address:</label>
										</div>
									</div>
								</div>
								<div class="pFormRow">
									<div class="pFormTitle">Club:</div>
									<div class="pFormInput">
										<input type="text" name="clubName" value="<?php echo $rQ["clubName"] ?>">
										<div class="pFormLabel">
											<label class="labelName">Club:</label>
										</div>
									</div>
								</div>
							</div>
							<div class="pFormEditButtons">
								<input type="submit" class="submitButton" name="saveReg" value="Save Changes"><br>
								<input type="submit" class="deleteButton" style="clear:both;" name="deleteReg" value="Delete">
							</div>
						</form>
					</div>
						<?php
					}
				}
				?>
				</div>
<?php
include "footer.php";
?>