<?php
/*(c) Easy Communications Inc.*/
require_once "../require.php";
require_once DATA_DIR."/class/class_search_sub.php";

foreach($_GET as $K => $V){
$FORM[$K]=$V;
}
$assigns[] = array("FORM",$FORM); 

//////////////////子供のカテゴリー取得///////////////////////
////////////////////////////////////////////////////////
/*SQL設定*/
$table_name = "`local_area_category`";
if($_GET["area_id"]){
$where = "`area_category_mother_id` = ".$_GET["area_id"]." ";
}else{
$where = "`area_category_mother_id` = 0 ";
}
$sort = "area_category_sort_number ASC";
//SQL発行
$children_cate=serach($table_name,$where,$order,'200','1');
$assigns[] = array("children_cate",$children_cate); 
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////

//print_r($children_cate);


//////////////////全カテゴリー取得///////////////////////
////////////////////////////////////////////////////////
/*SQL設定*/
$table_name = "`local_area_category`";
$where = "";
$sort = "area_category_sort_number ASC";
//SQL発行
$all_cate=serach($table_name,$where,$order,'9999','1');
$assigns[] = array("all_cate",$all_cate); 

//親カテゴリー設定
foreach($all_cate["result"] as $temp){
$mc[$temp["area_category_id"]] = array($temp["area_category_name"],$temp["area_category_mother_id"]);
}
$assigns[] = array("MC",$mc);//親カテゴリー出力用
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////


if($_GET["area_id"]){

/*SQL設定*/
$table_name = "";
$where = "area_category_id LIKE '".$_GET["area_id"]."'";
$sort = "";
$order = "";
$table_name = "local_area_category";


//SQL発行
$result=serach($table_name,$where,$order,1,1);

if($result["count"] != 1){
$error = new ERROR_DISP;
$error->assigns=$assigns;
$error->e_message="エリアIDが存在しません。";
$error->error();
};


///////////結果編集//////////////
/////////////////////////////////
if(isset($result["result"]) && $result["result"] !=""){
foreach($result["result"] as $temp){
	
$fix_result[] = $temp;
}
}
/////////////////////////////////
/////////////////////////////////

//SQL返り値をassign
$assigns[] = array("area",$fix_result[0]); 

}else{

$assigns["all_area"] = array("all_area","1");

}


if($children_cate["count"] == 0){
$assigns["children"] = array("children","0");
}else{
$assigns["children"] = array("children","1");
}


//////////////////子供がいない時兄弟取得///////////////////////
////////////////////////////////////////////////////////
if($children_cate["count"] == 0){
$table_name = "`local_area_category`";
$where = "`area_category_mother_id` = ".$mc[$_GET["area_id"]][1]." ";
$sort = "area_category_sort_number ASC";
//SQL発行
$children_cate=serach($table_name,$where,$order,'200','1');
$assigns[] = array("children_cate",$children_cate);
}

if($children_cate["count"] == 0){
$assigns["no_child"] = array("no_child","1");
}
/////////////////////////////////
/////////////////////////////////


/*出力*/
$disp = new DISP;
$disp->assigns=$assigns;
$disp->main_tpl="ccf/local.tpl";
$disp->display();
exit();

?>