";
echo "| LinkSet | ";
echo "";
echo "";
echo "";
echo "| SPC | ";
echo "AdminState | ";
echo "OperState | ";
echo "AvailStatus | ";
echo " | ";
echo " ";
echo "";
$sqlstring = "select AdminState,OperState,AvailStatus,TheirPC from OMCR_ALinkSet where bssid=$bssid";
//echo $sqlstring . "
";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($adminstate,$operstate,$availstatus,$theirpc) =$row;
}
if($adminstate==1)$adminstate="Locked";
else if($adminstate==2)$adminstate="Unlocked";
if($operstate==1)$operstate="Disable";
else if($operstate==2)$operstate="Enable";
if($availstatus==0)$availstatus="In_Test";
else if($availstatus==1)$availstatus="Failed";
else if($availstatus==2)$availstatus="Power_Off";
else if($availstatus==3)$availstatus="Offline";
else if($availstatus==4)$availstatus="Online";
else if($availstatus==5)$availstatus="Dependency";
else if($availstatus==6)$availstatus="Degraded";
else if($availstatus==7)$availstatus="Not_Installed";
echo "$theirpc | ";
echo "$adminstate | ";
echo "$operstate | ";
echo "$availstatus | ";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "" ;
$sqlstring = "select ObjectId from OMCR_BSSTREE where engDisplayName like 'ALink%' and Presence=1 and bssid=$bssid";
//echo $sqlstring . "
";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($object[])=$row;//e.g ALink.0.0.(0~3)
}
$no_of_link=count($object);
$array = array(0, 1, 2, 3, 4);
//print_r($array);
for($n=0;$n<$no_of_link;$n++)
{
$link_num = explode(".",$object[$n]);
$num[$n] = $link_num[3];
unset($array[$num[$n]]);
}
$array = array_values($array);
//print_r($array);
echo "";
$linkno = $array[0];
$addtype = 'ALink';
$objectid = 'ALinkSet.0.0';
echo "";
echo "| ALink | ";
echo "+ | ";
echo "
";
echo " | ";
echo "";
echo "";
echo "";
echo "| No | ";
echo "AdminState | ";
echo "OperState | ";
echo "AvailStatus | ";
echo "Delete | ";
echo "";
echo " ";
for($i=0;$i<$no_of_link;$i++)
{
$alink = explode(".",$object[$i]);
$alinkno = $alink[3];
$sqlstring = "select AdminState,OperState,AvailStatus from OMCR_ALink where ObjectId='Alink.0.0.$alinkno' and bssid=$bssid";
//echo $sqlstring . "
";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($adminstate,$operstate,$availstatus) =$row;
}
if($adminstate==1)$adminstate="Locked";
else if($adminstate==2)$adminstate="Unlocked";
if($operstate==1)$operstate="Disable";
else if($operstate==2)$operstate="Enable";
if($availstatus==0)$availstatus="In_Test";
else if($availstatus==1)$availstatus="Failed";
else if($availstatus==2)$availstatus="Power_Off";
else if($availstatus==3)$availstatus="Offline";
else if($availstatus==4)$availstatus="Online";
else if($availstatus==5)$availstatus="Dependency";
else if($availstatus==6)$availstatus="Degraded";
else if($availstatus==7)$availstatus="Not_Installed";
echo "";
echo "";
echo "";
echo " ";
echo "";
?>
|
![](\"../../images/left.gif\")
Back