class.ContainerDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Style\Content\Container;
 
use ilDBInterface;
 
class ContainerDBRepository
{
    public const TABLE_NAME = 'sty_rep_container';
 
    protected ilDBInterface $db;
 
    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;
    }
 
    public function updateReuse(int $ref_id, bool $reuse): void
    {
        $db = $this->db;
 
        $db->replace(
            self::TABLE_NAME,
            [
                "ref_id" => ["integer", $ref_id]
            ],
            [
                "reuse" => ["integer", (int) $reuse]
            ]
        );
    }
 
    public function readReuse(int $ref_id): bool
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM " . self::TABLE_NAME .
            " WHERE ref_id = %s ",
            ["integer"],
            [$ref_id]
        );
        $rec = $db->fetchAssoc($set);
 
        return (bool) ($rec["reuse"] ?? false);
    }
 
    public function filterByReuse(array $ref_ids): array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM " . self::TABLE_NAME .
            " WHERE reuse = %s AND " . $db->in("ref_id", $ref_ids, false, "integer"),
            ["integer"],
            [1]
        );
        $ref_ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $ref_ids[] = (int) $rec["ref_id"];
        }
        return $ref_ids;
    }
}