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;
}
