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