<?PHP 
//*****************************************************************************
//* プログラム名：ユーザ更新処理
//* プログラムID：ZIS9802.php
//* 機能        ：ユーザ更新処理
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/SessionChk.inc");
include("./inc/dbcon.inc");

$mode = $_POST["mode"];
$uSeq = $_POST["uSeq"];
$uName = $_POST["uName"];

$uPw = $_POST["uPw"];

$bSeq = intval($_POST["bumonseq"]);

$use_area = intval($_POST["use_area"]);


if($_POST["chkAdmin"]){
	$uAdmin = 1;
}else{
	$uAdmin = 0;
}

if($_POST["chkNyukin"]){
	$uNyukin = 1;
}else{
	$uNyukin = 0;
}

if($_POST["chkShikin"]){
	$uShikin = 1;
}else{
	$uShikin = 0;
}

if($_POST["chkRcv"]){
	$chkRcv = 1;
}else{
	$chkRcv = 0;
}

if($_POST["chkBrr"]){
	$chkBrr = 1;
}else{
	$chkBrr = 0;
}

if($_POST["chkZis"]){
	$chkZis = 1;
}else{
	$chkZis = 0;
}
//デバッグ
//echo("mode:".$mode." seq:".$seq." uName:".$uName." uAdmin:".$uAdmin ." uNyukin:".$uNyukin." uShikin:".$uShikin."<br>");

if($mode == "add"){
	//新規
	//seq設定
	$strSQL = "SELECT * FROM user_inf ORDER BY user_seq DESC";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRec) > 0){
		$objData = pg_fetch_object($objRec, 0);
		$newSeq = $objData->user_seq + 1;

		//disp_rank
		$strSQL2 = "SELECT * FROM user_inf ORDER BY disp_rank DESC";
		$objRec2 = pg_exec($strSQL2);
		if($objRec2==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		if(pg_numrows($objRec2) > 0){
			$objData2 = pg_fetch_object($objRec2, 0);
			$newRank = $objData2->disp_rank + 1;
		}

	}else{
		$newSeq = 1;
		$newRank = 1;
	}
	//INSERT
	$strSQL = "INSERT INTO user_inf (user_seq, user_id, user_pw, user_namekj, user_namekn, disp_rank, admin_flg, nyukin_flg, shikin_flg, bumon_seq ) ";
	$strSQL .= "VALUES (".$newSeq.", '', '".$uPw."', '".$uName."', '', ".$newRank.", ".$uAdmin.", ".$uNyukin.", ".$uShikin.", ".$bSeq." )";

//デバグ
//echo($strSQL."<br>");
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}

		//*** 入力資格 ***//
		//データ削除
		$strSQL = "DELETE FROM user_sikaku WHERE user_seq = ".$newSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

		//*** 請求･入金管理 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $newSeq.",";
		$strSQL .= "'20',";
		$strSQL .= intval($chkRcv);
		$strSQL .= ")";
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

		//*** 借入金管理 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $newSeq.",";
		$strSQL .= "'30',";
		$strSQL .= intval($chkBrr);
		$strSQL .= ")";
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

		//*** 資金実績 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $newSeq.",";
		$strSQL .= "'40',";
		$strSQL .= intval($chkZis);
		$strSQL .= ")";
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

		//*** 閲覧可能エリア登録 ***//
		//データ削除
		$strSQL = "DELETE FROM user_area WHERE user_seq = ".$newSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

		$Ary_Data=split("#",$area_inp);
		for ($intI=0; $intI < count($Ary_Data)-1; $intI++){ 
				$strSQL = "INSERT INTO user_area (user_seq, area_id) VALUES (".$newSeq.", '".$Ary_Data[$intI]."')";
				$objRec = pg_exec($strSQL);
				if($objRec==false){
						echo("SQL実行に失敗しました(INSERT)");
						exit;
				}
		}

}else if($mode == "edt"){

	//修正
	$strSQL = "UPDATE user_inf SET user_pw = '".$uPw."', user_namekj = '".$uName."', admin_flg = ".$uAdmin ;
	$strSQL .= " , nyukin_flg = ".$uNyukin.", shikin_flg = ".$uShikin.", bumon_seq = ".$bSeq ;
	$strSQL .= " WHERE user_seq = ".$uSeq ;
//デバグ
//echo($strSQL."<br>");
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(UPDATE)");
		exit;
	}

	//管理者がいなくなる場合、管理権限を戻す
	$strSQL ="SELECT * FROM user_inf WHERE admin_flg = 1";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRec) < 1){
			$msg = "管理者設定を変更できませんでした。管理権限を持つ人が最低一人は必要です。";
			$strSQL = "UPDATE user_inf SET admin_flg = 1 ";
			$strSQL .= " WHERE user_seq = ".$uSeq ;
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(UPDATE)");
				exit;
			}
	}

		//*** 入力資格 ***//
		//データ削除
		$strSQL = "DELETE FROM user_sikaku WHERE user_seq = ".$uSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

		//*** 請求･入金管理 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $uSeq.",";
		$strSQL .= "'20',";
		$strSQL .= intval($chkRcv);
		$strSQL .= ")";
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

		//*** 借入金管理 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $uSeq.",";
		$strSQL .= "'30',";
		$strSQL .= intval($chkBrr);
		$strSQL .= ")";
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}

		//*** 資金実績 ***//
		$strSQL  = "INSERT INTO user_sikaku (";
		$strSQL .= " user_seq   , ";
		$strSQL .= " sikaku_kbn , ";
		$strSQL .= " sikaku_mode ";
		$strSQL .= " )values(";
		$strSQL .= $uSeq.",";
		$strSQL .= "'40',";
		$strSQL .= intval($chkZis);
		$strSQL .= ")";

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

		//*** 閲覧可能エリア登録 ***//
		//データ削除
		$strSQL = "DELETE FROM user_area WHERE user_seq = ".$uSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

		$Ary_Data=split("#",$area_inp);
		for ($intI=0; $intI < count($Ary_Data)-1; $intI++){ 
				$strSQL = "INSERT INTO user_area (user_seq, area_id) VALUES (".$uSeq.", '".$Ary_Data[$intI]."')";
				$objRec = pg_exec($strSQL);
				if($objRec==false){
						echo("SQL実行に失敗しました(INSERT)");
						exit;
				}
		}

}else if($mode == "del"){
		//ユーザ削除
		$strSQL = "DELETE FROM user_inf WHERE user_seq = ".$uSeq;
		//デバグ
		//echo($strSQL."<br>");
		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
		}

		//*** 入力資格 ***//
		//データ削除
		$strSQL = "DELETE FROM user_sikaku WHERE user_seq = ".$uSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

		//*** 閲覧可能エリア ***//
		$strSQL = "DELETE FROM user_area WHERE user_seq = ".$uSeq;
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(DELETE)");
				exit;
		}

}else if($mode == "up" || $mode == "down"){
	if($mode == "up"){				//上へ
		$addNum = -1;
	}else if($mode == "down"){		//下へ
		$addNum = 1;
	}
	//変更対象の表示順取得
	$strSQL = "SELECT * FROM user_inf ORDER BY disp_rank" ;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRec) > 0){
		for ($i = 0; $i < pg_numrows($objRec); $i++) {
			//親Seqが同じレコードを配列に格納
			$objDspRec[$i] = pg_fetch_object($objRec, $i);
			$dspSeq[$i] = $objDspRec[$i]->user_seq ;
			$dspRnk[$i] = $objDspRec[$i]->disp_rank ;
//デバッグ
//echo($i." : ".$dspRnk[$i]." : ".$dspSeq[$i]." : ".$$uSeq."<br>");
			if ($dspSeq[$i] == $uSeq) {
				//自分が何番目かを取得
				$ownCnt = $i ;
			}
		}
	}

	//変更対象の前or後のデータ更新
	$strSQL = "UPDATE user_inf SET disp_rank = ".$dspRnk[$ownCnt]." WHERE user_seq = ".$dspSeq[$ownCnt+$addNum];
//echo($strSQL);
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(UPDATE)");
		exit;
	}
	//変更対象のデータ更新
	$strSQL = "UPDATE user_inf SET disp_rank = ".$dspRnk[$ownCnt+$addNum]." WHERE user_seq = ".$dspSeq[$ownCnt];
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(UPDATE)");
		exit;
	}
}

?>

<html>
<head>
<meta http-equiv="content-type" content="text/html; cahrset=euc-jp">
<meta http-equiv="content-style-type" content="text/css">
<meta name="robots" content="noindex, nofollow">
<title></title>
<script language="javascript">
function trans(){
	document.frm.action = "ZIS9800.php";
	document.frm.method="POST";
	document.frm.submit();
}
</script>
</head>
<body onload="trans();">
<form name="frm">
<input type="hidden" name="idx" value="<?PHP  echo $_POST["idx"]?>">
<input type="hidden" name="msg" value="<?PHP  echo $msg ?>">
</form>
</body>
</html>