FM / payment

/home/desid573/public_html/payment

Name	Size	Mode	Actions
assets/	-	0755	rm
eway-rapid-php-master/	-	0755	rm
pdd/	-	0755	rm
xero/	-	0755	rm
xero-2/	-	0755	rm
xero-php-oauth2-master/	-	0755	rm
10.php	1941	0644	edit dl rm
11.php	992	0644	edit dl rm
approved.php	1513	0644	edit dl rm
a_name_address.php	931	0644	edit dl rm
checktime.php	1436	0644	edit dl rm
driverCheck.php	794	0644	edit dl rm
eCrypt.js	68424	0644	edit dl rm
eway-rapid-php-master.zip	57270	0644	edit dl rm
eWay.php	42697	0644	edit dl rm
index.php	56045	0644	edit dl rm
index1.php	34506	0644	edit dl rm
index15May.php	48366	0644	edit dl rm
indexOLD.php	41793	0644	edit dl rm
indexTest.php	42517	0644	edit dl rm
payment-shutdown.log	517	0644	edit dl rm
quote.php	7218	0644	edit dl rm
test.php	1871	0644	edit dl rm
thankyou.php	24144	0644	edit dl rm
thankyouOLD.php	30110	0644	edit dl rm
thankyouTest.php	21950	0644	edit dl rm
tokenUpdate.php	10673	0644	edit dl rm
updatetoken.php	3696	0644	edit dl rm
xero-2-2.zip	2834178	0644	edit dl rm

Edit: /home/desid573/public_html/payment/indexTest.php (42517B)

<?php
$actual_link = (isset($_SERVER['HTTPS']) ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$promo_value = 1;
$promo_code = 1;
$charge = "0.00";
$kmRate = "2.75";
$quote = "39";
$xero="none";
$claim = "none";
$phone="1";
$minsTo = "";
$booking_date = "none";
$booking_time = "none";
if($_GET['admin']==1) {
$admin = "yes";
} else {
$admin = "no";
}
$name = "";
if(isset($_GET['ref'])) {
$reference = $_GET['ref'];
} else {
$reference = time().rand(10,5000);
}
$client_key = '4T7y1vuKPkdhRYUQdH6msueW9hqV2wpcwnSk0Qwxkvwf7TjQn40qymPW7IJb66gUC1w1505cDMkj9IR82juQEnIp4/8nd0nDhwYDSDoqROtNBWmkqtqYmF6F4qVGMUq3HpJrY3y2kdSljCFfWzWc7LIEn4G5XY2IZAPgAO5+mhwvYrricmqwLhqzV4FBUII5AwTvJZl4awrdul4vLWkS73vJuW/XrXHseGK/nqB3oSRluZ1jKp2qDgVTwrXYEbx4rwwS42X2w0C9tLKywxf27WD2CCK8ftSeQBimVqFI0r6VuRXFVaOn6SQTOD9V/TsCfPk5Zh6/PWcfapyVKS+l1w==';
$pickup = urldecode($_GET['pickup']);
$dropoff = urldecode($_GET['dropoff']);
if($_GET['type']=="DD") {
$type = "Designated Driver";
$item = $_GET['type'];

$dbhost = "localhost";
	    		$dbuser = "perthdes_inquiri";
	    		$dbpass = "@G&{)0*&Ts^V";
	    		$dbname = "perthdes_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 prices WHERE id=0");
        		if(!$result) {
        		error_log($conn->error);
        		}
			$row = mysqli_fetch_assoc($result);
        		$kmRate = $row['km'];
        		$timeRate = $row['time'];
        		$baseRate = $row['base'];
        		$result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference='".$_GET['ref']."'");
        		if(!$result) {
        		error_log($conn->error);
        		}
			$row = mysqli_fetch_assoc($result);
        		$quote = $row['job_quote'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$name = $row['job_name'];
        		$pickup = $row['job_pickup'];
        		$dropoff = $row['job_dropoff'];
        		$phone = $row['job_phone'];
        		$token = $row['token'];
        		if($token == "" && $_GET['token'] != ""){
        		$token = $_GET['token'];
        		}
        		
        		$xero = $row['xero_inv'];
        		$spatula_id = $row['spat_ref'];
        		$booking_date = $row['job_date'];
        		$booking_time = $row['job_time'];
        		if($xero == "") {
			$xero = "none";
			}
			if($spatula_id != ""){
			$url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs";
			$curlObj = curl_init();
			curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);

$response = curl_exec($curlObj);

curl_close($curlObj);
	
			$array = json_decode($response, true);

date_default_timezone_set("Australia/Perth");
                        //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y');
                        $booking_date = str_replace(",", "", $booking_date);
                        $bookingTime = str_replace(" ", "", $booking_time);
       			$booking = $booking_date." ".$bookingTime;
       			$booking = strtotime($booking);
		       	
		       	
		       	
       			$time1 = $array['tasks']['items'][0]['completed']['time']/1000;
       			if($time1 == "") {
       			$time1 = $booking;
       			}
		       	$time2 = $array['tasks']['items'][1]['completed']['time']/1000;
       				if($time2 == "") {
       					$time2 = time();
       				}
       			
       			
       			$grace = 5;
       			
       			$diff = $time2-$time1;
       			$timeEstimate = $quote_time + $grace;
       	
    				$Res['diff'] = ceil($diff/60);
    				$Res['time1'] = date('d/m/Y H:i', $time1);
    				$Res['time2'] = date('d/m/Y H:i', $time2);
    				
    				//echo '<div style="margin-left: 10px">';
    				//echo "Start Time = ".$Res['time1'];
    				//echo "<br>";
    				//echo "End Time = ".$Res['time2'];
    				//echo "<br>";
    				//echo "Difference = ".$Res['diff']."mins";
    				//echo "<br>";
    				//echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms";
    				//echo "<br>";
    				$charge = ceil($Res['diff']-$timeEstimate);
    				//echo "Charge + $".$charge;
    				//echo "<br>";
    				//echo '<button name="update" id="update"><span id="updatetext">Change</span></button>';
    				//echo "</div>";
    				
    			
			
			}
			
			
			
}
if($_GET['type']=="FC" or $_GET['type']=="SF") {
$type = "FamilyCab Taxi Service";
$item = $_GET['type'];
			$dbhost = "localhost";
			$dbuser = "perthdes_famcab";
	    		$dbpass = "C]+6wQySxov(";
	    		$dbname = "perthdes_familycab";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    		$price_code = "1";
	    		if($_GET['type']=="SF") {
	    		$price_code = "0";
	    		}
	    		$result = mysqli_query($conn, "SELECT * FROM prices WHERE id='".$price_code."'");
        		if(!$result) {
        		error_log($conn->error);
        		}
			$row = mysqli_fetch_assoc($result);
        		$kmRate = $row['km'];
        		$largeKmRate = $row['large_km'];
        		$timeRate = $row['time'];
        		$baseRate = $row['base'];
        		$result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference='".$_GET['ref']."'");
			$row = mysqli_fetch_assoc($result);
        		$quote = $row['job_quote'];
        		$quote_km = $row['quote_km'];
        		$quote_time = $row['quote_time'];
        		$name = $row['job_name'];
        		$phone = $row['job_phone'];
        		$pickup = $row['job_pickup'];
        		$dropoff = $row['job_dropoff'];
        		$token = $row['token'];
        		$minsTo = $row['mins_post'];
        		$booking_date = $row['job_date'];
        		$booking_time = $row['job_time'];
        		if($token=="" && $_GET['token'] != ""){
        		$token = $_GET['token'];
        		}
        		$xero = $row['xero_inv'];
        		$spatula_id = $row['spat_ref'];
        		if($xero == "") {
			$xero = "none";
			}
			$minsTo = "";
			$url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs";
			$curlObj = curl_init();
			curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);

$response = curl_exec($curlObj);

curl_close($curlObj);
	
			$array = json_decode($response, true);

date_default_timezone_set("Australia/Perth");
                        //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y');
                        $booking_date = str_replace(",", "", $booking_date);
                        $bookingTime = str_replace(" ", "", $booking_time);
       			$booking = $booking_date." ".$bookingTime;
       			$booking = strtotime($booking);
		       	
       			$time1 = $array['tasks']['items'][0]['completed']['time']/1000;
       			if($time1 == "") {
       			$time1 = $booking;
       			}
       			
		       	$time2 = $array['tasks']['items'][1]['completed']['time']/1000;
       				if($time2 == "") {
       					$time2 = time();
       				}
       			
       			
       			$grace = 5;
       			
       			$diff = $time2-$time1;
       			$timeEstimate = $quote_time + $grace;
       	
    				$Res['diff'] = ceil($diff/60);
    				$Res['time1'] = date('d/m/Y H:i', $time1);
    				$Res['time2'] = date('d/m/Y H:i', $time2);
    				
    				//echo '<div style="margin-left: 10px">';
    				//echo "Start Time = ".$Res['time1'];
    				//echo "<br>";
    				//echo "End Time = ".$Res['time2'];
    				//echo "<br>";
    				//echo "Difference = ".$Res['diff']."mins";
    				//echo "<br>";
    				//echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms";
    				//echo "<br>";
    				$charge = ceil($Res['diff']-$timeEstimate)*$timeRate;
    				//echo "Charge + $".$charge;
    				//echo "<br>";
    				//echo '<button name="update" id="update"><span id="updatetext">Change</span></button>';
    				//echo "</div>";
    			
    				
    			
}
if($_GET['type']=="HK" OR $_GET['type']=="SI") {
$type = "HomeKey Designated Driver Service";
$item = $_GET['type'];
$dbhost = "localhost";
	    		$dbuser = "perthdes_inquiri";
	    		$dbpass = "@G&{)0*&Ts^V";
	    		$dbname = "perthdes_new_pro_api";
	    		$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
	    		$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
	    		if($_GET['type']=="HK") {
			$result = mysqli_query($conn, "SELECT * FROM prices WHERE id=0");
			} else {
			$result = mysqli_query($conn, "SELECT * FROM prices WHERE id=1");
			}
        		if(!$result) {
        		error_log($conn->error);
        		}
			$row = mysqli_fetch_assoc($result);
        		$kmRate = $row['km'];
        		
        		$timeRate = $row['time'];
        		$baseRate = $row['base'];
	    		
        		$result = mysqli_query($conn, "SELECT * FROM booking WHERE reference='".$_GET['ref']."' ORDER BY spatula_id DESC LIMIT 0,1");
			$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'];
        		$xero = $row['xero_inv'];
        		$minsTo = "";
        		if($xero == "") {
			$xero = "none";
			}
        		$booking_date = $row['booking_date'];
        		$booking_time = $row['booking_time'];
        		$quote = $row['quote'];
        		$cid = $row['cid'];
        		$result = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
			$row = mysqli_fetch_assoc($result);
			$name = $row['name'];
			$phone = $row['mobile'];
			error_log($conn->error);
			$result = mysqli_query($conn, "SELECT * FROM customer_tokens WHERE cid='".$cid."'");
			$row = mysqli_fetch_assoc($result);
			$token = $row['access_token_value'];
        		
        			
        		$url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_ia?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs";
			$curlObj = curl_init();
			curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);

$response = curl_exec($curlObj);

curl_close($curlObj);
	
			$array = json_decode($response, true);

date_default_timezone_set("Australia/Perth");
                        //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y');
       			$booking = $booking_date." ".$booking_time;
       			$booking = strtotime($booking);
		       	
       			$time1 = $array['tasks']['items'][0]['completed']['time']/1000;
       			if($time1 == "") {
       			$time1 = $booking;
       			}
		       	$time2 = $array['tasks']['items'][1]['completed']['time']/1000;
       				if($time2 == "") {
       					$time2 = time();
       				}
       			
       			if($_GET['type']=="HK") {
       			$grace = 5;
       			} else {
       			$grace = 10;
       			}
       			$diff = $time2-$time1;
       			$timeEstimate = $quote_time + $grace;
       	
    				$Res['diff'] = ceil($diff/60);
    				$Res['time1'] = date('d/m/Y H:i', $time1);
    				$Res['time2'] = date('d/m/Y H:i', $time2);
    				
    				//echo '<div style="margin-left: 10px">';
    				//echo "Start Time = ".$Res['time1'];
    				//echo "<br>";
    				//echo "End Time = ".$Res['time2'];
    				//echo "<br>";
    				//echo "Difference = ".$Res['diff']."mins";
    				//echo "<br>";
    				//echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms";
    				//echo "<br>";
    				$charge = ceil($Res['diff']-$timeEstimate)*$timeRate;
    				//echo "Charge + $".$charge;
    				//echo "<br>";
    				//echo '<button name="update" id="update"><span id="updatetext">Change</span></button>';
    				//echo "</div>";
    				
    			$result = mysqli_query($conn, "SELECT promo_code FROM customers WHERE id='".$cid."'");
			$row = mysqli_fetch_assoc($result);
			if($row['promo_code'] != ""){
			$promo_code = $row['promo_code'];
			$result = mysqli_query($conn, "SELECT value FROM promo_codes WHERE code='".$promo_code."'");
			if($result->num_rows > 0) {
			$row = mysqli_fetch_assoc($result);
			$promo_value = $row['value'];
			
			} else {
			if(substr($_REQUEST['promo_code'], 0, 2) === "RF"){
  				$sql = "SELECT * FROM referrals where code = '".$promo_code."'";
				$result = $conn->query($sql);
				if ($result->num_rows > 0) {
				$row = $result->fetch_assoc();
				$promo_value = $row['value'];
				}
				}
			}
			}
			
        		
        			
        			
        			
        			
}
if($_GET['type']=="FA" OR $_GET['type']=="SA") {
$type = "FamilyCab Taxi Service";
$item = "FA";
$dbhost = "localhost";
$dbuser = "perthdes_fam_app";
$dbpass = "TW#7CCqKReDn";
$dbname = "perthdes_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='".$_GET['ref']."' ORDER BY spatula_id DESC LIMIT 0,1");
			$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'];
        		$xero = $row['xero_inv'];
        		if($xero == "") {
			$xero = "none";
			}
			$minsTo = $row['mins_to'];
        		$booking_date = $row['booking_date'];
        		$booking_time = $row['booking_time'];
        		$quote = $row['quote'];
        		$cid = $row['cid'];
        		$result = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'");
			$row = mysqli_fetch_assoc($result);
			$name = $row['name'];
			$phone = $row['mobile'];
			error_log($conn->error);
			$result = mysqli_query($conn, "SELECT * FROM customer_tokens WHERE cid='".$cid."'");
			$row = mysqli_fetch_assoc($result);
			$token = $row['access_token_value'];
        		
        		$url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs";
			$curlObj = curl_init();
			curl_setopt($curlObj, CURLOPT_URL, $url);
			curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);

$response = curl_exec($curlObj);

curl_close($curlObj);
	
			$array = json_decode($response, true);

if($token != "") {
$tokenCheck = "yes";
} else {
$tokenCheck = "no";
}

if($booking_date != "none") {
$format = "d/m/Y";
$booking_date = date($format, strtotime($booking_date));

}
if($minsTo == "" || $minsTo == "N/A") {
$minsTo = "none";
}

$invname = $name;
if(!isset($pickup)) {
$pickup = $_GET['pickup'];
}
if(!isset($dropoff)) {
$dropoff = $_GET['dropoff'];
}

$invdesc = "$type
$pickup
TO
$dropoff";

if(isset($_GET['invdesc'])) {
$invdesc = $_GET['invdesc'];
}
if($quote == "") {
$quote = $_GET['amount'];
}

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    
    <title>Process Payment</title>

<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
	
    <link async rel="stylesheet" href="assets/intlTelInput.css">

<style>
        #map {
            height:300px;
        }
        body{
            background-color: #d9d9d9;
            overflow-x: hidden;
        }
        .phone_error {
display:none;
color:#a94442;
margin-bottom: 2px;
margin-top: 5px;
}
.lat_error_pickup {
display:none;
color:#a94442;
margin-bottom: 10px;
margin-top: 5px;
}
.box {
display:none;
} 
.smallButton{
width: 100%;
}
.flightDiv {
display: none;
}
.discount, .referral {
display:none;
color:#ff0000;
}
.used {
display: none;
color:#ff0000;
}
.btn {
border-radius: 0 !important;
}
.invoiceDiv {
display: none;
}
.editTime {
display: none;
}
.fullWidth {

text-align: center;
background:#FFFFFF;
display: block;
}
.tolls {
display:none;
}

</style>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
     <script type="text/javascript">
function setDecimal(input) {
  input.value = parseFloat(input.value).toFixed(2);
}

</script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-xs-12 ">
            <h3></h3>
        </div>
    </div>
</div>
<div class="container">
    <form role="search" id="form1" method="POST" onSubmit="myButton.disabled = true; $('#buttontext').text('Processing...'); return true;" action="thankyouTest.php" data-eway-encrypt-key="<?=$client_key?>">
    <input type="hidden" name="submit_form" value="1">
    <input type="hidden" id="redirecturl" name="redirecturl" value="">
    <input type="hidden" id="url" name="url" value=<?=$actual_link?>>
     <input type="hidden" id="referral" name="referral" value=<?=$claim?>>
    
    <div class="used col-xs-12 col-md-6">This reference already has a payment applied</div>

<div class="row">		
		<div id="termPerth1" class="btn-group col-xs-12 col-md-6" data-toggle="buttons">
  			<label class="col-xs-12 col-md-4 btn btn-primary ">
    				<input type="radio" name="payment_type" id="payment_type1" value="card" autocomplete="off">Credit Card
  			</label>
  			<label class="col-xs-12 col-md-4 btn btn-primary active">
    				<input type="radio" name="payment_type" id="payment_type2" value="token" autocomplete="off" active><span id="tokenText">Stored Card</span>
 			</label>
  			<label class="col-xs-12 col-md-4 btn btn-primary">
    				<input type="radio" name="payment_type" id="payment_type3" value="account" autocomplete="off">Account/Cash
  			</label>
		</div>
		
		
                </div>
                <div class="row times" style="margin-top: 10px">
                
                <div class="col-xs-6 col-md-6 startTime">
                <p class="fullWidth">Start Time <br>
                <span class"fullWidth" id="startId"></span></p>
                </div>
                <div class="col-xs-6 col-md-6 editTime">
                             
               
                    	<div class='input-group date' id="date-group"><input type="text"  class="form-control"   name="date" id="date" placeholder="Date"><span class="input-group-addon">
                        <span class="glyphicon glyphicon-calendar"></span></div>
                        
                
                
                   	<div class="input-group bootstrap-timepicker timepicker">
                    	<input id="time" type="text" name="time"  class="form-control input-small">
            		<span class="input-group-addon"><i class="glyphicon glyphicon-time"></i></span>
            
        		
                  	       
                </div>
                <p class="flightDiv">Flight Arrival Time</p>
                </div>
                <div class="col-xs-6 col-md-6">
                <p class="fullWidth">Finish Time <br>
                <span class"fullWidth" id="finishId"></span></p>
                </div>
                </div>
                
                <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                <table class="table">
    <thead>
      <tr>
      	<th></th>
        <th>Est. <span class="flightDiv">inc. <?=$minsTo?> mins</span></th>
        <th>Act.</th>
        <th>Adjustment</th>
      </tr>
    </thead>
    <tbody>
      <tr>
      	<td>Time.</td>
        <td><input type="text"  class="form-control" id="timeEst" placeholder="" maxlength="20" autocomplete="off" name="timeEst" value="<?=$timeEstimate + $minsTo?>"></td>
        <td><input type="text"  class="form-control" id="timeAct" placeholder="" maxlength="20" autocomplete="off" name="timeAct" value="<?=$Res['diff']?>"></td>
        <td><button type="button" class="btn btn-primary smallButton" name="update" id="update"><span id="updatetext">+ $<?=$charge?></span></button></td>
      </tr>
      <tr>
      	<td>Km</td>
        <td><input type="text"  class="form-control" id="kmEst" placeholder="" maxlength="20" autocomplete="off" name="kmEst" value="<?=$quote_km?>"></td>
        <td><input type="text"  class="form-control" id="kmAct" placeholder="kms" maxlength="20" autocomplete="off" name="kmAct" value=""></td>
        <td><button type="buton" class="btn btn-primary smallButton" name="updateKM" id="updateKM"><span id="updatetextKM">+ $0.00</span></button></td>
      </tr>
      
    </tbody>
  </table>
                </div>
                
                </div>
                
                
                <div class="row" style="margin-top: 10px">
                
                <div class="col-xs-12 col-md-6">
                
                
                
<div class="input-group">
  <span class="input-group-addon"><i class="glyphicon glyphicon-usd"></i></span>
                    <input type="text" required class=" form-control" id="amount" name="amount" placeholder="Amount 0.00" value="<?=number_format($quote*$promo_value, 2)?>" onchange="setDecimal(this)">
</div>

<div class="discount">Promotional discount applied</div>
                    <div class="referral">$<?=$claim?> Referral credit applied</div>
                </div>
                <div class="col-xs-12 col-md-6 tolls">
                <div class="input-group">
  					<span class="input-group-addon"><i class="glyphicon glyphicon-road"></i></span>
                <input type="text" class=" form-control" id="tollAmount" name="tollAmount" placeholder="Amount 0.00" value="<?=number_format($tollQuote, 2)?>" onchange="setDecimal(this)">
                </div>
                </div>
                
                
                </div>
                
                <div class="row" style="margin-top: 10px">
                    
 					<div class="col-xs-12 col-md-6">
                    <input type="text"  class="admin form-control" id="reference" placeholder="Reference" maxlength="20" autocomplete="off" name="reference" value="<?=$reference?>">
                
                </div>
                 </div>
                <div class="row" style="margin-top: 0px">
                <div class="col-xs-12 col-md-6">
                    <input type="text"  class=" form-control" id="email" placeholder="E-mail - Not Required" maxlength="50" autocomplete="off" name="email">
                </div>
               
              
            </div>
            <div class="box card" id="card_div">
              <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                    <input type="text"  class=" form-control" id="fullname" placeholder="Full Name" maxlength="20" autocomplete="off" name="fullname" value="<?=$name?>">
                </div></div>
                
              <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                    <input type="text" class=" form-control" id="EWAY_CARDNUMBER" placeholder="Credit Card Number" maxlength="20" autocomplete="off" name="EWAY_CARDNUMBER" data-eway-encrypt-name="EWAY_CARDNUMBER">
                </div></div><div class="row" style="margin-top: 10px">
                <div class="col-xs-6 col-md-3">
                    <input type="text" class=" form-control" id="EWAY_CARDCVN" placeholder="CVN" maxlength="4" autocomplete="off" name="EWAY_CARDCVN" data-eway-encrypt-name="EWAY_CARDCVN">
                </div>

</select>

<select id="EWAY_CARDEXPIRYYEAR" name="EWAY_CARDEXPIRYYEAR">
            <option value="17">2017</option>
            <option value="18">2018</option>
            <option value="19">2019</option>
            <option value="20">2020</option>
            <option value="21">2021</option>
            <option value="22">2022</option>
            <option value="23">2023</option>
            <option value="24">2024</option>
            <option value="25">2025</option>
            <option value="26">2026</option>
            <option value="27">2027</option>
        </select>
        
                </div></div>
                <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                <input type="checkbox" id="saveCustomer" name="saveCustomer" value="yes"> Save Customer Details?<br>
                </div></div>
<div class="save_customer" style="display:none;">
<div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                    <input type="tel"  class=" form-control" id="phone" placeholder="Phone" maxlength="20" autocomplete="off" name="phone" >
                    <div class="phone_error">Invalid phone number format</div>
                </div></div>
                <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                    <input type="text"  class=" form-control" id="homeaddress" placeholder="Home Address" autocomplete="off" name="homeaddress">
                </div>

</div>
            </div>

</div>
        <div class="box token" id="token_div">
              <div class="row" style="margin-top: 10px">
                <div class="col-xs-12 col-md-6">
                    <input type="text" class=" form-control" id="token" placeholder="Token" maxlength="200" autocomplete="off" name="token" value="<?=$token?>">
                </div>
                
                
                <div class="col-xs-12 col-md-6">
                    <button class="col-xs-12 col-md-6" id="tokenupdate" name="tokenupdate" type="button"><h5>Update Token</h5></button>
                    </div>

</div></div>
        
        	
            <div class="row" style="margin-top: 10px">
<div class="col-xs-12 col-md-6"><button class="col-xs-12 col-md-6" id="invoiceButton" type="button"><h5>Invoice Details</h5></button></div></div>
<div class="invoiceDiv">
<div class="row" style="margin-top: 10px">
<div class="col-xs-12 col-md-6">

Job Type<br><select id="type" name="type">
            <option value="DD" <?php if ($item =='DD') echo 'selected="selected"';?>>Designated Driver</option>
            <option value="FC" <?php if ($item =='FC') echo 'selected="selected"';?>>FamilyCab</option>     
            <option value="SI" <?php if ($item =='SI') echo 'selected="selected"';?>>Std Insured HomeKey</option>     
            <option value="HK" <?php if ($item =='HK') echo 'selected="selected"';?>>HomeKey Driver</option>
            <option value="FA" <?php if ($item =='FA') echo 'selected="selected"';?>>FamilyCab App</option>
            <option value="SF" <?php if ($item =='SF') echo 'selected="selected"';?>>FamilyCab Sydney</option>
            <option value="SA" <?php if ($item =='SA') echo 'selected="selected"';?>>FamilyCab App Sydney</option>          
        </select> <br>
        Billing Name<br></div></div>
        <div class="row" style="margin-top: 10px">
        <div class="col-xs-12 col-md-6">
        <input type="text"  class=" form-control" id="invname" placeholder="Billing Name" maxlength="30" autocomplete="off" name="invname" value="<?php if(!isset($name)) {
        echo 'cash';
        } else {
        echo $invname;
        }?>"></div></div>
        <div class="row" style="margin-top: 10px; margin-bottom: 20px;">
        <div class="col-xs-12 col-md-6">
         Invoice Description<br><textarea placeholder="eg: Greenwood to Karrinyup" style="height:70px;" name="invdesc" id="invdesc" class="form-control"><?php if (isset($invdesc)) echo $invdesc;?></textarea>
         
         </div></div>
         </div>
         <div class="row" style="margin-top: 10px"> 
            <div class="col-xs-12 col-md-6 ">
                
                    <button name="myButton" class="btn btn-primary col-xs-12 col-md-6" id="testLatLng"><span id="buttontext" >Submit</span></button>
                
            </div></div>
           <div class="row" style="margin-top: 10px, margin-bottom: 20px;">
            <div class="col-xs-12 col-md-6 " style="color: #d9d9d9">
            <p>help </p>
            </div>
            </div>
        </form>

</div>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>

$("#phone").intlTelInput({
      // allowDropdown: false,
      autoHideDialCode: true,
      // autoPlaceholder: "off",
      // dropdownContainer: "body",
      // excludeCountries: ["us"],
      formatOnDisplay: true,
       geoIpLookup: function(callback) {
        $.get("http://ipinfo.io", function() {}, "jsonp").always(function(resp) {
           var countryCode = (resp && resp.country) ? resp.country : "";
           callback(countryCode);
         });
       },
       initialCountry: "au",
      nationalMode: false,
      // onlyCountries: ['us', 'gb', 'ch', 'ca', 'do'],
      placeholderNumberType: "Mobile",
       preferredCountries: ['au', 'nz', 'cn', 'id', 'my'],
      separateDialCode: true,
      utilsScript: "assets/utils.js"
    });
    
    $('#phone').on('change', function () {
if($("#phone").intlTelInput("isValidNumber") == true) { 
  var intlNumber = $("#phone").intlTelInput("getNumber");
    $('#phone').val( intlNumber );
   $('.phone_error').hide();
   return true;;
    } else {
    $("#phone").val("");
    $('.phone_error').show();
    return false;;
    }
   })

var tokenCheck = "<?=$tokenCheck?>";
var kmChange = 0;
var name = "<?=$name?>";
$(document).ready(function(){

var admin = "<?=$admin?>";

var promo_code = "<?=$promo_code?>";
var claim = "<?=$claim?>";

var used = "<?=$xero?>";

var startTime = "<?=$Res['time1']?>";
var finishTime = "<?=$Res['time2']?>";
var minsTo = "<?=$minsTo?>";

var type = "<?=$_GET['type']?>";

if(type == "SA" || type == "SF") {
	$('.tolls').show();
}
if(minsTo != "none") {
$('.flightDiv').show();
}

$(".times").hide();
if(startTime != "") {
$(".times").show();
$('#startId').text(startTime);
$('#finishId').text(finishTime);
}

if(admin == "no") {
$(".admin").hide();
}

if(tokenCheck == "no") {
$('#tokenText').text("No Stored Card Details");
$('#payment_type[value="token"]').hide();  
}

if(promo_code != 1){
	$(".discount").show();
	}
if(claim != "none"){
	$(".referral").show();
	var quote = $('#amount').val();
    	quote = parseFloat(quote) - parseFloat(claim);
    	$('#amount').val(parseFloat(quote).toFixed(2));
	}
if(used != "none") {
$(".used").show()
$("#testLatLng").attr("disabled", true);
$("#buttontext").text("Already Processed");
}

if($("#token").val() == "") {
            	$(".box").not(".card").hide();

$(".card").show();
            $("#payment_type1").prop("checked", true);
		$("#payment_type1").parent(".btn").addClass("active");
		$("#payment_type2").parent(".btn").removeClass("active");
		$("#payment_type3").parent(".btn").removeClass("active");
		}

if($("#token").val() != "") {
$(".box").not(".token").hide();

$(".token").show();
            $("#payment_type2").prop("checked", true);
            $("#payment_type1").parent(".btn").removeClass("active");
            $("#payment_type2").parent(".btn").addClass("active");
            $("#payment_type3").parent(".btn").removeClass("active");
            }
if($("#token").val() == "account") {
		$(".box").not(".card").hide();
        $(".box").not(".token").hide();
        $("#payment_type3").prop("checked", true);
        	$("#payment_type1").parent(".btn").removeClass("active");	
        	$("#payment_type2").parent(".btn").removeClass("active");
		$("#payment_type3").parent(".btn").addClass("active");
		}

$("#saveCustomer").click(function(){
if(this.checked){
$(".save_customer").show();
var phone = "<?=$phone?>";
if(phone == "1") {
phone = "";
}
$('#phone').val(phone);
} else {
$(".save_customer").hide();
}
});

$("#tokenupdate").click(function() {
	var name = "<?=$name?>";
	var token = "<?=$token?>";
	var url = $("#url").val();
	url = encodeURIComponent(url);
	
	
	if(tokenCheck == "no") {
	alert("No Token Available");
	} else {
	var data = "https://bookings.perthdesignateddrivers.com.au/payment/tokenUpdate.php?&cardName=" + name + "&token=" + token + "&url=" + url;
	window.location = data;
	}
	})

});
    var charge = <?=$charge?>;
    if(charge != "0"){
    $('#update').click(function() {
    	var quote = $('#amount').val();
    	quote = charge + + quote;
    	$('#amount').val(parseFloat(quote).toFixed(2));
    	$('#update').attr("disabled", "disabled");
    	})
    	
    }
    $('#updateKM').click(function() {
    	var quote = $('#amount').val();
    	quote = parseFloat(quote) + kmChange;
    	$('#amount').val(parseFloat(quote).toFixed(2));
    	$('#updateKM').attr("disabled", "disabled");
    	})
    	
    $('.startTime').click(function() {
    	$('.startTime').hide()
    	$('.editTime').show()
    	var bookingDate = "<?=$booking_date?>";
	var bookingTime = "<?=$booking_time?>";

if(bookingDate != "none") {
		var date_input=$("#date"); //our date input has the name "date"
        	var container=$('.bootstrap-iso form').length>0 ? $('.bootstrap-iso form').parent() : "body";
        		date_input.datepicker({
       			//startDate: new Date(),
       		
		            format: 'dd/mm/yyyy',
		            container: container,
		            todayHighlight: true,
		            autoclose: true,
		            datesDisabled: '25/12/2018',
            
        		})
        date_input.val(bookingDate);
        if(bookingTime.indexOf("AM") == -1 && bookingTime.indexOf("PM") == -1) {
        var timestring = new Date("01/01/1970 " + bookingTime);
        console.log(timestring);
        var hours = timestring.getHours();
        var mins = timestring.getMinutes();
        var day = "AM";
        if(hours > 11) {
        day = "PM";
        }
        if(hours >= 13) {
        hours = hours - 12;       
        }
        if(hours == "00") {
        hours == "12";
        }
        var bookingTime = hours + ":" + mins + " " + day;
        }
 	$('#time').val(bookingTime);
 	updateActTime();
}
    })
    
    function updateActTime() {
    
    var startTime = "<?=$time1?>";
    var endTime = "<?=$time2?>";
    if(endTime != "") {
    endTime = new Date(parseInt(endTime) * 1000);
    }
    
    var act = $('#timeAct').val();
    
    if($('#date').val() != '') {
    	var newDate = $('#date').val();
    	var dateSplit = newDate.split("/");
    	var newTime = $('#time').val();
    	newTime = newTime.replace(":", " ");
    	var timeSplit = newTime.split(" ");
    	var hours = timeSplit[0];
    	if(timeSplit[2] == "AM" && hours == "12") {
    	hours = "0";
    	}
    	if(timeSplit[2] == "PM" && hours != "12") {
    	hours = parseInt(hours) + 12;
    	}
    	startTime = new Date(dateSplit[2], (dateSplit[1] - 1), dateSplit[0], hours, timeSplit[1]);
    	
    	act = parseFloat((endTime.getTime() - startTime.getTime()) / 60 / 1000).toFixed(0);
    	$('#timeAct').val(act)
    }
    
    var rate = "<?=$timeRate?>";
    var est = $('#timeEst').val();
    
    
    charge = parseFloat((act - est) * rate).toFixed(1);
    var changeText = "+ $" + charge;
        $("#updatetext").text(changeText);
    }
    
    $('#time').timepicker().on('changeTime.timepicker', function(e) {
    updateActTime();
    });
    
    $('#timeAct, #date, #time').change(function() {
    updateActTime();
    })
    
    $('#invoiceButton').click(function() {
    $('.invoiceDiv').show();
    })
    if(name == "") {
    $('.invoiceDiv').show();
    }
    
    $('input[name="payment_type"]').change(function(){
	var radioValue = $("input[name='payment_type']:checked").val();
        if(radioValue=="card"){

$(".box").not(".card").hide();

$(".card").show();

}

if(radioValue=="token" && tokenCheck != "no"){

$(".box").not(".token").hide();

$(".token").show();

}
        if(radioValue=="account"){
        $(".box").not(".card").hide();
        $(".box").not(".token").hide();
        }

});
    
    function initAutocomplete() {
        var perthBounds = new google.maps.LatLngBounds(new google.maps.LatLng(-32.787777, 115.556739), new google.maps.LatLng(-31.159266, 116.545509));

pickup = new google.maps.places.Autocomplete((document.getElementById('homeaddress')),{types: ['geocode','establishment'],
            componentRestrictions:{country:"au"}, bounds: perthBounds, strictBounds: true,});
        pickup.addListener();
        pickup.addListener('place_changed', function() {
           
        });
        }
        
        $("#kmAct").on('keyup', function () {
        var est = $("#kmEst").val();
        var kms = $("#kmAct").val();
        var rate = "<?=$kmRate?>";
        var change = Math.ceil((kms - est) * rate);
        kmChange = change;
        var changeText = "+ $" + change;
        $("#updatetextKM").text(changeText);
        })

</script>
<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCq_JZBDbrE5qma5SgF06M2dVAqbiZBZ-o&libraries=places,geometry&callback=initAutocomplete"   async defer></script>
</body>
</html>

connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $result = mysqli_query($conn, "SELECT * FROM prices WHERE id=0"); if(!$result) { error_log($conn->error); } $row = mysqli_fetch_assoc($result); $kmRate = $row['km']; $timeRate = $row['time']; $baseRate = $row['base']; $result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference='".$_GET['ref']."'"); if(!$result) { error_log($conn->error); } $row = mysqli_fetch_assoc($result); $quote = $row['job_quote']; $quote_km = $row['quote_km']; $quote_time = $row['quote_time']; $name = $row['job_name']; $pickup = $row['job_pickup']; $dropoff = $row['job_dropoff']; $phone = $row['job_phone']; $token = $row['token']; if($token == "" && $_GET['token'] != ""){ $token = $_GET['token']; } $xero = $row['xero_inv']; $spatula_id = $row['spat_ref']; $booking_date = $row['job_date']; $booking_time = $row['job_time']; if($xero == "") { $xero = "none"; } if($spatula_id != ""){ $url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs"; $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, $url); curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0); $response = curl_exec($curlObj); curl_close($curlObj); $array = json_decode($response, true); date_default_timezone_set("Australia/Perth"); //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y'); $booking_date = str_replace(",", "", $booking_date); $bookingTime = str_replace(" ", "", $booking_time); $booking = $booking_date." ".$bookingTime; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($time1 == "") { $time1 = $booking; } $time2 = $array['tasks']['items'][1]['completed']['time']/1000; if($time2 == "") { $time2 = time(); } $grace = 5; $diff = $time2-$time1; $timeEstimate = $quote_time + $grace; $Res['diff'] = ceil($diff/60); $Res['time1'] = date('d/m/Y H:i', $time1); $Res['time2'] = date('d/m/Y H:i', $time2); //echo '

'; //echo "Start Time = ".$Res['time1']; //echo "
"; //echo "End Time = ".$Res['time2']; //echo "
"; //echo "Difference = ".$Res['diff']."mins"; //echo "
"; //echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms"; //echo "
"; $charge = ceil($Res['diff']-$timeEstimate); //echo "Charge + $".$charge; //echo "
"; //echo ''; //echo "

"; } } if($_GET['type']=="FC" or $_GET['type']=="SF") { $type = "FamilyCab Taxi Service"; $item = $_GET['type']; $dbhost = "localhost"; $dbuser = "perthdes_famcab"; $dbpass = "C]+6wQySxov("; $dbname = "perthdes_familycab"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $price_code = "1"; if($_GET['type']=="SF") { $price_code = "0"; } $result = mysqli_query($conn, "SELECT * FROM prices WHERE id='".$price_code."'"); if(!$result) { error_log($conn->error); } $row = mysqli_fetch_assoc($result); $kmRate = $row['km']; $largeKmRate = $row['large_km']; $timeRate = $row['time']; $baseRate = $row['base']; $result = mysqli_query($conn, "SELECT * FROM jobs WHERE reference='".$_GET['ref']."'"); $row = mysqli_fetch_assoc($result); $quote = $row['job_quote']; $quote_km = $row['quote_km']; $quote_time = $row['quote_time']; $name = $row['job_name']; $phone = $row['job_phone']; $pickup = $row['job_pickup']; $dropoff = $row['job_dropoff']; $token = $row['token']; $minsTo = $row['mins_post']; $booking_date = $row['job_date']; $booking_time = $row['job_time']; if($token=="" && $_GET['token'] != ""){ $token = $_GET['token']; } $xero = $row['xero_inv']; $spatula_id = $row['spat_ref']; if($xero == "") { $xero = "none"; } $minsTo = ""; $url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs"; $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, $url); curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0); $response = curl_exec($curlObj); curl_close($curlObj); $array = json_decode($response, true); date_default_timezone_set("Australia/Perth"); //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y'); $booking_date = str_replace(",", "", $booking_date); $bookingTime = str_replace(" ", "", $booking_time); $booking = $booking_date." ".$bookingTime; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($time1 == "") { $time1 = $booking; } $time2 = $array['tasks']['items'][1]['completed']['time']/1000; if($time2 == "") { $time2 = time(); } $grace = 5; $diff = $time2-$time1; $timeEstimate = $quote_time + $grace; $Res['diff'] = ceil($diff/60); $Res['time1'] = date('d/m/Y H:i', $time1); $Res['time2'] = date('d/m/Y H:i', $time2); //echo '

'; //echo "Start Time = ".$Res['time1']; //echo "
"; //echo "End Time = ".$Res['time2']; //echo "
"; //echo "Difference = ".$Res['diff']."mins"; //echo "
"; //echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms"; //echo "
"; $charge = ceil($Res['diff']-$timeEstimate)*$timeRate; //echo "Charge + $".$charge; //echo "
"; //echo ''; //echo "

"; } if($_GET['type']=="HK" OR $_GET['type']=="SI") { $type = "HomeKey Designated Driver Service"; $item = $_GET['type']; $dbhost = "localhost"; $dbuser = "perthdes_inquiri"; $dbpass = "@G&{)0*&Ts^V"; $dbname = "perthdes_new_pro_api"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); if($_GET['type']=="HK") { $result = mysqli_query($conn, "SELECT * FROM prices WHERE id=0"); } else { $result = mysqli_query($conn, "SELECT * FROM prices WHERE id=1"); } if(!$result) { error_log($conn->error); } $row = mysqli_fetch_assoc($result); $kmRate = $row['km']; $timeRate = $row['time']; $baseRate = $row['base']; $result = mysqli_query($conn, "SELECT * FROM booking WHERE reference='".$_GET['ref']."' ORDER BY spatula_id DESC LIMIT 0,1"); $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']; $xero = $row['xero_inv']; $minsTo = ""; if($xero == "") { $xero = "none"; } $booking_date = $row['booking_date']; $booking_time = $row['booking_time']; $quote = $row['quote']; $cid = $row['cid']; $result = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'"); $row = mysqli_fetch_assoc($result); $name = $row['name']; $phone = $row['mobile']; error_log($conn->error); $result = mysqli_query($conn, "SELECT * FROM customer_tokens WHERE cid='".$cid."'"); $row = mysqli_fetch_assoc($result); $token = $row['access_token_value']; $url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_ia?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs"; $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, $url); curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0); $response = curl_exec($curlObj); curl_close($curlObj); $array = json_decode($response, true); date_default_timezone_set("Australia/Perth"); //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y'); $booking = $booking_date." ".$booking_time; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($time1 == "") { $time1 = $booking; } $time2 = $array['tasks']['items'][1]['completed']['time']/1000; if($time2 == "") { $time2 = time(); } if($_GET['type']=="HK") { $grace = 5; } else { $grace = 10; } $diff = $time2-$time1; $timeEstimate = $quote_time + $grace; $Res['diff'] = ceil($diff/60); $Res['time1'] = date('d/m/Y H:i', $time1); $Res['time2'] = date('d/m/Y H:i', $time2); //echo '

'; //echo "Start Time = ".$Res['time1']; //echo "
"; //echo "End Time = ".$Res['time2']; //echo "
"; //echo "Difference = ".$Res['diff']."mins"; //echo "
"; //echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms"; //echo "
"; $charge = ceil($Res['diff']-$timeEstimate)*$timeRate; //echo "Charge + $".$charge; //echo "
"; //echo ''; //echo "

"; $result = mysqli_query($conn, "SELECT promo_code FROM customers WHERE id='".$cid."'"); $row = mysqli_fetch_assoc($result); if($row['promo_code'] != ""){ $promo_code = $row['promo_code']; $result = mysqli_query($conn, "SELECT value FROM promo_codes WHERE code='".$promo_code."'"); if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $promo_value = $row['value']; } else { if(substr($_REQUEST['promo_code'], 0, 2) === "RF"){ $sql = "SELECT * FROM referrals where code = '".$promo_code."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); $promo_value = $row['value']; } } } } } if($_GET['type']=="FA" OR $_GET['type']=="SA") { $type = "FamilyCab Taxi Service"; $item = "FA"; $dbhost = "localhost"; $dbuser = "perthdes_fam_app"; $dbpass = "TW#7CCqKReDn"; $dbname = "perthdes_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='".$_GET['ref']."' ORDER BY spatula_id DESC LIMIT 0,1"); $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']; $xero = $row['xero_inv']; if($xero == "") { $xero = "none"; } $minsTo = $row['mins_to']; $booking_date = $row['booking_date']; $booking_time = $row['booking_time']; $quote = $row['quote']; $cid = $row['cid']; $result = mysqli_query($conn, "SELECT * FROM customers WHERE id='".$cid."'"); $row = mysqli_fetch_assoc($result); $name = $row['name']; $phone = $row['mobile']; error_log($conn->error); $result = mysqli_query($conn, "SELECT * FROM customer_tokens WHERE cid='".$cid."'"); $row = mysqli_fetch_assoc($result); $token = $row['access_token_value']; $url = "https://api.fleeteng.com.au/v2/graph/role/jobs/$spatula_id?access_token=9olkJkrIcttN8Zlh1lgAch70KFC_nJiIpUiCeaBMswbs"; $curlObj = curl_init(); curl_setopt($curlObj, CURLOPT_URL, $url); curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0); $response = curl_exec($curlObj); curl_close($curlObj); $array = json_decode($response, true); date_default_timezone_set("Australia/Perth"); //$booking_date = date_format(date_create_from_format('d/m/Y', $booking_date), 'd-m-Y'); $booking = $booking_date." ".$booking_time; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($time1 == "") { $time1 = $booking; } $time2 = $array['tasks']['items'][1]['completed']['time']/1000; if($time2 == "") { $time2 = time(); } $grace = 5; $diff = $time2-$time1; $timeEstimate = $quote_time + $grace; $Res['diff'] = ceil($diff/60); $Res['time1'] = date('d/m/Y H:i', $time1); $Res['time2'] = date('d/m/Y H:i', $time2); //echo '

'; //echo "Start Time = ".$Res['time1']; //echo "
"; //echo "End Time = ".$Res['time2']; //echo "
"; //echo "Difference = ".$Res['diff']."mins"; //echo "
"; //echo "Estimated = ".$timeEstimate."mins ".$quote_km."kms"; //echo "
"; $charge = ceil($Res['diff']-$timeEstimate)*45/60; //echo "Charge + $".$charge; //echo "
"; //echo ''; //echo "

"; $result = $conn->query("SELECT * FROM credits WHERE customer_id='".$cid."' and is_used = 0"); if($result->num_rows > 0) { $row = $result->fetch_assoc(); $claim = $row["value"]; } else { $result = mysqli_query($conn, "SELECT promo_code FROM customers WHERE id='".$cid."'"); $row = mysqli_fetch_assoc($result); if($row['promo_code'] != ""){ $promo_code = $row['promo_code']; $result = mysqli_query($conn, "SELECT value FROM promo_codes WHERE code='".$promo_code."'"); if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $promo_value = $row['value']; } else { if(substr($promo_code, 0, 2) === "RF"){ $sql = "SELECT * FROM referrals where code = '".$promo_code."'"; $result = $conn->query($sql); if ($result->num_rows > 0) { $row = $result->fetch_assoc(); $promo_value = $row['value']; } } } } } $result = mysqli_query($conn, "SELECT * FROM prices WHERE id=1"); if(!$result) { error_log($conn->error); } $row = mysqli_fetch_assoc($result); $kmRate = $row['km']; $largeKmRate = $row['large_km']; $timeRate = $row['time']; $baseRate = $row['base']; } if($token != "") { $tokenCheck = "yes"; } else { $tokenCheck = "no"; } if($booking_date != "none") { $format = "d/m/Y"; $booking_date = date($format, strtotime($booking_date)); } if($minsTo == "" || $minsTo == "N/A") { $minsTo = "none"; } $invname = $name; if(!isset($pickup)) { $pickup = $_GET['pickup']; } if(!isset($dropoff)) { $dropoff = $_GET['dropoff']; } $invdesc = "$type $pickup TO $dropoff"; if(isset($_GET['invdesc'])) { $invdesc = $_GET['invdesc']; } if($quote == "") { $quote = $_GET['amount']; } ?> Process Payment

> >

This reference already has a payment applied

Credit Card Stored Card Account/Cash

Start Time

Flight Arrival Time

Finish Time

	Est. inc. mins	Act.	Adjustment
Time.
Km

Promotional discount applied

$ Referral credit applied

Save Customer Details?

Job Type

Billing Name

Invoice Description

help