User::LEVEL_TESTER, ]; if(!$include_archived) { $nvp["archived"] = 0; } $users = User::query($nvp); $user_ids = array_column($users, "id"); $users = array_combine($user_ids, $users); $addresses = UserAddress::query([ "user_id" => $user_ids ]); $tests = Test::query([ "tester_id" => $user_ids, "status" => Test::STATUS_COMPLETED ]); $user_test_timestamps = []; foreach($tests as $test) { $timestamp = $user_test_timestamps[$test->tester_id] ?? 0; $dt_start = new DateTime($test->dts_start, new DateTimeZone("UTC")); $test_timestamp = $dt_start->getTimestamp(); if($test_timestamp < $timestamp) continue; $user_test_timestamps[$test->tester_id] = $test_timestamp; } $output = []; foreach($addresses as $address) { $user = $users[$address->user_id]; $dt_registered = new DateTime($user->dts_registered, new DateTimeZone("UTC")); $date_last_test = null; $last_test_timestamp = $user_test_timestamps[$address->user_id] ?? null; $last_test_date = null; $days_since_last_test = null; if($last_test_timestamp) { $dt_last_test = CarbonImmutable::createFromTimestamp($last_test_timestamp, TIMEZONE); $date_last_test = $dt_last_test->format("d/m/Y"); $days_since_last_test = $dt_last_test->diffInDays($dt_now); } $output[] = [ "id" => (int) $address->id, "userId" => (int) $address->user_id, "name" => $user->getDisplayName(), "latitude" => (float) $address->latitude, "longitude" => (float) $address->longitude, "user" => [ "id" => (int) $user->id, "score" => (int) $user->score, "dateRegistered" => $dt_registered->format("d/m/Y"), "dateLastTest" => $date_last_test, "daysSinceLastTest" => $days_since_last_test ] ]; } JSON::success([ "addresses" => $output ]); break; }