";
echo "| RCarrier $trx_cont[3] | ";
echo "";
echo "";
echo "";
echo "| Receive Mode | ";
echo "AdminState | ";
echo "OperState | ";
echo "AvailStatus | ";
echo " | ";
echo "";
echo " ";
$sqlstring = "select AdminState,OperState,AvailStatus,RxAntenna from OMCR_RCarrier where ObjectId='RCarrier.$trx_cont[1].$trx_cont[2].$trx_cont[3]' and bssid=$bssid";//$trx_object_name[$i]
//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,$rxmode) =$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";
if($rxmode==0)$rxmode="DIVERSITY";
else if($rxmode==1)$rxmode="ANTENNA 1";
else if($rxmode==2)$rxmode="ANTENNA 2";
echo "";
echo "";
echo "| $rxmode";
echo " | ";
echo "$adminstate | ";
echo "$operstate | ";
echo "$availstatus | ";
echo " | ";
echo " ";
echo " ";
echo "";
echo "";
//Trx ..............
$sqlstring="select AdminState,OperState,AvailStatus,trxDiagResult from OMCR_Trx where bssid=$bssid and ObjectId like 'Trx.$trx_cont[1].$trx_cont[2].$trx_cont[3]'";
//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,$rxresult) =$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";
//Failed=0;Passed=1;Not Performed=2
if($rxresult==0)$rxresult="Failed";
else if($rxresult==1)$rxresult="Passed";
else if($rxresult==2)$rxresult="Not Performed";
echo "";
echo "| Trx $trx_cont[3] | ";
echo "";
echo "";
echo "";
echo "| Diagnostic Result | ";
echo "AdminState | ";
echo "OperState | ";
echo "AvailStatus | ";
echo " | ";
echo "";
echo " ";
echo "";
echo "| $rxresult | ";
echo "$adminstate | ";
echo "$operstate | ";
echo "$availstatus | ";
echo " | ";
echo " ";
//TrxCh========
echo "";
echo "| No | ";
echo "AdminState | ";
echo "OperState | ";
echo "AvailStatus | ";
echo "Usage Status | ";
//echo "";
echo " ";
for($j=0;$j<8;$j++)
{
$sqlstring="select AdminState,OperState,AvailStatus,UsageState from OMCR_TrxCh where bssid=$bssid and ObjectId like 'TrxCh.$btsid.$cellid.$trx_cont[3].$j'";
//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,$usagestate) =$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";
//IDLE=0;ACTIVE=1;BUSY=2
if($usagestate==0)$usagestate="IDLE";
else if($usagestate==1)$usagestate="ACTIVE";
else if($usagestate==2)$usagestate="BUSY";
echo "";
echo"| TRXCH $j | ";
echo "$adminstate | ";
echo "$operstate | ";
echo "$availstatus | ";
echo "$usagestate | ";
echo " ";
}
echo "";
echo " ";
echo " | ";
}
//PowerControl
echo "";
echo "| Power Control | ";
echo "";
echo "";
echo "";
echo "| MsTxPwrMin | ";
echo "BtsTxPwrMin | ";
echo "Averging window for Level | ";
echo "Averging window for Quality | ";
echo "";
echo " ";
$sqlstring="select MsTxPwrMin,BtsTxPwrMin,PcAveragingLevelParamHreqave,PcAveragingQualParamHreqave from OMCR_PwrCont where bssid=$bssid and ObjectId like 'PwrCont.$btsid.$cellid.0'";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($mtpm,$btpm,$alph,$aqph) =$row;
}
echo "";
echo "";
echo " ";
echo "";
echo "";
echo "";
echo "| Handover Control | ";
echo "";
echo "";
echo "";
echo "| Uplink RxLev Threshold | ";
echo "Uplink RxQual Threshold | ";
echo "Downlink RxLev Threshold | ";
echo "Downlink RxQual Threshold | ";
echo "";
echo " ";
$sqlstring="select HoThresholdLevUl,HoThresholdQualUl,HoThresholdLevDl,HoThresholdQualDl from OMCR_HandCont where bssid=$bssid and ObjectId like 'HandCont.$btsid.$cellid.0'";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($htlu,$htqu,$htld,$htqd) =$row;
}
echo "";
echo "";
echo " ";
echo "";
echo "";
//AdjHand >>>>>>>>>
echo "";
//Check AdjHand is ok.......
$sqlstring = "select ObjectId from OMCR_BSSTREE where ObjectId like 'AdjHand.$btsid.$cellid%' and engDisplayName='' 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($adjhand_object[]) =$row;
}
//echo "$adjhand_object[0]";
$no_of_adj = count($adjhand_object);
$array = array(0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31);
//print_r($array);
for($n=0;$n<$no_of_adj;$n++)
{
$adj_num = explode(".",$adjhand_object[$n]);
$num[$n] = $adj_num[3];
unset($array[$num[$n]]);
}
$array = array_values($array);
//print_r($array);
$adjhand = $array[0];
$objectid = "AdjHand.".$btsid.".".$cellid.".".$adjhand;
$addtype = "AdjHand";
echo "";
echo "";
echo "| Adjacent Hand | ";
echo "+ | ";
echo "
";
//////////////////////////////AdjHand Parametet//////////////////////////////////////////
echo " | ";
echo "";
echo "";
echo "| Name | ";
echo "MCC | ";
echo "MNC | ";
echo "LAC | ";
echo "Cell Id | ";
echo "BSIC | ";
echo "BCCH | ";
echo "Delete | ";
echo "";
echo " ";
for($i=0;$i<$no_of_adj;$i++)
{
$adjconts = explode(".",$adjhand_object[$i]);
$sqlstring = "select Label,CellGlobalIdentityLaiMcc,CellGlobalIdentityLaiMnc,LocationAreaCodes,CellGlobalIdentityCi,BsIdentityCodes,BcchFrequency from OMCR_AdjHand where bssid=$bssid and ObjectId like 'AdjHand.$btsid.$adjconts[2].$adjconts[3]'";
//echo $sqlstring . "
";
$result = mysqli_query($pubConn,$sqlstring) or
die("Invalid query: $sqlstring\n" . mysqli_error($pubConn));
while($row = mysqli_fetch_row($result))
{
list($cellname,$mcc,$mnc,$lac,$cellid,$bsic,$bcch) =$row;
}
echo "";
//echo "";
echo "";
echo " ";
?> | | | |
![](\"../../images/left.gif\")
Back