/** * Default action, will forward, or show start page * * @var int $category Selected category */ public function indexAction() { $category = $this->getRequest()->getParam("category"); $pagesModel = new Model_DbTable_Pages(); $pages = $pagesModel->fetchAll($pagesModel->select()->where("category_id = ?", $category)->order("name ASC")); //$pages = $pages as }
/** * Default action, will forward, or show start page */ public function indexAction() { Zend_Layout::getMvcInstance()->setLayout("index"); $categoriesModel = new Model_DbTable_PagesCategories(); $pagesModel = new Model_DbTable_Pages(); $category = $categoriesModel->fetchRow($categoriesModel->select()->where("name = ?", "Пресса")->where("parent_id IS NULL")); $categories = $category->findDependentRowset("Model_DbTable_PagesCategories"); foreach ($categories as $category) { switch ($category->name) { case 'Новости': $news = $category; break; case 'Акции': $stocks = $category; break; case 'Статьи': $posts = $category; break; } } if (isset($posts)) { $this->view->post = $pagesModel->fetchRow($pagesModel->random()->where("category_id = ?", $posts->id)); } if (isset($news)) { $this->view->news = $pagesModel->fetchRow($pagesModel->select()->where("category_id = ?", $news->id)->order("timestamp DESC")); } if (isset($stocks)) { $this->view->stocks = $pagesModel->fetchRow($pagesModel->select()->where("category_id = ?", $stocks->id)->order("timestamp DESC")); } $forumModel = new Model_DbTable_Forum(); $this->view->forum = new StdClass(); $this->view->forum->answer = $forumModel->fetchRow($forumModel->select()->order("timestamp DESC")->where("parent_id IS NOT NULL")); $this->view->forum->question = $this->view->forum->answer->findParentRow("Model_DbTable_Forum"); }
public function deleteAction() { if (!Zend_Auth::getInstance()->hasIdentity()) { throw new Zend_Exception("You can't edit this item"); } $id = $this->getRequest()->getParam("id"); $pagesModel = new Model_DbTable_Pages(); $page = $pagesModel->find($id)->current(); if (!$page) { throw new Zend_Exception("Selected page not found"); } if ($this->getRequest()->getParam("accept") == "accepted") { $page->delete(); $this->_redirect("/sections/media"); exit; } else { $this->view->page = $page; } }