groupes.php

<?php 
include('dbconfig.php');
include('security.php');
secAdmin();
include('includes/header.php');
include('includes/navbar.php');
?>
  
<div class="modal fade" id="addadminprofile" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Ajouter un groupe</h5>
        <button type="button" class="close" data-bs-dismiss="modal" aria-label="Fermer">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <form action="code.php" method="POST">
        <div class="modal-body">
          <div class="form-group">
            <label>Nom du groupe</label>
            <input type="text" name="nom" class="form-control" placeholder="Entrer Nom du groupe">
          </div>
          <div class="form-group">
            <label for="niveau">Niveau</label>
            <select name="niveau" class="form-control">
              <option value="" selected disabled>Sélectionner un niveau</option>
              <?php 
              $query_niveau = "SELECT * FROM `niveau`";
              $query_run_niveau = mysqli_query($connection, $query_niveau);
              if ($query_run_niveau) {
                  while ($row = mysqli_fetch_assoc($query_run_niveau)) { 
              ?>
              <option value="<?php echo $row['NiveauID']; ?>"><?php echo $row['Niveau_name']; ?></option>
              <?php
                  }
              }
              ?>
            </select>
          </div>
          <div class="form-group">
            <label>Date de création</label>
            <input type="date" name="date_creation" class="form-control" placeholder="Entrer Date">
          </div>
          <div class="form-group">
            <label for="professeur">Professeur</label>
            <select name="professeur" class="form-control">
              <option value="" selected disabled>Choisir un professeur</option>
              <?php 
              $query_prof = "SELECT * FROM `professeurs`";
              $query_run_prof = mysqli_query($connection, $query_prof);
              if ($query_run_prof) {
                  while ($row = mysqli_fetch_assoc($query_run_prof)) { 
              ?>
              <option value="<?php echo $row['ProfesseurID']; ?>"><?php echo $row['Professeur_name'] . ' ' . $row['Professeur_prenom']; ?></option>
              <?php
                  }
              }
              ?>
            </select>
          </div>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Fermer</button>
          <button type="submit" name="groupebtn" class="btn btn-primary">Enregistrer</button>
        </div>
      </form>
    </div>
  </div>
</div>

<div class="container-fluid">
  <div class="card shadow mb-4">
    <div class="card-header py-3">
      <h6 class="m-0 font-weight-bold text-primary">Groupes
        <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addadminprofile">Ajouter</button>
      </h6>
    </div>
    <div class="card-body">
      <?php
      if(isset($_SESSION['success']) && $_SESSION['success'] != '') {
        echo '<h6 class="alert alert-success" role="alert"> '.$_SESSION['success'].' </h6>
        <meta http-equiv="refresh" content="5; url = groupes.php" />';
        unset($_SESSION['success']);
      }

      if(isset($_SESSION['status']) && $_SESSION['status'] != '') {
        echo '<h6 class="alert alert-danger" role="alert"> '.$_SESSION['status'].' </h6>';
        unset($_SESSION['status']);
      }
      ?>
      <div class="table-responsive">
        <?php 
        $query = "SELECT * FROM groupes";
        $query_run = mysqli_query($connection, $query);
        ?>
        <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
          <thead>
            <tr>
              <th>ID</th>
              <th>Nom</th>
              <th>Niveau</th>
              <th>Date de création</th>
              <th>Professeur</th>
              <th>Éditer</th>
              <th>Supprimer</th>
            </tr>
          </thead>
          <tbody>
            <?php
            if(mysqli_num_rows($query_run) > 0) {
              while($row = mysqli_fetch_assoc($query_run)) {
            ?>
              <tr>
                <td><?php echo $row['GroupeID']; ?></td>
                <td><?php echo $row['Groupe_name']; ?></td> 
                <td>
                  <?php 
                  $niveau_query = "SELECT Niveau_name FROM niveau WHERE NiveauID = ".$row['Niveau'];
                  $niveau_result = mysqli_query($connection, $niveau_query);
                  if(mysqli_num_rows($niveau_result) > 0) {
                    $niveau_row = mysqli_fetch_assoc($niveau_result);
                    echo $niveau_row['Niveau_name'];
                  } else {
                    echo "Non attribué";
                  }
                  ?>
                </td>
                <td><?php echo $row['Date_creation']; ?></td>
                <td>
                  <?php 
                  $prof_query = "SELECT Professeur_name, Professeur_prenom FROM professeurs WHERE ProfesseurID = ".$row['ProfesseurID'];
                  $prof_result = mysqli_query($connection, $prof_query);
                  if(mysqli_num_rows($prof_result) > 0) {
                    $prof_row = mysqli_fetch_assoc($prof_result);
                    echo $prof_row['Professeur_name'] . ' ' . $prof_row['Professeur_prenom'];
                  } else {
                    echo "Non attribué";
                  }
                  ?>
                </td>
                <td>
                  <form action="groupe_edit.php" method="post">
                    <input type="hidden" name="edit_id" value="<?php echo $row['GroupeID']; ?>">
                    <button type="submit" name="editg_btn" class="btn btn-success">Éditer</button>
                  </form>
                </td>
                <td>
                  <button type="button" class="btn btn-danger" data-toggle="modal" data-target="#confirmDeleteGroupeModal<?php echo $row['GroupeID']; ?>">Supprimer</button>
                  <div class="modal fade" id="confirmDeleteGroupeModal<?php echo $row['GroupeID']; ?>" tabindex="-1" role="dialog" aria-labelledby="confirmDeleteGroupeModalLabel" aria-hidden="true">
                    <div class="modal-dialog" role="document">
                      <div class="modal-content">
                        <div class="modal-header">
                          <h5 class="modal-title" id="confirmDeleteGroupeModalLabel">Confirmation de suppression</h5>
                          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            <span aria-hidden="true">&times;</span>
                          </button>
                        </div>
                        <div class="modal-body">
                          Voulez-vous vraiment supprimer ce groupe?
                        </div>
                        <div class="modal-footer">
                          <button type="button" class="btn btn-secondary" data-dismiss="modal">Annuler</button>
                          <form action="code.php" method="post">
                            <input type="hidden" name="deleteg_id" value="<?php echo $row['GroupeID']; ?>">
                            <button type="submit" name="deleteg_btn" class="btn btn-danger">Supprimer</button>
                          </form>
                        </div>
                      </div>
                    </div>
                  </div>
                </td>
              </tr>
            <?php
              }
            } else {
              echo "Aucun enregistrement trouvé";
            }
            ?>
          </tbody>
        </table>
      </div>
    </div>
  </div>
</div>

<?php
include('includes/scripts.php');
include('includes/footer.php');
?>