<?php 
//*****************************************************************************
//* 
//* プログラム名：プロジェクト管理
//* プログラムID：PRJ903.php
//* 機能        ：プロジェクト登録・修正
//* 作成者      ：
//* 
//*****************************************************************************

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

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

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

/*
$prjName = mb_convert_encoding(addslashes($prjName), "eucJP-win", "auto");
$prjNaiyo = mb_convert_encoding(addslashes($prjNaiyo), "eucJP-win", "auto");
$prjBiko = mb_convert_encoding(addslashes($prjBiko), "eucJP-win", "auto");
*/

//責任者
if($stradd1 != "/"){
	$stradd1 = "/".$stradd1;
}
//参加者
if($stradd2 != "/"){
	$stradd2 = "/".$stradd2;
	//責任者が参加者にいない場合、追加
	$tempArr1 = split("/", $stradd1);
	$tempArr2 = split("/", $stradd2);
	for($i=1;$i<count($tempArr1)-1;$i++){
		$flg = 0;
		for($j=1;$j<count($tempArr2)-1;$j++){
			if($tempArr1[$i] == $tempArr2[$j]){
				$flg = 1;
			}
		}
		if($flg == 0){
			$stradd2 = "/".$tempArr1[$i].$stradd2;
		}
	}
}
//監査者
if($stradd3 != "/"){
	$stradd3 = "/".$stradd3;
}

$prj_seq = "";
if((int)$seq == 0){
//新規
	//seq設定
	$strSQL = "select * from prj_tbl order by seq desc";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0){
		$objNo = pg_fetch_object($objRec, 0);
		$seqNew = ($objNo->seq) + 1;
	}else{
		$seqNew = 1;
	}
	

	//いんさーと
	$strSQL = "insert into prj_tbl ";
	$strSQL .= "(seq, prj_name, sekinin_list, kansa_list, sanka_list, prj_naiyo, prj_etc, start_date, end_date, end_flg, disp_rank) ";
	$strSQL .= "values(".$seqNew.", '".addslashes($prjName)." ', '".$stradd1."', '".$stradd3."', '".$stradd2."', '".addslashes($prjNaiyo)." ', '".addslashes($prjBiko)." ', '', '', 0, ".$seqNew.")";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}
	
	//監査用インサート
	if($stradd3 != "/"){
		$tempArr1 = split("/", $stradd3);
		for($i=1;$i<count($tempArr1)-2;$i++){
			$strSQL = "insert into prj_comm_tbl ";
			$strSQL .= "(seq, task_seq, task_sub_seq, comm_seq, comm_flg, comment, input_date, syain_cd) ";
			$strSQL .= "values(".$seqNew.", 0, 0, ".$i.", 3, '0', '', '".$tempArr1[$i]."')";
			$objRec = pg_exec($strSQL);
			if($objRec == false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
	}	
	
	//カテゴリインサート
	if((int) $ctg_seq != 0){
		$strSQL = "insert into prj_ctg_tbl ";
		$strSQL .= "(prj_seq, ctg_seq) ";
		$strSQL .= "values(".$seqNew.", ".$ctg_seq.")";
		$objRec = pg_exec($strSQL);
		if($objRec == false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

	}
	$prj_seq = $seqNew;
}else{
//修正
	//あっぷでーと
	$strSQL = "update prj_tbl set ";
	$strSQL .= "seq = ".$seq.", prj_name = '".addslashes($prjName)." ', sekinin_list = '".$stradd1."', kansa_list = '".$stradd3."', sanka_list = '".$stradd2."', prj_naiyo = '".addslashes($prjNaiyo)." ', prj_etc = '".addslashes($prjBiko)." ' ";
	$strSQL .= "where seq = ".$seq;
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(UPDATE)");
		exit;
	}
	//監査用デリート・インサート
	$strSQL = "delete from prj_comm_tbl where seq = ".$seq." and comm_flg = 3";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(DELETE)");
		exit;
	}
	if($stradd3 != "/"){
		$tempArr1 = split("/", $stradd3);
		for($i=1;$i<count($tempArr1)-2;$i++){
			$strSQL = "insert into prj_comm_tbl ";
			$strSQL .= "(seq, task_seq, task_sub_seq, comm_seq, comm_flg, comment, input_date, syain_cd) ";
			$strSQL .= "values(".$seq.", 0, 0, ".$i.", 3, '0', '', '".$tempArr1[$i]."')";
//echo $strSQL."\n";
			$objRec = pg_exec($strSQL);
			if($objRec == false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
	}	


	//カテゴリデリート・インサート
	$strSQL = "delete from prj_ctg_tbl where prj_seq = ".$seq;
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(DELETE)");
		exit;
	}
	if((int) $ctg_seq != 0){
		$strSQL = "insert into prj_ctg_tbl ";
		$strSQL .= "(prj_seq, ctg_seq) ";
		$strSQL .= "values(".$seq.", ".$ctg_seq.")";
		$objRec = pg_exec($strSQL);
		if($objRec == false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

	}

	$prj_seq = $seq;
	
}

//ファイルアップロード処理
$strTempPath="temp/".$PHP_FOLDER_NAME."/PRJ/";
//削除チェックボックス確認
if($delF1 == "1"){
	DB_File_DELETE("PRJ", $prj_seq, "1", $strTempPath);
}
if($delF2 == "1"){
	DB_File_DELETE("PRJ", $prj_seq, "2", $strTempPath);
}
if($delF3 == "1"){
	DB_File_DELETE("PRJ", $prj_seq, "3", $strTempPath);
}
if($delF4 == "1"){
	DB_File_DELETE("PRJ", $prj_seq, "4", $strTempPath);
}
if($delF5 == "1"){
	DB_File_DELETE("PRJ", $prj_seq, "5", $strTempPath);
}
//ファイルアップ
if($upfile1_name != ""){
	$f1_orgName = $upfile1_name;
	$f1_seqName = $prj_seq."-1";
	move_uploaded_file($upfile1, $strTempPath.$f1_seqName);
	DB_File_INSERT("PRJ", $prj_seq, "1", $f1_orgName, $f1_seqName);
}
if($upfile2_name != ""){
	$f2_orgName = $upfile2_name;
	$f2_seqName = $prj_seq."-2";
	move_uploaded_file($upfile2, $strTempPath.$f2_seqName);
	DB_File_INSERT("PRJ", $prj_seq, "2", $f2_orgName, $f2_seqName);
}
if($upfile3_name != ""){
	$f3_orgName = $upfile3_name;
	$f3_seqName = $prj_seq."-3";
	move_uploaded_file($upfile3, $strTempPath.$f3_seqName);
	DB_File_INSERT("PRJ", $prj_seq, "3", $f3_orgName, $f3_seqName);
}
if($upfile4_name != ""){
	$f4_orgName = $upfile4_name;
	$f4_seqName = $prj_seq."-4";
	move_uploaded_file($upfile4, $strTempPath.$f4_seqName);
	DB_File_INSERT("PRJ", $prj_seq, "4", $f4_orgName, $f4_seqName);
}
if($upfile5_name != ""){
	$f5_orgName = $upfile5_name;
	$f5_seqName = $prj_seq."-5";
	move_uploaded_file($upfile5, $strTempPath.$f5_seqName);
	DB_File_INSERT("PRJ", $prj_seq, "5", $f5_orgName, $f5_seqName);
}

function DB_File_DELETE($pType,$pSeq,$pFno,$pPath){

	$strSQL  = "SELECT * FROM common_file_tbl ";
	$strSQL .= "WHERE ";
	$strSQL .= " type ='".$pType."' AND ";
	$strSQL .= " seq1 = ".$pSeq." AND ";
	$strSQL .= " seq2 = 0 AND ";
	$strSQL .= " seq3 = 0 AND ";
	$strSQL .= " seq4 = 0 AND ";
	$strSQL .= " seq5 = 0 AND ";
	$strSQL .= " file_seq =".$pFno." ";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0){
	
		$objdata = pg_fetch_object($objRec, 0);
		$filePath = $pPath.($objdata->file_name);
		if(file_exists($filePath)){
			unlink($filePath);  
		}
		$strSQL  = "DELETE FROM common_file_tbl ";
		$strSQL .= "WHERE ";
		$strSQL .= " type ='".$pType."' AND ";
		$strSQL .= " seq1 = ".$pSeq." AND ";
		$strSQL .= " seq2 = 0 AND ";
		$strSQL .= " seq3 = 0 AND ";
		$strSQL .= " seq4 = 0 AND ";
		$strSQL .= " seq5 = 0 AND ";
		$strSQL .= " file_seq =".$pFno." ";
		$objRecD = pg_exec($strSQL);
		if($objRecD == false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
		}
	}
	
}

function DB_File_INSERT($pType,$pSeq,$pFno,$pOrgName,$pSeqName){
	
	$strSQL  = "INSERT INTO common_file_tbl ";
	$strSQL .= " (";
	$strSQL .= "  type, ";
	$strSQL .= "  seq1, ";
	$strSQL .= "  seq2, ";
	$strSQL .= "  seq3, ";
	$strSQL .= "  seq4, ";
	$strSQL .= "  seq5, ";
	$strSQL .= "  file_seq, ";
	$strSQL .= "  file_name, ";
	$strSQL .= "  file_name_org, ";
	$strSQL .= "  file_comm, ";
	$strSQL .= "  file_yobi1, ";
	$strSQL .= "  file_yobi2, ";
	$strSQL .= "  file_yobi3 ";
	$strSQL .= " )";
	$strSQL .= " VALUES(";
	$strSQL .= "  '".$pType."', ";
	$strSQL .= "  ".$pSeq.", ";
	$strSQL .= "  0, ";
	$strSQL .= "  0, ";
	$strSQL .= "  0, ";
	$strSQL .= "  0, ";
	$strSQL .= "  ".$pFno.", ";
	$strSQL .= "  '".$pSeqName."', ";
	$strSQL .= "  '".$pOrgName."', ";
	$strSQL .= "  '', ";
	$strSQL .= "  '', ";
	$strSQL .= "  '', ";
	$strSQL .= "  '' ";
	$strSQL .= " )";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}
}

header("Location:PRJ000.php?prj_seq=".$prj_seq);

?>