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/cancel_booking.php (6064B)

<?php
require("lib/config.php");
require("../vromo.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;
		}
		
	}
	
	
	$Res["data"] = $booking_detail;
	$Res["user-data"] = $booking_details;
	$Res["message"] = "Booking successfully cancelled"; 
	$Res["status"] = "OK"; 
	
	$name= $Res["data"][0]["spatula_id"];
$url = "https://api.vromo.io/v2/graph/role/jobs/$name?access_token=".$vromo;

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,$url);
    // curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
    // curl_setopt($ch, CURLOPT_POSTFIELDS, $json);
    // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, '{"cancelled": {"note": "", "reason": {"id": 25102}}}');

$result = curl_exec($ch);
    
    curl_close($ch);
    
$name = $booking_details[0]['name'];
$date = $booking_detail[0]['booking_date'];
$time = $booking_detail[0]['booking_time'];
$type = $booking_detail[0]['type'];
$id = $booking_detail[0]['spatula_id'];
$reference = $booking_detail[0]['reference'];

if($Res["data"][0]["status"] == ""){
$status = "cancelled";

$slackmessage = "$name for $date $time has cancelled - no charge";

} else {
$status = "cancelled";
$nameencode = urlencode($name);

$slackmessage = "$name for $date $bookingtime has cancelled - <https://desidrivers.com.au/payment?ref=$reference&amount=15.00&type=FA | Charge Cancellation Fee>";
}
	
	$result = mysqli_query($conn, "UPDATE booking SET status='".$status."' WHERE id='".$_REQUEST['bid']."'");
	
			//send slack message
			
			if ($type == "SA"){
        $url = "https://hooks.slack.com/services/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";
    
    } else if ($type == "MA") {
        $url = "https://hooks.slack.com/services/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";
    } else if ($type == "BA") {
        $url = "https://hooks.slack.com/services/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";
    } else if($type == "GA") {
        $url = "https://hooks.slack.com/services/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";
    } else if($type == "YA") {
        $url = "https://hooks.slack.com/services/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";
    } else {
        $url = 'https://hooks.slack.com/services/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';
    }
	
			$curlObj = curl_init();
			curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
			curl_setopt($curlObj, CURLOPT_HEADER, 0);
			curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
			curl_setopt($curlObj, CURLOPT_POST, 1);
			curl_setopt($curlObj, CURLOPT_POSTFIELDS, '{"text": "'.$slackmessage.'"}');
		
			$response = curl_exec($curlObj);
		
			curl_close($curlObj);
			
			//delete  job
	
			$url = "https://desidrivers.com.au/cancelJob.php?ref=$reference&type=$type";
    			$curlObj = curl_init();

curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
			curl_setopt($curlObj, CURLOPT_HEADER, 0);
			curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));

$response = curl_exec($curlObj);

curl_close($curlObj);

//echo "<pre>";
//print_r($Res);
//echo "</pre>";
 $message = '<div style ="width:725; margin:0 auto;"><p>Hi,</p>
				<p>Hi,
				Please cancel My booking ,Please check the detail below:</p>
				<p>Booking was '.$status.'</p>
				<p style = "font-weight:bold;";>Details:</p>
				<table width="400" style="border:none;">
					<tr>
						<td>Booking Id</td>
						<td>'.$Res["data"][0]["id"].'</td>
					</tr>
					<tr>
						<td>Name</td>
						<td>'.$Res["user-data"][0]["name"].'</td>
					</tr>
					<tr>
						<td>Mobile</td>
						<td>'.$Res["user-data"][0]["mobile"].'</td>
					</tr>
					<tr>
						<td>email Id</td>
						<td>'.$Res["data"][0]["email"].'</td>
					</tr>
					<tr>
						<td>Booking Date</td>
						<td>'.$Res["data"][0]["booking_date"].'</td>
					</tr>
					<tr>
						<td>Booking Time</td>
						<td>'.$Res["data"][0]["booking_time"].'</td>
					</tr>
					<tr>
						<td>Booking Time</td>
						<td>'.$Res["data"][0]["booking_time"].'</td>
					</tr>
					<tr>
						<td>Pickup address</td>
						<td>'.$Res["data"][0]["pickup_addr"].'</td>
					</tr>
					<tr>
						<td>Drop Address</td>
						<td>'.$Res["data"][0]["pickoff_addr"].'</td>
					</tr>
					<tr>
						<td>Spatula ID</td>
						<td>'.$Res["data"][0]["spatula_id"].'</td>
					</tr>
				</table>
				</div>';
				$to = "booking@perthdesignateddrivers.com.au" ;
				//$to = "chandan10n@gmail.com" ;
				$from = $Res["data"][0]["email"];
				$title = "Cancel Booking";
				$headers = "MIME-Version: 1.0 \r\n";
				$headers .= "From: $from \n";
				$headers .= "MIME-Version: 1.0\r\n";
				$headers .= "Content-type: text/html;charset=ISO-8859-1 \r\n";
				$headers .= "X-Priority: 3\r\n";
				$headers .= "X-Mailer: smail-PHP " . phpversion() . "\r\n";
				
				mail($to, $title, $message, $headers);
				
   echo json_encode(new ArrayObject($Res));

}
else
{
	$Res["message"] = "no such result present in booking"; 
	$Res["status"] = "ok";
	echo json_encode(new ArrayObject($Res)); 
}

cmd: