function users() { if (isset($this->users)) { return $this->users; } static $query; DB::prepare_query($query, "SELECT user.userid as userid,login,firstname,midname,lastname,email FROM `user_submission`" . " LEFT JOIN `user` ON `user_submission`.`userid` = `user`.`userid`" . " WHERE submissionid=?"); $query->execute(array($this->submissionid)); $this->users = User::fetch_all($query); return $this->users; }
static function all($filter = "%") { static $query; // TODO: which fields to select? DB::prepare_query($query, "SELECT userid,login,firstname,midname,lastname,email,is_admin FROM `user`" . " WHERE `login` LIKE ?" . " OR CONCAT_WS(' ',`firstname`,`midname`,`lastname`) LIKE ?" . " OR CONCAT_WS(' ',`firstname`,`lastname`,`midname`) LIKE ?" . " ORDER BY `lastname`,`firstname`,`midname`"); $query->execute(array($filter, $filter, $filter)); return User::fetch_all($query); }