Файловый менеджер

Файловый менеджер - Редактировать - /home/gqdcvggs/go.imators.com/gov.tar

Назад
index.php��0000664��00000157723�15114743404�0006410 0��ustar�00��<?php session_start(); require_once '../db.php'; $user_selected = false; $user_data = null; $identite = null; $compte = null; $casier = []; if(isset($_GET['user_id'])) { $user_id = $_GET['user_id']; $user_selected = true; // Récupération des données utilisateur $sql = "SELECT * FROM users WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user_data = $result->fetch_assoc(); // Récupération des données d'identité $sql = "SELECT * FROM identites WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $identite = $result->fetch_assoc(); // Récupération des données bancaires $sql = "SELECT * FROM comptes_bancaires WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $compte = $result->fetch_assoc(); // Récupération du casier judiciaire $sql = "SELECT * FROM casier_judiciaire WHERE user_id = ? ORDER BY date DESC"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); while($row = $result->fetch_assoc()) { $casier[] = $row; } } // Traitement des actions if(isset($_POST['action'])) { $action = $_POST['action']; $target_user_id = isset($_POST['user_id']) ? $_POST['user_id'] : null; switch($action) { case 'envoyer_message': $sujet = $_POST['sujet']; $contenu = $_POST['contenu']; $type = $_POST['type']; $montant = ($type == 'facture') ? $_POST['montant'] : null; $sql = "INSERT INTO courriers (destinataire_id, expediteur, sujet, contenu, type, montant) VALUES (?, 'Gouvernement de Peerkinton', ?, ?, ?, ?)"; $stmt = $conn->prepare($sql); $stmt->bind_param("isssd", $target_user_id, $sujet, $contenu, $type, $montant); if($stmt->execute()) { $message = "Message envoyé avec succès."; $message_type = "success"; } else { $message = "Erreur lors de l'envoi du message."; $message_type = "error"; } break; case 'modifier_notoriete': $nouvelle_notoriete = $_POST['nouvelle_notoriete']; $raison = $_POST['raison']; $sql = "UPDATE identites SET notoriete = ? WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("ii", $nouvelle_notoriete, $target_user_id); if($stmt->execute()) { // Journaliser la modification $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'modification_notoriete', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "Modification de la notoriété à {$nouvelle_notoriete}. Raison: {$raison}"; $stmt->bind_param("iis", $admin_id, $target_user_id, $details); $stmt->execute(); $message = "Notoriété modifiée avec succès."; $message_type = "success"; } else { $message = "Erreur lors de la modification de la notoriété."; $message_type = "error"; } break; case 'ajouter_infraction': $type = $_POST['type_infraction']; $description = $_POST['description_infraction']; $sanction = $_POST['sanction_infraction']; $date = $_POST['date_infraction']; $sql = "INSERT INTO casier_judiciaire (user_id, type, description, sanction, date) VALUES (?, ?, ?, ?, ?)"; $stmt = $conn->prepare($sql); $stmt->bind_param("issss", $target_user_id, $type, $description, $sanction, $date); if($stmt->execute()) { // Journaliser l'action $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'ajout_infraction', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "Ajout d'une infraction de type {$type}. Sanction: {$sanction}"; $stmt->bind_param("iis", $admin_id, $target_user_id, $details); $stmt->execute(); $message = "Infraction ajoutée au casier judiciaire."; $message_type = "success"; } else { $message = "Erreur lors de l'ajout de l'infraction."; $message_type = "error"; } break; case 'modification_solde': $montant = $_POST['montant_modification']; $raison = $_POST['raison_modification']; $operation = $_POST['operation_solde']; if($operation == 'ajouter') { $sql = "UPDATE comptes_bancaires SET solde = solde + ? WHERE user_id = ?"; } else { $sql = "UPDATE comptes_bancaires SET solde = solde - ? WHERE user_id = ?"; } $stmt = $conn->prepare($sql); $stmt->bind_param("di", $montant, $target_user_id); if($stmt->execute()) { // Journaliser l'action $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'modification_solde', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "{$operation} {$montant}€. Raison: {$raison}"; $stmt->bind_param("iis", $admin_id, $target_user_id, $details); $stmt->execute(); $message = "Solde modifié avec succès."; $message_type = "success"; } else { $message = "Erreur lors de la modification du solde."; $message_type = "error"; } break; case 'modifier_identite': $nom = $_POST['nom']; $prenom = $_POST['prenom']; $date_naissance = $_POST['date_naissance']; $lieu_naissance = $_POST['lieu_naissance']; $nationalite = $_POST['nationalite']; $sexe = $_POST['sexe']; $adresse = $_POST['adresse']; $telephone = $_POST['telephone']; $profession = $_POST['profession']; $sql = "UPDATE identites SET nom = ?, prenom = ?, date_naissance = ?, lieu_naissance = ?, nationalite = ?, sexe = ?, adresse = ?, telephone = ?, profession = ? WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("ssssssssi", $nom, $prenom, $date_naissance, $lieu_naissance, $nationalite, $sexe, $adresse, $telephone, $profession, $target_user_id); if($stmt->execute()) { // Journaliser l'action $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'modification_identite', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "Modification des informations d'identité"; $stmt->bind_param("iis", $admin_id, $target_user_id, $details); $stmt->execute(); $message = "Identité modifiée avec succès."; $message_type = "success"; } else { $message = "Erreur lors de la modification de l'identité."; $message_type = "error"; } break; case 'bloquer_compte': $raison = $_POST['raison_blocage']; $duree = $_POST['duree_blocage']; // en jours $sql = "UPDATE users SET bloque = 1, raison_blocage = ?, date_fin_blocage = DATE_ADD(NOW(), INTERVAL ? DAY) WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("sii", $raison, $duree, $target_user_id); if($stmt->execute()) { // Journaliser l'action $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'blocage_compte', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "Blocage du compte pour {$duree} jours. Raison: {$raison}"; $stmt->bind_param("iis", $admin_id, $target_user_id, $details); $stmt->execute(); $message = "Compte bloqué avec succès."; $message_type = "success"; } else { $message = "Erreur lors du blocage du compte."; $message_type = "error"; } break; } // Redirection pour éviter la resoumission du formulaire header("Location: gouvernement.php?user_id=" . $target_user_id . "&message=" . urlencode($message) . "&message_type=" . $message_type); exit(); } // Récupération de tous les utilisateurs pour la sélection $sql = "SELECT u.id, u.email, i.nom, i.prenom FROM users u LEFT JOIN identites i ON u.id = i.user_id ORDER BY i.nom, i.prenom"; $stmt = $conn->prepare($sql); $stmt->execute(); $result = $stmt->get_result(); $tous_utilisateurs = []; while($row = $result->fetch_assoc()) { $tous_utilisateurs[] = $row; } ?> <!DOCTYPE html> <html lang="fr"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Administration Gouvernementale - Peerkinton</title> <script src="https://cdn.tailwindcss.com"></script> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600&display=swap" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css" rel="stylesheet"> <style> body { font-family: 'Poppins', sans-serif; } .tab-content { display: none; } .tab-content.active { display: block; } </style> <script> tailwind.config = { theme: { extend: { fontFamily: { 'sans': ['Poppins', 'sans-serif'], }, colors: { 'gov': { 50: '#f0f9ff', 100: '#e0f2fe', 500: '#0369a1', 600: '#0284c7', 700: '#0369a1', 800: '#075985', 900: '#0c4a6e', } } } } } </script> </head> <body class="bg-gray-50 text-gray-900"> <div class="min-h-screen flex flex-col"> <!-- En-tête --> <header class="bg-gov-800 text-white shadow"> <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-4"> <div class="flex justify-between items-center"> <div class="flex items-center"> <i class="fas fa-landmark text-2xl mr-3"></i> <h1 class="text-xl font-semibold">Gouvernement de Peerkinton</h1> </div> <div> <a href="logout.php" class="text-white hover:text-gray-200"> <i class="fas fa-sign-out-alt mr-1"></i> Déconnexion </a> </div> </div> </div> </header> <!-- Contenu principal --> <main class="flex-grow py-6"> <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8"> <?php if(isset($_GET['message'])): ?> <div class="mb-6 px-4 py-3 rounded <?php echo $_GET['message_type'] == 'success' ? 'bg-green-50 text-green-800' : 'bg-red-50 text-red-800'; ?>"> <?php echo $_GET['message']; ?> </div> <?php endif; ?> <!-- Sélection d'un citoyen --> <div class="bg-white shadow overflow-hidden sm:rounded-lg mb-6"> <div class="px-4 py-5 sm:px-6"> <h2 class="text-lg font-medium text-gray-900">Sélection d'un citoyen</h2> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Sélectionnez un citoyen pour effectuer des actions administratives. Chaque action est enregistré dans nos journaux d'observation a des fins de garentir la sécurité de nos systèmes envers vos actions. </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="GET" class="flex items-center space-x-4"> <div class="flex-grow"> <select name="user_id" id="user_id" class="block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <option value="">Sélectionnez un citoyen</option> <?php foreach($tous_utilisateurs as $u): ?> <option value="<?php echo $u['id']; ?>" <?php echo (isset($_GET['user_id']) && $_GET['user_id'] == $u['id']) ? 'selected' : ''; ?>> <?php echo $u['nom'] ? $u['nom'] . ' ' . $u['prenom'] . ' (' . $u['email'] . ')' : $u['email']; ?> </option> <?php endforeach; ?> </select> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> <i class="fas fa-search mr-2"></i> Sélectionner </button> </div> </form> </div> </div> <?php if($user_selected && $user_data): ?> <!-- Informations du citoyen --> <div class="bg-white shadow overflow-hidden sm:rounded-lg mb-6"> <div class="px-4 py-5 sm:px-6 flex justify-between items-center"> <div> <h2 class="text-lg font-medium text-gray-900"> <?php echo $identite ? $identite['nom'] . ' ' . $identite['prenom'] : $user_data['email']; ?> </h2> <p class="mt-1 max-w-2xl text-sm text-gray-500"> ID: <?php echo $user_data['id']; ?> • <?php echo $identite ? 'Carte d\'identité: ' . $identite['id_carte'] : 'Pas de carte d\'identité'; ?> </p> </div> <?php if($identite): ?> <div class="text-right"> <span class="px-3 py-1 text-sm font-medium rounded-full <?php if($identite['notoriete'] >= 80) echo 'bg-green-100 text-green-800'; elseif($identite['notoriete'] >= 60) echo 'bg-blue-100 text-blue-800'; elseif($identite['notoriete'] >= 40) echo 'bg-yellow-100 text-yellow-800'; elseif($identite['notoriete'] >= 20) echo 'bg-orange-100 text-orange-800'; else echo 'bg-red-100 text-red-800'; ?>"> Notoriété: <?php echo $identite['notoriete']; ?>/100 </span> </div> <?php endif; ?> </div> </div> <!-- Onglets --> <div class="border-b border-gray-200 mb-6"> <nav class="-mb-px flex space-x-8"> <a href="#tab-actions" class="border-gov-500 text-gov-600 whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm tab-link" data-tab="tab-actions"> <i class="fas fa-cogs mr-2"></i> Actions </a> <a href="#tab-identite" class="border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300 whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm tab-link" data-tab="tab-identite"> <i class="fas fa-id-card mr-2"></i> Identité </a> <a href="#tab-casier" class="border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300 whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm tab-link" data-tab="tab-casier"> <i class="fas fa-gavel mr-2"></i> Casier judiciaire </a> <a href="#tab-messages" class="border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300 whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm tab-link" data-tab="tab-messages"> <i class="fas fa-envelope mr-2"></i> Envoyer un message </a> </nav> </div> <!-- Contenu des onglets --> <div class="tab-content active" id="tab-actions"> <div class="grid grid-cols-1 md:grid-cols-2 gap-6"> <!-- Modification de la notoriété --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Modifier la notoriété </h3> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="modifier_notoriete"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div> <label for="nouvelle_notoriete" class="block text-sm font-medium text-gray-700">Nouvelle valeur (0-100)</label> <input type="number" name="nouvelle_notoriete" id="nouvelle_notoriete" min="0" max="100" value="<?php echo $identite ? $identite['notoriete'] : 50; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="raison" class="block text-sm font-medium text-gray-700">Raison</label> <textarea name="raison" id="raison" rows="3" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"></textarea> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Appliquer la modification </button> </div> </form> </div> </div> <!-- Modification du solde --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Modifier le solde bancaire </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Solde actuel: <?php echo $compte ? number_format($compte['solde'], 2, ',', ' ') . ' €' : 'Aucun compte bancaire'; ?> </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="modification_solde"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div> <label for="operation_solde" class="block text-sm font-medium text-gray-700">Opération</label> <select name="operation_solde" id="operation_solde" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <option value="ajouter">Ajouter des fonds</option> <option value="retirer">Retirer des fonds</option> </select> </div> <div> <label for="montant_modification" class="block text-sm font-medium text-gray-700">Montant</label> <div class="mt-1 relative rounded-md shadow-sm"> <input type="number" name="montant_modification" id="montant_modification" step="0.01" min="0.01" required class="block w-full pr-12 border-gray-300 rounded-md focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <div class="absolute inset-y-0 right-0 pr-3 flex items-center pointer-events-none"> <span class="text-gray-500 sm:text-sm">€</span> </div> </div> </div> <div> <label for="raison_modification" class="block text-sm font-medium text-gray-700">Raison</label> <textarea name="raison_modification" id="raison_modification" rows="3" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"></textarea> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Effectuer l'opération </button> </div> </form> </div> </div> <!-- Blocage de compte --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Bloquer l'accès </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> État actuel: <?php echo $user_data['bloque'] ? 'Bloqué jusqu\'au ' . date('d/m/Y', strtotime($user_data['date_fin_blocage'])) : 'Actif'; ?> </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="bloquer_compte"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div> <label for="duree_blocage" class="block text-sm font-medium text-gray-700">Durée du blocage (jours)</label> <input type="number" name="duree_blocage" id="duree_blocage" min="1" max="365" value="7" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="raison_blocage" class="block text-sm font-medium text-gray-700">Raison du blocage</label> <textarea name="raison_blocage" id="raison_blocage" rows="3" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"></textarea> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-red-600 hover:bg-red-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-red-500" onclick="return confirm('Êtes-vous sûr de vouloir bloquer ce compte ?');"> Bloquer l'accès </button> </div> </form> </div> </div> </div> </div> <div class="tab-content" id="tab-identite"> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Carte d'identité </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Informations d'identité du citoyen. </p> </div> <?php if($identite): ?> <!-- Aperçu de la carte d'identité --> <div class="border-t border-gray-200"> <div class="p-6 bg-gradient-to-r from-gov-600 to-gov-800 rounded-lg mx-4 my-5 text-white shadow-lg"> <div class="flex justify-between items-start mb-6"> <div> <h4 class="text-xl font-bold mb-1">Peerkinton</h4> <p class="text-sm opacity-80">Carte Nationale d'Identité</p> </div> <div class="text-right"> <p class="text-sm opacity-80">ID: <?php echo $identite['id_carte']; ?></p> </div> </div> <div class="grid grid-cols-2 gap-4 mb-4"> <div> <p class="text-xs opacity-80">Nom</p> <p class="font-medium"><?php echo $identite['nom']; ?></p> </div> <div> <p class="text-xs opacity-80">Prénom</p> <p class="font-medium"><?php echo $identite['prenom']; ?></p> </div> <div> <p class="text-xs opacity-80">Date de naissance</p> <p class="font-medium"><?php echo date('d/m/Y', strtotime($identite['date_naissance'])); ?></p> </div> <div> <p class="text-xs opacity-80">Lieu de naissance</p> <p class="font-medium"><?php echo $identite['lieu_naissance']; ?></p> </div> <div> <p class="text-xs opacity-80">Nationalité</p> <p class="font-medium"><?php echo $identite['nationalite']; ?></p> </div> <div> <p class="text-xs opacity-80">Sexe</p> <p class="font-medium"><?php echo $identite['sexe']; ?></p> </div> </div> <div class="mt-6 pt-4 border-t border-white border-opacity-20 flex justify-between items-center"> <div> <p class="text-xs opacity-80">Date d'émission</p> <p class="font-medium"><?php echo date('d/m/Y', strtotime($identite['date_emission'])); ?></p> </div> <div class="text-right"> <p class="text-xs opacity-80">Date d'expiration</p> <p class="font-medium"><?php echo date('d/m/Y', strtotime($identite['date_expiration'])); ?></p> </div> </div> </div> </div> <!-- Formulaire de modification d'identité --> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <h4 class="text-md font-medium text-gray-900 mb-4">Modifier les informations d'identité</h4> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="modifier_identite"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div class="grid grid-cols-1 md:grid-cols-2 gap-4"> <div> <label for="nom" class="block text-sm font-medium text-gray-700">Nom</label> <input type="text" name="nom" id="nom" value="<?php echo $identite['nom']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="prenom" class="block text-sm font-medium text-gray-700">Prénom</label> <input type="text" name="prenom" id="prenom" value="<?php echo $identite['prenom']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="date_naissance" class="block text-sm font-medium text-gray-700">Date de naissance</label> <input type="date" name="date_naissance" id="date_naissance" value="<?php echo $identite['date_naissance']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="lieu_naissance" class="block text-sm font-medium text-gray-700">Lieu de naissance</label> <input type="text" name="lieu_naissance" id="lieu_naissance" value="<?php echo $identite['lieu_naissance']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="nationalite" class="block text-sm font-medium text-gray-700">Nationalité</label> <input type="text" name="nationalite" id="nationalite" value="<?php echo $identite['nationalite']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="sexe" class="block text-sm font-medium text-gray-700">Sexe</label> <select name="sexe" id="sexe" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <option value="M" <?php echo $identite['sexe'] == 'M' ? 'selected' : ''; ?>>Masculin</option> <option value="F" <?php echo $identite['sexe'] == 'F' ? 'selected' : ''; ?>>Féminin</option> </select> </div> <div> <label for="adresse" class="block text-sm font-medium text-gray-700">Adresse</label> <input type="text" name="adresse" id="adresse" value="<?php echo $identite['adresse']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="telephone" class="block text-sm font-medium text-gray-700">Téléphone</label> <input type="text" name="telephone" id="telephone" value="<?php echo $identite['telephone']; ?>" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="profession" class="block text-sm font-medium text-gray-700">Profession</label> <input type="text" name="profession" id="profession" value="<?php echo $identite['profession']; ?>" class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Mettre à jour les informations </button> </div> </form> </div> <?php else: ?> <div class="border-t border-gray-200 px-4 py-5 sm:p-6 text-center"> <div class="mb-4"> <i class="fas fa-exclamation-circle text-yellow-500 text-4xl"></i> </div> <h4 class="text-lg font-medium text-gray-900 mb-2">Pas de carte d'identité</h4> <p class="text-gray-500 mb-4">Ce citoyen n'a pas encore de carte d'identité.</p> <a href="creer_identite.php?user_id=<?php echo $user_data['id']; ?>" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Créer une carte d'identité </a> </div> <?php endif; ?> </div> </div> <div class="tab-content" id="tab-casier"> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Casier judiciaire </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Historique des infractions du citoyen. </p> </div> <!-- Formulaire d'ajout d'infraction --> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <h4 class="text-md font-medium text-gray-900 mb-4">Ajouter une infraction</h4> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="ajouter_infraction"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div class="grid grid-cols-1 md:grid-cols-2 gap-4"> <div> <label for="type_infraction" class="block text-sm font-medium text-gray-700">Type d'infraction</label> <select name="type_infraction" id="type_infraction" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <option value="">Sélectionner...</option> <option value="Infraction routière">Infraction routière</option> <option value="Vol">Vol</option> <option value="Violence">Violence</option> <option value="Fraude">Fraude</option> <option value="Trafic">Trafic</option> <option value="Autre">Autre</option> </select> </div> <div> <label for="date_infraction" class="block text-sm font-medium text-gray-700">Date de l'infraction</label> <input type="date" name="date_infraction" id="date_infraction" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> </div> <div> <label for="description_infraction" class="block text-sm font-medium text-gray-700">Description</label> <textarea name="description_infraction" id="description_infraction" rows="3" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"></textarea> </div> <div> <label for="sanction_infraction" class="block text-sm font-medium text-gray-700">Sanction</label> <input type="text" name="sanction_infraction" id="sanction_infraction" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm" placeholder="Ex: Amende de 500€, 3 mois de prison, etc."> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-red-600 hover:bg-red-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-red-500"> Ajouter au casier judiciaire </button> </div> </form> </div> <!-- Liste des infractions --> <div class="border-t border-gray-200"> <div class="px-4 py-5 sm:p-6"> <h4 class="text-md font-medium text-gray-900 mb-4">Historique des infractions</h4> <?php if(count($casier) > 0): ?> <div class="overflow-x-auto"> <table class="min-w-full divide-y divide-gray-200"> <thead class="bg-gray-50"> <tr> <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Date</th> <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Type</th> <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Description</th> <th scope="col" class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Sanction</th> </tr> </thead> <tbody class="bg-white divide-y divide-gray-200"> <?php foreach($casier as $infraction): ?> <tr> <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500"> <?php echo date('d/m/Y', strtotime($infraction['date'])); ?> </td> <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900"> <?php echo $infraction['type']; ?> </td> <td class="px-6 py-4 text-sm text-gray-500"> <?php echo $infraction['description']; ?> </td> <td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500"> <?php echo $infraction['sanction']; ?> </td> </tr> <?php endforeach; ?> </tbody> </table> </div> <?php else: ?> <div class="text-center py-4"> <div class="mb-4"> <i class="fas fa-check-circle text-green-500 text-4xl"></i> </div> <h4 class="text-lg font-medium text-gray-900 mb-2">Casier judiciaire vierge</h4> <p class="text-gray-500">Ce citoyen n'a commis aucune infraction.</p> </div> <?php endif; ?> </div> </div> </div> </div> <div class="tab-content" id="tab-messages"> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> Envoyer un message officiel </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Communiquer avec le citoyen au nom du gouvernement. </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-4"> <input type="hidden" name="action" value="envoyer_message"> <input type="hidden" name="user_id" value="<?php echo $user_data['id']; ?>"> <div> <label for="type" class="block text-sm font-medium text-gray-700">Type de message</label> <select name="type" id="type" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm" onchange="toggleFactureFields()"> <option value="communication">Communication générale</option> <option value="facture">Facture</option> </select> </div> <div> <label for="sujet" class="block text-sm font-medium text-gray-700">Sujet</label> <input type="text" name="sujet" id="sujet" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div id="facture-fields" style="display: none;"> <label for="montant" class="block text-sm font-medium text-gray-700">Montant de la facture</label> <div class="mt-1 relative rounded-md shadow-sm"> <input type="number" name="montant" id="montant" step="0.01" min="0.01" class="block w-full pr-12 border-gray-300 rounded-md focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <div class="absolute inset-y-0 right-0 pr-3 flex items-center pointer-events-none"> <span class="text-gray-500 sm:text-sm">€</span> </div> </div> </div> <div> <label for="contenu" class="block text-sm font-medium text-gray-700">Contenu du message</label> <textarea name="contenu" id="contenu" rows="6" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"></textarea> </div> <div> <button type="submit" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Envoyer le message </button> </div> </form> </div> </div> </div> <?php else: ?> <div class="bg-white shadow overflow-hidden sm:rounded-lg px-4 py-5 sm:p-6 text-center"> <div class="mb-4"> <i class="fas fa-user-alt text-gray-400 text-5xl"></i> </div> <h3 class="text-lg font-medium text-gray-900 mb-2">Sélectionnez un citoyen</h3> <p class="text-gray-500">Veuillez sélectionner un citoyen pour afficher ses informations et effectuer des actions administratives.</p> </div> <?php endif; ?> </div> </main> </div> <script> document.addEventListener('DOMContentLoaded', function() { const tabLinks = document.querySelectorAll('.tab-link'); const tabContents = document.querySelectorAll('.tab-content'); tabLinks.forEach(link => { link.addEventListener('click', function(e) { e.preventDefault(); const tab = this.getAttribute('data-tab'); tabLinks.forEach(t => { t.classList.remove('border-gov-500', 'text-gov-600'); t.classList.add('border-transparent', 'text-gray-500', 'hover:text-gray-700', 'hover:border-gray-300'); }); this.classList.add('border-gov-500', 'text-gov-600'); this.classList.remove('border-transparent', 'text-gray-500', 'hover:text-gray-700', 'hover:border-gray-300'); tabContents.forEach(content => { content.classList.remove('active'); }); document.getElementById(tab).classList.add('active'); }); }); toggleFactureFields(); }); function toggleFactureFields() { const typeSelect = document.getElementById('type'); const factureFields = document.getElementById('facture-fields'); const montantInput = document.getElementById('montant'); if(typeSelect.value === 'facture') { factureFields.style.display = 'block'; montantInput.required = true; } else { factureFields.style.display = 'none'; montantInput.required = false; } } </script> </body> </html>��creer_identite.php��0000664��00000026551�15114753770�0010267 0��ustar�00��<?php session_start(); require_once '../db.php'; $user_id = isset($_GET['user_id']) ? $_GET['user_id'] : null; if(!$user_id) { header("Location: /"); exit(); } $sql = "SELECT * FROM users WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); if(!$user) { header("Location: /"); exit(); } $sql = "SELECT * FROM identites WHERE user_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); if($result->num_rows > 0) { header("Location: /index.php?user_id=" . $user_id . "&message=Ce citoyen possède déjà une carte d'identité&message_type=error"); exit(); } function genererIdCarte() { return 'ID-' . strtoupper(substr(md5(uniqid(rand(), true)), 0, 8)); } if(isset($_POST['creer_identite'])) { $nom = $_POST['nom']; $prenom = $_POST['prenom']; $date_naissance = $_POST['date_naissance']; $lieu_naissance = $_POST['lieu_naissance']; $nationalite = $_POST['nationalite']; $sexe = $_POST['sexe']; $adresse = $_POST['adresse']; $telephone = $_POST['telephone']; $profession = $_POST['profession']; $id_carte = genererIdCarte(); $date_emission = date('Y-m-d'); $date_expiration = date('Y-m-d', strtotime('+10 years')); $sql = "INSERT INTO identites (user_id, nom, prenom, date_naissance, lieu_naissance, nationalite, sexe, adresse, telephone, profession, id_carte, notoriete, date_emission, date_expiration) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 50, ?, ?)"; $stmt = $conn->prepare($sql); $stmt->bind_param("issssssssssss", $user_id, $nom, $prenom, $date_naissance, $lieu_naissance, $nationalite, $sexe, $adresse, $telephone, $profession, $id_carte, $date_emission, $date_expiration); if($stmt->execute()) { $sql = "INSERT INTO comptes_bancaires (user_id, solde) VALUES (?, 1000.00)"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $sql = "INSERT INTO journal_gouvernement (admin_id, action, cible_id, details) VALUES (?, 'creation_identite', ?, ?)"; $stmt = $conn->prepare($sql); $admin_id = $_SESSION['admin_id']; $details = "Création d'une carte d'identité et ouverture de compte bancaire"; $stmt->bind_param("iis", $admin_id, $user_id, $details); $stmt->execute(); header("Location: gouvernement.php?user_id=" . $user_id . "&message=Carte d'identité créée avec succès&message_type=success"); exit(); } else { $error = "Erreur lors de la création de la carte d'identité"; } } ?> <!DOCTYPE html> <html lang="fr"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Création d'identité - Peerkinton</title> <script src="https://cdn.tailwindcss.com"></script> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600&display=swap" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css" rel="stylesheet"> <style> body { font-family: 'Poppins', sans-serif; } </style> <script> tailwind.config = { theme: { extend: { fontFamily: { 'sans': ['Poppins', 'sans-serif'], }, colors: { 'gov': { 50: '#f0f9ff', 100: '#e0f2fe', 500: '#0ea5e9', 600: '#0284c7', 700: '#0369a1', 800: '#075985', 900: '#0c4a6e', } } } } } </script> </head> <body class="bg-gray-50 text-gray-900"> <div class="min-h-screen flex flex-col"> <header class="bg-gov-800 text-white shadow"> <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-4"> <div class="flex justify-between items-center"> <div class="flex items-center"> <i class="fas fa-landmark text-2xl mr-3"></i> <h1 class="text-xl font-semibold">Gouvernement de Peerkinton</h1> </div> <div> <a href="gouvernement.php" class="text-white hover:text-gray-200 mr-4"> <i class="fas fa-arrow-left mr-1"></i> Retour </a> <a href="logout.php" class="text-white hover:text-gray-200"> <i class="fas fa-sign-out-alt mr-1"></i> Déconnexion </a> </div> </div> </div> </header> <main class="flex-grow py-6"> <div class="max-w-3xl mx-auto px-4 sm:px-6 lg:px-8"> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h2 class="text-lg font-medium text-gray-900">Création d'une carte d'identité</h2> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Pour le citoyen: <?php echo htmlspecialchars($user['email']); ?> </p> </div> <?php if(isset($error)): ?> <div class="px-4 py-3 bg-red-50 text-red-800 border-t border-gray-200"> <?php echo $error; ?> </div> <?php endif; ?> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-6"> <div class="grid grid-cols-1 md:grid-cols-2 gap-6"> <div> <label for="nom" class="block text-sm font-medium text-gray-700">Nom</label> <input type="text" name="nom" id="nom" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="prenom" class="block text-sm font-medium text-gray-700">Prénom</label> <input type="text" name="prenom" id="prenom" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="date_naissance" class="block text-sm font-medium text-gray-700">Date de naissance</label> <input type="date" name="date_naissance" id="date_naissance" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="lieu_naissance" class="block text-sm font-medium text-gray-700">Lieu de naissance</label> <input type="text" name="lieu_naissance" id="lieu_naissance" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="nationalite" class="block text-sm font-medium text-gray-700">Nationalité</label> <input type="text" name="nationalite" id="nationalite" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="sexe" class="block text-sm font-medium text-gray-700">Sexe</label> <select name="sexe" id="sexe" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> <option value="M">Masculin</option> <option value="F">Féminin</option> </select> </div> <div class="md:col-span-2"> <label for="adresse" class="block text-sm font-medium text-gray-700">Adresse</label> <input type="text" name="adresse" id="adresse" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="telephone" class="block text-sm font-medium text-gray-700">Téléphone</label> <input type="text" name="telephone" id="telephone" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> <div> <label for="profession" class="block text-sm font-medium text-gray-700">Profession</label> <input type="text" name="profession" id="profession" class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-gov-500 focus:border-gov-500 sm:text-sm"> </div> </div> <div class="pt-4 border-t border-gray-200"> <div class="flex justify-between items-center"> <p class="text-sm text-gray-500"> Un solde initial de 1000€ sera crédité sur le compte bancaire du citoyen. </p> <button type="submit" name="creer_identite" class="inline-flex justify-center py-2 px-4 border border-transparent shadow-sm text-sm font-medium rounded-md text-white bg-gov-600 hover:bg-gov-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-gov-500"> Créer la carte d'identité </button> </div> </div> </form> </div> </div> </div> </main> </div> </body> </html>��functions_loterie.php��0000644��00000003412�15114753770�0011022 0��ustar�00��<?php // Fonctions pour le cryptage/décryptage des numéros de loterie function crypterNumeros($numeros, $cle) { // Utiliser base64 + simple décalage pour éviter les problèmes d'encoding $data = $numeros . '\|' . $cle; $encrypted = base64_encode($data); // Ajouter un décalage simple pour plus de sécurité $shifted = ''; for($i = 0; $i < strlen($encrypted); $i++) { $shifted .= chr((ord($encrypted[$i]) + 3) % 256); } return base64_encode($shifted); } function decrypterNumeros($numeros_cryptes, $cle) { try { // Décoder le base64 externe $shifted = base64_decode($numeros_cryptes); // Annuler le décalage $encrypted = ''; for($i = 0; $i < strlen($shifted); $i++) { $encrypted .= chr((ord($shifted[$i]) - 3 + 256) % 256); } // Décoder et vérifier la clé $data = base64_decode($encrypted); $parts = explode('\|', $data); if(count($parts) == 2 && $parts[1] == $cle) { return $parts[0]; // Retourner les numéros } return false; } catch(Exception $e) { return false; } } function genererNumerosAleatoires() { $nums = range(1, 10); shuffle($nums); $numeros = array_slice($nums, 0, 3); sort($numeros); return implode('-', $numeros); } function validerNumeros($numeros) { $nums = explode('-', $numeros); if(count($nums) != 3) { return false; } foreach($nums as $num) { $n = (int)$num; if($n < 1 \|\| $n > 10) { return false; } } // Vérifier qu'ils sont tous différents if(count(array_unique($nums)) != 3) { return false; } return true; } ?>��error_log��0000644��00000011335�15114753770�0006476 0��ustar�00��[25-Jun-2025 19:31:50 UTC] PHP Warning: include(cron_tirage_loterie.php): Failed to open stream: No such file or directory in /home/gqdcvggs/peerkinton.com/gov/loterie.php on line 67 [25-Jun-2025 19:31:50 UTC] PHP Warning: include(cron_tirage_loterie.php): Failed to open stream: No such file or directory in /home/gqdcvggs/peerkinton.com/gov/loterie.php on line 67 [25-Jun-2025 19:31:50 UTC] PHP Warning: include(): Failed opening 'cron_tirage_loterie.php' for inclusion (include_path='.:/opt/cpanel/ea-php81/root/usr/share/pear') in /home/gqdcvggs/peerkinton.com/gov/loterie.php on line 67 [26-Jun-2025 15:50:00 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/index.php on line 151 [26-Jun-2025 15:50:00 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/index.php:154 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/index.php(154): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/index.php on line 154 [26-Jun-2025 15:51:05 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/index.php on line 90 [26-Jun-2025 15:51:05 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/index.php:93 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/index.php(93): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/index.php on line 93 [02-Jul-2025 12:59:27 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 73 [02-Jul-2025 12:59:27 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php:76 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/creer_identite.php(76): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 76 [02-Jul-2025 13:01:57 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/index.php on line 90 [02-Jul-2025 13:01:57 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/index.php:93 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/index.php(93): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/index.php on line 93 [29-Sep-2025 19:02:48 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 73 [29-Sep-2025 19:02:48 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php:76 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/creer_identite.php(76): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 76 [10-Oct-2025 16:38:48 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 73 [10-Oct-2025 16:38:48 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php:76 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/creer_identite.php(76): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 76 [10-Oct-2025 16:39:15 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/index.php on line 90 [10-Oct-2025 16:39:15 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/index.php:93 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/index.php(93): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/index.php on line 93 [18-Oct-2025 14:44:33 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 73 [18-Oct-2025 14:44:33 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php:76 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/creer_identite.php(76): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/creer_identite.php on line 76 [18-Oct-2025 14:44:53 UTC] PHP Warning: Undefined array key "admin_id" in /home/gqdcvggs/peerkinton.com/gov/index.php on line 90 [18-Oct-2025 14:44:53 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Column 'admin_id' cannot be null in /home/gqdcvggs/peerkinton.com/gov/index.php:93 Stack trace: #0 /home/gqdcvggs/peerkinton.com/gov/index.php(93): mysqli_stmt->execute() #1 {main} thrown in /home/gqdcvggs/peerkinton.com/gov/index.php on line 93 ��loterie.php��0000644��00000146732�15114753770�0006747 0��ustar�00��<?php session_start(); if(!isset($_SESSION['user_id']) \|\| $_SESSION['user_id'] != 1) { header("Location: login.php"); exit(); } require_once '../db.php'; require_once 'functions_loterie.php'; $user_id = $_SESSION['user_id']; $sql = "SELECT * FROM users WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); $message = ''; $success = false; if(isset($_POST['action'])) { switch($_POST['action']) { case 'creer_loterie': $nom = $_POST['nom_loterie']; $date_tirage = $_POST['date_tirage']; $num1 = $_POST['numero_1']; $num2 = $_POST['numero_2']; $num3 = $_POST['numero_3']; $jackpot = $_POST['jackpot_initial']; if(empty($nom) \|\| empty($date_tirage) \|\| empty($num1) \|\| empty($num2) \|\| empty($num3)) { $message = "Tous les champs sont obligatoires."; } elseif($num1 == $num2 \|\| $num1 == $num3 \|\| $num2 == $num3) { $message = "Les trois numéros doivent être différents."; } elseif($num1 < 1 \|\| $num1 > 10 \|\| $num2 < 1 \|\| $num2 > 10 \|\| $num3 < 1 \|\| $num3 > 10) { $message = "Les numéros doivent être entre 1 et 10."; } else { $numeros_string = $num1 . '-' . $num2 . '-' . $num3; $cle_cryptage = 'peerkinton_secret_' . date('Y'); $numeros_cryptes = crypterNumeros($numeros_string, $cle_cryptage); $sql = "INSERT INTO loteries (nom, date_tirage, numeros_gagnants, cle_cryptage, jackpot, statut) VALUES (?, ?, ?, ?, ?, 'ouvert')"; $stmt = $conn->prepare($sql); $stmt->bind_param("ssssd", $nom, $date_tirage, $numeros_cryptes, $cle_cryptage, $jackpot); if($stmt->execute()) { $success = true; $message = "Loterie créée avec succès ! Numéros gagnants : " . $numeros_string; } else { $message = "Erreur lors de la création de la loterie."; } } break; case 'forcer_tirage': $loterie_id = $_POST['loterie_id']; $sql = "UPDATE loteries SET date_tirage = CURDATE() WHERE id = ? AND statut = 'ouvert'"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $loterie_id); if($stmt->execute() && $stmt->affected_rows > 0) { ob_start(); $_GET['force_tirage'] = $loterie_id; include 'cron_tirage_loterie.php'; $tirage_output = ob_get_clean(); $success = true; $message = "Tirage forcé avec succès !"; } else { $message = "Erreur : loterie introuvable ou déjà tirée."; } break; case 'generer_auto': $numeros_string = genererNumerosAleatoires(); $nom = "Loterie Auto #" . date('W'); $date_tirage = date('Y-m-d', strtotime('+7 days')); $jackpot = 1000; $cle_cryptage = 'peerkinton_secret_' . date('Y'); $numeros_cryptes = crypterNumeros($numeros_string, $cle_cryptage); $sql = "INSERT INTO loteries (nom, date_tirage, numeros_gagnants, cle_cryptage, jackpot, statut) VALUES (?, ?, ?, ?, ?, 'ouvert')"; $stmt = $conn->prepare($sql); $stmt->bind_param("ssssd", $nom, $date_tirage, $numeros_cryptes, $cle_cryptage, $jackpot); if($stmt->execute()) { $success = true; $message = "Loterie automatique créée ! Date: $date_tirage, Numéros: $numeros_string"; } else { $message = "Erreur lors de la création automatique."; } break; } } $onglet = isset($_GET['tab']) ? $_GET['tab'] : 'overview'; ?> <!DOCTYPE html> <html lang="fr"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Administration Loterie - Peerkinton</title> <script src="https://cdn.tailwindcss.com"></script> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600&display=swap" rel="stylesheet"> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css" rel="stylesheet"> <style> body { font-family: 'Poppins', sans-serif; } .tab-content { display: none; } .tab-content.active { display: block; } </style> <script> tailwind.config = { theme: { extend: { fontFamily: { 'sans': ['Poppins', 'sans-serif'], }, colors: { primary: { 50: '#f0f9ff', 100: '#e0f2fe', 200: '#bae6fd', 300: '#7dd3fc', 400: '#38bdf8', 500: '#0ea5e9', 600: '#0284c7', 700: '#0369a1', 800: '#075985', 900: '#0c4a6e', } } } } } </script> </head> <body class="bg-gray-50 text-gray-900"> <div class="min-h-screen flex flex-col"> <nav class="bg-white shadow"> <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8"> <div class="flex justify-between h-16"> <div class="flex"> <div class="flex-shrink-0 flex items-center"> <img src="../logo.png" alt="Peerkinton Logo" class="h-8"> <a href="index.php" class="ml-4 flex items-center px-3 py-2 text-gray-700 hover:text-primary-600 transition-colors"> <i class="fas fa-arrow-left mr-2"></i> Retour Dashboard </a> </div> </div> <div class="flex items-center"> <div class="ml-3 relative"> <div class="flex items-center space-x-4"> <div class="bg-red-100 text-red-800 px-3 py-1 rounded-full text-xs font-semibold"> <i class="fas fa-crown mr-1"></i>ADMIN </div> <span class="text-sm font-medium"><?php echo htmlspecialchars($user['email']); ?></span> <a href="logout.php" class="text-gray-500 hover:text-gray-700"> <i class="fas fa-sign-out-alt"></i> </a> </div> </div> </div> </div> </div> </nav> <div class="flex-grow py-6"> <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8"> <div class="mb-6"> <h1 class="text-3xl font-bold text-gray-900 flex items-center"> <i class="fas fa-dice mr-3 text-purple-600"></i> Administration Loterie </h1> <p class="mt-1 text-sm text-gray-600">Gestion complète du système de loterie Peerkinton</p> </div> <?php if($message): ?> <div class="mb-6 px-4 py-3 rounded-lg <?php echo $success ? 'bg-green-50 border border-green-200 text-green-800' : 'bg-red-50 border border-red-200 text-red-800'; ?>"> <div class="flex items-center"> <i class="<?php echo $success ? 'fas fa-check-circle' : 'fas fa-exclamation-triangle'; ?> mr-2"></i> <?php echo htmlspecialchars($message); ?> </div> </div> <?php endif; ?> <div class="border-b border-gray-200 mb-6"> <nav class="-mb-px flex space-x-8"> <button onclick="showTab('overview')" class="tab-link <?php echo $onglet == 'overview' ? 'border-primary-500 text-primary-600' : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'; ?> whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm"> <i class="fas fa-chart-line mr-2"></i> Vue d'ensemble </button> <button onclick="showTab('create')" class="tab-link <?php echo $onglet == 'create' ? 'border-primary-500 text-primary-600' : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'; ?> whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm"> <i class="fas fa-plus-circle mr-2"></i> Créer Loterie </button> <button onclick="showTab('manage')" class="tab-link <?php echo $onglet == 'manage' ? 'border-primary-500 text-primary-600' : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'; ?> whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm"> <i class="fas fa-cogs mr-2"></i> Gérer Loteries </button> <button onclick="showTab('stats')" class="tab-link <?php echo $onglet == 'stats' ? 'border-primary-500 text-primary-600' : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'; ?> whitespace-nowrap py-4 px-1 border-b-2 font-medium text-sm"> <i class="fas fa-chart-pie mr-2"></i> Statistiques </button> </nav> </div> <!-- VUE D'ENSEMBLE --> <div class="tab-content <?php echo $onglet == 'overview' ? 'active' : ''; ?>" id="tab-overview"> <?php // Statistiques globales $sql = "SELECT COUNT() as total_loteries FROM loteries"; $total_loteries = $conn->query($sql)->fetch_assoc()['total_loteries']; $sql = "SELECT COUNT() as loteries_actives FROM loteries WHERE statut = 'ouvert'"; $loteries_actives = $conn->query($sql)->fetch_assoc()['loteries_actives']; $sql = "SELECT SUM(prix_paye) as revenus_total FROM loterie_participations"; $revenus_total = $conn->query($sql)->fetch_assoc()['revenus_total'] ?: 0; $sql = "SELECT SUM(gains) as gains_distribues FROM loterie_participations WHERE gains > 0"; $gains_distribues = $conn->query($sql)->fetch_assoc()['gains_distribues'] ?: 0; ?> <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-6 mb-8"> <div class="bg-white overflow-hidden shadow rounded-lg"> <div class="p-5"> <div class="flex items-center"> <div class="flex-shrink-0"> <i class="fas fa-dice text-2xl text-purple-600"></i> </div> <div class="ml-5 w-0 flex-1"> <dl> <dt class="text-sm font-medium text-gray-500 truncate">Total Loteries</dt> <dd class="text-lg font-medium text-gray-900"><?php echo $total_loteries; ?></dd> </dl> </div> </div> </div> </div> <div class="bg-white overflow-hidden shadow rounded-lg"> <div class="p-5"> <div class="flex items-center"> <div class="flex-shrink-0"> <i class="fas fa-play-circle text-2xl text-green-600"></i> </div> <div class="ml-5 w-0 flex-1"> <dl> <dt class="text-sm font-medium text-gray-500 truncate">Loteries Actives</dt> <dd class="text-lg font-medium text-gray-900"><?php echo $loteries_actives; ?></dd> </dl> </div> </div> </div> </div> <div class="bg-white overflow-hidden shadow rounded-lg"> <div class="p-5"> <div class="flex items-center"> <div class="flex-shrink-0"> <i class="fas fa-coins text-2xl text-yellow-600"></i> </div> <div class="ml-5 w-0 flex-1"> <dl> <dt class="text-sm font-medium text-gray-500 truncate">Revenus Total</dt> <dd class="text-lg font-medium text-gray-900"><?php echo number_format($revenus_total, 0, ',', ' '); ?> F&</dd> </dl> </div> </div> </div> </div> <div class="bg-white overflow-hidden shadow rounded-lg"> <div class="p-5"> <div class="flex items-center"> <div class="flex-shrink-0"> <i class="fas fa-trophy text-2xl text-orange-600"></i> </div> <div class="ml-5 w-0 flex-1"> <dl> <dt class="text-sm font-medium text-gray-500 truncate">Gains Distribués</dt> <dd class="text-lg font-medium text-gray-900"><?php echo number_format($gains_distribues, 0, ',', ' '); ?> F&</dd> </dl> </div> </div> </div> </div> </div> <!-- Loteries récentes --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900">Loteries Récentes</h3> </div> <div class="border-t border-gray-200"> <div class="overflow-x-auto"> <table class="min-w-full divide-y divide-gray-200"> <thead class="bg-gray-50"> <tr> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ID</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Nom</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Date Tirage</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Jackpot</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Statut</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Participants</th> </tr> </thead> <tbody class="bg-white divide-y divide-gray-200"> <?php $sql = "SELECT l., COUNT(lp.id) as nb_participants FROM loteries l LEFT JOIN loterie_participations lp ON l.id = lp.loterie_id GROUP BY l.id ORDER BY l.date_creation DESC LIMIT 10"; $result = $conn->query($sql); while($loterie = $result->fetch_assoc()) { $statut_class = ''; $statut_text = ''; switch($loterie['statut']) { case 'ouvert': $statut_class = 'bg-green-100 text-green-800'; $statut_text = 'Ouvert'; break; case 'ferme': $statut_class = 'bg-yellow-100 text-yellow-800'; $statut_text = 'Fermé'; break; case 'tire': $statut_class = 'bg-blue-100 text-blue-800'; $statut_text = 'Tiré'; break; } echo '<tr>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">' . $loterie['id'] . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' . htmlspecialchars($loterie['nom']) . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">' . date('d/m/Y', strtotime($loterie['date_tirage'])) . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">' . number_format($loterie['jackpot'], 0, ',', ' ') . ' F&</td>'; echo '<td class="px-6 py-4 whitespace-nowrap">'; echo '<span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium ' . $statut_class . '">' . $statut_text . '</span>'; echo '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">' . $loterie['nb_participants'] . '</td>'; echo '</tr>'; } ?> </tbody> </table> </div> </div> </div> </div> <!-- CRÉER LOTERIE --> <div class="tab-content <?php echo $onglet == 'create' ? 'active' : ''; ?>" id="tab-create"> <div class="grid grid-cols-1 lg:grid-cols-2 gap-8"> <!-- Création manuelle --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-edit mr-2 text-primary-600"></i>Création Manuelle </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Créez une loterie avec des paramètres personnalisés. </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <form action="" method="POST" class="space-y-6"> <input type="hidden" name="action" value="creer_loterie"> <div> <label for="nom_loterie" class="block text-sm font-medium text-gray-700">Nom de la loterie</label> <input type="text" name="nom_loterie" id="nom_loterie" required class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 sm:text-sm" placeholder="Ex: Loterie Spéciale Noël"> </div> <div> <label for="date_tirage" class="block text-sm font-medium text-gray-700">Date du tirage</label> <input type="date" name="date_tirage" id="date_tirage" required min="<?php echo date('Y-m-d', strtotime('+1 day')); ?>" class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 sm:text-sm"> </div> <div> <label class="block text-sm font-medium text-gray-700 mb-3">Numéros gagnants (seront cryptés)</label> <div class="grid grid-cols-3 gap-4"> <div> <label class="block text-xs text-gray-500 mb-1">1er numéro</label> <select name="numero_1" required class="w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 text-center font-bold"> <?php for($i = 1; $i <= 10; $i++): ?> <option value="<?php echo $i; ?>"><?php echo $i; ?></option> <?php endfor; ?> </select> </div> <div> <label class="block text-xs text-gray-500 mb-1">2ème numéro</label> <select name="numero_2" required class="w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 text-center font-bold"> <?php for($i = 1; $i <= 10; $i++): ?> <option value="<?php echo $i; ?>"><?php echo $i; ?></option> <?php endfor; ?> </select> </div> <div> <label class="block text-xs text-gray-500 mb-1">3ème numéro</label> <select name="numero_3" required class="w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 text-center font-bold"> <?php for($i = 1; $i <= 10; $i++): ?> <option value="<?php echo $i; ?>"><?php echo $i; ?></option> <?php endfor; ?> </select> </div> </div> </div> <div> <label for="jackpot_initial" class="block text-sm font-medium text-gray-700">Jackpot initial (F&)</label> <input type="number" name="jackpot_initial" id="jackpot_initial" required min="100" value="1000" class="mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-primary-500 focus:border-primary-500 sm:text-sm"> </div> <div> <button type="submit" class="w-full flex justify-center py-2 px-4 border border-transparent rounded-md shadow-sm text-sm font-medium text-white bg-primary-600 hover:bg-primary-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-primary-500"> <i class="fas fa-plus mr-2"></i> Créer la Loterie </button> </div> </form> </div> </div> <!-- Création automatique --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-magic mr-2 text-purple-600"></i>Création Automatique </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Génération automatique avec numéros aléatoires. </p> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <div class="text-center"> <div class="bg-purple-100 p-6 rounded-full w-24 h-24 mx-auto mb-6 flex items-center justify-center"> <i class="fas fa-dice text-3xl text-purple-600"></i> </div> <h4 class="text-lg font-semibold text-gray-900 mb-4">Génération Automatique</h4> <div class="bg-gray-50 rounded-lg p-4 mb-6"> <div class="grid grid-cols-2 gap-4 text-sm"> <div> <span class="text-gray-600">Nom :</span> <span class="font-medium">Loterie Auto #<?php echo date('W'); ?></span> </div> <div> <span class="text-gray-600">Date :</span> <span class="font-medium"><?php echo date('d/m/Y', strtotime('+7 days')); ?></span> </div> <div> <span class="text-gray-600">Jackpot :</span> <span class="font-medium">1,000 F&</span> </div> <div> <span class="text-gray-600">Numéros :</span> <span class="font-medium">Aléatoires</span> </div> </div> </div> <form action="" method="POST"> <input type="hidden" name="action" value="generer_auto"> <button type="submit" class="w-full flex justify-center py-3 px-4 border border-transparent rounded-md shadow-sm text-sm font-medium text-white bg-purple-600 hover:bg-purple-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-purple-500"> <i class="fas fa-magic mr-2"></i> Générer Automatiquement </button> </form> </div> </div> </div> </div> </div> <!-- GÉRER LOTERIES --> <div class="tab-content <?php echo $onglet == 'manage' ? 'active' : ''; ?>" id="tab-manage"> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-cogs mr-2 text-primary-600"></i>Gestion des Loteries </h3> <p class="mt-1 max-w-2xl text-sm text-gray-500"> Administrez toutes les loteries existantes. </p> </div> <div class="border-t border-gray-200"> <div class="overflow-x-auto"> <table class="min-w-full divide-y divide-gray-200"> <thead class="bg-gray-50"> <tr> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ID</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Nom</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Date Tirage</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Jackpot</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Participants</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Statut</th> <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Actions</th> </tr> </thead> <tbody class="bg-white divide-y divide-gray-200"> <?php $sql = "SELECT l., COUNT(lp.id) as nb_participants, SUM(CASE WHEN lp.gagnant = 'oui' THEN 1 ELSE 0 END) as nb_gagnants FROM loteries l LEFT JOIN loterie_participations lp ON l.id = lp.loterie_id GROUP BY l.id ORDER BY l.date_tirage DESC"; $result = $conn->query($sql); while($loterie = $result->fetch_assoc()) { $statut_class = ''; $statut_text = ''; $can_force_tirage = false; switch($loterie['statut']) { case 'ouvert': $statut_class = 'bg-green-100 text-green-800'; $statut_text = 'Ouvert'; $can_force_tirage = true; break; case 'ferme': $statut_class = 'bg-yellow-100 text-yellow-800'; $statut_text = 'Fermé'; break; case 'tire': $statut_class = 'bg-blue-100 text-blue-800'; $statut_text = 'Tiré'; break; } echo '<tr>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm font-medium text-gray-900">' . $loterie['id'] . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900">' . htmlspecialchars($loterie['nom']) . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">' . date('d/m/Y', strtotime($loterie['date_tirage'])) . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-900 font-semibold">' . number_format($loterie['jackpot'], 0, ',', ' ') . ' F&</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm text-gray-500">' . $loterie['nb_participants'] . '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap">'; echo '<span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium ' . $statut_class . '">' . $statut_text . '</span>'; echo '</td>'; echo '<td class="px-6 py-4 whitespace-nowrap text-sm font-medium space-x-2">'; if($can_force_tirage) { echo '<form action="" method="POST" class="inline">'; echo '<input type="hidden" name="action" value="forcer_tirage">'; echo '<input type="hidden" name="loterie_id" value="' . $loterie['id'] . '">'; echo '<button type="submit" onclick="return confirm(\'Êtes-vous sûr de vouloir forcer le tirage ?\')" class="text-red-600 hover:text-red-900">'; echo '<i class="fas fa-play-circle mr-1"></i>Forcer Tirage'; echo '</button>'; echo '</form>'; } if($loterie['statut'] == 'tire') { echo '<button onclick="showResults(' . $loterie['id'] . ')" class="text-blue-600 hover:text-blue-900 ml-2">'; echo '<i class="fas fa-eye mr-1"></i>Voir Résultats'; echo '</button>'; } echo '</td>'; echo '</tr>'; } ?> </tbody> </table> </div> </div> </div> </div> <!-- STATISTIQUES --> <div class="tab-content <?php echo $onglet == 'stats' ? 'active' : ''; ?>" id="tab-stats"> <div class="grid grid-cols-1 lg:grid-cols-2 gap-8"> <!-- Revenus par mois --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-chart-line mr-2 text-green-600"></i>Revenus Mensuels </h3> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <?php $sql = "SELECT YEAR(lp.date_participation) as annee, MONTH(lp.date_participation) as mois, SUM(lp.prix_paye) as revenus FROM loterie_participations lp WHERE lp.date_participation >= DATE_SUB(NOW(), INTERVAL 6 MONTH) GROUP BY YEAR(lp.date_participation), MONTH(lp.date_participation) ORDER BY annee DESC, mois DESC LIMIT 6"; $result = $conn->query($sql); ?> <div class="space-y-3"> <?php while($row = $result->fetch_assoc()): ?> <?php $mois_nom = date('F Y', mktime(0, 0, 0, $row['mois'], 1, $row['annee'])); $pourcentage = ($row['revenus'] / 5000) * 100; // Base 5000 pour la barre ?> <div> <div class="flex justify-between text-sm"> <span class="font-medium text-gray-900"><?php echo $mois_nom; ?></span> <span class="text-gray-600"><?php echo number_format($row['revenus'], 0, ',', ' '); ?> F&</span> </div> <div class="mt-1 bg-gray-200 rounded-full h-2"> <div class="bg-green-600 h-2 rounded-full" style="width: <?php echo min($pourcentage, 100); ?>%"></div> </div> </div> <?php endwhile; ?> </div> </div> </div> <!-- Top joueurs --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-users mr-2 text-blue-600"></i>Top Joueurs </h3> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <?php $sql = "SELECT u.email, COUNT(lp.id) as nb_participations, SUM(lp.prix_paye) as total_depense, SUM(lp.gains) as total_gains FROM loterie_participations lp JOIN users u ON lp.user_id = u.id GROUP BY lp.user_id ORDER BY nb_participations DESC LIMIT 10"; $result = $conn->query($sql); ?> <div class="space-y-4"> <?php $position = 1; ?> <?php while($row = $result->fetch_assoc()): ?> <div class="flex items-center justify-between p-3 bg-gray-50 rounded-lg"> <div class="flex items-center"> <div class="flex-shrink-0 w-8 h-8 bg-primary-600 text-white rounded-full flex items-center justify-center text-sm font-bold"> <?php echo $position; ?> </div> <div class="ml-3"> <p class="text-sm font-medium text-gray-900"><?php echo htmlspecialchars($row['email']); ?></p> <p class="text-xs text-gray-500"><?php echo $row['nb_participations']; ?> participations</p> </div> </div> <div class="text-right"> <p class="text-sm font-semibold text-gray-900"> <?php echo number_format($row['total_gains'] - $row['total_depense'], 0, ',', ' '); ?> F& </p> <p class="text-xs text-gray-500"> <?php echo $row['total_gains'] > $row['total_depense'] ? 'Bénéfice' : 'Perte'; ?> </p> </div> </div> <?php $position++; ?> <?php endwhile; ?> </div> </div> </div> <!-- Taux de gain --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-percentage mr-2 text-purple-600"></i>Taux de Gains </h3> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <?php $sql = "SELECT COUNT() as total_participations, SUM(CASE WHEN gagnant = 'oui' THEN 1 ELSE 0 END) as total_gagnants, SUM(CASE WHEN gains >= 200 THEN 1 ELSE 0 END) as jackpots_partiels, SUM(CASE WHEN gains >= 1000 THEN 1 ELSE 0 END) as jackpots_complets FROM loterie_participations"; $stats = $conn->query($sql)->fetch_assoc(); $taux_gain = $stats['total_participations'] > 0 ? ($stats['total_gagnants'] / $stats['total_participations']) 100 : 0; ?> <div class="space-y-4"> <div class="text-center"> <div class="text-3xl font-bold text-purple-600"><?php echo number_format($taux_gain, 1); ?>%</div> <div class="text-sm text-gray-500">Taux de gain global</div> </div> <div class="grid grid-cols-2 gap-4 text-center"> <div class="bg-yellow-50 p-3 rounded-lg"> <div class="text-lg font-semibold text-yellow-600"><?php echo $stats['jackpots_partiels']; ?></div> <div class="text-xs text-gray-600">Gains partiels</div> </div> <div class="bg-green-50 p-3 rounded-lg"> <div class="text-lg font-semibold text-green-600"><?php echo $stats['jackpots_complets']; ?></div> <div class="text-xs text-gray-600">Jackpots</div> </div> </div> </div> </div> </div> <!-- Prochains tirages --> <div class="bg-white shadow overflow-hidden sm:rounded-lg"> <div class="px-4 py-5 sm:px-6"> <h3 class="text-lg leading-6 font-medium text-gray-900"> <i class="fas fa-calendar-alt mr-2 text-orange-600"></i>Prochains Tirages </h3> </div> <div class="border-t border-gray-200 px-4 py-5 sm:p-6"> <?php $sql = "SELECT nom, date_tirage, jackpot FROM loteries WHERE statut = 'ouvert' AND date_tirage >= CURDATE() ORDER BY date_tirage ASC LIMIT 5"; $result = $conn->query($sql); ?> <div class="space-y-3"> <?php if($result->num_rows > 0): ?> <?php while($row = $result->fetch_assoc()): ?> <div class="flex justify-between items-center p-3 bg-orange-50 rounded-lg"> <div> <p class="text-sm font-medium text-gray-900"><?php echo htmlspecialchars($row['nom']); ?></p> <p class="text-xs text-gray-500"><?php echo date('d/m/Y', strtotime($row['date_tirage'])); ?></p> </div> <div class="text-right"> <p class="text-sm font-semibold text-orange-600"> <?php echo number_format($row['jackpot'], 0, ',', ' '); ?> F& </p> </div> </div> <?php endwhile; ?> <?php else: ?> <div class="text-center text-gray-500 py-8"> <i class="fas fa-calendar-times text-3xl mb-3"></i> <p>Aucun tirage programmé</p> </div> <?php endif; ?> </div> </div> </div> </div> </div> </div> </div> </div> <!-- Modal pour les résultats --> <div id="resultModal" class="fixed inset-0 bg-gray-600 bg-opacity-50 overflow-y-auto h-full w-full hidden"> <div class="relative top-20 mx-auto p-5 border w-11/12 md:w-3/4 lg:w-1/2 shadow-lg rounded-md bg-white"> <div class="mt-3"> <div class="flex justify-between items-center mb-4"> <h3 class="text-lg font-medium text-gray-900" id="modalTitle">Résultats du Tirage</h3> <button onclick="closeModal()" class="text-gray-400 hover:text-gray-600"> <i class="fas fa-times text-xl"></i> </button> </div> <div id="modalContent" class="space-y-4"> <!-- Contenu chargé dynamiquement --> </div> </div> </div> </div> <script> function showTab(tabName) { document.querySelectorAll('.tab-content').forEach(content => { content.classList.remove('active'); }); document.querySelectorAll('.tab-link').forEach(link => { link.classList.remove('border-primary-500', 'text-primary-600'); link.classList.add('border-transparent', 'text-gray-500'); }); document.getElementById('tab-' + tabName).classList.add('active'); event.target.classList.remove('border-transparent', 'text-gray-500'); event.target.classList.add('border-primary-500', 'text-primary-600'); } function showResults(loterieId) { // Simuler l'affichage des résultats (à implémenter avec AJAX) document.getElementById('modalTitle').textContent = 'Résultats du Tirage #' + loterieId; document.getElementById('modalContent').innerHTML = ` <div class="text-center"> <div class="bg-blue-100 p-4 rounded-lg mb-4"> <p class="font-semibold">Chargement des résultats...</p> </div> </div> `; document.getElementById('resultModal').classList.remove('hidden'); } function closeModal() { document.getElementById('resultModal').classList.add('hidden'); } // Fermer modal en cliquant à l'extérieur window.onclick = function(event) { const modal = document.getElementById('resultModal'); if (event.target == modal) { closeModal(); } } </script> </body> </html>��

| ver. 1.6 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка