require_once"./dbconfig.php";
require_once"./config.php";
require_once"../../db/util/nslib.php";
require "DB.php";
//検索条件
/*
if ($_REQUEST['m'] == "ses") {
$cond_sql .= " and session_mei = ?";
$cond_val[] = $_REQUEST['ses_name'];
}
*/
if ($_REQUEST['m'] == "ses") {
$cond_sql .= " and s_day_p = ? and s_time_p = ?";
$cond_val[] = $_REQUEST['sday'];
$cond_val[] = $_REQUEST['stime'];
if ($_REQUEST['live1'] =='1') {
if (ereg("Saint Luke", $_REQUEST['session_mei'])) {
$cond_sql .= " and session_mei like ?";
$cond_val[] = '%' . "Saint Luke" . '%';
} else {
$cond_sql .= " and session_mei = ?";
$cond_val[] = $_REQUEST['session_mei'];
}
} else {
$cond_sql .= " and room_mei = ?";
$cond_val[] = $_REQUEST['ro_name'];
}
}
//区分による日本語/英語判定
if ($_REQUEST['kbn'] == "" || $_REQUEST['kbn'] == null) {
$kbn = "cap";
} else if ($_REQUEST['kbn'] == "cap") {
$kbn = "cap";
} else if ($_REQUEST['kbn'] == "e") {
$kbn = "e";
} else if ($_REQUEST['kbn'] == "p") {
$kbn = "p";
} else if ($_REQUEST['kbn'] == "s") {
$kbn = "s";
} else if ($_REQUEST['kbn'] == "cm") {
$kbn = "cm";
} else {
$kbn = "cap";
}
$o_smarty->assign("kbn",$kbn);
$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() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
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() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
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";
$sql .= $cond_sql;
$sql .= " order by sewanin,yakuwari,sname";
//$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";
//$stt = $db->prepare($sql);
$result = $db->getAll($sql,$cond_val,DB_FETCHMODE_ASSOC);
if (DB::isError($result)) {
echo $result->getMessage() . "
";
echo $result->getDebugInfo();
die("
ERROR
");
}
$program_data = $result;
//座長とオペレータ等役割を分離
foreach($program_data as $key=>$val) {
//日英名前
$dr_name = null;
if ($kbn == "s" || $kbn == "cm") {
$dr_name = $val['pr_name_p'];
} else {
$dr_name = $val['pr_name_e'];
}
if ($val['yakuwari'] == "Chair") {
$chairs .= $dr_name . ",";
} else if ($val['yakuwari'] == "座長") {
$zacho_chairs .= $dr_name . ",";
} else if ($val['yakuwari'] == "Chair for sub-screen") {
$subscreen_chairs .= $dr_name . ",";
} else if ($val['yakuwari'] == "Co-Chair") {
$co_chairs .= $dr_name . ",";
} else if ($val['yakuwari'] == "裏座長") {
$urazachos .= $dr_name . ",";
} else if ($val['yakuwari'] == "Commentator") {
$commentators .= $dr_name . ",";
} else if ($val['yakuwari'] == "Discusser") {
$discussers .= $dr_name . ",";
} else if ($val['yakuwari'] == "Moderator") {
$moderators .= $dr_name . ",";
} else if ($val['yakuwari'] == "IVUS Commentator") {
$ivus_commentators .= $dr_name . ",";
} else if ($val['yakuwari'] == "Operator") {
$operators .= $dr_name . ",";
} else if ($val['yakuwari'] == "Trainer") {
$trainers .= $dr_name . ",";
} else if ($val['yakuwari'] == "カテ室コメンテーター") {
$kateshitsu_commentators .= $dr_name . ",";
} else if ($val['yakuwari'] == "コメンテーター") {
$komenteta .= $dr_name . ",";
} else if ($val['yakuwari'] == "Assistant Operator") {
$assistant_operator .= $dr_name . ",";
} else if ($val['yakuwari'] == "Head of Judge") {
$head_of_judge .= $dr_name . ",";
} else if ($val['yakuwari'] == "Judge") {
$judge .= $dr_name . ",";
} else if ($val['yakuwari'] == "OCT Commentator") {
$oct_commentator .= $dr_name . ",";
} else if ($val['yakuwari'] == "CT Commentator") {
$ct_commentator .= $dr_name . ",";
} else if ($val['yakuwari'] == "司会") {
$shikai .= $dr_name . ",";
} else if ($val['yakuwari'] == "演者") {
$enja .= $dr_name . ",";
} else if ($val['yakuwari'] == "シンポジスト") {
$shinpojisuto .= $dr_name . ",";
} else if ($val['yakuwari'] == "アドバイザー") {
$advisor .= $dr_name . ",";
} else if ($val['yakuwari'] == "プレゼンター") {
$presentor .= $dr_name . ",";
} else if ($val['yakuwari'] == "CTコメンテーター") {
$ct_comenteta .= $dr_name . ",";
} else if ($val['yakuwari'] == "オペ室ディレクター") {
$opeshitsu_director .= $dr_name . ",";
} else if ($val['yakuwari'] == "術者") {
$jutsusha .= $dr_name . ",";
} else if ($val['yakuwari'] == "中継手伝い") {
$chukei_tetsudai .= $dr_name . ",";
} else if ($val['yakuwari'] == "審査員長") {
$shinsaincho .= $dr_name . ",";
} else if ($val['yakuwari'] == "進行手伝い") {
$shinko_tetsudai .= $dr_name . ",";
} else if ($val['yakuwari'] == "Accommodation") {
$accommodation .= $dr_name . ",";
}
}
$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,",");
$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("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);
//Keynote Lecture
foreach($program_data as $pkey=>$pval) {
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';
}
}
//ライブ
//if (stristr($program_data[0]['session_mei'],'live') ==true) {
if ($program_data[0]['live1'] == 1) {
$live_flag = 'yes';
} else {
$live_flag = 'no';
}
$o_smarty->assign("live_flag",$live_flag);
//同時通訳
if ($program_data[0]['interpretation'] == '英語セッション:英語⇒日本語のみ有') {
$interpretation = 'ej';
} else if ($program_data[0]['interpretation'] == '日英同時通訳有'
|| $program_data[0]['interpretation'] == '日本語セッション:日本語⇒英語のみ有'
) {
$interpretation = 'je';
}
$o_smarty->assign("interpretation",$interpretation);
//スポンサー
$o_smarty->assign("sponsor",$program_data[0]['sponsor']);
$o_smarty->assign("program_data",$program_data);
if ($_REQUEST['m'] == "ses") {
$o_smarty->display("2006/program/session_detail.tpl");
}
exit;
?>