<?
	class common_task_templates
	{						
		public function get_details($id)
		{			
			global $database;			
						
			$get_name = "
			SELECT *
			FROM workflow_tasks
			WHERE id = '$id'
			LIMIT 1
			";
			$value = $database->getRow($get_name);

			$value['creator'] = common_users::full_name($value['creator']);
			$value['submitter'] = common_users::full_name($value['submitter']);

	        $groups = common_ref_global_client::get_all_groups("groups");
	        $departments = common_department::get_all_department();			
			
			$value['departments'] = self::get_tasks_departments($id,$departments);					
			$value['groups'] = self::get_tasks_groups($id,$groups);									

			$value['approve_departments'] = self::get_tasks_approve_departments($id,$departments);					
			$value['approve_groups'] = self::get_tasks_approve_groups($id,$groups);	
																
			return $value;			
		}	

		public function get_tasks_departments($id,$departments)
		{
			global $database;
									
			$query = "
			SELECT department_id
			FROM workflow_tasks_departments
			WHERE template_id = '$id'
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['department_id']] = array("id" => $result['department_id'],"name" => $departments[$result['department_id']]['name']);	
			
			return $final_results;											
		}	

		public function get_tasks_groups($id,$groups)
		{
			global $database;
									
			$query = "
			SELECT group_id
			FROM workflow_tasks_groups
			WHERE template_id = '$id'
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['group_id']] = array("id" => $result['group_id'],"name" => $groups[$result['group_id']]['name']);	
			
			return $final_results;											
		}	

		public function get_tasks_approve_departments($id,$departments)
		{
			global $database;
									
			$query = "
			SELECT department_id
			FROM workflow_tasks_approve_departments
			WHERE template_id = '$id'
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['department_id']] = array("id" => $result['department_id'],"name" => $departments[$result['department_id']]['name']);	
			
			return $final_results;											
		}	

		public function get_tasks_approve_groups($id,$groups)
		{
			global $database;
									
			$query = "
			SELECT group_id
			FROM workflow_tasks_approve_groups
			WHERE template_id = '$id'
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['group_id']] = array("id" => $result['group_id'],"name" => $groups[$result['group_id']]['name']);	
			
			return $final_results;											
		}					
	}

?>