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