Merge branch 'main' into issue-3911issue-3911

1 files changed, 849 insertions, 0 deletions

diff --git a/lib/classes/MVV.php b/lib/classes/MVV.php
new file mode 100644
index 0000000..b4d9edf
--- /dev/null
+++ b/lib/classes/MVV.php
@@ -0,0 +1,849 @@
+<?php
+/**
+ * MVV.php
+ * Helper class
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License as
+ * published by the Free Software Foundation; either version 2 of
+ * the License, or (at your option) any later version.
+ *
+ * @author      Peter Thienel <thienel@data-quest.de>
+ * @author      Timo Hartge <hartge@data-quest.de>
+ * @license     http://www.gnu.org/licenses/gpl-2.0.html GPL version 2
+ * @category    Stud.IP
+ * @since       4.1
+ */
+
+
+require_once 'config/mvv_config.php';
+
+class MVV implements Loggable {
+
+    /**
+     * The global key used by mvv classes to store values in cache.
+     */
+    const CACHE_KEY = 'MVV';
+
+    /**
+     * Determines whether the mvv backend is visible.
+     *
+     * @return boolean True if backend is visible
+     */
+    public static function isVisible() {
+        if (!$GLOBALS['perm']) {
+            return false;
+        }
+        if ($GLOBALS['perm']->have_perm('root') || ($GLOBALS['perm']->have_perm('admin')
+                && RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVAdmin'))) {
+            return true;
+        }
+        if (RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVEntwickler')) {
+            return true;
+        }
+        if (RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVRedakteur')) {
+            return true;
+        }
+        if (RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVTranslator')) {
+            return true;
+        }
+        if (RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVFreigabe')) {
+            return true;
+        }
+        if (RolePersistence::isAssignedRole(
+                        $GLOBALS['user']->id, 'MVVLvGruppenAdmin')) {
+            return true;
+        }
+        return false;
+    }
+
+    /**
+     * Determines whether the search for modules is visible in the global search.
+     *
+     * @return boolean True if backend is visible in search
+     */
+    public static function isVisibleSearch()
+    {
+        return isset($GLOBALS['perm'])
+            && ($GLOBALS['perm']->have_perm('autor') || Config::get()->COURSE_SEARCH_IS_VISIBLE_NOBODY)
+            && Modul::publicModulesAvailable();
+    }
+
+    /**
+     * This method enriches the logentry templates with data of the mvv classes
+     *
+     * @param  LogEvent  log event entry
+     *
+     * @return void
+     */
+    public static function logFormat(LogEvent $event)
+    {
+        $templ = $event->action->info_template;
+
+        $table = explode('.', $event->info);
+        switch ($table[0]) {
+
+            case 'abschluss':
+                $abschluss = Abschluss::find($event->affected_range_id);
+                if ($abschluss) {
+                    $url = URLHelper::getURL('dispatch.php/fachabschluss/abschluesse/details/' . $abschluss->getId(), [], true);
+                    $templ = str_replace('%abschluss(%affected)', '<a href="' . $url . '">' . htmlReady($abschluss->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_abschl_kategorie':
+                $abskategorie = AbschlussKategorie::find($event->affected_range_id);
+                if ($abskategorie) {
+                    $url = URLHelper::getURL('dispatch.php/fachabschluss/kategorien/details/' . $abskategorie->getId(), [], true);
+                    $templ = str_replace('%abskategorie(%affected)', '<a href="' . $url . '">' . htmlReady($abskategorie->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_abschl_zuord':
+                $abschluss = Abschluss::find($event->affected_range_id);
+                if ($abschluss) {
+                    $url = URLHelper::getURL('dispatch.php/fachabschluss/abschluesse/details/' . $abschluss->getId(), [], true);
+                    $templ = str_replace('%abschluss(%affected)', '<a href="' . $url . '">' . htmlReady($abschluss->getDisplayName()) . '</a>', $templ);
+                }
+                $co_kategorie = AbschlussKategorie::find($event->coaffected_range_id);
+                if ($co_kategorie) {
+                    $url = URLHelper::getURL('dispatch.php/fachabschluss/kategorien/details/' . $co_kategorie->getId(), [], true);
+                    $templ = str_replace('%abskategorie(%coaffected)', '<a href="' . $url . '">' . htmlReady($co_kategorie->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'fach':
+            case 'mvv_fach_inst':
+                $fach = Fach::find($event->affected_range_id);
+                if ($fach) {
+                    $url = URLHelper::getURL('dispatch.php/fachabschluss/faecher/details/' . $fach->getId(), [], true);
+                    $templ = str_replace('%fach(%affected)', '<a href="' . $url . '">' . htmlReady($fach->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_lvgruppe':
+            case 'mvv_lvgruppe_seminar':
+                $lvgruppe = Lvgruppe::find($event->affected_range_id);
+                if ($lvgruppe) {
+                    $url = URLHelper::getURL('dispatch.php/lvgruppen/lvgruppen/details/' . $lvgruppe->getId(), [], true);
+                    $templ = str_replace('%lvgruppe(%affected)', '<a href="' . $url . '">' . htmlReady($lvgruppe->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_lvgruppe_modulteil':
+                $lvgruppe = Lvgruppe::find($event->affected_range_id);
+                if ($lvgruppe) {
+                    $url = URLHelper::getURL('dispatch.php/lvgruppen/lvgruppen/details/' . $lvgruppe->getId(), [], true);
+                    $templ = str_replace('%lv(%affected)', '<a href="' . $url . '">' . htmlReady($lvgruppe->getDisplayName()) . '</a>', $templ);
+                }
+                $co_modulteil = Modulteil::find($event->coaffected_range_id);
+                if ($co_modulteil) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/modulteil_lvg/' . $co_modulteil->getId(), [], true);
+                    $templ = str_replace('%modulteil(%coaffected)', '<a href="' . $url . '">' . htmlReady($co_modulteil->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_modul':
+            case 'mvv_modul_user':
+            case 'mvv_modul_inst':
+                $modul = Modul::find($event->affected_range_id);
+                if ($modul) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/details/' . $modul->getId(), [], true);
+                    $templ = str_replace('%modul(%affected)', '<a href="' . $url . '">' . htmlReady($modul->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_modulteil':
+                $modulteil = Modulteil::find($event->affected_range_id);
+                if ($modulteil) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/modulteil_lvg/' . $modulteil->getId(), [], true);
+                    $templ = str_replace('%modulteil(%affected)', '<a href="' . $url . '">' . htmlReady($modulteil->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_modulteil_deskriptor':
+                $modulteil_desk = ModulteilDeskriptor::find($event->affected_range_id);
+                if ($modulteil_desk) {
+                    $modteil = Modulteil::find($modulteil_desk->modulteil_id);
+                    $url = URLHelper::getURL('dispatch.php/module/module/modulteil_lvg/' . $modteil->getId(), [], true);
+                    $templ = str_replace('%modulteildesk(%affected)', 'in Modulteil <a href="' . $url . '">' . htmlReady($modteil->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_modulteil_language':
+                $modulteil = Modulteil::find($event->affected_range_id);
+                if ($modulteil) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/modulteil_lvg/' . $modulteil->getId(), [], true);
+                    $templ = str_replace('%modulteil(%affected)', '<a href="' . $url . '">' . htmlReady($modulteil->getDisplayName()) . '</a>', $templ);
+                }
+                $co_mtlanguage = ModulteilLanguage::find([
+                    $event->affected_range_id,
+                    $event->coaffected_range_id
+                ]);
+                if ($co_mtlanguage) {
+                    $templ = str_replace('%language(%coaffected)', htmlReady($co_mtlanguage->getDisplayName()), $templ);
+                }
+                break;
+
+            case 'mvv_modulteil_stgteilabschnitt':
+                $modulteil = Modulteil::find($event->affected_range_id);
+                if ($modulteil) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/modulteil_lvg/' . $modulteil->getId(), [], true);
+                    $templ = str_replace('%modulteil(%affected)', '<a href="' . $url . '">' . htmlReady($modulteil->getDisplayName()) . '</a>', $templ);
+                }
+                $co_stgteilabs = StgteilAbschnitt::find($event->coaffected_range_id);
+                if ($co_stgteilabs) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/versionen/details_abschnitt/' . $co_stgteilabs->getId(), [], true);
+                    $templ = str_replace('%stgteilabs(%coaffected)', '<a href="' . $url . '">' . htmlReady($co_stgteilabs->getDisplayName()) . '</a>', $templ);
+                    $templ = str_replace('%fachsem', $event->dbg_info, $templ);
+                }
+                break;
+
+            case 'mvv_modul_deskriptor':
+                $modul_desk = ModulDeskriptor::find($event->affected_range_id);
+                if ($modul_desk) {
+                    $mod = Modul::find($modul_desk->modul_id);
+                    $url = URLHelper::getURL('dispatch.php/module/module/details/' . $mod->getId(), [], true);
+                    $templ = str_replace('%moduldesk(%affected)', 'in Modul <a href="' . $url . '">' . htmlReady($mod->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_modul_language':
+                $modul = Modul::find($event->affected_range_id);
+                if ($modul) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/details/' . $modul->getId(), [], true);
+                    $templ = str_replace('%modul(%affected)', '<a href="' . $url . '">' . htmlReady($modul->getDisplayName()) . '</a>', $templ);
+                }
+                $co_mlanguage = ModulLanguage::find([
+                    $event->affected_range_id,
+                    $event->coaffected_range_id
+                ]);
+                if ($co_mlanguage) {
+                    $templ = str_replace('%language(%coaffected)', htmlReady($co_mlanguage->getDisplayName()), $templ);
+                }
+                break;
+
+            case 'mvv_stgteil':
+            case 'mvv_fachberater':
+                $stgteil = StudiengangTeil::find($event->affected_range_id);
+                if ($stgteil) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/studiengangteile/details_versionen/' . $stgteil->getId(), [], true);
+                    $templ = str_replace('%stgteil(%affected)', '<a href="' . $url . '">' . htmlReady($stgteil->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_stgteilabschnitt':
+                $stgteilabs = StgteilAbschnitt::find($event->affected_range_id);
+                if ($stgteilabs) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/versionen/details_abschnitt/' . $stgteilabs->getId(), [], true);
+                    $templ = str_replace('%stgteilabs(%affected)', '<a href="' . $url . '">' . htmlReady($stgteilabs->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_stgteilabschnitt_modul':
+                $stgteilabs = StgteilAbschnitt::find($event->affected_range_id);
+                if ($stgteilabs) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/versionen/details_abschnitt/' . $stgteilabs->getId(), [], true);
+                    $templ = str_replace('%stgteilabs(%affected)', '<a href="' . $url . '">' . htmlReady($stgteilabs->getDisplayName()) . '</a>', $templ);
+                }
+                $co_modul = Modul::find($event->coaffected_range_id);
+                if ($co_modul) {
+                    $url = URLHelper::getURL('dispatch.php/module/module/details/' . $co_modul->getId(), [], true);
+                    $templ = str_replace('%modul(%coaffected)', '<a href="' . $url . '">' . htmlReady($co_modul->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_stgteilversion':
+                $version = StgteilVersion::find($event->affected_range_id);
+                if ($version) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/versionen/abschnitte/' . $version->getId(), [], true);
+                    $templ = str_replace('%version(%affected)', '<a href="' . $url . '">' . htmlReady($version->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_stgteil_bez':
+                $stgteilbez = StgteilBezeichnung::find($event->affected_range_id);
+                if ($stgteilbez) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/stgteilbezeichnungen/details/' . $stgteilbez->getId(), [], true);
+                    $templ = str_replace('%stgteilbez(%affected)', '<a href="' . $url . '">' . htmlReady($stgteilbez->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_stg_stgteil':
+                $stg = Studiengang::find($event->affected_range_id);
+                if ($stg) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/studiengaenge/details_studiengang/' . $stg->getId(), [], true);
+                    $templ = str_replace('%stg(%affected)', '<a href="' . $url . '">' . htmlReady($stg->getDisplayName()) . '</a>', $templ);
+                }
+                $co_stgteil = StudiengangTeil::find($event->coaffected_range_id);
+                if ($co_stgteil) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/studiengangteile/details_versionen/' . $co_stgteil->getId(), [], true);
+                    $templ = str_replace('%stgteil(%coaffected)', '<a href="' . $url . '">' . htmlReady($co_stgteil->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_studiengang':
+                $stg = Studiengang::find($event->affected_range_id);
+                if ($stg) {
+                    $url = URLHelper::getURL('dispatch.php/studiengaenge/studiengaenge/details_studiengang/' . $stg->getId(), [], true);
+                    $templ = str_replace('%stg(%affected)', '<a href="' . $url . '">' . htmlReady($stg->getDisplayName()) . '</a>', $templ);
+                }
+                break;
+
+            case 'mvv_contacts':
+                $contact = MvvContact::find($event->affected_range_id);
+                if ($contact) {
+                    $url = URLHelper::getLink('dispatch.php/shared/contacts/details/index/' . $contact->id);
+                    $templ = str_replace(
+                        '%contact(%affected)',
+                        '<a href="' . $url . '">' . htmlReady($contact->getDisplayName()) . '</a>',
+                        $templ
+                    );
+                }
+                break;
+
+            case 'mvv_contacts_ranges':
+                $contact_range = MvvContactRange::find($event->dbg_info);
+                if ($contact_range) {
+                    if ($contact_range->contact) {
+                        $url_affected = URLHelper::getLink(
+                            'dispatch.php/shared/contacts/details/index/' . $contact_range->contact->id);
+                        $templ = str_replace(
+                            '%contact(%affected)',
+                            '<a href="' . $url_affected . '">' . htmlReady($contact_range->contact->getDisplayName()) . '</a>',
+                            $templ
+                        );
+                    }
+                    $range = null;
+                    switch ($contact_range->range_type) {
+                        case 'Modul':
+                            $range = Modul::find($event->coaffected_range_id);
+                            $url_coaffected = URLHelper::getLink(
+                                'dispatch.php/module/module/details/' . $range->id,
+                                [],
+                                true
+                            );
+                            break;
+                        case 'Studiengang':
+                            $range = Studiengang::find($event->coaffected_range_id);
+                            $url_coaffected = URLHelper::getLink(
+                                'dispatch.php/studiengaenge/studiengaenge/details_studiengang/' . $range->id,
+                                [],
+                                true
+                            );
+                            break;
+                        case 'StudiengangTeil':
+                            $range = StudiengangTeil::find($event->coaffected_range_id);
+                            $url_coaffected = URLHelper::getLink(
+                                'dispatch.php/studiengaenge/studiengangteile/details_versionen/' . $range->id,
+                                [],
+                                true
+                            );
+
+                    }
+                    if ($range) {
+                        $templ = str_replace(
+                            '%range(%coaffected)',
+                            '<a href="' . $url_coaffected . '">' . htmlReady($range->getDisplayName()) . '</a>',
+                            $templ
+                        );
+                    }
+                }
+                break;
+
+            case 'mvv_extern_contacts':
+                $extern_contact = MvvExternContact::find($event->affected_range_id);
+                if ($extern_contact) {
+                    $url = URLHelper::getLink('dispatch.php/shared/contacts/details/index/' . $extern_contact->id);
+                    $templ = str_replace(
+                        '%contact(%affected)',
+                        '<a href="' . $url . '">' . htmlReady($extern_contact->getDisplayName()) . '</a>',
+                        $templ
+                    );
+                }
+                break;
+
+            case 'mvv_files':
+                $file = MvvFile::find($event->affected_range_id);
+                if ($file) {
+                    $url = URLHelper::getLink('dispatch.php/materialien/files/index/' . $file->id);
+                    $templ = str_replace(
+                        '%file(%affected)',
+                        '<a href="' . $url . '">' . htmlReady($file->getDisplayName()) . '</a>',
+                        $templ
+                    );
+                }
+                break;
+
+            case 'mvv_files_filerefs':
+                $fileref = MvvFileFileref::find($event->affected_range_id);
+                if ($fileref) {
+                    $url = URLHelper::getLink('dispatch.php/materialien/index/' . $fileref->mvvfile_id);
+                    $templ = str_replace(
+                        '%fileref(%affected)',
+                        '<a href="' . $url . '">' . htmlReady($fileref->getDisplayName()) . '</a>',
+                        $templ
+                    );
+                }
+                break;
+
+            case 'mvv_files_ranges':
+                $file_range = MvvFileRange::find([
+                    $event->affected_range_id,
+                    $event->coaffected_range_id
+                ]);
+                if ($file_range) {
+                    if ($file_range->mvv_file) {
+                        $url_affected = URLHelper::getLink(
+                            'dispatch.php/materialien/index/' . $file_range->mvvfile_id
+                        );
+                        $templ = str_replace(
+                            '%fileref(%affected)',
+                            '<a href="' . $url_affected . '">' . htmlReady($file_range->mvv_file->getDisplayName()) . '</a>',
+                            $templ
+                        );
+                    }
+                    $range = null;
+                    switch ($file_range->range_type) {
+                        case 'Studiengang':
+                            $range = Studiengang::find($event->coaffected_range_id);
+                            $url_coaffected = URLHelper::getLink(
+                                'dispatch.php/studiengaenge/studiengaenge/details_studiengang/' . $range->id,
+                                [],
+                                true
+                            );
+                            break;
+                        case 'StgteilVersion':
+                            $range = StgteilVersion::find($event->coaffected_range_id);
+                            $url_coaffected = URLHelper::getLink(
+                                'dispatch.php/studiengaenge/studiengangteile/version/' . $range->id,
+                                [],
+                                true
+                            );
+
+                    }
+                    if ($range) {
+                        $templ = str_replace(
+                            '%range(%coaffected)',
+                            '<a href="' . $url_coaffected . '">' . htmlReady($range->getDisplayName()) . '</a>',
+                            $templ
+                        );
+                    }
+                }
+                break;
+
+            default:
+                break;
+        }
+
+        // specials
+        // Benutzergruppen im Modul z.B. Modulverantwortlicher
+        $templ = str_replace('%gruppe', $event->dbg_info, $templ);
+        // Objekt konnte nicht eingesetzt werden da es vermutlich nicht mehr existiert, beim delete landet der alte Bezeichner im debug
+        $templ = str_replace('%modul(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%modulteil(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%modulteildesk(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%moduldesk(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stg(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stgteil(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stgteilabs(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%version(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stgteilbez(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%lvgruppe(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%fach(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%abschluss(%affected)', $event->dbg_info, $templ);
+        $templ = str_replace('%abskategorie(%affected)', $event->dbg_info, $templ);
+
+        $templ = str_replace('%abskategorie(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%modulteil(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%modul(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%language(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stgteilabs(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%stgteil(%coaffected)', $event->dbg_info, $templ);
+        $templ = str_replace('%contact', $event->dbg_info, $templ);
+
+        return $templ;
+    }
+
+    /**
+     * This method searches the log-entries for log-actions of the mvv classes.
+     * Used by search function on log page.
+     *
+     * @param  string  $needle The search term.
+     * @param  string  $action_name The name of the log action.
+     *
+     * @return array Found log events.
+     */
+    public static function logSearch($needle, $action_name = null)
+    {
+        $result = [];
+
+        $modul_actions = [
+            'MVV_MODUL_NEW',
+            'MVV_MODUL_UPDATE',
+            'MVV_MODUL_DEL',
+            'MVV_MODUL_DESK_NEW',
+            'MVV_MODUL_DESK_UPDATE',
+            'MVV_MODUL_DESK_DEL',
+            'MVV_MODULINST_NEW',
+            'MVV_MODULINST_DEL',
+            'MVV_MODULINST_UPDATE',
+            'MVV_MODUL_USER_NEW',
+            'MVV_MODUL_USER_DEL',
+            'MVV_MODUL_USER_UPDATE',
+            'MVV_MODUL_LANG_NEW',
+            'MVV_MODUL_LANG_DEL',
+            'MVV_MODUL_LANG_UPDATE',
+            'MVV_MODULTEIL_STGTEILABS_NEW',
+            'MVV_MODULTEIL_STGTEILABS_DEL',
+            'MVV_MODULTEIL_STGTEILABS_UPDATE',
+            'MVV_STGTEILABS_MODUL_NEW',
+            'MVV_STGTEILABS_MODUL_DEL',
+            'MVV_STGTEILABS_MODUL_UPDATE'
+        ];
+
+        if (in_array($action_name, $modul_actions)) {
+            $module = Modul::findBySQL(
+                "code LIKE CONCAT('%', :needle, '%') OR modul_id = :needle"
+            );
+            $deskriptoren = ModulDeskriptor::findBySql(
+                "bezeichnung LIKE CONCAT('%', :needle, '%')
+                 OR deskriptor_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($module as $modul) {
+                $result[] = [
+                    $modul->getId(),
+                    $modul->getDisplayName()
+                ];
+            }
+            foreach ($deskriptoren as $desk) {
+                $modul = Modul::find($desk->modul_id);
+                $result[] = [
+                    $modul->getId(),
+                    $modul->getDisplayName()
+                ];
+            }
+        }
+
+        $modulteile_actions = [
+            'MVV_MODULTEIL_NEW',
+            'MVV_MODULTEIL_UPDATE',
+            'MVV_MODULTEIL_DEL',
+            'MVV_MODULTEIL_DESK_NEW',
+            'MVV_MODULTEIL_DESK_UPDATE',
+            'MVV_MODULTEIL_DESK_DEL',
+            'MVV_MODULTEIL_LANG_NEW',
+            'MVV_MODULTEIL_LANG_DEL',
+            'MVV_MODULTEIL_LANG_UPDATE',
+            'MVV_LVMODULTEIL_NEW',
+            'MVV_LVMODULTEIL_DEL',
+            'MVV_LVMODULTEIL_UPDATE'
+        ];
+
+        if (in_array($action_name, $modulteile_actions)) {
+            $deskriptoren = ModulDeskriptor::findBySql(
+                "bezeichnung LIKE CONCAT('%', :needle, '%')
+                 OR deskriptor_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($deskriptoren as $desk) {
+                $modulteil = Modulteil::find($desk->modulteil_id);
+                $result[] = [
+                    $modulteil->getId(),
+                    $modulteil->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_STUDIENGANG_NEW',
+            'MVV_STUDIENGANG_UPDATE',
+            'MVV_STUDIENGANG_DEL',
+            'MVV_STG_STGTEIL_NEW',
+            'MVV_STG_STGTEIL_DEL',
+            'MVV_STG_STGTEIL_UPDATE'
+        ])) {
+            $stg = Studiengang::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR studiengang_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($stg as $studiengang) {
+                $result[] = [
+                    $studiengang->getId(),
+                    $studiengang->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_STGTEIL_NEW',
+            'MVV_STGTEIL_UPDATE',
+            'MVV_STGTEIL_DEL',
+            'MVV_FACHBERATER_NEW',
+            'MVV_FACHBERATER_UPDATE',
+            'MVV_FACHBERATER_DEL'
+        ])) {
+            $stgteile = StudiengangTeil::findBySQL(
+                "zusatz LIKE CONCAT('%', :needle, '%')
+                 OR zusatz_en LIKE CONCAT('%', :needle, '%')
+                 OR stgteil_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($stgteile as $stgteil) {
+                $result[] = [
+                    $stgteil->getId(),
+                    $stgteil->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_STGTEILVERSION_NEW',
+            'MVV_STGTEILVERSION_UPDATE',
+            'MVV_STGTEILVERSION_DEL'
+        ])) {
+            $versionen = StgteilVersion::findBySQL(
+                "code LIKE CONCAT('%', :needle, '%')
+                 OR version_id = :needle
+                 OR stgteil_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($versionen as $version) {
+                $result[] = [
+                    $version->getId(),
+                    $version->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_STGTEILBEZ_NEW',
+            'MVV_STGTEILBEZ_UPDATE',
+            'MVV_STGTEILBEZ_DEL'
+        ])) {
+            $stgbez = StgteilBezeichnung::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR stgteil_bez_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($stgbez as $bez) {
+                $result[] = [
+                    $bez->getId(),
+                    $bez->getDisplayName()
+                ];
+            }
+        }
+
+        $stgteil_actions = [
+            'MVV_STGTEILABS_NEW',
+            'MVV_STGTEILABS_UPDATE',
+            'MVV_STGTEILABS_DEL',
+            'MVV_MODULTEIL_STGTEILABS_NEW',
+            'MVV_MODULTEIL_STGTEILABS_DEL',
+            'MVV_MODULTEIL_STGTEILABS_UPDATE',
+            'MVV_STG_STGTEIL_NEW',
+            'MVV_STG_STGTEIL_DEL',
+            'MVV_STG_STGTEIL_UPDATE',
+            'MVV_STGTEILABS_MODUL_NEW',
+            'MVV_STGTEILABS_MODUL_DEL',
+            'MVV_STGTEILABS_MODUL_UPDATE'
+        ];
+
+        if (in_array($action_name, $stgteil_actions)) {
+            $stgteilabs = Lvgruppe::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR abschnitt_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($stgteilabs as $abschnitt) {
+                $result[] = [
+                    $abschnitt->getId(),
+                    $abschnitt->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_LVGRUPPE_NEW',
+            'MVV_LVGRUPPE_DEL',
+            'MVV_LVGRUPPE_UPDATE',
+            'MVV_LVMODULTEIL_NEW',
+            'MVV_LVMODULTEIL_DEL',
+            'MVV_LVMODULTEIL_UPDATE',
+            'MVV_LVSEMINAR_NEW',
+            'MVV_LVSEMINAR_DEL',
+            'MVV_LVSEMINAR_UPDATE'
+        ])) {
+            $lvgruppen = Lvgruppe::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR lvgruppe_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($lvgruppen as $lvgruppe) {
+                $result[] = [
+                    $lvgruppe->getId(),
+                    $lvgruppe->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_FACH_NEW',
+            'MVV_FACH_UPDATE',
+            'MVV_FACH_DEL',
+            'MVV_FACHINST_NEW',
+            'MVV_FACHINST_DEL',
+            'MVV_FACHINST_UPDATE'
+        ])) {
+            $faecher = Fach::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR fach_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($faecher as $fach) {
+                $result[] = [
+                    $fach->getId(),
+                    $fach->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_ABSCHLUSS_NEW',
+            'MVV_ABSCHLUSS_UPDATE',
+            'MVV_ABSCHLUSS_DEL',
+            'MVV_ABS_ZUORD_NEW',
+            'MVV_ABS_ZUORD_DEL',
+            'MVV_ABS_ZUORD_UPDATE'
+        ])) {
+            $abschluesse = Abschluss::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR abschluss_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($abschluesse as $abschluss) {
+                $result[] = [
+                    $abschluss->getId(),
+                    $abschluss->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_KATEGORIE_NEW',
+            'MVV_KATEGORIE_UPDATE',
+            'MVV_KATEGORIE_DEL',
+            'MVV_ABS_ZUORD_NEW',
+            'MVV_ABS_ZUORD_DEL',
+            'MVV_ABS_ZUORD_UPDATE'
+        ])) {
+            $abskategorien = AbschlussKategorie::findBySQL(
+                "name LIKE CONCAT('%', :needle, '%')
+                 OR name_en LIKE CONCAT('%', :needle, '%')
+                 OR kategorie_id = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($abskategorien as $abskategorie) {
+                $result[] = [
+                    $abskategorie->getId(),
+                    $abskategorie->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_CONTACT_NEW',
+            'MVV_CONTACT_UPDATE',
+            'MVV_CONTACT_DELETE',
+            'MVV_CONTACT_RANGE_NEW',
+            'MVV_CONTACT_RANGE_UPDATE',
+            'MVV_CONTACT_RANGE_DELETE',
+            'MVV_CONTACT_EXTERN_NEW',
+            'MVV_CONTACT_EXTERN_UPDATE',
+            'MVV_CONTACT_EXTERN_DELETE'
+        ])) {
+            $contacts_intern = MvvContact::findBySQL(
+                "LEFT JOIN `auth_user_md5`
+                   ON `mvv_contacts`.`contact_id` = `auth_user_md5`.`user_id`
+                 WHERE `auth_user_md5`.`username` LIKE CONCAT('%', :needle, '%')
+                    OR `auth_user_md5`.`nachname` LIKE CONCAT('%', :needle, '%')
+                    OR `auth_user_md5`.`email` = :needle",
+                [':needle' => $needle]
+            );
+            $contacts_extern = MvvContact::findBySQL(
+                "LEFT JOIN `mvv_extern_contacts`
+                   ON `mvv_contacts`.`contact_id` = `mvv_extern_contacts`.`extern_contact_id`
+                 WHERE `mvv_extern_contacts`.`name` = :needle
+                    OR `mvv_extern_contacts`.`mail` = :needle",
+                [':needle' => $needle]
+            );
+            $contacts = array_merge($contacts_intern, $contacts_extern);
+            foreach ($contacts as $contact) {
+                $result[] = [
+                    $contact->id,
+                    $contact->getDisplayName()
+                ];
+            }
+        }
+
+        if (in_array($action_name, [
+            'MVV_FILE_NEW',
+            'MVV_FILE_UPDATE',
+            'MVV_FILE_DELETE',
+            'MVV_FILE_RANGE_NEW',
+            'MVV_FILE_RANGE_UPDATE',
+            'MVV_FILE_RANGE_DELETE',
+            'MVV_FILE_FILEREF_NEW',
+            'MVV_FILE_FILEREF_UPDATE',
+            'MVV_FILE_FILEREF_DEL'
+        ])) {
+            $files = MvvFile::findBySQL(
+                "LEFT JOIN `mvv_files_filerefs` USING (`mvvfile_id`)
+                 LEFT JOIN `file_refs`
+                   ON `mvv_files_filerefs`.`fileref_id` = `file_refs`.`id`
+                 LEFT JOIN `files`
+                   ON `file_refs`.`file_id` = `files`.`id`
+                 WHERE `mvv_files`.`tags` LIKE CONCAT('%', :needle, '%')
+                    OR `mvv_files_filerefs`.`name` LIKE CONCAT('%', :needle, '%')
+                    OR `file_refs`.`name` LIKE CONCAT('%', :needle, '%')
+                    OR `files`.`name` = :needle
+                    OR `files`.`author_name` = :needle",
+                [':needle' => $needle]
+            );
+            foreach ($files as $file) {
+                $result[$file->id] = [
+                    $file->id,
+                    $file->getDisplayName()
+                ];
+            }
+        }
+
+        return $result;
+    }
+
+    /**
+     * Returns imagepath for given language, used by MVV
+     * First tries $GLOBALS['CONTENT_LANGUAGES'], if not defined returns hardcoded path
+     *
+     * @param string $language e.g. 'DE'
+     * @return string path to language icon
+     */
+    public static function getContentLanguageImagePath($language): string
+    {
+        $content_language = $GLOBALS['MVV_MODUL_DESKRIPTOR']['SPRACHE']['values'][$language]['content_language'];
+        return 'languages/' . ($GLOBALS['CONTENT_LANGUAGES'][$content_language]['picture'] ?? 'lang_' . mb_strtolower($language) . '.gif');
+    }
+
+}