class.UsageDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\COPage\Usage;

class UsageDBRepository
{
    protected \ilDBInterface $db;

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

    public function deleteHistoryUsagesLowerEqualThan(
        string $pc_type,
        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 page_pc_usage WHERE usage_type = " .
            $db->quote($a_type, "text") .
            " AND usage_id = " . $db->quote((int) $a_id, "integer") .
            " AND usage_lang = " . $db->quote($a_lang, "text") .
            $and_hist .
            " AND pc_type = " . $db->quote($pc_type, "text");
        $db->manipulate($q);
    }
}