<?
	// 인클루드
	require_once( "../inc/session.php" );
	require_once( "../inc/common.inc" );      // 공통 함수 모음
	require_once( "../inc/db_pgsql.inc" ); // 데이터베이스 인터페이스

	$admin_seq = $_COOKIE["cookie_admin_seq"];
	$suid = $HTTP_COOKIE_VARS[SUID];

	if ($suid != "guru222")
	{
	    AlertBack("전체관리자만 접근할 수 있습니다.");
	    exit;
	}

	$mode = isset($_POST['mode']) 	 		? $_POST['mode'] 	: NULL;
	$parrange = isset($_POST['parrange'])   ? $_POST['parrange']   : NULL;
	$prcid = isset($_POST['prcid']) 		? $_POST['prcid'] 	: NULL;
	$prcseq = isset($_POST['prcseq']) 		? $_POST['prcseq'] 	: NULL;
	$pname  = isset($_POST['pname']) 		? $_POST['pname'] 	: NULL;
	$old_pname  = isset($_POST['old_pname'])? $_POST['old_pname'] 	: NULL;
	$pip  = isset($_POST['pip']) 			? $_POST['pip'] 	: NULL;
	$pport  = isset($_POST['pport']) 		? $_POST['pport'] 	: NULL;
	$ptype  = isset($_POST['ptype']) 		? $_POST['ptype'] 	: NULL;
	$pmonitor  = isset($_POST['pmonitor']) 	? $_POST['pmonitor'] 	: NULL;

	$old_pname = $prcid."_".$old_pname;
	$pname = $prcid."_".$pname;
	
	// 성공 플래그
	$success_flag = 0;

	// 모니터링 변수 설정
	if ($pmonitor == "1")
		$pmonitor = "Y";
	else
		$pmonitor = "N";

	$objConn = new DB_Sql;

	// 기존에 동일한 server명이 존재하면, 추가 금지 조치.
	if ($mode == "add")
	{
		$strSQL  = " SELECT COUNT(name) FROM t_rms_rc_server_index ";
		$strSQL .= " WHERE rcid = '$prcid' AND name = '$pname' AND deleted_yn = 'N'";
		
		$objConn->query( $strSQL );
		if( $objConn->nf() != 0 )
		{
		    $objConn->next_record();
		    $cnt = $objConn->f(0);
		}
		if( $cnt > 0 )
		{
		    $objConn->close();
		    AlertBack( "동일한 서버이름이 존재합니다.\n\n다른 서버이름을 입력하세요." );
		    exit;
		}
	}
	if ($mode == "mod" && $pname != $old_pname)
	{
		$strSQL  = " SELECT COUNT(name) FROM t_rms_rc_server_index ";
		$strSQL .= " WHERE rcid = '$prcid' AND name = '$pname' AND deleted_yn = 'N'";

		$objConn->query( $strSQL );
		if( $objConn->nf() != 0 ) 
		{
		    $objConn->next_record();
		    $cnt = $objConn->f(0);
		}
		if( $cnt > 0 )
		{
		    $objConn->close();
		    AlertBack( "동일한 서버이름이 존재합니다.\n\n다른 서버이름을 입력하세요." );
		    exit;
		}
	}

	/* decision server type */
	switch($ptype)
	{
		case "RC" :
				$servType = "0";
				$to_align = "A";
				break;
		case "STAT" :
				$servType = "1";
				$to_align = "B";
				break;
		case "RTS" : 
				$servType = "2";
				$to_align = "C";
				break;
		case "RCTS" :
				$servType = "3";
				$to_align = "D";
				break;
		case "RCDB" :
				$servType = "4";
				$to_align = "E";
				break;
		case "CACHE" :
				$servType = "5";
				$to_align = "AB";
				break;
		case "TIMED" :
				$servType = "9";
				$to_aign = "K";
		default :
				break;
	}

	/* for sending server information string */
	$info_string = "'".$pname."|".$pip."|".$pport."|".$servType."|".$pmonitor."'";
	$res_func = 0;
	
	if ($mode == "add")
	{
		$title = "등록";
		$loginid = $_COOKIE["cookie_admin_id"] ;
		$reg_date    = date( "Y-m-d H:i:s", time() );
		$update_date = date( "Y-m-d H:i:s", time() );
		$remoteaddr  = getenv('REMOTE_ADDR');
		$alert_msg   = "[서버등록] POP ID:" . $prcid ." 서버 이름:" . $pname;
		
		/* popen rcmng_client */
		$servicetype = "INSERT";
		/* $res_func = exec_update_server_list($prcid, $pname, $servicetype, $info_string); */
			
		$sql = " START TRANSACTION ";
		$objConn->query( $sql );
		
		$sql  = " INSERT INTO t_rms_rc_server_index ";
		$sql .= " (rc_server_seq, rcid, name, ip, port, type, reg_datetime, update_datetime, monitor_yn, etc1, etc2, deleted_yn) ";
		$sql .= " VALUES ('', '$prcid', '$pname', '$pip', '$pport', '$ptype', now(), now(), '$pmonitor', '$to_align', '$parrange', 'N') ";		
		
		if ($objConn->query( $sql ))
		{
			$sql = " COMMIT ";
			$objConn->query( $sql );
			$success_flag = 1;
		}
		else
		{
			$sql = " ROLLBACK ";
			$objConn->query( $sql );
		}
	}
	else if ($mode == "mod")
	{
		$title = "수정";
		$loginid = $_COOKIE["cookie_admin_id"] ;
		$reg_date    = date( "Y-m-d H:i:s", time() );
		$update_date = date( "Y-m-d H:i:s", time() );
		$remoteaddr  = getenv('REMOTE_ADDR');
		$alert_msg   = "[서버수정] POP ID:" . $prcid ." 서버 이름:" . $pname;
		
		/* popen rcmng_client */
		$servicetype = "UPDATE";
		/* $res_func = exec_update_server_list($prcid, $old_pname, $servicetype, $info_string); */
		
		$sql = " START TRANSACTION ";
		$objConn->query( $sql );
		
		$sql  = " UPDATE t_rms_rc_server_index SET ";
		$sql .= " name='$pname', ip='$pip', port='$pport', type='$ptype', etc1='$to_align', update_datetime=now() ";
		$sql .= " , monitor_yn='$pmonitor' ";
		$sql .= " WHERE rcid = '$prcid' AND rc_server_seq = '$prcseq' AND deleted_yn = 'N' ";

		if ($objConn->query( $sql ))
		{
			$sql = " COMMIT ";
			$objConn->query( $sql );
			$success_flag = 1;
		}
		else
		{
			$sql = " ROLLBACK ";
			$objConn->query( $sql );
		}
	}
	else if ($mode == "del")
	{
		$loginid = $_COOKIE["cookie_admin_id"] ;
		$reg_date    = date( "Y-m-d H:i:s", time() );
		$update_date = date( "Y-m-d H:i:s", time() );
		$remoteaddr  = getenv('REMOTE_ADDR');
		$alert_msg   = "[서버삭제] POP ID:" . $prcid ." 서버 이름:" . $pname;

		/* popen rcmng_client */
		$servicetype = "DELETE";
		/* $res_func = exec_update_server_list($prcid, $pname, $servicetype, $info_string); */
		
		$sql = " START TRANSACTION ";
		$objConn->query( $sql );
		
		$sql  = " UPDATE t_rms_rc_server_index SET ";
		$sql .= " deleted_yn='Y', update_datetime=now() ";
		$sql .= " WHERE rcid = '$prcid' AND rc_server_seq = '$prcseq' AND deleted_yn = 'N' ";

		if ($objConn->query( $sql ))
		{
			$sql = " COMMIT ";
			$objConn->query( $sql );
			$success_flag = 1;
		}
		else
		{
			$sql = " ROLLBACK ";
			$objConn->query( $sql );
		}

		$objConn->close();
		echo "<script>location.href='./rc_server_pop.html?rc_id=".$prcid."';</script>";
	}
	$objConn->close();
	// mod 가 실패할 경우..
	if ($success_flag == 0)
	{
		echo " <script>alert('Error');";
		echo " history.go(-1);";
		echo " </script>";
	}

	switch($ptype)
    {
	    case "RTS" :
		$ptype = "RTS";
		break;
		case "RCDB" :
		$ptype = "RCDB";
		break;
		case "RCTS" :
		$ptype = "RCTS";
		break;
	}
	
?>

<html>
<head>
<title>POP 서버 관리</title>
<style type="text/css">
<style>
A:link {text-decoration:none}
A:visited {text-decoration:none}
A:hover {text-decoration:none}
body {
  margin:0;
  background-color:#FFFFFF;
}
td {
font-family:dotum,arial;
font-size:12px;
color:#5E5E5E;
line-height:20px;
}
.txt_t {font-size:14px; color:#000000; font-weight:bold;}
.txt_b {color:#238CDC; font-weight:bold;}
</style>
<script language="JavaScript" src="../js/checkform.js"></script>
<SCRIPT LANGUAGE="JavaScript">
//$%^&350,220$%^&
window.focus();
window.resizeTo(500, 250);
</SCRIPT>
</head>
<form name="rc_mod" method="post">
<table width="100%" bordercolor="#e7e7e7" bgcolor="#e7e7e7">
  <tr bordercolor="#e7e7e7">
	<td width="100%" height="24" bgcolor="#e7e7e7" class="style2" scope="col" align="center">
	<b><?=$rc_id?> 서버 <?=$title?> 완료</b>
	</td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height='0'>&nbsp;</td>
</tr>
<tr>
  <!-- CONTENT TABLE START -->
                  <table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <!-- LEFT CELL START -->
                      <td valign="top">
                        <!-- content subtitle -->

                        <!-- POP 서버 테이블 START -->
                        <table width="100%" border="0" cellpadding="0" cellspacing="0">
                          <tr>
                            <td width="100%">
                              <!-- POP 정보 TABLE START -->
                              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="ContentTable">
                                <tr>
                                  <td colspan="5" height="2" bgcolor="#B9B9B9"></td>
                                </tr>

                                <tr align="center">
                                  <td bgcolor="#F6F5F2">서버명</td>
                                  <td bgcolor="#F6F5F2">IP</td>
                                  <td bgcolor="#F6F5F2">port</td>
                                  <td bgcolor="#F6F5F2">서버타입</td>
                                  <td bgcolor="#F6F5F2">서버감시</td>
                                </tr>
                                <tr>
                                  <td colspan="5" height="1" bgcolor="E1E1E1"></td>
                                </tr>
                                <tr align="center" bgcolor="#FFFFFF">
                                  <td><?=$pname?></td>
                                  <td><?=$pip?></td>
                                  <td><?=$pport?></td>
                                  <td><?=$ptype?></td>
                                  <td><?if($pmonitor=='Y')echo "on";else echo "off";?></td>
                                </tr>
                                <tr>
                                  <td colspan="5" height="1" bgcolor="E1E1E1"></td>
                                </tr>
                                <tr>
                                  <td colspan="5" height="5"></td>
                                </tr>
                              </table>
                              <!-- POP 서버 TABLE END -->
</tr>
<tr>
  <td height="20"></td>
</tr>
</table>

<table width="100%" bordercolor="#e7e7e7" bgcolor="#e7e7e7">
  <tr bordercolor="#e7e7e7">
	<td width="100%" height="24" bgcolor="#e7e7e7" class="style2" scope="col" align="center">
	<a href="./rc_server_pop.html?rc_id=<?=$prcid?>&arrange=<?=$parrange?>"><img src="../image/icon_confirm.gif" border="0"></a>
	</td>
  </tr>
</table>
</form>
</body>
</html>

<?php

function exec_update_server_list($rcid, $svrname, $servtype, $info_string)
{	
	$path = "/user/ics10/gms/new_sh_statusd/src/";

	/* servtype : INSERT=1, UPDATE=2, DELETE=3 */
	$command = $path . "rcmng_client";

	if ($servtype == "DELETE")
		$command .= " " .  $rcid . " " . $svrname . " " . $servtype;
	else
		$command .= " " .  $rcid . " " . $svrname . " " . $servtype . " " . $info_string;

	$fp = popen($command , "r");

	$context = "";
	while(!feof($fp))
	{
		$context .= fgets($fp, 1024);
	}
	pclose($fp);
	
	if ( !strcmp($context, "SUCCESS") )
		$res = 1;
	else
		$res = 0;
	return $res;
}
?>