<?php

class Users {

	public function __construct() {
	}

	public function tabUsers($f3) {
		if (isset($f3->get('GET')['filter'])) {
			$filter = '%'.$f3->get('GET')['filter'].'%';
			$f3->set('result',$f3->get('DB')->exec('SELECT userid, username, organization, firstname, lastname, email, lastlogin FROM user WHERE username LIKE ?', $filter));
			$f3->set('oldFilter', htmlspecialchars($f3->get('GET')['filter']));
		} else {
			$f3->set('result',$f3->get('DB')->exec('SELECT userid, username, organization, firstname, lastname, email, lastlogin FROM user'));
			$f3->set('oldFilter', '');
		}
		// now render the view
		echo Template::instance()->render('views/users.htm');
	}
}

?>