<?PHP
/**
 * patTemplate modfifier Locale
 *
 * $Id$
 *
 * @package     patTemplate
 * @package     Modifiers
 * @author      gERD Schaufelberger <gerd@php-tools.net>
 */

/**
 * patTemplate modifier Locale
 * 
 * Load column from database. The value should be the table's primary key
 *
 * Parameter:
 *  - table, name of table to load from
 *  - column, which column to display
 *
 * @package     patTemplate
 * @package     Modifiers
 * @author      gERD Schaufelberger <gerd@php-tools.net>
 */
class patTemplate_Modifier_Data extends patTemplate_Modifier
{
   /**
    * shared table object
    * @var WBDatasource_Table
    */
    static protected $_table    =   null;

   /**
    * modify the value
    *
    * @access   public
    * @param    string      value
    * @return   string      modified value
    */
    public function modify($value, $params = array())
    {
        if (!isset($params['table']) || !isset($params['column'])) {
            return $value;
        }

        if (0 == intval($value)) {
            return '';
        }

        $table  =   $params['table'];
        $id     =   $value;
        $opt    =   array();
        if (isset($params['deleted']) && 0 < $params['deleted']) {
            $opt['deleted'] =   1;
        }

        // load table object
        if( !self::$_table ) {
            self::$_table  =   WBClass::create( 'WBDatasource_Table' );
        }

        $list   =   self::$_table->get($table, $id, null, array(), $opt);
        if (empty($list)) {
            return '';
        }

        return $list[0][$params['column']];
    }
}