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/index1.php (34506B)

<?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";
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'];
        		$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?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);
	
			$json = json_decode($response, true);

$array = array_filter($json['items'], function($v) use ($spatula_id) {
				
                                           return $v['id'] == $spatula_id; });
                                           
                        $array = reset($array);
                        
                        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);
                        $booking_time = str_replace(" ", "", $booking_time);
       			$booking = $booking_date." ".$booking_time;
       			$booking = strtotime($booking);
		       	
		       	
		       	
       			$time1 = $array['tasks']['items'][0]['completed']['time']/1000;
       			if($booking > $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") {
$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);
	    		$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'];
        		$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'];
        		$pickup = $row['job_pickup'];
        		$dropoff = $row['job_dropoff'];
        		$token = $row['token'];
        		if($token=="" && $_GET['token'] != ""){
        		$token = $_GET['token'];
        		}
        		$xero = $row['xero_inv'];
        		$spatula_id = $row['spat_ref'];
        		if($xero == "") {
			$xero = "none";
			}
			
			$url = "https://api.fleeteng.com.au/v2/graph/role/jobs?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);
	
			$json = json_decode($response, true);

$array = array_filter($json['items'], function($v) use ($spatula_id) {
				
                                           return $v['id'] == $spatula_id; });
                                           
                        $array = reset($array);
                        
                        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);
                        $booking_time = str_replace(" ", "", $booking_time);
       			$booking = $booking_date." ".$booking_time;
       			$booking = strtotime($booking);
		       	
       			$time1 = $array['tasks']['items'][0]['completed']['time']/1000;
       			if($booking > $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'];
        		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'];
			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?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);
	
			$json = json_decode($response, true);

$array = array_filter($json['items'], function($v) use ($spatula_id) {
				
                                           return $v['id'] == $spatula_id; });
                                           
                        $array = reset($array);
                        
                        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($booking > $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."'");
			$row = mysqli_fetch_assoc($result);
			$promo_value = $row['value'];
			}
			
        		
        			
        			
        			
        			
}
if($_GET['type']=="FA" OR $_GET['type']=="NW") {
$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";
			}
        		$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'];
			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?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);
	
			$json = json_decode($response, true);

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

$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">

<style>
        #map {
            height:300px;
        }
        body{
            background-color: #d9d9d9;
        }
.lat_error_pickup {
display:none;
color:#a94442;
margin-bottom: 10px;
margin-top: 5px;
}
.box {
display:none;
} 
.smallButton{
width: 140px;
}
.discount {
display:none;
color:#ff0000;
}
.used {
display: none;
color:#ff0000;
}
.btn {
border-radius: 0 !important;
}
.invoiceDiv {
display: none;
}
.fullWidth {
width: 100%;
text-align: center;
background:#FFFFFF;
display: block;
}

</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="thankyou.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?>>
    
    <div class="used">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" style="margin-top: 10px">
                <div class="times">
                <div class="col-xs-6 col-md-6">
                <p class="fullWidth">Start Time <br>
                <span class"fullWidth" id="startId"></span></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.</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?>"></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 smallBtn" 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="button" class="btn btn-primary smallBtn" name="updateKM" id="updateKM"><span id="updatetextKM">+ $0.00</span></button></td>
      </tr>
      
    </tbody>
  </table>
                </div>
                </div>
                <div class="col-xs-12 col-md-6">
                
                
                
<div class="input-group">
  <span class="input-group-addon">$</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></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></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">Update Token</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="NW" <?php if ($item =='NW') echo 'selected="selected"';?>>Family Network App</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">
        <div class="col-xs-12 col-md-6">
         Invoice Description<br><textarea placeholder="eg: Greenwood to Karrinyup" style="width:100%;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="btn-block col-xs-12 col-md-6 ">
                
                    <button name="myButton" class="btn btn-primary col-xs-12 col-md-6  id="testLatLng"><span id="buttontext" style="display: block;">Submit</span></button>
                
            </div></div>
        </form>

</div>

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

var tokenCheck = "<?=$tokenCheck?>";
var kmChange = 0;

$(document).ready(function(){

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

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

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

var startTime = "<?=$Res['time1']?>";
var finishTime = "<?=$Res['time2']?>";
var name = "<?=$name?>";
$(".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(used != "none") {
$(".used").show()
$("#testLatLng").attr("disabled", true);
$("#buttontext").text("Already Processed");
}

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

$(".card").show();
		$("#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_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_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();
} else {
$(".save_customer").hide();
}
});

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

});
    var charge = <?=$charge?>;
    if(charge != "0"){
    $('#update').click(function() {
    	var quote = $('#amount').val();
    	quote = parseFloat(quote) + charge;
    	$('#amount').val(parseFloat(quote).toFixed(2));
    	})
    }
    $('#updateKM').click(function() {
    	var quote = $('#amount').val();
    	quote = parseFloat(quote) + kmChange;
    	$('#amount').val(parseFloat(quote).toFixed(2));
    	})
    
    $('#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']; $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?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); $json = json_decode($response, true); $array = array_filter($json['items'], function($v) use ($spatula_id) { return $v['id'] == $spatula_id; }); $array = reset($array); 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); $booking_time = str_replace(" ", "", $booking_time); $booking = $booking_date." ".$booking_time; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($booking > $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") { $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); $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']; $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']; $pickup = $row['job_pickup']; $dropoff = $row['job_dropoff']; $token = $row['token']; if($token=="" && $_GET['token'] != ""){ $token = $_GET['token']; } $xero = $row['xero_inv']; $spatula_id = $row['spat_ref']; if($xero == "") { $xero = "none"; } $url = "https://api.fleeteng.com.au/v2/graph/role/jobs?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); $json = json_decode($response, true); $array = array_filter($json['items'], function($v) use ($spatula_id) { return $v['id'] == $spatula_id; }); $array = reset($array); 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); $booking_time = str_replace(" ", "", $booking_time); $booking = $booking_date." ".$booking_time; $booking = strtotime($booking); $time1 = $array['tasks']['items'][0]['completed']['time']/1000; if($booking > $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']; 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']; 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?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); $json = json_decode($response, true); $array = array_filter($json['items'], function($v) use ($spatula_id) { return $v['id'] == $spatula_id; }); $array = reset($array); 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($booking > $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."'"); $row = mysqli_fetch_assoc($result); $promo_value = $row['value']; } } if($_GET['type']=="FA" OR $_GET['type']=="NW") { $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"; } $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']; 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?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); $json = json_decode($response, true); $array = array_filter($json['items'], function($v) use ($spatula_id) { return $v['id'] == $spatula_id; }); $array = reset($array); 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($booking > $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 "

This reference already has a payment applied

Credit Card Stored Card Account/Cash

Start Time

Finish Time

	Est.	Act.	Adjustment
Time.
Km

Promotional discount applied

Save Customer Details?

Job Type

Billing Name

Invoice Description