<?php
require_once 'lib/core.php';

if(isset($_POST["from"]) && isset($_POST["to"])){

 $from=explode(",", $_POST['from']);
 $to=explode(",",$_POST['to']);
 $distance=test_input($_POST['distance']);
 $discount=test_input($_POST['discount']);
 $status=test_input($_POST['status']);
 // $route_reverse=test_input($_POST['route_reverse']);

 $sql="insert into route(city1,city2,distance,discount,status) values('$from[0]','$to[0]','$distance','$discount','$status')";            
 if($conn->query($sql))
 {
    $id=$conn->insert_id;
    $success="no";
    foreach($_POST['cab_type'] as $cab_type)
    {
        $amount=$cab_type['amount'];
        $cab_id=$cab_type['id'];
        $extra_amount=$cab_type['extra_amount'];
        $route_type=$cab_type['route_type'];
        $date_from=$cab_type['date_from'];
        $date_to=$cab_type['date_to'];
        $price=$cab_type['price'];
        $reverse=$cab_type['reverse'];
        $reverse_amount=$cab_type['reverse_amount'];
        $round=$cab_type['round'];
        $round_amount=$cab_type['round_amount'];
        $sql="insert into cab_route(cab_type,amount,route_id,extra_amount,route_type,date_from,date_to,price,reverse,reverse_amount,round,round_amount) values('$cab_id','$amount','$id','$extra_amount','$route_type'," . ($date_from==NULL ? "NULL" : "'$date_from'") . "," . ($date_to==NULL ? "NULL" : "'$date_to'") . ",'$price','$reverse','$reverse_amount','$round','$round_amount')";
        if($cab_id!="" && $amount!=""){
            if($conn->query($sql))
            {
             $cab_route_id=$conn->insert_id;
             if (isset($_POST['cab_type'])) {
                for ($i=0; $i < count($cab_type['date']); $i++) {
                    $date=$cab_type['date'][$i];
                    $amt = $cab_type['amt'][$i];
                    $sql = "INSERT INTO route_date_price (cab_route_id, date, amt, route_id) 
                    VALUES ('$cab_id', '$date', '$amt', '$id')";
                    $conn->query($sql);
                }
            }
            $success="ok";
        }

        else
        {
            $sql="delete from route_date_price where route_id=$id";
            $conn->query($sql);
            $sql="delete from cab_route where route_id=$id";
            $conn->query($sql);
            $sql="delete from route where id=$id";
            $conn->query($sql);
            $success="no";
        }
    }else{
        $success="ok";
    }
}
if($success=="ok")
    echo "success";
else
    echo "error";
}
else
{
  echo "error";
}
}
//DELETING CAB DATA

if(isset($_POST['delete_id']))
{
 $id_d=$_POST["delete_id"];

 $sql=$conn->query("delete from route where id='$id_d'");
 $sql=$conn->query("delete from cab_route where route_id='$id_d'");
 $sql=$conn->query("delete from route_date_price where route_id='$id_d'");
 if($sql)
 {
     echo "success";			
 }
 else
 {
     echo "error";
 }

}


//UPDATING Packages DATA

if(isset($_POST["route_id"]))
{   

    $route_id=$_POST["route_id"];
    $from=explode(",", $_POST['edit_from']);
    $to=explode(",",$_POST['edit_to']);
    $distance=test_input($_POST['distance']);
    $discount=test_input($_POST['discount']);
    $status=test_input($_POST['status']);
    $reverse_route=test_input($_POST['reverse_route']);

    $route_reverse = $_POST['route_reverse'];

    if (empty($route_reverse)) {
        $sql="update route set distance='$distance',city1='$from[0]',city2='$to[0]',discount='$discount',status='$status',reverse_route='$reverse_route' where id='$route_id'";
    }else{
        $sql=$conn->query("update route set reverse_route='2' where id='$route_id'");

        $sql="insert into route(city1,city2,distance,discount,status,reverse_route) values('$to[0]','$from[0]','$distance','$discount','$status','$route_reverse')";  
    }

    if($conn->query($sql))
    {
        $success="no";
      // $sql="delete from route_date_price where route_id='$route_id'";
      // $conn->query($sql);
        if (empty($route_reverse)) {
          $sql="delete from cab_route where route_id='$route_id'";
          $conn->query($sql);
      }else{
        $route_id=$conn->insert_id;
    }
    foreach($_POST['cab_type'] as $ecab_type)
    {
        $amount=$ecab_type['amount'];
        $cab_id=$ecab_type['id'];
        $extra_amount=$ecab_type['extra_amount'];
        $route_type=$ecab_type['route_type'];
        $date_from=$ecab_type['date_from'];
        $date_to=$ecab_type['date_to'];
        $price=$ecab_type['price'];
        $reverse=$ecab_type['reverse'];
        $reverse_amount=$ecab_type['reverse_amount'];
        $round=$ecab_type['round'];
        $round_amount=$ecab_type['round_amount'];
        $sql="insert into cab_route(cab_type,amount,route_id,extra_amount,reverse,reverse_amount,route_type,date_from,date_to,price,round,round_amount) values('$cab_id','$amount','$route_id','$extra_amount','$reverse','$reverse_amount','$route_type'," . ($date_from==NULL ? "NULL" : "'$date_from'") . "," . ($date_to==NULL ? "NULL" : "'$date_to'") . ",'$price','$round','$round_amount')";
        if($cab_id!="" && $amount!=""){
            if($conn->query($sql))
            {

             if (isset($_POST['cab_type'])) {

                for ($i=0; $i < count($ecab_type['date']); $i++) {
                    $date=$ecab_type['date'][$i];
                    $amt = $ecab_type['amt'][$i];
                    $route_date_id = $ecab_type['route_date_id'][$i];

                    if (empty($route_reverse)) {
                        $query = $conn->query("SELECT * FROM route_date_price WHERE id='$route_date_id'");
                        if ($query->num_rows==0) {

                            $sql = $conn->query("INSERT INTO route_date_price (cab_route_id, date, amt, route_id) VALUES ('$cab_id', '$date', '$amt', '$route_id')");
                        }else{
                            $sql=$conn->query("UPDATE route_date_price SET amt='$amt' WHERE id='$route_date_id'");
                        }

                    }else{
                        $sql = $conn->query("INSERT INTO route_date_price (cab_route_id, date, amt, route_id) 
                        VALUES ('$cab_id', '$date', '$amt', '$route_id')");
                    }
                }
            }


            $success="ok";
        }
        else
        {
            if (empty($route_reverse)) {
                $sql="delete from route_date_price where route_id='$route_id'";
                $conn->query($sql);
                $sql="delete from cab_route where route_id='$route_id'";
                $conn->query($sql);
                $sql="delete from route where id='$route_id'";
                $conn->query($sql);
                $success="no";
            }
        }
    }else{
        $success="ok";
    }
}
if($success=="ok")
    echo "success";
else
    echo "error1";
}
else
{
  echo "error2";
}
}


//DELETING CAB DATA

if(isset($_POST['delete_route_price']))
{
 $id=$_POST["delete_route_price"];
 $sql=$conn->query("delete from route_date_price where id='$id'");
 if($sql)
 {
     echo "success";          
 }
 else
 {
     echo "error";
 }

}

?>