Location: PHPKode > projects > OpenDataCenter Network Management System > include/mainview_page/interface/view.php
<?php
// ----------------------------------------------------------------------
// Copyright (C) 2007 by GREGORY LE BRAS
// ----------------------------------------------------------------------
// LICENSE
//
// This file is part of ODCNMS - Open DataCenter Network Management System
// 
// ODCNMS is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
// 
// Foobar is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with Foobar; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
// ----------------------------------------------------------------------
// Original Author of file: GREGORY LE BRAS - http://www.odcnms.org/
// ----------------------------------------------------------------------
?>
<?php
$request=mysql_query("SELECT * FROM $name_table_interface WHERE id=\"$id\"") or die ("ERROR!");

while($tmp_request=mysql_fetch_array($request))
{
$interface_name = $tmp_request['name'];
?>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
	<tr>
		<td width="90%"><h4><img src="images/interface.gif" alt="interface" align="top"> <?php echo $tmp_request['name']; ?></h4></td>
		<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=interface&action=edit&id=<?php echo $id; ?>"><?php echo TXT_EDIT; ?></a> ]</td>
		</td>
	<tr>
</table>
<table class="list" width="100%" cellspacing="2" cellpadding="3">
<?php
$arrayifType[1] = "other";
		$arrayifType[2] = "regular1822";
		$arrayifType[3] = "hdh1822";
		$arrayifType[4] = "ddnX25";
		$arrayifType[5] = "rfc877x25";
		$arrayifType[6] = "ethernetCsmacd";
		$arrayifType[7] = "iso88023Csmacd";
		$arrayifType[8] = "iso88024TokenBus";
		$arrayifType[9] = "iso88025TokenRing";
		$arrayifType[10] = "iso88026Man";
		$arrayifType[11] = "starLan";
		$arrayifType[12] = "proteon10Mbit";
		$arrayifType[13] = "proteon80Mbit";
		$arrayifType[14] = "hyperchannel";
		$arrayifType[15] = "fddi";
		$arrayifType[16] = "lapb";
		$arrayifType[17] = "sdlc";
		$arrayifType[18] = "ds1";
		$arrayifType[19] = "e1";
		$arrayifType[20] = "basicISDN";
		$arrayifType[21] = "primaryISDN";
		$arrayifType[22] = "propPointToPointSerial";
		$arrayifType[23] = "ppp";
		$arrayifType[24] = "softwareLoopback";
		$arrayifType[25] = "eon";
		$arrayifType[26] = "ethernet3Mbit";
		$arrayifType[27] = "nsip";
		$arrayifType[28] = "slip";
		$arrayifType[29] = "ultra";
		$arrayifType[30] = "ds3";
		$arrayifType[31] = "sip";
		$arrayifType[32] = "frameRelay";
		$arrayifType[33] = "rs232";
		$arrayifType[34] = "para";
		$arrayifType[35] = "arcnet";
		$arrayifType[36] = "arcnetPlus";
		$arrayifType[37] = "atm";
		$arrayifType[38] = "miox25";
		$arrayifType[39] = "sonet";
		$arrayifType[40] = "x25ple";
		$arrayifType[41] = "iso88022llc";
		$arrayifType[42] = "localTalk";
		$arrayifType[43] = "smdsDxi";
		$arrayifType[44] = "frameRelayService";
		$arrayifType[45] = "v35";
		$arrayifType[46] = "hssi";
		$arrayifType[47] = "hippi";
		$arrayifType[48] = "modem";
		$arrayifType[49] = "aal5";
		$arrayifType[50] = "sonetPath";
		$arrayifType[51] = "sonetVT";
		$arrayifType[52] = "smdsIcip";
		$arrayifType[53] = "propVirtual";
		$arrayifType[54] = "propMultiplexor";
		$arrayifType[55] = "ieee80212";
		$arrayifType[56] = "fibreChannel";
		$arrayifType[57] = "hippiInterface";
		$arrayifType[58] = "frameRelayInterconnect";
		$arrayifType[59] = "aflane8023";
		$arrayifType[60] = "aflane8025";
		$arrayifType[61] = "cctEmul";
		$arrayifType[62] = "fastEther";
		$arrayifType[63] = "isdn";
		$arrayifType[64] = "v11";
		$arrayifType[65] = "v36";
		$arrayifType[66] = "g703at64k";
		$arrayifType[67] = "g703at2mb";
		$arrayifType[68] = "qllc";
		$arrayifType[69] = "fastEtherFX";
		$arrayifType[70] = "channel";
		$arrayifType[71] = "ieee80211";
		$arrayifType[72] = "ibm370parChan";
		$arrayifType[73] = "escon";
		$arrayifType[74] = "dlsw";
		$arrayifType[75] = "isdns";
		$arrayifType[76] = "isdnu";
		$arrayifType[77] = "lapd";
		$arrayifType[78] = "ipSwitch";
		$arrayifType[79] = "rsrb";
		$arrayifType[80] = "atmLogical";
		$arrayifType[81] = "ds0";
		$arrayifType[82] = "ds0Bundle";
		$arrayifType[83] = "bsc";
		$arrayifType[84] = "async";
		$arrayifType[85] = "cnr";
		$arrayifType[86] = "iso88025Dtr";
		$arrayifType[87] = "eplrs";
		$arrayifType[88] = "arap";
		$arrayifType[89] = "propCnls";
		$arrayifType[90] = "hostPad";
		$arrayifType[91] = "termPad";
		$arrayifType[92] = "frameRelayMPI";
		$arrayifType[93] = "x213";
		$arrayifType[94] = "adsl";
		$arrayifType[95] = "radsl";
		$arrayifType[96] = "sdsl";
		$arrayifType[97] = "vdsl";
		$arrayifType[98] = "iso88025CRFPInt";
		$arrayifType[99] = "myrinet";
		$arrayifType[100] = "voiceEM";
		$arrayifType[101] = "voiceFXO";
		$arrayifType[102] = "voiceFXS";
		$arrayifType[103] = "voiceEncap";
		$arrayifType[104] = "voiceOverIp";
		$arrayifType[105] = "atmDxi";
		$arrayifType[106] = "atmFuni";
		$arrayifType[107] = "atmIma";
		$arrayifType[108] = "pppMultilinkBundle";
		$arrayifType[109] = "ipOverCdlc";
		$arrayifType[110] = "ipOverClaw";
		$arrayifType[111] = "stackToStack";
		$arrayifType[112] = "virtualIpAddress";
		$arrayifType[113] = "mpc";
		$arrayifType[114] = "ipOverAtm";
		$arrayifType[115] = "iso88025Fiber";
		$arrayifType[116] = "tdlc";
		$arrayifType[117] = "gigabitEthernet";
		$arrayifType[118] = "hdlc";
		$arrayifType[119] = "lapf";
		$arrayifType[120] = "v37";
		$arrayifType[121] = "x25mlp";
		$arrayifType[122] = "x25huntGroup";
		$arrayifType[123] = "trasnpHdlc";
		$arrayifType[124] = "interleave";
		$arrayifType[125] = "fast";
		$arrayifType[126] = "ip";
		$arrayifType[127] = "docsCableMaclayer";
		$arrayifType[128] = "docsCableDownstream";
		$arrayifType[129] = "docsCableUpstream";
		$arrayifType[130] = "a12MppSwitch";
		$arrayifType[131] = "tunnel";
		$arrayifType[132] = "coffee";
		$arrayifType[133] = "ces";
		$arrayifType[134] = "atmSubInterface";
		$arrayifType[135] = "l2vlan";
		$arrayifType[136] = "l3ipvlan";
		$arrayifType[137] = "l3ipxvlan";
		$arrayifType[138] = "digitalPowerline";
		$arrayifType[139] = "mediaMailOverIp";
		$arrayifType[140] = "dtm";
		$arrayifType[141] = "dcn";
		$arrayifType[142] = "ipForward";
		$arrayifType[143] = "msdsl";
		$arrayifType[144] = "ieee1394";
		$arrayifType[145] = "if-gsn";
		$arrayifType[146] = "dvbRccMacLayer";
		$arrayifType[147] = "dvbRccDownstream";
		$arrayifType[148] = "dvbRccUpstream";
		$arrayifType[149] = "atmVirtual";
		$arrayifType[150] = "mplsTunnel";
		$arrayifType[151] = "srp";
		$arrayifType[152] = "voiceOverAtm";
		$arrayifType[153] = "voiceOverFrameRelay";
		$arrayifType[154] = "idsl";
		$arrayifType[155] = "compositeLink";
		$arrayifType[156] = "ss7SigLink";
		$arrayifType[157] = "propWirelessP2P";
		$arrayifType[158] = "frForward";
		$arrayifType[159] = "rfc1483";
		$arrayifType[160] = "usb";
		$arrayifType[161] = "ieee8023adLag";
		$arrayifType[162] = "bgppolicyaccounting";
		$arrayifType[163] = "frf16MfrBundle";
		$arrayifType[164] = "h323Gatekeeper";
		$arrayifType[165] = "h323Proxy";
		$arrayifType[166] = "mpls";
		$arrayifType[167] = "mfSigLink";
		$arrayifType[168] = "hdsl2";
		$arrayifType[169] = "shdsl";
		$arrayifType[170] = "ds1FDL";
		$arrayifType[171] = "pos";
		$arrayifType[172] = "dvbAsiIn";
		$arrayifType[173] = "dvbAsiOut";
		$arrayifType[174] = "plc";
		$arrayifType[175] = "nfas";
		$arrayifType[176] = "tr008";
		$arrayifType[177] = "gr303RDT";
		$arrayifType[178] = "gr303IDT";
		$arrayifType[179] = "isup";
		$arrayifType[180] = "propDocsWirelessMaclayer";
		$arrayifType[181] = "propDocsWirelessDownstream";
		$arrayifType[182] = "propDocsWirelessUpstream";
		$arrayifType[183] = "hiperlan2";
		$arrayifType[184] = "propBWAp2Mp";
		$arrayifType[185] = "sonetOverheadChannel";
		$arrayifType[186] = "digitalWrapperOverheadChannel";
		$arrayifType[187] = "aal2";
		$arrayifType[188] = "radioMAC";
		$arrayifType[189] = "atmRadio";
		$arrayifType[190] = "imt";
		$arrayifType[191] = "mvl";
		$arrayifType[192] = "reachDSL";
		$arrayifType[193] = "frDlciEndPt";
		$arrayifType[194] = "atmVciEndPt";
		$arrayifType[195] = "opticalChannel";
		$arrayifType[196] = "opticalTransport";
		$arrayifType[197] = "propAtm";
		$arrayifType[198] = "voiceOverCable";
		$arrayifType[199] = "infiniband";
		$arrayifType[200] = "teLink";
		$arrayifType[201] = "q2931";
		$arrayifType[202] = "virtualTg";
		$arrayifType[203] = "sipTg";
		$arrayifType[204] = "sipSig";
		$arrayifType[205] = "docsCableUpstreamChannel";
		$arrayifType[206] = "econet";
		$arrayifType[207] = "pon155";
		$arrayifType[208] = "pon622";
		$arrayifType[209] = "bridge";
		$arrayifType[210] = "linegroup";
		$arrayifType[211] = "voiceEMFGD";
		$arrayifType[212] = "voiceFGDEANA";
		$arrayifType[213] = "voiceDID";
		$arrayifType[214] = "mpegTransport";
		$arrayifType[215] = "sixToFour";
		$arrayifType[216] = "gtp";
		$arrayifType[217] = "pdnEtherLoop1";
		$arrayifType[218] = "pdnEtherLoop2";
		$arrayifType[219] = "opticalChannelGroup";
		$arrayifType[220] = "homepna";
		$arrayifType[221] = "gfp";
		$arrayifType[222] = "ciscoISLvlan";
		$arrayifType[223] = "actelisMetaLOOP";
		$arrayifType[224] = "fcipLink";
		$arrayifType[225] = "rpr";
		$arrayifType[226] = "qam";
		$arrayifType[227] = "lmp";
		$arrayifType[228] = "cblVectaStar";
		$arrayifType[229] = "docsCableMCmtsDownstream";
		$arrayifType[230] = "adsl2";
		$arrayifType[231] = "macSecControlledIF";
		$arrayifType[232] = "macSecUncontrolledIF";
		$arrayifType[233] = "aviciOpticalEther";
		$arrayifType[234] = "atmbond";
		$arrayifType[235] = "voiceFGDOS";
		$arrayifType[236] = "mocaVersion1";
		$arrayifType[237] = "ieee80216WMAN";
		$arrayifType[238] = "adsl2plus";
		$arrayifType[239] = "dvbRcsMacLayer";
		$arrayifType[240] = "dvbTdm";
		$arrayifType[241] = "dvbRcsTdma";
		$arrayifType[242] = "x86Laps";
		
		$request=mysql_query("SELECT * FROM $name_table_interface WHERE id=\"$id\"") or die ("ERROR!");

		while($tmp_request=mysql_fetch_array($request))
		{	
			echo "<tr class=\"list_title\">
				<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_INDEX.":</b> $tmp_request[index]</td>
			</tr>";	
			echo "<tr class=\"list_title\">
				<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_NAME.":</b> $tmp_request[name]</td>
			</tr>";				
			foreach ($arrayifType as $key => $arrayvalue)
			{
				if ($key == $tmp_request['type'])
				{
					echo "<tr class=\"list_title\">
						<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_TYPE.":</b> $arrayvalue</td>
					</tr>";						
				}
			}
			switch ($tmp_request['speed'])
			{
				case '10':
				echo "<tr class=\"list_title\">
					<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_SPEED.":</b> 10 Mbps</td>
				</tr>";		
				break;
				
				case '100':
				echo "<tr class=\"list_title\">
					<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_SPEED.":</b> 10/100 Mbps</td>
				</tr>";	
				break;
				
				case '1000':
				echo "<tr class=\"list_title\">
					<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_SPEED.":</b>  10/100/1000 Mbps</td>
				</tr>";					
				break;

				default:
				echo "<tr class=\"list_title\">
					<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_SPEED.":</b> ".$tmp_request['speed']." Mbps</td>
				</tr>";					
				break;        
			}			
			echo "<tr class=\"list_title\">
				<td width=\"100%\" style=\"font-weight:normal;\"><b>".TXT_DESCRIPTION.":</b> $tmp_request[description]</td>
			</tr></table>";	
			
			$request_count_interface_interface=mysql_query("SELECT count(*) FROM $name_table_link_interface_interface WHERE interface_id=\"$id\" OR interface2_id=\"$id\"") or die ("ERROR!");
			$result_interface_interface = mysql_fetch_array($request_count_interface_interface);
			
			$request_count_port_interface=mysql_query("SELECT count(*) FROM $name_table_link_port_interface WHERE interface_id=\"$id\"") or die ("ERROR!");
			$result_port_interface = mysql_fetch_array($request_count_port_interface);			
			
			if (($result_interface_interface[0]!="0") || ($result_port_interface[0]!="0"))
			{
?>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
	<tr>
		<td width="100%"><h4><img src="images/link.gif" alt="Link" align="top"> <?php echo TXT_LINK_BETWEEN; ?></h4></td>
	<tr>
</table>
<table width="100%" cellspacing="2" cellpadding="3">
<?php
		$request=mysql_query("SELECT * FROM $name_table_link_interface_interface WHERE interface_id=\"$id\" OR interface2_id=\"$id\"") or die ("ERROR!");

		while($tmp_request=mysql_fetch_array($request))
		{				
			$request2=mysql_query("SELECT id,slot_id,name FROM $name_table_interface WHERE id=\"$tmp_request[interface_id]\"") or die ("ERROR12!");

			while($tmp_request2=mysql_fetch_array($request2))
			{
				echo "<tr><td><img src=\"images/interface.gif\" alt=\"Interface\" align=\"top\"> Interface $tmp_request2[name] of slot";
				
				$request3=mysql_query("SELECT id,name,device_id FROM $name_table_slot WHERE id=\"$tmp_request2[slot_id]\"") or die ("ERROR12!");
				while($tmp_request3=mysql_fetch_array($request3))
				{
					echo " <a href=\"index.php?include=mainview&page=slot&action=view&id=$tmp_request3[id]\">$tmp_request3[name]</a> ";
					echo "and device";
					
					$request4=mysql_query("SELECT id,name FROM $name_table_device WHERE id=\"$tmp_request3[device_id]\"") or die ("ERROR12!");
					while($tmp_request4=mysql_fetch_array($request4))
					{
						echo " <a href=\"index.php?include=mainview&page=device&action=view&id=$tmp_request4[id]\">$tmp_request4[name]</a></td></tr>";
					}					
				}			
			}
			
			$request2=mysql_query("SELECT id,slot_id,name FROM $name_table_interface WHERE id=\"$tmp_request[interface2_id]\"") or die ("ERROR12!");

			while($tmp_request2=mysql_fetch_array($request2))
			{
				echo "<tr><td><img src=\"images/interface.gif\" alt=\"Interface\" align=\"top\"> Interface $tmp_request2[name] of slot";
				
				$request3=mysql_query("SELECT id,name,device_id FROM $name_table_slot WHERE id=\"$tmp_request2[slot_id]\"") or die ("ERROR12!");
				while($tmp_request3=mysql_fetch_array($request3))
				{
					echo " <a href=\"index.php?include=mainview&page=slot&action=view&id=$tmp_request3[id]\">$tmp_request3[name]</a> ";
					echo "and device";
					
					$request4=mysql_query("SELECT id,name FROM $name_table_device WHERE id=\"$tmp_request3[device_id]\"") or die ("ERROR12!");
					while($tmp_request4=mysql_fetch_array($request4))
					{
						echo " <a href=\"index.php?include=mainview&page=device&action=view&id=$tmp_request4[id]\">$tmp_request4[name]</a></td></tr>";
					}					
				}			
			}
			echo "<tr><td>[ <a href=\"index.php?include=mainview&page=link&action=edit&what=interface_interface&id_interface1=$tmp_request[interface_id]&id_interface2=$tmp_request[interface2_id]\">".TXT_EDIT."</a> ]</tr></td>";
			echo "</table>";			
		}
		
		$request=mysql_query("SELECT * FROM $name_table_link_port_interface WHERE interface_id=\"$id\"") or die ("ERROR!");

		while($tmp_request=mysql_fetch_array($request))
		{	
			$request2=mysql_query("SELECT id,slot_id,name FROM $name_table_interface WHERE id=\"$tmp_request[interface_id]\"") or die ("ERROR12!");

			while($tmp_request2=mysql_fetch_array($request2))
			{
				echo "<tr><td><img src=\"images/interface.gif\" alt=\"Interface\" align=\"top\"> Interface $tmp_request2[name] of slot";
				
				$request3=mysql_query("SELECT id,number,device_id FROM $name_table_slot WHERE id=\"$tmp_request2[slot_id]\"") or die ("ERROR12!");
				while($tmp_request3=mysql_fetch_array($request3))
				{
					echo " <a href=\"index.php?include=mainview&page=slot&action=view&id=$tmp_request3[id]\">$tmp_request3[number]</a> ";
					echo "and device";
					
					$request4=mysql_query("SELECT id,name FROM $name_table_device WHERE id=\"$tmp_request3[device_id]\"") or die ("ERROR1!");
					while($tmp_request4=mysql_fetch_array($request4))
					{
						echo " <a href=\"index.php?include=mainview&page=device&action=view&id=$tmp_request4[id]\">$tmp_request4[name]</a></td></tr>";
					}					
				}			
			}
			
			$request2=mysql_query("SELECT id,patch_panel_id,name FROM $name_table_port WHERE id=\"$tmp_request[port_id]\"") or die ("ERROR1!");

			while($tmp_request2=mysql_fetch_array($request2))
			{
				echo "<tr><td><img src=\"images/port.gif\" alt=\"Port\" align=\"top\"> Port number $tmp_request2[name] of patch panel";
				
				$request3=mysql_query("SELECT id,name FROM $name_table_patch_panel WHERE id=\"$tmp_request2[patch_panel_id]\"") or die ("ERROR1!");
				while($tmp_request3=mysql_fetch_array($request3))
				{
					echo " <a href=\"index.php?include=mainview&page=patch_panel&action=view&id=$tmp_request3[id]\">$tmp_request3[name]</a></td></tr>";
				}
			}
			echo "<tr><td>[ <a href=\"index.php?include=mainview&page=link&action=edit&what=port_interface&id_port=$tmp_request[port_id]&id_interface=$tmp_request[interface_id]\">".TXT_EDIT."</a> ]</tr></td>";			
			echo "</table>";
		}
	}
	else
	{
?>
		<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
			<tr>
				<td width="90%"><h4><img src="images/link.gif" alt="Link" align="top"> <?php echo TXT_LINK_BETWEEN; ?></h4></td>
				<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=link&action=add&id_interface=<?php echo$tmp_request['id']; ?>"><?php echo TXT_ADD; ?> <?php echo TXT_LINK; ?></a> ]</td>
			<tr>
		</table>
<?php		
	}	
}
?>
<br><center><a href="javascript:history.go(-1);"><?php echo TXT_BACK; ?></a></center>
<?php
}
?>
Return current item: OpenDataCenter Network Management System