archive_testers.php 641 B

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