<?php 
//*****************************************************************************
//* 
//* プログラム名：電子会議室
//* プログラムID：MET921.php
//* 機能        ：電子会議室.修正
//* 作成者      ：
//* 
//*****************************************************************************

include("include/session_start.inc");
include("include/SessionChk.inc");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strTempPath="temp/".$PHP_FOLDER_NAME."/kaigi/";

//開始日時
if (strlen($selSM)==1) $selSM="0".$selSM;
if (strlen($selSD)==1) $selSD="0".$selSD;
if (strlen($selSH)==1) $selSH="0".$selSH;
$strSYMDH=$selSY.$selSM.$selSD.$selSH;

//終了日時
if (strlen($selEM)==1) $selEM="0".$selEM;
if (strlen($selED)==1) $selED="0".$selED;
if (strlen($selEH)==1) $selEH="0".$selEH;
$strEYMDH=$selEY.$selEM.$selED.$selEH;

//現在情報取得
$strSQL = "select file_name, file_name_jp, list_spk, list_obs from kaigi_info_tbl where meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objNo = pg_fetch_object($recData, 0);
$strFName = trim($objNo->file_name);
$strFnameJP = trim($objNo->file_name_jp);
$lstSPK = trim($objNo->list_spk);
$lstOBS = trim($objNo->list_obs);

//現在ファイル数
$intFNUM = 0;
if($strFName != ""){
	$arrTemp = split("/",$strFName);
	$intFNUM = count($arrTemp);
}
//ファイル追加あり？
$strADDFILE = "";
$strADDFILEJ = "";
if(count($file)>1){
	$j=$intFNUM + 1;
	for($i=1;$i<count($file);$i++){
		$file_name[$i]=str_replace("/","／",$file_name[$i]);
		$file_name[$i]=str_replace(".","/",$file_name[$i]);
		list($strname1,$strextension1)=split("/",$file_name[$i]);
		$file_name[$i]="kaigi_".$mtgNo."-".$j.".".$strextension1;
		$file_name1_jp=$strname1.".".$strextension1;
		$file1 = $strTempPath.$file_name[$i];
		move_uploaded_file($file[$i],$file1);
		$fileArr[]=$file_name[$i];
		$fileArrJ[]=$file_name1_jp;
		$j++;
	}
	$fileNM=join("/",$fileArr);
	$fileJP=join("/",$fileArrJ);

	if(substr($fileNM,0,1) == "/"){
		$fileNM = substr($fileNM,1);
	}
	if(substr($fileJP,0,1) == "/"){
		$fileJP = substr($fileJP,1);
	}

	if($intFNUM = 0){
		$strADDFILE = "file_name = '".$fileNM."', ";
		$strADDFILEJ = "file_name_jp = '".$fileJP."', ";
	}else{
		if($strFName == ""){
			$strADDFILE = "file_name = '".$fileNM."', ";
			$strADDFILEJ = "file_name_jp = '".$fileJP."', ";
		}else{
			$strADDFILE = "file_name = '".$strFName."/".$fileNM."', ";
			$strADDFILEJ = "file_name_jp = '".$strFnameJP."/".$fileJP."', ";
		}
	}
}

//発言者
$strADDSPK = "";
if ($hidSPADD != "/"){
	$strTemp = $lstSPK.$hidSPADD;
	$strTemp = str_replace("//","/",$strTemp);
	$strADDSPK = "list_spk = '".$strTemp."', ";
	$tmpADDSP = $hidSPADD;
}
//オブザーバ　発言者として登録した人ははずす
$strADDOBS = "";
if($hidOBADD != "/"){
	$strArr1=split("/",$hidSPADD);
	$strArr2=split("/",$hidOBADD);
	$strTemp="";
	for($i=1;$i<count($strArr2)-1;$i++){
		$flg=0;
		for($j=1;$j<count($strArr1)-1;$j++){
			if($strArr1[$j] == $strArr2[$i]){
				$flg=1;
				break;
			}
		}
		if($flg==0){
			$strTemp.="/". $strArr2[$i];
		}
	}
	$strTemp.="/";
	$tmpADDOB = $strTemp;
	if ($strTemp != "/"){
		$strTemp = $lstOBS.$strTemp;
		$strTemp = str_replace("//","/",$strTemp);
		$strADDOBS = "list_obs = '".$strTemp."', ";
	}
}
//$strSQL = "update kaigi_info_tbl set category_no = ".$selCategory.", theme = '".$txtTheme."', measure = '".$txtMeasure."', meeting_rule = '".$txtRule."', ";
$strSQL = "update kaigi_info_tbl set category_no = ".$selCategory.", theme = '".addslashes($txtTheme)."', meeting_rule = '".addslashes($txtRule)."', ";
$strSQL .= $strADDFILE.$strADDFILEJ.$strADDSPK.$strADDOBS;
$strSQL .= "etc = '".addslashes($txtEtc)."', date_start = '".$strSYMDH."', date_end = '".$strEYMDH."', notice_flg = ".$radNotice." where meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(UPDATE)");
	exit;
}

//pkaigi設定
//全発言取得
$strSQL = "select kaigi_tbl.meeting_no, kaigi_tbl.remark_no, kaigi_tbl.answer_no, kaigi_tbl.cp_answer_no, kaigi_info_tbl.category_no  ";
$strSQL .= "from kaigi_tbl join kaigi_info_tbl on kaigi_info_tbl.meeting_no = kaigi_tbl.meeting_no where kaigi_tbl.meeting_no = ".$mtgNo;
$recData=pg_exec($strSQL);
if($recData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
//発言者
if(trim($tmpADDSP) != ""){
	$tempArr = split("/",$tmpADDSP);
	for($i=1;$i<count($tempArr)-1;$i++){
		for($j=0;$j<pg_numrows($recData);$j++){
			$objFtc = pg_fetch_object($recData, $j);
			$strSQL = "insert into pkaigi_tbl (syain_cd, meeting_no, remark_no, answer_no, cp_answer_no, category_no, speak_flg, read_flg) ";
			$strSQL .= "values('".$tempArr[$i]."', ".($objFtc->meeting_no).", ".($objFtc->remark_no).", ".($objFtc->answer_no).", ".($objFtc->cp_answer_no).", ".($objFtc->category_no).", 1, 0)";
			$retINS=pg_exec($strSQL);
			if($retINS==false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
	}
}
//オブザーバ
if(trim($tmpADDOB) != ""){
	$tempArr = split("/",$tmpADDOB);
	for($i=1;$i<count($tempArr)-1;$i++){
		for($j=0;$j<pg_numrows($recData);$j++){
			$objFtc = pg_fetch_object($recData, $j);
			$strSQL = "insert into pkaigi_tbl (syain_cd, meeting_no, remark_no, answer_no, cp_answer_no, category_no, speak_flg, read_flg) ";
			$strSQL .= "values('".$tempArr[$i]."', ".($objFtc->meeting_no).", ".($objFtc->remark_no).", ".($objFtc->answer_no).", ".($objFtc->cp_answer_no).", ".($objFtc->category_no).", 0, 0)";
			$retINS=pg_exec($strSQL);
			if($retINS==false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
	}
}

?>

<script language="javascript">
function DoSubmit(){
	document.e_gru.action = "MET030.php";
	document.e_gru.method="POST";
	document.e_gru.submit();
	return false;
}
</script>
<body onload="DoSubmit()">
<form name = "e_gru" method="post"><input name='mtgNo'  type="hidden" value="<?php  echo $mtgNo ?>"></form>
</body>