<?php 

/**
 * Wolf CMS - Content Management Simplified. <http://www.wolfcms.org>
 * Copyright (C) 2009 Martijn van der Kleijn <hide@address.com>
 * Copyright (C) 2008 Philippe Archambault <hide@address.com>
 *
 * This file is part of Wolf CMS.
 *
 * Wolf CMS 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 3 of the License, or
 * (at your option) any later version.
 *
 * Wolf CMS 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 Wolf CMS.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Wolf CMS has made an exception to the GNU General Public License for plugins.
 * See exception.txt for details and the full text.
 */

/**
 * @package wolf
 * @subpackage models
 *
 * @author Philippe Archambault <hide@address.com>
 * @version 0.1
 * @license http://www.gnu.org/licenses/gpl.html GPL License
 * @copyright Philippe Archambault, 2008
 */

/**
 * class User
 *
 * @author Philippe Archambault <hide@address.com>
 * @since Wolf version 0.1
 */
class User extends Record {
    const TABLE_NAME = 'user';

    public $name = '';
    public $email = '';
    public $username = '';

    // User preferences
    public $language = '';

    public $created_on;
    public $updated_on;
    public $created_by_id;
    public $updated_by_id;

    public function getPermissions() {
        if ( !isset($this->id)) {
            return array();
        }

        $perms = array();
        $sql = 'SELECT name FROM '.self::tableNameFromClassName('Permission').' AS permission, '. self::tableNameFromClassName('UserPermission')
            . ' WHERE permission_id = permission.id AND user_id='.$this->id;

        $stmt = self::$__CONN__->prepare($sql);
        $stmt->execute();

        while ($perm = $stmt->fetchObject())
            $perms[] = $perm->name;

        return $perms;
    }

    public static function findBy($column, $value) {
        return Record::findOneFrom('User', $column.' = ?', array($value));
    }

    public function beforeInsert() {
        $this->created_by_id = AuthUser::getId();
        $this->created_on = date('Y-m-d H:i:s');
        return true;
    }

    public function beforeUpdated() {
        $this->updated_by_id = AuthUser::getId();
        $this->updated_on = date('Y-m-d H:i:s');
        return true;
    }

    public static function find($args = null) {

    // Collect attributes...
        $where    = isset($args['where']) ? trim($args['where']) : '';
        $order_by = isset($args['order']) ? trim($args['order']) : '';
        $offset   = isset($args['offset']) ? (int) $args['offset'] : 0;
        $limit    = isset($args['limit']) ? (int) $args['limit'] : 0;

        // Prepare query parts
        $where_string = empty($where) ? '' : "WHERE $where";
        $order_by_string = empty($order_by) ? '' : "ORDER BY $order_by";
        $limit_string = $limit > 0 ? "LIMIT $offset, $limit" : '';

        $tablename = self::tableNameFromClassName('User');

        // Prepare SQL
        $sql = "SELECT $tablename.*, creator.name AS created_by_name, updater.name AS updated_by_name FROM $tablename".
            " LEFT JOIN $tablename AS creator ON $tablename.created_by_id = creator.id".
            " LEFT JOIN $tablename AS updater ON $tablename.updated_by_id = updater.id".
            " $where_string $order_by_string $limit_string";

        $stmt = self::$__CONN__->prepare($sql);
        $stmt->execute();

        // Run!
        if ($limit == 1) {
            return $stmt->fetchObject('User');
        }
        else {
            $objects = array();
            while ($object = $stmt->fetchObject('User')) {
                $objects[] = $object;
            }
            return $objects;
        }

    }

    public static function findAll($args = null) {
        return self::find($args);
    }

    public static function findById($id) {
        return self::find(array(
        'where' => self::tableNameFromClassName('User').'.id='.(int)$id,
        'limit' => 1
        ));
    }

} // end User class