PHP Code Help
Posted: Fri Apr 30, 2010 9:26 am
Hi I have the following code that returns only 1 type of room from a database (ie Twin), does anyone know how to adjust it to return all the room types available
(ie Double, Family, Twin) ?
(ie Double, Family, Twin) ?
Code: Select all
<?php
# Copyright 2009 e21Software.com Ltd. All Rights Reserved.
# The contents of this file may be modified but not sold, copied
# or reverse engineered. The contents may not be used on any
# website(s) or internet services other than those agreed in
# writing by authorised representatives of e21Software.com Ltd.
#$t3a=microtime_float();
if(!isset($fld['agtPwd'])){$fld=array();}
if(!isset($fld['Language'])){$fld['Language']=substr($Languages,0,3);}
$Query='';
foreach($_REQUEST as $key=>$data){
$ky=strtolower($key);
if($ky == 'id'){$key='Id';}
if($ky == 'l'){$key='Language';}
if($ky == 'b'){$key='Basis';}
if($ky == 'iu'){$key='InfoUnitNo';}
if($ky == 'ui'){$key='UnitID';}
if($ky == 'pn'){$key='PlaceNo';}
if($ky == 'dn'){$key='DevNo';}
if($ky == 'an'){$key='AccNo';}
if($ky == 'cr'){$key='Currency';}
if($ky == 'agt'){$key='AgencyCode';}
if($ky == 'ad'){$key='ArrivalDate';}
if($ky == 'nt'){$key='NumberNights';}
if($ky == 'a'){$key='Adults';}
if($ky == 'c'){$key='Children';}
if($ky == 's'){$key='Sort';}
# if($ky == 'ftr'){$key='PlaceCategories';}
if(!isset($_COOKIE[$key])){$fld[$key]=$data;}
}
foreach($fld as $key=>$data){if(strpos('Options,searchForm,Results,XQ,Type,Fields,Sort,',$key) === false){$Query.="$key=$data&";}}
if(isset($fld['agtPwd'])){$fld['head']='N';}else{$fld['head']='Y';}
if(!isset($fld['ArrivalDate'])){$Query.='Options=NOP&';}
if(isset($fld['PoolHeat'])){$fld['ftr'].='~PHeatS~PHeatE~HeatPool';}
if(isset($fld['AirCon'])){$fld['ftr'].='~AirCon~AirCn~AirConM~AirConL';}
if(isset($fld['ftr'])){$Query.="Categories=$fld[ftr]&";}
if(!isset($fld['allocOnly'])){$fld['allocOnly']='';}
if(!isset($fld['AgencyCode'])){$fld['AgencyCode']='';}
if(!isset($fld['Sort'])){$fld['Sort']='4';}
if(isset($fld['Nights'])){$fld['NumberNights']=$fld['Nights'];}
$Language=$fld['Language'];
if($fld['searchForm'] == ''){$fld['searchForm']=str_replace('/','',$fld['ArrivalDate'])."?$fld[NumberNights]?$fld[PlaceNo]?$fld[DevNo]?$fld[Adults]?$fld[Children]?$fld[Infants]?$fld[Babies]?$fld[Currency]?$fld[AgencyCode]?$fld[OfferCode]?$fld[Basis]?$fld[Country]?$fld[Region]?$fld[SubRegion]?";}
if(!isset($fld['XQ'])&&isset($fld['Results'])){$fld['XQ']=$fld['Results'];}
if(isset($fld['XQ'])){list($Results,$fld['searchForm'])=explode('__form',$fld['XQ']);$fld['head']='N';$Results=URLdecode($Results);}
$dtls=array();$sfrm=array();
list($sfrm['ad'],$sfrm['nt'],$sfrm['pn'],$sfrm['dn'],$sfrm['a'],$sfrm['c'],$sfrm['i'],$sfrm['b'],$sfrm['cur'],$sfrm['agt'],$sfrm['offer'],$sfrm['basis'],$sfrm['ctry'],$sfrm['rg'],$sfrm['sg'])=explode('?',$fld['searchForm']); # This is used to store the search criteria #
if(!isset($fld['ArrivalDate']) && isset($sfrm['ad'])){$fld['ArrivalDate']=substr($sfrm['ad'],0,2).'/'.substr($sfrm['ad'],2,2).'/'.substr($sfrm['ad'],4,4);}
if(!isset($fld['agtPwd'])){
include('Std.php');
e21Site();
e21Languages();
}
if(!isset($fld['XQ'])){
$htm='http://'.$_SERVER['SERVER_NAME'];
$Query = "Site=$Site&".$Query."&B2X=C, ,&Html=$htm/search-3.html";
if(isset($fld['agtCode'])){$Query.='&Agent=AGT'.($fld['agtCur'] != ''?'c':'');}
if($fld['Type'] == 'S'){$Query.='&ForSale=Y';}
URLencode($Query);
#print " $Query \n";
$Results=e21Curl($Query,'http://www.'.str_replace('www.','',$accommRes).'/cgi/api_accommres_search.pl');
#print " $Results \n\n";
}
#$t3d=microtime_float();
#$Features=e21Features();
e21dbOpen();
$Title=$Lng['AvndPr'];
$k1=$Lng['Development'];
$words=array();$dtl=array();
$Description='';$xPn='';$fld['XQ']='';
$dtl['Units']='';$dtl['PD']='';$dtl['Locations']='';
$dtl['txLoc']='';$dtl['Categories']='';$dtl['TourArea']='';$dtl['TourAreas']='';
$key=$Language.'|{meta name="keywords"';
#$t1a=microtime_float();
foreach (explode('?-?',$Results) as $rec){
if(strpos($rec,'||') !== false){
$dtls=explode('||',$rec);
$dtl['Units'].="'".($dtls[31] == ''?($dtls[35] == ''?$dtls[34]:$dtls[35]):$dtls[31])."',";
if($dtl['PD'] != "$dtls[4],$dtls[5]"){
$dtl['PD']="$dtls[4],$dtls[5]";$dtl['Country']=$dtls[7];$dtl['txLoc']=($dtls[45]!=''?e21Text('',$dtls[45]):$dtls[1]);
if(strpos($dtl['Locations'],$dtl['txLoc']) === false){$dtl['Locations'].=$dtl['txLoc'].',';}
}
if($dtls[29] != '' and strpos($dtl['Categories'],$dtls[29]) === false){$dtl['Categories'].=$dtls[29].',';}
}
}
#$t1c=microtime_float();
$Description=substr($dtl['Categories'],0,-1).' '.$Lng['Accommodation'].' '.substr($dtl['Locations'],0,-1).' - '.substr($dtl['TourAreas'],0,-1).' '.$dtl['Country'];
$rec='. '.$Lng['BookStage0'].'.';$Description=substr($Description,0,200-strlen($rec)).$rec;
#print "<!-- Dsc=$Description -->\n<!-- Cat=$dtl[Categories] -->\n<!-- loc= $dtl[Locations] -->\n<!-- TA=$dtl[TourAreas] -->\n";
$rec='';unset($dtls);unset($dtl);
foreach($words as $key=>$data){$rec.=$key.',';}
unset($words);
#print "\n";
#e21Menus("search.php",1); # Print out any Menus defined in Std.php #
#e21Content('1','',$Country); # Print out parts of the content which can be manipulated according depending on layout required defined in Std.php #
if($fld['head'] == 'Y'){
list($Hdr,$Ftr)=e21Content($Title,substr($rec,0,-1),$Description);
print $Hdr;
$Ftr=str_replace("name='searchForm'>","name='searchForm' value='$fld[searchForm]'>",$Ftr);
}
#$t2a=microtime_float();
# Start of showing the results, the form 'Xtras' is mandatory #
print "
<form action='' name='Xtras' target='booking_form' method='post'><input type='hidden' name='Fields'><input type='hidden' name='Id'><input type='hidden' name='searchForm' value='$frm[searchForm]'><input type='hidden' name='Language' value='$Language'></form>
<table border=0 cellspacing=0 width='100%'>
<tbody>\n";
if($sfrm['ad'] != ''){print " <tr><td class='sortBy' align='right'>$Lng[SortBy] <select id=tcSort name='Sort' onchange='sortSearch(this);'><option value='4'".($fld['Sort'] == '4'?' selected':'').">$Lng[Resort]</option><option value='1'".($fld['Sort'] == '1'?' selected=selected':'').">$Lng[Alphally]</option><option value='3'".($fld['Sort'] == '3'?' selected=selected':'').">$Lng[SortPLow]</option><option value='2'".($fld['Sort'] == '2'?' selected':'').">$Lng[SortPHigh]</option></select></td></tr>\n";}
print " <tr>
<td class='htag'>";
if($sfrm['ad'] != ''){
if(substr($sfrm['ad'],2,1) == '0'){$data='Month'.substr($sfrm['ad'],3,1);}else{$data='Month'.substr($sfrm['ad'],2,2);}
print "
<div class='clr bkt dflt-1 px12'><div class='lqd'><div class='lqd-t'><span></span></div><div class='lqd-c'>
<h4>$Lng[Accommodation]: ".substr($sfrm['ad'],0,2).' '.$Lng[$data].' '.substr($sfrm['ad'],4,4).", $sfrm[nt] $Lng[Nights], $sfrm[a] $Lng[Adults]".($sfrm['c'] > 0?" $sfrm[c] $Lng[Children]":'').($sfrm['i'] > 0?" $sfrm[i] $Lng[Infants]":'').($sfrm['basis'] != ''?", ".$Lng["$sfrm[basis]"]:'')."</h4>
</div><div class='lqd-b'><span></span></div></div></div>\n";
}
print "</td>\n </tr>\n <tr>\n <td>\n";
print " <div class='clr bkt dflt-1 px12'><div class='lqd'><div class='lqd-t'><span></span></div><div class='lqd-c'>\n";
if(strpos($Results,'__search:0') !== false){print "<div id='Page-1'><table><tbody><tr><td><br><center><h3>$Lng[Sorry3]</h3><center><br></td></tr>";$Results='';}
$sLg=substr($Language,0,2);
# Here is the record layout of each result each element is seperated by || #
#Count=0,Place=1,Property=2,Accommodation=3,PlaceNo=4,DevNo=5,AccNo=6,Country=7
#PriceSym=8,Price=9,Currency=10,YProRef=11,xAccImage1=12,xAccImage2=13
#MaxGuests=14,Bathrooms=15,DevFeatures=16,xsBook=17,AccFeatures=18,GPF=19,
#NAS=20,NASRating=21,NASEye=22,EyeRating=23,NASHear=24,HearRating=25,PlusChildren=26
#GPF=27,NoRooms=28,Category=29,DevCountry=30,SingleUnit=31,YLocRef=32,YAccRef=33,
#UnitInfoNo=34,UnitID=35,PlaceCategories=36,DoubleBeds=37,SingleBeds=38,SofaBeds=39,
#Bedrooms=40,DevImage1=41,DevImage2=42,Sid=43,VTours=44,txLoc=45,txDev=46,txAcc=47
#AgencyCType=48,AgencyComm=49,AgencyRetained=50,CurrencyRate=51,B2X=52
$Page=1;$knt=0;$xPn='';
$rds=array();$srt=array();
foreach (explode('?-?',$Results) as $rec){
if(strpos($rec,'||') !== false){
#print "<!-- $rec -->\n";
$dtls=explode('||',$rec);$key='';
if($fld['AgencyCode'] == '' || strpos($fld['UnitLists'],",$dtls[35],") === false){$key=($fld['allocOnly'] == ''?"z$dtls[0]":'');}else{$key="a$dtls[0]";}
if($key != ''){
$rds[$key]=$rec;$srt[$key]=$dtls[9];
if($fld['Sort']){
if($fld['Sort'] == '1'){$srt[$key]="$dtls[2]$dtls[3]$dtls[1]";}
if($fld['Sort'] == '2'||$fld['Sort'] == '3'){$srt[$key]=(substr($key,0,1) == 'z'?"$dtls[9]":'0.00');}
if($fld['Sort'] == '4'){$srt[$key]="$dtls[1]$dtls[2]$dtls[3]";}
}
}
}
}
if($fld['Sort']){if($fld['Sort'] == '2'){arsort($srt);}else{asort($srt);}}
foreach($srt as $ID=>$rec){
$rec=$rds[$ID];
if(strpos($rec,'||') !== false){
# Split the record into elements - refer to the above to correspond what with each element #
#http://www.onlyvillas.com/searches.php?pn=9&dn=1028,1049,1050,1051,1052,1053
#print "<!-- ($ID) $rec -->\n";
unset($dtls);$dtls=explode('||',$rec);
$Accept=($dtls[52] == 'B'?'N':'Y');
$Price="<span class='Currency'> $dtls[10]";$fld['sym']=preg_replace('/ \S+/','',$dtls[8]);
if($dtls[9] == '1.00'){if($dtls[19] != '-1'){$Price=number_format($dtls[19],2,'.',',').$Price.'*';}else{$Price='-.--'.$Price;}}else{$Price=number_format($dtls[9],2,'.',',').$Price;}
if($Accept == 'Y'){
$fld['XQ'].='?-?'.$rec.'?-?';
$dtls['txLoc']=ucwords(strtolower(($dtls[45]==''?e21Text('LOC',$dtls[4]):e21Text('',$dtls[45]))));if($dtls['txLoc']==''){$dtls['txLoc']=$dtls[1];}
$dtls['txDev']=ucwords(strtolower(($dtls[46]==''?e21Text('DEV',$dtls[5]):e21Text('',$dtls[46]))));if($dtls['txDev']==''){$dtls['txDev']=$dtls[2];}
$dtls['txAcc']=ucwords(strtolower(($dtls[47]==''?e21Text('ACC',$dtls[3]):e21Text('',$dtls[47]))));
if($knt == 0){
if($Page > 1){print " </tbody>\n </table>\n </div>\n";}
print " <div id='Page-$Page'";if($Page > 1){print " style='display:none;'>\n";}else{print ">\n";}
print "
<table border=0 cellspacing='0' cellpadding='0' width='98%'>
<tbody>\n";
}
#--- Location & Development Details ---#
if("$dtls[4],$dtls[5]" != $xPn or $knt == 0){
# print " <tr><td class='bar-1' colspan=4>";
$Thumb1='';$Thumb2='';
# if($dtls[41] == '1'){$Thumb1=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]_image1.jpg");$Thumb1=str_replace(' ','',$Thumb1);}
# if($dtls[42] == '2'){$Thumb2=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]_image2.jpg");$Thumb2=str_replace(' ','',$Thumb2);}
if($dtls[11] == ''){
if($fld['agtCode'] == ''){$dtls['lkDev']="details.php?id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]";}else{$dtls['lkDev']="#' onclick='return(showLPA(this,\"id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]\"));";}
# print "$dtls[txLoc], $dtls[txDev]</td></tr><tr><td><br/></td></tr>\n";
# print "<tr><td valign='top'>".($Thumb1 != ''?"<img alt='$dtls[txDev]' src='$Thumb1' width=125 border=0/> ":'').($Thumb2 != ''?"<img alt='$dtls[txDev]' src='$Thumb2' width=125 border=0/>":'')."</td>\n";
}else{
if($fld['agtCode'] == ''){$dtls['lkLoc']="details.php?id=p&l=$Language&pn=$dtls[4]";}else{$dtls['lkLoc']="#' onclick='return(showLPA(this,\"id=p&l=$Language&pn=$dtls[4]\"));";}
# print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]($Lng[TouristInfo])' href='$dtls[lkLoc]'>$dtls[txLoc]</a>, $dtls[txDev]</td></tr><tr><td><br/></td></tr>\n";
# print " <tr><td valign='top' width=280>";
if($fld['agtCode'] == ''){$dtls['lkDev']="details.php?id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]";}else{$dtls['lkDev']="#' onclick='return(showLPA(this,\"id=l&l=$Language&pn=$dtls[4]&dn=$dtls[5]\"));";}
# print "<a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'>".($Thumb1 != ''?"<img alt='$dtls[txDev] $Lng[Details]' src='$Thumb1' width=125 border=0/></a> ":'</a>');
# print "<a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'>".($Thumb2 != ''?"<img alt='$dtls[txDev] $Lng[Details]' src='$Thumb2' width=125 border=0/>":'')."</a></td>\n";
}
# $sql="select Info from dev where(PlaceNo = '$dtls[4]')and(DevNo = '$dtls[5]');";
#--- Retreive Information regarding the Property - defined in Accommres ---#
# $dbR=mysql_query($sql);
# $row=mysql_fetch_array($dbR);
# $fld['Lng']=$fld['Language'];if(strpos($row['Info'],"|$fld[Lng]|") === false){$fld['Lng']=substr($Languages,0,3);}
# $Info=explode("|$fld[Lng]|",$row['Info']);$data=$Info[1];$data=str_replace('~','<br/>',$data);
# print " <td style='padding:10px;'>\n";
# print " <div class='pagetext' style='overflow:hidden;height:9em;'>$data</div>\n";
# if($data != ''){print " <div style='position:relative;top:-5px;text-align:right;padding-right:10px;'><a title='$dtls[txDev] $Lng[Details]' href='$dtls[lkDev]'><small><small><br>$Lng[MoreInfo] ...</small></small></a></div>\n";}
# print " </td>\n";
# print " </tr>\n";
$xPn="$dtls[4],$dtls[5]";
}
$dtls['lkAcc']="id=d&l=$Language&cr=$dtls[10]";
if($sfrm['ad'] != ''){$dtls['lkAcc'].="&ad=$fld[ArrivalDate]";}
if($sfrm['nt'] != ''){$dtls['lkAcc'].="&nt=$sfrm[nt]";}
if($sfrm['a'] != ''){$dtls['lkAcc'].="&a=$sfrm[a]";}
# if($sfrm['Currency'] != ''){$dtls['lkAcc'].="&cr=$sfrm[Currency]";}
if($dtls[35] != ''){$dtls['lkAcc'].="&ui=$dtls[35]";}
if($dtls['Basis'] != ''){$dtls['lkAcc'].="&b=$dtls[Basis]";}
# $data="details.php?Id=d&Language=$Language&ArrivalDate=$fld[ArrivalDate]&Nights=$fld[NumberNights]&Adults=$fld[Adults]&Currency=$fld[Currency]&UnitID=$dtls[35]&Basis=$dtls[Basis]";
if($fld['AgencyCode'] != ''){$dtls['lkAcc'].="&AgencyCode=$fld[AgencyCode]&AgencyRef=$fld[AgencyRef]&Agent=AGT".($fld['agtCur'] != ''?'c':'');}
if($dtls[34] != ''){if($dtls[34] != $dtls[35]){$dtls['lkAcc'].="&iu=$dtls[34]";}}else{$dtls['lkAcc'].="&pn=$dtls[4]&dn=$dtls[5]&an=$dtls[6]";}
if($sfrm['c'] != ''){$dtls['lkAcc'].="&c=$sfrm[c]";}
if($sfrm['Infants'] != ''){$dtls['lkAcc'].="&Infants=$sfrm[Infants]";}
if($sfrm['Babies'] != ''){$dtls['lkAcc'].="&Babies=$sfrm[Babies]";}
if($fld['agtCode'] == ''){$dtls['lkAcc']="details.php?$dtls[lkAcc]";}else{$dtls['lkAcc']="#' onclick='return(showLPA(this,\"$dtls[lkAcc]\"));";}
#--- Depending on Location&Development being commented out ---#
# print " <tr><td class='bar-2' colspan='4'>$dtls[txAcc]</td></tr>\n";
print " <tr><td class='bar-p' colspan='4'><a href='$dtls[lkLoc]'>$dtls[txLoc]</a>, <a href='$dtls[lkAcc]'>$dtls[txDev] - $dtls[txAcc]</a></td></tr>\n";
print <<<HTM
<tr>
<td style='' colspan='4' style='padding:8px;'>
<table border=0 cellspacing=0 cellpadding=0 width='100%'>
<tbody>
<tr><td colspan=4 style='padding-bottom:10px;'></td></tr>
<tr>
<td width=280 class='top'>
HTM;
#--- Define thumb images of the Accommodation ---#
$Thumb1='';$Thumb2='';
if($dtls[12] == '1'){$Thumb1=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]$dtls[3]_thumbimage_$dtls[34]$dtls[12].jpg");$Thumb1=str_replace(' ','',$Thumb1);}else{$Thumb1='';}
if($dtls[13] == '2'){$Thumb2=strtolower("http://$accommRes/onlinebookings/$Site/$dtls[1]$dtls[2]$dtls[3]_thumbimage_$dtls[34]$dtls[13].jpg");$Thumb2=str_replace(' ','',$Thumb2);}else{$Thumb2='';}
if($dtls[11] == ''){
print ($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb1' width=125 border=0 /> ":'').($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[txDev] - $dtls[Acc]' src='$Thumb2' width=125 border=0 />":'');
}else{
# print "<a class='psize12' title='$dtls[1] $Lng[Details]' href='details.php?Id=d&Fields=PlaceNo=$dtls[4],Place=$dtls[1],Country=$dtls[7]'><img id='img-$dtls[0]' alt='$dtls[3]' src='$Thumb' border=0 /></a>";
print "<a class='psize12' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'>".($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb1' width=125 border=0 />":'')."</a> ";
print "<a class='psize12' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'>".($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[txDev] - $dtls[txAcc]' src='$Thumb2' width=125 border=0 />":'')."</a>";
# $dtls[17]=str_replace("';","&VTours=$fld[VTours]';",$dtls[17]);
# print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]' href='#' onclick=\"$dtls[17]AccommresBook(2);\">".($Thumb1 != ''?"<img id='img-$dtls[0]a' alt='$dtls[Acc]' src='$Thumb1' width=125 border=0 />":'')."</a> ";
# print "<a class='psize12' title='$dtls[txLoc] $Lng[Details]' href='#' onclick=\"$dtls[17]AccommresBook(2);\">".($Thumb2 != ''?"<img id='img-$dtls[0]b' alt='$dtls[Acc]' src='$Thumb2' width=125 border=0 />":'')."</a>";
}
print "</td>\n";
print " <td valign='top'>\n";
print " <table border=0 cellspacing=0 cellpadding=0 width='100%'>\n";
# <tr><td align='right'><div><a id='resBookit' onclick="$dtls[17]AccommresBook(1);"><img alt='' src='images/$Language/disponibilidad.gif' border=0></a></div></td></tr>
print " <tr>\n";
print " <td class='pagetext' align='left' class='top'>$dtls[40] $Lng[Bedrooms]<br/>$dtls[15] $Lng[Bathrooms]<br/>$dtls[14] $Lng[MaxGuests]".($dtls[26] != ''?" + $dtls[26] $Lng[Children]<br/>":"<br/>");
$data='';$fld['GACode']=$fld['AgencyCode'];
if($dtls[37] != ''){$data= "$dtls[37] $Lng[DoubleBeds],";}
if($dtls[38] != ''){$data.= "$dtls[38] $Lng[SingleBeds],";}
if($dtls[39] != ''){$data.= "$dtls[39] $Lng[SofaBeds],";}
print str_replace(',,','',"$data,")."<br/><br/>";
if($dtls[12] !=''){print "<a class='more' title='$dtls[txDev] $Lng[Details]' href='$dtls[lkAcc]'><small>$Lng[MoreInfo]</small></a>";}
print "</td>\n";
print " <td valign='bottom' align='right' style='margin-right:5px;'>\n";
# Show price and the book now button #
if($fld['AgencyCode'] != '' && substr($ID,0,1) == 'a'){$dtls[8]='0.00';$dtls[17]=preg_replace('/AgencyCode=/i','AgencyCode=GRNTE ',$dtls[17]);$fld['GACode']="GRNTE $fld[AgencyCode]";}
print " <table class='booknowtext' border=0>\n";
if($dtls[9] == '1.00'){
if($dtls[27] == '0-'){$dtls[27]='';}
if($dtls[27] != ''){
list($fld['gpF'],$fld['gpT'])=explode('-',$dtls[27]);$fld['gpF']=preg_replace('/\D/g','',$fld['gpF']);$fld['gpT']=preg_replace('/\D/g','',$fld['gpT']);
$fld['gpF']=number_format($fld['gpF']*$dtls[51]);$fld['gpT']=number_format($fld['gpT']*$dtls[51]);
$dtls[27]="$Lng[GPr]<br><b>$fld[sym] $fld[gpF]</b> <small>$Lng[To]</small> <b>$fld[gpT]</b> <small>$dtls[10]</small>";
}
}
print " <tr><td align=right>".($dtls[9] != '1.00'?"<b>$Lng[Available]</b>":"$dtls[27]")."<br/></td></tr>\n";
print " <tr><td align=right><b>".($dtls[9] != '1.00'?"$dtls[8] $dtls[10]":'')."</b></td></tr>\n";
if($dtls[9] != '1.00' && $dtls[49] != '' && $dtls[50] != 'A'){
# $dtls['agtRate']=($dtls[19] - ($dtls[19] / ((100 + $dtls[49])/100))) * $dtls[50];
$dtls['agtRate']=($dtls[19] * ($dtls[49]/100)) * $dtls[51];
#print "\n<tr><td> $dtls[agtRate]=($dtls[19] * ($dtls[49]/100)) * $dtls[50]</td></tr>";
print " <tr><td align=right><br/><span class='pi pt9'>$Lng[Commission] ".number_format($dtls['agtRate'],2,'.',',')."</span></td></tr>\n";
}
if(isset($fld['agtPwd'])){
$data='agentBookConfirm()';if($dtls[8] == '0.00'){$dtls[17]=preg_replace('/\&AgencyCode=/i',"&AgencyCode=GRNTE ",$dtls[17]);}
if($fld['agtCur'] != ''){$dtls[17]=preg_replace('/\&AgencyCode=/i',"&Loc=$dtls[txLoc]&Dev=$dtls[txDev]&Acc=$dtls[txAcc]&Agent=AGTc&AgencyDeposit=$fld[agtDeposit]&AgencyCode=",$dtls[17]);}
$dtls[17]=preg_replace('/document\.Xtras\.Fields\.value/',"e21Fld.Fields",$dtls[17]);
}else{
if(strpos($dtls[17],'&Extras=&') === false){
$data='AccommresBook(1)';
}else{
$data='AccommresBook(5)';
$dtls[17]="document.Xtras.Fields.value='SiteCode=$Site&ArrivalDate=$fld[ArrivalDate]&NumberNights=$fld[NumberNights]&PlaceNo=$dtls[4]&DevNo=$dtls[5]&AccNo=$dtls[6]&Currency=$fld[Currency]&Adults=$fld[Adults]&Children=$fld[Children]&Infants=$fld[Infants]&Babies=$fld[Babies]&InfoUnitNo=$dtls[34]&OfferCode=$fld[OfferCode]&AgencyCode=$fld[GACode]';";
}
}
if($dtls[9] == '1.00'){$Lng['BookNow']=$Lng['Details'];$dtls[17]="OpenWindow('$dtls[lkAcc]','_parent')";$data='';}
print <<<HTM
<tr><td align='right'><div><button class="bTn-W more" name="book" onclick="$dtls[17]$data;">$Lng[BookNow]</button></div></td></tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
HTM;
$knt++;//if($knt == 10){$knt=0;$Page++;}
}
}
}
if($Results != '' && $knt == 0){print "<div id='Page-1'><table><tbody><tr><td><br><center><h3>$Lng[Sorry3]</h3><center><br></td></tr>";}
print " </tbody>
</table>
</div>
</div><div class='lqd-b'><span></span></div></div></div>
</div>
</td>
</tr>\n";
# Show page numbers unless results fit on one page #
if($knt == 0){$Page--;}
if($Page > 1){
print " <tr height='40'>\n <td colspan=4 align='right' valign='bottom' class='pagePN psize10'>\n < <a id='pg-p' href='#' onclick='showPage(\"-\",\"$Page\",this);'>$Lng[PrvPage]</a> ";
for($i=1;$i<=$Page;$i++){print "<a id='pg-$i' href='#' onclick='showPage(\"$i\",\"$Page\",this);'>$i</a>".($i<$Page?',':'');}
print " <a id='pg-n' href='#' onclick='showPage(\"+\",\"$Page\",this);'>$Lng[NxtPage]</a> >\n";
}
if($dbR){mysql_free_result($dbR);}
e21dbClose();
$fld['XQ']=URLencode($fld['XQ'])."__form$fld[searchForm]";
print "\n </tbody>\n</table>\n<script type='text/javascript'>\nLanguage='$Language';\ne21Fld['searchForm']='$fld[searchForm]';\ne21Fld['XQ']='$fld[XQ]';\n</script>\n";
if($fld['head'] == 'Y'){print $Ftr;}
#$t2b=microtime_float();
#print "<!-- Args: ".($t3b - $t3a)." -->\n";
#print "<!-- std: ".($t3c - $t3b)." -->\n";
#print "<!-- srch: ".($t3d - $t3c)." -->\n";
#print "<!-- dbOp: ".($t1a - $t3d)." -->\n";
#print "<!-- Res: ".($t1b - $t1a)." -->\n";
#print "<!-- sql: ".($t1c - $t1b)." -->\n";
#print "<!-- hdr: ".($t2a - $t1c)." -->\n";
#print "<!-- htm: ".($t2b - $t2a)." -->\n";
#print "<!-- Total: ".($t2b - $t3a)." -->\n\n\n";
#print "<!-- $sql -->\n";
function microtime_float(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
?>