"; global $pubConn; $DEBUG = 0; $mode = $_REQUEST['mode']; $sysTypeNo = $_REQUEST['sysTypeNo']; $save = $_POST['save']; if($DEBUG) echo "
mode=$mode"; $sysConfTable = 'OMC_PUB.sysConf'; $sysInfoTable = 'OMC_PUB.sysInfo'; $sysInfoDefTable = 'OMC_PUB.sysInfoDef'; $pubDb ='OMC_PUB'; $netIdDefArr=array(array('0', "international network"), array('1', "international network spare"), array('2', "national network"), array('3', "national network spare") ); if($DEBUG) echo "
sysId=$sysId"; if(isset($sysId) && strlen($sysId) > 5){ $sysIdArr = explode('_',$sysId); $sysTypeNo = $sysIdArr[0]; $sysNo = $sysIdArr[1]; $subSysNo = $sysIdArr[2]; if($DEBUG) echo "
sysTypeNo=$sysTypeNo"; if($DEBUG) echo "
sysNo=$sysNo"; if($DEBUG) echo "
subSysNo=$subSysNo"; } if($sysTypeNo == '500' && isset($bssId)){ if($DEBUG) echo "
Process BSS's return......"; if(isset($errorInfo)){ echo "
Error:$errorInfo"; if($mode == 'delete'){ $delSql = "DELETE FROM $sysInfoTable WHERE sysTypeNo='$sysTypeNo' AND sysNo = '$sysNo' AND subSysNo = '$subSysNo' AND ip = '$ip' "; if($DEBUG) echo "
delSql = $delSql"; mysqli_query($pubConn,$delSql); //echo "
Delete BSS$bssId OK"; //if(!$DEBUG) echo " "; //exit(); } exit(); }else{ if($mode == 'add'){ $addSql = "REPLACE INTO $sysInfoTable (sysTypeNo,sysNo,subSysNo,isRemote,netId,DPC,ip,baseStat,sysAlias,updateTime ) VALUES('$sysTypeNo','$sysNo','$subSysNo','$isRemote','$netId','$DPC','$ip','1','$sysAlias',CURRENT_TIMESTAMP) "; if($DEBUG) echo "
addSql = $addSql"; $result = mysqli_query($pubConn,$addSql); echo mysqli_error($pubConn); echo "
Create BSS$bssId OK"; $mode = 'edit'; }elseif($mode == 'delete'){ $delSql = "DELETE FROM $sysInfoTable WHERE sysTypeNo='$sysTypeNo' AND sysNo = '$sysNo' AND subSysNo = '$subSysNo' AND ip = '$ip' "; if($DEBUG) echo "
delSql = $delSql"; mysqli_query($pubConn,$delSql); echo "
Delete BSS$bssId OK"; if(!$DEBUG) echo " "; exit(); }else{ echo "Error:Unknown mode($mode)"; exit(); } } } if(isset($save) && $save != '-1'){ if($sysTypeNo == '500' && $mode=='add'){ $sysId= $sysTypeNo.'_'.$sysNo.'_'.$subSysNo; $addBssUrl="../../bssomc/bsstable.php?mode=add&sysId=$sysId&ip=$ip&remark=$sysAlias&language=$language"; echo " "; exit(); } if($mode=='add'){ $addSql = "REPLACE INTO $sysInfoTable (sysTypeNo,sysNo,subSysNo,isRemote,netId,DPC,ip,baseStat,sysAlias,updateTime ) VALUES('$sysTypeNo','$sysNo','$subSysNo','$isRemote','$netId','$DPC','$ip','1','$sysAlias',CURRENT_TIMESTAMP) "; if($DEBUG) echo "
addSql = $addSql"; $result = mysqli_query($pubConn,$addSql); echo mysqli_error($pubConn); $sysId=$sysTypeNo.'_'.$sysNo.'_'.$subSysNo; $mode = 'edit'; }else{ $sysIdArr = explode('_',$sysId); $sysTypeNo = $sysIdArr[0]; $sysNo = $sysIdArr[1]; $subSysNo = $sysIdArr[2]; $saveSql = "UPDATE $sysInfoTable SET isRemote='$isRemote',netId='$netId',DPC='$DPC',ip ='$ip', baseStat='$baseStat',sysAlias='$sysAlias',updateTime = CURRENT_TIMESTAMP WHERE sysTypeNo='$sysTypeNo' AND sysNo = '$sysNo' AND subSysNo = '$subSysNo' "; if($DEBUG) echo "
saveSql = $saveSql"; $result = mysqli_query($pubConn,$saveSql); echo mysqli_error($pubConn); } if($result > 0){ echo "
OK!"; }else{ echo "
Error!"; } if(!$DEBUG) echo " "; exit(); }elseif($mode =='delete'){ $sysIdArr = explode('_',$sysId); $sysTypeNo = $sysIdArr[0]; $sysNo = $sysIdArr[1]; $subSysNo = $sysIdArr[2]; if($sureDel == 'Yes'){ if($sysTypeNo == '500'){ echo " "; exit(); }else{ $delSql = "DELETE FROM $sysInfoTable WHERE sysTypeNo='$sysTypeNo' AND sysNo = '$sysNo' AND subSysNo = '$subSysNo' AND ip = '$ip' "; if($DEBUG) echo "
delSql = $delSql"; mysqli_query($pubConn,$delSql); echo "
Delete ok"; echo " "; } exit(); }elseif($sureDel == 'No'){ echo "
Delete Canceled"; $mode='edit'; }else{ echo "Are you sure to delete system information of $sysName ?"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; exit(); } } if(isset($sysId)){ $sysIdArr = explode('_',$sysId); $sysTypeNo = $sysIdArr[0]; $sysNo = $sysIdArr[1]; $subSysNo = $sysIdArr[2]; } if($mode == 'edit'){ $sysListSql = "SELECT sysTypeName,$sysInfoTable.sysTypeNo,sysNo,subSysNo,isRemote,netId,DPC,ip,baseStat,sysAlias,updateTime FROM $sysConfTable,$sysInfoTable WHERE $sysConfTable.sysTypeNo = $sysInfoTable.sysTypeNo AND $sysInfoTable.sysTypeNo='$sysTypeNo' AND $sysInfoTable.sysNo = '$sysNo' AND $sysInfoTable.subSysNo = '$subSysNo' AND $sysInfoTable.ip = '$ip' ORDER BY $sysInfoTable.sysTypeNo,sysNo,subSysNo,updateTime"; if($DEBUG) echo "

sysListSql = $sysListSql"; $sysListResult = mysqli_query($pubConn,$sysListSql); echo mysqli_error($pubConn); $sysListRows= @mysqli_fetch_array($sysListResult); $isRemote = $sysListRows[isRemote]; $netId = $sysListRows[netId]; $DPC = $sysListRows[DPC]; } ?>

" > "; echo ""; echo ""; $baseStatArr=array(array('1',"Normal"),array('0',"False")); //do{ echo ""; //===isRemote=== echo ""; echo ""; //===netId=== echo ""; echo ""; echo ""; //===DPC=== echo ""; echo ""; echo ""; //===ip== echo ""; if(isset($ip)){ echo ""; }else{ echo ""; } echo ""; //}while($sysId != 'add' && $sysListRows=@mysql_fetch_array($sysListResult)); echo ""; echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

system Name	"; if($mode == 'add'){ echo ""; echo "system Type"; echo ""; //显示选择设备类型下拉菜单 $sysTypeSql ="SELECT sysTypeNo,sysTypeName,maxSysNum,maxSubSysNum FROM $sysConfTable WHERE needInstall > '0' ORDER BY sysTypeNo "; if($DEBUG) echo " $sysTypeSql"; $sysTypeResult = mysqli_query($pubConn,$sysTypeSql); $sysTypeRows = @mysqli_fetch_array($sysTypeResult); if(!isset($sysTypeNo)){ $sysTypeNo=$sysTypeRows[sysTypeNo]; } do{ echo ""; echo "$sysTypeRows[sysTypeName]"; echo ""; }while($sysTypeRows = mysqli_fetch_array($sysTypeResult)); echo ""; //显示选择系统编号下拉菜单 echo "sysNo:"; echo ""; if($sysTypeNo >= 222 && $sysTypeNo <= 225){ for($i=0;$i$i [{$PlatTypeDefArr[$i][remark]}]"; } }else{ for($i=0;$i<$maxSysNum;$i++){ echo "$i"; } } echo ""; //显示选择子系统编号下拉菜单 echo "subSysNo:"; echo ""; for($i=0;$i<$maxSubSysNum;$i++){ echo "$i"; } echo ""; echo ""; }else{ echo ""; $sysName = $sysListRows[sysTypeName].'_'.$sysListRows[sysNo].'_'.$sysListRows[subSysNo]; echo "$sysName "; echo ""; } echo "
Network Type	"; echo ""; if(isset($isRemote) && $isRemote == '1'){ echo "Ethernet"; echo "SS7(E1)"; }else{ echo "Ethernet"; echo "SS7(E1)"; } echo "
Net ID:	"; for($i=0;$i{$netIdDefArr[$i][1]}"; }else{ echo "{$netIdDefArr[$i][1]}"; } } echo "
DPC:
IP:
baseStatus:	"; for($i=0;$i{$baseStatArr[$i][1]}"; }else{ echo "{$baseStatArr[$i][1]}"; } } echo "
updateTime:	$sysListRows[updateTime]
Alias:

"; echo "  "; echo "  "; echo ""; echo ""; echo ""; adjust_content_tail("down"); ?>