classes/projects/projectCategory.class.php

<?php
/*******************************************************************************
 * Copyright (c) 2006 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *    Denis Roy (Eclipse Foundation)- initial API and implementation
 *    Nathan Gervais (Eclipse Foundation) - Expanded new fields being added
 *******************************************************************************/

require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/smartconnection.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
//require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/projects/project.class.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/classes/projects/category.class.php");

class ProjectCategory {

	#*****************************************************************************
	#
	# projectCategory.class.php
	#
	# Author: 	Denis Roy
	# Date:		2005-10-25
	#
	# Description: Functions and modules related to associations between a project and a category
	#
	# HISTORY:
	#
	#*****************************************************************************

	var $project_id;
	var $category_id;
	var $description;
	var $long_description;
	var $projectObject;
	var $categoryObject;


	# default constructor
	function projectCategory() {
		$this->project_id 		= "";
		$this->category_id		= "";
		$this->description 		= "";
		$this->long_description = "";
		$this->projectObject	= new Project();
		$this->categoryObject	= new Category();
	}
	
	function getProjectID() {
		return $this->project_id;
	}
	function getCategoryID() {
		return $this->category_id;
	}
	function getDescription() {
		return $this->description;
	}
	function getLongDescription() {
		return $this->long_description;
	}	
	function getProjectObject() {
		return $this->projectObject;
	}
	function getCategoryObject() {
		return $this->categoryObject;
	}
	 

	function setProjectID($_project_id) {
		$this->project_id = $_project_id;
	}
	function setCategoryID($_category_id) {
		$this->category_id = $_category_id;
	}
	function setDescription($_description) {
		$this->description = $_description;
	}
	function setLongDescription($_long_description) {
		$this->long_description = $_long_description;
	}	
	function setProjectObject($_Project) {
		$this->projectObject = $_Project;
	}
	function setCategoryObject($_Category) {
		$this->categoryObject = $_Category;
	}


	function deleteProjectCategory($_project_id, $_category_id) {
		
		$App = new App();
	
	    if($_project_id != "" && $_category_id != "") {
			$WHERE .= " WHERE project_id = " . $App->returnQuotedString($_project_id);
			$WHERE .= " AND category_id = " . $App->returnQuotedString($_category_id);
	
		
		    $sql = "DELETE
	        	FROM
					project_categories "
				. $WHERE;

		    $dbc = new DBConnectionRW();
		    $dbh = $dbc->connect();
		
		    $result = mysql_query($sql, $dbh);
		
		    $dbc->disconnect();
		    $dbh 	= null;
		    $dbc 	= null;
		    $result = null;
		    $myrow	= null;
	    }
	}

	function insertUpdateProjectCategory($_project_id, $_category_id, $_description) {
		
		$App = new App();
	
	    if($_project_id != "" && $_category_id != "") {
		
		    $sql = "INSERT INTO project_categories (
						project_id,
						category_id,
						description,
						long_description
						)
	        		VALUES (
					" . $App->returnQuotedString($_project_id) . ",
					" . $App->returnQuotedString($_category_id) . ",
					" . $App->returnQuotedString($_description) . ",
					" . $App->returnQuotedString($this->getLongDescription()). "
						)";

			# smart connection does not work here
			if (file_exists("/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php")) {
				require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php";
			}
		    $dbc = new DBConnectionRW();
		    $dbh = $dbc->connect();
		
		    $result = mysql_query($sql, $dbh);
		
		    $dbc->disconnect();
		    $dbh 	= null;
		    $dbc 	= null;
		    $result = null;
		    $myrow	= null;
	    }
	}

}
?>