File Source for DEnum.inc

<?php
require_once $config->get('sysRoot').'alpha/model/types/AlphaTypeInterface.inc';
/**
* The DEnum (Dynamic Enum) complex data type. Similiar to Enum,
* except list items are stored in a database table and are editable.
*
* @package alpha::model::types
* @since 1.0
* @author John Collins <dev@alphaframework.org>
* @version $Id: DEnum.inc 1341 2011-03-17 15:02:02Z johnc $
* @license http://www.opensource.org/licenses/bsd-license.php The BSD License
* @copyright Copyright (c) 2011, John Collins (founder of Alpha Framework).
* All rights reserved.
*
* <pre>
* Redistribution and use in source and binary forms, with or
* without modification, are permitted provided that the
* following conditions are met:
*
* * Redistributions of source code must retain the above
* copyright notice, this list of conditions and the
* following disclaimer.
* * Redistributions in binary form must reproduce the above
* copyright notice, this list of conditions and the
* following disclaimer in the documentation and/or other
* materials provided with the distribution.
* * Neither the name of the Alpha Framework nor the names
* of its contributors may be used to endorse or promote
* products derived from this software without specific
* prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND
* CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
* INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
* MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
* NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
* HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
* OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
* </pre>
*
*/
class DEnum extends AlphaDAO implements AlphaTypeInterface{
/**
* An array of valid DEnum options
*
* @var array
* @since 1.0
*/
protected $options;
/**
* The currently selected DEnum option
*
* @var integer
* @since 1.0
*/
protected $value;
/**
* The name of the DEnum used in the database
*
* @var String
* @since 1.0
*/
protected $name;
/**
* The name of the database table for the class
*
* @var string
* @since 1.0
*/
const TABLE_NAME = 'DEnum';
/**
* An array of data display labels for the class properties
*
* @var array
* @since 1.0
*/
protected $dataLabels = array("OID"=>"DEnum ID#","name"=>"Name");
/**
* The message to display to the user when validation fails
*
* @var string
* @since 1.0
*/
protected $helper = 'Not a valid denum option!';
/**
* Constructor that sets up the DEnum options
*
* @param String $name
*/
public function __construct($name=null) {
// ensure to call the parent constructor
parent::__construct();
$this->markTransient('options');
$this->markTransient('value');
$this->markTransient('helper');
$this->name = new String($name);
if(isset($name)) {
try {
$this->loadByAttribute('name',$name);
}catch(BONotFoundException $e) {
// DEnum does not exist so create it
$this->save();
}
$this->getOptions();
}
}
/**
* Setter for the name of the DEnum used in the database
*
* @param string $name
* @since 1.0
*/
public function setName($name) {
$this->name->setValue($name);
}
/**
* Get the array of DEnum options from the database
*
* @param boolean $alphaSort
* @return array
* @since 1.0
* throws AlphaException
*/
public function getOptions($alphaSort = false) {
$sqlQuery = 'SELECT * FROM '.self::TABLE_NAME.' WHERE name = \''.$this->name->getValue().'\';';
$this->lastQuery = $sqlQuery;
if(!$result = AlphaDAO::getConnection()->query($sqlQuery)) {
throw new AlphaException('Failed to load DEnum '.$this->name->getValue().', not found in database.');
}
// now build an array of item indexes to be returned
$row = $result->fetch_array(MYSQLI_ASSOC);
$count = 0;
$this->options = array();
$tmp = new DEnumItem();
foreach($tmp->loadItems($row["OID"]) as $DEnumItem) {
$this->options[$DEnumItem->getID()] = $DEnumItem->getValue();
$count++;
}
if($alphaSort)
asort($this->options, SORT_STRING);
return $this->options;
}
/**
* Getter for the validation helper string
*
* @return string
* @since 1.0
*/
public function getHelper() {
return $this->helper;
}
/**
* Set the validation helper text
*
* @param string $helper
* @since 1.0
*/
public function setHelper($helper) {
$this->helper = $helper;
}
/**
* Getter for the name
*
* @return String
* @since 1.0
*/
public function getName() {
return $this->name;
}
/**
* Used to get the current DEnum item selected index value
*
* @return integer
* @since 1.0
*/
public function getValue() {
return $this->value;
}
/**
* Used to get the current DEnum item string value
*
* @return string
* @since 1.0
*/
public function getDisplayValue() {
// check to see if the options have already been loaded from the DB
if(empty($this->options))
$this->getOptions();
$val = Integer::zeroPad($this->value);
if(isset($this->options[$val]))
return $this->options[$val];
else
return 'Unknown';
}
/**
* Used to select the current DEnum item
*
* @param string $item
* @since 1.0
*/
public function setValue($item) {
// check to see if the options have already been loaded from the DB
if(empty($this->options))
$this->getOptions();
// confirm that the item ID provided is a valid key for the options array
if (in_array($item, array_keys($this->options))) {
$this->value = $item;
}else{
throw new IllegalArguementException($this->getHelper());
}
}
/**
* Gets the count from the database of the DEnumItems associated with this object
*
* @return integer
* @since 1.0
* @throws AlphaException
*/
public function getItemCount() {
$sqlQuery = 'SELECT COUNT(OID) AS item_count FROM DEnumItem WHERE DEnumID = \''.$this->getID().'\';';
$this->lastQuery = $sqlQuery;
if(!$result = AlphaDAO::getConnection()->query($sqlQuery)) {
throw new AlphaException('Failed to get the item count for the DEnum.');
}
$row = $result->fetch_array(MYSQLI_ASSOC);
if (isset($row['item_count'])) {
return $row['item_count'];
}else{
throw new AlphaException('Failed to get the item count for the DEnum. Database error string is ['.AlphaDAO::getConnection()->error.']');
}
}
/**
* Used to get the DenumItem ID for the given option name
*
* @param string $optionName
* @return integer
* @since 1.0
*/
public function getOptionID($optionName) {
$denumItem = new DEnumItem();
$denumItem->loadByAttribute('value', $optionName);
$id = $denumItem->getID();
if(!empty($id))
return $id;
else
return 0;
}
/**
* Used to convert the object to a printable string
*
* @return string
* @since 1.0
*/
public function __toString() {
return strval($this->value);
}
}
?>

	alpha--model--types

[ class tree: alpha--model--types ] [ index: alpha--model--types ] [ all elements ]

Source for file DEnum.inc