<?php

class Travel_Model_TblHotelRooms {
    
    private $db = NULL;
    public $baseUrl;
    
    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 getRoomTypes($intLoggedinUserAgencySysId = 0) {
        if($intLoggedinUserAgencySysId > 0){
            $sql =" SELECT * from TB_Master_RoomType where IsActive = 1 and IsMarkForDel = 0 and (AgencySysId = $intLoggedinUserAgencySysId OR IsMaster = 1) ORDER BY Title ";
        }else{
            $sql =" SELECT * from TB_Master_RoomType where IsActive = 1 and IsMarkForDel = 0 ORDER BY Title ";
        }
        return $this->db->query($sql)->fetchAll();
    }
    
    public function getRoomAmenities($intLoggedinUserAgencySysId = '') {
        if((int)$intLoggedinUserAgencySysId > 0){
            $sql =" SELECT * from TB_Master_Accom_RoomAminity where AgencySysId = $intLoggedinUserAgencySysId OR AgencySysId is NULL ORDER BY Title ";
        }else{
            $sql =" SELECT * from TB_Master_Accom_RoomAminity ORDER BY Title ";
        }
        return $this->db->query($sql)->fetchAll();
    }
    
   public function getRoomType($RoomType) {
        $sql =" SELECT Title from TB_Master_RoomType WHERE RoomType='".$RoomType."'";
        return $this->db->query($sql)->fetchAll();
    }
    
}