users_export.php 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. /**
  3. * @var string $type
  4. */
  5. use Carbon\CarbonImmutable;
  6. switch($type) {
  7. case "email":
  8. header("Content-Type: text/csv; charset=utf-8");
  9. http::setDownloadHeaders("email_addresses.csv");
  10. $handle = fopen("php://output", "wb");
  11. fputcsv($handle, ["id", "first_name", "last_name", "email", "date_of_birth", "date_last_test", "archived"]);
  12. $nvp = [
  13. "email" => (new Constraint("IS_NOT_NULL")),
  14. ];
  15. $newsletter_consent = http::value("newsletter_consent", "int");
  16. if($newsletter_consent !== null) {
  17. $nvp["newsletter_consent"] = $newsletter_consent;
  18. }
  19. $level = http::value("level", "int");
  20. if($level) {
  21. $nvp["level"] = $level;
  22. }
  23. $max_age = http::value("max_age", "int");
  24. $dt_max = null;
  25. $no_tests_after = http::value("no_tests_after");
  26. if($no_tests_after) {
  27. $dt_max = CarbonImmutable::parse($no_tests_after, TIMEZONE);
  28. }
  29. $users = User::query($nvp);
  30. foreach($users as $user) {
  31. $dt_start = $user->getDateTimeLastTest();
  32. // If user is older than the maximum age allowed, skip it
  33. if($max_age && $user->getAge() > $max_age) {
  34. continue;
  35. }
  36. // If user has done a test after the specified
  37. if($dt_start && $dt_max && $dt_start > $dt_max) {
  38. continue;
  39. }
  40. $date_last_test = null;
  41. if($dt_start) {
  42. $date_last_test = $dt_start->setTimezone(TIMEZONE)->format("d/m/Y");
  43. }
  44. fputcsv($handle, [$user->id, $user->first_name, $user->last_name, $user->email, $user->date_of_birth, $date_last_test, $user->archived]);
  45. }
  46. break;
  47. default:
  48. throw new Exception("Invalid type.");
  49. }