| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 |
- <?php
- /**
- * @var string $action
- */
- use Carbon\CarbonImmutable;
- $user = Core::$user;
- $dt_now = CarbonImmutable::now(TIMEZONE);
- JSON::header();
- switch($action) {
- case "get-all":
- $users = User::query(["level" => User::LEVEL_TESTER]);
- $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;
- }
|