<?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_TraveloguesController 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();
        $this->imageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/travelogues/';

        $options = $aConfig['bootstrap'];
        $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_travelogues';
        $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 indexAction() {
        //Check admin logedin or not
        $this->checklogin();
        $getData = array();
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            $searchArr = array(
                'Title' => $getData['Title'],
                'rows' => $getData['rows'],
                'page' => $getData['page'],
            );
            $crud = new Admin_Model_CRUD();
            $crud->searchArrt = $searchArr;
            $resulsetold = $crud->getCount($this->table, ['isMarkForDel' => 0], 'TravId');
            $resultset = $crud->rv_select_blog_all($this->table, ['*'], ['isMarkForDel' => 0], ['TravId' => 'DESC']);

            $resultsetArr = array();
            foreach ($resultset as $key => $value) {
                if ($value['category'] == 1) {
                    $category = 'Tours';
                } else if ($value['category'] == 2) {
                    $category = 'Activity';
                } else {
                    $category = 'Visa';
                }


                $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' => $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 edittraveloguesAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Edittravelogues();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/travelogues/edittravelogues/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'], 500);
        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'];
                    $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);
                    }


                    $fileNameDescArr = array();
                    //   echo "<pre>";print_r($fileNameDescArr);die;

                    $totalCount = $getData['count_Blog_des'] - 1;

//                    foreach ($detailimage as $keyd => $detailimageVal) {
                    for ($man = 0; $man < $totalCount; $man++) {
                        $detailimageVal = $detailimage[$man];
                        if (!empty($detailimageVal) && trim($detailimageVal) != '') {

                            $orignaldetailimageName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $BlogId . "/images/description/"; // root folder for destination images
                            //echo "<pre>";print_r($detailimageVal);die;
                            $fileExt11 = $this->_helper->General->getFileExtension($detailimageVal);
                            $fileNameDesc = $lastInsertId . '_' . $this->current_time . '_' . $man . '.' . $fileExt11;
                            //   echo "<pre>";print_r($fileNameDesc);die; 
                            if (!file_exists($orignaldetailimageName)) {
                                mkdir($orignaldetailimageName, $this->DIR_WRITE_MODE, true);
                            }
                            foreach ($_FILES["detailimage"]["tmp_name"] as $dkey1 => $dimage) {
                                if ($man == $dkey1) {
                                    $dtemp_file_name1 = $dimage; // temprary file name
                                }
                            }
                            @move_uploaded_file($dtemp_file_name1, $orignaldetailimageName . "/" . $fileNameDesc);
                            $fileNameDescArr[] = $fileNameDesc;
                        } else {
                            $fileNameDescArr[] = $getData['hidendetailimage'][$man];
                        }
                    }

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

                    $detailimage = $_FILES['detailimage']['name'];
                    //  echo "<pre>";print_r($detailimage);die;
                    $fileNameDescArr = array();
                    foreach ($detailimage as $keyd => $detailimageVal) {
                        if (!empty($detailimageVal)) {

                            $orignaldetailimageName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $TravId; // root folder for destination images
                            //  print_r($orignaldetailimageName); die;
                            $fileExt11 = $this->_helper->General->getFileExtension($detailimageVal);
                            $fileNameDesc = $TravId . '_' . $this->current_time . '_' . $keyd . '.' . $fileExt11;
                            if (!file_exists($orignaldetailimageName)) {
                                mkdir($orignaldetailimageName, $this->DIR_WRITE_MODE, true);
                            }
                            foreach ($_FILES["detailimage"]["tmp_name"] as $dkey1 => $dimage) {
                                if ($keyd == $dkey1) {
                                    $dtemp_file_name1 = $dimage; // temprary file name
                                }
                            }
                            @move_uploaded_file($dtemp_file_name1, $orignaldetailimageName . "/" . $fileNameDesc);
                            $originalLargeFolder = $orignaldetailimageName . '/large';
                            $originalMediumFolder = $orignaldetailimageName . '/medium';
                            $originalSmallFolder = $orignaldetailimageName . '/small';

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

                            $fileNameDescArr[] = $fileNameDesc;
                        }
                    }
                    $BlogDescriptionArr = [
                        'blogdetailTitle' => ($getData['blogdetailTitle']),
                        'BlogDescription' => ($getData['BlogDescription']),
                        'images' => $fileNameDescArr,
                        'detailPackages' => ($getData['detailPackages']),
                    ];

                    $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']),
                        'description' => ($getData['description']),
                        'metatag' => ($getData['metatag']),
                        'selectedPackages' => isset($getData['selectedPackages']) ? json_encode($getData['selectedPackages']) : '',
                        'category' => ($getData['category']),
                        'BlogDescription' => json_encode($BlogDescriptionArr),
                    ];

                    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/travelogues/index");
                }
            }
        }

        $result = $crud->getCmsdata($this->table, ['*'], ['TravId' => $pId], ['TravId' => '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["keyword"] = @$result->keyword;
        $editdata["description"] = @$result->description;
        $editdata["metatag"] = @$result->metatag;
        $editdata["category"] = @$result->category;
        //echo "<pre>";print_r($editdata);die;
        $form->populate($editdata);
        $this->view->BlogDescription = @$result->BlogDescription;
        $this->view->TravDate = @$result->TravDate;
        $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->TravId = @$result->TravId;
    }

    public function addtraveloguesAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Addtravelogues();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/travelogues/addtravelogues");
        $form->setName("add_travelogues");
        $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'], 500);
        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;


                    $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];
                    $detailimage = $_FILES['detailimage']['name'];
                    //  echo "<pre>";print_r($detailimage);die;
                    $fileNameDescArr = array();
                    foreach ($detailimage as $keyd => $detailimageVal) {
                        if (!empty($detailimageVal)) {

                            $orignaldetailimageName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $TravId; // root folder for destination images
                            //  print_r($orignaldetailimageName); die;
                            $fileExt11 = $this->_helper->General->getFileExtension($detailimageVal);
                            $fileNameDesc = $TravId . '_' . $this->current_time . '_' . $keyd . '.' . $fileExt11;
                            if (!file_exists($orignaldetailimageName)) {
                                mkdir($orignaldetailimageName, $this->DIR_WRITE_MODE, true);
                            }
                            foreach ($_FILES["detailimage"]["tmp_name"] as $dkey1 => $dimage) {
                                if ($keyd == $dkey1) {
                                    $dtemp_file_name1 = $dimage; // temprary file name
                                }
                            }
                            @move_uploaded_file($dtemp_file_name1, $orignaldetailimageName . "/" . $fileNameDesc);
                            $fileNameDescArr[] = $fileNameDesc;
                        }
                    }
                    $BlogDescriptionArr = [
                        'blogdetailTitle' => ($getData['blogdetailTitle']),
                        'BlogDescription' => ($getData['BlogDescription']),
                        'images' => $fileNameDescArr,
                        'detailPackages' => ($getData['detailPackages']),
                    ];

                    $savePageData = [
                        'TravTitle' => ($getData['TravTitle']),
                        'TravIdentifier' => strtolower(Catabatic_Helper::getSeoName($getData['TravTitle'])),
                        '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']) : '',
                        'category' => ($getData['category']),
                        'BlogDescription' => json_encode($BlogDescriptionArr),
                    ];

                    //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/travelogues/index");
                }
            }
        }

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

    public function deletetraveloguesAction() {
        $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("Deleted successfully.");
                $this->_redirect("/admin/travelogues/index");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }

    public function commentsAction() {
        $pId = (int) $this->getRequest()->getParam("id");
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $resultset = $crud->rv_select_all($this->commenttable, ['*'], ['IsMarkForDel' => 0, 'blogId' => $pId], ['commentId' => 'DESC']);
        $result = $crud->rv_select_row($this->table, ['*'], ['TravId' => $pId], ['TravId' => 'asc']);
        # Start : Pagination 
        $page = $this->_getParam('page', 1);
        $resultset = Zend_Paginator::factory($resultset);
        $resultset->setItemCountPerPage($this->per_page_record);
        $resultset->setCurrentPageNumber($page);
        # End : Pagination
        $this->view->page = $page;
        $this->view->per_page_record = $this->per_page_record;
        $this->view->resultset = $resultset;
        $this->view->blogDetails = $result;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }

    public function editcommentAction() {


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

        $form->setName("edit_comment");

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

                    $editPageData = [
                        'blogId' => ($getData['blogId']),
                        'name' => ($getData['name']),
                        'emailId' => ($getData['emailId']),
                        'phone' => ($getData['phone']),
                        'comment' => ($getData['comment']),
                        'status' => ($getData['status']),
                        'UpdateDate' => date('Y-m-d h:i:s'),
                    ];
                    $crud->rv_update($this->commenttable, $editPageData, ['commentId =?' => $TravId]);
                    $this->view->successMessage = "Comment has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Comment has been updated successfully.");
                    $this->_redirect("/admin/travelogues/comments/id/" . $getData['blogId']);
                }
            }
        }

        $result = $crud->getCmsdata($this->commenttable, ['*'], ['commentId' => $pId], ['commentId' => 'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["commentId"] = @$result->commentId;
        $editdata["blogId"] = @$result->blogId;
        $editdata["name"] = @$result->name;
        $editdata["emailId"] = @$result->emailId;
        $editdata["phone"] = @$result->phone;
        $editdata["comment"] = @$result->comment;
        $editdata["status"] = @$result->status;
        $this->view->blogId = @$result->blogId;
        $form->populate($editdata);
        $this->view->form = $form;
    }

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

    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 = [
                    'displayOnBanner' => $val
                ];
                $result = $crud->rv_update('tbl_travelogues', $updatedata, ['TravId =?' => $tId]);
                $resultset = $crud->rv_select_all("tbl_travelogues", ['*'], ['displayOnBanner' => 1, 'status' => 1, 'isMarkForDel' => 0], ['TravId' => 'ASC']);

                if (count($resultset) > 10) {
                    $result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
                    echo Zend_Json::encode($result_message);
                    $updatedata = [
                        'displayOnBanner' => 0
                    ];
                    $result = $crud->rv_update('tbl_travelogues', $updatedata, ['TravId =?' => $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;
    }

}