/*********************************************************************
REAL121 携帯サイト お気に入り一覧 Rainbowsoft S.Yabuta 2008/07/25
セッション変数:
SELECT_ROOM :部屋コード配列
*/
include_once("config.php");
include_once("libraries/common.php");
include_once("mobile_common.php");
/*------------------------------------------------------------------*/
//unset($_SESSION['SELECT_ROOM']);
/*
echo "
";
var_dump($_SESSION);
echo "
";
var_dump($_REQUEST);
echo "
";
*/
mobileHTMLHeader("横浜賃貸ナビmobile","VALOR 横浜賃貸ナビ");
if($_REQUEST['BOX']=='DELETE'){
delete($_REQUEST['ROOMCODE']);
} else {
main();
}
mobileHTMLFooter();
/*********************************************************************
* メイン
*/
function main() {
global $conn;
$MobileClass = new MobileClass();
if(!isset($_SESSION['SELECT_ROOM']) or (count($_SESSION['SELECT_ROOM']) == 0)){
echo "";
echo "お気に入りまだ未登録です。
";
echo "TOPへ";
echo "
";
mobileHTMLFooter();
exit;
}
//--------------------------------------------
// 担当店
$sname=array();
readShop($sname);
readROOM($_SESSION['SELECT_ROOM'],$roomData);
echo "";
foreach($roomData as $RDATA){
$v1 = ConvSjis($RDATA['railway_name1']) ."・". ConvSjis($RDATA['station_name1']) . "駅";
$v2 = "徒歩" . $RDATA['station_time1']."分";
if($RDATA['bus_stop_name1']<>""){
$v2 = "バス";
}
$v3 = $RDATA['rent']/10000;
$v4 = $RDATA['monopolize_area'];
$object = sprintf("%s 最寄駅:%s %s/賃料:%.1f万円 /建物専有面積 %.2fm2 \n",$MobileClass->Convert('F8C4'),$v1,$v2,$v3,$v4);
$SHOPCD = $RDATA['branch_charge'];
$ShopNM = $sname[$SHOPCD];
$ShopNB = $RDATA['num'];
echo $object."(".$ShopNM.")";
echo " [詳細] ";
echo "[削除]";
echo "
";
}
// 部屋情報の配列をURL文字に
$ROOMS = '';
foreach($_SESSION['SELECT_ROOM'] as $idx => $val){
$ROOMS .= "&ROOMCODE[" . $idx . "]=" . $val;
}
$ROOMS = ereg_replace('^&','',$ROOMS);
echo "" . $MobileClass->Convert('F8F3') . "";
echo "お問合せ
";
echo "" . $MobileClass->Convert('F8D9') . "";
echo "トップへ戻る";
echo "";
}
/*********************************************************************
* お気に入りの1件削除
*/
function delete($roomCode) {
$del=array_keys($_SESSION['SELECT_ROOM'],$roomCode);
unset($_SESSION['SELECT_ROOM'][$del[0]]);
header('Location: box_list.php');
}
/*********************************************************************
* 部屋情報の読み込み
部屋のシステムコードを1個か配列で呼ぶと部屋情報を配列で返す
*/
function readROOM($roomCodes,&$roomData) {
$DB = NewADOConnection(DB_TYPE);
$DB->pconnect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$DB) die("DB接続に失敗しました");
//var_dump($roomCodes);
if(is_array($roomCodes)){
$whereIn = join(",",$roomCodes);
} else {
$whereIn = $roomCodes;
}
$sql = <<< EOS
select r.code,o.railway_name1,o.station_name1,o.station_time1,o.bus_stop_name1,o.bus_stop_time1,
r.rent,r.monopolize_area,r.branch_charge,o.num
from r121_room as r,r121_object as o
where r.object_code=o.code
and o.visible_flg=1
and r.visible_flg=1
and r.code in( $whereIn )
EOS;
//echo "
$sql
";
//echo "
". $DB->RecordCount();
$roomData = $DB->GetAll($sql);
}
?>