addresses_ajax.php 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. $user = Core::$user;
  3. JSON::header();
  4. switch($action) {
  5. case "get-all":
  6. $users = User::query(["level" => User::LEVEL_TESTER]);
  7. $user_ids = array_column($users, "id");
  8. $users = array_combine($user_ids, $users);
  9. $addresses = UserAddress::query([
  10. "user_id" => $user_ids
  11. ]);
  12. $tests = Test::query([
  13. "tester_id" => $user_ids,
  14. "status" => Test::STATUS_COMPLETED
  15. ]);
  16. $user_test_timestamps = [];
  17. foreach($tests as $test) {
  18. $timestamp = $user_test_timestamps[$test->tester_id] ?? 0;
  19. $dt_start = new DateTime($test->dts_start, new DateTimeZone("UTC"));
  20. $test_timestamp = $dt_start->getTimestamp();
  21. if($test_timestamp < $timestamp) continue;
  22. $user_test_timestamps[$test->tester_id] = $test_timestamp;
  23. }
  24. $output = [];
  25. foreach($addresses as $address) {
  26. $user = $users[$address->user_id];
  27. $dt_registered = new DateTime($user->dts_registered, new DateTimeZone("UTC"));
  28. $date_last_test = null;
  29. $last_test_timestamp = $user_test_timestamps[$address->user_id] ?? null;
  30. $last_test_date = null;
  31. if($last_test_timestamp) {
  32. $dt_last_test = DateTime::createFromFormat("U", $last_test_timestamp, new DateTimeZone(TIMEZONE));
  33. $date_last_test = $dt_last_test->format("d/m/Y");
  34. }
  35. $output[] = [
  36. "id" => (int) $address->id,
  37. "userId" => (int) $address->user_id,
  38. "name" => $user->getDisplayName(),
  39. "latitude" => (float) $address->latitude,
  40. "longitude" => (float) $address->longitude,
  41. "user" => [
  42. "id" => (int) $user->id,
  43. "score" => (int) $user->score,
  44. "dateRegistered" => $dt_registered->format("d/m/Y"),
  45. "dateLastTest" => $date_last_test,
  46. ]
  47. ];
  48. }
  49. JSON::success([
  50. "addresses" => $output
  51. ]);
  52. break;
  53. }