<?php
//*****************************************************************************
//* 
//* プログラム名：業務報告・指示
//* プログラムID：MET002.php
//* 機能        ：詳細表示、入力画面
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//*****************************************************************************
//*　インクルードファイル
//*****************************************************************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
include("./include/dbcon.inc");

//***************************
//*　画面制御
//***************************
include("inc/header.inc");
include("menu_opacity.php");
include("include/input_chk.inc");
include("inc/MET002.inc");

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

/*201310対応
if (empty($intPage)){
	$intPage=0;
}
*/
if (empty($intPage)||$intPage == 0){
	$intPage=0;
	$kaisiIti = 0;
}else{
	$kaisiIti = $intPage * 10;
}

//カテゴリマスタ情報取得
$strSQLmst = "SELECT category_name FROM mst_metcategory WHERE category_no=$category_no ";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objmst = pg_fetch_object($objRecmst, 0);
$category_name = $objmst->category_name;

//タイトルマスタ情報取得
$strSQLtitle = "SELECT title_name FROM mst_mettitle WHERE title_no=$title_no ";
$objRectitle = pg_exec($strSQLtitle);
if($objRectitle==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objTitle = pg_fetch_object($objRectitle, 0);
$title_name = $objTitle->title_name;

/* 201310対応　利用していない
//発言者情報取得
$strSQL="SELECT name_kj_sei,name_kj_mei,bumon_name FROM syain_tbl,syozoku_tbl,mst_bumon ".
				"WHERE syain_tbl.syain_cd='$PHP_SYAIN_CD' " .
				"AND syozoku_tbl.syain_cd=syain_tbl.syain_cd " .
				"AND syozoku_tbl.syozoku_cd=mst_bumon.syozoku_cd ".
				"ORDER BY mst_bumon.disp_rank" ;
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objData = pg_fetch_object($objRecSet, 0);
$name_kj_sei = $objData->name_kj_sei;
$name_kj_mei = $objData->name_kj_mei;
$bumon_name = $objData->bumon_name;
*/

//電子会議室情報取得
//201310　対応　$kanri_flgが1になることはないのでif文はずす
//201310　対応　社員が途中で追加になった場合の対応も遅延の原因なのでやめる。
/*
if( ($admin_session =="administrator") && ($kanri_flg==1)){
		//管理者
		$strSQLInfo = "SELECT meet_date,meet_time,memo,name_kj_sei,name_kj_mei,meet_tbl.seq,meet_tbl.syain_cd ".
									"FROM syain_tbl,meet_tbl " .
									"WHERE syain_tbl.syain_cd=meet_tbl.syain_cd and " .
									"meet_tbl.title_no=$title_no " .
									//"Order by f_flg ,meet_tbl.seq DESC";
									"ORDER BY f_flg ,meet_tbl.seq DESC ".
									"LIMIT 10 OFFSET ". $kaisiIti;
}else{
		//社員が途中で追加になった場合の対応
		$strSQLchk = "SELECT seq,meet_date,meet_time,memo,name_kj_sei,name_kj_mei,meet_tbl.seq,meet_tbl.syain_cd ".
								"FROM syain_tbl,meet_tbl " .
								"WHERE syain_tbl.syain_cd=meet_tbl.syain_cd " .
								"AND meet_tbl.title_no=$title_no " .
								"ORDER BY f_flg,meet_tbl.seq DESC ";
		$objRecchk = pg_exec($strSQLchk);
		if($objRecchk==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for ($intChk = 0; $intChk < pg_numrows($objRecchk); $intChk++) {
			$objchk = pg_fetch_object($objRecchk, $intChk);
			$intseq=$objchk->seq;
			$strSQL = "SELECT seq from pmeet_tbl Where syain_cd='$PHP_SYAIN_CD' and category_no=$category_no and title_no=$title_no and seq=$intseq ";
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if (pg_numrows($objRec) == 0){
				$strSQLp = "Insert Into pmeet_tbl (seq,syain_cd,category_no,title_no,read_flg) values ($intseq,'$PHP_SYAIN_CD',$category_no,$title_no,1)";
				$objRecp = pg_exec($strSQLp);
				if($objRecp==false){
					echo("SQL実行に失敗しました(INSERT)");
					exit;
				}
			}
		}
		$strSQLInfo = "SELECT read_flg,meet_date,meet_time,memo,name_kj_sei,name_kj_mei,meet_tbl.seq,meet_tbl.syain_cd ".
									"FROM syain_tbl,meet_tbl,pmeet_tbl " .
									"WHERE syain_tbl.syain_cd=meet_tbl.syain_cd and " .
									"pmeet_tbl.syain_cd ='$PHP_SYAIN_CD' and " .
									"pmeet_tbl.seq=meet_tbl.seq and " .
									"meet_tbl.title_no=$title_no " .
									"Order by f_flg ,read_flg,meet_tbl.seq DESC";
}
*/
//201310　対応
$strSQLInfo  = "";
$strSQLInfo  = "SELECT meet_date,meet_time,memo,name_kj_sei,name_kj_mei,meet_tbl.seq,meet_tbl.syain_cd,read_flg ";
$strSQLInfo .= "FROM syain_tbl, ";
$strSQLInfo .= "meet_tbl left outer join (SELECT read_flg, seq FROM pmeet_tbl WHERE pmeet_tbl.syain_cd = '$PHP_SYAIN_CD' AND category_no=$category_no) flg on meet_tbl.seq = flg.seq ";
$strSQLInfo .= "WHERE syain_tbl.syain_cd=meet_tbl.syain_cd ";
$strSQLInfo .= "AND meet_tbl.title_no=$title_no ";
$strSQLInfo .= "ORDER BY read_flg,meet_tbl.seq DESC ";
$strSQLInfo .= "LIMIT 10 OFFSET ".$kaisiIti;
$objRecInfo = pg_exec($strSQLInfo);
if($objRecInfo==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

/* 201310対応
$numRecInfo = pg_numrows($objRecInfo);
$page10times1plus = 10 * ($intPage+1);
*/

//終了ページの取得
/*　201310　対応で不要となる
$intEndCnt=10 * ($intPage+1);
if ($intEndCnt>pg_numrows($objRecInfo)){
	$intEndCnt=pg_numrows($objRecInfo);
}
*/
//　201310　対応
//for ($intCnt = 10 * $intPage; $intCnt < $intEndCnt; $intCnt++) {

for ( $intCnt = 0 ; $intCnt < pg_numrows($objRecInfo); $intCnt++ ) {
		$objInfo = pg_fetch_object($objRecInfo, $intCnt);
		//発言日時編集
		$strDate[$intCnt]=substr($objInfo->meet_date,0,4) . "年" . substr($objInfo->meet_date,5,2) . "月" .
											substr($objInfo->meet_date,8,2) . "日" . substr($objInfo->meet_time,0,2) . "時" .
											substr($objInfo->meet_time,3,2) ."分" ;

		$memo[$intCnt] = str_replace ("\n", "<BR>", $objInfo->memo);
		$memo[$intCnt] = str_replace ("\t", "　　", $memo[$intCnt]);
		$memo[$intCnt] = str_replace (" ", "&nbsp;", $memo[$intCnt]);
		$memo[$intCnt] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$memo[$intCnt]);
				
		$arrname_kj_sei[$intCnt] = $objInfo->name_kj_sei;
		$arrname_kj_mei[$intCnt] = $objInfo->name_kj_mei;
		//部門に新規で追加された人でだったら既読にしておく
		if ( is_null ($objInfo->read_flg) ) {
			$arrread_flg[$intCnt] = 1;
		} else {
			$arrread_flg[$intCnt] = $objInfo->read_flg;
		}

		$arrseq[$intCnt] = $objInfo->seq;

		//添付ファイル取得
		$strSQLF = "select * from meet_file_tbl where meet_seq = ".$objInfo->seq." AND comm_seq = 0 ORDER BY file_seq";
		$objRecF = pg_exec($strSQLF);
		if($objRecF==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if (pg_numrows($objRecF) > 0){
			for($fcnt=0;$fcnt<pg_numrows($objRecF);$fcnt++){
				$objF = pg_fetch_object($objRecF, $fcnt);
				$fileNameORG[$intCnt][$fcnt] = $objF->file_org;
				$fileName[$intCnt][$fcnt] = $strTempPath.$objF->file_name;
			}
		}

		/*201310対応　どこでも利用していない情報のため削除
		//未読、既読設定
		$strSQLmi = "SELECT read_flg FROM pmeet_tbl WHERE syain_cd = '$PHP_SYAIN_CD' AND seq = ". $objInfo->seq ." AND title_no = ".$title_no ;
		$objRecmi = pg_exec($strSQLmi);
		if($objRecmi==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if (pg_numrows($objRecmi) > 0){
			$objmi = pg_fetch_object($objRecmi, 0);
			$read_flg = $objmi->read_flg;
		}else{
			$read_flg = 1;
		}
		*/
		//部門名の取得
		$strSQLbumon = "SELECT bumon_name FROM mst_bumon,syozoku_tbl " .
										"WHERE syozoku_tbl.syain_cd = '$objInfo->syain_cd' and ".
										" mst_bumon.syozoku_cd = syozoku_tbl.syozoku_cd " .
										" Order by mst_bumon.disp_rank ";
		$objRecbumon = pg_exec($strSQLbumon);
		if($objRecbumon==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if (pg_numrows($objRecbumon) > 0){
			$objbumon = pg_fetch_object($objRecbumon, 0);
			$arrbumon_name[$intCnt] = $objbumon->bumon_name;
		}else{
			$arrbumon_name[$intCnt] = "";
		}

		//発言の削除
		$upd_flg[$intCnt]="";
		$del_flg[$intCnt] = "";
		
		if(($title_no != "") && ($category_no != "")){
			if ( $objInfo->syain_cd == $PHP_SYAIN_CD ){
				$upd_flg[$intCnt]=1;
				$del_flg[$intCnt]=1;
			}elseif ( $PHP_BIT[5] == 1 || $admin_session =="administrator" ) {
				//権限があったら削除ボタン表示
				$del_flg[$intCnt]=1;
			}
		/* 201310 対応　無駄なSQL文を削除
			//管理者権限取得している社員
			$strSQLtitle = "SELECT * FROM meet_tbl WHERE syain_cd = '$PHP_SYAIN_CD' AND seq=".$objInfo->seq;
			$objRectitle = pg_exec($strSQLtitle);
			if($objRectitle==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
			}
			if (pg_numrows($objRectitle)==1){
					$upd_flg[$intCnt]=1;
			}
			if (pg_numrows($objRectitle)==1 || $PHP_BIT[5] == 1 || $admin_session =="administrator"){
					$del_flg[$intCnt]=1;
			}
			*/
		}

		
		//201310対応　テンプレ整理して不要となったため
		//$arrintCnt[$i] = $intCnt;	利用していない
		//$numRecInfo1minus = pg_numrows($objRecInfo) - 1;
		

		//コメント取得
		$strSqlC = "SELECT comm_seq, meet_comm_tbl.syain_cd,comment, comm_date, syain_tbl.name_kj_sei, syain_tbl.name_kj_mei ";
		$strSqlC .= "FROM meet_comm_tbl JOIN syain_tbl ON syain_tbl.syain_cd = meet_comm_tbl.syain_cd ";
		$strSqlC .= "WHERE seq = ".$objInfo->seq." ORDER BY comm_seq desc";
		$objRecC = pg_exec($strSqlC);
		if($objRecC==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if (pg_numrows($objRecC) > 0){
			for($ic=0;$ic<pg_numrows($objRecC);$ic++){
				$objInfoC = pg_fetch_object($objRecC, $ic);
				$CommName[$intCnt][$ic] = $objInfoC->name_kj_sei.$objInfoC->name_kj_mei;
				$CommTime[$intCnt][$ic] = substr($objInfoC->comm_date,0,4)."年".substr($objInfoC->comm_date,4,2)."月".substr($objInfoC->comm_date,6,2)."日".substr($objInfoC->comm_date,8,2)."時".substr($objInfoC->comm_date,10,2)."分";
				$CommSeq[$intCnt][$ic] = $objInfoC->comm_seq;
				$Comment[$intCnt][$ic] = str_replace ("\n", "<BR>", $objInfoC->comment);
				$Comment[$intCnt][$ic] = str_replace ("\t", "　　", $Comment[$intCnt][$ic]);
				$Comment[$intCnt][$ic] = str_replace (" ", "&nbsp;", $Comment[$intCnt][$ic]);
				$Comment[$intCnt][$ic] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$Comment[$intCnt][$ic]);

				if($objInfoC->syain_cd == $PHP_SYAIN_CD || $PHP_BIT[5] == 1){
					$CommDel[$intCnt][$ic] = 1;
				}else{
					$CommDel[$intCnt][$ic] = 0;
				}
				//【追加】コメント可否
				if($objInfoC->syain_cd == $PHP_SYAIN_CD){
					$CommUpd[$intCnt][$ic] = 1;
				}else{
					$CommUpd[$intCnt][$ic] = 0;
				}

				//添付ファイル取得
				$strSQLF2 = "SELECT * FROM meet_file_tbl WHERE meet_seq = ".$objInfo->seq." AND comm_seq = ".$objInfoC->comm_seq." ORDER BY file_seq";
				$objRecF2 = pg_exec($strSQLF2);
				if($objRecF2==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}
				if (pg_numrows($objRecF2) > 0){
					for($fcnt2=0;$fcnt2<pg_numrows($objRecF2);$fcnt2++){
						$objF2 = pg_fetch_object($objRecF2, $fcnt2);
						$fileCommORG[$intCnt][$ic][$fcnt2] = $objF2->file_org;
						$fileComm[$intCnt][$ic][$fcnt2] = $strTempPath.$objF2->file_name;
					}
				}

			}
		}

}

//201310対応　ページ遷移ボタン設定
//全件数
$strSQL = "SELECT COUNT(*)  as cnt FROM syain_tbl,meet_tbl WHERE syain_tbl.syain_cd=meet_tbl.syain_cd and meet_tbl.title_no=$title_no ";
$objRecCntSet = pg_exec($strSQL);
if($objRecCntSet==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

if(pg_numrows($objRecCntSet)>0){
	$ftcData = pg_fetch_object($objRecCntSet,0);
	$numRecInfo = $ftcData->cnt;
}else{
	$numRecInfo = 0;
}
$page10times1plus = 10 * ($intPage+1);
$mae_pege =$intPage-1;
$usiro_page = $intPage+1;


//201310対応　次の10件ボタンの設定をテンプレから移植
$botton = "";
if (($intPage > 0) && ($numRecInfo > $page10times1plus)){
	$botton = "<input type='button' value='<<前の10件へ' name='Page' onClick='PageCnt(". $mae_pege .");'>";
	$botton .= "<input type='button' value='最新の発言へ' name='Page' onClick='first();'>";
	$botton .= "<input type='button' value='次の10件へ>>' name='Page' onClick='PageCnt(". $usiro_page .");'>";
}elseif (($intPage > 0) && ($numRecInfo <= $page10times1plus)){
	$botton = "<input type='button' value='<<前の10件へ' name='Page' onClick='PageCnt(". $mae_pege .");'>";
	$botton .= "<input type='button' value='最新の発言へ' name='Page' onClick='first();'>";
	$botton .= "<input type='button' value='次の10件へ>>' name='Page' readonly disabled>";
}elseif (($intPage == 0) && ($numRecInfo > $page10times1plus)){
	$botton = "<input type='button' value='<<前の10件へ' name='Page' readonly disabled>";
	$botton .= "<input type='button' value='最新の発言へ' name='Page' onClick='first();'>";
	$botton .= "<input type='button' value='次の10件へ>>' name='Page' onClick='PageCnt(". $usiro_page .");'>";
}else{
	$botton = "<input type='button' value='<<前の10件へ' name='Page' readonly disabled>";
	$botton .= "<input type='button' value='最新の発言へ' name='Page' onClick='first();'>";
	$botton .= "<input type='button' value='次の10件へ>>' name='Page' readonly disabled>";
}


$o_smarty->assign('kanri_flg',$kanri_flg);
$o_smarty->assign('category_name',$category_name);
$o_smarty->assign('title_name',$title_name);
$o_smarty->assign('category_no',$category_no);
$o_smarty->assign('title_no',$title_no);
/* 201310対応　利用していない関数
$o_smarty->assign('name_kj_sei',$name_kj_sei);
$o_smarty->assign('name_kj_mei',$name_kj_mei);
$o_smarty->assign('bumon_name',$bumon_name);
*/
$o_smarty->assign('intPage',$intPage);
//201310対応　テンプレ整理して不要となったため
/*
$o_smarty->assign('numRecInfo',$numRecInfo);
$o_smarty->assign('page10times1plus',$page10times1plus);
$o_smarty->assign('numRecInfo1minus',$numRecInfo1minus);
*/

$o_smarty->assign('strDate',$strDate);
$o_smarty->assign('arrname_kj_sei',$arrname_kj_sei);
$o_smarty->assign('arrname_kj_mei',$arrname_kj_mei);
$o_smarty->assign('arrbumon_name',$arrbumon_name);
$o_smarty->assign('memo',$memo);
$o_smarty->assign('arrread_flg',$arrread_flg);
$o_smarty->assign('arrseq',$arrseq);
$o_smarty->assign('del_flg',$del_flg);
$o_smarty->assign('upd_flg',$upd_flg);

$o_smarty->assign('CommName',$CommName);
$o_smarty->assign('CommTime',$CommTime);
$o_smarty->assign('Comment',$Comment);
$o_smarty->assign('CommDel',$CommDel);
$o_smarty->assign('CommSeq',$CommSeq);
$o_smarty->assign('CommUpd',$CommUpd);

/* 201310対応　利用していない関数
$o_smarty->assign('arrintCnt',$arrintCnt);
$o_smarty->assign('PHP_DISABLED',$PHP_DISABLED);
$o_smarty->assign('PHP_DISABLED_flg',$PHP_DISABLED_flg);
*/
$o_smarty->assign('fileName',$fileName);
$o_smarty->assign('fileNameORG',$fileNameORG);
$o_smarty->assign('fileComm',$fileComm);
$o_smarty->assign('fileCommORG',$fileCommORG);

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

//201310対応
$o_smarty->assign('botton',$botton);

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

?>