<?
/*
+-------------------------------------------------------------------------
|   Google Map Api with PHP, MySQL, GeoDecorder
|   =============================================
|   by Sreeprakash. N
|   (c) 2005 Schogini Systems.
|   http://www.schogini.us
|   =============================================
|   Web: http://www.schogini.us
|   Time: Monday, 1 August 2005
+--------------------------------------------------------------------------
|
|   > File: hetels-list.php this is called via the iframe in index.php
|   > Uses MySQL Database to generate markers dynamically
|   > Module written by: Sreeprakash. N
|   > Date started: 7/15/2005
|
|   > Module Version Number: 1.0.0
|   > DBA Checked: Najeeb Jabbar
|   > Quality Checked: by Gayatri. S. Prakash
+-------------------------------------------------------------------------
*/

/*-------------------------------------------------------------------------*/
// This include file has MySQL DB Details and functions
/*-------------------------------------------------------------------------*/

/*-------------------------------------------------------------------------*/
// This include file has MySQL DB Details and functions
/*-------------------------------------------------------------------------*/

require("admin/inc/config.inc");
include("phpweather/phpweather.php");
require("phpweather/output/pw_text_en.php");
require("phpweather/output/pw_images.php");
/*-------------------------------------------------------------------------*/
// This file can be called with two parameters via Type and Name
/*-------------------------------------------------------------------------*/

if (!isset($_SESSION)) {
  session_start();
}

$thisType=$_GET['Type'];  //Restaurant , Real-Estate , default Hotel
$thisName=$_GET['Name'];  //Abbey

if(!isset($thisType))$thisType=$_GET['type']; 
if(!isset($thisName))$thisName=$_GET['name'];

if(!isset($thisType)||$thisType=="")$thisType="Hotel";

$_SESSION[thisType]=$thisType;

$xx="-80.224145";
$yy="25.787676";

if($thisType=="Disney"){
 //The coordinates are different than our Miami Beach maps. Here are the coordinates to Kissimmee, FL:
 //map.centerAndZoom(new GPoint(-81.412867, 28.303988), 6)
 $xx="-81.412867";
 $yy="28.303988";
}

if(!isset($thisName)||$thisType==""){
  	echo "Sorry, need the name of the $thisType.";
	exit;
}else{
    if($thisType=="Hotel"){
    	$sql="select * from tblMapDetails where type='Hotel' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'map-hotels.gif');
    	$details="Get rates";
    	$template='popuptemplate_hotel.htm';
    }elseif($thisType=="Restaurant"){
    	$sql="select * from tblMapDetails where type='Restaurant'  and name like '%$thisName%'";
    	//$tpl->assign("hotelsimage", 'restaurants.gif');
    	$details="Reservations";
    	$template='popuptemplate_restaurant.htm';
    }elseif ($thisType=="Real-Estate"){// Real Estate
    	$sql="select * from tblMapDetails where type='RealEstate' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'map-real-estate.gif');
     	$details="Request a showing";
    	$template='popuptemplate_real_estate.htm';
    }
    elseif ($thisType=="Attractions"){
    	$sql="select * from tblMapDetails where type='Attractions' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'map-attractions.gif');
     	$details="Request a showing";
    	$template='popuptemplate_attractions.htm';
    }
    elseif ($thisType=="Disney"){
    	$sql="select * from tblMapDetails where type='Disney' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'disney-world.gif');
     	$details="Get rates";
    	$template='popuptemplate_disney.htm';
    }
    elseif ($thisType=="House-for-sale-by-owner"){
    	$sql="select * from tblMapDetails where type='House_For_Sale_By_Owner' and name like '%$thisName%'";
    	
    	$tpl->assign("hotelsimage", 'map-house-for-sale.gif');
     	$details="Request a showing";
    	$template='popuptemplate_house_for_sale_by_owner.htm';
    }
    //Schogini: Edited by anish on 20-03-06
    elseif ($thisType=="Nightlife"){
    	$sql="select * from tblMapDetails where type='Nightlife' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'restaurants-title.gif');
     	$details="Request a showing";
    	$template='popuptemplate_nightlife.htm';
    }
	//Schogini: Edited by anish on 19-04-06
    elseif ($thisType=="Caribbean_Bahamas"){
    	$sql="select * from tblMapDetails where type='Caribbean_Bahamas' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'island.gif');
     	$details="Request a showing";
    	$template='popuptemplate_Caribbean_Bahamas.htm';
    }
	//Schogini: Edited by anish on 02-05-06
    elseif ($thisType=="Shopping"){
    	$sql="select * from tblMapDetails where type='Shopping' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Request a showing";
    	$template='popuptemplate_Shopping.htm';
	}
    //Schogini: Edited by anish on 16-06-06
    elseif ($thisType=="Traffic-Camera"){
    	$sql="select * from tblMapDetails where type='Traffic-Camera' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Request a showing";
    	$template='popuptemplate_traffic_camera.htm';
	}
	//Schogini: Edited by anish on 16-06-06
    elseif ($thisType=="Visitor-Pass"){
    	$sql="select * from tblMapDetails where type='Visitor-Pass' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Get a Visitor Pass";
    	$template='popuptemplate_Visitor-Pass.htm';
	}
	//Schogini: Edited by anish on 29-07-06
    elseif ($thisType=="Community"){
    	$sql="select * from tblMapDetails where type='Community' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Request a showing";
    	$template='popuptemplate_community.htm';
	}
	//Schogini: Edited by anish on 14-08-06
    elseif ($thisType=="Recycling"){
    	$sql="select * from tblMapDetails where type='Recycling' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Request a showing";
    	$template='popuptemplate_recycling.htm';
	}
	//Schogini: Edited by anish on 02-09-06
	elseif ($thisType=="Vacation-Rentals"){
    	$sql="select * from tblMapDetails where type='Vacation-Rentals' and name like '%$thisName%'";
    	$tpl->assign("hotelsimage", 'shops-stores.gif');
     	$details="Request a showing";
    	$template='popuptemplate_vacation-rentals.htm';
	}
    $resultall=gQuery($sql);
	$numberall = $resultall->numRows($resultall);
	if($numberall>1){
         $html="Sorry, more than one record found.";
    }else{
        if($db_row=$resultall->fetchRow()){
        	$name=s($db_row[name]);
        	$street=s($db_row[street]);
            $city=s($db_row[city]);
            $image=s($db_row[image]);
			$url2=$db_row[urldetails2];

        	$s1s="<span class=\"FilmTitlesLinked\">";$s1e="</span>";
        	$s2s="<span class=\"BusinessText\">";$s2e="</span>";
        	$s3s="<span class=\"BusinessTextLinked\">";$s3e="</span>";
			if($thisType=="Caribbean_Bahamas"){
				$html="$s1s<b><a href=\"{$db_row[urldetails]}\">$name</a></b>$s1e<br>";
				$html.="$s2s{$street}<br>";
				//$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e<br>";
				$html.="<img src=\"admin/mapimages/$image\" width=\"120\" height=\"80\"><br>";
			}elseif($thisType=="Traffic-Camera"){//edited by anish 22-06-2006
				$html="$s1s<b>$name</b>$s1e<br>";//edited by anish 01-07-2006 to remove link
				$html.="$s2s{$street}<br>";
				$html.="{$db_row[city]}, {$db_row[state]} $s2e<br>";
				//edited by anish to make camera image live 22-07-2006
				$html.="<span><img src=\"$url2\" width=\"322\" height=\"210\"></span><br>";
			}else{
				$html="$s1s<b><a href=\"{$db_row[urldetails]}\">$name</a></b>$s1e<br>";
				$html.="$s2s{$street}<br>";
				$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e<br>";
				$html.="<img src=\"admin/mapimages/$image\" width=\"120\" height=\"80\"><br>";
		
			}
        	/*$html="$s1s<b><a href=\"{$db_row[urldetails]}\">$name</a></b>$s1e<br>";
        	$html.="$s2s{$street}<br>";
        	$html.="$city, {$db_row[state]} {$db_row[zip]}$s2e<br>";
        	$html.="<img src=\"admin/mapimages/$image\" width=\"120\" height=\"80\"><br>";*/
        	//Schogini: Edited by anish on 02-02-06 to display business details on rightside
            $htmlside.="$s1s<b><a href=\"{$db_row[urldetails]}\">$name</a></b>$s1e<br>";
        	$htmlside.="$s2s{$street}<br>";
        	$htmlside.="$city, {$db_row[state]} {$db_row[zip]}$s2e<br>";
		
		
		if(isset($db_row[description])&&trim($db_row[description])!=""){
			if($thisType=="Traffic-Camera"){
			$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
			//$new_desc=substr($new_desc,0,20)."..";
            //$new_desc=split_to_lines($new_desc,35);			
			$html.="$s2s{$new_desc}$s2e<br>";
			}else{
			$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
            //$new_desc=substr($new_desc,0,20)."..";
            $new_desc=split_to_lines($new_desc,30);
			$html.="$s2s{$new_desc}$s2e<br>";
			}
		}
		
			/*$new_desc=preg_replace("/\'/","\\'",$db_row[description]);
            //$new_desc=substr($new_desc,0,20)."..";
            $new_desc=split_to_lines($new_desc,35);*/
		
		
		    $desc="<span class=\"BusinessText\">$new_desc<br>"."</span>";
		
		
        	//if(isset($db_row[description])&&trim($db_row[description])!="")
        		//$html.=$desc;
        		//Schogini: Edited by anish on 02-02-06 to display business details on rightside
        		//$htmlside.="{$db_row[description]}<br>";
        		if(!empty($db_row[description])&&trim($db_row[description])!="")$htmlside.=$desc;
			if($thisType=="Visitor-Pass") {
        	$html.="$s3s<a href=\"{$db_row[urldetails]}\">Business Profile</a>$s3e&nbsp;";
			$htmlside.="$s3s<a href=\"{$db_row[urldetails]}\">Business Profile</a>$s3e&nbsp;";
			}elseif($thisType=="Traffic-Camera") {
        	//$html.="$s3s<a href=\"{$db_row[urldetails]}\">View Details</a>$s3e&nbsp;";
			//$htmlside.="$s3s<a href=\"{$db_row[urldetails]}\">View Details</a>$s3e&nbsp;";
			}else{
			$html.="$s3s<a href=\"{$db_row[urldetails]}\">View Details</a>$s3e&nbsp;";
			$htmlside.="$s3s<a href=\"{$db_row[urldetails]}\">View details</a>$s3e&nbsp;";
			}
			 
        	if(isset($db_row[urldetails2])&&trim($db_row[urldetails2])!=""){
				//Schogini: Edited by anish on 02-02-06 to display business details on rightside
				if($thisType!="Traffic-Camera") {
        	      $html.="-&nbsp;$s3s<a href=\"{$db_row[urldetails2]}\">$details</a>$s3e<br>";
  	              $htmlside.="&nbsp;$s3s<a href=\"{$db_row[urldetails2]}\">$details</a>$s3e<br>";
				}
            }

        	if(isset($db_row[longitude])&&isset($db_row[lattide])){
        		if(trim($db_row[longitude])!=""&&trim($db_row[lattide])!=""){
                    $xx=$db_row[longitude];
                    $yy=$db_row[lattide];
        		}else{
                  $html="Sorry, coordinates not found.";
                  #$xx="-80.224145";
                  #$yy="25.787676";
                }
        	}
        }else{
           $html="Sorry, record not found.";
        }
    }
}
//print "API: ".$api."<br>";
//Schogini: Edited by anish on 11-08-06 to display weather on rightside
$weather = new phpweather();
$data = $weather->decode_metar();
$type = 'pw_text_en';
$text = new $type($weather);
$icons = new pw_images($weather);
//echo $w['image']['url']."Anish";
$sign="°C";
$sign2="°F";
$sign=htmlentities($sign);
$sign2=htmlentities($sign2);
$tpl->assign("image1", $icons->get_sky_image());
$tpl->assign("image2", $icons->get_winddir_image());
$tpl->assign("image3", $icons->get_temp_image());
$tpl->assign("title1", $weather->get_location());
$tpl->assign("title2", $weather->get_location());
$tpl->assign("title3", $weather->get_location());
$tpl->assign("temp", $data['temperature']['temp_c'].$sign);
$tpl->assign("speed", $data['wind']['miles_per_hour']);
$tpl->assign("feel", $data['temperature']['temp_f'].$sign2);
$tpl->assign("dir", $data['wind']['deg']);
$tpl->assign("sky", $data['clouds'][0]['condition']);
$tpl->assign("types", $thisType);
$tpl->assign("api",$api);
$tpl->assign("hotelname",$name);
$tpl->assign("infohtml", "<div align=center><center>$html</center></div>");
//Schogini: Edited by anish on 02-02-06 to display business details on rightside
$tpl->assign("inforightside", "$htmlside");
$tpl->assign("long", $xx);
$tpl->assign("latt", $yy);
$tpl->display($template);
?>