/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>

      <form method="post" action="./removedate.php">

        <input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />

        <input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName']; ?>" />

        <button id="remove" name="remove" value="remove">remove</button>

      </form>

			</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>

      <form method="post" action="./removedate.php">

        <input type="hidden" name="user1remove" id="user1remove" value="<?php echo $lunchSuggestion[0]; ?>" />

        <input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName'];  ?>" />

        <button id="remove" name="remove" value="remove">remove</button>

      </form>

			</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>

      <table>

      <tr>

      <td>

      <form method="post" action="./removedate.php">

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

        <input type="hidden" name="user2remove" id="user2remove" value="<?php echo $_SESSION['userName']; ?>" />

        <button id="remove" name="remove" value="remove">remove</button>

      </form>

      </td>

      <td>

			<form method="POST" action="./declinedate.php">

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

			<input type="hidden" name="user" value="<?php echo $_SESSION['userName']; ?>"/>

      <input type="hidden" name="DeclineLunch" value="DeclineLunch" />

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

			</form>

      </td>

      </tr>

      </table>

			</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>

      <table>

      <tr>

      <td>

			<form method="POST" action="./acceptdate.php">

        <input type="hidden" name="AcceptLunch" value="AcceptLunch" />

			  <input type="hidden" name="user" value="<?php echo $_SESSION['userName']; ?>"/>

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

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

			</form>

      </td>

      <td>

      <form method="post" action="./removedate.php">

        <input type="hidden" name="user1remove" id="user1remove" value="<?php echo $_SESSION['userName']; ?>" />

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

        <button id="remove" name="remove" value="remove">remove</button>

      </form>

      </td>

      </tr>

      </table>

			</div>

      <?php

		}

	}

?>