blob: 58f0ffe1d05be018ad3c5a1d5b74ac4ed5114524 [file] [log] [blame]
<?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(realpath(dirname(__FILE__) . "/../../system/app.class.php"));
require_once("project.class.php");
require_once("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 __construct() {
$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;
$result = $App->eclipse_sql($sql);
$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()). "
)";
$result = $App->eclipse_sql($sql);
$result = null;
$myrow = null;
}
}
}
?>