<?php 
//*****************************************************************************
//* 
//* プログラム名：電子決裁
//* プログラムID：FLO004_1.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");
include("inc/mtc_comfunc.inc");

include("include/common_function.inc");

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

	//**** ＤＢ接続 ****//
$intseq = $seq;
$strDBinc="include/dbcon.inc";

include($strDBinc);

$kessaisya_num = 0;

$strTempPath="temp/".$PHP_FOLDER_NAME."/sinsei/";
//データ取得
$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=$intseq";
$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]=LINE_BR($objRecData->reason,70);
//申請書名(英字)
$strSinsei[5]=$objRecData->file_name;
$strFileNm=LINE_DEL($objRecData->file_name_jp,50);
//申請書名(日本語)
$strSinsei[6]=$objRecData->file_name_jp;

	// ダウンロードボタン
if(trim($strFileNm)!=""){
	if(is_mb()){
		//モバイル
		$PhpDL = "<input type=button onclick='DownFile(\"".$strTempPath.$strSinsei[5]."\",\"".$strSinsei[5]."\")' value=ダウンロード>";
	}else{
		$PhpDL = "<input type=button onclick='DownFile(\"".$strTempPath.$strSinsei[5]."\",\"".$strSinsei[6]."\")' value=ダウンロード>";
	}
}

//選択したデータの状況テーブルあるか？
$strSQL1="SELECT * FROM kessaijoukyou_tbl Where sinsei_seq='".$strSinsei[0]."' 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>";
					$strComment[$intCnt1+1] = "".nl2br($objRecData1->kessai_comment);
				}

				$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]=$objRecMei->name_kj_sei.$objRecMei->name_kj_mei;
				$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;

	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]=$objRec->name_kj_sei.$objRec->name_kj_mei;
		$strJyokyo[1][4]=$objRecData->kessaisya_cd1;
	}

	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]=$objRec->name_kj_sei.$objRec->name_kj_mei;
		$strJyokyo[2][4]=$objRecData->kessaisya_cd2;
	}

	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]=$objRec->name_kj_sei.$objRec->name_kj_mei;
		$strJyokyo[3][4]=$objRecData->kessaisya_cd3;
	}

	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]=$objRec->name_kj_sei.$objRec->name_kj_mei;
		$strJyokyo[4][4]=$objRecData->kessaisya_cd4;
	}

	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]=$objRec->name_kj_sei.$objRec->name_kj_mei;
		$strJyokyo[5][4]=$objRecData->kessaisya_cd5;
	}

}

// 決裁者
$intChkFlg = 0;
$intCnt = 0;
for($intData = 1; $intData <= $kessaisya_num ; $intData++){
	$PhpComment = "";
	if ($intChkFlg==0){
		$PhpComment = '<div align="left">■コメント：<br>'.
		'<textarea name="inp_Comment'.$intseq.'" cols="50" rows="4"></textarea>';

		if ($strJyokyo[$intData][0]==0){
			if ($strJyokyo[$intData][4]==$PHP_SYAIN_CD){
				$PhpJyokyo[$intCnt] =  "<TD colspan=2 height=50 bgcolor=#ffffff align=center>".$PhpComment.
					 "<div align=center><INPUT type=button value=承認  onclick=javascript:set_syori($intData,1,".$intseq.",document.e_gru.inp_Comment".$intseq.".value,'".$strJyokyo[$intData][4]."');>　".
					 "<INPUT type=button value=却下 onclick=javascript:set_syori($intData,2,".$intseq.",document.e_gru.inp_Comment".$intseq.".value,'".$strJyokyo[$intData][4]."');></div>".
					 "</SPAN></TD><TD bgcolor=#ffffff><span class=Normalfont></TD>";
			}else{
				$PhpJyokyo[$intCnt] = "<TD height=50 width=70 bgcolor=#ffffff class=Normalfont></SPAN></TD><TD width=300 bgcolor=#ffffff class=Normalfont></span></TD><TD width=200 bgcolor=#ffffff class=Normalfont></span></TD>";
			}
			$intChkFlg=1;
		}elseif ($strJyokyo[$intData][0]==1){
			$PhpJyokyo[$intCnt] = "<TD width=70 bgcolor=#ffffff align=center class=Normalfont></span><SPAN class=kessai>承認</span></TD><TD height=50 width=300 bgcolor=#ffffff class=Normalfont>".$strComment[$intData].
				 "</TD><TD width=200 bgcolor=#ffffff align=center class=Normalfont>".
				$strJyokyo[$intData][1]." ".$strJyokyo[$intData][2].
				 "</SPAN></TD>";
		}elseif ($strJyokyo[$intData][0]==2){
			$PhpJyokyo[$intCnt] = "<TD width=70 bgcolor=#ffffff align=center class=Normalfont></span><SPAN class=kyakka>却下</span></TD><TD height=50 width=300 bgcolor=#ffffff><span class=Normalfont>".$strComment[$intData].
				 "</TD><TD width=200 bgcolor=#ffffff align=center class=Normalfont>".
				 $strJyokyo[$intData][1]." ".$strJyokyo[$intData][2].
				 "</SPAN></TD>";
			$intChkFlg=1;
		}
	}else{
		$PhpComment = "";
		$PhpJyokyo[$intCnt] =  "<TD height=50 width=70 bgcolor=#ffffff class=Normalfont></SPAN></TD><TD width=300 bgcolor=#ffffff class=Normalfont></span></TD><TD width=200 bgcolor=#ffffff class=Normalfont></span></TD>";
	}
	// 決裁者リスト
	$PhpList[$intCnt] = "<TD height=20 width=200 bgcolor=#ffffff><SPAN class=Normalfont>".$strJyokyo[$intData][3]."</SPAN></TD>";
	$intCnt = $intCnt + 1;
}

$PhpSeq = "<input type=hidden name=intseq value=".$intseq.">";

$o_smarty->assign('PhpCnt',$intCnt);
$o_smarty->assign('PhpDL',$PhpDL);
$o_smarty->assign('PhpTime',$strSinsei[1]);
$o_smarty->assign('PhpName',$strSinsei[2]);
$o_smarty->assign('PhpKind',$strSinsei[3]);
$o_smarty->assign('PhpRiyu',$strSinsei[4]);
$o_smarty->assign('PhpSin_E',$strSinsei[5]);
$o_smarty->assign('PhpSin_J',$strSinsei[6]);
$o_smarty->assign('PhpJyokyo',$PhpJyokyo);
$o_smarty->assign('PhpList',$PhpList);
$o_smarty->assign('PhpSeq',$PhpSeq);
$o_smarty->display('FLO004_1.tpl');

?>