/home/desid573/public_html/angel/payment
Edit: /home/desid573/public_html/angel/payment/index.php (31236B)
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_id?access_token=".$vromo;
$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)*$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($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($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($pickup == "") {
$pickup = "Pick Up";
}
if(!isset($dropoff)) {
$dropoff = $_GET['dropoff'];
}
if($dropoff == "") {
$dropoff = "Destination";
}
$invdesc = "$type
$pickup
TO
$dropoff";
if(isset($_GET['invdesc'])) {
$invdesc = $_GET['invdesc'];
}
if($quote == "") {
$quote = $_GET['amount'];
}
?>
Process Payment