<?php
if(!empty($_SESSION['admin_connect_id']))
{


 ?>
<h4 class="title" ><i class="fa fa-arrow-right"></i> Liste des destinations  
<a href="index.php?p=add_destination"  class="btn btn-sm btn-success pull-right">Ajouter</a>
 </h4>
        <div class="row">
          <div class="col-lg-12">
                  <div class="form-panel">
                    <table id="dataTables" class="table table-striped table-bordered table-hover">
                      <thead>
                          <tr>
                            <th >Nom </th>
                            <th >Nom en arabe</th>
                            <th >Wilaya</th>
                            <th style="width:20%;"> Actions</th>
                          </tr>
                      </thead>

      <tbody>

       <?php

       $req_sql="SELECT *,destinations.id as iddestination,destinations.created_at as dstcreated_at,destinations.updated_at as dstupdated_at FROM destinations,wilayas,users where 
       destinations.dstwilaya=wilayas.C_WILAYA and destinations.added_by=users.id ";
      $query_unite=mysqli_query($con,$req_sql);

         while ($row = mysqli_fetch_array($query_unite) ) {  ?>
         <tr>
         
          <td > <?php echo $row['dstnom']; ?> </td>
          <td > <?php echo $row['dstnomar']; ?> </td>
          <td > <?php echo $row['L_WILAYA_F']; ?> </td>
          
      
          <td>
           <button type="button" class="btn btn-info btn-xs" data-toggle="modal"  data-target="#affiche<?php echo $row['iddestination'];?>">Afficher</button>
           <a href="index.php?p=edit_destination&id=<?php echo $row['iddestination'];?>" class="btn btn-success btn-xs"> Modifier</a>
    
 <button type="button" class="btn btn-danger btn-xs sup_en"  data="<?php echo $row['iddestination'];?>" >Supprimer</button>
 <div class="modal fade" id="affiche<?php echo $row['iddestination'];?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel">Destination  "<?php echo $row["dstnom"]; ?> "</h4>
      </div>
      <div class="modal-body">
      <table class="table table-striped table-bordered table-hover" >
             <tr><th>Nom </th> <td > <?php echo $row["dstnom"]; ?></td></tr>
             <tr><th>Nom en arabe </th> <td > <?php echo $row["dstnomar"]; ?></td></tr>
             <tr><th>Wilaya</th> <td > <?php echo $row["L_WILAYA_F"]; ?></td></tr>
        
             <tr><th>Ajouté par</th> <td > <?php echo $row["nom"]; ?></td></tr>
             <tr><th>Date d'ajout </th> <td > <?php $date=date_create($row['dstcreated_at']);  echo date_format($date,"d/m/Y H:i"); ?></td></tr>
     <tr><th> Date de modification </th> <td > <?php $date=date_create($row['dstupdated_at']);  echo date_format($date,"d/m/Y H:i"); ?></td></tr>


          


      </table>

      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Fermer</button>
      </div>
    </div>
  </div>
</div>
 </td>

          </tr>
          <?php  } ?>
     </tbody>
     </table>
                  </div>
          </div>
          </div>
<script type="text/javascript">
 $(document).ready(function() {
  $("#g_destination").addClass("active");
 document.title = 'Liste des destination ';
$(".sup_en").click(function ()
{   var id = $(this).attr('data');

swal({
  title: ' Voulez vous vraiment supprimer cet enregistrement ?',
  text: "Vous ne serez pas capable de revenir à cela!",
  type: 'warning',
  width: 600,
  showCancelButton: true,
  confirmButtonColor: '#3085d6',
  cancelButtonColor: '#d33',
  confirmButtonText: 'Oui, supprimez-le !',
  cancelButtonText:  'Non'
}).then((result) => {
  if (result.value) {
//if click oui
$.get("actions/fonctions.php?type=sup_destination&id="+id,function()
    {   
       setTimeout(function() {
              location.reload();
               }, 2000);
    });

    swal(

      'Supprimé !',
      'L\'enregistrement a été supprimé.',
      'success'
    ).then(function(){ 
   location.reload();
   })
  


  }
})

});

 $(".desact_user").click(function ()
{   var id = $(this).attr('id');
$.get("actions/fonctions.php?type=desact_user&id="+id,function()
    {    location.reload();
    });
});

$(".act_user").click(function ()
{   var id = $(this).attr('id');
$.get("actions/fonctions.php?type=act_user&id="+id,function()
    {    location.reload();
    });
});


} );
      </script>
<?php } ?>