<?php
//fetch.php
$connect = mysqli_connect('localhost', 'root', '', 'ticketing');
$output = '';
if(isset($_POST["query"]))
{
 $search = mysqli_real_escape_string($connect, $_POST["query"]);
 $query = "
  SELECT * FROM users
  WHERE name LIKE '%".$search."%'
  OR username LIKE '%".$search."%'
  OR level LIKE '%".$search."%'
  OR id LIKE '%".$search."%'
  OR email LIKE '%".$search."%'
 ";
}
else
{
 $query = "
  SELECT * FROM users ORDER BY id
 ";
}
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
 $output .= '
  <div class="table-responsive">
   <table class="table table bordered">
    <tr>
     <th>Name</th>
     <th>Username</th>
     <th>Email</th>
     <th>Level</th>
     <th>Action</th>
    </tr>
 ';
 while($row = mysqli_fetch_array($result))
 {
  $output .= '
   <tr>
    <td>'.$row["name"].'</td>
    <td>'.$row["username"].'</td>
    <td>'.$row["email"].'</td>
    <td>'.$row["level"].'</td>
    <td><a style="cursor:pointer;" class="btn btn-info edit" data-id="'.$row['id'].'"><span class="glyphicon glyphicon-edit" aria-hidden="true" ></span></a> || <a style="cursor:pointer;" class="btn btn-danger delete" data-id="'.$row['id'].'"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></a>
            </td>
   </tr>
  ';
 }
 echo $output;
}
else
{
 echo 'Data Not Found';
}

?>

$(document).ready(function(){

 load_data();

 function load_data(query)
 {
  $.ajax({
   url:"fetch.php",
   method:"POST",
   data:{query:query},
   success:function(data)
   {
    $('#result').html(data);
   }
  });
 }
 $('#search_text').keyup(function(){
  var search = $(this).val();
  if(search != '')
  {
   load_data(search);
  }
  else
  {
   load_data();
  }
 });

$('#add').click(function(){
    $('#addnew').modal('show');
    $('#addForm')[0].reset();
  });

  $('#addbutton').click(function(){
    var name = $('#name').val();
    if(name!=''){
      var addForm = $('#addForm').serialize();
      $.ajax({
        type: 'POST',
        url: 'adduser.php',
        data: addForm,
        success:function(){
          $('#addnew').modal('hide');
          $('#addForm')[0].reset();
          load_data();
          $('#alert').slideDown();
          $('#alerttext').text('Member Added Successfully');
        }
      });
    }
    else{
      alert('Please input Fields')
    }

  });

  //edit
  $(document).on('click', '.edit', function(){
    var id = $(this).data('id');
    var name = $('#name'+id).text();
    var email = $('#email'+id).text();
    var username = $('#username'+id).text();
    var password = $('#password'+id).text();
    $('#editmem').modal('show');
    $('#ename').val(name);
    $('#eemail').val(email);
    $('#eusername').val(username);
    $('#epassword').val(password);
    $('#editbutton').val(id);
  });

  $('#editbutton').click(function(){
    var id = $(this).val();
    var editForm = $('#editForm').serialize();
    $.ajax({
      type: 'POST',
      url: 'edituser.php',
      data: editForm + "&id="+id,
      success:function(){
        $('#editmem').modal('hide');
        $('#editForm')[0].reset();
        load_data();
        $('#alert').slideDown();
        $('#alerttext').text('Member Updated Successfully');
      }
    });
  });

//delete
  $(document).on('click', '.delete', function(){
    var id = $(this).data('id');
    var name = $('#name'+id).text();
    $('#delmem').modal('show');
    $('#dname').text(name);
    $('#delbutton').val(id);
  });

  $('#delbutton').click(function(){
    var id = $(this).val();
    $.ajax({
      type: 'POST',
      url: 'deleteuser.php',
      data: {
        id: id,
      },
      success:function(){
        $('#delmem').modal('hide');
        load_data();
        $('#alert').slideDown();
        $('#alerttext').text('Member Deleted Successfully');
      }
    });
  });

});