<?
	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"] ;
	$strTok =explode(':' , $_POST["codeDno"]);
	
	$code_dno = $strTok[1] ;
	$depart = $_POST["doccontents_inc"] ;
	
	error_log ("dno:" . $dno . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("code_dno:" . $code_dno . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("depart:" . $depart . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");

	if ($flag == "list" ) { 	
	 	
		$from_sql = 		
				" from code_info ci ";	
		
		$count_sql = " select count(*) as cnt 
		                  $from_sql  " ;

		// INNER JOIN 은 교집합을 a 를 기준으로 다 있는 경우만 출력
		/*
		$sql = "SELECT a.*, b.DEPTNM as user_deptnm, c.SPSIGNPATH as sign, d.CODENM as pos FROM (
				(SELECT * FROM COM_USER) a
 				INNER join COM_DEPT b ON a.deptno = b.DEPTNO
				 INNER join SGN_PATH c ON a.USERID = c.USERID 
				 INNER join COM_CODE d ON a.USERPOS = d.CODECD) 
				 order by USERNO desc ";		
		*/

		// LEFT JOIN 은 a 를 기준으로 모두 출력하는데 b,c 가 조건 안맞으면 NULL 출력 대입
		$sql = "SELECT a.*, b.depart as depart FROM (
				(SELECT * FROM code_info) a
 				INNER join check_depart b ON a.dno = b.code_dno)
 				 where a.code = 'US' 
				 order by a.dno asc ";		
		
		
		$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("쿼리오류 발생: " . $sql, 3, "/usr/local/imagefilter30/var/logs/php.log");

?>
{"list":[
<?
		$count = 0;
		
		while ($data = mysql_fetch_array($result)) {
			if ( $count != 0 ) { echo(","); }
			$dno = $data['dno'];
			$name = $data['title'];
			$sign = $data['depart'];

?>
{"dno":"","filterStr":"","notiMsg":""}
<?
			$count++;
		}

?>
]}

<?
		if($connect) mysql_close($connect);
	    exit;
	}

	if ($flag == "update_list" ) { 	
	 	
		if ($dno == 0)	exit;

		$sql = "SELECT a.*, b.depart as depart FROM (
				(SELECT * FROM code_info) a
 				LEFT join check_depart b ON a.dno = b.code_dno)
				 WHERE a.dno = " . $dno . " ";		
	  	error_log ("update_list_sql:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
		
//		$result=mysql_query($sql, $connect) or die (mysql_error());
		$result=mysql_query($sql, $connect);

?>
{"list":[
<?
		$count = 0;
		
		while ($data = mysql_fetch_array($result)) {
			$dno = $data['dno'];
			$name = $data['title'];
			$sign = $data['depart'];
	  		error_log ("update_list_data:" . $sign . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
?>
{"dno":"","filterStr":"","notiMsg":""}
<?
			$count++;
		}

?>
]}

<?    
		if($connect) mysql_close($connect);
    	exit;
	}

	if ($flag == "delete" ) { 	
	 	$delete_sql = "DELETE FROM  check_depart WHERE code_dno = '$dno'" ;
	  	error_log ("delete_sql:" . $delete_sql . "\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());
	  	$sql = " insert into check_depart (
	  			   depart
			       ,code_dno
			       ,regdate   
	  	         ) value (
	  	            '$depart'
	  	          , '$code_dno'
	  	          , '$date'
	  	        ) " ;
	    
	  	error_log ("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  check_depart set 
	  			   depart = '$depart' 
	  			   where code_dno = $dno
	  			    " ;
	  	error_log ("update_sql:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	    
	}	
		
    if($connect) mysql_close($connect);

?>