<?

require_once PLUGINPATH . '/classes/love/shop/Shop.class.inc';
require_once PLUGINPATH . '/classes/love/shop/Area.class.inc';
require_once PLUGINPATH . '/classes/love/comn/BaseCommon.class.inc';
require_once PLUGINPATH . '/classes/love/comn/PageLink.class.inc';
require_once PLUGINPATH . '/classes/love/axlib/poi3.class.inc';
require_once PLUGINPATH . '/classes/love/city/City.class.inc';
require_once PLUGINPATH . '/classes/love/recommend/Recommend.class.inc';
require_once PLUGINPATH . '/classes/love/station/Station.class.inc';
require_once PLUGINPATH . '/classes/love/drive/Spot.class.inc';

$PLG_SHOP = new Shop();
$PLG_SHOP->setDb($DB);

$PLG_AREA = new Area();
$PLG_AREA->setDb($DB);

$PLG_CITY = new City();
$PLG_CITY->setDb($DB);

$PLG_STATION = new Station();
$PLG_STATION->setDb($DB);

$PLG_POI = new poi();

$PLG_COMMON = new BaseCommon();

$PLG_REC = new Recommend;
$PLG_REC->setDb($DB);

$PLG_DDSpot = new DDSpot($CON_DRIVE);
$PLG_DDSpot->connect('drive');

$line_code    = $CON_PRM->get('line_code');
$station_code = $CON_PRM->get('station_code');
if(!$line_code || !$station_code){
//	$CON_CONTENTS->error("駅を選択していません。","エラー",FALSE,"default","");
}

//緯度･経度
$lat = "";
$lat = $CON_PRM->get('lat');
$lon = "";
$lon = $CON_PRM->get('lon');
$lat_d = "";
$lat_d = $CON_PRM->get('lat_d');
$lon_d = "";
$lon_d = $CON_PRM->get('lon_d');
$pos	 = $CON_PRM->get('pos');

$AREACODE = "";
$AREACODE = $CON_PRM->get('AREACODE');//Docomoオープンエリアコード
$geo = $CON_PRM->get('geo');

//日時指定
if(isset($_REQUEST["dt"]) && $_REQUEST["dt"]!=""){
	//dtの指定があれば、過去や未来の表示が出来る
	$_dt = $_REQUEST["dt"];
	$now = substr($_dt, 0, 4)."-".substr($_dt, 4, 2)."-".substr($_dt, 6, 2)." ".substr($_dt, 8, 2).":".substr($_dt, 10, 2).":".substr($_dt, 12, 2);
}else{
	$now = date("Y-m-d H:i:s");
}
$nowdate = substr($now,0,10);
$nowtime = substr($now,11,5);

//探索範囲
if(!isset($radius) || !$radius){
	$radius = $df_radius_default;
}

$lat_d = "";
$lon_d = "";


/*
* 緯度・経度計算（GPS機能か iエリアから来た場合）
*/
//GPS情報
$PLG_GPS = new gps();
$PLG_KTAI = new Ktai();//携帯DB用クラス

if(((($lat && $lon) || $AREACODE) && !$lat_d && !$lon_d) || $pos) {
	// lat, lon取得処理→後で関数化
	$gps_datas  = array();

	if($CON_CLIENT->carrier == "DOCOMO"){
		if($PLG_KTAI->gps_support=='Y'){
			$minor = 'GPS2';
		}else{
			$minor = "OPENIAREA";
		}
//echo $minor;
		if($AREACODE){
			$data= array();
			$data  = GetCoordinatesArea($AREACODE);
			
			$gps_datas["iarea_lat_min"]	= $data["lat_min"]/3600000;
			$gps_datas["iarea_lat_max"]	= $data["lat_max"]/3600000;
			$gps_datas["iarea_lon_min"]	= $data["lon_min"]/3600000;
			$gps_datas["iarea_lon_max"]	= $data["lon_max"]/3600000;
	
			$data = GetAreaLocation($AREACODE);
			$gps_datas["iarea_lat"]	= hyper_dms2deg($data["lat_d"]);
			$gps_datas["iarea_lon"]	= hyper_dms2deg($data["lon_d"]);
			
			$lat_d = $gps_datas["iarea_lat"];
			$lon_d = $gps_datas["iarea_lon"];
		} else {
		// GPS 持ってるパラメータ：lat、lon、geo、x-acc

			$AREACODE = "GPS取得";
			$gps_datas	 = $PLG_GPS->GetKtaiLocationData($CON_CLIENT->carrier,$lat,$lon,"DEGREE",$minor,$geo);
//var_dump($gps_datas);
			$lat_d = $gps_datas["lat"];
			$lon_d = $gps_datas["lon"];
		}
	} else {
		if($PLG_KTAI->gps_support=='Y' || $PLG_KTAI->location_support=='Y'){
			$minor = 'GPS2';
		}
		$gps_datas	 = $PLG_GPS->GetKtaiLocationData($CON_CLIENT->carrier,$lat,$lon,"DEGREE",$minor,$geo);
		$lat_d = $gps_datas["lat"];
		$lon_d = $gps_datas["lon"];
	}
}

// Debugエディア（iエリア）
if($CON_CLIENT->carrier == "OTHER" && (!$lat_d || !$lon_d)){
	$lat_d = 35.695311111111;
	$lon_d = 139.76367222222;
}

if($line_code || $station_code){
	$where_station = "line_code=? and station_code=?";
	$val_station	 = array($line_code,$station_code);
	$list_station	 = $PLG_STATION->getSelectList('*', $where_station, 'station_sort',$val_station);

	$lat_d = $list_station[0]["lat_d"];
	$lon_d = $list_station[0]["lon_d"];
}

ob_start();
var_export($list_station);
$vals_str = ob_get_contents();
ob_end_clean();
$CON_CONTENTS->SaveDebugString("[駅情報]".$vals_str);

//スポット一覧
$where_all	 = "flg = '0' AND ( grid1 = '01' OR grid1 = '02')";
$where_look	 = "flg = '0' AND grid1 = '01'";
$where_enjoy = "flg = '0' AND grid1 = '02'";
$sql_col = "*";
$sort ="";

//$lat_d=35.6963970717;
//$lon_d=139.768127831;
$radius = 3;//Debug用

//緯度・経度
if($lat_d && $lon_d){
	list($lat2,$lat1,$lon2,$lon1) = LocationRenge($lat_d,$lon_d,$radius);
	$where_distance	 = " and lat_d between $lat1 and $lat2 and lon_d between $lon1 and $lon2";
	
	$sql_col .= ",floor((6371.003685*acos(cos($lat_d*pi()/180)*cos($lon_d*pi()/180)*cos(lat_d*pi()/180 )*";
	$sql_col .= "cos(lon_d*pi()/180)+cos($lat_d*pi()/180)*sin($lon_d*pi()/180)*cos(lat_d*pi()/180)*";
	$sql_col .= "sin(lon_d*pi()/180)+sin($lat_d*pi()/180)*sin(lat_d*pi()/180)))*1000) as distance ";
	if(!$sort){
		$orderby = 'distance';
	}
	$where_all	 .= $where_distance;
	$where_look	 .= $where_distance;
	$where_enjoy .= $where_distance;
}

$count_all = $PLG_DDSpot->count($where_all, array());
$count_look = $PLG_DDSpot->count($where_look, array());
$count_enjoy = $PLG_DDSpot->count($where_enjoy, array());

ob_start();
var_export($list);
$vals_str = ob_get_contents();
ob_end_clean();
$CON_CONTENTS->SaveDebugString("[レジャースポット一覧]".$vals_str);

// Recommend
$position = 'search_1';
$rec_info_s = $PLG_REC->getRecommendNowAll($position);

include './jb/common/gps.model.inc';

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja">
<head>
<style type="text/css">
		<!--
		A:link { color: #104e83; }
		A:visited { color: #964338; }
		A:active { color: #fbf7de; }
		-->
		</style>
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS" />
<meta http-equiv="Cache-Control" content="no-cache" />
<META NAME="GOOGLEBOT" CONTENT="NOARCHIVE">
<META NAME="ROBOTS" CONTENT="NOARCHIVE">
<meta name="vnd.up.bookmark" wml:forua="true" content="http://love.edia.ne.jp" />
<meta name="keywords" content="レジャースポット,ラブホナビ,ラブホ,カラオケ,タウン,周辺,口コミ,ランキング,オススメ" />
<meta name="description" content="レジャースポット/ラブホナビ、口コミ、ランキング情報も!" />

<title>レジャースポット/ラブホナビ</title>
</head>
<body style="color:#7d650a;background-color:#fbf7de;">
<table width="100%" height="100%">
	<tr>
		<td style="background-color:#000000;color:#FFFFFF;text-align:center;font-weight:bold;">XHTML版</td>
		<td bgcolor="#CCCCCC" nowrap width = "2" valign="TOP"></td>
		<td style="background-color:#000000;color:#FFFFFF;text-align:center;font-weight:bold;">HTML版</td>
		<td bgcolor="#CCCCCC" nowrap width = "2" valign="TOP"></td>
		<td style="background-color:#000000;color:#FFFFFF;text-align:center;font-weight:bold;">DebugString</td>
	</tr>
	<tr>
		<td width = "240"  nowrap valign="TOP">
<!-- XHTML -------------------------------------------------------->
<div style="text-align:right;">
<font style="font-size: x-small;">ラブホ・クチコミ情報なら</font><br />
<a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&"><img src="/img/logo_small.gif" alt="ラブホナビ"></a><br />
<a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=column-view&gpid=21&pgid=1"><font style="font-size: x-small;">サイトマップへ</font></a><br />
</div>
<a name="TOP" id="TOP"></a>
<div style="background-color:#C74839">
<span style="color:#FBF7DE">レジャースポット</span><br />
</div>
<br />
<b>Warning</b>:  Undefined variable $line_code in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>14</b><br />
<br />
<b>Warning</b>:  Undefined variable $station_code in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>14</b><br />
<span style="font-size:x-small;">現在地から</span><br />
<br />
<b>Warning</b>:  Undefined variable $count_all in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>20</b><br />
<span style="font-size:x-small;">件のスポットが見つかりました。</span><br />
<br />
<br />
<b>Warning</b>:  Undefined variable $count_look in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>22</b><br />
<br />
<b>Warning</b>:  Undefined variable $count_enjoy in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>26</b><br />
<br />
<a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=drive_spot-top"><span style="font-size:x-small;">レジャースポットTOPへ</span></a><br />
<img src="/img/search_hotel_banner.gif" alt="ラブホテル,ラブホ,デートスポット,女子会,レジャー,ファッション"><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/new.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-newlist"><span style="font-size:x-small;">最新のおすすめラブホテル</span></a><br />
<br />
<b>Warning</b>:  Undefined variable $gps_fg in <b>/opt/loveho/web/jb/common/menushop.view.inc</b> on line <b>20</b><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/train.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=station-arealist"><span style="font-size:x-small;">駅近くのホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/car_sedan.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=ic-arealist"><span style="font-size:x-small;">IC近くのホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/house.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-arealist"><span style="font-size:x-small;">住所でラブホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/clover.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-taste"><span style="font-size:x-small;">特徴でラブホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737">∟</span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=column-view&gpid=31&pgid=1"><span style="font-size:x-small;">ホテル掲載依頼</span></a><br />
<br />
<div style="text-align:center">
<form method="GET" action="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&">
<input type="hidden" name="jb" value="search-freeword">
<input type="radio" name="stype" value="kword" checked>
<span style="font-size:x-small;">キーワード</span><input type="radio" name="stype" value="station">
<span style="font-size:x-small;">駅名</span><br />
<input type="text" name="freeword" size=15><input type="submit" value="検索"></form></div>
<div style="text-align:center;background-color:#BAD4D1">
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/secret.gif"></span><span style="font-size:x-small;">ショートカット</span><br />
</div>
<div style="background-color:#D9E6D7">
<span style="font-size:x-small;"><img src = "./img/emoji/i/0.gif">ラブホナビTOPへ</span><br />
</div>
<br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/0.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&" accesskey=0><span style="font-size:x-small;">ラブホナビTOPへ戻る</span></a><br />

<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/soon.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=column-view&gpid=21&pgid=1"><span style="font-size:x-small;">サイトマップへ</span></a><br />

<div style="text-align:center">
<img src="./img/copyright2009.gif" alt="Edia NAVIGATION FOR YOUR LIFE Copyright 2009"></div>

<!-------------------------------------------------------- XHTML -->
		</td>
		<td bgcolor="#CCCCCC" nowrap width = "1" valign="TOP"></td>
		<td nowrap width = "240" valign="TOP">
<!-- HTML --------------------------------------------------------->
<a name="TOP" id="TOP"></a>
<span style="">レジャースポット</span><br />
<hr />
<br />
<b>Warning</b>:  Undefined variable $line_code in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>14</b><br />
<br />
<b>Warning</b>:  Undefined variable $station_code in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>14</b><br />
<span style="font-size:x-small;">現在地から</span><br />
<br />
<b>Warning</b>:  Undefined variable $count_all in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>20</b><br />
<span style="font-size:x-small;">件のスポットが見つかりました。</span><br />
<br />
<br />
<b>Warning</b>:  Undefined variable $count_look in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>22</b><br />
<br />
<b>Warning</b>:  Undefined variable $count_enjoy in <b>/opt/loveho/web/jb/drive_spot/genre_list.view.inc</b> on line <b>26</b><br />
<br />
<a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=drive_spot-top"><span style="font-size:x-small;">レジャースポットTOPへ</span></a><br />
<img src="/img/search_hotel_banner.gif" alt="ラブホテル,ラブホ,デートスポット,女子会,レジャー,ファッション"><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/new.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-newlist"><span style="font-size:x-small;">最新のおすすめラブホテル</span></a><br />
<br />
<b>Warning</b>:  Undefined variable $gps_fg in <b>/opt/loveho/web/jb/common/menushop.view.inc</b> on line <b>20</b><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/train.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=station-arealist"><span style="font-size:x-small;">駅近くのホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/car_sedan.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=ic-arealist"><span style="font-size:x-small;">IC近くのホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/house.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-arealist"><span style="font-size:x-small;">住所でラブホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/clover.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=search-taste"><span style="font-size:x-small;">特徴でラブホテルを検索</span></a><br />
<span style="font-size:x-small;color:#c94737">∟</span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=column-view&gpid=31&pgid=1"><span style="font-size:x-small;">ホテル掲載依頼</span></a><br />
<br />
<div style="text-align:center">
<form method="GET" action="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&">
<input type="hidden" name="jb" value="search-freeword">
<input type="radio" name="stype" value="kword" checked>
<span style="font-size:x-small;">キーワード</span><input type="radio" name="stype" value="station">
<span style="font-size:x-small;">駅名</span><br />
<input type="text" name="freeword" size=15><input type="submit" value="検索"></form></div>
<div style="text-align:center;">
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/secret.gif"></span><span style="font-size:x-small;">ショートカット</span><br />
</div>
<span style="font-size:x-small;"><img src = "./img/emoji/i/0.gif">ラブホナビTOPへ</span><br />
<br />
<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/0.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&" accesskey=0><span style="font-size:x-small;">ラブホナビTOPへ戻る</span></a><br />

<span style="font-size:x-small;color:#c94737"><img src = "./img/emoji/i/soon.gif"></span><a href="/index.php?ses_id=3f3d7ac93b87403d5477fd44e2a64313&jb=column-view&gpid=21&pgid=1"><span style="font-size:x-small;">サイトマップへ</span></a><br />

<div style="text-align:center">
<img src="./img/copyright2009.gif" alt="Edia NAVIGATION FOR YOUR LIFE Copyright 2009"></div>

<!--------------------------------------------------------- HTML -->
		</td>
		<td bgcolor="#CCCCCC" nowrap width = "1" valign="TOP"></td>
		<td nowrap height="100%" valign="TOP">
<textarea style="width:100%;height:100%" wrap="off" >
RELEASE_300:1
IS_MEM:
IS_MEM2:1
SESSION_ID:3f3d7ac93b87403d5477fd44e2a64313
http://weblog.edia.ne.jp/index0001.php?jb=drive_spot-genre_list&uid=EDIA_TESTUID&car=OTHER&mtype=m1&kword=&kdomain=&server=love.edia.ne.jp&script=/index.php


■■■PROCESS_FLOW■■■
/index.php
./exec/default.exec.inc
./jb/drive_spot/genre_list.model.inc
./jb/drive_spot/genre_list.view.inc

</textarea>
		</td>
	</tr>
</table>
</body>
</html>