Symphony.

2009/08/24 13:31:36 > WARNING: 512 - MySQL Error (1146): Table 'sym_test.sym_entries_data_' doesn't exist in query "DELETE FROM sym_entries_data_ WHERE  `entry_id` = '123'" in file /Users/jnichols/Sites/sym-test/symphony/lib/toolkit/class.mysql.php on line 401

<?php

if (!defined('__IN_SYMPHONY__')) die('<h2>Symphony Error</h2><p>You cannot directly access this file</p>');

require_once(TOOLKIT . '/fields/field.input.php');

Class fieldColorChooser extends Field{

            function __construct(&$parent){
                parent::__construct($parent);
                $this->_name = 'Color Chooser';
                $this->_required = true;
                $this->set('required', 'no');
            }       

            function displaySettingsPanel(&$wrapper, $errors=NULL){
                parent::displaySettingsPanel($wrapper, $errors);

                $this->appendRequiredCheckbox($wrapper);
                $this->appendShowColumnCheckbox($wrapper);
            }

            function displayPublishPanel(&$wrapper, $data=NULL, $flagWithError=NULL, $fieldnamePrefix=NULL, $fieldnamePostfix=NULL){

                //Waiting on documentation on how to efficiently add scripts to the admin area.
                //$this->_engine->Page->addScriptToHead(URL . '/extensions/color_chooser_field/assets/farbtastic.js', 180);
                //$this->_engine->Page->addScriptToHead(URL . '/extensions/color_chooser_field/assets/color-chooser.js', 185);
                //$this->_engine->Page->addStylesheetToHead(URL . '/extensions/color_chooser_field/assets/farbtastic.css', 'screen', 190);

                $value = $data['value'];        
                $label = Widget::Label($this->get('label'));
                $label->setAttribute('class', 'color-chooser');
                if($this->get('required') != 'yes') $label->appendChild(new XMLElement('i', 'Optional'));
                $label->appendChild(Widget::Input('fields'.$fieldnamePrefix.'['.$this->get('element_name').']'.$fieldnamePostfix, (strlen($value) != 0 ? $value : '#')));

                if($flagWithError != NULL) $wrapper->appendChild(Widget::wrapFormElementWithError($label, $flagWithError));
                else $wrapper->appendChild($label);
            }

            function checkPostFieldData($data, &$message, $entry_id=NULL){
                $message = NULL;

                if($this->get('required') == 'yes' && strlen($data) == 0 ){
                    $message = "This is a required field.";
                    return self::__MISSING_FIELDS__;
                }
                // The Farbtastic needs a value in the field to work. '#' is the default value placed by the js.
                if($this->get('required') == 'yes' && $data == "#" ){
                    $message = "This is a required field.";
                    return self::__MISSING_FIELDS__;
                }
                // Make sure the value entered is a valid hex color, '#' or '' is OK
                if($data !== '#' && strlen($data) !== 0 ){
                    if(!preg_match("/^#[0-9a-f]{6}$/i" , $data)){
                        $message = "This is not a valid 6 character hex color value.";
                        return self::__MISSING_FIELDS__;
                    }
                }

                return self::__OK__;

            }       

        }

    ?>

function isSortable(){
                return true;
            }

            function canFilter(){
                return true;
            }

            function allowDatasourceOutputGrouping(){
                return true;
            }

            function allowDatasourceParamOutput(){
                return true;
            }

function createTable(){

    return Symphony::Database()->query(

        "CREATE TABLE IF NOT EXISTS `sym_entries_data_" . $this->get('id') . "` (
          `id` int(11) unsigned NOT NULL auto_increment,
          `entry_id` int(11) unsigned NOT NULL,
          `handle` varchar(255) default NULL,
          `value` varchar(255) default NULL,
          PRIMARY KEY  (`id`),
          KEY `entry_id` (`entry_id`),
          KEY `handle` (`handle`),
          KEY `value` (`value`)
        ) TYPE=MyISAM;"

    );
}

class fieldColorChooser extends fieldInput { }