/home/desid573/public_html/fc_api
Edit: /home/desid573/public_html/fc_api/get_booking_status.php (3246B)
query($sql);
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'];
}
$quote = $booking_detail[0]['quote'];
if($booking_detail[0]['xero_inv'] != "") {
$sql = "SELECT * FROM invoices WHERE reference = '".$booking_detail[0]['reference']."'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$quote = $row["amount"];
if($quote == null) {
$quote = 0;
}
}
$type = $booking_detail[0]['type'];
$currentCity = "perth";
if($type == "FA") {
} else if($type == "SA") {
$currentCity = "sydney";
} else if($type == "MA") {
$currentCity = "melbourne";
} else if($type == "BA" OR $type == "GA") {
$currentCity == "queensland";
}
$sql = "SELECT * FROM `booking_edit_request` WHERE `approved` = 0 AND `bid` = ".$_REQUEST["bid"];
$result = $conn->query($sql);
$Res["pending"] = false;
if($result->num_rows > 0) {
$Res["pending"] = true;
$data = $result->fetch_assoc();
$Res["pending_id"] = $data["id"];
}
$Res["bid"] = $_REQUEST['bid'];
$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["pick_lat"] = $booking_detail[0]['pickup_lat'];
$Res["pick_lon"] = $booking_detail[0]['pickup_long'];
$Res["dropoff"] = $booking_detail[0]['pickoff_addr'];
$Res["drop_lat"] = $booking_detail[0]['pickoff_lat'];
$Res["drop_lon"] = $booking_detail[0]['pickoff_long'];
$Res["quote"] = $quote;
$Res["luggage_details"] = $booking_detail[0]["luggage"];
$Res["currentCity"] = $currentCity;
$Res["flight_num"] = $booking_detail[0]['flight_num'];
$Res["mins_to"] = $booking_detail[0]['mins_to'];
$Res["xero"] = $booking_detail[0]['xero_inv'];
$Res["book_pax"] = $booking_detail[0]["book_pax"];
$Res["book_rf"] = $booking_detail[0]["book_rf"];
$Res["book_ff"] = $booking_detail[0]["book_ff"];
$Res["book_b"] = $booking_detail[0]["book_b"];
$Res["spat_link"] = $spat_link;
$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));
