<?php
    require_once 'header.php';
  	require_once 'navbar.php';
 
     
     $sql="SELECT * from user_group";
     $res=$conn->query($sql);
     if($res->num_rows > 0)
     {
        while($row=$res->fetch_assoc())
        {
            $users[]=$row;
        }
     }
?>

<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0">User Group</h3>
        <button id="addd" title="" class="btn btn-primary pull-right" data-toggle="modal" data-target="#modal-default">
                <i class="fa fa-plus"></i>
        </button>
        
    </div>
    <div id="alert2" class="col-md-12"></div>
    	<!-- Table -->
    <div class="row">
        <div class="col-12">
        <?php
			if(isset($success))
			{
				?>
			  <div class="alert alert-success" id="success">Success! Your Request has been submited.</div>
			<?php
			}
			else if(isset($error))
			{
				?>
			  <div class="alert alert-danger" id="success">Error! Your Request could not be submited.<?php echo $sql1; ?></div>
			<?php
			}
			?>
           <div class="alert alert-success" id="success" style="display:none">Success! Your Request has been submited.</div>
            
              
            <div class="card shadow">
                   <div class="card-body">
                            <div class="table-responsive">
                                <table id="example" class="table card-table table-vcenter text-nowrap text-center align-items-center">
                                    <thead>
                                        <tr>
                                            <th>S.NO.</th>
                                            <th>Name</th>
                                            <th>Slug</th>
                                            <th>Action</th>
                                          </tr>
                                    </thead>
                                    <?php
                                    $x=1;
                                    foreach($users as $user)
                                    {
                                        ?>
                                        <tr>
                                            <td><?=$x;?></td>
                                            <td><?=$user['name'];?></td>
                                            <td><?=$user['slug'];?></td>
                                            <td>
                                                <a class="btn btn-primary" href="edit_usergroup.php?id=<?=$user['group_id'];?>" ><i class="fa fa-edit btn-success"></i></a>
                                                <a class="btn btn-danger text-white" href="ajax_usergroup.php?delete_id=<?=$user['group_id'];?>" ><i class="fa fa-trash"></i></a>
                                            </td>
                                        </tr>
                                        <?php
                                        $x++;
                                    }
                                    ?>
                                      <tbody >
                                    </tbody>
                                </table>
                            </div>
                        </div>
                  </div>
                
        </div>
    </div>
</div>

<!--Add Modal To Display-->
<div class="modal fade" id="modal-default">
    <div class="modal-dialog">
        <div class="modal-content">
          <div class="card-header">
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">&times;</span>
            </button>
               <div class="alert alert-danger"id="error" style="display:none">Error! Your Request could not be submited.</div>
               
              <h4 style="text-align: left">Create New User Group</h4><div class="col-md-6 float-right" id="alert"></div>
          </div> 
          <form method="post" action="ajax_usergroup.php">
          <div class="modal-body">
              <div class="row">
                 <div class="col-md-6">
                      <label>Name :</label><input type="text" class="form-control" name="name" value="">
                  </div>
              </div>
            </div>
          <div class="modal-footer">
            <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
            <button type="submit" name="add_usergroup" id="add" class="btn btn-primary" >Add</button>
          </div>
            </form>
        </div>
    <!-- /.modal-content -->
    </div>
<!-- /.modal-dialog -->
</div>



<?php
  require_once 'footer.php';
  require_once 'jslinks.php';
?>

    <!-- Adon JS -->
    <script src="assets/js/custom.js"></script>
    <script src="assets/js/datatable.js"></script>