FM / public

/home/desid573/public_html

Name	Size	Mode	Actions
.well-known/	-	0755	rm
angel/	-	0755	rm
app/	-	0755	rm
assets/	-	0755	rm
cgi-bin/	-	0755	rm
drivers/	-	0755	rm
eway/	-	0755	rm
family/	-	0755	rm
fc_api/	-	0755	rm
gcdriver/	-	0755	rm
google/	-	0755	rm
hooks/	-	0755	rm
ims/	-	0755	rm
ims2/	-	0755	rm
ims3/	-	0755	rm
magicride.ng/	-	0750	rm
Mini-Inventory-and-Sales-Management-System-master/	-	0755	rm
old/	-	0755	rm
payment/	-	0755	rm
smee-client-master/	-	0755	rm
tester/	-	0755	rm
test_api/	-	0755	rm
tollster/	-	0755	rm
verde/	-	0755	rm
.ftpquota	18	0644	edit dl rm
.htaccess	1595	0644	edit dl rm
.user.ini	623	0644	edit dl rm
10.php	1941	0644	edit dl rm
11.php	1776	0644	edit dl rm
12.php	1112	0644	edit dl rm
400.shtml	990	0644	edit dl rm
401.shtml	1005	0644	edit dl rm
403.shtml	966	0644	edit dl rm
404.shtml	967	0644	edit dl rm
405.shtml	975	0644	edit dl rm
406.shtml	906	0644	edit dl rm
500.shtml	963	0644	edit dl rm
addDate.php	1438	0644	edit dl rm
app.zip	2365189	0644	edit dl rm
appoff.php	4797	0644	edit dl rm
a_index.php	15145	0644	edit dl rm
a_index1.php	15566	0644	edit dl rm
a_name_address.php	1010	0644	edit dl rm
a_thankyou.php	13211	0644	edit dl rm
cancel.php	8118	0644	edit dl rm
cancelJob.php	1162	0644	edit dl rm
checkDDPrice.php	1101	0644	edit dl rm
checker.php	694	0644	edit dl rm
class.phpmailer.php	80046	0644	edit dl rm
class.pop3.php	10385	0644	edit dl rm
class.smtp.php	24586	0644	edit dl rm
cleanUpSpatula.php	1617	0644	edit dl rm
confirm_check.php	6257	0644	edit dl rm
cpmove-desid573.tar.gz	6864557031	0644	edit dl rm
createcode.php	846	0644	edit dl rm
customer_address.php	1091	0644	edit dl rm
customer_delete.php	836	0644	edit dl rm
customer_index.php	9620	0644	edit dl rm
customer_update.php	1311	0644	edit dl rm
deleteDate.php	550	0644	edit dl rm
deleteprocess.php	2405	0644	edit dl rm
desidrivers.com.au_1608920241.php	5940	0644	edit dl rm
desidrivers.com.au_1609828175.php	5940	0644	edit dl rm
desidrivers.com.au_1616868643.php	5940	0644	edit dl rm
desidrivers.com.au_1637301975.php	5940	0644	edit dl rm
desidrivers.com.au_1639152857.php	5940	0644	edit dl rm
desidrivers.com.au_1641233330.php	5940	0644	edit dl rm
desidrivers.com.au_1641319578.php	5940	0644	edit dl rm
desidrivers.com.au_1647540767.php	5940	0644	edit dl rm
desidrivers.com.au_1650434806.php	5940	0644	edit dl rm
desidrivers.com.au_1650910031.php	5940	0644	edit dl rm
desidrivers.com.au_1653458783.php	5940	0644	edit dl rm
desidrivers.com.au_1660370822.php	5940	0644	edit dl rm
desidrivers.com.au_1670936136.php	5940	0644	edit dl rm
desidrivers.com.au_1677823585.php	5940	0644	edit dl rm
desidrivers.com.au_1681538797.php	5940	0644	edit dl rm
desidrivers.com.au_1689358025.php	5940	0644	edit dl rm
desidrivers.com.au_1730311693.php	5940	0644	edit dl rm
desidrivers.com.au_1735236463.php	5940	0644	edit dl rm
desidrivers.com.au_1735711647.php	5940	0644	edit dl rm
desidrivers.com.au_1743185292.php	5940	0644	edit dl rm
desidrivers.com.au_1743833158.php	5940	0644	edit dl rm
desidrivers.com.au_1746943553.php	5940	0644	edit dl rm
desidrivers.com.au_1750701953.php	5940	0644	edit dl rm
desidrivers.com.au_1752818776.php	5940	0644	edit dl rm
desidrivers.com.au_1753164358.php	5940	0644	edit dl rm
desidrivers.com.au_1753553154.php	5940	0644	edit dl rm
desidrivers.com.au_1753596377.php	5940	0644	edit dl rm
desidrivers.com.au_1756836372.php	5940	0644	edit dl rm
desidrivers.com.au_1758909980.php	5940	0644	edit dl rm
desidrivers.com.au_1760292383.php	5940	0644	edit dl rm
desidrivers.com.au_1761113162.php	5940	0644	edit dl rm
desidrivers.com.au_1761199577.php	5940	0644	edit dl rm
desidrivers.com.au_1762884366.php	5940	0644	edit dl rm
desidrivers.com.au_1764439552.php	5940	0644	edit dl rm
desidrivers.com.au_1765044452.php	5940	0644	edit dl rm
desidrivers.com.au_1765436459.php	5940	0644	edit dl rm
desidrivers.com.au_1765865163.php	5940	0644	edit dl rm
desidrivers.com.au_1769883052.php	5940	0644	edit dl rm
desidrivers.com.au_1770357976.php	5940	0644	edit dl rm
desidrivers.com.au_1771092507.php	5940	0644	edit dl rm
desidrivers.com.au_1772301949.php	5940	0644	edit dl rm
desidrivers.com.au_1773641731.php	5940	0644	edit dl rm
desidrivers.com.au_1775066775.php	5940	0644	edit dl rm
desis.zip	53287223	0644	edit dl rm
dispatch.php	2326	0644	edit dl rm
error_log	12806022	0644	edit dl rm
error_log_250913	29612275	0644	edit dl rm
error_log_251117	16736601	0644	edit dl rm
error_log_260603	37979880	0644	edit dl rm
familyPrice.php	4548	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
google0826623ce41a5365.html	53	0644	edit dl rm
holidays.php	5369	0644	edit dl rm
ims-master.zip	35927391	0644	edit dl rm
jobcancel.php	18105	0644	edit dl rm
job_index_results.php	6939	0644	edit dl rm
json-test.php	276	0644	edit dl rm
listen.php	70	0644	edit dl rm
magic_logo.jpg	80980	0644	edit dl rm
newcode.php	4532	0644	edit dl rm
newJob.php	9199	0644	edit dl rm
newjob_index.php	6073	0644	edit dl rm
new_spatula_job.php	24849	0644	edit dl rm
off.php	3283	0644	edit dl rm
onboard.php	7327	0644	edit dl rm
oops.php	3722	0644	edit dl rm
php.ini	617	0644	edit dl rm
postcode_array.php	0	0644	edit dl rm
quote.php	11432	0644	edit dl rm
recall.php	935	0644	edit dl rm
replysms.php	964	0644	edit dl rm
search.php	853	0644	edit dl rm
sendtofamily.php	1153	0644	edit dl rm
sendToSlack.php	0	0644	edit dl rm
smscheck.php	1042	0644	edit dl rm
smsconfirm.php	10090	0644	edit dl rm
smsInvoice.php	5994	0644	edit dl rm
smslog.php	805	0644	edit dl rm
smsmel.php	685	0644	edit dl rm
smssend.php	4252	0644	edit dl rm
smsSendInv.php	1098	0644	edit dl rm
spatula_addFC.php	5076	0644	edit dl rm
spat_test.php	1308	0644	edit dl rm
test.php	670	0644	edit dl rm
test2.php	0	0644	edit dl rm
test123.php	19	0644	edit dl rm
tollster (1).zip	9867447	0644	edit dl rm
typeConfig.php	6414	0644	edit dl rm
typeGet.php	5972	0644	edit dl rm
update.php	24185	0644	edit dl rm
urlShortener.php	3031	0644	edit dl rm
vromo.php	273	0644	edit dl rm
webhook.php	2330	0644	edit dl rm
x.php	1156	0644	edit dl rm

Edit: /home/desid573/public_html/new_spatula_job.php (24849B)

<?php
//ini_set('display_errors', '1');
//error_reporting(E_ALL);
//header('Content-type: application/json; charset=utf-8');
require("urlShortener.php");

$name=$_REQUEST['type'];

if(!empty($name))
{
    $dist=GetAddress($name);
    echo json_encode($dist, true);
    
}

//calculate distance
function GetAddress($type)
{
   
$array = [];
if($type=="DD") {

$dbhost = "localhost";
	    		$dbuser = "desid573_inquiri";
	    		$dbpass = "@G&{)0*&Ts^V";
	    		$dbname = "desid573_inquiries";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    		
        		$result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference = '".$_REQUEST['ref']."'");
        		if(!$result) {
        		error_log($conn->error);
        		}
			while($row = mysqli_fetch_assoc($result)) {
        		$quote = $row['job_quote'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$tokencustomerid = $row['token'];
        		$name = $row['job_name'];
        		$email = $row['job_email'];
        		$pickup = $row['job_pickup'];
        		
        		$dropoff = $row['job_dropoff'];
        		$pickCoords = checkLocalCoords($pickup);
        	        error_log(json_encode($pickCoords, true));
        	        if($pickCoords == false) {
        	            
        	            $pickplace = getplaceid($pickup);
            		    if($pickplace) {
            		    $pickCoords = getCoords($pickplace, $pickup);
            		    }
        	            
        	        } 
            		
        	
    		        $dropCoords = checkLocalCoords($dropoff); 
    		        
    		        if($dropCoords == false) {
    		
                		$dropplace = getplaceid($dropoff);
                		if($dropplace) {
                		    $dropCoords = getCoords($dropplace, $dropoff);
                		
        		        }
    		        }
        		$ref = $row['reference'];
        		$code = "DD";
        		$mins_to = "";
        		$flightNum = "";
        		$phone = $row['job_phone'];
        		$token = $row['token'];
        		if($token == "" && $_GET['token'] != ""){
        		$token = $_GET['token'];
        		}
        		
        		$xero = $row['xero_inv'];
        		$spatula_id = $row['spat_ref'];
        		date_default_timezone_set("Australia/Perth");
        		$d = date_create_from_format("jS M, Y", $row["job_date"]);
                $date24 = date_format($d, "Y-m-d");
                
                
                
                
                $time24 = date("G:i", strtotime($row["job_time"]));            
                $timeUTC = date("c", strtotime("$date24 $time24"));
                
                $timestamp = strtotime("$date24 $time24") * 1000;
                if($pickCoords && $dropCoords) {
			
			    
                $paymentlink = shortenLink($ref, $type, "payment");
                
                
                $post = '[{"name": "DD ' . $name . '", "campaign": {"id": 5623765662}, "contact": {"name": "' . $name . '","phone": "' . $phone . '"},"tasks": [{"timeframe":{"by": '.$timestamp.'}, "zone": {"name": "' . $pickup . '","address": "' . $pickup . '","coords": {"lat": ' . $pickCoords["lat"] . ',"lon": ' . $pickCoords["lon"] . '},"radius": 100}},{"zone": {"name": "' . $dropoff . '","address": "' . $dropoff . '","coords": {"lat": ' . $dropCoords["lat"] . ',"lon": ' . $dropCoords["lon"] . '},"radius": 100}}],"attr": [{ "key": "Payment Link", "value": "' . $paymentlink . '" }]}]';

$json = createSpatulaJob($post);
                
                $spatulalink = $json['items'][0]['tracking'];
                $spatulaid = $json['items'][0]['id'];
                
                $result = mysqli_query($conn, "UPDATE jobs SET spat_ref = ".$spatulaid.", spat_link = '".$spatulalink."' WHERE reference = '".$_REQUEST['ref']."' ");
                if(!$result) {
                    error_log($conn->error);
                }
                
                if(strlen($spatulaid) > 1) {
                    $array = array("status" => "OK", "message" => "Success", "id" => $spatulaid, "link" => $spatulalink);
                    
                } else {
                    $array = array("status" => "error", "message" => "failed");
                    
                }
                return $array;
                
                
                }
                
                
                
        	
        		
			}
        					
}
if($type=="FC" or $type=="SF" or $type=="MF" or $type=="BF" or $type=="GC" or $type == "SC") {

$dbhost = "localhost";
			$dbuser = "desid573_famcab";
	    		$dbpass = "C]+6wQySxov(";
	    		$dbname = "desid573_familycab";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    		
        		$result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference = '".$_REQUEST['ref']."'");
			while($row = mysqli_fetch_assoc($result)){
			    $tokencustomerid = $row['token'];
        		$quote = $row['job_quote'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$name = $row['job_name'];
        		$email = $row['job_email'];
        		$phone = $row['job_phone'];
        		$pickup = $row['job_pickup'];
        		$dropoff = $row['job_dropoff'];
        	
        	    
        	    
            		$pickCoords = checkLocalCoords($pickup);
        	        error_log(json_encode($pickCoords, true));
        	        if($pickCoords == false) {
        	            
        	            $pickplace = getplaceid($pickup);
            		    if($pickplace) {
            		    $pickCoords = getCoords($pickplace, $pickup);
            		    }
        	            
        	        } 
            		
        	
    		        $dropCoords = checkLocalCoords($dropoff); 
    		        
    		        if($dropCoords == false) {
    		
                		$dropplace = getplaceid($dropoff);
                		if($dropplace) {
                		    $dropCoords = getCoords($dropplace, $dropoff);
                		
        		        }
    		        }
        		$postAddresses = '';
        		
        		$ref = $row['reference'];
        		//$code = $row['type'];
        		$mins_to = $row['mins_post'];
        		$flightNum = $row['flight_num'];
        		$xero = $row['xero_inv'];
        		$spatula_id = $row['spat_ref'];
        		
        		$date = $row['job_date'];
        		$time = $row['job_time'];
        		
                $d = date_create_from_format("jS M, Y", $date);
                $date24 = date_format($d, "Y-m-d");
                if($type == "SF") {
                date_default_timezone_set("Australia/Sydney");
                } else if($type == "MF") {
                date_default_timezone_set("Australia/Melbourne");
                } else if($type == "BF") {
                date_default_timezone_set("Australia/Brisbane");    
                } else {
                date_default_timezone_set("Australia/Perth");
                }
                
                $time24 = date("G:i", strtotime($time));            
                $timeUTC = date("c", strtotime("$date24 $time24"));
                $timestamp = strtotime("$date24 $time24") * 1000;
        		$bookPax = $row['job_pax'];
        		$bookRF = $row['job_rf'];
        		$bookFF = $row['job_ff'];
        		$bookB = $row['job_boost'];
        		$luggage = $row['job_luggage'];
        		
        		
			
			    $paymentlink = shortenLink($ref, $type, "payment");
                
                $flighttext = "$flightNum + $mins_to mins";
                if($flightNum == ""){
                $flighttext = "";
                }
                
                	
                	
                	
                
                $seats = "$bookPax pax \\n$bookRF RF\\n$bookFF FF\\n$bookB Boost";
                
        	    $post = '[{"name": "' .$type.' '. $name . '","campaign": {"id": 5623765662}, "contact": {"name": "' . $name . '","phone": "' .$phone . '"}, "tasks": [{"timeframe":{"by": '.$timestamp.'}, "zone": {"name": "' . $pickup . '","address": "' . $pickup . '","coords": {"lat": ' . $pickCoords["lat"] . ',"lon": ' . $pickCoords["lon"] . '},"radius": 100}},{"zone": {"name": "' . $dropoff . '","address": "' . $dropoff . '","coords": {"lat": ' . $dropCoords["lat"] . ',"lon": ' . $dropCoords["lon"] . '},"radius": 100}}],"attr": [{"key": "Flight", "value": "'.$flight.' + '.$mins.' mins"},{ "key": "Seats", "value": "' . $seats . '" },{"key": "Luggage", "value": "'.$luggage.'"}, {"key": "Payment Link", "value": "'.$paymentlink.'"}]}]';
                error_log($post);    
                $json = createSpatulaJob($post);
                
                
                $spatulalink = $json['items'][0]['tracking'];
                $spatulaid = $json['items'][0]['id'];
                
                $result = mysqli_query($conn, "UPDATE jobs SET spat_ref = ".$spatulaid.", spat_link = '".$spatulalink."' WHERE reference = '".$_REQUEST['ref']."' ");
                if(!$result) {
                    error_log($conn->error);
                }
                
                if(strlen($spatulaid) > 1) {
                    $array = array("status" => "OK", "message" => "Success", "id" => $spatulaid, "link" => $spatulalink);
                    
                } else {
                    $array = array("status" => "error", "message" => "failed");
                    
                }
                return $array;
        		}
			
    			
}
if($type=="HK" OR $type=="SI") {

$dbhost = "localhost";
	    		$dbuser = "desid573_inquiri";
	    		$dbpass = "@G&{)0*&Ts^V";
	    		$dbname = "desid573_new_pro_api";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    		
	    		
        		$result = mysqli_query($conn, "SELECT  * FROM booking WHERE reference = ".$_REQUEST['ref']);
			while($row = mysqli_fetch_assoc($result)) {
        		$spatula_id = $row['spatula_id'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$pickup = $row['pickup_addr'];
        		
        		
        		$dropoff = $row['pickoff_addr'];
        		$pickCoords = checkLocalCoords($pickup);
        	        error_log(json_encode($pickCoords, true));
        	        if($pickCoords == false) {
        	            
        	            $pickplace = getplaceid($pickup);
            		    if($pickplace) {
            		    $pickCoords = getCoords($pickplace, $pickup);
            		    }
        	            
        	        } 
            		
        	
    		        $dropCoords = checkLocalCoords($dropoff); 
    		        
    		        if($dropCoords == false) {
    		
                		$dropplace = getplaceid($dropoff);
                		if($dropplace) {
                		    $dropCoords = getCoords($dropplace, $dropoff);
                		
        		        }
    		        }
        		$ref = $row['reference'];
        		$code = $row['type'];
        		$mins_to = "";
        		$flightNum = "";
        		date_default_timezone_set("Australia/Perth");
        		$booking_date = $row['booking_date'];
        		$booking_time = $row['booking_time'];
        		
                
	            $timeUTC = date("c", strtotime("$booking_date $booking_time"));
        		$timestamp = strtotime("$booking_date $booking_time") * 1000;
        		$quote = $row['quote'];
        		$cid = $row['cid'];
        		$result1 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
			$row1 = mysqli_fetch_assoc($result1);
			$name = $row1['name'];
			$email = $row1['email'];
			$phone = $row1['mobile'];
			if(!$result1){
			error_log($conn->error);
			}
			
			
		    $paymentlink = shortenLink($ref, $type, "payment");

$post = '[{"name": "' .$type.' ' . $name . '", "campaign": {"id": 5622549795}, "contact": {"name": "' . $name . '","phone": "' .$phone . '"},"tasks": [{"timeframe":{"by": '.$timestamp.'}, "zone": {"name": "' . $pickup . '","address": "' . $pickup . '","coords": {"lat": ' . $pickCoords["lat"] . ',"lon": ' . $pickCoords["lon"] . '},"radius": 100}},{"zone": {"name": "' . $dropoff . '","address": "' . $dropoff . '","coords": {"lat": ' . $dropCoords["lat"] . ',"lon": ' . $dropCoords["lon"] . '},"radius": 100}}],"attr": [{ "key": "Payment Link", "value": "' . $paymentlink . '" }]}]';
            error_log($post);
            $json = createSpatulaJob($post);
                
            $spatulalink = $json['items'][0]['tracking'];
            $spatulaid = $json['items'][0]['id'];

$result = mysqli_query($conn, "UPDATE booking SET spatula_id = ".$spatulaid.", spatula_link = '".$spatulalink."' WHERE reference = '".$_REQUEST['ref']."' ");
            if(!$result) {
                error_log($conn->error);
            }
            
            if(strlen($spatulaid) > 1) {
                $array = array("status" => "OK", "message" => "Success", "id" => $spatulaid, "link" => $spatulalink);
                
            } else {
                $array = array("status" => "error", "message" => "failed");
                
            }
            return $array;
		    
		}
        			
        		
        			
        			
}
if($type=="FA" or $type=="SA" or $type == "MA" or $type == "BA" or $type == "GA" or $type == "YA") {

$item = "FA";
$dbhost = "localhost";
$dbuser = "desid573_fam_app";
$dbpass = "TW#7CCqKReDn";
$dbname = "desid573_famcab_api";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
        		$result = mysqli_query($conn, "SELECT * FROM booking WHERE reference = ".$_REQUEST['ref']);
			while($row = mysqli_fetch_assoc($result)){
        		$spatula_id = $row['spatula_id'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$pickup = $row['pickup_addr'];
        		
        		$dropoff = $row['pickoff_addr'];
        		
        		$pickCoords = checkLocalCoords($pickup);
        	        error_log(json_encode($pickCoords, true));
        	        if($pickCoords == false) {
        	            
        	            $pickplace = getplaceid($pickup);
            		    if($pickplace) {
            		    $pickCoords = getCoords($pickplace, $pickup);
            		    }
        	            
        	        } 
            		
        	
    		        $dropCoords = checkLocalCoords($dropoff); 
    		        
    		        if($dropCoords == false) {
    		
                		$dropplace = getplaceid($dropoff);
                		if($dropplace) {
                		    $dropCoords = getCoords($dropplace, $dropoff);
                		
        		        }
    		        }
        		
        		
        		$xero = $row['xero_inv'];
        		$ref = $row['reference'];
        		$code = $row['type'];
        		if($xero == "") {
			$xero = "none";
			}
			
			if($type == "SA") {
                date_default_timezone_set("Australia/Sydney");
                } else if($type == "MA") {
                date_default_timezone_set("Australia/Melbourne");
                } else if($type == "BA" OR $type == "GA") {
                date_default_timezone_set("Australia/Brisbane");    
                } else {
                date_default_timezone_set("Australia/Perth");
                }
			
        		$booking_date = $row['booking_date'];
        		$booking_time = $row['booking_time'];
        		
        		$timeUTC = date("c", strtotime("$booking_date $booking_time"));
        		$timestamp = strtotime($booking_date." ".$booking_time) * 1000;
        		error_log($timestamp);
        		$mins_to = $row['mins_to'];
        		$flight_num = $row['flight_num'];
        		$book_pax = $row['book_pax'];
        		$book_rf = $row['book_rf'];
        		$book_ff = $row['book_ff'];
        		$book_b = $row['book_b'];
        		$luggage = $row['luggage'];
        		$quote = $row['quote'];
        		$cid = $row['cid'];
        		$result2 = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
			$row1 = mysqli_fetch_assoc($result2);
			$name = $row1['name'];
			$email = $row1['email'];
			$phone = $row1['mobile'];
			
			$longUrl = "https://www.desidrivers.com.au/payment/?ref=".$_REQUEST['ref']."&type=".$type; 
            $postData = array('longUrl' => $longUrl);
            $jsonData = json_encode($postData);
            
            $paymentlink = shortenLink($ref, $type, "payment");
			
			
            $additional_string = "";
            if($flight_num != ""){
            	$additional_string = $flight_num." +".$mins_to."mins";
            	
            	} 
            
            if($luggage != ""){
            
            
            	$additional_string .= "\\nLuggage: ".str_replace("\n", "", $luggage); 
            
            }
            
            
            $seats_string = $book_pax." pax\\n";
            if($book_rf != "0") {
            $seats_string .= $book_rf." RF\\n";
            }
            if($book_ff != "0") {
            $seats_string .= $book_ff." FF\\n";
            }
            if($_REQUEST['book_b'] != "0") {
            $seats_string .= $book_b." B\\n";
            }
		
			$post = '[{"name": "' .$type.' ' . $name . '","campaign": {"id": 5623765662}, "contact": {"name": "' . $name . '","phone": "' .$phone . '"},"tasks": [{"timeframe":{"by": '.$timestamp.'}, "zone": {"name": "' . $pickup . '","address": "' . $pickup . '","coords": {"lat": ' . $pickCoords["lat"] . ',"lon": ' . $pickCoords["lon"] . '},"radius": 100}},{"zone": {"name": "' . $dropoff . '","address": "' . $dropoff . '","coords": {"lat": ' . $dropCoords["lat"] . ',"lon": ' . $dropCoords["lon"] . '},"radius": 100}}],"attr": [{ "key": "Payment Link", "value": "' . $paymentlink . '" },{ "key": "Seats", "value": "' . $seats_string . '" },{ "key": "Additional", "value": "' . $additional_string . '" }]}]';
			
			$json = createSpatulaJob($post);
            
            
            $spatulalink = $json['items'][0]['tracking'];
            $spatulaid = $json['items'][0]['id'];
            
            $result = mysqli_query($conn, "UPDATE booking SET spatula_id = ".$spatulaid.", spatula_link = '".$spatulalink."' WHERE reference = '".$_REQUEST['ref']."' ");
                if(!$result) {
                    error_log($conn->error);
                }
                
                if(strlen($spatulaid) > 1) {
                    $array = array("status" => "OK", "message" => "Success", "id" => $spatulaid, "link" => $spatulalink);
                    
                } else {
                    $array = array("status" => "error", "message" => "failed");
                    
                }
                return $array;
			
			}	
        		
        }
        
    
    //return $array;
}

function createSpatulaJob($post) {
    
    require("vromo.php");
    
    $curlObj = curl_init();

curl_setopt($curlObj, CURLOPT_URL, 'https://api.vromo.io/v2/graph/role/jobs?access_token='.$vromo);
    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, $post);
    
            
            
            
    $response = curl_exec($curlObj);
    error_log($response);
    
    $json = json_decode($response, true);
    
    curl_close($curlObj);
    
    return $json;
    
    
}
function updatePlace($name, $lat, $lng) {
    
    $dbhost = "localhost";
	$dbuser = "desid573_fam_app";
    $dbpass = "TW#7CCqKReDn";
    $dbname = "desid573_eway_codes";
	$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	
	$sql = "SELECT * FROM place_coords WHERE name = '".$name."'";
	$result = $conn->query($sql);
	if($result->num_rows > 0) {
	    
	    $sql = "UPDATE `place_coords` SET `lat`=".$lat.",`lon`=".$lng.", date_added = NOW() WHERE `name`='".$name."'";
	    error_log($sql);
	    $result = $conn->query($sql);
	    if(!$result) {
	        error_log("Error updating coords ".$conn->error);
	    }
	    
	    
	} else {
	    
	    $sql = "INSERT INTO `place_coords`(`id`, `name`, `lat`, `lon`, `date_added`) VALUES (NULL,'".$name."',".$lat.",".$lng.",NOW())";
	    $result = $conn->query($sql);
	    if(!$result) {
	        error_log($sql);
	        error_log("Error inserting coords ".$conn->error);
	    }
	    
	}
    
    
}

cmd: