<?php

# $Id$

 /* -------------------------------------------------------------------------+
   | ActiveRecord.php                                                        |
   +-------------------------------------------------------------------------+
   | http://phpfunk.com                                                      |
   | Copyright (c) 2006 Salvador T. Pimienta                                 |
   | All Rights Reserved.                                                    |
   +-------------------------------------------------------------------------+
   | 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 phpfunk.com 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    |
   | OWNER 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.    |                               
   +----------------------------------------------------------------------- */
   
/**
 * Currently the implementation is TIED to mysql database
 * Find methods are supported by separate finder class!
 */
class ActiveRecord {
    
    var $id;
    var $attributes;
    var $table;
    
    /**
     * Default implementation assumes table name is class name + 's'
     * @param string $table table name if you want to override the default name
     */
    function ActiveRecord($table='') {
        $this->attributes = array();
        $this->id = null;
        if($table) {
            $this->table = $table;
        } else {
            $this->table = strtolower(get_class($this)) . "s";
        }
    }


    /**
     * Cannot be called statically, this is an instance method.  Sets id and attributes to values in $arr
     * @return void
     * @param array $arr assoc array of attributes
     */
    function fromArray( $arr ) {
        // should look for id and pop it out
        foreach( $arr as $i => $v ) {
            if( $i == 'id' ) {
                $this->id = $arr['id'];
            } else {
                $this->attributes[$i] = $v;
            }
        }
    }
    
    /**
     * @return array an associative array of fields=> values
     */
    function toArray() {
        $arr = array();
        foreach( $this->attributes as $key=>$value) {
            $arr[$key] = $value;
        }
        return $arr;
    }
    
    /**
     * @access public
     * @return int id of this record or null if record has not been saved yet
     */
    function getID() {
        return $this->id;
    }
    
    function save() {
        if( is_null($this->id)){
            return $this->insert();
        } else {
            return $this->update();
        }
    }
    
    function equals($object) {
        if(!is_subclass_of($object, 'ActiveRecord')) return FALSE;
        foreach($this->attributes as $i=>$v) {
            if($v != $object->get($i)) return FALSE;
        }
        return TRUE;
    }

    /**
     * Deletes record from DB, but does not null the object
     * @return bool true on success
     */
    function delete() {
        $sql = "delete from $this->table where id=$this->id";
        mysql_query($sql);
        return mysql_affected_rows() > 0;
    }

    function insert() {
        $columns = '';
        $values = '';
        $sql = "insert into $this->table set ";
        foreach( $this->attributes as $key=>$value) {
            $sql .= "$key='".mysql_real_escape_string($value)."', ";
        }
        $sql = rtrim($sql, ", ");
        if( !$res = mysql_query($sql)) {
            trigger_error( mysql_error() . __FILE__ . __LINE__ , E_USER_WARNING );
            return FALSE;
        }
        if( !$this->id) {
            $this->id = mysql_insert_id();
        }
        return TRUE;
    }
    
    function update() {
        $sql = "update $this->table set ";
        foreach( $this-> attributes as $key => $value ) {
            $sql .= "$key = '".mysql_real_escape_string($value)."',";
        }
        $sql = rtrim($sql, ",");
        $sql .= " where id=$this->id";
        if( !$res = mysql_query($sql)) {
            trigger_error( mysql_error(), E_USER_WARNING );
            return FALSE;
        }
        return TRUE;        
    }
    
    function get($attr) {
        if(isset($this->attributes[$attr])) {
            return $this->attributes[$attr];
        }
        trigger_error("No such attribute");
        return null;
    }
    
    /**
     * @param String $attr
     * @param mixed $value primitive or an object
     */
    function set( $attr, $value ) {
        $this->attributes[$attr] = $value;
    }
    
}

?>