Collaboration diagram for ILIAS\Skill\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\Skill\Usage\UsageDBRepository::__construct ( \ilDBInterface $db )

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

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

     {
         $this->db = $db;
     }

Member Function Documentation

◆ deleteHistoryUsagesLowerEqualThan()

ILIAS\Skill\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.

References ILIAS\Skill\Usage\UsageDBRepository\$db, $q, and ilDBInterface\quote().

Referenced by ilPCMediaObject\deleteHistoryLowerEqualThan().

      : 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);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getHistoryUsagesLowerEqualThan()

ILIAS\Skill\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.

References ILIAS\Skill\Usage\UsageDBRepository\$db, and ilDBInterface\quote().

Referenced by ilPCMediaObject\deleteHistoryLowerEqualThan().

      : 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;
     }