ILIAS\MediaPool\MediaPoolRepository Class Reference

Media pool repository. More...

Collaboration diagram for ILIAS\MediaPool\MediaPoolRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	getItems (int $pool_id, string $title_filter="", string $format_filter="", string $keyword_filter="", string $caption_filter="")

Protected Member Functions
	getMediaObjects (int $pool_id, string $title_filter="", string $format_filter="", string $keyword_filter='', string $caption_filter="")
	getContentSnippets (int $pool_id, string $title_filter="", string $format_filter="", string $keyword_filter='', string $caption_filter="")

Protected Attributes
ilDBInterface	$db

Detailed Description

Media pool repository.

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 27 of file class.MediaPoolRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\MediaPool\MediaPoolRepository::__construct

(

\ilDBInterface

$db = null

)

Definition at line 31 of file class.MediaPoolRepository.php.

    {
        global $DIC;
        $this->db = ($db) ?: $DIC->database();
    }

References ILIAS\MediaPool\MediaPoolRepository\$db, and $DIC.

Member Function Documentation

getContentSnippets()

ILIAS\MediaPool\MediaPoolRepository::getContentSnippets ( int  $pool_id, string  $title_filter = "", string  $format_filter = "", string  $keyword_filter = '', string  $caption_filter = ""  )

protected

Returns

array[]

Definition at line 103 of file class.MediaPoolRepository.php.

     : array {
        // format filter snippets come with internal "pg" format
        if (!in_array($format_filter, ["pg", ""])) {
            return [];
        }
 
        // snippets do not have no caption
        if ($caption_filter != "") {
            return [];
        }
 
        $db = $this->db;
 
        $query = "SELECT DISTINCT mep_tree.*, mep_item.* " .
            "FROM mep_tree JOIN mep_item ON (mep_tree.child = mep_item.obj_id) ";
 
        $query .=
            " WHERE mep_tree.mep_id = " . $db->quote($pool_id, "integer") .
            " AND mep_item.type = " . $db->quote("pg", "text");
 
        // filter
        if (trim($title_filter) != "") {    // title
            $query .= " AND " . $db->like("mep_item.title", "text", "%" . trim($title_filter) . "%");
        }
 
        $objs = array();
        $set = $db->query($query);
        while ($rec = $db->fetchAssoc($set)) {
            //$rec["foreign_id"] = $rec["obj_id"];
            //$rec["obj_id"] = "";
            $objs[] = $rec;
        }
 
        // Keyword filter
        if ($keyword_filter) {
            include_once './Services/MetaData/classes/class.ilMDKeyword.php';
            $res = \ilMDKeyword::_searchKeywords($keyword_filter, 'mpg', $pool_id);
            foreach ($objs as $obj) {
                if (in_array($obj['obj_id'], $res)) {
                    $filtered[] = $obj;
                }
            }
            return (array) $filtered;
        }
        return $objs;
    }

getItems()

ILIAS\MediaPool\MediaPoolRepository::getItems	(	int	$pool_id,
		string	$title_filter = "",
		string	$format_filter = "",
		string	$keyword_filter = "",
		string	$caption_filter = ""
	)

Returns

array[]

Definition at line 159 of file class.MediaPoolRepository.php.

     : array {
        $mobs = $this->getMediaObjects(
            $pool_id,
            $title_filter,
            $format_filter,
            $keyword_filter,
            $caption_filter
        );
 
        $snippets = $this->getContentSnippets(
            $pool_id,
            $title_filter,
            $format_filter,
            $keyword_filter,
            $caption_filter
        );
 
        return \ilArrayUtil::sortArray(array_merge($mobs, $snippets), "title", "asc");
    }

getMediaObjects()

ILIAS\MediaPool\MediaPoolRepository::getMediaObjects ( int  $pool_id, string  $title_filter = "", string  $format_filter = "", string  $keyword_filter = '', string  $caption_filter = ""  )

protected

Returns

array[]

Definition at line 40 of file class.MediaPoolRepository.php.

     : array {
        $db = $this->db;
 
        $query = "SELECT DISTINCT mep_tree.*, object_data.* " .
            "FROM mep_tree JOIN mep_item ON (mep_tree.child = mep_item.obj_id) " .
            " JOIN object_data ON (mep_item.foreign_id = object_data.obj_id) ";
 
        if ($format_filter != "" or $caption_filter != '') {
            $query .= " JOIN media_item ON (media_item.mob_id = object_data.obj_id) ";
        }
 
        $query .=
            " WHERE mep_tree.mep_id = " . $db->quote($pool_id, "integer") .
            " AND object_data.type = " . $db->quote("mob", "text");
 
        // filter
        if (trim($title_filter) != "") {    // title
            $query .= " AND " . $db->like("object_data.title", "text", "%" . trim($title_filter) . "%");
        }
        if (!in_array($format_filter, ["", "mob"])) {            // format
            $filter = ($format_filter === "unknown")
                ? ""
                : $format_filter;
            $query .= " AND " . $db->equals("media_item.format", $filter, "text", true);
        }
        if (trim($caption_filter)) {
            $query .= 'AND ' . $db->like('media_item.caption', 'text', '%' . trim($caption_filter) . '%');
        }
 
        $query .=
            " ORDER BY object_data.title";
 
        $objs = array();
        $set = $db->query($query);
        while ($rec = $db->fetchAssoc($set)) {
            $rec["foreign_id"] = $rec["obj_id"];
            $rec["obj_id"] = "";
            $objs[] = $rec;
        }
 
        // Keyword filter
        if ($keyword_filter) {
            $res = \ilMDKeyword::_searchKeywords($keyword_filter, 'mob', 0);
 
            foreach ($objs as $obj) {
                if (in_array($obj['foreign_id'], $res)) {
                    $filtered[] = $obj;
                }
            }
            return (array) $filtered;
        }
        return $objs;
    }

References $query.

Field Documentation

$db

ilDBInterface ILIAS\MediaPool\MediaPoolRepository::$db

protected

Definition at line 29 of file class.MediaPoolRepository.php.

Referenced by ILIAS\MediaPool\MediaPoolRepository\__construct().

---

The documentation for this class was generated from the following file:

• Modules/MediaPool/classes/class.MediaPoolRepository.php