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; }