aboutsummaryrefslogtreecommitdiff
path: root/www/html
diff options
context:
space:
mode:
Diffstat (limited to 'www/html')
-rwxr-xr-xwww/html/bilan.py (renamed from www/html/analyse.py)36
-rwxr-xr-xwww/html/fonctions.py2
-rwxr-xr-xwww/html/index.py20
-rwxr-xr-xwww/html/style.css16
4 files changed, 56 insertions, 18 deletions
diff --git a/www/html/analyse.py b/www/html/bilan.py
index c6a6c87..376f0c6 100755
--- a/www/html/analyse.py
+++ b/www/html/bilan.py
@@ -11,41 +11,63 @@ def index(req):
#sql part
conn=connexionBD()
cur=conn.cursor()
-
+###
cur.execute("SELECT COUNT(*) FROM paquet")
conn.commit()
total=str(cur.fetchone()[0])
-
+#
cur.execute("SELECT COUNT(DISTINCT ip_source) FROM paquet")
conn.commit()
total_ip_src=str(cur.fetchone()[0])
-
+#
cur.execute("SELECT COUNT(DISTINCT ip_destination) FROM paquet")
conn.commit()
total_ip_dst=str(cur.fetchone()[0])
-
+#
cur.execute("SELECT COUNT(DISTINCT port_source) FROM paquet")
conn.commit()
total_port_src=str(cur.fetchone()[0])
-
+#
cur.execute("SELECT COUNT(DISTINCT port_destination) FROM paquet")
conn.commit()
total_port_dst=str(cur.fetchone()[0])
-
+#
+ cur.execute("SELECT COUNT(*) FROM paquet WHERE (heure>=( SELECT LOCALTIME - interval '1 hour' ) AND heure<= (SELECT LOCALTIME));")
+ conn.commit()
+ total_uneheure=str(cur.fetchone()[0])
+#
+ cur.execute("SELECT ip_destination, COUNT(ip_destination) FROM paquet GROUP BY ip_destination")
+ conn.commit()
+ each_ip_dest=cur.fetchall()
+###
conn.close()
#sql part
+#loop
+ for i in each_ip_dest :
+ content+=("""<tr>
+<td>""" + str(i[0]) + """</td>
+<td>""" + str(i[1]) + """</td>
+ </tr>""")
+#loop
+
#write the html page
req.write(baseHTML("ATS-Project","""
-<h1>Analyse</h1>
+<h1>Bilan</h1>
<ul>
<li>Nombre total de paquets : <b>"""+total+"""</b></li>
+<li>Nombre total de paquets depuis 1h : <b>"""+total_uneheure+"""</b></li>
<li>Nombre total d'adresses IP source differentes : <b>"""+total_ip_src+"""</b></li>
<li>Nombre total d'adresses IP destination differentes : <b>"""+total_ip_dst+"""</b></li>
<li>Nombre total de ports source differents : <b>"""+total_port_src+"""</b></li>
<li>Nombre total de ports destination differents : <b>"""+total_port_dst+"""</b></li>
</ul>
+<br/>
+<table>
+<tr><th>IP destination</th><th>Recurrence</th></tr>
+"""+str(content)+"""
+</table>
<canvas id="protocole" width="20vh" height="40vw"></canvas>
<script src="/Chart.js"></script>
<script src="/pie.js"></script>
diff --git a/www/html/fonctions.py b/www/html/fonctions.py
index c9c3df2..8fce43b 100755
--- a/www/html/fonctions.py
+++ b/www/html/fonctions.py
@@ -15,7 +15,7 @@ def baseHTML(title,body):
<a href="/">Index</a>
<a href="/filtrage.py">Filtrage</a>
<a href="/syntaxe.py">Syntaxe</a>
- <a href="/analyse.py">Analyse</a>
+ <a href="/bilan.py">Bilan</a>
</nav>
"""+ body +"""</body>
</html>
diff --git a/www/html/index.py b/www/html/index.py
index 7f419b0..446a90e 100755
--- a/www/html/index.py
+++ b/www/html/index.py
@@ -29,23 +29,23 @@ def index(req):
#takes every lines from the select
for i in data :
- content+=("""<tr>""" +
-"""<td>""" + str(i[1]) + """</td>""" +
-"""<td>""" + str(i[2]) + """</td>""" +
-"""<td>""" + str(i[3]) + """</td>""" +
-"""<td>""" + lien('destination.py?ip=' + str(i[4]), str(i[4])) + """</td>""" +
-"""<td>""" + str(i[5]) + """</td>""" +
-"""<td>""" + str(i[6]) + """</td>""" +
-"""</tr>""")
+ content+=("""<tr>
+<td>""" + str(i[1]) + """</td>
+<td>""" + str(i[2]) + """</td>
+<td>""" + str(i[3]) + """</td>
+<td>""" + lien('destination.py?ip=' + str(i[4]), str(i[4])) + """</td>
+<td>""" + str(i[5]) + """</td>
+<td>""" + str(i[6]) + """</td>
+ </tr>""")
#write the html page
req.write(baseHTML("ATS-Project","""
<h1>ATS-Project</h1>
<div id="tip" style="display:block;">
-Pour voir le nombre de paquets en destination d'une adresse IP, cliquez sur cette dernière dans le tableau.<div id="ok" onclick="toggle_div(this,'tip');"><b>OK</b></div></div>
+Pour voir le nombre de paquets en destination d'une adresse IP, cliquez sur cette dernière dans le tableau <button id="ok" onclick="toggle_div(this,'tip');">OK</button></div>
<p>Nombre total de paquets : <b>"""+ count +"""</b></p>
<em>Pour afficher toute la table, cliquez</em>
-<button onclick="affiche_tas()">ICI</button><br/>
+<button id="afficheTas" onclick="affiche_tas()">ICI</button><br/>
<div id="tab">
<table class="data_tab">
<tr><th>Heure</th><th>Protocole</th><th>IP Source</th><th>IP Destination</th><th>Port Source</th><th>Port Destination</th></tr>
diff --git a/www/html/style.css b/www/html/style.css
index c08fa96..abecc86 100755
--- a/www/html/style.css
+++ b/www/html/style.css
@@ -51,3 +51,19 @@ em{
li{
color:#FFFFFF;
}
+
+
+#afficheTas{
+ background-color: #262626;
+ border: solid thin #FF00FF;
+ color: #FF00FF;
+ cursor: pointer;
+}
+
+
+#ok{
+ background-color: #262626;
+ border: solid #6666FF;
+ color: #D42471;
+ cursor: pointer;
+}