<?php
require_once 'header.php';
require_once 'navbar.php';


$sql="select * from booking_types";
$result=$conn->query($sql);
if($result->num_rows>0)
{
  while($row=$result->fetch_assoc())
  {
    $companies[]=$row;
    $companies1[]=$row;
  }
}
?>

<!-- Page content -->
<div class="container-fluid pt-8">
  <div class="page-header mt-0 p-3">
    <h3 class="mb-sm-0 text-uppercase">Hold Payment </h3>
    <button id="addd" title="" class="btn btn-primary pull-right" data-toggle="modal" data-target="#add-category-modal">
      <i class="fa fa-plus"></i>
    </button>

  </div>
  <div id="alert2" class="col-md-12"></div>
  <!-- Table -->
  <div class="row">
    <div class="col-12">
      <div class="card shadow">

        <div class="">
          <div class="grid-margin">
            <div class="">
              <div class="table-responsive p-3">
                <table class="table text-center card-table table-vcenter text-nowrap  align-items-center" id="example">
                  <thead>
                    <tr>
                      <th>S.No</th>
                      <th>Company</th>
                      <th>Booking ID</th>
                      <th>Amount</th>
                      <th>Note</th>
                      <th>Created Date/Time</th>
                      <th>Action</th>
                    </tr>
                  </thead>
                  <tbody id="tbody">
                  </tbody>
                </table>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>


<!--Add Modal-->
<div class="modal fade" id="add-category-modal">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="card-header">
        <h4 style="text-align: left;">Add Hold Payment <span id="alert"></span></h4>
      </div>
      <div class="modal-body">
        <form id="add" enctype="multipart/form-data">
          <div class="row">
           <div class="col-md-12">
            <label>Company Type</label>
            <select class="select2 form-control w-100" name="company_id" required>
              <?php foreach($companies as $company){ ?>
               <option value="<?=$company['id'];?>"><?=$company['title'];?></option>
             <?php } ?>
           </select>
         </div>
         <div class="col-md-12 mt-3">
          <label>Booking ID</label>
          <input type="text" class="form-control" name="booking_id" required>
        </div>
        <div class="col-md-12 mt-3">
          <label>Amount</label>
          <input type="number" class="form-control" name="amount" required>
        </div>
        <div class="col-md-12 mt-3">
          <label>Note</label>
          <textarea class="form-control" rows="3" name="note" required></textarea>
        </div>
      </div>
      <br/>
      <div class="modal-footer">
        <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
        <button type="submit" class="btn btn-primary">Add</button>
      </div>
    </form>
  </div>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
<!--Edit Modal-->
<div class="modal fade" id="edit-category">
  <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>
        <h4 style="text-align: left">Edit Hold Payment <span id="alert1"></span></h4>
      </div>
      <div class="modal-body">
        <form id="edit_cartype" method="POST" enctype="multipart/form-data">
          <div class="row">
            <input type="hidden" name="save_id" id="save_id">
           <div class="col-md-12">
            <label>Company Type</label>
            <select class="select2 form-control w-100" name="edit_company_id" id="company_id" required>
              <?php foreach($companies as $company){ ?>
               <option value="<?=$company['id'];?>"><?=$company['title'];?></option>
             <?php } ?>
           </select>
         </div>
         <div class="col-md-12 mt-3">
          <label>Booking ID</label>
          <input type="text" class="form-control" name="booking_id" id="booking_id" required>
        </div>
        <div class="col-md-12 mt-3">
          <label>Amount</label>
          <input type="number" class="form-control" name="amount" id="amount" required>
        </div>
        <div class="col-md-12 mt-3">
          <label>Note</label>
          <textarea class="form-control" rows="3" name="note" id="note" required></textarea>
        </div>
      </div>
      <br/>
      <div class="modal-footer">
        <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
        <button type="submit" class="btn btn-primary">Save Changes</button>
      </div>
    </form>
  </div>
</div>

<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
</div>
<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>

<script>
  $(document).ready(function () {
    output();

    //  add modal

    $('#add').submit(function (e) {
      e.preventDefault();
      $("#global-loader").show();
      $.ajax({
        url: "ajax_hold_payment.php",
        type: "POST",
        data:  new FormData(this),
        contentType: false,
        cache: false,
        processData:false,
        success: function (response) {
          $("#global-loader").fadeOut();
          if (response != "Something Wrong") {
            $('#alert').html('<span class="p-1 m-1 alert alert-success">Successfully Added.</span>').show();
            
            setTimeout(function () {
              location.reload()
            }, 2000)

          } else {
            $('#alert').html('<span class="p-1 m-1 alert alert-danger">Something Wrong, can\'t add.</span>').show()
            setTimeout(function () {
              $('#alert').hide()
            }, 1000)
          }
          
        }
      })
    })

    // To save changes in edit modal    
    $('#edit_cartype').submit(function (e) {
      e.preventDefault();
      $("#global-loader").show();
      $.ajax({
        url: "ajax_hold_payment.php",
        type: "POST",
        data:  new FormData(this),
        contentType: false,
        cache: false,
        processData:false,
        success: function (response) {
          $("#global-loader").fadeOut();
          if (response == "Success") {
            $('#alert1').html('<span class="p-1 m-1 alert alert-success">Successfully Updated</span>').show();
            
            setTimeout(function () {
              location.reload()
            }, 2000)
          } else {
            $('#alert1').html('<span class="p-1 m-1 alert alert-danger">Something Wrong, can\'t update.</span>').show()
            setTimeout(function () {
              $('#alert1').hide()
            }, 1000)
          }
        }
      })
    })
  })

  // To show all the categories in main menu

  function output() {
    var inHTML = '';
    var i = 1;
    $.getJSON("ajax_hold_payment?show=1", function (data) {
      $.each(data, function (key, item) {

        inHTML +=
        `<tr>
        <td>${i}</td>
        <td>${item.title}</td> 
        <td>${item.booking_id}</td> 
        <td>${item.amount} </td> 
        <td>${item.note}</td> 
        <td>${item.created_at}</td> 
        <td>
           <a href="#edit-category" class="btn btn-success" data-toggle="modal" onclick="edit(${item.id})"><i class="fa fa-edit btn-success"></i></a>
           <button type="button" id="del" name="del" class="btn btn-danger" onclick="del(${item.id})" value="${item.id}" ><i class="fa fa-trash"></i></button></td>
        </tr>`;
        i++;
      })
      $('#tbody').html(inHTML);
      $('#example').DataTable({
        layout: {
          topStart: {
            buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
          }
        },
        "stateSave": true,
        dom: 'lBfrtip',
        "lengthMenu": [[10, 25, 50, 100, 250, 500, 1000, -1], [10, 25, 50, 100, 250, 500, 1000, 'All']]
      });
    })
  }

  // Deletion of categories

  function del(e) {
    var verify = confirm("Do you really want to delete!!!");
    if (verify) {
     $("#global-loader").show();
     $.ajax({
      url: "ajax_hold_payment.php",
      type: "POST",
      data: {
        delete_id: e,
      },
      success: function (response) {
        $("#global-loader").fadeOut();
        if (response == "Success") {
          $("#global-loader").fadeOut();
          $('#alert2').html('<span class="p-1 m-1 alert alert-success">Successfully Deleted</span>').show()
          setTimeout(function () {
            $('#alert2').hide()
            location.reload();
          }, 1000)
        } else {
          $('#alert2').html('<span class="p-1 m-1 alert alert-danger">Something Wrong, can\'t delete.</span>').show()
          setTimeout(function () {
            $('#alert2').hide()
          }, 1000)
        }
      },
    })
   }
 }

  //On click of edit button to show values of database in edit modal

 function edit(e) {
   $("#global-loader").show();
   $.ajax({
    url: "ajax_hold_payment.php",
    type: "POST",
    dataType: "JSON",
    data: {
      hold_payment_id: e,
    },
    success: function (response) { 
      $("#company_id").val(response.company_id).select2();
      $('#booking_id').val(response.booking_id);
      $('#amount').val(response.amount);
      $('#note').val(response.note);
      $('#save_id').val(response.id);

    },
  })
 }
</script>