/home/desid573/public_html/test_api
Edit: /home/desid573/public_html/test_api/cancel_booking.php (5621B)
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 $time has cancelled -
";
}
$result = mysqli_query($conn, "UPDATE booking SET status='".$status."' WHERE id='".$_REQUEST['bid']."'");
//send slack message
$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);
//delete Spatula 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 "";
//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"].' |
