Touren application

[infodrom.org/touren.infodrom.org] / core / sys_user.class.php

<?php

class Sys_User extends DatabaseTable
{
    public function __construct($id=false, $column=false)
    {
        parent::__construct('sys_user', $id, $column);
    }

    public function generateKey()
    {
        $key = md5(random_bytes(20));

        $this->modify(['pwkey' => $key,
                       'pwkey_valid' => 'now()']);
    }

    public function setPassword($passwd)
    {
        return $this->modify(['passwd' => md5($this->data->email.$passwd),
                              'pwkey' => NULL,
                              'pwkey_valid' => NULL]);
    }

    public function getUserlist($tour_id=false)
    {
        $tour_id = intval($tour_id);
        $sql =<<<EOS
            SELECT DISTINCT
              sys_user.id,sys_user.name,sys_user.email,tour_id IS NOT NULL AS active
            FROM sys_user
            LEFT JOIN tour_member ON sys_user.id = member_id
                                 AND ({$tour_id} = 0 OR tour_id = {$tour_id})
            WHERE sys_user.id > 1 AND active = true
            ORDER by sys_user.name
EOS;

        return $this->db->fetchObjectList($sql);
    }
}