FM / drivers

/home/desid573/public_html/angel/drivers/

/home/desid573/public_html/angel/drivers

Name	Size	Mode	Actions
twilio-php-master/	-	0755	rm
avail.php	19359	0644	edit dl rm
cancel_booking.php	4537	0644	edit dl rm
checkDetails.php	1050	0644	edit dl rm
create.php	2332	0644	edit dl rm
createbilling.php	7335	0644	edit dl rm
createdriver.php	4708	0644	edit dl rm
daily.php	9342	0644	edit dl rm
default.php	16383	0644	edit dl rm
delete.php	942	0644	edit dl rm
deletedriver.php	3508	0644	edit dl rm
error_log	193375	0644	edit dl rm
getDailyAvailability.php	3065	0644	edit dl rm
getDefaultAvailability.php	1102	0644	edit dl rm
getDriverAvailability.php	1642	0644	edit dl rm
home.php	5517	0644	edit dl rm
login.php	7782	0644	edit dl rm
loginDriver.php	1214	0644	edit dl rm
new.php	835	0644	edit dl rm
off.php	3502	0644	edit dl rm
register.php	8676	0644	edit dl rm
setDefaultAvailability.php	3257	0644	edit dl rm
setDriverAvailability.php	3365	0644	edit dl rm
setDriverPin.php	2189	0644	edit dl rm
smsregister.php	1564	0644	edit dl rm
updateDetails.php	3350	0644	edit dl rm

Edit: /home/desid573/public_html/angel/drivers/cancel_booking.php (4537B)

<?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;
		}
		
	}
	
	
	$Res["data"] = $booking_detail;
	$Res["user-data"] = $booking_details;
	$Res["message"] = "booking info for user"; 
	$Res["status"] = "OK"; 
	
	$name= $Res["data"][0]["spatula_id"];
$url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$name?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs";

$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);

$result = curl_exec($ch);
    
    curl_close($ch);

}
else
{
	$Res["message"] = "no such result present in booking"; 
	$Res["status"] = "ok"; 
}

$name = $booking_details[0]['name'];
$date = $booking_detail[0]['booking_date'];
$time = $booking_detail[0]['booking_time'];

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

$slackmessage = "$name for $date $time has cancelled - no charge";
$result = mysqli_query($conn, "UPDATE booking SET status='cancelled' WHERE spatula_id='".$id."'");
} else {
$status = $Res["data"][0]["status"];
$nameencode = urlencode($bookingdetails['name']);
$reference = $booking_detail[0]['reference'];
$slackmessage = "$name for $date $time has cancelled - <https://bookings.perthdesignateddrivers.com.au/payment?reference=$reference&amount=39.00&name=$nameencode&type=DD | Charge Cancellation Fee>";
}

$curlObj = curl_init();
	curl_setopt($curlObj, CURLOPT_URL, 'https://hooks.slack.com/services/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');
	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);

$result = mysqli_query($conn, "UPDATE booking SET status='cancelled' WHERE spatula_id='".$id."'");
//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";
				if(mail($to, $title, $message, $headers))
				{
					echo json_encode(new ArrayObject($Res)); 
				}

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 info for user"; $Res["status"] = "OK"; $name= $Res["data"][0]["spatula_id"]; $url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$name?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs"; $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); $result = curl_exec($ch); curl_close($ch); } else { $Res["message"] = "no such result present in booking"; $Res["status"] = "ok"; } $name = $booking_details[0]['name']; $date = $booking_detail[0]['booking_date']; $time = $booking_detail[0]['booking_time']; if($Res["data"][0]["status"] == ""){ $status = "unassigned"; $slackmessage = "$name for $date $time has cancelled - no charge"; $result = mysqli_query($conn, "UPDATE booking SET status='cancelled' WHERE spatula_id='".$id."'"); } else { $status = $Res["data"][0]["status"]; $nameencode = urlencode($bookingdetails['name']); $reference = $booking_detail[0]['reference']; $slackmessage = "$name for $date $time has cancelled - "; } $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, 'https://hooks.slack.com/services/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'); 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); $result = mysqli_query($conn, "UPDATE booking SET status='cancelled' WHERE spatula_id='".$id."'"); //echo "

";
//print_r($Res);
//echo "

"; $message = '

Hi,

Hi, Please cancel My booking ,Please check the detail below:

Booking was '.$status.'

Details:

Booking Id	'.$Res["data"][0]["id"].'
Name	'.$Res["user-data"][0]["name"].'
Mobile	'.$Res["user-data"][0]["mobile"].'
email Id	'.$Res["data"][0]["email"].'
Booking Date	'.$Res["data"][0]["booking_date"].'
Booking Time	'.$Res["data"][0]["booking_time"].'
Booking Time	'.$Res["data"][0]["booking_time"].'
Pickup address	'.$Res["data"][0]["pickup_addr"].'
Drop Address	'.$Res["data"][0]["pickoff_addr"].'
Spatula ID	'.$Res["data"][0]["spatula_id"].'

'; $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"; if(mail($to, $title, $message, $headers)) { echo json_encode(new ArrayObject($Res)); }