== $users = Db::select(' SELECT custom_users.id, custom_users.name, custom_users.email, custom_users.archiveUser, custom_users.hourlyRate, custom_users.doNotSendEmail, custom_access_level.code, custom_access_level.description FROM custom_users INNER JOIN custom_access_level ON custom_users.accessLevelCode=custom_access_level.code'); $this['users'] = $users; } ?> == {##} {% for user in users %} {##} {% endfor %}
Name Email Access Level ArchivedReceive Emails
Name Email Access Level Archived
{{ user.name }} {{ user.email }} {{ user.description }} {% if user.archiveUser == 1 %} Yes {% else %} No {% endif %} {% if user.doNotSendEmail == 1 %} No {% else %} Yes {% endif %}