public function calendarAction() { $this->_helper->layout->setLayout('full'); $proxy = new SxCms_Event_DataMapper(); $events = $proxy->getNextEvents(null); $config = Zend_Registry::get('config'); $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($events)); $paginator->setCurrentPageNumber($this->_getParam('page'))->setItemCountPerPage($config->modules->event->list->count); $this->view->paginator = $paginator; }
public function deleteAction() { SxCms_Acl::requireAcl('event', 'event.delete'); $event_id = $this->_getParam('id'); $proxy = new SxCms_Event_DataMapper(); $this->_event = $proxy->getEventById($event_id); $this->_event->delete(); $flashMessenger = $this->_helper->getHelper('FlashMessenger'); $flashMessenger->addMessage($this->admin_tmx->_('eventdeleted')); $this->_helper->redirector->gotoSimple('index', 'event'); }
public function delete() { $db = Zend_Registry::get('db'); $db->delete('EventTsl', 'event_id = ' . $this->getId() . ' AND language = \'' . $_SESSION['System']['lng'] . '\''); if (!SxCms_Event_DataMapper::isEventById($this->getId())) { $db->delete('Event', 'event_id = ' . $this->getId()); } foreach ($this->getFields() as $field) { $field->delete(); } }
public function exportAction() { SxCms_Acl::requireAcl('subscriptions', 'subscription.export'); $event_id = $this->_getParam('id'); $eventMapper = new SxCms_Event_DataMapper(); $event = $eventMapper->getEventById($event_id); $subProxy = new SxCms_Event_Subscription_DataMapper(); $subscriptions = $subProxy->getValidSubscriptionsForEvent($event_id); $fieldProxy = new SxCms_Event_Field_DataMapper(); $fields = $fieldProxy->getFieldsByEvent($event_id); $objPHPExcel = new PHPExcel(); $objPHPExcel->createSheet("Event Subsciptions"); $objPHPExcel->setActiveSheetIndex(0); $objPHPSheet = $objPHPExcel->getActiveSheet(); $objPHPSheet->setCellValueByColumnAndRow(0, 1, $this->admin_tmx->_('subscriptionsforevent') . $event->getTitle()); $i = 0; foreach ($fields as $field) { $objPHPSheet->setCellValueByColumnAndRow($i, 2, $field->getLabel()); $i++; } $j = 3; foreach ($subscriptions as $subscription) { $i = 0; foreach ($fields as $field) { $objPHPSheet->setCellValueByColumnAndRow($i, $j, $subscription[$field->getName()]); $i++; } $j++; } $file = "sub_" . date("d_m_Y") . ".xls"; header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header("Content-Disposition: attachment; filename={$file}"); header("Content-Transfer-Encoding: binary"); error_reporting(0); $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); $objWriter->setTempDir(APPLICATION_ROOT . '/tmp'); $objWriter->save("php://output"); die; }