users_export.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  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. "newsletter_consent" => 1,
  15. ];
  16. $level = http::value("level", "int");
  17. if($level) {
  18. $nvp["level"] = $level;
  19. }
  20. $max_age = http::value("max_age", "int");
  21. $dt_max = null;
  22. $no_tests_after = http::value("no_tests_after");
  23. if($no_tests_after) {
  24. $dt_max = CarbonImmutable::parse($no_tests_after, TIMEZONE);
  25. }
  26. $users = User::query($nvp);
  27. foreach($users as $user) {
  28. $dt_start = $user->getDateTimeLastTest();
  29. // If user is older than the maximum age allowed, skip it
  30. if($max_age && $user->getAge() > $max_age) {
  31. continue;
  32. }
  33. // If user has done a test after the specified
  34. if($dt_start && $dt_max && $dt_start > $dt_max) {
  35. continue;
  36. }
  37. $date_last_test = null;
  38. if($dt_start) {
  39. $date_last_test = $dt_start->setTimezone(TIMEZONE)->format("d/m/Y");
  40. }
  41. fputcsv($handle, [$user->id, $user->first_name, $user->last_name, $user->email, $user->date_of_birth, $date_last_test, $user->archived]);
  42. }
  43. break;
  44. default:
  45. throw new Exception("Invalid type.");
  46. }