<?

/* ----------------------------------------------------------------------------------------------------
   インポート
---------------------------------------------------------------------------------------------------- */
require_once("../_inc/project/param.php");
require_once("../_inc/global/lib.php");
require_once("../_inc/global/post.php");
require_once("../_inc/global/session.php");
require_once("../_inc/mysql/connect.php");


/* ----------------------------------------------------------------------------------------------------
   変数定義
---------------------------------------------------------------------------------------------------- */
$CK_LABEL = "shop_s";

$SHOP_S_LIMIT = 30;

/* ----------------------------------------------------------------------------------------------------
   実行処理
---------------------------------------------------------------------------------------------------- */
if ($_GET['dsp'] == "list") {
	$_SESSION[$SES_LABEL]['dsp'] = "list";
} else {
	$_SESSION[$SES_LABEL]['dsp'] = "thumb";
}

if (!is_numeric($_GET['p'])) $_GET['p'] = 0;

$table = " from ({$TABLE_ID}_apaman_room room left join {$TABLE_ID}_apaman_build build on room.amb_id = build.amb_id) left join {$TABLE_ID}_apaman_condition cond on room.amr_id = cond.amr_id";
$order = " order by cast(amb_city as signed), amr_upddate desc, room.amr_id desc";
$limit = " limit ".$_GET['p']*$SHOP_S_LIMIT.",{$SHOP_S_LIMIT}";

if ($_SESSION[$SES_LABEL]['dsp'] == "list") {
	$param = "room.amr_id,room.amb_id,amr_buildno,amr_upddate,amr_recommend,amr_plan,amr_rent,amr_commonfee,amr_security,amr_repay,amr_keymoney,amr_img_main,amb_city,amb_address,amb_type,amb_railway1,amb_railway2,amc_1,amc_2,amc_3,amc_4,amc_5,amc_6,amc_7,amc_8,amc_9,amc_10";
} else {
	$param = "room.amr_id,room.amb_id,amr_buildno,amr_upddate,amr_recommend,amr_copy,amr_plan,amr_rent,amr_img_main,amb_city,amb_type,amc_1,amc_2,amc_3,amc_4,amc_5,amc_6,amc_7,amc_8,amc_9,amc_10";
}

$where = " where amr_public = '1' and amr_upddate <= '".date('Y;m;d')."' and (amr_upddate >= '".date("Y;m;d",strtotime("-1 week"))."' or amr_recommend = '1')";

if (is_numeric($_GET['shop'])) {
	$shopname = $SHOP_OBJ[$_GET['shop']];
	$where .= "and amr_shop like '%{$_GET['shop']}%'";
}

$sql = "select room.amr_id" . $table . $where . $order;
$rs = getDbResult($sql, "ショップ別最新おすすめ物件を取得できません。".$sql);

$total = mysql_num_rows($rs);

$sql = "select " . $param . $table . $where . $order . $limit;
$rs = getDbResult($sql, "ショップ別最新おすすめ物件を取得できません。".$sql);

// ページを表示
if ($_GET['dsp'] == "list") {
	include("_shop_s_list.php");
} else {
	include("_shop_s_thumb.php");
}

?>