<?php 

//*****************************************************************************

//* 

//* プログラム名：施設予約

//* プログラムID：RES003.php

//* 機能				：削除確認画面

//* 作成者			：

//* 

//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");

include("include/SessionChk.inc");

include('include/smarty.conf');



include("inc/header.inc");



$strDBinc="include/dbcon.inc";

include($strDBinc);





	//データ取得

	$strSQL="";

	$objRecSet="null";

	$Data="null";

	$strSQL="Select rsv_no,syain_cd,rsv_st_date,rsv_ed_date,rsv_st_time,rsv_ed_time,".

			"reg_date,reg_time,contact,purpose,resume".

			" From sisetu_TBL WHERE seq=$intsts";

	$objRecSet = pg_exec($strSQL);

	if($objRecSet==false){

		echo("SQL実行に失敗しました(SELECT)");

		exit;

	}

	$Data = pg_fetch_object($objRecSet, 0);

	$rsv_no=$Data->rsv_no;

	$syain_cd=$Data->syain_cd;

	//開始日

	list($rsv_st_year,$rsv_st_mon,$rsv_st_day)=split("/",$Data->rsv_st_date);

	$rsv_date=$rsv_st_year."年".$rsv_st_mon."月".$rsv_st_day."日";

	//終了日

	if ($Data->rsv_st_date != $Data->rsv_ed_date){

		list($rsv_ed_year,$rsv_ed_mon,$rsv_ed_day)=split("/",$Data->rsv_ed_date);

		$rsv_date=$rsv_date."　〜　".$rsv_ed_year."年".$rsv_ed_mon."月".$rsv_ed_day."日";

	}

	//開始時刻

	if ($Data->rsv_st_time != ""){

		list($rsv_st_hour,$rsv_st_mini)=split(":", $Data->rsv_st_time);

		$rsv_time=$rsv_st_hour."時".$rsv_st_mini."分";

	}

	//終了時刻

	if ($Data->rsv_ed_time != ""){

		list($rsv_ed_hour,$rsv_ed_mini)=split(":", $Data->rsv_ed_time);

		$rsv_time=$rsv_time."　〜　".$rsv_ed_hour."時".$rsv_ed_mini."分";

	}

	$contact=$Data->contact;

	$purpose=$Data->purpose;

	$resume=str_replace("\n", "<BR>", $Data->resume);



	//人情報取得

	$strSQL="";

	$objRecSet="null";

	$Data="null";

	$strSQL = "SELECT 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;

	}

	$intCnt=0;

	$Data = pg_fetch_object($objRecSet, 0);

	$strname=$Data->name_kj_sei."　".$Data->name_kj_mei;



	//施設名取得

	$strSQL="";

	$objRecSet="null";

	$Data="null";

	$strSQL="Select sisetu_name From mst_sisetu WHERE seq=$rsv_no";

	$objRecSet = pg_exec($strSQL);

	if($objRecSet==false){

			echo("SQL実行に失敗しました(SELECT)");

			exit;

	}

	$Data = pg_fetch_object($objRecSet, 0);

	$strsisetu=$Data->sisetu_name;

	if ($link_cd==0){

			$strlink="なし";

	}else{

			$strlink="あり";

	}



	if ($rsv_time == "" ){

			$rsv_time= "指定なし";

	}



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

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

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

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

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

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

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

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



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

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

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







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



?>