<?php
require_once 'header.php';
require_once 'navbar.php';
$id=$_GET['id'];
$sql="select * from package_types";
$result=$conn->query($sql);
if($result->num_rows>0)
{
  while($row=$result->fetch_assoc())
  {
     $package_types[]=$row;
     $package_types1[]=$row;
 }
}
$sql="select * from operate_cities";
$result=$conn->query($sql);
if($result->num_rows>0)
{
    while($row=$result->fetch_assoc())
    {
        $operate_city[]=$row;
        $operate_city1[]=$row;
    }
}
$sql="select id,type from cab_types";
$result=$conn->query($sql);
if($result->num_rows>0)
{
  while($row=$result->fetch_assoc())
  {
     $cab_types[]=$row;
 }
}
$sql="SELECT *,packages.id as id FROM packages INNER JOIN package_types ON package_types.id=packages.package_type_id WHERE packages.id='$id'";
    // $sql="select * from cab_package where package_id=$id";
if($result=$conn->query($sql))
{
  $row=$result->fetch_assoc();
             // print_r($row);
}    
?>
<script src="https://cdn.ckeditor.com/4.13.1/standard/ckeditor.js"></script>
<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0">EDIT PACKAGES</h3>
        
    </div>
    <div id="alerte"></div>
    <div class="row">
        <div class="col-12">
            <div class="card shadow">
                <div class="card-header bg-transparent border-0">
                    <h2 class=" mb-0">Edit Package Details</h2>
                </div>
                <div class="">
                    <div class="grid-margin">
                        <div class="">
                            <div class="table-responsive">
                              <form method="post" action="packages_ajax.php">
                                  <div class="modal-body">
                                      <div class="row">
                                        <div class="col-md-6">
                                         <label> Type :</label>
                                         <select class="form-control" id="etype" name="etype" required>
                                            <?php
                                            if(isset($package_types1))
                                            {
                                             $x=1;
                                             foreach($package_types1 as $data1)
                                             {
                                                 ?>
                                                 <option value="<?=$data1['id'];?>" <?php if ($row['package_type_id']==$data1['id']) {
                                                    echo 'selected';
                                                } ?>><?=$data1['type'];?></option>
                                                <?php
                                            }
                                        }
                                        ?>
                                    </select>
                                </div>
                                <div class="col-md-6">
                                  <label> From :</label>
                                  <select class="form-control select2" name="cityone" required>
                                    <option value="">Select City</option>
                                    <?php
                                    if(isset($operate_city))
                                    {
                                     $x=1;
                                     foreach($operate_city as $data)
                                     {
                                         ?>
                                         <option value="<?=$data['city'];?>" 
                                            <?php if ($row['city1']==$data['city']) { echo 'selected'; } ?>>
                                            <?=$data['city'];?></option>
                                            <?php
                                        }
                                    }
                                    ?>
                                </select>

                                <!-- <input type="text" value="<?php echo $row['city1']; ?>" class="form-control" id="cityone" name="cityone" required> -->
                            </div>
                            <!-- <?php if ($row['city2']=='NA') {  ?>
                                <style>
                                    #cityto{
                                        display: none;
                                    }
                                </style>
                                <?php } ?> -->

                            <!-- <div class="col-md-4" id="cityto">
                              <label> To :</label>
                              <select class="form-control" id="citytwo" name="citytwo" >
                                <option value="NA">Select City</option>
                                <?php
                                if(isset($operate_city))
                                {
                                   $x=1;
                                   foreach($operate_city as $data)
                                   {
                                       ?>
                                       <option value="<?=$data['city'];?>"
                                        <?php if ($row['city2']==$data['city']) { echo 'selected'; } ?>>
                                        <?=$data['city'];?></option>
                                        <?php
                                    }
                                }
                                ?>
                            </select>

                            <input type="text" id="citytwo" value="<?php echo $row['city2']; ?>" class="form-control" name="citytwo" required>
                        </div> -->
                        <?php
                        if(isset($cab_types))
                        {
                            $i=1;
                            foreach($cab_types as $cab_type)
                            {
                                $sql="SELECT *,packages.id as id FROM cab_package INNER JOIN packages ON packages.id=cab_package.package_id WHERE packages.id='$id' AND cab_package.cab_type='".$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="ecab_type[<?=$i?>][amount]" id="ecab_type<?=$cab_type['id'];?>" value="<?php echo $rows['amount'] ?>" required >
                                  <input type="hidden" class="form-control" name="ecab_type[<?=$i?>][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="ecab_type[<?=$i?>][extra_amount]" value="<?php echo $rows['extra_amount'] ?>" required>
                              </div>
                              <div class="col-md-6">
                                  <label> Inclusion (<?=$cab_type['type']?>):</label>
                                  <textarea  class="form-control icab_type<?=$cab_type['id'];?>" name="ecab_type[<?=$i?>][inclusions]" id="editor<?=$i?>"><?php echo $rows['inclusions'] ?></textarea>
                              </div><div class="col-md-6">
                                  <label> Exclusion (<?=$cab_type['type']?>):</label>
                                  <textarea  class="form-control xcab_type<?=$cab_type['id'];?>" name="ecab_type[<?=$i?>][exclusions]" id="editors<?=$i?>"><?php echo $rows['exclusions'] ?>
                              </textarea>
                          </div>
                          <script>
                             CKEDITOR.replace( 'editor<?=$i?>');
                             CKEDITOR.replace( 'editors<?=$i?>');
                         </script>
                         <?php
                         $i++;
                     }
                 }
                 ?>
                 <div class="col-md-6">
                  <label>Distance :</label>
                  <input type="number" id="distance2"  class="form-control" name="distance2" value="<?php echo $row['distance'] ?>">
              </div>
              <div class="col-md-6">
                  <label>Features :</label>
                  <input type="text" class="form-control" name="efeatures" id="efeatures" value="<?php echo $row['package_features'] ?>">
              </div>
              <div class="col-md-6 mt-2">
                <button type="submit" name="edit_packages" id="edit_packages"  class="btn btn-primary" >Save changes</button>
            </div>
            <input type=hidden name=edit id="edit" value="<?php echo $row['id'] ?>">
        </div>
    </div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
require_once 'footer.php';
require_once 'jslinks.php';
?>
<script>
   $(document).ready(function(){
    $('#type').on('change', function() {
        var types = $(this).find(':selected').text();
        // alert(types);
        var type = types.split(" ");
        if (type[0]=='Local' || type[0]=='local') {
            $('#city_to').hide();
        }else{
            $('#city_to').show();
        }
    });
    $('#etype').on('change', function() {
        var etypes = $(this).find(':selected').text();
        var etype = etypes.split(" ");
        if (etype[0]=='Local' || etype[0]=='local') {
            $('#cityto').hide();
        }else{
            $('#cityto').show();
        }
    });
})

</script>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=<?=$google_key?>&libraries=places"></script>
<script>
  function initialize() {
    var options = {
      types:'cities',
      componentRestrictions: {country: 'ind'}
  };
  var input = document.getElementById('cityone');
  var autocomplete = new google.maps.places.Autocomplete(input, options);
  var input = document.getElementById('citytwo');
  var autocomplete2 = new google.maps.places.Autocomplete(input, options);
}
google.maps.event.addDomListener(window, 'load', initialize);
</script>