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

include("inc/FLO001.inc");
include("inc/FLO004_1.inc");

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

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

//初期値設定
if (empty($disp_flg)){
	$disp_flg=0;
}
if (empty($ichiran)){
	$ichiran=1;
}

//ページカウント
if (empty($intPage)){
	$intPage=0;
}

//社員情報取得
$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;
}

$where="";
if($disp_flg == 0){
	//$strWhere=" Where syain_cd='".$PHP_SYAIN_CD."'";
	$strWhere=" Where sinsei_tbl.syain_cd='".$PHP_SYAIN_CD."'";
}else{
	$strWhere=" Where ";
	$intKanriFlg=pg_numrows($objRecSet);
	for($intCnt = 0; $intCnt < $intKanriFlg ; $intCnt++) {
		$objData = pg_fetch_object($objRecSet, $intCnt);
		$strWhere=$strWhere." sinsei_tbl.sinsei_syubetu=".$objData->sinsei_syubetu." or ";
	}
	$strWhere=$strWhere." sinsei_tbl.sinsei_syubetu=0";
}

//全体件数のカウント
//$strSQL = "SELECT COUNT(*) as cnt From sinsei_tbl Join  kessaisya_tbl On kessaisya_tbl.sinsei_syubetu = sinsei_tbl.sinsei_syubetu ". $strWhere;

$strSQL = "SELECT COUNT(*) as cnt ".
		  "FROM sinsei_tbl ".
		  "Join  kessaisya_tbl ON kessaisya_tbl.sinsei_syubetu = sinsei_tbl.sinsei_syubetu ".
		  "Join  syain_tbl ON sinsei_tbl.syain_cd = syain_tbl.syain_cd ".
		  $strWhere;
$objRecCntSet = pg_exec($strSQL);
if($objRecCntSet==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_numrows($objRecCntSet)>0){
	$ftcData = pg_fetch_object($objRecCntSet,0);
	$intKensuCnt = $ftcData->cnt;
}else{
	$intKensuCnt = 0;
}
//抽出開始位置
if($intPage == 0){
	$kaisiIti = 0;
}else{
	$kaisiIti = $intPage * 10;
}
	//データ取得
//	$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 ";
//$strSQL = "SELECT  seq,syain_cd,sinsei_tbl.sinsei_syubetu,sinsei_date,sinsei_time, reason, ".
//$strSQL = "SELECT  seq,syain_cd,sinsei_tbl.sinsei_syubetu,sinsei_date,sinsei_time, reason, ".

$strSQL = "SELECT  seq,sinsei_tbl.syain_cd,sinsei_tbl.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, ".
					" hantei_flg,kessaisya_cd1,kessaisya_cd2,kessaisya_cd3,kessaisya_cd4,kessaisya_cd5, ".
					//追加
					" name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei,sinsei_name, ".
					" CASE ".
					"  WHEN kessaisya_cd1='".$PHP_SYAIN_CD."' And sinsei_flg1='0'  THEN '0' ".
					"  WHEN kessaisya_cd2='".$PHP_SYAIN_CD."' And sinsei_flg2='0' And sinsei_flg1='1' THEN '0' ".
					"  WHEN kessaisya_cd3='".$PHP_SYAIN_CD."' And sinsei_flg3='0' And sinsei_flg2='1' THEN '0' ".
					"  WHEN kessaisya_cd4='".$PHP_SYAIN_CD."' And sinsei_flg4='0' And sinsei_flg3='1' THEN '0' ".
					"  WHEN kessaisya_cd5='".$PHP_SYAIN_CD."' And sinsei_flg5='0' And sinsei_flg4='1' THEN '0' ".
					" ELSE ".
					"  '1' ".
					" END AS Jnban ".
					"FROM  ".
					" sinsei_tbl Join kessaisya_tbl ".
					" On ".
					"  kessaisya_tbl.sinsei_syubetu = sinsei_tbl.sinsei_syubetu  ".
					//追加
					"Join  syain_tbl ON sinsei_tbl.syain_cd = syain_tbl.syain_cd ".
					"Join  mst_sinsei ON sinsei_tbl.sinsei_syubetu = mst_sinsei.sinsei_syubetu ".
					$strWhere." ".
					"ORDER BY  ";
//					"ORDER BY  ".
//					" Jnban ASC,sinsei_tbl.seq DESC LIMIT 10 OFFSET ".$kaisiIti;
// ソート情報
switch ($Sort_Mode) {
	case "1":
		//申請日時
		$strSQL .= " sinsei_tbl.seq ";
		if ($Sort_Ptn == "1"){
			$Sort_Disp[1] = "▲";
			$Sort_Val[1]  = "2";
		}else{
			$Sort_Disp[1] = "▼";
			$Sort_Val[1]  = "1";
		}
		$Sort_Disp[2] = "";
		$Sort_Val[2]  = "1";
		$Sort_Disp[3] = "";
		$Sort_Val[3]  = "1";
		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;
	case "2":
		//申請者
		$Sort_Disp[1] = "";
		$Sort_Val[1]  = "1";
		if ($Sort_Ptn == "1"){
			$strSQL .= "name_kn_sei ASC ,name_kn_mei ASC ";
			$Sort_Disp[2] = "▲";
			$Sort_Val[2]  = "2";
		}else{
			$strSQL .= "name_kn_sei DESC ,name_kn_mei DESC ";
			$Sort_Disp[2] = "▼";
			$Sort_Val[2]  = "1";
		}
		$Sort_Disp[3] = "";
		$Sort_Val[3]  = "1";
		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;
	case "3":
		//申請種別
		$strSQL .= "sinsei_name ";
		$Sort_Disp[1] = "";
		$Sort_Val[1]  = "1";
		$Sort_Disp[2] = "";
		$Sort_Val[2]  = "1";
		if ($Sort_Ptn == "1"){
			$Sort_Disp[3] = "▲";
			$Sort_Val[3]  = "2";
		}else{
			$Sort_Disp[3] = "▼";
			$Sort_Val[3]  = "1";
		}
		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;
	default:
		//デフォルト表示設定
		$strSQL .= " Jnban ASC,sinsei_tbl.seq ";
		$Sort_Mode = "1";
		$Sort_Ptn  = "2";
		$Sort_Disp[1] = "▼";
		$Sort_Val[1] = "1";
		$Sort_Disp[2] = "";
		$Sort_Val[2] = "1";
		$Sort_Disp[3] = "";
		$Sort_Val[3] = "1";
		$Sort_Disp[4] = "";
		$Sort_Val[4] = "1";

}
if($Sort_Mode!= "2"){
	switch ($Sort_Ptn) {
		case "1":
			$strSQL .= "ASC ";
			break;
		case "2":
			$strSQL .= "DESC ";
	}
}

$strSQL .= "LIMIT 10 OFFSET ".$kaisiIti;
$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;
	*/
	$strSinsei[$intCnt][2]=$objRecData->name_kj_sei.$objRecData->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][3]=$objRecData->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);

	//決裁状況
	//新決裁者テーブル検索
	$strSQL1="SELECT * FROM kessaijoukyou_tbl Where sinsei_seq='".$strSinsei[$intCnt][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]=$objRecData1->kessai_joukyou;
			if($objRecData1->kessai_comment!="" && $objRecData1->kessai_comment!="　"){
				$strComment[$intCnt1+1]="<font color=\"#ff0000\">　※コメントあり<br></font>";
			}else{
				$strComment[$intCnt1+1]="<BR>";
			}

			//申請者名称
			$strSQL2="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$objRecData1->syain_cd."'";
			$objData2 = pg_exec($strSQL2);
			if($objData2==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			$objRec2 = pg_fetch_object($objData2, 0);
			$StrKessai=$objRec2->name_kj_sei.$objRec2->name_kj_mei;

			$kesai_no = $intCnt1 + 1;

			if($objRecData1->kessai_joukyou==0){
				if($objRecData1->syain_cd==$PHP_SYAIN_CD){
					$strSinsei[$intCnt][7].="<span class=\"Normalfont\"><strong><font color=\"#CC0000\">".$StrKessai."さんの".$kesai_no."次決裁中"."</font><strong></span>";
					$strSinsei[$intCnt][8]=1;
				}else{
					$strSinsei[$intCnt][7].="<span class=\"Normalfont\"><strong>".$StrKessai."さんの".$kesai_no."次決裁中"."<strong></span>";
					$strSinsei[$intCnt][8]=0;
				}
				if ($disp_flg==1){
					if($objRecData1->syain_cd==$PHP_SYAIN_CD){
						$strSinsei[$intCnt][9]      = "tblUn";
					}else{
						$strSinsei[$intCnt][9]      = "tblAl";
					}
				}else{
					$strSinsei[$intCnt][9]      = "tblUn";
				}
				break;
			}elseif($objRecData1->kessai_joukyou==1){
				$strSinsei[$intCnt][7].=$kesai_no."次決裁:<font color=\"#009933\">承認</font>".$strComment[$intCnt1+1];
				$strSinsei[$intCnt][8]=0;
				$strSinsei[$intCnt][9]      = "tblAl";
			}elseif ($objRecData1->kessai_joukyou==2){
				$strSinsei[$intCnt][7].=$kesai_no."次決裁:<font color=\"#FF0000\">却下</font>".$strComment[$intCnt1+1];
				$strSinsei[$intCnt][8]=0;
				$strSinsei[$intCnt][9]      = "tblAl";
				break;
			}
		}
	}else{
		//旧データのまま
		$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!="" && $objRecData->comment1!="　"){$strComment[1]="<font color=\"#ff0000\">　※コメントあり<br></font>";}else{$strComment[1]="<BR>";};
		if($objRecData->comment2!="" && $objRecData->comment2!="　"){$strComment[2]="<font color=\"#ff0000\">　※コメントあり<br></font>";}else{$strComment[2]="<BR>";};
		if($objRecData->comment3!="" && $objRecData->comment3!="　"){$strComment[3]="<font color=\"#ff0000\">　※コメントあり<br></font>";}else{$strComment[3]="<BR>";};
		if($objRecData->comment4!="" && $objRecData->comment4!="　"){$strComment[4]="<font color=\"#ff0000\">　※コメントあり<br></font>";}else{$strComment[4]="<BR>";};
		if($objRecData->comment5!="" && $objRecData->comment5!="　"){$strComment[5]="<font color=\"#ff0000\">　※コメントあり<br></font>";}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){
				$KessaiSya[1]=$objRec->kessaisya_cd1;
				$KessaiSya[2]=$objRec->kessaisya_cd2;
				$KessaiSya[3]=$objRec->kessaisya_cd3;
				$KessaiSya[4]=$objRec->kessaisya_cd4;
				$KessaiSya[5]=$objRec->kessaisya_cd5;

				//申請者名称
				$strSQL="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd='".$KessaiSya[$intData]."'";
				$objData2 = pg_exec($strSQL);
				if($objData2==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}
				$objRec2 = pg_fetch_object($objData2, 0);
				$StrKessai=$objRec2->name_kj_sei.$objRec2->name_kj_mei;
							
				if($KessaiSya[$intData]==$PHP_SYAIN_CD){
					$strSinsei[$intCnt][7].="<span class=\"Normalfont\"><strong><font color=\"#CC0000\">".$StrKessai."さんの".$intData."次決裁中"."</font><strong></span>";
					$strSinsei[$intCnt][8]=1;
				}else{
					$strSinsei[$intCnt][7].="<span class=\"Normalfont\"><strong>".$StrKessai."さんの".$intData."次決裁中"."<strong></span>";
					$strSinsei[$intCnt][8]=0;
				}
				if ($disp_flg==1){
					if($KessaiSya[$intData]==$PHP_SYAIN_CD){
						$strSinsei[$intCnt][9]      = "tblUn";
					}else{
						$strSinsei[$intCnt][9]      = "tblAl";
					}
				}else{
					$strSinsei[$intCnt][9]      = "tblUn";
				}
				break;
			}elseif ($strJyokyo[$intData]==1){
				$strSinsei[$intCnt][7].=$intData."次決裁:<font color=\"#009933\">承認</font>".$strComment[$intData];
				$strSinsei[$intCnt][8]=0;
				$strSinsei[$intCnt][9]      = "tblAl";
			}elseif ($strJyokyo[$intData]==2){
				$strSinsei[$intCnt][7].=$intData."次決裁:<font color=\"#FF0000\">却下</font>".$strComment[$intData];
				$strSinsei[$intCnt][8]=0;
				$strSinsei[$intCnt][9]      = "tblAl";
				break;
			}
		}
	}
}

for($intCnt = 0; $intCnt < count($strSinsei) ; $intCnt++){
	$PhpDate[$intCnt]    = $strSinsei[$intCnt][1]; //申請日時
	$PhpName[$intCnt]    = $strSinsei[$intCnt][2]; //申請者
	$PhpKind[$intCnt]    = $strSinsei[$intCnt][3]; //申請書種別
	$PhpNaiyo[$intCnt]   = $strSinsei[$intCnt][4]; //申請内容
	$PhpFile[$intCnt]    = $strSinsei[$intCnt][6]; //ファイル名
	$PhpJokyo[$intCnt]   = $strSinsei[$intCnt][7]; //状況
	$PhpFlg[$intCnt]     = $strSinsei[$intCnt][8]; //フラグ
	$PhpDel[$intCnt]     = $strSinsei[$intCnt][0]; //シーケンス
	$PhpBgColor[$intCnt] = $strSinsei[$intCnt][9]; //背景色
}

// ボタン表示
$PhpBtnKessai ="<INPUT type=button value=決裁一覧 onclick=Load3()>";
if ( count($strSinsei) == 0){
	$PhpBtnChk ="<INPUT type=\"button\" onclick=\"All_chk();\" value=\"ﾁｪｯｸ\"  disabled=true >".
							"<span class=\"Tinnyfont\"><br></span><INPUT type=button value=削除 onclick=submit1()  disabled=true>";
}else{
	$PhpBtnChk ="<INPUT type=\"button\" onclick=\"All_chk();\" value=\"ﾁｪｯｸ\" >".
							"<span class=\"Tinnyfont\"><br></span><INPUT type=button value=削除 onclick=submit1() >";
}

//ページ、ボタンセット
if (($intPage > 0) && ($intKensuCnt > (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = $intPage+1;
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt(1,".$Sort_Mode.",".$Sort_Ptn.")' > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt(3,".$Sort_Mode.",".$Sort_Ptn.")' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt(2,".$Sort_Mode.",".$Sort_Ptn.")' > ";
}elseif(($intPage > 0) && ($intKensuCnt <= (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = "";
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt(1,".$Sort_Mode.",".$Sort_Ptn.")'  > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt(3,".$Sort_Mode.",".$Sort_Ptn.")' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt(2,".$Sort_Mode.",".$Sort_Ptn.")' disabled> ";
}elseif(($intPage == 0) && ($intKensuCnt > (10 * ($intPage+1)))){
	$PageBackPrm = "";
	$PageNextPrm = $intPage+1;
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt(1,".$Sort_Mode.",".$Sort_Ptn.")' disabled> ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt(3,".$Sort_Mode.",".$Sort_Ptn.")' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt(2,".$Sort_Mode.",".$Sort_Ptn.")' > ";
}else{
	$PageBackPrm = "";
	$PageNextPrm = "";
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt(1,".$Sort_Mode.",".$Sort_Ptn.")' disabled > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt(3,".$Sort_Mode.",".$Sort_Ptn.")' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt(2,".$Sort_Mode.",".$Sort_Ptn.")' disabled > ";
}

$o_smarty->assign('PhpBtnChk',$PhpBtnChk);
$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('PhpJokyo',$PhpJokyo);
$o_smarty->assign('PhpDel',$PhpDel);
$o_smarty->assign('PhpFlg',$PhpFlg);
$o_smarty->assign('PhpJokyo',$PhpJokyo);
$o_smarty->assign('PhpBtnKessai',$PhpBtnKessai);
$o_smarty->assign('PhpBtnChk',$PhpBtnChk);
$o_smarty->assign('PhpBgColor',$PhpBgColor);
$o_smarty->assign('pg_numrows',pg_numrows($objRecSet));
$o_smarty->assign('ichiran',$ichiran);
$o_smarty->assign('disp_flg',$disp_flg);
$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[10]);

$o_smarty->assign('PageBackPrm',$PageBackPrm);
$o_smarty->assign('PageNextPrm',$PageNextPrm);
$o_smarty->assign('intPage',$intPage);

$o_smarty->assign('botan1',$botan1);
$o_smarty->assign('botan2',$botan2);
$o_smarty->assign('botan3',$botan3);

$o_smarty->assign('Sort_Disp',$Sort_Disp);
$o_smarty->assign('Sort_Val',$Sort_Val);
$o_smarty->assign('Sort_Ptn',$Sort_Ptn);
$o_smarty->assign('Sort_Mode',$Sort_Mode);

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

?>