3 class Sys_User extends DatabaseTable
5 public function __construct($id=false, $column=false)
7 parent::__construct('sys_user', $id, $column);
10 public function generateKey()
12 $key = md5(random_bytes(20));
14 $this->modify(['pwkey' => $key,
15 'pwkey_valid' => 'now()']);
18 public function setPassword($passwd)
20 return $this->modify(['passwd' => md5($this->data->email.$passwd),
22 'pwkey_valid' => NULL]);
25 public function getUserlist($tour_id=false)
27 $tour_id = intval($tour_id);
30 sys_user.id,sys_user.name,sys_user.email,tour_id IS NOT NULL AS active
32 LEFT JOIN tour_member ON sys_user.id = member_id
33 AND ({$tour_id} = 0 OR tour_id = {$tour_id})
34 WHERE sys_user.id > 1 AND active = true
35 ORDER by sys_user.name
38 return $this->db->fetchObjectList($sql);