10,37 → 10,33 |
$net = abs(intval($_GET["net"])); |
|
if($net==0) { |
echo "<table>\n"; |
echo "<tr>\n"; |
echo "<th>Сеть</th><th>Подсети</th><th colspan='2'>Ресурсы</th>\n"; |
echo "</tr>\n"; |
echo "<table>"; |
echo "<tr>"; |
echo "<th>Сеть</th><th>Подсети</th><th>Ресурсы</th>"; |
|
$nets =& $db->query("SELECT * FROM networks"); |
while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
|
$first = true; |
echo "<tr>"; |
echo "<td><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></td>"; |
|
echo "<td>"; |
$snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
echo $info_snets['subnet']."<br>"; |
} |
echo "</td>"; |
|
echo "<td>"; |
$res =& $db->query("SELECT * |
FROM res_net_stat |
JOIN resources ON resources.id = res_net_stat.resource_id |
WHERE res_net_stat.network_id=".$info_nets['id']); |
while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
echo "<tr>\n"; |
|
if ($first) { |
echo " <td rowspan='".$res->numRows()."'><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></td>\n"; |
echo " <td rowspan='".$res->numRows()."'>"; |
$snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
if ($snets->numRows()==0) echo "Нет данных."; |
while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
echo $info_snets['subnet']."<br>"; |
} |
echo " </td>\n"; |
$first = false; |
echo "<img src='".$info_res['picture']."' alt='logo'><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a><br>"; |
} |
|
echo " <td><img src='".$info_res['picture']."' alt='logo'></td>\n<td><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a></td>\n"; |
echo "</tr>\n"; |
} |
echo "</td>"; |
echo "</tr>"; |
} |
echo "</table>"; |
} |