class.ilInternalLink.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilInternalLink
{
    public static function _deleteAllLinksOfSource($a_source_type, $a_source_id, $a_lang = "-")
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $lang_where = "";
        if ($a_lang != "") {
            $lang_where = " AND source_lang = " . $ilDB->quote($a_lang, "text");
        }
        
        $q = "DELETE FROM int_link WHERE source_type = " .
            $ilDB->quote($a_source_type, "text") . " AND source_id=" .
            $ilDB->quote((int) $a_source_id, "integer") .
            $lang_where;
        $ilDB->manipulate($q);
    }
 
    public static function _deleteAllLinksToTarget($a_target_type, $a_target_id, $a_target_inst = 0)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->manipulateF(
            "DELETE FROM int_link WHERE target_type = %s " .
            " AND target_id = %s AND target_inst = %s ",
            array("text", "integer", "integer"),
            array($a_target_type, (int) $a_target_id, (int) $a_target_inst)
        );
    }
 
    public static function _saveLink(
        $a_source_type,
        $a_source_id,
        $a_target_type,
        $a_target_id,
        $a_target_inst = 0,
        $a_source_lang = "-"
    ) {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->replace(
            "int_link",
            array(
                "source_type" => array("text", $a_source_type),
                "source_id" => array("integer", (int) $a_source_id),
                "source_lang" => array("text", $a_source_lang),
                "target_type" => array("text", $a_target_type),
                "target_id" => array("integer", (int) $a_target_id),
                "target_inst" => array("integer", (int) $a_target_inst)
            ),
            array()
        );
    }
 
    public static function _getSourcesOfTarget($a_target_type, $a_target_id, $a_target_inst)
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $q = "SELECT * FROM int_link WHERE " .
            "target_type = " . $ilDB->quote($a_target_type, "text") . " AND " .
            "target_id = " . $ilDB->quote((int) $a_target_id, "integer") . " AND " .
            "target_inst = " . $ilDB->quote((int) $a_target_inst, "integer");
        $source_set = $ilDB->query($q);
        $sources = array();
        while ($source_rec = $ilDB->fetchAssoc($source_set)) {
            $sources[$source_rec["source_type"] . ":" . $source_rec["source_id"] . ":" . $source_rec["source_lang"]] =
                array("type" => $source_rec["source_type"], "id" => $source_rec["source_id"],
                    "lang" => $source_rec["source_lang"]);
        }
 
        return $sources;
    }
 
    public static function _getTargetsOfSource($a_source_type, $a_source_id, $a_source_lang = "-")
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $lang_where = "";
        if ($a_source_lang != "") {
            $lang_where = " AND source_lang = " . $ilDB->quote($a_source_lang, "text");
        }
 
        $q = "SELECT * FROM int_link WHERE " .
            "source_type = " . $ilDB->quote($a_source_type, "text") . " AND " .
            "source_id = " . $ilDB->quote((int) $a_source_id, "integer") .
            $lang_where;
 
        $target_set = $ilDB->query($q);
        $targets = array();
        while ($target_rec = $ilDB->fetchAssoc($target_set)) {
            $targets[$target_rec["target_type"] . ":" . $target_rec["target_id"] . ":" . $target_rec["target_inst"]] =
                array("type" => $target_rec["target_type"], "id" => $target_rec["target_id"],
                "inst" => $target_rec["target_inst"]);
        }
 
        return $targets;
    }
 
    public static function _getIdForImportId($a_type, $a_target)
    {
        include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
        switch ($a_type) {
            case "PageObject":
                $id = ilLMObject::_getIdForImportId($a_target);
                if ($id > 0) {
                    return "il__pg_" . $id;
                }
                break;
 
            case "StructureObject":
                $id = ilLMObject::_getIdForImportId($a_target);
                if ($id > 0) {
                    return "il__st_" . $id;
                }
                break;
 
            case "GlossaryItem":
                $id = ilGlossaryTerm::_getIdForImportId($a_target);
                //echo "+".$id."+".$a_target."+";
                if ($id > 0) {
                    return "il__git_" . $id;
                }
                break;
 
            case "WikiPage":
                // no import IDs for wiki pages (yet)
                //$id = ilGlossaryTerm::_getIdForImportId($a_target);
                $id = 0;
                if ($id > 0) {
                    return "il__wpage_" . $id;
                }
                break;
 
            case "MediaObject":
                $id = ilObjMediaObject::_getIdForImportId($a_target);
                if ($id > 0) {
                    return "il__mob_" . $id;
                }
                break;
                
            case "RepositoryItem":
                
                $tarr = explode("_", $a_target);
                $import_id = $a_target;
                
                // if a ref id part is given, strip this
                // since this will not be part of an import id
                // see also bug #6685
                if ($tarr[4] != "") {
                    $import_id = $tarr[0] . "_" . $tarr[1] . "_" . $tarr[2] . "_" . $tarr[3];
                }
 
                $id = ilObject::_getIdForImportId($import_id);
 
                // get ref id for object id
                // (see ilPageObject::insertInstIntoIDs for the export procedure)
                if ($id > 0) {
                    $refs = ilObject::_getAllReferences($id);
                    foreach ($refs as $ref) {
                        return "il__obj_" . $ref;
                    }
                }
 
                // 26 Sep 2018: moved this under the import id handling above
                // If an imported object is found, this is always preferred.
                // see also bug #23324
                if (ilInternalLink::_extractInstOfTarget($a_target) == IL_INST_ID
                    && IL_INST_ID > 0) {
                    // does it have a ref id part?
                    if ($tarr[4] != "") {
                        return "il__obj_" . $tarr[4];
                    }
                }
 
                break;
 
        }
        return false;
    }
 
    public static function _exists($a_type, $a_target)
    {
        global $DIC;
 
        $tree = $DIC->repositoryTree();
        
        switch ($a_type) {
            case "PageObject":
            case "StructureObject":
                include_once("./Modules/LearningModule/classes/class.ilLMObject.php");
                return ilLMObject::_exists($a_target);
                break;
 
            case "GlossaryItem":
                return ilGlossaryTerm::_exists($a_target);
                break;
 
            case "MediaObject":
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                return ilObjMediaObject::_exists($a_target);
                break;
                
            case "WikiPage":
                include_once("./Modules/Wiki/classes/class.ilWikiPage.php");
                return ilWikiPage::_exists("wiki", (int) $a_target);
                break;
                
            case "RepositoryItem":
                if (is_int(strpos($a_target, "_"))) {
                    $ref_id = ilInternalLink::_extractObjIdOfTarget($a_target);
                    return $tree->isInTree($ref_id);
                }
                break;
        }
        return false;
    }
 
    
    public static function _extractInstOfTarget($a_target)
    {
        if (!is_int(strpos($a_target, "__"))) {
            $target = explode("_", $a_target);
            if ($target[1] > 0) {
                return $target[1];
            }
        }
        return false;
    }
    
    public static function _removeInstFromTarget($a_target)
    {
        if (!is_int(strpos($a_target, "__"))) {
            $target = explode("_", $a_target);
            if ($target[1] > 0) {
                return "il__" . $target[2] . "_" . $target[3];
            }
        }
        return false;
    }
    
    public static function _extractObjIdOfTarget($a_target)
    {
        $target = explode("_", $a_target);
        return $target[count($target) - 1];
    }
 
    public static function _extractTypeOfTarget($a_target)
    {
        $target = explode("_", $a_target);
        return $target[count($target) - 2];
    }
 
    public static function searchUsers($a_search_str)
    {
        $result = new ilSearchResult();
 
        $query_parser = new ilQueryParser($a_search_str, '%_');
        $query_parser->setCombination(QP_COMBINATION_AND);
        $query_parser->setMinWordLength(3);
        $query_parser->parse();
 
        $user_search = ilObjectSearchFactory::_getUserSearchInstance($query_parser);
        $user_search->enableActiveCheck(true);
        $user_search->setFields(array('login'));
        $result_obj = $user_search->performSearch();
        $result->mergeEntries($result_obj);
 
        $user_search->setFields(array('firstname'));
        $result_obj = $user_search->performSearch();
        $result->mergeEntries($result_obj);
 
        $user_search->setFields(array('lastname'));
        $result_obj = $user_search->performSearch();
        $result->mergeEntries($result_obj);
 
        $result->setMaxHits(100000);
        $result->preventOverwritingMaxhits(true);
        $result->filter(ROOT_FOLDER_ID, true);
 
        // Filter users (depends on setting in user accounts)
        include_once 'Services/User/classes/class.ilUserFilter.php';
        $users = ilUserFilter::getInstance()->filter($result->getResultIds());
 
        include_once("./Services/User/classes/class.ilObjUser.php");
        $p = ilObjUser::getProfileStatusOfUsers($users);
 
        $users = array_intersect($users, $p["public"]);
 
        return $users;
    }
}