| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- <?php /** @noinspection PhpUnhandledExceptionInspection */
- /**
- * @var string $type
- */
- switch($type) {
- case "email":
- header("Content-Type: text/csv; charset=utf-8");
- http::setDownloadHeaders("email_addresses.csv");
- $handle = fopen("php://output", "wb");
- fputcsv($handle, ["id", "first_name", "last_name", "email", "date_of_birth", "date_last_test", "archived"]);
- $nvp = [
- "email" => (new Constraint("IS_NOT_NULL")),
- "newsletter_consent" => 1,
- ];
- $level = http::value("level", "int");
- if($level) {
- $nvp["level"] = $level;
- }
- $users = User::query($nvp);
- foreach($users as $user) {
- $dt_start = $user->getDateTimeLastTest();
- $date_last_test = null;
- if($dt_start) {
- $date_last_test = $dt_start->setTimezone(TIMEZONE)->format("d/m/Y");
- }
- fputcsv($handle, [$user->id, $user->first_name, $user->last_name, $user->email, $user->date_of_birth, $date_last_test, $user->archived]);
- }
- break;
- default:
- throw new Exception("Invalid type.");
- }
|