PonControl/olt_list.php at master · v222008/PonControl · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<font size=5>
Список OLT
</font>
<br/>
<br/>
<font size=4>
<?php
include 'vars.php';
$extra = 'index.php';


$conn = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
mysql_query("SET NAMES utf8");


$sql = "create database if not exists $mysql_db  default charset utf8";

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}


mysql_select_db($mysql_db);


$sql = "CREATE TABLE IF NOT EXISTS olts (   `ip` INT UNSIGNED UNIQUE,   `place` varchar(256) DEFAULT NULL,   `ro` varchar(64) DEFAULT NULL,  `rw` varchar(64) DEFAULT NULL, `last_act` varchar(64) DEFAULT NULL, `lat` varchar(16) DEFAULT NULL, `lon` varchar(16) DEFAULT NULL, `olt_comments` varchar(256) DEFAULT NULL, `numsfp` varchar(16) DEFAULT NULL, `sfp1` varchar(256) DEFAULT NULL, `sfp2` varchar(256) DEFAULT NULL, `sfp3` varchar(256) DEFAULT NULL, `sfp4` varchar(256) DEFAULT NULL, `sfp5` varchar(256) DEFAULT NULL, `sfp6` varchar(256) DEFAULT NULL, `sfp7` varchar(256) DEFAULT NULL, `sfp8` varchar(256) DEFAULT NULL, `sfp9` varchar(256) DEFAULT NULL, `sfp10` varchar(256) DEFAULT NULL, `sfp11` varchar(256) DEFAULT NULL, `sfp12` varchar(256) DEFAULT NULL, `sfp13` varchar(256) DEFAULT NULL, `sfp14` varchar(256) DEFAULT NULL, `sfp15` varchar(256) DEFAULT NULL, `sfp16` varchar(256) DEFAULT NULL)";

$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}


$sql = "select * from olts order by ip";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}
$number = mysql_num_rows($retval);
?>
<div align="center">
<table>


<?php
if ($number == 0) {
echo "<a href=\"?page=addolt\">Чтобы начать работу ДОБАВЬТЕ OLT</a>";
} else {
$count = 0;
  while ($row=mysql_fetch_array($retval)) {


$count = $count + 1;
$ip_sql = $row['ip'];
$ip = long2ip($ip_sql);
$place = $row['place'];
$numsfp = $row['numsfp'];
$last_act = $row['last_act'];
$ro = $row['ro'];
$olt = str_replace (".", "_", $ip);
include 'ping.php';
if ($ping == 0) {
$color = "red";
$cell_color = "#FF0000";
}
else {
$color = "normal";
$cell_color = "#00FF00";
}
echo "<tr class=\"container\" onclick=\"document.location = '?page=olt&olt=$ip';\">";
echo "<td style=\"width: 8px; padding: 0px; background: $cell_color;\"></td>";
echo "<td style=\"text-align:center; padding: 5px;\" >$count</td><td><a href=\"?page=olt&olt=$olt\">".$ip."</a></td>";
echo "<td style=\"font-size: 18px; padding-left: 30px; min-width: 400px;\"><ul id=\"nav\"><li>";
echo "<a href=\"index.php?page=olt&olt=$ip\">";
echo $place;
echo "</a>";

echo "<ul>";
echo "<span style=\"font-size: 11px;\">";
$count_sfp = 1;
while ($count_sfp <= $numsfp) {
echo "<li><a href=\"index.php?page=olt&olt=$ip&sfp=$count_sfp\">SFP $count_sfp</a></li>";
$count_sfp = $count_sfp + 1;
}


echo "</span>";
echo "</ul>";

echo "</li></ul>";
echo "</td>";

echo "<td>".$last_act."</td></tr>";


}


mysql_close($conn);
}
?>
</table>
</font>
</div>
<font size=3>
<div align=right>
<br/>
<a href="index.php?page=addolt">Добавить новый OLT</a>
<br/>
<a href="index.php?page=ping_all">Опросить все OLT и ONU</a>
</div>
</font>