<?php 
//*****************************************************************************
//* 
//* プログラム名：電子決裁
//* プログラムID：FLO002_m.php
//* 機能        ：判定画面
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");

//*** 広告 ***//
include("include_m/Advertisement.inc");

//*** 共通処理 ***//
include("include_m/CommonProcess.inc");

//*** URL取得処理 ***//
include("include_m/CommonUrlGet.inc");

//*** 初期値設定 ***//
if ($_GET["Page"]==""){
	$DispPage = 0;
}else{
	$DispPage = $_GET["Page"];
}

//*** 電子決済 ***//
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'FLO001.php'";
$rsRecset = pg_exec($strMenuSQL);
$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");

//*** 共通関数 ***//
function mtc_rtrim($pstr){
	if (mb_strlen($pstr) > 0) {
		$tempSTR = mb_substr($pstr,mb_strlen($pstr)-1,1);
		$retSTR = $pstr;
		if($tempSTR == " " || $tempSTR == "　"){
			$retSTR = mb_substr($retSTR, 0, mb_strlen($retSTR) - 1);
		}
		return $retSTR;
	}else{
		return "";
	}
}

//データ取得
$strSQL="Select seq,syain_cd,sinsei_syubetu,sinsei_date,sinsei_time,".
		"reason,file_name,file_name_jp,sinsei_flg1,sinsei_date1,sinsei_time1,".
		"sinsei_flg2,sinsei_date2,sinsei_time2,sinsei_flg3,sinsei_date3,sinsei_time3,".
		"sinsei_flg4,sinsei_date4,sinsei_time4,sinsei_flg5,sinsei_date5,sinsei_time5,".
		"comment1,comment2,comment3,comment4,comment5 ".
		"From sinsei_tbl Where seq=$seq";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}

$objRecData = pg_fetch_object($objRecSet, 0);

//SEQ
$strSinsei[0]=$objRecData->seq;

//申請日時
$strSinsei[1]=$objRecData->sinsei_date." ".$objRecData->sinsei_time;

//申請者名称
$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->syain_cd."'";
$objData = pg_exec($strSQL);
if($objData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objRec = pg_fetch_object($objData, 0);
$strSinsei[2]=$objRec->name_kj_sei.$objRec->name_kj_mei;

//申請種別
$strSQL="Select sinsei_name from mst_sinsei where sinsei_syubetu=".$objRecData->sinsei_syubetu;
$objData = pg_exec($strSQL);
if($objData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objRec = pg_fetch_object($objData, 0);
$strSinsei[3]=$objRec->sinsei_name;

//申請理由
$strSinsei[4]=$objRecData->reason;

//申請書名(英字)
$strSinsei[5]=$objRecData->file_name;
$strFileNm=$objRecData->file_name_jp;

//申請書名(日本語)
$strSinsei[6]=$objRecData->file_name_jp;



//選択したデータの状況テーブルあるか？
$strSQL1="SELECT * FROM kessaijoukyou_tbl Where sinsei_seq=$seq ORDER BY kessai_no";
$objData1 = pg_exec($strSQL1);
if($objData1==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

if(pg_numrows($objData1)>0){

		//新決裁者テーブルがあったら
		for($intCnt1 = 0; $intCnt1 < pg_numrows($objData1) ; $intCnt1++) {

				$objRecData1 = pg_fetch_object($objData1, $intCnt1);

				

				//決裁状況
				$strJyokyo[$intCnt1+1][0]=$objRecData1->kessai_joukyou;
				$strJyokyo[$intCnt1+1][1]=$objRecData1->kessai_day;
				$strJyokyo[$intCnt1+1][2]=$objRecData1->kessai_time;


				//コメント
				if(mtc_rtrim($objRecData1->kessai_comment)!=""){
					$strComment[$intCnt1+1] = "".$objRecData1->kessai_comment."<BR>";
				}

				$strSQLMei="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl ".
						"Where syain_cd='".$objRecData1->syain_cd."'";
				$objDataMei = pg_exec($strSQLMei);

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

				$objRecMei = pg_fetch_object($objDataMei, 0);

				$strJyokyo[$intCnt1+1][3]=mb_convert_encoding($objRecMei->name_kj_sei.$objRecMei->name_kj_mei, "SJIS", "EUC-JP");
				$strJyokyo[$intCnt1+1][4]=$objRecData1->syain_cd;

		}
		//決済者数
		$kessaisya_num = pg_numrows($objData1);
}else{
	//決裁状況
	$strJyokyo[1][0]=$objRecData->sinsei_flg1;
	$strJyokyo[1][1]=$objRecData->sinsei_date1;
	$strJyokyo[1][2]=$objRecData->sinsei_time1;
	$strJyokyo[2][0]=$objRecData->sinsei_flg2;
	$strJyokyo[2][1]=$objRecData->sinsei_date2;
	$strJyokyo[2][2]=$objRecData->sinsei_time2;
	$strJyokyo[3][0]=$objRecData->sinsei_flg3;
	$strJyokyo[3][1]=$objRecData->sinsei_date3;
	$strJyokyo[3][2]=$objRecData->sinsei_time3;
	$strJyokyo[4][0]=$objRecData->sinsei_flg4;
	$strJyokyo[4][1]=$objRecData->sinsei_date4;
	$strJyokyo[4][2]=$objRecData->sinsei_time4;
	$strJyokyo[5][0]=$objRecData->sinsei_flg5;
	$strJyokyo[5][1]=$objRecData->sinsei_date5;
	$strJyokyo[5][2]=$objRecData->sinsei_time5;

	if(mtc_rtrim($objRecData->comment1)!=""){$strComment[1] = "".$objRecData->comment1."<BR>";};
	if(mtc_rtrim($objRecData->comment2)!=""){$strComment[2] = "".$objRecData->comment2."<BR>";};
	if(mtc_rtrim($objRecData->comment3)!=""){$strComment[3] = "".$objRecData->comment3."<BR>";};
	if(mtc_rtrim($objRecData->comment4)!=""){$strComment[4] = "".$objRecData->comment4."<BR>";};
	if(mtc_rtrim($objRecData->comment5)!=""){$strComment[5] = "".$objRecData->comment5."<BR>";};

	//*** 決裁者情報取得 ///
	$strSQL="Select sinsei_syubetu,kessaisya_cd1,kessaisya_cd2,".
					"kessaisya_cd3,kessaisya_cd4,kessaisya_cd5,kessaisya_num".
					" From kessaisya_tbl Where sinsei_syubetu=".$objRecData->sinsei_syubetu;
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
	}
	$objRecData = pg_fetch_object($objRecSet, 0);
	$kessaisya_num=$objRecData->kessaisya_num;

	//第1決裁者
	if ($objRecData->kessaisya_num>0){
			$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->kessaisya_cd1."'";
			$objData = pg_exec($strSQL);
			if($objData==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			$objRec = pg_fetch_object($objData, 0);
			$strJyokyo[1][3]=mb_convert_encoding($objRec->name_kj_sei.$objRec->name_kj_mei, "SJIS", "EUC-JP");
			$strJyokyo[1][4]=$objRecData->kessaisya_cd1;
	}

	//第2決裁者
	if ($objRecData->kessaisya_num>1){
			$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->kessaisya_cd2."'";
			$objData = pg_exec($strSQL);
			if($objData==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
			}
			$objRec = pg_fetch_object($objData, 0);
			$strJyokyo[2][3]=mb_convert_encoding($objRec->name_kj_sei.$objRec->name_kj_mei, "SJIS", "EUC-JP");
			$strJyokyo[2][4]=$objRecData->kessaisya_cd2;
	}

	//第3決裁者
	if ($objRecData->kessaisya_num>2){
			$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->kessaisya_cd3."'";
			$objData = pg_exec($strSQL);
			if($objData==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
			}
			$objRec = pg_fetch_object($objData, 0);
			$strJyokyo[3][3]=mb_convert_encoding($objRec->name_kj_sei.$objRec->name_kj_mei, "SJIS", "EUC-JP");
			$strJyokyo[3][4]=$objRecData->kessaisya_cd3;
	}

	//第4決裁者
	if ($objRecData->kessaisya_num>3){
			$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->kessaisya_cd4."'";
			$objData = pg_exec($strSQL);
			if($objData==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
			}
			$objRec = pg_fetch_object($objData, 0);
			$strJyokyo[4][3]=mb_convert_encoding($objRec->name_kj_sei.$objRec->name_kj_mei, "SJIS", "EUC-JP");
			$strJyokyo[4][4]=$objRecData->kessaisya_cd4;
	}

	//第5決裁者
	if ($objRecData->kessaisya_num>4){
			$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData->kessaisya_cd5."'";
			$objData = pg_exec($strSQL);
			if($objData==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
			}
			$objRec = pg_fetch_object($objData, 0);
			$strJyokyo[5][3]=mb_convert_encoding($objRec->name_kj_sei.$objRec->name_kj_mei, "SJIS", "EUC-JP");
			$strJyokyo[5][4]=$objRecData->kessaisya_cd5;
	}
}

	// 決裁者
	$intChkFlg = 0;
	$intCnt = 0;
	for($intData = 1; $intData <= $kessaisya_num ; $intData++){
			if ($intChkFlg==0){
				if ($strJyokyo[$intData][0]==0){
						if ($strJyokyo[$intData][4]==$PHP_SYAIN_CD){
								$PhpJyokyo[$intCnt] = "決裁";
						}else{
								$PhpJyokyo[$intCnt] = "";
						}
						$intChkFlg=1;
				}elseif ($strJyokyo[$intData][0]==1){
						$PhpJyokyo[$intCnt] = "承認";
				}elseif ($strJyokyo[$intData][0]==2){
						$PhpJyokyo[$intCnt] = "却下";
						$intChkFlg=1;
				}
			}else{
					$PhpComment[$intCnt] = "";
					$PhpJyokyo[$intCnt] =  "";
			}
			$PhpComment[$intCnt]=mb_convert_encoding($strComment[$intData], "SJIS", "EUC-JP");

			//決裁者リスト
			$PhpList[$intCnt] = $strJyokyo[$intData][3];
			$intCnt = $intCnt + 1;
	}


?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>E-グルPro(<?php  echo $PHP_TITLE_NAME; ?>)</TITLE>
</HEAD>
<BODY>
<form Method="GET" action="FLO003_m.php">
<center>
<?php  echo $PHP_TITLE_NAME; ?><br>
<?php  echo $strName; ?>
<HR width="100%">
<?php  echo $koukokuTEL; ?>
</center>
<?php 
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
?>

<HR width="100%">
<center>申請書内容</center><br>
<a href="FLO001_m.php?D_Flg=0&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>申請一覧へ</a>&nbsp;
<a href="FLO001_m.php?D_Flg=1&<?php  echo $PHP_Argument ?>"accesskey="2"><?php  echo Get_Num("2"); ?>決裁一覧へ</a>&nbsp;
<a href="FLO001_m.php?D_Flg=<?php echo $D_Flg; ?>&Page=<?php echo $DispPage; ?>&<?php  echo $PHP_Argument ?>"accesskey="2"><?php  echo Get_Num("3"); ?>戻る</a>
<br />
<?php 
echo "【申請日時】<br />";
echo $strSinsei[1]."<br />";
echo "<br />";

echo "【申請者】<br />";
echo mb_convert_encoding($strSinsei[2],"SJIS", "EUC-JP")."<br />";
echo "<br />";

echo "【申請書種別】<br />";
echo mb_convert_encoding($strSinsei[3],"SJIS", "EUC-JP")."<br />";
echo "<br />";

echo "【申請内容】<br />";
echo mb_convert_encoding($strSinsei[4],"SJIS", "EUC-JP")."<br />";
echo "<br />";

echo "【ファイル名】<br />";
//echo '<a href="'.$UrlHead_PC.'temp/'.$PHP_FOLDER.'/sinsei/'.$strSinsei[5].'">';
echo mb_convert_encoding($strSinsei[6],"SJIS", "EUC-JP")."<br />";
//echo '</a>';
echo "<br />";

echo "【決裁状況】<br />";
for ($intCnt = 0; $intCnt < count($PhpList); $intCnt++) {
		$intChk=$intCnt+1;
		echo "　[第".$intChk."決裁]<br />";
		if ($PhpJyokyo[$intCnt]=="決裁"){
				echo "　　".$PhpList[$intCnt]."<br />";
				echo '<center>';
				echo '<textarea name="Cm" rows="5" cols="20"></textarea><br />';
				echo '<INPUT type=submit NAME="intsts" value="承認">　';
				echo '<INPUT type=submit NAME="intsts" value="却下">';
				echo '<INPUT TYPE="hidden" NAME="Sts" VALUE="'.$intChk.'">';
				echo '</center>';
				echo '<HR width="90%">';

		}else{
				echo "　　".$PhpList[$intCnt]."-".$PhpJyokyo[$intCnt]."<br />";
				if ($PhpComment[$intCnt]!=""){
						echo "　　ｺﾒﾝﾄ:".$PhpComment[$intCnt];
				}
				echo '<HR width="90%">';
		}
}
echo "<br />";

?>
<a href="FLO001_m.php?D_Flg=0&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>申請一覧へ</a>&nbsp;
<a href="FLO001_m.php?D_Flg=1&<?php  echo $PHP_Argument ?>"accesskey="2"><?php  echo Get_Num("2"); ?>決裁一覧へ</a>&nbsp;
<a href="FLO001_m.php?D_Flg=<?php echo $D_Flg; ?>&Page=<?php echo $DispPage; ?>&<?php  echo $PHP_Argument ?>"accesskey="2"><?php  echo Get_Num("3"); ?>戻る</a>
<br>
<INPUT TYPE="hidden" NAME="D_Flg" VALUE="<?php  echo $D_Flg ?>">
<INPUT TYPE="hidden" NAME="Page"  VALUE="<?php  echo $DispPage ?>">
<INPUT TYPE="hidden" NAME="seq"   VALUE="<?php  echo $seq ?>">
<HR width="100%">
<?php 
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
	//*** 共通変数取得 ***//
	include("include_m/CommonHidden.inc");
?>
</form>
</BODY>
</HTML>