<?
	class common_quote_tasks
	{						
		public function get_all_quote_tasks()
		{			
			global $database;
			
			$current_date = date('Y-m-d');
			
			//$database->debug = true;
			
			$get_all_quote_tasks = "
			SELECT *
			FROM quotes_tasks
			";
			$all_quote_tasks = $database->getAll($get_all_quote_tasks);
			
			return $all_quote_tasks;			
		}		
		
		public function get_all_quote_tasks_by_status($status)
		{			
			global $database;
			
			$current_date = date('Y-m-d');
			
			//$database->debug = true;
			
			$get_all_quote_tasks = "
			SELECT *
			FROM quotes_tasks
			WHERE status = '$status'
			";
			$all_quote_tasks = $database->getAll($get_all_quote_tasks);
			
			return $all_quote_tasks;			
		}	
		
		public function get_all_quote_tasks_by_status_and_quote($status,$quote_id)
		{			
			global $database;
			
			$current_date = date('Y-m-d');
			
			//$database->debug = true;
			
			$get_all_quote_tasks = "
			SELECT *
			FROM quotes_tasks
			WHERE status = '$status'
				AND quote_id = '$quote_id'
			";
			$all_quote_tasks = $database->getAll($get_all_quote_tasks);
			
			return $all_quote_tasks;			
		}		
			
		public function get_quote_tasks($id)
		{			
			global $database;
			
			//$database->debug = true;
			
			$get_quote_tasks = "
			SELECT *
			FROM quotes_tasks
			WHERE id='$id'
			";
			$quote_tasks = $database->getRow($get_quote_tasks);
			
			return $quote_tasks;			
		}										
	}
?>