<?php require 'inc/includes.php'; 

    
$nbr = $DB->query("SELECT count(*) as nbr FROM users");
$perpage = 4;
$nbr_pages = ceil($nbr[0]->nbr/$perpage );

if(isset($_GET['page'])){
	$page = intval($_GET['page']);
	if($page > $nbr_pages){
		$page = $nbr_pages;
	}
}else{
	$page =1;
}

$premierPage = ($page-1) *$perpage;

$users= $DB->query("SELECT id,username,email,avatar FROM users ORDER BY created_at ASC LIMIT ".$premierPage.",".$perpage."");

  require 'inc/header.php'; ?>
<section>

<aside id="sidebar2">
      		<!-- widget --> 
       		<section class="widget">
             <ul>
               	<li class="catsidebar active"><a href="role.php">Roles</a></li>
                <li class="catsidebar"><a href="users.php">Utilisateurs</a></li>
               	<li class="catsidebar"><a href="echantillons.php">Nature d'echantillon</a></li>
				<li class="catsidebar"><a href="typestocks">Type de stockage</a></li>

               </ul>
           </section>
           <!-- Fin widget -->
       
           <!-- Fin widget --> 
       
       
       </aside>
       
       

</section>


<!-- fiche -->

        <article style="width: 85%;margin: auto;0px; position: relative;">
		
 <div class="container-fluid">
                    
<div class="card card-primary card-outline">
    
    <!-- /.card-header -->
<div class="card-body">
    <div id="reports_table_wrapper" class="dataTables_wrapper dt-bootstrap4 no-footer">
		<div class="row">
		
		<!-- Le bouton de gauche sans titre -->
	    <div class="col-sm-4">
			<div class="dt-buttons btn-group flex-wrap">
				<a href="createuser.php"> 
					<button class="btn btn-primary btn-sm float-right" tabindex="0" aria-controls="reports_table" type="button" title="">Nouveau </button>
				</a>	
			</div>
       </div>
	  
		<!-- Fin du bouton de gauche sans titre -->
	  
	   <!-- Les boutons du centre avec le titre -->
<div class="col-sm-4">
			<div class="dt-buttons btn-group flex-wrap">
				<a href="createuser.php"> 
				
				<div class="dt-buttons btn-group flex-wrap">
				<a href="createuser.php"> 
					<button class="btn btn-primary btn-sm float-right" tabindex="0" aria-controls="reports_table" type="button" title="">Importer </button>
				</a>	
			</div>
			
			
					<button class="btn btn-primary btn-sm float-right" tabindex="0" aria-controls="reports_table" type="button" title="">Exporter </button>
				</a>	
			</div>
	
	<!-- FIN Les boutons du centre avec le titre -->
 </div>
 
<div class="col-sm-4">
	<div id="reports_table_filter" class="dataTables_filter"><label><input type="search" class="form-control form-control-sm" placeholder="Rechercher" aria-controls="reports_table"></label>
	
	</div></div>
	
	
</div>

<div class="row">
	<div class="col-sm-12">
	
	<!-- 	DEBUT TITRES TABLEAU -->		
 
		<table id="reports_table" class="table table-striped table-hover table-bordered dataTable no-footer" role="grid" aria-describedby="reports_table_info"> 
			<thead>
								<th class="sorting_disabled" rowspan="1" colspan="1" style="width: 242px;">Actions</th>
								<th class="sorting_disabled" rowspan="1" colspan="1" style="width: 300px;">Role</th>
			</thead>
			
			
		<!-- 	FIN TITRES TABLEAU -->		
		
		<!-- 	DEBUT COLONNE 1 -->		

		<tbody>
              <tr role="row" class="odd">
				  
				  
				   <td><a href="editrole.php" class="btn btn-primary btn-sm"> 
					 <i class="fa fa-edit"></i> 
						</a>
						
					<form method="GET" action="admin/users/9" class="d-inline">
								<button type="submit" class="btn btn-danger btn-sm delete_user">
								<input type="hidden" name="_method" value="delete">
								<i class="fa fa-trash"></i>
								</button>  
						
						</form>
					</td>
					<td><span class="badge badge-primary mr-1">Administrateur</span></td>

			 
				</tr>
		</tbody>
		
		<!-- 	FIN COLONNE 1 -->
		
		
         </table>
		  
		  

</div>
 
 <!-- 		  Zone page  -->		 

 
 </div>
 
   </div>

  
  
  <!-- jQuery -->
<script src="https://extremelab.tech/plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="https://extremelab.tech/plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Bootstrap 4 -->
<script src="https://extremelab.tech/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="https://extremelab.tech/plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="https://extremelab.tech/plugins/sparklines/sparkline.js"></script>
<!-- jQuery Knob Chart -->
<script src="https://extremelab.tech/plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="https://extremelab.tech/plugins/moment/moment.min.js"></script>
<script src="https://extremelab.tech/plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="https://extremelab.tech/plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="https://extremelab.tech/plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="https://extremelab.tech/plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="https://extremelab.tech/dist/js/adminlte.js"></script>
<!-- DataTables -->
<script src="https://extremelab.tech/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-fixedheader/js/dataTables.fixedHeader.min.js" type="text/javascript"></script>
<script src="https://extremelab.tech/plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="https://extremelab.tech/plugins/jszip/jszip.min.js"></script>
<script src="https://extremelab.tech/plugins/pdfmake/pdfmake.min.js"></script>
<script src="https://extremelab.tech/plugins/pdfmake/vfs_fonts.js"></script>
<script src="https://extremelab.tech/plugins/datatables-buttons/js/buttons.php5.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-buttons/js/buttons.print.min.js"></script>
<script src="https://extremelab.tech/plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
<!-- Toastr-->
<script src="https://extremelab.tech/js/toastr.min.js"></script>
<!-- Validate -->
<script src="https://extremelab.tech/plugins/jquery-validation/jquery.validate.min.js"></script>
<script src="https://extremelab.tech/plugins/print/jQuery.print.min.js"></script>
<script src="https://extremelab.tech/js/jquery.classyqr.min.js"></script>
<script src="https://extremelab.tech/js/select2.js"></script>
<script src="https://extremelab.tech/plugins/sweet-alert/sweetalert.min.js"></script>
<!-- Scripts Translation -->

<!-- Main dashboard -->
  <script src="https://extremelab.tech/js/admin/main.js"></script>
<!-- Flash messages -->
<script>
    </script>

    <!-- Switch -->
  <script src="https://extremelab.tech/plugins/swtich-netliva/js/netliva_switch.js"></script>
  <script src="https://extremelab.tech/js/admin/dashboard.js"></script>
  
  <script src="//code.tidio.co/wm6kjlncgktzimpuaad5qetmtv9h1cui.js" async></script>

</body>
</html>
		 
