<?php

# $Id$

 /* -------------------------------------------------------------------------+
   | ActiveRecordFinder.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.    |                               
   +----------------------------------------------------------------------- */

require_once 'DBWrapper.php';
require_once 'ActiveRecord.php';
require_once 'Registry.php';

/**
 * Abstract superclass
 */
class ActiveRecordFinder {
    
    var $table;
    var $conn;
    
    function ActiveRecordFinder() {
        $this->table = $table;
        if(!$this->table) {
            $this->table = strtolower(substr(get_class($this), 0, -6) . "s");
        }
        $this->conn =& Registry::get('db');
    }
    
    /**
     * @abstract
     * Subclass must define this to instantiate correct class 
     */
    function createInstance() {
    }
    
    /**
     * Find that should work for simple 1 table active record objects
     */
    function find($id) {
        $sql = $this->find_statement();
        $row = $this->conn->selectOne($sql, $id, __FILE__, __LINE__);
        if(!$row) return $row;
        $obj = $this->createInstance();
        $obj->fromArray($row);
        return $obj;
    }

    /**
     * Returns default SQL to find by ID
     * @return string SQL
     */
    function find_statement() {
        return "select * from $this->table where id=?";
    }
    
    /**
     * @deprecated
     */
    function _find($sql, $id) {
        trigger_error("_find() is deprecated in " . get_class($this));
        $row = $this->conn->selectOne($sql, $id, __FILE__, __LINE__);
        if( !$row ) { return $row; }
        //create one
        $obj = $this->createInstance();
        $keys = array_keys($row);
        foreach( $keys as $key ) {
            $obj->set($key, $row[$key] );
        }
        $obj -> id = $row['id'];
        return $obj;
    }
    
    function findAll($arr = '', $limit = 0, $offset = 0 ) {
        $args = '';
        $sql = "select * from $this->table";
        if( $arr ) {
            $where = '';
            $args = array();
            foreach ( $arr as $i => $v ) {
                $where .= "$i = '".$this->conn->escape($v)."' and ";
                $args[] = $v;
            }
            $where = rtrim($where, " and " );
            $sql .= " where $where";
        }
        return $this->_findAll($sql, $limit, $offset);
    }


    /**
     * @access private
     * generic find method
     */
    function _findAll($sql, $limit=0, $offset=0) {
        if($limit) {
            $sql .= " limit $limit offset $offset";
        }
        $rows = $this->conn->selectRows($sql, '', __FILE__, __LINE__);
        if( !$rows ) { return $rows; } // FALSE or null
        $ret = array();
        foreach( $rows as $row ) {
            $obj = $this->createInstance();
            $obj-> fromArray($row);
            $ret[] = $obj;
        }
        return $ret;

    }
}

?>