<?php 
//*****************************************************************************
//* 
//* プログラム名：電子会議室詳細
//* プログラムID：MET030.php
//* 機能        ：電子会議室詳細画面
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/STRING.inc");
include('./include/smarty.conf');
include("inc/header.inc");
include("inc/input_chk.inc");
include("inc/MET030.inc");

//メニューセット
include("menu_opacity.php");
$strDBinc="include/dbcon.inc";
include($strDBinc);

$strTempPath="temp/".$PHP_FOLDER_NAME."/kaigi/";

//ＵＲＬ関数
function link_url($str){
		$regex = "((https?://|ftp://)([0-9A-Za-z:_?./~%;()=+#-]|&amp;)+)";
		$str = eregi_replace($regex, "<a href=\"\\1\" target=\"_blank\">\\1</a>", $str);

		$regex_mail = "((mailto:)?([0-9A-Za-z._-]+@[0-9A-Za-z.-]+))";
		$str = eregi_replace($regex_mail, "<a href=\"mailto:\\3\">\\1</a>", $str);

		return $str;
}

$strSQL="";
$objRec="null";

$strTitle = "電子会議室";

$strSQL = "select theme, measure, meeting_rule, etc,date_start, date_end, chairperson, minutes_maker, minutes, list_spk, list_obs, ";
$strSQL .= "file_name, file_name_jp, notice_flg, opener, mst_kaigi_category.category_name, mst_kaigi_category.category_no ";
$strSQL .= "from kaigi_info_tbl join mst_kaigi_category on mst_kaigi_category.category_no = kaigi_info_tbl.category_no ";
$strSQL .= "where meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$ftcData = pg_fetch_object($recData,0);

//テーマ・議題・ルール・特記事項・議長フラグ
$strTheme = link_url(str_replace ("\r\n","<br>",htmlspecialchars($ftcData->theme)));
$strMeasure = link_url(str_replace ("\r\n","<br>",htmlspecialchars($ftcData->measure)));
$strMeeting_rule = link_url(str_replace ("\r\n","<br>",htmlspecialchars($ftcData->meeting_rule)));
$strEtc = link_url(str_replace ("\r\n","<br>",htmlspecialchars($ftcData->etc)));

//期間
$strDate_start = $ftcData->date_start;
$strDate_end = $ftcData->date_end;
$strDate = (int) substr($strDate_start,0,4);
$strDate .= "年";
$strDate .= (int) substr($strDate_start,4,2);
$strDate .= "月";
$strDate .= (int) substr($strDate_start,6,2);
$strDate .= "日";
$strDate .= (int) substr($strDate_start,8,2);
$strDate .= "時　〜　";
$strDate .= (int) substr($strDate_end,0,4);
$strDate .= "年";
$strDate .= (int) substr($strDate_end,4,2);
$strDate .= "月";
$strDate .= (int) substr($strDate_end,6,2);
$strDate .= "日";
$strDate .= (int) substr($strDate_end,8,2);
$strDate .= "時";
//kaigi終了フラグ設定
$strTemp = date("Y").date("m").date("d").date("H");
$flgEnd = 0;
if($strDate_end <= $strTemp){
	$strDate .= "<font color=\"#FF0000\">　（終了）　</font>";
	$flgEnd = 1;
}

//議長・議事録作成者　番号
$strCPNo = trim($ftcData->chairperson);
$strMKNo = trim($ftcData->minutes_maker);
//会議修正・削除権
if(($strCPNo == $PHP_SYAIN_CD) || ($strCPNo == $PHP_SYAIN_CD)){
	$flgPower=1;
}
//議長か？
if(($strCPNo == $PHP_SYAIN_CD)){
	$flgCP=1;
}
//議事録作成権
if($strMKNo == $PHP_SYAIN_CD){
	$flgMinutesMK=1;
}
//参加者リスト
$strListSP = trim($ftcData->list_spk);
$strListOB = trim($ftcData->list_obs);

//資料ファイルパス
$strTemp = $ftcData->file_name;
if(trim($strTemp) != ""){
	$strFile_name = split("/",$strTemp);
	for($i=0;$i<count($strFile_name);$i++){
		$strFile_name[$i] = $strTempPath.$strFile_name[$i];
	}	
}

//資料日本語ファイル名
$strTemp = $ftcData->file_name_jp;
if(trim($strTemp) != ""){
	$strFile_name_jp = split("/",$strTemp);
}

//通知有無
$strNtc_flg = $ftcData->notice_flg;
//開設者　番号
$strOPNoener = trim($ftcData->opener);
//カテゴリ名
$strCTGName = $ftcData->category_name;
$strCTGNo = $ftcData->category_no;

//発言or傍観？
$strSyain = $ftcData->list_spk;
if(strpos($strSyain, "/".$PHP_SYAIN_CD."/") === false){
	$strSpkFlg = 0;
}else{
	$strSpkFlg = 1;
}

//議事録作成済み？
if(trim($ftcData->minutes) != ""){
	$flgMinutes=1;
}else{
	$flgMinutes=0;
}

//人
//議長
$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".$strCPNo."'";
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$ftcData = pg_fetch_object($recData,0);
$strCPName = ($ftcData->name_kj_sei).($ftcData->name_kj_mei);
//議事録作成者
$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".$strMKNo."'";
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$ftcData = pg_fetch_object($recData,0);
$strMKName = ($ftcData->name_kj_sei).($ftcData->name_kj_mei);
//開設者
$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".$strOPNoener."'";
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$ftcData = pg_fetch_object($recData,0);
$strOPName = ($ftcData->name_kj_sei).($ftcData->name_kj_mei);
//発言者
$arrTEMP = split("/", $strListSP);
$j=0;
$arrSP="";
for($i=1;$i<count($arrTEMP)-1;$i++){
		$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".$arrTEMP[$i]."'";
		$recData=pg_exec($strSQL);
		if($recData==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		$ftcData = pg_fetch_object($recData,0);
		if ($i % 2 ==1){
				$arrSP.='<tr bgcolor="#FFFFFF" class="voice">';
		}
		$arrSP .= '<td width="50%" align="center"><span class="Normalfont">'.($ftcData->name_kj_sei).($ftcData->name_kj_mei).'</span></td>';
		if ($i % 2 ==0){
				$arrSP.='</tr>';
		}
}
if ($i % 2 ==0){
		$arrSP .= '<td width="50%"><span class="Normalfont">　</span></td>';
		$arrSP.='</tr>';
}

//オブザーバ
$arrOB="";
if(trim($strListOB) != "/"){
	$arrTEMP = split("/", $strListOB);
	$j=0;
	for($i=1;$i<count($arrTEMP)-1;$i++){
			$strSQL = "select name_kj_sei, name_kj_mei from syain_tbl where syain_cd = '".$arrTEMP[$i]."'";
			$recData=pg_exec($strSQL);
			if($recData==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			$ftcData = pg_fetch_object($recData,0);
			if ($i % 2 ==1){
					$arrOB.='<tr bgcolor="#FFFFFF" class="voice">';
			}
			$arrOB .= '<td width="50%" align="center"><span class="Normalfont">'.($ftcData->name_kj_sei).($ftcData->name_kj_mei).'</span></td>';
			if ($i % 2 ==0){
					$arrOB.='</tr>';
			}
			$j++;
	}
	if ($i % 2 == 0){
			$arrOB .= '<td width="50%"><span class="Normalfont">　</span></td>';
			$arrOB.='</tr>';
	}
}else{
		$arrOB .='<tr bgcolor="#FFFFFF" class="voice">';
		$arrOB .= '<td colspan="2" align="center"><span class="Normalfont">なし</span></td>';
		$arrOB .='</tr>';
}

if ($PHP_TITLE_ID[6]!=""){
		$TEL_memo_Flg = 1;
}
$o_smarty->assign('strTitle',$strTitle);
$o_smarty->assign('strTheme',$strTheme);
$o_smarty->assign('strMeasure',$strMeasure);
$o_smarty->assign('strMeeting_rule',$strMeeting_rule);
$o_smarty->assign('strEtc',$strEtc);
$o_smarty->assign('strDate',$strDate);
$o_smarty->assign('strFile_name_jp',$strFile_name_jp);
$o_smarty->assign('strFile_name',$strFile_name);
$o_smarty->assign('strCTGName',$strCTGName);
$o_smarty->assign('strCTGNo',$strCTGNo);
$o_smarty->assign('strSpkFlg',$strSpkFlg);
$o_smarty->assign('flgEnd',$flgEnd);
$o_smarty->assign('mtgNo',$mtgNo);
$o_smarty->assign('flgPower',$flgPower);
$o_smarty->assign('flgMinutes',$flgMinutes);
$o_smarty->assign('flgMinutesMK',$flgMinutesMK);
$o_smarty->assign('strDate_start',$strDate_start);
$o_smarty->assign('strDate_end',$strDate_end);
$o_smarty->assign('strNtc_flg',$strNtc_flg);

$o_smarty->assign('flgCP',$flgCP);

$o_smarty->assign('strCPName',$strCPName);
$o_smarty->assign('strMKName',$strMKName);
$o_smarty->assign('strOPName',$strOPName);
$o_smarty->assign('arrSP',$arrSP);
$o_smarty->assign('arrOB',$arrOB);

$o_smarty->assign('TEL_memo_Flg',$TEL_memo_Flg);
$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[9]);

$o_smarty->display('MET030.tpl');

?>