0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} switch($_GET['public']){ case 1: $sqlupdate.=" f_public=1"; $public1=" selected"; break; /*case 2: $sqlupdate.=" f_public=2"; $public2=" selected"; break;*/ default: $sqlupdate.=" f_public>=0"; $public0=" selected"; break; } $searchcnt++; } //形式 if($_GET['seat']){ if($searchcnt>0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>0"; $seat1=" selected=\"selected\""; break; case "theater": $sqlupdate.=" f_maxtheater>0"; $seat2=" selected=\"selected\""; break; case "school": $sqlupdate.=" f_maxschool>0"; $seat3=" selected=\"selected\""; break; case "dinner": $sqlupdate.=" f_maxdinner>0"; $seat4=" selected=\"selected\""; break; case "buffet": $sqlupdate.=" f_maxbuffet>0"; $seat5=" selected=\"selected\""; break; default: $sqlupdate.=" f_maxseats>=0 AND f_maxtheater>=0 AND f_maxschool>=0 AND f_maxdinner>=0 AND f_maxbuffet>=0"; $seat0=" selected=\"selected\""; break; } $searchcnt++; } //エリア if($_GET['area']){ if($searchcnt>0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} $sqlupdate.=" f_area=".$_GET['area']; $searchcnt++; } //最大収容人数 if($_GET['capacity']){ if($searchcnt>0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} switch($_GET['capacity']){ case "0": $sqlupdate.=" f_maxp>=0"; $capacity0=" selected=\"selected\""; break; case "1-50": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=1 AND f_maxseats<=50"; break; case "theater": $sqlupdate.=" f_maxtheater>=1 AND f_maxtheater<=50"; break; case "school": $sqlupdate.=" f_maxschool>=1 AND f_maxschool<=50"; break; case "dinner": $sqlupdate.=" f_maxdinner>=1 AND f_maxdinner<=50"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=1 AND f_maxbuffet<=50"; break; default: $sqlupdate.=" f_maxp>=1 AND f_maxp<=50"; break; } }else{ $sqlupdate.=" f_maxp>=1 AND f_maxp<=50"; } $capacity1=" selected=\"selected\""; break; case "51-100": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=51 AND f_maxseats<=100"; break; case "theater": $sqlupdate.=" f_maxtheater>=51 AND f_maxtheater<=100"; break; case "school": $sqlupdate.=" f_maxschool>=51 AND f_maxschool<=100"; break; case "dinner": $sqlupdate.=" f_maxdinner>=51 AND f_maxdinner<=100"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=51 AND f_maxbuffet<=100"; break; default: $sqlupdate.=" f_maxp>=51 AND f_maxp<=100"; break; } }else{ $sqlupdate.=" f_maxp>=51 AND f_maxp<=100"; } $capacity2=" selected=\"selected\""; break; case "101-300": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=101 AND f_maxseats<=300"; break; case "theater": $sqlupdate.=" f_maxtheater>=101 AND f_maxtheater<=300"; break; case "school": $sqlupdate.=" f_maxschool>=101 AND f_maxschool<=300"; break; case "dinner": $sqlupdate.=" f_maxdinner>=101 AND f_maxdinner<=300"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=101 AND f_maxbuffet<=300"; break; default: $sqlupdate.=" f_maxp>=101 AND f_maxp<=300"; break; } }else{ $sqlupdate.=" f_maxp>=101 AND f_maxp<=300"; } $capacity3=" selected=\"selected\""; break; case "301-500": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=301 AND f_maxseats<=500"; break; case "theater": $sqlupdate.=" f_maxtheater>=301 AND f_maxtheater<=500"; break; case "school": $sqlupdate.=" f_maxschool>=301 AND f_maxschool<=500"; break; case "dinner": $sqlupdate.=" f_maxdinner>=301 AND f_maxdinner<=500"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=301 AND f_maxbuffet<=500"; break; default: $sqlupdate.=" f_maxp>=301 AND f_maxp<=500"; break; } }else{ $sqlupdate.=" f_maxp>=301 AND f_maxp<=500"; } $capacity4=" selected=\"selected\""; break; case "501-1000": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=501 AND f_maxseats<=1000"; break; case "theater": $sqlupdate.=" f_maxtheater>=501 AND f_maxtheater<=1000"; break; case "school": $sqlupdate.=" f_maxschool>=501 AND f_maxschool<=1000"; break; case "dinner": $sqlupdate.=" f_maxdinner>=501 AND f_maxdinner<=1000"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=501 AND f_maxbuffet<=1000"; break; default: $sqlupdate.=" f_maxp>=501 AND f_maxp<=1000"; break; } }else{ $sqlupdate.=" f_maxp>=501 AND f_maxp<=1000"; } $capacity5=" selected=\"selected\""; break; case "1001-": if($_GET['seat']){ switch($_GET['seat']){ case "seats": $sqlupdate.=" f_maxseats>=1001"; break; case "theater": $sqlupdate.=" f_maxtheater>=1001"; break; case "school": $sqlupdate.=" f_maxschool>=1001"; break; case "dinner": $sqlupdate.=" f_maxdinner>=1001"; break; case "buffet": $sqlupdate.=" f_maxbuffet>=1001"; break; default: $sqlupdate.=" f_maxp>=1001"; break; } }else{ $sqlupdate.=" f_maxp>=1001"; } $capacity6=" selected=\"selected\""; break; } $searchcnt++; } //最大面積 if($_GET['maxarea']){ if($searchcnt>0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} switch($_GET['maxarea']){ case "-300": $sqlupdate.=" f_maxa<=300"; $area1=" selected=\"selected\""; break; case "301-500": $sqlupdate.=" f_maxa>=301 AND f_maxa<=500"; $area2=" selected=\"selected\""; break; case "501-1000": $sqlupdate.=" f_maxa>=501 AND f_maxa<=1000"; $area3=" selected=\"selected\""; break; case "1001-": $sqlupdate.=" f_maxa>=1001"; $area4=" selected=\"selected\""; break; default: $sqlupdate.=" f_maxa>=0"; $area0=" selected=\"selected\""; break; } $searchcnt++; } //キーワード if($_GET['key']){ //$keyword=mb_convert_encoding($_GET['key'],"UTF-8","EUC-JP"); $keyword_cnt=0; $keyword=str_replace("　"," ",$_GET['key']); if($searchcnt>0){$sqlupdate.=" AND";}else{$sqlupdate.=" WHERE";} $keyword_array=preg_split("/[ ]+/",$keyword); foreach($keyword_array as $keyword_array_element){ if($keyword_cnt>0){$sqlupdate.=" AND";} $sqlupdate.=" (f_name LIKE BINARY \"%".$keyword_array_element."%\" OR f_ename LIKE BINARY \"%".$keyword_array_element."%\" OR f_details LIKE BINARY \"%".$keyword_array_element."%\" OR f_record LIKE BINARY \"%".$keyword_array_element."%\" OR f_postno LIKE BINARY \"%".$keyword_array_element."%\" OR f_address LIKE BINARY \"%".$keyword_array_element."%\" OR f_tel LIKE BINARY \"%".$keyword_array_element."%\" OR f_fax LIKE BINARY \"%".$keyword_array_element."%\" OR f_access LIKE BINARY \"%".$keyword_array_element."%\" OR c_name LIKE BINARY \"%".$keyword_array_element."%\" OR c_remarks LIKE BINARY \"%".$keyword_array_element."%\" OR d_name LIKE BINARY \"%".$keyword_array_element."%\" OR d_category LIKE BINARY \"%".$keyword_array_element."%\" OR d_remarks LIKE BINARY \"%".$keyword_array_element."%\" OR r_name LIKE BINARY \"%".$keyword_array_element."%\" OR r_remarks LIKE BINARY \"%".$keyword_array_element."%\")"; $keyword_cnt++; } } } $sqlupdate.=" GROUP BY f_name ORDER BY sortNo"; /*施設タイプ生成*/ $typeSelect="\n"; /*エリア生成*/ $areaSelect="\n"; ?>

MICEマップ 青葉山川内エリア 仙台駅周辺エリア 青葉山川内エリア 仙台駅周辺エリア 郊外・その他
\n"; echo ""; echo "\n\n"; } ?>
施設一覧
詳細 施設名 最大面積(m2) 最大収容人数
固定席 シアター スクール ディナー ブッフェ
詳細$myrow[f_name]".number_format($myrow[f_maxa])."$conv_seats_view$conv_theater_view$conv_school_view$conv_dinner_view$conv_buffet_view