class.UsageDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\MediaObjects\Usage;

class UsageDBRepository
{
    protected \ilDBInterface $db;

    public function __construct(\ilDBInterface $db)
    {
        $this->db = $db;
    }

    public function getHistoryUsagesLowerEqualThan(
        string $a_type,
        int $a_id,
        int $a_usage_hist_nr,
        string $a_lang = "-"
    ): 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;
    }

    public function deleteHistoryUsagesLowerEqualThan(
        string $a_type,
        int $a_id,
        int $a_usage_hist_nr,
        string $a_lang = "-"
    ): 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);
    }
}