/extremedating/trunk

<?PHP

	$lunchSuggestionArray = $db->query("SELECT user2 from planLunch WHERE user1='$username'");

	$lunchSuggestionQuery = $lunchSuggestionArray->fetchAll();

	foreach ($lunchSuggestionQuery as $lunchSuggestion) {

		$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchSuggestion[0]'");

		$self = $userinfo->fetchAll();

		$firstName = $self [0]['firstName'];

		$userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchSuggestion[0]'");

		$self = $userinfo->fetchAll();

		$surName = $self [0]['surName'];

		$userinfo = $db->query("SELECT date from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");

		$self = $userinfo->fetchAll();

		$datetime = $self [0]['date'];

		$userinfo = $db->query("SELECT message from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");

		$self = $userinfo->fetchAll();

		$message = $self [0]['message'];

		$userinfo = $db->query("SELECT accepted from planLunch WHERE user1='$username' AND user2='$lunchSuggestion[0]'");

		$self = $userinfo->fetchAll();

		$accepted = $self [0]['accepted'];

		if ($accepted=='true') {

			echo '<div class="dinnerwraps">';

			echo '<p>Du har bokat lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';

			echo '<p>' . $message . '</p>';

			echo '</div>';

		} else {

			echo '<div class="dinnerwraps">';

			echo '<p>Du har föreslagit lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';

			echo '<p>' . $message . '</p>';

			echo '</div>';

		}

	}

	$lunchAcceptionArray = $db->query("SELECT user1 from planLunch WHERE user2='$username'");

	$lunchAcceptionQuery = $lunchAcceptionArray->fetchAll();

	foreach ($lunchAcceptionQuery as $lunchAcception) {

		$userinfo = $db->query("SELECT firstName from Users WHERE loginName='$lunchAcception[0]'");

		$self = $userinfo->fetchAll();

		$firstName = $self [0]['firstName'];

		$userinfo = $db->query("SELECT surName from Users WHERE loginName='$lunchAcception[0]'");

		$self = $userinfo->fetchAll();

		$surName = $self [0]['surName'];

		$userinfo = $db->query("SELECT date from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");

		$self = $userinfo->fetchAll();

		$datetime = $self [0]['date'];

		$userinfo = $db->query("SELECT message from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");

		$self = $userinfo->fetchAll();

		$message = $self [0]['message'];

		$userinfo = $db->query("SELECT accepted from planLunch WHERE user2='$username' AND user1='$lunchAcception[0]'");

		$self = $userinfo->fetchAll();

		$accepted = $self [0]['accepted'];

		if ($accepted=='true') {

			echo '<div class="dinnerwraps">';

			echo '<p>Du har bokat lunch med ' . $firstName . ' ' . $surName . ' den ' . $datetime . '</p>';

			echo '<p>' . $message . '</p>';

			echo '<form method="POST" action="">';

			echo '<input type="hidden" name="user1_2" value="'.$lunchAcception[0].'"/>';

			echo '<button type="Submit" name="AcceptLunch">Avboka</button>';

			echo '</form>';

			echo '</div>';

			if (isset($_POST['user1_2'])) {

				$luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");

				$lunchinfo = $luncharray->fetchAll();

				$lunchquery = $lunchinfo[0];

				if($lunchquery[0] == 'true') {

					$db->exec("UPDATE planLunch SET accepted='false' WHERE(user2='$username' AND user1='{$_POST['user1_2']}')");

					header("Location:profile.php?uid=" . $_POST['user1_2']);

				}

			}

		} else {

			echo '<div class="dinnerwraps">';

			echo '<p>' . $firstName . ' ' . $surName . ' har föreslagit lunch med dig den ' . $datetime . '</p>';

			echo '<p>' . $message . '</p>';

			echo '<form method="POST" action="">';

			echo '<input type="hidden" name="user1" value="'.$lunchAcception[0].'"/>';

				echo '<button type="Submit" name="AcceptLunch">Acceptera</button>';

			echo '</form>';

			echo '</div>';

			if (isset($_POST['user1'])) {

				$luncharray = $db->query("SELECT accepted from planLunch WHERE(user2='$username' AND user1='{$_POST['user1']}')");

				$lunchinfo = $luncharray->fetchAll();

				$lunchquery = $lunchinfo[0];

				if($lunchquery[0] == 'false') {

					$db->exec("UPDATE planLunch SET accepted='true' WHERE(user2='$username' AND user1='{$_POST['user1']}')");

					header("Location:profile.php?uid=" . $_POST['user1']);

				}

			}

		}

	}

?>