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

1 files changed, 825 insertions, 0 deletions

diff --git a/lib/classes/StudipSemTreeViewAdmin.php b/lib/classes/StudipSemTreeViewAdmin.php
new file mode 100644
index 0000000..59c926a
--- /dev/null
+++ b/lib/classes/StudipSemTreeViewAdmin.php
@@ -0,0 +1,825 @@
+<?php
+# Lifter001: TEST
+# Lifter002: TODO
+# Lifter005: TODO
+# Lifter007: TODO
+# Lifter003: TODO
+# Lifter010: TODO
+// +---------------------------------------------------------------------------+
+// This file is part of Stud.IP
+// StudipSemTreeViewAdmin.php
+// Class to print out the seminar tree in administration mode
+//
+// Copyright (c) 2003 André Noack <noack@data-quest.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.
+// +---------------------------------------------------------------------------+
+
+use Studip\Button, Studip\LinkButton;
+
+
+/**
+* class to print out the seminar tree (admin mode)
+*
+* This class prints out a html representation of the whole or part of the tree
+*
+* @access   public
+* @author   André Noack <noack@data-quest.de>
+* @package
+*/
+class StudipSemTreeViewAdmin extends TreeView
+{
+    var $admin_ranges = [];
+    var $msg = [];
+    var $marked_item;
+    var $marked_sem;
+    var $mode;
+    var $move_item_id = null;
+    var $edit_item_id = null;
+
+    /**
+    * constructor
+    *
+    * @access public
+    */
+    function __construct($start_item_id = "root"){
+        $this->start_item_id = ($start_item_id) ? $start_item_id : "root";
+        $this->root_content = $GLOBALS['UNI_INFO'];
+        parent::__construct("StudipSemTree"); //calling the baseclass constructor
+        URLHelper::bindLinkParam("_marked_item", $this->marked_item);
+        $this->marked_sem =& $_SESSION['_marked_sem'];
+        $this->parseCommand();
+    }
+
+    /**
+    * manages the session variables used for the open/close thing
+    *
+    * @access   private
+    */
+    function handleOpenRanges(){
+
+        $this->open_ranges[$this->start_item_id] = true;
+
+        if (Request::option('close_item') || Request::option('open_item')){
+            $toggle_item = (Request::option('close_item')) ? Request::option('close_item') : Request::option('open_item');
+            if (!$this->open_items[$toggle_item]){
+                $this->openItem($toggle_item);
+            } else {
+                unset($this->open_items[$toggle_item]);
+            }
+        }
+
+        if (Request::option('item_id')) $this->anchor = Request::option('item_id');
+
+    }
+
+    function openItem($item_id){
+        if ($this->tree->hasKids($item_id)){
+            $this->start_item_id = $item_id;
+            $this->open_ranges = null;
+            $this->open_items = null;
+            $this->open_items[$item_id] = true;
+            $this->open_ranges[$item_id] = true;
+        } else {
+            $this->open_ranges[$this->tree->tree_data[$item_id]['parent_id']] = true;
+            $this->open_items[$item_id] = true;
+            $this->start_item_id = $this->tree->tree_data[$item_id]['parent_id'];
+        }
+        if ($this->start_item_id == "root"){
+            $this->open_ranges = null;
+            $this->open_ranges[$this->start_item_id] = true;
+        }
+        $this->anchor = $item_id;
+    }
+
+    function parseCommand(){
+        $this->mode = '';
+        if (Request::quoted('mode'))
+        $this->mode = Request::quoted('mode');
+        if (Request::option('cmd')){
+            $exec_func = "execCommand" . Request::option('cmd');
+            if (method_exists($this,$exec_func)){
+                if ($this->$exec_func()){
+                    $this->tree->init();
+                }
+            }
+        }
+        if ($this->mode == "MoveItem" || $this->mode == "CopyItem")
+        $this->move_item_id = $this->marked_item;
+    }
+
+    public function execCommandOrderItemsAlphabetically()
+    {
+        $item_id = Request::option('sort_id');
+        $sorted_items_stmt = DBManager::get()->prepare(
+            'SELECT * FROM sem_tree LEFT JOIN Institute ON studip_object_id = Institut_id WHERE parent_id = :parent_id ORDER BY IF(studip_object_id, Institute.name, sem_tree.name)'
+        );
+        $sorted_items_stmt->execute([
+            'parent_id' => $item_id,
+        ]);
+        $sorted_items = $sorted_items_stmt->fetchAll(PDO::FETCH_ASSOC);
+        foreach ($sorted_items as $priority => $data) {
+            $update_priority_stmt = DBManager::get()->prepare('UPDATE sem_tree SET priority = :priority WHERE sem_tree_id = :sem_tree_id');
+            $update_priority_stmt->execute([
+                'priority' => $priority,
+                'sem_tree_id' => $data['sem_tree_id']
+            ]);
+        }
+        $this->msg[$item_id] = 'info§' . _('Die Einträge im Bereich wurden alphabetisch sortiert.');
+
+        return true;
+    }
+
+    function execCommandOrderItem(){
+        $direction = Request::quoted('direction');
+        $item_id = Request::option('item_id');
+        $items_to_order = $this->tree->getKids($this->tree->tree_data[$item_id]['parent_id']);
+        if (!$this->isParentAdmin($item_id) || !$items_to_order)
+        return false;
+        for ($i = 0; $i < count($items_to_order); ++$i){
+            if ($item_id == $items_to_order[$i])
+            break;
+        }
+        if ($direction == "up" && isset($items_to_order[$i-1])){
+            $items_to_order[$i] = $items_to_order[$i-1];
+            $items_to_order[$i-1] = $item_id;
+        } elseif (isset($items_to_order[$i+1])){
+            $items_to_order[$i] = $items_to_order[$i+1];
+            $items_to_order[$i+1] = $item_id;
+        }
+        $view = DbView::getView('sem_tree');
+        for ($i = 0; $i < count($items_to_order); ++$i){
+            $view->params = [$i, $items_to_order[$i]];
+            $rs = $view->get_query("view:SEM_TREE_UPD_PRIO");
+        }
+        $this->mode = "";
+        $this->msg[$item_id] = "msg§" . (($direction == "up") ? _("Element wurde eine Position nach oben verschoben.") : _("Element wurde eine Position nach unten verschoben."));
+        return true;
+    }
+
+    function execCommandNewItem(){
+        $item_id = Request::option('item_id');
+        if ($this->isItemAdmin($item_id)){
+            $new_item_id = DbView::get_uniqid();
+            $this->tree->storeItem($new_item_id,$item_id,_("Neuer Eintrag"), $this->tree->getNumKids($item_id) +1);
+            $this->openItem($new_item_id);
+            $this->edit_item_id = $new_item_id;
+            if ($this->mode != "NewItem") $this->msg[$new_item_id] = "info§" . _("Hier können Sie die Bezeichnung und die Kurzinformation zu diesem Bereich eingeben.");
+            $this->mode = "NewItem";
+        }
+        return false;
+    }
+
+    function execCommandEditItem(){
+        $item_id = Request::option('item_id');
+        if ($this->isItemAdmin($item_id) || $this->isParentAdmin($item_id)){
+            $this->mode = "EditItem";
+            $this->anchor = $item_id;
+            $this->edit_item_id = $item_id;
+            if($this->tree->tree_data[$this->edit_item_id]['studip_object_id']){
+                $this->msg[$item_id] = "info§" . _("Hier können Sie die Kurzinformation zu diesem Bereich eingeben. Der Name kann nicht geändert werden, da es sich um eine Stud.IP-Einrichtung handelt.");
+            } else {
+                $this->msg[$item_id] = "info§" . _("Hier können Sie die Bezeichnung und die Kurzinformation zu diesem Bereich eingeben");
+            }
+        }
+        return false;
+    }
+
+    function execCommandInsertItem(){
+        $item_id = Request::option('item_id');
+        $parent_id = Request::option('parent_id');
+        $item_name = Request::quoted('edit_name');
+        $item_info = Request::quoted('edit_info');
+        $item_type = Request::int('edit_type');
+        if ($this->mode == "NewItem" && $item_id){
+            if ($this->isItemAdmin($parent_id)){
+                $priority = count($this->tree->getKids($parent_id));
+                if ($this->tree->InsertItem($item_id,$parent_id,$item_name,$item_info,$priority,null,$item_type)){
+                    $this->mode = "";
+                    $this->tree->init();
+                    $this->openItem($item_id);
+                    $this->msg[$item_id] = "msg§" . _("Dieser Bereich wurde neu eingefügt.");
+                }
+            }
+        }
+        if ($this->mode == "EditItem"){
+            if ($this->isParentAdmin($item_id)){
+                if ($this->tree->UpdateItem($item_id, $item_name, $item_info, $item_type)){
+                    $this->msg[$item_id] = "msg§" . _("Bereich wurde geändert.");
+                } else {
+                    $this->msg[$item_id] = "info§" . _("Keine Veränderungen vorgenommen.");
+                }
+                $this->mode = "";
+                $this->tree->init();
+                $this->openItem($item_id);
+            }
+        }
+        return false;
+    }
+
+    function execCommandAssertDeleteItem(){
+        $item_id = Request::option('item_id');
+        if ($this->isParentAdmin($item_id)){
+            $this->mode = "AssertDeleteItem";
+            $this->open_items[$item_id] = true;
+            $this->msg[$item_id] = "info§" ._("Sie beabsichtigen diesen Bereich inklusive aller Unterbereiche zu löschen. ")
+            . sprintf(_("Es werden insgesamt %s Bereiche gelöscht!"),count($this->tree->getKidsKids($item_id))+1)
+            . "<br>" . _("Wollen Sie diese Bereiche wirklich löschen?") . "<br>"
+            . LinkButton::createAccept(_('Ja!'),
+                    URLHelper::getURL($this->getSelf('cmd=DeleteItem&item_id='.$item_id)),
+                    ['title' => _('löschen')])
+            . "&nbsp;"
+            . LinkButton::createCancel(_('Nein!'),
+                    URLHelper::getURL($this->getSelf('cmd=Cancel&item_id='. $item_id)));
+        }
+        return false;
+    }
+
+    function execCommandDeleteItem(){
+        $item_id = Request::option('item_id');
+        $item_name = $this->tree->tree_data[$item_id]['name'];
+        if ($this->isParentAdmin($item_id) && $this->mode == "AssertDeleteItem"){
+            $this->openItem($this->tree->tree_data[$item_id]['parent_id']);
+            $items_to_delete = $this->tree->getKidsKids($item_id);
+            $items_to_delete[] = $item_id;
+            $deleted = $this->tree->DeleteItems($items_to_delete);
+            if ($deleted['items']){
+                $this->msg[$this->anchor] = "msg§" . sprintf(_("Der Bereich <b>%s</b> und alle Unterbereiche (insgesamt %s) wurden gelöscht. "),htmlReady($item_name),$deleted['items']);
+            } else {
+                $this->msg[$this->anchor] = "error§" . _("Fehler, es konnten keine Bereiche gelöscht werden !");
+            }
+            if ($deleted['entries']){
+                $this->msg[$this->anchor] .= sprintf(_("<br>Es wurden %s Veranstaltungszuordnungen gelöscht. "),$deleted['entries']);
+            }
+            $this->mode = "";
+        }
+        return true;
+    }
+
+    function execCommandMoveItem(){
+        $item_id = Request::option('item_id');
+        $this->anchor = $item_id;
+        $this->marked_item = $item_id;
+        $this->mode = "MoveItem";
+        return false;
+    }
+
+    function execCommandCopyItem(){
+        $item_id = Request::option('item_id');
+        $this->anchor = $item_id;
+        $this->marked_item = $item_id;
+        $this->mode = "CopyItem";
+        return false;
+    }
+
+    function execCommandDoMoveItem(){
+        $item_id = Request::option('item_id');
+        $item_to_move = $this->marked_item;
+        if ($this->mode == "MoveItem" && ($this->isItemAdmin($item_id) || $this->isParentAdmin($item_id))
+        && ($item_to_move != $item_id) && ($this->tree->tree_data[$item_to_move]['parent_id'] != $item_id)
+        && !$this->tree->isChildOf($item_to_move,$item_id)){
+            $view = DbView::getView('sem_tree');
+            $view->params = [$item_id, count($this->tree->getKids($item_id)), $item_to_move];
+            $rs = $view->get_query("view:SEM_TREE_MOVE_ITEM");
+            if ($rs->affected_rows()){
+                $this->msg[$item_to_move] = "msg§" . _("Bereich wurde verschoben.");
+            } else {
+                $this->msg[$item_to_move] = "error§" . _("Keine Verschiebung durchgeführt.");
+            }
+        }
+        $this->tree->init();
+        $this->openItem($item_to_move);
+        $this->mode = "";
+        return false;
+    }
+
+    function execCommandDoCopyItem(){
+        $item_id = Request::option('item_id');
+        $item_to_copy = $this->marked_item;
+        if ($this->mode == "CopyItem" && ($this->isItemAdmin($item_id) || $this->isParentAdmin($item_id))
+        && ($item_to_copy != $item_id) && ($this->tree->tree_data[$item_to_copy]['parent_id'] != $item_id)
+        && !$this->tree->isChildOf($item_to_copy,$item_id)){
+            $items_to_copy = $this->tree->getKidsKids($item_to_copy);
+            $seed = DbView::get_uniqid();
+            $new_item_id = md5($item_to_copy . $seed);
+            $parent_id = $item_id;
+            $num_copy = $this->tree->InsertItem($new_item_id,$parent_id,
+            addslashes($this->tree->tree_data[$item_to_copy]['name']),
+            addslashes($this->tree->tree_data[$item_to_copy]['info']),
+            $this->tree->getMaxPriority($parent_id)+1,
+            ($this->tree->tree_data[$item_to_copy]['studip_object_id'] ? $this->tree->tree_data[$item_to_copy]['studip_object_id'] : null),
+            $this->tree->tree_data[$item_to_copy]['type']);
+            if($num_copy){
+                if ($items_to_copy){
+                    for ($i = 0; $i < count($items_to_copy); ++$i){
+                        $num_copy += $this->tree->InsertItem(md5($items_to_copy[$i] . $seed),
+                        md5($this->tree->tree_data[$items_to_copy[$i]]['parent_id'] . $seed),
+                        addslashes($this->tree->tree_data[$items_to_copy[$i]]['name']),
+                        addslashes($this->tree->tree_data[$items_to_copy[$i]]['info']),
+                        $this->tree->tree_data[$items_to_copy[$i]]['priority'],
+                        ($this->tree->tree_data[$items_to_copy[$i]]['studip_object_id'] ? $this->tree->tree_data[$items_to_copy[$i]]['studip_object_id'] : null),
+                        $this->tree->tree_data[$item_to_copy]['type']);
+                    }
+                }
+                $items_to_copy[] = $item_to_copy;
+                for ($i = 0; $i < count($items_to_copy); ++$i){
+                    $sem_entries = $this->tree->getSemIds($items_to_copy[$i], false);
+                    if ($sem_entries){
+                        for ($j = 0; $j < count($sem_entries); ++$j){
+                            $num_entries += $this->tree->InsertSemEntry(md5($items_to_copy[$i] . $seed), $sem_entries[$j]);
+                        }
+                    }
+                }
+            }
+
+            if ($num_copy){
+                $this->msg[$new_item_id] = "msg§" . sprintf(_("%s Bereich(e) wurde(n) kopiert."), $num_copy) . "<br>"
+                . sprintf(_("%s Veranstaltungszuordnungen wurden kopiert"), $num_entries);
+            } else {
+                $this->msg[$new_item_id] = "error§" . _("Keine Kopie durchgeführt.");
+            }
+            $this->tree->init();
+            $this->openItem($new_item_id);
+        }
+        $this->mode = "";
+        return false;
+    }
+
+    function execCommandInsertFak(){
+        if($this->isItemAdmin("root") && Request::quoted('insert_fak')){
+            $view = DbView::getView('sem_tree');
+            $item_id = $view->get_uniqid();
+            $view->params = [$item_id,'root','',$this->tree->getNumKids('root')+1,'',Request::quoted('insert_fak'),0];
+            $rs = $view->get_query("view:SEM_TREE_INS_ITEM");
+            if ($rs->affected_rows()){
+                $this->tree->init();
+                $this->openItem($item_id);
+                $this->msg[$item_id] = "msg§" . _("Dieser Bereich wurde neu eingefügt.");
+                return false;
+            }
+        }
+        return false;
+    }
+
+    function execCommandMarkSem(){
+        $item_id = Request::option('item_id');
+        $marked_sem_array =  Request::quotedArray('marked_sem');
+        $marked_sem = array_values(array_unique($marked_sem_array));
+        $sem_aktion = explode("_",Request::quoted('sem_aktion'));
+        if (($sem_aktion[0] == 'mark' || $sem_aktion[1] == 'mark') && count($marked_sem)){
+            $count_mark = 0;
+            for ($i = 0; $i < count($marked_sem); ++$i){
+                if (!isset($this->marked_sem[$marked_sem[$i]])){
+                    ++$count_mark;
+                    $this->marked_sem[$marked_sem[$i]] = true;
+                }
+            }
+            if ($count_mark){
+                $this->msg[$item_id] = "msg§" . sprintf(_("Es wurde(n) %s Veranstaltung(en) der Merkliste hinzugefügt."),$count_mark);
+            }
+        }
+        if ($this->isItemAdmin($item_id)){
+            if (($sem_aktion[0] == 'del' || $sem_aktion[1] == 'del') && count($marked_sem)){
+                $not_deleted = [];
+                foreach($marked_sem as $key => $seminar_id){
+                    $seminar = new Seminar($seminar_id);
+                    if(count($seminar->getStudyAreas()) == 1){
+                        $not_deleted[] = $seminar->getName();
+                        unset($marked_sem[$key]);
+                    }
+                }
+                if ($this->msg[$item_id]){
+                    $this->msg[$item_id] .= "<br>";
+                } else {
+                    $this->msg[$item_id] = "msg§";
+                }
+                if(count($marked_sem)){
+                    $count_del = $this->tree->DeleteSemEntries($item_id, $marked_sem);
+                    $this->msg[$item_id] .= sprintf(_("%s Veranstaltungszuordnung(en) wurde(n) aufgehoben."),$count_del);
+                }
+                if(count($not_deleted)){
+                    $this->msg[$item_id] .= '<br>'
+                                         . sprintf(_("Für folgende Veranstaltungen wurde die Zuordnung nicht aufgehoben, da es die einzige Zuordnung ist: %s")
+, '<br>'.htmlready(join(', ', $not_deleted)));
+                }
+            }
+            $this->anchor = $item_id;
+            $this->open_items[$item_id] = true;
+            return true;
+        }
+        return false;
+    }
+
+    function execCommandCancel(){
+        $item_id = Request::option('item_id');
+        $this->mode = "";
+        $this->anchor = $item_id;
+        return false;
+    }
+
+    function showSemTree(){
+        ?>
+        <script type="text/javascript">
+        function invert_selection(the_form){
+            my_elements = document.forms[the_form].elements['marked_sem[]'];
+            if(!my_elements.length){
+                if(my_elements.checked)
+                my_elements.checked = false;
+                else
+                my_elements.checked = true;
+            } else {
+                for(i = 0; i < my_elements.length; ++i){
+                    if(my_elements[i].checked)
+                    my_elements[i].checked = false;
+                    else
+                    my_elements[i].checked = true;
+                }
+            }
+        }
+        </script>
+        <?
+        echo "\n<table width=\"99%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
+        if ($this->start_item_id != 'root'){
+            echo "\n<tr><td class=\"table_row_odd\" align=\"left\" valign=\"top\"><div style=\"font-size:10pt;margin-left:10px\"><b>"
+            . _("Studienbereiche") . ":</b><br>" .  $this->getSemPath()
+            . "</div></td></tr>";
+        }
+        echo "\n<tr><td class=\"blank\"  align=\"left\" valign=\"top\">";
+        $this->showTree($this->start_item_id);
+        echo "\n</td></tr></table>";
+    }
+
+    function getSemPath(){
+        $ret = "";
+        //$ret = "<a href=\"" . parent::getSelf("start_item_id=root") . "\">" .htmlReady($this->tree->root_name) . "</a>";
+        if ($parents = $this->tree->getParents($this->start_item_id)){
+            for($i = count($parents)-1; $i >= 0; --$i){
+                $ret .= " &gt; <a class=\"tree\" href=\"" . URLHelper::getLink($this->getSelf("start_item_id={$parents[$i]}&open_item={$parents[$i]}",false))
+                . "\">" .htmlReady($this->tree->tree_data[$parents[$i]]["name"]) . "</a>";
+            }
+        }
+        return $ret;
+    }
+
+    /**
+    * returns html for the icons in front of the name of the item
+    *
+    * @access   private
+    * @param    string  $item_id
+    * @return   string
+    */
+    function getItemHeadPics($item_id){
+        $head = $this->getItemHeadFrontPic($item_id);
+        $head .= "\n<td  class=\"printhead\" nowrap  align=\"left\" valign=\"bottom\">";
+        if ($this->tree->hasKids($item_id)){
+            $head .= Icon::create('folder-full', Icon::ROLE_CLICKABLE, ['title' => !empty($this->open_ranges[$item_id]) ? _('Alle Unterelemente schliessen') : _('Alle Unterelemente öffnen')])->asImg(['class' => 'text-top']);
+        } else {
+            $head .= Icon::create('folder-empty', 'clickable', ['title' => _('Dieses Element hat keine Unterelemente')])->asImg();
+        }
+        return $head . "</td>";
+    }
+
+    function getItemContent($item_id){
+        if ($item_id == $this->edit_item_id) {
+            return $this->getEditItemContent();
+        }
+        if (empty($GLOBALS['SEM_TREE_TYPES'][$this->tree->getValue($item_id, 'type')]['editable'])){
+            $is_not_editable = true;
+            $this->msg[$item_id] = "info§" . sprintf(_("Der Typ dieses Elementes verbietet eine Bearbeitung."));
+        }
+        if ($item_id == $this->move_item_id) {
+            $this->msg[$item_id] = "info§" . sprintf(_("Dieses Element wurde zum Verschieben / Kopieren markiert. Bitte wählen Sie ein Einfügesymbol %s aus, um das Element zu verschieben / kopieren."), Icon::create('arr_2right', 'sort', ['title' => "Einfügesymbol"])->asImg(16, ["alt" => "Einfügesymbol"]));
+        }
+        $content = "\n<table width=\"90%\" cellpadding=\"2\" cellspacing=\"2\" align=\"center\" style=\"font-size:10pt;\">";
+        $content .= $this->getItemMessage($item_id);
+        $content .= "\n<tr><td style=\"font-size:10pt;\">";
+        if (empty($is_not_editable)) {
+            if ($this->isItemAdmin($item_id) ){
+                $content .= LinkButton::create(_('Neues Objekt'),
+                        URLHelper::getURL($this->getSelf('cmd=NewItem&item_id='.$item_id)),
+                        ['title' => _('Innerhalb dieser Ebene ein neues Element einfügen')]) . '&nbsp;';
+                $content .= LinkButton::create(_('Sortieren'),
+                        URLHelper::getURL($this->getSelf('cmd=OrderItemsAlphabetically&sort_id='.$item_id)),
+                        ['title' => _('Sortiert die untergeordneten Elemente alphabetisch')]) . '&nbsp;';
+            }
+            if ($this->isParentAdmin($item_id) && $item_id != "root"){
+                $content .= LinkButton::create(_('Bearbeiten'),
+                        URLHelper::getURL($this->getSelf('cmd=EditItem&item_id=' . $item_id)),
+                        ['title' => 'Dieses Element bearbeiten']) . '&nbsp;';
+
+                $content .= LinkButton::create(_('Löschen'),
+                        URLHelper::getURL($this->getSelf('cmd=AssertDeleteItem&item_id=' . $item_id)),
+                        ['title' => _('Dieses Element löschen')]) . '&nbsp;';
+
+                if ($this->move_item_id == $item_id && ($this->mode == "MoveItem" || $this->mode == "CopyItem")){
+                    $content .= LinkButton::create(_('Abbrechen'),
+                            URLHelper::getURL($this->getSelf('cmd=Cancel&item_id=' . $item_id)),
+                            ['title' => _('Verschieben / Kopieren abbrechen')]) . '&nbsp;';
+                } else {
+                    $content .= LinkButton::create(_('Verschieben'),
+                            URLHelper::getURL($this->getSelf('cmd=MoveItem&item_id='.$item_id)),
+                            ['title' => _('Dieses Element in eine andere Ebene verschieben')]) . '&nbsp;';
+                    $content .= LinkButton::create(_('Kopieren'),
+                            URLHelper::getURL($this->getSelf('cmd=CopyItem&item_id='.$item_id)),
+                            ['title' => _('Dieses Element in eine andere Ebene kopieren')]);
+                }
+            }
+        }
+        if ($item_id == 'root' && $this->isItemAdmin($item_id)){
+            $view = DbView::getView('sem_tree');
+            $rs = $view->get_query("view:SEM_TREE_GET_LONELY_FAK");
+            $content .= "\n<p><form action=\"" . URLHelper::getLink($this->getSelf("cmd=InsertFak")) . "\" method=\"post\" class=\"default\">"
+                . CSRFProtection::tokenTag()
+                . '<div><label>'
+                . _("Stud.IP-Fakultät einfügen")
+                . "\n<select style=\"width:200px;\" name=\"insert_fak\">";
+            while($rs->next_record()){
+                $content .= "\n<option value=\"" . $rs->f("Institut_id") . "\">" . htmlReady(my_substr($rs->f("Name"),0,50)) . "</option>";
+            }
+            $content .= "</select></label></div><div class=\"col-1\"> " . Button::create(_('Eintragen'), ['title' => _("Fakultät einfügen")]) . "</div></form></p>";
+        }
+        $content .= "</td></tr></table>";
+
+        $content .= "\n<table border=\"0\" width=\"90%\" cellpadding=\"2\" cellspacing=\"0\" align=\"center\" style=\"font-size:10pt\">";
+        if ($item_id == "root"){
+            $content .= "\n<tr><td  class=\"table_header_bold\" align=\"left\" style=\"font-size:10pt;\">" . htmlReady($this->tree->root_name) ." </td></tr>";
+            $content .= "\n<tr><td  class=\"table_row_even\" align=\"left\" style=\"font-size:10pt;\">" . htmlReady($this->root_content) ." </td></tr>";
+            $content .= "\n</table>";
+            return $content;
+        }
+        if ($this->tree->tree_data[$item_id]['info']){
+            $content .= "\n<tr><td style=\"font-size:10pt;\" class=\"table_row_even\" align=\"left\" colspan=\"3\">";
+            $content .= formatReady($this->tree->tree_data[$item_id]['info']) . "</td></tr>";
+        }
+        $content .= "<tr><td style=\"font-size:10pt;\"colspan=\"3\">&nbsp;</td></tr>";
+        if ($this->tree->getNumEntries($item_id)) {
+            $content .= "<tr><td class=\"table_row_even\" style=\"font-size:10pt;\" align=\"left\" colspan=\"3\"><b>" . _("Einträge auf dieser Ebene:");
+            $content .= "</b>\n</td></tr>";
+            $entries = $this->tree->getSemData($item_id);
+            $content .= $this->getSemDetails($entries,$item_id);
+        } else {
+            $content .= "\n<tr><td class=\"table_row_even\" style=\"font-size:10pt;\" colspan=\"3\">" . _("Keine Einträge auf dieser Ebene vorhanden!") . "</td></tr>";
+        }
+        $content .= "</table>";
+        return $content;
+    }
+
+    function getSemDetails($snap, $item_id, $lonely_sem = false){
+        $form_name = DbView::get_uniqid();
+        $content = "<form class=\"default\" name=\"$form_name\" action=\"" . URLHelper::getLink($this->getSelf("cmd=MarkSem")) ."\" method=\"post\">
+        <input type=\"hidden\" name=\"item_id\" value=\"$item_id\">";
+        $content .= CSRFProtection::tokenTag();
+        $group_by_data = $snap->getGroupedResult("sem_number", "seminar_id");
+        $sem_data = $snap->getGroupedResult("seminar_id");
+        $group_by_duration = $snap->getGroupedResult("sem_number_end", ["sem_number","seminar_id"]);
+        foreach ($group_by_duration as $sem_number_end => $detail){
+            if ($sem_number_end != -1 && ($detail['sem_number'][$sem_number_end] && count($detail['sem_number']) == 1)){
+                continue;
+            } else {
+                foreach ($detail['seminar_id'] as $seminar_id => $foo){
+                    $start_sem = key($sem_data[$seminar_id]["sem_number"]);
+                    if ($sem_number_end == -1){
+                        $sem_number_end = count($this->tree->sem_dates)-1;
+                    }
+                    for ($i = $start_sem; $i <= $sem_number_end; ++$i){
+                        if ($group_by_data[$i] && !$tmp_group_by_data[$i]){
+                            foreach($group_by_data[$i]['seminar_id'] as $id => $bar){
+                                $tmp_group_by_data[$i]['seminar_id'][$id] = key($sem_data[$id]["Name"]);
+                            }
+                        }
+                        $tmp_group_by_data[$i]['seminar_id'][$seminar_id] = key($sem_data[$seminar_id]["Name"]);
+                    }
+                }
+            }
+        }
+        if (is_array($tmp_group_by_data)){
+            foreach ($tmp_group_by_data as $start_sem => $detail){
+                $group_by_data[$start_sem] = $detail;
+            }
+        }
+
+        foreach ($group_by_data as $group_field => $sem_ids){
+            foreach ($sem_ids['seminar_id'] as $seminar_id => $foo){
+                $name = mb_strtolower(key($sem_data[$seminar_id]["Name"]));
+                $name = str_replace("ä","ae",$name);
+                $name = str_replace("ö","oe",$name);
+                $name = str_replace("ü","ue",$name);
+                $group_by_data[$group_field]['seminar_id'][$seminar_id] = $name;
+            }
+            uasort($group_by_data[$group_field]['seminar_id'], 'strnatcmp');
+        }
+
+        krsort($group_by_data, SORT_NUMERIC);
+
+        foreach ($group_by_data as $sem_number => $sem_ids){
+            $content .= "\n<tr><td class=\"content_seperator\" colspan=\"3\" style=\"font-size:10pt;\" >" . $this->tree->sem_dates[$sem_number]['name'] . "</td></tr>";
+            if (is_array($sem_ids['seminar_id'])){
+                foreach(array_keys($sem_ids['seminar_id']) as $seminar_id) {
+                    $sem_name = key($sem_data[$seminar_id]["Name"]);
+                    $sem_number_start = key($sem_data[$seminar_id]["sem_number"]);
+                    $sem_number_end = key($sem_data[$seminar_id]["sem_number_end"]);
+                    if ($sem_number_start != $sem_number_end){
+                        $sem_name .= " (" . $this->tree->sem_dates[$sem_number_start]['name'] . " - ";
+                        $sem_name .= (($sem_number_end == -1) ? _("unbegrenzt") : $this->tree->sem_dates[$sem_number_end]['name']) . ")";
+                    }
+                    $content .= "<tr><td class=\"table_row_even\" width=\"1%\"><input type=\"checkbox\" name=\"marked_sem[]\" value=\"$seminar_id\" style=\"vertical-align:middle\">
+                    </td><td class=\"table_row_even\" style=\"font-size:10pt;\"><a href=\"dispatch.php/course/details/?sem_id=". $seminar_id
+                    ."&send_from_search=true&send_from_search_page=" . rawurlencode(URLHelper::getLink($this->getSelf())) . "\">" . htmlReady($sem_name) . "</a>
+                    </td><td class=\"table_row_even\" align=\"right\" style=\"font-size:10pt;\">(";
+                    $doz_name = array_keys($sem_data[$seminar_id]['doz_name']);
+                    $doz_uname = array_keys($sem_data[$seminar_id]['doz_uname']);
+                    if (is_array($doz_name)){
+                        uasort($doz_name, 'strnatcasecmp');
+                        $i = 0;
+                        foreach ($doz_name as $index => $value){
+                            if ($i == 4){
+                                $content .= "... <a href=\"dispatch.php/course/details/?sem_id=". $seminar_id
+                                ."&send_from_search=true&send_from_search_page=" . rawurlencode(URLHelper::getLink($this->getSelf())) . "\">("._("mehr").")</a>";
+                                break;
+                            }
+                            $content .= "<a href=\"dispatch.php/profile?username=" . $doz_uname[$index] ."\">" . htmlReady($value) . "</a>";
+                            if($i != count($doz_name)-1){
+                                $content .= ", ";
+                            }
+                            ++$i;
+                        }
+                    }
+                    $content .= ") </td></tr>";
+                }
+            }
+        }
+        $content .= "<tr><td class=\"table_row_even\" colspan=\"2\">"
+            . LinkButton::create(_('Auswählen'), ['title' => _('Auswahl umkehren'), 'onClick' => 'invert_selection(\''. $form_name .'\');return false;'])
+            . "</td><td class=\"table_row_even\" align=\"right\"><div class=\"hgroup\">
+        <select name=\"sem_aktion\" style=\"margin-right: 1em;\" " . tooltip(_("Aktion auswählen"),true) . ">
+        <option value=\"mark\">" . _("in Merkliste übernehmen") . "</option>";
+        if (!$lonely_sem && $this->isItemAdmin($item_id)){
+            $content .= "<option value=\"del_mark\">" . _("löschen und in Merkliste übernehmen") . "</option>
+            <option value=\"del\">" . _("löschen") . "</option>";
+        }
+        $content .= "</select>" . Button::createAccept(_('OK'), ['title' => _("Gewählte Aktion starten")])
+                 . "</div></td></tr> </form>";
+        return $content;
+    }
+
+    function getEditItemContent(){
+        ob_start();
+        ?>
+        <form name="item_form" action="<?= URLHelper::getLink($this->getSelf("cmd=InsertItem&item_id={$this->edit_item_id}")) ?>" method="POST" class="default" style="width: 90%; margin: auto;">
+            <?= CSRFProtection::tokenTag(); ?>
+            <input type="hidden" name="parent_id" value="<?= $this->tree->tree_data[$this->edit_item_id]['parent_id'] ?>">
+
+            <table style="width: 100%"><?= $this->getItemMessage($this->edit_item_id,2) ?></table>
+
+            <fieldset>
+                <legend><?= _("Bereich editieren") ?></legend>
+
+                <label>
+                    <?= _("Name des Elements") ?>
+                    <input type="text" name="edit_name"
+                        <?= ($this->tree->tree_data[$this->edit_item_id]['studip_object_id']) ? 'disabled="disabled"' : '' ?>
+                           value="<?= htmlReady($this->tree->tree_data[$this->edit_item_id]['name']) ?>">
+                </label>
+
+               <? if (count($GLOBALS['SEM_TREE_TYPES']) > 1) : ?>
+               <label>
+                   <?= _("Typ des Elements") ?>
+                    <select name="edit_type">
+                    <? foreach ($GLOBALS['SEM_TREE_TYPES'] as $sem_tree_type_key => $sem_tree_type) :
+                        if ($sem_tree_type['editable']) :
+                            $selected = $sem_tree_type_key == $this->tree->getValue($this->edit_item_id, 'type') ? 'selected' : '';
+                            echo '<option value="'.htmlReady($sem_tree_type_key).'"'.$selected.'>';
+                            echo htmlReady($sem_tree_type['name'] ? $sem_tree_type['name'] : $sem_tree_type_key);
+                            echo '</option>';
+                        endif;
+                    endforeach;
+                    ?>
+                    </select>
+                </label>
+                <? else : # Auswahl ausblenden, wenn nur ein Typ vorhanden ?>
+                <input type='hidden' name='edit_type' value='0'>
+                <? endif ?>
+
+                <? $buttonlink_id = ($this->mode == "NewItem") ? $this->tree->tree_data[$this->edit_item_id]['parent_id'] : $this->edit_item_id; ?>
+
+                <label>
+                    <?= _("Infotext:") ?>
+                    <textarea rows="5" name="edit_info" wrap="virtual"><?= htmlReady($this->tree->tree_data[$this->edit_item_id]['info']) ?></textarea>
+                </label>
+            </fieldset>
+
+            <footer>
+                <?= Button::createAccept(_('Absenden'), ['title' => _('Einstellungen übernehmen')]) ?>
+                <?= LinkButton::createCancel(_('Abbrechen'),
+                    URLHelper::getURL($this->getSelf('cmd=Cancel&item_id='.$buttonlink_id)),
+                    ['title' => _('Aktion abbrechen')])
+                ?>
+            </footer>
+        </form>
+
+        <?
+        return ob_get_clean();
+    }
+
+
+    function isItemAdmin($item_id){
+        global $auth;
+        if ($auth->auth['perm'] == "root"){
+            return true;
+        }
+        if (!($admin_id = $this->tree->tree_data[$this->tree->getAdminRange($item_id)]['studip_object_id'])){
+            return false;
+        }
+        if(!isset($this->admin_ranges[$admin_id])){
+            $view = DbView::getView('sem_tree');
+            $view->params[0] = $auth->auth['uid'];
+            $view->params[1] = $admin_id;
+            $rs = $view->get_query("view:SEM_TREE_CHECK_PERM");
+            $this->admin_ranges[$admin_id] = ($rs->next_record()) ? true : false;
+        }
+        if ($this->admin_ranges[$admin_id]){
+            return true;
+        } else {
+            return false;
+        }
+    }
+
+    function isParentAdmin($item_id){
+        return $this->isItemAdmin($this->tree->tree_data[$item_id]['parent_id']);
+    }
+
+    function getItemHead($item_id){
+        $head = "";
+        if (($this->mode == "MoveItem" || $this->mode == "CopyItem") && ($this->isItemAdmin($item_id) || $this->isParentAdmin($item_id))
+        && ($this->move_item_id != $item_id) && ($this->tree->tree_data[$this->move_item_id]['parent_id'] != $item_id)
+        && !$this->tree->isChildOf($this->move_item_id,$item_id)){
+            $head .= "<a href=\"" . URLHelper::getLink($this->getSelf("cmd=Do" . $this->mode . "&item_id=$item_id")) . "\">"
+            . Icon::create('arr_2right', 'sort', ['title' => _("An dieser Stelle einfügen")])->asImg(16, ["alt" => _("An dieser Stelle einfügen")])."</a>&nbsp;";
+        }
+        $head .= parent::getItemHead($item_id);
+        if ($item_id != "root"){
+            $head .= " (" . $this->tree->getNumEntries($item_id,true) . ") " ;
+        }
+        if ($item_id != $this->start_item_id && $this->isParentAdmin($item_id) && $item_id != $this->edit_item_id){
+            $head .= "</td><td nowrap align=\"right\" valign=\"bottom\" class=\"printhead\">";
+            if (!$this->tree->isFirstKid($item_id)){
+                $head .= "<a href=\"". URLHelper::getLink($this->getSelf("cmd=OrderItem&direction=up&item_id=$item_id")) .
+                "\">" .  Icon::create('arr_2up', 'sort')->asImg(['class' => 'text-top', 'title' => _("Element nach oben")]) .
+                "</a>";
+            }
+            if (!$this->tree->isLastKid($item_id)){
+                $head .= "<a href=\"". URLHelper::getLink($this->getSelf("cmd=OrderItem&direction=down&item_id=$item_id")) .
+                "\">" . Icon::create('arr_2down', 'sort')->asImg(['class' => 'text-top', 'title' => _("Element nach unten")]) .
+                "</a>";
+            }
+            $head .= "&nbsp;";
+        }
+        return $head;
+    }
+
+    function getItemMessage($item_id,$colspan = 1){
+        $content = "";
+        if (!empty($this->msg[$item_id])) {
+            $msg = explode("§",$this->msg[$item_id]);
+            $pics = [
+                'error' => Icon::create('decline', 'attention'),
+                'info'  => Icon::create('exclaim', 'inactive'),
+                'msg'   => Icon::create('accept', 'accept')];
+            $content = "\n<tr><td colspan=\"{$colspan}\"><table border=\"0\" cellspacing=\"0\" cellpadding=\"2\" width=\"100%\" style=\"font-size:10pt\">
+                        <tr><td class=\"blank\" align=\"center\" width=\"25\">" .  $pics[$msg[0]]->asImg(['class' => 'text-top']) . "</td>
+            <td class=\"blank\" align=\"left\">" . $msg[1] . "</td></tr>
+            </table></td></tr><tr>";
+        }
+        return $content;
+    }
+
+    function getSelf($param = "", $with_start_item = true){
+        $url_params = "foo=" . DbView::get_uniqid();
+        if ($this->mode) $url_params .= "&mode=" . $this->mode;
+        if ($with_start_item) $url_params .= "&start_item_id=" . $this->start_item_id;
+        if ($param) $url_params .= '&' . $param;
+        return parent::getSelf($url_params);
+    }
+}
+//test
+//page_open(array("sess" => "Seminar_Session", "auth" => "Seminar_Default_Auth", "perm" => "Seminar_Perm", "user" => "Seminar_User"));
+//include 'lib/include/html_head.inc.php';
+//include ('lib/seminar_open.php'); // initialise Stud.IP-Session
+//$test = new StudipSemTreeViewAdmin(Request::quoted('start_item_id'));
+//$test->showSemTree();
+//echo "<hr><pre>";
+//print_r($_open_items);
+//page_close();
+?>