== $restaurants = Db::select(' SELECT custom_restaurants.id, custom_restaurants.code, custom_restaurants.name, custom_restaurants.isDeactivated, custom_brands.code AS brandCode, custom_brands.description, custom_cities.code As citiesCode, custom_cities.cityDescription FROM custom_restaurants INNER JOIN custom_brands ON custom_restaurants.brandCode=custom_brands.code INNER JOIN custom_cities ON custom_restaurants.city=custom_cities.code ORDER BY custom_restaurants.name'); $this['restaurants'] = $restaurants; } ?> == {% for restaurant in restaurants %} {% endfor %}
# Code Name Brand City Edit
Brand City
{{ loop.index }} {{ restaurant.code }} {{ restaurant.name }} {{ restaurant.description }} {{ restaurant.cityDescription }}