<?php 
//*****************************************************************************
//* 
//* プログラム名：電子決裁
//* プログラムID：FLO003.php
//* 機能        ：決裁一覧
//* 作成者      ：
//* 
//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");
include("inc/session_start.inc");
include("inc/SessionChk.inc");
include('./include/smarty.conf');
include("inc/header.inc");

//メニューセット
include("menu_opacity.php");
include("inc/STRING.inc");
include("inc/FLO003.inc");

//**** ＤＢ接続 ****//
$strDBinc="include/dbcon.inc";
include($strDBinc);

$strTempPath="temp/".$PHP_FOLDER_NAME."/sinsei/";

//社員情報取得

$strSQL="Select sinsei_syubetu From kessaisya_tbl Where ".
		"kessaisya_cd1='$PHP_SYAIN_CD' or ".
		"kessaisya_cd2='$PHP_SYAIN_CD' or ".
		"kessaisya_cd3='$PHP_SYAIN_CD' or ".
		"kessaisya_cd4='$PHP_SYAIN_CD' or ".
		"kessaisya_cd5='$PHP_SYAIN_CD'";

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

$intMax=pg_numrows($objRecSet);
for($intCnt = 0; $intCnt < $intMax ; $intCnt++) {
	$objData = pg_fetch_object($objRecSet, $intCnt);
	if ($intCnt==0){
		$strWhere=$strWhere." Where (sinsei_syubetu=".$objData->sinsei_syubetu;
	}
	else
	{
		$strWhere=$strWhere." or sinsei_syubetu=".$objData->sinsei_syubetu;
	}
}
$strWhere=$strWhere.")";

//データ取得

$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 ".$strWhere." Order By seq DESC";

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

$intMax=pg_numrows($objRecSet);
for($intCnt = 0; $intCnt < $intMax ; $intCnt++) {
	$objRecData = pg_fetch_object($objRecSet, $intCnt);
	//SEQ
	$strSinsei[$intCnt][0]=$objRecData->seq;
	//申請日時
	$strSinsei[$intCnt][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[$intCnt][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[$intCnt][3]=$objRec->sinsei_name;

	//申請理由
	$strSinsei[$intCnt][4]=LINE_BR($objRecData->reason,36);
	//申請書名(英字)
	$strSinsei[$intCnt][5]=$objRecData->file_name;
	//申請書名(日本語)
	$strSinsei[$intCnt][6]=LINE_DEL($objRecData->file_name_jp,12);
	//決済状況
	$strJyokyo[1]=$objRecData->sinsei_flg1;
	$strJyokyo[2]=$objRecData->sinsei_flg2;
	$strJyokyo[3]=$objRecData->sinsei_flg3;
	$strJyokyo[4]=$objRecData->sinsei_flg4;
	$strJyokyo[5]=$objRecData->sinsei_flg5;

	if($objRecData->comment1!=""){$strComment[1]="【".$objRecData->comment1."】<BR>";}else{$strComment[1]="<BR>";};
	if($objRecData->comment2!=""){$strComment[2]="【".$objRecData->comment2."】<BR>";}else{$strComment[2]="<BR>";};
	if($objRecData->comment3!=""){$strComment[3]="【".$objRecData->comment3."】<BR>";}else{$strComment[3]="<BR>";};
	if($objRecData->comment4!=""){$strComment[4]="【".$objRecData->comment4."】<BR>";}else{$strComment[4]="<BR>";};
	if($objRecData->comment5!=""){$strComment[5]="【".$objRecData->comment5."】<BR>";}else{$strComment[5]="<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;

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

	$objRec = pg_fetch_object($objData, 0);
	for($intData = 1; $intData <= $objRec->kessaisya_num ; $intData++)
	{
		if ($strJyokyo[$intData]==0)
		{
			//自決裁担当順
			$strSinsei[$intCnt][7].="<span class=\"MiddleBold\">".$intData."次決裁中</span>";
			switch ($intData){
				case 1:
						if ($objRec->kessaisya_cd1==$PHP_SYAIN_CD)
						{
							$strSinsei[$intCnt][8]="ccffcc";
						}
						else
						{
							$strSinsei[$intCnt][8]="ffffff";
						}
						break;
				case 2:
						if ($objRec->kessaisya_cd2==$PHP_SYAIN_CD)
						{
							$strSinsei[$intCnt][8]="ccffcc";
						}
						else
						{
							$strSinsei[$intCnt][8]="ffffff";
						}
						break;

				case 3:
						if ($objRec->kessaisya_cd3==$PHP_SYAIN_CD)
						{
							$strSinsei[$intCnt][8]="ccffcc";
						}
						else
						{
							$strSinsei[$intCnt][8]="ffffff";
						}
						break;

				case 4:
						if ($objRec->kessaisya_cd4==$PHP_SYAIN_CD)
						{
							$strSinsei[$intCnt][8]="ccffcc";
						}
						else
						{
							$strSinsei[$intCnt][8]="ffffff";
						}
						break;

				case 5:
						if ($objRec->kessaisya_cd5==$PHP_SYAIN_CD)
						{
							$strSinsei[$intCnt][8]="ccffcc";
						}
						else
						{
							$strSinsei[$intCnt][8]="ffffff";
						}
					break;
			}
			break;
		}

		elseif ($strJyokyo[$intData]==1)
		{
			$strSinsei[$intCnt][7].=$intData."次決裁:<font color=\"#009933\">承認</font>".$strComment[$intData];
			$strSinsei[$intCnt][8]="ffffff";
		}

		elseif ($strJyokyo[$intData]==2)
		{
			$strSinsei[$intCnt][7].=$intData."次決裁:<font color=\"#FF0000\">却下</font>".$strComment[$intData];
			$strSinsei[$intCnt][8]="ffffff";
			break;
		}
	}
}


for($intCnt = 0; $intCnt < count($strSinsei); $intCnt++)
{
	//申請日時
	$PhpDate[$intCnt]   = "<TD bgcolor=".$strSinsei[$intCnt][8]." align=center><span class=Flowfont>".$strSinsei[$intCnt][1]."</span></TD>";
	//申請者
	$PhpName[$intCnt]   = "<TD bgcolor=".$strSinsei[$intCnt][8]."><span class=Normalfont>".$strSinsei[$intCnt][2]."</span></TD>";
	//申請書種別
	$PhpKind[$intCnt]   = "<TD bgcolor=".$strSinsei[$intCnt][8]." align=center><span class=Normalfont>".$strSinsei[$intCnt][3]."</span></TD>";
	//申請内容
	$PhpNaiyo[$intCnt]  = "<TD bgcolor=".$strSinsei[$intCnt][8]."><span class=Normalfont>".$strSinsei[$intCnt][4]."</span></TD>";
	//ファイル名
	$PhpFile[$intCnt]   = "<TD bgcolor=".$strSinsei[$intCnt][8]."><span class=Normalfont>".$strSinsei[$intCnt][6]."</span></TD>";
	//状況
	$PhpJyokyo[$intCnt] = "<TD bgcolor=".$strSinsei[$intCnt][8]." ><span class=Normalfont>".$strSinsei[$intCnt][7]."</span></TD>";
	//表示ボタン
	$PhpBtn[$intCnt]    = "<TD bgcolor=".$strSinsei[$intCnt][8]." align=center>"."<INPUT type=button value=表示 onclick=submit1(".$strSinsei[$intCnt][0].")></TD>";
}


		$o_smarty->assign('PhpCnt',count($strSinsei));
		$o_smarty->assign('PhpDate',$PhpDate);
		$o_smarty->assign('PhpName',$PhpName);
		$o_smarty->assign('PhpKind',$PhpKind);
		$o_smarty->assign('PhpNaiyo',$PhpNaiyo);
		$o_smarty->assign('PhpFile',$PhpFile);
		$o_smarty->assign('PhpJyokyo',$PhpJyokyo);
		$o_smarty->assign('PhpBtn',$PhpBtn);
		$o_smarty->display('FLO003.tpl');

?>