1
0

users_export.php 999 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. /**
  3. * @var string $type
  4. */
  5. switch($type) {
  6. case "email":
  7. header("Content-Type: text/csv; charset=utf-8");
  8. http::setDownloadHeaders("email_addresses.csv");
  9. $handle = fopen("php://output", "wb");
  10. fputcsv($handle, ["id", "first_name", "last_name", "email", "date_of_birth", "date_last_test", "archived"]);
  11. $nvp = [
  12. "email" => (new Constraint("IS_NOT_NULL")),
  13. "newsletter_consent" => 1,
  14. ];
  15. $level = http::value("level", "int");
  16. if($level) {
  17. $nvp["level"] = $level;
  18. }
  19. $users = User::query($nvp);
  20. foreach($users as $user) {
  21. $dt_start = $user->getDateTimeLastTest();
  22. $date_last_test = null;
  23. if($dt_start) {
  24. $date_last_test = $dt_start->setTimezone(TIMEZONE)->format("d/m/Y");
  25. }
  26. fputcsv($handle, [$user->id, $user->first_name, $user->last_name, $user->email, $user->date_of_birth, $date_last_test, $user->archived]);
  27. }
  28. break;
  29. default:
  30. throw new Exception("Invalid type.");
  31. }