function DevClass($ina, $opa, $sta, $lim, $ord)
{
global $link, $modgroup, $self, $clalbl, $srtlbl, $lstlbl, $qtylbl, $venlbl, $totlbl, $opt;
?>
<table class="full fixed"><tr><td class="helper">
<h2>Device <?php
echo $clalbl;
?>
</h2>
<canvas id="clapie" style="display: block;margin: 0 auto;padding: 10px;" width="400" height="300"></canvas>
<table class="content">
<tr class="<?php
echo $modgroup[$self];
?>
2">
<th colspan="2" width="33%"><img src="img/16/abc.png"><br><?php
echo $clalbl;
?>
</th>
<th><img src="img/16/dev.png"><br>Devices</th>
</tr>
<?php
if ($ord) {
$ocol = 'icon';
$srt = "{$srtlbl}: {$clalbl}";
} else {
$ocol = ($opt ? 'sum' : 'cnt') . " desc";
$srt = "{$srtlbl}: {$qtylbl}";
}
if ($opt) {
$rcol = 2;
$ftlbl = "{$clalbl} (Stacked)";
$query = GenQuery('devices', 'g', 'SUBSTR(icon,1,2);sum(stack) AS sum', $ocol, $lim, array($ina), array($opa), array($sta));
} else {
$rcol = 1;
$ftlbl = $clalbl;
$query = GenQuery('devices', 'g', 'SUBSTR(icon,1,2)', $ocol, $lim, array($ina), array($opa), array($sta));
}
$res = DbQuery($query, $link);
if ($res) {
$row = 0;
$chd = array();
while ($r = DbFetchRow($res)) {
if ($row % 2) {
$bg = "txta";
$bi = "imga";
} else {
$bg = "txtb";
$bi = "imgb";
}
$row++;
$chd[] = array('value' => $r[$rcol], 'color' => GetCol('trf', $row));
echo "<tr class=\"{$bg}\"><th class=\"{$bi}\" width=\"10%\"><img src=\"img/dev/{$r['0']}an.png\" title=\"{$r['0']}\"></th>\n";
echo "<td>" . DevCat($r[0]) . "</td>\n";
echo "<td>" . Bar($r[$rcol], GetCol('trf', $row), 'ls') . " <a href=\"Devices-List.php?in[]=icon&op[]=like&st[]={$r['0']}%\" title=\"Device {$lstlbl}\">{$r[$rcol]}</a></td></tr>\n";
}
DbFreeResult($res);
}
?>
</table>
<table class="content" >
<tr class="<?php
echo $modgroup[$self];
?>
2"><td><?php
echo $row;
?>
<?php
echo $ftlbl;
?>
, <?php
echo $srt;
?>
</td></tr>
</table>
<script language="javascript">
var data = <?php
echo json_encode($chd, JSON_NUMERIC_CHECK);
?>
var ctx = document.getElementById("clapie").getContext("2d");
var myNewChart = new Chart(ctx).Pie(data);
</script>
</td><td class="helper">
<h2>Device <?php
echo $venlbl;
?>
</h2>
<canvas id="venpie" style="display: block;margin: 0 auto;padding: 10px" width="400" height="300"></canvas>
<table class="content">
<tr class="<?php
echo $modgroup[$self];
?>
2">
<th colspan="2" width="40"><img src="img/16/cbox.png"><br><?php
echo $venlbl;
?>
</th>
<th><img src="img/16/dev.png"><br>Devices</th>
</tr>
<?php
if ($ord) {
$ocol = 'icon';
$srt = "{$srtlbl}: {$venlbl}";
} else {
$ocol = ($opt ? 'sum' : 'cnt') . " desc";
$srt = "{$srtlbl}: {$qtylbl}";
}
if ($opt) {
$rcol = 2;
$ftlbl = "{$venlbl} (Stacked)";
$query = GenQuery('devices', 'g', 'SUBSTR(icon,3,1);sum(stack) AS sum', $ocol, $lim, array($ina), array($opa), array($sta));
} else {
$rcol = 1;
$ftlbl = $venlbl;
$query = GenQuery('devices', 'g', 'SUBSTR(icon,3,1)', $ocol, $lim, array($ina), array($opa), array($sta), array(), $join);
}
$res = DbQuery($query, $link);
if ($res) {
$row = 0;
$chd = array();
while ($r = DbFetchRow($res)) {
if ($row % 2) {
$bg = "txta";
$bi = "imga";
} else {
$bg = "txtb";
$bi = "imgb";
}
$row++;
$o = "=";
if (!$r[0]) {
$r[0] = "^\$";
$o = "~";
}
list($vn, $ic) = DevVendor('', $r[0]);
$chd[] = array('value' => $r[$rcol], 'color' => GetCol('345', $row, 1));
echo "<tr class=\"{$bg}\"><th style=\"background-color:#fff\" width=\"10%\">\n";
echo "<a href=\"http://www.google.com/search?q={$vn}&btnI=1\" target=\"window\"><img src=\"img/oui/{$ic}.png\" title=\"{$vn}\"></a></th><td>{$vn}</td>\n";
echo "<td>" . Bar($r[$rcol], GetCol('345', $row, 1), 'ls') . " <a href=Devices-List.php?in[]=icon&op[]=~&st[]=^..{$r['0']}>{$r[$rcol]}</a></td></tr>\n";
}
DbFreeResult($res);
}
?>
</table>
<table class="content" >
<tr class="<?php
echo $modgroup[$self];
?>
2"><td><?php
echo $row;
?>
<?php
echo $ftlbl;
?>
, <?php
echo $srt;
?>
</td></tr>
</table>
<script language="javascript">
var data = <?php
echo json_encode($chd, JSON_NUMERIC_CHECK);
?>
var ctx = document.getElementById("venpie").getContext("2d");
var myNewChart = new Chart(ctx).Pie(data);
</script>
</td></tr></table>
<p>
<?php
}
}
DbFreeResult($res);
$dbloc = explode($locsep, $dev[10]);
if($dbloc[2]){
$dvloc = 'reg='.urlencode($dbloc[0]).'&cty='.urlencode($dbloc[1]).'&bld='.urlencode($dbloc[2]);
$lolbl = "$place[b]";
}elseif($dbloc[1]){
$dvloc = 'reg='.urlencode($dbloc[0]).'&cty='.urlencode($dbloc[1]);
$lolbl = "$place[c]";
}else{
$dvloc = 'reg='.urlencode($dev[10]);
$lolbl = "$place[r]";
}
list($vn,$ic) = DevVendor($dev[25]);
?>
</td></tr>
<tr><th class="<?= $modgroup[$self] ?>2"><?= $deslbl ?></th><td class="txta">
<a href="http://www.google.com/search?q=<?= urlencode($dev[3]) ?>&btnI=1" target="window"><img src="img/oui/<?= $ic ?>.png" title="<?= $vn ?>"></a>
<a href="Devices-List.php?in[]=type&op[]==&st[]=<?= urlencode($dev[3]) ?>"><?= $dev[3] ?></a> <?= $dev[7] ?></td></tr>
<tr><th class="<?= $modgroup[$self] ?>2"><?= $loclbl ?></th><td class="txtb">
<div style="float:right">
<a href="Topology-Table.php?<?= $dvloc ?>"><img src="img/16/icon.png" title="<?= (($verb1)?"$sholbl $lolbl":"$lolbl $sholbl") ?>"></a>
<a href="Monitoring-Health.php?<?= $dvloc ?>"><img src="img/16/hlth.png" title="<?= (($verb1)?"$sholbl $lolbl":"$lolbl $sholbl") ?>"></a>
</div>
<?php
if($isadmin and $guiauth != 'none' and ($wasup and $dev[26] or $sysobj == 'NoSNMP-User') and !isset($_GET['print']) ){# Admin, write access or user-created
?>
<form method="get" name="locfrm">
<input type="hidden" name="dev" value="<?= $dev[0] ?>">
if( in_array("imgNS",$col) ){
TblCell('','',"bgcolor=\"white\"","<a href=\"Devices-Status.php?dev=$ud\"><img width=\"".(preg_match('/^ph|^wa|^ca/',$dev[18])?40:100)."\" src=\"".DevPanel($dev[3],$dev[18],$dev[28])."\" title=\"$dev[3]\"></a>$stk $most","th-img");
}
if(in_array("devip",$col)){
$dvip = Devcli( $ip, $dev[16] );
if( !in_array("device",$col) ){$dvip .= " ($dev[0])";}
TblCell($dvip);
}
if(in_array("origip",$col)){
TblCell( Devcli($oi,$dev[16]) );
}
if(in_array("serial",$col)){
TblCell($dev[2]);
}
if(in_array("type",$col)){
list($vn,$ic) = DevVendor($dev[25],substr($dev[18],2,1) );
TblCell( $dev[3],"?in[]=type&op[]==&st[]=".urlencode($dev[3]),'',"<a href=\"http://www.google.com/search?q=".urlencode($dev[3])."&btnI=1\" target=\"window\"><img src=\"img/oui/$ic.png\" title=\"$vn\"></a> ");
}
if(in_array("services",$col)){
TblCell( Syssrv($dev[6])." ($dev[6])","?in[]=services&op[]==&st[]=$dev[6]");
}
if(in_array("description",$col)){
TblCell($dev[7]);
}
if(in_array("devos",$col)){
TblCell( $dev[8],"?in[]=devos&op[]==&st[]=".urlencode($dev[8]) );
}
if(in_array("bootimage",$col)){
TblCell( $dev[9],"?in[]=bootimage&op[]==&st[]=".urlencode($dev[9]) );
}
if(in_array("location",$col)){
