<?
	include "./db_conn.php";

	//$viewtable_db_host="10.77.77.77";
	//$viewtable_db_host="localhost";
	//$viewtable_db_id="root";
	//$viewtable_db_passwd="admin01";
	//$viewtable_db_name="proshield";  
        $viewtable_db_host="10.251.2.21";
        $viewtable_db_id="imagocr";
        $viewtable_db_passwd="thsrudgh";
        $viewtable_db_name="ALDER";

	$viewtable_connect = mysql_connect($viewtable_db_host, $viewtable_db_id, $viewtable_db_passwd) or die (mysql_error());
	mysql_select_db($viewtable_db_name, $viewtable_connect) or die (mysql_error());

	error_log ("DB start:" . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 

	$viewtable_sql = "select USER_ID, USER_EMAIL, USER_NAME, POSITIONNAME, USER_CUSTOM03, USER_CUSTOM04 from vwIMAGOCR";
	$viewtable_result=mysql_query($viewtable_sql, $viewtable_connect) or die (mysql_error());

	$ok_cnt = 0;
	$tot_cnt = 0;

  	// 기존 직위를 지우고 새로 생성한다.
  	$sql = "delete from COM_CODE where CLASSNO = 5";
	error_log ("userExcel @@@_1:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
    $result = @mysql_query($sql, $connect);	

  	$sql = "delete from COM_CODE where CLASSNO = 3";
	error_log ("userExcel @@@_1:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
    $result = @mysql_query($sql, $connect);	

	$count = 0;
	
	while  ($viewtable_data=mysql_fetch_array($viewtable_result)) 
	{
		
		$viewtable_user_id = $viewtable_data[0];	
		$viewtable_user_email = $viewtable_data[1];	
		$viewtable_user_name = $viewtable_data[2];	
		$viewtable_positionname = $viewtable_data[3];	
		$viewtable_user_custom03 = $viewtable_data[4];	
		$viewtable_user_custom04 = $viewtable_data[5];	
		//error_log ("## viewtable_user_id -->" . $viewtable_user_id . ", viewtable_user_name=" . $viewtable_user_name . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log");	

		$pos_sql = "select CODECD from COM_CODE where CODENM = '" . $viewtable_positionname . "'";
		//error_log ("userExcel ##_직위 처리: pos_sql:" . $pos_sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
		$pos_result=mysql_query($pos_sql, $connect) or die (mysql_error());
		
		if ($data=mysql_fetch_array($pos_result)) {
			//error_log ("userExcel userpos:" . $userpos . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
		} else {
			$count++;

			// *** 직위 처리			
		  	$sql = " insert into COM_CODE (CLASSNO, CODECD, CODENM) values (3, '$count', '$viewtable_positionname')";
			error_log ("userExcel @@_11:" . $sql . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
		    $result = @mysql_query($sql, $connect);	
			error_log ("userExcel @@_empty_userpos:" . "[" . $count . "]" . $userpos . "\n", 3, "/usr/local/imagefilter30/var/logs/php.log"); 
		}	

	}
	
	if($viewtable_connect) mysql_close($viewtable_connect);
	if($connect) mysql_close($connect);
		
	exit;

?>