public function getAllActive($lng = 'nl', $paginator = true, $pindex = 1, $perpage = 25, $cache = true) { if ($cache == true) { $cacheId = $this->generateCacheId(get_class($this) . '_' . __FUNCTION__, func_get_args()); $cache = Zend_Registry::get('cache'); if (true == ($result = $cache->load($cacheId))) { return $result; } } $db = Zend_Registry::get('db'); $select = $db->select()->from(array('ty' => 'SheetsType'), array('*'))->join(array('tyt' => 'SheetsTypeTsl'), 'ty.type_id = tyt.type_id', array('*'))->where('tyt.lng = ?', $_SESSION['System']['lng'])->where('ty.active = ?', 1)->order('ty.position ASC'); if ($paginator === true) { $adapter = new Base_PaginatorAdapter($select); $adapter->setMapper($this->_mapper); $data = new Zend_Paginator($adapter); $data->setCurrentPageNumber((int) $pindex); $data->setItemCountPerPage((int) $perpage); } else { $results = $db->fetchAll($select); $data = $this->_mapper->mapAll($results); } $proxy = new SxModule_Sheets_Subtype_Proxy(); $subtypes = $proxy->getAll(); foreach ($data as $type) { foreach ($subtypes as $subtype) { if ($type->getId() == $subtype->getType()) { $type->addSubtype($subtypes); } } } if ($cache == true) { $cacheTags = $this->generateCacheTags(get_class($this) . '_' . __FUNCTION__); $cache->save($data, $cacheId, $cacheTags); } return $data; }
public function deleteAction() { SxCms_Acl::requireAcl('sheets', 'sheets.delete'); $type_id = $this->_getParam('id'); $proxy = new SxModule_Sheets_Subtype_Proxy(); $this->_subtype = $proxy->getTypeById($type_id); $this->_subtype->delete(); $cache = Zend_Registry::get('cache'); $cache->clean(Zend_Cache::CLEANING_MODE_MATCHING_ANY_TAG, array('SxModule_Sheets_Subtype')); $proxyAction = new SxModule_Sheets_Proxy(); $proxyAction->deleteByType($type_id); $flashMessenger = $this->_helper->getHelper('FlashMessenger'); $flashMessenger->addMessage($this->admin_tmx->_('itemdeleted')); $this->_helper->redirector->gotoSimple('index', 'sheets_subtype', 'admin', array('type' => $this->_getParam('type'))); }
public function getSubtypeAction() { $subcat = new SxModule_Sheets_Subtype_Proxy(); $type = $this->_getParam('typeid'); $this->view->subcat = $subcat->getAllbyTypeActive($type, $_SESSION['System']['lng'], true); $view = utf8_encode($this->view->render('sheets/get-subtype.phtml')); $results = Zend_Json::encode(array('subcat' => utf8_encode($view))); $this->view->results = $results; $this->render('json'); $this->_helper->layout->disableLayout(); }