<?php

class Travel_Model_PackagesMaster
{

    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();
    }

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

    public function packageSearch($keyword, $keywordsCat = NULL)
    {
        $keyword = str_replace('-', ' ', trim($keyword));
        $keywordsCat = ucwords(str_replace('-', ' ', trim($keywordsCat)));
        //echo $keywordsCat;die;
        $response = array();
        $whereCondition = " T1.IsMarkForDel = '0' AND T1.IsActive='1' AND T1.IsPublish = 1 AND T1.ItemType = 1 ";
        if (trim($keyword) != '') {
            $whereCondition .= " AND T1.PackageSearchString LIKE '%$keyword%' ";
        }
        if (trim($keywordsCat) != '') {
            $whereCondition .= " AND T1.PackageCategory LIKE '%$keywordsCat%' ";
        }
        //$whereCondition .= " AND ',' + T1.Destinations + ',' like '%,' + '$keyword' + ',%' ";
        $select = $this->db->select()
            ->from(array("T1" => "tb_tbb2c_packages_master"), array('T1.GTXPkgId', 'T1.PkgSysId', 'T1.AgencySysId', 'T1.PackageCategory', 'T1.ItemType', 'T1.PackageType', 'T1.GTXPkgSourceId', 'T1.PackageSubType', 'T1.HotDeal', 'T1.DestinationsId', 'T1.ShortJsonInfo', 'T1.LongJsonInfo', 'T1.PackageSearchString AS Destinations', 'T1.Countries', 'T1.CountryIds', 'T1.MinPrice', 'T1.MaxPrice', 'T1.Nights', 'T1.Image', 'T1.MinPax', 'T1.PkgValidFrom', 'T1.PkgValidUntil', 'T1.BookingValidUntil', 'T1.StarRating'))
            ->where($whereCondition)
            ->order("T1.DisplayIndex DESC")
            ->order("T1.MinPrice ASC");
        //echo $select;die;
        $response = $this->db->fetchAll($select);
        //echo '<pre>'; print_r($response); die;
        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();
    }
}