/** * Gets the Event entrants. * * @param integer $id * @return EntrantsModel|null */ public function getEventEntrantsById($eventId) { $entryArray = $this->db()->select('*')->from('events_entrants')->where(array('event_id' => $eventId))->limit('17')->execute()->fetchRows(); if (empty($entryArray)) { return null; } $entry = array(); foreach ($entryArray as $entries) { $entryModel = new EntrantsModel(); $entryModel->setUserId($entries['user_id']); $entryModel->setStatus($entries['status']); $entry[] = $entryModel; } return $entry; }
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'))); }