archive_testers.php 658 B

123456789101112131415161718192021222324252627282930313233
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. use Carbon\CarbonImmutable;
  3. chdir(__DIR__);
  4. require "../initialise.php";
  5. $date = CarbonImmutable::now()->subYears(23)->toDateString();
  6. $users = User::query([
  7. "level" => User::LEVEL_TESTER,
  8. "date_of_birth" => Constraint::lessThan($date),
  9. "archived" => "0"
  10. ]);
  11. $user_count = count($users);
  12. $archived_count = 0;
  13. foreach($users as $user) {
  14. if($user->date_of_birth === "0000-00-00") {
  15. continue;
  16. }
  17. $archived_count++;
  18. echo sprintf("%s (%s) archived.\n", $user->getDisplayName(), $user->date_of_birth);
  19. $user->archived = 1;
  20. $user->commit();
  21. }
  22. echo "Users archived: $archived_count\n";