__HTML;
require_once("../lib_data/side.php");
Side_sch();
if($type){
require_once("all/$type.php");
Side_narrow();
}
///-----------------------------------------------------------------------------
/// ▼検索部分
///-----------------------------------------------------------------------------
$where_d = array();
$where_m= array();
$where_t= array();
//価格
if($cate == "1" or $cate == "2" or $cate == "3"){
if($s01){array_push($where_d,"(a80 >= $s01) ");}
if($s02){array_push($where_d,"(a80 < $s02) ");}
}else{
/*
if($s01){array_push($where_d,"(a351 >= $s01 and (a376!=2)) ");}
if($s02){array_push($where_d,"(a351 < $s02 and (a376!=2)) ");}
*/
if($s01){array_push($where_d,"(a351 >= $s01) ");}
if($s02){array_push($where_d,"(a351 < $s02) ");}
}
//部屋タイプ
if($s10=="1ルーム"){array_push($where_m,"(a184 ='ワンルーム') ");}
if($s11=="1K"){array_push($where_m,"(a183 = '1' and a184 ='K') ");}
if($s12=="1DK"){array_push($where_m,"(a183 = '1' and a184 ='DK') ");}
if($s13=="1LDK"){array_push($where_m,"(a183 = '1' and a184 ='LDK') ");}
if($s14=="2K"){array_push($where_m,"(a183 = '2' and a184 ='K') ");}
if($s15=="2DK"){array_push($where_m,"(a183 = '2' and a184 ='DK') ");}
if($s16=="2LDK"){array_push($where_m,"(a183 = '2' and a184 ='LDK') ");}
if($s17=="3DK"){array_push($where_m,"(a183 = '3' and a184 ='DK') ");}
if($s18=="3LDK"){array_push($where_m,"(a183 = '3' and a184 ='LDK') ");}
if($s19=="4DK"){array_push($where_m,"(a183 = '4' and a184 ='DK') ");}
if($s20=="4LDK"){array_push($where_m,"(a183 = '4' and a184 ='LDK') ");}
if($s21=="5DK以上"){array_push($where_m,"(a183 >= '5') ");}
//専有面積・床面積
if($cate == "1" or $cate == "4"){
if($s03){array_push($where_d,"(a115 >= $s03) ");}
if($s04){array_push($where_d,"(a115 < $s04) ");}
}elseif($cate == "2" or $cate == "5"){
if($s03){array_push($where_d,"(a115 >= $s03) ");}
if($s04){array_push($where_d,"(a115 < $s04) ");}
}elseif($cate == "3" or $cate == "6"){
if($s03){array_push($where_d,"(a110 >= $s03) ");}
if($s04){array_push($where_d,"(a110 < $s04) ");}
}
//分数
if($s05){array_push($where_d,"(a34 <= $s05 and a34 != '') ");}
//築年
if ($s06){
$year_d = date(Y) - $s06;
array_push($where_d, "a135 >= '$year_d' ");
}
//エリア
if (count($s50)){
foreach ( $s50 as $value ){
array_push($where_t, "a05 like '%\_{$value}\_%' ");
}
if(!count($where_t)){$where_tt="";}else{$where_tt = "and (".join("or ",$where_t).")";}
}
//小学校学区
if ($s317){
array_push($where_d, "a317 = '$s317' ");
// $where_ss = "and a317 = '$s317' ";
}
//print $s317."----------" ;
//中学校学区
if ($s320){
//$where_sc = "and a320 = '$s320' ";
array_push($where_d, "a320 = '$s320' ");
}
//路線
if ($s60){
foreach ( $s60 as $value ){
array_push($where_t, "a31 = '$value' or a41 = '$value' or a51 = '$value' ");
}
if(!count($where_t)){$where_tt="";}else{$where_tt = "and (".join("or ",$where_t).")";}
}
//テーマ
if($theme){
$theme_bar="\_".$theme."\_";
array_push($where_d, "a139 like '%$theme_bar%' ");
}
print<<<__HTML
{$sch_title}で探す
$theme_btn
$theme_name
__HTML;
///-----------------------------------------------------------------------------
/// SQL条件
///-----------------------------------------------------------------------------
//print $cate;
if($s07==1){
//価格高い順
if($cate==1 or $cate==2 or $cate==3){
$where_by="order by CAST(a80 AS UNSIGNED) desc";
}else{
$where_by="order by a376 , CAST(a351 AS UNSIGNED) desc";
}
}elseif($s07==2){
//更新新しい順
$where_by="order by a429 desc";
}elseif($s07==3){
//更新古い順
$where_by="order by a429";
}else{
//安い順
if($cate==1 or $cate==2 or $cate==3){
$where_by="order by CAST(a80 AS UNSIGNED)";
}else{
$where_by="order by a02,CAST(a80 AS UNSIGNED),CAST(a351 AS UNSIGNED)";
}
}
if($_SESSION['mem_login']==1){
$hp_koukai = " (a238='1' or a238='2') ";
}else{
$hp_koukai = " (a238='1') ";
}
//HP表示(a238)が可かどうか//成約済(a70)などではないもの
//$where_ka = "$hp_display a70 !='169' $hp_koukai $cate_d ";
$where_ka = "$hp_display $hp_koukai $cate_d ";
//print $where_ka;
if(!count($where_d) and !count($where_m)){
$where="where ".$where_ka;
}elseif(count($where_d)and !count($where_m)){
$where = "where ".$where_ka." and ".join("and ",$where_d);
}elseif(count($where_m)and !count($where_d)){
$where = "where ".$where_ka." and (".join("or ",$where_m).")";
}else{
$where = "where ".$where_ka." and ".join("and ",$where_d)."and (";
$where .=join("or ",$where_m).")";
}
///-----------------------------------------------------------------------------
/// ▼エリアごとまたはテーマ
///-----------------------------------------------------------------------------
if($area or $theme or (!$area and !$theme and !$train)){
//$group_by="group by a06,a07,a08";
//エリア条件
$where_area = "where a02 != 'test'";
$order_area = " order by a03";
$sql = "select * from M_AREA $where_area $order_area";
//print $sql."
";
$res =mysql_query("$sql") or die("SQL失敗123");
//if($cate){
print <<<__HTML
$area_sub
__HTML;
//処理
$tr = 1;
//を埋める処理
$count = "select * from M_AREA $where_area";
$res_count =mysql_query("$count") or die("SQL失敗");
$log_count = mysql_num_rows($res_count);
if($log_count%3==1){$td=" ";}
elseif($log_count%3==2){$td=" ";}else{$td="";}
while($list = mysql_fetch_array($res)){
//同一エリアの件数
$area_no = "'%\_$list[0]\_%'";
$sql_kensu = "select * from D_BUKKEN $where and a05 like $area_no";
$res_kensu =mysql_query("$sql_kensu") or die("SQL失敗345");
$log_kensu = mysql_num_rows($res_kensu);
//学区表示のための配列作成
$sc_area_no = $list[0];
while($list_sc_area = mysql_fetch_array($res_kensu)){
$sc_area_data[] = $sc_area_no;
}
if($log_kensu){
$kensu_class = "";
}else{
$kensu_class="gr_999";
}
//処理
if($tr%3==1){$tr_a=" ";}else{$tr_a="";}
if($tr%3==0 and $log_count%3!=0){$tr_b=" ";}else{$tr_b="";}
$select_array = array("$list[0]"=>"$list[2]");
$s50_s = check_data_key2($select_array,$s50,"s50[]");
print $tr_a ;
print<<<__HTML
{$s50_s}({$log_kensu}件)
__HTML;
print $tr_b ;
$tr++;
}
print $td ;
print "
";
//}//if($cate){の閉じ
//////// 学区 ////////
if(count($s50)){
$area_0 = '
選択なし ';
foreach ( $s50 as $value ){
$value="\_".$value."\_";
$sql = "select * from M_SCHOOL where a03='1' and a04 like '%$value%' order by CAST(a05 AS UNSIGNED)";
$res =mysql_query("$sql") or error("SQL失敗");
while($list = mysql_fetch_array($res)){
if($list[2]){
if($s317==$list[0]){
$op.=<<<__HTML
$list[2]
__HTML;
}else{
$op.=<<<__HTML
$list[2]
__HTML;
}
}
}
$sql = "select * from M_SCHOOL where a03='2' and a04 like '%$value%' order by CAST(a05 AS UNSIGNED)";
$res =mysql_query("$sql") or error("SQL失敗");
while($list = mysql_fetch_array($res)){
if($list[2]){
if($s320==$list[0]){
$opc.=<<<__HTML
$list[2]
__HTML;
}else{
$opc.=<<<__HTML
$list[2]
__HTML;
}
}
}
}
}else{
$area_0 = '
エリアを選択して下さい ';
}
//if($cate){
print<<<__HTML
小学校
$area_0$op
中学校
$area_0$opc
__HTML;
//}
}
///-----------------------------------------------------------------------------
/// ▲エリアごとまたはテーマ
///-----------------------------------------------------------------------------
///-----------------------------------------------------------------------------
/// ▼路線ごとまたはテーマ
///-----------------------------------------------------------------------------
if($train or $theme){
print <<<__HTML
$train_sub
__HTML;
$group_by="group by a31,a41,a51";
$order_train = " order by a03";
$sql = "select * from M_TRAFFIC $order_train";
$res =mysql_query("$sql") or die("SQL失敗");
//処理
$tr = 1;
//を埋める処理
$sql_rosen = "select * from D_BUKKEN $where and (a31 != '' or a41 != '' or a51 != '') $group_by";
$res_rosen =mysql_query("$sql_rosen") or die("SQL失敗");
//同一路線の件数
while($list = mysql_fetch_array($res)){
$sql_count = "select * from D_BUKKEN $where and (a31 = '$list[0]' or a41 = '$list[0]' or a51 = '$list[0]')";
$res_count =mysql_query("$sql_count") or die("SQL失敗");
$log_count = mysql_num_rows($res_count);
if($log_count){
if($tr%3==1){$td=" ";}
elseif($tr%3==2){$td=" ";}else{$td="";}
//処理
if($tr%3==1){$tr_a=" ";}else{$tr_a="";}
if($tr%3==0 and $log_count%3!=0){$tr_b=" ";}else{$tr_b="";}
$select_array = array("$list[0]"=>"$list[2]");
$s60_s = check_data_key2($select_array,$s60,"s60[]");
print $tr_a;
print<<<__HTML
{$s60_s}({$log_count}件)
__HTML;
print $tr_b;
$tr++;
}
}
print $td;
print "
";
}
///-----------------------------------------------------------------------------
/// ▲路線ごとまたはテーマ
///-----------------------------------------------------------------------------
//if($cate){
print<<<__HTML
全ての条件をクリアする
$hidden
__HTML;
//}
///-----------------------------------------------------------------------------
/// 件数表示処理
///-----------------------------------------------------------------------------
$kensu = 15;
$g_array = array();
foreach($_GET as $key => $value){
if($key != "start" and !is_array($value)){
$value = urlencode($value);
$g_data = "$key=$value";
array_push($g_array,$g_data);
}else{
if(is_array($value)){
foreach ( $value as $val_d ){
$g_data = "{$key}%5B%5D=$val_d";
array_push($g_array,$g_data);
}
}
}
}
$g_str = join("&",$g_array);
///-----------------------------------------------------------------------------
/// 条件と上の件数表示
///-----------------------------------------------------------------------------
$sql = "select * from D_BUKKEN $where $where_tt $where_ss $where_sc $where_by ";
$res =mysql_query("$sql") or die("SQL失敗");
$log_size = mysql_num_rows($res);
prev_next($log_size,$kensu,$start,$myself,$g_str);
///-----------------------------------------------------------------------------
/// 物件のSQL
///-----------------------------------------------------------------------------
$sql = "select * from D_BUKKEN $where $where_tt $where_ss $where_sc $where_by limit $start,$kensu ";
//print $sql;
$res =mysql_query("$sql") or die("SQL失敗");
$map_ok_kensu=0;
while($list = mysql_fetch_array($res)){
//地図データ
if($list[311] and $list[312] and $list[12]==1){
$map_ok_kensu++;
if($list[2]==11){$cate=1;}
elseif($list[2]==12){$cate=2;}
elseif($list[2]==13){$cate=3;}
elseif($list[2]==21){$cate=4;}
elseif($list[2]==22){$cate=5;}
elseif($list[2]==23){$cate=6;}
//画像1
$photo_file1="../sch_h/img/$list[0]_1_s.jpg";//外観
$photo_file6="../sch_h/img/$list[0]_6_s.jpg";//間取り
if(is_file($photo_file1)){
$size = image_resize("100","100",$photo_file1);
$photo1=<<<__HTML
__HTML;
}elseif(!is_file($photo_file1) and is_file($photo_file6)){
$size = image_resize("100","100",$photo_file6);
$photo1=<<<__HTML
__HTML;
}else{
$photo1=<<<__HTML
__HTML;
}
if($cate == 1 or $list[2]=="11"){
//売買戸建て
$type_name= "
";
$bukken_title="$list[6]$list[7]$list[8]";
if($list[183] or $list[184]){$map_madori="
間取り:$list[183]{$list[184]}
";}
}
elseif($cate ==2 or $list[2]=="12"){
//売買マンション
$type_name= "
";
$bukken_title="$list[15]";
$man_add="
$list[6]$list[7]$list[8]
";
if($list[183] or $list[184]){$map_madori="
間取り:$list[183]{$list[184]}
";}
}
elseif($cate ==3 or $list[2]=="13"){
//売買土地
$type_name= "
";
$bukken_title="$list[6]$list[7]$list[8]";
if($list[110]){
$totimenseki_tsubo = $list[110]/3.30579;
$totimenseki_tsubo = sprintf("%01.2f",$totimenseki_tsubo);
$totimenseki="(".$totimenseki_tsubo." 坪)";
$map_madori="
土地面積:{$list[110]}㎡{$totimenseki}
";}
}
elseif($cate ==4 or $list[2]=="21"){
//賃貸戸建て
$type_name= "
";
$bukken_title="$list[6]$list[7]$list[8]";
if($list[183] or $list[184]){$map_madori="
間取り:$list[183]{$list[184]}
";}
}
elseif($cate ==5 or $list[2]=="22"){
//賃貸マンション
$type_name= "
";
$bukken_title="$list[15]";
$man_add="
$list[6]$list[7]$list[8]
";
if($list[183] or $list[184]){$map_madori="
間取り:$list[183]{$list[184]}
";}
}
elseif($cate ==6 or $list[2]=="23"){
//賃貸土地
$type_name= "
";
$bukken_title="$list[6]$list[7]$list[8]";
if($list[110]){
$totimenseki_tsubo = $list[110]/3.30579;
$totimenseki_tsubo = sprintf("%01.2f",$totimenseki_tsubo);
$totimenseki="(".$totimenseki_tsubo." 坪)";
$map_madori="
土地面積:{$list[110]}㎡{$totimenseki}
";}
}
//iPad判断小数点4桁または6桁に
if($isiPad and ($isiPad_os3 or $isiPad_os4)){
$map311=number_format($list[311],4);
$map312=number_format($list[312],4);
}elseif($isiPad and (!$isiPad_os3 and !$isiPad_os4)){
$map311=number_format($list[311],6);
$map312=number_format($list[312],6);
}else{
$map311=$list[311];
$map312=$list[312];
}
$map_data.=<<<__HTML
$type_name
$man_add
$photo1
お問い合わせNo:$list[1]
$kotsu01
$map_madori
{$map311},{$map312}
__HTML;
}
}
///緯度経度がひとつもない時
if(!$map_data){
//会社情報
$sql_com = "select * from M_COMPANY";
$res_com =mysql_query("$sql_com") or die("SQL失敗1");
$list_com = mysql_fetch_array($res_com);
$map_data.="";
}
//資料請求リストへ1
if($list_com[71]==2 or ($list_com[71]==3 and $_SESSION['mem_login']==1)){
$to_list=<<<__HTML
資料請求リストへ
__HTML;
}
if (!$log_size){
print <<<__HTML
条件に該当する物件が見つかりませんでした。検索条件を変えて再度検索してみて下さい。
__HTML;
}
if ($map_ok_kensu){
$map_ok_kensu_txt =<<<__HTML
(地図情報表示可能物件は{$map_ok_kensu}件)
__HTML;
}
if($map_data){
print<<<__HTML
該当物件の$log_size 件中 $start_list_num 件 ~ $end_list_num 物件を表示しています。$map_ok_kensu_txt
緯度経度情報等の誤差により、実際の場所と異なる場合があります。
$to_list
__HTML;
}
if($log_size){
print<<<__HTML
$all_list
$prev_link $num_list $start_link
__HTML;
///-----------------------------------------------------------------------------
/// 物件のSQL
///-----------------------------------------------------------------------------
$sql = "select * from D_BUKKEN $where $where_tt $where_ss $where_sc $where_by limit $start,$kensu ";
//print $sql;
$res =mysql_query("$sql") or die("SQL失敗");
//マーカーの数字
$ii=1;
while($list = mysql_fetch_array($res)){
//print_r ($list) ;
if($list[2]==11){$cate=1;}
elseif($list[2]==12){$cate=2;}
elseif($list[2]==13){$cate=3;}
elseif($list[2]==21){$cate=4;}
elseif($list[2]==22){$cate=5;}
elseif($list[2]==23){$cate=6;}
$b_list_id = "b_j_list_".$list[0];
if($_SESSION[$b_list_id]){
$s_list_img = '../sch/images/btn_get_data_list_f2.jpg';
$b_list_fn = "sch_listBtn_on";
}else{
$s_list_img = '../sch/images/btn_get_data_list.jpg';
$b_list_fn = "sch_listBtn";
}
//画像1
$photo_file1="../sch_h/img/$list[0]_1_s.jpg";//外観
$photo_file6="../sch_h/img/$list[0]_6_s.jpg";//間取り
if(is_file($photo_file1)){
$size = image_resize("100","100",$photo_file1);
$photo1=<<<__HTML
__HTML;
}elseif(!is_file($photo_file1) and is_file($photo_file6)){
$size = image_resize("100","100",$photo_file6);
$photo1=<<<__HTML
__HTML;
}else{
$photo1=<<<__HTML
__HTML;
}
//オススメテーマアイコン
$cate_theme = array();
$cate_theme_str = str_replace("_","",$list[139]);
$cate_theme = split("/",$cate_theme_str);
//カテゴリーの表示順並べ替え
$cate_theme_num = array();
$i = 0;
foreach ( $cate_theme as $num_value ){
$sql_category_num = "select * from M_CATEGORY where a00 = '$num_value' ";
$res_category_num =mysql_query("$sql_category_num") or die("SQL失敗1");
$list_category_num = mysql_fetch_array($res_category_num);
//$num_keyに$list_category_num[6]を格納。
//keyの値が重複すると新しいものに書き換えられてしまうので、「.x」を追加して小数点以下を追加。
//小数点以下の値はカウントアップする$i
$num_key = $list_category_num[6].".".$i;
$cate_theme_num[$num_key] = $num_value;
//小数点以下カウントアップ
$i++;
}
//a06の表示順(と小数点以下)で配列をソート
ksort($cate_theme_num);
// print_r($cate_theme_num);
$theme_icon = "";
foreach ( $cate_theme_num as $value ){
$theme_icon_data="../user_data/theme_img/{$value}_2_s.jpg"; //テーマアイコン
if(is_file($theme_icon_data)){
//カテゴリー名の取得
$sql_category_s = "select * from M_CATEGORY where a00 = '$value' ";
$res_category_s =mysql_query("$sql_category_s") or die("SQL失敗1");
$list_category_s = mysql_fetch_array($res_category_s);
$size = image_resize("30","30",$theme_icon_data);
$theme_icon .=<<<__HTML
__HTML;
}
}
//会員物件
if($list[238] == 2){
$mem_bukken ="
< 会員物件 > ";
}else{
$mem_bukken = "";
}
if($cate == 1){$type_name= "
";} //売買戸建て
elseif($cate ==4){$type_name= "
";} //賃貸戸建て
elseif($cate ==2){$type_name= "
";} //売買マンション
elseif($cate ==5){$type_name= "
";} //賃貸マンション
elseif($cate ==3){$type_name= "
";} //売買土地
elseif($cate ==6){$type_name= "
";} //賃貸土地
//資料請求リストへ2
if($list_com[71]==2 or ($list_com[71]==3 and $_SESSION['mem_login']==1)){
$to_list2=<<<__HTML
__HTML;
}
//マンション名
if($list[15] or $list[16]){
$mansion_name =<<<__HTML
{$list[15]} $list[16]
__HTML;
}else{
$mansion_name = "";
}
//地図があるかどうか
if($map_ok_kensu and ($list[311] and $list[312] and $list[12]==1)){
$map_marker=<<<__HTML
__HTML;
$ii++;
}else{
$map_marker="";
}
print <<<__HTML
$list[502] {$type_name}【お問い合せNo:{$list[1]}】 $mansion_name$mem_bukken
$theme_icon
$photo1
$map_marker
詳細を見る
$to_list2
__HTML;
Bukken_table();
}
}
//▲while終了
///////////////////////////////////////////////////////
//下の件数表示
///////////////////////////////////////////////////////
if ( $log_size ){
print <<<__HTML
$all_list
$prev_link $num_list $start_link
__HTML;
}
print <<<__HTML
$to_list