diff options
Diffstat (limited to 'lib/classes/MVV.php')
| -rw-r--r-- | lib/classes/MVV.php | 849 |
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'); + } + +} |