/home/desid573/public_html/angel
Edit: /home/desid573/public_html/angel/get_booking_status.php (2219B)
query($sql);
$driver = "";
if ($result->num_rows > 0)
{
while($row_details = $result->fetch_assoc())
{
$booking_detail[] = $row_details;
}
$sql = "SELECT * FROM `customers` where email = '".$booking_detail[0]["email"]."'";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
while($row_detail = $result->fetch_assoc())
{
$booking_details[] = $row_detail;
}
}
if($booking_detail[0]['spatula_link'] == "" OR $booking_detail[0]['spatula_link'] == "[") {
$sql = "SELECT * FROM `holding_link` where id = 1";
$hold = $conn->query($sql);
if($hold->num_rows > 0) {
$hold_link = $hold->fetch_assoc();
$spat_link = $hold_link["link"];
}
} else {
$spat_link = $booking_detail[0]['spatula_link'];
}
if($booking_detail[0]['driver'] != "") {
$sql = "SELECT * FROM `desid573_eway_codes`.`drivers` where `driver` = '".$booking_detail[0]['driver']."'";
$hold = $conn->query($sql);
if($hold->num_rows > 0) {
$driver_details = $hold->fetch_assoc();
$driver = $driver_details["driver"];
$driver_phone = $driver_details["driver_phone"];
}
}
$Res["data"] = $booking_detail;
$Res["user-data"] = $booking_details;
$Res["booking_status"] = $booking_detail[0]['status'];
$Res["date"] = $booking_detail[0]['booking_date'];
$Res["time"] = $booking_detail[0]['booking_time'];
$Res["pickup"] = $booking_detail[0]['pickup_addr'];
$Res["dropoff"] = $booking_detail[0]['pickoff_addr'];
$Res["quote"] = $booking_detail[0]['quote'];
$Res["xero"] = $booking_detail[0]['xero_inv'];
$Res["spat_link"] = $spat_link;
$Res["driver"] = $driver;
$Res["driver_phone"] = $driver_phone;
$Res["message"] = "booking info for user";
$Res["status"] = "OK";
}
else
{
$Res["message"] = "no such result present in booking";
$Res["status"] = "ok";
}
echo json_encode(new ArrayObject($Res));
