eclipse.org-common/classes/projects/categoryList.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("category.class.php");
require_once(realpath(dirname(__FILE__) . "/../../system/app.class.php"));

class CategoryList {

	#*****************************************************************************
	#
	# CategoryList.class.php
	#
	# Author: 	Denis Roy
	# Date:		2005-10-25
	#
	# Description: Functions and modules related Lists of categories (for projects)
	#
	# HISTORY:
	#
	#*****************************************************************************

	var $list = array();


	function getList() {
		return $this->$list;
	}

	function setList($_list) {
		$this->list = $_list;
	}


    function add($_project) {
            $this->list[count($this->list)] = $_project;
    }


    function getCount() {
            return count($this->list);
    }

    function getItemAt($_pos) {
            if($_pos < $this->getCount()) {
                    return $this->list[$_pos];
            }
    }

	function selectCategoryList() {

		$App = new App();
	    $WHERE = "";

	    $sql = "SELECT
					CAT.category_id,
					CAT.description,
					CAT.image_name,
					CAT.category_shortname
	        	FROM
					categories AS CAT
				ORDER BY CAT.description ";

	    $result = $App->eclipse_sql($sql);

	    while($myrow = mysql_fetch_array($result)) {

	            $Category = new Category();
	            $Category->setCategoryID	($myrow["category_id"]);
	            $Category->setDescription	($myrow["description"]);
	            $Category->setImageName		($myrow["image_name"]);
	            $Category->setCategoryShortname ($myrow["category_shortname"]);
	            $this->add($Category);
	    }

	    $result = null;
	    $myrow	= null;
	}
}
?>