page maintenance: voir/supprimer les logs et lien vers voir les e-mails, suppression des modes de fonctionnement

1 files changed, 50 insertions, 0 deletions

diff --git a/src/controller/MaintenanceController.php b/src/controller/MaintenanceController.php
new file mode 100644
index 0000000..49ec23f
--- /dev/null
+++ b/src/controller/MaintenanceController.php
@@ -0,0 +1,50 @@
+<?php
+// src/controller/MaintenanceController.php
+
+declare(strict_types=1);
+
+use Doctrine\ORM\EntityManager;
+use App\Entity\log;
+
+class MaintenanceController
+{
+        static public function getLogs(EntityManager $entityManager): void
+        {
+                $data = $entityManager->getRepository(Log::class)->findAll();
+                if(empty($data)){
+                        echo json_encode(['success' => false]);
+                }
+                else{
+                        $view = '<h4>Table ' . TABLE_PREFIX . 'log de la BDD</h4>
+                                <table style="border-collapse: collapse; font-size: smaller;">
+                                        <thead>
+                                                <tr>
+                                <th style="border: 1px black solid;">date et heure (Greenwich)</th>
+                                <th style="border: 1px black solid;">connexion réussie</th>
+                            </tr>
+                        </thead>
+                        <tbody>';
+            foreach($data as $entry){
+                $view .= '<tr>
+                        <td style="border: 1px black solid;">' . $entry->getFormatedDate() . '</td>
+                        <td style="border: 1px black solid;">' . ($entry->getSuccess() ? 'oui' : 'non') . '</td>
+                </tr>';
+            }
+            $view .= '</tbody></table>';
+                        echo json_encode(['success' => true, 'view' => $view]);
+                }
+                die;
+        }
+        static public function eraseLogs(EntityManager $entityManager): void
+        {
+                try{
+                        $table = $entityManager->getClassMetadata(Log::class)->getTableName();
+                        $entityManager->getConnection()->executeStatement("TRUNCATE TABLE {$table}"); // SQL donné à DBAL
+                        echo json_encode(['success' => true]);
+                }
+                catch(Exception $e){
+                        echo json_encode(['success' => false]);
+                }
+                die;
+        }
+}
\ No newline at end of file