show "Matrikelnummer" field in admin/user result table, closes #3336

Closes #3336

Merge request studip/studip!2270

2 files changed, 67 insertions, 0 deletions

diff --git a/cli/Commands/Migrate/MigrateMatrikelnummer.php b/cli/Commands/Migrate/MigrateMatrikelnummer.php
new file mode 100644
index 0000000..fbad2d8
--- /dev/null
+++ b/cli/Commands/Migrate/MigrateMatrikelnummer.php
@@ -0,0 +1,66 @@
+<?php
+
+namespace Studip\Cli\Commands\Migrate;
+
+use Symfony\Component\Console\Command\Command;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Input\InputOption;
+use Symfony\Component\Console\Output\OutputInterface;
+
+class MigrateMatrikelnummer extends Command
+{
+    protected static $defaultName = 'migrate:matrikelnummer';
+
+    protected function configure() : void
+    {
+        $this->setDescription('Migrates the "Matrikelnummer" datafield into the matriculation_number column of the auth_user_md5 table.');
+        $this->setHelp('This command migrates the "Matrikelnummer" datafield into the matriculation_number column of the auth_user_md5 table. The ID of the datafield must be provided. The datafield is not deleted in the migration process.');
+        $this->addOption('id', 'i', InputOption::VALUE_REQUIRED, 'The ID of the "Matrikelnummer" datafield.', null);
+    }
+
+    protected function execute(InputInterface $input, OutputInterface $output) : int
+    {
+        $datafield_id = $input->getOption('id');
+        if (!$datafield_id) {
+            echo 'No ID for the "Matrikelnummer" datafield has been provided.' . "\n";
+            return Command::FAILURE;
+        }
+        $datafield = \DataField::find($datafield_id);
+        if (!$datafield) {
+            echo 'The datafield could not be found.' . "\n";
+            return Command::FAILURE;
+        }
+        //Get all entries of the datafield for users and set the
+        //matriculation_number field:
+
+        $verbose = $input->getOption('verbose');
+
+        $modifier = function ($entry) use ($verbose) {
+            if (!$entry->content) {
+                return;
+            }
+            $user = \User::find($entry->range_id);
+            if (!$user) {
+                return;
+            }
+            $user->matriculation_number = $entry->content;
+            if ($user->isDirty()) {
+                $success = $user->store();
+                if ($verbose) {
+                    if ($success === false) {
+                        printf('Error updating matriculation number for user %s.', $user->username) . "\n";
+                    } elseif ($success > 0) {
+                        printf('Matriculation number updated for user %s.', $user->username) . "\n";
+                    }
+                }
+            }
+        };
+
+        \DatafieldEntryModel::findEachByDatafield_id(
+            $modifier,
+            $datafield->id
+        );
+
+        return Command::SUCCESS;
+    }
+}
diff --git a/cli/studip b/cli/studip
index bef389c..c4addb9 100755
--- a/cli/studip
+++ b/cli/studip
@@ -38,6 +38,7 @@ $commands = [
     Commands\Fix\EndTimeWeeklyRecurredEvents::class,
     Commands\Fix\IconDimensions::class,
     Commands\HelpContent\Migrate::class,
+    Commands\Migrate\MigrateMatrikelnummer::class,
     Commands\Migrate\MigrateList::class,
     Commands\Migrate\MigrateStatus::class,
     Commands\Migrate\Migrate::class,