<?php
require_once 'lib/core.php';
//ADDING CAB DATA
if(isset($_POST["from"]) && isset($_POST["type"]))
{
 $city1=test_input($_POST['from']);
 // $city2=test_input($_POST['to']);
 $type=test_input($_POST['type']);
 $features=test_input($_POST['features']);
 $distance=test_input($_POST['distance']);

 $from_city=explode(",", $city1);
 // if (!empty($city1)) {
 //    $to_city=explode(",", $city2);
 //    $to_city = $to_city[0];
 // }else{
 //    $to_city='';
 // }
 $sql="insert into packages(city1,package_type_id,package_features,distance) values('$from_city[0]','$type','$features','$distance')";            
 if($conn->query($sql))
 {

    $id=$conn->insert_id;
    $success="no";

    
    foreach($_POST['cab_type'] as $cab_type)
    {
        $amount=$cab_type['amount'];
        $extra_amount=$cab_type['extra_amount'];
        $inclusion=$cab_type['inclusions'];
        $exclusion=$cab_type['exclusions'];
        $cab_id=$cab_type['id'];
        $sql="insert into cab_package(cab_type,amount,extra_amount,package_id,inclusions,exclusions) values('$cab_id','$amount','$extra_amount','$id','$inclusion','$exclusion')";
        if($conn->query($sql))
        {
            $success="ok";
        }
        else
        {
            $sql="delete from cab_package where package_id=$id";
            $conn->query($sql);
            $sql="delete from packages where id=$id";
            $conn->query($sql);
            $success="no";
        }
    }
    if($success=="ok"){
        echo '<script language="javascript">';
        echo 'alert("Successfully Added"); location.href="packages.php"';
        echo '</script>';
    }else{
     echo '<script language="javascript">';
     echo 'alert("Something went wrong"); location.href="add_package.php"';
     echo '</script>';
 }
}
else
{
  echo '<script language="javascript">';
  echo 'alert("Something went wrong"); location.href="add_package.php"';
  echo '</script>';
}
}
//DELETING CAB DATA
if(isset($_POST['delete_id']))
{
 $id_d=$_POST["delete_id"];

			/*$sql="delete from cab_packages where package-id=$id_d";
			if($conn->query($sql))
			{*/

             $sql="delete from packages where id=$id_d";
             if($conn->query($sql))
             {
             $sql=$conn->query("delete from cab_package where package_id=$id_d");
              echo "success";			
          }
          else
          {
             echo "error";
         }

     }
//UPDATING Packages DATA
     if(isset($_POST["edit"]))
     {
        $package_id=$_POST["edit"];
        $city1=test_input($_POST['cityone']);
        $type=test_input($_POST['etype']);
        $city2=test_input($_POST['citytwo']);
        $features=test_input($_POST['efeatures']);
        $distance=test_input($_POST['distance2']);
        $from_city=explode(",", $city1);

        $sql="update packages set distance='$distance',city1='$from_city[0]',package_type_id='$type',package_features='$features' where id='$package_id'";
        if($conn->query($sql))
        {
          $success="no";
          $sql="delete from cab_package where package_id='$package_id'";
          $conn->query($sql);
          foreach($_POST['ecab_type'] as $ecab_type)
          {
            $amount=$ecab_type['amount'];
            $extra_amount=$ecab_type['extra_amount'];
            $inclusion=$ecab_type['inclusions'];
            $exclusion=$ecab_type['exclusions'];
            $cab_id=$ecab_type['id'];
            $sql="insert into cab_package(cab_type,amount,extra_amount,package_id,inclusions,exclusions) values('$cab_id','$amount','$extra_amount','$package_id','$inclusion','$exclusion')";

            if($conn->query($sql))
            {
                $success="ok";
            }
            else
            {
                $sql="delete from cab_package where package_id='$package_id'";
                $conn->query($sql);
                $sql="delete from packages where id='$package_id'";
                $conn->query($sql);
                $success="no";
            }
        }
        if($success=="ok"){
            echo '<script language="javascript">';
            echo 'alert("Updated Successfully"); location.href="packages.php"';
            echo '</script>';
        }
        else{
            echo '<script language="javascript">';
            echo 'alert("Something went wrong"); location.href="edit_package.php?id='.$package_id.'"';
            echo '</script>';
        }
    }
    else
    {
       echo '<script language="javascript">';
       echo 'alert("Something went wrong"); location.href="edit_package.php?id='.$package_id.'"';
       echo '</script>';
   }
}


//FETCHING Packages DETAILS
if(isset($_POST['package_details']))
{
    $sql="select p.distance,p.id,p.package_type_id,p.city1,p.city2,p.package_features,t.type,t.id as type_id from packages p,package_types t where p.package_type_id=t.id";
    if($result=$conn->query($sql))
    {
        if($result->num_rows>0)
        {

          while($row=$result->fetch_assoc())
          {
           $packages[]=$row;
       }
       echo json_encode($packages);
   }
   else
    echo "unable to fetch data";
}    
}
//FETCHING Packages DATA FOR EDIT MODAL
if(isset($_POST['show_edit_data']))
{
    $id=$_POST['show_edit_data'];
    $sql="select * from packages where id=$id";
    if($result=$conn->query($sql))
    {
        if($result->num_rows>0)
        {

          while($row=$result->fetch_assoc())
          {
           $edit_packages[]=$row;
       }
       echo json_encode($edit_packages);
   }
   else
    echo "unable to fetch data";
}    
}
//FETCHING Packages CAB AMOUNT DATA FOR EDIT MODAL
if(isset($_POST['get_cab_amount']))
{
    $id=$_POST['get_cab_amount'];
    $sql="select * from cab_package where package_id=$id";
    if($result=$conn->query($sql))
    {
        if($result->num_rows>0)
        {

          while($row=$result->fetch_assoc())
          {
           $cab_amount[]=$row;
       }
       echo json_encode($cab_amount);
   }
   else
    echo "unable to fetch data";
}    
}
?>