show_community.php

<?php include('header.php');
if(!$loggedin){
	$_SESSION['AlertRed'] = "You have to be logged in to do that.";
	header("location:index.php");
}

if (!isset($_GET['comm_id'])) {
    $_SESSION['AlertRed'] = "No such community can be found.";
	header("location:index.php");
}else{
    $commid=$_GET['comm_id'];
    //Check if there is a community with that id
	
    $stmt=$db->prepare("SELECT * FROM Comms WHERE CommID=?");
	$stmt->execute(array($commid));
	$numrows = $stmt->rowCount();

	if($numrows==0){
		$_SESSION['AlertRed'] = "No such community can be found.";
		header("location:index.php");
	}else{


		$upvotessortnext="_desc";
		$chronosortnext ="_desc";
		
		if(isset($_GET['order_by'])){
			$orderby=$_GET['order_by'];

			if($orderby=="upvotes"){
				$orderby="upvotes_desc";
				$upvotessortnext="_asc";
			}else if($orderby=="upvotes_desc"){
				$upvotessortnext="_asc";
			}else if($orderby=="upvotes_asc"){
				;
			}else if($orderby=="chrono"){
				$orderby="chrono_desc";
				$chronosortnext="_asc";
			}else if($orderby=="chrono_desc"){
				$chronosortnext="_asc";
			}else if($orderby=="chrono_asc"){
				;
			}else{
				$orderby="chrono_desc"; #this is going to be default
				$chronosortnext ="_asc";
			}

		}else{
			$orderby="chrono_desc"; #this is going to be default
			$chronosortnext ="_asc";

		}


		if($orderby=="chrono_desc"){
			$orderstmt="ORDER BY date desc;";
		}else if($orderby=="chrono_asc"){
			$orderstmt="ORDER BY date asc;";
		}else if($orderby=="upvotes_desc"){
			$orderstmt="ORDER BY upvotes desc;";
		}else if($orderby=="upvotes_asc"){
			$orderstmt="ORDER BY upvotes asc;";
		}

		//Save the privacy setting of the group aside
		$row = $stmt->fetch(PDO::FETCH_ASSOC);
		if($row['Privacy']=='private'){$private=true;}else{$private=false;}
		$commname=$row['CommName'];
		$shortdesc=$row['ShortDesc'];

		//Check whether user is joined to the community.
		$stmt=$db->prepare("SELECT * FROM UsersInComms WHERE CommID=? AND UserID=?");
		$stmt->execute(array($commid,$userid));
		$numrows = $stmt->rowCount();
		if($numrows==0){ $joined=false; }else{ $joined=true; }

		//Check whether user has a pending request for given community.
		$stmt=$db->prepare("SELECT * FROM Requests WHERE CommID=? AND UserID=?");
		$stmt->execute(array($commid,$userid));
		$numrows = $stmt->rowCount();
		if($numrows==0){ $pending=false; }else{ $pending=true; }

		//Check whether user is admin of the page or not.
		$stmt=$db->prepare("SELECT * FROM UsersInComms WHERE CommID=? AND UserID=? AND Role='admin';");
		$stmt->execute(array($commid,$userid));
		$numrows = $stmt->rowCount();
		if($numrows==0){ $admin=false; }else{ $admin=true; }

		//Let's start drawing the page
		echo "<div class='container'><h2>".$commname."</h2><p>".$shortdesc." </p><p><i>";

		
		//Handling the buttons (join-joined-request-pending)

		if($admin){
			if($private){
				echo "<a href='./show_Requests.php?comm_id=".$commid."'>Click here to see Requests to join</a><br>";
			}
				echo "<a href='./preapprove_Users.php?comm_id=".$commid."'>Click here to add Users to your community</a>";

		}
		else if($joined){

			echo "Joined";	
		}else if(!$private){
			echo "<a href='./join.php?comm_id=".$commid."'>Click here to join</a>";
		}else if($pending){
			echo "Request Pending";
		}else{
			echo "<a href='./join.php?comm_id=".$commid."'>Click here to send a join request</a>";
		}
		
		echo "</i></p>";

		//Link to create new post

		if($joined){
			echo "<p><a href=\"./create_post.php?comm_id=$commid\">Add Post</a></p>";
		}



		//Handling the Posts

		if(!(!$joined && $private)){

			echo "	
      		<table class='table table-striped'>
        	<thead>
          	<tr>
          	<th width=5><a href=\"./show_community.php?comm_id=".$commid."&order_by=upvotes".$upvotessortnext."\">Upvotes</a></th>
          	<th><a href=\"./show_community.php?comm_id=".$commid."&order_by=chrono".$chronosortnext."\">Date</a></th>
            <th>Post Title</th>
            <th>Author</th>
          	</tr>
        	</thead>
        	<tbody>";


			$query = $db->prepare("SELECT P.PostID pid, P.PostTitle ptitle, U.UserName uname, U.UserID uid,
			(SELECT COUNT(*) FROM UpvotesForPosts UP WHERE UP.PostID=P.PostID AND UP.IsDeleted=0) as upvotes,
			P.CreatedOn AS date  
			FROM Posts P, Users U
			WHERE P.UserID=U.UserID AND P.CommID=? 
			".$orderstmt);
			$query->execute(array($commid));

			while($row = $query->fetch ( PDO::FETCH_ASSOC )){
				echo"<tr>
				<td>".$row['upvotes']."</td>
				<td>".$row['date']."</td>
				<td><a href='./show_post.php?post_id=".$row['pid']."'>".$row['ptitle']."</a></td>
				<td><a href='./show_user.php?user_id=".$row['uid']."'>".$row['uname']."</a></td>
				</tr>";
			}

		}
	}
}

$db=null;
?>
</tbody></table></div>

<?php include('footer.php');?>