<?php
/**
 * MVV.class.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');
    }

}