public function manageAction()
{
// Create form
if (!$this->_helper->requireAuth()->setAuthParams(null, null, 'edit')->isValid()) {
return;
}
$this->view->formFilter = $formFilter = new Event_Form_Filter_Manage();
$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 = $this->_helper->api()->user()->getViewer();
$table = $this->_helper->api()->getDbtable('events', 'event');
$tableName = $table->info('name');
// Only mine
if (@$values['view'] == 2) {
$select = $table->select()->where('user_id = ?', $viewer->getIdentity());
} else {
$membership = Engine_Api::_()->getDbtable('membership', 'event');
$select = $membership->getMembershipsOfSelect($viewer);
}
if (!empty($values['text'])) {
$select->where("`{$tableName}`.title LIKE ?", '%' . $values['text'] . '%');
}
$this->view->paginator = $paginator = Zend_Paginator::factory($select);
$this->view->text = $values['text'];
$this->view->view = $values['view'];
$paginator->setItemCountPerPage(20);
$paginator->setCurrentPageNumber($this->_getParam('page'));
}
public function manageAction()
{
// Create form
if (!$this->_helper->requireAuth()->setAuthParams('event', null, 'edit')->isValid()) {
return;
}
// Get navigation
$this->view->navigation = $navigation = Engine_Api::_()->getApi('menus', 'core')->getNavigation('event_main');
// Render
$this->_helper->content->setEnabled();
$this->view->formFilter = $formFilter = new Event_Form_Filter_Manage();
$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();
$table = Engine_Api::_()->getDbtable('events', 'event');
$tableName = $table->info('name');
// Only mine
if (@$values['view'] == 2) {
$select = $table->select()->where('user_id = ?', $viewer->getIdentity());
} else {
$membership = Engine_Api::_()->getDbtable('membership', 'event');
$select = $membership->getMembershipsOfSelect($viewer);
}
if (!empty($values['search_text'])) {
$values['text'] = $values['search_text'];
}
if (!empty($values['text'])) {
$select->where("`{$tableName}`.title LIKE ?", '%' . $values['text'] . '%');
}
$select->order('starttime ASC');
//$select->where("endtime > FROM_UNIXTIME(?)", time());
$this->view->paginator = $paginator = Zend_Paginator::factory($select);
$this->view->text = $values['text'];
$this->view->view = $values['view'];
$paginator->setItemCountPerPage(20);
$paginator->setCurrentPageNumber($this->_getParam('page'));
// Check create
$this->view->canCreate = Engine_Api::_()->authorization()->isAllowed('event', null, 'create');
}
