X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=plekit%2Fphp%2Fcolumns.php;h=ffc41ced5d06b651457626ff8c86dbc692ccc5ce;hb=eeb11c7fedb5ddceee3884a4b7509d60e84714b8;hp=89404e5a3f43af004b88f5d43b65e78b698025a7;hpb=fa425f537d2e4aced1a2362672791aed274dd903;p=plewww.git diff --git a/plekit/php/columns.php b/plekit/php/columns.php index 89404e5..ffc41ce 100644 --- a/plekit/php/columns.php +++ b/plekit/php/columns.php @@ -9,7 +9,7 @@ drupal_set_html_head(' class PlekitColumns { var $column_configuration = ""; -var $reference_node = ""; +var $reference_nodes = array(); var $first_time = false; var $all_headers = array(); @@ -20,48 +20,54 @@ var $fix_columns = array(); var $tag_columns = array(); var $extra_columns = array(); +var $comon_live_data = ""; +var $tophat_live_data = ""; +var $ComonData = array(); +var $TopHatData = array(); +var $TopHatAgents = array(); + var $table_ids; var $HopCount = array(); +var $RTT = array(); - function PlekitColumns ($column_configuration, $fix_columns, $tag_columns, $extra_columns=NULL, $this_table_headers=NULL) { +function PlekitColumns ($column_configuration, $fix_columns, $tag_columns, $extra_columns=NULL, $this_table_headers=NULL) { + if ($column_configuration != NULL) { $this->fix_columns = $fix_columns; $this->tag_columns = $tag_columns; $this->extra_columns = $extra_columns; - //print("

FIX

"); - //print_r($this->fix_columns); - //print("

TAG

"); - //print_r($this->tag_columns); - //print("

EXTRA

"); - //print_r($this->extra_columns); - $this->prepare_headers(); $this->parse_configuration($column_configuration); $this->visible_headers = $this->get_visible(); - - //print("

VISIBLE

"); - //print_r($this->visible_headers); - + } } /* -INFO +INFO/HEADERS */ function prepare_headers() { foreach ($this->fix_columns as $column) { -$this->all_headers[$column['header']]=array('header'=>$column['header'],'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'], 'fixed'=>true, 'visible'=>false); +$this->all_headers[$column['header']]=array('header'=>$column['header'],'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'], 'fixed'=>true, 'visible'=>false, 'source'=>'myplc'); } $tmp_headers = array(); + +if ($this->extra_columns) +foreach ($this->extra_columns as $column) { +$tmp_headers[$column['header']]=array('header'=>$column['header'],'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'], 'fetched'=>$column['fetched'], 'visible'=>false, 'source'=>$column['source']); + +} + +if ($this->tag_columns) foreach ($this->tag_columns as $column) { if ($column['headerId'] != "") @@ -69,17 +75,10 @@ if ($column['headerId'] != "") else $headerId = $column['header']; -//$this->all_headers[$headerId]=array('header'=>$headerId,'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'],'visible'=>false); -$tmp_headers[$headerId]=array('header'=>$headerId,'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'],'visible'=>false); +$tmp_headers[$headerId]=array('header'=>$headerId,'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'],'visible'=>false, 'source'=>'myplc'); } -if ($this->extra_columns) -foreach ($this->extra_columns as $column) { -//$this->all_headers[$column['header']]=array('header'=>$column['header'],'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'], 'fetched'=>$column['fetched'],'visible'=>false); -$tmp_headers[$column['header']]=array('header'=>$column['header'],'type'=>$column['type'],'tagname'=>$column['tagname'],'title'=>$column['title'], 'description'=>$column['title'], 'label'=>$column['header'], 'fetched'=>$column['fetched'], 'visible'=>false); - usort ($tmp_headers, create_function('$col1,$col2','return strcmp($col1["label"],$col2["label"]);')); -} foreach ($tmp_headers as $t) $this->all_headers[$t['header']] = $t; @@ -115,11 +114,11 @@ return ""; function node_tags() { - $fetched_tags = array('node_id'); + $fetched_tags = array('node_id','hostname'); foreach ($this->all_headers as $h) { - if ($h['visible'] == true && $h['tagname'] != "" && !$h['fetched']) + if ($h['visible'] == true && $h['tagname'] != "" && !$h['fetched'] && $h['source']=="myplc") $fetched_tags[] = $h['tagname']; } @@ -173,12 +172,9 @@ CONFIGURATION function parse_configuration($column_configuration) { $this->column_configuration = $column_configuration; - //$this->default_configuration = $default_configuration; - - //print($this->print_headers()); - $columns_conf = explode("|", $column_configuration); + foreach ($columns_conf as $c) { $conf = explode(":",$c); @@ -186,25 +182,33 @@ function parse_configuration($column_configuration) { if ($conf[0] == "default") continue; + if (!$this->all_headers[$conf[0]]) + continue; + $this->all_headers[$conf[0]]['visible']=true; - //print("

-".$conf[0]."-should be visible now - ".$this->all_headers[$conf[0]]['visible']); + + if ($this->all_headers[$conf[0]]['source'] == "comon") + $this->comon_live_data.=",".$this->all_headers[$conf[0]]['tagname']; + + if ($this->all_headers[$conf[0]]['source'] == "tophat") + { + if ($this->all_headers[$conf[0]]['tagname'] == 'hopcount') + { + $this->reference_nodes['hopcount'] = $conf[1]; + //print ("ref node in configuration = ".$conf[1]); + $this->all_headers[$conf[0]]['refnode']=$this->reference_nodes['hopcount']; + } + else if (strpos($this->all_headers[$conf[0]]['tagname'],"agents") === false) + $this->tophat_live_data.=",".$this->all_headers[$conf[0]]['tagname']; + //$threshold = explode(",",$conf[1]); + //$this->all_headers[$conf[0]]['threshold']=$threshold; + } + //print_r($this->all_headers[$conf[0]]); /* - if ($conf[1] == "f") - continue; - else if ($this->inTypeC($conf[0])) { - $this->all_headers[$conf[0]]['duration']= substr($conf[0], strlen($conf[0])-1, strlen($conf[0])); - $threshold = explode(",",$conf[1]); - $this->all_headers[$conf[0]]['threshold']=$threshold; - } - else if ($this->inTypeD($conf[0])) - { - $this->reference_node = $conf[1]; - $this->reference_node = "planetlab-europe-07.ipv6.lip6.fr"; - $this->all_headers[$conf[0]]['refnode']=$this->reference_node; $threshold = explode(",",$conf[1]); $this->all_headers[$conf[0]]['threshold']=$threshold; } @@ -213,13 +217,9 @@ function parse_configuration($column_configuration) { $exclude_list = explode(",",$conf[1]); $this->all_headers[$conf[0]]['exclude_list']=$exclude_list; } - else - { - $threshold = explode(",",$conf[1]); - $this->all_headers[$conf[0]]['threshold']=$threshold; - } */ } + } @@ -232,46 +232,249 @@ CELLS */ -function getHopCount($ref_node, $planetlab_nodes) -{ +function convert_data($value, $data_type) { + + //print "converting ".$value." as ".$data_type; + + if ($value == "" || $value == null || $value == "n/a" || $value == "None") + return "n/a"; + + if ($data_type == "string") + return $value; + + if ($data_type == "date") + return date("Y-m-d", $value); + + if ($data_type == "uptime") + return (int)((int) $value / 86400); + + if (is_numeric($value)) + return ((int) ($value * 10))/10; + + return $value; + +} + +function getTopHatAgents() { + + $tophat_auth = array( 'AuthMethod' => 'password', 'Username' => 'guest@top-hat.info', 'AuthString' => 'guest'); + $tophat_api = new TopHatAPI($tophat_auth); + + //print ("Requesting tophat agents..."); + //print_r($r); + + $values = $tophat_api->Get('agents', 'latest', array('colocated.platform_name' => array('SONoMA', 'DIMES', 'ETOMIC', 'TDMI'), 'platform_name'=> 'TDMI'), array('hostname', 'colocated.peer_name', 'colocated.platform_name')); + + $result = array(); + + if ($values) foreach ($values as $t) { + //print_r($t); + //print("


"); + $result[$t['hostname']] = ""; + foreach ($t['colocated'] as $ll) { + + if (strpos($result[$t['hostname']]['all'],$ll['platform_name']) === false) { + if ($result[$t['hostname']]['all'] != "") + $result[$t['hostname']]['all'] .= ","; + $result[$t['hostname']]['all'] .= $ll['platform_name']; + } + + if ($ll['platform_name'] == 'SONoMA') { + if (strpos($result[$t['hostname']]['sonoma'],$ll['peer_name']) === false) { + if ($result[$t['hostname']]['sonoma'] != "") + $result[$t['hostname']]['sonoma'] .= ","; + $result[$t['hostname']]['sonoma'] .= $ll['peer_name']; + } + } + + if ($ll['platform_name'] == 'TDMI') { + if (strpos($result[$t['hostname']]['tdmi'],$ll['peer_name']) === false) { + if ($result[$t['hostname']]['tdmi'] != "") + $result[$t['hostname']]['tdmi'] .= ","; + $result[$t['hostname']]['tdmi'] .= $ll['peer_name']; + } + } + } + } + + $this->TopHatAgents = $result; + + //print_r($this->TopHatAgents); + + return $result; +} + +function getTopHatData($data, $planetlab_nodes) { + + $tophat_auth = array( 'AuthMethod' => 'password', 'Username' => 'guest@top-hat.info', 'AuthString' => 'guest'); + $tophat_api = new TopHatAPI($tophat_auth); + + $requested_data = explode(",", $data); + + $r = array ('hostname'); + + foreach ($requested_data as $rd) + if ($rd) $r[] = $rd; + + //print ("Requesting data from TopHat ..."); + //print_r($r); + + $values = $tophat_api->Get('ips', 'latest', array('hostname' => $planetlab_nodes), $r ); + + $result = array(); + + if ($values) foreach ($values as $t) + foreach ($requested_data as $rd) + if ($rd) $result[$t['hostname']][$rd] = $t[$rd]; + + //print_r($result); + + return $result; +} + +function getTopHatRefNodes() { + + $tophat_auth = array( 'AuthMethod' => 'password', 'Username' => 'guest@top-hat.info', 'AuthString' => 'guest'); + $tophat_api = new TopHatAPI($tophat_auth); + + //print "calling tophat for agents"; + + $agents = $tophat_api->Get('agents', 'latest', array('peer_name'=>array('PLC', 'PLE'), 'agent_status'=> 'OK'), array('hostname')); + + //print_r($agents); + + return $agents; + +} + +function getPairwise($ref_node, $planetlab_nodes, $command, $data) { + + $tophat_auth = array( 'AuthMethod' => 'password', 'Username' => 'guest@top-hat.info', 'AuthString' => 'guest'); + $tophat_api = new TopHatAPI($tophat_auth); + + $traceroute = $tophat_api->Get($command, 'latest', array('src_hostname' => $ref_node, 'dst_hostname' => $planetlab_nodes), array('dst_hostname', $data) ); + + print "Got result: ".$traceroute; + + $hopcount = array(); + + if ($traceroute) + { + foreach ($traceroute as $t) + { + $hopcount[$t['dst_hostname']]=$t[$data]; + //print " current: ".$t['dst_hostname'].":".$t['hop_count']; + } + + return $hopcount; + } + else + return ""; +} + +function comon_query_nodes($requested_data) { + + $base_url = "http://comon.cs.princeton.edu/status/tabulator.cgi?table=table_nodeviewshort&format=formatcsv&dumpcols='name"; + + $url = $base_url.$requested_data."'"; -$tophat_auth = array( 'AuthMethod' => 'password', 'Username' => 'guest', 'AuthString' => 'guest'); -$tophat_api = new TopHatAPI($tophat_auth); + //print ("Retrieving comon data for url ".$url); -$traceroute = $tophat_api->Get('traceroute', 'latest', array('src_hostname' => $ref_node, 'dst_hostname' => $planetlab_nodes), array('dst_hostname', 'hop_count') ); + $sPattern = '\', \''; + $sReplace = '|'; -$hopcount = array(); + $str=file_get_contents($url); -if ($traceroute) foreach ($traceroute as $t) -$hopcount[$t['dst_hostname']]=$t['hop_count']; -return $hopcount; + if ($str === false) + return ''; + + $result=preg_replace( $sPattern, $sReplace, $str ); + $sPattern = '/\s+/'; + $sReplace = ';'; + $result=preg_replace( $sPattern, $sReplace, $result ); + + $comon_data = explode(";", $result); + $cl = array(); + $comon_values = array(); + + foreach ($comon_data as $cd) { + $cc = explode("|", $cd); + if ($cc[0] == "name") { + $cl = $cc; + } + $comon_values[$cc[0]] = array(); + $cindex=1; + foreach ($cl as $cltag) { + if ($cltag != "name") + $comon_values[$cc[0]][$cltag] = $cc[$cindex++]; + } + } + + return $comon_values; } //Depending on the columns selected more data might need to be fetched from //external sources -function fetch_data($nodes) { +function fetch_live_data($all_nodes) { -//TopHat pairwise data + //print("

fetching live data

"); + +//comon data + if ($this->comon_live_data != "") { + + //print ("live data to be fetched =".$this->comon_live_data); + $this->ComonData= $this->comon_query_nodes($this->comon_live_data); + //print_r($this->ComonData); + } - if ($this->reference_node != "") +//TopHat per_node data + if ($this->tophat_live_data != "") { $dd = array(); - if ($nodes) foreach ($nodes as $n) + if ($all_nodes) foreach ($all_nodes as $n) $dd[] = $n['hostname']; - if ($potential_nodes) foreach ($potential_nodes as $n) + //print("Calling tophat api for ".$this->tophat_live_data); + $st = time() + microtime(); + $this->TopHatData = $this->getTopHatData($this->tophat_live_data, $dd); + //printf(" (%.2f ms)
", (time() + microtime()-$st)*100); + //print_r($this->TopHatData); + } + +//TopHat pairwise data + + $this->HopCount = ""; + $this->RTT = ""; + + if ($this->reference_nodes != "") + { + //print_r($this->reference_nodes); + + $dd = array(); + + if ($all_nodes) foreach ($all_nodes as $n) $dd[] = $n['hostname']; - print("Calling tophat api for reference node = ".$this->reference_node); $st = time() + microtime(); - $HopCount = $this->getHopCount($this->reference_node, $dd); - printf(" (%.2f ms)
", (time() + microtime()-$st)*100); - //print_r($HopCount); - } + if ($this->headerIsVisible("HC")) + { + print("[NEW] Calling tophat api for HopCount with reference node = ".$this->reference_nodes['hopcount']); + $this->HopCount = $this->getPairwise($this->reference_nodes['hopcount'], $dd, 'traceroute', 'hop_count'); + } + else + + if ($this->headerIsVisible("RTT")) + { + print("[NEW] Calling tophat api for RTT with reference node = ".$this->reference_nodes['rtt']); + $this->RTT = $this->getPairwise($this->reference_nodes['rtt'], $dd, 'rtt','rtt'); + } + //printf(" (%.2f ms)
", (time() + microtime()-$st)*100); + print_r($this->HopCount); + } } @@ -307,53 +510,123 @@ function checkThreshold($value, $threshold, $hh) { function cells($table, $node) { -$this->fetch_data($node); +//$node_string = ""; + +foreach ($this->all_headers as $h) { -foreach ($this->all_headers as $h) -{ if (!$h['fixed']) { -if ($h['visible'] != "") -{ -if ($this->inTypeC($h['header'])) +if ($h['visible'] != "") { + +/* +if ($this->inTypeB($h['header'])) { - $tagname = $h['tagname']; - $value = $node[$tagname]; + $value = $node[$h['tagname']]; $v = $this->checkThreshold($value, $h['threshold'], $h['header']); $table->cell($v[0],$v[1]); } -else if ($this->inTypeB($h['header'])) +else if ($this->inTypeA($h['header'])) { $value = $node[$h['tagname']]; - $v = $this->checkThreshold($value, $h['threshold'], $h['header']); + $v = $this->excludeItems($value, $h['exclude_list'], $h['header']); $table->cell($v[0],$v[1]); } -else if ($this->inTypeD($h['header'])) +*/ +if ($h['source'] == "comon") { - $value = $this->HopCount[$node['hostname']]; - $v = $this->excludeItems($value, $h['threshold'], $h['header']); - $table->cell($v[0],$v[1]); + //print("
Searching for ".$h['tagname']."at ".$node); + if ($this->ComonData != "") + $value = $this->convert_data($this->ComonData[$node['hostname']][$h['tagname']], $h['tagname']); + else + $value = "n/a"; + + $table->cell($value,array('name'=>$h['header'], 'display'=>'table-cell')); + //$node_string.= "\"".$value."\","; } -else if ($this->inTypeA($h['header'])) +else if ($h['source'] == "tophat") { - $value = $node[$h['tagname']]; - $v = $this->excludeItems($value, $h['exclude_list'], $h['header']); - $table->cell($v[0],$v[1]); + //print("
Searching for ".$h['tagname']."at ".$node); + if ($h['tagname'] == "hopcount") + { + //print "value = ".$this->HopCount[$node['hostname']]; + //$value = "hc"; + if ($this->HopCount != "") + $value = $this->HopCount[$node['hostname']]; + else + $value = "n/a"; + } + else if ($h['tagname'] == "rtt") + { + if ($this->RTT != "") + if ($this->RTT[$node['hostname']] != "") + $value = $this->RTT[$node['hostname']]; + else + $value = "n/a"; + else + $value = "n/a"; + } + else if ($h['tagname'] == "agents") + { + if ($this->TopHatAgents != "") + if ($this->TopHatAgents[$node['hostname']] != "") + $value = $this->TopHatAgents[$node['hostname']]['all']; + else + $value = "n/a"; + else + $value = "n/a"; + } + else if ($h['tagname'] == "agents_tdmi") + { + if ($this->TopHatAgents != "") + if ($this->TopHatAgents[$node['hostname']] != "") + $value = $this->TopHatAgents[$node['hostname']]['tdmi']; + else + $value = "n/a"; + else + $value = "n/a"; + } + else if ($h['tagname'] == "agents_sonoma") + { + if ($this->TopHatAgents != "") + if ($this->TopHatAgents[$node['hostname']] != "") + $value = $this->TopHatAgents[$node['hostname']]['sonoma']; + else + $value = "n/a"; + else + $value = "n/a"; + } + else + { + if ($this->TopHatData != "") + $value = $this->convert_data($this->TopHatData[$node['hostname']][$h['tagname']], $h['type']); + else + $value = "n/a"; + } + + $table->cell($value,array('name'=>$h['header'], 'display'=>'table-cell')); + //$node_string.= "\"".$value."\","; } else { - $value = $node[$h['tagname']]; + //$value = $node[$h['tagname']]; + $value = $this->convert_data($node[$h['tagname']], $h['type']); $table->cell($value,array('name'=>$h['header'], 'display'=>'table-cell')); + //$node_string.= "\"".$value."\","; } } else if ($node[$h['tagname']]) - $table->cell($node[$h['tagname']], array('name'=>$h['header'], 'display'=>'none')); + { + $value = $this->convert_data($node[$h['tagname']], $h['type']); + $table->cell($value, array('name'=>$h['header'], 'display'=>'none')); + } else - $table->cell("??", array('name'=>$h['header'], 'display'=>'none')); + $table->cell("n/a", array('name'=>$h['header'], 'display'=>'none')); } } +//return $node_string; + } @@ -366,24 +639,32 @@ HTML function javascript_init() { -print(""); +$refnodes = $this->getTopHatRefNodes(); +//$tophat_agents = $this->getTopHatAgents(); +$ref_nodes = ""; +foreach ($refnodes as $r) +{ + if ($r['hostname'] == $this->reference_nodes['hopcount']) + $selected = "selected=selected"; + else + $selected = ""; + + $ref_nodes = $ref_nodes.""; +} + +print(""); print(""); } - - function quickselect_html() { -//return '

This link uses the onclick event handler.
Open popup

'; - - $quickselection = ""; $prev_label=""; $optionclass = "out"; foreach ($this->all_headers as $h) @@ -397,27 +678,19 @@ foreach ($this->all_headers as $h) $disabled = ""; if ($this->headerIsVisible($h['label'])) - { $optionclass = "in"; - //$selected = "selected=selected"; - } else - { $optionclass = "out"; - //$selected = ""; - } if ($prev_label == $h['label']) continue; $prev_label = $h['label']; + $quickselection.=""; -//$quickselection.=""; -$quickselection.=""; } - $quickselection.=""; return $quickselection; @@ -432,15 +705,15 @@ if ($showDescription) else $table_width = 350; -print(""); -print(""); +print("
Add/remove columns
"); +print(""); if ($showDescription) - print(""); + print(""); -print("
Add/remove columnsColumn description and configurationColumn description and configuration
"); +print("
"); - print('
'); + print('
'); print (""); $prev_label=""; $optionclass = "out"; @@ -481,12 +754,14 @@ print ("
"); print (""); } @@ -494,8 +769,8 @@ print ("
+ +
- - - - - +
".$h['label']." ".$h['title']."   
+ + + +
".$h['label']." ".$h['title']."   
"); if ($showDescription) { - print(""); + print(""); } print("");
"); - print("
            
"); + print("