<?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_ThingstodoController 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/thingstodo/category/';
$this->imageUrl2 = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/thingstodo/';

        $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 managethingstodocatAction(){

        //Check admin logedin or not
        $this->checklogin();
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
        $crud = new Admin_Model_CRUD();
        $getData = array();
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            $searchArr = array(
                'Title' => $getData['Title'],
                'rows' => $getData['rows'],
                'page' => $getData['page'],
                'val' => $getData['val'],

            );
            $resulsetold = $crud->getCount('tb_tbb2c_thingstodo_category', ['isMarkForDel' => 0], 'DesSysId');
            $crud->searchArr = $searchArr;
            $resultset = $crud->rv_select_static('tb_tbb2c_thingstodo_category', ['DesSysId', 'category','CatImage','IconImage','subtitle','description','isPublish'], ['isMarkForDel' => 0], ['DesSysId' => 'DESC']);
           // print_r( $resultset);die;'IsPublish' => 1,
                    
                    
            foreach ($resultset as $key => $value) {
               $resultsetArr[] = [
                'DesSysId' =>  $value['DesSysId'], 
                 'CatImage' =>  $value['CatImage'],  
                 'IconImage' =>  $value['IconImage'], 
                 
                'category' =>  $value['category'],
            'subtitle' =>  $value['subtitle'],
            //'description' =>  $value['description'],
                            
                'isMarkForDel' =>0,
                'isPublish' =>$value['isPublish'],

               ]; 
            }
            
            $result = Zend_Json::encode($resultsetArr);

            $newResult = Zend_Json::decode($result, false);
             $finalResult["total"] = $resulsetold[0]['DesSysId'];
             $finalResult["rows"] = $newResult;
           // echo "<pre>";  print_r($finalResult);
           //    die;
             echo json_encode($finalResult);
            exit;
        }
    }

  public function activeAction(){
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        $val = (int) $this->getRequest()->getParam("val");
      
        if ($tId) {
            try {
                $updatedata = [
                    'IsPublish' => $val
                ];
                $result = $crud->rv_update('tb_tbb2c_thingstodo_category', $updatedata, ['DesSysId =?' => $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 editthingstodocatAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
       // $form = new Admin_Form_Editdestinationpage();
        $pId = $this->getRequest()->getParam("id");
        $page = ($this->getRequest()->getParam("page")) ? $this->getRequest()->getParam("page") : 1;

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
           $DesSysId = $getData['DesSysId'];

                    $catimage = $_FILES['CatImage']['name'];
                    if (!empty($catimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl1.$DesSysId.'/banner';
                        $fileExt = $this->_helper->General->getFileExtension($catimage);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["CatImage"]["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);

                    }

                    $iconimage = $_FILES['IconImage']['name'];
                    if (!empty($iconimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl1.$DesSysId.'/icon';
                        $fileExt = $this->_helper->General->getFileExtension($iconimage);
                        $ifileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["IconImage"]["tmp_name"]; // temprary file name

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

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

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

                    }
                    $id = $getData['DesSysId'];
 
                 
                    $editDestinationData = [
                        'category' => ($getData['category']),
                        'description' => ($getData['description']),
                        'subtitle' => ($getData['subtitle']),
                        //'content_description' => ($getData['content_description']),
                        
                    ];
                    
                   if ($fileName != '') {
                        $editDestinationData['CatImage'] = $fileName;
                    }

                    if ($ifileName !='') {
                        $editDestinationData['IconImage'] = $ifileName;
                    }

                    
                    
                    $crud->rv_update('tb_tbb2c_thingstodo_category', $editDestinationData, ['DesSysId =?' => $id]);
                    $this->view->successMessage = "things To Do Category has been Updated successfully.";
                    $this->_helper->flashMessenger->addMessage("Destination has been updated successfully.");
                    $this->_redirect("/admin/thingstodo/managethingstodocat");
              

        }
 $result = $crud->rv_select_static('tb_tbb2c_thingstodo_category', ['DesSysId', 'category','CatImage','IconImage','subtitle','description'], ['isMarkForDel' => 0,'isPublish' =>1,'DesSysId' => $pId ], ['DesSysId' => 'DESC']);
$result = $result[0];
     
                $this->view->getdata = $result;

    }
    
    public function addthingstodocatAction(){
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        //$form = new Admin_Form_Adddestination();
        $tId = (int) $this->getRequest()->getParam("id");
$lastRow = $crud->getCmsdata('tb_tbb2c_thingstodo_category', ['DesSysId'], ['DesSysId'], ['DesSysId' => 'DESC']);
        $DesSysId = $lastRow['DesSysId'] +1;

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
                //echo "<pre>";print_r($getData);die;

            if (isset($getData['save']) == "Save") {

                    $catimage = $_FILES['CatImage']['name'];
                    $iconimage = $_FILES['IconImage']['name'];
                    
                    if (!empty($catimage)) {

        //                  print_r( $DesSysId);
        // die;
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl1.$DesSysId.'/banner';
                        $fileExt = $this->_helper->General->getFileExtension($catimage);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["CatImage"]["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 != "") { //                                
                        $cimage_add = $fileName;
                    } else {
                        $cimage_add = ""; //                               
                    }
                    
                 if (!empty($iconimage)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl1.$DesSysId.'/icon';
                        $fileExt = $this->_helper->General->getFileExtension($iconimage);
                        $ifileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                       
                        $temp_file_name = $_FILES["IconImage"]["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 ($ifileName != "") { //                                
                        $iimage_add = $ifileName;
                    } else {
                        $iimage_add = ""; //                               
                    }
                $savePageData = [
                    'category' => ($getData['category']),
                    'subtitle' => ($getData['subtitle']),
                    'description' => ($getData['description']),
                    //'content_description' => ($getData['content_description']),
                    'CatImage' => $cimage_add,
                    'IconImage' => $iimage_add,
                    'IsPublish' => 1,
                    
                    'IsMarkForDel' => 0,
                ];
              // echo "<pre>";print_r($savePageData);die;
                $crud->rv_insert('tb_tbb2c_thingstodo_category', $savePageData);
                $this->view->successMessage = "things To Do Category has been saved successfully.";
                $this->_helper->flashMessenger->addMessage("Destination has been added successfully.");
                $this->_redirect("/admin/thingstodo/managethingstodocat");
            }
        }

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

     public function deletethingstodocatAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        //echo $tId;die;
        if ($tId) {
            $checkdata = $crud->rv_select_row('tb_tbb2c_thingstodo_category', ['DesSysId'], ['DesSysId' => $tId], ['DesSysId' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_delete('tb_tbb2c_thingstodo_category', ['DesSysId =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Deleted successfully.");
                $this->_redirect("/admin/thingstodo/managethingstodocat");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }
    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($this->table, ['isMarkForDel' => 0], 'TravId');
            $resultset = $crud->getCategory(['tb2.isMarkForDel' => 0], ['tb1.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 json_encode($finalResult); 
            exit;
        }
    }

    public function editthingstodoAction() {

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

        $form->setName("edit_travelogues");
          $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);

        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'];

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

                        if (!empty($orignalFileName)) {
                            
 $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl2.$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->imageUrl2.$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->imageUrl2.$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']): '',
                         'category' => ($getData['category']),
                    ];

 $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($this->table, $editPageData, ['TravId =?' => $TravId]);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                    $this->_redirect("/admin/thingstodo/index");
                }
            }
        }

        $result = $crud->getCmsdata($this->table, ['*'], ['TravId' => $pId], ['TravId' => 'DESC']);

          $resultCategory = $crud->rv_select_all('tb_tbb2c_thingstodo_category', ['DesSysId', 'category'], ['IsPublish' => 1, 'IsMarkForDel' => 0],['DesSysId' => 'DESC']);
//        echo "<pre>";print_r($result);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->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->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);
          $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->imageUrl2.$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->imageUrl2.$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->imageUrl2.$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']): '',
                           '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->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('tbl_thingstodo', ['TravId'], ['TravId' => $tId], ['TravId' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_delete('tbl_thingstodo', ['TravId =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Deleted 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;
    }

}