<?php 
//*****************************************************************************
//* 
//* プログラム名：スケジュール確認
//* プログラムID：TOP005.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("menu_opacity.php");

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


if($plan_kbn!=""){
	$plan_kbn1=$plan_kbn;
}
$youbi=array("日曜日","月曜日","火曜日","水曜日","木曜日","金曜日","土曜日");

//*****日付編集*****//
	$wk_year=substr($strwkdate, 0, 4);
	$wk_mon=substr($strwkdate, 4, 2);
	$wk_day=substr($strwkdate, 6, 2);

//*****社員情報取得(登録者用)*****//
	if ($syain_cd!=""){
		$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='$syain_cd'";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if (pg_numrows($objRecSet)>0){
			$objRecData = pg_fetch_object($objRecSet, 0);
			$strName=$objRecData->name_kj_sei.$objRecData->name_kj_mei;
		}
	}
//*****スケジュール情報取得*****//
	if (($intseq!=0) && ($intaddsts==0)){
		$strSQL="SELECT seq,disp_cd,write_cd,scdl_st_date,scdl_ed_date,".
				"scdl_st_time,scdl_ed_time,scdl_plan,scdl_place,scdl_biko,".
				"scdl_type,share_syain,scdl_code,flg_share,share_syain,flg_pub,link_cd,".
				"plan_kbn,plan_komoku ".
				"FROM schedule_tbl WHERE seq=$intseq";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		$objRecData = pg_fetch_object($objRecSet, 0);

		$strSyainSQL = "SELECT * FROM syain_tbl Where syain_cd='$objRecData->write_cd'";
		$objSyainRec = pg_exec($strSyainSQL);
		if($objSyainRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		$objSyainData = pg_fetch_object($objSyainRec, 0);
		$write_name=$objSyainData->name_kj_sei.$objSyainData->name_kj_mei;
		$scdl_type=$objRecData->scdl_type;
		$scdl_code=$objRecData->scdl_code;
		list($st_year,$st_mon,$st_day)=split("/",$objRecData->scdl_st_date);
		list($ed_year,$ed_mon,$ed_day)=split("/",$objRecData->scdl_ed_date);
		$scdl_st_date=$objRecData->scdl_st_date;
		$scdl_ed_date=$objRecData->scdl_ed_date;
		list($st_hour,$st_minute)=split(":",$objRecData->scdl_st_time);
		list($ed_hour,$ed_minute)=split(":",$objRecData->scdl_ed_time);
		$schedule=$objRecData->scdl_plan;
		$place=$objRecData->scdl_place;
		$detail=LINE_BR($objRecData->scdl_biko,60);
		$flg_share=$objRecData->flg_share;
		$flg_pub=$objRecData->flg_pub;
		$plan_kbn1=$objRecData->plan_kbn;
		$plan_komoku=$objRecData->plan_komoku;
		if (is_null($objRecData->link_cd)){
			$link_cd=0;
		}
		else{
			$link_cd=$objRecData->link_cd;
		}

		$strJyoken=str_replace("/","' or syain_cd='",$objRecData->share_syain);
		$strSQLSyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl ".
							"Where syain_cd=" . "'" .$strJyoken ."'" .
							" Order by disp_rank";
		$objRecSet = pg_exec($strSQLSyain);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for ($intCnt = 0; $intCnt < pg_numrows($objRecSet); $intCnt++) {
			$objRecData = pg_fetch_object($objRecSet, $intCnt);
			$strAddSyain[$intCnt][0]=$objRecData->syain_cd;
			$strAddSyain[$intCnt][1]=$objRecData->name_kj_sei.$objRecData->name_kj_mei;
		}
		$strSisetu="";
		if ($link_cd!=0){
			//*****施設情報取得*****//
			$strSQL="Select rsv_no From sisetu_TBL WHERE seq=$link_cd";
			$objRecSet = pg_exec($strSQL);
			if($objRecSet==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			//20081114 追加
			if(pg_numrows($objRecSet)!=0){
				$objRecData = pg_fetch_object($objRecSet, 0);
				$intsisetu=$objRecData->rsv_no;

				$strSQL="Select seq,sisetu_name,disp_rank From mst_sisetu Where seq=$intsisetu";
				$objRecSet = pg_exec($strSQL);
				if($objRecSet==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}	
				$objRecData = pg_fetch_object($objRecSet, 0);
				$strSisetu=$objRecData->sisetu_name;
			}
		}

	}

//*****社員情報取得(共有リスト用)*****//
	$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl ".
			"Where del_flg=true Order by disp_rank";
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	for ($intCnt = 0; $intCnt < pg_numrows($objRecSet); $intCnt++) {
		$objRecData = pg_fetch_object($objRecSet, $intCnt);
		$strAllSyain[$intCnt][0]=$objRecData->syain_cd;
		$strAllSyain[$intCnt][1]=$objRecData->name_kj_sei.$objRecData->name_kj_mei;
	}

	if (($intaddsts == 1) || ($intaddsts == 2)){
		$strJyoken=str_replace("/","' or syain_cd='",$strsel);
		$strSQLSyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl ".
							"Where syain_cd=" . "'" .$strJyoken ."'" .
							" Order by disp_rank";
		$objRecSet = pg_exec($strSQLSyain);
		if($objRecData==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for ($intCnt = 0; $intCnt < pg_numrows($objRecSet); $intCnt++) {
			$objRecData = pg_fetch_object($objRecSet, $intCnt);
			$strAddSyain[$intCnt][0]=$objRecData->syain_cd;
			$strAddSyain[$intCnt][1]=$objRecData->name_kj_sei.$objRecData->name_kj_mei;
		}
		if ($scdl_type==1){
			$scdl_code=$scdl_yobi;
		}
		elseif ($scdl_type==2){
			$scdl_code=$scdl_day;
		}

	}


	//**** ＤＢ接続 ****//
	$strDBinc="include/dbcon.inc";
	include($strDBinc);
?>

<form name="e_gru">
<br>
<!--入力フォーム-->
<?php  
	if ($strName!=""){
		echo "<span class=Normalfont>".$strName."さんのスケジュール確認</span>";
	}
 ?>
<BR>
<table width="602" border="0" cellspacing="1" cellpadding="1" class="mainColor">
	<tr><td>
	<TABLE cellspacing="1" cellpadding="1" width="600" align="center" class="mainColor" border="0">
		<TBODY>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>入力者</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<span class="Normalfont"><?php echo $write_name; ?></span>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>設定日</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<span class="Normalfont"><?php echo $wk_year; ?>年<?php echo $wk_mon; ?>月<?php echo $wk_day; ?>日</span>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>パターン</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
			<?php 
				if ($scdl_type==0){
					echo "<span class=Normalfont>標準</span>";
				}
				elseif ($scdl_type==1){
					echo "<span class=Normalfont>毎週　".$youbi[$scdl_code]."</span>";
				}
				elseif ($scdl_type==2){
					//20090818 月末対応
					if ($scdl_code == 32){
						$scdl_code = "月末";
					}else{
						$scdl_code = $scdl_code."日";
					}
					echo "<span class=Normalfont>毎月　".$scdl_code."</span>";
				}
			?>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>予定日付</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<span class="Normalfont">
					<?php echo $st_year; ?>年<?php echo $st_mon; ?>月<?php echo $st_day?>日　〜　<?php echo $ed_year; ?>年<?php echo $ed_mon; ?>月<?php echo $ed_day; ?>日
				</span>
			</TD>
		</TR>
		<TR>
			<TD height="30" width="150" class="toneDown"><span class="Normalfont">予定時刻</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<?php 
					$strtime="";
					if ($st_hour!=""){
						$strtime=$st_hour."時".$st_minute."分";
					}
					if ($ed_hour!=""){
						$strtime=$strtime."〜".$ed_hour."時".$ed_minute."分";
					}
				?>
				<span class="Normalfont"><?php echo $strtime; ?></span>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>予定種別</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<?php 
					if ($plan_kbn1 == "0"){
						$strsyubetu="";
					}
					elseif ($plan_kbn1 == "1"){
						$strsyubetu="社内";
					}
					elseif ($plan_kbn1 == "2"){
						$strsyubetu="社外";
					}
					elseif ($plan_kbn1 == "3"){
						$strsyubetu="その他　(".$plan_komoku.")";
					}
				?>
				<span class=Normalfont><?php echo $strsyubetu; ?></span>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>予定</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff"><span class=Normalfont><?php  echo $schedule; ?></span></TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>場所</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff"><span class=Normalfont><?php  echo $place; ?></span></TD>
		</TR>
		<TR>
			<TD vAlign=center width=300 height=25 class="toneDown"><span class=Normalfont>備考</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff"><span class=Normalfont><?php  echo $detail; ?></span></TD>
		</TR>
		<TR>
			<TD class="toneDown"><span class="Normalfont">共有</span></TD>
			<TD bgColor=#ffffff>
				<?php 
				$intMax=count($strAddSyain);
				if ($intMax != 0){
					for ($intCnt = 0; $intCnt < $intMax; $intCnt++) {
						echo "<span class=Normalfont>".$strAddSyain[$intCnt][1]."</span><BR>";
					}
				}
				?>
			</TD>
			</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>公開/非公開</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<?php 
					if ($flg_pub == 0){
						echo "<span class=Normalfont>公開</span>";
					}
					else{
						echo "<span class=Normalfont>非公開</span>";
					}
				?>
			</TD>
		</TR>
		<TR>
			<TD width=300 height=25 class="toneDown"><span class=Normalfont>施設予約</span></TD>
			<TD width=953 height=25 bgcolor="#ffffff">
				<span class=Normalfont><?php  echo $strSisetu; ?></span>
			</TD>
		</TR>
		</TBODY>
		</TABLE>
	</TD>
	</TR>
</TABLE>
<TABLE>
	<TR>
<?php  
	if($syain_cd==$PHP_SYAIN_CD){
		$PHP_BIT_SCE = 1;
	}else{
		$PHP_BIT_SCE = $PHP_BIT[1];
	}
	if($PHP_BIT_SCE == 1){ ?>
		<TD width=953 colSpan=3 height=25><INPUT onclick="return schedule(<?php  echo "'".$syain_cd."',".$intseq; ?>);" type=button value="全体変更"><?php  if ($scdl_st_date!=$scdl_ed_date){ ?><INPUT onclick="change(<?php  echo "'".$syain_cd."',".$intseq; ?>)" type=button value="この日のみ変更"><?php  } ?>
<?php 	}	?>
<INPUT onclick="move_top(<?php  echo $strkijyunDate; ?>);"type=button value="キャンセル"></TD>
	</TR>
</TABLE>
<br>
<br>
<hr width="967">
<?php 
//コピーライト
include("include/copyright.inc");
?>
<input type="hidden" name="intseq" value=<?php  echo $intseq; ?>>
<input type="hidden" name="syain_cd" value=<?php  echo $syain_cd; ?>>
<input type="hidden" name="strwkdate" value=<?php  echo $strwkdate; ?>>
<input type="hidden" name="strkijyunDate" value=<?php  echo $strkijyunDate; ?>>
<input type="hidden" name="intGmflg" value=<?php  echo $intGmflg; ?>>
<input type="hidden" name="link_cd" value=<?php  echo $link_cd; ?>>
<input type="hidden" name="intdelflg" value="">
<input type="hidden" name="scdl_bumon" value="<?php  echo $intbumon; ?>"> 
<input type="hidden" name="intbumon" value="<?php  echo $intbumon; ?>"> 
</form>
</BODY>
</HTML>