/**
* 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;
}
}
