public function init() { $pageTitle = 'Детали трубопроводов'; $pageMapper = new Default_Model_Mapper_Pages(); $page = $pageMapper->findByPath('pipeline', new Default_Model_Pages()); if ($page) { $pageTitle = $page->getTitle(); $this->view->meta_title = $page->getMetaTitle(); $this->view->meta_description = $page->getMetaDescription(); $this->view->meta_keywords = $page->getMetaKeywords(); $this->view->page = $page; } $this->view->title = $pageTitle; $categoriesMapper = new Pipeline_Model_Mapper_PipelineCategories(); $select = $categoriesMapper->getDbTable()->select(); $select->where('parent_id = ?', 0)->where('active != ?', 0)->where('deleted != ?', 1)->order('sorting ASC'); $categories = $categoriesMapper->fetchAll($select); $this->view->categories = $categories; /*//Заглушка if(!Zend_Auth::getInstance()->hasIdentity()){ $this->_helper->layout->setLayout('_cap'); $this->render('cap'); }*/ $this->view->adminPath = 'pipeline-categories/'; }
/** * @return array */ public function getCategoryArray() { $pipelineCategoryMapper = new Pipeline_Model_Mapper_PipelineCategories(); $select = $pipelineCategoryMapper->getDbTable()->select(); $select->where('deleted != ?', 1)->order('sorting ASC'); $categoryArray = array(); $categoryArray[] = 'нет'; $pipelineCategories = $pipelineCategoryMapper->fetchAll(); if (!empty($pipelineCategories)) { foreach ($pipelineCategories as $category) { $categoryArray[$category->getId()] = $category->getTitle(); } } return $categoryArray; }
/** * @return array */ public function getCategories() { if (0 == count($this->_categories)) { $categoriesMapper = new Pipeline_Model_Mapper_PipelineCategories(); $select = $categoriesMapper->getDbTable()->select(); $select->where('parent_id = ?', 0)->where('active != ?', 0)->where('deleted != ?', 1)->order('sorting ASC'); $this->_categories = $categoriesMapper->fetchAll($select); } return $this->_categories; }