<?php
require_once('classes/profile.php');

class Friends {
	function addFriend($id, $userid) {
		$db = Database::obtain();
		
		if ($this->checkPendingFriendship($id, $userid) == true) {
			$msg = "This friendship already has a pending request. Check your emails.";
			return $msg;
		}
		
		if ($this->checkHaveAlready($id, $userid) == true) {
			$msg = 'You are already friends with this person!';
			return $msg;
		}

		if ($this->checkFriendExists($id) == false) {
			$msg = 'This memeber does not exist.';
			return $msg;
		}
		
		if ($this->checkBlankProfile($id) == false) {
			$msg = "This user hasn't completed his/her profile so cannot be currently added to your friends.";
			return $msg;
		}
		
		if ($this->checkBlankProfile($userid) == false) {
			$msg = "You need to fill out your profile before being able to add friends.";
			return $msg;
		}	
		
		$data['user_id'] = $userid;
		$data['friend_id'] = $id;
		$data['date'] = time();
		$data['verified'] = 0;

		$pid = $db->insert(tbl_friends, $data);
	}
	
	function removeFriend($friendid, $userid) {
		$db = Database::obtain();
		
		if ($this->checkHaveAlready($friendid, $userid) == false) {
			$msg = 'You are not currently friends with this person silly';
			return $msg;
		}
		
		if ($this->checkFriendExists($friendid) == false) {
			$msg = 'This user doesn\'t exist in our system';
			return $msg;
		}		
		
		$sql = "DELETE FROM " . tbl_friends . " WHERE user_id = " . (int)$userid . " AND friend_id = " . (int)$friendid . " AND verified = 1";
		$q = $db->query($sql);

		if ($q > 0)
		{
			$sqlRemFriend = "DELETE FROM " . tbl_friends . " WHERE friend_id = " . (int)$userid . " AND user_id = " . (int)$friendid;
			$q = $db->query($sqlRemFriend);
		}
		else
		{
			$sqlIndFriend = "DELETE FROM " . tbl_friends . " WHERE user_id = " . (int)$userid . " AND friend_id = " . (int)$friendid;
			$q = $db->query($sqlIndFriend);
		}
		
	}
	
	function checkBlankProfile($id) {
		$db = Database::obtain();
		
		$sql = "SELECT user_id 
			FROM " . tbl_profile . "
			WHERE user_id = " . (int)$id . " AND first_name != ''";
			
		$row = $db->query_first($sql);
		
		if (!empty($row)) {
			return true;
		}
		
		return false;
	}
	
	function checkPendingFriendship($id, $userid) {
		$db = Database::obtain();
		
		$sql = "SELECT user_id 
			FROM " . tbl_friends . "
			WHERE user_id = " . (int)$userid . " AND friend_id = " . (int)$id . " AND verified='0'";
			
		$row = $db->query_first($sql);
		
		if (!empty($row)) {
			return true;
		}
		
		$sql = "SELECT user_id 
			FROM " . tbl_friends . "
			WHERE user_id = " . (int)$id . " AND friend_id = " . (int)$userid . " AND verified='0'";
			
		$row = $db->query_first($sql);
		
		if (!empty($row)) {
			return true;
		}
		
		return false;
	}
	
	function checkFriendExists($id) {
		$db = Database::obtain();

		$sql = "SELECT user_id
			FROM " . tbl_profile . "
			WHERE user_id = " . (int)$id;
		$row = $db->query_first($sql);

		if (!empty($row)) {
			return true;
		}
	
		return false;
	}

	function checkHaveAlready($id, $userid) {
		$db = Database::obtain();

		$sql = "SELECT friend_id
			FROM " . tbl_friends . "
			WHERE friend_id = " . (int)$id . "
			AND user_id = " . (int)$userid;
		$row = $db->query_first($sql);
		
		if ($row > 0) {
			return true;
		}

		return false;
	}
		
	function getFriends($userid) {
		$db = Database::obtain();
		
		$sql = "SELECT " . tbl_users . ".id, " . tbl_users . ".email, " . tbl_profile . ".first_name, " . tbl_profile . ".last_name, " . tbl_profile . ".twitter, " . tbl_profile . ".facebook
		        FROM " . tbl_friends . "
        		JOIN " . tbl_users ." ON " . tbl_friends . ".friend_id = " . tbl_users . ".id
       			JOIN " . tbl_profile . " ON " . tbl_friends . ".friend_id = " . tbl_profile . ".user_id
        		WHERE " . tbl_friends . ".user_id =  " . $userid . " AND " . tbl_friends . ".verified = '1'";
		$friends = $db->fetch_array($sql);

		return $friends;
		
	}
	
	function checkIsFriend($friendid, $userid) {
		$db = Database::obtain();
		
		$sql = "SELECT friend_id
				FROM " . tbl_friends . "
				WHERE friend_id = " . (int)$friendid . " AND user_id = " . (int)$userid;
		
		$pid = $db->query_first($sql);
		
		if ($pid > 0)
		{
			return true;
		}
		
		return false;
		
	}
	
	function checkAlreadyVerified($userid, $friendid) {
		$db = Database::obtain();
		
		$sql = "SELECT user_id, friend_id
				FROM " . tbl_friends . "
				WHERE friend_id = " . (int)$friendid . " AND user_id = " . (int)$userid . " AND verified='1'";
		
		$pid = $db->query_first($sql);
		
		if ($pid > 0)
		{
			return true;
		}
		
		return false;	
	}

	function checkAlreadyIgnored($userid, $friendid) {
		$db = Database::obtain();
		
		$sql = "SELECT friend_id
				FROM " . tbl_friends . "
				WHERE friend_id = " . (int)$friendid . " AND user_id = " . (int)$userid;
		
		$pid = $db->query_first($sql);
		
		if ($pid > 0)
		{
			return true;
		}
		
		return false;	
	}
	
	function sendFriendVerification($userid, $friendid) {
		$profile = new Profile;
		$user = $profile->get(intval($userid));	
		$friend = $profile->get(intval($friendid));
			
        $subject = "You have a new friend request over at LifeLitUp.com";
        $emailMsg = "Hi " . $friend["first_name"] . ",\n"
                ."" . $user["first_name"] . " " . $user["last_name"] . " wants to become your friend on LifeLitUp\n\n"
                ."If you know this person and want to confirm this friendship, then please click here:\n"
				."http://www.lifelitup.com/alpha/profile.php?action=confirmFriend&userid=" . $friend["user_id"] . "&friendid=" . $user["user_id"] . "\n\n"
                ."If you do not know this person or want to ignore this friend request, then click the link below:\n"
				."http://www.lifelitup.com/alpha/profile.php?action=ignoreFriend&userid=" . $friend["user_id"] . "&friendid=" . $user["user_id"] . "\n\n"
                ."Regards,\n"
                ."The LLU Team!";
                   
        $headers = 'From: no-reply@lifelitup.com' . "\r\n" .
                'Reply-To: no-reply@lifelitup.com' . "\r\n" .
                'X-Mailer: PHP/' . phpversion();
                
        mail($friend['email'], $subject, $emailMsg, $headers);
	}

	function verifyFriend($friendid, $userid) {
		$db = Database::obtain();
		
		if ($this->checkIsFriend($friendid, $userid) == false) {
			$msg = 'This person hasn\'t previously added you to their friends list.';
			return $msg;
		}
		
		if ($this->checkAlreadyVerified($userid, $friendid) == true) {
			$msg = 'This friendship has already been verified.';
			return $msg;
		}		
		
		$udata["verified"] = 1;
		$db->update(tbl_friends, $udata, "user_id=" . $userid ."");
		
		$fdata["user_id"] = $friendid;
		$fdata["friend_id"] = $userid;
		$fdata["date"] = time();
		$fdata["verified"] = 1;
		
		$pid = $db->insert(tbl_friends, $fdata);
		return $pid;
	}

	function ignoreFriend($friendid, $userid) {
		$db = Database::obtain();
		
		if ($this->checkAlreadyIgnored($userid, $friendid) == false) {
			$msg = 'This friendship has already been ignored.';
			return $msg;
		}
		
		if ($this->checkIsFriend($friendid, $userid) == false) {
			$msg = 'This person hasn\'t previously added you to their friends list.';
			return $msg;
		}
		
		if ($this->checkAlreadyVerified($userid, $friendid) == true) {
			$msg = 'This friendship has already been verified.';
			return $msg;
		}		
		
		$sql = "DELETE FROM " . tbl_friends . " WHERE user_id = " . $userid . " AND friend_id = " . $friendid;
		$row = $db->query($sql);
	
		return $row;		
	}
	
	function getFriendRequests($userid) {
		$db = Database::obtain();
		
		$sql = "SELECT " . tbl_friends . ".user_id, " . tbl_profile . ".first_name, " . tbl_profile . ".last_name
			FROM " . tbl_friends . "
			JOIN " . tbl_profile . " ON " . tbl_friends . ".user_id = " . tbl_profile . ".user_id
			WHERE " . tbl_friends . ".friend_id = " . $userid . " AND verified='0'";
		
		$requests = $db->fetch_array($sql);

		return $requests;
	}
}
?>