== $currentUsers = Db::select(' SELECT custom_user_department.id AS id, custom_user_department.email AS email, custom_restaurants.code, custom_restaurants.name, custom_responsible_department.description AS depDesc FROM custom_user_department INNER JOIN custom_restaurants ON custom_user_department.restaurant_id = custom_restaurants.id INNER JOIN custom_responsible_department ON custom_user_department.resp_department_id = custom_responsible_department.id'); $this['currentUsers'] = $currentUsers; } ?> == {% for cu in currentUsers %} {% endfor %}
Brand Department E-mail
Restaurant Department E-mail
{{ cu.code ~ '-' ~ cu.name }} {{ cu.depDesc }} {{ cu.email }}