Exemplo n.º 1
0
class MapController extends Budpar_Controller_Common
{
    /**
     * IS: -
     * FS: -
     * Desc: Fungsi inisialisasi
     */
    public function init()
    {
        parent::init();
    }
    /**
     * IS: Parameter id terdeklarasi
     * FS: Mengirimkan ke viewer: pageTitle, mapLocationForm, mapDestForm, poi,
     *     categoriesParent
     * Desc: Fungsi untuk menampilkan peta
     */
    public function indexAction()
    {
        $this->_helper->layout->setLayout('kebudayaan');
        // Param
        if ($this->_hasParam('id')) {
            $this->view->id = $this->_getParam('id');
            //echo $this->view->id . ' tes';
        }
        // Form
        $mapLocationForm = new Form_MapLocationForm();
        $mapDestForm = new Form_MapDestForm();
        $mapCategoryForm = new Form_MapCategoryForm();
 /**
  * IS: Parameter id, sortby, dan sortorder terdeklarasi
  * FS: Mengirimkan ke viewer: pageTitle, category, destination, areaDb
  * Desc: Fungsi untuk menampilkan detail activity dan menampilkan destinasi2
  *       yang termasuk activity tersebut
  */
 public function detailAction()
 {
     // Set layout
     $this->_helper->layout->setLayout('kebudayaan');
     // Param
     $id = $this->_getParam('id');
     $sortBy = $this->_getParam('sortby');
     $sortOrder = $this->_getParam('sortorder', 'desc');
     $title = null;
     // Model
     $categoryDb = new Model_DbTable_Category();
     $destDescDb = new Model_DbTable_DestinationDescription();
     $areaDb = new Model_DbTable_Area();
     // Data
     $destinationQuery = $destDescDb->getSearch('', '', $id, $this->_languageId, array('sort_by' => $sortBy, 'sort_order' => $sortOrder));
     $category = $categoryDb->getByLangAndId($id, $this->_languageId);
     $this->_generateSorter($sortBy, $sortOrder);
     // View
     $this->view->pageTitle = $category['name'];
     $this->view->category = $category;
     $this->view->count = count($destinationQuery);
     $this->view->destination = $destinationQuery;
     // $this->view->destination = parent::setPaginator($destinationQuery);
     $this->view->areaDb = $areaDb;
 }
 /**
  * IS: Parameter id, sortby, dan sortorder terdeklarasi
  * FS: Mengirimkan ke viewer: pageTitle, category, destination, areaDb
  * Desc: Fungsi untuk menampilkan detail activity dan menampilkan destinasi2
  *       yang termasuk activity tersebut
  */
 public function detailAction()
 {
     // Set layout
     $this->_helper->layout->setLayout('kebudayaan');
     // Param
     $id = $this->_getParam('id');
     $sortBy = $this->_getParam('sortby');
     $sortOrder = $this->_getParam('sortorder', 'desc');
     $page = $this->_getParam('page');
     $title = null;
     // Model
     $categoryDb = new Model_DbTable_Category();
     $destDescDb = new Model_DbTable_DestinationDescription();
     $areaDb = new Model_DbTable_Area();
     // Data
     $destinationQuery = $destDescDb->getSearch('', '', $id, $this->_languageId, array('sort_by' => $sortBy, 'sort_order' => $sortOrder));
     $paginator = Zend_Paginator::factory($destinationQuery);
     $paginator->setItemCountPerPage(8);
     $paginator->setCurrentPageNumber($page);
     $category = $categoryDb->getByLangAndId($id, $this->_languageId);
     $this->view->headTitle()->prepend($category['name']);
     $this->view->category = $category;
     $this->view->paginator = $paginator;
     $this->view->culture_chunk = array_chunk(iterator_to_array($paginator), 2);
     $this->view->languageId = $this->_languageId;
     $this->view->languageID = $this->_languageId;
     $this->view->langId = $this->_languageId;
     $this->view->getImg = function ($file) {
         return UPLOAD_FOLDER . $FILE;
     };
     array_unshift($this->_meta, $category['name'], "kategori kebudayaan", "kategori budaya");
     $this->view->headMeta()->appendName('keywords', join(', ', $this->_meta));
     $this->view->headMeta()->appendName('description', "Kebudayaan Indonesia - Laman referensi kebudayaan Indonesia. Turut mewujudkan bangsa Indonesia yang cerdas dan berbudaya");
     $this->view->headLink()->headLink(array('rel' => 'canonical', 'href' => Zend_Controller_Front::getInstance()->getRequest()->getScheme() . '://' . Zend_Controller_Front::getInstance()->getRequest()->getHttpHost() . $this->view->url(array('id' => $category['category_id'], 'slug' => $this->view->makeUrlFormat($category['name'])), $this->_languageId == 1 ? 'subkategori' : 'subcategory', true)), 'PREPEND');
 }
Exemplo n.º 4
0
 protected function _generateCommon()
 {
     // Param set variable
     $this->_destId = $this->_getParam('destId');
     // Model
     $destDb = new Model_DbTable_Destination();
     $destDescDb = new Model_DbTable_DestinationDescription();
     $areaToPoiDb = new Model_DbTable_AreaToPoi();
     $lang = $this->_languageId;
     if ($lang == 1) {
         $destination = $destDb->getAllByIdLang($this->_destId, $this->_languageId);
     } else {
         $destination = $destDb->getAllByIdLangForIndo($this->_destId, $this->_languageId);
     }
     if ($this->_sess->userId) {
         $this->view->rate = $this->_rate;
     }
     //$destProvince = $areaToPoiDb->getProvinceByPoiId($this->_destId);
     $nameDest = $destDescDb->getNameById($this->_destId, $this->_languageId);
     $taglineDest = $destDescDb->getTaglineById2($this->_destId, $this->_languageId);
     if ($taglineDest != null) {
         $nameDestfull = $nameDest . " : " . $taglineDest;
     } else {
         $nameDestfull = $nameDest;
     }
     // - Set protected value variables
     $this->_destTitle = $destDescDb->getNameById($this->_destId, $this->_languageId);
     $this->_formatDestTitle = $this->view->makeUrlFormat($this->_destTitle);
     // View
     $this->view->destination = $destination;
     $this->view->destId = $this->_destId;
     $this->view->destTitle = $nameDestfull;
     $this->view->formatDestTitle = $this->_formatDestTitle;
 }
     // Tidak pake view
     $this->_helper->viewRenderer->setNoRender(true);
     // Param
     $categoryId = $this->_getParam('categoryId');
     // Model
     //$destModel = new Model_Destination;
     $destDescDb = new Model_DbTable_DestinationDescription();
     // Data
     $destination = $destDescDb->getAllByCategoryList($categoryId, $this->_languageId);
     $destinationData = $this->_createArrayDestination($destination);
     echo json_encode($destinationData);
 }
 /**
  * IS: 
Exemplo n.º 6
0
 public function getAllForMap()
 {
     $destDescDb = new Model_DbTable_DestinationDescription();
     $destination = $destDescDb->getAllForMap($this->_languageId);
     $poiInfo = array();
     $poiCategories = array();
     foreach ($destination as $row) {
         $poiInfo[$row['poi_id']] = array();
         $poiInfo[$row['poi_id']]['descname'] = $row['descname'];
         $poiInfo[$row['poi_id']]['x'] = $row['pointX'];
         $poiInfo[$row['poi_id']]['y'] = $row['pointY'];
         $poiInfo[$row['poi_id']]['des'] = $this->_getContentBox($row);
         if ($row['category_id']) {
             $poiCategories[$row['poi_id']] = $row['category_id'];
         }
     }
     $this->_poiInfo = $poiInfo;
     $this->_poiCategories = $poiCategories;
 }
 /**
  * IS: -
  * FS: Mengirimkan ke viewer: ajax, pageTitle, sectionTitle,sectionContent
  * Desc: Fungsi untuk menampilkan informasi tips
  */
 public function tipsAction()
 {
     $this->_helper->layout->setLayout('one-column');
     // untuk menghitung page view
     $this->view->pageViewer = $this->countView();
     if ($this->_request->isXmlHttpRequest()) {
         $this->_helper->layout->disableLayout();
         $this->view->ajax = true;
     }
     // Model
     $destDescDb = new Model_DbTable_DestinationDescription();
     // Data
     $tips = $destDescDb->getTipsByIdLang($this->_destId, $this->_languageId);
     $tips = $this->_replaceImageUrl($tips);
     // Breadcrumb
     $pageTitle = $this->view->translate('id_poi_tips');
     $this->_generateDescBreadcrumb($pageTitle);
     // Passing ke view
     $this->view->pageTitle = $this->_destTitle . ' - ' . $pageTitle;
     $this->view->sectionTitle = $pageTitle;
     $this->view->sectionContent = $this->view->HtmlDecode($tips);
     if ($this->_request->isXmlHttpRequest()) {
         $this->render('detail');
     } else {
         $this->view->tab = 'tips';
     }
     $this->render('index');
     //$this->render('destination');
 }
 public function deletetranslationAction()
 {
     $this->_helper->viewRenderer->setNoRender();
     $id = $this->_getParam('id');
     if (null != $id) {
         $tbl = new Model_DbTable_Destination();
         $tbl_description = new Model_DbTable_DestinationDescription();
         $culture = $tbl->find($id)->current();
         if (null != $culture) {
             $tbl_description->fetchRow(array('poi_id = ?' => $id, 'language_id = ?' => 2))->delete();
             $this->loggingaction('Culture', 'Delete', $id, 2);
             $this->_helper->flashMessenger->addMessage('Translasi berhasil dihapus.');
         }
     }
     $this->_helper->redirector('index');
 }
 /**
  * IS: Parameter id terdeklarasi
  * FS: Mengirimkan ke viewer: poi_id, form, gkey, header_image
  * Desc: Mengatur aksi yang dilakukan untuk halaman edit
  */
 public function editAction()
 {
     /*retrieving parameter and creating form*/
     $poi_id = $this->_getParam('id');
     $language_id = $this->_getParam('lang');
     //create instance of destination table and get destination data
     $table_destination = new Model_DbTable_Destination();
     $table_destination_description = new Model_DbTable_DestinationDescription();
     $table_category = new Model_DbTable_Category();
     $table_categorytopoi = new Model_DbTable_CategoryToPoi();
     $table_area = new Model_DbTable_Area();
     $table_areatopoi = new Model_DbTable_AreaToPoi();
     $table_relatedpoi = new Model_DbTable_RelatedPoi();
     $data = null;
     $form = new Admin_Form_PoiFormIndo();
     $table_related_article_poi = new Model_DbTable_RelatedArticlePoi();
     //get realated article data
     // @param =  article_id
     $ralated_poi = $table_related_article_poi->getByPoiId($poi_id, $language_id);
     $this->view->edit = 1;
     $this->view->ralated_poi = $ralated_poi;
     $this->view->poi_id = $poi_id;
     /*Update Process*/
     if ($this->getRequest()->isPost()) {
         //if the form is valid
         if ($form->isValid($_POST)) {
             //check if it is a special destination or not
             if ($language_id != 2) {
                 $indo = $table_destination_description->checkForEnglish($poi_id);
                 if (!$indo) {
                     if ($_POST['SpecialDestination'] == 1) {
                         $header_image = preg_replace("/'/", "'", $_POST['HeaderImage']);
                     } else {
                         $header_image = null;
                     }
                     $PoiName = preg_replace("/'/", "'", $_POST['PoiName']);
                     $PoiTagLine = preg_replace("/'/", "'", $_POST['PoiTagline']);
                     $PoiInformation = preg_replace("/'/", "'", $_POST['PoiInformation']);
                     $PoiHowToGetThere = preg_replace("/'/", "'", $_POST['PoiHowToGetThere']);
                     $PoiHowToGetAround = preg_replace("/'/", "'", $_POST['PoiHowToGetAround']);
                     $PoiWhatToDo = preg_replace("/'/", "'", $_POST['PoiWhatToDo']);
                     $PoiWhereToEat = preg_replace("/'/", "'", $_POST['PoiWhereToEat']);
                     $PoiWhereToStay = preg_replace("/'/", "'", $_POST['PoiWhereToStay']);
                     $PoiWhatToBuy = preg_replace("/'/", "'", $_POST['PoiWhatToBuy']);
                     $PoiTips = preg_replace("/'/", "'", $_POST['PoiTips']);
                     $desc = array('poi_id' => $poi_id, 'language_id' => $language_id, 'name' => $PoiName, 'tagline' => $PoiTagLine, 'description' => $PoiInformation, 'howToGetThere' => $PoiHowToGetThere, 'howToGetAround' => $PoiHowToGetAround, 'whatToDo' => $PoiWhatToDo, 'whereToEat' => $PoiWhereToEat, 'whereToStay' => $PoiWhereToStay, 'whatToBuy' => $PoiWhatToBuy, 'tips' => $PoiTips, 'header_image' => $header_image);
                     //updating data to the database
                     $table_destination_description->insertPoiDescription($desc);
                 } else {
                     if ($_POST['SpecialDestination'] == 1) {
                         $header_image = preg_replace("/'/", "'", $_POST['HeaderImage']);
                     } else {
                         $header_image = null;
                     }
                     $PoiName = preg_replace("/'/", "'", $_POST['PoiName']);
                     $PoiTagLine = preg_replace("/'/", "'", $_POST['PoiTagline']);
                     $PoiInformation = preg_replace("/'/", "'", $_POST['PoiInformation']);
                     $PoiHowToGetThere = preg_replace("/'/", "'", $_POST['PoiHowToGetThere']);
                     $PoiHowToGetAround = preg_replace("/'/", "'", $_POST['PoiHowToGetAround']);
                     $PoiWhatToDo = preg_replace("/'/", "'", $_POST['PoiWhatToDo']);
                     $PoiWhereToEat = preg_replace("/'/", "'", $_POST['PoiWhereToEat']);
                     $PoiWhereToStay = preg_replace("/'/", "'", $_POST['PoiWhereToStay']);
                     $PoiWhatToBuy = preg_replace("/'/", "'", $_POST['PoiWhatToBuy']);
                     $PoiTips = preg_replace("/'/", "'", $_POST['PoiTips']);
                     $desc = array('poi_id' => $poi_id, 'language_id' => 1, 'name' => $PoiName, 'tagline' => $PoiTagLine, 'description' => $PoiInformation, 'howToGetThere' => $PoiHowToGetThere, 'howToGetAround' => $PoiHowToGetAround, 'whatToDo' => $PoiWhatToDo, 'whereToEat' => $PoiWhereToEat, 'whereToStay' => $PoiWhereToStay, 'whatToBuy' => $PoiWhatToBuy, 'tips' => $PoiTips, 'header_image' => $header_image);
                     //updating data to the database
                     $table_destination_description->UpdatePoiDescription($desc, $poi_id, 1);
                 }
             } else {
                 if ($_POST['SpecialDestination'] == 1) {
                     //if it was a special destination but no image uploaded
                     if ($_POST['HeaderImage'] == '') {
                         $this->_flash->addMessage('3\\Warning: Data is saved without image! You should upload an image for a featured destination.');
                     } else {
                         $header_image = preg_replace("/'/", "'", $_POST['HeaderImage']);
                     }
                 } else {
                     $header_image = null;
                 }
                 $PoiName = preg_replace("/'/", "'", $_POST['PoiName']);
                 $PoiAddress = preg_replace("/'/", "'", $_POST['PoiAddress']);
                 $PoiPhone = preg_replace("/'/", "'", $_POST['PoiPhone']);
                 $PoiWebsite = preg_replace("/'/", "'", $_POST['PoiWebsite']);
                 if ($_POST['SpecialDestination'] == 0) {
                     $SpecialDestination = 0;
                 } else {
                     $SpecialDestination = 1;
                 }
                 /*preparing data for Poi table*/
                 $data = array('pointX' => $_POST['pointx'], 'pointY' => $_POST['pointy'], 'address' => $PoiAddress, 'phone' => $PoiPhone, 'website' => $PoiWebsite, 'main_category' => $_POST['MainCategory'], 'popular' => $_POST['PopularSelect'], 'status' => $_POST['SaveStatus'], 'special' => $SpecialDestination, 'header_image' => ' ');
                 /*updating data to Poi table and get the last inserted poi id*/
                 $table_destination->updatePoi($data, $poi_id);
                 /*preparing data for poi description table*/
                 $PoiTagLine = preg_replace("/'/", "'", $_POST['PoiTagline']);
                 $PoiInformation = preg_replace("/'/", "'", $_POST['PoiInformation']);
                 $PoiHowToGetThere = preg_replace("/'/", "'", $_POST['PoiHowToGetThere']);
                 $PoiHowToGetAround = preg_replace("/'/", "'", $_POST['PoiHowToGetAround']);
                 $PoiWhatToDo = preg_replace("/'/", "'", $_POST['PoiWhatToDo']);
                 $PoiWhereToEat = preg_replace("/'/", "'", $_POST['PoiWhereToEat']);
                 $PoiWhereToStay = preg_replace("/'/", "'", $_POST['PoiWhereToStay']);
                 $PoiWhatToBuy = preg_replace("/'/", "'", $_POST['PoiWhatToBuy']);
                 $PoiTips = preg_replace("/'/", "'", $_POST['PoiTips']);
                 $desc = array('poi_id' => $poi_id, 'language_id' => 2, 'name' => $PoiName, 'tagline' => $PoiTagLine, 'description' => $PoiInformation, 'howToGetThere' => $PoiHowToGetThere, 'howToGetAround' => $PoiHowToGetAround, 'whatToDo' => $PoiWhatToDo, 'whereToEat' => $PoiWhereToEat, 'whereToStay' => $PoiWhereToStay, 'whatToBuy' => $PoiWhatToBuy, 'tips' => $PoiTips, 'header_image' => $header_image);
                 //updating data to the database
                 $table_destination_description->UpdatePoiDescription($desc, $poi_id, 2);
                 /*preparing data for categorytopoi table
                  *Get category count and data*/
                 $category_count = $this->_getParam('MaxCategory');
                 $category_stack = array();
                 for ($i = 0; $i <= $category_count; $i++) {
                     if (!empty($_POST['catValue' . $i])) {
                         array_push($category_stack, $_POST['catValue' . $i]);
                     }
                 }
                 /*inserting data for categorytopoi table*/
                 $category_list = $table_categorytopoi->getCategoryIdByPoiId($poi_id);
                 /*convert to non associative array*/
                 $saved_category = array();
                 foreach ($category_list as $temp_cat) {
                     array_push($saved_category, $temp_cat['category_id']);
                 }
                 /*processing the data
                   if the posted data not found on saved category id list then insert the data */
                 foreach ($category_stack as $category_new) {
                     if (!in_array($category_new, $saved_category)) {
                         $category_poi = array('category_id' => $category_new, 'poi_id' => $poi_id);
                         $table_categorytopoi->insertCategoryToPoi($category_poi, 2);
                     }
                 }
                 /*complement check, if the data on saved category list not found on posted category
                   then delete that data on the database*/
                 foreach ($saved_category as $old_category) {
                     if (!in_array($old_category, $category_stack)) {
                         $table_categorytopoi->deleteCategoryToPoi($old_category, $poi_id);
                     }
                 }
                 /* We do it the same way for processing the area data
                  * First, we obtain the data from the database and then convert it
                  * to a non assoc. array*/
                 $areatopoi_list = $table_areatopoi->getPoiAreaId($poi_id);
                 $saved_area = array();
                 foreach ($areatopoi_list as $temp_area) {
                     array_push($saved_area, $temp_area['area_id']);
                 }
                 /* Obtain the list of the new area data posted from the form*/
                 $area_count = $this->_getParam('MaxArea');
                 $area_stack = array();
                 for ($i = 0; $i <= $area_count; $i++) {
                     if (!empty($_POST['areaValue' . $i])) {
                         array_push($area_stack, $_POST['areaValue' . $i]);
                     }
                 }
                 /* Compare the new area list with the old area list
                  *  if its not in the old area list then insert to the database*/
                 foreach ($area_stack as $new_area) {
                     if (!in_array($new_area, $saved_area)) {
                         $area_poi = array('area_id' => $new_area, 'poi_id' => $poi_id);
                         $table_areatopoi->insertAreaToPoi($area_poi);
                     }
                 }
                 /* Now we do the complement action
                  * compare the old list with the new list,
                  * delete if not found on the new list*/
                 foreach ($saved_area as $old_area) {
                     if (!in_array($old_area, $area_stack)) {
                         $table_areatopoi->deleteAreaToPoi($old_area, $poi_id);
                     }
                 }
                 /*related poi data processing*/
                 $relpoi_stack = array();
                 $relCtr = $_POST['relPoi_counter'];
                 for ($i = 0; $i <= $relCtr; $i++) {
                     if (!empty($_POST['relpoi' . $i])) {
                         array_push($relpoi_stack, $_POST['relpoi' . $i]);
                     }
                 }
                 $saved_relpoi = $table_relatedpoi->getAllRelatedByPoiIdLangId($poi_id, $language_id);
                 $old_relpoi = array();
                 if (sizeof($saved_relpoi) > 0) {
                     foreach ($saved_relpoi as $value) {
                         array_push($old_relpoi, $value['related_poi']);
                     }
                 }
                 foreach ($relpoi_stack as $value) {
                     if (!in_array($value, $old_relpoi)) {
                         $data = array('poi_id' => $poi_id, 'related_poi' => $value);
                         $table_relatedpoi->insertRelatedPoi($data);
                     }
                 }
                 foreach ($old_relpoi as $value) {
                     if (!in_array($value, $relpoi_stack)) {
                         $table_relatedpoi->deleteSpecificRelatedPoi($poi_id, $value);
                     }
                 }
             }
             ////$this->_helper->layout()->disableLayout();
             ////$this->_helper->viewRenderer->setNoRender(true);
             /* update related article */
             //param
             // this part add related
             if ($_POST['counterRelated'] > 0) {
                 $counter = $_POST['counterRelated'];
                 for ($i = 1; $i <= $counter; $i++) {
                     //echo $_POST['link'.$i];
                     //cek existing label and link in database
                     // if $cek having value = false, then data will be saved
                     if (isset($_POST['label' . $i])) {
                         $cek = $table_related_article_poi->cek_existing($_POST['label' . $i], $_POST['link' . $i]);
                         if (!$cek or $cek == false) {
                             $data = array('poi_id' => $poi_id, 'label' => $_POST['label' . $i], 'link' => $_POST['link' . $i], 'language_id' => $language_id);
                             $table_related_article_poi->insertRelated($data);
                         }
                     }
                 }
             }
             //bagian untuk menghapus data related artikel
             if ($_POST['counterDel'] > 0) {
                 $counterDel = $_POST['counterDel'];
                 for ($i = 1; $i <= $counterDel; $i++) {
                     //cek existing label and link in database
                     // if found, data will be removed
                     if (isset($_POST['labeldel' . $i])) {
                         $cek = $table_related_article_poi->cek_existing_forDel($_POST['labeldel' . $i], $_POST['linkdel' . $i]);
                     }
                 }
             }
             //Send a success message via flashmessenger
             $this->loggingaction('destination', 'edit', $poi_id, $language_id);
             $this->_flash->addMessage('1\\Destination English Update Success!');
             //redirect to the destination list page
             $this->_redirect($this->view->rootUrl('/admin/destinationindo/'));
         }
     }
     /*load data from the database preparing for view process*/
     if ($language_id == 2) {
         $data = $table_destination->getAllByIdLangForIndo($poi_id, $language_id);
         $parent_category = $table_category->getparentCategoryId($data['main_category']);
         $parent_area = $table_areatopoi->getPoiAreaId($poi_id);
     } else {
         $indo = $table_destination_description->checkForEnglish($poi_id);
         if ($indo) {
             $data = $table_destination->getAllByIdLangForIndo($poi_id, $language_id);
         }
     }
     $tesheader = $table_destination_description->getheaderimagebyid2($poi_id, $language_id);
     /*Set every element Value*/
     if ($data != null) {
         $form->Poi_Name->setValue($this->view->HtmlDecode($data['name']));
         $form->Popular_Select->setValue($this->view->HtmlDecode($data['popular']));
         $form->Poi_Address->setValue($this->view->HtmlDecode(strip_tags($data['address'])));
         $form->Poi_Website->setValue($data['website']);
         $form->Poi_Phone->setValue($data['phone']);
         $form->Poi_TagLine->setValue($this->view->HtmlDecode($data['tagline']));
         $form->Poi_Information->setValue($this->view->HtmlDecode($data['description']));
         $form->Poi_HowToGetThere->setValue($this->view->HtmlDecode($data['howToGetThere']));
         $form->Poi_HowToGetAround->setValue($this->view->HtmlDecode($data['howToGetAround']));
         $form->Poi_WhatToDo->setValue($this->view->HtmlDecode($data['whatToDo']));
         $form->Poi_WhereToEat->setValue($this->view->HtmlDecode($data['whereToEat']));
         $form->Poi_WhereToStay->setValue($this->view->HtmlDecode($data['whereToStay']));
         $form->Poi_WhatToBuy->setValue($this->view->HtmlDecode($data['whatToBuy']));
         $form->Poi_Tips->setValue($this->view->HtmlDecode($data['tips']));
         $form->Poi_x->setValue($data['pointX']);
         $form->Poi_y->setValue($data['pointY']);
         $form->HeaderImage->setValue($tesheader['header_image']);
     }
     /*check if this is a special destination, if it is, then checkbox value to true*/
     if ($table_destination->checkSpecialDestination($poi_id)) {
         $form->SpecialDestination->setChecked(true);
         $this->view->state_special = TRUE;
     } else {
         $form->SpecialDestination->setChecked(false);
         $this->view->state_special = FALSE;
     }
     /*send data image filename to the view*/
     $this->view->header_image = $data['header_image'];
     /*set another value to the form element*/
     $area_amount = $table_areatopoi->countAreaByPoiId($poi_id);
     $category_amount = $table_categorytopoi->countCategoryByPoiId($poi_id);
     $main_category = $table_destination->getMainCategoryById($poi_id);
     $form->Category_counter->setValue($category_amount);
     $form->Count_category->setValue($category_amount);
     $form->Main_category->setValue($main_category['main_category']);
     $form->Area_counter->setValue($area_amount);
     $form->Count_area->setValue($area_amount);
     /*send form to view class*/
     $this->view->poi_id = $poi_id;
     $this->view->form = $form;
     $this->view->language_id = $language_id;
     /*get google map key from zend registry and send it to the view*/
 }
 public function tagLinkUsercontributorDetail($userStoryId, $lang_id, $url)
 {
     $userStoryTag = new Model_DbTable_UserStoryTag();
     $detailTags = $userStoryTag->getTag($userStoryId, $lang_id);
     $event = new Model_DbTable_EventDesc();
     $destination = new Model_DbTable_DestinationDescription();
     $article = new Model_DbTable_ArticleDescription();
     $related = '<ul>';
     //
     if (count($detailTags) > 0) {
         //$related = count($detailTags);
         foreach ($detailTags as $tags) {
             if ($tags->object_type == 'event') {
                 $getEvent = $event->getEvenName($tags->object_id, $lang_id);
                 $related .= '<li><a target="_blank" href="' . $url . '/event/detail/' . $tags->object_id . '/' . $getEvent['name'] . '">' . $getEvent['name'] . '</a></li>';
             } else {
                 if ($tags->object_type == 'destination') {
                     $getDest = $destination->getDestName($tags->object_id, $lang_id);
                     $related .= '<li><a target="_blank" href="' . $url . '/destination/' . $tags->object_id . '/' . $getDest['name'] . '">' . $getDest['name'] . '</a></li>';
                 } else {
                     $getArticle = $article->getArticleName($tags->object_id, $lang_id);
                     if (!empty($getArticle['poi_id'])) {
                         $Dest = $destination->getDestName($getArticle['poi_id'], $lang_id);
                         $related .= '<li><a target="_blank" href="' . $url . '/destination/' . $getArticle['poi_id'] . '/' . $Dest['name'] . '/article/' . $tags->object_id . '/' . $getArticle['title'] . '">' . $getArticle['title'] . '</a></li>';
                     }
                 }
             }
         }
         $related .= '</ul>';
         return $related;
     } else {
         //            $related .= '<li> - </li>';
         //            $related .= '</ul>';
         return false;
     }
 }