<?php
/**
 * Gforge group_join_request Facility
 *
 * Copyright 2005 (c) GForge Group
 *
 * @version   $Id: GroupJoinRequest.class 4384 2005-05-20 19:16:26Z marcelo $
 *
 * This file is part of Gforge.
 *
 * Gforge is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * Gforge distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Gforge; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  US
 */

require_once('common/include/Error.class');
require_once('common/include/Validator.class');

/*
function &groupjoinrequest_get_object($group_id,$user_id,$data=false) {
	global $GROUPJOINREQUEST_OBJ;
	if (!isset($GROUPJOINREQUEST_OBJ["_".$group_id."_".$user_id."_"])) {
		if ($data) {
			//the db result handle was passed in
		} else {
			$res=db_query("SELECT * FROM group_join_request
				WHERE group_id='$group_id' AND user_id='$user_id'");

			if (db_numrows($res) <1 ) {
				$GROUPJOINREQUEST_OBJ["_".$group_id."_".$user_id."_"]=false;
				return false;
			}
			$data =& db_fetch_array($res);

		}
		$grp =& group_get_object($group_id);
		$GROUPJOINREQUEST_OBJ["_".$group_id."_".$user_id."_"]= new GroupJoinRequest($grp,$user_id,$data);

	}

	return $GROUPJOINREQUEST_OBJ["_".$group_id."_".$user_id."_"];
}
*/
function &get_group_join_requests($Group) {
	if (!$Group || !is_object($Group) || $Group->isError()) {
		return false;
	} else {
		$res=db_query("SELECT * FROM group_join_request WHERE group_id='".$Group->getID()."'");
		while ($arr = db_fetch_array($res)) {
			$reqs[] = new GroupJoinRequest($Group,$arr['user_id'],$arr);
		}
		return $reqs;
	}
}

class GroupJoinRequest extends Error {

	/**
	 * Associative array of data from db.
	 *
	 * @var  array   $data_array.
	 */
	var $data_array;

	var $Group;
	/**
	 *  Constructor.
	 *
	 *  @param  Group 	The Group object.
	 *  @param  int 	The user_id.
	 *  @param  array 	The associative array of data.
	 *  @return boolean success.
	 */
	function GroupJoinRequest($Group=false, $user_id=false, $arr=false) {
		$this->error(); 

		if (!$Group || !is_object($Group)) {
			$this->setError('GroupJoinRequest:: No Valid Group Object');
				return false;
		}
		if ($Group->isError()) {
			$this->setError('GroupJoinRequest:: '.$Group->getErrorMessage());
				return false;
		}
		$this->Group =& $Group;
		if ($user_id) {
			if (!$arr || !is_array($arr)) {
				if (!$this->fetchData($group_id,$user_id)) {
					return false;
				}
			} else {
				$this->data_array =& $arr;
				//
				//      Verify this message truly belongs to this Group
				//
				if ($this->data_array['group_id'] != $this->Group->getID()) {
					$this->setError('group_id in db result does not match Group Object');
					return false;
				}
			} 
		}
		return true;
	}

	/**
	 * create - create a new GroupJoinRequest in the database.
	 *
	 *	@param	int4 user_id.
	 *	@param	text comments.
	 *	@param	int4 request_date.
	 * @return boolean Success.
	 */
	function create($user_id,$comments) {
		global $Language;
		
		$v = new Validator();
		$v->check($user_id, "user_id");
		//$v->check($comments, "comments");
		if (!$v->isClean()) {
			$this->setError($v->formErrorMsg("Must include "));
			return false;
		}

		// Check if user is already a member of the project
		$perm =& $this->Group->getPermission( user_get_object($user_id) );
		if ($perm && is_object($perm) && $perm->isMember()) {
			$this->setError($Language->getText('project_joinrequest','already_member'));
			return false;
		}

		// Check if user has already submitted a request
		$sql = "SELECT * FROM group_join_request WHERE group_id='".$this->Group->getID()."' AND user_id='".$user_id."'";
		$result = db_query($sql);
		if (db_numrows($result)) {
			$this->setError($Language->getText('project_joinrequest','already_requested'));
			return false;
		}

		db_begin();

		$sql="INSERT INTO group_join_request (group_id,user_id,comments,request_date)
			VALUES ('".$this->Group->getID()."','".$user_id."',
			'".addslashes(htmlspecialchars($comments))."','".time()."')";
		$result=db_query($sql);
		if (!$result || db_affected_rows($result) < 1) {
			$this->setError('GroupJoinRequest::create() Posting Failed '.db_error());
			db_rollback();
			return false;
		} else {
			if (!$this->fetchData($group_id,$user_id)) {
				db_rollback();
				return false;
			} else {
				$this->sendJoinNotice();
				db_commit();
				return true;
			}
		}
	}

    /**
	 *  fetchData - re-fetch the data for this GroupJoinRequest from the database.
	 *
	 *  @param  int  The group_id.
	 *  @param  int  The user_id.
	 *  @return     boolean success.
	 */
	function fetchData($group_id,$user_id) {
	        $res=db_query("SELECT * FROM group_join_request
	                WHERE
					user_id='$user_id'
	        		AND group_id='". $this->Group->getID() ."'");
	        if (!$res || db_numrows($res) < 1) {
	                $this->setError('GroupJoinRequest::fetchData() Invalid ID '.db_error());
	                return false;
			}
	        $this->data_array =& db_fetch_array($res);
	        db_free_result($res);
	        return true;
	}

	/**
	 *      getID - get this GroupJoinRequest ID
	 *
	 *      @return int The group_id.
	 * /
	function getID() {
		return $this->data_array['group_id'];
	}

	/**
	 *      getGroup - get the group object.
	 *
	 *      @return Group The Group.
	 */
	function &getGroup() {
		return $this->Group;
	}

	/**
	 *      getUserId - get the field user_id.
	 *
	 *      @return int4 The field.
	 */
	function getUserId() {
		return $this->data_array['user_id'];
	}

	/**
	 *      getComments - get the field comments.
	 *
	 *      @return text The field.
	 * /
	function getComments() {
		return $this->data_array['comments'];
	}

	/**
	 *      getRequestDate - get the field request_date.
	 *
	 *      @return int4 The field.
	 */
	function getRequestDate() {
		return $this->data_array['request_date'];
	}

	/**
	 *	sendJoinNotice() - 
	 *
	 *	@return boolean	true/false.
	 */
	function sendJoinNotice() {
		global $Language;
		$user =& session_get_user();
		$admins =& $this->Group->getAdmins();
		for ($i=0; $i<count($admins); $i++) {
			$emails[]=$admins[$i]->getEmail();
		}
		$email=implode($emails,',');
		$subject = $Language->getText('project_joinrequest','join_notice_subject',array($this->Group->getPublicName()));
		$comments = util_unconvert_htmlspecialchars($this->data_array["comments"]);
		$body = $Language->getText('project_joinrequest','join_notice_body',array($user->getRealName(),$GLOBALS['sys_default_domain'],$this->Group->getId(),$comments));
		$body = str_replace("\\n","\n",$body);

		return util_send_message($email,$subject,$body);
	}

	/**
	 *	reject()
	 *
	 *	@return	boolean	success.
	 */
	function reject() {
		global $Language;
		$user =& user_get_object($this->getUserId());
		$subject = $Language->getText('project_joinrequest','join_notice_subject',array($this->Group->getPublicName()));
		$body = $Language->getText('project_joinrequest','denied',array($this->Group->getPublicName()));
		util_send_message($user->getEmail(),$subject,$body);
		return $this->delete(1);
	}

	/**
	 *	delete() - delete this row from the database.
	 *
	 *	@param	boolean	I'm Sure.
	 *	@return	boolean	true/false.
	 */
	function delete($sure) {
		if (!$sure) {
			$this->setError('Must be sure before deleting');
			return false;
		}
		$perm =& $this->Group->getPermission( session_get_user() );
		if (!$perm || !is_object($perm)) {
			$this->setPermissionDeniedError();
			return false;
		} elseif ($perm->isError()) {
			$this->setPermissionDeniedError();
			return false;
		} elseif (!$perm->isAdmin()) {
			$this->setPermissionDeniedError();
			return false;
		} else {
			$res=db_query("DELETE FROM group_join_request WHERE 
				group_id='".$this->Group->getID()."' 
				AND user_id='".$this->getUserId()."'");
			if (!$res || db_affected_rows($res) < 1) {
				$this->setError('Could Not Delete: '.db_error());
			} else {
				return true;
			}
		}
	}
}

?>