__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"] ; $src_ip = $_POST["src_ip"] ; $src_mask = $_POST["src_mask"] ; $src_port = $_POST["src_port"] ; if ($src_port == null) $src_port = "0"; $dst_ip = $_POST["dst_ip"] ; $dst_mask = $_POST["dst_mask"] ; $dst_port = $_POST["dst_port"] ; $to_port = $_POST["to_port"] ; $use_yn = $_POST["useData"] ; if (strstr($use_yn, 'on')) $use_yn = 'Y'; else $use_yn = 'N'; /* if (isset($_FILES['xls_file']) && !$_FILES['xls_file']['error']) { // file name $filename = $_FILES['xls_file']['name']; // Location $location = 'upload/'.$filename; // file extension $file_extension = pathinfo($location, PATHINFO_EXTENSION); $file_extension = strtolower($file_extension); // Valid image extensions $image_ext = array("jpg","png","jpeg","gif","xls"); if(in_array($file_extension,$image_ext)){ // Upload file if(move_uploaded_file($_FILES['xls_file']['tmp_name'],$location)){ if (!file_exists($location)) { echo ""; exit; } error_log ("############_filename=" . $location . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); } } } */ function moveOneUp($current_policy_order, $id, $connect) { // 0. 최상위 레벨 return if ($current_policy_order == 1) return; // 1. 바꿀 order 를 구한다. $changed_order = $current_policy_order - 1; // 2. 이전 id 를 구한다. $before_id_sql = " select id from FIREWALL_POLICY where policy_order = '$changed_order' " ; $id_result = mysql_query($before_id_sql, $connect) or die (mysql_error()); if ($data = mysql_fetch_array($id_result)) { $before_id = $data[0]; //total_count } // 3. 한단계 내린다. $sql = " update FIREWALL_POLICY set policy_order = '$current_policy_order' where id = '$before_id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); // 4. 현재를 한단계 올린다. $sql = " update FIREWALL_POLICY set policy_order = '$changed_order' where id = '$id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); } function moveOneDown($current_policy_order, $id, $connect) { $last_order_sql = " select policy_order from FIREWALL_POLICY order by policy_order desc limit 1 " ; $order_result = mysql_query($last_order_sql, $connect) or die (mysql_error()); if ($data=mysql_fetch_array($order_result)) { $last_order = $data[0]; //total_count } // 0. 현재가 마지막 레벨 이면 return if ($current_policy_order == $last_order) return; // 1. 바꿀 order 를 구한다. $changed_order = $current_policy_order + 1; // 2. 이전 id 를 구한다. $after_id_sql = " select id from FIREWALL_POLICY where policy_order = '$changed_order' " ; $id_result = mysql_query($after_id_sql, $connect) or die (mysql_error()); if ($data = mysql_fetch_array($id_result)) { $after_id = $data[0]; //total_count } // 3. 한단계 올린다. $sql = " update FIREWALL_POLICY set policy_order = '$current_policy_order' where id = '$after_id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); // 4. 현재를 한단계 내린다. $sql = " update FIREWALL_POLICY set policy_order = '$changed_order' where id = '$id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); } function moveLastDown($current_policy_order, $id, $connect) { $last_order_sql = " select policy_order from FIREWALL_POLICY order by policy_order desc limit 1 " ; $order_result = mysql_query($last_order_sql, $connect) or die (mysql_error()); if ($data=mysql_fetch_array($order_result)) { $last_order = $data[0]; //total_count } // 0. 현재가 마지막 레벨 이면 return if ($current_policy_order == $last_order) return; // 1. 현재 이후 order 를 하나씩 줄인다. $sql = " update FIREWALL_POLICY set policy_order = policy_order - 1 where policy_order > '$current_policy_order' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); // 2. 현재를 마지막으로 내린다. $sql = " update FIREWALL_POLICY set policy_order = '$last_order' where id = '$id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); } function moveTopUp($current_policy_order, $id, $connect) { $last_order_sql = " select policy_order from FIREWALL_POLICY order by policy_order desc limit 1 " ; $order_result = mysql_query($last_order_sql, $connect) or die (mysql_error()); if ($data=mysql_fetch_array($order_result)) { $last_order = $data[0]; //total_count } // 0. 현재가 최상 레벨 이면 return if ($current_policy_order == "1") return; // 1. 현재 이전 order 를 하나씩 올린다. $sql = " update FIREWALL_POLICY set policy_order = policy_order + 1 where policy_order < '$current_policy_order' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); // 2. 현재를 최상으로 올린다. $sql = " update FIREWALL_POLICY set policy_order = '1' where id = '$id' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); } 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 FIREWALL_POLICY"; $count_sql = " select count(*) as cnt $from_sql " ; $sql = " select * $from_sql order by policy_order 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":[ {"dno":"","useData":,"filterStr":"","policy_type":"","src_ip":"","src_mask":"","src_port":"","dst_ip":"","dst_mask":"","dst_port":"","to_port":"","regdate":""} ]} {"dno":"","useData":,"filterStr":"","policy_type":"","src_ip":"","src_mask":"","src_port":"","dst_ip":"","dst_mask":"","dst_port":"","to_port":"","regdate":""} '$current_policy_order' " ; $result = @mysql_query($sql, $connect) or die(mysql_error()); if($connect) mysql_close($connect); exit; } if ($flag == "move" ) { $method = $_GET["method"] ; error_log ("move_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"); error_log ("method=", 3, "/usr/local/imagefilter30/var/logs/php.log"); error_log ($method, 3, "/usr/local/imagefilter30/var/logs/php.log"); error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); $current_order_sql = " select policy_order from FIREWALL_POLICY where id = '$dno' " ; $order_result=mysql_query($current_order_sql, $connect) or die (mysql_error()); if ($data=mysql_fetch_array($order_result)) { $current_order = $data[0]; //total_count } if ($method == "oneUp") { moveOneUp($current_order, $dno, $connect); } else if ($method == "oneDown") { moveOneDown($current_order, $dno, $connect); } else if ($method == "lastDown") { moveLastDown($current_order, $dno, $connect); } else if ($method == "topUp") { moveTopUp($current_order, $dno, $connect); } 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 FIREWALL_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; } if ($total_count == 0) { $policy_order = 1; } else { $last_order_sql = " select policy_order from FIREWALL_POLICY order by policy_order desc limit 1 " ; $order_result=mysql_query($last_order_sql, $connect) or die (mysql_error()); if ($data=mysql_fetch_array($order_result)) { $order_count = $data[0]; //total_count } $policy_order = $order_count + 1; } error_log ("policy_order=" . $policy_order. "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); error_log ("use_yn=" . $use_yn. "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); $sql = " insert into FIREWALL_POLICY ( policy_order ,policy_type ,name ,src_ip ,src_mask ,src_port ,dst_ip ,dst_mask ,dst_port ,to_port ,use_yn ,regdate ) value ( '$policy_order' , '$policy_type' , '$policy_name' , '$src_ip' , '$src_mask' , '$src_port' , '$dst_ip' , '$dst_mask' , '$dst_port' , '$to_port' ,'$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 FIREWALL_POLICY set name = '$policy_name' , policy_type = '$policy_type' , src_ip = '$src_ip' , src_mask = '$src_mask' , src_port = '$src_port' , dst_ip = '$dst_ip' , dst_mask = '$dst_mask' , dst_port = '$dst_port' , to_port = '$to_port' , 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); ?>