public function manageAction() { // Navigation // $this->view->navigation = $navigation = Engine_Api::_()->getApi('menus', 'core') // ->getNavigation('group_main'); // Form $this->view->formFilter = $formFilter = new Group_Form_Filter_Manage(); $this->view->formValues = $values = $formFilter->getValues(); // Populate form data if ($formFilter->isValid($this->_getAllParams())) { $this->view->formValues = $values = $formFilter->getValues(); } else { $formFilter->populate($defaultValues); $this->view->formValues = $values = array(); } $viewer = $this->_helper->api()->user()->getViewer(); $membership = Engine_Api::_()->getDbtable('membership', 'group'); $select = $membership->getMembershipsOfSelect($viewer); $table = Engine_Api::_()->getItemTable('group'); $tName = $table->info('name'); if ($values['view'] == 2) { $select->where("`{$tName}`.`user_id` = ?", $viewer->getIdentity()); } if (!empty($values['text'])) { $select->where($table->getAdapter()->quoteInto("`{$tName}`.`title` LIKE ?", '%' . $values['text'] . '%') . ' OR ' . $table->getAdapter()->quoteInto("`{$tName}`.`description` LIKE ?", '%' . $values['text'] . '%')); } $this->view->paginator = $paginator = Zend_Paginator::factory($select); $this->view->text = $values['text']; $this->view->view = $values['view']; $paginator->setCurrentPageNumber($this->_getParam('page')); }
public function manageAction() { // Render $this->_helper->content->setEnabled(); // Form $this->view->formFilter = $formFilter = new Group_Form_Filter_Manage(); $this->view->formValues = $defaultValues = $formFilter->getValues(); // Populate form data if ($formFilter->isValid($this->_getAllParams())) { $this->view->formValues = $values = $formFilter->getValues(); } else { $formFilter->populate($defaultValues); $this->view->formValues = $values = array(); } $viewer = Engine_Api::_()->user()->getViewer(); $membership = Engine_Api::_()->getDbtable('membership', 'group'); $select = $membership->getMembershipsOfSelect($viewer); $select->where('group_id IS NOT NULL'); $table = Engine_Api::_()->getItemTable('group'); $tName = $table->info('name'); if ($values['view'] == 2) { $select->where("`{$tName}`.`user_id` = ?", $viewer->getIdentity()); } if (!empty($values['text'])) { $select->where($table->getAdapter()->quoteInto("`{$tName}`.`title` LIKE ?", '%' . $values['text'] . '%') . ' OR ' . $table->getAdapter()->quoteInto("`{$tName}`.`description` LIKE ?", '%' . $values['text'] . '%')); } $this->view->paginator = $paginator = Zend_Paginator::factory($select); $this->view->text = $values['text']; $this->view->view = $values['view']; $paginator->setCurrentPageNumber($this->_getParam('page')); // Check create $this->view->canCreate = Engine_Api::_()->authorization()->isAllowed('group', null, 'create'); }