function ajax_get_car_list()
{
$distance = $_POST['distance'] / 1000;
$is_return = $_POST['return'];
$date_pickup = $_POST['pickup_date'];
$start_location_id = $_POST['start_id'];
$end_location_id = $_POST['end_id'];
$args = array('posts_per_page' => -1, 'post_type' => 'cars', 'post_status' => 'publish');
$car_html = '';
$query = new WP_Query($args);
if ($query->have_posts()) {
while ($query->have_posts()) {
$query->the_post();
$image = rwmb_meta('vbs_car-image', 'type=plupload_image&size=thumbnail');
foreach ($image as $img) {
$src = $img['url'];
}
$cost = calculateCost(get_the_ID(), $distance, $date_pickup, $start_location_id, $end_location_id);
if ($is_return == '1') {
$cost = $cost * 2;
}
$car_html .= '<div class="car_data">';
$car_html .= '<div class="car_image"><img src="' . $src . '" /></div>';
$car_html .= '<div class="car_info_middle">';
$car_html .= '<h4 class="car_name">' . get_the_title() . '</h4>';
$car_html .= '<ul class="car_info">
<li><i class="fa fa-male"></i> ' . rwmb_meta('vbs_passengers') . '</li>
<li><i class="fa fa-suitcase"></i> ' . rwmb_meta('vbs_luggage') . '</li>
<li><i class="fa fa-briefcase"></i> ' . rwmb_meta('vbs_handbag') . '</li>
<li><i class="fa fa-child"></i> ' . rwmb_meta('vbs_child_seats') . '</li>
</ul>';
$car_html .= '</div>';
$car_html .= '<div class="car_info_right"><h1 class="car_cost"><span class="currency">€</span><span class="cost">' . round($cost, 2) . '</span></h1>';
$car_html .= '<input class="selection" type="radio" data-id="' . get_the_ID() . '" name="cost" value="' . round($cost, 2) . '" /> ' . __('Select', 'vbs') . '</div>';
$car_html .= '</div>';
}
}
wp_reset_query();
echo $car_html;
exit;
}
<?php
// configuration
require "../includes/config.php";
// SQL queries
$data = query("SELECT history_count.id, history_count.username, history_count.date, history_count.cash, history_count.historyCount, COUNT(portfolio.id) as portfolioCount FROM (SELECT users.id, users.username, users.date, users.cash, COUNT(history.id) as historyCount FROM users LEFT JOIN history ON users.id = history.id GROUP BY username) as history_count LEFT JOIN portfolio ON history_count.id = portfolio.id GROUP BY history_count.username");
$portfolio = query("SELECT * FROM portfolio");
$users = query("SELECT * FROM users");
// declares totals array, assigns all user id values to 0
$totals = [];
foreach ($users as $user) {
$totals[$user["id"]] = $user["cash"];
}
foreach ($portfolio as $tickers) {
$totals[$tickers["id"]] = $totals[$tickers["id"]] + calculateCost($tickers["symbol"], $tickers["shares"]);
}
render("leaderboard.php", ["data" => $data, "users" => $users, "portfolio" => $portfolio, "totals" => $totals, "title" => "Leaderboard"]);
function ajax_calculateCost()
{
$cost = calculateCost($_POST['carid'], $_POST['total_distance'], $_POST['date'], '0', '0');
echo json_encode($cost);
exit;
}
