";
echo "| UnAssigned TRXs | ";
echo "";
echo "";
echo "";
echo "| BtsMgrNumber | ";
echo "BtsNumber | ";
echo "TrxNumber | ";
echo "Assign to Bts.$btsid.$cellid | ";
echo "";
echo " ";
$sqlstring = "select ObjectId from OMCR_BSSTREE where ObjectId like 'Trx.$btsid%' and Presence=1 and ObjectId not like 'Trx.$btsid.$cellid%' 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($trx_object_name[]) =$row;
}
$no_of_trx = count($trx_object_name);//e.g RCarrier.0.0.4
for($i=0;$i<$no_of_trx;$i++)
{
$trx_cont = explode(".",$trx_object_name[$i]);
echo "";
echo "";
echo " ";
echo "";
echo "";
echo "";
echo "| Assigned TRXs | ";
echo "";
echo "";
/* echo "";
echo "| BtsMgrNumber | ";
echo "BtsNumber | ";
echo "TrxNumber | ";
echo " | ";
echo "";
echo " ";
*/
$sqlstring = "select ObjectId from OMCR_BSSTREE where ObjectId like 'Trx.$btsid.$cellid%' 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($trx_object[]) =$row;
}
$no_of_trx_1 = count($trx_object);//e.g RCarrier.0.0.4
for($i=0;$i<$no_of_trx_1;$i++)
{
$trx_cont = explode(".",$trx_object[$i]);
echo "";
echo "";
echo "| BtsMgr $trx_cont[1] | ";
echo "Bts $trx_cont[2] | ";
echo "Trx $trx_cont[3] | ";
echo " | ";
echo "";
}
echo " ";
echo " ";
echo "";
echo "";
echo " ";
echo "
Note: If you want to assign trx,you must Lock AbisMgr !";
?> | |
![](\"../../images/left.gif\")
Back