<?php 
//*****************************************************************************
//* 
//* プログラム名：プロジェクト管理
//* プログラムID：PRJ003.php
//* 機能        ：プロジェクト作成画面
//* 作成者      ：
//* 
//*****************************************************************************

header( "Content-type: text/html; charset=EUC-JP");

include("inc/session_start.inc");
include("inc/SessionChk.inc");

include('./include/smarty.conf');
include("inc/mtc_comfunc.inc");


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


//社員リスト
$strSQL = "select syain_cd, name_kj_sei, name_kj_mei from syain_tbl Where del_flg = true order by disp_rank";
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$syain_list ="";
for ($intlist = 0; $intlist < pg_numrows($objRec); $intlist++) {
		$objlist = pg_fetch_object($objRec, $intlist);
		$syain_list.= "<OPTION value= '".$objlist->syain_cd."' selected>".$objlist->name_kj_sei.$objlist->name_kj_mei."</OPTION>";
}


//ファイルアップ配列初期化
for($fCnt=0;$fCnt<5;$fCnt++){
	$strFileP[$fCnt] = "";
	$strFileN[$fCnt] = "";
	$strFileC[$fCnt] = $fCnt + 1;
	$strFileD[$fCnt] = "";
}

if($seq == 0){

	//先
	$syain_add = '<OPTION value="" >　　　　　　</OPTION>';
	$syain_add2 = '<OPTION value="" >　　　　　　</OPTION>';
	$syain_add3 = '<OPTION value="" >　　　　　　</OPTION>';

	//カテゴリリスト
	$strSQL = "select ctg_seq, ctg_name from mst_prj_category order by disp_rank";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$ctg_list ="<option value='0'>カテゴリなし</option>";
	for ($intlist = 0; $intlist < pg_numrows($objRec); $intlist++) {
		$objlist = pg_fetch_object($objRec, $intlist);
		$ctg_list.= "<OPTION value= '".$objlist->ctg_seq."'>".$objlist->ctg_name."</OPTION>";
	}
	
	$DIVNAME = "make_prj";

}else{

	$strSQL = "select seq, prj_name, sekinin_list, kansa_list, sanka_list, prj_naiyo, prj_etc, start_date, end_date, prj_ctg_tbl.ctg_seq from prj_tbl ";
	$strSQL .= "left join prj_ctg_tbl on prj_ctg_tbl.prj_seq = prj_tbl.seq ";
	$strSQL .= "where seq = ".$seq;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$objftc = pg_fetch_object($objRec, 0);
	//名称
	$strPrjName = htmlspecialchars(mtc_rtrim($objftc->prj_name));
	//内容
	$strPrjNaiyo = mtc_rtrim($objftc->prj_naiyo);
	
	//資料
	$strSQLF = "SELECT * FROM common_file_tbl WHERE type='PRJ' AND seq1 = ".$objftc->seq." ORDER BY file_seq";
	$objRecF = pg_exec($strSQLF);
	if($objRecF == false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRecF) > 0){
		for($fCnt=0;$fCnt<pg_numrows($objRecF);$fCnt++){
			$objftcF = pg_fetch_object($objRecF, $fCnt);
			$strFileP[($objftcF->file_seq) - 1] = "temp/".$PHP_FOLDER_NAME."/PRJ/".($objftcF->file_name);
			$strFileN[($objftcF->file_seq) - 1] = htmlspecialchars($objftcF->file_name_org);
			$strFileD[($objftcF->file_seq) - 1] = "disabled";
		}
	}

	//備考
	$strPrjBiko = mtc_rtrim($objftc->prj_etc);
	//カテゴリSEQ
	$strCtgSeq = (int) $objftc->ctg_seq;
		
	//責任者
	$syain_add = "";
	$temp =	trim($objftc->sekinin_list);
	if($temp != "/"){
		$strwhere = str_replace("//", "", $temp);
		$strwhere = substr($strwhere, 1, (strlen($strwhere) - 1));
		$strwhere = str_replace("/", "' or syain_cd = '", $strwhere);
		$strSQL2 = "select name_kj_sei, name_kj_mei, syain_cd from syain_tbl where syain_cd = '".$strwhere."' Order by disp_rank";
		$objRec2 = pg_exec($strSQL2);
		if($objRec2 == false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for($i=0;$i<pg_numrows($objRec2);$i++){
			$objftc2 = pg_fetch_object($objRec2, $i);
			$syain_add .=  "<OPTION value='".$objftc2->syain_cd."' selected>".($objftc2->name_kj_sei).($objftc2->name_kj_mei)."</option>";
		}
	}
	$syain_add .= '<OPTION value="" >　　　　　　</OPTION>';

	//参加者
	$syain_add2 = "";
	$temp =	trim($objftc->sanka_list);
	if($temp != "/"){
		$strwhere = str_replace("//", "", $temp);
		$strwhere = substr($strwhere, 1, (strlen($strwhere) - 1));
		$strwhere = str_replace("/", "' or syain_cd = '", $strwhere);
		$strSQL2 = "select name_kj_sei, name_kj_mei, syain_cd from syain_tbl where syain_cd = '".$strwhere."' Order by disp_rank";
		$objRec2 = pg_exec($strSQL2);
		if($objRec2 == false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for($i=0;$i<pg_numrows($objRec2);$i++){
			$objftc2 = pg_fetch_object($objRec2, $i);
			$syain_add2 .=  "<OPTION value='".$objftc2->syain_cd."' selected>".($objftc2->name_kj_sei).($objftc2->name_kj_mei)."</option>";
		}
	}
	$syain_add2 .= '<OPTION value="" >　　　　　　</OPTION>';

	//監査
	$syain_add3 = "";
	$temp =	trim($objftc->kansa_list);
	if($temp != "/"){
		$strwhere = str_replace("//", "", $temp);
		$strwhere = substr($strwhere, 1, (strlen($strwhere) - 1));
		$strwhere = str_replace("/", "' or syain_cd = '", $strwhere);
		$strSQL2 = "select name_kj_sei, name_kj_mei, syain_cd from syain_tbl where syain_cd = '".$strwhere."' Order by disp_rank";
		$objRec2 = pg_exec($strSQL2);
		if($objRec2 == false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for($i=0;$i<pg_numrows($objRec2);$i++){
			$objftc2 = pg_fetch_object($objRec2, $i);
			$syain_add3 .=  "<OPTION value='".$objftc2->syain_cd."' selected>".($objftc2->name_kj_sei).($objftc2->name_kj_mei)."</option>";
		}
	}
	$syain_add3 .= '<OPTION value="" >　　　　　　</OPTION>';
	

	//カテゴリリスト
	$strSQL = "select mst_prj_category.ctg_seq, ctg_name from mst_prj_category left join prj_ctg_tbl on prj_ctg_tbl.prj_seq = ".$seq." order by disp_rank";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$ctg_list ="<option value='0'>カテゴリなし</option>";
	for ($intlist = 0; $intlist < pg_numrows($objRec); $intlist++) {
		$objlist = pg_fetch_object($objRec, $intlist);
		if($strCtgSeq == $objlist->ctg_seq){
			$ctg_list.= "<OPTION value= '".$objlist->ctg_seq."' selected>".$objlist->ctg_name."</OPTION>";
		}else{
			$ctg_list.= "<OPTION value= '".$objlist->ctg_seq."'>".$objlist->ctg_name."</OPTION>";
		}
	}

	$DIVNAME = "mod-prj";	
}

$o_smarty->assign('seq',$seq);

$o_smarty->assign('strFileP',$strFileP);
$o_smarty->assign('strFileN',$strFileN);
$o_smarty->assign('strFileC',$strFileC);
$o_smarty->assign('strFileD',$strFileD);

$o_smarty->assign('ctg_list',$ctg_list);

$o_smarty->assign('syain_add',$syain_add);
$o_smarty->assign('syain_add2',$syain_add2);
$o_smarty->assign('syain_add3',$syain_add3);
$o_smarty->assign('syain_list',$syain_list);

$o_smarty->assign('DIVNAME',$DIVNAME);

$o_smarty->assign('strPrjName',$strPrjName);
$o_smarty->assign('strPrjNaiyo',$strPrjNaiyo);
$o_smarty->assign('strPrjBiko',$strPrjBiko);

$o_smarty->display('PRJ003.tpl');
?>