<?php include 'lib/core.php';
//Show All cities
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show_cab'])) {
        $show = "SELECT * FROM airport";
        $result = $conn->query($show);
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $cities[] = $row;
            }
            echo json_encode($cities);
        }
    }
}
if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding package cities
    if (isset($_POST['cab_type'])) {
        $cab_type = $_POST['cab_type'];
        $price = $_POST['price'];
        $luggage = $_POST['luggage'];
        $ac = $_POST['ac'];
        $seat = $_POST['seat'];
        $inclusion = $_POST['inclusion'];
        $exclusion = $_POST['exclusion'];
        $image = $_FILES['cab_img']['name'];
        $location='airport_cabs/'.time().$image;
        $cab_img = 'airport_cabs/'.time().$image;
        if(!empty($image)) {
            $sql = "INSERT INTO airport(img,type,price,inclusion,exclusion) VALUES('$cab_img','$cab_type','$price','$inclusion','$exclusion')";
            if ($conn->query($sql)) {
                move_uploaded_file($_FILES['cab_img']['tmp_name'], $location);
                echo "Success";
            }
            else {
                echo "Something Wrong";
            }
        }    else {
            echo "Can't left empty";
        }
    }
    //Show Current City in Edit Modal
    if (isset($_POST['id'])) {
        $id = $_POST['id'];
        $query = "SELECT * FROM airport WHERE id = " . $id;
        $result = $conn->query($query);
        if ($result->num_rows > 0) {
            $response = $result->fetch_assoc();
            echo json_encode($response);
        }
    }
    //Updating package City in Modal
    if (isset($_POST['airport_id'])) {
        $id = $_POST['airport_id'];
        $edit_price = $_POST['edit_price'];
        $edit_cab_type = $_POST['edit_cab_type'];
        $edit_luggage = $_POST['edit_luggage'];
        $edit_ac = $_POST['edit_ac'];
        $edit_seat = $_POST['edit_seat'];
        $inclusions = $_POST['inclusions'];
        $exclusions = $_POST['exclusions'];
        $image = $_FILES['edit_cab_img']['name'];
        $location='airport_cabs/'.time().$image;
        $cab_img = 'airport_cabs/'.time().$image;
        if ($image!='') {
            $sql = "UPDATE airport SET type = '$edit_cab_type',price = '$edit_price',img = '$cab_img',inclusion='$inclusions',exclusion='$exclusions' WHERE id = $id";
            if ($conn->query($sql)) {
                move_uploaded_file($_FILES['edit_cab_img']['tmp_name'], $cab_img);
                echo "Success";
            } else {
                echo "Something Wrong";
            }
        }else{
            $sql = "UPDATE airport SET type = '$edit_cab_type',price = '$edit_price',inclusion='$inclusions',exclusion='$exclusions' WHERE id = $id";
            if ($conn->query($sql)) {
                echo "Success";
            } else {
                echo "Something Wrong";
            }
        }
    }
    //Delete package cities
    if (isset($_POST['delete_id'])) {
        $id = $_POST['delete_id'];
        $query = "DELETE FROM airport WHERE id = " . $id;
        if ($conn->query($query)) {
            echo "Success";
        } else {
            echo "Something Wrong";
        }
    }
}
?>