diff options
Diffstat (limited to 'lib/extern/modules/ExternModuleLecturedetails.class.php')
| -rw-r--r-- | lib/extern/modules/ExternModuleLecturedetails.class.php | 605 |
1 files changed, 605 insertions, 0 deletions
diff --git a/lib/extern/modules/ExternModuleLecturedetails.class.php b/lib/extern/modules/ExternModuleLecturedetails.class.php new file mode 100644 index 0000000..ff803b8 --- /dev/null +++ b/lib/extern/modules/ExternModuleLecturedetails.class.php @@ -0,0 +1,605 @@ +<? +# Lifter002: TODO +# Lifter007: TODO +# Lifter003: TODO +# Lifter010: TODO +/** +* ExternModuleLecturedetails.class.php +* +* +* +* +* @author Peter Thienel <pthienel@web.de>, Suchi & Berg GmbH <info@data-quest.de> +* @access public +* @modulegroup extern +* @module ExternModuleLecturedetails +* @package studip_extern +*/ + +// +---------------------------------------------------------------------------+ +// This file is part of Stud.IP +// ExternModuleLecturedetails.class.php +// +// Copyright (C) 2003 Peter Thienel <pthienel@web.de>, +// Suchi & Berg GmbH <info@data-quest.de> +// +---------------------------------------------------------------------------+ +// 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 any later version. +// +---------------------------------------------------------------------------+ +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// You should have received a copy of the GNU General Public License +// along with this program; if not, write to the Free Software +// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. +// +---------------------------------------------------------------------------+ + + +require_once 'lib/extern/views/extern_html_templates.inc.php'; +require_once 'lib/extern/modules/views/ExternSemBrowse.class.php'; +require_once 'lib/dates.inc.php'; + +class ExternModuleLecturedetails extends ExternModule { + + + // private + var $seminar_id; + + /** + * + */ + function __construct($range_id, $module_name, $config_id = NULL, $set_config = NULL, $global_id = NULL) { + $this->data_fields = ['subtitle', 'lecturer', 'art', 'status', 'description', + 'location', 'semester', 'time', 'number', 'teilnehmer', 'requirements', + 'lernorga', 'leistung', 'range_path', 'misc', 'ects']; + $this->registered_elements = [ + 'ReplaceTextSemType', + 'Body', + 'TableHeader', + 'SemName' => 'TableParagraphText', + 'Headline' => 'TableParagraphText', + 'Content' => 'TableParagraphText', + 'LinkInternSimple' => 'LinkIntern', + 'StudipInfo', + 'StudipLink']; + $this->args = ['seminar_id']; + $this->field_names = [ + _("Untertitel"), + _("Lehrende"), + _("Veranstaltungsart"), + _("Veranstaltungstyp"), + _("Beschreibung"), + _("Ort"), + _("Semester"), + _("Zeiten"), + _("Veranstaltungsnummer"), + _("Teilnehmende"), + _("Voraussetzungen"), + _("Lernorganisation"), + _("Leistungsnachweis"), + _("Bereichseinordnung"), + _("Sonstiges"), + _("ECTS-Punkte")]; + parent::__construct($range_id, $module_name, $config_id, $set_config, $global_id); + } + + function setup () { + // extend $data_fields if generic datafields are set + $config_datafields = $this->config->getValue("Main", "genericdatafields"); + $this->data_fields = array_merge((array)$this->data_fields, (array)$config_datafields); + + // setup module properties + $this->elements["SemName"]->real_name = _("Name der Veranstaltung"); + $this->elements["Headline"]->real_name = _("Überschriften"); + $this->elements["Content"]->real_name = _("Absätze"); + $this->elements["LinkInternSimple"]->link_module_type = 2; + $this->elements["LinkInternSimple"]->real_name = _("Link zum Modul Mitarbeiterdetails"); + } + + function printout ($args) { + + if ($this->config->getValue("Main", "wholesite")) + echo html_header($this->config); + + if (!$language = $this->config->getValue("Main", "language")) + $language = "de_DE"; + init_i18n($language); + + echo $this->toString($args); + + if ($this->config->getValue("Main", "wholesite")) + echo html_footer(); + } + + function printoutPreview () { + + if ($this->config->getValue("Main", "wholesite")) + echo html_header($this->config); + + if (!$language = $this->config->getValue("Main", "language")) + $language = "de_DE"; + init_i18n($language); + + include "lib/extern/modules/views/lecturedetails_preview.inc.php"; + + if ($this->config->getValue("Main", "wholesite")) + echo html_footer(); + } + + function toString ($args) { + $out = ""; + $this->seminar_id = $args["seminar_id"]; + $query = "SELECT * FROM seminare WHERE Seminar_id = ?"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + $row = $statement->fetch(PDO::FETCH_ASSOC); + + $visible = $this->config->getValue("Main", "visible"); + $j = -1; + if ($row !== false) { + + $data["name"] = htmlReady($row['Name']); + + if ($visible[++$j] && $row['Untertitel']) + $data["subtitle"] = htmlReady($row['Untertitel']); + + if ($visible[++$j]) { + if (!$name_sql = $this->config->getValue("Main", "nameformat")) + $name_sql = "full"; + $name_sql = $GLOBALS['_fullname_sql'][$name_sql]; + + $query = "SELECT $name_sql AS name, username, position FROM seminar_user su LEFT JOIN + auth_user_md5 USING(user_id) LEFT JOIN user_info USING(user_id) + WHERE su.Seminar_id = ? AND su.status='dozent' ORDER BY position, username"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + while ($res = $statement->fetch(PDO::FETCH_ASSOC)) { + $data["lecturer"][] = $this->elements["LinkInternSimple"]->toString( + ["module" => "Persondetails", + "link_args" => "username=" . $res['username'] + . "&seminar_id=" . $this->seminar_id, + "content" => $res['name'] ]); + } + if (is_array($data["lecturer"])) + $data["lecturer"] = implode(", ", $data["lecturer"]); + } + + if ($visible[++$j] && $row['art']) + $data["art"] = htmlReady($row['art']); + + if ($visible[++$j]) { + // reorganize the $SEM_TYPE-array + foreach ($GLOBALS["SEM_CLASS"] as $key_class => $class) { + $i = 0; + foreach ($GLOBALS["SEM_TYPE"] as $key_type => $type) { + if ($type["class"] == $key_class) { + $i++; + $sem_types_position[$key_type] = $i; + } + } + } + + $aliases_sem_type = $this->config->getValue("ReplaceTextSemType", + "class_" . $GLOBALS["SEM_TYPE"][$row['status']]['class']); + if ($aliases_sem_type[$sem_types_position[$row['status']] - 1]) + $data["status"] = $aliases_sem_type[$sem_types_position[$row['status']] - 1]; + else + $data["status"] = htmlReady($GLOBALS["SEM_TYPE"][$row['status']]["name"]); + } + + if ($visible[++$j] && $row['Beschreibung']) + $data["description"] = formatLinks($row['Beschreibung']); + + if ($visible[++$j]) + $data["location"] = htmlReady(Seminar::getInstance($this->seminar_id)->getDatesTemplate('dates/seminar_export_location')); + + if ($visible[++$j]) + $data["semester"] = get_semester($this->seminar_id); + + if ($visible[++$j]) { + $data["time"] = htmlReady(Seminar::getInstance($this->seminar_id)->getDatesExport()); + if ($first_app = vorbesprechung($this->seminar_id, 'export')) { + $data["time"] .= "<br>" . $this->config->getValue("Main", "aliaspredisc") . htmlReady($first_app); + } + if ($begin = Seminar::getInstance($this->seminar_id)->getFirstDate('export')) { + $data["time"] .= "<br>" . $this->config->getValue("Main", "aliasfirstmeeting") . htmlReady($begin); + } + } + + if ($visible[++$j] && $row['VeranstaltungsNummer']) + $data["number"] = htmlReady($row['VeranstaltungsNummer']); + + if ($visible[++$j] && $row['teilnehmer']) + $data["teilnehmer"] = htmlReady($row['teilnehmer']); + + if ($visible[++$j] && $row['vorrausetzungen']) + $data["requirements"] = htmlReady($row['vorrausetzungen']); + + if ($visible[++$j] && $row['lernorga']) + $data["lernorga"] = htmlReady($row['lernorga']); + + if ($visible[++$j] && $row['leistungsnachweis']) + $data["leistung"] = htmlReady($row['leistungsnachweis']); + + if ($visible[++$j]) { + $range_path_level = $this->config->getValue("Main", "rangepathlevel"); + $pathes = get_sem_tree_path($this->seminar_id, $range_path_level); + if (is_array($pathes)) { + $data["range_path"] = htmlReady(implode("\n", array_values($pathes)),true,true); + } + } + + if ($visible[++$j] && $row['Sonstiges']) + $data["misc"] = formatLinks($row['Sonstiges']); + + if ($visible[++$j] && $row['ects']) + $data["ects"] = htmlReady($row['ects']); + + // generic data fields + if ($generic_datafields = $this->config->getValue("Main", "genericdatafields")) { + $localEntries = DataFieldEntry::getDataFieldEntries($this->seminar_id); + foreach ($generic_datafields as $id) { + if ($visible[++$j] && isset($localEntries[$id]) && is_object($localEntries[$id])) { + $data[$id] = $localEntries[$id]->getDisplayValue(); + } + } + } + $out = $this->toStringMainTable($data, FALSE); + } + + return $out; + } + + function toStringPreview ($args) { + // reorganize the $SEM_TYPE-array + foreach ($GLOBALS["SEM_CLASS"] as $key_class => $class) { + $i = 0; + foreach ($GLOBALS["SEM_TYPE"] as $key_type => $type) { + if ($type["class"] == $key_class) { + $i++; + $sem_types_position[$key_type] = $i; + } + } + } + + $data_sem["name"] = _("Name der Veranstaltung"); + $data_sem["subtitle"] = _("Untertitel der Veranstaltung"); + switch ($this->config->getValue("Main", "nameformat")) { + case "no_title_short" : + $data_sem["lecturer"] = _("Meyer, P."); + break; + case "no_title" : + $data_sem["lecturer"] = _("Peter Meyer"); + break; + case "no_title_rev" : + $data_sem["lecturer"] = _("Meyer Peter"); + break; + case "full" : + $data_sem["lecturer"] = _("Dr. Peter Meyer"); + break; + case "full_rev" : + $data_sem["lecturer"] = _("Meyer, Peter, Dr."); + break; + default : + $data_sem["lecturer"] = _("Dr. Peter Meyer"); + } + $data_sem["art"] = _("Testveranstaltung"); + $data_sem["semtype"] = 1; + $data_sem["description"] = str_repeat(_("Beschreibung") . " ", 10); + $data_sem["location"] = _("A 123, 1. Stock"); + $data_sem["semester"] = "WS 2003/2004"; + $data_sem["time"] = _("Di. 8:30 - 13:30, Mi. 8:30 - 13:30, Do. 8:30 - 13:30"); + $data_sem["number"] = "1234"; + $data_sem["teilnehmer"] = str_repeat(_("Teilnehmende") . " ", 6); + $data_sem["requirements"] = str_repeat(_("Voraussetzungen") . " ", 6); + $data_sem["lernorga"] = str_repeat(_("Lernorganisation") . " ", 6); + $data_sem["leistung"] = str_repeat(_("Leistungsnachweis") . " ", 6); + $data_sem["range_path"] = _("Fakultät > Studiengang > Bereich"); + $data_sem["misc"] = str_repeat(_("Sonstiges") . " ", 6); + $data_sem["ects"] = "4"; + + + setlocale(LC_TIME, $this->config->getValue("Main", "timelocale")); + $order = $this->config->getValue("Main", "order"); + $visible = $this->config->getValue("Main", "visible"); + $aliases = $this->config->getValue("Main", "aliases"); + $j = -1; + + $data["name"] = $data_sem["name"]; + + if ($visible[++$j]) + $data["subtitle"] = $data_sem["subtitle"]; + + if ($visible[++$j]) { + $data["lecturer"][] = sprintf("<a href=\"\"%s>%s</a>", + $this->config->getAttributes("LinkInternSimple", "a"), + $data_sem["lecturer"]); + if (is_array($data["lecturer"])) + $data["lecturer"] = implode(", ", $data["lecturer"]); + } + + if ($visible[++$j]) + $data["art"] = $data_sem["art"]; + + if ($visible[++$j]) { + $aliases_sem_type = $this->config->getValue("ReplaceTextSemType", + "class_{$SEM_TYPE[$data_sem['semtype']]['class']}"); + if ($aliases_sem_type[$sem_types_position[$data_sem['semtype']] - 1]) + $data["status"] = $aliases_sem_type[$sem_types_position[$data_sem['semtype']] - 1]; + else { + $data["status"] = htmlReady($SEM_TYPE[$data_sem['semtype']]["name"] + ." (". $SEM_CLASS[$SEM_TYPE[$data_sem['semtype']]["class"]]["name"].")"); + } + } + + if ($visible[++$j]) + $data["description"] = $data_sem["description"]; + + if ($visible[++$j]) + $data["location"] = $data_sem["location"]; + + if ($visible[++$j]) + $data["semester"] = $data_sem["semester"]; + + if ($visible[++$j]) + $data["time"] = $data_sem["time"]; + + if ($visible[++$j]) + $data["number"] = $data_sem["number"]; + + if ($visible[++$j]) + $data["teilnehmer"] = $data_sem["teilnehmer"]; + + if ($visible[++$j]) + $data["requirements"] = $data_sem["requirements"]; + + if ($visible[++$j]) + $data["lernorga"] = $data_sem["lernorga"]; + + if ($visible[++$j]) + $data["leistung"] = $data_sem["leistung"]; + + if ($visible[++$j]) { + $pathes = [$data_sem["range_path"]]; + if (is_array($pathes)) { + $pathes_values = array_values($pathes); + if ($this->config->getValue("Main", "range") == "long") + $data["range_path"] = $pathes_values; + else { + foreach ($pathes_values as $path) { + $_paths = explode(">", $path); + $data["range_path"][] = array_pop($_paths); + } + } + $data["range_path"] = array_filter($data["range_path"], "htmlReady"); + $data["range_path"] = implode("<br>", $data["range_path"]); + } + } + + if ($visible[++$j]) + $data["misc"] = $data_sem["misc"]; + + if ($visible[++$j]) + $data["ects"] = $data_sem["ects"]; + + return $this->toStringMainTable($data, TRUE); + } + + + // private + function toStringMainTable ($data, $preview) { + $order = $this->config->getValue("Main", "order"); + $visible = $this->config->getValue("Main", "visible"); + $aliases = $this->config->getValue("Main", "aliases"); + + if ($this->config->getValue("Main", "studiplink")) { + $out .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\""; + if ($studiplink_width = $this->config->getValue("TableHeader", "table_width")) + $out .= " width=\"$studiplink_width\""; + if ($studiplink_align = $this->config->getValue("TableHeader", "table_align")) + $out .= " align=\"$studiplink_align\">\n"; + + if ($preview) + $studip_link = ""; + else { + if ($this->config->getValue("Main", "studiplinktarget") != "signin") { + $studip_link = $GLOBALS['ABSOLUTE_URI_STUDIP'] . 'seminar_main.php?auswahl='; + $studip_link .= $this->seminar_id; + $studip_link .= "&again=1&redirect_to=dispatch.php/course/basicdata/view/".$this->seminar_id."&login=true&new_sem=TRUE"; + } + else { + $studip_link = $GLOBALS['ABSOLUTE_URI_STUDIP'] . 'dispatch.php/course/details/?again=1&sem_id='; + $studip_link .= $this->seminar_id; + } + } + if ($this->config->getValue("Main", "studiplink") == "top") { + $args = ["width" => "100%", "height" => "40", "link" => $studip_link]; + $out .= "<tr><td width=\"100%\">\n"; + $out .= $this->elements["StudipLink"]->toString($args); + $out .= "</td></tr>"; + } + $table_attr = $this->config->getAttributes("TableHeader", "table"); + $pattern = ["/width=\"[0-9%]+\"/", "/align=\"[a-z]+\"/"]; + $replace = ["width=\"100%\"", ""]; + $table_attr = preg_replace($pattern, $replace, $table_attr); + $out .= "<tr><td width=\"100%\">\n<table$table_attr>"; + } + else + $out .= "<table" . $this->config->getAttributes("TableHeader", "table") . ">"; + + $out .= $this->elements["SemName"]->toString(["content" => $data["name"]]); + + if ($this->config->getValue("Main", "headlinerow")) { + foreach ($order as $position) { + if ($visible[$position] && $data[$this->data_fields[$position]]) { + $out .= $this->elements["Headline"]->toString( + ["content" => $aliases[$position]]); + $out .= $this->elements["Content"]->toString( + ["content" => $data[$this->data_fields[$position]]]); + } + } + } + else { + foreach ($order as $position) { + if ($visible[$position] && $data[$this->data_fields[$position]]) { + $out .= $this->elements["Content"]->toString(["content" => + $this->config->getTag("Headline", "font") . $aliases[$position] . + "</font>" . $data[$this->data_fields[$position]]]); + } + } + } + + if ($this->config->getValue("Main", "studipinfo")) { + $out .= $this->elements["Headline"]->toString(["content" => + $this->config->getValue("StudipInfo", "headline")]); + $out .= $this->toStringStudipInfo($preview); + } + + $out .= "</table>\n"; + + if ($this->config->getValue("Main", "studiplink")) { + if ($this->config->getValue("Main", "studiplink") == "bottom") { + $args = ["width" => "100%", "height" => "40", "link" => $studip_link]; + $out .= "</td></tr>\n<tr><td width=\"100%\">\n"; + $out .= $this->elements["StudipLink"]->toString($args); + } + $out .= "</td></tr></table>\n"; + } + + return $out; + } + + // private + function toStringStudipInfo ($preview) { + if ($preview) { + $studip_info = $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "homeinst") . " "]); + $studip_info .= sprintf("<a href=\"\"%s>%s</a><br>\n", + $this->config->getAttributes("LinkInternSimple", "a"), + _("Heimatinstitut")); + + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "involvedinst") . " "]); + $studip_info .= str_repeat(_("Beteiligte Institute") . " ", 5) . "<br>\n"; + + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countuser") . " "]); + $studip_info .= "23<br>\n"; + + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countpostings") . " "]); + $studip_info .= "42<br>\n"; + + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countdocuments") . " "]); + $studip_info .= "7<br>\n"; + } + else { + $query="SELECT i.Institut_id, i.Name, i.url FROM seminare LEFT JOIN Institute i + USING(institut_id) WHERE Seminar_id = ?"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + $res = $statement->fetch(PDO::FETCH_ASSOC); + $own_inst = $res['Institut_id']; + + $studip_info = $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "homeinst") . " "]); + + if ($res['url']) { + $link_inst = htmlReady($res['url']); + if (!preg_match('{^https?://.+$}', $link_inst)) + $link_inst = "http://$link_inst"; + $studip_info .= sprintf( + "<a href=\"%s\"%s target=\"_blank\" rel=\"noopener noreferrer\">%s</a>", + $link_inst, + $this->config->getAttributes("LinkInternSimple", "a"), + htmlReady($res['Name']) + ); + }else + $studip_info .= htmlReady($res['Name']); + $studip_info .= "<br>\n"; + + + $query = "SELECT Name, url FROM seminar_inst LEFT JOIN Institute i USING(institut_id) + WHERE seminar_id = ? AND i.institut_id!='$own_inst'"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + $involved_insts = NULL; + foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $res) { + if ($res['url']) { + $link_inst = htmlReady($res['url']); + if (!preg_match('{^https?://.+$}', $link_inst)) + $link_inst = "http://$link_inst"; + $involved_insts[] = sprintf( + "<a href=\"%s\"%s target=\"_blank\" rel=\"noopener noreferrer\">%s</a>", + $link_inst, + $this->config->getAttributes("LinkInternSimple", "a"), + htmlReady($res['Name']) + ); + } + else + $involved_insts[] = $res['Name']; + } + + if ($involved_insts) { + $involved_insts = implode(", ", $involved_insts); + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "involvedinst") . " "]); + $studip_info .= $involved_insts . "<br>\n"; + } + + $query = "SELECT count(*) as count_user FROM seminar_user WHERE Seminar_id = ?"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + $res = $statement->fetch(PDO::FETCH_ASSOC); + + if ($res['count_user']) { + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countuser") . " "]); + $studip_info .= $res['count_user'] . "<br>\n"; + } + + + // get postings for all ForumModules + foreach (PluginEngine::getPlugins('ForumModule') as $plugin) { + $postings += $plugin->getNumberOfPostingsForSeminar($this->seminar_id); + } + + if ($postings) { + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countpostings") . " "]); + $studip_info .= $postings . "<br>\n"; + } + + $query = "SELECT COUNT(*) AS count_documents + FROM folders + INNER JOIN file_refs ON folder_id = folders.id + WHERE range_id = ? AND range_type = 'course' + AND folder_type IN ('RootFolder', 'StandardFolder') + GROUP BY range_id"; + $parameters = [$this->seminar_id]; + $statement = DBManager::get()->prepare($query); + $statement->execute($parameters); + $res = $statement->fetch(PDO::FETCH_ASSOC); + + if ($res['count_documents']) { + $studip_info .= $this->elements["StudipInfo"]->toString(["content" => + $this->config->getValue("StudipInfo", "countdocuments") . " "]); + $studip_info .= $res['count_documents'] . "\n"; + } + } + + return $this->elements["Content"]->toString(["content" => $studip_info]); + } + +} + +?> |