| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364 |
- <?php /** @noinspection PhpUnhandledExceptionInspection */
- /**
- * @var string $type
- */
- use Carbon\CarbonImmutable;
- 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;
- }
- $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.");
- }
|