FM / app

/home/desid573/public_html/app

Name	Size	Mode	Actions
braintree/	-	0755	rm
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	9655	0644	edit dl rm
cancel_booking.php	4925	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
contact_us_mail.php	890	0644	edit dl rm
copy_account_to_homekey.php	4334	0644	edit dl rm
dispatch.php	877	0644	edit dl rm
emailConfirmReset.php	401	0644	edit dl rm
error_log	586874	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	2183	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	2170	0644	edit dl rm
get_completed_bookings.php	710	0644	edit dl rm
get_ETA.php	6332	0644	edit dl rm
get_lead_message.php	673	0644	edit dl rm
get_open_bookings.php	1399	0644	edit dl rm
get_payment_byuser.php	1064	0644	edit dl rm
get_price.php	760	0644	edit dl rm
get_recipes.php	6361	0644	edit dl rm
get_TE.php	1217	0644	edit dl rm
index.php	10411	0644	edit dl rm
index_backup.php	4791	0644	edit dl rm
lib_tr.zip	105047	0644	edit dl rm
login_api.php	5789	0644	edit dl rm
noteconfirm.php	8208	0644	edit dl rm
off.php	2854	0644	edit dl rm
passwordResetLink.php	5190	0644	edit dl rm
pay_file.php	7302	0644	edit dl rm
pay_file_back.php	5326	0644	edit dl rm
placehold.html	2141	0644	edit dl rm
post.php	2535	0644	edit dl rm
reset_email.php	1775	0644	edit dl rm
reset_phone.php	5717	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	1055	0644	edit dl rm

Edit: /home/desid573/public_html/app/get_open_bookings.php (1399B)

<?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 `email` = '".$_REQUEST['email']."' AND status <> 'completed' AND status <> 'cancelled' AND status <> 'expired'";
$result = $conn->query($sql);
if ($result->num_rows > 0) 
{
	while($row_details = $result->fetch_assoc()) 
	{
		$format = 'Y-m-d';
            $datetime = DateTime::createFromFormat($format, $row_details["booking_date"]);
            $bookingdate = $datetime->getTimestamp();
            
	    if($bookingdate < strtotime("yesterday")) {
	        
	        $sql1 = "UPDATE `booking` SET `status` = 'expired' WHERE `id` = '".$row_details['id']."'";
	        $result1 = $conn->query($sql1);
	        if(!$result1) {
	            error_log($conn->error);
	        }
	        
	    } else {
	    
		$booking_detail[] = $row_details;
		
	    }
	}
	
	
	
	error_log(json_encode($booking_detail, true));
	if(count($booking_detail) > 0) {
	$Res["data"] = $booking_detail;
	$Res["message"] = "Bookings Found"; 
	$Res["status"] = "OK"; 
	} else {
	   $Res["message"] = "No Open Bookings Found"; 
	    $Res["status"] = "no";  
	    
	}
	
}
else
{
	$Res["message"] = "No Open Bookings Found"; 
	$Res["status"] = "no"; 
}

echo json_encode(new ArrayObject($Res));

'completed' AND status <> 'cancelled' AND status <> 'expired'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row_details = $result->fetch_assoc()) { $format = 'Y-m-d'; $datetime = DateTime::createFromFormat($format, $row_details["booking_date"]); $bookingdate = $datetime->getTimestamp(); if($bookingdate < strtotime("yesterday")) { $sql1 = "UPDATE `booking` SET `status` = 'expired' WHERE `id` = '".$row_details['id']."'"; $result1 = $conn->query($sql1); if(!$result1) { error_log($conn->error); } } else { $booking_detail[] = $row_details; } } error_log(json_encode($booking_detail, true)); if(count($booking_detail) > 0) { $Res["data"] = $booking_detail; $Res["message"] = "Bookings Found"; $Res["status"] = "OK"; } else { $Res["message"] = "No Open Bookings Found"; $Res["status"] = "no"; } } else { $Res["message"] = "No Open Bookings Found"; $Res["status"] = "no"; } echo json_encode(new ArrayObject($Res));