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


//Show All available_cabs
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $show = "SELECT available_vehicle.*,vendor_profile.full_name FROM available_vehicle INNER JOIN vendor_profile ON vendor_profile.vendor_id=available_vehicle.vendor_id";
        $result = $conn->query($show);

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


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

    if (isset($_POST['vendor_id'])) {
        $vendor_id = $_POST['vendor_id'];
        $cab_type = $_POST['cab_type'];
        $from = $_POST['from'];
        $to = $_POST['to'];
        $date = $_POST['date'];
        $time = $_POST['time'];
        $status = $_POST['status'];
        $remark = $_POST['remark'];
        $add = "INSERT INTO available_vehicle(`vendor_id`,`status`,`cab_type`,`from`,`to`,`date`,`time`,`remark`) VALUES('$vendor_id','pending','$cab_type','$from','$to','$date','$time','$remark')";

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

    }


    //Show Current Catagory in Edit Modal

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

        $query = "SELECT * FROM available_vehicle WHERE id = " . $id;

        $result = $conn->query($query);

        if ($result->num_rows > 0) {
            $current_category = $result->fetch_assoc();
            echo json_encode($current_category);
        }
    }

    //Updating Catagory in Modal
    if($_SERVER['REQUEST_METHOD'] == "POST") {
        if (isset($_POST['save_id'])) {
            $id = $_POST['save_id'];
            $vendor_id = $_POST['edit_vendor_id'];
            $cab_type = $_POST['cab_type'];
            $from = $_POST['from'];
            $to = $_POST['to'];
            $date = $_POST['date'];
            $time = $_POST['time'];
            $status = $_POST['status'];
            $remark = $_POST['remark'];
            $sql = "UPDATE `available_vehicle` SET `vendor_id`='$vendor_id',`cab_type`='$cab_type',`status`='$status',`from`='$from',`to`='$to',`date`='$date',`time`='$time',`remark`='$remark' WHERE id = $id";
            if ($conn->query($sql)) {
                echo "Success";
            } else {
                echo "Something Wrong";
            }

        }
    }

    //Delete categories

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

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

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

    }
}

?>