<?
require_once"./dbconfig.php";
require_once"./config.php";
require_once"../../db/util/nslib.php";
require "DB.php";

foreach($_REQUEST as $kye=>$val) {
	if (is_array($_REQUEST[$key])) {
		foreach($_REQUEST[$key] as $ar_kye=>$ar_val) {
			$_REQUEST[$key][$ar_key] = strip_tags(htmlspecialchars(addslashes($_REQUEST[$key][$ar_key])));
		}
	} else {
		$_REQUEST[$key] = addslashes(htmlspecialchars(strip_tags($_REQUEST[$key])));
	}
}

//カテゴリ一覧
$db =& DB::connect($dsn);
if (DB::isError($db)) {
	$db->getMessage();
	$db->getDebugInfo();
	die("connect error");
}

$sql = "SELECT distinct(category_mei) from program where category_mei is not null";

$sql .= " order by category_mei";

$result = $db->getAll($sql,array(),DB_FETCHMODE_ASSOC);

if (DB::isError($result)) {
	echo $result->getMessage() . "<BR>";
	echo $result->getDebugInfo();
	die("<BR>ERROR<BR>");
}

$sql = null;

$category_data = $result;

if ($result !=null) {
$category_val = '(';
foreach($category_data as $ckey=>$cval) {
	$category_val .= '\'' . $cval['category_mei'] . '\',';
}
$category_val = rtrim($category_val,",");
$category_val .= ')';
}


//部屋一覧
$db =& DB::connect($dsn);
if (DB::isError($db)) {
	$db->getMessage();
	$db->getDebugInfo();
	die("connect error");
}

$sql = "SELECT distinct(room_mei) from program where room_mei is not null";

$sql .= " order by room_mei";

$result = $db->getAll($sql,array(),DB_FETCHMODE_ASSOC);

if (DB::isError($result)) {
	echo $result->getMessage() . "<BR>";
	echo $result->getDebugInfo();
	die("<BR>ERROR<BR>");
}

$sql = null;

$room_data = $result;

$rooms_val = '(';
foreach($room_data as $rkey=>$rval) {
	$rooms_val .= '\'' . $rval['room_mei'] . '\',';
}
$rooms_val = rtrim($rooms_val,",");
$rooms_val .= ')';

//検索条件
//ClassificationありDateなし
if ($_REQUEST['kubun'] != null) {
	if ($_REQUEST['selected_days'] == null) {
		$err_msg = "Please select Date.";

		$msg_body = $err_msg ;
		$msg_buttons =<<<_BUTTONS_
<form>
<input type="button" onClick="Javascript:history.back()" value="back">
</form>
_BUTTONS_;
		$o_smarty->assign("msg_body",$msg_body);
		$o_smarty->assign("msg_buttons",$msg_buttons);
		$o_smarty->display("2008/program/print_msg.tpl");
		exit;

	}
}
//ClassificationなしDateあり
if ($_REQUEST['selected_days'] != null) {
	if ($_REQUEST['kubun'] == null) {
		$err_msg = "Please select Classification.";

		$msg_body = $err_msg ;
		$msg_buttons =<<<_BUTTONS_
<form>
<input type="button" onClick="Javascript:history.back()" value="back">
</form>
_BUTTONS_;
		$o_smarty->assign("msg_body",$msg_body);
		$o_smarty->assign("msg_buttons",$msg_buttons);
		$o_smarty->display("2008/program/print_msg.tpl");
		exit;

	}
}


//区分
if ($_REQUEST['kubun'] != null) {
	$kubun_all_flag = 0;
	$kubun_val = "("; 
	foreach($_REQUEST['kubun'] as $key=>$val) {
		$kubun_val .= "'{$val}',";
		if ($val == 'All') {
			$kubun_all_flag = 1;
		}
	}
	$kubun_val = rtrim($kubun_val,",");
	$kubun_val .= ")"; 

	if ($kubun_all_flag == 0) {
		$cond_sql .= " and kubun in " . $kubun_val;
		//$cond_val[] = $kubun_val;
	}
} else if ($_REQUEST['kubun'] == null) {
	$kubun_val = "('Coronary','Surgical','Electrophysiology','Peripheral','Co-medical')"; 
	$cond_sql .= " and (kubun in " . $kubun_val . " or kubun is null)";
}
//日時
if ($_REQUEST['selected_days'] != null) {
	$s_day_all_flag = 0;
	$s_day_val = "("; 
	foreach($_REQUEST['selected_days'] as $key=>$val) {
		$s_day_val .= "'{$val}',";
		if ($val == 'All') {
			$s_day_all_flag = 1;
		}
	}
	$s_day_val = rtrim($s_day_val,",");
	$s_day_val .= ")"; 

	if ($s_day_all_flag == 0) {
		$cond_sql .= " and s_day_p in " . $s_day_val;
		//$cond_val[] = $s_day_val;
	}

} else if ($_REQUEST['selected_days'] == null) {
	$s_day_val = "('2008-01-31','2008-02-01','2008-02-02')"; 
	$cond_sql .= " and s_day_p in " . $s_day_val;
}

//category
if ($_REQUEST['category'] != null) {
	$category_val = "("; 
	foreach($_REQUEST['category'] as $key=>$val) {
		$category_val .= "'{$val}',";
	}
	$category_val = rtrim($category_val,",");
	$category_val.= ")"; 

	if ($category_val !=null) {
		$cond_sql .= " and category_mei in " . $category_val;
	}
	//$cond_val[] = $category_val;
} else if ($_REQUEST['category'] == null) {
	//$category_val= "('ACS','Atherectomy','Bifurcation','CTO','Complex Lesions','Complications','DES','Imaging','LMT','New Devices/Thechnology','Renal Failure','Restenosis','TRI','VulnerablePlaque','etc','Live')"; 
	if ($category_val !=null) {
		$cond_sql .= " and (category_mei in " . $category_val . " or category_mei is null)";
	}
}

//keyword
if ($_REQUEST['keyword'] != null) {
	$keyword_val = "%{$_REQUEST['keyword']}%"; 

	$cond_sql .= " and (category_mei ilike ?)";
	$cond_val[] = $keyword_val;
	$cond_val[] = $keyword_val;
}

//dr_name_lk
if ($_REQUEST['dr_name_lk'] != null) {
/*
	$dr_name_val = "%{$_REQUEST['dr_name_lk']}%"; 
	$cond_sql .= " and (pr_name_e ilike ? or pr_name_p ilike ? or pr_name_furigana ilike ?)";
	$cond_val[] = $dr_name_val;
	$cond_val[] = $dr_name_val;
	$cond_val[] = $dr_name_val;
*/
	$dr_list_url = 'http://www.cct.gr.jp/2008/program/dr_list.php?dr_name_lk=' . rawurlencode($_REQUEST['dr_name_lk']);
	header("Location:{$dr_list_url}");
	exit;
}

//Room
if ($_REQUEST['rooms'] != null) {
	$rooms_val = "("; 
	foreach($_REQUEST['rooms'] as $key=>$val) {
		$rooms_val .= "'{$val}',";
	}
	$rooms_val = rtrim($rooms_val,",");
	$rooms_val .= ")"; 

	$cond_sql .= " and room_mei in " . $rooms_val;
	//$cond_val[] = $rooms_val;
} else if ($_REQUEST['rooms'] == null) {
	//$rooms_val .= "('Exhibit Hall','Hall A','Hall B','Main Theater','Masters Theater','Room  4','Room  5','Room  6','Room  7','Room  8','Room  9','Room 10','Room 11','Room 12','Room 13','Room 14','Room 15')"; 

	//$cond_sql .= " and room_mei in " . $rooms_val;
}

//echo $cond_sql;
//exit;

$db =& DB::connect($dsn);
if (DB::isError($db)) {
	$db->getMessage();
	$db->getDebugInfo();
	die("connect error");
}

/*
//座長を取得
$sql = "SELECT pr_name_e from program where interid is not null";
$sql .= $cond_sql;
$sql .= " and yakuwari = 'Chair'";

$result = $db->getAll($sql,$cond_val,DB_FETCHMODE_ASSOC);

if (DB::isError($result)) {
	echo $result->getMessage() . "<BR>";
	echo $result->getDebugInfo();
	die("<BR>ERROR<BR>");
}

foreach ($result as $key=>$val) {
	$chairs .= $val['pr_name_e'] . ",";
}
$chairs = rtrim($chairs,",");
$o_smarty->assign("chairs",$chairs);

//オペレータを取得
$sql = "SELECT pr_name_e from program where interid is not null";
$sql .= $cond_sql;
$sql .= " and yakuwari = 'Operator'";

$result = $db->getAll($sql,$cond_val,DB_FETCHMODE_ASSOC);

if (DB::isError($result)) {
	echo $result->getMessage() . "<BR>";
	echo $result->getDebugInfo();
	die("<BR>ERROR<BR>");
}

foreach ($result as $key=>$val) {
	$operators .= $val['pr_name_e'] . ",";
}
$operators = rtrim($operators,",");
$o_smarty->assign("operators",$operators);
*/

//セッションのデータを取得
//$sql = "SELECT * from program where interid is not null and yakuwari not in ('Chair','Operator')";
$sql = "SELECT * from program where interid is not null and kubun is not null";
/*
if ($_REQUEST['hyoji_hoho'] == "list") {
	$sql .= " and live3 is null";
}
*/

$sql .= $cond_sql;

//order
if ($_REQUEST['hyoji_hoho'] == "list") {
	$order_sql = " order by s_day_p,s_time_p,room_mei";
} else if ($_REQUEST['hyoji_hoho'] == "detail") {
	//$order_sql = " order by kubun_order,kubun_for_printing,s_day_p,room_mei,s_time_p";
	$order_sql = " order by kubun_order,kubun_for_printing,s_day_p,s_time_p,e_time_p,psn,yakuwari";
}
$sql .= $order_sql;

//$sql .= " group by s_day_p,s_time_p,e_time_p,room_e,shurui,session_mei order by s_day_p,s_time_p,e_time_p,room_e";

//echo "<!--" . $sql . "//-->";
//$stt = $db->prepare($sql);
$result = $db->getAll($sql,$cond_val,DB_FETCHMODE_ASSOC);

if (DB::isError($result)) {
	echo $result->getMessage() . "<BR>";
	echo $result->getDebugInfo();
	die("<BR>ERROR<BR>");
}
//echo $sql;
//echo "<BR><BR><BR>";
$program_data = $result;

//日本語対応用
/*

foreach($program_data as $key=>$val) {
	if ($val['kubun'] == "Surgical" || $val['kubun'] == "Co-medical") {
		$program_data['$key']['session_mei'] = $val['session_mei_j'];
		$program_data['$key']['lecture_title'] = $val['lecture_title_j'];
		$program_data['$key']['pr_name_e'] = $val['pr_name_p'];
	}
}
*/

//echo count($result) . "ken<BR>";


//座長とオペレータ等役割を分離
foreach($program_data as $key=>$val) {
		$session_key = $val['s_day_p'] . $val['s_time_p'] . $val['room_mei'];
		$program_data[$key]['session_key'] = $session_key;
	if (strstr($val['yakuwari'],"Chair")) {
		$chairs .= $val['pr_name_e'] . " , ";
		$chairs_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "座長") {
		$zacho_chairs .= $val['pr_name_e'] . " , ";
		$zachos_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Chair for sub-screen") {
		$subscreen_chairs .= $val['pr_name_e'] . " , ";
		$subscreen_chairs_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Co-Chair") {
		$co_chairs .= $val['pr_name_e'] . " , ";
		$co_chairs_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "裏座長") {
		//英語表記に統一
		$subscreen_chairs .= $val['pr_name_e'] . " , ";
		$subscreen_chairs_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Commentator") {
		$commentators .= $val['pr_name_e'] . " , ";
		$commentators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Discussor") {
		$discussers .= $val['pr_name_e'] . " , ";
		$discussers_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Moderator") {
		$moderators .= $val['pr_name_e'] . " , ";
		$moderators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "IVUS Commentator") {
		$ivus_commentators .= $val['pr_name_e'] . " , ";
		$ivus_commentators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Operator") {
		$operators .= $val['pr_name_e'] . " , ";
		$operators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Lecturer") {
		$lecturers .= $val['pr_name_e'] . " , ";
		$lecturers_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Trainer") {
		$trainers .= $val['pr_name_e'] . " , ";
		$trainers_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "カテ室コメンテーター") {
		$kateshitsu_commentators .= $val['pr_name_e'] . " , ";
		$kateshitsu_commentators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "コメンテーター") {
		$komenteta .= $val['pr_name_e'] . " , ";
		$komenteta_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Assistant Operator") {
		$assistant_operator .= $val['pr_name_e'] . " , ";
		$assistant_operator_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Head of Judge") {
		$head_of_judge .= $val['pr_name_e'] . " , ";
		$head_of_judge_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Judge") {
		$judge .= $val['pr_name_e'] . " , ";
		$judge_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "OCT Commentator") {
		$oct_commentator .= $val['pr_name_e'] . " , ";
		$oct_commentator_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "CT Commentator") {
		$ct_commentator .= $val['pr_name_e'] . " , ";
		$ct_commentator_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "司会") {
		$shikai .= $val['pr_name_e'] . " , ";
		$shikai_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "演者") {
		$enja .= $val['pr_name_e'] . " , ";
		$enja_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "シンポジスト") {
		$shinpojisuto .= $val['pr_name_e'] . " , ";
		$shinpojisuto_commentators_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "アドバイザー") {
		$advisor .= $val['pr_name_e'] . " , ";
		$advisor_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "プレゼンター") {
		$presentor .= $val['pr_name_e'] . " , ";
		$presentor_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "CTコメンテーター") {
		$ct_comenteta .= $val['pr_name_e'] . " , ";
		$ct_comenteta_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "オペ室ディレクター") {
		$opeshitsu_director .= $val['pr_name_e'] . " , ";
		$opeshitsu_director_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "術者") {
		$jutsusha .= $val['pr_name_e'] . " , ";
		$jutsusha_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "中継手伝い") {
		$chukei_tetsudai .= $val['pr_name_e'] . " , ";
		$chukei_tetsudai_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "審査員長") {
		$shinsaincho .= $val['pr_name_e'] . " , ";
		$shinsaincho_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "進行手伝い") {
		$shinko_tetsudai .= $val['pr_name_e'] . " , ";
		$shinko_tetsudai_data[$session_key] .= $val['pr_name_e'] . " , ";
	} else if ($val['yakuwari'] == "Accommodation") {
		$accommodation .= $val['pr_name_e'] . " , ";
		$accommodation_data[$session_key] .= $val['pr_name_e'] . " , ";
	}
}

//var_dump($chairs_data);
//exit;

$chairs = rtrim($chairs," , ");
$zacho_chairs = rtrim($zacho_chairs," , ");
$subscreen_chairs = rtrim($subscreen_chairs," , ");
$co_chairs = rtrim($co_chairs," , ");
$urazachos = rtrim($urazachos," , ");
$commentators = rtrim($commentators," , ");
$discussers = rtrim($discussers," , ");
$moderators = rtrim($moderators," , ");
$ivus_commentators = rtrim($ivus_commentators," , ");
$operators = rtrim($operators," , ");
$trainers = rtrim($trainers," , ");
$kateshitsu_commentators = rtrim($kateshitsu_commentators," , ");

$komenteta = rtrim($komenteta," , ");
$assistant_operator = rtrim($assistant_operator," , ");
$head_of_judge = rtrim($head_of_judge," , ");
$judge = rtrim($judge," , ");
$oct_commentator = rtrim($oct_commentator," , ");
$ct_commentator = rtrim($ct_commentator," , ");
$shikai = rtrim($shikai," , ");
$enja = rtrim($enja," , ");
$shinpojisuto = rtrim($shinpojisuto," , ");
$advisor = rtrim($advisor," , ");
$presentor = rtrim($presentor," , ");
$ct_comenteta = rtrim($ct_comenteta," , ");
$opeshitsu_director = rtrim($opeshitsu_director," , ");
$jutsusha = rtrim($jutsusha," , ");
$chukei_tetsudai = rtrim($chukei_tetsudai," , ");
$shinsaincho = rtrim($shinsaincho," , ");
$shinko_tetsudai = rtrim($shinko_tetsudai," , ");
$accommodation = rtrim($accommodation," , ");

if ($chairs_data != null) {
	foreach($chairs_data as $key=>$val) {
		$chairs_data[$key] = rtrim($val," , ");
	}
}
if ($zachos_data != null) {
	foreach($zachos_data as $key=>$val) {
		$zachos_data[$key] = rtrim($val," , ");
	}
}
if ($subscreen_chairs_data != null) {
	foreach($subscreen_chairs_data as $key=>$val) {
		$subscreen_chairs_data[$key] = rtrim($val," , ");
	}
}
if ($co_chairs_data != null) {
	foreach($co_chairs_data as $key=>$val) {
		$co_chairs_data[$key] = rtrim($val," , ");
	}
}
if ($urazachos_data != null) {
	foreach($urazachos_data as $key=>$val) {
		$urazachos_data[$key] = rtrim($val," , ");
	}
}
if ($commentators_data != null) {
	foreach($commentators_data as $key=>$val) {
		$commentators_data[$key] = rtrim($val," , ");
	}
}
if ($discussers_data != null) {
	foreach($discussers_data as $key=>$val) {
		$discussers_data[$key] = rtrim($val," , ");
	}
}
if ($moderators_data != null) {
	foreach($moderators_data as $key=>$val) {
		$moderators_data[$key] = rtrim($val," , ");
	}
}
if ($ivus_commentators_data != null) {
	foreach($ivus_commentators_data as $key=>$val) {
		$ivus_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($operators_data != null) {
	foreach($operators_data as $key=>$val) {
		$operators_data[$key] = rtrim($val," , ");
	}
}
if ($trainers_data != null) {
	foreach($trainers_data as $key=>$val) {
		$trainers_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($kateshitsu_commentators_data != null) {
	foreach($kateshitsu_commentators_data as $key=>$val) {
		$kateshitsu_commentators_data[$key] = rtrim($val," , ");
	}
}


if ($komenteta_data != null) {
	foreach($komenteta_data as $key=>$val) {
		$komenteta_data[$key] = rtrim($val," , ");
	}
}
if ($assistant_operator_data != null) {
	foreach($assistant_operator_data as $key=>$val) {
		$assistant_operator_data[$key] = rtrim($val," , ");
	}
}
if ($head_of_judge_data != null) {
	foreach($head_of_judge_data as $key=>$val) {
		$head_of_judge_data[$key] = rtrim($val," , ");
	}
}
if ($judge_data != null) {
	foreach($judge_data as $key=>$val) {
		$judge_data[$key] = rtrim($val," , ");
	}
}
if ($oct_commentator_data != null) {
	foreach($oct_commentator_data as $key=>$val) {
		$oct_commentator_data[$key] = rtrim($val," , ");
	}
}
if ($ct_commentator_data != null) {
	foreach($ct_commentator_data as $key=>$val) {
		$ct_commentator_data[$key] = rtrim($val," , ");
	}
}
if ($shikai_data != null) {
	foreach($shikai_data as $key=>$val) {
		$shikai_data[$key] = rtrim($val," , ");
	}
}
if ($enja_data != null) {
	foreach($enja_data as $key=>$val) {
		$enja_data[$key] = rtrim($val," , ");
	}
}
if ($shinpojisuto_commentators_data != null) {
	foreach($shinpojisuto_commentators_data as $key=>$val) {
		$shinpojisuto_commentators_data[$key] = rtrim($val," , ");
	}
}
if ($advisor_data != null) {
	foreach($advisor_data as $key=>$val) {
		$advisor_data[$key] = rtrim($val," , ");
	}
}
if ($presentor_data != null) {
	foreach($presentor_data as $key=>$val) {
		$presentor_data[$key] = rtrim($val," , ");
	}
}
if ($ct_comenteta_data != null) {
	foreach($ct_comenteta_data as $key=>$val) {
		$ct_comenteta_data[$key] = rtrim($val," , ");
	}
}
if ($opeshitsu_director_data != null) {
	foreach($opeshitsu_director_data as $key=>$val) {
		$opeshitsu_director_data[$key] = rtrim($val," , ");
	}
}
if ($jutsusha_data != null) {
	foreach($jutsusha_data as $key=>$val) {
		$jutsusha_data[$key] = rtrim($val," , ");
	}
}
if ($chukei_tetsudai_data != null) {
	foreach($chukei_tetsudai_data as $key=>$val) {
		$chukei_tetsudai_data[$key] = rtrim($val," , ");
	}
}
if ($shinsaincho_data != null) {
	foreach($shinsaincho_data as $key=>$val) {
		$shinsaincho_data[$key] = rtrim($val," , ");
	}
}
if ($shinko_tetsudai_data != null) {
	foreach($shinko_tetsudai_data as $key=>$val) {
		$shinko_tetsudai_data[$key] = rtrim($val," , ");
	}
}
if ($accommodation_data != null) {
	foreach($accommodation_data as $key=>$val) {
		$accommodation_data[$key] = rtrim($val," , ");
	}
}

$o_smarty->assign("chairs",$chairs);
$o_smarty->assign("zacho_chairs",$zacho_chairs);
$o_smarty->assign("subscreen_chairs",$subscreen_chairs);
$o_smarty->assign("co_chairs",$co_chairs);
$o_smarty->assign("urazachos",$urazachos);
$o_smarty->assign("commentators",$commentators);
$o_smarty->assign("discussers",$discussers);
$o_smarty->assign("moderators",$moderators);
$o_smarty->assign("ivus_commentators",$ivus_commentators);
$o_smarty->assign("operators",$operators);
$o_smarty->assign("trainers",$trainers);
$o_smarty->assign("kateshitsu_commentators",$kateshitsu_commentators);


$o_smarty->assign("chairs_data",$chairs_data);
$o_smarty->assign("zachos_data",$zachos_data);
$o_smarty->assign("subscreen_chairs_data",$subscreen_chairs_data);
$o_smarty->assign("co_chairs_data",$co_chairs_data);
$o_smarty->assign("urazachos_data",$urazachos_data);
$o_smarty->assign("commentators_data",$commentators_data);
$o_smarty->assign("discussers_data",$discussers_data);
$o_smarty->assign("moderators_data",$moderators_data);
$o_smarty->assign("ivus_commentators_data",$ivus_commentators_data);
$o_smarty->assign("operators_data",$operators_data);
$o_smarty->assign("trainers_data",$trainers_data);
$o_smarty->assign("kateshitsu_commentators_data",$kateshitsu_commentators_data);


$o_smarty->assign("komenteta",$komenteta);
$o_smarty->assign("assistant_operator",$assistant_operator);
$o_smarty->assign("head_of_judge",$head_of_judge);
$o_smarty->assign("judge",$judge);
$o_smarty->assign("oct_commentator",$oct_commentator);
$o_smarty->assign("ct_commentator",$ct_commentator);
$o_smarty->assign("shikai",$shikai);
$o_smarty->assign("enja",$enja);
$o_smarty->assign("shinpojisuto",$shinpojisuto);
$o_smarty->assign("advisor",$advisor);
$o_smarty->assign("presentor",$presentor);
$o_smarty->assign("ct_comenteta",$ct_comenteta);
$o_smarty->assign("opeshitsu_director",$opeshitsu_director);
$o_smarty->assign("jutsusha",$jutsusha);
$o_smarty->assign("chukei_tetsudai",$chukei_tetsudai);
$o_smarty->assign("shinsaincho",$shinsaincho);
$o_smarty->assign("shinko_tetsudai",$shinko_tetsudai);
$o_smarty->assign("accommodation",$accommodation);


$o_smarty->assign("komenteta_data",$komenteta_data);
$o_smarty->assign("assistant_operator_data",$assistant_operator_data);
$o_smarty->assign("head_of_judge_data",$head_of_judge_data);
$o_smarty->assign("judge_data",$judge_data);
$o_smarty->assign("oct_commentator_data",$oct_commentator_data);
$o_smarty->assign("ct_commentator_data",$ct_commentator_data);
$o_smarty->assign("shikai_data",$shikai_data);
$o_smarty->assign("enja_data",$enja_data);
$o_smarty->assign("shinpojisuto_commentators_data",$shinpojisuto_commentators_data);
$o_smarty->assign("advisor_data",$advisor_data);
$o_smarty->assign("presentor_data",$presentor_data);
$o_smarty->assign("ct_comenteta_data",$ct_comenteta_data);
$o_smarty->assign("opeshitsu_director_data",$opeshitsu_director_data);
$o_smarty->assign("jutsusha_data",$jutsusha_data);
$o_smarty->assign("chukei_tetsudai_data",$chukei_tetsudai_data);
$o_smarty->assign("shinsaincho_data",$shinsaincho_data);
$o_smarty->assign("shinko_tetsudai_data",$shinko_tetsudai_data);
$o_smarty->assign("accommodation_data",$accommodation_data);


//keynote,ライブ
foreach($program_data as $pkey=>$pval) {
	//Keynote Lecture
	if (stristr($pval['lecture_title'],'keynote') ==true) {
		$program_data[$pkey]['lecture_title'] = str_replace('Keynote lecture:','',$program_data[$pkey]['lecture_title']);
		$program_data[$pkey]['keynote_flag'] = 'yes';
	}
	//ライブ
	$session_key = $pval['s_day_p'] . $pval['s_time_p'] . $pval['room_mei'];
	if ($program_data[$pkey]['live1'] == '1') {
		$live_flag[$session_key] = 'yes';
		$live_flag_yes[$session_key]['flag'] = 'yes';
		$live_flag_yes[$session_key]['live2'] = $pval['live2'];

		
	} else {
		$live_flag[$session_key] = 'no';
	}
}

//関連ライブ情報を取得
if ($live_flag_yes != null) {
	foreach($live_flag_yes as $l_key=>$l_val) {
		$live2_like = null;
		$live2_like = '%' . $live_flag_yes[$l_key]['live2'] . '%';
		$live_sql = "SELECT * from program where interid is not null and live2 like ? and live3 = '1' order by s_day_p,s_time_p,session_mei,session_mei_j,yakuwari,sname";
		
		$lc_result = $db->getAll($live_sql,array($live2_like),DB_FETCHMODE_ASSOC);
		
		if (DB::isError($lc_result)) {
			echo $lc_result->getMessage() . "<BR>";
			echo $lc_result->getDebugInfo();
			die("<BR>ERROR<BR>");
		}
		//日本語対応用
		foreach($lc_result as $lcr_key=>$lcr_val) {
			if ($lcr_val['kubun'] == 'Surgical' || $lcr_val['kubun'] == 'Co-medical') {
				$lc_result[$lcr_key]['session_mei'] = $lc_result[$lcr_key]['session_mei_j'];
			}
		}
		$live_chukei_data[$live_flag_yes[$l_key]['live2']] = $lc_result;
	}
	
	//var_dump($live_chukei_data);
	//exit;
	
	$o_smarty->assign("live_flag",$live_flag);
	$o_smarty->assign("live_chukei_data",$live_chukei_data);
}

//同時通訳
if ($program_data[0]['interpretation'] == '英語セッション：英⇒日のみあり'
	|| $program_data[0]['interpretation'] == '英語セッション：英⇒日のみ有'
	|| $program_data[0]['interpretation'] == '英語セッション：英語⇒日本語のみ有'
	) {
		$interpretation = 'ej';
} else if ($program_data[0]['interpretation'] == '英語セッション：日本語⇒英語のみ有'
	|| $program_data[0]['interpretation'] == '日本語セッション：日⇒英のみ有'
	) {
		$interpretation = 'je';
}
foreach($program_data as $key=>$val) {
	//セッショッッ名日本語
	$session_key = $val['s_day_p'] . $val['s_time_p'] . $val['room_mei'];
	if ($program_data[$key]['interpretation'] == '英語セッション：英⇒日のみあり'
		|| $program_data[$key]['interpretation'] == '英語セッション：英⇒日のみ有'
		|| $program_data[$key]['interpretation'] == '英語セッション：英語⇒日本語のみ有'
		) {
			$interpretation[$session_key] = 'ej';
	} else if ($program_data[$key]['interpretation'] == '英語セッション：日本語⇒英語のみ有'
		|| $program_data[$key]['interpretation'] == '日本語セッション：日⇒英のみ有'
		) {
			$interpretation[$session_key] = 'je';
	}
}
$o_smarty->assign("interpretation",$interpretation);
//スポンサー
$o_smarty->assign("sponsor",$program_data[0]['sponsor']);


//echo count($program_data);
//if ($_REQUEST['m'] == "ses") {
//	$o_smarty->display("2006/program/session_detail.tpl");
//}
if ($_REQUEST['hyoji_hoho'] == "list") {
	$o_smarty->assign("program_data",$program_data);
	$o_smarty->display("2008/program/search_result_list.tpl");
} else if ($_REQUEST['hyoji_hoho'] == "detail") {
	//echo count($program_data) . "件<BR>";
	//区分け
	$program_data_separated = null;
	foreach($program_data as $p_key=>$p_val) {
		
	}
	$o_smarty->assign("program_data",$program_data);
	$o_smarty->display("2008/program/search_result_printable.tpl");
}
exit;

?>