public function bycuisineAction() { $id = $this->_getParam('id', 0); if ($id > 0) { //show food categories from this cuisine id $cuisines = new Model_DbTable_Cuisines(); $itemsRowset = $cuisines->find($id); $thisCuisine = $itemsRowset->current(); $cuisineName = $thisCuisine['name']; $this->view->cuisineName = $cuisineName; $this->view->title = "{$cuisineName}"; $this->view->headTitle($this->view->title, 'PREPEND'); //$select = $fooditems->select() ->order('name DESC'); $categoriesFound = $thisCuisine->findDependentRowset('Model_DbTable_FoodItems', 'Cuisine'); //, $select); $this->view->categories = $categoriesFound; } }
public function detailAction() { $id = $this->_getParam('id', 0); if ($id > 0) { //show detailed view of this dish, its rating, and restaurant $dishesC = new Model_DbTable_DishesComplete(); $itemsRowset = $dishesC->find($id); $thisDishC = $itemsRowset->current(); $this->view->dish = $thisDishC; $restaurants = new Model_DbTable_Restaurants(); $itemsRowset = $restaurants->find($thisDishC['rest_id']); $thisRest = $itemsRowset->current(); $this->view->restaurant = $thisRest; $dishName = $thisDishC['dish_name']; $categoryID = $thisDishC['fooditem_id']; $fooditems = new Model_DbTable_FoodItems(); $itemsRowset = $fooditems->find($categoryID); $thisCategory = $itemsRowset->current(); $cuisineID = $thisCategory['cuisine_id']; $cuisines = new Model_DbTable_Cuisines(); $itemsRowset = $cuisines->find($cuisineID); $thisCuisine = $itemsRowset->current(); $categoryName = $thisCategory['name']; $cuisineName = $thisCuisine['name']; $this->view->title = "{$cuisineName}: {$categoryName}: {$dishName}"; $this->view->headTitle("{$dishName}", 'PREPEND'); $dishes = new Model_DbTable_Dishes(); $itemsRowset = $dishes->find($id); $thisDish = $itemsRowset->current(); $foundReviews = $thisDish->findDependentRowset('Model_DbTable_ReviewsComplete', 'Dish'); $this->view->reviews = $foundReviews; } }