<?php
/**
 * Documentation
 * @author
 * @category
 * @package
 * @subpackage
 * @copyright Copyright (c) 2005-2012 ITCrimea Ukraine Inc. (http://www.itcrimea.com)
 * @license
 */
class User_Table extends System_Db_Table
{
    /**
     * Documentation
     *
     * @var mixed
     */
    protected static $_instance = null;

    /**
     * Documentation
     *
     * @var mixed
     */
    protected $_name = 'users';

    /**
     * Documentation
     *
     * @var mixed
     */
    protected $_dependentTables = array('Comment_Table',
                                        'Company_Table',
                                        'Company_Department_User_Table',
                                        'Erp_Invoice_Table',
                                        'Erp_Invoice_Position_Table',
                                        'Erp_Repair_Table', 'Erp_Worklog_Table');

    /**
     * Documentation
     *
     * @var mixed
     */
    protected $_referenceMap    = array(
        'RoleID' => array(
            'columns'           => 'RoleID',
            'refTableClass'     => 'User_Role_Table',
            'refColumns'        => 'ID'
        ),
        'Company' => array(
            'columns'           => 'Company_ID',
            'refTableClass'     => 'Company_Table',
            'refColumns'        => 'ID',
            'onDelete'          => self::CASCADE,
            'onUpdate'          => self::RESTRICT
        ),
        'Parent'  => array(
            'columns'           => 'Parent_ID',
            'refTableClass'     => 'User_Table',
            'refColumns'        => 'ID'
        ),
        'Logo' => array(
            		'columns'           => 'Logo_ID',
            		'refTableClass'     => 'Image_Table',
            		'refColumns'        => 'ID'
         )
    );

    /**
    * Documentation
    * @author
    * @return mixed
    */
    public function findByRole($paramRoleID)
    {
        return $this->fetchRow($this->select()->where('RoleID = ?', $paramRoleID));
    }

    /**
    * Documentation
    * @author
    * @return mixed
    */
    public function checkUser($Login, $Password)
    {
        $Login = strtolower($Login);
        //$Password = User::encodePassword($Password);
        $select = $this->select();
        $select->where('Login = ?', $Login);
        $select->where('Password = ?', $Password);
        $user = $this->fetchRow($select);
        if (is_object($user)){
            $user->LastLogin = date('Y-m-d H:i:s', time());
            $user->save();
        }
        return $user;
    }

    /**
    * Documentation
    * @author
    * @return User_Table
    */
    public static function getInstance()
    {
        if (null === self::$_instance) {
            self::$_instance = new self();
        }
        return self::$_instance;
    }

}