function get_all_users() { $link = open_database_connection(); $query = "SELECT * FROM users ORDER BY uid ASC"; $users = array(); if ($result = mysqli_query($link, $query)) { // fetch associative array while ($row = mysqli_fetch_assoc($result)) { $row['tags'] = get_user_tags($row['uid']); $row['equipments'] = get_user_equipments($row['uid']); $users[] = $row; } // free result set mysqli_free_result($result); } // close connection mysqli_close($link); return $users; }
function dashboard_action() { // needed to hide the menu $dashboard_active = true; // dealing with order form if (isset($_POST['client'])) { new_order($_POST); } // dealing with transfers if (intval($_POST['transfers']) > 0) { new_transfer($_POST['recipient'], $_POST['transfers'], $_POST); } // dealing with message form if (isset($_POST['message'])) { add_message($_POST['uid'], $_POST['message']); } // if order form is needed if (isset($_GET['uid'])) { // get all the snacks $snacks = get_visible_snacks(); $client = get_user_by_uid($_GET['uid']); $client['lastorder'] = get_last_order_timestamp_by_uid($client['uid']); $client['lastpayment'] = get_last_payment_by_uid($client['uid']); $client['tags'] = get_user_tags($client['uid']); $client['equipments'] = get_user_equipments($client['uid']); $client['jobs'] = get_jobs_by_uid($client['uid']); } else { $messages = get_all_messages(); $events = get_google_calendar_events(); $first_coffee = get_first_coffee(); $jobs = get_last_jobs(); } // get all the users $users = get_all_users_sorted_by_balance_descending(); require 'templates/dashboard.php'; }