<?
	include "./db_conn.php";
	include "./include/jsonRPCClient.php";
	
	/*
	$rpcService = new jsonRPCClient("$PACKETMON_HTTP_URL/JSON-RPC");
	$param = array();
	$arr = $rpcService->__call("shield.server.view",$param);
	
	$resultArr = $arr['list'];
	*/  
	$flag = $_GET["flag"] ;
	$dno = $_GET["dno"] ;
	
	if ($flag == "update" ) { 
		$dno =  $_POST["update_dno"] ;
	}

	$policy_type =  $_POST["policy_type"] ;;
	$policy_name = $_POST["filterStr"] ;
	$service_port = $_POST["service_port"] ;
	$use_yn = $_POST["useData"] ;
	if (strstr($use_yn, 'on'))	$use_yn = 'Y';
	else $use_yn = 'N';


    $count = 0;
	foreach ($_FILES as $file) {   
	
	    $filename = $file['name'];
	    $count++;

		// Upload file
		if ($count == '1')
		{
		    $cert_filename = $filename;
		    $cert_location = 'upload/'.$filename;
			if(move_uploaded_file($file['tmp_name'],$cert_location)){
				error_log ("@@_cert_filename=" . $cert_location . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
			}
		} else if ($count == '2')
		{
		    $key_filename = $filename;
		    $key_location = 'upload/'.$filename;
			if(move_uploaded_file($file['tmp_name'],$key_location)){
				error_log ("@@_key_filename=" . $key_location . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
			}
		}
	}  

	if ($flag == "list" ) { 	
	 	
		$startDate = $_GET["startDate"] ;
		$endDate = $_GET["endDate"] ;
		
		
		error_log ($startDate, 3, "/usr/local/imagefilter30/var/logs/php.log");
		error_log ($endDate, 3, "/usr/local/imagefilter30/var/logs/php.log");
	
		$from_sql = 		
				" from SSL_POLICY";	
		
		$count_sql = " select count(*) as cnt 
		                  $from_sql  " ;
		
		$sql = 	" select * 
				  $from_sql 
				 order by id asc  " ;	
		
		error_log ("firewall_policy_view:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
		$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
		
		if ($data=mysql_fetch_array($count_result)) {
		    $total_count = $data[0];  //total_count
		} else {
		    $total_count=0;
		}	

//		$result=mysql_query($sql, $connect) or die (mysql_error());
		$result=mysql_query($sql, $connect);
		//error_log("쿼리오류 발생: " . mysqli_error(), 3, "/usr/local/imagefilter30/var/logs/php.log");

?>
{"list":[
<?
		$count = 0;
		
		while ($data = mysql_fetch_array($result)) {
			if ( $count != 0 ) { echo(","); }
			$id = $data['id'];
			$use_yn = $data['use_yn'];
			$name = $data['name'];
			$reg_date = $data['regdate'];
			if (strstr($data[use_yn], 'Y'))
			{
				$use_yn_str = "true";
			} else
			{
				$use_yn_str = "false";
			}
?>
{"dno":"","useData":,"filterStr":"","policy_type":"","service_port":"","cert_path":"","key_path":"","regdate":""}
<?
			$count++;
		}

?>
]}

<?
		if($connect) mysql_close($connect);
	    exit;
	}

	if ($flag == "update_list" ) { 	
	 	
		error_log ("dno=", 3, "/usr/local/imagefilter30/var/logs/php.log");
		error_log ($dno, 3, "/usr/local/imagefilter30/var/logs/php.log");
		error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
		if ($dno == 0)	exit;

		$from_sql = 		
				" from SSL_POLICY where id = " . $dno . " ";	
		
		$sql = 	" select * 
				  $from_sql 
				 order by id asc  " ;	
		
//		$result=mysql_query($sql, $connect) or die (mysql_error());
		$result=mysql_query($sql, $connect);

		$count = 0;
		
		while ($data = mysql_fetch_array($result)) {
			if (strstr($data[use_yn], 'Y'))
			{
				$use_yn_str = "true";
			} else
			{
				$use_yn_str = "false";
			}
?>
{"dno":"","useData":,"filterStr":"","policy_type":"","service_port":"","cert_path":"","key_path":"","regdate":""}
<?
			$count++;
		}

		if($connect) mysql_close($connect);
    	exit;
	}

	if ($flag == "delete" ) { 	

	 	$delete_sql = "DELETE SSL_POLICY FROM  SSL_POLICY WHERE SSL_POLICY.id = '$dno'" ;
	  	error_log ($delete_sql, 3, "/usr/local/imagefilter30/var/logs/php.log");
		error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    @mysql_query($delete_sql, $connect) or die(mysql_error());  	    
	        
	    if($connect) mysql_close($connect);
	    exit;
	    
	}
	
	if ($flag == "insert") { 	

		$date = date('Y-m-d h:i:s', time());
		$count_sql = " select count(*) as cnt from SSL_POLICY " ;
		
		$count_result=mysql_query($count_sql, $connect) or die (mysql_error());
		
		if ($data=mysql_fetch_array($count_result)) {
		    $total_count = $data[0];  //total_count
		} else {
		    $total_count=0;
		}	

		error_log ("use_yn=" . $use_yn. "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");

	  	$sql = " insert into SSL_POLICY (
	  			   policy_type
			       ,name   
			       ,service_port   
			       ,cert_path   
			       ,key_path  
			       ,use_yn
			       ,regdate              
	  	         ) value (
	  	          '$policy_type'
	  	          , '$policy_name'
	  	          , '$service_port'
	  	          , '$cert_location'
	  	          , '$key_location'
	  	          ,'$use_yn'
	  	          ,'$date'
	  	        ) " ;
	    
		error_log ("policy_insert_sql=" . $sql. "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	}  else if ($flag == "update") { 	
	  	$sql = " update  SSL_POLICY set 
	  			   name = '$policy_name'  ,
	  			   policy_type = '$policy_type'  ,
				   service_port = '$service_port'  ,
				   cert_path = '$cert_filename'  ,
				   key_path = '$key_filename'  ,
	  			   use_yn = '$use_yn'  
	  			   where id = $dno
	  			    " ;
		error_log ("##_policy_update_sql=" . $sql. "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	
	}	
		
	if ( $result ) {
		
		if ($flag == "insert") { 	    	
			$policy_id = mysql_insert_id();	
		} else if ($flag == "update") { 	
			$policy_id = $dno ;	
		}	
	    	
	}   	

    if($connect) mysql_close($connect);

?>