<?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_location WHERE id=\"$id\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$location_name = $tmp_request['name'];
?>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="80%"><h4><img src="images/location.gif" alt="Location" align="top"> <?php echo $tmp_request['name']; ?></h4></td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=location&action=edit&id=<?php echo $id; ?>"><?php echo TXT_EDIT; ?></a> ]</td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=location&action=delete&id=<?php echo $id; ?>"><?php echo TXT_DELETE; ?></a> ]</td>
<tr>
</table>
<table class="list" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><?php echo $tmp_request['description']; ?></td>
</tr>
</table>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90%"><h4><img src="images/rack.gif" alt="Rack" align="top"> <?php echo TXT_ALL; ?> "<?php echo $location_name; ?>" <?php echo TXT_RACKS; ?></h4></td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=rack&action=add"><?php echo TXT_ADD; ?></a> ]</td>
<tr>
</table>
<table class="sortable list" id="sortable" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td width="38%"><?php echo TXT_NAME; ?></td>
<td width="50%"><?php echo TXT_DESCRIPTION; ?></td>
<td width="12%" class="unsortable"><?php echo TXT_ACTION; ?></td>
</tr>
<?php
$list1 = "list1";
$list2 = "list2";
$line_count = 0;
$request=mysql_query("SELECT * FROM $name_table_rack WHERE location_id=\"$id\" ORDER BY name ASC") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$line_color = ($line_count % 2) ? $list1 : $list2;
?>
<tr class="<?php echo "$line_color"; ?>">
<td width="38%" valign="top"><?php print("<a href=\"index.php?include=mainview&page=rack&action=view&id=$tmp_request[id]\">$tmp_request[name]</a>"); ?></td>
<td width="50%" valign="top"><?php echo $tmp_request['description']; ?></td>
<td width="12%" valign="top">[ <?php print("<a href=\"index.php?include=mainview&page=rack&action=edit&id=$tmp_request[id]\">".TXT_EDIT."</a>"); ?> ] [ <?php print("<a href=\"index.php?include=mainview&page=rack&action=delete&id=$tmp_request[id]\">".TXT_DELETE."</a>"); ?> ]</td>
</tr>
<?php
$line_count++;
}
?>
</table>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90%"><h4><img src="images/customer.gif" alt="Customer" align="top"> <?php echo TXT_ALL; ?> "<?php echo $location_name; ?>" <?php echo TXT_CUSTOMERS; ?></h4></td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=customer&action=add"><?php echo TXT_ADD; ?></a> ]</td>
<tr>
</table>
<table class="sortable list" id="sortable" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td width="28%" valign="top"><?php echo TXT_NAME; ?></td>
<td width="60%" valign="top"><?php echo TXT_DESCRIPTION; ?></td>
<td width="12%" valign="top" class="unsortable"><?php echo TXT_ACTION; ?></td>
</tr>
<?php
$list1 = "list1";
$list2 = "list2";
$line_count = 0;
$customer_count = 0;
$subnet_array = array();
$customer_array = array();
$request2=mysql_query("SELECT id FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$request3=mysql_query("SELECT id,ip_address_id FROM $name_table_device WHERE rack_id=\"$tmp_request2[id]\"") or die ("ERROR!");
while($tmp_request3=mysql_fetch_array($request3))
{
$request4=mysql_query("SELECT id,subnet_id FROM $name_table_ip_address WHERE id=\"$tmp_request3[ip_address_id]\"") or die ("ERROR!");
while($tmp_request4=mysql_fetch_array($request4))
{
array_push ($subnet_array, "$tmp_request4[subnet_id]");
}
$request_link_subnet=mysql_query("SELECT * FROM $name_table_link_vlan_device WHERE device_id=\"$tmp_request3[id]\"") or die ("ERROR!");
while($tmp_request_link_subnet=mysql_fetch_array($request_link_subnet))
{
$request_link_vlan=mysql_query("SELECT * FROM $name_table_link_subnet_vlan WHERE vlan_id=\"$tmp_request_link_subnet[vlan_id]\"") or die ("ERROR!");
while($tmp_request_link_vlan=mysql_fetch_array($request_link_vlan))
{
array_push ($subnet_array, "$tmp_request_link_vlan[subnet_id]");
}
}
}
}
$result = array_unique ($subnet_array);
foreach ($result as $key => $arrayvalue)
{
$request5=mysql_query("SELECT customer_id FROM $name_table_link_customer_subnet WHERE subnet_id=\"$arrayvalue\"") or die ("ERROR!");
while($tmp_request5=mysql_fetch_array($request5))
{
$request6=mysql_query("SELECT id FROM $name_table_customer WHERE id=\"$tmp_request5[customer_id]\"") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
array_push ($customer_array, "$tmp_request6[id]");
}
}
}
$result2 = array_unique ($customer_array);
foreach ($result2 as $key => $arrayvalue2)
{
$request6=mysql_query("SELECT id,name,description FROM $name_table_customer WHERE id=\"$arrayvalue2\"") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
$line_color = ($line_count % 2) ? $list1 : $list2;
echo "<tr class=\"$line_color\">
<td width=\"28%\" valign=\"top\"><a href=\"index.php?include=mainview&page=customer&action=view&id=$tmp_request6[id]\">$tmp_request6[name]</a></td>
<td width=\"60%\" valign=\"top\">$tmp_request6[description]</td>
<td width=\"12%\" valign=\"top\">[ <a href=\"index.php?include=mainview&page=customer&action=edit&id=$tmp_request6[id]\">".TXT_EDIT."</a> ] [ <a href=\"index.php?include=mainview&page=customer&action=delete&id=$tmp_request6[id]\">".TXT_DELETE."</a> ]</td>
</tr>";
$line_count++;
$customer_count++;
}
}
?>
</table>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90%"><h4><img src="images/network.gif" alt="Networks" align="top"> <?php echo TXT_ALL; ?> "<?php echo $location_name; ?>" <?php echo TXT_NETWORKS; ?></h4></td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=network&action=add"><?php echo TXT_ADD; ?></a> ]</td>
<tr>
</table>
<table class="sortable list" id="sortable" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td class="unsortable" width="20%" valign="top"><?php echo TXT_NAME; ?></td>
<td width="10%" valign="top"><?php echo TXT_ADDRESS; ?></td>
<td width="12%" valign="top"><?php echo TXT_MASK; ?></td>
<td width="36%" valign="top"><?php echo TXT_DESCRIPTION; ?></td>
<td class="unsortable" width="12%" valign="top"><?php echo TXT_ACTION; ?></td>
</tr>
<?php
$list1 = "list1";
$list2 = "list2";
$line_count = 0;
$network_count = 0;
$ip_address_array = array();
$network_array = array();
$i = 0;
$request2=mysql_query("SELECT id FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$request3=mysql_query("SELECT id,ip_address_id FROM $name_table_device WHERE rack_id=\"$tmp_request2[id]\"") or die ("ERROR!");
while($tmp_request3=mysql_fetch_array($request3))
{
array_push ($ip_address_array, "$tmp_request3[ip_address_id]");
$request_link_device_ip_address = mysql_query("SELECT * FROM $name_table_link_device_ip_address WHERE device_id=\"$tmp_request3[id]\"") or die ("ERROR!");
while ($tmp_request_link_device_ip_address=mysql_fetch_array($request_link_device_ip_address))
{
array_push ($ip_address_array, "$tmp_request_link_device_ip_address[ip_address_id]");
}
}
$result = array_unique ($ip_address_array);
foreach ($result as $key => $arrayvalue)
{
$request4=mysql_query("SELECT id,subnet_id FROM $name_table_ip_address WHERE id=\"$arrayvalue\" ") or die ("ERROR!");
while($tmp_request4=mysql_fetch_array($request4))
{
$request5=mysql_query("SELECT network_id FROM $name_table_subnet WHERE id=\"$tmp_request4[subnet_id]\"") or die ("ERROR!");
while($tmp_request5=mysql_fetch_array($request5))
{
$request6=mysql_query("SELECT id,name,address,mask,description FROM $name_table_network WHERE id=\"$tmp_request5[network_id]\"") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
array_push ($network_array, "$tmp_request6[id]");
}
}
}
}
}
$result2 = array_unique ($network_array);
foreach ($result2 as $key2 => $arrayvalue2)
{
$request6=mysql_query("SELECT id,name,address,mask,description FROM $name_table_network WHERE id=\"$arrayvalue2\"") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
$line_color = ($line_count % 2) ? $list1 : $list2;
$requestcount=mysql_query("SELECT count(status) FROM $name_table_subnet WHERE network_id=$tmp_request6[id]") or die ("ERROR!");
$all_subnet = mysql_fetch_array($requestcount);
$requestcount_assigned=mysql_query("SELECT count(status) FROM $name_table_subnet WHERE network_id=$tmp_request6[id] AND status='0'") or die ("ERROR!");
$all_subnet_assigned = mysql_fetch_array($requestcount_assigned);
$requestcount_unused=mysql_query("SELECT count(status) FROM $name_table_subnet WHERE network_id=$tmp_request6[id] AND status='1'") or die ("ERROR!");
$all_subnet_unused = mysql_fetch_array($requestcount_unused);
$requestcount_reserved=mysql_query("SELECT count(status) FROM $name_table_subnet WHERE network_id=$tmp_request6[id] AND status='2'") or die ("ERROR!");
$all_subnet_reserved = mysql_fetch_array($requestcount_reserved);
?>
<table class="list" width="100%" cellspacing="2" cellpadding="3">
<tr class="<?php echo "$line_color"; ?>">
<td width="20%" valign="top"><?php print("<a href='#' onclick=\"displayelement('ajaxcontentarea_$i');urlredirectdiv('ajax_view.php?what=displaysubnet&id=$tmp_request6[id]','ajaxcontentarea_$i');\"><img id='arrow_$i' src=\"images/arrow_up.gif\" border='0' align='top' onclick=\"changeimage('images/arrow_up.gif','images/arrow_down.gif','arrow_$i');\"></a><a href=\"index.php?include=mainview&page=network&action=view&id=$tmp_request6[id]\">$tmp_request6[name]</a>");
if ((($all_subnet_assigned[0]!=$all_subnet[0]) || ($all_subnet[0]==0)))
{
echo " (<font style='background-color:#0000ff;color:#fff;'>$all_subnet_assigned[0]</font> | <font style='background-color:#00ff00;color:#fff;'>$all_subnet_unused[0]</font> | <font style='background-color:#ff0000;color:#fff;'>$all_subnet_reserved[0]</font> / $all_subnet[0])";
}
?></td>
<td width="10%" valign="top"><?php echo $tmp_request6['address']; ?></td>
<td width="12%" valign="top"><?php echo $tmp_request6['mask']; $net = find_net($tmp_request6['address'],$tmp_request6['mask']); echo " (".$net['cidr'].")";?></td>
<td width="36%" valign="top"><?php echo $tmp_request6['description']; ?></td>
<td width="12%" valign="top">[ <?php print("<a href=\"index.php?include=mainview&page=network&action=edit&id=$tmp_request6[id]\">"); echo TXT_EDIT; echo "</a>"; ?> ] [ <?php print("<a href=\"index.php?include=mainview&page=network&action=delete&id=$tmp_request6[id]\">"); echo TXT_DELETE; echo "</a>"; ?> ]</td>
</tr>
</table>
<?php
echo "<div style=\"display:none;position:relative;margin-left: 20px;background-color:#ededed;\" id=\"ajaxcontentarea_$i\"></div>";
$line_count++;
$network_count++;
$i++;
}
}
?>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90%"><h4><img src="images/device.gif" alt="Device" align="top"> <?php echo TXT_ALL; ?> "<?php echo $location_name; ?>" <?php echo TXT_DEVICES; ?></h4></td>
<td width="10%" style="text-align:right">[ <a href="index.php?include=mainview&page=device&action=add"><?php echo TXT_ADD; ?></a> ]</td>
<tr>
</table>
<table class="sortable list" id="sortable" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td valign="top"><?php echo TXT_NAME; ?></td>
<td valign="top"><?php echo TXT_ADDRESS; ?></td>
<td valign="top"><?php echo TXT_MANUFACTURER; ?></td>
<td valign="top"><?php echo TXT_CATEGORY; ?></td>
<td valign="top"><?php echo TXT_MODEL; ?></td>
<td valign="top"><?php echo TXT_LOCATION; ?></td>
<td valign="top"><?php echo TXT_RACK; ?></td>
<td valign="top"><?php echo TXT_DESCRIPTION; ?></td>
<td class="unsortable" width="12%" valign="top"><?php echo TXT_ACTION; ?></td>
</tr>
<?php
$list1 = "list1";
$list2 = "list2";
$line_count = 0;
$device_count = 0;
$request2=mysql_query("SELECT id FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$request3=mysql_query("SELECT * FROM $name_table_device WHERE rack_id=\"$tmp_request2[id]\"") or die ("ERROR!");
while($tmp_request3=mysql_fetch_array($request3))
{
$line_color = ($line_count % 2) ? $list1 : $list2;
?>
<tr class="<?php echo "$line_color"; ?>">
<td valign="top"><?php print("<a href=\"index.php?include=mainview&page=device&action=view&id=$tmp_request3[id]\">$tmp_request3[name]</a>"); ?></td>
<td valign="top"><?php
$request4=mysql_query("SELECT id,ip FROM $name_table_ip_address WHERE id=$tmp_request3[ip_address_id]") or die ("ERROR!");
while($tmp_request4=mysql_fetch_array($request4))
{
echo "<a href=\"index.php?include=mainview&page=ip_address&action=view&id=$tmp_request4[id]\">".$tmp_request4['ip']."</a>";
}
?></td>
<td valign="top"><?php
$request5=mysql_query("SELECT id,name,manufacturer_id FROM $name_table_model WHERE id=$tmp_request3[model_id]") or die ("ERROR!");
while($tmp_request5=mysql_fetch_array($request5))
{
$request6=mysql_query("SELECT id,name FROM $name_table_manufacturer WHERE id=$tmp_request5[manufacturer_id]") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
echo "<a href=\"index.php?include=mainview&page=manufacturer&action=view&id=$tmp_request6[id]\">".$tmp_request6['name']."</a>";
}
}
?></td>
<td valign="top"><?php
$request7=mysql_query("SELECT id,name,category_id FROM $name_table_model WHERE id=$tmp_request3[model_id]") or die ("ERROR!");
while($tmp_request7=mysql_fetch_array($request7))
{
$request8=mysql_query("SELECT id,name FROM $name_table_category WHERE id=$tmp_request7[category_id]") or die ("ERROR!");
while($tmp_request8=mysql_fetch_array($request8))
{
echo "<a href=\"index.php?include=mainview&page=category&action=view&id=$tmp_request8[id]\">".$tmp_request8['name']."</a>";
}
}
?></td>
<td valign="top"><?php
$request9=mysql_query("SELECT id,name FROM $name_table_model WHERE id=$tmp_request3[model_id]") or die ("ERROR!");
while($tmp_request9=mysql_fetch_array($request9))
{
echo "<a href=\"index.php?include=mainview&page=model&action=view&id=$tmp_request9[id]\">".$tmp_request9['name']."</a>";
}
?></td>
<td valign="top"><?php
$request10=mysql_query("SELECT id,name,location_id FROM $name_table_rack WHERE id=$tmp_request3[rack_id]") or die ("ERROR!");
while($tmp_request10=mysql_fetch_array($request10))
{
$request11=mysql_query("SELECT id,name FROM $name_table_location WHERE id=$tmp_request10[location_id]") or die ("ERROR!");
while($tmp_request11=mysql_fetch_array($request11))
{
echo "<a href=\"index.php?include=mainview&page=location&action=view&id=$tmp_request11[id]\">".$tmp_request11['name']."</a>";
}
}
?></td>
<td valign="top"><?php
$request12=mysql_query("SELECT id,name FROM $name_table_rack WHERE id=$tmp_request3[rack_id]") or die ("ERROR!");
while($tmp_request12=mysql_fetch_array($request12))
{
echo "<a href=\"index.php?include=mainview&page=rack&action=view&id=$tmp_request12[id]\">".$tmp_request12['name']."</a>";
}
?></td>
<td valign="top"><?php echo $tmp_request3['description']; ?></td>
<td valign="top">[ <?php print("<a href=\"index.php?include=mainview&page=device&action=edit&id=$tmp_request3[id]\">"); echo TXT_EDIT; echo "</a>"; ?> ] [ <?php print("<a href=\"index.php?include=mainview&page=device&action=delete&id=$tmp_request3[id]\">"); echo TXT_DELETE; echo "</a>"; ?> ]</td>
</tr>
<?php
$device_count++;
}
}
?>
</table>
<table class="subtitle" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><h4><img src="images/stats.gif" alt="Stats" align="top"> <?php echo TXT_STATS; ?></h4></td>
<tr>
</table>
<table class="list" width="100%" cellspacing="2" cellpadding="3">
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/rack.gif" alt="Rack" align="top"> <b><?php echo TXT_RACK; ?> :</b>
<?php
$request=mysql_query("SELECT count(*) FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
$data = mysql_fetch_array($request);
echo "$data[0]";
?>
<?php echo TXT_RACKS; ?></td>
</tr>
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/patch_panel.gif" alt="Patch Panel" align="top"> <b><?php echo TXT_PATCH_PANEL; ?> :</b>
<?php
$count = 0;
$request=mysql_query("SELECT id FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$rack_id=$tmp_request['id'];
$request2=mysql_query("SELECT count(*) FROM $name_table_patch_panel WHERE rack_id=\"$rack_id\"") or die ("ERROR!");
$data = mysql_fetch_array($request2);
$count += $data[0];
}
echo "$count";
?>
<?php echo TXT_PATCH_PANELS; ?></td>
</tr>
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/port.gif" alt="Port" align="top"> <b><?php echo TXT_PORT; ?> :</b>
<?php
$count = 0;
$request=mysql_query("SELECT id FROM $name_table_rack WHERE location_id=\"$id\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$rack_id=$tmp_request['id'];
$request2=mysql_query("SELECT id FROM $name_table_patch_panel WHERE rack_id=\"$rack_id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$patch_panel_id=$tmp_request2['id'];
$request3=mysql_query("SELECT count(*) FROM $name_table_port WHERE patch_panel_id=\"$patch_panel_id\"") or die ("ERROR!");
$data = mysql_fetch_array($request3);
$count += $data[0];
}
}
echo "$count";
?>
<?php echo TXT_PORTS; ?></td>
</tr>
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/customer.gif" alt="Customer" align="top"> <b><?php echo TXT_CUSTOMERS; ?> :</b>
<?php echo "$customer_count";?> <?php echo TXT_CUSTOMERS; ?></td>
</tr>
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/network.gif" alt="Network" align="top"> <b><?php echo TXT_NETWORKS; ?> :</b>
<?php echo "$network_count";?> <?php echo TXT_NETWORKS; ?></td>
</tr>
<tr class="list_title">
<td width="100%" style="font-weight:normal;"><img src="images/device.gif" alt="Device" align="top"> <b><?php echo TXT_DEVICES; ?> :</b>
<?php echo "$device_count";?> <?php echo TXT_DEVICES; ?></td>
</tr>
</table>
<br><center><a href="javascript:history.go(-1);"><?php echo TXT_BACK; ?></a></center>
<?php
}
?>