Dataface/Serializer.php

Go to the documentation of this file.

<?php
/*-------------------------------------------------------------------------------
 * Xataface Web Application Framework
 * Copyright (C) 2005-2008 Web Lite Solutions Corp (shannah@sfu.ca)
 * 
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *-------------------------------------------------------------------------------
 */
import( 'Dataface/Table.php');
import( 'Dataface/Error.php');
class Dataface_Serializer {


        var $_table;
        
        function Dataface_Serializer($tablename){
                $this->_table =& Dataface_Table::loadTable($tablename);
        }
        
        static function number2db($value)
        {
            $larr = localeconv();
            $search = array(
                $larr['decimal_point'], 
                $larr['mon_decimal_point'], 
                $larr['thousands_sep'], 
                $larr['mon_thousands_sep'], 
                $larr['currency_symbol'], 
                $larr['int_curr_symbol']
            );
            $replace = array('.', '.', '', '', '', '');
        
            return str_replace($search, $replace, $value);
        }
        
        
        function serialize($fieldname, $value, $handleRepeat=true){
                
                // check to see if the input value is a placeholder.  If it is, we should pass it 
                // through untouched.
                if ( is_string($value) and preg_match('/^__(.*)__$/', $value)){
                        // This fixes an issue with addRelatedRecord();
                        return $value;
                }
                
                if ( $value === null ){
                        return null;
                }
                
                if ( strpos($fieldname, '.') !== false ){
                        // This is a related field.
                        $table =& $this->_table->getTableTableForField($fieldname);
                        list( $relname, $fieldname) = explode('.', $fieldname);
                        $serializer = new Dataface_Serializer($table->tablename);
                        $out = $serializer->serialize($fieldname, $value, $handleRepeat);
                        
                        return $out;
                        
                }
                
                $table =& $this->_table;
                $field =& $table->getField($fieldname);
                if ( PEAR::isError($field) ){
                        throw new Exception($field->getMessage());
                }
                
                $delegate =& $table->getDelegate();
                if ( $delegate !== null and method_exists($delegate, $fieldname."__serialize") ){
                        $val = call_user_func(array(&$delegate, $fieldname."__serialize"), $value);
                        
                        return $val;
                }
                $widget = $field['widget'];
                $type = $widget['type'];
                
                
                if ( $handleRepeat and $field['repeat'] and is_array($value) ){
                        foreach ($value as $key=>$val){
                                $value[$key] = $this->serialize($fieldname, $val, false);
                        }
                        
                        $value = implode($field['separator'], $value);
                        
                }
                
                $evt = new stdClass;
                $evt->table = $this->_table;
                $evt->field =& $field;
                $evt->value = $value;
                $evt->done = false;
                $this->_table->app->fireEvent('serialize_field_value', $evt);
                if ( $evt->done ){
                        return $evt->value;
                }
                
                if ($table->isDate( $fieldname ) ){
                        
                        if ( !isset($value) || !$value ) return null;
                        $params = $value; //$field['value'];
                        if ( is_string($params)  and strtotime($params) ){
                                $timestamp = strtotime($params);
                                switch ($table->getType($fieldname)){
                                        case 'date':
                                                return date('Y-m-d', $timestamp);
                                        case 'datetime':
                                        case 'timestamp':
                                                return date('Y-m-d h:i:s', $timestamp);
                                        case 'time':
                                                return date('h:i:s', $timestamp);
                                        case 'year':
                                                return date('Y', $timestamp);
                                }
                                        
                        }
                        if ( !is_array($params) ) return null;
                        
                        
                        $datestr = str_pad($params['year'],4,"0",STR_PAD_LEFT).'-'.str_pad($params['month'],2,"0",STR_PAD_LEFT).'-'.str_pad($params['day'],2,"0",STR_PAD_LEFT);
                        $timestr = str_pad($params['hours'],2,"0",STR_PAD_LEFT).':'.str_pad($params['minutes'],2,"0",STR_PAD_LEFT).':'.str_pad($params['seconds'], 2,"0",STR_PAD_LEFT);
                        
                        switch ( $table->getType($fieldname) ){ 
                                case 'date':
                                        return $datestr;
                                        //return "FROM_UNIXTIME('$datestr')";
                                case 'datetime':
                                        return $datestr.' '.$timestr;
                                        //return "FROM_UNIXTIME('$datestr $timestr')";
                                case 'timestamp':
                                        return str_pad($params['year'],4,"0",STR_PAD_LEFT).str_pad($params['month'],2,"0",STR_PAD_LEFT).str_pad($params['day'],2,"0",STR_PAD_LEFT).str_pad($params['hours'],2,"0",STR_PAD_LEFT).str_pad($params['minutes'],2,"0",STR_PAD_LEFT).str_pad($params['seconds'],2,"0",STR_PAD_LEFT);
                                case 'time':
                                        return $timestr;
                                case 'year':
                                        return str_pad($params['year'],4,"0",STR_PAD_LEFT);
                        }

                }
                
                //if ( $table->isInt( $fieldname ) ){
                //      if ( !$value ) return 0;
                //      return $value;
                //}
                
                //if ( $table->isFloat( $fieldname) ){
                //      return self::number2db(doubleval($value));
                //}
                
                
                
                
                if ( is_array( $value ) ){
                        if ( $widget['type'] == 'table' or $widget['type'] == 'group'){
                                import( 'XML/Serializer.php');
                                $serializer = new XML_Serializer(array('typeHints'=>true));
                                $ser_res =& $serializer->serialize($value);
                                if (!PEAR::isError($ser_res) ){
                                        return $serializer->getSerializedData();
                                }
                        }

                        throw new Exception("Trying to serialize value for field '$fieldname' that we don't know what to do with.  The value is an array and we don't know how to parse it.", E_USER_ERROR);
                        
                } else {
                        
                        
                        return $value;
                }
        
        
        
        }
        

        
        function unserialize($fieldname, $value){
                throw new Exception("Not implemented yet.", E_USER_ERROR);
        
        }
        
        
        function encrypt($fieldname, $value=null){
                if ( !isset($value) ) $value = '';
                if ( strpos($fieldname, '.') !== false ){
                        // This is a related field.
                        $table =& $this->_table->getTableTableForField($fieldname);
                        list( $relname, $fieldname) = explode('.', $fieldname);
                        $serializer = new Dataface_Serializer($table->tablename);
                        $out = $serializer->encrypt($fieldname, $value);
                        
                        return $out;
                        
                }
                $field = $this->_table->getField($fieldname);
                if ( PEAR::isError($field) ){
                        error_log($field->getMessage()."\n".implode("\n", $field->getBacktrace()));
                        throw new Exception("Failed to encrypt field $fieldname.  See error log for details.", E_USER_ERROR);
                        
                }
                if ( isset($field['encryption']) ){
                        switch(strtolower($field['encryption'])){
                                case 'md5':
                                        return 'MD5('.$value.')';
                                case 'password':
                                        return 'PASSWORD('.$value.')';
                                case 'sha1':
                                        return 'SHA1('.$value.')';
                                case 'encrypt':
                                        return 'ENCRYPT('.$value.')';
                                case 'aes_encrypt':
                                        return 'AES_ENCRYPT('.$value.',\''.addslashes($field['aes_key']).'\')';
                        }
                }
                return $value;
        }
        
        
        
        



}