sysTypeNo = $sysTypeNo"; if($DEBUG) echo "
sysNo = $sysNo"; if($DEBUG) echo "
subSysNo = $subSysNo"; if($DEBUG) echo "
selectedDPC = $selectedDPC"; if($DEBUG) echo "
selectedSysId = $selectedSysId"; //产生菜单时,所依据的表名 $objDb = 'OBJ_'.$sysTypeNo; $confTable = 'paramConf'; //所链接的页面 $targetPage = 'paramConf_down_main.php'; //---------------------- //选择语言版本 if($language == 'eng'){ $showName = name_2; //语种2 }else{ $showName = name_1; //语种1 } //----------------------- echo""; //------------------------------------------------------------------------ //下面列出该菜单依赖的字段名,用逗号隔开 //**如果需要添加可显示的层数,以按相同格式更改$levelList和$levelNum //**例如:$levelList = "level_0,level_1,level_2,level_3,level_4.menu_6,menu_7,menu_8,menu_9,level_10.......level_n"; //** 并将$levelNum = n+1; $levelList = "level_1,level_2,level_3,level_4,level_5,level_6,level_7,level_8,level_9,level_10"; $levelNum = 10; //------------------------------------------------------------------------ if($subSysNo == '99'){ $isSysParam=1; }else{ $isSysParam=0; } ?> "; ?>
"; if(($sysNo == '99') || ($subSysNo == '99')){ if($sysNo == '99'){ $paramType = 2; if($sysTypeNo[0] == '2'){ if($sysTypeNo == '222' || $sysTypeNo == '223'|| $sysTypeNo == '260'){ $sysIdSql ="SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,sysAlias FROM $sysInfoTable,$sysConfTable WHERE $sysInfoTable.sysTypeNo=$sysConfTable.sysTypeNo AND $sysInfoTable.sysTypeNo = '$sysTypeNo' AND sysNo!='8' AND sysNo!='11' AND DPC='$selectedDPC' "; }else{ $sysIdSql ="SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,sysAlias FROM $sysInfoTable,$sysConfTable WHERE $sysInfoTable.sysTypeNo=$sysConfTable.sysTypeNo AND $sysInfoTable.sysTypeNo = '$sysTypeNo' AND sysNo='9' AND DPC='$selectedDPC' "; } }else{ $sysIdSql ="SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,sysAlias FROM $sysInfoTable,$sysConfTable WHERE $sysInfoTable.sysTypeNo=$sysConfTable.sysTypeNo AND $sysInfoTable.sysTypeNo = '$sysTypeNo' "; } }else{ $paramType = 1; $sysIdSql ="SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,sysAlias FROM $sysInfoTable,$sysConfTable WHERE $sysInfoTable.sysTypeNo=$sysConfTable.sysTypeNo AND $sysInfoTable.sysTypeNo = '$sysTypeNo' AND sysNo = '$sysNo' "; } if($DEBUG) echo "sysIdSql(1) = $sysIdSql
"; $result = mysqli_query($pubConn,$sysIdSql); echo mysqli_error($pubConn); $rowsNum=mysqli_num_rows($result); $rows=mysqli_fetch_array($result); $sysTypeName=$rows[sysTypeName]; if($rowsNum < 1){ echo " 
Can not find Any system be installed.
"; exit(); } if($sysNo == '99'){ echo "$sysTypeName"."_pub"; }else{ echo "$sysTypeName"."_$sysNo"."_pub"; } echo "   Select: "; echo ""; }else{ if ( ('222' == $sysTypeNo) || ('223' == $sysTypeNo) ) //MTP3 OR SCCP) $paramType = 2; else $paramType = 0; $sysIdSql ="SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,sysAlias FROM $sysInfoTable,$sysConfTable WHERE $sysInfoTable.sysTypeNo=$sysConfTable.sysTypeNo AND $sysInfoTable.sysTypeNo = '$sysTypeNo' AND sysNo = '$sysNo' AND subSysNo = '$subSysNo' "; if($DEBUG) echo "sysIdSql(2) = $sysIdSql
"; $result = mysqli_query($pubConn,$sysIdSql); echo mysqli_error($pubConn); $rowsNum=mysqli_num_rows($result); $rows=mysqli_fetch_array($result); $sysTypeName=$rows[sysTypeName]; if($rowsNum < 1){ echo " Can not find this system.
"; exit(); } echo "$sysTypeName"._."$sysNo"._."$subSysNo"; $sysAlias=$rows[sysAlias]; if(strlen($sysAlias)){ echo "   [$sysAlias]"; } } ?> '0' AND operType !='4' ORDER BY ".$levelList ; if($DEBUG) echo "
$treeMenuSql"; $treeMenuResult = mysqli_query($pubConn,$treeMenuSql); echo mysqli_error($pubConn); $n=0; while($treeMenuRows = @mysqli_fetch_array($treeMenuResult)){ //从第i层开始划分层次,第i层之前不参与显示算法 for($i=$bgnLevelNo; $i<=$levelNum; $i++){ $levelId = 'level_'.$i; $treeMenuArr[$n][$i-1]=$treeMenuRows[$levelId]; } $treeMenuArr[$n][$levelNum]=$treeMenuRows[$showName]; $treeMenuArr[$n][$levelNum+1]=$treeMenuRows[keyId]; $treeMenuArr[$n][$levelNum+2]=$treeMenuRows[paramType]; $n++; } /*************************************下面是顺序显示菜单程序***************************************/ for($i=0 ; $i < sizeof($treeMenuArr); $i++){ //从上到下 ---> 级 $objName = $treeMenuArr[$i][$levelNum]; $objKeyId= $treeMenuArr[$i][$levelNum+1]; $num=$bgnLevelNo; while($treeMenuArr[$i][$num] > 0){ $num++; } $lastLevelNum = $treeMenuArr[$i][$num - 1].'.'; $isSysParam = $treeMenuArr[$i][$levelNum+2]; $leaf_show = "".$lastLevelNum.' '.$objName.""; $knot_show = "".$lastLevelNum.' '.$objName.""; $show_1 = "\n$knot_show"; if($isSysParam > 0){ $show_2 = "\n $leaf_show"; $show_4 = "\n $leaf_show"; }else{ $show_2 = "\n $leaf_show"; $show_4 = "\n $leaf_show"; } $show_3 = "\n"; $show_5 = "\n"; echo""; }//end for($i=0 ; $i < sizeof($treeMenuArr); $i++) ?>
"; echo ""; for($j=0; $j < $levelNum;$j++){ //从左到右 ---> 层 if($treeMenuArr[$i][$j] > 0){ //如果该节点大于零 if($treeMenuArr[$i+1][$j] > $treeMenuArr[$i][$j] ){ //如果下面有树枝或页子与本节点(树枝或叶子)相连,即下面有兄弟节点 if($treeMenuArr[$i][$j+1] > 0){ //如果是树枝 echo "$show_3"; //show_3 }else{//叶子 echo "$show_2"; //show_2 } }else{//如果下面的节点号不大于本节点号 if($treeMenuArr[$i][$j+1] > 0){ //如果本节点不是叶子 $is_line =0; //标志位,用于标志同一树枝下面是否还有分支,或是直接连在本枝上的叶子。 //顺着上一层目录,向下查找 for($p=$i+1;$p < sizeof($treeMenuArr) && $treeMenuArr[$p][$j-1] == $treeMenuArr[$i][$j-1];$p++){ if($treeMenuArr[$p][$j] > $treeMenuArr[$i][$j]){ //找到了!!! $is_line = 1; break; } } if($is_line == 1){ //下面还有分支,或是直接连在本枝上的叶子 echo "$show_3"; //show_3 }else{//同一树枝下没有分支,或是连在本枝上的叶子 echo "$show_5"; //show_5 } }else{ //本节点是叶子 if($treeMenuArr[$i+1][$j+1] > 0){ //本节点有分叉,即有起点在本节点的子树 echo "$show_1"; //show_1 }else{//本节点是该树枝上最末一片页子 echo "$show_4"; //show_4 } } } //end else of if($treeMenuArr[$i+1][$j] > $treeMenuArr[$i][$j] ) } //end if($treeMenuArr[$i][$j] > 0) } //end for($j=0;$j < $levelNum;$j++) echo"