ajout filtrage AJAX

3 files changed, 61 insertions, 0 deletions

diff --git a/www/html/affiche-tab.py b/www/html/affiche-tab.py
new file mode 100644
index 0000000..2f5a516
--- /dev/null
+++ b/www/html/affiche-tab.py
@@ -0,0 +1,39 @@
+#!/usr/bin/python3
+# -*- coding: utf-8 -*-
+
+import mod_python                     
+from fonctions import baseHTML, connexionBD, lien
+
+def index(req):
+    req.content_type="text/html"
+    content=str()
+
+    condition=req.form["condition"]
+    
+    conn=connexionBD()
+    cur=conn.cursor()
+    sql="select * from paquet where {}".format(condition)
+    cur.execute(sql)
+    conn.commit()
+    data=cur.fetchall()
+    conn.close()
+
+    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>""")
+
+    req.write("""
+<center><table>
+<tr><th>Heure</th><th>Protocole</th><th>IP Source</th><th>IP Destination</th><th>Port Source</th><th>Port Destination</th></tr>
+"""
++ content + 
+"""
+</table></center>
+"""))
+
diff --git a/www/html/filtre.js b/www/html/filtre.js
new file mode 100644
index 0000000..b523360
--- /dev/null
+++ b/www/html/filtre.js
@@ -0,0 +1,17 @@
+function cherche(){
+	
+	var condition = document.getElementById("condition");
+	var url = "affiche-tab.py?condition=" + condition.value;
+	
+	var req = new XMLHttpRequest();
+	req.open("GET", url, true);
+	
+	req.onreadystatechange = function(){
+		if(req.readyState == 4 && req.status == 200) {
+			var tab=document.getElementById("tab");
+			tab.innerHTML = req.responseText;
+		}
+	}
+	
+	req.send();
+}
diff --git a/www/html/index.py b/www/html/index.py
index f670a37..7e45dca 100755
--- a/www/html/index.py
+++ b/www/html/index.py
@@ -32,10 +32,15 @@ def index(req):
 #write the html page
     req.write(baseHTML("ATS-Project","""
 <center><h1>ATS-Project</h1></center>
+<b>Filtrage</b>
+<input type="text" id="condition" onkeyup="cherche()">
+<div id="tab">
 <center><table>
 <tr><th>Heure</th><th>Protocole</th><th>IP Source</th><th>IP Destination</th><th>Port Source</th><th>Port Destination</th></tr>
 """
 + content + 
 """
 </table></center>
+</div>
+<script src="filtre.js"></script>
 """))