Secu²

import tkinter as tk
from tkinter import messagebox
import sqlite3

# --- Connexion  la base de donnes ---
def get_db_connection():
    return sqlite3.connect("badges.db")

# --- Application principale ---
class App(tk.Tk):
    def __init__(self):
        super().__init__()
        self.title("Gestion des Badges")
        self.geometry("400x300")
        self.frames = {}

        for F in (HomePage, AddBadgePage, LinkUserPage, DeleteUserPage):
            frame = F(self, self)
            self.frames[F] = frame
            frame.place(relwidth=1, relheight=1)

        self.show_frame(HomePage)

    def show_frame(self, frame_class):
        frame = self.frames[frame_class]
        frame.tkraise()

# --- Page d'accueil ---
class HomePage(tk.Frame):
    def __init__(self, parent, controller):
        super().__init__(parent)
        tk.Label(self, text="Page d'accueil", font=("Arial", 16)).pack(pady=20)

        tk.Button(self, text="Ajouter un badge", command=lambda: controller.show_frame(AddBadgePage)).pack(pady=5)
        tk.Button(self, text="Lier utilisateur  un badge", command=lambda: controller.show_frame(LinkUserPage)).pack(pady=5)
        tk.Button(self, text="Supprimer un utilisateur", command=lambda: controller.show_frame(DeleteUserPage)).pack(pady=5)

# --- Page : Ajouter un badge ---
class AddBadgePage(tk.Frame):
    def __init__(self, parent, controller):
        super().__init__(parent)
        tk.Label(self, text="Ajouter un Badge", font=("Arial", 14)).pack(pady=10)

        tk.Label(self, text="Badge ID:").pack()
        self.badge_id_entry = tk.Entry(self)
        self.badge_id_entry.pack()

        tk.Label(self, text="Droit (1/0):").pack()
        self.droit_entry = tk.Entry(self)
        self.droit_entry.pack()

        tk.Button(self, text="Ajouter", command=self.ajouter_badge).pack(pady=10)
        tk.Button(self, text="Retour", command=lambda: controller.show_frame(HomePage)).pack()

    def ajouter_badge(self):
        badge_id = self.badge_id_entry.get()
        droit = self.droit_entry.get()

        if not badge_id or not droit:
            messagebox.showerror("Erreur", "Tous les champs doivent tre remplis.")
            return

        conn = get_db_connection()
        cursor = conn.cursor()

        cursor.execute('SELECT * FROM badges WHERE badge_id = ?', (badge_id,))
        if cursor.fetchone():
            messagebox.showerror("Erreur", "Le badge existe dj.")
        else:
            cursor.execute('INSERT INTO badges (badge_id, droit, nom) VALUES (?, ?, ?)', (badge_id, droit, None))
            conn.commit()
            messagebox.showinfo("Succs", "Badge ajout.")
        conn.close()

# --- Page : Lier utilisateur  badge ---
class LinkUserPage(tk.Frame):
    def __init__(self, parent, controller):
        super().__init__(parent)
        tk.Label(self, text="Lier un utilisateur  un badge", font=("Arial", 14)).pack(pady=10)

        tk.Label(self, text="Nom d'utilisateur:").pack()
        self.username_entry = tk.Entry(self)
        self.username_entry.pack()

        tk.Label(self, text="Badge ID:").pack()
        self.badge_id_entry = tk.Entry(self)
        self.badge_id_entry.pack()

        tk.Label(self, text="Admin (1/0):").pack()
        self.is_admin_entry = tk.Entry(self)
        self.is_admin_entry.pack()

        tk.Button(self, text="Lier", command=self.lier_utilisateur).pack(pady=10)
        tk.Button(self, text="Retour", command=lambda: controller.show_frame(HomePage)).pack()

    def lier_utilisateur(self):
        username = self.username_entry.get()
        badge_id = self.badge_id_entry.get()
        is_admin = self.is_admin_entry.get()

        if not username or not badge_id or not is_admin:
            messagebox.showerror("Erreur", "Tous les champs doivent tre remplis.")
            return

        conn = get_db_connection()
        cursor = conn.cursor()

        cursor.execute('SELECT * FROM badges WHERE badge_id = ?', (badge_id,))
        badge = cursor.fetchone()

        if not badge:
            messagebox.showerror("Erreur", "Le badge n'existe pas.")
            conn.close()
            return

        cursor.execute('SELECT * FROM users WHERE username = ?', (username,))
        user = cursor.fetchone()

        if not user:
            cursor.execute('INSERT INTO users (username, badge_id, is_admin) VALUES (?, ?, ?)', (username, badge_id, is_admin))
        else:
            cursor.execute('UPDATE users SET badge_id = ?, is_admin = ? WHERE username = ?', (badge_id, is_admin, username))

        cursor.execute('UPDATE badges SET nom = ? WHERE badge_id = ?', (username, badge_id))

        conn.commit()
        conn.close()
        messagebox.showinfo("Succs", f"Utilisateur '{username}' li au badge {badge_id}.")

# --- Page : Supprimer un utilisateur ---
class DeleteUserPage(tk.Frame):
    def __init__(self, parent, controller):
        super().__init__(parent)
        tk.Label(self, text="Supprimer un Utilisateur", font=("Arial", 14)).pack(pady=10)

        tk.Label(self, text="Nom d'utilisateur:").pack()
        self.username_entry = tk.Entry(self)
        self.username_entry.pack()

        tk.Button(self, text="Supprimer", command=self.supprimer_utilisateur).pack(pady=10)
        tk.Button(self, text="Retour", command=lambda: controller.show_frame(HomePage)).pack()

    def supprimer_utilisateur(self):
        username = self.username_entry.get()

        if not username:
            messagebox.showerror("Erreur", "Nom d'utilisateur requis.")
            return

        conn = get_db_connection()
        cursor = conn.cursor()

        cursor.execute('SELECT badge_id FROM users WHERE username = ?', (username,))
        result = cursor.fetchone()

        if not result:
            messagebox.showerror("Erreur", "Utilisateur non trouv.")
            conn.close()
            return

        badge_id = result[0]

        cursor.execute('DELETE FROM users WHERE username = ?', (username,))
        cursor.execute('DELETE FROM badges WHERE badge_id = ?', (badge_id,))
        conn.commit()
        conn.close()
        messagebox.showinfo("Succs", f"Utilisateur '{username}' et son badge ont t supprims.")

# --- Dmarrage ---
if __name__ == "__main__":
    # Assure-toi que la base a bien les bonnes tables ( adapter si dj cre)
    conn = get_db_connection()
    c = conn.cursor()
    c.execute('''
        CREATE TABLE IF NOT EXISTS users (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            username TEXT UNIQUE,
            badge_id TEXT,
            is_admin INTEGER
        )
    ''')
    c.execute('''
        CREATE TABLE IF NOT EXISTS badges (
            badge_id TEXT PRIMARY KEY,
            droit INTEGER,
            nom TEXT
        )
    ''')
    conn.commit()
    conn.close()

    app = App()
    app.mainloop()

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <title>Page d'authentification</title>
    <style>
        body { font-family: Arial, sans-serif; margin: 40px; }
        table { border-collapse: collapse; width: 80%; }
        th, td { padding: 10px; text-align: center; border: 1px solid #ddd; }
        th { background-color: #f2f2f2; }
    </style>
</head>
<body>
    <h2>Bienvenue sur le site</h2>
    <p><a href="{{ url_for('login') }}">Se connecter</a></p>
    <p><a href="{{ url_for('signup') }}">Crer un compte</a></p>
</body>
</html>

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <title>Connexion</title>
    <style>
        body { font-family: Arial, sans-serif; margin: 40px; }
        table { border-collapse: collapse; width: 80%; }
        th, td { padding: 10px; text-align: center; border: 1px solid #ddd; }
        th { background-color: #f2f2f2; }
    </style>
</head>
<body>
    <h2>Connexion</h2>
    <form method="POST">
        <label>Nom d'utilisateur: <input type="text" name="username"></label><br>
        <label>Mot de passe: <input type="password" name="password"></label><br>
        <button type="submit">Se connecter</button>
    </form>
    {% if error %}<p style="color:red;">{{ error }}</p>{% endif %}
</body>
</html>

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <title>Crer un Compte</title>
    <style>
        body { font-family: Arial, sans-serif; margin: 40px; }
        table { border-collapse: collapse; width: 80%; }
        th, td { padding: 10px; text-align: center; border: 1px solid #ddd; }
        th { background-color: #f2f2f2; }
    </style>
</head>
<body>
    <h2>Crer un compte</h2>
    <form method="POST">
        <label>Nom d'utilisateur: <input type="text" name="username" required></label><br>
        <label>Mot de passe: <input type="password" name="password" required></label><br>
        <label>Confirmer le mot de passe: <input type="password" name="confirm_password" required></label><br>
        <button type="submit">Crer un compte</button>
    </form>
    {% if error %}<p style="color:red;">{{ error }}</p>{% endif %}
</body>
</html>

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Tableau de Bord</title>
    <style>
        body { font-family: Arial, sans-serif; margin: 40px; }
        table { border-collapse: collapse; width: 80%; }
        th, td { padding: 10px; text-align: center; border: 1px solid #ddd; }
        th { background-color: #f2f2f2; }
    </style>
    <script type="text/javascript">
        // Rafrachir la page toutes les 30 secondes
        setTimeout(function(){
            location.reload();
        }, 10000);  // 10 secondes
    </script>
</head>
<body>
    <h1>Tableau de Bord</h1>
    <p>Bienvenue, {{ user['username'] }} !</p>
    <p>Voici les informations de votre badge :</p>
    
    <ul>
        <li>Nom : {{ badge['nom'] }}</li>
        <li>ID Badge : {{ badge['badge_id'] }}</li>
        <li>Droit : {{ badge['droit'] }}</li>
        <li>Code : {{ badge['code'] }}</li>
        <li>Timestamp : {{ badge['timestamp'] }}</li>
    </ul>
</body>
</html>

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Badges</title>
    <style>
        body { font-family: Arial, sans-serif; margin: 40px; }
        table { border-collapse: collapse; width: 80%; }
        th, td { padding: 10px; text-align: center; border: 1px solid #ddd; }
        th { background-color: #f2f2f2; }
    </style>
</head>
<body>
    <h1>Badges et Codes</h1>
    <table>
        <thead>
            <tr>
                <th>ID Badge</th>
                <th>Nom</th>
                <th>Droit</th>
                <th>Code gnr</th>
                <th>Dernire gnration</th>
            </tr>
        </thead>
        <tbody id="badge-table-body">
        </tbody>
    </table>

    <script>
        async function loadBadges() {
            try {
                const res = await fetch("/badges-json");
                const badges = await res.json();

                const tbody = document.getElementById("badge-table-body");
                tbody.innerHTML = "";

                badges.forEach(badge => {
                    const row = document.createElement("tr");

                    row.innerHTML = `
                        <td>${badge.badge_id}</td>
                        <td>${badge.nom || '-'}</td>
                        <td>${badge.droit ? 'Oui' : 'Non'}</td>
                        <td>${badge.code || 'Aucun code gnr'}</td>
                        <td>${badge.timestamp || 'Jamais'}</td>
                    `;
                    tbody.appendChild(row);
                });
            } catch (error) {
                console.error("Erreur lors du chargement des badges :", error);
            }
        }

        loadBadges(); // Initial
        setInterval(loadBadges, 5000); // Rafrachit toutes les 5 secondes
    </script>
</body>
</html>