<?php

class Zend_Controller_Action_Helper_Custom extends Zend_Controller_Action_Helper_Abstract {

    public function __construct() {
        $this->getTravelPlanStatusName = API_CUSTOMER_STATUS_PLAN_TYPE_LIST;
    }


        
        public function getStatiPages(){
             $this->objMdl   = new Admin_Model_CRUD();
            $staticPage = $this->objMdl->rv_select_all( 'tbl_static_pages' , ['identifier','page_title'], ['status'=>'Activate','displayOnFooter'=>1], ['sid'=>'ASC']);  
		return $staticPage;
	}
        
        public function getCommonBoxVal(){
            $this->objMdl   = new Admin_Model_CRUD();
            $commonBoxVal = $this->objMdl->rv_select_all( 'tbl_common_box' , ['*'], ['status'=>1], ['common_id'=>'ASC']);  
		return $commonBoxVal;
	}
        public function homeCommonBoxVal(){
            $this->objMdl   = new Admin_Model_CRUD();
            $commonBoxVal = $this->objMdl->rv_select_all( 'tbl_home_common_box' , ['*'], ['status'=>1], ['home_common_id'=>'ASC']);  
		return $commonBoxVal;
	}
        
        public function getContactDetailForFooterCms() {
        $this->objMdl = new Admin_Model_CRUD();
        $data = $this->objMdl->selectOne("tbl_query", ['*'], ['status' => 1]);
        return $data;
    }
    
    public function destinationForHeader() {
        $tbl_all_continent = $this->objMdl->rv_select_all( 'tbl_all_continent' , ['*'], ['status'=>1], ['ContinentId'=>'ASC']);  
        $destinations = $this->objMdl->getDestinationsHeader(['tbl.IsActive' => 1, 'tbl.IsPublish' => 1, 'tbl.IsMarkForDel' => 0, 'tbl.DisplayOnHeader' => 1, 'tb2.IsMarkForDel' => 0], ['tbl.DesSysId' => 'ASC'], 50);
        $continent_label = $region_label = $region_names = $finalDestination = $finalContinent = [];

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

            if (($value['region_label'] != NULL) && !in_array($value['region_label'], $region_label)) {
                $region_names[] = $value['region_name'];
                $region_label[] = $value['region_label'];
            }
//            if(!in_array($value['ContinentId'], $continent_label)){
////             $finalRegion[$value['ContinentId']][] = [
////                'region_label' => $value['region_label'],
////                 
////            ];
//             $continent_label[] = $value['ContinentId'];
//            }
            $finalDestination[$value['region_label']][] = [
                'DesSysId' => $value['DesSysId'],
                'Title' => $value['Title'],
                'Image' => $value['Image'],
            ];
            if(!in_array($value['region_label'], $continent_label)){
           
             $finalContinent[$value['ContinentId']][] =[
                 'Title' =>$value['region_name'],
                 'Label' =>$value['region_label'],
                 'Image' =>$value['region_image'],
               
             ];
             $continent_label[] = $value['region_label'];
            }
        }
        
        $array = [
           'region_name' => $region_names,
           'region_label' => $region_label,
//           'continent_label' => $continent_label,
           'destinations' => $finalDestination,
           'Regioncontinent' => $finalContinent,
           'AllContinent' => $tbl_all_continent,
        ];
//        echo "<pre>";print_r($array);die('here');
        return $array;
    }
    
    
     public function continentRegionForHeader() {
        $tbl_all_continent = $this->objMdl->rv_select_all( 'tbl_all_continent' , ['*'], ['status'=>1], ['ContinentId'=>'ASC']);  
        //$destinations = $this->objMdl->getDestinationsHeader(['tbl.IsActive' => 1, 'tbl.IsPublish' => 1, 'tbl.IsMarkForDel' => 0,  'tb2.IsMarkForDel' => 0], ['tbl.DesSysId' => 'ASC'], 50);
        $destinations = $this->objMdl->getContinentRegionHeader();
       $finalContinent = [];
//               echo "<pre>";print_r($destinations);die('here');  
       $i = 0;
        foreach ($destinations as $key => $value) {
            $region_nameFinal = '';
                
                $region_nameFinal = str_replace("and","&",  strtolower($value['region_name']));
             if($value['ContinentLabel'] !== 'india'){
//            $countryIds = explode(',', $value['countryIds']);   
//            $countries = explode(',', $value['countries']);   
                 
              $finalContinent[$value['ContinentTitle']]['Type'] = 'country'; 
            $finalContinent[$value['ContinentTitle']]['ContinentTitle'] = $value['ContinentTitle']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['Title'] = trim($region_nameFinal); 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['label'] = $value['region_label']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['Image'] = $value['region_image'];
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['countryId'][] = $value['countryId']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['countryName'][] = $value['countryTitle']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['countryName'][] = $value['countryTitle']; 
            
            
             }
             else{

                $finalContinent[$value['ContinentTitle']]['Type'] = 'state'; 
                $finalContinent[$value['ContinentTitle']]['ContinentTitle'] = $value['ContinentTitle']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['Title'] = $region_nameFinal; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['label'] = $value['region_label']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['Image'] = $value['region_image']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['countryId'][] = $value['StateSysId']; 
            $finalContinent[$value['ContinentTitle']]['region'][$value['region_label']]['countryName'][] = $value['stateTitle']; 
                    
             }  
   
        $i++;    
            
        }
//        echo "<pre>";print_r($finalContinent);die('here');
       
//        echo "<pre>";print_r($array);die('here');
        return $finalContinent;
    }
    
    
     public function destinationForHeaderNew() {
        $destinations = $this->objMdl->getDestinationsHeader(['tbl.IsActive' => 1,'tbl.IsMarkForDel' => 0, 'tbl.DisplayOnHeader' => 1], ['tbl.DesSysId' => 'ASC'], 50);
        $continent_label = $region_label = $region_names = $finalDestination = $finalContinent = [];
//echo "<pre>";print_r($destinations);die('here');
        foreach ($destinations as $key => $value) {

            if (($value['region_label'] != NULL) && !in_array($value['region_label'], $region_label)) {
                $region_names[] = $value['region_name'];
                $region_label[] = $value['region_label'];
            }
            $finalDestination[$value['region_label']][] = [
                'DesSysId' => $value['DesSysId'],
                'Title' => $value['Title'],
                'Image' => $value['Image'],
            ];
        }
        
        $array = [
           'region_name' => $region_names,
           'region_label' => $region_label,
//           'continent_label' => $continent_label,
           'destinations' => $finalDestination,
        ];
//        echo "<pre>";print_r($array);die('here');
        return $array;
    }
    

}
?>