pPas[$i]=$pPas[$i]"; $wPas = $wPas." AND level_$lNum = $pPas[$i] "; $i++; } //echo "
wPas=$wPas"; //Prefix attributes $oidPat = "2.1.2"; $pPat = explode(".",$oidPat); $i = 0; $wPat = ''; while(isset($pPat[$i])) { $lNum = $i+1; if($DEBUG) echo "
pPat[$i]=$pPat[$i]"; $wPat = $wPat." AND level_$lNum = $pPat[$i] "; $i++; } //echo "
wPat=$wPat"; //Assign TG to prefix $oidTg = "2.1.3"; $pTg = explode(".",$oidTg); $i = 0; $wTg = ''; while(isset($pTg[$i])) { $lNum = $i+1; if($DEBUG) echo "
pTg[$i]=$pTg[$i]"; $wTg = $wTg." AND level_$lNum = $pTg[$i] "; $i++; } //echo "
wTg=$wTg"; $wAnd = " AND level_1 = 2 AND level_2 = 1 AND (level_3 = 1 OR level_3 = 2 OR level_3 = 3) "; /************get default value**************/ $defSql = " SELECT initValue,level_3 FROM paramConf WHERE keyId > 0 ".$wAnd." ORDER BY level_3 "; $defRes = @mysqli_query($pubConn,$defSql); $defRow = @mysqli_fetch_array($defRes); do { $leve_3 = $defRow[level_3]; $defaultValue[$leve_3] = $defRow[initValue]; //echo "
defaultValue[$leve_3]=$defaultValue[$leve_3]"; }while($defRow = @mysqli_fetch_array($defRes)); $prefixFlagArr=array( array('num' => '0', 'remark' => 'N', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'Y', 'color' => '#0000FF') ); $inTonArr=array( array('num' => '0', 'remark' => 'Spare', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'SUB', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'UNK', 'color' => '#0000FF'), array('num' => '3', 'remark' => 'NDD', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'IDD', 'color' => '#0000FF'), array('num' => '5', 'remark' => 'Spare', 'color' => '#0000FF') ); $outTonArr=array( array('num' => '0', 'remark' => 'Spare', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'SUB', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'UNK', 'color' => '#0000FF'), array('num' => '3', 'remark' => 'NDD', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'IDD', 'color' => '#0000FF'), array('num' => '5', 'remark' => 'Spare', 'color' => '#0000FF') ); $cdrFlagArr=array( array('num' => '0', 'remark' => 'Off', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'On', 'color' => '#0000FF') ); if($DEFAULT_SYS == 'MSC'){ $proTypeArr=array( array('num' => '0', 'remark' => 'Trunk', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'MSISDN', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'MSRN', 'color' => '#0000FF'), array('num' => '3', 'remark' => 'MSC', 'color' => '#0000FF') ); $callTypeArr=array( array('num' => '0', 'remark' => 'Normal Call', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'Emergency', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'MCT', 'color' => '#FF0000'), array('num' => '3', 'remark' => 'IP', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'IN', 'color' => '#0000FF'), array('num' => '5', 'remark' => 'FC', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'Free Call', 'color' => '#0000FF'), ); }else{ $proTypeArr=array( array('num' => '0', 'remark' => 'Trunk', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'PBX', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'SUB', 'color' => '#0000FF'), array('num' => '3', 'remark' => '--', 'color' => '#0000FF') ); $callTypeArr=array( array('num' => '0', 'remark' => 'Normal', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'EM', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'MCT', 'color' => '#FF0000'), array('num' => '3', 'remark' => 'VMS', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'IN', 'color' => '#0000FF') ); } $tgTypeArr=array( array('num' => '0', 'remark' => 'PSTN', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'HPLMN', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'VPLMN', 'color' => '#0000FF'), array('num' => '3', 'remark' => 'subscriber', 'color' => '#0000FF'), array('num' => '4', 'remark' => '--', 'color' => '#0000FF') ); $camelFlagArr=array( array('num' => '0', 'remark' => 'N', 'color' => '#FF0000'), array('num' => '1', 'remark' => 'Y', 'color' => '#0000FF') ); $cliTypeArr = array( array('num' => '0', 'remark' => 'Sub', 'color' => '#0000FF'), array('num' => '1', 'remark' => 'NDD', 'color' => '#0000FF'), array('num' => '2', 'remark' => 'IDD', 'color' => '#0000FF'), array('num' => '3', 'remark' => 'UNK(local)', 'color' => '#0000FF'), array('num' => '4', 'remark' => 'UNK(NDD)', 'color' => '#0000FF'), array('num' => '5', 'remark' => 'UNK(IDD)', 'color' => '#0000FF') ); /************select value to see************/ //Attributes of TG $andSql = " SELECT level_3,instanceNo,initValue,readValue FROM $tb_2 WHERE subSysNo = '99' ".$wAnd." ORDER BY instanceNo "; if($DEBUG) echo "
andSql=$andSql"; $andRes = @mysqli_query($pubConn,$andSql); $andRow = @mysqli_fetch_array($andRes); echo mysqli_error($pubConn); do { $level_3 = $andRow[level_3]; $instanceNo = $andRow[instanceNo]; $initValue = $andRow[initValue]; //echo "
initValue=$initValue"; if($initValue == $defaultValue[$level_3]){ $andShow[$level_3][$instanceNo] = 0; }else{ $andShow[$level_3][$instanceNo] = 1; } //echo "
andShow[$level_3][$instanceNo]={$andShow[$level_3][$instanceNo]}"; if($level_3 == 1){ $prefixNum = $initValue; $pNum = explode("E",$prefixNum); $prefixNum=$prefixArr[$instanceNo][1] = $pNum[0]; //echo "
prefixArr[$instanceNo][1]={$prefixArr[$instanceNo][1]}"; }elseif($level_3 == 2){ $DEBUG = 0; $hex_0 = substr($initValue,0,2); if($DEBUG)echo "
hex_0=$hex_0"; $bin_0 = omc_keep_length(DecBin(HexDec($hex_0)),0,8); if($DEBUG)echo "
bin_0=$bin_0"; $inTon = $prefixArr[$instanceNo][2] = BinDec(substr($bin_0,4,4)); //echo "
inTon=$inTon"; $outTon = $prefixArr[$instanceNo][3] = BinDec(substr($bin_0,0,4)); //echo "
outTon=$outTon"; $hex_1 = substr($initValue,2,2); if($DEBUG)echo "
hex_1=$hex_1"; $bin_1 = omc_keep_length(DecBin(HexDec($hex_1)),0,8); if($DEBUG)echo "
bin_1=$bin_1"; $trkDelC = $prefixArr[$instanceNo][4] = BinDec(substr($bin_1,4,4)); if($DEBUG)echo "
trkDelC=$trkDelC"; $trkInsC = $prefixArr[$instanceNo][5] = BinDec(substr($bin_1,0,4)); if($DEBUG)echo "
trkInsC=$trkInsC"; $trkInsD = substr($initValue,4,16); $pTrk = explode("E",$trkInsD); $trkInsD = $prefixArr[$instanceNo][6] = $pTrk[0]; if($DEBUG)echo "
trkInsD=$trkInsD"; $hex_6 = substr($initValue,20,2); if($DEBUG)echo "
hex_6=$hex_6"; $bin_6 = omc_keep_length(DecBin(HexDec($hex_6)),0,8); if($DEBUG) echo "
bin_6=$bin_6"; $cdrFlag = $prefixArr[$instanceNo][7] = BinDec(substr($bin_6,7,1)); if($DEBUG)echo "
cdrFlag=$cdrFlag"; $proType = $prefixArr[$instanceNo][8] = BinDec(substr($bin_6,4,2)); if($DEBUG)echo "
proType=$proType"; $callType = $prefixArr[$instanceNo][9] = BinDec(substr($bin_6,1,3)); if($DEBUG)echo "
callType=$callType"; $prefixFlag = $prefixArr[$instanceNo][0] = BinDec(substr($bin_6,0,1)); if($DEBUG)echo "
prefixFlag=$prefixFlag"; $dLen = $prefixArr[$instanceNo][10] = HexDec(substr($initValue,22,2)); if($DEBUG)echo "
dLen=$dLen"; $hex_8 = substr($initValue,24,2); if($DEBUG)echo "
hex_8=$hex_8"; $bin_8 = omc_keep_length(DecBin(HexDec($hex_8)),0,8); if($DEBUG)echo "
bin_8=$bin_8"; $eDelC = $prefixArr[$instanceNo][11] = BinDec(substr($bin_8,4,4)); if($DEBUG)echo "
eDelC=$eDelC"; $eInsC = $prefixArr[$instanceNo][12] = BinDec(substr($bin_8,0,4)); if($DEBUG)echo "
eInsC=$eInsC"; $eInsD = substr($initValue,26,8); $pTrk = explode("E",$eInsD); $eInsD = $prefixArr[$instanceNo][13] = $pTrk[0]; if($DEBUG)echo "
eInsD=$eInsD"; $cliType = $prefixArr[$instanceNo][15] = hexdec(substr($initValue,34,2)); if($DEBUG) echo "cliType = $cliType
"; }else{ $tgNum = $prefixArr[$instanceNo][14] = HexDec($initValue); //echo "
prefixArr[$instanceNo][14]={$prefixArr[$instanceNo][14]}"; } }while($andRow = @mysqli_fetch_array($andRes)); $wDef = " AND ("; //for($i=0;$i<256;$i++) for($i=0;$i<1024;$i++) { if($andShow[1][$i] > 0 || $andShow[2][$i] > 0 || $andShow[3][$i] > 0){ $realShow[$i] = 1; //echo "
realShow[$i]=$realShow[$i]"; $wDef = $wDef." instanceNo = $i OR "; } } $wDef = substr($wDef,0,-3); $wDef = $wDef.")"; if(strlen($wDef) < 10){ $wDef = ' AND instanceNo < 0 '; } //echo "
wDef=$wDef"; //$realShow[0] = "1"; $scroll_x = isset($scroll_x)?$scroll_x:'0'; $scroll_y = isset($scroll_y)?$scroll_y:'0'; echo ""; echo "
"; ?> "; echo ""; echo ""; echo "Configuration > Network > Prefix overview"; echo ""; echo ""; //showHelp($helpId); echo ""; echo ""; echo "

$strBack"; echo ""; echo ""; ?> "; ?>

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "
No. Prefix In-TON Out-TON T-D-C T-I-C T-I-D CDR Properties Call type Digit-L M-D-C M-I-C M-I-D TG CLI
$i{$prefixArr[$i][1]} {$inTonArr[$prefixArr[$i][2]][remark]} {$outTonArr[$prefixArr[$i][3]][remark]} {$prefixArr[$i][4]} {$prefixArr[$i][5]} {$prefixArr[$i][6]} {$cdrFlagArr[$prefixArr[$i][7]][remark]} {$proTypeArr[$prefixArr[$i][8]][remark]} {$callTypeArr[$prefixArr[$i][9]][remark]} {$prefixArr[$i][10]} {$prefixArr[$i][11]} {$prefixArr[$i][12]} {$prefixArr[$i][13]} {$prefixArr[$i][14]} {$cliTypeArr[$prefixArr[$i][15]][remark]} 
"; echo ""; echo ""; ?>