class.ilBiblEntryFactory.php

Go to the documentation of this file.

<?php
class ilBiblEntryFactory implements ilBiblEntryFactoryInterface
{
    use ilBibliographicSecureString;

    protected int $bibliographic_obj_id;
    protected int $entry_id;
    protected string $type;
    protected array $attributes;
    protected ilDBInterface $db;


    public function __construct(protected \ilBiblFieldFactoryInterface $field_factory, protected \ilBiblTypeInterface $file_type, protected \ilBiblOverviewModelFactoryInterface $overview_factory)
    {
        global $DIC;
        $this->db = $DIC->database();
    }

    public function loadParsedAttributesByEntryId(int $entry_id): array
    {
        $ilBiblEntry = ilBiblEntry::where(['id' => $entry_id])->first();
        $attributes = $this->getAllAttributesByEntryId($entry_id);

        $type = $this->file_type->getId() == ilBiblTypeFactoryInterface::DATA_TYPE_RIS ? $ilBiblEntry->getType() : 'default';
        $parsed_attributes = [];
        foreach ($attributes as $attribute) {
            $value = $this->secure($attribute->getValue());
            // surround links with <a href="">
            // Allowed signs in URL: a-z A-Z 0-9 . ? & _ / - ~ ! ' * ( ) + , : ; @ = $ # [ ] %
            $value = preg_replace('!(http)(s)?:\/\/[a-zA-Z0-9.?&_/\-~\!\'\*()+,:;@=$#\[\]%]+!', "<a href=\"\\0\" target=\"_blank\">\\0</a>", $value);



            $attribute->setValue($value);
            $parsed_attributes[strtolower($this->file_type->getStringRepresentation() . '_' . $type . '_' . $attribute->getName())] = $value;

            $this->field_factory->findOrCreateFieldOfAttribute($attribute);
        }

        return $parsed_attributes;
    }

    public function findByIdAndTypeString(int $id, string $type_string): ilBiblEntryInterface
    {
        return ilBiblEntry::where(['id' => $id])->first();
    }

    public function findOrCreateEntry(int $id, int $bibliographic_obj_id, string $entry_type): \ilBiblEntryInterface
    {
        $inst = $this->getARInstance($id);
        if ($inst === null) {
            $inst = $this->createEntry($bibliographic_obj_id, $entry_type);
        }
        $inst->setDataId($bibliographic_obj_id);
        $inst->setEntryType($entry_type);
        $inst->update();

        return $inst;
    }

    public function createEntry(int $bibliographic_obj_id, string $entry_type): \ilBiblEntryInterface
    {
        $inst = new ilBiblEntry();
        $inst->setDataId($bibliographic_obj_id);
        $inst->setEntryType($entry_type);
        $inst->create();

        return $inst;
    }

    public function getEmptyInstance(): \ilBiblEntry
    {
        return new ilBiblEntry();
    }

    private function getARInstance(int $id): ?\ilBiblEntry
    {
        return ilBiblEntry::where(["ïd" => $id])->first();
    }

    public function filterEntriesForTable(int $object_id, ?ilBiblTableQueryInfo $info = null): array
    {
        $entries = $this->filterEntryIdsForTableAsArray($object_id, $info);
        $entry_objects = [];
        foreach ($entries as $entry_id => $entry) {
            $entry_objects[$entry_id] = $this->findByIdAndTypeString($entry['type'], $entry['id']);
        }

        return $entry_objects;
    }

    public function filterEntryIdsForTableAsArray(int $object_id, ?ilBiblTableQueryInfo $info = null): array
    {
        $types = ["integer"];
        $values = [$object_id];

        $filters = $info->getFilters();
        if (!empty($filters)) {
            $q = "SELECT (e.id), e.type FROM il_bibl_entry AS e WHERE data_id = %s";
            foreach ($filters as $filter) {
                $value = $filter->getFieldValue();
                if (!$value) {
                    continue;
                }
                if ($filter->getOperator() === "IN" && is_array($filter->getFieldValue())) {
                    $types[] = "text";
                    $values[] = $filter->getFieldName();
                    $q .= " AND e.id IN (SELECT a.entry_id FROM il_bibl_attribute AS a WHERE a.name = %s AND " . $this->db->in("a.value", $value, false, "text") . ")";
                } else {
                    $types[] = "text";
                    $values[] = $filter->getFieldName();
                    $types[] = "text";
                    $values[] = "{$value}";
                    $q .= " AND e.id IN (SELECT a.entry_id FROM il_bibl_attribute AS a WHERE a.name = %s AND a.value {$filter->getOperator()} %s )";
                }
            }
        } else {
            $q = "SELECT DISTINCT (e.id), e.type FROM il_bibl_entry AS e
                JOIN il_bibl_attribute AS a ON a.entry_id = e.id
                        WHERE data_id = %s";
        }
        $entries = [];
        $set = $this->db->queryF($q, $types, $values);

        $i = 0;
        while ($rec = $this->db->fetchAssoc($set)) {
            $entries[$i]['entry_id'] = $rec['id'];
            $entries[$i]['entry_type'] = $rec['type'];
            $i++;
        }

        return $entries;
    }

    public function deleteEntryById(int $id): void
    {
        $entry = ilBiblEntry::where(['id' => $id])->first();
        if ($entry instanceof ilBiblEntry) {
            $entry->delete();
        }
    }

    public function deleteEntriesById(int $object_id): void
    {
        $this->db->manipulateF("DELETE FROM il_bibl_entry WHERE data_id = %s", ['integer'], [$object_id]);
    }

    public function getAllAttributesByEntryId(int $id): array
    {
        return ilBiblAttribute::where(['entry_id' => $id])->get();
    }

    public function getFileType(): \ilBiblTypeInterface
    {
        return $this->file_type;
    }

    public function setFileType(string $file_type): void
    {
        $this->file_type = $file_type;
    }

    public function setAttributes(array $attributes): void
    {
        $this->attributes = $attributes;
    }

    public function getAttributes(): array
    {
        return $this->attributes;
    }
}