public function eventAction() { $eventMapper = new EventMapper(); $entrantsMapper = new EntrantsMapper(); $entrantsModel = new EntrantsModel(); $commentMapper = new CommentMapper(); $commentModel = new CommentModel(); $event = $eventMapper->getEventById($this->getRequest()->getParam('id')); $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('menuEvents'), array('controller' => 'index', 'action' => 'index'))->add($event->getTitle(), array('controller' => 'show', 'action' => 'event', 'id' => $event->getId())); if ($this->getRequest()->isPost()) { if ($this->getRequest()->getPost('save')) { $entrantsModel->setEventId(trim($this->getRequest()->getPost('id'))); $entrantsModel->setUserId($this->getUser()->getId()); $entrantsModel->setStatus(trim($this->getRequest()->getPost('save'))); $entrantsMapper->saveUserOnEvent($entrantsModel); $this->addMessage('saveSuccess'); } if ($this->getRequest()->getPost('commentEvent')) { $date = new \Ilch\Date(); $commentModel->setKey('events/show/event/id/' . $this->getRequest()->getParam('id')); $commentModel->setText($this->getRequest()->getPost('commentEvent')); $commentModel->setDateCreated($date); $commentModel->setUserId($this->getUser()->getId()); $commentMapper->save($commentModel); $this->addMessage('saveSuccess'); } if ($this->getRequest()->getPost('deleteUser')) { $entrantsMapper->deleteUserFromEvent($this->getRequest()->getParam('id'), $this->getUser()->getId()); $this->addMessage('deleteSuccess'); } if ($this->getRequest()->getPost('deleteEvent')) { $eventMapper->delete($this->getRequest()->getParam('id')); $this->addMessage('deleteSuccess'); $this->redirect(array('controller' => 'index', 'action' => 'index')); } } if ($this->getUser()) { $this->getView()->set('eventEntrants', $entrantsMapper->getEventEntrants($this->getRequest()->getParam('id'), $this->getUser()->getId())); } $this->getView()->set('event', $eventMapper->getEventById($this->getRequest()->getParam('id'))); $this->getView()->set('eventEntrantsUser', $entrantsMapper->getEventEntrantsById($this->getRequest()->getParam('id'))); $this->getView()->set('eventEntrantsCount', count($entrantsMapper->getEventEntrantsById($this->getRequest()->getParam('id')))); $this->getView()->set('eventComments', $commentMapper->getCommentsByKey('events/show/event/id/' . $this->getRequest()->getParam('id'))); }
public function showAction() { if ($this->getRequest()->isPost('delete')) { $eventMapper = new EventMapper(); $eventMapper->delete($this->getRequest()->getParam('id')); $this->addMessage('deleteSuccess'); $this->redirect(array('action' => 'index')); } $eventMapper = new EventMapper(); $this->getView()->set('event', $eventMapper->getEventById($this->getRequest()->getParam('id'))); }
public function treatAction() { $eventMapper = new EventMapper(); $eventModel = new EventModel(); $event = $eventMapper->getEventById($this->getRequest()->getParam('id')); if ($this->getRequest()->getParam('id')) { $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('menuEvents'), array('action' => 'index'))->add($event->getTitle(), array('controller' => 'show', 'action' => 'event', 'id' => $event->getId()))->add($this->getTranslator()->trans('edit'), array('action' => 'treat', 'id' => $event->getId())); $this->getView()->set('event', $eventMapper->getEventById($this->getRequest()->getParam('id'))); } else { $this->getLayout()->getHmenu()->add($this->getTranslator()->trans('menuEvents'), array('action' => 'index'))->add($this->getTranslator()->trans('add'), array('action' => 'treat')); } $imageAllowedFiletypes = $this->getConfig()->get('event_filetypes'); $imageHeight = $this->getConfig()->get('event_height'); $imageWidth = $this->getConfig()->get('event_width'); $imageSize = $this->getConfig()->get('event_size'); if ($this->getRequest()->isPost()) { if ($this->getRequest()->getParam('id')) { $eventModel->setId($this->getRequest()->getParam('id')); $event = $eventMapper->getEventById($this->getRequest()->getParam('id')); } $title = trim($this->getRequest()->getPost('title')); $start = new \Ilch\Date(trim($this->getRequest()->getPost('start'))); $place = trim($this->getRequest()->getPost('place')); $text = trim($this->getRequest()->getPost('text')); $show = trim($this->getRequest()->getPost('calendarShow')); if ($this->getRequest()->getPost('end') != '') { $end = new \Ilch\Date(trim($this->getRequest()->getPost('end'))); } if (!empty($_FILES['image']['name'])) { $path = $this->getConfig()->get('event_uploadpath'); $file = $_FILES['image']['name']; $file_tmpe = $_FILES['image']['tmp_name']; $endung = strtolower(pathinfo($file, PATHINFO_EXTENSION)); $file_size = $_FILES['image']['size']; if (in_array($endung, explode(' ', $imageAllowedFiletypes))) { $size = getimagesize($file_tmpe); $width = $size[0]; $height = $size[1]; if ($file_size <= $imageSize and $width == $imageWidth and $height == $imageHeight) { $image = $path . time() . '.' . $endung; if ($this->getRequest()->getParam('id') and $event->getImage() != '') { $eventMapper->delImageById($this->getRequest()->getParam('id')); } $eventModel->setImage($image); if (move_uploaded_file($file_tmpe, $image)) { $this->addMessage('successImage'); } } else { $this->addMessage('failedFilesize', 'warning'); } } else { $this->addMessage('failedFiletypes', 'warning'); } } if (empty($start)) { $this->addMessage('missingDate', 'danger'); } elseif (empty($title)) { $this->addMessage('missingTitle', 'danger'); } elseif (empty($place)) { $this->addMessage('missingPlace', 'danger'); } elseif (empty($text)) { $this->addMessage('missingText', 'danger'); } else { if (!empty($_FILES['image']['name'])) { $eventModel->setImage($image); } $eventModel->setUserId($this->getUser()->getId()); $eventModel->setTitle($title); $eventModel->setStart($start); $eventModel->setEnd($end); $eventModel->setPlace($place); $eventModel->setText($text); $eventModel->setShow($show); $eventMapper->save($eventModel); $this->addMessage('saveSuccess'); if ($this->getRequest()->getPost('image_delete') != '') { $eventMapper->delImageById($this->getRequest()->getParam('id')); $this->redirect(array('action' => 'treat', 'id' => $this->getRequest()->getParam('id'))); } if ($this->getRequest()->getParam('id')) { $eventId = $this->getRequest()->getParam('id'); $this->redirect(array('controller' => 'show', 'action' => 'event', 'id' => $eventId)); } else { $this->redirect(array('controller' => 'show', 'action' => 'my')); } } } if ($eventMapper->existsTable('calendar') == true) { $this->getView()->set('calendarShow', 1); } $this->getView()->set('image_height', $imageHeight); $this->getView()->set('image_width', $imageWidth); $this->getView()->set('image_size', $imageSize); $this->getView()->set('image_filetypes', $imageAllowedFiletypes); }
/** * @return \Modules\Events\Mappers\Events[] */ public function getEventListPast($limit = null) { $eventMapper = new EventMapper(); $sql = 'SELECT * FROM `[prefix]_events` WHERE start < CURDATE() ORDER BY start DESC'; if ($limit !== null) { $sql .= ' LIMIT ' . $limit; } $rows = $this->db()->queryArray($sql); if (empty($rows)) { return null; } $events = array(); foreach ($rows as $row) { $events[] = $eventMapper->getEventById($row['id']); } return $events; }