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

$query = "SELECT * FROM round_km_limit LIMIT 1";
$result = $conn->query($query);
$km_limit = $result->fetch_assoc();

if (isset($_POST['km_limit'])) {
  $km_limit = $_POST['km_limit'];
  $sql = "UPDATE round_km_limit SET km_limit = '$km_limit'";

  if ($conn->query($sql)) {
    echo '<script>alert("Save Changes Successfully");location.href="round_km_limit";</script>';
  } else {
    echo '<script>alert("Something Wrong");</script>';
  }

}
?>

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

            </div>
            <!-- Table -->
            <div class="row">
              <div class="col-12">
                <div class="card shadow">
                <!-- <div class="card-header bg-transparent border-0">
                    <h2 class=" mb-0">Cities List</h2>
                  </div> -->
                  <div class="p-4">
                    <div class="grid-margin">
                      <div class="">
                        <div class="table-responsive">
                          <table id="example" class="text-center table card-table table-vcenter text-nowrap  align-items-center">
                            <thead>
                              <tr>
                                <th style="width: 80px">S.No</th>
                                <th>Km Limit</th>
                                <th style="width: 150px"> &nbsp;&nbsp;&nbsp;&nbsp;Action</th>
                              </tr>
                            </thead>
                            <tbody>
                              <?php 
                              $show = "SELECT * FROM round_km_limit";
                              $result = $conn->query($show);
                                while ($row = $result->fetch_assoc()) { ?>
                                  <tr>
                                    <td>1</td>
                                    <td><?=$row['km_limit'];?></td>
                                    <td><button type="button" id="edit-btn" name="edit" class="btn btn-success" data-toggle="modal" data-target="#edit-keys"><i class="fa fa-edit btn-success"></i></button>
                                    </td>
                                  </tr>
                                <?php } ?>
                              </tbody>
                            </table>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>

            <!--Edit Modal-->
            <div class="modal fade" id="edit-keys">
              <div class="modal-dialog">
                <div class="modal-content">
                  <div class="card-header">
                    <h4 style="text-align: left;">Edit Km Limit <span id="alert1"></span></h4>
                  </div>
                  <form method="post">
                    <div class="modal-body">
                      <div class="row">
                        <div class="col-md-12">
                          <label>Km Limit</label>
                          <input type="number" class="form-control" name="km_limit" id="km_limit" value="<?=$km_limit['km_limit'];?>" required="required"
                          autofocus>
                        </div>
                      </div>
                      <br/>
                      <div class="modal-footer">
                        <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
                        <button type="submit" name="save_key_btn" id="save_key_btn" class="btn btn-primary">save Changes</button>
                      </div>
                    </div>
                  </form>
                </div>
              </div>
              <!-- /.modal-content -->
            </div>
            <?php
            require_once 'footer.php';
            require_once 'jslinks.php';
            ?>
            <script src="assets/js/custom.js"></script>
            <script src="assets/js/datatable.js"></script>