<?php 

//*****************************************************************************

//* 

//* プログラム名：電子会議室詳細

//* プログラムID：MET040.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/MET040.inc");

//メニューセット
include("menu_opacity.php");

$strDBinc="include/dbcon.inc";
include($strDBinc);


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

$strTitle = "電子会議室（返信）";

$strSQL = "select theme, measure, meeting_rule, etc,date_start, date_end, chairperson, minutes_maker, list_spk, ";
$strSQL .= "file_name, file_name_jp, notice_flg, opener, mst_kaigi_category.category_name ";
$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 = $ftcData->theme;
$strMeasure = $ftcData->measure;
$strMeeting_rule = $ftcData->meeting_rule;
$strEtc = $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);

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

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

//発言・返信・議長返信
$strSQL = "select meeting_no, remark_no, answer_no, cp_answer_no, speak, date, ";
$strSQL .= "syain_tbl.name_kj_sei, syain_tbl.name_kj_mei ";
$strSQL .= "from kaigi_tbl ";
$strSQL .= "join syain_tbl on kaigi_tbl.person = syain_tbl.syain_cd ";
$strSQL .= "where meeting_no = ".$mtgNo." and remark_no = ".$remNo." and cp_answer_no = 0 " ;
$strSQL .= "order by answer_no desc, cp_answer_no desc";
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}


$fetchData = pg_fetch_object($recData,pg_numrows($recData)-1);
$strREM =  $fetchData->speak;


for($i=0;$i<pg_numrows($recData)-1;$i++){
	$fetchData = pg_fetch_object($recData,$i);
	$strSPK[$i] =  $fetchData->speak;
}



$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('strSpkFlg',$strSpkFlg);
//$o_smarty->assign('flgEnd',$flgEnd);
$o_smarty->assign('mtgNo',$mtgNo);
$o_smarty->assign('remNo',$remNo);

$o_smarty->assign('strSPK',$strSPK);
$o_smarty->assign('strREM',$strREM);
/*
$o_smarty->assign('intAnsNum',$intAnsNum);
$o_smarty->assign('intRemNo',$intRemNo);
*/

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

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

?>