(new Constraint("IS_NOT_NULL")), "newsletter_consent" => 1, ]; $level = http::value("level", "int"); if($level) { $nvp["level"] = $level; } $max_age = http::value("max_age", "int"); $dt_max = null; $no_tests_after = http::value("no_tests_after"); if($no_tests_after) { $dt_max = CarbonImmutable::parse($no_tests_after, TIMEZONE); } $users = User::query($nvp); foreach($users as $user) { $dt_start = $user->getDateTimeLastTest(); // If user is older than the maximum age allowed, skip it if($max_age && $user->getAge() > $max_age) { continue; } // If user has done a test after the specified if($dt_start && $dt_max && $dt_start > $dt_max) { continue; } $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."); }