<?php

/* * ***********************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name     : IndexController.php
 * File Desc.    : Index controller for home page front end
 * Created By    : Ranvir Singh <ranvir@catpl.co.in>
 * Created Date  : 27 Oct 2017
 * Updated Date  : 03 Nov 2017

 * Travelogue_IndexController | Travelogue Module / Index controller
 * *************************************************************
 */

class Travelogue_IndexController extends Zend_Controller_Action {

    public $baseUrl = '';
    public $AgencyId;
    protected $objMdl;
    protected $objHelperGeneral;
    protected $tablename;

    public function init() {

        $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
        $BootStrap = $aConfig['bootstrap'];
        $this->siteName = $BootStrap['siteName'];
        $this->baseUrl = $BootStrap['siteUrl'];
        $this->AgencyId = $BootStrap['gtxagencysysid'];

        $this->objMdl = new Admin_Model_CRUD();
        $this->tablename = "tbl_travelogues";
        $this->objHelperGeneral = $this->_helper->General;
        //$this->_helper->layout->disableLayout();
        //$this->_helper->_layout->setLayout('layout-visa')->setLayoutPath(APPLICATION_PATH.'/layouts/scripts');
    }

    public function indexAction() {

        $travelouges = $this->objMdl->rv_select_all($this->tablename, ['TravId', 'TravIdentifier', 'TravTitle', 'TravImage', 'TravBannerImage', 'TravDestination', 'TravUploadedBy',
            'TravDate', 'TravDays', 'TravTraveller', 'TravCost', 'TravDescription', 'TravMultiImage', 'CreateDate'], ['status' => 1, 'isMarkForDel' => 0], ['TravId' => 'DESC']);
        $getPageDetail = $this->objMdl->rv_select_row('tbl_static_pages', ['*'], ['sid' => 194], ['sid' => 'desc']);
        // echo"<pre>";print_r($getPageDetail);die;
        $this->view->getPageDetail = $getPageDetail;

        $resultsetSeoForBlog = array();
        $resultsetSeoForBlog['TravTitle'] = $getPageDetail['page_title']; // get package Keyword
        $resultsetSeoForBlog['Keyword'] = $getPageDetail['meta_keywords']; // get package Keyword
        $resultsetSeoForBlog['Description'] = $getPageDetail['meta_description']; // get package Description
        $resultsetSeoForBlog['metaTitle'] = (trim($getPageDetail['meta_title']) != '') ? $getPageDetail['meta_title'] : $getPageDetail['page_title']; // get package Metatag

        $this->view->detailLayout = $resultsetSeoForBlog;
        // code here
        $this->view->baseUrl = $this->baseUrl;
        $this->view->travelouges = $travelouges;
    }

    public function detailAction() {

        $params = $this->getRequest()->getParams();
        $currencyTypeArray = $this->objHelperGeneral->getCurrencyData();
//       echo "<pre>";print_r($params);die();
        $travelouge = $this->objMdl->rv_select_row($this->tablename, ['TravId', 'TravIdentifier', 'TravTitle', 'TravImage', 'TravBannerImage', 'TravDestination', 'TravUploadedBy',
            'TravDate', 'TravDays', 'TravTraveller', 'TravCost', 'TravDescription', 'TravMultiImage', 'CreateDate', 'Keyword', 'metatag', 'description', 'selectedPackages', 'BlogDescription'], ['status' => 1, 'isMarkForDel' => 0, 'TravIdentifier' => $params['travid']],
                ['TravId' => 'DESC']);
        $getPageDetail = $this->objMdl->rv_select_row('tbl_static_pages', ['*'], ['sid' => 194], ['sid' => 'desc']);
        $this->view->getPageDetail = $getPageDetail;
        //  echo "<pre>";print_r($getPageDetail[background_image]);exit;

        $recent_travelouges = $this->objMdl->rv_select_all($this->tablename, ['TravId', 'TravTitle', 'TravIdentifier', 'TravBannerImage', 'TravUploadedBy',
            'TravDate', 'TravImage', 'CreateDate'], ['status' => 1, 'isMarkForDel' => 0], ['TravId' => 'DESC'], 10);

        $selectedPackages = (isset($travelouge['selectedPackages']) && $travelouge['selectedPackages'] != '') ? json_decode($travelouge['selectedPackages']) : '';

        $packIds = implode(',', $selectedPackages);
        if ($packIds) {
            $where = ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1];
            $whereCustom = 'PkgSysId IN(' . $packIds . ')';
            // $trendingTours = $this->objMdl->rv_select_all_package_for_multi_ids();
            $finalRelatedPackages = $this->objMdl->rv_select_all_custom_query('tb_tbb2c_packages_master',
                    ['*'], $where, $whereCustom, ['MinPrice' => 'ASC'], 1000);

            $m = 1;

            foreach ($finalRelatedPackages as $key => $value) {

                $destinationArr = explode(',', $value['Destinations']); // get the first destination only by extracting array
                $LongJsonInfo = Zend_Json::decode($value['LongJsonInfo']);

                if (isset($_SESSION['TravelAgent']['session']) && !empty($_SESSION['TravelAgent']['session'])) {
                    $categoryDetails = $this->objHelperGeneral->getCategoryAndPriceArray($LongJsonInfo['package']['TourTypes']['MarketType'], 'B2B', $value['PackageType'], $value['PackageSubType']); // get default category
                } else {
                    $categoryDetails = $this->objHelperGeneral->getCategoryAndPriceArray($LongJsonInfo['package']['TourTypes']['MarketType'], 'B2C', $value['PackageType'], $value['PackageSubType']); // get default category
                }

                $tourImage1 = explode(',', $value['Image']);
                $tourImage = $tourImage1[0];

                $defaultCategoryId = $categoryDetails['defaultCategoryId'];
                $defaultCategory = $categoryDetails['defaultCategory'];
                $defaultTourType = $categoryDetails['defaultTourType'];
                $TPId = ($value['PackageType'] == $this->packageTypeStatic) ? $LongJsonInfo['package']['TPId'] : $categoryDetails['TPId'];
                $MPType = (!empty($categoryDetails['MPType']) && ($categoryDetails['MPType'] != 'LowestCost')) ? array_search($categoryDetails['MPType'], unserialize(CONST_MEAL_PLAN_ARR)) : 0;

                $tourTypeChar = ($defaultTourType == 1) ? 'P' : 'G'; // if private than P else G for Group tour type
                $priceArrJson = $categoryDetails['priceArrJson'];

                $displayFinalPrice = $this->objHelperGeneral->getPackagePrice($defaultCategory, $tourTypeChar, $priceArrJson, true);  // Param 4: true ( if calculate discounted price )
                $getCurrencyType = $priceArrJson[$tourTypeChar][$defaultCategory]['price'][0]['Currency'];
                $popularPackageArray[] = [
                    'name' => $this->objHelperGeneral->trimContent($LongJsonInfo['package']['Name'], 24),
                    'nameF' => $LongJsonInfo['package']['Name'], // full name of package name
                    'img' => $tourImage,
                    'night' => $value['Nights'],
                    'price' => $this->objHelperGeneral->moneyFormatINR(round($displayFinalPrice)),
                    'currencyType' => ($currencyTypeArray[$getCurrencyType]) ? $currencyTypeArray[$getCurrencyType] : 'INR',
                    'star' => $value['StarRating'],
                    'Destination' => $value['Destinations'],
                    'PkgSysId' => $value['PkgSysId'],
                    'GTXPkgId' => $value['GTXPkgId'],
                    'defaultCategoryId' => $defaultCategoryId,
                    'defaultCategory' => $defaultCategory,
                    'tourtype' => $defaultTourType,
                    'TPId' => $TPId,
                    'PackageType' => $value['PackageType'],
                    'mp' => $MPType,
                    'Countries' => $value['Countries'],
                    'isFixedDeparturesPackage' => $LongJsonInfo['package']['IsFixedDeparturePackage'],
                    'BookingValidUntil' => $value['BookingValidUntil'],
                ];
                $m++;
            }
        }


        $BlogDescription = json_decode($travelouge['BlogDescription'], 1);
     
        $finalBlogDescriptionArray = array();

        if (!empty($BlogDescription)) {
            for ($m = 0; $m < count($BlogDescription['blogdetailTitle']); $m++) {

                $packIds = (isset($BlogDescription['detailPackages'][$m]) && $BlogDescription['detailPackages'][$m] != '') ? trim($BlogDescription['detailPackages'][$m]) : '';

                $popularPackageArrayNew = array();
                if ($packIds) {

                    $where = ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1];
                    $whereCustom = 'GTXPkgId IN(' . $packIds . ')';
                        $finalRelatedPackagesD = $this->objMdl->rv_select_all_custom_query('tb_tbb2c_packages_master', ['*'], $where, $whereCustom, ['MinPrice' => 'ASC'], 1000);
                    // print_r($finalRelatedPackagesD); die;
                    foreach ($finalRelatedPackagesD as $popularKey1 => $popularValue1) {

                        $popularPackageImage1D = explode(',', $popularValue1['Image']);
                        $popularPackageImageD = $popularPackageImage1D[0];

                        $LongJsonInfoNew = json_decode($popularValue1['LongJsonInfo'], true);

                        // echo "<pre>";print_r($LongJsonInfoNew['package']['ImgThumbnail']);die;
                        $popularPackageArrayNew[] = [
                            'GTXPkgId' => $popularValue1['GTXPkgId'],
                            'PkgSysId' => $popularValue1['PkgSysId'],
                            'Name' => $LongJsonInfoNew['package']['Name'],
                            'img' => $popularPackageImageD,
                            'gtximg' => $LongJsonInfoNew['package']['ImgThumbnail'],
                            'packageNameUrl' => $popularValue1['packageNameUrl'],
                            'Destination' => $popularValue1['Destinations'],
                            'PackageSearchString' => $LongJsonInfoNew['PackageSearchString'],
                            'CountryType' => ($popularValue1['CountryIds'] == 101) ? 'india' : 'international',
                            'Nights' => ($popularValue1['Nights']),
                            'star' => ($popularValue1['StarRating']),
                            'Inclusions' => $LongJsonInfoNew['package']['Inclusions'],
                            'Price' => isset($LongJsonInfoNew['package']['TourTypes']['MarketType'][0]['TourType'][0]['Categories']['Category'][0]['Price']) ? (int) $LongJsonInfoNew['package']['TourTypes']['MarketType'][0]['TourType'][0]['Categories']['Category'][0]['Price'] : $popularValue1['MinPrice'],
                        ];
                    }
                }



                $finalBlogDescriptionArray[] = [
                    'blogdetailTitle' => $BlogDescription['blogdetailTitle'][$m],
                    'BlogDescription' => $BlogDescription['BlogDescription'][$m],
                    'images' => $BlogDescription['images'][$m],
                    'popularPackageArray' => $popularPackageArrayNew,
                ];
            }
        }

       // echo "<pre>";print_r($finalBlogDescriptionArray);die;
        //      echo "<pre>";print_r($popularPackageArray); die;
        $this->view->finalBlogDescriptionArray = $finalBlogDescriptionArray;

        $this->view->popularPackageArray = $popularPackageArray;

        $resultsetSeoForBlog = array();
        $resultsetSeoForBlog['TravTitle'] = $travelouge['TravTitle']; // get package Keyword
        $resultsetSeoForBlog['Keyword'] = $travelouge['Keyword']; // get package Keyword
        $resultsetSeoForBlog['Description'] = $travelouge['description']; // get package Description
        $resultsetSeoForBlog['metaTitle'] = (trim($travelouge['metatag']) != '') ? $travelouge['metatag'] : $travelouge['TravTitle']; // get package Metatag
		$metaImage = '';
		if($travelouge['TravImage'] != ''){
			$metaImage = $baseUrl.'public/upload/travelogues/'.$travelouge['TravId'].'/images/large/'.$travelouge['TravImage'];
		}else if($travelouge['TravBannerImage'] != ''){
			$metaImage = $baseUrl.'public/upload/travelogues/'.$travelouge['TravId'].'/banner/large/'.$travelouge['TravBannerImage'];
		}
        $resultsetSeoForBlog['metaImage'] = (trim($metaImage) != '') ? $metaImage : ''; // get package Metatag
	
        $this->view->detailLayout = $resultsetSeoForBlog;

//              echo "<pre>";print_r($resultsetSeoForBlog);die;
        // code here
        $this->view->baseUrl = $this->baseUrl;
        $this->view->travelouge = $travelouge;
        $this->view->recent_travelouges = $recent_travelouges;

        $this->view->actual_link = (isset($_SERVER['HTTPS']) ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

        $this->view->postTitle = $travelouge['TravTitle'];
        $this->view->imageUrl = $baseUrl . "public/upload/travelogues/" . $travelouge['TravBannerImage'];
    }

}