<?
Class SBLib {
	
	############## SQL Injection 대응 함수 ####################
	public function SQL_Injection($get_Str) {
		return eregi_replace("( select| union| insert| update| delete| drop|\"|\'|#|\/\*|\*\/|\\\|\;)", "", $get_Str);
	}
	
	##############################################################################################################
	#
	# Oracle Select Row Conut GET SQL문과 DB Connection을 넘겨받음
	#
	##############################################################################################################
	public function RowCNT($sql, $conn) {
		
		$sql_query = 'SELECT COUNT(*) AS NUMBER_OF_ROWS FROM (' . $sql . ')';
		$stmt= oci_parse($conn, $sql_query);
		oci_define_by_name($stmt, 'NUMBER_OF_ROWS', $number_of_rows);
		oci_execute($stmt);
		oci_fetch($stmt);

		oci_free_statement($stmt);
		return $number_of_rows;
	}

	##############################################################################################################
	#
	# 시작 날자와 끝 날자의 GAP 계산 날자형식 (yyyy-mm-dd)
	#
	##############################################################################################################	
	public function DayGap($sday, $eday) {
		$stdt = explode("-", $sday);
		$eddt = explode("-", $eday);
			
		$stime = mktime(0, 0, 0, $stdt[1], $stdt[2], $stdt[0]);
		$etime = mktime(0, 0, 0, $eddt[1], $eddt[2], $eddt[0]);
			
		$daygap = number_format(intval($etime-$stime)/86400);
		
		return $daygap;
	}
	
	##############################################################################################################
	#
	# 시작 날자와 끝 날자의 GAP 계산 날자형식 (yyyymmdd)
	#
	##############################################################################################################
	public function DayGap2($sday, $eday) {
		$stdt[0] = substr($sday, 0, 4);
		$stdt[1] = substr($sday, 4, 2);
		$stdt[2] = substr($sday, 6, 2);
		
		$eddt[0] = substr($eday, 0, 4);
		$eddt[1] = substr($eday, 4, 2);
		$eddt[2] = substr($eday, 6, 2);
		//$eddt = explode("-", $eday);
			
		$stime = mktime(0, 0, 0, $stdt[1], $stdt[2], $stdt[0]);
		$etime = mktime(0, 0, 0, $eddt[1], $eddt[2], $eddt[0]);
			
		$daygap = number_format(intval($etime-$stime)/86400);
	
		return $daygap;
	}
	
	#################################################################################
	#
	# 두날자 사이의 개월수와 남은 날자 구하기
	#
	#################################################################################
	function GapSdtEdt($startdt, $enddt){
	
		$diff = array();
		$s_date = explode('-', $startdt);
		$e_date = explode('-', $enddt);
	
		$diff_month = ($e_date[0] - $s_date[0])*12 + $e_date[1] - $s_date[1];
	
		$diff_day = $e_date[2] - $s_date[2];
		if($diff_day < 0) {
			$diff_month--;
			$diff_day = $e_date[2] + (int)date('t',strtotime('-1 month',strtotime($e_date[0].$e_date[1].'01'))) - $s_date[2];
		}
		$diff[0] = $diff_day;
		$diff[1] = $diff_month;
	
		return $diff;
	
	}
	
	#################################################################################
	#
	# 금주의 일요일 구하기
	#
	#################################################################################
	function StartSunday(){
		$Time=explode(" ",microtime());
	
		$StartWeek=mktime(0,0,0,date("m",$Time[1]),date("d",$Time[1])-date("w",$Time[1]),date("Y",$Time[1]));
	
		return date("Ymd",$StartWeek);
	}
	
	##############################################################################################################
	#
	# 접속 에이전트 브라우저 확인하기
	#
	##############################################################################################################
	public function getBrowser()
	{
		$u_agent = $_SERVER['HTTP_USER_AGENT'];
		$bname = 'Unknown';
		$platform = 'Unknown';
		$version= "";
	
		//First get the platform?
		if (preg_match('/linux/i', $u_agent)) { $platform = 'linux'; }
		elseif (preg_match('/macintosh|mac os x/i', $u_agent)) { $platform = 'mac'; }
		elseif (preg_match('/windows|win32/i', $u_agent)) { $platform = 'windows'; }
	
		// Next get the name of the useragent yes seperately and for good reason
		if(preg_match('/MSIE/i',$u_agent) && !preg_match('/Opera/i',$u_agent)) { $bname = 'Explorer'; $ub = "MSIE"; }
		elseif(preg_match('/Firefox/i',$u_agent)) { $bname = 'Firefox'; $ub = "Firefox"; }
		elseif(preg_match('/Chrome/i',$u_agent)) { $bname = 'Chrome'; $ub = "Chrome"; }
		elseif(preg_match('/Safari/i',$u_agent)) { $bname = 'Safari'; $ub = "Safari"; }
		elseif(preg_match('/Opera/i',$u_agent)) { $bname = 'Opera'; $ub = "Opera"; }
		elseif(preg_match('/Netscape/i',$u_agent)) { $bname = 'Netscape'; $ub = "Netscape"; }
	
		// finally get the correct version number
		$known = array('Version', $ub, 'other');
		$pattern = '#(?<browser>' . join('|', $known) .
		')[/ ]+(?<version>[0-9.|a-zA-Z.]*)#';
		if (!preg_match_all($pattern, $u_agent, $matches)) {
			// we have no matching number just continue
		}
	
		// see how many we have
		$i = count($matches['browser']);
		if ($i != 1) {
			//we will have two since we are not using 'other' argument yet
			//see if version is before or after the name
			if (strripos($u_agent,"Version") < strripos($u_agent,$ub)){ $version= $matches['version'][0]; }
			else { $version= $matches['version'][1]; }
		}
		else { $version= $matches['version'][0]; }
	
		// check if we have a number
		if ($version==null || $version=="") {$version="?";}
		return array('userAgent'=>$u_agent, 'name'=>$bname, 'version'=>$version, 'platform'=>$platform, 'pattern'=>$pattern);
	}
	
	
	##############################################################################################################
	#
	# Mycrypt 라이브러리를 이용한 암호화, 암호화 대상 str과 key를 넘겨받아 사용 -- 비권장사항
	#
	##############################################################################################################	
	public function Gob_Encrypt($plain_data, $key){
		$encrypted_data_on_binary = mcrypt_ecb (MCRYPT_SERPENT, $key, $plain_data, MCRYPT_ENCRYPT);
		$encrypted_data = base64_encode($encrypted_data_on_binary);
		return $encrypted_data;
	}

	
	##############################################################################################################
	#
	# Mycrypt 라이브러리를 이용한 복호화, 복호화 대상 str과 key를 넘겨받아 사용 -- 비권장사항
	#
	##############################################################################################################
	public function Gob_Decrypt($encrypted_data, $key){
		$decrypted_data_on_binary = base64_decode($encrypted_data);
		$plain_data = mcrypt_ecb (MCRYPT_SERPENT, $key, $decrypted_data_on_binary, MCRYPT_DECRYPT);
		return $plain_data;
	}
}

?><?
Class BizCK extends SBLib {
	
	###################################################################################
	#
	# Login History 등록
	#
	###################################################################################
	public function LoginHistory($cd, $con){
		$ip = $_SERVER['REMOTE_ADDR'];
	
		$sql = "INSERT INTO LOGIN_HISTORY (M_ID, InIP) VALUES('$cd','$ip')";
		$res = @mysql_query($sql, $con);
	}
	
	
	###################################################################################
	#
	# 업무에 사용할 T-Key 유무체크
	#
	###################################################################################
	function T_KeyExist($comm_info, $v_kid, $con){
		$etkey = "";
		//$HDR  = $comm_info[0];
	
		//$v_txgcode = "210";
		//$v_txcode  = $comm_info[2];
		//$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4];
	
		//$m = substr(microtime(), 2,3);
		//$tkey = $HDR.date('Ymd').time().$m;
	
		//$cdate = date('Ymd');
	
		$sql = "SELECT T_Key FROM Tok_Key WHERE MBizNo = '$v_mbizno' AND KID = '$v_kid' ";
		$res = mysql_query($sql, $con);
		
		$num_rows = mysql_num_rows($res);
		$row=mysql_fetch_array($res);
		$row = mysql_fetch_array($res);
		if($num_rows > 0){
			$etkey = (isset($row["T_Key"]) ? $row["T_Key"] : null);
		}else{
			$etkey = "N";
		}
	
		return $etkey;
	}
	
	
	###################################################################################
	#
	# 업무에 사용할 T-Key 생성
	#
	###################################################################################
	function T_KeyCreate($comm_info, $v_kid, $con){
		$tkey  = "";
		$etkey = "";
		$HDR  = $comm_info[0];
		
		//$v_txgcode = "210";
		//$v_txcode  = $comm_info[2];
		//$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4]; 
		
		$m = substr(microtime(), 2,3);
		$tkey = $HDR.date('Ymd').time().$m;
		
		$cdate = date('Ymd');
		$etkey = $this -> T_KeyExist($comm_info, $v_kid, $con);
		if($etkey == "N") {
			$sql = "INSERT INTO Tok_Key (MBizNo, KID, T_Key, Cdate) VALUES('$v_mbizno', '$v_kid', '$tkey', '$cdate')";
		}else{
			$sql = "UPDATE Tok_Key SET T_Key = '$tkey', Cdate = '$cdate' WHERE MBizNo = '$v_mbizno' AND KID = '$v_kid' ";
		}
		$res = mysql_query($sql, $con);
		
		$this -> T_KeyCHistory($v_mbizno, $v_kid, $tkey, $cdate, $con);
		
		return $tkey;
	}
	
	###################################################################################
	#
	# 신규 사업자번호의 경우 저장
	#
	###################################################################################
	public function T_KeyCHistory($v_mbizno, $v_kid, $tkey, $cdate, $con){
		
		$sql = "INSERT INTO Tok_Key_History (MBizNo, KID, T_Key, Cdate) VALUES('$v_mbizno', '$v_kid', '$tkey', '$cdate')";
		$res = mysql_query($sql, $con);
		
	}
	
	
	
	###################################################################################
	#
	# SQNO 추출 - Next Sqno를 생성 후 Idx_Sqno의 Sqno를 +1해준다.
	#
	###################################################################################
	public function GetTxno($con) {

		$sql_s = "select max(Sqno)+1 as nextval from Idx_Sqno ";
		$res_s = mysql_query($sql_s, $con);
		$row_s = mysql_fetch_array($res_s);
		$nextval = $row_s['nextval'];
		
		$sql_u = "update Idx_Sqno set Sqno = '$nextval' ";
		$res_u = mysql_query($sql_u, $con);
		
		return $nextval;
	}
	
	###################################################################################
	#
	# TX_INFO의 정보를 v_txcode에 따라 데이터 처리함.
	#
	###################################################################################
	public function TxDataProc($txcd) {
		
		$res = array();
		
		switch ($txcd) {
			case "1001":
				$res[0] = $this -> SQL_Injection(isset($_POST["v_kid"]) ? $_POST["v_kid"] : null);
				$res[1] = $this -> SQL_Injection(isset($_POST["v_kpw"]) ? $_POST["v_kpw"] : null);
				break;
			
			case "2001":
				$res[0] = $this -> SQL_Injection(isset($_POST["v_tkey"  ]) ? $_POST["v_tkey"  ] : null);
				$res[1] = $this -> SQL_Injection(isset($_POST["v_rbizno"]) ? $_POST["v_rbizno"] : null);
				break;

			case "9001":
				$res[0] = $this -> SQL_Injection(isset($_POST["v_tkey"  ]) ? $_POST["v_tkey"  ] : null);
				$res[1] = $this -> SQL_Injection(isset($_POST["v_rbizno"]) ? $_POST["v_rbizno"] : null);
				break;
				
			default:
				return $res;
		}
		return $res;		
	}
	
	###################################################################################
	#
	# 1001업무 처리
	#
	###################################################################################
	public function TxRes1001($comm_info, $rescode, $v_kid, $con) {
		$resdata = "";
		
		$v_work    = $comm_info[0];
		$v_txgcode = "210";
		$v_txcode  = $comm_info[2];
		$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4];
		
		$v_tkey = $this -> T_KeyCreate($comm_info, $v_kid, $con);
		
		$resdata = "v_work=".$v_work."\n";
		$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
		$resdata = $resdata."v_txcode=".$v_txcode."\n";
		$resdata = $resdata."v_rescode=".$v_rescode."\n";
		$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		$resdata = $resdata."v_tkey=".$v_tkey."\n";
		
		return $resdata;
	}

	###################################################################################
	#
	# 2001업무 처리
	#
	###################################################################################
	public function TxRes2001($comm_info, $rescode, $v_rbizno, $bizst, $stdt, $updt) {
		$resdata = "";
	
		$v_work    = $comm_info[0];
		$v_txgcode = "210";
		$v_txcode  = $comm_info[2];
		$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4];
	
		$resdata = "v_work=".$v_work."\n";
		$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
		$resdata = $resdata."v_txcode=".$v_txcode."\n";
		$resdata = $resdata."v_rescode=".$v_rescode."\n";
		$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		$resdata = $resdata."v_rbizno=".$v_rbizno."\n";
		$resdata = $resdata."v_status=".$bizst."\n";
		$resdata = $resdata."v_update=".$stdt."\n";
		$resdata = $resdata."v_cdate=".$updt."\n";
	
		return $resdata;
	}
	
	
	###################################################################################
	#
	# 신규 사업자번호의 경우 저장 
	#
	###################################################################################
	public function NewBizInstert($comm_info, $v_rbizno, $con){
		$resdata = "";
		$sqlst   = "";
		
		$v_work 	= $comm_info[0];
		$v_txgcode  = "210";
		$v_txcode   = $comm_info[2];
		$v_rescode  = "D001";
		$v_mbizno   = $comm_info[4];
		
		$sql = "INSERT INTO BizNo_Info (BizNo, BizST) VALUES('$v_rbizno', 'NB')";
		$res = mysql_query($sql, $con);
		if($res) {
			$resdata = "";
			
			$resdata = "v_work=".$v_work."\n";
			$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
			$resdata = $resdata."v_txcode=".$v_txcode."\n";
			$resdata = $resdata."v_rescode=".$v_rescode."\n";
			$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		}else{
			$v_rescode = "T01";
			
			$resdata = "v_work=".$v_work."\n";
			$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
			$resdata = $resdata."v_txcode=".$v_txcode."\n";
			$resdata = $resdata."v_rescode=".$v_rescode."\n";
			$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		}
		
		
		
		return $resdata;
	}
	
	###################################################################################
	#
	# 보나뱅크 DB에 없는 경우 또는 업데이트 기간이 1주일 이상 지난 경우 신규로 검색해옴
	#
	###################################################################################
	public function RealCheck($comm_info, $v_rbizno, $con) {
		$result = $this->CallCkeck($v_rbizno);
		$resdata = array();
		$resdata = explode("§", $result);
		
		$start = $resdata[0]; // 결과의 처음시작
		$suces = $resdata[1]; // 성공여부 S:성공, F:실패
		$rescode = ($suces == "S") ? "000" : "S01"; 
		$bizno = $resdata[2]; // 조회대상 사업자번호

		/**
		 * 01 -> VG : 부가가치세 일반과세자 
		 * 02 -> VS : 부가가치세 간이과세자
		 * 03 -> VF : 부가가치세 면세과세자
		 * 04 -> SD : 폐업자
		 * 05 -> CB : 휴업자
		 * 06 -> VN : 비영리법인
		 * 90 -> ET : 기타유형
		 * 91 -> NN : 미등록사업자(해외건수)
		 * 99 -> EE : 오류
		 */
		$bizst = $resdata[3]; // 과세유형
		if($bizst == "01"){
			$bizst = "VG";
		}elseif($bizst == "02"){
			$bizst = "VS";
		}elseif($bizst == "03"){
			$bizst = "VF";
		}elseif($bizst == "04"){
			$bizst = "SD";
		}elseif($bizst == "05"){
			$bizst = "CB";
		}elseif($bizst == "06"){
			$bizst = "";
		}elseif($bizst == "VN"){
			$bizst = "";
		}elseif($bizst == "90"){
			$bizst = "ET";
		}elseif($bizst == "91"){
			$bizst = "NN";
		}else{
			$bizst = "EE";
		}
		$ntsdt = $resdata[4]; // 국세청 적용일 
		$schdt = $resdata[5]; // 국세청 조회일
		$ssddt = $resdata[6]; // 폐업일
		$chgdt = $resdata[7]; // 과셍유형 전환일
		$errmg = $resdata[8]; // 오류메시지
		$enddt = $resdata[9]; // 결과 끝
		
		$this->UdateST($v_rbizno, $bizst, $ssddt, $schdt, $con); // 결과값 업데이트
		
		$resdata = "";
		
		$v_work    = $comm_info[0];
		$v_txgcode = "210";
		$v_txcode  = $comm_info[2];
		$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4];
		
		$resdata = "v_work=".$v_work."\n";
		$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
		$resdata = $resdata."v_txcode=".$v_txcode."\n";
		$resdata = $resdata."v_rescode=".$v_rescode."\n";
		$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		$resdata = $resdata."v_rbizno=".$v_rbizno."\n";
		$resdata = $resdata."v_status=".$bizst."\n";
		$resdata = $resdata."v_update=".$schdt."\n";
		$resdata = $resdata."v_cdate=".$ssddt."\n";
		
		return $resdata;
		
		
	}
	
	###################################################################################
	#
	# 보나뱅크 DB에 없는 경우 또는 업데이트 기간이 1주일 이상 지난 경우 신규로 검색해옴
	#
	###################################################################################
	public function RealNTSCheck($comm_info, $v_rbizno, $con) {
		$result = $this->NTSCK($v_rbizno);
		$ssddt = "";
		//echo $result;
		$resdata = array();
		$resdata = explode(" ", $result);
	
		$ResDat01 = str_replace("<trtCntn>","",$resdata[0]); // 결과의 처음시작
		$ResDat02 = $resdata[1]; // 성공여부 S:성공, F:실패
	
		//$b = "VG";
		//echo $ResDat01."/";
		//$a = str_replace("부가가치세","VG", trim($ResDat01));
		//$a = "VG";
		//echo trim($a);
		//echo strcmp($a, $b);
		//echo $this->asc_hex($ResDat01)."/";
		//echo $this->asc_hex("부가가치세");
	
		//$enc = mb_detect_encoding($ResDat01, array("utf-8", "euc-kr"));
		//echo $enc;
		
		/**
		if($ResDat01 == "부가가치세") {
			if($ResDat02 == "일반과세자") {
				$bizst = "VG";
			}elseif ($ResDat02 == "간이과세자") {
				$bizst = "VS";
			}elseif ($ResDat02 == "면세사업자"){
				$bizst = "VS";
			}else{
				$bizst = "ET";
			}
				
		}elseif ($ResDat01 == "폐업자") {
			$bizst = "SD";
			//$tmpdt = substr($resdata[4], 9, 10);
			$tmpdt = substr($resdata[3], 9, 10);
			
			$ssddt = str_replace("-","", $tmpdt);
			//echo $tmpdt;
		}elseif ($ResDat01 == "휴업자") {
			$bizst = "CB";
		}elseif ($ResDat01 == "수익사업을") {
			$bizst = "VN";
		}elseif ($ResDat01 == "사업을") {
			$bizst = "NN";
		}else{
			$bizst = "ET";
		}
		*/
		
		if($ResDat01 == "부가가치세") {
			if($ResDat02 == "일반과세자") {
				$bizst = "VG";
			}elseif ($ResDat02 == "간이과세자") {
				$bizst = "VS";
			}elseif ($ResDat02 == "면세사업자"){
				$bizst = "VF";
			}else{
				$bizst = "ET";
			}
				
		}elseif ($ResDat01 == "폐업자") {
			$bizst = "SD";
			$tmpdt = substr($resdata[3], 9, 10);
			$ssddt = str_replace("-","", $tmpdt);
			//echo $tmpdt;
		}elseif ($ResDat01 == "휴업자") {
			$bizst = "CB";
		}elseif ($ResDat01 == "수익사업을") {
			$bizst = "VN";
		}elseif ($ResDat01 == "사업을") {
			$bizst = "NN";
		}elseif ($ResDat01 == "사업자단위과세(종사업장)로") {
			if($ResDat02 == "전환폐업자") {
				$bizst = "SD";
				$tmpdt = substr($resdata[5], 9, 10);
				$ssddt = str_replace("-","", $tmpdt);
			}
		}else{
			$bizst = "ET";
		}
		$rescode = "000";
		$bizno = $v_rbizno; // 조회대상 사업자번호
	
		/**
		 * 01 -> VG : 부가가치세 일반과세자
		 * 02 -> VS : 부가가치세 간이과세자
		 * 03 -> VF : 부가가치세 면세과세자
		 * 04 -> SD : 폐업자
		 * 05 -> CB : 휴업자
		 * 06 -> VN : 비영리법인
		 * 90 -> ET : 기타유형
		 * 91 -> NN : 미등록사업자(해외건수)
		 * 99 -> EE : 오류
	
			$bizst = $resdata[3]; // 과세유형
			if($bizst == "01"){
			$bizst = "VG";
			}elseif($bizst == "02"){
			$bizst = "VS";
			}elseif($bizst == "03"){
			$bizst = "VF";
			}elseif($bizst == "04"){
			$bizst = "SD";
			}elseif($bizst == "05"){
			$bizst = "CB";
			}elseif($bizst == "06"){
			$bizst = "VN";
			}elseif($bizst == "90"){
			$bizst = "ET";
			}elseif($bizst == "91"){
			$bizst = "NN";
			}else{
			$bizst = "EE";
			}
			*/
		//$ntsdt = $resdata[4]; // 국세청 적용일
		$schdt = date("Ymd"); // 국세청 조회일
		//$ssddt = $resdata[6]; // 폐업일
		//$chgdt = $resdata[7]; // 과셍유형 전환일
		//$errmg = $resdata[8]; // 오류메시지
		//$enddt = $resdata[9]; // 결과 끝
	
		$this->UdateST($v_rbizno, $bizst, $ssddt, $schdt, $con); // 결과값 업데이트
	
		$resdata = "";
	
		$v_work    = $comm_info[0];
		$v_txgcode = "210";
		$v_txcode  = $comm_info[2];
		$v_rescode = $rescode;
		$v_mbizno  = $comm_info[4];
	
		$resdata = "v_work=".$v_work."\n";
		$resdata = $resdata."v_txgcode=".$v_txgcode."\n";
		$resdata = $resdata."v_txcode=".$v_txcode."\n";
		$resdata = $resdata."v_rescode=".$v_rescode."\n";
		$resdata = $resdata."v_mbizno=".$v_mbizno."\n";
		$resdata = $resdata."v_rbizno=".$v_rbizno."\n";
		$resdata = $resdata."v_status=".$bizst."\n";
		$resdata = $resdata."v_update=".$schdt."\n";
		$resdata = $resdata."v_cdate=".$ssddt."\n";
		//echo $resdata;
		return $resdata;
	
	
	}
	
	###################################################################################
	#
	# 보나뱅크 DB에 없는 경우 또는 업데이트 기간이 1주일 이상 지난 경우 신규로 검색해옴
	#
	###################################################################################
	public function UdateST($v_rbizno, $bizst, $ssddt, $schdt, $con) {
		//$updt = date('Ymd');
		$sql = "UPDATE BizNo_Info SET BizST = '$bizst', STDT = '$ssddt', UpDT = '$schdt' WHERE BizNo = '$v_rbizno' ";
		//echo $sql;
		$res = mysql_query($sql, $con);
	}
	
	###################################################################################
	#
	# 기웅정보통신 ASP를 통해 결과값 가져오기
	#
	###################################################################################
	public function CallCkeck($v_rbizno) {
		$url = "http://121.189.16.114/EcctService";
		$var = "BIZ_NO=".$v_rbizno."&ORG_CD=bonabank&LIC_CD=bonabank";
		$buffer = "";
		$cinfo  = "";
		
		$curl = curl_init();
		curl_setopt($curl, CURLOPT_URL, $url);
		curl_setopt($curl, CURLOPT_POST, 1);
		curl_setopt($curl, CURLOPT_POSTFIELDS, $var);
		curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
		//curl_setopt($curl, CURLOPT_POST, 0);
		//curl_setopt($curl, CURLOPT_USERAGENT, $agent);
		curl_setopt($curl, CURLOPT_REFERER, "");
		curl_setopt($curl, CURLOPT_TIMEOUT, 15);
		
		$buffer = curl_exec($curl);
		$cinfo = curl_getinfo($curl);
		
		curl_close($curl);

		$buffer = ($cinfo['http_code'] != 200) ? "N" : $buffer;
		return $buffer;
		//echo $buffer;
	}
	
	###################################################################################
	#
	# 국세청가서 체크하기
	#
	###################################################################################
	public function NTSCK($v_rbizno) {
		//echo "NTS 01";
		$RtData = "";
		$mno = substr($v_rbizno, 3, 2);
		//echo $mno;
		$url = "https://teht.hometax.go.kr/wqAction.do?actionId=ATTABZAA001R08&screenId=UTEABAAA13&popupYn=false&realScreenId=";
		$var = "<map id='ATTABZAA001R08'><pubcUserNo/><mobYn>N</mobYn><inqrTrgtClCd>1</inqrTrgtClCd><txprDscmNo>".$v_rbizno."</txprDscmNo><dongCode>".$mno."</dongCode><psbSearch>Y</psbSearch><map id='userReqInfoVO'/></map>";
		$buffer = "";
		$cinfo  = "";
	
		$curl = curl_init();
		curl_setopt($curl, CURLOPT_URL, $url);
		curl_setopt($curl, CURLOPT_POST, 1);
		curl_setopt($curl, CURLOPT_POSTFIELDS, $var);
		curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
		//curl_setopt($curl, CURLOPT_POST, 0);
		//curl_setopt($curl, CURLOPT_USERAGENT, $agent);
		curl_setopt($curl, CURLOPT_REFERER, "");
		$headers = [
				'Origin: https://teht.hometax.go.kr',
				'Accept-Encoding: gzip, deflate, br',
				'Accept-Language: ko-KR,ko;q=0.8,en-US;q=0.6,en;q=0.4',
				'User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36',
				'Content-Type: application/xml; charset=UTF-8',
				'Accept: application/xml; charset=UTF-8',
				'Referer: https://teht.hometax.go.kr/websquare/websquare.html?w2xPath=/ui/ab/a/a/UTEABAAA13.xml',
				//'Cookie: WMONID=NWy195yFz59; TXPPsessionID=LJWCsyhIFB1154CT9OdkA3scNeCwtTI3xN66khDV9VUaThmcgyfaYdCuWNW1r3zQ.s_backup_servlet_TXPP01; TEHTsessionID=5IzzrM8rwSYk2jy2LET986rxv8woLmoyxaPq53yoVE2sodnYgPORlkryuypP8IaK.tupiwsp06_servlet_TEHT03; beforeSearchTime=1482993417383',
				//'Connection: keep-alive'
		];
		//echo "NTS 02";
		curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
	
		//curl_setopt($curl, CURLOPT_TIMEOUT, 15);
	
		$buffer = curl_exec($curl);
		$cinfo = curl_getinfo($curl);
		//echo "NTS 02";
		curl_close($curl);
		$buffer = iconv("utf-8","euc-kr", $buffer);
		//echo $buffer;
		//$buffer = ($cinfo['http_code'] != 200) ? "N" : $buffer;
		preg_match('/<trtCntn>(.*?)<\/trtCntn>/is', $buffer, $RtData);
	
	
		return $RtData[0];
		//echo $buffer;
	}
	
	
	###################################################################################
	#
	# 조회 사업자번호가 있는지 체크
	#
	###################################################################################
	public function ExistBizno($v_rbizno, $con){
		$resdata = array();
		
		$sql = "SELECT BizST, STDT, UpDT FROM BizNo_Info WHERE BizNo = '$v_rbizno' ";
		$res = mysql_query($sql, $con);
		
		$num_rows = mysql_num_rows($res);
		$row=mysql_fetch_array($res);
		
		if($num_rows == 0){
			$resdata[0] = "N";
			$resdata[1] = "N";
			$resdata[2] = "N";
			$resdata[3] = "N";
				
		}else{
			$resdata[0] = "E";
			$resdata[1] = (isset($row[0]) ? $row[0] : null);
			$resdata[2] = (isset($row[1]) ? $row[1] : date("Ymd", strtotime("-10 day")));
			$resdata[3] = (isset($row[2]) ? $row[2] : date("Ymd", strtotime("-10 day")));
		}
			return $resdata;
	}
	###################################################################################
	#
	# Koreaju ID/PW를 통해 Koreaju USER 유효성 검증
	#
	###################################################################################
	public function KoreaJUTH($v_kid, $v_kpw, $conn){
		
		$resdata = "";
		$kid = strtoupper($v_kid);
		$kpw = strtoupper($v_kpw);
		
		$query = "SELECT COMP_NAME,MEMB_IDID FROM MEMBERS_ WHERE MEMB_IDID ='$kid' AND PASS_WORD = crypto.encrypt('$kpw') AND MEMB_STAT ='2' ";
		//$query = "SELECT COMP_NAME,MEMB_IDID,PASS_WORD,CUST_CODE,IDEN_NUMB FROM MEMBERS_ WHERE MEMB_IDID ='$u_id' AND PASS_WORD ='$u_pw' AND MEMB_STAT ='2' ";
		$stmt = OCIParse($conn,$query);
		OCIExecute($stmt);
		
		//echo"$query";
		if(OCIFetchinto($stmt, $row)){
			$resdata = "E";
		}else{
			$resdata = "N";
		}
		return $resdata;
		
	}

	###################################################################################
	#
	# Koreaju ID/PW를 통해 Koreaju USER 유효성 검증
	#
	###################################################################################
	public function T_KeyTruth($schkey, $con) {
		
		$rt_data = "";
		$cdate   = "";
		$odate   = date('Ymd');
		
		$sql = "SELECT T_Key, Cdate FROM Tok_Key WHERE T_Key = '$schkey' ";
		$res = mysql_query($sql, $con);
		
		$num_rows = mysql_num_rows($res);
		
		$row=mysql_fetch_array($res);
		
		if($num_rows == 0){
			$rt_data = "F";
		}else{
			$cdate = (isset($row["Cdate"]) ? $row["Cdate"] : null);
			if($cdate == $odate){
				$rt_data = "S";
			}else{
				$rt_data = "F";
			}
		}
		
		return $rt_data;
		
	}
	
	###################################################################################
	#
	# 요청에 대한 비즈니스 로직 수행 실패 시 오류정보 리턴 
	#
	###################################################################################
	public function ErrorProc($comm_info, $rescd) {
		$v_work 	= $comm_info[0];
		$v_txgcode  = "210";
		$v_txcode   = $comm_info[2];
		$v_rescode  = $rescd;
		$v_mbizno   = $comm_info[4];
				
		$rt_data = "";
		$rt_data = "v_work=".$v_work."\n";
		$rt_data = $rt_data."v_txgcode=".$v_txgcode."\n";
		$rt_data = $rt_data."v_txcode=".$v_txcode."\n";
		$rt_data = $rt_data."v_rescode=".$v_rescode."\n";
		$rt_data = $rt_data."v_mbizno=".$v_mbizno."\n";
	
		return $rt_data;
	
	}
	
	
	###################################################################################
	#
	# 각 요청 업무에 대한 TX Data Save 
	#
	###################################################################################
	public function TxSave($comm_info, $txdata_info, $con) {
		$rt_data = "";
		$v_kid  = "";
		$v_tkey = "";
		
		$v_work		= $comm_info[0];
		$v_txgcode	= $comm_info[1];
		$v_txcode	= $comm_info[2];
		$v_rescode	= $comm_info[3];
		$v_mbizno	= $comm_info[4];
		$v_txno	    = $comm_info[5];
		
		if($v_txcode == "1001"){
			$v_kid  = $txdata_info[0];
		}else{
			$v_tkey = $txdata_info[0];
		}
		
		
		$sql = "INSERT INTO TrInfo(TxNo, WorkID, MBizNo, KID, T_Key, TxCode, TxResCD)
				VALUES('$v_txno','$v_work','$v_mbizno','$v_kid','$v_tkey','$v_txcode','$v_rescode')";
		//echo $sql;
		$res = mysql_query($sql, $con);
		$rt_data = ($res) ? "OK" : "NOT" ;
		return $rt_data;
		
	}
	
	###################################################################################
	#
	# 각 요청 업무에 대한 TX 결과 데이터 업데이트
	#
	###################################################################################
	public function TxUpdate($txno, $rescd, $con) {
		$txst = ($rescd == "000")? "S001" : "E001";
		$sql = "UPDATE TrInfo SET TxResCD = '$rescd', TxStatus = '$txst' WHERE TxNo = '$txno' ";
		//echo $sql;
		$res = mysql_query($sql, $con);
		$rt_data = ($res) ? "OK" : "NOT" ;
		return $rt_data;
	
	}
	
	
	###################################################################################
	#
	# 요청에 대한 비즈니스 로직 수행 전 요청 Data Save 실패 시 오류정보 리턴 
	#
	###################################################################################
	public function Err($comm_info, $txdata_info, $con) {
		$rt_data = "";
		$rt_data = "v_work=".$v_work."\n";
		$rt_data = $rt_data."v_txgcode=210"."\n";
		$rt_data = $rt_data."v_txcode=".$v_txcode."\n";
		$rt_data = $rt_data."v_rescode=TX0"."\n";
		$rt_data = $rt_data."v_resmsg=요청처리가 완료되지 않았습니다 재 요청 바랍니다"."\n";
		
		return $rt_data;
		
	}
	
	###################################################################################
	#
	# 요청에 대한 로그남기기 
	#
	###################################################################################
	public function LW_Req($comm_info, $tx_data) {
		$log_data = "";
		$com_info = "";
		$tx_info = "";
		
		$file_nm = $this -> FileExist();
		$v_work		= $comm_info[0];
		$v_txgcode	= $comm_info[1];
		$v_txcode	= $comm_info[2];
		$v_rescode	= $comm_info[3];
		$v_resmsg	= $comm_info[4];
		$v_txstamp	= $comm_info[5];
		$v_termno	= $comm_info[6];
		$v_gps_lat	= $comm_info[7];
		$v_gps_lng	= $comm_info[8];
		
		$com_info = $com_info."COMM_INFO ======================================="."\n";
		$com_info = $com_info."v_work=".$v_work."\n";
		$com_info = $com_info."v_txgcode=".$v_txgcode."\n";
		$com_info = $com_info."v_txcode=".$v_txcode."\n";
		$com_info = $com_info."v_rescode=".$v_rescode."\n";
		$com_info = $com_info."v_resmsg=".$v_resmsg."\n";
		$com_info = $com_info."v_txstamp=".$v_txstamp."\n";
		$com_info = $com_info."v_termno=".$v_termno."\n";
		$com_info = $com_info."v_gps_lat=".$v_gps_lat."\n";
		$com_info = $com_info."v_gps_lng=".$v_gps_lng."\n";
		$com_info = $com_info."================================================="."\n";
		
		switch ($v_txcode) {
			case "1001":
				$v_tagid = $tx_data[0];
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."v_tagid=".$v_tagid."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
					
			case "1002":
				$v_tagid = $tx_data[0];
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."v_tagid=".$v_tagid."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
					
			case "3001":
				$v_tagid	= $tx_data[0];
				$v_bcnt 	= $tx_data[1];
				$v_btagidgp	= $tx_data[2];
				
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."v_tagid=".$v_tagid."\n";
				$tx_info = $tx_info."v_bcnt=".$v_bcnt."\n";
				$tx_info = $tx_info."v_btagidgp=".$v_btagidgp."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
					
			case "5001":
				$v_dbizno	= $tx_data[0];
				$v_cnt		= $tx_data[1];
				$v_tagidgp	= $tx_data[2];
				
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."v_dbizno=".$v_dbizno."\n";
				$tx_info = $tx_info."v_cnt=".$v_cnt."\n";
				$tx_info = $tx_info."v_tagidgp=".$v_tagidgp."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
		
			case "5002":
				$v_dbizno	= $tx_data[0];
				$v_cnt		= $tx_data[1];
				$v_tagidgp	= $tx_data[2];
				
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."v_dbizno=".$v_dbizno."\n";
				$tx_info = $tx_info."v_cnt=".$v_cnt."\n";
				$tx_info = $tx_info."v_tagidgp=".$v_tagidgp."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
		
			case "7001":
				$u_mail		= $tx_data[0];
				$u_mw		= $tx_data[1];
				$u_byear	= $tx_data[2];
				
				$tx_info = $tx_info."TX_INFO ========================================="."\n";
				$tx_info = $tx_info."u_mail=".$u_mail."\n";
				$tx_info = $tx_info."u_mw=".$u_mw."\n";
				$tx_info = $tx_info."u_byear=".$u_byear."\n";
				$tx_info = $tx_info."================================================="."\n";
				break;
		
			default:
				return $tx_info;
		}
		$log_date = date('Y-m-d H:i:s');
		$log_data .= "I [".$log_date."] TXCODE[".$v_txcode."] ############"."\n";
		$log_data .= $com_info.$tx_info;
		$log_data .= "\n";
		
		$logfp = fopen($file_nm, 'a');
		fwrite($logfp, $log_data);
		fclose($logfp);
		
	}

	###################################################################################
	#
	# 응답에 대한 로그남기기
	#
	###################################################################################
	public function LW_Res($resdata, $txcd) {
		$log_data = "";
		$file_nm = $this -> FileExist();
		
		$log_date = date('Y-m-d H:i:s');
		$log_data .= "O [".$log_date."] TXCODE[".$txcd."] ############"."\n";
		$log_data .= $resdata;
		$log_data .= "================================================="."\n";
		$log_data .= "\n";
	
		$logfp = fopen($file_nm, 'a');
		fwrite($logfp, $log_data);
		fclose($logfp);
	
	}
	
	###################################################################################
	#
	# 요청에 대한 로그파일 확인
	#
	###################################################################################
	public function FileExist() {
		$tmp_fnm = date('Ymd');
		//$logfnm = "";
		$log_filenm = "./log/".$tmp_fnm.".log";
		if(is_file($log_filenm)) {
			$rt_data = "/home/rfid/dev/log/".$tmp_fnm.".log";
		}else{
			$write_data = "\n";
			$file = "/home/rfid/dev/log/".$tmp_fnm.".log";
			$sfp = fopen($file,'w');
			fwrite($sfp,$write_data);
			fclose($sfp);
			$rt_data = $file;
		}
		return $rt_data;
	}
	

}

?>