";
$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
Sukawati area is well-known as the center of shopping handicraft in Bali. Sukawati Art Market is 'a must see' place for shopping enthusiasts. Huge number of small stalls occupied the two stories building offer a lot of cheap souvenirs. Almost any kind of Bali's souvenirs can be found in here either painting, woodcarving, clothes, temple umbrellas and other temple accessories, leather puppet, wind chime, jewelries and others. The souvenirs choices are has huge quantity and available in various choices.
Sukawati is located near Denpasar and Ubud with easy access to both area. Sukawati and neighboring area named Batuan are the home of the craftsmen and great painters making it an excellent place to stay. There is many private villas in Sukawati, most of the
Sukawati villas are located in Pabean Beach area on the south coast of Sukawati. Villa Samudra, Pratama Villas, Villa Nataraja and Villa Raj. Santi Mandala Villa & Spa is also a good choice.
Sukawati can be reached with 20-minute drive from Ubud and Denpasar and 45-minute drive from Ngurah Rai International Airport.
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}