projecttask.class

GForge 3.0 协作开发平台 支持CVS, mailing lists, bug tracking, message boards/forums, task management, perman

		$project_task_id=$this->getID();

		$perm =& $this->ProjectGroup->Group->getPermission( session_get_user() );

		if (!$perm || !is_object($perm) || !$perm->isPMAdmin()) {
			$this->setPermissionDeniedError();
			return false;
		}

	}
*/

	/**
	 *	getOtherTasks - Return a result set of tasks in this subproject that do not equal
	 *	the current task_id.
	 *
	 *	@returns Database result set.
	 */
	function getOtherTasks () {
		//
		//	May not yet have an ID, if we are creating a NEW task
		//
		if ($this->getID()) {
			$addstr=" AND project_task_id <> '". $this->getID() ."' ";
		}
		$sql="SELECT project_task_id,summary 
		FROM project_task 
		WHERE group_project_id='". $this->ProjectGroup->getID() ."' 
		$addstr ORDER BY project_task_id DESC";
		return db_query($sql);
	}

	/**
	 *  getHistory - returns a result set of audit trail for this ProjectTask.
	 *
	 *  @return database result set.
	 */
	function getHistory() {
		$sql="SELECT * 
		FROM project_history_user_vw 
		WHERE project_task_id='". $this->getID() ."' 
		ORDER BY mod_date DESC";
		return db_query($sql);
	}

	/**
	 *  getMessages - get the list of messages attached to this ProjectTask.
	 *
	 *  @return database result set.
	 */
	function getMessages() {
		$sql="select * 
			FROM project_message_user_vw 
			WHERE project_task_id='". $this->getID() ."' ORDER BY postdate DESC";
		return db_query($sql);
	}

	/**
	 * addMessage - Handle the addition of a followup message to this task.
	 *
	 * @param	   string  The message.
	 * @returns	boolean	success.
	 */
	function addMessage($message) {
		$sql="INSERT INTO project_messages (project_task_id,body,posted_by,postdate) 
			VALUES ('". $this->getID() ."','". htmlspecialchars($message) ."','".user_getid()."','". time() ."')";
		$res=db_query($sql);
		if (!$res || db_affected_rows($res) < 1) {
			$this->setError('AddMessage():: '.db_error());
			return false;
		} else {
			return true;
		}
	}

	/**
	 * addHistory - Handle the insertion of history for these parameters.
	 *
	 * @param	string  The field name.
	 * @param	string  The old value.
	 * @returns	boolean	success.
	 */
	function addHistory ($field_name,$old_value) {
		$sql="insert into project_history(project_task_id,field_name,old_value,mod_by,mod_date) 
			VALUES ('". $this->getID() ."','$field_name','$old_value','".user_getid()."','".time()."')";
		$result=db_query($sql);
		if (!$result) {
			$this->setError('ERROR IN AUDIT TRAIL - '.db_error());
			return false;
		} else {
			return true;
		}
	}

	/**
	 * checkCircular - recursive function calls itself to look at all tasks you are dependent on.
	 *
	 * @param	int	The project_task_id you are dependent on.
	 * @param	int	The project_task_id you are checking circular dependencies for.
	 * @returns	boolean	success.
	 */
	function checkCircular($depend_on_id, $original_id) {
		global $Language;
		if ($depend_on_id == $original_id) {
			$this->setError($Language->getText('pm_projecttask','circular_dependency'));
	 		return false;
		}

		$res=db_query("SELECT is_dependent_on_task_id AS id 
			FROM project_dependencies 
			WHERE project_task_id='$depend_on_id'");
		$rows=db_numrows($res);

		for ($i=0; $i<$rows; $i++) {
			if (!$this->checkCircular(db_result($res,$i,'id'), $original_id)) {
				return false;
			}
		}
		return true;
	}

	/**
	 * setDependentOn - takes an array of project_task_id's and builds dependencies.
	 *
	 * @param	array	The array of project_task_id's.
	 * @returns	boolean	success.
	 */
	function setDependentOn(&$arr) {
//
//	IMPORTANT - MUST VERIFY NO CIRCULAR DEPENDENCY!! 
//
		//get existing dependencies to diff against
		$arr2 =& $this->getDependentOn();
		$this->dependon =& $arr2;

		if (count($arr) || count($arr2)) {
			$add_arr = array_diff ($arr, $arr2);
			$del_arr = array_diff ($arr2, $arr);
			for ($i=0; $i<count($del_arr); $i++) {
				db_query("DELETE FROM project_dependencies 
					WHERE project_task_id='".$this->getID()."'
					AND is_dependent_on_task_id='". $del_arr[$i] ."'");
				if (db_error()) {
					$this->setError('setDependentOn()-1:: '.db_error());
					return false;
				}
			}
			for ($i=0; $i<count($add_arr); $i++) {
				//
				//	Check task for circular dependencies
				//
				if (!$this->checkCircular($add_arr[$i],$this->getID())) {
					return false;
				}
				db_query("INSERT INTO project_dependencies (project_task_id,is_dependent_on_task_id) 
					VALUES ('".$this->getID()."','". $add_arr[$i] ."')");
				if (db_error()) {
					$this->setError('setDependentOn()-2:: '.db_error());
					return false;
				}
			}
			return true;
		} else {
			return true;
		}
	}

	/**
	 *	getDependentOn - get an array of project_task_id's that you are dependent on.
	 *
	 *	@return	array	The array of project_task_id's.
	 */
	function &getDependentOn() {
		if (!$this->getID()) {
			return array();
		}
		if (!$this->dependon) {
			$this->dependon =& util_result_column_to_array(db_query("SELECT is_dependent_on_task_id 
				FROM project_dependencies 
				WHERE project_task_id='".$this->getID()."'"));
		}
		return $this->dependon;
	}

	/**
	 * setAssignedTo - takes an array of user_id's and builds assignments.
	 *
	 * @param	array	The array of user_id's.
	 * @returns	boolean	success.
	 */
	function setAssignedTo(&$arr) {
		$arr2 =& $this->getAssignedTo();
		$this->assignedto =& $arr2;

		//If no one is assigned, then assign it to "100" - NOBODY
		if (count($arr) < 1 || ((count($arr)==1) && ($arr[0]==''))) {
			$arr=array('100');
		}
		if (count($arr) || count($arr2)) {
			$add_arr = array_diff ($arr, $arr2);
			$del_arr = array_diff ($arr2, $arr);
			for ($i=0; $i<count($del_arr); $i++) {
				db_query("DELETE FROM project_assigned_to
					WHERE project_task_id='".$this->getID()."'
					AND assigned_to_id='". $del_arr[$i] ."'");
				if (db_error()) {
					$this->setError('setAssignedTo()-1:: '.db_error());
					return false;
				}
			}
			for ($i=0; $i<count($add_arr); $i++) {
				db_query("INSERT INTO project_assigned_to (project_task_id,assigned_to_id) 
					VALUES ('".$this->getID()."','". $add_arr[$i] ."')");
				if (db_error()) {
					$this->setError('setAssignedTo()-2:: '.db_error());
					return false;
				}
			}
			return true;
		} else {
			return true;
		}
	}

	/**
	 *	getAssignedTo - get an array of user_id's that you are assigned to.
	 *
	 *	@return	array	The array of user_id's.
	 */
	function &getAssignedTo() {
		if (!$this->getID()) {
			return array();
		}
		if (!$this->assignedto) {
			$this->assignedto =& util_result_column_to_array(db_query("SELECT assigned_to_id 
				FROM project_assigned_to 
				WHERE project_task_id='".$this->getID()."'"));
		}
		return $this->assignedto;
	}

	/**
	 *	update - update this ProjectTask in the database.
	 *
	 *	@param	string	The summary of this task.
	 *	@param	string	The detailed description of this task.
	 *	@param	int	The Priority of this task.
	 *	@param	int	The Hours estimated to complete this task.
	 *	@param	int	The (unix) start date of this task.
	 *	@param	int	The (unix) end date of this task.
	 *	@param	int	The status_id of this task.
	 *	@param	int	The category_id of this task.
	 *	@param	int	The percentage of completion in integer format of this task.
	 *	@param	array	An array of user_id's that are assigned this task.
	 *	@param	array	An array of project_task_id's that this task depends on.
	 *	@return	boolean success.
	 */
	function update($summary,$details,$priority,$hours,$start_date,$end_date,
		$status_id,$category_id,$percent_complete,&$assigned_arr,&$depend_arr) {
                $v = new Validator();
                $v->check($summary, "summary");
                $v->check($priority, "priority");
                $v->check($hours, "hours");
                $v->check($start_date, "start date");
                $v->check($end_date, "end date");
                $v->check($status_id, "status");
                $v->check($category_id, "category");
                if (!$v->isClean()) {
                        $this->setError($v->formErrorMsg("Must include "));
                        return false;
                }

		$perm =& $this->ProjectGroup->Group->getPermission( session_get_user() );

		if (!$perm || !is_object($perm) || !$perm->isPMAdmin()) {
			$this->setPermissionDeniedError();
			return false;
		}

		db_begin();
		if ($details) {
			if (!$this->addMessage($details)) {
				db_rollback();
				return false;
			}
		}
		if ($this->getStatusID() != $status_id)
			{ $this->addHistory ('status_id',$this->getStatusID());  }

		if ($this->getCategoryID() != $category_id)
			{ $this->addHistory ('category_id',$this->getCategoryID());  }

		if ($this->getPriority() != $priority)
			{ $this->addHistory ('priority',$this->getPriority());  }

		if ($this->getSummary() != htmlspecialchars(stripslashes($summary)))
			{ $this->addHistory ('summary',addslashes($this->getSummary()));  }

		if ($this->getPercentComplete() != $percent_complete)
			{ $this->addHistory ('percent_complete',$this->getPercentComplete()); }

		if ($this->getHours() != $hours)
			{ $this->addHistory ('hours',$this->getHours());  }

		if ($this->getStartDate() != $start_date)
			{ $this->addHistory ('start_date',$this->getStartDate());  }

		if ($this->getEndDate() != $end_date)
			{ $this->addHistory ('end_date',$this->getEndDate());  }
		if (!$this->setDependentOn($depend_arr)) {
			db_rollback();
			return false;
		} elseif (!$this->setAssignedTo($assigned_arr)) {
			db_rollback();
			return false;
		} else {
			$sql="UPDATE project_task SET
				summary='".htmlspecialchars($summary)."',
				priority='$priority',
				hours='$hours',
				start_date='$start_date',
				end_date='$end_date',
				status_id='$status_id',
				percent_complete='$percent_complete',
				category_id='$category_id'
				WHERE group_project_id='".$this->ProjectGroup->getID()."'
				AND project_task_id='".$this->getID()."'";

			$res=db_query($sql);
			if (!$res || db_affected_rows($res) < 1) {
				$this->setError('Error On Update: '.db_error());
				db_rollback();
				return false;
			} else {
				if (!$this->fetchData($this->getID())) {
					return false;
				} else {
					$this->sendNotice();
					db_commit();
					return true;
				}
			}
		}

	}

	/**
	 *	sendNotice - contains the logic for sending email/jabber updates.
	 *
	 *	@return	boolean	success.
	 */
	function sendNotice($first=false) {
		$ids =& $this->getAssignedTo();

		//
		//	See if there is anyone to send messages to
		//
		if (count($ids) < 1 && !$this->ProjectGroup->getSendAllPostsTo()) {
			return true;
		}

		$body = "Task #". $this->getID() ." has been updated. ".
			"\n\nProject: ". $this->ProjectGroup->Group->getPublicName() .
			"\nSubproject: ". $this->ProjectGroup->getName() .
			"\nSummary: ".util_unconvert_htmlspecialchars( $this->getSummary() ).
			"\nComplete: ". $this->getPercentComplete() ."%".
			"\nStatus: ". $this->getStatusName() .
			"\n\nDescription: ". util_unconvert_htmlspecialchars( $this->getDetails() );

		/*
			Now get the followups to this task
		*/
		$result2=$this->getMessages();

		$rows=db_numrows($result2);

		if ($result2 && $rows > 0) {
			$body .= "\n\nFollow-Ups:";
			for ($i=0; $i<$rows;$i++) {
				$body .= "\n\n-------------------------------------------------------";
				$body .= "\nDate: ". date($GLOBALS['sys_datefmt'],db_result($result2,$i,'postdate'));
				$body .= "\nBy: ".db_result($result2,$i,'user_name');
				$body .= "\n\nComment:\n".util_unconvert_htmlspecialchars(db_result($result2,$i,'body'));
			}
		}
		$body .= "\n\n-------------------------------------------------------".
			"\nFor more info, visit:".
			"\n\nhttp://$GLOBALS[sys_default_domain]/pm/task.php?func=detailtask&project_task_id=".
				$this->getID() ."&group_id=".
				$this->ProjectGroup->Group->getID() ."&group_project_id=". $this->ProjectGroup->getID();

		$subject="[Task #". $this->getID() .'] '.
			util_unconvert_htmlspecialchars( $this->getSummary() );

		util_handle_message(array_unique($ids),$subject,$body,$this->ProjectGroup->getSendAllPostsTo());
		return true;
	}

}

?>