<?php

class Travel_Model_ByoMaster {

    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 getTravelPlanData($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchRow($select);
        return $getTravelPlan;
    }
    public function getTravelPlanHotelData($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan_hotel_selected"));
       // $select->joinLeft(array('t2' => 'tb_traavelplan_destination'), 't1.TPSysId = t2.TPSysId',array("CitySysId","NoDay","StartDate","EndDate"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchAll($select);
        return $getTravelPlan;
    }
    public function getTravelPlanItineraryData($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan_itinerary"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchAll($select);
        return $getTravelPlan;
    }
     public function getTraavelplanTncData($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan_tnc"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchRow($select);
        return $getTravelPlan;
    }
     public function getDestination($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan_destination"),array("CitySysId","NoDay","StartDate","EndDate","Seq","destName"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchAll($select);
        $arraycity = array();
        foreach ($getTravelPlan as $val) {
            $keyVal = $val["Seq"];
            $arraycity[$keyVal]["NoDay"] = $val["NoDay"];
            $arraycity[$keyVal]["Seq"] = $val["Seq"];
            $arraycity[$keyVal]["CitySysId"] = $val["CitySysId"];
            $arraycity[$keyVal]["destName"] = $val["destName"];
            $arraycity[$keyVal]["StartDate"] = $val["StartDate"];
            $arraycity[$keyVal]["EndDate"] = $val["EndDate"];
        }
        return $arraycity;
    }
     public function getTraavelplanVehicles($TPSysId){
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan_vehicles"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $getTravelPlan = $this->db->fetchAll($select);
        return $getTravelPlan;
    }
    

    function getItnaryDays($TPSysId) {
        $select = $this->db->select()->from(array("t1" => "tb_traavelplan"), array("EndCityId","EndCity","StartCity","TotalAdult","TotalChild","TotalInfant","StartDate"));
        $select->joinLeft(array('t2' => 'tb_traavelplan_destination'), 't1.TPSysId = t2.TPSysId',array("CitySysId","NoDay"));
        $select->joinLeft(array('t3' => 'tb_master_geo_city'), 't2.CitySysId = t3.CityId', array("Title"));
        $select->where("t1.TPSysId = ?", $TPSysId);
        $select->order("t2.StartDate ASC");
      //  echo $select;exit;
        $getZsontoArray = $this->db->fetchAll($select);
        $totalDays = 0;
        $arraycity = array();
        $i = 0;
        foreach ($getZsontoArray as $key => $val) {
            $days = (int) $val['NoDay'];
            $totalDays = $totalDays + $days;
            $arraycity['CitySysId'][$i]['days'] = (int) $days;
            $arraycity['CitySysId'][$i]['cityId'] = (int) $val['CitySysId'];
            $arraycity['CitySysId'][$i]['cityIdName'] = $val['Title'];
            $arraycity['EndCityId'] = (int) $val['EndCityId'];
            $arraycity['EndCity'] =  $val['EndCity'];
            $arraycity['StartCity'] =  $val['StartCity'];
            $arraycity['TotalAdult'] = (int) $val['TotalAdult'];
            $arraycity['TotalChild'] = (int) $val['TotalChild'];
            $arraycity['TotalInfant'] = (int) $val['TotalInfant'];
            $arraycity['StartDate'] =  $val['StartDate'];
            
            $i++;
        }
        $returnArray = array();
            $d=0;
            foreach ($arraycity['CitySysId'] as $valueCity) {
                for ($k = 0; $k<$valueCity['days']; $k++) {
                    $returnArray[$d]['destSysId'] = $valueCity['cityId'];
                    $returnArray[$d]['CityName'] = $valueCity['cityIdName'];
                    $d++;
                }
            }
         $returnArray[$d]['destSysId'] = $arraycity['EndCityId'];
         $returnArray[$d]['CityName'] = $arraycity['EndCity'];

         $returnAr = array(
             "arraycity"=>$arraycity,
             "returnArray"=>$returnArray
         );
         
        
        return $returnAr;
    }

     public function getLoginFooterData(){
        $select = $this->db->select()->from(array("t1" => "tbl_query"));
        $select->where("t1.status = ? and isb2b = ?", 1,1);
        $select->order("t1.id DESC");
        $result = $this->db->fetchRow($select);
        return $result;
    }
   


}