<?php
/*
                             *******************
*******************************    PHP FILE   *******************************
**                           *******************                           **
**                                                                         **
**  project   : Online Booking Manager                                     **
**  filename  : index.php                                                  **
**  version   : 2.2                                                        **
**  date      : July 15, 2006                                              **
*****************************************************************************
**                                                                         **
** Copyright (c) 2004, SoftVisions SRL                                     **
** All rights reserved.                                                    **
**                                                                         **
** The source code for this program is not published or otherwise divested **
** of its trade secrets.                                                   **
**                                                                         **
** Disclosure restricted unless granted by                                 **
** formal written contract with SoftVisions SRL.                           **
**                                                                         **
**                                                                         **
** Contact: office@soft-visions.com                                        **
**                                                                         **
*****************************************************************************                                                                    **
                                                                           **
VERSION HISTORY:                                                           **
----------------                                                           **
                                                                           **
Version : 2.2                                                              **
Date : June 15, 2004                                                       **
Revised by : SoftVisions SRL                                               **
Description : Original version.                                            **
                                                                           **
*****************************************************************************
*/
		//JUDD
		function generateURL($ln, $RoomType) {
			$prop = str_replace (" ", "_", $RoomType);
			$arrayLanguages = array("en" =>"apartments","de" =>"wohnungen", "fr" => "appartements");
			$apartment = $arrayLanguages[$ln];
			return "http://www.akaza.net/$ln/$apartment/$prop.html";
		}
		//END JUDD

   include ("obm22/funct.php");
   include ("include.php");
   if ($ln == ""){
      $ln = "en";
   }
   $id = 1;
   $refName = getRefName();
   $strResArchive = "$refName~";
   loadTranslationFile("default");
   $MyHTTP_POST_GET_VARS = getHTTP_POST_GET_VARS($HTTP_POST_VARS,$HTTP_GET_VARS);

   $query1 = "select Left(c.Name,3) as cur,h.Name from currency c,hotel h where h.HotelID= $id and c.CurrencyID= h.CurrencyID";
   $res1 = dataQuery($query1);
   $row1 = mysql_fetch_array($res1);
   $cur = $row1["cur"];
   $hotelName = $row1[Name];

   $currentDate = mktime();
   $currentYear = date("Y",$currentDate);
   if (!isSet($typeSearch)){
      $typeSearch = "withoutAvailability";
   }
   if (!isSet($guests)){
      $guests = 1;
   }
   if (!isSet($areaID)){
      $areaID = 0;
   }
   if (!isSet($page)){
      $page = 1;
   }
   if (!isSet($shortTerm)){
      $shortTerm = "all";
   }
   
   if (!isSet($searchNew)){
      $searchNew = "yes";

      $nextDay = $currentDate + 1*24*60*60;
      $nextWeek = $currentDate + 8*24*60*60;
      $daysI = date("j",$nextDay);
      $monthsI = date("n",$nextDay);
      $yearI = date("Y",$nextDay);
      $daysS = date("j",$nextWeek);
      $monthsS = date("n",$nextWeek);
      $yearS = date("Y",$nextWeek);

      $showOnlyAvailable = "no";

   }
   if (($searchNew == "no") and ($strFacilities != "")){
      $tmpKeysFac = split(",", $strFacilities);
      $facilities = array();
      foreach ($tmpKeysFac as $k => $v){
         $facilities[$v] = "on";
      }
   }

   $arrFacID = array();
   if ((isset($facilities)) and (count($facilities) != 0)){
      foreach ($facilities as $k => $v){
         $arrFacID[count($arrFacID)] = $k;
      }
   }

   $dateI = mktime(0,0,0,$monthsI,$daysI,$yearI);
   $dateS = mktime(0,0,0,$monthsS,$daysS,$yearS);
   $nights = round((date($dateS) - date($dateI)) /(24*60*60));

   $perPage = 10;
   $rooms = 1;
   $pageName = $_SERVER[PHP_SELF];


   $arrAreas = array();
   $arrAreasSave = array();
   $arrPropID = array();
   $strPropID = "";
   $queryAreas = "SELECT AreaID,Name from areas where HotelID='$id' order by OrderID,Name";
   $resultAreas = dataQuery($queryAreas);
   $numResAreas = mysql_num_rows($resultAreas);

   //initializez arrPropRate, arrPropErrCode, arrPropErrValue
   $arrPropRate = array();
   $arrPropErrCode = array();
   $arrPropErrValue = array();

   while ($rowAreas = mysql_fetch_array($resultAreas)){
      $areaName = $rowAreas[Name];
      if ($ln != "en"){
         $queryAreaTrans = "select Name from translateareas where AreaID='$rowAreas[AreaID]' and Language='$ln'";
         $rowAreasTrans = mysql_fetch_array(dataQuery($queryAreaTrans));
         if (trim($rowAreasTrans) != ""){
            $areaName = $rowAreasTrans[Name];
         }
      }


      $arrAreasSave[$rowAreas[AreaID]] = $areaName;


      //selectez toate proprietatile cu areaID curenta si dupa ce obtin PropID
      //daca am areaID != 0 le bag in fata !!!!!!
      $tmpArrPropID = array();
      $tmpStrPropID = "";
      $countRommsFac = 0;

      $andShortTerm = "";
      if ($shortTerm != "all"){
         $andShortTerm = "and ShortTerm='$shortTerm'";
      }
      $queryResults = "select RoomID from room where AreaID='$rowAreas[AreaID]' $andShortTerm and PropertyType='A' and HotelID='$id' order by OrderID,TypeRoom";
      if ($typeSearch == "withAvailability"){
         $queryResults = "select RoomID from room where AreaID='$rowAreas[AreaID]' $andShortTerm and PropertyType='A' and HotelID='$id' and Guests >= '$guests' order by OrderID,TypeRoom";
      }
      $resResults = dataQuery($queryResults);

      while ($rowResults = mysql_fetch_array($resResults)){
         $queryF2R = "SELECT FacilityID FROM facilitiestorooms where RoomID='$rowResults[RoomID]'";
         $resF2R = dataQuery($queryF2R);
         $arrF2R = array();
         while ($rowF2R = mysql_fetch_array($resF2R)){
            $arrF2R[count($arrF2R)] = $rowF2R[FacilityID];
         }

         $errCode = "";
         $errValue = "";
         $totalPrice = 0;
         if ($typeSearch == "withAvailability"){
            $typeRoom = $rowResults[RoomID];
            $str = minimStay($dateI,$dateS,$id,$typeRoom);
            if ($str == ""){//if min stay//=""minim stay is ok
               $srtMax = maximumStay($dateI,$dateS,$id,$typeRoom);
               if ($srtMax == ""){//maxStay is ok
                  $strSDays = startingDays($dateI,$dateS,$id,$typeRoom);
                  $strEDays = endingDays($dateI,$dateS,$id,$typeRoom);
                  if (($strSDays == "") and ($strEDays == "")){
                     if (isHotelOpen($dateI,$dateS,$id,$typeRoom) == 1) {
                        $errCode = "noRooms";
                     }elseif(($availRoom=isRoomAvail($dateI,$dateS,$id,$typeRoom,$rooms)) <> -1){///////////isRoomAvail():0 camere disponibile  //////////////////
                        if ($availRoom <= 0){
                           $errCode = "noRooms";
                        }else{
                           $errCode = "notEnoughRooms";
                        }
                     }else{///availability ok
                        $dateT = $dateI;
                        $flag = 0;
                        $arrayRates = getRates();// get the rates
                        foreach ($arrayRates as $v){
                           $totalPrice += $v[2];
                           $totalPriceS = $totalPrice;
                        }
                        //aici se seteaza flag
                        $dDateI = date("Y-m-d",$dateI);
                        
                        $query = "select TypeRoom,Description,Photo,Deposit,Type,Cleaning,TypeC from room where RoomID='$typeRoom'";
                        $res1 = dataQuery($query);
                        $row1 = mysql_fetch_array($res1);
         
                        $discPrice = 0;
                        $queryDisc = "Select d.* from discounts d, discountstorooms dr where d.Nights='$nights' and d.HotelID='$id' and d.Status='a' and d.DiscountID=dr.DiscountID and dr.RoomID='$typeRoom' and ('$dDateI' between d.Start and d.End)";
                        $rowDisc = mysql_fetch_array(dataQuery($queryDisc));
                        if ($rowDisc[Value] != 0){
                           $valDisc = "";
                           $discPrice = $rowDisc[Value];
                           if ($rowDisc[Type] == "p"){
                              $valDisc = "$rowDisc[Value] %";
                              $discPrice = ($totalPrice * $rowDisc[Value]) / 100;
                           }
                        }
                        $totalPrice -= $discPrice;
         
                        //aici booking fee
                        $deposit = $row1[Deposit];
                        if ($row1[Type] == "p"){
                           $deposit = ($totalPrice * $row1[Deposit]) / 100;
                        }
                        $totalPrice += $deposit;
         
                        $discPromo = 0;
                        if ($promoCode != ""){
                           $queryPromo = "Select p.* from promotions p, promotionstorooms pr where p.Name='$promoCode' and p.HotelID='$id' and p.Status='a' and p.PromotionID=pr.PromotionID and pr.RoomID='$typeRoom'";
                           $rowPromo = mysql_fetch_array(dataQuery($queryPromo));
                           if ($rowPromo[Value] != 0){
                              $valPromo = "";
                              $discPromo = $rowPromo[Value];
                              if ($rowPromo[Type] == "p"){
                                 $valPromo = "$rowPromo[Value] %";
                                 $discPromo = ($totalPrice * $rowPromo[Value]) / 100;
                              }
                           }
                        }
                        $totalPrice -= $discPromo;
         
                        //aici cleaning fee
                        $cleaning = $row1[Cleaning];
                        if ($row1[TypeC] == "p"){
                           $cleaning = ($totalPrice * $row1[Cleaning]) / 100;
                        }
                        $totalPrice += $cleaning;
                        
                        
                        if ($flag == 1){
                           $errCode = "onRequest";
                        }

                     }///end else availability ok
                  }else{
                     if ($strSDays != ""){
                        //echo getHtmlErrStay($strSDays);
                        $errCode = "startDay";
                        $errValue = $strSDays;
                     }else if ($strEDays != ""){
                        //echo getHtmlErrStay($strEDays);
                        $errCode = "endDay";
                        $errValue = $strEDays;
                     }
                  }
               }else{//if max stay//<> ""maximum stay is not ok
                  //echo getHtmlErrStay($srtMax);
                  $errCode = "maxStay";
                  $errValue = $srtMax;
               }
            }else{//if min stay//<> ""minimum stay is not ok
               //echo getHtmlErrStay($str);
               $errCode = "minStay";
               $errValue = $str;
            }

         }

         $arrPropRate[$typeRoom] = $totalPrice;
         $arrPropErrCode[$typeRoom] = $errCode;
         $arrPropErrValue[$typeRoom] = $errValue;

         //echo "<br><br> RoomID $typeRoom $totalPrice" . var_dump($arrPropErrValue) . "<br><br>";

         if ((count(array_diff($arrFacID,$arrF2R)) == 0) and ($errCode == "")){
            $countRommsFac ++;
            $tmpArrPropID[count($tmpArrPropID)] = $rowResults[RoomID];
         }
      }

      //var_dump($arrPropRate);

      if (count($tmpArrPropID) != 0){
         $tmpStrPropID = join(",",$tmpArrPropID);
      }
      if ($rowAreas[AreaID] == $areaID){
         array_unshift($arrAreas,array("$rowAreas[AreaID]","$areaName","$rowCountProp[NrProp]"));

         //array_unshift($arrPropID, $tmpStrPropID);
         if ($tmpStrPropID != ""){
            if ($strPropID == ""){
               $strPropID = $tmpStrPropID;
            }else{
               $strPropID = $tmpStrPropID . "," . $strPropID;
            }
         }
      }else{
         $arrAreas[count($arrAreas)] = array("$rowAreas[AreaID]","$areaName","$rowCountProp[NrProp]");
         //array_push($arrPropID, $tmpStrPropID);
         if ($tmpStrPropID != ""){
            if ($strPropID == ""){
               $strPropID = $tmpStrPropID;
            }else{
               $strPropID = $strPropID . "," . $tmpStrPropID;
            }
         }
      }
   }
   if ($strPropID != ""){
      $arrPropID = split(",",$strPropID);
   }

?>
<html>
<head>
   <script type="text/javascript">
      function openmappopup(popurl){
         var winpops=window.open(popurl,"","width=800,height=600")
      }

      function openpopup(popurl){
         var winpops=window.open(popurl,"","width=430,height=200")
      }
      function setCurrentDate(){
         checkin = new Date();
         checkout = new Date();
         checkin.setDate(checkin.getDate()+1);
         checkout.setDate(checkout.getDate()+8);
         selectElement(window.document.checka.daysI,checkin.getDate());
         selectElement(window.document.checka.monthsI,checkin.getMonth()+1);
         selectElement(window.document.checka.yearI,checkin.getFullYear());
         selectElement(window.document.checka.daysS,checkout.getDate());
         selectElement(window.document.checka.monthsS,checkout.getMonth()+1);
         selectElement(window.document.checka.yearS,checkout.getFullYear());
      }
      function selectElement(param,testValue){
         for (var i = 0; i < param.length; i++) {
            if (param.options[i].value == testValue) {
               param.options[i].selected = true;
            }
         }
      }
      function openMR(){
         var width = screen.Width - 50;
         var height = screen.Height - 200;
         var str = "height=" + height + ",innerHeight=" + height;
         str += ",width=" + width + ",innerWidth=" + width;
         if (window.screen) {
            var ah = screen.availHeight - 100;
            var aw = screen.availWidth - 10;
            var xc = (aw - width) / 2;
            var yc = (ah - height) / 2;
            str += ",left=" + xc + ",screenX=" + xc;
            str += ",top=" + yc + ",screenY=" + yc;
         }
         window.open('obm22/checkavail.php?ln=en','obm22','scrollbars=yes,status=yes,menubar=no,toolbar=yes,' + str);
      }
      function openCR(){
         var width = screen.Width - 50;
         var height = screen.Height - 200;
         var str = "height=" + height + ",innerHeight=" + height;
         str += ",width=" + width + ",innerWidth=" + width;
         if (window.screen) {
            var ah = screen.availHeight - 100;
            var aw = screen.availWidth - 10;
            var xc = (aw - width) / 2;
            var yc = (ah - height) / 2;
            str += ",left=" + xc + ",screenX=" + xc;
            str += ",top=" + yc + ",screenY=" + yc;
         }
         window.open('obm22/cancel_res.php?ln=en','obm22','scrollbars=yes,status=yes,menubar=no,toolbar=yes,' + str);
      }
      function verifica() {
         var data1,data2,d,dat1,dat2;
         data1 = new Date();
         data2 = new Date();
         if (window.document.checka.yearI.options[window.document.checka.yearI.selectedIndex].value == "0" ||
            window.document.checka.monthsI.options[window.document.checka.monthsI.selectedIndex].value == "0" ||
            window.document.checka.daysI.options[window.document.checka.daysI.selectedIndex] == "0" ||
            window.document.checka.yearS.options[window.document.checka.yearS.selectedIndex] == "0" ||
            window.document.checka.monthsS.options[window.document.checka.monthsS.selectedIndex] == "0" ||
            window.document.checka.daysS.options[window.document.checka.daysS.selectedIndex] == "0")
         {
            alert ("<?=$alert1?>");
            return false;
         }
         d = new Date();
         dc = new Date(d.getFullYear(),d.getMonth(), d.getDate());
         dataC = Date.parse(dc.toUTCString());

         dat1 = new Date(window.document.checka.yearI.options[window.document.checka.yearI.selectedIndex].value, parseInt(window.document.checka.monthsI.options[window.document.checka.monthsI.selectedIndex].value) -1 ,window.document.checka.daysI.options[window.document.checka.daysI.selectedIndex].value);
         dat2 = new Date(window.document.checka.yearS.options[window.document.checka.yearS.selectedIndex].value, parseInt(window.document.checka.monthsS.options[window.document.checka.monthsS.selectedIndex].value) -1 ,window.document.checka.daysS.options[window.document.checka.daysS.selectedIndex].value);
         data1 = Date.parse(dat1.toUTCString());
         data2 = Date.parse(dat2.toUTCString());

         if(dataC > data1){
            alert("<?=$alert2?>");
            return false;
         }
         if (data1 >= data2){
            alert ("<?=$alert3?>");
            return false;
         }
         return true;
      }

      function openW(){
         if (verifica()){
            var width = screen.Width - 50;
            var height = screen.Height - 200;
            var str = "height=" + height + ",innerHeight=" + height;
            str += ",width=" + width + ",innerWidth=" + width;
            if (window.screen) {
               var ah = screen.availHeight - 100;
               var aw = screen.availWidth - 10;
               var xc = (aw - width) / 2;
               var yc = (ah - height) / 2;
               str += ",left=" + xc + ",screenX=" + xc;
               str += ",top=" + yc + ",screenY=" + yc;
            }
            window.open('','obm22','scrollbars=yes,status=yes,menubar=no,toolbar=yes,' + str);
            window.document.checka.submit();
         }else{
            return false;
         }
      }

      // Checks if browser is Netscape 2.0x since the options array properties don't work with Netscape 2.0x
      function isBrowserSupp() {
      // Get the version of the browser
         version =  parseFloat( navigator.appVersion );
         if ( ( version >= 2.0 ) && ( version < 2.1 ) && ( navigator.appName.indexOf( "Netscape" ) != -1 ) ) {
            return false;
         }else {
            return true;
         }
         return true;
      }

      function isLeapYear( yrStr ) {
         var leapYear = false;
         var year = parseInt( yrStr, 10 );
         if ( year % 4 == 0 ) {
            leapYear = true;
            if( year % 100 == 0 ) {
               leapYear = false;
               if( year % 400 == 0 ) {
                  leapYear=true;
               }
            }
         }
         return leapYear;
      }

      function getDaysInMonth( mthIdx, YrStr ) {
         var maxDays = 31
         if( mthIdx == 1 ) {
            if( isLeapYear( YrStr ) ) {
               maxDays=29;
            } else {
               maxDays=28;
            }
         }

         if( mthIdx == 3 || mthIdx == 5 || mthIdx == 8 || mthIdx == 10 ) {
            maxDays=30;
         }
         return maxDays;
      }

      function adjustDate( monthObj, dayObj, yearObj ) {
         var value = 0;
         var mthIdx = monthObj.options.selectedIndex;
         var Dt = dayObj;
         var theYear = yearObj.options[yearObj.options.selectedIndex].value;
         var numDays = getDaysInMonth( mthIdx, theYear );
         if( mthIdx == 1 ) {
            if( Dt.options.selectedIndex + 2 < numDays ) {
               return 0;
            } else {
               if( Dt.options.selectedIndex + 1 > numDays) {
                  Dt.options.selectedIndex=numDays - 1;
               }
               if( (Dt.options.selectedIndex + 1) == numDays ) {
                  return 1;
               } else {
                  return 4;
               }
            }
         }
         if( Dt.options.selectedIndex + 2 < numDays ) {
            value = 0;
         } else {
            if ( Dt.options.selectedIndex + 1 > numDays ) {
               Dt.options.selectedIndex--;
               value = 3;
            } else if ( Dt.options.selectedIndex + 1 == numDays ) {
               value = 2;
            } else {
               value = 4;
            }
         }
         return value;
      }

      function amadChange( inM, inD, inY ) {
         if ( !isBrowserSupp() ) {
            return;
         }
         var res = adjustDate( inM.options.selectedIndex, inD, inY.options[inY.options.selectedIndex].value );
         return;
      }

      function dmddChange( outM, outD, outY ) {
         if ( !isBrowserSupp() ) {
            return;
         }
         adjustDate( outM.options.selectedIndex, outD, outY.options[outY.options.selectedIndex].value );
         return;
      }
      function openMap(map,wImg,hImg){
         if (typeof(winMap) == "object" && winMap != null ){
            winMap.close();
         }
         winMap = window.open('obm22/map_photo.php?ln=<?=$ln?>&map=' + map,'map','scrollbars=no,status=no,width=' + wImg + ',height=' + hImg + ',top=0,left=0,menubar=no,titlebar=Property Map');
      }

      function sendRequest(forma){
         var regex = /^[a-zA-Z0-9._-]+@([a-zA-Z0-9.-]+\.)+[a-zA-Z0-9.-]{2,4}$/;
         if(!regex.test(forma.email.value)){
            alert("<?=$a1?>");
            forma.email.focus();
            return false;
         }
      }
      function submitSearchForm(areaID){
         window.document.forms['searchByArea'].areaID.value = areaID;
         window.document.forms['searchByArea'].submit();
      }
      function openImg(roomID,wImg,hImg){
         if (typeof(winNew) == "object" && winNew != null ){
            winNew.close();
         }
         winNew = window.open('obm22/room_photo.php?roomID=' + roomID,'photo','scrollbars=no,status=no,width=' + wImg + ',height=' + hImg + ',top=0,left=0,menubar=no,titlebar=Photo Gallery');
      }

      function openAC(roomid,lang){
         if (roomid != ""){
            width=800;
            height=300;
         }else{
            width=500;
            height=450;
         }
         var checkin = new Date();
         checkin.setDate(checkin.getDate()+1);
         var checkout = new Date();
         checkout.setDate(checkout.getDate()+1);
         var selectedMonth = checkin.getMonth()+1;
         var selectedYear = checkin.getFullYear();
         var selectedMonthS = checkout.getMonth()+1;
         var selectedYearS = checkout.getFullYear();
         xPos = (screen.Width - width) / 2;
         yPos = (screen.Height - height) / 2;
         window.open('obm22/availabilitycalendar.php?id=<?= $id?>&roomid=' + roomid + '&month=' + selectedMonth + '&year=' + selectedYear + '&monthS=' + selectedMonthS + '&yearS=' + selectedYearS + '&ln=' + lang,'availabilitycalendar','scrollbars=yes,status=no,resizable=yes,width=' + width + ',height=' + height + ',top=' + yPos + ',left=' + xPos + ',menubar=no');
         return false;
      }
	  </script>
	<!-- JUDD -->
	<link rel="shortcut icon" href="http://www.akaza.net/favicon.ico" type="image/x-icon">
	<link rel="stylesheet" href="http://www.akaza.net/templates/akaza_template/css/template_css.css" type="text/css">
	<link rel="stylesheet" href="http://www.akaza.net/css/style.css" type="text/css"><!--- OBM stylesheet --->
	<!-- /JUDD -->
   <title><?=$title?></title>
</head>
<?php
	include_once ('layout/header.inc.php');
?>
<!-- /JUDD -->
				  <table class="page_default">
                  <tr>
                     <!--Left Column-->
                     <td width="100%" height="274" valign="top" align="center">

<?
   if ($typeSearch == "withAvailability"){
?>
                        <table border="0" width="97%" height="41" cellspacing="0" cellpadding="0" align="center">
                        <tr>
                           <td class="textBlue11"><b><a href="<?=$pageName?>?ln=<?=$ln?>"><font color="#000000" size="2" face="Arial Narrow"><?=$seeAllPropText?></font></a></b></td>
                        </tr>
                        </table>
<?
   }
?>
                        <table border="0" width="88%" cellpadding="2">
                        <tr>
                           <td width="100%" valign="top">
                              <table border="0" cellspacing="0" cellpadding="0" width="98%" align="center">
                              <tr>
                                 <td>
                                    <p style="margin-top: 5"><b><font size="3" color="#6B6A9B" face="Arial"><?=$pageTitle?></font></b>
                                    <p style="margin-top: 3; margin-bottom: 5"><font face="Arial" color="#000000" size="2"><?=$para1Text?></font></p>
									<p style="margin-top: 3; margin-bottom: 5"><font face="Arial" color="#000000" size="2"><a href="http://www.akaza.net/barcelona-and-its-neighbourhoods/">Information on neighbourhoods of Barcelona</a></font></p>
                                 </td>
                              </tr>
                              </table>
                           </td>
                        </tr>
                        <tr>
                           <td width="100%">
 
                              <!---------- START SEARCH FORM CODE ----------------->
                              <form name="checka" action="<?=$pageName?>" method="post" onSubmit="return verifica()">
                              <input type="hidden" name="ln" value="<?=$ln?>" >
                              <input type="hidden" name="refid" value="<?=$refid?>">
                              <input type="hidden" name="showOnlyAvailable" value="yes">
                              <input type="hidden" name="rooms" value="1">
                              <input type="hidden" name="searchNew" value="yes">
                              <input type="hidden" name="promoCode" value="">
                              <input type="hidden" name="typeSearch" value="withAvailability">


                              <table border="0" cellspacing="0" cellpadding="0" style="border:1px solid;border-right:2px solid" width="98%" bordercolor="#B2B3C8" align="center" bgcolor="#E2E2E2">
                              <tr>
                                 <td class="textBlueBold12" colspan="4" height="30">&nbsp;&nbsp;&nbsp;<?=$checkAvailPrices?></b></td>
                              </tr>
                              <tr>
                                 <td class="textSpace5" colspan="4" height="1" bgcolor="#B2B3C8"><img src="images/1x1negro.gif"></td>
                              </tr>

<?
   if (count($arrAreas) != 0){
?>
                              <tr>
                                 <td class="textBlueBold11" height="30" colspan="4">&nbsp;&nbsp;&nbsp;<?=$searchAreaText?>:</td>
                              </tr>
                              <tr>
                                 <td colspan="4">
                                    <table cellpadding="0" cellspacing="0" width="90%" align="center" border="0">
                                    <tr>
<?
      $perColumn = 4;
      $widthColumn = 100 / $perColumn;
      $i = 0;
      foreach ($arrAreas as $k => $v){
         $i++;
         $checkArea = "";
         if ($v[0] == $areaID){
            $checkArea = "checked";
         }

?>
                                       <td width="<?=$widthColumn?>%" class="textBlue11"><input type="radio" name="areaID" id="areaID[<?=$v[0]?>]" value="<?=$v[0]?>" <?=$checkArea?>>&nbsp;<?=$v[1]?></td>
<?
         if (($i == $numResAreas) and ($i % $perColumn != 0)){

            //$colspanValue = ($perColumn - $i % $perColumn) + 1;
            $startJ = $numResAreas;
            $stopJ = $perColumn - ($i % $perColumn);
            for ($j = 1; $j <= $stopJ; $j++){

?>
                                       <td width="<?=$widthColumn?>%" class="textBlue11">&nbsp;</td>
<?
            }
         }


         if ((($i % $perColumn) == 0) and ($i != $numResAreas)){
?>
                                    </tr>
                                    <tr>
<?
         }
      }
?>
                                    </tr>
                                    </table>
                                 </td>
                              </tr>
                              <tr>
                                 <td colspan="4" height="1" bgcolor="#B2B3C8"><img src="images/1x1negro.gif"></td>
                              </tr>
<?
   }
?>
                              <tr>
                                 <td class="textBlueBold11" height="30" align="right" width="15%"><?=$arrivalText?>:</td>
                                 <td>
                                    &nbsp;
                                    <select name="daysI" class="textblue11" onchange="adjustDate( this.form.monthsI, this, this.form.yearI )">
<?
   for($i = 1; $i <= 31; $i++) {
      if ($i == $daysI){
?>
                                       <option value="<?= $i?>" selected><?= $i?></option>
<?

      }else{
?>
                                       <option value="<?= $i?>"><?= $i?></option>
<?
      }
   }
?>
                                    </select>
                                    <select name="monthsI" class="textblue11" onchange="adjustDate( this, this.form.daysI, this.form.yearI )">
<?
   for($i = 1;  $i< count($arrayMonth); $i++) {
      if ($i == $monthsI){
?>
                                       <option value="<?= $i?>" selected><?= $arrayMonth[$i]?></option>
<?
      }else{
?>
                                       <option value="<?= $i?>"><?= $arrayMonth[$i]?></option>
<?
      }
   }
?>
                                    </select>
                                    <select name="yearI" class="textblue11" onchange="adjustDate( this.form.monthsI, this.form.daysI, this )">
<?
   for($i=$currentYear;$i < $currentYear + 4;$i++){
      if ($i == $yearI){
?>
                                       <option value="<?= $i?>" selected><?= $i?></option>
<?
      }else{
?>
                                       <option value="<?= $i?>"><?= $i?></option>
<?
      }
   }
?>
                                    </select>
                                 </td>
                                 <td class="textBlueBold11" height="30" align="right"><?=$guestsText?>:</td>
                                 <td>
                                    &nbsp;
                                    <select name="guests" class="textblue11" style="width:100">
<?
   for ($i = 1; $i <= 8; $i++){
      if ($i == $guests){
?>
                                       <option value="<?=$i?>" selected><?=$i?></option>
<?
      }else{
?>
                                       <option value="<?=$i?>"><?=$i?></option>
<?
      }
   }
?>
                                    </select>
                                 </td>

                              </tr>
                              <tr>
                                 <td class="textBlueBold11" height="30" align="right"><?=$departureText?>:</td>
                                 <td>
                                    &nbsp;
                                    <select name="daysS" class="textblue11" onchange="adjustDate( this.form.monthsS, this, this.form.yearS )">
<?
   for($i = 1; $i <= 31; $i++) {
      if ($i == $daysS){
?>
                                       <option value="<?= $i?>" selected><?= $i?></option>
<?
      }else{
?>
                                       <option value="<?= $i?>"><?= $i?></option>
<?
      }
   }
?>
                                    </select>
                                    <select name="monthsS" class="textblue11" onchange="adjustDate( this, this.form.daysS, this.form.yearS )">
<?
   for($i = 1;  $i< count($arrayMonth); $i++) {
      if ($i == $monthsS){
?>
                                       <option value="<?= $i?>" selected><?= $arrayMonth[$i]?></option>
<?
      }else{
?>
                                       <option value="<?= $i?>"><?= $arrayMonth[$i]?></option>
<?
      }
   }
?>
                                    </select>
                                    <select name="yearS" class="textblue11" onchange="adjustDate( this.form.monthsS, this.form.daysS, this )">
<?
   for($i=$currentYear;$i < $currentYear + 4;$i++){
      if ($i == $yearS){
?>
                                       <option value="<?= $i?>" selected><?= $i?></option>
<?
      }else{
?>
                                       <option value="<?= $i?>"><?= $i?></option>
<?
      }
   }
?>
                                    </select>
                                 </td>
                                 <td class="textBlueBold11" height="30" align="right"><?=$txtRental?>:</td>
                                 <td >
                                    &nbsp;
                                    <select name="shortTerm" class="textblue11"  style="width:100">
<?
   foreach($arrShortTerm as $k => $v) {
      if ($k == $shortTerm){
?>
                                       <option value="<?= $k?>" selected><?= $v?></option>
<?
      }else{
?>
                                       <option value="<?= $k?>"><?= $v?></option>
<?
      }
   }
?>
                                    </select>
                                 </td>
                              </tr>
                              <tr>
                                 <td colspan="2">&nbsp;</td>
                                 <td class="textBlueBold11" height="30" align="center" colspan="2">&nbsp;<input type="Submit" name="Submit" value="<?=$checkAvailText?>" class="classButton2"></td>
                              </tr>
                              <tr>
                                 <td colspan="4" height="1" bgcolor="#B2B3C8"><img src="images/1x1negro.gif"></td>
                              </tr>
                              </table>
                              </form>
                              <!---------- END SEARCH FORM CODE ----------------->
<?
   $numberOfUsers = count($arrPropID);
   $numberOfPages = 1 + floor(($numberOfUsers -1 )/$perPage);
   if ($page > $numberOfPages){
      $page = $numberOfPages;
   }

   $nextPage =  $page + 1;
   $previousPage = $page - 1;

   $start = ($page - 1) * $perPage;
   if ($page == $numberOfPages OR $numberOfUsers == 0) {
      $end = $page * $perPage - ($page * $perPage - $numberOfUsers)  ;
   } else {
      $end = $page * $perPage;
   }
?>
                              <!---------- START PAGINATION CODE ----------------->
                              <table width="98%" align="center" cellspacing="0" cellpadding="0" bordercolor="#8CBE00">
                              <tr bgcolor="#FFE4B9">
                                 <td width="20%" class="textBlue11"><?=$resPage?>:</td>
                                 <td align="center" class="textBlue11"><?=getPagesString()?></td>
                                 <td width="20%" class="textBlue11" align="right">[ <?= $start+1 ?> - <?= $end?> <?=$of?> <?= $numberOfUsers?> <?=$rec?> ]</td>
                              </tr>
                              <tr>
                                 <td class="textSpace5" colspan="2"><br><br></td>
                              </tr>
                              </table>
                              <!---------- END PAGINATION CODE ----------------->
                              <!---------- START RESULTS CODE ----------------->

<?
   if (count($arrPropID) == 0){//room types not defined in administration panel
      echo getHtmlNoRoomsDefined();
   }else{//room types defined in administration panel


      $arrDispPropID = array_slice($arrPropID,$start,$perPage);


      foreach ($arrDispPropID as $k => $v){ 

         $typeRoom = $v;
         $countRommsFac ++;
         $propPhoto = "<img src=\"images/not_available.gif\" width=\"150\" height=\"100\" align=\"left\" style=\"border:1px solid;border-color:#FFFFFF\">";
         $query = "select TypeRoom,Guests,Description,Photo,AreaID,Map,Size,Bedrooms,Bethrooms,MonthlyFee from room where RoomID='$typeRoom'";
         $res1 = dataQuery($query);
         $row1 = mysql_fetch_array($res1);
         $lnRoomType = $row1[TypeRoom];
	  //JUDD
		$prop_url = generateURL($ln, $lnRoomType);
	  //End JUDD
		 
		 $lnDescription = $row1[Description];
         if ($ln <> 'en'){
            $sql = "select RoomType,Description from translaterooms where RoomID=$typeRoom and Language='$ln'";
            $resrn = dataQuery($sql);
            $rowrn = mysql_fetch_array($resrn);
            if (trim($rowrn[RoomType]) <> "" and $rowrn[RoomType] <> "NULL"){
               $lnRoomType = $rowrn[RoomType];
            }
            if (trim($rowrn[Description]) <> "" and $rowrn[Description] <> "NULL"){
               $lnDescription = $rowrn[Description];
            }
         }


         /*$mapLink = "<a href=\"JavaScript:void(openMap('images/admin/maps/map_not_available.gif','150','150'))\" class=\"linkBlue11\">$mapText</a>";
         if ((trim($row1[Map]) != "") and (is_file("obm22/images/admin/maps/$typeRoom/$row1[Map]"))){
            $sizeMap = GetImageSize("obm22/images/admin/maps/$typeRoom/$row1[Map]");
            $mapW = $sizeMap[0];
            $mapH = $sizeMap[1] + 50;
            $mapLink = "<a href=\"JavaScript:void(openMap('images/admin/maps/$typeRoom/$row1[Map]','$mapW','$mapH'))\" class=\"linkBlue11\">$mapText</a>";
         }*/

            //$mapLink = "<a href=\"JavaScript:void(openmappopup('maps.php'))\" class=\"linkBlue11\">$mapText</a>";
			$mapLink = "<FORM><input type=\"hidden\" name=\"propID\" value=\"$typeRoom\" method=\"POST\"><input TYPE=\"button\" onClick=\"openmappopup('maps.php?propID=$typeRoom')\" value=\"$mapText\"></FORM>";

         $photoLink = "";
         $arrPhotos = array();
         if (is_dir("obm22/images/admin/rooms/$typeRoom")){
            $handle = opendir("obm22/images/admin/rooms/$typeRoom");
            while (false !== ($file = readdir($handle))) {
               if ($file != "." && $file != "..") {
                  $arrPhotos[count($arrPhotos)] = "$file";
               }
            }
            closedir($handle);
         }
         sort ($arrPhotos);
         reset ($arrPhotos);

         if (count($arrPhotos) != 0){
            foreach ($arrPhotos as $k => $v){
               $sizeImg = GetImageSize("obm22/images/admin/rooms/$typeRoom/$v");
               $photoW = $sizeImg[0];
               $photoH = $sizeImg[1] + 120;
               $propPhoto = "<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/admin/rooms/$typeRoom/$v\" width=\"150\" height=\"100\" align=\"left\" style=\"border:1px solid;border-color:#FFFFFF\"></a>";
               break;
            }
            $photoLink = "&nbsp;[$morePhotoText&nbsp;&nbsp;<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/client/photo.gif\" width=\"17\" height=\"12\" border=\"0\" alt=\"$viewImgT\"></a>]";
         }

         $errCode = $arrPropErrCode[$typeRoom];
         $errValue = $arrPropErrValue[$typeRoom];
         $totalPrice = $arrPropRate[$typeRoom];
?>
                              <table width="100%" cellspacing="0" cellpadding="0" border="0">
                              <tr>
                                 <td>
                                    <table width="100%" cellspacing="0" cellpadding="0" border="0">
                                    <tr>
                                       <td>
                                          <table cellspacing="0" cellpadding="0" border="0" bgcolor="#FFF9F2" align="center" width="98%">
                                          <tr>
                                             <td>
                                                <table cellspacing="0" cellpadding="0" border="0" align="center" width="100%">
                                                <tr>
                                                   <td valign="top" width="4"><img src="obm22/images/client/colt_ss.gif" width="4" height="4"></td>
                                                   <td height="4" valign="top" width="100%">
                                                      <table cellspacing="0" cellpadding="0" border="0" width="100%">
                                                      <tr>
                                                         <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                                      </tr>
                                                      <tr>
                                                         <td height="3"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                                      </tr>
                                                      </table>
                                                   </td>
                                                   <td width="4"><img src="obm22/images/client/colt_ds.gif" width="4" height="4"></td>
                                                </tr>
                                                </table>
                                             </td>
                                          </tr>
                                          <tr>
                                             <td>
                                                <table width="100%" cellpadding="0" cellspacing="0" bgcolor="#FFF9F2">
                                                <tr>
                                                   <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                                   <td width="100%" class="text003399_11">
                                                      <table width="100%" cellpadding="0" cellspacing="0">
                                                      <tr>
                                                         <td class="textblue11" bgcolor="#FFF9F2" height="30"> &nbsp;<?=$roomTT?>:&nbsp;<b><?= $lnRoomType?></b></td>
                                                         <td class="textblue11" bgcolor="#FFF9F2" align="right"><a href="JavaScript:void(openAC('<?=$typeRoom?>', '<?=$ln?>'))" class="linkBlue11"><?=$checkAvailText?></a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="<?php echo $prop_url?>" class="linkBlue11"><?=$moreInfoText?></a>&nbsp;&nbsp;</td>
                                                      </tr>
                                                      <tr>
                                                         <td height="1" bgcolor="#6E86AC" colspan="2"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                                      </tr>
                                                      <tr>
                                                         <td class="textSpace3" colspan="2">&nbsp;</td>
                                                      </tr>
                                                      <tr>
                                                         <td colspan="2">
                                                            <table width="100%" cellpadding="0" cellspacing="0">
                                                            <tr>
                                                               <td width="150" align="left"><?=$propPhoto?></td>
                                                               <td valign="top" bgColor="#F6F6F6">
                                                                  <table width="100%" cellpadding="0" cellspacing="0">
                                                                  <tr>
                                                                     <td width="62%">
                                                                        <table cellpadding="2" cellspacing="1" width="97%" align="center" bgcolor="#FFFFFF">
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td width="40%" class="textBlue11"><?=$areaText?>:</td>
                                                                           <td  class="textBlue11"><?=$arrAreasSave[$row1[AreaID]]?></td>
                                                                        </tr>
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td class="textBlue11"><?=$sizeText?>:</td>
                                                                           <td class="textBlue11"><?=$row1[Size]?></td>
                                                                        </tr>
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td class="textBlue11"><?=$bedroomsText?>:</td>
                                                                           <td class="textBlue11"><?=$row1[Bedrooms]?></td>
                                                                        </tr>
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td class="textBlue11"><?=$bathroomsText?>:</td>
                                                                           <td class="textBlue11"><?=$row1[Bethrooms]?></td>
                                                                        </tr>
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td class="textBlue11"><?=$guestsText?>:</td>
                                                                           <td class="textBlue11"><?=$row1[Guests]?></td>
                                                                        </tr> 
<?
            if ($row1['MonthlyFee'] != ""){ 
?>                                                                        
                                                                        <tr bgColor="#F6F6F6">
                                                                           <td class="textBlue11"><?=$txtMonthlyFee?>:</td>
                                                                           <td class="textBlue11"><?=$row1['MonthlyFee']?></td>
                                                                        </tr>
<?
            }
?>                                                                        
                                                                        
                                                                        
                                                                        </table>
                                                                     </td>
                                                                     <td class="textBlue11">
<?
            if ($typeSearch == "withAvailability"){
?>
                                                                        <form action="obm22/checkavailR.php" method="post" name="bookIt_<?= $typeRoom?>">
                                                                        <input type="hidden" name="ln" id="ln" value="<?=$ln?>">
                                                                        <input type="hidden" name="id" id="id" value="<?= $id?>">
                                                                        <input type="hidden" name="typeRoom" id="typeRoom" value="<?= $typeRoom?>">
                                                                        <input type="hidden" name="strResArchive" value="<?= base64_encode($strResArchive)?>">
                                                                        <input type="hidden" name="rooms" value="1">
                                                                        <input type="hidden" name="daysI" value="<?=$daysI?>">
                                                                        <input type="hidden" name="monthsI" value="<?=$monthsI?>">
                                                                        <input type="hidden" name="yearI" value="<?=$yearI?>">
                                                                        <input type="hidden" name="daysS" value="<?=$daysS?>">
                                                                        <input type="hidden" name="monthsS" value="<?=$monthsS?>">
                                                                        <input type="hidden" name="yearS" value="<?=$yearS?>">
                                                                        <input type="hidden" name="guests" value="<?=$guests?>">
                                                                        <input type="hidden" name="promoCode" value="<?=$promoCode?>">
                                                                        <table cellpadding="0" cellspacing="0" align="center">
                                                                        <tr>
                                                                           <td class="textred14" align="center"><?=$priceStayText?></td>
                                                                        </tr>
                                                                        <tr>
                                                                           <td class="textSpace5" align="center">&nbsp;</td>
                                                                        </tr>
                                                                        <tr>
                                                                           <td class="textred16" align="center"><b><?=$totalPrice?> <?=$cur?></b></td>
                                                                        </tr>
                                                                        <tr>
                                                                           <td class="textSpace5" align="center">&nbsp;</td>
                                                                        </tr>

                                                                        <tr>
                                                                           <td align="center"><input type="submit" class="classButton2" style="width:<?= $bookButtonWidth ?> px" value="<?= $bookButtonText?>"></td>
                                                                        </tr>
                                                                        </table>
                                                                        </form>
<?
            }else{
?>
                                                                        <form action="obm22/checkavail.php" method="post" name="checkAvail_<?= $typeRoom?>">
                                                                        <input type="hidden" name="ln" id="ln" value="<?=$ln?>">
                                                                        <input type="hidden" name="id" id="id" value="<?= $id?>">
                                                                        <input type="hidden" name="roomID" id="roomID" value="<?= $typeRoom?>">
                                                                        <input type="hidden" name="strResArchive" value="<?= base64_encode($strResArchive)?>">
                                                                        <table cellpadding="0" cellspacing="0" align="center">
                                                                        <tr>
                                                                           <td align="center"><input type="submit" class="classButton2" style="width:<?= $bookButtonWidth ?> px" value="<?= $bookButtonText?>"></td>
                                                                        </tr>
                                                                        </table>
                                                                        </form>
<?
            }
?>
                                                                     </td>
                                                                  </tr>
                                                                  </table>
                                                               </td>
                                                            </tr>
                                                            <tr>
                                                               <td class="textBlue11" align="center" valign="top">
<?
            if (count($arrPhotos) > 1){
?>
                                                                  <a href="JavaScript:void(openImg('<?=$typeRoom?>','<?=$photoW?>','<?=$photoH?>'))" class="linkB81315_11"><?=$morePhotoText?></a><br>
<?
            }
?>
																<br><br><?php echo $mapLink ?>
                                                               </td>
                                                               <td>
                                                                  <table cellpadding="2" cellspacing="1" width="99%" align="center">
                                                                  <tr>
                                                                     <td class="textBlue11"><?=substr($lnDescription,0,200)?> <a href="<?php echo $prop_url?>" class="linkBlue11">[...]</a></td>
                                                                  </tr>
<?
            $queryFac = "SELECT f.FacilityID, f.Name from facilities f, facilitiestorooms fr where fr.RoomID='$typeRoom' and fr.FacilityID=f.FacilityID and f.HotelID='$id' order by f.Name";
            $resultFac = dataQuery($queryFac);
            $a = array();
            while ($rowFac = mysql_fetch_array($resultFac)){
               $tmpFacName = $rowFac[Name];
               if ($ln != "en"){
                  $queryFacTrans = "SELECT Name from translatefacilities where FacilityID='$rowFac[FacilityID]' and HotelID='$id' and Language='$ln'";
                  $resultFacTrans = dataQuery($queryFacTrans);
                  $rowFacTrans = mysql_fetch_array($resultFacTrans);
                  if ($rowFacTrans[Name] != ""){
                     $tmpFacName = $rowFacTrans[Name];
                  }
               }
               $a[count($a)] = $tmpFacName;
            }
            $showFacilities = join(", ",$a);
            //de tradus

?>
                                                                  <tr>
                                                                     <td class="textBlue11"><b><?=$fac?></b>: &nbsp;<?=$showFacilities?></td>
                                                                  </tr>
                                                                  </table>
                                                               </td>
                                                            </tr>
                                                            </table>
                                                         </td>
                                                      </tr>
                                                      </table>


<?
         //}
?>


                                                   </td>
                                                   <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                                </tr>
                                                </table>
                                             </td>
                                          </tr>
                                          <tr>
                                             <td colspan="3" height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                                          </tr>
                                          </table>
                                       </td>
                                    </tr>
                                    </table>
                                    <span Class="textSpace5"><br><br></span>
                                 </td>
                              </tr>
                              </table>
<?


            //}//end if facilities are OK
      }//end while room types
      if ($countRommsFac == 0){
         echo getHtmlNoFacilities();
      }
      if (count($arrPropID) == 0){
         echo getHtmlNoFacilities();
      }
      //}//room types not defined in administration panel for the guest number
   }//end else : room types defined in administration panel
//}
?>
                              <!---------- END RESULTS CODE ----------------->
                              <!---------- START PAGINATION CODE ----------------->
                              <table width="98%" align="center" cellspacing="0" cellpadding="0" bordercolor="#8CBE00">
                              <tr bgcolor="#FFE4B9">
                                 <td width="20%" class="textBlue11"><?=$resPage?>:</td>
                                 <td align="center" class="textBlue11"><?=getPagesString()?></td>
                                 <td width="20%" class="textBlue11" align="right">[ <?= $start+1 ?> - <?= $end?> <?=$of?> <?= $numberOfUsers?> <?=$rec?> ]</td>
                              </tr>
                              <tr>
                                 <td class="textSpace5" colspan="2"><br><br></td>
                              </tr>
                              </table>
                              <br><br>
                              <!---------- END PAGINATION CODE ----------------->
                           </td>
                        </tr>
                        </table>
                     </td>
                  </tr>
                  </table>
               </td>
            </tr>
            </table>

<!-- JUDD -->
<?php
	include_once ('layout/footer.inc.php');
?>
<!-- /JUDD -->

<?php
//Holy crap, why can't they put these into an include file?!?!?
function getHtml30days(){
   global $msgFT1;
   $html30days = "";
   $html30days = <<<EOT
     <br>
     <table align="center" width="97%" cellspacing="1" cellpadding="0" bgcolor="red">
     <tr>
        <td class="text">
          <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff">
           <tr>
              <td class="textred_11" align="center">$msgFT1</td>
            </tr>
            </table>
        </td>
     </tr>
     </table>
     <br>
EOT;
 return $html30days;
}

function getHtmlErrStay($str){
global $ln,$id,$typeRoom,$dateI,$dateS,$guests,$rooms,$roomTT,$lnRoomType,$lnDescription,$fac,
       $hotelpropT,$trynewcritButtonWidth,$trynewcritButtonText,$checkavailability,$wcabutton;;

   $propPhoto = "";
   $photoLink = "";
   $arrPhotos = array();
   if (is_dir("obm22/images/admin/rooms/$typeRoom")){
      $handle = opendir("obm22/images/admin/rooms/$typeRoom");
      while (false !== ($file = readdir($handle))) {
         if ($file != "." && $file != "..") {
            $arrPhotos[count($arrPhotos)] = "$file";
         }
      }
      closedir($handle);
   }
   sort ($arrPhotos);
   reset ($arrPhotos);

   if (count($arrPhotos) != 0){
      foreach ($arrPhotos as $k => $v){
         $sizeImg = GetImageSize("obm22/images/admin/rooms/$typeRoom/$v");
         $photoW = $sizeImg[0];
         $photoH = $sizeImg[1] + 120;
         $propPhoto = "<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/admin/rooms/$typeRoom/$v\" width=\"150\" height=\"100\" align=\"left\" style=\"border:1px solid\"></a>";
         break;
      }
      $photoLink = "&nbsp;click here for more photos&nbsp;&nbsp;<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/client/photo.gif\" width=\"17\" height=\"12\" border=\"0\" alt=\"$viewImgT\"></a>";
   }


     $htmlErrStay = "";
     $htmlErrStay = <<<EOT
        <table bgcolor="#ffffff" width="100%" cellspacing="0" cellpadding="0" border="0">
        <tr>
           <td>
              <form action="checkavail.php" method="post">
                 <input type="hidden" name="ln" id="ln" value="$ln">
                 <input type="hidden" name="id" id="id" value="$id">
              <table cellspacing="0" cellpadding="0" border="0" bgcolor="#FFF9F2" align="center" width="98%">
              <tr>
                 <td>
                    <table cellspacing="0" cellpadding="0" border="0" align="center" width="100%">
                    <tr>
                       <td valign="top" width="4"><img src="obm22/images/client/colt_ss.gif" width="4" height="4"></td>
                       <td height="4" valign="top" width="100%">
                          <table cellspacing="0" cellpadding="0" border="0" width="100%">
                          <tr>
                             <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          <tr>
                             <td height="3"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          </table>
                       </td>
                       <td width="4"><img src="obm22/images/client/colt_ds.gif" width="4" height="4"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td>
                    <table width="100%" cellpadding="0" cellspacing="0" bgcolor="#FFF9F2">
                    <tr>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                       <td width="100%" class="text003399_11">
                          <table align="center" width="100%" cellspacing="1" cellpadding="0" border="0">
                          <tr>
                             <td class="textblue11" bgcolor="#FFF9F2"> &nbsp;$roomTT:&nbsp;<b>$lnRoomType</b>&nbsp;&nbsp;$photoLink</td>
                             <td align="right" bgcolor="#FFF9F2">
                                 <input type="button" class="classButton2" style="width:$wcabutton px" value="$checkavailability" onclick="void(openAC('$typeRoom'));">&nbsp;&nbsp;&nbsp;
                                 <input type="submit" class="classButton3" style="width:$trynewcritButtonWidth px" value="$trynewcritButtonText">
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="textblue11" bgcolor="#ffffff">$propPhoto$lnDescription</td>
                          </tr>
                          <tr>
                             <td class="textblue11" bgcolor="#ffffff" colspan="2">$fac:
EOT;

$query1 = "SELECT f.Name from facilities f, facilitiestorooms fr where fr.RoomID='$typeRoom' and fr.FacilityID=f.FacilityID and f.HotelID='$id' order by f.Name";
$result1 = dataQuery($query1);
$a = array();
while ($row1 = mysql_fetch_array($result1)){
     $a[count($a)] = $row1[Name];
}
$facilities = join(", ",$a);


$htmlErrStay .=<<<EOT
                                $facilities;
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="text"><br>
                                <table align="center" width="98%" cellspacing="1" cellpadding="0" bgcolor="red">
                                <tr>
                                   <td class="text">
                                      <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff">
                                      <tr>
                                         <td class="textred_11" align="center">$str</td>
                                      </tr>
                                      </table>
                                   </td>
                                </tr>
                                </table><br>
                            </td>
                          </tr>
                          </table>
                       </td>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td colspan="3" height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
              </tr>
              </table>
           </td>
           </form>
        </tr>
        </table>
EOT;
return $htmlErrStay;
}

function getHtmlNoRoomsForNoAdults(){
   global $noRooms,$guests,$adultsT,$id,$ln,$trynewcritButtonWidth,$trynewcritButtonText;


   $htmlNoRoomsForNoAdults = "";
   $htmlNoRoomsForNoAdults = <<<EOT
     <br>
     <table align="center" width="98%" cellspacing="1" cellpadding="0" bgcolor="red">
     <form action="checkavail.php" method="post">
     <input type="hidden" name="ln" id="ln" value="$ln">
     <input type="hidden" name="id" id="id" value="$id">
     <tr>
        <td class="text">
          <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff" valign="top">
           <tr>
              <td class="textred_11" align="center" valign="top">$noRooms $guests $adultsT&nbsp;&nbsp;
                   <input type="submit" class="classButton3" style="width:$trynewcritButtonWidth px" value="$trynewcritButtonText">
              </td>
            </tr>
            </table>
        </td>
     </tr>
     </form>
     </table>
     <br>
EOT;
 return $htmlNoRoomsForNoAdults;
}

function getHtmlJustRooms($nr){
  global $ln,$id,$typeRoom,$dateI,$dateS,$guests,$rooms,$roomTT,$lnRoomType,
          $lnDescription,$fac,$hotelpropT,$msgFT2,$trynewcritButtonWidth,$trynewcritButtonText;

   $propPhoto = "";
   $photoLink = "";
   $arrPhotos = array();
   if (is_dir("obm22/images/admin/rooms/$typeRoom")){
      $handle = opendir("obm22/images/admin/rooms/$typeRoom");
      while (false !== ($file = readdir($handle))) {
         if ($file != "." && $file != "..") {
            $arrPhotos[count($arrPhotos)] = "$file";
         }
      }
      closedir($handle);
   }
   sort ($arrPhotos);
   reset ($arrPhotos);

   if (count($arrPhotos) != 0){
      foreach ($arrPhotos as $k => $v){
         $sizeImg = GetImageSize("obm22/images/admin/rooms/$typeRoom/$v");
         $photoW = $sizeImg[0];
         $photoH = $sizeImg[1] + 120;
         $propPhoto = "<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/admin/rooms/$typeRoom/$v\" width=\"150\" height=\"100\" align=\"left\" style=\"border:1px solid\"></a>";
         break;
      }
      $photoLink = "&nbsp;click here for more photos&nbsp;&nbsp;<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/client/photo.gif\" width=\"17\" height=\"12\" border=\"0\" alt=\"$viewImgT\"></a>";
   }


   $htmlJustRooms = "";
   $getmsgFT2 =  getmsgFT2($nr);
   $htmlJustRooms =<<<EOT
        <table bgcolor="#ffffff" width="100%" cellspacing="0" cellpadding="0" border="0">
        <tr>
           <td>
              <form action="checkavail.php" method="post">
                 <input type="hidden" name="ln" id="ln" value="$ln">
                 <input type="hidden" name="id" id="id" value="$id">
              <table cellspacing="0" cellpadding="0" border="0" bgcolor="#FFF9F2" align="center" width="98%">
              <tr>
                 <td>
                    <table cellspacing="0" cellpadding="0" border="0" align="center" width="100%">
                    <tr>
                       <td valign="top" width="4"><img src="obm22/images/client/colt_ss.gif" width="4" height="4"></td>
                       <td height="4" valign="top" width="100%">
                          <table cellspacing="0" cellpadding="0" border="0" width="100%">
                          <tr>
                             <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          <tr>
                             <td height="3"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          </table>
                       </td>
                       <td width="4"><img src="obm22/images/client/colt_ds.gif" width="4" height="4"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td>
                    <table width="100%" cellpadding="0" cellspacing="0" bgcolor="#FFF9F2">
                    <tr>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                       <td width="100%" class="text003399_11">
                          <table align="center" width="100%" cellspacing="1" cellpadding="0" border="0">
                          <tr>
                             <td class="textblue11" bgcolor="#FFF9F2"> &nbsp;$roomTT:&nbsp;<b>$lnRoomType</b>&nbsp;&nbsp;$photoLink</td>
                             <td align="right" bgcolor="#FFF9F2">
                                                       <input type="submit" class="classButton3" style="width:$trynewcritButtonWidth px" value="$trynewcritButtonText">
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="textblue11" bgcolor="#ffffff">$propPhoto$lnDescription</td>
                          </tr>
                          <tr>
                             <td class="textblue11" bgcolor="#ffffff" colspan="2">$fac:
EOT;

$query1 = "SELECT f.Name from facilities f, facilitiestorooms fr where fr.RoomID='$typeRoom' and fr.FacilityID=f.FacilityID and f.HotelID='$id' order by f.Name";
$result1 = dataQuery($query1);
$a = array();
while ($row1 = mysql_fetch_array($result1)){
     $a[count($a)] = $row1[Name];
}
$facilities = join(", ",$a);


$htmlJustRooms .=<<<EOT
                                $facilities;
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="text"><br>
                               <table align="center" width="97%" cellspacing="1" cellpadding="0" bgcolor="red">
                               <tr>
                                  <td>
                                    <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff">
                                     <tr>
                                        <td class="textred_11" align="center">$getmsgFT2 </td>
                                      </tr>
                                      </table>
                                  </td>
                               </tr>
                               </table><br>
                             </td>
                          </tr>
                          </table>
                       </td>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td colspan="3" height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
              </tr>
              </table>
           </td>
           </form>
        </tr>
        </table>
EOT;
return $htmlJustRooms;
}

function getHtmlNoRoomsDefined(){
   global $noRoomsDefined;
   $htmlNoRooms = "";
   $htmlNoRooms =<<<EOT
     <br>
     <table align="center" width="100%" cellspacing="1" cellpadding="0" bgcolor="red">
     <tr>
        <td class="text">
          <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff">
           <tr>
              <td class="textred_11" align="center">$noRoomsDefined</td>
            </tr>
            </table>
        </td>
     </tr>
     </table>
     <br>
EOT;
return $htmlNoRooms;
}

function getHtmlNoRooms(){
   global $ln,$id,$typeRoom,$dateI,$dateS,$guests,$rooms,$roomTT,$lnRoomType,
          $lnDescription,$fac,$hotelpropT,$msgFT3,$trynewcritButtonWidth,$trynewcritButtonText;

   $propPhoto = "";
   $photoLink = "";
   $arrPhotos = array();
   if (is_dir("obm22/images/admin/rooms/$typeRoom")){
      $handle = opendir("obm22/images/admin/rooms/$typeRoom");
      while (false !== ($file = readdir($handle))) {
         if ($file != "." && $file != "..") {
            $arrPhotos[count($arrPhotos)] = "$file";
         }
      }
      closedir($handle);
   }
   sort ($arrPhotos);
   reset ($arrPhotos);

   if (count($arrPhotos) != 0){
      foreach ($arrPhotos as $k => $v){
         $sizeImg = GetImageSize("obm22/images/admin/rooms/$typeRoom/$v");
         $photoW = $sizeImg[0];
         $photoH = $sizeImg[1] + 120;
         $propPhoto = "<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/admin/rooms/$typeRoom/$v\" width=\"150\" height=\"100\" align=\"left\" style=\"border:1px solid\"></a>";
         break;
      }
      $photoLink = "&nbsp;click here for more photos&nbsp;&nbsp;<a href=\"JavaScript:void(openImg('$typeRoom','$photoW','$photoH'))\"><img src=\"obm22/images/client/photo.gif\" width=\"17\" height=\"12\" border=\"0\" alt=\"$viewImgT\"></a>";
   }

   $htmlNoRooms = "";
   $htmlNoRooms =<<<EOT
        <table bgcolor="#ffffff" width="100%" cellspacing="0" cellpadding="0" border="0">
        <tr>
           <td>
              <form action="checkavail.php" method="post">
                 <input type="hidden" name="ln" id="ln" value="$ln">
                 <input type="hidden" name="id" id="id" value="$id">
              <table cellspacing="0" cellpadding="0" border="0" bgcolor="#FFF9F2" align="center" width="98%">
              <tr>
                 <td>
                    <table cellspacing="0" cellpadding="0" border="0" align="center" width="100%">
                    <tr>
                       <td valign="top" width="4"><img src="obm22/images/client/colt_ss.gif" width="4" height="4"></td>
                       <td height="4" valign="top" width="100%">
                          <table cellspacing="0" cellpadding="0" border="0" width="100%">
                          <tr>
                             <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          <tr>
                             <td height="3"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                          </tr>
                          </table>
                       </td>
                       <td width="4"><img src="obm22/images/client/colt_ds.gif" width="4" height="4"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td>
                    <table width="100%" cellpadding="0" cellspacing="0" bgcolor="#FFF9F2">
                    <tr>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                       <td width="100%" class="text003399_11">
                          <table align="center" width="100%" cellspacing="1" cellpadding="0" border="0">
                          <tr>
                             <td class="textblue11" bgcolor="#FFF9F2"> &nbsp;$roomTT:&nbsp;<b>$lnRoomType</b>&nbsp;&nbsp;$photoLink</td>
                             <td align="right" bgcolor="#FFF9F2">
                                <input type="submit" class="classButton3" style="width:$trynewcritButtonWidth px" value="$trynewcritButtonText">
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="textblue11" bgcolor="#ffffff">$propPhoto$lnDescription</td>
                          </tr>
                          <tr>
                             <td class="textblue11" bgcolor="#ffffff" colspan="2">$fac:
EOT;

$query1 = "SELECT f.Name from facilities f, facilitiestorooms fr where fr.RoomID='$typeRoom' and fr.FacilityID=f.FacilityID and f.HotelID='$id' order by f.Name";
$result1 = dataQuery($query1);
$a = array();
while ($row1 = mysql_fetch_array($result1)){
     $a[count($a)] = $row1[Name];
}
$facilities = join(", ",$a);

$htmlNoRooms .=<<<EOT
                                $facilities;
                             </td>
                          </tr>
                          <tr>
                             <td colspan="2" class="text"><br>
                                <table align="center" width="97%" cellspacing="1" cellpadding="0" bgcolor="red">
                                <tr>
                                   <td>
                                      <table align="center" width="100%" cellspacing="0" cellpadding="2" border="0" bgcolor="#ffffff">
                                      <tr>
                                         <td class="textred_11" align="center">$msgFT3</td>
                                      </tr>
                                      </table>
                                   </td>
                                </tr>
                                </table><br>
                             </td>
                          </tr>
                          </table>
                       </td>
                       <td height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
                    </tr>
                    </table>
                 </td>
              </tr>
              <tr>
                 <td colspan="3" height="1" bgcolor="#6E86AC"><img src="obm22/images/client/pixelT.gif" width="1" height="1"></td>
              </tr>
              </table>
           </td>
           </form>
        </tr>
        </table>
EOT;
return $htmlNoRooms;
}

function getHtmlNoFacilities(){
   global $noFacilities;
   $htmlNoFacilities = "";
   $htmlNoFacilities =<<<EOT
     <br>
     <table align="center" width="100%" cellspacing="1" cellpadding="0" bgcolor="red">
     <tr>
        <td class="text">
          <table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff">
           <tr>
              <td class="textred_11" align="center">$noFacilities</td>
            </tr>
            </table>
        </td>
     </tr>
     </table>
     <br>
EOT;
return $htmlNoFacilities;
}


function getPagesString(){
     global $ln,
            $id,
            $areaID,
            $facilities,
            $page,
            $numberOfPages,
            $results,
            $perPage,
            $guests,
            $promoCode,
            $daysI,
            $monthsI,
            $yearI,
            $daysS,
            $monthsS,
            $yearS,
            $pageName,
            $showOnlyAvailable,
            $typeSearch;

     $searchNew = "no";
     $strFacilities = "";
     if (count($facilities) != 0){
         $arrKeysFac = array_keys($facilities);
         $strFacilities = join(",",$arrKeysFac);
     }
     $ret = "";
     $nextPage = $page + 1;
     $previousPage = $page - 1;
     if ($numberOfPages <= 10){
          for ($i=1; $i <= $numberOfPages; $i++){
              if ($i == $page){
                    $ret .= "<span class='textorange11'><b>[ $i ]</b></span>&nbsp;";
               }else{
                    $ret .= "[ <a class='link4B5765_3' href='$pageName?ln=$ln&page=$i&id=$id&searchNew=$searchNew&areaID=$areaID&strFacilities=$strFacilities&guests=$guests&promoCode=$promoCode&daysI=$daysI&monthsI=$monthsI&yearI=$yearI&daysS=$daysS&monthsS=$monthsS&yearS=$yearS&showOnlyAvailable=$showOnlyAvailable&typeSearch=$typeSearch'>$i</a> ]&nbsp;";
               }
          }
     }else{
          if ($page <> 1){
               $ret = "<b><a class='linkFF880011' href='$pageName?ln=$ln&page=1&id=$id&searchNew=$searchNew&areaID=$areaID&strFacilities=$strFacilities&guests=$guests&promoCode=$promoCode&daysI=$daysI&monthsI=$monthsI&yearI=$yearI&daysS=$daysS&monthsS=$monthsS&yearS=$yearS&showOnlyAvailable=$showOnlyAvailable&typeSearch=$typeSearch'> < </a>&nbsp;&nbsp;</b>&nbsp;";
          }
          if ($page + 10<= $numberOfPages){
               for ($i=$page; $i < $page+10; $i++){
                    if ($i == $page){
                         $ret .= "<span class='textorange11'><b>[ $i ]</b></span>&nbsp;";
                    }else{
                         $ret .= "[ <a class='link4B5765_3' href='$pageName?ln=$ln&page=$i&id=$id&searchNew=$searchNew&areaID=$areaID&strFacilities=$strFacilities&guests=$guests&promoCode=$promoCode&daysI=$daysI&monthsI=$monthsI&yearI=$yearI&daysS=$daysS&monthsS=$monthsS&yearS=$yearS&showOnlyAvailable=$showOnlyAvailable&typeSearch=$typeSearch'>$i</a> ]&nbsp;";
                    }
               }
               $ret .= "<b>&nbsp;&nbsp;<a class='linkFF880011' href='$pageName?ln=$ln&page=$nextPage&id=$id&searchNew=$searchNew&areaID=$areaID&strFacilities=$strFacilities&guests=$guests&promoCode=$promoCode&daysI=$daysI&monthsI=$monthsI&yearI=$yearI&daysS=$daysS&monthsS=$monthsS&yearS=$yearS&showOnlyAvailable=$showOnlyAvailable&typeSearch=$typeSearch'> >> </a></b>&nbsp;";
          }else{
               $li = $numberOfPages - 10;
               for ($i=$li; $i <= $numberOfPages; $i++){
                    if ($i == $page){
                         $ret .= "<span class='textorange11'><b>[ $i ]</b></span>&nbsp;";
                    }else{
                         $ret .= "[ <a class='link4B5765_3' href='$pageName?ln=$ln&page=$i&id=$id&searchNew=$searchNew&areaID=$areaID&strFacilities=$strFacilities&guests=$guests&promoCode=$promoCode&daysI=$daysI&monthsI=$monthsI&yearI=$yearI&daysS=$daysS&monthsS=$monthsS&yearS=$yearS&showOnlyAvailable=$showOnlyAvailable&typeSearch=$typeSearch'>$i</a> ]&nbsp;";
                    }
               }
          }
     }
     return $ret;
}
?>