<?
	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"] ;
	
	$user_id = $_POST["user_id"] ;
	$user_name = $_POST["user_name"] ;
	$user_position = $_POST["user_position"] ;
	$dept_code = $_POST["dept_code"] ;
	$dept_name = $_POST["dept_name"] ;
	$doccontents_inc = $_POST["doccontents_inc"] ;
	$use_yn = $_POST["use_yn"] ;
/*
	error_log ("##_flag=" . $flag, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("##_dno=" . $dno, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("user_id=" . $user_id, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("user_name=" . $user_name, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("user_position=" . $user_position, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("dept_code=" . $dept_code, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("dept_name=" . $dept_name, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("doccontents_inc=" . $doccontents_inc, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\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 COM_USER cu ";	
		
		$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.DEPTNM as user_deptnm, c.SPSIGNPATH as sign , d.CODENM as pos FROM (
				(SELECT * FROM COM_USER) a
 				LEFT join COM_DEPT b ON a.deptno = b.DEPTNO
				 LEFT join SGN_PATH c ON a.USERID = c.USERID 
				 LEFT join COM_CODE d ON a.USERPOS = d.CODECD) 
				 order by USERNO desc ";		
		
        error_log ("SQL@@@@@@@@@", 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("쿼리오류 발생: " . $sql, 3, "/usr/local/imagefilter30/var/logs/php.log");

?>
{"list":[
<?
		$count = 0;
		
		while ($data = mysql_fetch_array($result)) {
			if ( $count != 0 ) { echo(","); }
			$dno = $data['USERNO'];
			$use_yn = $data['DELETEFLAG'];
			$id = $data['USERID'];
			$name = $data['USERNM'];
			$position = $data['pos'];
			$sign = $data['sign'];
			$dept_name = $data['user_deptnm'];
			$reg_date = $data['sign'];

?>
{"dno":"","useData":"","filterStr":"","siteAlarm":"","pushEmail":"","pushSms":"","notiMsg":"","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 COM_USER mp where USERNO = " . $dno . " ";	

		$sql = "SELECT a.*, b.DEPTNM as user_deptnm, c.SPSIGNPATH as sign , d.CODENM as pos FROM (
				(SELECT * FROM COM_USER) a
 				LEFT join COM_DEPT b ON a.deptno = b.DEPTNO
				 LEFT join SGN_PATH c ON a.USERID = c.USERID 
				 LEFT join COM_CODE d ON a.USERPOS = d.CODECD) 
				 WHERE USERNO = " . $dno . " ";		
		
//		$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['USERNO'];
			$use_yn = $data['DELETEFLAG'];
			$id = $data['USERID'];
			$name = $data['USERNM'];
			$position = $data['pos'];
			$sign = $data['sign'];
			$dept_name = $data['user_deptnm'];
			$dept_code = $data['DEPTNO'];
			$reg_date = $data['sign'];
?>
{"dno":"","useData":"","filterStr":"","siteAlarm":"","pushEmail":"","pushSms":"","notiMsg":"","regdate":""}
<?
			$count++;
		}

?>
]}

<?    
		if($connect) mysql_close($connect);
    	exit;
	}

	if ($flag == "delete" ) { 	
	 	$delete_sql = "DELETE COM_USER, SGN_PATH FROM  COM_USER LEFT JOIN SGN_PATH ON COM_USER.USERID = SGN_PATH.USERID WHERE USERNO = '$dno'" ;
	  	error_log ($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 COM_USER (
	  			   USERID
			       ,USERNM   
			       ,DEPTNO
			       ,USERPOS
			       ,DELETEFLAG              
	  	         ) value (
	  	            '$user_id'
	  	          , '$user_name'
	  	          ,'$dept_code'
	  	          ,'$user_position'
	  	          ,'$use_yn'
	  	        ) " ;
	    
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	

	  	$sql = " insert into SGN_PATH (
	  			   USERID
			       ,SPSIGNPATH   
	  	         ) value (
	  	            '$user_id'
	  	          , '$doccontents_inc'
	  	        ) " ;
	    
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	}  else if ($flag == "update") { 	
	  	$sql = " update  COM_USER set 
	  			   USERNM = '$user_name'  ,
	  			   DEPTNO = '$dept_code'  ,
	  			   USERPOS = '$user_position'   ,  
	  	           DELETEFLAG = '$use_yn'
	  			   where USERNO = '$dno'
	  			    " ;
	  	error_log ($sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	    
	  	$sql = " update  SGN_PATH set 
	  			   SPSIGNPATH = '$doccontents_inc'  
	  			   where USERID = '$user_id'
	  			    " ;
	  	error_log ($sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	    $result = @mysql_query($sql, $connect) or die(mysql_error());	
	
	}	
		
/*	
	error_log ("policy_title=" . $policy_title, 3, "/usr/local/imagefilter30/var/logs/php.log");
	error_log ("\n", 3, "/usr/local/imagefilter30/var/logs/php.log");
	

    echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8">';    
	echo '<script type="text/javascript">';
	echo " alert('Success'); " ;
	echo ' window.opener.getList(); ';
	echo ' window.close(); ';
	echo '</script>';
*/
    if($connect) mysql_close($connect);

?>