/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') {

      ?>

			<div class="dinnerwraps">

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

			<p> <?php echo $message; ?></p>

			</div>

      <?php

		} else {

      ?>

			<div class="dinnerwraps">

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

			<p> <?php echo $message; ?></p>

			</div>';

      <?php

		}

	}

	$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') {

      ?>

			<div class="dinnerwraps">

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

			<p><?php echo $message; ?>  </p>

			<form method="POST" action="">

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

			<button type="Submit" name="AcceptLunch">Avboka</button>

			</form>';

			</div>';

			<?php

			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 {

      ?>

			<div class="dinnerwraps">

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

			<p> <?php $message ?> </p>

			<form method="POST" action="">

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

      <button type="Submit" name="AcceptLunch">Acceptera</button>

			</form>';

			</div>';

      <?php

			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']);

				}

			}

		}

	}

?>