/**
* 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 pipelineEditAction()
{
Zend_Layout::getMvcInstance()->setLayout("pipeline");
if (!Zend_Auth::getInstance()->hasIdentity()) {
throw new Zend_Exception("You can't edit this item");
}
$id = $this->getRequest()->getParam('id');
if (!$id) {
$pagesModel = new Model_DbTable_PagesCategories();
$this->view->page = $pagesModel->fetchRow($pagesModel->select()->where("parent_id IS NULL")->where("name = ?", "Трубопроводная арматура"));
if ($this->getRequest()->isPost()) {
$this->view->page->description = $this->getRequest()->getParam("content");
$this->view->page->save();
$this->_redirect("/sections/pipeline");
exit;
}
} else {
$pagesModel = new Model_DbTable_Pages();
$this->view->page = $pagesModel->fetchRow($pagesModel->select()->where("id = ?", $id));
if ($this->getRequest()->isPost()) {
$this->view->page->content = $this->getRequest()->getParam("content");
$this->view->page->save();
$this->_redirect("/sections/pipeline/");
exit;
}
}
}
