/home/desid573/public_html/fc_api
Edit: /home/desid573/public_html/fc_api/confirm_booking_change_ajax.php (6696B)
query($sql);
$nameArray = [
"date" => "booking_date",
"time" => "booking_time",
"pickup" => "pickup_addr",
"pick_lat" => "pickup_lat",
"pick_lon" => "pickup_long",
"dropoff" => "pickoff_addr",
"drop_lat" => "pickoff_lat",
"drop_lon" => "pickoff_long",
"book_pax" => "book_pax",
"book_rf" => "book_rf",
"book_ff" => "book_ff",
"book_b" => "book_b",
"new_quote" => "quote",
"new_quote_km" => "quote_km",
"new_quote_time" => "quote_time",
"flight_num" => "flight_num",
"mins" => "mins_to",
"luggage" => "luggage"];
if($result->num_rows > 0) {
$request = $result->fetch_assoc();
$array = ["id", "bid", "approved", "date_requested", "date_approved"];
$sql = "UPDATE `booking` SET ";
foreach($request as $key => $value) {
if($value != "" & array_search($key, $array) === false) {
$sql .= $nameArray["$key"]." = '".$value."', ";
}
}
$sql .= "status = 'confirmed' WHERE id = ".$request["bid"];
error_log($sql);
$update = $conn->query($sql);
if(!$update) {
error_log("update error ".$conn->error);
$r["status"] = "error";
$r["message"] = "update error";
} else {
$sql = "SELECT * FROM booking WHERE id = ".$request["bid"];
$d = $conn->query($sql);
if(!$d) {
error_log("couldnt get booking details ".$conn->error);
} else {
$booking_details = $d->fetch_assoc();
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://desidrivers.com.au/google/google-api-php-client-2.2.1/calendarRemove.php?ref=".$booking_details['reference']."&type=".$booking_details["type"]);
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);
error_log($response);
curl_close($curlObj);
$response = json_decode($response, true);
if($response["status"] == "OK" OR $response["message"] == "not found") {
require("../urlShortener.php");
$url = shortenLink($ref, $type, "options");
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, "https://desidrivers.com.au/google/google-api-php-client-2.2.1/calendarAdd.php?ref=".$booking_details['reference']."&type=".$booking_details["type"]."&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);
error_log($response);
curl_close($curlObj);
if($response == "OK") {
error_log("calendar updated");
} else {
$message_post = " could not add new calendar";
error_log("Update OK Calendar deleted but could not add new calendar");
}
} else {
$message_post = " could not delete calendar";
error_log("Update OK could not delete calendar");
}
}
$sql = "UPDATE booking_edit_request SET date_approved = '".date("Y-m-d G:i", strtotime("now"))."', approved = 1 WHERE id = ".$request_id;
$update_edit = $conn->query($sql);
if(!$update_edit) {
error_log($sql);
error_log("update edit failed ".$conn->error);
}
if($booking_details["type"] == "SA") {
date_default_timezone_set("Australia/Sydney");
$slackurl = "https://hooks.slack.com/services/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";
} else if ($booking_details["type"] == "MA") {
date_default_timezone_set("Australia/Melbourne");
$slackurl = "https://hooks.slack.com/services/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";
} else if ($booking_details["type"] == "BA") {
date_default_timezone_set("Australia/Brisbane");
$slackurl = "https://hooks.slack.com/services/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";
} else if($booking_details["type"] == "GA") {
$slackurl = "https://hooks.slack.com/services/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";
date_default_timezone_set("Australia/Brisbane");
} else {
$slackurl = "https://hooks.slack.com/services/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";
date_default_timezone_set("Australia/Perth");
}
$sql = "SELECT * FROM customers WHERE id = ".$booking_details["cid"];
$c = $conn->query($sql);
$customer_details = $c->fetch_assoc();
$message = "Update Confirmed:\n".$customer_details["name"]." ".$booking_details["booking_date"]." ".$booking_details["booking_time"]."\n";
error_log($message);
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, $slackurl);
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": "'.$message.'"}');
$response = curl_exec($curlObj);
error_log($response);
curl_close($curlObj);
$r["status"] = "ok";
$r["message"] = "updated successfully ".$message_post;
}
} else {
$r["status"] = "error";
$r["message"] = "request not found";
}
echo json_encode($r, true);
?>
