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 "
| No. | $i | "; echo "