AbulÉdu » abuledu-murdeclasse

// Mot de passe administrateur

define ("SUPER_ADMIN","{{supassword}}");

// Autre constantes

<?php

/************************************************************************************

 *

 *  Projet AbulEdu Mur de Classe  - Licence: GNU/Affero GPL v3 ou +

 *

 *  (c) 2020 Frédéric Adamczak <fred@fadamczak.fr>

 *

 *   This file is part of AbulEdu Mur de Classe.

 *

 *   AbulEdu Mur de Classe is free software: you can redistribute it and/or modify

 *   it under the terms of the GNU Affero General Public License as published by

 *   the Free Software Foundation, either version 3 of the License, or

 *   (at your option) any later version.

 *

 *   AbulEdu Mur de Classe is distributed in the hope that it will be useful,

 *   but WITHOUT ANY WARRANTY; without even the implied warranty of

 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 *   GNU Affero General Public License for more details.

 *

 *   You should have received a copy of the GNU General Public License

 *   along with ClicAlbum. If not, see <https://www.gnu.org/licenses/>.

 *

 ************************************************************************************/

include_once("../_config/config.php");

echo "<h4>On efface les murs inactifs</h4>";

try {

  $db = new PDO('mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME.';charset=utf8', DATABASE_USER, DATABASE_PASSWORD);

} catch (PDOException $e) {

    print "Erreur !: " . $e->getMessage();

    die();

}

// On recherche tous les murs inactifs depuis 6 mois

$periode = date('Y-m-d', strtotime('-12 month'));

$sql = "SELECT id_mur FROM mur WHERE date_acces < '$periode'";

if (!$query=$db->query($sql)) {

  die ("Erreur dans la requete 1");

}

$res = $query->fetchAll(PDO::FETCH_NUM);

// Pour chacun de ces murs :

// 1- on vide le dossier correspondant

// 2- on le supprime de la base

foreach($res as $mur) {

  $id = $mur[0];

  echo "Mur n° ".$id."<br />";

  $dossier = "../MURS/".$id;

  echo $dossier."<br />";

  // Lecture du contenu du dossier

  $fichiers = scandir($dossier);

  // On enlève les fichiers . et ..

  array_shift($fichiers);

  array_shift($fichiers);

  // On supprime tous les fichiers restants

  foreach($fichiers as $fichier) {

    $supp =  $dossier. DIRECTORY_SEPARATOR .$fichier;

    if (!unlink($supp)) {

      echo "<h5>Erreur dans la suppression de : ".$supp."</h5>";

    }

    // On supprime les briques du mur

    $sql = "DELETE FROM brique WHERE id_mur='$id'";

    if (!$query=$db->query($sql)) {

      die ("Erreur dans la requete de suppression des briques");

    }

  }

  // On supprime le répertoire

  if (!rmdir($dossier)) {

    echo "<h5>Erreur dans la suppression du dossier : ".$dossier."</h5>";

  }

  // On supprime les murs de la base.

  $sql = "DELETE FROM mur WHERE date_acces < '$periode'";

  if (!$query=$db->query($sql)) {

    die ("Erreur dans la requete de suppression du mur");

  }

}

print "<h4>Opération terminée</h4>";

?>

<?php

/************************************************************************************

 *

 *  Projet AbulEdu Mur de Classe  - Licence: GNU/Affero GPL v3 ou +

 *

 *  (c) 2020 Frédéric Adamczak <fred@fadamczak.fr>

 *

 *   This file is part of AbulEdu Mur de Classe.

 *

 *   AbulEdu Mur de Classe is free software: you can redistribute it and/or modify

 *   it under the terms of the GNU Affero General Public License as published by

 *   the Free Software Foundation, either version 3 of the License, or

 *   (at your option) any later version.

 *

 *   AbulEdu Mur de Classe is distributed in the hope that it will be useful,

 *   but WITHOUT ANY WARRANTY; without even the implied warranty of

 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 *   GNU Affero General Public License for more details.

 *

 *   You should have received a copy of the GNU General Public License

 *   along with ClicAlbum. If not, see <https://www.gnu.org/licenses/>.

 *

 ************************************************************************************/

//getVar();

include_once("_classes/MyException.php");

//include_once("_classes/Categorie.php");

include_once("_classes/Mur.php");

//include_once("_classes/Theme.php");

include_once("_classes/Brique.php");

//include_once("_classes/Mailer.php");

// L'utilisateur est il connecté en SUPER_USER

if ($_SESSION['SUPER_USER'] == "ok") {

  affichePageSuperUser();

} else {

  // Y a-t-il eu une tentative de connexion ?

  if (isset($_POST["mdp_su"])) {

    // Le mot de passe saisi est-il le bon ?

    if($_POST['mdp_su']==SUPER_ADMIN) {

      $_SESSION['SUPER_USER'] = "ok";

      affichePageSuperUser();

    } else {

      afficheLoginType("<span class='alert alert-danger'>Le mot de passe saisi est incorrect.</span>");

    }

  } else {

    // Afficher le formulaire d'identification

    afficheLoginType("");

  }

}

function affichePageSuperUser() {

  // Récupération des données nécessaires à l'affichage de la page

  // - nombre total de murs

  // - nombre de mur publics

  // - nombre de muir n'ayant pas été actifs depuis plus de 12 mois

  // - l'ensemble des murs

  // - l'ensemble des briques

  $nbMurs = getNbMurs()[0];

  $nbPublics = getNbMursPublics()[0];

  $nbInactifs = getNbMursInactifs(date('Y-m-d', strtotime('-12 month')))[0];

  $murs = getAllMurs();

  $briques = getAllBriques();

  // Est ce qu'il y a une requete à exécuter ?

  if($_POST['sql'] !='') {

    $requete = execSql(str_secure($_POST['sql']));

    if ($requete !==false) {

      $res= $requete;

    } else {

      $res = "<p class='alert alert-danger mt-3'>ERREUR dans la requete SQL</p>";

    }

    //debug($requete);

  }

  afficheSuperUser($nbMurs,$nbPublics,$nbInactifs,$murs,$res);

}

?>

<?php

/************************************************************************************

 *

 *  Projet AbulEdu Mur de Classe  - Licence: GNU/Affero GPL v3 ou +

 *

 *  (c) 2020 Frédéric Adamczak <fred@fadamczak.fr>

 *

 *   This file is part of AbulEdu Mur de Classe.

 *

 *   AbulEdu Mur de Classe is free software: you can redistribute it and/or modify

 *   it under the terms of the GNU Affero General Public License as published by

 *   the Free Software Foundation, either version 3 of the License, or

 *   (at your option) any later version.

 *

 *   AbulEdu Mur de Classe is distributed in the hope that it will be useful,

 *   but WITHOUT ANY WARRANTY; without even the implied warranty of

 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 *   GNU Affero General Public License for more details.

 *

 *   You should have received a copy of the GNU General Public License

 *   along with ClicAlbum. If not, see <https://www.gnu.org/licenses/>.

 *

 ************************************************************************************/

/**

 * Retourne le nombre total de mur présents dans la BDD

 * @return [Array] [Nombre de murs (tableau inidce)]

 */

function getNbMurs() {

  global $db;

  $sql="SELECT COUNT(id_mur) FROM mur";

  try {

    if (!$query=$db->query($sql)) {

      throw new  MyException("Erreur dans le SELECT");

    } else {

      $query->setFetchMode(PDO::FETCH_NUM);

      return ($query->fetch());

    }

  } catch (MyException $e) {

    $e->errorMessage();

  }

}

/**

 * Retourne le nombre de murs publics

 * @return [Arrazy] [tableau indicé ]

 */

function getNbMursPublics() {

  global $db;

  $sql="SELECT COUNT(id_mur) FROM mur WHERE mdp_acces =''";

  try {

    if (!$query=$db->query($sql)) {

      throw new  MyException("Erreur dans le SELECT");

    } else {

      $query->setFetchMode(PDO::FETCH_NUM);

      return ($query->fetch());

    }

  } catch (MyException $e) {

    $e->errorMessage();

  }

}

/**

 * Retourne les murs dont la dernière activité remonte à plus de 6 mois

 * @param  [type] $sixMois [description]

 * @return [type]          [description]

 */

function getNbMursInactifs($periode) {

  global $db;

  $sql = "SELECT COUNT(id_mur) FROM mur WHERE date_acces < '$periode'";

  try {

    if (!$query=$db->query($sql)) {

      throw new  MyException("Erreur dans le SELECT");

    } else {

      $query->setFetchMode(PDO::FETCH_NUM);

      return ($query->fetch());

    }

  } catch (MyException $e) {

    $e->errorMessage();

  }

}

/**

 * Retourne l'ensemble des murs

 * @return [Array] [Classe Mur]

 */

function getAllMurs() {

  global $db;

  $sql = "SELECT * FROM mur ORDER BY id_mur";

  try {

    if (!$query=$db->query($sql)) {

      throw new  MyException("Erreur dans le SELECT");

    } else {

      return ($query->fetchAll(PDO::FETCH_CLASS,"Mur"));

    }

  } catch (MyException $e) {

    $e->errorMessage();

  }

}

/**

 * Retourne l'ensemble des briques

 * @return [Array] [Assoc]

 */

function getAllBriques() {

  global $db;

  $sql = "SELECT * FROM brique ORDER BY id_mur";

  try {

    if (!$query=$db->query($sql)) {

      throw new  MyException("Erreur dans le SELECT");

    } else {

      return ($query->fetchAll(PDO::FETCH_ASSOC));

    }

  } catch (MyException $e) {

    $e->errorMessage();

  }

}

/**

 * Exécute une requete SQL passée en paramètres

 * @param  [String] $sql [Requete à exécuter]

 * @return [Array/Boolean]      [Faux si la requete n'a pu s'exécuter / Array de resultats]

 */

function execSql($sql) {

  global $db;

  if ($query = $db->query($sql)) {

    return $query->fetchAll(PDO::FETCH_ASSOC);

  } else {

    return(false);

  }

}

?>

<?php

/************************************************************************************

 *

 *  Projet AbulEdu Mur de Classe  - Licence: GNU/Affero GPL v3 ou +

 *

 *  (c) 2020 Frédéric Adamczak <fred@fadamczak.fr>

 *

 *   This file is part of AbulEdu Mur de Classe.

 *

 *   AbulEdu Mur de Classe is free software: you can redistribute it and/or modify

 *   it under the terms of the GNU Affero General Public License as published by

 *   the Free Software Foundation, either version 3 of the License, or

 *   (at your option) any later version.

 *

 *   AbulEdu Mur de Classe is distributed in the hope that it will be useful,

 *   but WITHOUT ANY WARRANTY; without even the implied warranty of

 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 *   GNU Affero General Public License for more details.

 *

 *   You should have received a copy of the GNU General Public License

 *   along with ClicAlbum. If not, see <https://www.gnu.org/licenses/>.

 *

 ************************************************************************************/

function afficheSuperUser($nbMurs,$nbPublics,$nbInactifs,$murs,$requete) {

  ?>

  <!doctype html>

  <html>

  <head>

      <?php include_once 'views/includes/head.php'?>

      <title><?= ucfirst($page) ?></title>

  </head>

  <body>

    <?php include_once 'views/includes/header.php'?>

    <div class="container">

      <div class="row mt-4">

        <div class="col-sm-3 ml-2 alert alert-primary">

          <?=$nbMurs?> mur(s) enregistré(s)

        </div>

        <div class="col-sm-3 ml-2 alert alert-success">

          <p>

            <?=$nbPublics?> mur(s) public(s)

          </p>

          <p>

            <?=$nbMurs-$nbPublics?> mur(s) privé(s)

          </p>

        </div>

        <div class="col-sm-3 ml-2 alert alert-secondary">

          <p>

            <?=$nbInactifs?> mur(s) inactif(s)

          </p>

          <p id="trash">

            <i class="fas fa-trash-alt"></i> Effacer les murs inactifs

          </p>

        </div>

      </div>

      <hr />

      <div class="row mt-4 mb-4">

        <div class="col-sm-12">

          <form method="post">

            <div class="form-group">

              <label for="sql">Requete SQL</label>

              <input type="text" class="form-control" id="sql" name="sql">

            </div>

            <button type="submit" class="btn btn-primary">lancer la requete</button>

          </form>

        </div>

        <div class="col-sm-12">

        <?php

          if (strpos($requete,"ERREUR dans la requete SQL")>0) {

            print $requete;

          } else {

            print "<div class='alert alert-success mt-3 mb-2'>";

            print "Résultats de la requete";

            print "</div>";

            print "<table class='table table-striped'>";

            print "<thead>";

            print "<tr>";

            foreach ($requete[0] as $key => $value) {

              print "<th scope='col'>$key</th>";

            }

            print "</tr>";

            print "</thead>";

            print "<tbody>";

            foreach ($requete as $sql) {

              print "<tr>";

              $i=0;

              foreach ($sql as $key => $value) {

                if ($i==0) {

                    print "<th scope='row'>$value</th>";

                } else {

                  print "<td>$value</td>";

                }

                ++$i;

              }

              print "</tr>";

            }

            print "</tbody>";

            print "</table>";

          }

          ?>

        </div>

      </div>

      <hr />

      <div class="row mt-4" id="lesMurs">

        <div class="col-sm-12">

          <b>LISTE DES MURS</b>

        </div>

        <table class="table table-striped">

          <thead>

            <tr>

              <th scope="col">#</th>

              <th scope="col">nom</th>

              <th scope="col">slug</th>

              <th scope="col">descriptif</th>

              <th scope="col">date création</th>

              <th scope="col">dernier accès</th>

            </tr>

          </thead>

          <tbody>

            <?php

            foreach($murs as $mur) {

              print "<tr>";

              print "<th scope='row'>".$mur->getid()."</th>";

              print "<td>".$mur->getNom()."</td>";

              print "<td>".$mur->getSlug()."</td>";

              print "<td>".$mur->getDescriptif()."</td>";

              print "<td>".$mur->getDateCreation()."</td>";

              print "<td>".$mur->getDateAcces()."</td>";

              print "</tr>";

            }

            ?>

          </tbody>

        </table>

      </div>

  </body>

  <script language='javascript'>

    $('#trash').hover(function(){

      $('#trash').css('cursor','pointer');

    });

    $('#trash').on('click',function(){

      if (confirm("Es-tu certaint de vouloir supprimer ces murs ?") == true) {

        console.log("on supprime les murs");

        location.href = "_scripts/berlin1989.php";

      }

    });

  </script>

  </html>

<?php

}

function afficheLoginType($msg) {

?>

<!doctype html>

<html>

<head>

    <?php include_once 'views/includes/head.php'?>

    <title><?= ucfirst($page) ?></title>

</head>

<body>

  <?php include_once 'views/includes/header.php'?>

  <div class="container">

    <form method="post">

      <?=$msg?>

      <div class="form-group">

        <label for="mdp_su">Password</label>

        <input type="password" class="form-control" id="mdp_su" name="mdp_su">

      </div>

       <button type="submit" class="btn btn-primary">OK</button>

    </form>

  </div>

</body>

</html>

<?php } ?>