common/project.class.php

<?php

require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/projects/project.class.php");

class Project_Project extends Project {

	#*****************************************************************************
	#
	# project.class.php
	#
	# Author: 	Denis Roy
	# Date:		2004-11-16
	#
	# Description: Functions and modules related to the MySQL database connection
	#
	# HISTORY:
	# 25/01/2006: Added is_archived, SetIsArchived() and getIsArchived()
	#
	#*****************************************************************************

	var $is_archived		= 0;
	
	function getIsArchived(){
		return $this->is_archived;
	}
	
	function setIsArchived($_is_archived){
		$this->is_archived = $_is_archived;
	}

	function selectList($_project_id) {
		parent::selectList($_project_id);
				
		$App = new App();
	    $WHERE = "";
	
	    if($_project_id != "") {
	
		    $dbc = new DBConnection();
		    $dbh = $dbc->connect();
		   
				$WHERE .= " WHERE PRJ.project_id = " . $App->returnQuotedString($_project_id);
				$sql = "SELECT 
							PRJ.is_active
			        	FROM
							projects AS PRJ "
						. $WHERE;

			$result = mysql_query($sql, $dbh);
	
			if($myrow = mysql_fetch_array($result)) {		    		
				$this->setIsArchived	($myrow["is_active"]);
		    }
		    
		    $dbh 	= null;
		    $dbc 	= null;
		    $result = null;
		    $myrow	= null;

	    }
	}

}
?>