<?
/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
/* index.php */
/*　-----------------------------------------------------------------------
	TOPページ表示
　　主な機能
　　1．カテゴリーごとに記事を表示
	出力テンプレート
	1．index.tpl　表示用の画面
															Create 2009/01/21
	------------------------------------------------------------------------ */
	session_start();

	require("./setup.php");
	require("./manager/req/connect.req");
	//require_once("./manager/req/xml_decode.php");

	$conn = connect('kumashi_db');

	//セッションIDを取得
	if(isset($_GET['SID'])) {
		$s_id = $_GET['SID'];
	}
	else {
		$s_id = session_id();
	}
//---------------------------------------------------------------------------------------
/*
// 携帯のユーザIDを取得 -------------------------------------------------
//・キャリア毎に扱いが異なるため、まずdocomo, au, softbank等の
//振り分けを行う。然る後、携帯のユーザIDを取得する

	//キャリア毎にユーザIDを取得。
	//docomo, au, softbankの三社対応。
	//その他はユーザIDの取得方法がない（そもそも提供していない）ので放置
	//端末IDを取得すれば認証できないこともないが
	//その場合機種交換には対応不可能となる。

//振り分け通過後は処理を行わない
if(!isset($_SESSION['pc_user']) && !isset($_SESSION['UID'])) {
	//docomoの場合
	if(strstr($_SERVER['HTTP_USER_AGENT'], "DoCoMo")){
		//docomoはパラメータにguid=ONと指定することで
		//ユーザIDがHTTPヘッダにX_DCMGUIDとして付加される。
		//要するにguid=ONをくっつけて読み込んだPHPで
		//ユーザIDが取得できる
		header("Location: ./m/dcm.php?guid=ON&SID={$s_id}");
		exit;
	}
	//auの場合
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "KDDI")){
		//**************_xx.ezweb.ne.jpといったデータ形式
		$UID = $_SERVER['HTTP_X_UP_SUBNO'];
		//セッション変数に保持する
		$_SESSION['UID'] = $UID;
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	//softbankの場合
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "Vodafone")){
		$UID = $_SERVER['HTTP_X_JPHONE_UID'];
		//セッション変数に保持する
		$_SESSION['UID'] = $UID;
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	//softbankの場合
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "SoftBank")){
		$UID = $_SERVER['HTTP_X_JPHONE_UID'];
		//セッション変数に保持する
		$_SESSION['UID'] = $UID;
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	//softbankの場合
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "J-PHONE")){
		$UID = $_SERVER['HTTP_X_JPHONE_UID'];
		//セッション変数に保持する
		$_SESSION['UID'] = $UID;
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	// その他のキャリアだった場合。何もしない -----------------
	//これらはユーザIDを取得できないため、会員登録は行えないが
	//携帯サイトを見る分には問題ない。
	//後のelseに引っかかるとPCと同じ扱いになり、PCサイトに
	//飛ばすことになるのでここの条件に引っかけておく
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "MOT-")){
		$_SESSION['UID'] = "exceptional_career";
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "UP.Browser")){
		$_SESSION['UID'] = "exceptional_career";
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	elseif(strstr($_SERVER['HTTP_USER_AGENT'], "WILLCOM")){
		$_SESSION['UID'] = "exceptional_career";
		// m/repo/index_m.phpから来た場合
		if(isset($_SESSION['destination'])) {
			header("Location: ./m/repo/index_login.php?SID={$s_id}");
			exit;
		}
		header("Location: ./m/index.php?SID={$s_id}");
		exit;
	}
	//---------------------------------------------------------

	//どの携帯のユーザエージェントにも一致しなかった
	//（即ち携帯ではない）場合
	else {
		//testcode -------------------------------------------
		//PCでデバッグするため、一時的にPCも携帯サイトに飛ばす
		//$_SESSION['UID'] = "test";
		//header("Location: ./m/index.php?SID={$s_id}");
		//exit;
		//----------------------------------------------------

        //PCユーザ、という値をセッション変数に保持
        $_SESSION['pc_user'] = "1";
	}
}
*/
//-----------------------------------------------------------------------

	//$pre_url = $_POST['pre_url']; print ("pre_url=" .$pre_url);
	//$cst_id  = $_SESSION['cst_id'];
	$mode = getRequest("mode");

	$smarty_object = new Smarty_setup; //Smarty のインスタンス作成
	$s_key = "";


	list($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
	$yy = $year + 1900 ;
	$mm = sprintf('%02d',$mon + 1 );

	if (getRequest("limit") == "" || getRequest("limit") != "no"){
		$limit = "limit 5";
	}else{
		$limit = "";
	}

/*
	//戻る対策
	if(isset($_GET['cate']) && !isset($_GET['mode']) && !isset($_GET['s_key'])) {
		if(isset($_SESSION['enc_key'])) {
			unset($_SESSION['enc_key']);
		}
	}
*/


	//　テンプレート判別、設定処理
	if ($mode == ""){
		//検索かチェック
		$qs = getRequest("qs"); //print urldecode($qs);
		if (getRequest("qs") != "" ){
			$templates = "serchnav";
			$smarty_object->assign("qs", $qs);

			//検索はQ&A、相談会　から検索
			$s_cnt = 0;
			// Q&A
			$sql = "SELECT * FROM law_qa WHERE valid_flg = '1' ".
					"AND (law_title like '%$qs%' OR law_question like '%$qs%' )".
					" ORDER BY regist_date DESC ";
			$result = mysql_query($sql) or die("SQL error:[$sql]");
			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->append("s_id", $data['qa_id']);
					$smarty_object->append("s_ttl", "法律相談Q&A |".$data['law_title']);
					$smarty_object->append("s_honbun", $data['law_question']);
					$smarty_object->append("s_link", "?mode=qalist&qa_id=".$data['qa_id']);
					//$smarty_object->append("s_link", "");
					$s_cnt++;
					//$smarty_object->append("l_index", fmod($s_cnt,20));
				}
			}

			// 相談会
			$sql = "SELECT * FROM consul WHERE valid_flg = '1' ".
					"AND (consul_ttl like '%$qs%' OR consul_exp like '%$qs%' )".
					" ORDER BY regist_date DESC ";
			$result = mysql_query($sql) or die("SQL error:[$sql]");
			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->append("s_id", $data['con_id']);
					$smarty_object->append("s_ttl", "相談会 |".$data['consul_ttl']);
					$smarty_object->append("s_honbun", $data['consul_exp']);
					$smarty_object->append("s_link", "?mode=consul&con_id=".$data['con_id']);
					//$smarty_object->append("s_link", "");
					$s_cnt++;
					//$smarty_object->append("l_index", fmod($s_cnt,20));
				}
			}
			$smarty_object->assign("s_cnt", $s_cnt);
			$st = getRequest("st");
			if ($s_cnt > ($st + 20)){
				$smarty_object->assign("stend", $st + 20);
			}else{
				$smarty_object->assign("stend", $s_cnt );
			}
			$smarty_object->assign("st", $st);
			if ($st == "" || $st == 0 ){
				$st = 1;
			}
			$smarty_object->assign("stv", $st);
			// ページ数設定
			$pages = ceil($s_cnt / 20) ; //print ceil($pages);
			for ($i=0;$i<$pages;$i++){
				$smarty_object->append("pg_st", $i * 20);
				$smarty_object->append("pg_no", $i + 1);
			}

			// 静的ページの検索
			//$html_s = glob('*.html',GLOB_MARK);
			$html_s = array("ab_about.html","gu_greeting.html","link.html","ab_person.html"
							,"privacy.html","use.html");
			//var_dump($html_s);

			for($i=0;$i<count($html_s);$i++){
				//  while($data = $html_s){

				//if ($html_s[$i] == "link.html"){

					$str = file_get_contents($html_s[$i]);
					$str = preg_replace('/<head>[\s\S]*<\/head>/','',$str);
					$str = preg_replace('/[\s\S]*<body>/','',$str);
					$str = preg_replace('/<a href[\s\S]*?<\/a>/','',$str);
					$str = preg_replace('/<img[\s\S]*?>/','',$str);
					if (mb_ereg($qs,strip_tags($str))){
						//print ($html_s[$i]);
						$smarty_object->append("s_id", "");
						$smarty_object->append("s_ttl", $html_s[$i]);
						$smarty_object->append("s_honbun", "");
						$smarty_object->append("s_link", $html_s[$i]);
						//$smarty_object->append("s_link", "");
						$s_cnt++;
					}
					//print strip_tags(preg_replace('/<h1>/','タイトル',$str));
				//}

				//$str = strip_tags($str);
			}

			/* --------------------
			// 新着
			$sql = "SELECT * FROM whatsnew WHERE valid_flg = '1' ".
					"AND (new_ttl like '%$qs%' OR new_write like '%$qs%' )".
					" ORDER BY regist_date DESC ";
			$result = mysql_query($sql) or die("SQL error:[$sql]");
			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->append("s_id", $data['nw_id']);
					$smarty_object->append("s_ttl", "新着情報 |".$data['new_ttl']);
					$smarty_object->append("s_honbun", $data['new_write']);
					//$smarty_object->append("s_link", $data['new_url']);
					$smarty_object->append("s_link", "mode=newslist&nw_id=".$data['nw_id']);
					$s_cnt++;
				}
			}
			--------------- */


		}else{
			//検索以外の処理
			// TOP
			$templates = "index";
			// 新着記事リスト作成
			$sql = "SELECT * FROM whatsnew WHERE valid_flg = '1' AND view_flg = '1' ".
					$key  .
					" ORDER BY regist_date DESC ".
					$limit . " OFFSET ". ($displaying_page * 20);
			$result = mysql_query($sql) or die("SQL error:[$sql]");
			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->append("l_nw_id", $data['nw_id']);
					$smarty_object->append("l_new_ttl", $data['new_ttl']);
					$smarty_object->append("l_new_write", mb_substr($data['new_write'],0,24));
					$smarty_object->append("l_new_url", $data['new_url']);
					$smarty_object->append("l_new_image", $data['new_image']);
					if ($data['view_flg'] == "1"){
						$smarty_object->append("l_view_flg", "表示");
					}else{
						$smarty_object->append("l_view_flg", "非表示");
					}
					$date = split(" ",$data['regist_date']);
					$smarty_object->append("l_regist_date", $date[0]);

				}
			}

		}


	}
	// --- 新着記事 ----------------------------------------------------------
	elseif ($mode == "newslist") {
		$templates = "newslist";

		// 新着記事リスト作成
		$sql = "SELECT * FROM whatsnew ".
				"WHERE valid_flg = '1' AND view_flg ='1' ".
				" ORDER BY regist_date DESC ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		if (mysql_numrows($result) > 0){
			while ($data = mysql_fetch_array($result)){
				$smarty_object->append("l_nw_id", $data['nw_id']);
				$smarty_object->append("l_new_ttl", $data['new_ttl']);
				$smarty_object->append("l_new_write", $data['new_write']);
				$smarty_object->append("l_new_url", $data['new_url']);
				$smarty_object->append("l_new_image", $data['new_image']);
				$date = split(" " ,$data['regist_date']);
				$smarty_object->append("l_regist_date", $date[0]);

			}
		}

	}
	// --- 法律相談Q&A ----------------------------------------------------------
	elseif ($mode == "qalist") {
		$templates = "qalist";

		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

		// 検索キー初期化
		$s_key = "";

		// 相談詳細表示用　qa_idがNULLの時は実行しない
		$qa_id = getRequest("qa_id");
		if ($qa_id != "" ){
			$s_key = " AND qa_id = '$qa_id'";
			$sql = "SELECT * FROM law_qa WHERE valid_flg = '1' ".
					" AND qa_id = '$qa_id'".
				 	" ORDER BY regist_date DESC ";
					//$limit . " OFFSET ". ($displaying_page * 20);
			$result = mysql_query($sql) or die("SQL error:[$sql]");
			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->assign("qa_id", $data['qa_id']);
					$smarty_object->assign("law_title", $data['law_title']);
					$smarty_object->assign("law_question", $data['law_question']);
					$smarty_object->assign("law_answer", $data['law_answer']);
					$smarty_object->assign("law_exp", mbereg_replace("\n","<br />",$data['law_exp']));
					$smarty_object->assign("law_image", $data['law_image']);
					$smarty_object->assign("regist_date", $data['regist_date']);
					$ct_id = $data['ct_id'];
					$s_key = " AND ct_id = '$ct_id' ";
				}
			}
			$templates = "qalistdetail";

		}

		//　カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' ".
				$s_key.
			 	" ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");


		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("l_ct_id", $ct_id);
			$smarty_object->append("l_ct_name", sele_ctname($ct_id));

			//　Q&Aリスト作成
			$sql2 = "SELECT * FROM law_qa WHERE valid_flg = '1' AND view_flg = '1' ".
					" AND ct_id = '$ct_id' ".
				 	" ORDER BY qa_id ";
					//$limit . " OFFSET ". ($displaying_page * 20);
			$result2 = mysql_query($sql2) or die("SQL error:[$sql]");
			$l_qa_id = array();
			$l_law_title = array();
			$l_q_no = array();
			$i = 1;
			if (mysql_numrows($result2) > 0){
				while ($data2 = mysql_fetch_array($result2)){
					array_push($l_q_no,$i);
					array_push($l_qa_id,$data2['qa_id']);
					array_push($l_law_title,$data2['law_title']);
					$i++;
				}
			}
			$smarty_object->append("l_q_no",$l_q_no);
			$smarty_object->append("l_qa_id",$l_qa_id);
			$smarty_object->append("l_law_title",$l_law_title);
		}
	}
	// --- 総合相談センター ----------------------------------------------------------
	elseif ($mode == "ac_center") {
		$templates = "ac_center";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
// --- 総合相談センター2 ----------------------------------------------------------
elseif ($mode == "ac_center2") {
	$templates = "ac_center2";
	//　サイド表示用カテゴリリスト作成
	$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
	" GROUP BY ct_id ORDER BY regist_date ";
	$result = mysql_query($sql) or die("SQL error:[$sql]");
	while ($data = mysql_fetch_array($result)){
		$ct_id = $data['ct_id'];
		$smarty_object->append("s_ct_id", $ct_id);
		$smarty_object->append("s_ct_name", sele_ctname($ct_id));
	}

}
	// --- 総合相談センター_02 ----------------------------------------------------------
	elseif ($mode == "ac_center_02") {
		$templates = "ac_center_02";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
	// --- 賃貸解決支援センター ----------------------------------------------------------
	elseif ($mode == "chintai_center") {
		$templates = "chintai_center";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
	// --- 賃貸解決支援センター（テスト） ----------------------------------------------------------
	elseif ($mode == "chintai_center_test") {
		$templates = "chintai_center_test";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
	// --- 賃貸解決支援センター_02 ----------------------------------------------------------
	elseif ($mode == "chintai_center_02") {
		$templates = "chintai_center_02";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
// --- 相続センター ----------------------------------------------------------
elseif ($mode == "souzoku_center") {
	$templates = "souzoku_center";
	//　サイド表示用カテゴリリスト作成
	$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
	" GROUP BY ct_id ORDER BY regist_date ";
	$result = mysql_query($sql) or die("SQL error:[$sql]");
	while ($data = mysql_fetch_array($result)){
		$ct_id = $data['ct_id'];
		$smarty_object->append("s_ct_id", $ct_id);
		$smarty_object->append("s_ct_name", sele_ctname($ct_id));
	}

}
// --- 相続センター_02 ----------------------------------------------------------
elseif ($mode == "souzoku_center_test") {
	$templates = "souzoku_center_test";
	//　サイド表示用カテゴリリスト作成
	$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
	" GROUP BY ct_id ORDER BY regist_date ";
	$result = mysql_query($sql) or die("SQL error:[$sql]");
	while ($data = mysql_fetch_array($result)){
		$ct_id = $data['ct_id'];
		$smarty_object->append("s_ct_id", $ct_id);
		$smarty_object->append("s_ct_name", sele_ctname($ct_id));
	}

}
// --- 相続センター2/20181221 ----------------------------------------------------------
elseif ($mode == "souzoku_center2") {
	$templates = "souzoku_center2";
	//　サイド表示用カテゴリリスト作成
	$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1' ".
	" GROUP BY ct_id ORDER BY regist_date ";
	$result = mysql_query($sql) or die("SQL error:[$sql]");
	while ($data = mysql_fetch_array($result)){
		$ct_id = $data['ct_id'];
		$smarty_object->append("s_ct_id", $ct_id);
		$smarty_object->append("s_ct_name", sele_ctname($ct_id));
	}

}
	// --- 講師派遣 ----------------------------------------------------------
	elseif ($mode == "ac_lecturer") {
		$templates = "ac_lecturer";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1'  ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}

	}
	// --- その他 ----------------------------------------------------------
	elseif ($mode == "ac_other") {
		$templates = "ac_other";
		//　サイド表示用カテゴリリスト作成
		$sql = "SELECT ct_id FROM law_cate WHERE valid_flg = '1' AND view_flg = '1'  ".
			 	" GROUP BY ct_id ORDER BY regist_date ";
		$result = mysql_query($sql) or die("SQL error:[$sql]");
		while ($data = mysql_fetch_array($result)){
			$ct_id = $data['ct_id'];
			$smarty_object->append("s_ct_id", $ct_id);
			$smarty_object->append("s_ct_name", sele_ctname($ct_id));
		}


	}
	// --- 催し(各種相談会) ----------------------------------------------------------
	elseif ($mode == "consul") {

		$s_key = "";
		// 相談会リスト作成
		//$ct_names = array("1"=>"不定期開催の相談会","2"=>"定期開催の相談会","3"=>"開催済みの相談会");
		$ct_names = array("1"=>"開催中の相談会","2"=>"開催済みの相談会");
		$sub_cates = array("1"=>"多重債務相談","2"=>"成年後見相談","3"=>"その他の相談");
		$con_id = getRequest("con_id");
		if ($con_id  == "" ){
			// リスト　表示　処理
			$templates = "consul";

			// 初期は開催中を表示
			$kaisai = getRequest("kaisai");
			if ($kaisai == "" || $kaisai == "1"){
				//開催中相談会を検索
				$view_flg = "1";
				$smarty_object->assign("kaisai",1);

				for ($i=1;$i<4;$i++){
					//$smarty_object->append("l_cs_ct_id",$i);
					//$smarty_object->append("l_cs_ctname",$ct_names[$i]);
					$smarty_object->append("l_cs_ct_id",$i);
					$smarty_object->append("l_cs_ctname",$sub_cates[$i]);

					$sql = "SELECT * FROM consul WHERE valid_flg = '1' ".
							"AND view_flg = '$view_flg' AND cs_ct_id='$i' ".$s_key  .
							" ORDER BY regist_date DESC ";
							//$limit . " OFFSET ". ($displaying_page * 20);
					$result = mysql_query($sql) or die("SQL error:[$sql]"); //print($sql);
					// 配列初期化
					$l_con_id = array();
					$l_consul_ttl = array();
					$l_consul_place = array();
					$l_consul_day = array();

					if (mysql_numrows($result) > 0){
						while ($data = mysql_fetch_array($result)){
							$l_con_id[] = $data['con_id'];
							$l_consul_ttl[] = $data['consul_ttl'];
							$l_consul_place[] = $data['consul_place'];
							$l_consul_day[] = $data['consul_day'];

						}
						$smarty_object->append("l_con_id", $l_con_id);
						$smarty_object->append("l_consul_ttl", $l_consul_ttl);
						$smarty_object->append("l_consul_day", $l_consul_day);
						$smarty_object->append("l_consul_place", $l_consul_place);
					}
				}

			}else{
				//開催済み相談会を検索
				$view_flg = "0";
				$smarty_object->assign("kaisai",0);
				$smarty_object->append("l_cs_ct_id",3);
				$smarty_object->append("l_cs_ctname",$ct_names[3]);

				$sql = "SELECT * FROM consul WHERE valid_flg = '1' ".
						"AND view_flg = '$view_flg' " .$s_key  .
						" ORDER BY regist_date DESC ";
						//$limit . " OFFSET ". ($displaying_page * 20);
				$result = mysql_query($sql) or die("SQL error:[$sql]"); //print($sql);
				// 配列初期化

				if (mysql_numrows($result) > 0){
					while ($data = mysql_fetch_array($result)){
						$l_con_id[] = $data['con_id'];
						$l_consul_ttl[] = $data['consul_ttl'];
						$l_consul_place[] = $data['consul_place'];
						$l_consul_day[] = $data['consul_day'];

					}
					$smarty_object->append("l_con_id", $l_con_id);
					$smarty_object->append("l_consul_ttl", $l_consul_ttl);
					$smarty_object->append("l_consul_day", $l_consul_day);
					$smarty_object->append("l_consul_place", $l_consul_place);
				}
			}

		}else{
			// リスト　表示　処理
			$templates = "consuldetail";

    		$sponsors = array( //'0' => '-----▼以下から選択-----',
      				'1' => '熊本県司法書士会',
       				'2' => '熊本県青年司法書士会',
       				'3' => '熊本県',
       				'4' => '熊本市',
       				'5' => '宇土市',
       				'6' => '八代市',
       				/* edit tazoe 2012/09/28
       				'7' => '（社）成年後見センター･リーガルサポート熊本支部',
       				*/
       				'7' => '（公社）成年後見センター･リーガルサポート熊本支部',
       				'8' => '熊本行政評価事務所　');

			// con_id 記事番号の詳細を検索
			$sql = "SELECT * FROM consul WHERE valid_flg = '1' ".
					//"AND view_flg = '1' AND con_id = '$con_id'";
					"AND  con_id = '$con_id'";

			$result = mysql_query($sql) or die("SQL error:[$sql]"); //print($sql);
			// 配列初期化

			if (mysql_numrows($result) > 0){
				while ($data = mysql_fetch_array($result)){
					$smarty_object->assign("con_id" , $data['con_id']);
					$smarty_object->assign("consul_ttl" , $data['consul_ttl']);
					$smarty_object->assign("consul_place" , $data['consul_place']);
					$smarty_object->assign("consul_day" , $data['consul_day']);
					$smarty_object->assign("consul_exp", $data['consul_exp']);
					$smarty_object->assign("consul_way", $data['consul_way']);
					$sponsor = split(",",$data['consul_sponsor']);//print (count($sponsor));
					if (count($sponsor) > 0 ){
						$consul_sponsor = "";
						for($i=0;$i<count($sponsor);$i++){
							if ($i == count($sponsor)-1 ){
								 $sepa = "&nbsp;";
							}else{
								$sepa = "&nbsp;/&nbsp;";
							}
							$con_sponsor = $sponsor[$i]; //print ($con_sponsor);
							$consul_sponsor .= $sponsors[$con_sponsor].$sepa ;
						}
						$smarty_object->assign("consul_sponsor", $consul_sponsor);
					}else{
						$consul_sponsor = $data['consul_sponsor'];
						$smarty_object->assign("consul_sponsor", $sponsors[$consul_sponsor]);
					}
					$smarty_object->assign("consul_inquery", $data['consul_inquery']);
					$smarty_object->assign("consul_cont", $data['consul_cont']);
					$smarty_object->assign("consul_image", $data['consul_image']);
					$smarty_object->assign("consul_note", $data['consul_note']);
					$convenes = $data['convenes'];
					$smarty_object->assign("regist_date", $data['regist_date']);

					//Add Nakamura 20140725

					$smarty_object->assign("view", $data['view_flg']);

				}
			}
			if($convenes == "1"){
				$sql = "SELECT * FROM convene ".
						"WHERE con_id = '$con_id' ORDER BY cnv_id ";
				$result = mysql_query($sql) or die("SQL error:[$sql]");

				if (mysql_numrows($result) > 0){
					while ($data = mysql_fetch_array($result)){
						$smarty_object->append("kubun",$data['kubun']);
						$smarty_object->append("cnv_date",$data['cnv_date']);
						$smarty_object->append("cnv_time",$data['cnv_time']);
						$smarty_object->append("cnv_place",$data['cnv_place']);
					}
				}else{
					$convenes = "0";
				}
				$smarty_object->assign("convenes", $convenes);
			}
		}


	}
	else{
		$templates = "index";
	}

    $smarty_object->assign("MAIN_URL",$MAIN_URL);
    $smarty_object->assign("TOP_URL",$TOP_URL);

	//$smarty_object->display("header.tpl");  //ヘッダー
    $smarty_object->display( $templates.".tpl");	//メインコンテンツ
	//$smarty_object->display("footer.tpl");  //フッター


// Debug_print
//var_dump($qalist);
//var_dump($genre);
//print ($templates);
//print ($SAVEDIR);

	//mysql_close();
	exit;
?>