<?php

/* * *************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name     : StaticpageController.php
 * File Desc.    : Staticpage controller managed all staic content pages
 * Created By    : Piyush Tiwari <piyush@catpl.co.in>
 * Created Date  : 23 May 2018
 * Updated Date  : 23 May 2018
 * ************************************************************* */

class Admin_ExploresaudiController extends Zend_Controller_Action{

    public $dbAdapter;
    public $perPageLimit;
    public $siteurl;
    public $DIR_WRITE_MODE;

    public function init() {
        /* Initialize db and session access */
        $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
        $this->siteurl = $aConfig['bootstrap']['siteUrl'];
        $this->appmode = $aConfig['bootstrap']['appmode'];
        $this->per_page_record = 20;
        $this->dbAdapter = Zend_Db_Table::getDefaultAdapter();
        $auth = Zend_Auth::getInstance();
        $authStorage = $auth->getStorage()->read();
        $this->username = $authStorage->username;
        $this->admin_type = $authStorage->role;

        $this->current_time = time();
       
     $options = $aConfig['bootstrap'];
     $this->stylecss = $options['stylecss'];

     $this->imageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/'.$this->stylecss.'/';
     $this->imageUrl1 = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/category/';
$this->imageUrl2 = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/exploresaudi/';

        $this->banner_large_image_width = $options['banner_large_image_width'];
        $this->banner_large_image_height = $options['banner_large_image_height'];
        $this->banner_medium_image_width = $options['banner_medium_image_width'];
        $this->banner_medium_image_height = $options['banner_medium_image_height'];
        $this->banner_small_image_width = $options['banner_small_image_width'];
        $this->banner_small_image_height = $options['banner_small_image_height'];
        
        
        $this->large_image_width = $options['large_image_width'];
        $this->large_image_height = $options['large_image_height'];
        $this->medium_image_width = $options['medium_image_width'];
        $this->medium_image_height = $options['medium_image_height'];
        $this->small_image_width = $options['small_image_width'];
        $this->small_image_height = $options['small_image_height'];

        $this->DIR_WRITE_MODE = 0777;

        $this->table = 'tbl_thingstodo';
        $this->commenttable = 'tbl_comments';
		//$_SERVER["DOCUMENT_ROOT"] = $_SERVER["DOCUMENT_ROOT"].'/holidaybazaar';
    }

    /**
     * index() method is used to admin login for form call
     * @param Null
     * @return Array 
     */

      public function getMultiDestinationdataAction(){

        $this->_helper->viewRenderer->setNoRender(true);
        $this->_helper->layout->disableLayout();
        $crud = new Admin_Model_CRUD();
//       print_r($this->getRequest()->getParam("query"));
//       exit;
        try {
            $arrResponse = array();
            if ($this->getRequest()->getParam("term") or $this->getRequest()->getParam("query")) {
                $term = $this->getRequest()->getParam("term") ? $this->getRequest()->getParam("term") : $this->getRequest()->getParam("query");
                $countryId = $this->getRequest()->getParam("countryId") ? $this->getRequest()->getParam("countryId") : '';

                $condCity = "tbl.Title like '" . $term . "%'";
                if (isset($countryId) && !empty($countryId)) {
                    $condCity .= " AND tbl.ContSysId = " . $countryId . "";
                }
                
                $arrResponse = $crud->getDestinationAutoSuggest($condCity);
                                 
                if(empty($arrResponse)){
                    $condCity = "tbl.title like '" . $term . "%'";
                //echo $condCity;die;
                $arrResponse = $crud->getCountryAutoSuggest($condCity);

                }
//                 print_r($arrResponse);die;
            }
            echo json_encode($arrResponse);
            exit;
        } catch (Exception $e) {
            $response = array('success' => false, 'msg' => $e->getMessage());
            echo json_encode($response);
            exit;
        }
    }
 
    public function indexAction(){
       
        //Check admin logedin or not
        $this->checklogin();
        $getData = array();
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            $searchArr = array(
                'TravId' => $getData['TravId'],
                'rows' => $getData['rows'],
                'page' => $getData['page'],
            );
            $crud = new Admin_Model_CRUD();
            $crud->searchArrt = $searchArr;
            $resulsetold = $crud->getCount('tbl_exploresaudi', ['isMarkForDel' => 0], 'TravId');
            $resultset = $crud->rv_select_all('tbl_exploresaudi', ['*'], ['IsMarkForDel' => 0, 'status' => 1],['TravId' => 'DESC']);

            $resultsetArr = array();
            foreach ($resultset as $key => $value){
                
                $resultsetArr[] = [
                
                 'TravId' =>  $value['TravId'],  
                 'TravTitle' =>  htmlentities($value['TravTitle']),  
                 'TravImage' =>  $value['TravImage'],  
                 'TravBannerImage' =>  $value['TravBannerImage'],  
                 'TravDestination' =>  $value['TravDestination'],  
                 'TravUploadedBy' =>  $value['TravUploadedBy'],  
                 'TravDate' =>  $value['TravDate'],  
                 'TravDays' =>  $value['TravDays'],  
                 'TravTraveller' =>  $value['TravTraveller'],  
                 'TravCost' =>  $value['TravCost'],  
                 'TravDescription' =>  htmlentities($value['TravDescription']),  
                 'CreateDate' =>  $value['CreateDate'],  
                 'TravMultiImage' =>  $value['TravMultiImage'],  
                 'displayOnBanner' =>  $value['displayOnBanner'],  
                 'status' =>  ($value['status']==1) ? 'Activate' : 'Deactivate',  
                 'category' =>  $value['category'],  
                 'tags' =>  $value['tags'],  
                ];
            }
           // echo"<pre>";print_r(html_entity_decode($resultsetArr));
            $result = Zend_Json::encode($resultsetArr); 
           //echo"<pre>"; print_r($result); die;
            $newResult = Zend_Json::decode($result, false);
            $finalResult["total"] = $resulsetold[0]['TravId'];
            $finalResult["rows"] = $newResult;
                       //echo"<pre>"; print_r($finalResult); die;

            echo json_encode($finalResult); 
            exit;
        }
    }

    public function editexploresaudiAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editexploresaudi();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/exploresaudi/editexploresaudi/id/" . $pId);

        $form->setName("edit_exploresaudi");
          $resultsetPackage = $crud->rv_select_all('tb_tbb2c_packages_master', ['PkgSysId', 'GTXPkgId', 'LongJsonInfo', 'Destinations'], ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1],['PkgSysId' => 'DESC'],50);
         $resultsetTravelogues = $crud->rv_select_all('tbl_travelogues', ['TravId', 'TravTitle', 'TravBannerImage', 'TravDestination'], ['IsMarkForDel' => 0],['TravId' => 'DESC'],50);
           $resultsetDestination = $crud->rv_select_all('tb_tbb2c_destinations', ['DesSysId', 'Title'], ['IsMarkForDel' => 0],['DesSysId' => 'DESC'],50);
            $resultsetThingstodo = $crud->rv_select_all('tbl_thingstodo', ['TravId', 'TravImage', 'TravTitle', 'TravDescription'], ['IsMarkForDel' => 0],['TravId' => 'DESC'],50);
            // print_r($resultsetThingstodo);
            // die;
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();

            if ($form->isValid($getData)) {

                //-------Start Code for Approve and Publish content---------//
                if (isset($getData['save']) == "Save") {
                        // echo "<pre>";print_r($getData);die;
                    //Code for check page alias name already exists or not


                    $TravId = $getData['TravId'];
                $oldImage = $getData['oldImage'];
                     $image2 = $_FILES['image']['name'];
                    
                     $qaArray = array();

                    foreach($getData['title'] as $qKey => $qValue) {
                        $orignalFileName = ((isset($image2[$qKey])) && !empty($image2[$qKey])) ? $image2[$qKey] : '';
                        $fileName = '';
                        if (!empty($orignalFileName)) {
                            
                            $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl2.$TravId.'/images';
                            // root folder for destination images

                            /* Get File Extension */
                            $fileExt = $this->_helper->General->getFileExtension($orignalFileName);
                            $fileName = $TravId . '_' . $this->current_time . '_' . $qKey . '.' . $fileExt;

                            /* Create directory if not exists */
                            if (!file_exists($orignalFolderName)) {
                                mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                            }

                           
                                    $temp_file_name = $_FILES["image"]["tmp_name"][$qKey]; 
                            @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                            $originalLargeFolder = $orignalFolderName . '/large';
                            $originalMediumFolder = $orignalFolderName . '/medium';
                            $originalSmallFolder = $orignalFolderName . '/small';

                            Catabatic_Helper::resizeImages($orignalFolderName, $originalLargeFolder, $fileName, $this->large_image_width, $this->large_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalMediumFolder, $fileName, $this->medium_image_width, $this->medium_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalSmallFolder, $fileName, $this->small_image_width, $this->small_image_height);
                            
                             
                        }else{
                            $fileName = $oldImage[$qKey];
                        }
 
                         
                        $qaArray[$qKey] = [
                            'title' => $qValue,
                            'description' => $getData['description'][$qKey],
                            'url' => $getData['url'][$qKey],
                             'image' => $fileName,
                        ];

         
                    }

  
    
                                        
                    $images = $_FILES['image']['name'];
                   
                    foreach ($images as $key => $orignalFileName) {

                        if (!empty($orignalFileName)) {
                            
                            $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/banner';
                            // root folder for destination images

                            /* Get File Extension */
                            $fileExt = $this->_helper->General->getFileExtension($orignalFileName);
                            $fileName = $TravId . '_' . $this->current_time . '_' . $key . '.' . $fileExt;

                            /* Create directory if not exists */
                            if (!file_exists($orignalFolderName)) {
                                mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                            }

                            foreach ($_FILES["image"]["tmp_name"] as $key1 => $image) {
                                if ($key == $key1) {
                                    $temp_file_name = $image; // temprary file name
                                }
                            }
                            @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                            $originalLargeFolder = $orignalFolderName . '/large';
                            $originalMediumFolder = $orignalFolderName . '/medium';
                            $originalSmallFolder = $orignalFolderName . '/small';

                            Catabatic_Helper::resizeImages($orignalFolderName, $originalLargeFolder, $fileName, $this->large_image_width, $this->large_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalMediumFolder, $fileName, $this->medium_image_width, $this->medium_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalSmallFolder, $fileName, $this->small_image_width, $this->small_image_height);
                            $newimagenamesArr[] = $fileName;
                            $newimagenames = implode(',', $newimagenamesArr);
                        }
                    }

if ($newimagenames != "") { //                                
                        $mimage_add = $newimagenames;
                    } else {
                        $mimage_add = ""; //                               
                    }
$fileName = $bfileName = '';
                    $blogimage = $_FILES['TravBlogImage']['name'];
                    if (!empty($blogimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/images';
                        $fileExtion = $this->_helper->General->getFileExtension($blogimage);
                        $bfileName = $this->current_time . '_blog.' . $fileExtion;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["TravBlogImage"]["tmp_name"]; // temprary file name

                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $bfileName);
                        
                        $originalLargeFolder = $orignalFolderName.'/large';
                        $originalMediumFolder = $orignalFolderName.'/medium';
                        $originalSmallFolder = $orignalFolderName.'/small';

                        Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$bfileName,$this->large_image_width,$this->large_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$bfileName,$this->medium_image_width,$this->medium_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$bfileName,$this->small_image_width,$this->small_image_height);

                    }

                    $bannerimage = $_FILES['TravBannerImage']['name'];
                    if (!empty($bannerimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/banner';
                        $fileExt = $this->_helper->General->getFileExtension($bannerimage);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["TravBannerImage"]["tmp_name"]; // temprary file name

                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                         $originalLargeFolder = $orignalFolderName.'/large';
                        $originalMediumFolder = $orignalFolderName.'/medium';
                        $originalSmallFolder = $orignalFolderName.'/small';

                        Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->banner_large_image_width,$this->banner_large_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->banner_medium_image_width,$this->banner_medium_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->banner_small_image_width,$this->banner_small_image_height);

                    }

                    $TravDate1 = explode('/', $getData['TravDate']);
                    $TravDate = $TravDate1[2] . "-" . $TravDate1[1] . "-" . $TravDate1[0];

                    $editPageData = [

                        'TravTitle' => ($getData['TravTitle']),
                        'TravIdentifier' => strtolower(Catabatic_Helper::getSeoName($getData['TravTitle'])),
                        'TravDestination' => (implode(",", $getData['TravDestination'])),
                        'TravUploadedBy' => ($getData['TravUploadedBy']),
						'TravDate' => $TravDate,
                        'tags' => ($getData['TravTags']),
                        'TravDescription' => ($getData['TravDescription']),
                        'status' => ($getData['status']),
                        'keyword' => ($getData['keyword']),
                        'TravyoutTitle' => ($getData['TravyoutTitle']),

                        'description' => ($getData['description']),
                        'metatag' => ($getData['metatag']),
                         'selectedPackages' => isset($getData['selectedPackages']) ? json_encode($getData['selectedPackages']): '',
                         'selectedTravelogues' => isset($getData['selectedTravelogues']) ? json_encode($getData['selectedTravelogues']): '',
                         'similarDestinations' => (isset($getData['similarDestinations']) && $getData['similarDestinations'] != '' )? json_encode($getData['similarDestinations']): '',
                        'selectedThingstodo' => isset($getData['selectedThingstodo']) ? json_encode($getData['selectedThingstodo']): '',
                         'category' => ($getData['category']),
                        'thingsFAQ' => (!empty($qaArray)) ? json_encode($qaArray) :'',

                    ];



 $oldimagenames = implode(',', $getData["oldImage"]);
                    $editPageData['TravmImage'] = ltrim($oldimagenames . ($newimagenames != '' ? ',' . $newimagenames : ''), ',');
                    
                    if ($bfileName != '') {
                        $editPageData['TravImage'] = $bfileName;
                    }

                    if ($fileName !='') {
                        $editPageData['TravBannerImage'] = $fileName;
                    }
                    if($getData['status'] == 0){
                    $editPageData['displayOnBanner'] = 0;
                    }
                    //echo "<pre>"; print_r($editPageData); die;
                    $crud->rv_update('tbl_exploresaudi', $editPageData, ['TravId' => 1]);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                    $this->_redirect("/admin/exploresaudi/editexploresaudi");
                }
            }
        }

        $result = $crud->getCmsdata('tbl_exploresaudi', ['*'], ['TravId' => 1], ['TravId' => 'DESC']);

          $resultCategory = $crud->rv_select_all('tbl_exploresaudi', ['*'], ['IsMarkForDel' => 0],['TravId' => 'DESC']);
          $similarDestinations = ($result->similarDestinations != '') ? implode(json_decode($result->similarDestinations)) : '';
          $SelectedDestinationsName = '';
          if($similarDestinations != ''){
            $SelectedDestinationsName = $crud->rv_select_all_destinationByIds('tb_tbb2c_destinations', ['Title', 'DesSysId'], ['IsActive' => 1, 'IsMarkForDel' => 0], 'DesSysId', $similarDestinations);
          }
          
      // echo "<pre>";print_r($resultCategory);die;
        $editdata["TravId"] = @$result->TravId;
        $editdata["TravTitle"] = @$result->TravTitle;
        $editdata["TravImage"] = @$result->TravImage;
        $editdata["TravBannerImage"] = @$result->TravBannerImage;
        $editdata["TravDestination"] = @explode(",", $result->TravDestination);
        $editdata["TravUploadedBy"] = @$result->TravUploadedBy;

        $TravDate2 = explode('-', $result->TravDate);
        $result->TravDate = $TravDate2[2] . "/" . $TravDate2[1] . "/" . $TravDate2[0];
        $editdata["TravDate"] = @$result->TravDate;
        $editdata["TravDays"] = @$result->TravDays;
        $editdata["TravTraveller"] = @$result->TravTraveller;
        $editdata["TravCost"] = @$result->TravCost;
        $editdata["TravDescription"] = @$result->TravDescription;
        $editdata["status"] = @$result->status;
        $editdata["TravTags"] = @$result->tags;
        $editdata["TravyoutTitle"] = @$result->TravyoutTitle;

        $editdata["keyword"] = @$result->keyword;
        $editdata["description"] = @$result->description;
        $editdata["metatag"] = @$result->metatag;
        $editdata["TravmImage"] .= @$result->TravmImage;

         $editdata["category"] = @$result->category;
        //echo "<pre>";print_r($editdata);die;
        $form->populate($editdata);

$this->view->TravDate = @$result->TravDate;
$this->view->category = @$result->category;
        $this->view->thingsFAQ = $result->thingsFAQ;

        $this->view->TravmImage .= @$result->TravmImage;

        $this->view->TravBannerImage = @$result->TravBannerImage;
        $this->view->TravBlogImage = @$result->TravImage;
        $this->view->form = $form;
         $this->view->resultsetPackage = $resultsetPackage;
         $this->view->selectedPackages  = @$result->selectedPackages;
        $this->view->selectedThingstodo  = @$result->selectedThingstodo;
         $this->view->resultsetThingstodo = $resultsetThingstodo;

         $this->view->resultsetTravelogues = $resultsetTravelogues;
         $this->view->resultsetDestination = $resultsetDestination;
        $this->view->similarDestinations  = @$result->similarDestinations;
        $this->view->SelectedDestinationsName  = $SelectedDestinationsName;
        $this->view->resultsetTravelogues = $resultsetTravelogues;

         $this->view->selectedTravelogues  = @$result->selectedTravelogues;
         $this->view->TravId  = @$result->TravId;
         $this->view->getCategory = $resultCategory;

    }

    public function addthingstodoAction(){


//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Addthingstodo();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/thingstodo/addthingstodo");
        $form->setName("add_thingstodo");
        $resultCategory = $crud->rv_select_all('tb_tbb2c_thingstodo_category', ['DesSysId', 'category'], ['IsPublish' => 1, 'IsMarkForDel' => 0],['DesSysId' => 'DESC']);

        $lastRow = $crud->getCmsdata($this->table, ['TravId'], ['TravId'], ['TravId' => 'DESC']);
        $TravId = $lastRow['TravId'] +1; 
          $resultsetPackage = $crud->rv_select_all('tb_tbb2c_packages_master', ['PkgSysId', 'GTXPkgId', 'LongJsonInfo', 'Destinations'], ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1],['PkgSysId' => 'DESC'],50);
        $resultsetThingstodo = $crud->rv_select_all('tbl_thingstodo', ['TravId', 'TravImage', 'TravTitle', 'TravDescription'], ['IsMarkForDel' => 0],['TravId' => 'DESC'],50);
          $resultsetTravelogues = $crud->rv_select_all('tbl_travelogues', ['TravId', 'TravTitle', 'TravBannerImage', 'TravDestination'], ['IsMarkForDel' => 0],['TravId' => 'DESC'],50);
         
   
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            if ($form->isValid($getData)) {
                //-------Start Code for Approve and Publish content---------//
                if (isset($getData['save']) == "Save") {
//                echo "<pre>";print_r($getData);die;
                    $images = $_FILES['image']['name'];
                   
                    foreach ($images as $key => $orignalFileName) {

                        if (!empty($orignalFileName)) {
                            
 $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/banner';
                        // root folder for destination images

                            /* Get File Extension */
                            $fileExt = $this->_helper->General->getFileExtension($orignalFileName);
                            $fileName = $TravId . '_' . $this->current_time . '_' . $key . '.' . $fileExt;

                            /* Create directory if not exists */
                            if (!file_exists($orignalFolderName)) {
                                mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                            }

                            foreach ($_FILES["image"]["tmp_name"] as $key1 => $image) {
                                if ($key == $key1) {
                                    $temp_file_name = $image; // temprary file name
                                }
                            }
                            @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                            $originalLargeFolder = $orignalFolderName . '/large';
                            $originalMediumFolder = $orignalFolderName . '/medium';
                            $originalSmallFolder = $orignalFolderName . '/small';

                            Catabatic_Helper::resizeImages($orignalFolderName, $originalLargeFolder, $fileName, $this->large_image_width, $this->large_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalMediumFolder, $fileName, $this->medium_image_width, $this->medium_image_height);
                            Catabatic_Helper::resizeImages($orignalFolderName, $originalSmallFolder, $fileName, $this->small_image_width, $this->small_image_height);
                            $newimagenamesArr[] = $fileName;
                            $newimagenames = implode(',', $newimagenamesArr);
                        }
                    }
if ($newimagenames != "") { //                                
                        $mimage_add = $newimagenames;
                    } else {
                        $mimage_add = ""; //                               
                    }
                    $blogimage = $_FILES['TravBlogImage']['name'];
                    $bannerimage = $_FILES['TravBannerImage']['name'];

                    if (!empty($blogimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/images';
                        $fileExtion = $this->_helper->General->getFileExtension($blogimage);
                        $bfileName = $this->current_time . '_blog.' . $fileExtion;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["TravBlogImage"]["tmp_name"]; // temprary file name

                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $bfileName);
                        
                        $originalLargeFolder = $orignalFolderName.'/large';
                        $originalMediumFolder = $orignalFolderName.'/medium';
                        $originalSmallFolder = $orignalFolderName.'/small';

                        Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$bfileName,$this->large_image_width,$this->large_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$bfileName,$this->medium_image_width,$this->medium_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$bfileName,$this->small_image_width,$this->small_image_height);

                    }
                    if ($bfileName != "") { //                                
                        $bimage_add = $bfileName;
                    } else {
                        $bimage_add = ""; //                               
                    }


                    if (!empty($bannerimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/banner';
                        $fileExt = $this->_helper->General->getFileExtension($bannerimage);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["TravBannerImage"]["tmp_name"]; // temprary file name

                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                         $originalLargeFolder = $orignalFolderName.'/large';
                        $originalMediumFolder = $orignalFolderName.'/medium';
                        $originalSmallFolder = $orignalFolderName.'/small';

                        Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->banner_large_image_width,$this->banner_large_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->banner_medium_image_width,$this->banner_medium_image_height);
                        Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->banner_small_image_width,$this->banner_small_image_height);

                    }

                    if ($fileName != "") {
                        $image_add = $fileName;
                    } else {
                        $image_add = "";
                    }

                    $TravDate1 = explode('/', $getData['TravDate']);
                    $TravDate = $TravDate1[2] . "-" . $TravDate1[1] . "-" . $TravDate1[0];

                    $savePageData = [
                        'TravTitle' => ($getData['TravTitle']),
                        'TravyoutTitle' => ($getData['TravyoutTitle']),

                        'TravIdentifier' => strtolower(Catabatic_Helper::getSeoName($getData['TravTitle'])),
                        'TravmImage' => $mimage_add,
                        'TravImage' => $bimage_add,

                        'TravBannerImage' => $image_add,
                        'TravDestination' => (implode(",", $getData['TravDestination'])),
                        'TravUploadedBy' => ($getData['TravUploadedBy']),
						'TravDate' => $TravDate,
                        'tags' => ($getData['TravTags']),
                        'TravDescription' => ($getData['TravDescription']),
                        'status' => ($getData['status']),
                        'keyword' => ($getData['keyword']),
                        'description' => ($getData['description']),
                        'metatag' => ($getData['metatag']),
                        'CreateDate' => date('Y-m-d H:i:s'),
                        'isMarkForDel' => 0,
                         'selectedPackages' => isset($getData['selectedPackages']) ? json_encode($getData['selectedPackages']): '',
                          'selectedTravelogues' => isset($getData['selectedTravelogues']) ? json_encode($getData['selectedTravelogues']): '',
                           'selectedThingstodo' => isset($getData['selectedThingstodo']) ? json_encode($getData['selectedThingstodo']): '',
                           'category' => ($getData['category']),
                        
                    ];
                    
                   // echo "<pre>";print_r($savePageData);die;
                    $crud->rv_insert($this->table, $savePageData);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been added successfully.");
                    $this->_redirect("/admin/thingstodo/index");
                }
            }
        }

        $this->view->form = $form;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
         $this->view->resultsetPackage = $resultsetPackage;
        $this->view->resultsetThingstodo = $resultsetThingstodo;

        $this->view->resultsetTravelogues = $resultsetTravelogues;

        $this->view->getCategory = $resultCategory;

    }

    public function deletethingstodoAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        //echo $tId;die;
        if ($tId) {
            $checkdata = $crud->rv_select_row($this->table, ['TravId'], ['TravId' => $tId], ['TravId' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_update($this->table, ['isMarkForDel' => 1], ['TravId =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/thingstodo/index");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }

   

    // public function activebAction() {
    //     $this->checklogin();
    //     $crud = new Admin_Model_CRUD();
    //     $tId = (int) $this->getRequest()->getParam("id");
    //     $val = (int) $this->getRequest()->getParam("val");
    //     if ($tId) {
    //         try {
    //             $updatedata = [
    //                 'displayOnBanner' => $val
    //             ];
    //             $result = $crud->rv_update('tbl_thingstodo', $updatedata, ['TravId =?' => $tId]);
    //             $resultset = $crud->rv_select_all("tbl_thingstodo", ['*'], ['displayOnBanner' => 1, 'status' => 1, 'isMarkForDel' => 0], ['TravId' => 'ASC']);
                
                
                
                
    //             if (!$result) {
    //                 $result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
    //                 echo Zend_Json::encode($result_message);
    //                 exit;
    //             } else {
    //                 $result_message = ['status' => true, 'message' => 'Active successfully'];
    //                 echo Zend_Json::encode($result_message);
    //                 exit;
    //             }
    //         } catch (Exception $ex) {
    //             $ex->getMessage();
    //         }
    //     }
    // }

 public function activebAction(){
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        $val = (int) $this->getRequest()->getParam("val");
        if ($tId) {
            try {
                $updatedata = [
                    'displayOnBanner' => $val
                ];
                $result = $crud->rv_update('tbl_thingstodo', $updatedata, ['TravId =?' => $tId]);
//                $resultset = $crud->rv_select_all("tb_tbb2c_destinations", ['*'] ,['IsFeatured'=>1,'IsPublish'=>1,'IsMarkForDel'=>0], ['Title'=>'ASC'] );
//                if(count($resultset)>6){
//                   $result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
//                    echo Zend_Json::encode($result_message);
//                    $updatedata = [
//                    'IsFeatured' => 0
//                ];
//                    $result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
//                    exit; 
//                }
                if (!$result) {
                    $result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
                    echo Zend_Json::encode($result_message);
                    exit;
                } else {
                    $result_message = ['status' => true, 'message' => 'Active successfully'];
                    echo Zend_Json::encode($result_message);
                    exit;
                }
            } catch (Exception $ex) {
                $ex->getMessage();
            }
        }
    }
    public function sanitize_data($string){
        $searchArr = array("iframe", "script", "document", "write", "alert", "%", "@", "$", ";", "+", "|", "#", "<", ">", ")", "(", "'", "\'", ",", "and ", " &", "& ", "and", " and", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
        $input_data = strtolower($string);
        $input_data = str_replace($searchArr, "", $input_data);

        $input_data = str_replace(" ", "-", $input_data);
        //echo $input_data; die;
        return $input_data;
    }

    /**
     * checklogin() method is used to check admin logedin or not
     * @param Null
     * @return Array 
     */
    public function checklogin() {
        if (($this->admin_type == "superadmin") || ($this->admin_type == "admin")) {
            $auth = Zend_Auth::getInstance();
            $hasIdentity = $auth->hasIdentity();
            /*             * ************* check admin identity *********** */
            if (!$hasIdentity) {
                $this->_redirect('admin/index/index');
            }
        } else {
            $this->_redirect('admin/index/index');
        }
    }


    
public function selectimageAction(){
        $this->view->layout()->disableLayout();
        $folder =  $this->getRequest()->getParam("folder");
        $dir_name = "public/upload/travelogues/descriptionimage/".$folder;
        $descriptionimages = glob($dir_name."*");
        $this->view->descriptionimages = $descriptionimages;
        $this->view->siteurl = $this->siteurl;
        // echo "";print_r($descriptionimages);die;


    }

 public function uploadImageAction()
    {
        //        $filename = $_FILES['file']['name'];
        $orignalFIleName = $_FILES["file"]["name"];
        if (!empty($orignalFIleName)) {
            $orignalFolderName = $_SERVER["DOCUMENT_ROOT"].'/' . $this->imageUrl;
            $originalSmallFolder = $orignalFolderName . "/descriptionimage";

            $fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
            $fileName = 'descriptionimage_' . time() . '.' . $fileExt;
            if (!file_exists($orignalFolderName)) {
                @mkdir($orignalFolderName, 0777, true);
            }
            if (!file_exists($originalSmallFolder)) {
                @mkdir($originalSmallFolder, 0777, true);
            }


            $temp_file_name = $_FILES["file"]["tmp_name"]; // temprary file name
            if (move_uploaded_file($temp_file_name, $originalSmallFolder . "/" . $fileName)) {
                $imageUrl = $this->siteurl.'public/upload/travelogues/descriptionimage/'.$fileName;
                $fileArray = array('status' => 'success', 'fileName' => $fileName,'imageUrl'=>$imageUrl);
            }
        }
        echo json_encode($fileArray);
        exit;
    }

}