";
$rst = open_mysql("partners_abldata", $sql);
open_mysql("close");
$line = mysql_fetch_array($rst, MYSQL_ASSOC);
if ($line[rate] > 0) {
if ($line[hotdeals] > 0) {
$out = "from USD " . round($line[rate] / 1.21) ." " . round($line[hotdeals] / 1.21)." ";
} else {
$out = "from USD ".round($line[rate] / 1.21);
}
} else {
$sql3 = "SELECT MIN(rate) as 'rate' FROM rate_availability
WHERE org_id='{$oid}' AND date like '%$year%' AND rate !=0";
//echo $sql3."
In and around
Pupuan is a cool and beautiful area on the slopes of Mt. Batukaru, in the western part of Bali. It is a coffee, clove and rice growing region with towering trees twisting mountain roads and breathtaking view. Pupuan is a place where you can enjoy awesome landscape accompanied by no one other than the friendly local farmers and cool climate. Pupuan boasts some of the most magnificent rice field scenery on the island. Pupuan is 45 km from Tabanan city and around two hour drive from Kuta.
Pupuan is a great place for honeymoon, retreat and romantic hideaway. Hotel in Pupuan are rare, the accommodation mostly villa. Pupuan villas offer good accommodation and great view. Pupuan villa with lower price is Kebun Villa, Cempaka Belimbing Villa is more expensive choice with more facilities and amenities and for top-end Pupuan villa is Sanda Boutique Villa.
Hotels Villas Travel Tips
Hotels Villas Blog
All Destinations
Top Selling Cities
";
while ($org_cit = mysql_fetch_array($result_cit, MYSQL_ASSOC)) {
$u_slug = toAscii($org_cit["org_city"]);
if(strpos(strtolower($org_cit["org_state"]), "java") || strtolower($org_cit["org_state"]) == "jakarta" || strtolower($org_cit["org_state"]) == "yogyakarta"){
$h_state = "java";
}elseif(strtolower($org_cit["org_state"]) == "west nusa tenggara"){
$h_state = "west-nusa-tenggara";
}elseif(strpos(strtolower($org_cit["org_state"]), "sulawesi")){
$h_state = "sulawesi";
}elseif(strpos(strtolower($org_cit["org_state"]), "kalimantan")){
$h_state = "kalimantan";
}elseif(strtolower($org_cit["org_state"]) == "east nusa tenggara"){
$h_state = "east-nusa-tenggara";
}elseif(strpos(strtolower($org_cit["org_state"]), "sumatra")){
$h_state = "sumatra";
}else{
$h_state = $org_cit["org_state"];
}
//$url_cit = "
";
$url_cit = " ";
echo "".$url_cit.$org_cit["org_city"]." ";
if ($iii == 10){echo "
"; }else{
$iii++;
}
}
echo " ";
?>
Subscribe to get special offers
Travel Tool
true (at main header page) or false (at others)
########################################################################################
function form_search_hotel_auto($main_header){
global $PHP_SELF;
global $HTTP_POST_VARS;
global $type;
global $location;
global $config_abl;
global $checkin;
global $nights;
global $rooms;
global $org;
global $gmode;
global $gtype;
global $ghotel;
global $glocation;
global $grategt;
global $gratelt;
global $gcheckin;
global $gnights;
global $grooms;
global $gsort;
global $affiliate_id;
global $gview;
$hotel = $HTTP_POST_VARS["Hotel"];
if($hotel==""){$hotel = $ghotel;}
if($hotel==""){$hotel = "all";}
if ($hotel == "all"){
$type = $HTTP_POST_VARS["Type"];
if($type==""){$type = $gtype;}
if($type==""){$type = "all";}
//$location = $HTTP_POST_VARS["Location"];
if($location==""){$location = $glocation;}
if($location==""){$location = "all";}
$rate_gt = $HTTP_POST_VARS["Rate-gt"];
if($rate_gt==""){$rate_gt = $grategt;}
if($rate_gt==""){$rate_gt = $config_abl["default_rate_gt"];}
$rate_lt = $HTTP_POST_VARS["Rate-lt"];
if($rate_lt==""){$rate_lt = $gratelt;}
if($rate_lt==""){$rate_lt = $config_abl["default_rate_lt"];}
}else{
$type = "";
$location = "";
$rate_gt = "all";
$rate_lt = "all";
}
$nights = $HTTP_POST_VARS["nights"];
if($nights==""){$nights = $gnights;}
if ($nights==""){$nights=$config_abl["default_nights"];}
$rooms = $HTTP_POST_VARS["rooms"];
if($rooms==""){$rooms = $grooms;}
if ($rooms==""){$rooms=$config_abl["default_rooms"];}
if($checkin==""){$checkin = $gcheckin;}
if(strlen($checkin)!=10){$checkin = "";}
$sortby = $HTTP_POST_VARS["sortby"];
if($sortby==""){$sortby = $gsort;}
if($sortby==""){$sortby = "0";}
$view = $HTTP_POST_VARS["view"];
if($view==""){$view = $gview;}
if($view==""){$view = "0";}
$ID = $org["id"];
$submit_title = "Search";
$hidden_fields = "
";
$form_action = "/hotel/search.html";
if ($ID != ""){
$type = $org["type"];
$hotel = $org["name"];
$location = $org["city"];
$submit_title = "Check Rooms Availability";
$form_action = "/".$type."/".$type."_detail/super_saver/".$ID.".html";
$hidden_fields = "
";
$hidden_fields .= "
";
$hidden_fields .= "
";
}
$hidden_fields .= "
";
//list city dalam combo box
/*$sqlcity = "SELECT DISTINCT org_city,org_state FROM organization order by org_state,org_city ";
$resultcity = open_mysql ("abldata", $sqlcity);
$listcity = "
";
$listcity .= "All City ";
while ($orgCity = mysql_fetch_array($resultcity, MYSQL_ASSOC)) {
if($location != "" && strtolower($orgCity["org_city"])==strtolower($location)){
$listcity .= "".$orgCity["org_state"]." -> ".$orgCity["org_city"]." ";
}else{
$listcity .= "".$orgCity["org_state"]." -> ".$orgCity["org_city"]." ";
}
}
$listcity .= " \n";
$resultcity = open_mysql ("close"); */
$sqlcity = "SELECT DISTINCT org_city,org_state,org_country FROM organization order by org_country,org_state,org_city ";
$resultcity = open_mysql("abldata", $sqlcity);
$listcity = "
";
$listcity .= "All City ";
while ($orgCity = mysql_fetch_array($resultcity, MYSQL_ASSOC)) {
if ($location != "" && strtolower($orgCity["org_city"]) == strtolower($location)) {
$listcity .= "" . $orgCity["org_country"] .
" -> " . $orgCity["org_state"] .
" -> " . $orgCity["org_city"] . " ";
} else {
$listcity .= "" . $orgCity["org_country"] .
" -> " . $orgCity["org_state"] .
" -> " . $orgCity["org_city"] . " ";
}
}
$listcity .= " \n";
$resultcity = open_mysql("close");
$arr_type = array(0=>"hotel", 1=>"villa", 2=>"preferred", 3=>"homestay", 4=>"hotdeals", 5=>"all");
if ($type==""){$type = "all";}
$output_type = '
';
for ($i=0;$i<=5;$i++){
if ($arr_type[$i] == $type){
$output_type .= ''.ucwords($arr_type[$i]).' ';
}else{
$output_type .= ''.ucwords($arr_type[$i]).' ';
}
}
$output_type .= ' ';
$bgcolor="#CCCCCC";
if ($type=="hotdeals"){$bgcolor="#CCFFCC";}
if ($checkin==""){
$tomorrow = mktime (0,0,0,date("m"),date("d")+$config_abl["default_start_checkin"],date("Y"));
$checkin = date("Y-m-d",$tomorrow);
}else{
#validate the date;
$checkin = date ("Y-m-d", mktime (0,0,0,substr($checkin,5,2)+0,substr($checkin,8,2)+0,substr($checkin,0,4)));
}
$org["checkin"] = $checkin;
$org["rooms"] = $rooms;
$org["nights"] = $nights;
$bln = (int) substr($checkin,5,2);
$thn = (int) substr($checkin,0,4);
$dt = (int) substr($checkin,8,2);
$output_ci = '
';
for ($i=1;$i<=12;$i++){
$month_name = date("F",mktime (0,0,0,$i,date("n"),date("Y")));
if ($i == $bln){
$output_ci .= ''.$month_name.' ';
}else{
$output_ci .= ''.$month_name.' ';
}
}
$output_ci .= ' ';
$output_ci .= '
';
for ($i=1;$i<=31;$i++){
if ($i == $dt){
$output_ci .= ''.$i.' ';
}else{
$output_ci .= ''.$i.' ';
}
}
$output_ci .= ' ';
$output_ci .= '
';
if ($thn>BaliNow("Y")){$min=$thn-BaliNow("Y");}else{$min=0;}
for ($i=$thn-$min;$i<=$thn+1;$i++){
if ($i == $thn){
$output_ci .= ''.$i.' ';
}else{
$output_ci .= ''.$i.' ';
}
}
$output_ci .= ' ';
$output_ni = '
';
for ($i=1;$i<=$config_abl["max_nights"];$i++){
if ($i == $nights+0){
$output_ni .= ''.$i.' ';
}else{
$output_ni .= ''.$i.' ';
}
}
$output_ni .= ' ';
$output_ro = '
';
for ($i=1;$i<=$config_abl["max_rooms"];$i++){
if ($i == $rooms+0){
$output_ro .= ''.$i.' ';
}else{
$output_ro .= ''.$i.' ';
}
}
$output_ro .= ' ';
$arr_sort = array(0=>"Hits", 1=>"Name", 2=>"Room Rate", 3=>"Location", 4=>"Star");
$output_sort = '
';
for ($i=0;$i<=3;$i++){
if ($i == $sortby){
$output_sort .= ''.ucwords($arr_sort[$i]).' ';
}else{
$output_sort .= ''.ucwords($arr_sort[$i]).' ';
}
}
$output_sort .= ' ';
if($gmode=="availability"){$view="1";}
$arr_sava = array(0=>"All", 1=>"Instant Confirm");
/*$output_sava = '
';
for ($i=0;$i<=1;$i++){
if ($i == $view){
$output_sava .= ''.ucwords($arr_sava[$i]).' ';
}else{
$output_sava .= ''.ucwords($arr_sava[$i]).' ';
}
}
$output_sava .= ' ';
*/
//GANTI DENGAN RADIO GROUP
$output_sava .= '
All ';
if ($view !=1){
$output_sava .= '
Instant Confirm ';
}else{
$output_sava .= '
Instant Confirm ';
}
if (!$main_header){
if ($ID != ""){
//check availability for hotel that selected
echo <<
EOT;
}else{
//if id == blank so nothing to display
}
}else{
if ($ID!=""){$hotel = "all";}
echo <<
Hotel Name
Destination
{$listcity}
Check-in date
{$output_ci}
Night
{$output_ni}