public function viewAction()
 {
     $this->accessRights(30);
     //Check User Roles
     $this->childModuleAccessRights(30, 'view');
     //Accept Child Module ID & it's Actions: add, edit, view, disable
     $msgs = '';
     //Get user id and validate
     $events_id = (int) $this->params()->fromRoute('id', 0);
     if (!$events_id) {
         return $this->redirect()->toRoute('event', array('action' => 'index'));
     }
     //Generate Adapter
     $this->adapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter');
     // Get the Event with the specified id.  An exception is thrown
     // if it cannot be found, in which case go to the index page.
     try {
         $event = $this->getEventTable()->getEvent($events_id);
         //Get anchor data
     } catch (\Exception $ex) {
         return $this->redirect()->toRoute('event', array('action' => 'index'));
     }
     $from = (array) $event;
     $form = new EventForm($this->adapter);
     $form->setData($event);
     //Update record after data posting
     $request = $this->getRequest();
     if ($request->isPost()) {
         $form->setData($request->getPost());
         //get previously posted data
         //Update user credentials
         $event = new Event();
         $form->setInputFilter($event->getInputFilter());
         $form->setData($request->getPost());
         if ($form->isValid()) {
             $event->exchangeArray($request->getPost());
             $guest_lists = $this->getEventTable()->fetchAllMediaProfiles($this->adapter, $events_id);
             $from_guest_list = array();
             $to_guest_list = array();
             //Check if we have guests from DB
             if (count($guest_lists) > 0) {
                 foreach ($guest_lists as $guest_list) {
                     $str = $guest_list['media_profiles_id'];
                     //Check if guest is invited
                     if ($guest_list['invited'] == 'checked') {
                         $str .= "|Invited";
                     } else {
                         $str .= "|Uninvited";
                     }
                     //check if user has attended
                     if ($guest_list['attended'] == 'checked') {
                         $str .= "|Attended";
                     } else {
                         $str .= "|Unattended";
                     }
                     //check if user has attended
                     if ($guest_list['confirmed'] == 'checked') {
                         $str .= "|Confirmed";
                     } else {
                         $str .= "|Revoke";
                     }
                     array_push($from_guest_list, $str);
                 }
             }
             //Check if we have new guest lists
             if (count($request->getPost('guest_lists')) > 1) {
                 foreach ($request->getPost('guest_lists') as $guest_list) {
                     $str = $guest_list;
                     //Check if guest is invited
                     $str .= "|" . $this->checkAttendedInvited('Invited', $request->getPost('invites'), $guest_list);
                     //check if user has attended
                     //Check if guest is invited
                     $str .= "|" . $this->checkAttendedInvited('Attended', $request->getPost('attendees'), $guest_list);
                     //check if user has attended
                     //Check if guest is invited
                     $str .= "|" . $this->checkAttendedInvited('Confirmed', $request->getPost('confirmees'), $guest_list);
                     array_push($to_guest_list, $str);
                 }
             }
             //Extract Diff into one string difference
             $differences_guests = array_diff($to_guest_list, $from_guest_list);
             $diff_str = "";
             foreach ($differences_guests as $difference) {
                 $diff_str .= 'media=full_name:' . $this->getEventTable()->getAllGuestLists($this->adapter, explode('|', $difference)[0])['full_name'] . "|";
                 $diff_str .= explode('|', $difference)[1] . "|";
                 $diff_str .= explode('|', $difference)[2] . "|";
                 $diff_str .= explode('|', $difference)[3] . "|";
             }
             //Save to Audit Trail
             //prepare audit trail parameters
             $to = $this->getRequest()->getPost()->toArray();
             $diff = array_diff_assoc($to, $from);
             unset($diff['submit'], $diff['DataTables_Table_0_length'], $diff['guest_lists'], $diff['attendees'], $diff['invites'], $diff['DataTables_Table_1_length'], $diff['guest_list'], $diff['invitee'], $diff['attendee'], $diff['confirmee'], $diff['confirmees']);
             //Remove IDs
             $changes = $this->prepare_modified_data($from, $to, $diff);
             $changes['post'] .= $diff_str;
             $diff_str_from = "";
             //Get the differences and compare from
             foreach ($differences_guests as $difference) {
                 //Find diff from from_variable
                 $find_me = explode('|', $difference)[0];
                 foreach ($from_guest_list as $from_guest_list_expand) {
                     if ($find_me == explode('|', $from_guest_list_expand)[0]) {
                         //Get the guest details
                         $diff_str_from .= 'media=full_name:' . $this->getEventTable()->getAllGuestLists($this->adapter, explode('|', $from_guest_list_expand)[0])['full_name'] . "|";
                         $diff_str_from .= explode('|', $from_guest_list_expand)[1] . "|";
                         $diff_str_from .= explode('|', $from_guest_list_expand)[2] . "|";
                         $diff_str_from .= explode('|', $from_guest_list_expand)[3] . "|";
                     }
                 }
             }
             $changes['pre'] .= $diff_str_from;
             $this->save_to_audit_trail($to['event_name'], $changes['pre'], $changes['post'], 'edit', 30);
             $this->getEventTable()->saveEvent($request->getPost());
             $this->flashMessenger()->addMessage(['content' => $request->getPost('event_name') . ' has been updated.', 'type' => 'success']);
             return $this->redirect()->toRoute('event');
         }
     }
     $view = new ViewModel(array('form' => $form, 'msgs' => $msgs, 'channels' => $this->getEventTable()->fetchAll($this->adapter), 'action' => 'preview', 'events_id' => $events_id, 'media_profiles_new' => $this->getEventTable()->fetchAllMediaProfilesNew($this->adapter, $events_id), 'media_profiles' => $this->getEventTable()->fetchAllMediaProfiles($this->adapter, $events_id), 'access_rights' => $this->getSubModuleAccessRights(30)));
     $view->setTemplate('event/preview');
     return $view;
 }
Esempio n. 2
0
 public function deleteAction()
 {
     $request = $this->getRequest();
     if ($request->isPost()) {
         $event = $request->getPost()->toArray();
         $events_obj = new Event($this->em, new WebsiteTbEvents());
         $json = array('status' => $events_obj->delete($event));
         echo Json::encode($json);
         return false;
     }
 }