2707 lines
89 KiB
PHP
Executable File
2707 lines
89 KiB
PHP
Executable File
<?php
|
||
/***********************************************************
|
||
WXC2 SP configuration.
|
||
|
||
*********************************************************/
|
||
|
||
require("../sub_inc/commfunc.php");
|
||
//*****
|
||
$url_temp=$_SERVER["REQUEST_URI"];
|
||
//echo "This page URL:$url_temp<br>";
|
||
?>
|
||
|
||
<head>
|
||
<script language="Javascript">
|
||
//=======This function called when click the more and hide button=========================
|
||
//Parameter
|
||
//where:specify which buttons group of more and hide to click
|
||
//num:specify how many the elements for showing
|
||
//oper:specify which button to click,more or hide
|
||
function clickOnMoreHide(where,num,oper)
|
||
{
|
||
var cmd;
|
||
//to change the more button to hide button or reverse
|
||
if(oper=='show')
|
||
{
|
||
cmd="document.all.show"+where+".style.display='none'";
|
||
eval(cmd);
|
||
cmd="document.all.hide"+where+".style.display='block'";
|
||
eval(cmd);
|
||
for(var i=4;i<num;i++)
|
||
{
|
||
cmd="document.all."+where+i+".style.display='block'";
|
||
eval(cmd);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
cmd="document.all.show"+where+".style.display='block'";
|
||
eval(cmd);
|
||
cmd="document.all.hide"+where+".style.display='none'";
|
||
eval(cmd);
|
||
|
||
for(var i=4;i<num;i++)
|
||
{
|
||
cmd="document.all."+where+i+".style.display='none'";
|
||
eval(cmd);
|
||
}
|
||
}
|
||
}
|
||
|
||
function openSetPrefix(trunkgp,instanceNo,objIdStr,sysId,webname,setname,backurl)
|
||
{
|
||
y = document.body.scrollTop;
|
||
//backurl = backurl+'?scroll_y='+y;
|
||
backurl=escape(backurl);
|
||
//alert(backurl);
|
||
URL="../mss/paramconf.php?instanceNo="+instanceNo+"&trunkgp="+trunkgp+"&objIdStr="+objIdStr+"&sysId="+sysId+"&webname="+webname+"&setname="+setname+"&backurl="+backurl+"&sub_page_top="+y+"&from_bss=1";
|
||
window.location.href=URL;
|
||
}
|
||
</script>
|
||
</head>
|
||
<?php
|
||
$DEBUG = 0;
|
||
|
||
|
||
if(!isset($page_top))
|
||
$page_top=0;
|
||
//echo "page_top:$page_top<br>";
|
||
|
||
//==========================delete the cell=====================
|
||
if($delete_cell==1)
|
||
{
|
||
|
||
//=====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];
|
||
//===============delete
|
||
$updSql = "update param_99 set initValue='$cell_default_value' where level_1 =2 and level_2 =2 and level_3 =7 and instanceNo='$cell_instance_no_delete'";
|
||
mysqli_query($pubConn,$updSql);
|
||
echo mysqli_error($pubConn);
|
||
unset($delete_cell);
|
||
}
|
||
|
||
//==========================================================
|
||
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
||
//==========================================================
|
||
$pubDb = 'OMC_PUB';
|
||
$db = "OBJ_322";
|
||
$paramTable ='OBJ_322.param_99';
|
||
$SP_show = 0;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
$nSetComm = 3;
|
||
//$backurl<72><6C><EFBFBD><EFBFBD>ҳ<EFBFBD><D2B3><EFBFBD><EFBFBD>ת<EFBFBD>ǻص<C7BB><D8B5><EFBFBD>ȷ<EFBFBD><C8B7>ҳ<EFBFBD><D2B3>
|
||
$backurl =$PHP_SELF."?trunkgp=".$trunkgp.">t=".$gtt."&sysNo=".$sysNo."&infoNo=".$infoNo."&linkset=".$linkset.">tSSN=".$gttSSN."&grpNo=".$grpNo."&appType=".$appType;
|
||
|
||
//echo "$backurl<br>";
|
||
//Spname
|
||
//ȡ<>豸<EFBFBD><E8B1B8>,<2C><><EFBFBD><EFBFBD>
|
||
getElementInfo($infoNo,$elementInfoArr);
|
||
$this_sysNo = $TypeNo = $elementInfoArr[sysNo];
|
||
$TypeIn = $elementInfoArr[typeValue];
|
||
$eleName = $elementInfoArr[eleName];
|
||
$devicename = $elementInfoArr[typeName];
|
||
$webname = $elementInfoArr[webName];
|
||
|
||
if($DEBUG) echo "<br>trunkgp: $trunkgp; webname: $webname";
|
||
{//initial params
|
||
switch($devicename)
|
||
{
|
||
case 'BSC':
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 1;
|
||
$prefix_show = 0;
|
||
$E1_show = 1;
|
||
$BSC_show = 1;
|
||
$GTT_show = 0;
|
||
$oidsysarr=array(
|
||
array('oid'=>'2.1.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.3', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.2', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),//time 2,3s
|
||
array('oid'=>'2.1.1', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
|
||
array('oid'=>'2.4.1', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4.2', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4.3', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
|
||
array('oid'=>'2.2.6', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.2.7', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
|
||
array('oid'=>'2.5.1', 'sysid'=>'222_99_99', 'selectsysid'=>'-1'),
|
||
);
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=>'322_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=>'222_99_99','selectsysid'=>'-1')
|
||
);
|
||
if($trunkgp=="")
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
}
|
||
break;
|
||
}
|
||
case 'Peripheral':
|
||
{
|
||
if($webname=='CNF')
|
||
{
|
||
$this_sysNo = 0;
|
||
$this_subSysNo = $subSysNo;
|
||
$TypeNo = 0;
|
||
}
|
||
if($webname=='VSS')
|
||
{
|
||
$vssPrefix_show=1;
|
||
}
|
||
if($webname=='PCR')
|
||
{
|
||
$pcrPrefix_show=1;
|
||
}
|
||
$SP_show = 1;
|
||
$TG_show = 1;
|
||
$prefix_show = 0;
|
||
$E1_show = 1;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
$aasMtp3_sysId = "222_11_".$TypeNo;
|
||
$vssMtp3_sysId = "222_8_".$TypeNo;
|
||
$vssSCCP_sysId = "223_8_".$TypeNo;
|
||
$oidsysarr=array(
|
||
array('oid'=>'2.1.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.5.1', 'sysid'=>'222_99_99', 'selectsysid'=>'-1'),
|
||
);
|
||
$oidAASarr=array(
|
||
array('oid'=>'2.5.1', 'sysid'=> $aasMtp3_sysId, 'selectsysid'=>'-1' ),
|
||
);
|
||
$oidVSSarr=array(
|
||
array('oid'=>'2.5.1', 'sysid'=> $vssMtp3_sysId, 'selectsysid'=> '-1'),
|
||
array('oid'=>'2.1.8', 'sysid'=> $vssSCCP_sysId, 'selectsysid'=> '-1'),
|
||
array('oid'=>'2.1.1', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.2', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.3', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
|
||
array('oid'=>'2.2', 'sysid'=>'223_99_99', 'selectsysid'=>'-1'),
|
||
);
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=>'322_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=>'222_99_99','selectsysid'=>'-1'),
|
||
);
|
||
if($webname=='AAS')
|
||
{
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=>'322_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=>'222_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=> $aasMtp3_sysId,'selectsysid'=> '-1'),
|
||
);
|
||
}
|
||
if($webname=='VSS')
|
||
{
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=>'322_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=>'222_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=> $vssMtp3_sysId,'selectsysid'=> '-1'),
|
||
array('oidstr'=>'3.2', 'setvalue'=>'02' ,'sysid'=>'223_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.2', 'setvalue'=>'02' ,'sysid'=> $vssSCCP_sysId,'selectsysid'=> '-1'),
|
||
);
|
||
}
|
||
if($trunkgp=="")
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
}
|
||
break;
|
||
}
|
||
case 'Switch':
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 1;
|
||
$prefix_show = 1;
|
||
$E1_show = 1;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
$oidsysarr=array(
|
||
array('oid'=>'2.1.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.3', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.2', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.1', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4', 'sysid'=>'322_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.5.1', 'sysid'=>'222_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.8.0', 'sysid'=>'225_99_99', 'selectsysid'=>'-1'),
|
||
);
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=>'222_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=>'322_99_99','selectsysid'=>'-1'),
|
||
array('oidstr'=>'3.2', 'setvalue'=>'01' ,'sysid'=>'225_99_99'),//XAPP
|
||
);
|
||
|
||
if($trunkgp=="")
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
}
|
||
break;
|
||
}
|
||
|
||
case $strGttObjects:
|
||
{
|
||
$SP_show = 1;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 1;
|
||
$oidsysarr=array(
|
||
array('oid'=>'2.2', 'sysid'=>'223_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.4', 'sysid'=>'223_99_99', 'selectsysid'=>'-1'),
|
||
array('oid'=>'2.1.12', 'sysid'=>'330_99_99', 'selectsysid'=>'-1')
|
||
);
|
||
$SaveArr=array(
|
||
array('oidstr'=>'3.2', 'setvalue'=>'02' ,'sysid'=>'223_99_99','selectsysid'=>'-1'),
|
||
);
|
||
break;
|
||
}
|
||
|
||
default:
|
||
{
|
||
$SP_show = 0;
|
||
$TG_show = 0;
|
||
$prefix_show = 0;
|
||
$E1_show = 0;
|
||
$BSC_show = 0;
|
||
$GTT_show = 0;
|
||
break;
|
||
}
|
||
}
|
||
}//end initial params
|
||
|
||
if($webname=='CNF')
|
||
$Spname = $Spname;
|
||
if($webname=='PCR')
|
||
$Spname = "$Spname-$this_sysNo-$this_subSysNo";
|
||
else
|
||
$Spname = $Spname."$TypeNo";
|
||
|
||
|
||
$sysId ='322_99_99';
|
||
|
||
$NetIdConfArr=array('International','International-S','National','National-S');
|
||
|
||
//==========================================================
|
||
//<2F><><EFBFBD>ݴ<EFBFBD><DDB4><EFBFBD>
|
||
//==========================================================
|
||
?>
|
||
|
||
|
||
<script LANGUAGE="JavaScript">
|
||
function delFirm(No,deltype,trunkgp,linkset,delcheckbox){
|
||
var delValue,x,y;
|
||
x = document.body.scrollLeft;
|
||
y = document.body.scrollTop;
|
||
|
||
if(confirm('Do you want to delete the selected?')!=true)
|
||
{
|
||
/*window.location.href='<?php echo $PHP_SELF;?>'+"?trunkgp="+trunkgp+"&linkset="+linkset;*/
|
||
delcheckbox.checked=false;
|
||
}
|
||
else
|
||
{
|
||
if(deltype == 'E1')
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&E1del=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
if(deltype == 'prefix')
|
||
{
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&prefixdel=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
if(deltype == 'convPrefix')
|
||
{
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&convPrefixDel=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
if(deltype == 'BTS')
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&BTSdel=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
if(deltype == 'GTT')
|
||
{
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo>tSSN=$gttSSN&grpNo=$grpNo&appType=$appType";?>>Tdel=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
if(deltype == 'LAC')
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&lacdel=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
}
|
||
|
||
function lockFirm(No,deltype,trunkgp,linkset,delcheckbox){
|
||
var delValue,x,y;
|
||
x = document.body.scrollLeft;
|
||
y = document.body.scrollTop;
|
||
|
||
if(deltype == 'E1lock')
|
||
{
|
||
if(confirm('Do you want to Lock the E1?')==true)
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&E1lock=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
if(deltype == 'E1unlock')
|
||
{
|
||
if(confirm('Do you want to Unlock the E1?')==true)
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&E1unlock=1&delValue='+No+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
|
||
}
|
||
|
||
function openSetConv(instanceNo,objIdStr,sysId,webname,setname,backurl,infoNo,trunkgp)
|
||
{
|
||
y = document.body.scrollTop;
|
||
backurl = backurl+'?scroll_y='+y;
|
||
backurl=escape(backurl);
|
||
|
||
URL="../mss/paramconf.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&objIdStr="+objIdStr+"&sysId="+sysId+"&webname="+webname+"&setname="+setname+"&backurl="+backurl+"&trunkgp="+trunkgp;
|
||
window.location.href=URL;
|
||
}
|
||
|
||
function openSetGTT(np,instanceNo,appType,bitFlag,ssn,linkset,grpNo,backurl)
|
||
{
|
||
backurl=escape(backurl);
|
||
url1 = '<?PHP echo "./gtt_edit.php?eleName=$eleName";?>';
|
||
URL=url1 + "&instanceNo="+instanceNo+"&appType="+appType+"&NP="+np+"&bitFlag="+bitFlag+"&SSN="+ssn+"&linkset="+linkset+"&grpNo="+grpNo+"&backurl="+backurl;
|
||
window.location.href=URL;
|
||
}
|
||
function openSet(objIdStr,instanceNo,setname,sysId,tg,linkset,webname,backurl,infoNo)
|
||
{
|
||
setname=escape(setname);
|
||
backurl=escape(backurl);
|
||
if(setname == 'LAC')
|
||
URL="./LACconf.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&pageType="+objIdStr+"&sysId="+sysId+"&setname="+setname+"&trunkgp="+tg+"&linkset="+linkset+"&backurl="+backurl;
|
||
else if(setname == 'E1channel')
|
||
URL="./E1channelEdit.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&Protocol="+sysId+"&trunkgp="+tg+"&linkset="+linkset+"&webname="+webname+"&backurl="+backurl;
|
||
else if(setname == 'GTT')
|
||
URL="./gtt_edit.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&NP="+objIdStr+"&bitFlag="+sysId+"&SSN="+tg+"&linkset="+linkset+"&grpNo="+webname+"&backurl="+backurl;
|
||
else if(setname == 'E1')
|
||
URL="./E1connectconf.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&cicflag="+objIdStr+"&ctrflag="+sysId+"&webname="+webname+"&trunkgp="+tg+"&linkset="+linkset+"&backurl="+backurl;
|
||
else
|
||
URL="./paramconf.php?infoNo="+infoNo+"&instanceNo="+instanceNo+"&objIdStr="+objIdStr+"&sysId="+sysId+"&setname="+setname+"&trunkgp="+tg+"&linkset="+linkset+"&webname="+webname+"&backurl="+backurl;
|
||
window.location.href=URL;
|
||
}
|
||
|
||
//===============delete the cell (add 2007-6-5)
|
||
function delete_cell(item,instanceNo,trunkgp,linkset)
|
||
{
|
||
//No,deltype,trunkgp,linkset,delcheckbox
|
||
var result;
|
||
result=confirm("Do you want to delete the selected?");
|
||
if(result==1)
|
||
{
|
||
window.location.href='<?php echo $PHP_SELF."?infoNo=$infoNo";?>&delete_cell=1&cell_instance_no_delete='+instanceNo+"&trunkgp="+trunkgp+"&linkset="+linkset;
|
||
}
|
||
else
|
||
{
|
||
item.checked=0;
|
||
return
|
||
}
|
||
}
|
||
|
||
</script>
|
||
|
||
<?php
|
||
if($_SERVER['REQUEST_METHOD'] == "POST")
|
||
{
|
||
if(isset($setSys) || isset($getSys))
|
||
{
|
||
if(isset($setSys))
|
||
{
|
||
echo "<br>Setting parameters<br>";
|
||
//========set the parameter for 8kboard (2007-6-5)=====================================
|
||
$database="OMC_PUB";
|
||
$sql="select sysNo from sysInfo where sysNo=0 and sysTypeNo=111 ";
|
||
$result=@mysqli_query($pubConn,$sql);
|
||
$rows=@mysqli_fetch_array($result);
|
||
if($rows[sysNo]==0)
|
||
$OidArr_8ke1[]=array('oid'=>'2.8', 'sysid'=>'111_0_99', 'selectsysid'=> '-1');
|
||
|
||
$database="OMC_PUB";
|
||
$sql="select sysNo from sysInfo where sysNo=1 and sysTypeNo=111 ";
|
||
$result=@mysqli_query($pubConn,$sql);
|
||
$rows=@mysqli_fetch_array($result);
|
||
if($rows[sysNo]==1)
|
||
$OidArr_8ke1[]=array('oid'=>'2.8', 'sysid'=>'111_1_99', 'selectsysid'=> '-1');
|
||
SetParam($OidArr_8ke1);
|
||
//===============================================================================
|
||
|
||
|
||
if($TypeIn ==2)
|
||
{
|
||
SetParam($oidAASarr);
|
||
}
|
||
if($TypeIn ==3)
|
||
{
|
||
SetParam($oidVSSarr);
|
||
}
|
||
|
||
if($devicename!=$strGttObjects)
|
||
{
|
||
set_e1channel($trunkgp);
|
||
}
|
||
|
||
SetParam($oidsysarr);
|
||
|
||
SaveParam($SaveArr);
|
||
|
||
}
|
||
else
|
||
{
|
||
echo "<br>Getting parameters<br>";
|
||
|
||
//========get the parameter for 8kboard (2007-6-5)=====================================
|
||
$database="OMC_PUB";
|
||
$sql="select sysNo from sysInfo where sysNo=0 and sysTypeNo=111 ";
|
||
$result=@mysqli_query($pubConn,$sql);
|
||
$rows=@mysqli_fetch_array($result);
|
||
if($rows[sysNo]==0)
|
||
$OidArr_8ke1[]=array('oid'=>'2.8', 'sysid'=>'111_0_99', 'selectsysid'=> '-1');
|
||
|
||
$database="OMC_PUB";
|
||
$sql="select sysNo from sysInfo where sysNo=1 and sysTypeNo=111 ";
|
||
$result=@mysqli_query($pubConn,$sql);
|
||
$rows=@mysqli_fetch_array($result);
|
||
if($rows[sysNo]==1)
|
||
$OidArr_8ke1[]=array('oid'=>'2.8', 'sysid'=>'111_1_99', 'selectsysid'=> '-1');
|
||
GetParam($OidArr_8ke1);
|
||
//===============================================================================
|
||
|
||
if($TypeIn ==2)
|
||
{
|
||
GetParam($oidAASarr);
|
||
}
|
||
if($TypeIn ==3)
|
||
{
|
||
GetParam($oidVSSarr);
|
||
}
|
||
if($devicename!=$strGttObjects)
|
||
{
|
||
get_e1channel($trunkgp);
|
||
}
|
||
GetParam($oidsysarr);
|
||
|
||
}
|
||
}
|
||
}
|
||
|
||
if(1==$prefixdel)
|
||
{
|
||
if($thisUsedRa==''&&$otherUsedRa=='')//delete it
|
||
{
|
||
$sysId = '322_99_99';
|
||
|
||
$sysIdArr = explode('_',$sysId);
|
||
$sysTypeNo = $sysIdArr[0];
|
||
$sysNo = $sysIdArr[1];
|
||
$subSysNo = $sysIdArr[2];
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$oidstr = '2.1.2';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
|
||
$flagoffset = "10.7-10.7";
|
||
$row[initValue] = setBitValue($row[initValue],$flagoffset,0);
|
||
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
if($DEBUG) echo "<br>delSql=$delSql";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
|
||
$oidstr = '2.1.1';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
if($DEBUG) echo "<br>delSql=$delSql";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
|
||
$oidstr = '2.1.3';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
if($DEBUG) echo "<br>delSql=$delSql";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
}
|
||
if($thisUsedRa!='')//set used RA part to default value
|
||
{
|
||
$thisUsedRaArr=explode(",", $thisUsedRa);
|
||
for($i=0; $i<sizeof($thisUsedRaArr); $i++)
|
||
{
|
||
if($thisUsedRaArr[$i]=='Default')
|
||
$thisUsedRaArr[$i] = 32;
|
||
}
|
||
{
|
||
$sysId = '322_99_99';
|
||
$sysIdArr = explode('_',$sysId);
|
||
$sysTypeNo = $sysIdArr[0];
|
||
$sysNo = $sysIdArr[1];
|
||
$subSysNo = $sysIdArr[2];
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$oidstr = '2.1.3';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
|
||
WHERE $objWhereStr AND instanceNo ='$delValue'
|
||
";
|
||
|
||
$Result = mysqli_query($pubConn,$paramSql);
|
||
$Row = mysqli_fetch_array($Result);
|
||
|
||
$RAoffsetarr = array(
|
||
"0.0-0.7","2.0-2.7","4.0-4.7","6.0-6.7",
|
||
"8.0-8.7","10.0-10.7","12.0-12.7","14.0-14.7",
|
||
"16.0-16.7","18.0-18.7","20.0-20.7","22.0-22.7",
|
||
"24.0-24.7","26.0-26.7","28.0-28.7","30.0-30.7",
|
||
"32.0-32.7","34.0-34.7","36.0-36.7","38.0-38.7",
|
||
"40.0-40.7","42.0-42.7","44.0-44.7","46.0-46.7",
|
||
"48.0-48.7","50.0-50.7","52.0-52.7","54.0-54.7",
|
||
"56.0-56.7","58.0-58.7","60.0-60.7","62.0-62.7",
|
||
"64.0-64.7");
|
||
$CToffsetarr = array(
|
||
"1.0-1.7","3.0-3.7","5.0-5.7","7.0-7.7",
|
||
"9.0-9.7","11.0-11.7","13.0-13.7","15.0-15.7",
|
||
"17.0-17.7","19.0-19.7","21.0-21.7","23.0-23.7",
|
||
"25.0-25.7","27.0-27.7","29.0-29.7","31.0-31.7",
|
||
"33.0-33.7","35.0-35.7","37.0-37.7","39.0-39.7",
|
||
"41.0-41.7","43.0-43.7","45.0-45.7","47.0-47.7",
|
||
"49.0-49.7","51.0-51.7","53.0-53.7","55.0-55.7",
|
||
"57.0-57.7","59.0-59.7","61.0-61.7","63.0-63.7",
|
||
"65.0-65.7");
|
||
|
||
$hex_set_tg = 'EE';
|
||
$hex_set_ct = '00';
|
||
for($j=0; $j< sizeof($thisUsedRaArr); $j++)
|
||
{
|
||
for($i=0; $i<33; $i++)
|
||
{
|
||
if($i==$thisUsedRaArr[$j])
|
||
{
|
||
$Row[initValue] = setBitValue($Row[initValue],$RAoffsetarr[$i],$hex_set_tg);
|
||
$Row[initValue] = setBitValue($Row[initValue],$CToffsetarr[$i],$hex_set_ct);
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
|
||
$Row[initValue] = strtoupper($Row[initValue]);
|
||
$updSql = "UPDATE $paramTable SET initValue = '$Row[initValue]'
|
||
WHERE $objWhereStr AND instanceNo = '$delValue'";
|
||
//echo $updSql;
|
||
mysqli_query($pubConn,$updSql);
|
||
}
|
||
}
|
||
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo "\n window.location.href=\"$backurl\";";
|
||
echo "\n </script>";
|
||
exit();
|
||
}
|
||
if(1==$convPrefixDel)
|
||
{
|
||
$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<br>";
|
||
|
||
$updSql = "update $net_paramTable set initValue='$conv_pre_def' where level_1 = '2' and level_2 = '8' and level_3 = '0' and instanceNo='$delValue'";
|
||
mysqli_query($pubConn,$updSql);
|
||
}
|
||
|
||
if(1==$E1del)//ɾ<><C9BE>E1connectʱ<74><CAB1>ɾ<EFBFBD><C9BE><EFBFBD><EFBFBD>ͬ<EFBFBD><CDAC><EFBFBD>ŵ<EFBFBD>E1 link
|
||
{
|
||
$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];
|
||
|
||
$oidstr = '2.4.4';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
|
||
$oidstr = '2.4.3';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
|
||
$oidstr = '2.4.2';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
|
||
$oidstr = '2.4.1';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
|
||
{//close 8ke1 enable, crc4flag
|
||
open8ke1Enable($delValue,0);
|
||
open8ke1CRC4Flag($delValue,0);
|
||
}//end close
|
||
|
||
$sysId = '222_99_99';
|
||
$sysIdArr = explode('_',$sysId);
|
||
$sysTypeNo = $sysIdArr[0];
|
||
$sysNo = $sysIdArr[1];
|
||
$subSysNo = $sysIdArr[2];
|
||
|
||
$E1link_oidstr = '2.5.1';
|
||
$E1link_objWhereStr= '';
|
||
$E1link_objWhereStr =getLevelWhere($E1link_oidstr);
|
||
|
||
|
||
$E1link_objDb = 'OBJ_'.$sysTypeNo;
|
||
$E1link_paramTable = 'param_'.$sysNo;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $E1link_objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
|
||
if($TypeIn == 3)//added by arwean 2006-03-30
|
||
{
|
||
$selSql = "select initValue from $paramTable where $E1link_objWhereStr and instanceNo='$delValue' ";
|
||
$result = @mysqli_query($pubConn,$selSql);
|
||
$rowFind = @mysqli_fetch_array($result);
|
||
//MTP3_8_pub
|
||
$VSS_MTP3Table = 'param_8';
|
||
$selSql = "select initValue,instanceNo from $VSS_MTP3Table where $E1link_objWhereStr and initValue!='$row[initValue]'";
|
||
$result = @mysqli_query($pubConn,$selSql);
|
||
if(0)
|
||
{
|
||
echo "<br>selSql: $selSql";
|
||
echo mysqli_num_rows($result);
|
||
exit;
|
||
}
|
||
while($Row_1=@mysqli_fetch_array($result))
|
||
{
|
||
if($Row_1[initValue]==$rowFind[initValue])
|
||
{
|
||
$delSql = "UPDATE $VSS_MTP3Table SET initValue = '$row[initValue]'
|
||
WHERE $E1link_objWhereStr AND instanceNo='$Row_1[instanceNo]'";
|
||
if(0)
|
||
{
|
||
echo "<br>delSql: $delSql";
|
||
exit;
|
||
}
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
break;
|
||
}
|
||
}
|
||
}//end if
|
||
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE $E1link_objWhereStr AND instanceNo='$delValue'";
|
||
// echo "<br>delSql=$delSql";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
|
||
if($TypeIn == 2)
|
||
{
|
||
//MTP3_11_pub
|
||
$AAS_MTP3Table = 'param_11';
|
||
$delSql = "UPDATE $AAS_MTP3Table SET initValue = '$row[initValue]'
|
||
WHERE $E1link_objWhereStr AND instanceNo='$AAS_E1ID'";
|
||
// echo "<br>delSql=$delSql";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
}
|
||
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo "\n window.location.href=\"$backurl\";";
|
||
echo "\n </script>";
|
||
exit();
|
||
}
|
||
|
||
if(1==$BTSdel)
|
||
{
|
||
$sysId = '322_99_99';
|
||
|
||
$sysIdArr = explode('_',$sysId);
|
||
$sysTypeNo = $sysIdArr[0];
|
||
$sysNo = $sysIdArr[1];
|
||
$subSysNo = $sysIdArr[2];
|
||
|
||
$oidstr = '2.2.7';
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$paramSql = " SELECT initValue,instanceNo FROM $paramTable
|
||
WHERE $objWhereStr AND instanceNo ='$delValue'
|
||
";
|
||
$Result = mysqli_query($pubConn,$paramSql);
|
||
$Row = mysqli_fetch_array($Result);
|
||
$delPrefixNo = hexdec(getBitValue($Row[initValue],'5.0-5.7'));
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$defCellValue = $row[initValue];
|
||
$delSql = "UPDATE $paramTable SET initValue = '$defCellValue'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
|
||
{//delete the delPrefixNo if there is no other cells use it.
|
||
$paramSql = " SELECT initValue FROM $paramTable
|
||
WHERE $objWhereStr and initValue!='$defCellValue' ";
|
||
$result = mysqli_query($pubConn,$paramSql);
|
||
$otherUsed=0;
|
||
while($row = mysqli_fetch_array($result))
|
||
{
|
||
$prefixNo=hexdec(getBitValue($row[initValue],'5.0-5.7'));
|
||
if($prefixNo==$delPrefixNo)
|
||
{
|
||
$otherUsed=1;
|
||
break;
|
||
}
|
||
}
|
||
if($otherUsed==0)//delete $delPrefixNo.
|
||
{
|
||
$tmpParamConfTable='paramConf';
|
||
$tmpObjIdStr='2.1';
|
||
$levelWhere = getLevelWhere($tmpObjIdStr);
|
||
if($DEBUG) echo "<BR>levelWhere=$levelWhere";
|
||
|
||
$getSql="SELECT initValue,level_3 FROM $tmpParamConfTable
|
||
WHERE $levelWhere AND (level_3='1' OR level_3='2' OR level_3='3') ORDER BY level_3
|
||
";
|
||
if($DEBUG) echo "<BR>getSql=$getSql";
|
||
$result =mysqli_query($pubConn,$getSql);
|
||
echo mysqli_error($pubConn);
|
||
$i=0;
|
||
unset($tmpDefaultValueArr);
|
||
while($rows=mysqli_fetch_array($result)){
|
||
if($DEBUG)
|
||
echo "<BR>initValue=$rows[initValue]";
|
||
$tmpDefaultValueArr[$i][initValue]=$rows[initValue];
|
||
//echo "<BR>level_3=$rows[level_3]";
|
||
$tmpDefaultValueArr[$i][level_3]=$rows[level_3];
|
||
$i++;
|
||
}
|
||
if($DEBUG) echo "<BR>$aasprefixArr<br>";
|
||
|
||
for($i=0;$i<sizeof($tmpDefaultValueArr);$i++)
|
||
{
|
||
$updateSql="UPDATE OBJ_322.param_99 SET
|
||
initValue='{$tmpDefaultValueArr[$i][initValue]}'
|
||
WHERE $levelWhere AND level_3='{$tmpDefaultValueArr[$i][level_3]}' AND (instanceNo='$delPrefixNo'";
|
||
for($j=1;$j<sizeof($tmpInstanceNoArr);$j++){
|
||
$updateSql=$updateSql." OR instanceNo='".$tmpInstanceNoArr[$j]."'";
|
||
}
|
||
$updateSql=$updateSql.")";
|
||
if($DEBUG) echo "<BR>updateSql=$updateSql";
|
||
mysqli_query($pubConn,$updateSql);
|
||
echo mysqli_error($pubConn);
|
||
}
|
||
// exit;
|
||
}
|
||
}
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo "\n window.location.href=\"$backurl\";";
|
||
echo "\n </script>";
|
||
exit();
|
||
}
|
||
|
||
if(1==$GTTdel)
|
||
{
|
||
$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;
|
||
|
||
$defSql = " SELECT initValue FROM paramConf WHERE $objWhereStr";
|
||
$defRes = @mysqli_query($pubConn,$defSql);
|
||
$row = @mysqli_fetch_array($defRes);
|
||
$flagoffset = "00.0-00.7";
|
||
$row[initValue] = setBitValue($row[initValue],$flagoffset,'00');
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo "\n window.location.href=\"$backurl\";";
|
||
echo "\n </script>";
|
||
exit();
|
||
}
|
||
|
||
if(1==$lacdel)
|
||
{
|
||
$objDb = 'OBJ_322';
|
||
$objIdStr = '2.2.6';
|
||
$objWhereStr =getLevelWhere($objIdStr);
|
||
$paramTable = 'param_99';
|
||
$updSql = "UPDATE $paramTable SET initValue = '0000000000'
|
||
WHERE $objWhereStr AND instanceNo = '$delValue'
|
||
";
|
||
if($DEBUG) echo "$updSql<br>";
|
||
mysqli_query($pubConn,$updSql);
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo "\n window.location.href=\"$backurl\";";
|
||
echo "\n </script>";
|
||
exit();
|
||
}
|
||
|
||
if((1==$E1lock)||(1==$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];
|
||
if(1==$E1lock) $set_value=0;
|
||
if(1==$E1unlock)$set_value=1;
|
||
open8ke1Enable($delValue,$set_value);
|
||
|
||
$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,$set_value);
|
||
$delSql = "UPDATE $paramTable SET initValue = '$row[initValue]'
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND instanceNo='$delValue'";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
$commIdStr =oidSysCommSend($sysId,$nSetComm,$oidstr);
|
||
if($commIdStr=='-1')
|
||
{
|
||
DelComm($commArr);
|
||
echo "<br><br><b>Error while getting/setting parameters. Please check the device state!<br>";
|
||
echo "oidSysCommSend($tmpSysId,$nSetComm,$tmpObjIdStr)<br>";
|
||
echo "<p align=\"left\"><a href=\"JavaScript:history.go(-1)\"><img align=absBottom border=0 src=\"../../images/left.gif\" width=\"14\" height=\"14\">Back</a>";
|
||
exit();
|
||
}
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo " location='$PHP_SELF?trunkgp=$trunkgp>t=$gtt&sysNo=$sysNo&infoNo=$infoNo&linkset=$linkset>tSSN=$gttSSN&grpNo=$grpNo&appType=$appType';";
|
||
echo "</script>";
|
||
}
|
||
|
||
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<br>";
|
||
$delRes = @mysqli_query($pubConn,$delSql);
|
||
echo mysqli_error($pubConn);
|
||
$commIdStr =oidSysCommSend($sysId,$nSetComm,$oidstr);
|
||
if($commIdStr=='-1')
|
||
{
|
||
DelComm($commArr);
|
||
echo "<br><br><b>Error while getting/setting parameters. Please check the device state!<br>";
|
||
echo "oidSysCommSend($tmpSysId,$nSetComm,$tmpObjIdStr)<br>";
|
||
echo "<p align=\"left\"><a href=\"JavaScript:history.go(-1)\"><img align=absBottom border=0 src=\"../../images/left.gif\" width=\"14\" height=\"14\">Back</a>";
|
||
exit();
|
||
}
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo " location='$PHP_SELF?trunkgp=$trunkgp>t=$gtt&sysNo=$sysNo&infoNo=$infoNo&linkset=$linkset>tSSN=$gttSSN&grpNo=$grpNo&appType=$appType';";
|
||
echo "</script>";
|
||
}
|
||
if($setSys || $getSys || $undoSet)
|
||
{
|
||
echo "<br><br><h4><font color=\"#0000ff\">Finished!</font></h4>";
|
||
if($DEBUG) exit();
|
||
//sleep(1);
|
||
echo "<script LANGUAGE=\"JavaScript\">";
|
||
echo " location='$PHP_SELF?trunkgp=$trunkgp>t=$gtt&sysNo=$sysNo&infoNo=$infoNo&linkset=$linkset>tSSN=$gttSSN&grpNo=$grpNo&appType=$appType';";
|
||
echo "</script>";
|
||
exit();
|
||
}
|
||
|
||
//==========================================================
|
||
//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD>
|
||
//==========================================================
|
||
?>
|
||
|
||
<body topmargin="0" leftmargin="12">
|
||
<?php
|
||
if(!isset($linkset))
|
||
{
|
||
if(!isset($linkset))
|
||
echo "<font><b>ERROR!!:linkset == NULL</b></font><br>";
|
||
exit(0);
|
||
}
|
||
echo "<form method=\"POST\" name=\"setForm\" action=\"$PHP_SELF?infoNo=$infoNo&trunkgp=$trunkgp&linkset=$linkset>tSSN=$gttSSN&grpNo=$grpNo\">";
|
||
{
|
||
echo "<table border=\"0\" width=\"100%\">";
|
||
echo "<tr>";
|
||
echo "<td width=\"50%\">";
|
||
if($TypeIn==17)
|
||
echo "Configuration > <a href=\"../overview/overview.php\">Network</a> > <a href=\"#\">$webname</a>";
|
||
else
|
||
echo "Configuration > <a href=\"../overview/overview.php\">Network</a> > <a href=\"#\">$devicename</a>";
|
||
echo "</td>";
|
||
echo "<td width=\"50%\" align=\"right\" title=\"Help\">";
|
||
switch ($devicename)
|
||
{
|
||
case 'Switch':
|
||
$helpId='2.32';
|
||
break;
|
||
case 'BSC':
|
||
$helpId='2.31';
|
||
break;
|
||
case 'Peripheral':
|
||
{
|
||
switch($webname)
|
||
{
|
||
case 'PCR':
|
||
$helpId='2.1.3.3';
|
||
break;
|
||
case 'AAS':
|
||
$helpId='2.1.3.1';
|
||
break;
|
||
case 'VSS':
|
||
$helpId='2.1.3.2';
|
||
break;
|
||
case 'CNF':
|
||
$helpId='2.1.3.4';
|
||
break;
|
||
default:
|
||
$helpId='2';
|
||
break;
|
||
}
|
||
break;
|
||
}
|
||
default:
|
||
$helpId='2';
|
||
break;
|
||
}
|
||
if($devicename!=$strGttObjects)
|
||
showHelp($helpId);
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
echo "</table>";
|
||
echo "<br>";
|
||
|
||
{
|
||
echo "<table width=\"100%\">";
|
||
echo "<tr>";
|
||
echo "<td width=\"70%\">";
|
||
echo "<b></b>";
|
||
echo "</td>";
|
||
echo "<td width=\"20%\" align=\"right\">";
|
||
echo "<input type=\"submit\" title=\"$strTitleGet\" name=\"getSys\" value=\"$strGet\" class=\"button\" style=\"cursor:pointer; left: 1; top: 2; width: 60; height: 25; position: relative\">";
|
||
echo " ";
|
||
echo "<input type=\"submit\" title=\"$strTitleSet\" name=\"setSys\" value=\"$strSet\" class=\"button\" style=\"cursor:pointer; left: 1; top: 2; width: 60; height: 25; position: relative\">";
|
||
echo "</td>";
|
||
echo "<td width=\"10%\">";
|
||
echo "<p align=\"right\"><a href=\"javascript:backpage(0,'../overview/overview.php?scroll_y=$page_top')\"><img align=absBottom border=0 src=\"../../images/left.gif\" width=\"14\" height=\"14\">$strBack</a>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
echo "<input type=\"hidden\" name=\"linkset\" value=\"$linkset\">";
|
||
echo "<input type=\"hidden\" name=\"trunkgp\" value=\"$trunkgp\">";
|
||
echo "<input type=\"hidden\" name=\"sysNo\" value=\"$sysNo\">";
|
||
echo "<input type=\"hidden\" name=\"grpNo\" value=\"$grpNo\">";
|
||
echo "<input type=\"hidden\" name=\"appType\" value=\"$appType\">";
|
||
echo "<input type=\"hidden\" name=\"infoNo\" value=\"$infoNo\">";
|
||
|
||
echo "</table>";
|
||
echo "<br>";
|
||
}
|
||
}
|
||
echo "<table rules=rows border=\"1\" width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666666\" bordercolordark=\"#FFFFFF\">";
|
||
|
||
if($SP_show)
|
||
{
|
||
if($TypeIn==17)//ISDN Switch
|
||
{
|
||
$oidstr = '2.11';
|
||
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
$paramSql = " SELECT initValue,instanceNo FROM param_99
|
||
WHERE $objWhereStr AND instanceNo ='$infoNo'
|
||
";
|
||
$Result = mysqli_query($pubConn,$paramSql);
|
||
$Row = mysqli_fetch_array($Result);
|
||
$elementname = trim(toAscii(getBitValue($Row[initValue],"14.0-23.7")));
|
||
echo "<tr>";
|
||
echo "<td width=\"15%\" bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\"><b>IUA Link</b></td>";
|
||
echo "<td colspan=\"$colspans\">$elementname</td>";
|
||
echo "</tr>";
|
||
}
|
||
else
|
||
{
|
||
$oidstr = '2.4.1';
|
||
|
||
$objWhereStr= '';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
$paramSql = " SELECT initValue,instanceNo FROM param_99
|
||
WHERE $objWhereStr AND instanceNo ='$linkset'
|
||
";
|
||
$Result = mysqli_query($pubConn,$paramSql);
|
||
$Row = mysqli_fetch_array($Result);
|
||
$linksetname = trim(toAscii(getBitValue($Row[initValue],"7.0-16.7")));
|
||
if(strlen($linksetname)==0)
|
||
$linksetname = '--';
|
||
echo "<tr>";
|
||
echo "<td width=\"15%\" bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\"><b>SS7</b></td>";
|
||
echo "<td ><a href=\"./wxc2_sp_signaling.php?trunkgp=$trunkgp&devicename=$devicename&sysNo=$sysNo&infoNo=$infoNo&linkset=$linkset&grpNo=$grpNo&appType=$appType\";>$linksetname</a></td>";
|
||
echo "</tr>";
|
||
}
|
||
}
|
||
|
||
if($TG_show)
|
||
{
|
||
{//Trunk group strat
|
||
echo "<tr>";
|
||
echo "<td width=\"15%\" bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\"><b>Trunk group</b></td>";
|
||
echo "<td><table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
echo "<td width=\"15%\">Category</td>";
|
||
if($webname=='IUA')
|
||
{
|
||
echo "<td width=\"15%\"> </td>";
|
||
echo "<td width=\"55%\"> </td>";
|
||
}
|
||
else
|
||
{
|
||
echo "<td width=\"15%\">NI</td>";
|
||
echo "<td width=\"55%\">DPC</td>";
|
||
}
|
||
echo "</tr>";
|
||
|
||
//------------<2D><>ѯTrunkGroup<75><70><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
|
||
$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);
|
||
//------------<2D><>TrunkGroup<75><70><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
//echo "<br>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]";
|
||
//------------<2D><>ʾTrunkGroup<75><70><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
echo "<tr>";
|
||
if(isset($trunkgp))
|
||
{
|
||
$setobjIdstr = "2.1.4-2.1.4";
|
||
$setname = 'Trunk Group';
|
||
if($TypeIn==17)
|
||
echo "<td ><a href=\"javascript:openSet('$setobjIdstr','$trunkgp-$RAC','$setname','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo');\">$trunkgp </a></td>";
|
||
else
|
||
echo "<td ><a href=\"javascript:openSet('$setobjIdstr','$trunkgp-$RAC','$setname','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo');\">$trunkgp </a></td>";
|
||
echo "<td >$Category </td>";
|
||
if($webname=='IUA')
|
||
{
|
||
echo "<td > </td>";
|
||
echo "<td > </td>";
|
||
}
|
||
else
|
||
{
|
||
echo "<td >$NetIdConfArr[$NetID] </td>";
|
||
echo "<td >$DPC </td>";
|
||
}
|
||
}
|
||
else
|
||
{
|
||
echo "<td >--</td>";
|
||
echo "<td >--</td>";
|
||
echo "<td >--</td>";
|
||
echo "<td colspan=\"4\">--</td>";
|
||
}
|
||
echo "</tr>";
|
||
echo "</table></td>";
|
||
echo "</tr>";
|
||
}//Trunk group end
|
||
}
|
||
if($E1_show)
|
||
{
|
||
{//E1 strat
|
||
//------------<2D><>ѯE1<45><31><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------
|
||
$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);
|
||
|
||
|
||
//------------<2D><>E1<45><31><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
$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<strlen($hex_mes);$i++)
|
||
{
|
||
$sig_hex_mes=substr($hex_mes,$i,1);
|
||
$sig_dec_mes=HexDec($sig_hex_mes);
|
||
$sig_bin_mes=DecBin($sig_dec_mes);
|
||
$sig_bin_mes=omc_keep_length($sig_bin_mes,0,4);
|
||
$bin_mes.=$sig_bin_mes;
|
||
}
|
||
|
||
//e1 layer2
|
||
$bin_inl=substr($bin_mes,$el2_bgn*8+7-$port,1);//0:'N'; 1:'Y'; 2:'--'
|
||
$E1state[$n] = bindec($bin_inl);
|
||
}
|
||
}//end E1 state
|
||
|
||
$mscLocflag[$n] = getBitValue($Row_3[initValue],"00.1-00.1");
|
||
|
||
$n++;
|
||
}
|
||
}
|
||
$tmpWhere=$tmpWhere.")";
|
||
}
|
||
|
||
{//Protocol
|
||
$oidstr = '2.4.1';
|
||
$objWhereStr= '';
|
||
$objWhereStr = getLevelWhere($oidstr);
|
||
|
||
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND $tmpWhere ORDER BY instanceNo
|
||
";
|
||
//echo "$paramSql";
|
||
$Result_1 = mysqli_query($pubConn,$paramSql);
|
||
$n=0;
|
||
while($Row_1 = mysqli_fetch_array($Result_1))
|
||
{
|
||
$instNo[$n] = $Row_1[instanceNo];
|
||
$is8ke1En = is8ke1Enable($Row_1[instanceNo]);
|
||
$Lockflag[$n] = $mscLocflag[$n] && $is8ke1En;
|
||
if($n==0)
|
||
{
|
||
$E1connarr = $instNo[$n];
|
||
}
|
||
else
|
||
{
|
||
$E1connarr = $E1connarr."_".$instNo[$n];
|
||
}
|
||
$E1Protocol[$n] = $Row_1;
|
||
$n++;
|
||
}
|
||
}
|
||
{//CIC
|
||
$oidstr = '2.4.3';
|
||
$objWhereStr= '';
|
||
$objWhereStr = getLevelWhere($oidstr);
|
||
|
||
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr AND $tmpWhere ORDER BY instanceNo
|
||
";
|
||
//echo "$paramSql";
|
||
$Result_2 = mysqli_query($pubConn,$paramSql);
|
||
$n=0;
|
||
while($Row_2 = mysqli_fetch_array($Result_2))
|
||
{
|
||
$E1cic[$n] = $Row_2;
|
||
$n++;
|
||
}
|
||
}
|
||
|
||
echo "<input type=\"hidden\" name=\"E1connarr\" value=\"$E1connarr\">";
|
||
if($DEBUG) echo "E1connarr=$E1connarr<br>";
|
||
//------------<2D><>ʾE1<45><31><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
$rowspan = $n +1;
|
||
if($n ==0)
|
||
{
|
||
$tmpcic = 255;
|
||
$rowspan =2;
|
||
}
|
||
else
|
||
{
|
||
$tmpcic = hexdec($E1cic[0][initValue]);
|
||
}
|
||
|
||
echo "<tr>";
|
||
echo "<td style=\"border-right:1px solid\" bgcolor=\"#E6E6E6\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>E1/T1 connection</b></td>";
|
||
if($TypeIn ==2 && $n > 1)//AAS<41><53><EFBFBD><EFBFBD><EFBFBD><EFBFBD>2<EFBFBD><32>E1connect
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:newError('E1')\"><font size=4>+</font></a></td>";
|
||
}
|
||
elseif($TypeIn ==2)
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:openSet('$tmpcic','new','E1','$n','$trunkgp','$linkset','$webname','$backurl','$infoNo')\"><font size=4>+</font></a></td>";
|
||
}
|
||
elseif($TypeIn !=2&& $n > 31)//<2F><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>32<33><32>E1connect
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:newError('E1')\"><font size=4>+</font></a></td>";
|
||
}
|
||
else
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:openSet('$tmpcic','new','E1','$n','$trunkgp','$linkset','$webname','$backurl','$infoNo')\"><font size=4>+</font></a></td>";
|
||
}
|
||
echo "</tr></table>";
|
||
echo "</td>";
|
||
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" >";
|
||
echo "<tr bgcolor=\"#E6E6E6\" >";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
echo "<td width=\"15%\">Protocol</td>";
|
||
if($webname=="IUA")
|
||
echo "<td width=\"15%\">Interface ID</td>";
|
||
else
|
||
echo "<td width=\"15%\">Circuit ID</td>";
|
||
echo "<td width=\"15%\">E1/T1 channel</td>";
|
||
echo "<td width=\"15%\">Status</td>";
|
||
echo "<td width=\"15%\">Admin State</td>";
|
||
echo "<td width=\"10%\"align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
if($n==0)
|
||
{
|
||
echo "<tr><td colspan=\"7\">--</td></tr>";
|
||
}
|
||
$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 "<tr id='e1t1$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='e1t1$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td ><a href=\"javascript:openSet('$cic','$instNo[$i]','E1','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\">$cardname</a></td>";
|
||
$p = hexdec(getBitValue($E1Protocol[$i][initValue],'0.0-0.7'));
|
||
echo "<td >$Protocol[$p] </td>";
|
||
|
||
echo "<td >$cic </td>";
|
||
|
||
echo "<td><a href=\"javascript:openSet('11','$instNo[$i]','E1channel','$Protocol[$p]','$trunkgp','$linkset','$webname','$backurl','$infoNo')\">";
|
||
|
||
$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 "<br>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 "<input type=\"hidden\" name=\"$cardname\" value=\"$oidCard\">";
|
||
echo "$enabletime enable</a></td>";
|
||
|
||
if($cic == 0)
|
||
{
|
||
$delE1ID = 0;
|
||
}
|
||
else
|
||
{
|
||
$delE1ID = 1;
|
||
}
|
||
$delID = $instNo[$i]."_".$delE1ID;
|
||
if($DEBUG) echo "$delID<br>";
|
||
if(isset($E1state[$i]) && $E1state[$i]==1)//$E1state[$i]Ҳ<><D2B2><EFBFBD><EFBFBD>û<EFBFBD>и<EFBFBD>ֵ
|
||
echo "<td>OK</td>";
|
||
else
|
||
echo "<td>Down</td>";
|
||
|
||
if($Lockflag[$i])
|
||
echo "<td><a href=\"javascript:lockFirm('$delID','E1lock','$trunkgp','$linkset',this)\" title=\"to lock this E1\">Unlocked</a>";
|
||
else
|
||
echo "<td><a href=\"javascript:lockFirm('$delID','E1unlock','$trunkgp','$linkset',this)\" title=\"to unlock this E1\">Locked</a>";
|
||
|
||
echo "</td>";
|
||
|
||
echo "<td align=\"right\" colspan=\"1\"><input type=\"checkbox\" name=\"C$instanceNo\" value=\"ON\" onClick=\"javascript:delFirm('$delID','E1','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
if($n>4)
|
||
{
|
||
echo "<tr id='showe1t1' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('e1t1',$n,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hidee1t1' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('e1t1',$n,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}//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 "<br>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 "<br>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 "<br>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 "<br>validPrefix[$prefix_no][prefix]:{$validPrefix[$prefix_no][prefix]}";
|
||
$prefix_no++;
|
||
}
|
||
if($prefix_no >= $valid_num)
|
||
break;
|
||
}
|
||
}//end get prefix value
|
||
|
||
//------------<2D><>ʾprefix<69><78><EFBFBD><EFBFBD><EFBFBD><EFBFBD>---------------------
|
||
$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 "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>Prefix</b></td>";
|
||
echo "<td align=\"right\"><a href=\"javascript:openSet('$setobjIdstr','new','Prefix','$sysId','$trunkgp','$linkset','$webname','$backurlprefix','$infoNo')\"><font size=4>+</font></a></td>";
|
||
echo "</tr></table>";
|
||
echo "</td>";
|
||
echo "<td>";
|
||
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">";
|
||
echo "<tr bgcolor=\"#E6E6E6\" >";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
echo "<td width=\"15%\">Prefix</td>";
|
||
echo "<td width=\"15%\">TON-in</td>";
|
||
echo "<td width=\"15%\">TON-out</td>";
|
||
echo "<td width=\"15%\">Properties</td>";
|
||
echo "<td width=\"15%\">Call Type</td>";
|
||
//echo "<td >CDR</td>";
|
||
echo "<td width=\"10%\"align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
|
||
$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 "<tr><td colspan=\"7\">--</td></tr>";
|
||
}
|
||
for($i=0;$i < $n;$i++)
|
||
{
|
||
$tmpInitValue = $validPrefix[$i][init_value];
|
||
$tmpInst = $validPrefix[$i][inst_no];
|
||
if($i>3)
|
||
echo "<tr id='prefix$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='prefix$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td ><a href=\"javascript:openSet('$setobjIdstr','$tmpInst','Prefix','$sysId','$trunkgp','$linkset','$webname','$backurlprefix','$infoNo');\">$i </a></td>";
|
||
$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 "<td >$oRano </td>";
|
||
echo "<td >$TON_in[$oTON_in] </td>";
|
||
echo "<td >$TON_out[$oTON_out] </td>";
|
||
echo "<td >$Properties[$oProperties] </td>";
|
||
echo "<td >$callTypeArr[$oCallType] </td>";
|
||
echo "<td align=\"right\"><input type=\"checkbox\" name=\"C$instanceNo\" value=\"ON\" onClick=\"javascript:delFirm($tmpInst,'prefix','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
//==============the more and hide button===================
|
||
if($n>4)
|
||
{
|
||
echo "<tr id='showprefix' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('prefix',$n,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideprefix' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('prefix',$n,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}
|
||
|
||
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<br>";
|
||
|
||
$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 "<br>convPrefix[$convNo][prefix]:{$convPrefix[$convNo][initValue]}";
|
||
$convNo++;
|
||
}
|
||
}//end while
|
||
$getsql = "select initValue,instanceNo from $net_paramTable where $levelWhere and initValue='$conv_pre_def'";
|
||
//echo "<br>getsql: $getsql;";
|
||
$result = @mysqli_query($pubConn,$getsql);
|
||
$Row = @mysqli_fetch_array($result);
|
||
$newConvInst=$Row[instanceNo];
|
||
$conv_nrow = $convNo + 1;
|
||
|
||
echo "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>Prefix manipulation</b></td>";
|
||
echo "<td align=\"right\"><a href=\"javascript:openSetConv('$newConvInst','$objIdStr','$sysId','$webname','$setname','$backurl','$infoNo','$trunkgp')\"><font size=4>+</font></a></td>";
|
||
echo "</tr></table>";
|
||
echo "</td>";
|
||
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" >";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
echo "<td width=\"15%\">Prefix</td>";
|
||
echo "<td width=\"15%\">Delete length</td>";
|
||
echo "<td width=\"15%\">Add length</td>";
|
||
echo "<td width=\"15%\">Add digits</td>";
|
||
echo "<td width=\"15%\">Valid length</td>";
|
||
echo "<td width=\"10%\"align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
if($convNo==0){
|
||
echo "<tr><td colspan=\"7\">--</td></tr>";
|
||
}
|
||
for($i=0; $i< $convNo; $i++)
|
||
{
|
||
if($i>3)
|
||
echo "<tr id='Prefixmanipulation$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='Prefixmanipulation$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetConv('{$convPrefix[$i][inst_no]}','$objIdStr','$sysId','$webname','$setname','$backurl','$infoNo','$trunkgp')\">$i</a></td>";
|
||
|
||
echo "<td width=\"15%\">{$convPrefix[$i][prefix]} </td>";
|
||
echo "<td width=\"15%\">{$convPrefix[$i][delLen]} </td>";
|
||
echo "<td width=\"15%\">{$convPrefix[$i][addLen]} </td>";
|
||
echo "<td width=\"15%\">{$convPrefix[$i][addDigs]} </td>";
|
||
echo "<td width=\"15%\">{$convPrefix[$i][valiLen]} </td>";
|
||
|
||
echo "<td width=\"10%\"align=\"right\"><input type=\"checkbox\" name=\"C$instanceNo\" value=\"ON\" onClick=\"javascript:delFirm('{$convPrefix[$i][inst_no]}','convPrefix','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
//===============more button==============
|
||
if($convNo>4)
|
||
{
|
||
echo "<tr id='showPrefixmanipulation' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('Prefixmanipulation',$convNo,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hidePrefixmanipulation' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('Prefixmanipulation',$convNo,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}
|
||
|
||
|
||
|
||
|
||
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 "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>LAC</b></td>";
|
||
echo "<td align=\"right\"><a href=\"javascript:openSet('6','new-0','LAC','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\"><font size=4>+</font></a></td>";
|
||
echo "</tr></table></td>";
|
||
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\" >No.</td>";
|
||
echo "<td width=\"15%\" >LAC</td>";
|
||
echo "<td width=\"15%\" >Page Mode</td>";
|
||
echo "<td width=\"55%\" align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
|
||
if($n==0)
|
||
{
|
||
echo "<tr bgcolor=\"#E6E6E6\"><td colspan=\"7\">--</td></tr>";
|
||
}
|
||
for($i=0;$i < $n;$i++)
|
||
{
|
||
if($i>3)
|
||
echo "<tr id='LAC$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='LAC$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
if($LAC_pageType[$i]==5) $pageTypeStr='By LAC';
|
||
else if($LAC_pageType[$i]==6) $pageTypeStr='In All Cell';
|
||
else $pageTypeStr='--';
|
||
$lac_inst = $LAC_inst[$i];
|
||
$lac_value = $LAC_value[$i];
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSet('{$LAC_pageType[$i]}','$lac_inst-$lac_value','LAC','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\">$i </a></td>";
|
||
echo "<td width=\"15%\">{$LAC_value[$i]}</td>";
|
||
echo "<td width=\"15%\">$pageTypeStr</td>";
|
||
echo "<td width=\"55%\" align=\"right\"><input type=\"checkbox\" name=\"\" value=\"ON\" onClick=\"javascript:delFirm('$lac_inst','LAC','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
//===============more button==============
|
||
if($n>4)
|
||
{
|
||
echo "<tr id='showLAC' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('LAC',$n,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideLAC' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('LAC',$n,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}//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";
|
||
//<2F><><EFBFBD><EFBFBD>һ<EFBFBD><D2BB>δ<EFBFBD>õ<EFBFBD>Cell parameter<65><72><EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD>btsʱʹ<CAB1><CAB9>
|
||
$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<sizeof($LAC_value);$j++)
|
||
{
|
||
if($lacValue==$LAC_value[$j])
|
||
{
|
||
$CellID[$num] = $Row[instanceNo];
|
||
$Em_flag[$num] = hexdec(getBitValue($Row[initValue],'00.0-00.7'));
|
||
$Em_prefix[$num]= hexdec(getBitValue($Row[initValue],'05.0-5.7'));
|
||
$CellNum[$num] = hexdec(getBitValue($Row[initValue],'03.0-04.7'));
|
||
$tmpLocEme = getBitValue($Row[initValue],'06.0-13.7');
|
||
$Em_routed[$num] = str_replace('E','',$tmpLocEme);
|
||
$Em_lac[$num] = $lacValue;
|
||
$num++;
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
$setobjIdstr = '2.2.7-2.2.7';
|
||
$newobjIdstr = 'new-2.2.7';
|
||
/* the Emergency call parameter (old hide 2007-6-5)
|
||
echo "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" width=\"15%\" style=\"border-right:1px solid\">";
|
||
echo "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" title=\"Emergency call.\"><b>Emergency call</b></td>";
|
||
if(!isset($newID))
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:newError('BTS')\"><font size=4>+</font></a></td>";
|
||
}
|
||
elseif(sizeof($LAC_value)==0)
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:newError('LAC')\"><font size=4>+</font></a></td>";
|
||
}
|
||
else
|
||
{
|
||
echo "<td align=\"right\"><a href=\"javascript:openSet('$newobjIdstr','$newID-$LAC_value[0]','BTS','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\"><font size=4>+</font></a></td>";
|
||
}
|
||
echo "</tr></table>";
|
||
echo "</td>";
|
||
echo "<td>";
|
||
echo "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" >";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No</td>";
|
||
echo "<td width=\"15%\">Prefix</td>";
|
||
echo "<td width=\"15%\">LAC</td>";
|
||
echo "<td width=\"15%\">Cell</td>";
|
||
echo "<td width=\"15%\">Em Number</td>";
|
||
echo "<td width=\"15%\">Em Flag</td>";
|
||
echo "<td width=\"10%\" align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
|
||
//<2F><>ʾCELL
|
||
if($num==0)
|
||
{
|
||
echo "<tr><td colspan=\"6\">--</td></tr>";
|
||
}
|
||
for($i=0;$i < $num;$i++)
|
||
{
|
||
$tmpInst=$Em_prefix[$i];
|
||
//get Prefix
|
||
{
|
||
$sysId = '322_99_99';
|
||
$sysIdArr = explode('_',$sysId);
|
||
$sysTypeNo = $sysIdArr[0];
|
||
$sysNo = $sysIdArr[1];
|
||
$subSysNo = $sysIdArr[2];
|
||
$oidstr = '2.1.1';
|
||
$objWhereStr =getLevelWhere($oidstr);
|
||
|
||
$objDb = 'OBJ_'.$sysTypeNo;
|
||
$paramTable = 'param_'.$sysNo;
|
||
|
||
$paramSql = " SELECT initValue,readValue,instanceNo FROM $paramTable
|
||
WHERE subSysNo = '$subSysNo' AND $objWhereStr and instanceNo='$tmpInst'
|
||
";
|
||
$result = @mysqli_query($pubConn,$paramSql);
|
||
$Row = @mysqli_fetch_array($result);
|
||
$tmpPrefix = str_replace('E','',$Row[initValue]);
|
||
if(strlen($tmpPrefix)==0)
|
||
$tmpPrefix='--';
|
||
}
|
||
if($i>3)
|
||
echo "<tr id='EmergencyCall$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='EmergencyCall$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td ><a href=\"javascript:openSet('$setobjIdstr','$CellID[$i]-$Em_lac[$i]','BTS','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\">{$CellID[$i]} </a></td>";
|
||
echo "<td ><a href=\"javascript:openSet('2.1.2-2.1.1-2.1.2-2.1.3','$tmpInst','Prefix','$sysId','$trunkgp','$linkset','$webname','$backurl','$infoNo')\">$tmpPrefix </a></td>";
|
||
echo "<td >$Em_lac[$i]</td>";
|
||
echo "<td >$CellNum[$i]</td>";
|
||
echo "<td >{$Em_routed[$i]}</td>";
|
||
echo "<td >{$emFlagArr[$Em_flag[$i]]}</td>";
|
||
echo "<td align=\"right\"><input type=\"checkbox\" name=\"C$instanceNo\" value=\"ON\" onClick=\"javascript:delFirm($CellID[$i],'BTS','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
//===============more button==============
|
||
if($num>4)
|
||
{
|
||
echo "<tr id='showEmergencyCall' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('EmergencyCall',$num,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideEmergencyCall' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('EmergencyCall',$num,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
|
||
echo "</table>";
|
||
echo "</td>";
|
||
*/
|
||
|
||
|
||
//================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 "<hr>";
|
||
echo "{$cell_instance_no[$cell_count]}<br>";
|
||
echo "----{$cell_emergency_call_flag[$cell_count]}<br>";
|
||
echo "----{$cell_lac[$cell_count]}<br>";
|
||
echo "----{$cell_id[$cell_count]}<br>";
|
||
echo "----{$cell_prefix_index_number[$cell_count]}<br>";
|
||
echo "----{$cell_local_emergency_number[$cell_count]}<br>";
|
||
echo "----{$cell_regional_zone_flag[$cell_count]}<br>";
|
||
echo "----{$cell_zone_code[$cell_count]}<br>";
|
||
}
|
||
*/
|
||
$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 "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" width=\"15%\" style=\"border-right:1px solid\">";
|
||
$oper="new";
|
||
echo "<b>Emergency Call</b><a href=\"./cell_edit.php?instanceNo=$cell_unuse_instanceNo&trunkgp=$trunkgp&linkset=$linkset&infoNo=$infoNo&operation=$oper&backurl=$url_temp\"><font color=blue size=4>+</font></a>";
|
||
echo "</td>";
|
||
echo "<td>";
|
||
echo "<table border=0 width=100% cellspacing=0>";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=10%>No.</td>";
|
||
echo "<td width=14%>Prefix</td>";
|
||
echo "<td width=12%>LAC</td>";
|
||
echo "<td width=12%>Cell ID</td>";
|
||
echo "<td width=20%>Emergency Number</td>";
|
||
echo "<td width=12%>Emergency Flag</td>";
|
||
echo "<td width=4%>Delete</td>";
|
||
echo "</tr>";
|
||
if($cell_count==0)
|
||
{
|
||
echo "<tr>";
|
||
echo "<td width=12%>--</td>";
|
||
echo "</tr>";
|
||
}
|
||
else
|
||
{
|
||
|
||
for($i=0;$i<$cell_count;$i++)
|
||
{
|
||
|
||
if($i>3)
|
||
echo "<tr id='EmergencyCall$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='EmergencyCall$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
|
||
$no_tmp=$cell_instance_no[$i];
|
||
|
||
$prefix_tmp_no=$cell_prefix_index_number[$i];
|
||
$oper="edit";
|
||
echo "<td><a href=\"./cell_edit.php?instanceNo=$no_tmp&trunkgp=$trunkgp&linkset=$linkset&infoNo=$infoNo&operation=$oper&backurl=$url_temp\">{$cell_instance_no[$i]}</a></td>";
|
||
echo "<td><a href=# onClick=\"javascript:openSetPrefix('$trunkgp','$prefix_tmp_no','no-2.1.1-2.1.2','322_99_99','MSC','Prefix','$u_t')\">{$cell_prefix_prefix[$i]}</a></td>";
|
||
echo "<td>{$cell_lac[$i]}</td>";
|
||
echo "<td>{$cell_id[$i]}</td>";
|
||
$tmp=str_replace("E","",$cell_local_emergency_number[$i]);
|
||
echo "<td>$tmp</td>";
|
||
echo "<td>{$cell_emergency_call_flag[$i]}</td>";
|
||
//=======delete button==================
|
||
echo "<td align=right><input type=checkbox onClick=\"javascript:delete_cell(this,'$no_tmp','$trunkgp','$linkset')\"></td>";
|
||
echo "</tr>";
|
||
|
||
|
||
|
||
}
|
||
//===============more button==============
|
||
if($cell_count>4)
|
||
{
|
||
echo "<tr id='showEmergencyCall' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('EmergencyCall',$cell_count,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideEmergencyCall' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('EmergencyCall',$cell_count,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}
|
||
}
|
||
|
||
|
||
|
||
|
||
}
|
||
|
||
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 "<br>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 "<br>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 "<br>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 "<br>gttSSN=$gttSSN, n=$n, m=$m";
|
||
{//show GTT
|
||
$setobjIdstr = "2.2-2.2";
|
||
if($appType != 5)
|
||
{
|
||
echo "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" width=\"15%\" style=\"border-right:1px solid\"><b>$strE164Number</b></td>";
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" >";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
echo "<td width=\"15%\">NP</td>";
|
||
else
|
||
echo "<td width=\"15%\">TT</td>";
|
||
echo "<td width=\"15%\">$strE164Number</td>";
|
||
echo "<td width=\"15%\"> </td>";
|
||
echo "<td width=\"15%\">NI</td>";
|
||
echo "<td width=\"15%\">DPC</td>";
|
||
echo "<td width=\"10%\"> </td>";
|
||
echo "</tr>";
|
||
|
||
echo "<tr>";
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">0</a></td>";
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">MSISDN</a></td>";
|
||
else
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">$tt</a></td>";
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">$globalTitle</a></td>";
|
||
echo "<td width=\"15%\"></td>";
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">{$NetIdConfArr[$NI]}</a></td>";
|
||
echo "<td width=\"15%\"><a href=\"javascript:openSetGTT('$np','$instNo','$appType','1','$gttSSN','$linkset','$grpNo','$backurl')\">$DPC</a></td>";
|
||
echo "<td width=\"15%\"> </td>";
|
||
echo "</tr>";
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}
|
||
//if($gttSSN==6 || $gttSSN==11)
|
||
if($appType==1 || $appType==3 || $appType==5)
|
||
{
|
||
$rowspan = $n+1;
|
||
echo "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>MSISDN</b></td>";
|
||
echo "<td align=\"right\"><a href=\"javascript:openSetGTT('1','new','$appType','0','$gttSSN','$linkset','$grpNo','$backurl')\"><font size=4>+</font></a></td>";
|
||
echo "</tr></table></td>";
|
||
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" >";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
echo "<td width=\"15%\">NP</td>";
|
||
else
|
||
echo "<td width=\"15%\">TT</td>";
|
||
echo "<td width=\"15%\">start GT</td>";
|
||
echo "<td width=\"15%\">end GT</td>";
|
||
echo "<td width=\"15%\">NI</td>";
|
||
echo "<td width=\"15%\">DPC</td>";
|
||
echo "<td width=\"10%\" align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
if($n==0)
|
||
echo "<tr><td colspan=\"7\">--</td></tr>";
|
||
for($i=0; $i< $n; $i++)
|
||
{
|
||
if($i>3)
|
||
echo "<tr id='MSISDN$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='MSISDN$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td ><a href=\"javascript:openSetGTT('1','{$msisdnGTTArr[$i][instanceNo]}','$appType','0','$gttSSN','$linkset','$grpNo','$backurl')\">$i</a></td>";
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
echo "<td>MSISDN</td>";
|
||
else
|
||
echo "<td>{$msisdnGTTArr[$i][tt]}</td>";
|
||
echo "<td>{$msisdnGTTArr[$i][start]}</td>";
|
||
echo "<td>{$msisdnGTTArr[$i][end]}</td>";
|
||
echo "<td>{$NetIdConfArr[$NI]}</td>";
|
||
echo "<td>$DPC</td>";
|
||
echo "<td align=\"right\"><input type=\"checkbox\" name=\"Checbox$n\" value=\"ON\" onClick=\"javascript:delFirm('{$msisdnGTTArr[$i][instanceNo]}','GTT','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
if($n>4)
|
||
{
|
||
echo "<tr id='showMSISDN' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('MSISDN',$n,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideMSISDN' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('MSISDN',$n,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
//if($gttSSN==6)
|
||
if($appType==1 || $appType == 5)
|
||
{
|
||
$rowspan = $m+1;
|
||
|
||
echo "<tr>";
|
||
echo "<td bgcolor=\"#E6E6E6\" style=\"border-right:1px solid\">";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\" ><tr>";
|
||
echo "<td align=\"left\" ><b>IMSI</b></td>";
|
||
echo "<td align=\"right\"><a href=\"javascript:openSetGTT('6','new','$appType','0','$gttSSN','$linkset','$grpNo','$backurl')\"><font size=4>+</font></a></td>";
|
||
echo "</tr></table></td>";
|
||
|
||
echo "<td>";
|
||
echo "<table width=\"100%\" cellpadding=\"1\" cellspacing=\"0\">";
|
||
echo "<tr bgcolor=\"#E6E6E6\">";
|
||
echo "<td width=\"15%\">No.</td>";
|
||
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
echo "<td width=\"15%\">NP</td>";
|
||
else
|
||
echo "<td width=\"15%\">TT</td>";
|
||
|
||
echo "<td width=\"15%\">start GT</td>";
|
||
echo "<td width=\"15%\">end GT</td>";
|
||
echo "<td width=\"15%\">NI</td>";
|
||
echo "<td width=\"15%\">DPC</td>";
|
||
echo "<td width=\"10%\" align=\"right\">Delete</td>";
|
||
echo "</tr>";
|
||
if($m==0)
|
||
echo "<tr><td colspan=\"7\">--</td></tr>";
|
||
for($i=0; $i< $m; $i++)
|
||
{
|
||
if($i>3)
|
||
echo "<tr id='IMSI$i' style=\"display:none\" onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
else
|
||
echo "<tr id='IMSI$i' onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
//echo "<tr onMouseOver=\"this.bgColor='#D2F0FF'\" onMouseOut=\"this.bgColor='#ffffff'\">";
|
||
echo "<td ><a href=\"javascript:openSetGTT('6','{$imsiGTTArr[$i][instanceNo]}','$appType','0','$gttSSN','$linkset','$grpNo','$backurl')\">$i</a></td>";
|
||
if($niTypeArr[$NI]==0)//ITU
|
||
{
|
||
if($imsiGTTArr[$i][np]==6)
|
||
echo "<td>IMSI</td>";
|
||
else if($imsiGTTArr[$i][np]==7)
|
||
echo "<td>GT</td>";
|
||
}
|
||
else
|
||
{
|
||
echo "<td>{$imsiGTTArr[$i][tt]}</td>";
|
||
}
|
||
echo "<td>{$imsiGTTArr[$i][start]}</td>";
|
||
echo "<td>{$imsiGTTArr[$i][end]}</td>";
|
||
echo "<td>{$NetIdConfArr[$NI]}</td>";
|
||
echo "<td>$DPC</td>";
|
||
echo "<td align=\"right\"><input type=\"checkbox\" name=\"Checbox$n\" value=\"ON\" onClick=\"javascript:delFirm('{$imsiGTTArr[$i][instanceNo]}','GTT','$trunkgp','$linkset',this)\" ></td>";
|
||
echo "</tr>";
|
||
}
|
||
|
||
//===============more button==============
|
||
if($m>4)
|
||
{
|
||
echo "<tr id='showIMSI' style=\"display:block\"><td><a href=\"javascript:clickOnMoreHide('IMSI',$m,'show')\">More >></a></td></tr>";
|
||
echo "<tr id='hideIMSI' style=\"display:none\"><td><a href=\"javascript:clickOnMoreHide('IMSI',$m,'hide')\">Hide >></a></td></tr>";
|
||
}
|
||
echo "</table>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
}
|
||
}
|
||
}//end show GTT
|
||
}//GTT
|
||
}
|
||
|
||
echo "</table> ";
|
||
|
||
if($devicename=='Peripheral')
|
||
{
|
||
$lowerWebname = strtolower($webname);
|
||
$loadfile = "load$lowerWebname.php";
|
||
echo "<div>";
|
||
echo "<a href=\"./$loadfile?infoNo=$infoNo&linkset=$linkset&trunkgp=$trunkgp&flag=$flag\"><b>MSS -> $webname<b></a>";
|
||
echo "</div>";
|
||
}
|
||
{//get all exist elements from elementExistConf
|
||
getExistElements($existElementArr);
|
||
|
||
if(@array_search('500', $existElementArr)==TRUE)//BSS
|
||
$BssExist = 1;
|
||
}//end get all exisit elements
|
||
if($BssExist==1)
|
||
if($devicename=='BSC')
|
||
{
|
||
echo "<div>";
|
||
echo "<a href=\"../bssSpecific/bssSpecific.php?bssid=$this_sysNo&infoNo=$infoNo&linkset=$linkset&trunkgp=$trunkgp&flag=$flag\"><b>MSS -> $webname<b></a>";
|
||
echo "</div>";
|
||
}
|
||
|
||
/*{
|
||
echo "<table width=\"100%\">";
|
||
echo "<tr>";
|
||
echo "<td width=\"70%\">";
|
||
echo " ";
|
||
echo "</td>";
|
||
echo "<td width=\"20%\" align=\"right\">";
|
||
echo "<input type=\"submit\" title=\"$strTitleGet\" name=\"getSys\" value=\"$strGet\" class=\"button\" style=\"cursor:pointer; left: 1; top: 2; width: 60; height: 25; position: relative\">";
|
||
echo " ";
|
||
echo "<input type=\"submit\" title=\"$strTitleSet\" name=\"setSys\" value=\"$strSet\" class=\"button\" style=\"cursor:pointer; left: 1; top: 2; width: 60; height: 25; position: relative\">";
|
||
echo "</td>";
|
||
echo "<td width=\"10%\">";
|
||
echo "<p align=\"right\"><a href=\"javascript:backpage(0,'../overview/overview.php')\"><img align=absBottom border=0 src=\"../../images/left.gif\" width=\"14\" height=\"14\">$strBack</a>";
|
||
echo "</td>";
|
||
echo "</tr>";
|
||
echo "</table>";
|
||
}*/
|
||
?>
|
||
</form>
|
||
<?php
|
||
if($E1_show == 1)
|
||
{
|
||
?>
|
||
<font color=#808080>
|
||
Notes:<br>
|
||
1. Add E1/T1 Connection first.
|
||
<br>
|
||
2. Link to SS7 webpage, add Signalling link.
|
||
</font>
|
||
</body>
|
||
</html>
|
||
<?php
|
||
}
|
||
?>
|