/** * @return array */ public function getCategoryArray() { $mediaCategoryMapper = new Media_Model_Mapper_MediaCategories(); $select = $mediaCategoryMapper->getDbTable()->select(); $select->where('active != ?', 0)->where('deleted != ?', 1)->order('sorting ASC'); $categoryArray = array(); $categoryArray[] = 'нет'; /** * @var $category Media_Model_MediaCategories; */ foreach ($mediaCategoryMapper->fetchAll($select) as $category) { $categoryArray[$category->getId()] = $category->getName(); } return $categoryArray; }
/** * @return array */ public function getCategoryArray() { $categoryMapper = new Media_Model_Mapper_MediaCategories(); $select = $categoryMapper->getDbTable()->select(); $select->where('active != ?', 0)->where('deleted != ?', 1)->order('sorting ASC'); $categoryArray = array(); $categoryArray[0] = 'нет'; $categories = $categoryMapper->fetchAll(); if (!empty($categories)) { /** @var Media_Model_MediaCategories $category */ foreach ($categories as $category) { $categoryArray[$category->getId()] = $category->getName(); } } return $categoryArray; }
/** * @return Media_Model_MediaCategories[] * */ public function getCategories() { if (0 == count($this->_categories)) { $mediaCategoryMapper = new Media_Model_Mapper_MediaCategories(); $select = $mediaCategoryMapper->getDbTable()->select(); $select->where('deleted != ?', 1)->where('active != ?', 0)->order('sorting ASC'); $this->_categories = $mediaCategoryMapper->fetchAll($select); } return $this->_categories; }