<?php
require_once 'header.php';
require_once 'navbar.php';
$id = $_GET['id'];

if (isset($_POST['name'])) {
  $name = $_POST['name']; 
  $ac = $_POST['ac']; 
  $luggage = $_POST['luggage']; 
  $price = $_POST['price']; 
  $oneway_extra = $_POST['oneway_extra']; 
  $roundprice = $_POST['roundprice']; 
  $round_extra = $_POST['round_extra']; 
  $perday = $_POST['perday']; 
  $daylimit = $_POST['daylimit']; 
  $passenger = $_POST['passenger']; 
  $after_extra_km = $_POST['after_extra_km']; 
  $features = $_POST['features']; 
  $similar_cars = $_POST['similar_cars']; 
  $cartype = $_POST['cartype'];
  $oneway_inclusion = $_POST['oneway_inclusion']; 
  $oneway_exclusion = $_POST['oneway_exclusion']; 
  $roundway_inclusion = $_POST['roundway_inclusion']; 
  $roundway_exclusion = $_POST['roundway_exclusion']; 
  $local_inclusion = $_POST['local_inclusion']; 
  $local_exclusion = $_POST['local_exclusion'];
  $indexing = $_POST['indexing'];

  $image = $_FILES['car_img']['name'];
  $path = 'upload/'.time().$image;

  if ($image!='') { 
    move_uploaded_file($_FILES['car_img']['tmp_name'], $path);
    $update = $conn->query("UPDATE cab_types SET img = '$path' WHERE id = $id");
  }

  $sql = "UPDATE cab_types SET 
  type = '$name',
  ac = '$ac',
  luggage = '$luggage',
  price='$price',
  extra_price='$oneway_extra',
  round_price='$roundprice',
  extra_round_price='$round_extra',
  perday='$perday',
  daylimit='$daylimit',
  number_passenger='$passenger',
  extra_afterkms='$after_extra_km',
  features='$features',
  similar_cars='$similar_cars',
  car_way='$cartype',
  oneway_inclusion='$oneway_inclusion',
  oneway_exclusion='$oneway_exclusion',
  roundway_inclusion='$roundway_inclusion',
  roundway_exclusion='$roundway_exclusion',
  local_inclusion='$local_inclusion',
  local_exclusion='$local_exclusion',
  indexing='$indexing'
  WHERE id = '$id'";

  if ($conn->query($sql)) {
    move_uploaded_file($_FILES['car_img']['tmp_name'], $path);
    echo '<script>alert("Updated Successfully");location.href="cabs_category";</script>';
  }
  else {
   echo '<script>alert("Something went wrong!..");</script>';
 }
}


$result = $conn->query("SELECT * FROM cab_types WHERE id='$id'");
$cab = $result->fetch_assoc();
?>

<!-- Page content -->
<div class="container-fluid pt-8">
  <div class="page-header mt-0 p-3">
    <h3 class="mb-sm-0">EDIT CAB CATEGORY </h3>
  </div>
  <div id="alert2" class="col-md-12"></div>
  <!-- Table -->
  <div class="row">
    <div class="col-12">
      <div class="card shadow p-4">
        <div class="">
          <div class="grid-margin">
            <form method="POST" enctype="multipart/form-data">
              <div class="row">
                <div class="col-md-4">
                  <label>Type</label>
                  <input type="text" class="form-control" name="name" value="<?=$cab['type']?>" id="name" required>
                </div>
                <div class="col-md-4">
                  <label>Car Image</label>
                  <input type="file" class="form-control" name="car_img" id="car_img">
                </div>
                <div class="col-md-2">
                  <label>Ac/Non-Ac</label>
                  <select type="text" class="form-control" name="ac" id="ac" required>
                    <option value="Ac" <?php if($cab['ac']=='Ac'){echo 'selected';} ?>>AC</option>
                    <option value="Non-Ac" <?php if($cab['ac']=='Non-Ac'){echo 'selected';} ?>>Non-AC</option>
                  </select>
                </div>
                <div class="col-md-2">
                  <label>Indexing</label>
                  <input type="number" class="form-control" name="indexing" value="<?=$cab['indexing']?>">
                </div>
                <div class="col-md-4">
                  <label>Luggage</label>
                  <input type="text" class="form-control" name="luggage" value="<?=$cab['luggage']?>" id="luggage">
                </div>

                <div class="col-md-4">
                  <label>Price/kms Oneway</label>
                  <input type="number" class="form-control" name="price" value="<?=$cab['price']?>" required>
                </div>
                <div class="col-md-4">
                  <label>Oneway Extra Price/kms</label>
                  <input type="number" class="form-control" name="oneway_extra" value="<?=$cab['extra_price']?>">
                </div>

                <div class="col-md-4">
                  <label>Price/kms Roundway</label>
                  <input type="number" class="form-control" name="roundprice" value="<?=$cab['round_price']?>" required>
                </div>
                <div class="col-md-4">
                  <label>Roundway Extra Price/kms</label>
                  <input type="number" class="form-control" name="round_extra" value="<?=$cab['extra_round_price']?>">
                </div>
                <div class="col-md-4">
                  <label>Price/Day</label>
                  <input type="text" class="form-control" name="perday" value="<?=$cab['perday']?>" >
                </div>
                <div class="col-md-4">
                  <label>Per Day Limit</label>
                  <input type="text" class="form-control" name="daylimit" value="<?=$cab['daylimit']?>">
                </div>
                <div class="col-md-4">
                  <label>No. of Passenger</label>
                  <input type="text" class="form-control" name="passenger" value="<?=$cab['number_passenger']?>">
                </div>
                <div class="col-md-4">
                  <label>After Extra/Km</label>
                  <input type="number" class="form-control" name="after_extra_km" value="<?=$cab['extra_afterkms']?>">
                </div>
                <div class="col-md-4">
                  <label>Features</label>
                  <input type="text" class="form-control" name="features" value="<?=$cab['features']?>">
                </div>
                <div class="col-md-4">
                  <label>Similar Cars</label>
                  <input type="text" class="form-control" name="similar_cars" value="<?=$cab['similar_cars']?>">
                </div>
                <div class="col-md-4">
                  <label>Car Type</label>
                  <select class="form-control" name="cartype" id="cartype">
                    <option value="B" <?php if($cab['car_way']=='B'){echo 'selected';} ?>>Both</option>
                    <option value="O" <?php if($cab['car_way']=='O'){echo 'selected';} ?>>Oneway</option>
                    <option value="R" <?php if($cab['car_way']=='R'){echo 'selected';} ?>>Roundway</option>
                  </select>
                </div>
                <div class="col-md-6">
                  <label>Oneway Inclusion</label>
                  <textarea class="editor" name="oneway_inclusion"><?=$cab['oneway_inclusion']?></textarea>
                </div>
                <div class="col-md-6">
                  <label>Oneway Exclusion</label>
                  <textarea class="editor" name="oneway_exclusion"><?=$cab['oneway_exclusion']?></textarea>
                </div>
                <div class="col-md-6">
                  <label>Roundway Inclusion</label>
                  <textarea class="editor" name="roundway_inclusion"><?=$cab['roundway_inclusion']?></textarea>
                </div>
                <div class="col-md-6">
                  <label>Roundway Exclusion</label>
                  <textarea class="editor" name="roundway_exclusion"><?=$cab['roundway_exclusion']?></textarea>
                </div>
                <div class="col-md-6">
                  <label>Local Inclusion</label>
                  <textarea class="editor" name="local_inclusion"><?=$cab['local_inclusion']?></textarea>
                </div>
                <div class="col-md-6">
                  <label>Local Exclusion</label>
                  <textarea class="editor" name="local_exclusion"><?=$cab['local_exclusion']?></textarea>
                </div>
                <br/>
                <div class="modal-footer">
                  <button type="submit" name="save-category-btn" class="btn btn-primary">Save Changes</button>
                </div>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
</div>

<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script>
  const editors = document.querySelectorAll('.editor');

// Replace each element with CKEditor
  editors.forEach(editor => {
    CKEDITOR.replace(editor);
  });

</script>