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/confirm_booking_change_ajax.php (6696B)

<?php

$request_id = $_POST["request_id"];

date_default_timezone_set("Australia/Perth");

require("lib/config.php");

$sql = "SELECT * FROM booking_edit_request WHERE id = ".$request_id;

$result = $conn->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);

cmd: