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


//Show All cities
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show_data'])) {
        $show = "SELECT * FROM distance_fare";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $distance[] = $row;
            }
            echo json_encode($distance);
        }
    }
}


if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding

    if (isset($_POST['km_from'])) {
        $km_from = $_POST['km_from'];
        $km_to = $_POST['km_to'];
        $sql = $conn->query("INSERT INTO distance_fare(km_from,km_to) VALUES('$km_from','$km_to')");
        $distance_fare_id = $conn->insert_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("INSERT INTO distance_fare_cab(distance_fare_id,cab_typeid,price,extra_price) VALUES('$distance_fare_id','$cab_type_id','$price','$extra_price')");
        }

        if ($sql) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }
    }


    //Delete package cities

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

        $query = "DELETE FROM distance_fare WHERE id = " . $id;

        if ($conn->query($query)) {
            echo "Success";
        } else {
            echo "Something Wrong";
        }

    }
}

?>