DBRepositoryPreloader.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\ResourceStorage\Preloader;

use ILIAS\ResourceStorage\Repositories;

class DBRepositoryPreloader extends StandardRepositoryPreloader implements RepositoryPreloader
{
    protected array $preloaded = [];

    public function __construct(protected \ilDBInterface $db, Repositories $repositories)
    {
        parent::__construct($repositories);
    }

    #[\Override]
    public function preload(array $identification_strings): void
    {
        $requested = array_diff($identification_strings, $this->preloaded);
        if ($requested === []) {
            return;
        }
        $r = $this->db->query(
            "SELECT *, il_resource_revision.title AS revision_title
FROM il_resource_revision
JOIN il_resource_info ON il_resource_revision.rid = il_resource_info.rid AND il_resource_info.version_number = il_resource_revision.version_number
JOIN il_resource ON il_resource_revision.rid = il_resource.rid
JOIN il_resource_stkh_u ON il_resource_stkh_u.rid = il_resource.rid
JOIN il_resource_stkh ON il_resource_stkh_u.stakeholder_id = il_resource_stkh.id
WHERE " . $this->db->in('il_resource_revision.rid', $requested, false, 'text')
        );
        while ($d = $this->db->fetchAssoc($r)) {
            $this->resource_repository->populateFromArray($d);
            $this->revision_repository->populateFromArray($d);
            $this->information_repository->populateFromArray($d);
            $this->stakeholder_repository->populateFromArray($d);
        }
        $this->preloaded = array_merge($this->preloaded, $identification_strings);
        $this->preloaded = array_unique($this->preloaded);
    }
}