<?php

class Travel_Model_VisaMaster {

    protected $db = NULL;
    public $intId = NULL;
    
    
    

    /*     * ************************************ */

    public function __construct() {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $this->db = Zend_Db_Table::getDefaultAdapter();
		$options = Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('bootstrap');
        $this->gtxagencysysid = $options['gtxagencysysid'];
        
    }

    public function __destruct() {
        $this->db->closeConnection();
    }
    
    
    
    public function visaSearch($keyword) {

        $keyword = str_replace('-', ' ', trim($keyword));

        $response = array();
        $whereCondition = " T1.IsMarkForDel = '0' AND T1.IsActive='1'  AND T1.ItemType = 6 AND T1.AgencySysId = ".$this->gtxagencysysid;

        $whereCondition .= " AND (T1.Countries like '%$keyword%' OR T1.Destinations like '%$keyword%')";
        $select = $this->db->select()
                ->from(array("T1" => "tb_tbb2c_packages_master"), array('T1.GTXPkgId', 'T1.CountryIds', 'T1.PkgSysId', 'T1.AgencySysId', 'T1.PackageCategory', 'T1.ItemType', 'T1.PackageType', 'T1.GTXPkgSourceId', 'T1.PackageSubType', 'T1.HotDeal', 'T1.DestinationsId', 'T1.ShortJsonInfo', 'T1.LongJsonInfo', 'T1.Destinations', 'T1.Countries', 'T1.MinPrice', 'T1.MaxPrice', 'T1.Nights', 'T1.Image', 'T1.MinPax', 'T1.PkgValidFrom', 'T1.PkgValidUntil', 'T1.BookingValidUntil', 'T1.StarRating', 'T1.visaFAQ','T1.packageNameUrl'))
                ->where($whereCondition);
//        echo $select;die;
        $response = $this->db->fetchAll($select);
            return $response;
    }
    public function visaSearchDetail($pkgId,$Countries) {

        $response = array();
        $whereCondition = " T1.IsMarkForDel = '0' AND T1.IsActive='1' AND T1.ItemType = 6 ";

//        $whereCondition .= " AND T1.PkgSysId = $pkgId ";
        $whereCondition .= " AND T1.packageNameUrl like '%$pkgId%' AND T1.Countries like '%$Countries%'";
        $select = $this->db->select()
                ->from(array("T1" => "tb_tbb2c_packages_master"), array('T1.GTXPkgId', 'T1.CountryIds', 'T1.PkgSysId', 'T1.AgencySysId', 'T1.PackageCategory', 'T1.ItemType', 'T1.PackageType', 'T1.GTXPkgSourceId', 'T1.PackageSubType', 'T1.HotDeal', 'T1.DestinationsId', 'T1.ShortJsonInfo', 'T1.LongJsonInfo', 'T1.Destinations', 'T1.Countries', 'T1.MinPrice', 'T1.MaxPrice', 'T1.Nights', 'T1.Image', 'T1.MinPax', 'T1.PkgValidFrom', 'T1.PkgValidUntil', 'T1.BookingValidUntil', 'T1.StarRating', 'T1.visaFAQ', 'T1.Keyword', 'T1.Description', 'T1.Metatag'))
                ->where($whereCondition);
//        echo $select;die;
        $response = $this->db->fetchAll($select);
            return $response;
    }
    
    public function visaSearchBannerImage($keyword) {

        $keyword = str_replace('-', ' ', trim($keyword));

        $response = array();
        $whereCondition = " T1.IsMarkForDel = '0' AND T1.IsActive='1'";

        $whereCondition .= " AND T1.Countries like '%$keyword%'";
        $select = $this->db->select()
                ->from(array("T1" => "tb_tbb2c_destinations"), array('T1.DesSysId','T1.Bannerimg'))
                ->where($whereCondition);
//        echo $select;die;
        $response = $this->db->fetchAll($select);
            return $response;
    }
    
    
    public function packageInclusion() {
        $response = array();
        $whereCondition = " T1.status = 1 ";
        $select = $this->db->select()
                ->from(array("T1" => "tbl_inclusion_icon"),array('T1.Title','T1.Icon'))
                ->where($whereCondition)
                ->order("T1.Title ASC");
        //echo $select;
        $data = $this->db->fetchAll($select);
        if($data){
            foreach ($data as $value) {
                $response[$value['Title']] = $value['Icon'];
            }
        }
        return $response;
    }
    
    public function packageThemes() {
        $response = array();
        $whereCondition = " T1.IsActive = '1' ";
        $select = $this->db->select()
                ->from(array("T1" => "tbl_pack_type"),array('T1.Title','T1.Icon'))
                ->where($whereCondition)
                ->order("T1.Title ASC");
        //echo $select;
        $data = $this->db->fetchAll($select);
        if($data){
            foreach ($data as $value) {
                $response[$value['Title']] = $value['Icon'];
            }
        }
        return $response;
    }
    
    
    
    public function getDestinationAutoSuggest($keyword , $table) {
        $keyword = trim($keyword);
        $response = array();
        
        $sql = "select DISTINCT(A.Destinations) as Destinations FROM $table A WHERE Destinations LIKE '%" .$keyword."%' ";
        $res = $this->db->query($sql)->fetchAll();
        
        if (count($res) > 0) {
            foreach ($res as $row) {
                $expDes = explode(',',$row['Destinations']);
                $response[] = array (
                    'label' => $row['Destinations'],
                    'value' => $row['Destinations'],
                );
            }
        }
        //echo '<pre>'; print_r($response); die;
        return $response;
    }
    
    public function getdestinationhome($table) {
        $response = array();
        
        $sql = "select DISTINCT(A.Destinations) as Destinations, A.Nights,A.MinPrice,A.MaxPrice FROM $table A WHERE 1=1 ";
        $res = $this->db->query($sql)->fetchAll();
        
        if (count($res) > 0) {
            foreach ($res as $row) {
                $expDes = explode(',',$row['Destinations']);
                $response[] = array (
                    'label' => $row['Destinations'],
                    'value' => $row['Destinations'],
                );
            }
        }
        //echo '<pre>'; print_r($response); die;
        return $res;
    }
    
    
    
    
    /* Added By Pardeep Panchal Ends */
    

    
   public function sendNewsLetter($tablename, array $addData) {
      
       $dbtable = new Zend_Db_Table($tablename);
        
        return $dbtable->insert($addData); // return inserted id
    }

    public function checkLetter($tablename, array $columns, array $where) {
        $dbtable = new Zend_Db_Table($tablename);
        $select = $dbtable->select()->from("$tablename as tbl", $columns);
        
        if(count($where)){
            foreach ($where as $k => $v)
            $select->where("$k =?","$v");
        }
        $result = $dbtable->fetchAll($select);
        if($result==NULL)
            return false;
        else
            return $result->toArray();
    }
   
    
    

}