<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Auth_mod extends CI_Model
{
    /**
     * all database tables
     *
     * @var array
     */
    private $tables = array(
                        'users' => 'users',
                        'cookies' => 'cookies',
                        'forgotten_passwords' => 'forgotten_passwords',
                        'users_roles' => 'users_roles'
                    );

    /**
     * construct function
     */
    public function __construct()
    {
        parent::__construct();

        $this->load->database();
    }

    /**
     * create a new user
     *
     * @param string $name
     * @param string $email
     * @param string $password
     */
    public function create_user($name, $email, $password, $role)
    {
        $email = trim($email);

        if ($this->check_email($email)) return FALSE;

        $name = trim($name);
        $password = sha1(trim($password));

        $this->db->insert($this->tables['users'], array('name' => $name, 'email' => $email, 'password' => $password));

        $id = $this->db->insert_id();

        $this->create_user_role($id, $role);
    }

    /**
     * create user role
     *
     * @param integer $user_id
     * @param integer $role
     */
    public function create_user_role($id, $role)
    {
        $this->db->insert($this->tables['users_roles'], array('id' => $id, 'role' => $role));
    }

    /**
     * login the user
     *
     * @param string $email
     * @param string $password
     *
     * @return object|FALSE
     */
    public function login($email, $password)
    {
        $email = trim($email);
        $password = sha1(trim($password));

        $query = $this->db->select('id, name, email, last_login')->from($this->tables['users'])->where(array('email' => $email, 'password' => $password, 'active' => TRUE))->get();

        if ($query->num_rows() === 1)
        {
            return $query->row();
        }

        return FALSE;
    }

    public function get_user_role($id)
    {
        $query = $this->db->select('role')->from($this->tables['users_roles'])->where('id', $id)->get();

        if ($query->num_rows() > 0)
        {
            return $query->result_array();
        }

        return FALSE;
    }

    /**
     * auto login the user for "remember me"
     *
     * @param integer $id
     */
    public function auto_login($cookie_value)
    {
        $query = $this->db->select('id, name, email, last_login')
                ->from($this->tables['users'])
                ->join($this->tables['cookies'], $this->tables['cookies'] . '.user_id = ' . $this->tables['users'] . '.id AND ' . $this->tables['cookies'] . '.value = ' . $cookie_value)
                ->where('active', TRUE)
                ->get();

        if ($query->num_rows() === 1)
        {
            return $query->row();
        }

        return FALSE;
    }

    /**
     * update user last login
     *
     * @param integer $id
     */
    public function update_last_login($id)
    {
        $this->db->where('id', $id)->update('last_login', CURRENT_TIMESTAMP);
    }

    /**
     * check if email is avaiable
     *
     * @param string $email
     *
     * @return boolean
     */
    public function check_email($email)
    {
        $email = trim($email);

        if ($this->db->where('email', $email)->count_all_results($this->tables['users']) === 1) return TRUE;

        return FALSE;
    }

    /**
     * reset user password
     *
     * @param string $email
     */
    public function update_password($user_id, $password)
    {
        $password = sha1(trim($password));

        $this->db->where('email', $email)->update('password', $password);
    }

    /**
     * insert cookie for "remember me"
     *
     * @param integer $user_id
     */
    public function create_cookie($user_id, $value)
    {
        $this->db->insert($this->tables['cookies'], array('user_id' => $user_id, 'value' => $value));
    }

    /**
     * delete cookie
     *
     * @param integer $user_id
     */
    public function delete_cookie($value)
    {
        $this->db->where('value', $value)->delete($this->tables['cookies']);
    }

    /**
     * create forgotten password value
     *
     * @param string $user_id
     * @param string $value
     */
    public function create_forgotten_password($user_id, $value)
    {
        $this->db->insert($this->tables['forgotten_passwords'], array('user_id' => $user_id, 'value' => $value));
    }

    /**
     * check forgotten password value
     *
     * @param string $user_email
     */
    public function check_forgotten_password($value)
    {
        if ($this->db->where('value', $value)->count_all_results($this->tables['forgotten_passwords']) === 1) return TRUE;

        return FALSE;
    }

    /**
     * get user id by email
     *
     * @param string $email
     */
    public function get_user_id_by_email($email)
    {
        $email = trim($email);

        $query = $this->db->select('id')
                ->from($this->tables['users'])
                ->where('email', $email)
                ->get();

        if ($query->num_rows() === 1)
        {
            $row = $query->row();

            return $row->email;
        }

        return FALSE;
    }
}