/home/desid573/public_html/payment
NameSizeModeActions
assets/-0755rm
eway-rapid-php-master/-0755rm
pdd/-0755rm
xero/-0755rm
xero-2/-0755rm
xero-php-oauth2-master/-0755rm
10.php19410644editdlrm
11.php9920644editdlrm
approved.php15130644editdlrm
a_name_address.php9310644editdlrm
checktime.php14360644editdlrm
driverCheck.php7940644editdlrm
eCrypt.js684240644editdlrm
eway-rapid-php-master.zip572700644editdlrm
eWay.php426970644editdlrm
index.php560450644editdlrm
index1.php345060644editdlrm
index15May.php483660644editdlrm
indexOLD.php417930644editdlrm
indexTest.php425170644editdlrm
payment-shutdown.log5170644editdlrm
quote.php72180644editdlrm
test.php18710644editdlrm
thankyou.php241440644editdlrm
thankyouOLD.php301100644editdlrm
thankyouTest.php219500644editdlrm
tokenUpdate.php106730644editdlrm
updatetoken.php36960644editdlrm
xero-2-2.zip28341780644editdlrm
Edit: /home/desid573/public_html/payment/index.php (56045B)
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']; $email = $row["job_email"]; $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.vromo.io/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_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 "
"; //check account $sql = "SELECT * FROM accounts WHERE input_name = '".$name."'"; $result = $conn->query($sql); if(!$result) { error_log("account lookup error ".$conn->error); } if($result->num_rows > 0) { $row = $result->fetch_assoc(); $name = $row["output_name"]; } } } if($_GET['type']=="FC" or $_GET['type']=="SF" or $_GET['type']=="BF" or $_GET['type']=="MF" or $_GET["type"] == "GC" or $_GET["type"] == "SC") { $type = "FamilyCab Taxi Service"; $item = $_GET['type']; $dbhost = "localhost"; $dbuser = "desid573_famcab"; $dbpass = "C]+6wQySxov("; $dbname = "desid573_familycab"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $price_code = "1"; if($_GET['type']!="FC") { $price_code = "0"; $result = mysqli_query($conn, "SELECT * FROM toll_estimates WHERE reference='".$reference."'"); if(!$result) { error_log($conn->error); } else { if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $tollAmount = $row['amount']; } } } $sql = "SELECT name FROM terminal_details"; $result = $conn->query($sql); $airportArray = []; while($row = $result->fetch_assoc()) { array_push($airportArray, $row["name"]); }; $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']; $email = $row["job_email"]; $phone = $row['job_phone']; $pickup = $row['job_pickup']; $dropoff = $row['job_dropoff']; $token = $row['token']; $minsTo = ""; $minsTo = $row['mins_post']; $booking_date = $row['job_date']; $booking_time = $row['job_time']; $pax = $row["job_pax"]; if($pax == "") { $pax = 1; } $rf = $row["job_rf"]; $ff = $row["job_ff"]; $boost = $row["job_boost"]; $seats = $rf + $ff + $boost; if($token=="" && $_GET['token'] != ""){ $token = $_GET['token']; } $xero = $row['xero_inv']; $spatula_id = $row['spat_ref']; if($xero == "") { $xero = "none"; } $url = "https://api.vromo.io/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_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 = "desid573_inquiri"; $dbpass = "@G&{)0*&Ts^V"; $dbname = "desid573_new_pro_api"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); 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 = 1.1; $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']; $email = $row["email"]; 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.vromo.io/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(); } 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($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" or $_GET['type']=="MA" or $_GET['type']=="BA" or $_GET["type"]=="GA" or $_GET["type"]=="YA") { $type = "FamilyCab Taxi Service"; $item = $_GET['type']; $dbhost = "localhost"; $dbuser = "desid573_fam_app"; $dbpass = "TW#7CCqKReDn"; $dbname = "desid573_famcab_api"; $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error); $qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $result = mysqli_query($conn, "SELECT * FROM booking WHERE reference='".$_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']; $pax = $row["book_pax"]; if($pax == "") { $pax = 1; } $rf = $row["book_rf"]; $ff = $row["book_ff"]; $boost = $row["book_b"]; $seats = $rf + $ff + $boost; $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']; $email = $row["email"]; 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.vromo.io/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; if($_GET['type']!="FA") { $price_code = "0"; $result = mysqli_query($conn, "SELECT * FROM toll_estimates WHERE reference='".$reference."'"); if(!$result) { error_log($conn->error); } else { if($result->num_rows > 0) { $row = mysqli_fetch_assoc($result); $tollAmount = $row['amount']; } } } $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']; $sql = "SELECT name FROM desid573_familycab.terminal_details"; $result = $conn->query($sql); $airportArray = []; if($result->num_rows > 0) while($row = $result->fetch_assoc()) { array_push($airportArray, $row["name"]); } else { error_log("cant connect ".$conn->error); }; } 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