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

$sql="select id,type from cab_types";
$result=$conn->query($sql);
if($result->num_rows>0)
{
  while($row=$result->fetch_assoc())
  {
   $cab_types[]=$row;
 }
}


$id = $_GET['id'];

$query = "SELECT * FROM distance_fare WHERE id = " . $id;
$result2 = $conn->query($query);
if ($result2->num_rows > 0) {
  $distance_fare = $result2->fetch_assoc();
}


// UPDATE
if (isset($_POST['km_from'])) {
  $km_from = $_POST['km_from'];
  $km_to = $_POST['km_to'];
  $sql = $conn->query("UPDATE distance_fare SET km_from='$km_from',km_to='$km_to' WHERE id=$id");

  for($i=0;$i<count($_POST['cab_type_id']);$i++){
    $cab_type_id=$_POST['cab_type_id'][$i];
    $price=$_POST['price'][$i];
    $extra_price=$_POST['extra_price'][$i];
    $sql = $conn->query("UPDATE distance_fare_cab SET price='$price',extra_price='$extra_price' WHERE cab_typeid=$cab_type_id AND distance_fare_id=$id");
  }

  if ($sql) {
    echo '<script>alert("Successfully Updated"); location.href="edit-distance-fare?id='.$id.'"</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">EDIT DISTANCE FARE</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">
              <div class="row">
                <div class="col-md-6">
                  <label>Distance KM From</label>
                  <input type="number" class="form-control" value="<?=$distance_fare['km_from'];?>" name="km_from" required>
                </div>
                <div class="col-md-6">
                  <label>Distance KM To</label>
                  <input type="number" class="form-control" value="<?=$distance_fare['km_to'];?>" name="km_to" required>
                </div>
                <?php
                if(isset($cab_types)){
                  $i=1;
                  foreach($cab_types as $cab_type){ 
                    $sql="SELECT distance_fare_cab.* FROM distance_fare_cab INNER JOIN distance_fare ON distance_fare.id=distance_fare_cab.distance_fare_id WHERE distance_fare.id='$id' AND distance_fare_cab.cab_typeid='".$cab_type['id']."'";
                    $result=$conn->query($sql);
                    $rows=$result->fetch_assoc();
                    ?>
                    <div class="col-md-6">
                      <label> Amount(<?=$cab_type['type']?>):</label>
                      <input type="text" class="form-control" name="price[]" value="<?php echo $rows['price'] ?>" required>
                      <input type="hidden" class="form-control" name="cab_type_id[]" value="<?=$cab_type['id'];?>" required>
                    </div>
                    <div class="col-md-6">
                      <label> Extra Amount(<?=$cab_type['type']?>):</label>
                      <input type="text" class="form-control" name="extra_price[]" value="<?php echo $rows['extra_price'] ?>" required>
                    </div>
                    <?php $i++;} } ?>
                  </div>
                  <br/>
                  <button type="submit" class="btn btn-primary">save Changes</button>
                </form>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>

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