FM / fc

/home/desid573/public_html/fc_api

Name	Size	Mode	Actions
lib/	-	0755	rm
twilio-php-master/	-	0755	rm
vendor/	-	0755	rm
after_booking_page.php	2595	0644	edit dl rm
appoff.php	4782	0644	edit dl rm
booking.php	17680	0644	edit dl rm
booking_edit_request.php	10196	0644	edit dl rm
cancel_booking.php	6064	0644	edit dl rm
check_open.php	0	0644	edit dl rm
composer.json	65	0644	edit dl rm
composer.lock	2355	0644	edit dl rm
confirmsend.php	2983	0644	edit dl rm
confirm_booking_change.php	6305	0644	edit dl rm
confirm_booking_change_ajax.php	6696	0644	edit dl rm
contact_us_mail.php	890	0644	edit dl rm
copy_account_to_homekey.php	4338	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
emailConfirmReset.php	486	0644	edit dl rm
error_log	30761021	0644	edit dl rm
family-cab_small.jpg	98853	0644	edit dl rm
generate_credit.php	3098	0644	edit dl rm
generate_referall.php	2779	0644	edit dl rm
getuser_byid.php	2341	0644	edit dl rm
getuser_bymail.php	3419	0644	edit dl rm
get_all_booking.php	779	0644	edit dl rm
get_booking_bybooking_id.php	813	0644	edit dl rm
get_booking_byuser.php	1057	0644	edit dl rm
get_booking_status.php	3246	0644	edit dl rm
get_completed_bookings.php	710	0644	edit dl rm
get_ETA.php	5013	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1537	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
get_price.php	41	0644	edit dl rm
get_recipes.php	6361	0644	edit dl rm
get_request_details.php	976	0644	edit dl rm
get_TE.php	1217	0644	edit dl rm
index.php	13722	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	8679	0644	edit dl rm
noteconfirm.php	9228	0644	edit dl rm
off.php	2854	0644	edit dl rm
passwordResetLink.php	5170	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2147	0644	edit dl rm
reset_email.php	1755	0644	edit dl rm
reset_phone.php	5717	0644	edit dl rm
test2.php	0	0644	edit dl rm
test_222.php	845	0644	edit dl rm
update_api.php	5910	0644	edit dl rm
update_api_on_mail.php	4723	0644	edit dl rm
validatecode.php	1094	0644	edit dl rm
validatephone.php	1034	0644	edit dl rm

Edit: /home/desid573/public_html/fc_api/get_booking_status.php (3246B)

<?php
require("lib/config.php");
require_once 'vendor/eway/eway-rapid-php/include_eway.php';
// =============== Get customer user api ===================================
$data  = $_REQUEST;
$sql = "SELECT * FROM `booking` where id = '".$_REQUEST['bid']."'";
$result = $conn->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));

cmd: