eventPage.php

<!--
eventPage.php

Loads all the event's information including the title, description, date,
and the list of toDos that belong to it. Also prints the creator of the 
event and its participants.

-->

<?php


$id = $_POST['id'];
$userID = $_POST['userID'];

include('./scripts/database_connection.php');

//Retreives all the ToDos of the event
$query = 'SELECT * FROM Has NATURAL JOIN Todo WHERE EventID = ' . $id .' ORDER BY Points DESC';
//Gets the admin of the event
$eventQuery = 'SELECT * FROM Event INNER JOIN User ON Admin = FBid WHERE EventID = ' . $id;


      
$result = mysql_query($query) or die(mysql_error());

for($i = 0; $row = @mysql_fetch_assoc($result); $i++) {
  $rows[$i] = $row;
}

$result = mysql_query($eventQuery) or die(mysql_error());

$event = mysql_fetch_assoc($result);

echo '<h3>'.$event['Title'].'</h3><br>';




if(!isset($rows)) echo '<p>There are no ideas for this event yet, be the first to propose something!</p>';

//Accordion collapsible list of ToDos
echo '<div class="accordion" id="accordion2">';

foreach($rows as $todo)
{
	$query = 'SELECT Point FROM Points WHERE FBid = '.$userID.' AND TodoID = '.$todo['TodoID'].';'; 
	$result = mysql_query($query) or die(mysql_error());

	$point = mysql_fetch_assoc($result);
	
	$num = intval($point['Point']);
	
	
	$plus = '';
	$minus = '';
	if($num === -1)
	{
		$minus = '#aa0000';
		$minState = 1;
	}
	else if($num === 1)
	{
		$plus = '#00aa00';
		$plusState = 1;
	}		
	
	$hash = hash('md4', $todo['Title'] + strval(rand()));
	echo '<div class="accordion-group"> <div class="accordion-heading">';
	echo '<div class="row-fluid"><div class="span10">';
	echo '<h4><a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion2" href="#'.$hash.'" tdid="'.$todo['TodoID'].'">'.$todo['Title'].'</a></h4>';
	echo '</div><div class="span2"><h3><a class="up" state="'.$plusState.'" path="'.$todo['TodoID'].'" href="#" style="background-color: '.$plus.';">+</a>&nbsp;&nbsp;<span id="'.$todo['TodoID'].'num">'.$todo['Points'].'</span>&nbsp;&nbsp;<a class="down" state="'.$minState.'" path="'.$todo['TodoID'].'" href="#" style="background-color: '.$minus.';">--</a></h3></div></div>';
	echo '</div>';
	
	echo '<div id="'.$hash.'" class="accordion-body collapse"><div class="accordion-inner">';
	echo '<p>'.$todo['Description'].'</p>';
	echo '<div id="cd'.$hash.'"></div>';
	echo '</div></div></div><br>';

}
echo '</div>';

echo '<br><b><p>Event added by '.$event['Name'].'</p></b><br>';
echo '<br><p>Participants: ';

//Gets all the participants of the event
$query = 'SELECT Name FROM Event NATURAL JOIN Participates NATURAL JOIN User WHERE Event.EventID = ' . $id;
$result = mysql_query($query) or die(mysql_error());

for($i = 0; $row = @mysql_fetch_assoc($result); $i++) {
  $rows[$i] = $row;
}

$last = count($rows);

$i = 0;

foreach($rows as $person)
{
	
	if(++$i === $last)
		echo $person['Name'].'<br><br>';
	else
		echo $person['Name'] . ', ';
}



echo '<a id="newIdea" class="btn btn-info"><b>Add an idea</b></a><br>';

//Join link
echo '<br><p>To add other people to this event, throw them this link:<br>';
echo 'http://decider.azurewebsites.net/joinEvent.php?id=' . $id;
echo '</p>';



?>