<?php 
//*****************************************************************************
//* 
//* プログラム名：施設予約
//* プログラムID：RES002.php
//* 機能				：入力画面
//* 作成者			：
//* 
//*****************************************************************************


header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include('include/smarty.conf');
include("inc/mtc_comfunc.inc");
include("inc/header.inc");


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

	$syain_cd=$PHP_SYAIN_CD;

	//施設名取得
	$strSQL="";
	$objRecSet="null";
	$Data="null";

	$strSQL="Select sisetu_name From mst_sisetu WHERE seq=$sisetu";
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}

	$Data = pg_fetch_object($objRecSet, 0);
	$strsisetu=$Data->sisetu_name;


	//日付編集
	$rsv_styear=substr($strwkdate, 0, 4);
	$rsv_stmon=substr($strwkdate, 4, 2);
	$rsv_stday=substr($strwkdate, 6, 2);
	$rsv_edyear=substr($strwkdate, 0, 4);
	$rsv_edmon=substr($strwkdate, 4, 2);
	$rsv_edday=substr($strwkdate, 6, 2);


	//データ取得
	if ($intsts != 0) {
			$strSQL="";
			$objRecSet="null";
			$Data="null";
			$strSQL="Select syain_cd,rsv_st_date,rsv_ed_date,rsv_st_time,rsv_ed_time,".
					"reg_date,reg_time,contact,purpose,resume,link_cd,rev_type,rev_code,reserve_mode,except_flg".
					" From sisetu_TBL WHERE seq=$intsts";
			$objRecSet = pg_exec($strSQL);
			if($objRecSet==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}

			$Data = pg_fetch_object($objRecSet, 0);

			//開始日
			list($rsv_styear,$rsv_stmon,$rsv_stday)=split("/", $Data->rsv_st_date);
			echo $Data->rsv_date_b;

			//終了日
			list($rsv_edyear,$rsv_edmon,$rsv_edday)=split("/", $Data->rsv_ed_date);

			//開始時刻
			if ($Data->rsv_st_time != ""){
				list($rsv_st_hour,$rsv_st_mini)=split(":", $Data->rsv_st_time);
			}

			//終了時刻
			if ($Data->rsv_ed_time != ""){
				list($rsv_ed_hour,$rsv_ed_mini)=split(":", $Data->rsv_ed_time);
			}

			$contact = htmlspecialchars(mtc_rtrim($Data->contact));
			$purpose = htmlspecialchars(mtc_rtrim($Data->purpose));
			$resume  = htmlspecialchars(mtc_rtrim($Data->resume));
			$syain_cd=$Data->syain_cd;
			$link_cd=$Data->link_cd;
			$rev_type=$Data->rev_type;
			$rev_code=$Data->rev_code;
			if ($link_cd==0){
				$strlink="なし";
			}
			else{
				$strlink="あり";
			}

			//仮予約/本予約
			if(($Data->reserve_mode) == 1 ){
				$sttsTemp = "checked";
			}else{
				$sttsTemp = "";
			};

			//休日除く？
			if(($Data->except_flg) == 1 ){
				$sttsDay = "checked";
			}else{
				$sttsDay = "";
			};
	}



	//<!--入力フォーム-->

	$week="";

	$Data_Array1=array("------","日曜日","月曜日","火曜日","水曜日","木曜日","金曜日","土曜日");
	$Data_Array2=array("99","0","1","2","3","4","5","6");
	for ($intCnt = 0 ; $intCnt <= count($Data_Array1)-1 ; $intCnt++) {
			$week.="<OPTION value=".$Data_Array2[$intCnt];
			if ($rev_code == $Data_Array2[$intCnt]){
					$week.= " selected";
			} 
			$week.= ">".$Data_Array1[$intCnt]."</OPTION>";
	}

	$month="<OPTION value=99 ";
	if ($rev_code == "99"){ 
			$month.= " selected";
	} 

	$month.=">----</OPTION>";
	for ($intCnt = 1 ; $intCnt <= 31 ; $intCnt++) {
			if (($rev_code == $intCnt) && ($rev_type==2)) {
					$month.= "<option value=$intCnt selected>".$intCnt."日</option>\n";
			}else{
					$month.= "<option value=$intCnt>".$intCnt."日</option>\n";
			}
	}
	//20090818 月末対応 「32」を月末とします
	if (($rev_code== 32) && ($rev_type==2)) {
		$month .= "<option value=32 selected>月末</option>\n";
	}else{
		$month .= "<option value=32>月末</option>\n";
	}

	switch($rev_type){
			case 0:$rev_type_Mode[0]=" checked";break;
			case 1:$rev_type_Mode[1]=" checked";break;
			case 2:$rev_type_Mode[2]=" checked";break;
			default :$rev_type_Mode[0]=" checked";break;
	}


	//人情報取得
	$strSQL="";
	$objRecSet="null";
	$Data="null";
	$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;
	}

	$intMax=pg_numrows($objRecSet);
	for($intCnt = 0; $intCnt < $intMax ; $intCnt++) {
			$Data = pg_fetch_object($objRecSet, $intCnt);
			$strName=$Data->name_kj_sei.$Data->name_kj_mei;
			if ($Data->syain_cd==$syain_cd){
					$yoyakusya .= "<OPTION value=$Data->syain_cd selected>$strName</OPTION>";
			}else{
					$yoyakusya .= "<OPTION value=$Data->syain_cd>$strName</OPTION>";
			}
	}

	//予約開始年
	$year1="";
	for ($i = $rsv_styear-1 ; $i <= $rsv_styear+1 ; $i++) {
			if ($rsv_styear == $i) {
				$year1.= "<option value=\"".$i."\" selected>".$i."年</option>\n";
			}else{
				$year1.= "<option value=\"".$i."\">".$i."年</option>\n";
			}
	}

	//予約開始月
	$month1="";
	for ($i = 1 ; $i <= 12 ; $i++) {
			if ($rsv_stmon == $i) {
					if (strlen($i)==1){
						$month1.= "<option value=\""."0".$i."\" selected>".$i."月</option>\n";
					}else{
						$month1.= "<option value=$i selected>".$i."月</option>\n";
					}
			}else{
					if (strlen($i)==1){
							$month1.= "<option value=\""."0".$i."\">".$i."月</option>\n";
					}else{
							$month1.= "<option value=$i>".$i."月</option>\n";
					}
			}
	}

	//予約開始日
	$day1="";
	for ($i = 1 ; $i <= 31 ; $i++) {
			if ($rsv_stday == $i) {
				if (strlen($i)==1){
						$day1.= "<option value=\""."0".$i."\" selected>".$i."日</option>\n";
				}else{
						$day1.= "<option value=$i selected>".$i."日</option>\n";
				}
			}else{
				if (strlen($i)==1){
						$day1.= "<option value=\""."0".$i."\">".$i."日</option>\n";
				}else{
						$day1.= "<option value=$i>".$i."日</option>\n";
				}
			}
	}

	//予約終了年
	$year2="";
	for ($i = $rsv_edyear-1 ; $i <= $rsv_edyear+1 ; $i++) {
			if ($rsv_edyear == $i) {
				$year2.= "<option value=\"".$i."\" selected>".$i."年</option>\n";
			}else{
				$year2.= "<option value=\"".$i."\">".$i."年</option>\n";
			}
	}

	//予約終了月
	$month2="";
	for ($i = 1 ; $i <= 12 ; $i++) {
			if ($rsv_edmon == $i) {
					if (strlen($i)==1){
							$month2.= "<option value=\""."0".$i."\" selected>".$i."月</option>\n";
					}else{
							$month2.= "<option value=$i selected>".$i."月</option>\n";
					}
			}else{
					if (strlen($i)==1){
							$month2.= "<option value=\""."0".$i."\">".$i."月</option>\n";
					}	else{
							$month2.= "<option value=$i>".$i."月</option>\n";
					}
			}
	}


	//予約終了日
	$day2="";
	for ($i = 1 ; $i <= 31 ; $i++) {
		if ($rsv_edday == $i) {
			if (strlen($i)==1){
					$day2.= "<option value=\""."0".$i."\" selected>".$i."日</option>\n";
			}else{
					$day2.= "<option value=$i selected>".$i."日</option>\n";
			}
		}else{
			if (strlen($i)==1){
					$day2.= "<option value=\""."0".$i."\">".$i."日</option>\n";
			}else{
					$day2.= "<option value=$i>".$i."日</option>\n";
			}
		}
	}


	$time1="";
	$Data_Array1=array("---","08時","09時","10時","11時","12時","13時","14時","15時","16時","17時","18時","19時","20時","21時","22時","23時","00時","01時","02時","03時","04時","05時","06時","07時");
	$Data_Array2=array("","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","00","01","02","03","04","05","06","07");
	for ($intCnt = 0 ; $intCnt <= count($Data_Array1)-1 ; $intCnt++) {
			$time1.='<OPTION value="'.$Data_Array2[$intCnt].'"';
			if ($rsv_st_hour == $Data_Array2[$intCnt]){
					$time1.= " selected";
			} 
			$time1.= ">".$Data_Array1[$intCnt]."</OPTION>";
	}

	$time2="";
	$Data_Array1=array("---","00分","10分","20分","30分","40分","50分");
	$Data_Array2=array("","00","10","20","30","40","50");
	for ($intCnt = 0 ; $intCnt <= count($Data_Array1)-1 ; $intCnt++) {
			$time2.='<OPTION value="'.$Data_Array2[$intCnt].'"';
			if ($rsv_st_mini == $Data_Array2[$intCnt]){
					$time2.= " selected";
			} 
			$time2.= ">".$Data_Array1[$intCnt]."</OPTION>";
	}

	$time3="";
	$Data_Array1=array("---","08時","09時","10時","11時","12時","13時","14時","15時","16時","17時","18時","19時","20時","21時","22時","23時","00時","01時","02時","03時","04時","05時","06時","07時");
	$Data_Array2=array("","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","00","01","02","03","04","05","06","07");
	for ($intCnt = 0 ; $intCnt <= count($Data_Array1)-1 ; $intCnt++) {
			$time3.='<OPTION value="'.$Data_Array2[$intCnt].'"';
			if ($rsv_ed_hour == $Data_Array2[$intCnt]){
					$time3.= " selected";
			} 
			$time3.= ">".$Data_Array1[$intCnt]."</OPTION>";
	}


	$time4="";
	$Data_Array1=array("---","00分","10分","20分","30分","40分","50分");
	$Data_Array2=array("","00","10","20","30","40","50");
	for ($intCnt = 0 ; $intCnt <= count($Data_Array1)-1 ; $intCnt++) {
			$time4.='<OPTION value="'.$Data_Array2[$intCnt].'"';
			if ($rsv_ed_mini == $Data_Array2[$intCnt]){
					$time4.= " selected";
			} 
			$time4.= ">".$Data_Array1[$intCnt]."</OPTION>";
	}


if($strlink!=""){
	$sisetu_link="<TR>";
	$sisetu_link.='<TD height="25" width="150" class="toneDown"><span class="Normalfont">スケジュールとのリンク</span></TD> ';
	$sisetu_link.='<TD width="150" bgcolor="#ffffff">'.$strlink."</TD>";
	$sisetu_link.="</TR>";
}

if ($intsts != 0) {
	$del_buttom='<INPUT type="button" value=" 削 除 " onclick="del_conf('.$intsts.','.$strHoujiDate.')">　 ';
}

$o_smarty->assign('intsts',$intsts);
$o_smarty->assign('rev_type_Mode',$rev_type_Mode);
$o_smarty->assign('week',$week);
$o_smarty->assign('month',$month);

$o_smarty->assign('yoyakusya',$yoyakusya);
$o_smarty->assign('strsisetu',$strsisetu);
$o_smarty->assign('year1',$year1);
$o_smarty->assign('month1',$month1);
$o_smarty->assign('day1',$day1);
$o_smarty->assign('year2',$year2);
$o_smarty->assign('month2',$month2);
$o_smarty->assign('day2',$day2);
$o_smarty->assign('sttsTemp',$sttsTemp);
$o_smarty->assign('sttsDay',$sttsDay);
$o_smarty->assign('time1',$time1);
$o_smarty->assign('time2',$time2);
$o_smarty->assign('time3',$time3);
$o_smarty->assign('time4',$time4);
$o_smarty->assign('mokuteki',$purpose);
$o_smarty->assign('address',$contact);
$o_smarty->assign('bikou',$resume);
$o_smarty->assign('sisetu_link',$sisetu_link);
$o_smarty->assign('sisetu',$sisetu);
$o_smarty->assign('intsts',$intsts);
$o_smarty->assign('link_cd',$link_cd);
$o_smarty->assign('del_buttom',$del_buttom);
$o_smarty->assign('strkijyundate',$strkijyundate);
$o_smarty->assign('calYMD2',$rsv_styear."/".$rsv_stmon."/".$rsv_stday);
$o_smarty->assign('calYMD3',$rsv_edyear."/".$rsv_edmon."/".$rsv_edday);

$o_smarty->assign('strHoujiDate',$strHoujiDate);


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

?>