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

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


//**** メニュー ****//
include("menu_opacity.php");
include("inc/STRING.inc");


$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";
//echo $strSQL;
$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;


//決裁状況
$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($objRecData->comment1!=""){$strComment[1] = "".$objRecData->comment1."<BR>";};
if($objRecData->comment2!=""){$strComment[2] = "".$objRecData->comment2."<BR>";};
if($objRecData->comment3!=""){$strComment[3] = "".$objRecData->comment3."<BR>";};
if($objRecData->comment4!=""){$strComment[4] = "".$objRecData->comment4."<BR>";};
if($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;
}

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

// 決裁者
$intChkFlg = 0;
$intCnt = 0;
for($intData = 1; $intData <= $kessaisya_num ; $intData++){
	$PhpComment = "";
	if ($intChkFlg==0){
		$PhpComment = '<div align="left">■コメント：<br>'.
		'<textarea name="Comment" cols="50" rows="4"></textarea>';
		if ($strJyokyo[$intData][0]==0){
			if ($strJyokyo[$intData][4]==$PHP_SYAIN_CD){
				$PhpJyokyo[$intCnt] =  "<TD height=50 width=130 bgcolor=#ffffff align=center>".$PhpComment.
					 "<INPUT type=button value=承認 onclick=javascript:set_syori($intData,1);>　".
					 "<INPUT type=button value=却下 onclick=javascript:set_syori($intData,2);>".
					 "</SPAN></TD>";
			}else{
				$PhpJyokyo[$intCnt] = "<TD height=50 width=130 bgcolor=#ffffff align=center><SPAN class=Normalfont></SPAN></TD>";
			}
			$intChkFlg=1;
		}elseif ($strJyokyo[$intData][0]==1){
			$PhpJyokyo[$intCnt] = "<TD height=50 width=130 bgcolor=#ffffff align=center>".$strComment[$intData].
				 "<SPAN class=Normalfont>承認<BR>".
				 $strJyokyo[$intData][1]." ".$strJyokyo[$intData][2].
				 "</SPAN></TD>";
		}elseif ($strJyokyo[$intData][0]==2){
			$PhpJyokyo[$intCnt] = "<TD height=50 width=130 bgcolor=#ffffff align=center>".$strComment[$intData].
				 "<SPAN class=Normalfont>却下<BR>".
				 $strJyokyo[$intData][1]." ".$strJyokyo[$intData][2].
				 "</SPAN></TD>";
			$intChkFlg=1;
		}
	}else{
		$PhpComment = "";
		$PhpJyokyo[$intCnt] =  "<TD height=50 width=130 bgcolor=#ffffff align=center><SPAN class=Normalfont></SPAN></TD>";
	}
	// 決裁者リスト
	$PhpList[$intCnt] = "<TD height=20 width=300 bgcolor=#ccffcc align=center><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.tpl');

?>