class.ObjectDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Style\Content\Object;
 
use ilDBInterface;
 
class ObjectDBRepository
{
    public const DATA_TABLE_NAME = 'style_data';
 
    protected ilDBInterface $db;
 
    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;
    }
 
    public function getOwnedStyles(array $owner_obj_ids): array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM style_usage su JOIN style_data sd " .
            " ON (su.style_id = sd.id AND su.obj_id = sd.owner_obj) " .
            " WHERE " . $db->in("su.obj_id", $owner_obj_ids, false, "integer"),
            [],
            []
        );
 
        $owned = [];
        while ($rec = $db->fetchAssoc($set)) {
            $owned[(int) $rec["owner_obj"]] = (int) $rec["style_id"];
        }
        return $owned;
    }
 
    // is a style owned by an object?
    public function isOwned(int $obj_id, int $style_id): bool
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM style_data " .
            " WHERE id = %s AND owner_obj = %s",
            ["integer", "integer"],
            [$style_id, $obj_id]
        );
 
        if ($db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }
 
 
    public function countOverallOwned(): int
    {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT count(*) cnt FROM style_data " .
            " WHERE owner_obj > %s",
            ["integer"],
            [0]
        );
 
        if ($rec = $db->fetchAssoc($set)) {
            return (int) $rec["cnt"];
        }
        return 0;
    }
 
    public function countObjSelected(int $style_id): int
    {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT count(*) cnt FROM style_usage " .
            " WHERE style_id = %s",
            ["integer"],
            [$style_id]
        );
 
        if ($rec = $db->fetchAssoc($set)) {
            return (int) $rec["cnt"];
        }
        return 0;
    }
 
}