array('paramTable'=>'OBJ_223.param_99', 'objIdStr'=>'2.1.8')
);
$netInfo = array(
'0'=>'International',
'1'=>'International spare',
'2'=>'National',
'3'=>'National spare'
);
?>
";
adjust_head();
adjust_title_head();
echo "";
echo "";
echo "| ";
echo "Template > Element";
echo " | ";
echo "";
echo " | ";
echo "
";
echo "
";
adjust_title_tail();
adjust_content_head();
echo "
";
echo "";
echo "";
echo "| Wxc2-Element";
echo " | Get | ";
echo "Set | ";
echo "
";
echo "";
echo "| No. | ";
echo "Name | ";
echo "Element | ";
echo "Signalling point | ";
echo "SS7 Network | ";
echo "Protocol | ";
echo "Global Title/Trunk group | ";
echo "State | ";
echo "Remarks | ";
echo "Delete | ";
echo "
";
$selSql = "SELECT * FROM element";
$selRes = @mysqli_query($pubConn,$selSql);
$totalDevice = @mysqli_num_rows($selRes);
for ($i=0; $i<$totalDevice; $i++){
$selRow = @mysqli_fetch_array($selRes);
$name[$i] = $selRow[name];
$element[$i] = $selRow[element];
$signallingPoint[$i] = $selRow[signallingPoint];
$remarks[$i] = $selRow[remarks];
if($DEBUG) echo "element[$i] = $element[$i]
";
}
//得到各element的状态和颜色------State
for ($i=0; $i<$totalDevice; $i++){
$selTimeSql = "SELECT sysStat.sysTypeNo,sysStat.updateTime AS updateTime FROM sysStat,sysConf
WHERE sysStat.sysTypeNo=sysConf.sysTypeNo
AND sysConf.sysTypeName LIKE \"$element[$i]\"
AND sysConf.needHeartBeat=1";
if($DEBUG) echo "selTimeSql = $selTimeSql
";
$selTimeRes = @mysqli_query($pubConn,$selTimeSql);
$num = @mysqli_num_rows($selTimeRes);
if($DEBUG) echo "num=$num
";
for ($j=0; $j<$num; $j++){
$selTimeRow = @mysqli_fetch_row($selTimeRes);
if($DEBUG) echo "$selTimeRow[0],updateTime = $selTimeRow[1]
";
$due_date = date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s")-$heatbeat_overtime,date("m"),date("d"),date("Y")));
$ove_date = date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s")+$heatbeat_overtime,date("m"),date("d"),date("Y")));
if($DEBUG) echo "$due_date, $ove_date
";
if ( ($selTimeRow[updateTime] < $due_date) || ($selTimeRow[updateTime] > $ove_date) ){
$state[$i] = "OK";
$stateColor[$i] = "#0000FF";
}else{
$state[$i] = "Fail";
$stateColor[$i] = "#FF0000";
}
}
if($DEBUG) echo "stateColor[$i] = $stateColor[$i]
";
}
//NI and GTT in SCCP-------SS7 network and Global Title/Trunk group
$localNodeConfArr=array(
array('NetID', '00.0-00.7'),
array('MSISDN', '01.0-10.7'),
array('IP0', '11.0-14.7'),
array('IP1', '15.0-18.7')
);
for ($i=0; $i<$totalDevice; $i++){
$levelArr=explode('.',$ss7Info[$element[$i]][objIdStr]);
$where = " WHERE ";
for($j=0;$jgetSql=$getSql
";
$getRes = @mysqli_query($pubConn,$getSql);
$getRow = @mysqli_fetch_row($getRes);
if($DEBUG) echo "getRow=$getRow[0]
";
$ni = hexdec(getBitValue($getRow[0],$localNodeConfArr[0][1]));
$ss7Network[$i] = $netInfo[$ni];
echo "ss7Network[$i] = {$ss7Network[$i]}
";
$gtt[$i] = getBitValue($getRow[0],$localNodeConfArr[1][1]);
$gtt[$i] = str_replace('F','',$gtt[$i]);
if($gtt[$i] == ''){
$gtt[$i] = '--';
}
echo "gtt=$gtt[$i]
";
}
for ($i=0; $i<$totalDevice; $i++){
echo "";
echo "| $seqNo | ";
echo "$name[$i] | ";
echo "$element[$i] | ";
echo "$signallingPoint[$i] | ";
echo "$ss7Network[$i] | ";
echo " | ";
echo "$gtt[$i] | ";
echo "$state[$i] | ";
echo "$remarks[$i] | ";
echo " | ";
echo "
";
}
//Add an element
echo "";
echo "| ";
echo "New | ";
echo "
";
adjust_content_tail();
echo "";
echo "";
?>