<?php
/**
 * File: departments.php
 *
 * Staff Master 0_7_5_5
 *
 * Staff Master - Staff Members and Departments Manager
 *
 * @version 0.7.5.5
 * @package StaffMaster_0_7_5_5
 * @subpackage: models
 * @copyright (C) 2007-2008 Travis Hubbard
 * @license http://www.gnu.org/licenses/  GNU/GPL v3
 * @link http://www.systemsunited.net/
 **/
defined( '_JEXEC' ) or die( 'Restricted access' );

jimport( 'joomla.application.component.model' );

/**
 * Staff Departments Model Class
 * @package StaffMaster_0_7_0_4
 */
class StaffModelDepartments extends JModel  {

   /**
	* Holds staff departments
	*
	* @access private
	* @var stdObj
	*/
	var $_staff_departments = null;

	/**
	* Holds single department
	*
	* @access private
	* @var stdObj
	*/
	var $_staff_department  = null;

   /**
	* getList : returns all published staff departments
	*
	* @return mixed
	*/
	function getList()  {

		if( !$this->_staff_departments )  {

			$query = "SELECT * FROM #__staff_departments WHERE published = '1' ORDER BY ordering";

			$this->_staff_departments = $this->_getList($query, 0, 0);

		}

		return $this->_staff_departments;

	}

   /**
	* getOne : returns one staff department by ID if it is published
	*
	* @param 	int
	* @return 	mixed
	*/
	function getOne( $id )  {

		if(!$this->_staff_departments)  {

			$query = "SELECT * FROM #__staff_departments WHERE id = $id AND published = '1' ";

			$this->_db->setQuery( $query , 0 , 1 );

			$this->_staff_departments = $this->_db->loadObject();

		}

		return $this->_staff_departments;

	}

   /**
	* getOneByAlias : returns one staff department by alias if it is published
	*
	* @param 	int
	* @return 	mixed
	*/
	function getOneByAlias( $alias )  {

		if(!$this->_staff_departments)  {

			$query = "SELECT * FROM #__staff_departments WHERE alias = '{$alias}' AND published = '1' ";

			$this->_db->setQuery( $query , 0 , 1 );

			$this->_staff_departments = $this->_db->loadObject();

		}

		return $this->_staff_departments;

	}
}
?>