<?php 
//*****************************************************************************
//* 
//* プログラム名：回覧板
//* プログラムID：CIR004.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("include/input_chk.inc");
include("inc/CIR004.inc");
//メニューセット
include("menu_opacity.php");
$strDBinc="include/dbcon.inc";
include($strDBinc);

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

$strSQLmst="";
$objRecmst="null";
$strSQL="";
$objRec="null";

//回覧板マスタ情報取得
$strSQLmst="SELECT date,time,title,memo,name_kj_sei,name_kj_mei,kairan_tbl.syain_cd,filename,filename_jp,filename2,filename_jp2,filename3,filename_jp3,date_kigen,time_kigen,readonly_list,open_flg from kairan_tbl,syain_tbl " .
			"Where seq=$seq and syain_tbl.syain_cd=kairan_tbl.syain_cd";

$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objmst = pg_fetch_object($objRecmst,0);
$strMemo=str_replace ("\n", "<BR>", $objmst->memo);
$strMemo = str_replace ("\t", "　　", $strMemo);
$strMemo = str_replace (" ", "&nbsp;", $strMemo);
$strMemo = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$strMemo);


$splitlen=80;

//ファイル1
$filename1=$objmst->filename;
$filename_jp1=str_replace("'","’",$objmst->filename_jp);
$strFileNm="";
if ($objmst->filename_jp!=""){
	$strFileNm=LINE_DEL($objmst->filename_jp,80);
}

//ファイル2
$filename2=$objmst->filename2;
$filename_jp2=str_replace("'","’",$objmst->filename_jp2);
$strFileNm2="";
if ($objmst->filename_jp2!=""){
	$strFileNm2=LINE_DEL($objmst->filename_jp2,80);
}

//ファイル3
$filename3=$objmst->filename3;
$filename_jp3=str_replace("'","’",$objmst->filename_jp3);
$strFileNm3="";
if ($objmst->filename_jp3!=""){
	$strFileNm3=LINE_DEL($objmst->filename_jp3,80);
}

//閲覧のみ
$readonly_cd=$objmst->readonly_list;
$tok = strtok($readonly_cd, "/");

while ($tok !== false) {
	if ($tok==$PHP_SYAIN_CD){
		$readonly_flg = 1;
	}
	$tok = strtok("/");
}

//回答の公開設定
$open_flg=$objmst->open_flg;

//回覧板詳細取得
$strSQL="SELECT pkairan_tbl.seq,pkairan_tbl.syain_cd,pkairan_tbl.date,pkairan_tbl.time,pkairan_tbl.memo,pkairan_tbl.read_flg,name_kj_sei,name_kj_mei,kairan_tbl.title FROM pkairan_tbl,syain_tbl,kairan_tbl ".
			"Where  syain_tbl.syain_cd =pkairan_tbl.syain_cd and kairan_tbl.seq=pkairan_tbl.seq and pkairan_tbl.seq ='$seq'" .
			"Order by disp_rank";

$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

$strMyComment="";
$view_flg=0;
for ($intCnt = 0; $intCnt < pg_numrows($objRec) ; $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);
	if ($objData->syain_cd==$PHP_SYAIN_CD) {
			$strMyComment=$objData->memo;
			$strMyComment_area='<textarea name="your_memo" rows="5" cols="80">'.$strMyComment.'</textarea>';
			$view_flg=1;
	}
}
	if($objData->syain_cd==$PHP_SYAIN_CD){
		$read_flg = $objData->read_flg;
	}
	$strButtonDisp=" 回 答 ";
	$PhpDate = $objmst->date;
	$PhpTime = $objmst->time;
	$PhpDate_kigen = $objmst->date_kigen;
	$PhpTime_kigen = $objmst->time_kigen;
	$PhpTitle = $objmst->title;
	$PhpName_kj_sei = $objmst->name_kj_sei;
	$PhpName_kj_mei = $objmst->name_kj_mei;


	if ($PhpTime_kigen == "") {
		$PhpTime_kigen = "回覧期限の設定がありません";
		//mktimeエラー回避
		$PhpTime_kigen2 = "";	
	}else{
		$PhpTime_kigen = $PhpTime_kigen."　まで";
		//mktimeエラー回避
		$PhpTime_kigen2 = $PhpTime_kigen;
	}

	$PhpSeq = $objData->seq;
	$o_smarty->assign('PhpDate',$PhpDate);
	$o_smarty->assign('PhpTime',$PhpTime);
	$o_smarty->assign('PhpDate_kigen',$PhpDate_kigen);
	$o_smarty->assign('PhpTime_kigen',$PhpTime_kigen);
	$o_smarty->assign('PhpTitle',$PhpTitle);
	$o_smarty->assign('PhpName_kj_sei',$PhpName_kj_sei);
	$o_smarty->assign('PhpName_kj_mei',$PhpName_kj_mei);
	$o_smarty->assign('PhpSeq',$PhpSeq);
	$o_smarty->assign('strTempPath',$strTempPath);

	if (($filename1!="") || ($filename2!="") || ($filename3!="")){

		if (trim($filename_jp1) != ""){

			$o_smarty->assign('strFileNm',$strFileNm);
			$o_smarty->assign('filename1',$filename1);
			$o_smarty->assign('filename_jp1',$filename_jp1);

		}
		if (trim($filename_jp2) != ""){
			$o_smarty->assign('strFileNm2',$strFileNm2);
			$o_smarty->assign('filename2',$filename2);
			$o_smarty->assign('filename_jp2',$filename_jp2);

		}
		if (trim($filename_jp3) != ""){
			$o_smarty->assign('strFileNm3',$strFileNm3);
			$o_smarty->assign('filename3',$filename3);
			$o_smarty->assign('filename_jp3',$filename_jp3);
		}
	}
	$o_smarty->assign('strMemo',$strMemo);

	//mktimeエラー回避
	if ($PhpTime_kigen2 == "") {
		$PhpDate_kigen = Date("Y/m/d");
		$PhpTime_kigen2 = Date("H:i");
	}

	list($year, $month, $day) = split('[/]', $PhpDate_kigen);
	list($hr, $min ) = split('[:]', $PhpTime_kigen2);
	$sec="00";
	$now = time();

	$kigen=mktime($hr, $min, $sec, $month, $day ,$year);

	if ($kigen == -1) {
		$sabun = 1;
	}else{
		$sabun=$kigen - $now;
	}
	$input = '<input type="button" onclick="return chk('.$PhpSeq.',1,0);" value="　回答する　">';
	$reset = '<input type="button" value="入力クリア" onClick="document.e_gru.your_memo.value=\'\'">';

	if ($readonly_flg==1){
		if ($read_flg==0){
			$strMyComment_area='<span class="Chufont">'."\n"."未読の場合は閲覧確認ボタンを押してください"."\n".'</span><input type="hidden" name="your_memo" value="">';
			$input = '<input type="button" onclick="return chk('.$PhpSeq.',1,0);" value="　閲覧確認　">';
			$reset = "";
		}else{
			$strMyComment_area='<span class="Chufont">'."\n"."閲覧確認済み"."\n".'</span>';
			$input = "";
			$reset = "";
		}
	}elseif($sabun < 0){
		if ($read_flg==0){
			$strMyComment_area='<span class="Chufont">'."\n"."回答期限が過ぎていますのでコメントの記入はできません"."<br>"."未読の場合は閲覧確認ボタンを押してください"."\n".'</span><input type="hidden" name="your_memo" value="">';
			$input = '<input type="button" onclick="return chk('.$PhpSeq.',1,0);" value="　閲覧確認　">';
			$reset = "";
		}else{
//			$strMyComment_area='<span class="Chufont">'."\n"."回答期限が過ぎていますのでコメントの記入はできません"."<br>"."未読の場合は閲覧確認ボタンを押してください"."\n".'</span><input type="hidden" name="your_memo" value="">';
//			$input = '<input type="button" onclick="return chk('.$PhpSeq.',1,0);" value="　閲覧確認　">';
//			$reset = "";

			$strMyComment_area='<span class="Chufont">'."\n"."回答期限が過ぎていますのでコメントの記入はできません"."\n".'</span>';
			$input = "";
			$reset = "";

		}
	}elseif($view_flg==1){
		$o_smarty->assign('strMyComment_area',$strMyComment_area);
	}else{
		$strMyComment_area='<textarea name="your_memo" rows="5" cols="80"></textarea>';
	}
	$o_smarty->assign('strMyComment_area',$strMyComment_area);
	$o_smarty->assign('input',$input);
	$o_smarty->assign('reset',$reset);

	//回覧先	
	for ($intCnt = 0; $intCnt < pg_numrows($objRec) ; $intCnt++) {
		$objData = pg_fetch_object($objRec, $intCnt);
		
		$strComent = str_replace ("\n", "<BR>", $objData->memo);
		$strComent = str_replace ("\t", "　　", $strComent);
		$strComent = str_replace ("\s", "&nbsp;", $strComent);
		$strComent = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$strComent);
		
		$PhpEtcName_kj_sei[$intCnt] = $objData->name_kj_sei;
		$PhpEtcName_kj_mei[$intCnt] = $objData->name_kj_mei;
		$PhpEtcDate[$intCnt] = $objData->date;
		$PhpEtcTime[$intCnt] = $objData->time;

		if ($open_flg==1){
			if (($objmst->syain_cd==$PHP_SYAIN_CD) ){
				$PhpEtcComent[$intCnt] = $strComent;
			}else{
				$PhpEtcComent[$intCnt] = "回答は非公開になっています";
			}
		}else{
			$PhpEtcComent[$intCnt] = $strComent;
		}
	}

	$o_smarty->assign('PhpEtcName_kj_sei',$PhpEtcName_kj_sei);
	$o_smarty->assign('PhpEtcName_kj_mei',$PhpEtcName_kj_mei);
	$o_smarty->assign('PhpEtcDate',$PhpEtcDate);
	$o_smarty->assign('PhpEtcTime',$PhpEtcTime);
	$o_smarty->assign('PhpEtcComent',$PhpEtcComent);
	
	$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[7]);

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


?>