";
echo "| Trunk group | ";
echo "";
echo "";
echo "| No. | ";
echo "Category | ";
if($webname=='IUA')
{
echo " | ";
echo " | ";
}
else
{
echo "NI | ";
echo "DPC | ";
}
echo " ";
//------------查询TrunkGroup参数表---------------------
$sysId = '322_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$oidstr = '2.1.4';
$objWhereStr= '';
$objWhereStr = getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo ='$trunkgp'
";
$Result = mysqli_query($pubConn,$paramSql);
$Row = mysqli_fetch_array($Result);
//------------读TrunkGroup参数表---------------------
//echo "
paramSql: $paramSql";
// $RAC = hexdec(getBitValue($Row[initValue],'10.0-10.7'));
$Flag = getBitValue($Row[initValue],'4.0-4.0');
$Category = getBitValue($Row[initValue],'4.3-4.5');
$NetID = hexdec(getBitValue($Row[initValue],'5.0-5.7'));
$DPC = hexdec(getBitValue($Row[initValue],'0.0-3.7'));
$Alternative = hexdec( getBitValue($Row[initValue],'7.0-7.7'));
$CDR = getBitValue($Row[initValue],'4.1-4.1');
$Flag = (BinDec($Flag)) ? ("Enable") : ("Disable");
$CDR = (BinDec($CDR)) ? ("on") : ("off");
switch(BinDec($Category))
{
case 0:
$Category = "PSTN";
break;
case 1:
$Category = "HPLMN";
break;
case 2:
$Category = "VPLMN";
break;
case 3:
$Category = "SUB";
break;
case 4:
$Category = "IP";
break;
case 5:
$Category = "Intercept";
break;
default:
$Category = "N/A";
}
//echo "$Row[initValue]";
//------------显示TrunkGroup参数表---------------------
echo "";
if(isset($trunkgp))
{
$setobjIdstr = "2.1.4-2.1.4";
$setname = 'Trunk Group';
if($TypeIn==17)
echo "| $trunkgp | ";
else
echo "$trunkgp | ";
echo "$Category | ";
if($webname=='IUA')
{
echo " | ";
echo " | ";
}
else
{
echo "$NetIdConfArr[$NetID] | ";
echo "$DPC | ";
}
}
else
{
echo "-- | ";
echo "-- | ";
echo "-- | ";
echo "-- | ";
}
echo " ";
echo " | ";
echo "
";
}//Trunk group end
}
if($E1_show)
{
{//E1 strat
//------------查询E1参数表---------------
$sysId = '322_99_99';
$oidstr = '2.4.2';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$HEXtrunkgp = omc_keep_length(dechex($trunkgp),"0","2");
$HEXtrunkgp = strtoupper($HEXtrunkgp);
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND initValue = '$HEXtrunkgp'
ORDER BY instanceNo";
//echo "$paramSql";
$Result = mysqli_query($pubConn,$paramSql);
//------------读E1参数表---------------------
$tmpWhere='(0';
$E1connarr="";
$out_time=date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s")-30,date("m"),date("d"),date("Y")));
$el2_bgn = 25; //e1 layer2
while($Row = mysqli_fetch_array($Result))
{
if($tmpWhere=='(0')
$tmpWhere="(instanceNo='$Row[instanceNo]'";
else
$tmpWhere=$tmpWhere." OR instanceNo='$Row[instanceNo]'";
}
$tmpWhere=$tmpWhere.")";
{
$oidstr = '2.4.4';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND $tmpWhere ORDER BY instanceNo
";
$Result_3 = mysqli_query($pubConn,$paramSql);
//echo $paramSql;
$tmpWhere='(0';
$n = 0;
while($Row_3 = mysqli_fetch_array($Result_3))
{
$oflag = getBitValue($Row_3[initValue],'0.0-0.0');
if($oflag)
{
if($tmpWhere=='(0')
$tmpWhere="(instanceNo='$Row_3[instanceNo]'";
else
$tmpWhere=$tmpWhere." OR instanceNo='$Row_3[instanceNo]'";
{//E1 state
$tempnum = $Row_3[instanceNo]/8;
$cardno = Floor($tempnum);
$sysNo = $cardno > 15 ? 1 : 0;
$slot = $cardno % 16;
$port = $Row_3[instanceNo] - $cardno*8;
$e1selSql = "SELECT sysTypeNo,sysNo,subSysNo,detailStat,updateTime
FROM sysStat WHERE sysTypeNo='111' AND sysNo='$sysNo' and subSysNo='$slot' ";
$e1Result = @mysqli_query($pubConn,$e1selSql);
if($e1Row = @mysqli_fetch_array($e1Result))
{
$hex_mes = $e1Row[detailStat];
$bin_mes='';
for($i=0;$i";
if($DEBUG) echo "E1connarr=$E1connarr
";
//------------显示E1参数表---------------------
$rowspan = $n +1;
if($n ==0)
{
$tmpcic = 255;
$rowspan =2;
}
else
{
$tmpcic = hexdec($E1cic[0][initValue]);
}
echo "";
echo "";
echo "";
echo "| E1/T1 connection | ";
if($TypeIn ==2 && $n > 1)//AAS最多加2条E1connect
{
echo "+ | ";
}
elseif($TypeIn ==2)
{
echo "+ | ";
}
elseif($TypeIn !=2&& $n > 31)//最多加32条E1connect
{
echo "+ | ";
}
else
{
echo "+ | ";
}
echo "
";
echo " | ";
echo "";
echo "";
echo "";
echo "| No. | ";
echo "Protocol | ";
if($webname=="IUA")
echo "Interface ID | ";
else
echo "Circuit ID | ";
echo "E1/T1 channel | ";
echo "Status | ";
echo "Admin State | ";
echo "Delete | ";
echo " ";
if($n==0)
{
echo "| -- | ";
}
$Protocol = array("TUP","ISUP","AIF","ISDN NT","ISDN LT","CI-CNF","CI-loopback");
for($i=0;$i < $n;$i++)
{
$tempnum = $instNo[$i]/8;
$cardno = Floor($tempnum);
$cardE1no = $instNo[$i] - $cardno*8;
$cscNo = Floor($cardno/16);
$subCardNo = $cardno%16;
$cardname = "CSC$cscNo"." "."Card-$subCardNo-$cardE1no";
$cic = hexdec(getBitValue($E1cic[$i][initValue],'0.0-0.7'));
if($i>3)
echo "";
else
echo " ";
//echo " ";
echo "| $cardname | ";
$p = hexdec(getBitValue($E1Protocol[$i][initValue],'0.0-0.7'));
echo "$Protocol[$p] | ";
echo "$cic | ";
echo "";
$tempnum = $instNo[$i]/8;
$cardno = Floor($tempnum);
$cardname = "cardno"."_$cardno";
$tempno = $cardno+1;
$oidCard = "2.5."."$tempno";
// $objWhereStr =getLevelWhere($oidCard);
$objWhereStr =" level_1 = '2' and level_2 = '5' and level_3 = '$tempno'";
$cardE1no = $instNo[$i] - $cardno*8;
$timeslotno = $cardE1no*32;
$enabletime = 0;
$tmp = $timeslotno+32;
$selSql = "SELECT initValue
FROM $paramTable
WHERE $objWhereStr AND instanceNo>='$timeslotno' AND instanceNo<='$tmp'
";
//echo "
E1 Enable Sql: $selSql";
$result=mysqli_query($pubConn,$selSql);
echo mysqli_error($pubConn);
for($j=0; $j< 32;$j++)
{
$rows =mysqli_fetch_array($result);
$orgValue=$rows[0];
echo mysqli_error($pubConn);
$getval = bindec(getBitValue($orgValue,'00.0-00.0'));
if($getval)
$enabletime++;
$timeslotno++;
}
echo "";
echo "$enabletime enable | ";
if($cic == 0)
{
$delE1ID = 0;
}
else
{
$delE1ID = 1;
}
$delID = $instNo[$i]."_".$delE1ID;
if($DEBUG) echo "$delID
";
if(isset($E1state[$i]) && $E1state[$i]==1)//$E1state[$i]也可能没有赋值
echo "OK | ";
else
echo "Down | ";
if($Lockflag[$i])
echo "Unlocked";
else
echo " | Locked";
echo " | ";
echo " | ";
echo " ";
}
if($n>4)
{
echo "| More >> | ";
echo "| Hide >> | ";
}
echo " ";
echo " | ";
echo "
";
}//E1 end
}
if($vssPrefix_show || $prefix_show || $pcrPrefix_show)//SHOW VSS PREFIX or switch prefix
{
$sysId = '322_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
{//get all valid prefix No
$oidstr = '2.1.2';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$defSql = " SELECT initValue,instanceNo FROM $paramTable
WHERE $objWhereStr and instanceNo<252
ORDER BY instanceNo";
//echo $defSql;
$defRes = @mysqli_query($pubConn,$defSql);
echo mysqli_error($pubConn);
$offset_enable = "10.7-10.7";
$offset_Properties = "10.2-10.3";
$offset_calltype = "10.4-10.6";
$prefix_num=0;
while($row = @mysqli_fetch_array($defRes))
{
$prefix_enable=hexdec(getBitValue($row[initValue],$offset_enable));
$prefix_property=hexdec(getBitValue($row[initValue],$offset_Properties));
$prefix_calltype=hexdec(getBitValue($row[initValue],$offset_calltype));
if($vssPrefix_show||$pcrPrefix_show)
$flag = $prefix_enable;
if($prefix_show)
//$flag = ($prefix_enable && ($prefix_property==0) && ($prefix_calltype==0));//enable,trunk,normalcall
$flag = $prefix_enable;
if($flag)
{
$enablePrefix[$prefix_num][inst_no]=$row[instanceNo];
$enablePrefix[$prefix_num][init_value]=$row[initValue];
//echo "
enablePrefix[$prefix_num][init_value]:{$enablePrefix[$prefix_num][init_value]}";
$prefix_num++;
}
}
}//end get valid prefix No
{
$oidstr = '2.1.3';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr and instanceNo<252
ORDER BY instanceNo
";
//echo "
paramSql: $paramSql";
$Result_1 = mysqli_query($pubConn,$paramSql);
$prefix_no=0;
$valid_num=0;
while($Row_1 = mysqli_fetch_array($Result_1))
{
if($Row_1[instanceNo]==$enablePrefix[$prefix_no][inst_no])
{
$tmpTg=hexdec($Row_1[initValue]);
//echo "
tmpTg: $tmpTg";
if($tmpTg == $trunkgp)
{
$validPrefix[$valid_num][inst_no] = $enablePrefix[$prefix_no][inst_no];
$validPrefix[$valid_num][init_value] = $enablePrefix[$prefix_no][init_value];
$valid_num++;
}
$prefix_no++;
}
if($prefix_no >= $prefix_num)
break;
}
}
{//get prefix value
$oidstr = '2.1.1';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr and instanceNo<252
ORDER BY instanceNo
";
// echo "$paramSql";
$Result_1 = mysqli_query($pubConn,$paramSql);
$prefix_no=0;
while($Row_1 = mysqli_fetch_array($Result_1))
{
if($Row_1[instanceNo]==$validPrefix[$prefix_no][inst_no])
{
$tempprefix=strtoupper($Row_1[initValue]);
$prefix = explode('E',$tempprefix);
if($prefix[0] =="")
$prefix[0]="--";
$validPrefix[$prefix_no][prefix]=$prefix[0];
//echo "
validPrefix[$prefix_no][prefix]:{$validPrefix[$prefix_no][prefix]}";
$prefix_no++;
}
if($prefix_no >= $valid_num)
break;
}
}//end get prefix value
//------------显示prefix参数表---------------------
$n=$prefix_no;
$rowspan = $prefix_no +1;
if($prefix_no==0) $rowspan=2;
$setobjIdstr = "2.1.2-2.1.1-2.1.2";
$backurlprefix=$backurl;
echo "";
echo "";
echo "";
echo "| Prefix | ";
echo "+ | ";
echo "
";
echo " | ";
echo "";
echo "";
echo "";
echo "| No. | ";
echo "Prefix | ";
echo "TON-in | ";
echo "TON-out | ";
echo "Properties | ";
echo "Call Type | ";
//echo "CDR | ";
echo "Delete | ";
echo " ";
$TON_in = array('Spare','MSISDN','Unkown','NDD','IDD','Spare');
$TON_out = array('Spare','MSISDN','Unkown','NDD','IDD','Spare');
$Properties = array('Trunk','MSISDN','MSRN','MSC');
$callTypeArr= array('Normal Call','Emergency','MCT','VMS','IN');
if($n==0){
echo "| -- | ";
}
for($i=0;$i < $n;$i++)
{
$tmpInitValue = $validPrefix[$i][init_value];
$tmpInst = $validPrefix[$i][inst_no];
if($i>3)
echo "";
else
echo " ";
//echo " ";
echo "| $i | ";
$oTON_in = BinDec(getBitValue($tmpInitValue,'0.0-0.3'));
$oTON_out = BinDec(getBitValue($tmpInitValue,'0.4-0.7'));
$oProperties = BinDec(getBitValue($tmpInitValue,'10.2-10.3'));
$oCallType = BinDec(getBitValue($tmpInitValue,'10.4-10.6'));
$oCDR = BinDec(getBitValue($tmpInitValue,'10.0-10.0'));
$oCDR = ($oCDR) ? ("ON") : ("OFF");
$oRano = $validPrefix[$i][prefix];
echo "$oRano | ";
echo "$TON_in[$oTON_in] | ";
echo "$TON_out[$oTON_out] | ";
echo "$Properties[$oProperties] | ";
echo "$callTypeArr[$oCallType] | ";
echo " | ";
echo " ";
}
//==============the more and hide button===================
if($n>4)
{
echo "| More >> | ";
echo "| Hide >> | ";
}
echo " ";
echo " | ";
echo "
";
}
if($prefix_show )//show conv prefix in switch
{
$pubDb = "OMC_PUB";
//get default value of local prefix(conv prefix)
$net_paramConf ='OBJ_225.paramConf';
$net_paramTable ="OBJ_225.param_99";
$getsql = "select initValue from $net_paramConf where level_1 = '2' and level_2 = '8' and level_3 = '0'";
$conv_pre_def = @mysqli_query($pubConn,$getsql);
$conv_pre_def = @mysqli_fetch_array($conv_pre_def);
$conv_pre_def = $conv_pre_def[0];
echo mysqli_error($pubConn);
if($DEBUG) echo "conv_pre_def = $conv_pre_def
";
$objIdStr='no-2.8';
$sysId = '225_99_99';
$setname="Prefix manipulation";
$oidStr = '2.8.0';
$levelWhere = getLevelWhere($oidStr);
$getsql = "select initValue,instanceNo from $net_paramTable where $levelWhere and initValue!='$conv_pre_def'";
$result = @mysqli_query($pubConn,$getsql);
echo mysqli_error($pubConn);
$convNo=0;
$cmpName = "Info".$infoNo;
//===================get the ISDN name
$databases="OBJ_225";
$sqll="select instanceNo,initValue from param_99 where level_1=2 and level_2=11 ";
$resultt=@mysqli_query($pubConn,$sqll);
$rowss=@mysqli_fetch_array($resultt);
do
{
//======assign tg
$trunk_tmp=hexdec(getBitValue($rowss[initValue],'3.0-3.7'))+0;
if($trunk_tmp==$trunkgp)
{
//=======title
$title=getBitValue($rowss[initValue],'14.0-23.7');
$temp="";
for($num=0;$num<10;$num++)
{
$str=substr($title,$num*2,2);
$str=hexdec($str);
$str=chr($str);
$temp.=$str;
}
$title=$temp;
$ISDN_Name=$title;
break;
}
}while($rowss=mysqli_fetch_array($resultt));
$ISDN_Name=trim($ISDN_Name);
while($pre_row = @mysqli_fetch_array($result))
{
$nameFlag = trim(toAscii(getBitValue($pre_row[initValue],'35.0-42.7')));
if(strcmp($nameFlag,$ISDN_Name)==0)
{
$convPrefix[$convNo][initValue]=$pre_row[initValue];
$convPrefix[$convNo][inst_no] = $pre_row[instanceNo];
$prefix = getBitValue($pre_row[initValue],'00.0-15.7');
if($convPrefix != 0)
$prefix = toAscii($prefix);
else
$prefix = '--';
$addDigs = getBitValue($pre_row[initValue],'18.0-33.7');
if($addDigs != 0)
$addDigs = toAscii($addDigs);
else
$addDigs = '--';
$convPrefix[$convNo][prefix] = $prefix;
$convPrefix[$convNo][delLen] = hexdec(getBitValue($pre_row[initValue],'16.0-16.7'));
$convPrefix[$convNo][addLen] = hexdec(getBitValue($pre_row[initValue],'17.0-17.7'));
$convPrefix[$convNo][addDigs] = $addDigs;
$convPrefix[$convNo][valiLen] = hexdec(getBitValue($pre_row[initValue],'34.0-34.7'));
//echo "
convPrefix[$convNo][prefix]:{$convPrefix[$convNo][initValue]}";
$convNo++;
}
}//end while
$getsql = "select initValue,instanceNo from $net_paramTable where $levelWhere and initValue='$conv_pre_def'";
//echo "
getsql: $getsql;";
$result = @mysqli_query($pubConn,$getsql);
$Row = @mysqli_fetch_array($result);
$newConvInst=$Row[instanceNo];
$conv_nrow = $convNo + 1;
echo "";
echo "";
echo "";
echo "| Prefix manipulation | ";
echo "+ | ";
echo "
";
echo " | ";
echo "";
echo "";
echo " | ";
echo "
";
}
if($BSC_show)
{
{//LAC
$sysId = '322_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$oidstr = '2.2.6';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr
";
$Result = mysqli_query($pubConn,$paramSql);
$n=0;
while($Row = mysqli_fetch_array($Result))
{
$tempGp = hexdec(getBitValue($Row[initValue],'01.0-01.7'));
$tempFlag = hexdec(getBitValue($Row[initValue],'0.0-0.7'));
if( $tempFlag == 1 && $trunkgp == $tempGp)
{
$LAC_value[$n] = hexdec(getBitValue($Row[initValue],'02.0-03.7'));
$LAC_inst[$n] = $Row[instanceNo];
$LAC_pageType[$n] = hexdec(getBitValue($Row[initValue],'4.0-4.7'));
$n++;
}
}
$setobjIdstr = '2.2.6';
echo "";
echo "";
echo "";
echo "| LAC | ";
echo "+ | ";
echo "
| ";
echo "";
echo "";
echo " | ";
echo "
";
}//LAC end
{//BTS
$emFlagArr = array(
'Disable',
'By Cell',
'By LAC',
'By MSC'
);
$sysId = '322_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$oidstr = '2.2.7';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
//************get default value*************
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
$defRes = @mysqli_query($pubConn,$defSql);
$defRow = @mysqli_fetch_array($defRes);
$BTS_DefValue = $defRow[initValue];
if($DEBUG) echo "BTS_DefValue] = $BTS_DefValue";
//查找一个未用的Cell parameter，供新加bts时使用
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND initValue='$BTS_DefValue'
";
$Result = mysqli_query($pubConn,$paramSql);
$Row = mysqli_fetch_array($Result);
$newID = $Row[instanceNo];
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
WHERE subSysNo = '$subSysNo' AND $objWhereStr
";
$Result = mysqli_query($pubConn,$paramSql);
$num = 0;
while($Row = mysqli_fetch_array($Result))
{
$lacValue = hexdec(getBitValue($Row[initValue],'1.0-2.7'));
if($lacValue!=0)// $lacValue!=0 ?
{
for($j=0; $j";
echo "";
echo "";
echo "| Emergency call | ";
if(!isset($newID))
{
echo "+ | ";
}
elseif(sizeof($LAC_value)==0)
{
echo "+ | ";
}
else
{
echo "+ | ";
}
echo "
";
echo " | ";
echo "";
echo "";
echo " | ";
*/
//================Emergency call parameter (add 2007-6-5)==================
{
//=====get the default value of cell=================
$database="OBJ_322";
$sql="select initValue from paramConf where level_1=2 and level_2=2 and level_3=7 ";
$result=@mysqli_query($pubConn,$sql);
$rows=@mysqli_fetch_array($result);
$cell_default_value=$rows[initValue];
//=====get the count of cell================
$database="OBJ_322";
$sql="select initValue,instanceNo from param_99 where level_1=2 and level_2=2 and level_3=7 ";
$result=@mysqli_query($pubConn,$sql);
$rows=@mysqli_fetch_array($result);
$cell_count=0;
do
{
if($rows[initValue]==$cell_default_value)
continue;
else
{
//============store the parameter
$cell_instance_no[$cell_count]=$rows[instanceNo];
$cell_emergency_call_flag[$cell_count]=hexdec(getBitValue($rows[initValue],'0.0-0.7'))+0;
$cell_lac[$cell_count]=hexdec(getBitValue($rows[initValue],'1.0-2.7'))+0;
$cell_id[$cell_count]=hexdec(getBitValue($rows[initValue],'3.0-4.7'))+0;
$cell_prefix_index_number[$cell_count]=hexdec(getBitValue($rows[initValue],'5.0-5.7'))+0;
$prefix_instance_no_tmp=$cell_prefix_index_number[$cell_count];
{
$databasee="OBJ_322";
$sqll="select initValue,instanceNo from param_99 where level_1=2 and level_2=1 and level_3=1 and instanceNo=$prefix_instance_no_tmp ";
$resultt=@mysqli_query($pubConn,$sqll);
$rowss=@mysqli_fetch_array($resultt);
$cell_prefix_prefix[$cell_count]=str_replace("E","",$rowss[initValue]);
if($cell_prefix_prefix[$cell_count]=="")
$cell_prefix_prefix[$cell_count]="--";
}
$cell_local_emergency_number[$cell_count]=getBitValue($rows[initValue],'6.0-13.7');
$cell_regional_zone_flag[$cell_count]=hexdec(getBitValue($rows[initValue],'14.0-14.7'))+0;
$cell_zone_code[$cell_count]=hexdec(getBitValue($rows[initValue],'15.0-16.7'))+0;
//test
/*
{
echo "
";
echo "{$cell_instance_no[$cell_count]}
";
echo "----{$cell_emergency_call_flag[$cell_count]}
";
echo "----{$cell_lac[$cell_count]}
";
echo "----{$cell_id[$cell_count]}
";
echo "----{$cell_prefix_index_number[$cell_count]}
";
echo "----{$cell_local_emergency_number[$cell_count]}
";
echo "----{$cell_regional_zone_flag[$cell_count]}
";
echo "----{$cell_zone_code[$cell_count]}
";
}
*/
$cell_count++;
}
}while($rows=@mysqli_fetch_array($result));
//========get the unuse cell instanceNo======================
$database="OBJ_322";
$sql="select initValue,instanceNo from param_99 where level_1=2 and level_2=2 and level_3=7 ";
$result=@mysqli_query($pubConn,$sql);
$rows=@mysqli_fetch_array($result);
do
{
if($rows[initValue]==$cell_default_value)
{
$cell_unuse_instanceNo=$rows[instanceNo];
break;
}
}while($rows=@mysqli_fetch_array($result));
//=======================show====================
$u_t=$url_temp;
$url_temp=urlencode($url_temp);
echo "";
echo "| ";
$oper="new";
echo "Emergency Call+";
echo " | ";
echo "";
echo "";
echo " | ";
echo "
";
}
}
}
if($GTT_show)
{
$sysId = '222_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$oidstr = '2.4.1';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$selSql = "select initValue from $paramTable where $objWhereStr and instanceNo='$linkset' ";
$result = mysqli_query($pubConn,$selSql);
$row = mysqli_fetch_array($result);
$DPC = hexdec(getBitValue($row[initValue],'0.0-2.7'));
$NI = bindec(getBitValue($row[initValue],'3.0-3.1'));
//echo "$DPC,$NI";
{//GTT
$NetIdConfArr=array(
"0"=>"International",
"1"=>"International spare",
"2"=>"National",
"3"=>"National spare"
);
$numPlanArr = array(
"7" => "GT",
"6"=> "IMSI",
"1"=> "MSISDN",
"0"=> "0"
);
$sysId = '223_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
$oidstr = '2.2';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$selSql = "select initValue,instanceNo from $paramTable where $objWhereStr and initValue like '01%' ";
$result = mysqli_query($pubConn,$selSql);
$offsetAppType='00.0-00.7';
$offsetGrpNo = '01.0-01.7';
$offsetBitFlag = '02.0-02.7';//if '1', global title.
$niTypeArr = getNiType();
$n=0;
$m=0;
while($rows=mysqli_fetch_array($result))
{
$tmpDpc = hexdec(getBitValue($rows[initValue],'24.0-26.7'));
$tmpNi = hexdec(getBitValue($rows[initValue],'23.0-23.7'));
$SSN = hexdec(getBitValue($rows[initValue],'27.0-27.7'));
$TT = hexdec(getBitValue($rows[initValue],'2.0-2.7'));
if($tmpDpc==$DPC && $tmpNi==$NI)
{
{//get gtt attribution form 2.4
$selSql = "select initValue from OBJ_223.param_99 where level_1='2' and level_2='4' and instanceNo='$rows[instanceNo]'";
if(0)echo "
selSql:$selSql";
$tmpResult = mysqli_query($pubConn,$selSql);
$tmpRow = mysqli_fetch_array($tmpResult);
$tmpGrpNo = hexdec(getBitValue($tmpRow[initValue],$offsetGrpNo));
$tmpAppType = hexdec(getBitValue($tmpRow[initValue],$offsetAppType));
$bitFlag = hexdec(getBitValue($tmpRow[initValue],$offsetBitFlag));
}//end get gtt attribution
if($grpNo==$tmpGrpNo && $tmpAppType==$appType)
{
if(0)echo "
1: dpc=$tmpDpc, ni=$tmpNi, grpNo=$tmpGrpNo, ssn=$SSN,instanceNo={$rows[instanceNo]}";
$NP = hexdec(getBitValue($rows[initValue],'01.0-01.7'));
$tmpStart = getBitValue($rows[initValue],'3.0-12.7');
$tmpEnd = getBitValue($rows[initValue],'13.0-22.7');
$startGT = str_replace('F','',$tmpStart);
$endGT = str_replace('F','',$tmpEnd);
if(strlen($startGT)==0) $startGT='--';
if(strlen($endGT)==0) $endGT='--';
if($niTypeArr[$NI]==0)//ITU
{
$msisdnFlag = ($NP==1);
$imsiFlag = ($NP==6 || $NP==7);
}
else//ansi
{
$msisdnFlag = ($TT==14 || $TT==10);
$imsiFlag = ($TT==9);
}
if(0)echo "
np:$NP, tt:$TT, msisdnFlag:$msisdnFlag, imsiFlag:$imsiFlag";
switch($appType)
{
case '1'://hlr
{
if($bitFlag)
{
$globalTitle = $startGT;
$instNo = $rows[instanceNo];
$np = $NP;
$tt = $TT;
}
else
{
if($msisdnFlag)
{
$msisdnGTTArr[$n][np]=$NP;
$msisdnGTTArr[$n][tt]=$TT;
$msisdnGTTArr[$n][instanceNo] = $rows[instanceNo];
$msisdnGTTArr[$n][start] = $startGT;
$msisdnGTTArr[$n][end] = $endGT;
$n++;
}
if($imsiFlag)
{
$imsiGTTArr[$m][np] = $NP;
$imsiGTTArr[$m][tt] = $TT;
$imsiGTTArr[$m][instanceNo] = $rows[instanceNo];
$imsiGTTArr[$m][start] = $startGT;
$imsiGTTArr[$m][end] = $endGT;
$m++;
}
}
break;
}
case '5'://new Element
{
if($msisdnFlag)
{
$msisdnGTTArr[$n][np]=$NP;
$msisdnGTTArr[$n][tt]=$TT;
$msisdnGTTArr[$n][instanceNo] = $rows[instanceNo];
$msisdnGTTArr[$n][start] = $startGT;
$msisdnGTTArr[$n][end] = $endGT;
$n++;
}
if($imsiFlag)
{
$imsiGTTArr[$m][np] = $NP;
$imsiGTTArr[$m][tt] = $TT;
$imsiGTTArr[$m][instanceNo] = $rows[instanceNo];
$imsiGTTArr[$m][start] = $startGT;
$imsiGTTArr[$m][end] = $endGT;
$m++;
}
break;
}
case '2'://vlr
case '0'://msc
case '4'://sgsn
{
$globalTitle = $startGT;
$instNo = $rows[instanceNo];
$np = $NP;
$tt = $TT;
break;
}
case '3'://smsc
{
if($bitFlag)
{
$globalTitle = $startGT;
$instNo = $rows[instanceNo];
$np = $NP;
}
else
{
if($msisdnFlag)
{
$msisdnGTTArr[$n][np] = $NP;
$msisdnGTTArr[$n][tt] = $TT;
$msisdnGTTArr[$n][instanceNo] = $rows[instanceNo];
$msisdnGTTArr[$n][start] = $startGT;
$msisdnGTTArr[$n][end] = $endGT;
$n++;
}
}
break;
}
}
}
}
}
// echo "
gttSSN=$gttSSN, n=$n, m=$m";
{//show GTT
$setobjIdstr = "2.2-2.2";
if($appType != 5)
{
echo "";
echo "| $strE164Number | ";
echo "";
echo "";
echo "";
echo "| No. | ";
if($niTypeArr[$NI]==0)//ITU
echo "NP | ";
else
echo "TT | ";
echo "$strE164Number | ";
echo " | ";
echo "NI | ";
echo "DPC | ";
echo " | ";
echo " ";
echo "";
echo "| 0 | ";
if($niTypeArr[$NI]==0)//ITU
echo "MSISDN | ";
else
echo "$tt | ";
echo "$globalTitle | ";
echo " | ";
echo "{$NetIdConfArr[$NI]} | ";
echo "$DPC | ";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo "
";
}
//if($gttSSN==6 || $gttSSN==11)
if($appType==1 || $appType==3 || $appType==5)
{
$rowspan = $n+1;
echo "";
echo "";
echo "";
echo "| MSISDN | ";
echo "+ | ";
echo "
| ";
echo "";
echo "";
echo " | ";
echo "
";
//if($gttSSN==6)
if($appType==1 || $appType == 5)
{
$rowspan = $m+1;
echo "";
echo "";
echo "";
echo "| IMSI | ";
echo "+ | ";
echo "
| ";
echo "";
echo "";
echo " | ";
echo "
";
}
}
}//end show GTT
}//GTT
}
echo "![](\"../../images/left.gif\")
Back";
exit();
}
echo "";
}
if(2==$E1unlock){
$IdArr = explode('_',$delValue);
$delValue = $IdArr[0];
$AAS_E1ID = $IdArr[1];
$sysId = '322_99_99';
$sysIdArr = explode('_',$sysId);
$sysTypeNo = $sysIdArr[0];
$sysNo = $sysIdArr[1];
$subSysNo = $sysIdArr[2];
open8ke1Enable($delValue,1);
$oidstr = '2.4.4';
$objWhereStr= '';
$objWhereStr =getLevelWhere($oidstr);
$objDb = 'OBJ_'.$sysTypeNo;
$paramTable = 'param_'.$sysNo;
$defSql = " SELECT initValue FROM $paramTable WHERE $objWhereStr AND instanceNo='$delValue'";
$defRes = @mysqli_query($pubConn,$defSql);
$row = @mysqli_fetch_array($defRes);
$flagoffset = "00.1-00.1";
$row[initValue] = setBitValue($row[initValue],$flagoffset,'1');
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
// echo "$delSql