Редакция 33 | Редакция 35 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 33 | Редакция 34 | ||
---|---|---|---|
Строка 8... | Строка 8... | ||
8 | <?php
|
8 | <?php
|
9 | 9 | ||
10 | $net = abs(intval($_GET["net"])); |
10 | $net = abs(intval($_GET["net"])); |
11 | 11 | ||
12 | if($net==0) { |
12 | if($net==0) { |
13 | echo "<table>"; |
13 | echo "<table>\n"; |
14 | echo "<tr>"; |
14 | echo "<tr>\n"; |
15 | echo "<th>Сеть</th><th>Подсети</th><th>Ресурсы</th>"; |
15 | echo "<th>Сеть</th><th>Подсети</th><th colspan='2'>Ресурсы</th>\n"; |
- | 16 | echo "</tr>\n"; |
|
16 | 17 | ||
17 | $nets =& $db->query("SELECT * FROM networks"); |
18 | $nets =& $db->query("SELECT * FROM networks"); |
18 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
19 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
19 | 20 | ||
20 | echo "<tr>"; |
21 | $first = true; |
21 | echo "<td><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></td>"; |
- | |
22 | - | ||
23 | echo "<td>"; |
- | |
24 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
- | |
25 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
- | |
26 | echo $info_snets['subnet']."<br>"; |
- | |
27 | }
|
- | |
28 | echo "</td>"; |
- | |
29 | - | ||
30 | echo "<td>"; |
- | |
31 | $res =& $db->query("SELECT * |
22 | $res =& $db->query("SELECT * |
32 | FROM res_net_stat
|
23 | FROM res_net_stat
|
33 | JOIN resources ON resources.id = res_net_stat.resource_id
|
24 | JOIN resources ON resources.id = res_net_stat.resource_id
|
34 | WHERE res_net_stat.network_id=".$info_nets['id']); |
25 | WHERE res_net_stat.network_id=".$info_nets['id']); |
35 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
26 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
- | 27 | echo "<tr>\n"; |
|
- | 28 | ||
- | 29 | if ($first) { |
|
- | 30 | echo " <td rowspan='".$res->numRows()."'><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></td>\n"; |
|
- | 31 | echo " <td rowspan='".$res->numRows()."'>"; |
|
- | 32 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
|
- | 33 | if ($snets->numRows()==0) echo "Нет данных."; |
|
- | 34 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
|
- | 35 | echo $info_snets['subnet']."<br>"; |
|
- | 36 | }
|
|
- | 37 | echo " </td>\n"; |
|
- | 38 | $first = false; |
|
- | 39 | }
|
|
- | 40 | ||
36 | echo "<img src='".$info_res['picture']."' alt='logo'><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a><br>"; |
41 | 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"; |
- | 42 | echo "</tr>\n"; |
|
37 | }
|
43 | }
|
38 | echo "</td>"; |
- | |
39 | echo "</tr>"; |
- | |
40 | }
|
44 | }
|
41 | echo "</table>"; |
45 | echo "</table>"; |
42 | }
|
46 | }
|
43 | else { |
47 | else { |
44 | $nets =& $db->query("SELECT * FROM networks WHERE id=".$net); |
48 | $nets =& $db->query("SELECT * FROM networks WHERE id=".$net); |