<?php 
//*****************************************************************************
//* 
//* プログラム叹¨搀枉饶
//* プログラムID¨CIR002.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/CIR002.inc");
//メニュ〖セット
include("menu_opacity.php");
$strDBinc="../".$PHP_FOLDER."/include/dbcon.inc";
include($strDBinc);

//**** ＤＢ儡鲁 ****//
include("./include/dbcon.inc");				//ＤＢ儡鲁


$strSQLsyain="";
$objRecsyain="null";
$strSQLrtn="";
$objRecrtn="null";
$strTempPath="temp/".$PHP_FOLDER_NAME."/kairan/";

if ($PHP_MODE_FLG==2){
	$PHP_DISABLED_flg=" disabled";
}

//柴的技からの搀枉息瓢
if (!empty($txtCTGName)){
	$fromKaigi_flg = 1;
} 


//浩搀枉の眷圭
if (!empty($seq)){

	$strSQLrtn="SELECT title,memo,filename,filename_jp,filename2,filename_jp2,filename3,filename_jp3 FROM kairan_tbl Where seq=$seq ";
	$objRecrtn = pg_exec($strSQLrtn);
	if($objRecrtn==false){
		echo("SQL悸乖に己窃しました(SELECT)");
		exit;
	}
	$obrtn = pg_fetch_object($objRecrtn,0);
	
	$kairan_title=htmlspecialchars($obrtn->title);
	$your_memo=$obrtn->memo;

	$splitlen=50;
	//ファイル1
	$strfilename=$obrtn->filename;
	$strfilename_jp=$obrtn->filename_jp;
	$strFileNm="";
	//ファイル1
	if ($obrtn->filename_jp!=""){
		$strFileNm=LINE_DEL($obrtn->filename_jp,16);
	}

	//ファイル2
	$strfilename2=$obrtn->filename2;
	$strfilename_jp2=$obrtn->filename_jp2;
	$strFileNm2="";
	if ($obrtn->filename_jp2!=""){
		$strFileNm2=LINE_DEL($obrtn->filename_jp2,16);
	}

	//ファイル3
	$strfilename3=$obrtn->filename3;
	$strfilename_jp3=$obrtn->filename_jp3;
	$strFileNm3="";
	if ($obrtn->filename_jp3!=""){
		$strFileNm3=LINE_DEL($obrtn->filename_jp3,16);
	}

}

//藕烧ファイル肋年
if ($file_kind == 1){
	$strfilename="";
	$strfilename_jp="";
	$strFileNm="";
}else if ($file_kind == 2){
	$strfilename2="";
	$strfilename_jp2="";
	$strFileNm2="";
}else if ($file_kind == 3){
	$strfilename3="";
	$strfilename_jp3="";
	$strFileNm3="";
}

//婶嚏攫鼠艰评
$strSQLmst = "SELECT syozoku_cd,bumon_name FROM mst_bumon Where del_flg=0 Order by disp_rank";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}

//家镑攫鼠艰评
$strSQLsyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where del_flg=true Order by disp_rank";
$objRecsyain = pg_exec($strSQLsyain);
if($objRecsyain==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}

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";
$objRecData = pg_exec($strSQLSyain);
if($objRecData==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}

if ($fromKaigi_flg==1){
	//家镑攫鼠艰评
	$strJyoken_sp=str_replace("/","' or syain_cd='",$txtSpeaker);
}
$strSQLSyain_sp="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd=" . "'" .$strJyoken_sp ."'" ." Order by disp_rank";
$objRecData_sp = pg_exec($strSQLSyain_sp);
if($objRecData_sp==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}


if ($fromKaigi_flg==1){
	//家镑攫鼠艰评
	$strJyoken_ob=str_replace("/","' or syain_cd='",$txtObserver);
}
$strSQLSyain_ob="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd=" . "'" .$strJyoken_ob ."'" ." Order by disp_rank";
$objRecData_ob = pg_exec($strSQLSyain_ob);
if($objRecData==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}

//<!--搀枉惹掐蜗〖-->
if ($fromKaigi_flg==1){
	$kairan_title = mb_convert_encoding($txtTheme,"EUC-JP","auto");
	$your_memo .= '≮柴的テ〖マ≯　'."\n".$kairan_title."\n";
//		$your_memo .= '≮柴的カテゴリ≯　'.mb_convert_encoding($txtCTGName,"EUC-JP","auto")."\n\n";
	$your_memo .= '≮柴的のル〖ル≯'."\n".mb_convert_encoding($txtRule,"EUC-JP","auto")."\n";
	$your_memo .= '≮泼淡祸灌≯'."\n".mb_convert_encoding($txtEtc,"EUC-JP","auto")."\n";
	$your_memo .= '≮柴的袋粗≯　'."\n".mb_convert_encoding($txtTerm,"EUC-JP","auto")."\n";
	$your_memo .= '≮的墓≯　'."\n".mb_convert_encoding($txtChairP,"EUC-JP","auto")."\n";
	$your_memo .= '≮的祸峡侯喇荚≯　'."\n".mb_convert_encoding($txtMinutesMk,"EUC-JP","auto")."\n";
	$your_memo .= '≮的祸峡≯　'."\n".mb_convert_encoding($txtMinutes,"EUC-JP","auto")."\n";
}
$o_smarty->assign('kairan_title',$kairan_title);
$o_smarty->assign('your_memo',$your_memo);


if ($send_flg==0){
	$send_flg_bumon ="checked";
}
$o_smarty->assign('send_flg_bumon',$send_flg_bumon);

$bumon .='<OPTION value="0">链婶嚏</OPTION>';
for ($intBumon = 0; $intBumon < pg_numrows($objRecmst); $intBumon++) {
	$objDatamst = pg_fetch_object($objRecmst, $intBumon);
	$bumon .= '<OPTION value="'.$objDatamst->syozoku_cd.'">'.$objDatamst->bumon_name.'</OPTION>';
}
$o_smarty->assign('bumon',$bumon);

//<!--家镑侍流慨黎-->
if ($send_flg==1 || $strsel != ""){
	$syain = "checked";
}

if ($fromKaigi_flg==1){
	if (pg_numrows($objRecData_sp) != 0){
	$syain = "checked";
		for ($intlist = 0; $intlist < pg_numrows($objRecData_sp); $intlist++) {
			$objlist = pg_fetch_object($objRecData_sp, $intlist);
			$syain_add .= '<OPTION value= "$objlist->syain_cd">'.$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
		}
		$syain_add .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
	}else{
		$syain_add .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
	}
}elseif(pg_numrows($objRecData) != 0){
	for ($intlist = 0; $intlist < pg_numrows($objRecData); $intlist++) {
		$objlist = pg_fetch_object($objRecData, $intlist);
		$syain_add .= '<OPTION value= "$objlist->syain_cd">'.$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
	}
	$syain_add .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
}else{
	$syain_add .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
}

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

for ($intlist = 0; $intlist < pg_numrows($objRecsyain); $intlist++) {
	$objlist = pg_fetch_object($objRecsyain, $intlist);
	$syain_list .= "<OPTION value= $objlist->syain_cd selected>".$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
}
$o_smarty->assign('syain_list',$syain_list);
$o_smarty->assign('syain',$syain);


//<!--避枉のみ-->
//$strsel2 = $strsel;
//	if (pg_numrows($objRecData) != 0){
//		for ($intlist = 0; $intlist < pg_numrows($objRecData); $intlist++) {
//			$objlist = pg_fetch_object($objRecData, $intlist);
//			$syain_add_view .= "<OPTION value= $objlist->syain_cd>".$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
//		}
//		$syain_add_view .= "<OPTION value= >　　　　　　　　　　</OPTION>";
//	}
//	else{
//		$syain_add_view .= "<OPTION value= >　　　　　　　　　　</OPTION>";
//	}
//	$o_smarty->assign('syain_add_view',$syain_add_view);
//
//
//	for ($intlist = 0; $intlist < pg_numrows($objRecsyain); $intlist++) {
//			$objlist = pg_fetch_object($objRecsyain, $intlist);
//			$syain_list_view .= "<OPTION value= $objlist->syain_cd selected>".$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
//	}
//	$o_smarty->assign('syain_list_view',$syain_list_view);


if ($fromKaigi_flg==1){
	if (pg_numrows($objRecData_ob) != 0){
		for ($intlist = 0; $intlist < pg_numrows($objRecData_ob); $intlist++) {
			$objlist = pg_fetch_object($objRecData_ob, $intlist);
			$syain_add_view .= "<OPTION value= $objlist->syain_cd>".$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
		}
		$syain_add_view .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
	}
	else{
		$syain_add_view .= '<OPTION value="" >　　　　　　　　　　</OPTION>';
	}
}else{
$syain_add_view = $syain_add;
}
$o_smarty->assign('syain_add_view',$syain_add_view);
$syain_list_view = $syain_list;
$o_smarty->assign('syain_list_view',$syain_list_view);

//搀枉袋嘎肋年

//钳
$Cir_y = "<OPTION value='' selected>----钳</OPTION>";
for ($i=Date("Y");$i<=Date("Y")+2;$i++) {
	$Cir_y .= "<OPTION value='".$i."'>".$i."钳</OPTION>";		
}

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

//奉
$Cir_m = "<OPTION value='' selected>--奉</OPTION>";
for ($i=1;$i<=12;$i++) {
	$Cir_m .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."奉</OPTION>";
}
$o_smarty->assign('Cir_m',$Cir_m);

//泣
$Cir_d = "<OPTION value='' selected>--泣</OPTION>";
for ($i=1;$i<=31;$i++) {
	$Cir_d .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."泣</OPTION>";
}
$b = 01;
$o_smarty->assign('Cir_d',$Cir_d);

//箕
$Cir_h = "<OPTION value='' selected>--箕</OPTION>";
for ($i=8;$i<=23;$i++) {
	$Cir_h .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."箕</OPTION>";
}
for ($i=0;$i<=7;$i++) {
	$Cir_h .= "<OPTION value='".sprintf('%02d', $i)."'>".$i."箕</OPTION>";
}
$o_smarty->assign('Cir_h',$Cir_h);

//尸
$Cir_min = "<OPTION value='' selected>--尸</OPTION>";
for ($i=0;$i<=11;$i++) {
	$Cir_min .= "<OPTION value='".sprintf('%02d', $i*5)."'>".($i*5)."尸</OPTION>";
}
$o_smarty->assign('Cir_min',$Cir_min);

//デフォルト袋嘎
$strSQLmst = "SELECT default_data FROM mst_default_data Where data_no = 3";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
	echo("SQL悸乖に己窃しました(SELECT)");
	exit;
}
$objDatamst = pg_fetch_object($objRecmst, 0);
$intDefault = (int) $objDatamst->default_data;
if($intDefault >= 30){
	$strDefault = " ".($intDefault / 30)." ヶ奉";
}else{
	$strDefault = " ".($intDefault / 7)." 降粗";
}
$o_smarty->assign('strDefault',$strDefault);

if (trim($strfilename)==""){
	$PhpFileName = '<input type="file" size="88" name="upfile1" value="" contentEditable="false" '.$PHP_DISABLED." ".$PHP_DISABLED_flg." ".$_SESSION["PHP_E_GRU_CAPA_OVER"].'>';
}else{
	$PhpFileName = '<span class="Normalfont"><A href='.$strTempPath.$strfilename.'>'.$strFileNm.'</A>　<INPUT TYPE="button" VALUE=" 猴 近 " onclick="file_del(1);"></span>';
	$PhpFileName .= '<input type="hidden" name="upfile1" value="">';
}
$o_smarty->assign('PhpFileName',$PhpFileName);

if (trim($strfilename2)==""){
	$PhpFileName2 = '<input type="file" size="88" name="upfile2" value="" contentEditable="false" '.$PHP_DISABLED." ".$PHP_DISABLED_flg." ".$_SESSION["PHP_E_GRU_CAPA_OVER"].'></TD>';
}else{
	$PhpFileName2 = '<span class="Normalfont"><A href='.$strTempPath.$strfilename2.'>'.$strFileNm2.'</A>　<INPUT TYPE="button" VALUE=" 猴 近 " onclick="file_del(2);"></span></TD>';
	$PhpFileName2 .= '<input type="hidden" name="upfile2" value="">';
}
$o_smarty->assign('PhpFileName2',$PhpFileName2);

if (trim($strfilename3)==""){
	$PhpFileName3 = '<input type="file" size="88" name="upfile3" value="" contentEditable="false" '.$PHP_DISABLED." ".$PHP_DISABLED_flg." ".$_SESSION["PHP_E_GRU_CAPA_OVER"].'></TD>';
}else{
	$PhpFileName3 = '<span class="Normalfont"><A href='.$strTempPath.$strfilename3.'>'.$strFileNm3.'</A>　<INPUT TYPE="button" VALUE=" 猴 近 " onclick="file_del(3);"></span></TD>';
	$PhpFileName3 .= '<input type="hidden" name="upfile3" value="">';
}

$kokai_flg_yes = "checked";

$o_smarty->assign('PhpFileName3',$PhpFileName3);
$o_smarty->assign('kokai_flg_yes',$kokai_flg_yes);

$o_smarty->assign('strfilename',$strfilename);
$o_smarty->assign('strfilename_jp',$strfilename_jp);
$o_smarty->assign('strFileNm',$strFileNm);
$o_smarty->assign('strfilename2',$strfilename2);
$o_smarty->assign('strfilename_jp2',$strfilename_jp2);
$o_smarty->assign('strFileNm2',$strFileNm2);
$o_smarty->assign('strfilename3',$strfilename3);
$o_smarty->assign('strfilename_jp3',$strfilename_jp3);
$o_smarty->assign('strFileNm3',$strFileNm3);

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

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

?>