<?php

class Travel_Model_TblAmenities {
    
    private $db = NULL;
    
    public $intId = NULL;
    
    public $strCondition  = NULL;
    
    public $orderByField = 'AminityId';
    
    public $orderBy      = 'ASC' ;
    
     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 getAccomodationAmenitiesList() {
        $sql = " SELECT AminityId, CatMask, Title, Icon, UpdateDate, CreateDate, IsMarkForDel, IsActive
                 FROM TB_Master_Accom_AccomAminity WHERE 1 = 1 " ;
        
        if(!empty($this->strCondition)) {
            $sql .= $this->strCondition;
        }
        
        
        
        return $this->db->query($sql)->fetchAll();
        
    }
    
    
    
    public function getHotlAmenitiesforPopupApi($hotelcode) { 
        $sql = " SELECT TOP 1 AccoAminitiesMask FROM TB_IC_Accomdation_API WHERE ShortName ='".$hotelcode."' ORDER BY AccomSysId DESC ";
        
    $htmAminityPop='';
        $result=$this->db->query($sql)->fetchAll();
        foreach($result as $val){
            $hotelAminity = $val['AccoAminitiesMask'];
        }
		$hotelAminity=substr($hotelAminity,1);
        //echo $hotelAminity; exit;
        $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_AccomAminity Where IsActive = 1 ";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
      if($hotelAminity!=''){
        $htlaminiti = str_split($hotelAminity);
           //unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            //print_r($aminitiesArray);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
              $s=0;        
            foreach ($amitnity as $key => $value) {
                if ($value == 1) {
                   
                    $htmAminityPop[$s]=$key;
                    $s++;
                }
                
                }
               
                //print_r($resutl);
        return $htmAminityPop;
      }
    }
    
    
    
    public function getRoomAmenitiesList() {
        $sql = " SELECT AminityId, Title, Icon, UpdateDate, CreateDate, IsMarkForDel, IsActive
                 FROM TB_Master_Accom_RoomAminity WHERE 1 = 1 " ;
        
        if(!empty($this->strCondition)) {
            $sql .= $this->strCondition;
        }
        
        $sql .= " ORDER BY " . $this->orderByField . " " . $this->orderBy ;
        
        return $this->db->query($sql)->fetchAll();
    }
    

    public function getHotlRoomAmenities() {
         $sql = " SELECT  Title FROM TB_Master_Accom_RoomAminity WHERE 1 = 1 " ;
        
        if(!empty($this->strCondition)) {
            $sql .= $this->strCondition;
        }
        
        $sql .= " ORDER BY " . $this->orderByField . " " . $this->orderBy ;
        $result=$this->db->query($sql)->fetchAll();
        $res=array();
        foreach($result as $val){
            $res[]=$val['Title'];
        }
        return $res;
    }
/*public function getHotlAmenities($hotelCode) {
        $resutl=array();
        $sql = " SELECT  AccoAminitiesMask FROM TB_IC_Accomdation WHERE ShortName ='".$hotelCode."'" ;
        
    
        $result=$this->db->query($sql)->fetchAll();
        foreach($result as $val){
            $hotelAminity=$val['AccoAminitiesMask'];
        }
         $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_AccomAminity ";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
      if(isset($hotelAminity)){
        $htlaminiti = str_split($hotelAminity);
           unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
                      
            foreach ($amitnity as $key => $value) {
                if ($value == 1) {
                   $MstImgsql = " SELECT Icon FROM TB_Master_Accom_AccomAminity where Title='".$key."'";//AND Title like '" .$keyword."%'" ;
                    $rowsetimg = $this->db->query($MstImgsql)->fetchAll();
                    foreach($rowsetimg as $imgV){
                        $IconActive[$key]=$imgV['Icon'];
                    }
                    
                }else{
                  $MstImgsqlIn = " SELECT GreyIcon FROM TB_Master_Accom_AccomAminity where Title='".$key."'";//AND Title like '" .$keyword."%'" ;
                    $rowsetimgIn = $this->db->query($MstImgsqlIn)->fetchAll();
                    foreach($rowsetimgIn as $imgVa){
                        $IconInActive[$key]=$imgVa['GreyIcon'];
                    } 
                }
                }
                $resutl=  array_merge($IconActive,$IconInActive);
                //print_r($resutl);
                }
        return $resutl;
        
    }*/
    public function getHotlAmenitiesforPopup($hotelAminity) {
        
         $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_AccomAminity ";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
      
        $htlaminiti = str_split($hotelAminity);
           unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
              $s=0;        
            foreach ($amitnity as $key => $value) {
                if ($value == 1) {
                   
                    $htmAminityPop[$s]=$key;
                    $s++;
                }
                
                }
               
                //print_r($resutl);
        return $htmAminityPop;
    }
    public function getRoomInventoryAmenitiesDB($hotelAminity) {
//        $sql = " SELECT  AccoAminitiesMask FROM TB_IC_Accomdation WHERE ShortName ='".$hotelCode."'" ;
//        
//    
//        $result=$this->db->query($sql)->fetchAll();
//        foreach($result as $val){
//            $hotelAminity=$val['AccoAminitiesMask'];
//        }
    
         $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_RoomAminity ";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
      
        $htlaminiti = str_split($hotelAminity);
     
           unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
            //print_r($amitnity);
            foreach($amitnity as $key=>$value){
                
                if($value=='1'){
                    $roomAmi[]=$key;
                }
            }
           // print_r($roomAmi);
        return $roomAmi;
    }
public function getHotlAmenitiesDB($hotelAminity) {
//        $sql = " SELECT  AccoAminitiesMask FROM TB_IC_Accomdation WHERE ShortName ='".$hotelCode."'" ;
//        
//    
//        $result=$this->db->query($sql)->fetchAll();
//        foreach($result as $val){
//            $hotelAminity=$val['AccoAminitiesMask'];
//        }
    
        $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_AccomAminity WHERE IsActive = '1'";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
//      11000000000000000
//      100000000011001011
        $htlaminiti = str_split($hotelAminity);
     
           unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
//            echo "<pre>";
//            print_r($amitnity);
                      
            foreach ($amitnity as $key => $value) {
                if ($value == 1) {
                   $MstImgsql = " SELECT Icon FROM TB_Master_Accom_AccomAminity where Title='".$key."' AND IsActive = '1'";//AND Title like '" .$keyword."%'" ;
                    $rowsetimg = $this->db->query($MstImgsql)->fetchAll();
                    foreach($rowsetimg as $imgV){
                        $IconActive[$key]=$imgV['Icon'];
                    }
                    
                }else{
                  $MstImgsqlIn = " SELECT GreyIcon FROM TB_Master_Accom_AccomAminity where Title='".$key."'";//AND Title like '" .$keyword."%'" ;
                    $rowsetimgIn = $this->db->query($MstImgsqlIn)->fetchAll();
                    foreach($rowsetimgIn as $imgVa){
                        $IconInActive[$key]=$imgVa['GreyIcon'];
                    } 
                }
                }
                $resutl=  array_merge($IconActive,$IconInActive);
                print_r($IconActive);
        return $resutl;
    }
    public function getRoomAmenitiesDB($hotelAminity) {
//        $sql = " SELECT  AccoAminitiesMask FROM TB_IC_Accomdation WHERE ShortName ='".$hotelCode."'" ;
//        
//    
//        $result=$this->db->query($sql)->fetchAll();
//        foreach($result as $val){
//            $hotelAminity=$val['AccoAminitiesMask'];
//        }
    
         $MstAminitysql = " SELECT AminityId, Title  FROM TB_Master_Accom_RoomAminity ";//AND Title like '" .$keyword."%'" ;
        $rowsetMst = $this->db->query($MstAminitysql)->fetchAll();
        foreach($rowsetMst as $val){
            $aminity[]=$val['Title'];
        }
      
        $htlaminiti = str_split($hotelAminity);
     
           unset($htlaminiti[0]);
            $aminitiesArray = array_values($htlaminiti);
            $count = min(count($aminity), count($aminitiesArray));
           
            $amitnity = array_combine($aminity, $aminitiesArray);
//                      
//            foreach ($amitnity as $key => $value) {
//                if ($value == 1) {
//                   $MstImgsql = " SELECT Icon FROM TB_Master_Accom_RoomAminity where Title='".$key."'";//AND Title like '" .$keyword."%'" ;
//                    $rowsetimg = $this->db->query($MstImgsql)->fetchAll();
//                    foreach($rowsetimg as $imgV){
//                        $IconActive[$key]=$imgV['Icon'];
//                    }
//                    
//                }else{
//                  $MstImgsqlIn = " SELECT GreyIcon FROM TB_Master_Accom_RoomAminity where Title='".$key."'";//AND Title like '" .$keyword."%'" ;
//                    $rowsetimgIn = $this->db->query($MstImgsqlIn)->fetchAll();
//                    foreach($rowsetimgIn as $imgVa){
//                        $IconInActive[$key]=$imgVa['GreyIcon'];
//                    } 
//                }
//                }
                $resutl=  array_merge($IconActive,$IconInActive);
                //print_r($resutl);
        return $resutl;
    }
    public function createMask($amenitiesIds) {
        
        $mask = '1';
        
        $arrAmenities = explode(",", $amenitiesIds);
        $arrMasterAmenities = $this->getRoomAmenitiesList();
        
        if(count($arrMasterAmenities) > 0 ) {
            foreach($arrMasterAmenities as $amenity) {
                $char = in_array($amenity['AminityId'], $arrAmenities) ? '1' : '0' ;
                $mask .= $char;
            }
        }
        
        return $mask;
    }
    public function getAmenitiesFromMask($mask, $format) {
        if(empty($mask)) return array();
        
        $objAmenity = new Travel_Model_TblAmenities();
        $objAmenity->orderByField = 'AminityId' ;
        $objAmenity->orderBy     = 'ASC' ;
        $arrRoomAmenities = $objAmenity->getRoomAmenitiesList();
        
        $amenityIds = '' ;
        for($i = 1; $i <= strlen($mask); $i++ ) {
            $ch = substr($mask, $i, 1);
            if($ch == '1') $amenityIds .= ($i) ."," ;
        }
        
        if(strTolower($format) == 'comma') return $amenityIds ;
        
        if(!empty($amenityIds)) {
            $amenityIds = Zend_Controller_Action_HelperBroker::getStaticHelper('String')->cleanCommaSepString($amenityIds);
            $objAmenity = new Travel_Model_TblAmenities();
            $objAmenity->strCondition = " AND TB_Master_Accom_RoomAminity.AminityId IN ( ".$amenityIds." ) ";
            return $objAmenity->getRoomAmenitiesList();
        }
        
        return array();
        
    }
   public function getHotelAminitiesWithCategory(){
       
          $sql = " SELECT  TB_Master_Accom_AccomAminity.Title, TB_Master_Accom_Aminity_Cat.Title as Category"
                 . " FROM TB_Master_Accom_AccomAminity LEFT JOIN TB_Master_Accom_Aminity_Cat "
                 . " ON TB_Master_Accom_AccomAminity.CatMask=TB_Master_Accom_Aminity_Cat.AminityCatId" ;
        
        if(!empty($this->strCondition)) {
            $sql .= $this->strCondition;
        }
        
        $sql .= " ORDER BY " . $this->orderByField . " " . $this->orderBy ;
        $result=$this->db->query($sql)->fetchAll();
       
        return $result;
       
       
       
   }
   
   
   
   /* Added By Pardeep */
   
   public function getAminitiesList(){
       $arrAminity = array('AminityId','Title','Icon','GreyIcon');
       $select = $this->db->select();
       $select->from(array('t1' => 'TB_Master_Accom_AccomAminity'),$arrAminity);
       $select->where('t1.IsActive = ?',1);
       if(!empty($this->strCondition)) {
           $select->where($this->strCondition);
        }
       $select->order('AminityId ASC');
       $result = $this->db->fetchAll($select);
       return $result;
   }


   /* Added By Pardeep */
    
    
}