/home/desid573/public_html
Edit: /home/desid573/public_html/familyPrice.php (4548B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query1 = "SELECT * FROM prices WHERE city='".$city."'";
$result = mysqli_query($conn, $query1);
$row = mysqli_fetch_assoc($result);
$base = $row['base'];
$km_rate = $row['km'];
$time_rate = $row['time'];
$large = $row['large_km'];
$min = $row['min'];
$min_late = $row['min_late'];
$multiplier = 1;
$resp["additional"] = "";
if(isset($date)) {
$dateArray = array();
$sql = "SELECT date FROM holiday WHERE ".$city." = 1";
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
array_push($dateArray, $row["date"]);
}
if(array_search($date, $dateArray) !== false) {
if($date == "2023-12-25") {
$multiplier = 2;
$resp["additional"] = "Fare is higher due to Christmas Day";
} else {
error_log("public holiday!");
$multiplier = 1.15;
$resp["additional"] = "Includes 15% increase for Public Holiday";
}
}
error_log(getWeekday($date));
if(getWeekday($date) == 0) {
$multiplier = 1.1;
$resp["additional"] = "Includes 10% increase for Sunday pickup";
}
}
function getWeekday($date) {
return date('w', strtotime($date));
}
if(!empty($km) && !empty($duration))
{
if($time < 6 OR $time > 22) {
$min = $min_late;
}
error_log($airport);
if($airport === true) {
error_log("airport true");
if($city == "queensland") {
$airport_charge = 6.5;
} else {
$airport_charge = 5;
}
} else {
$airport_charge = 0;
}
if($pax > 3) {
$km_rate = $large;
}
if($seats > 1) {
$seats_charge = ($seats - 1) * 5;
} else {
$seats_charge = 0;
}
$fare = $km * $km_rate + $duration * $time_rate;
$levy = 0;
if($city == "sydney" or $city == "melbourne") {
$levy = 1.1;
}
if($levy > 10) {
$levy = 10;
}
$fare = $fare + $seats_charge + $base;
if($fare < $min) {
$fare = $min;
}
if($city != "perth") {
$fare = $fare + $levy;
}
if($city == "melbourne") {
$fare = $fare + 5;
}
$fare = $fare + $airport_charge;
$sql = "INSERT INTO `desid573_eway_codes`.`ip_address`(`id`, `ip`, `quote`, `quote_date`, `booking_reference`, `booking_date`, `city`) VALUES (null,'".$_SERVER['REMOTE_ADDR']."','".$fare."',NOW(),'','','".$city."')";
$submit = $conn->query($sql);
if(!$submit) {
error_log("ip error: ".$conn->error);
}
$slackmessage = "New FC $city quote $$fare from ".$_SERVER['REMOTE_ADDR'];
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, 'https://hooks.slack.com/services/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');
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curlObj, CURLOPT_HEADER, 0);
curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
curl_setopt($curlObj, CURLOPT_POST, 1);
curl_setopt($curlObj, CURLOPT_POSTFIELDS, '{"text": "'.$slackmessage.'"}');
$response = curl_exec($curlObj);
curl_close($curlObj);
$total = $fare * $multiplier;
$resp["status"] = "OK";
$resp["message"] = "fare calculated";
$resp["fare"] = "$fare";
$resp["levy"] = "$levy";
$resp["total"] = "$total";
echo json_encode($resp, true);
}
