addresses_ajax.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. <?php
  2. /**
  3. * @var string $action
  4. */
  5. use Carbon\CarbonImmutable;
  6. $user = Core::$user;
  7. $dt_now = CarbonImmutable::now(TIMEZONE);
  8. JSON::header();
  9. switch($action) {
  10. case "get-all":
  11. $include_archived = HTTP::value("include_archived");
  12. $nvp = [
  13. "level" => User::LEVEL_TESTER,
  14. ];
  15. if(!$include_archived) {
  16. $nvp["archived"] = 0;
  17. }
  18. $users = User::query($nvp);
  19. $user_ids = array_column($users, "id");
  20. $users = array_combine($user_ids, $users);
  21. $addresses = UserAddress::query([
  22. "user_id" => $user_ids
  23. ]);
  24. $tests = Test::query([
  25. "tester_id" => $user_ids,
  26. "status" => Test::STATUS_COMPLETED
  27. ]);
  28. $user_test_timestamps = [];
  29. foreach($tests as $test) {
  30. $timestamp = $user_test_timestamps[$test->tester_id] ?? 0;
  31. $dt_start = new DateTime($test->dts_start, new DateTimeZone("UTC"));
  32. $test_timestamp = $dt_start->getTimestamp();
  33. if($test_timestamp < $timestamp) continue;
  34. $user_test_timestamps[$test->tester_id] = $test_timestamp;
  35. }
  36. $output = [];
  37. foreach($addresses as $address) {
  38. $user = $users[$address->user_id];
  39. $dt_registered = new DateTime($user->dts_registered, new DateTimeZone("UTC"));
  40. $date_last_test = null;
  41. $last_test_timestamp = $user_test_timestamps[$address->user_id] ?? null;
  42. $last_test_date = null;
  43. $days_since_last_test = null;
  44. if($last_test_timestamp) {
  45. $dt_last_test = CarbonImmutable::createFromTimestamp($last_test_timestamp, TIMEZONE);
  46. $date_last_test = $dt_last_test->format("d/m/Y");
  47. $days_since_last_test = $dt_last_test->diffInDays($dt_now);
  48. }
  49. $output[] = [
  50. "id" => (int) $address->id,
  51. "userId" => (int) $address->user_id,
  52. "name" => $user->getDisplayName(),
  53. "latitude" => (float) $address->latitude,
  54. "longitude" => (float) $address->longitude,
  55. "user" => [
  56. "id" => (int) $user->id,
  57. "score" => (int) $user->score,
  58. "dateRegistered" => $dt_registered->format("d/m/Y"),
  59. "dateLastTest" => $date_last_test,
  60. "daysSinceLastTest" => $days_since_last_test
  61. ]
  62. ];
  63. }
  64. JSON::success([
  65. "addresses" => $output
  66. ]);
  67. break;
  68. }