== $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; } ?> ==
Brand | Department | ||
---|---|---|---|
Restaurant | Department | ||
{{ cu.code ~ '-' ~ cu.name }} | {{ cu.depDesc }} | {{ cu.email }} |
|