<?
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;
	}
}

?>