<?
require_once('nmrs.inc');

class PERFORMANCE{

function getNetTypeList() {
	global $db;

	$query = $db->query("
						select	distinct(SDH_TYPE) as SDH_TYPE
						from	SDH
						order by SDH_TYPE desc ");

	$network_type_list = array();
	while ($result = $db->fetchArray($query)) {
		$network_type_list[][SDH_TYPE] = $result[SDH_TYPE];
	}
	return $network_type_list;
}

function getNetCollectorSRCInfo($sdh_type = '') {
	if(!$sdh_type) return;
	global $db;

	$query = $db->query("
						select	distinct SDH_SRC,SDH_SRC_CNAME
						from	SDH
						where SDH_TYPE = '$sdh_type'
						order by SDH_SRC ");
	
	$net_collector_src_list = array();
	$record=0;
	while ($result = $db->fetchArray($query)) {
		$net_collector_src_list[$record][SRC] = $result[SDH_SRC];
		$net_collector_src_list[$record][SRC_CNAME] = $result[SDH_SRC_CNAME];
		$record=$record+1;
	}
	return $net_collector_src_list;
}

function getNetCollectorDSTInfo($sdh_type = '',$collector_src = '') {
	if(!$sdh_type && !$collector_src) return;
	global $db;

	$query = $db->query("
						select	distinct SDH_DST,SDH_DST_CNAME
						from	SDH
						where SDH_TYPE = '$sdh_type' and SDH_SRC = '$collector_src'
						order by SDH_DST ");
	
	$net_collector_dst_list = array();
	$record=0;
	while ($result = $db->fetchArray($query)) {
		$net_collector_dst_list[$record][DST] = $result[SDH_DST];
		$net_collector_dst_list[$record][DST_CNAME] = $result[SDH_DST_CNAME];
		$record=$record+1;
	}
	return $net_collector_dst_list;
}

function getSdhInfo($sdh_type = '',$collector_src = '',$collector_dst = '')
{
	if(!$sdh_type) return;
	global $db;
	$Sdh_info = array();
	if($collector_src) $and_string = " and  SDH_SRC = '$collector_src'";
	if($collector_dst) $and_string = $and_string . " and SDH_DST = '$collector_dst'";
	
	$query = $db->query("
		SELECT SDH_TYPE,SDH_SRC,SDH_SRC_CNAME,SDH_DST,SDH_DST_CNAME
		FROM SDH 
		WHERE SDH_TYPE = '$sdh_type' $and_string");

	$record=0;
	while($result = $db->fetchArray($query)){
		$Sdh_info[$record][SDH_TYPE] 		= $result[SDH_TYPE];
		$Sdh_info[$record][SDH_SRC] 			= $result[SDH_SRC];
		$Sdh_info[$record][SDH_SRC_CNAME]= $result[SDH_SRC_CNAME];
		$Sdh_info[$record][SDH_DST] 			= $result[SDH_DST];
		$Sdh_info[$record][SDH_DST_CNAME]= $result[SDH_DST_CNAME];
		$record=$record+1; 
	}	
	return $Sdh_info;
}

//function getSdhInfo($sdh_sla_type='')
//{
//	if(!$sdh_sla_type) return;
//	global $db;
//	$sdh_list = array();
//	
//	$query = $db->query("
//		select distinct SDH_SLA_SRC,SDH_SLA_DST
//		from SDH_SLA_LOG
//		where SDH_SLA_TYPE='$sdh_sla_type' ");
//		
//		$i = 1;				
//		while ($result = $db->fetchArray($query)) {
//			$sdh_list[$i][SRC] = $result[SDH_SLA_SRC];
//			$sdh_list[$i][DST] = $result[SDH_SLA_DST];
//			$i = $i + 1;
//		}
//		return $sdh_list;	
//}

function getSESPerformanceInfo($start_time='',$end_time='',$sdh_sla_type='',$src='',$dst='')
{
	if(!$start_time && !$end_time && !$sdh_sla_type && !$src && !$dst) return;
	global $db;
	$performance_list = array();
	
	$query = $db->query("
		select sum(SDH_SLA_SES) as SES
		from SDH_SLA_LOG
		where SDH_SLA_TYPE='$sdh_sla_type' and SDH_SLA_SRC='$src' and SDH_SLA_DST='$dst' and
      			SDH_SLA_DATETIME between to_date($start_time,'yyyymmdd') and to_date($end_time,'yyyymmdd') ");
		
		$result = $db->fetchArray($query);
		return $result;	
}

function getESPerformanceInfo($start_time='',$end_time='',$sdh_sla_type='',$src='',$dst='')
{
	if(!$start_time && !$end_time && !$sdh_sla_type && !$src && !$dst) return;
	global $db;
	$performance_list = array();
	
	$query = $db->query("
		select sum(SDH_SLA_ES) as ES
		from SDH_SLA_LOG
		where SDH_SLA_TYPE='$sdh_sla_type' and SDH_SLA_SRC='$src' and SDH_SLA_DST='$dst' and
      			SDH_SLA_DATETIME between to_date($start_time,'yyyymmdd') and to_date($end_time,'yyyymmdd') ");
		
		$result = $db->fetchArray($query);
		return $result;	
}

function getUASPerformanceInfo($start_time='',$end_time='',$sdh_sla_type='',$src='',$dst='')
{
	if(!$start_time && !$end_time && !$sdh_sla_type && !$src && !$dst) return;
	global $db;
	$performance_list = array();
	
	$query = $db->query("
		select sum(SDH_SLA_UAS) as UAS
		from SDH_SLA_LOG
		where SDH_SLA_TYPE='$sdh_sla_type' and SDH_SLA_SRC='$src' and SDH_SLA_DST='$dst' and
      			SDH_SLA_DATETIME between to_date($start_time,'yyyymmdd') and to_date($end_time,'yyyymmdd') ");
		
		$result = $db->fetchArray($query);
		return $result;	
}
}
?>