/**
  * IS: Parameter id terdeklarasi
  * FS: Mengirimkan ke viewer: event
  * Desc: Fungsi untuk menampilkan detail international event
  */
 public function viewAction()
 {
     // Param
     $id = $this->_getParam('id');
     // Model
     $eventDb = new Model_DbTable_Event();
     // Data
     $event = $eventDb->getAllWithDescById($id, 1);
     // View
     $this->view->event = $event[0];
 }
 /**
  * IS: Parameter id terdeklarasi
  * FS: Mengirimkan ke viewer: form, date_view, show_clock, event_time,
  *     event_id
  * Desc: Mengatur aksi yang dilakukan untuk halaman edit
  */
 public function editAction()
 {
     //set parameter
     $language_id = $this->_getParam('lang');
     $event_id = $this->_getParam('id');
     //creating instance
     $form = new Admin_Form_EventForm();
     $form->setCategorySelectData();
     $table_event = new Model_DbTable_Event();
     $table_event_description = new Model_DbTable_EventDesc();
     $table_poitoevent = new Model_DbTable_PoiToEvent();
     //if this is a post request
     if ($this->getRequest()->isPost()) {
         //preparing data and update for event description
         $event_name = htmlspecialchars($_POST['eventName'], ENT_QUOTES);
         $event_description = htmlspecialchars($_POST['eventDescription'], ENT_QUOTES);
         if ($language_id == 1) {
             $indo = $table_event_description->checkForIndo($event_id, 1);
             if ($indo) {
                 $data = array('event_id' => $event_id, 'language_id' => $language_id, 'name' => $event_name, 'description' => $event_description);
                 $table_event_description->updateEvent($data, $event_id, $language_id);
             } else {
                 $data2 = array('event_id' => $event_id, 'language_id' => $language_id, 'name' => $event_name, 'description' => $event_description);
                 $table_event_description->insertEvent($data2);
             }
         } else {
             if ($_POST['dateStart'] == $_POST['dateEnd']) {
                 $startdate = $_POST['dateStart'] . ' ' . $_POST['timeStart'] . ':00';
                 $enddate = $_POST['dateStart'] . ' ' . $_POST['timeEnd'] . ':00';
             } else {
                 $startdate = $_POST['dateStart'] . ' ' . $_POST['timeStart'] . ':00';
                 $enddate = $_POST['dateEnd'] . ' ' . $_POST['timeEnd'] . ':00';
             }
             //preparing data and update for event table
             $data = array('main_pics' => $_POST['eventImage'], 'date_start' => $startdate, 'date_end' => $enddate, 'category' => $_POST['mainCategory']);
             $table_event->updateEvent($data, $event_id);
             $data = array('event_id' => $event_id, 'language_id' => $language_id, 'name' => $event_name, 'description' => $event_description);
             $table_event_description->updateEvent($data, $event_id, $language_id);
             $poi_count = $_POST['poiMax'];
             $poiarr = array();
             for ($i = 0; $i <= $poi_count; $i++) {
                 if ($_POST['poiValue' . $i] != '') {
                     array_push($poiarr, $_POST['poiValue' . $i]);
                 }
             }
             //create poi related to event list
             $saved_poitoevent = array();
             $saved_list = $table_poitoevent->getAllPoiNameByEventId($event_id);
             //convert to a non ASSOC array
             foreach ($saved_list as $list) {
                 array_push($saved_poitoevent, $list['poi_id']);
             }
             //compare the new list with the new one, if the new one doesnt exist then insert then new one
             foreach ($poiarr as $poi_new) {
                 if (!in_array($poi_new, $saved_poitoevent)) {
                     $data = array('event_id' => $event_id, 'poi_id' => $poi_new);
                     $table_poitoevent->insertEvent($data);
                 }
             }
             //do the complementary process, if the old one doesnot exist in the new list then delete the old ones
             foreach ($saved_poitoevent as $poi_old) {
                 if (!in_array($poi_old, $poiarr)) {
                     if ($poi_old != '') {
                         $table_poitoevent->deleteEvent($event_id, $poi_old);
                     }
                 }
             }
         }
         //preparing data for updating the poi to event data
         $this->loggingaction('event', 'edit', $event_id, $language_id);
         $this->_flash->addMessage("1\\Event Update Success!");
         $this->_redirect($this->view->rootUrl('/admin/eventindo/'));
     }
     if ($language_id == 1) {
         $indo = $table_event_description->checkForIndo($event_id, $language_id);
         if ($indo) {
             $saved_list = $table_poitoevent->getAllPoiNameByEventId($event_id, $language_id);
         }
     } else {
         $saved_list = $table_poitoevent->getAllPoiNameByEventId($event_id, $language_id);
     }
     //data processing
     $event_data = $table_event->getAllWithDescById($event_id, $language_id);
     $event_name = $this->view->HtmlDecode($event_data[0]['name']);
     $event_description = $this->view->HtmlDecode($event_data[0]['description']);
     $poiCount = $table_poitoevent->countRelatedPoiByEventId($event_id);
     $datetime_start = explode(' ', $event_data[0]['date_start']);
     $datetime_end = explode(' ', $event_data[0]['date_end']);
     //set form element value
     $form->eventName->setValue($event_name);
     $form->eventDescription->setValue($event_description);
     $form->eventImage->setValue($event_data[0]['main_pics']);
     $form->dateEnd->setValue($datetime_end[0]);
     $form->dateStart->setValue($datetime_start[0]);
     $form->timeStart->setValue(substr($datetime_start[1], 0, 5));
     $form->timeEnd->setValue(substr($datetime_end[1], 0, 5));
     $form->mainCategory->setValue($event_data[0]['category']);
     $form->poiMax->setValue($poiCount);
     if ($datetime_start[0] == $datetime_end[0]) {
         $this->view->date_view = $datetime_start[0] . ' one day event';
         $this->view->show_clock = TRUE;
     } else {
         $this->view->date_view = $datetime_start[0] . ' until ' . $datetime_end[0];
         $this->view->show_clock = FALSE;
     }
     $this->view->event_time = array($datetime_start[1], $datetime_end[1]);
     $this->view->event_id = $event_id;
     $this->view->form = $form;
     $this->view->langId = $language_id;
 }
 /**
  * IS: Parameter id, title terdeklarasi
  * FS: Mengirimkan ke viewer: event, poiRelated, comments, commentForm
  * Desc: Fungsi untuk menampilkan detail event
  */
 public function detailAction()
 {
     // Variable
     $contentType = 2;
     // Param
     $id = $this->_getParam('id');
     $title = $this->_getParam('title');
     // Model
     $eventDb = new Model_DbTable_Event();
     $poiToEventDb = new Model_DbTable_PoiToEvent();
     // Data
     $event = $eventDb->getAllWithDescById($id, $this->_languageId);
     $author = $eventDb->getAuthor($id, $this->_languageId);
     //if description is empty, will be redirecting to calender event
     //	if($event[0]['description'])
     //	{
     //update data viewer, hanya di incremen 1 saja setiap kali content detail di load
     $eventDb->updateField($id, array('viewer' => $event[0]['viewer'] + 1));
     $poiRelated = $poiToEventDb->getAllPoiNameByEventId($id, $this->_languageId);
     // View
     $this->view->event = $event[0];
     $this->view->poiRelated = $poiRelated;
     //            $this->view->author = $author['name'];
     //	}
     //	else
     //	{
     //	    $this->_redirector->gotoUrl($this->view->baseUrl('/event/calendar/'));
     //	}
 }