Collaboration diagram for ILIAS\MediaObjects\Usage\UsageDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)

	getHistoryUsagesLowerEqualThan (string $a_type, int $a_id, int $a_usage_hist_nr, string $a_lang="-")

	deleteHistoryUsagesLowerEqualThan (string $a_type, int $a_id, int $a_usage_hist_nr, string $a_lang="-")

Protected Attributes
ilDBInterface	$db

Detailed Description

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

Definition at line 26 of file class.UsageDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\MediaObjects\Usage\UsageDBRepository::__construct ( \ilDBInterface $db )

Definition at line 30 of file class.UsageDBRepository.php.

    {
        $this->db = $db;
    }

References ILIAS\MediaObjects\Usage\UsageDBRepository\$db.

Member Function Documentation

◆ deleteHistoryUsagesLowerEqualThan()

ILIAS\MediaObjects\Usage\UsageDBRepository::deleteHistoryUsagesLowerEqualThan	(	string	$a_type,
		int	$a_id,
		int	$a_usage_hist_nr,
		string	$a_lang = `"-"`
	)

Definition at line 58 of file class.UsageDBRepository.php.

     : void {
        $db = $this->db;
 
        $and_hist = " AND usage_hist_nr > 0 AND usage_hist_nr <= " . $db->quote($a_usage_hist_nr, "integer");
        $q = "DELETE FROM mob_usage WHERE usage_type = " .
            $db->quote($a_type, "text") .
            " AND usage_id= " . $db->quote($a_id, "integer") .
            " AND usage_lang = " . $db->quote($a_lang, "text") .
            $and_hist;
        $db->manipulate($q);
    }

◆ getHistoryUsagesLowerEqualThan()

ILIAS\MediaObjects\Usage\UsageDBRepository::getHistoryUsagesLowerEqualThan	(	string	$a_type,
		int	$a_id,
		int	$a_usage_hist_nr,
		string	$a_lang = `"-"`
	)

Definition at line 35 of file class.UsageDBRepository.php.

     : array {
        $db = $this->db;
 
        $and_hist = " AND usage_hist_nr > 0 AND usage_hist_nr <= " . $db->quote($a_usage_hist_nr, "integer");
 
        $mob_ids = array();
        $set = $db->query("SELECT DISTINCT(id) FROM mob_usage" .
            " WHERE usage_type = " . $db->quote($a_type, "text") .
            " AND usage_id = " . $db->quote($a_id, "integer") .
            " AND usage_lang = " . $db->quote($a_lang, "text") .
            $and_hist);
 
        while ($row = $db->fetchAssoc($set)) {
            $mob_ids[] = $row["id"];
        }
        return $mob_ids;
    }

Field Documentation

◆ $db

ilDBInterface ILIAS\MediaObjects\Usage\UsageDBRepository::$db

protected

Definition at line 28 of file class.UsageDBRepository.php.

Referenced by ILIAS\MediaObjects\Usage\UsageDBRepository\__construct().

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

components/ILIAS/MediaObjects/Usage/class.UsageDBRepository.php

Public Member Functions

Protected Attributes