class.ilDclTable.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\components\DataCollection\Fields\Formula\FormulaParser\Math\Functions;
use ILIAS\components\DataCollection\Fields\Formula\FormulaParser\Math\Operators;
 
class ilDclTable
{
    protected int $id = 0;
    protected ?int $objId = null;
    protected ?ilObjDataCollection $obj = null;
    protected string $title = "";
    protected array $fields = [];
    protected array $stdFields = [];
    protected array $records = [];
    protected bool $is_visible = false;
    protected bool $add_perm = false;
    protected bool $edit_perm = false;
    protected bool $delete_perm = false;
    protected bool $edit_by_owner = false;
    protected bool $delete_by_owner = false;
    protected bool $save_confirmation = false;
    protected bool $limited = false;
    protected string $limit_start = "";
    protected string $limit_end = "";
    protected bool $export_enabled = false;
    protected int $table_order = 0;
    protected bool $import_enabled = false;
 
    protected string $default_sort_field = "0";
    protected string $default_sort_field_order = 'asc';
    protected string $description = '';
    protected bool $public_comments = false;
    protected int $view_own_records_perm = 0;
    protected ?array $all_fields = null;
    protected ILIAS\HTTP\Services $http;
    protected ILIAS\Refinery\Factory $refinery;
    protected ilObjUser $user;
    protected ilDBInterface $db;
    protected bool $show_invalid = false;
 
    public function __construct(int $a_id = 0)
    {
        global $DIC;
 
        $this->http = $DIC->http();
        $this->refinery = $DIC->refinery();
        $this->db = $DIC->database();
        $this->user = $DIC->user();
 
        if ($a_id != 0) {
            $this->id = $a_id;
            $this->doRead();
        }
    }
 
    public function doRead(): void
    {
        $query = "SELECT * FROM il_dcl_table WHERE id = " . $this->db->quote($this->getId(), "integer");
        $set = $this->db->query($query);
        $rec = $this->db->fetchAssoc($set);
 
        $this->setObjId($rec["obj_id"]);
        if (null !== $rec["title"]) {
            $this->setTitle($rec["title"]);
        }
        $this->setAddPerm((bool) $rec["add_perm"]);
        $this->setEditPerm((bool) $rec["edit_perm"]);
        $this->setDeletePerm((bool) $rec["delete_perm"]);
        $this->setEditByOwner((bool) $rec["edit_by_owner"]);
        if (null !== $rec["export_enabled"]) {
            $this->setExportEnabled((bool) $rec["export_enabled"]);
        }
        $this->setImportEnabled((bool) $rec["import_enabled"]);
        $this->setLimited((bool) $rec["limited"]);
        $this->setLimitStart((string) $rec["limit_start"]);
        $this->setLimitEnd((string) $rec["limit_end"]);
        $this->setIsVisible((bool) $rec["is_visible"]);
        if (null !== $rec['description']) {
            $this->setDescription($rec['description']);
        }
        $this->setDefaultSortField((string) $rec['default_sort_field_id']);
        $this->setDefaultSortFieldOrder($rec['default_sort_field_order']);
        $this->setPublicCommentsEnabled((bool) $rec['public_comments']);
        $this->setViewOwnRecordsPerm((bool) $rec['view_own_records_perm']);
        $this->setDeleteByOwner((bool) $rec['delete_by_owner']);
        $this->setSaveConfirmation((bool) $rec['save_confirmation']);
        if (null !== $rec['table_order']) {
            $this->setOrder($rec['table_order']);
        }
    }
 
    public function doDelete(bool $delete_only_content = false, bool $omit_notification = false): void
    {
        foreach ($this->getRecords() as $record) {
            $record->doDelete($omit_notification);
        }
 
        foreach ($this->getRecordFields() as $field) {
            $field->doDelete();
        }
 
        if (!$delete_only_content) {
            $query = "DELETE FROM il_dcl_table WHERE id = " . $this->db->quote($this->getId(), "integer");
            $this->db->manipulate($query);
        }
    }
 
    public function doCreate(bool $create_tablefield_setting = true, bool $create_standardview = true): void
    {
        $id = $this->db->nextId("il_dcl_table");
        $this->setId($id);
        $query = "INSERT INTO il_dcl_table (" . "id" . ", obj_id" . ", title" . ", add_perm" . ", edit_perm" . ", delete_perm" . ", edit_by_owner"
            . ", limited" . ", limit_start" . ", limit_end" . ", is_visible" . ", export_enabled" . ", import_enabled" . ", default_sort_field_id"
            . ", default_sort_field_order" . ", description" . ", public_comments" . ", view_own_records_perm"
            . ", delete_by_owner, save_confirmation , table_order ) VALUES (" . $this->db->quote(
                $this->getId(),
                "integer"
            ) . ","
            . $this->db->quote($this->getObjId(), "integer") . "," . $this->db->quote($this->getTitle(), "text") . ","
            . $this->db->quote($this->getAddPerm() ? 1 : 0, "integer") . "," . $this->db->quote(
                $this->getEditPerm() ? 1 : 0,
                "integer"
            ) . ","
            . $this->db->quote(
                $this->getDeletePerm() ? 1 : 0,
                "integer"
            ) . "," . $this->db->quote($this->getEditByOwner() ? 1 : 0, "integer") . ","
            . $this->db->quote($this->getLimited() ? 1 : 0, "integer") . "," . $this->db->quote(
                $this->getLimitStart(),
                "timestamp"
            ) . ","
            . $this->db->quote($this->getLimitEnd(), "timestamp") . "," . $this->db->quote(
                $this->getIsVisible() ? 1 : 0,
                "integer"
            ) . ","
            . $this->db->quote(
                $this->getExportEnabled() ? 1 : 0,
                "integer"
            ) . "," . $this->db->quote($this->getImportEnabled() ? 1 : 0, "integer") . ","
            . $this->db->quote($this->getDefaultSortField(), "text") . "," . $this->db->quote(
                $this->getDefaultSortFieldOrder(),
                "text"
            ) . ","
            . $this->db->quote($this->getDescription(), "text") . "," . $this->db->quote(
                $this->getPublicCommentsEnabled(),
                "integer"
            ) . ","
            . $this->db->quote(
                $this->getViewOwnRecordsPerm(),
                "integer"
            ) . "," . $this->db->quote($this->getDeleteByOwner() ? 1 : 0, 'integer') . ","
            . $this->db->quote($this->getSaveConfirmation() ? 1 : 0, 'integer') . "," . $this->db->quote(
                $this->getOrder(),
                'integer'
            ) . ")";
 
        $this->db->manipulate($query);
 
        if ($create_standardview) {
            //standard tableview
            ilDclTableView::createOrGetStandardView($this->id);
        }
 
        if ($create_tablefield_setting) {
            $this->buildOrderFields();
        }
    }
 
    public function doUpdate(): void
    {
        $this->db->update(
            "il_dcl_table",
            [
                "obj_id" => ["integer", $this->getObjId()],
                "title" => ["text", $this->getTitle()],
                "add_perm" => ["integer", (int) $this->getAddPerm()],
                "edit_perm" => ["integer", (int) $this->getEditPerm()],
                "delete_perm" => ["integer", (int) $this->getDeletePerm()],
                "edit_by_owner" => ["integer", (int) $this->getEditByOwner()],
                "limited" => ["integer", $this->getLimited()],
                "limit_start" => ["timestamp", $this->getLimitStart()],
                "limit_end" => ["timestamp", $this->getLimitEnd()],
                "is_visible" => ["integer", $this->getIsVisible() ? 1 : 0],
                "export_enabled" => ["integer", $this->getExportEnabled() ? 1 : 0],
                "import_enabled" => ["integer", $this->getImportEnabled() ? 1 : 0],
                "description" => ["text", $this->getDescription()],
                "default_sort_field_id" => ["text", $this->getDefaultSortField()],
                "default_sort_field_order" => ["text", $this->getDefaultSortFieldOrder()],
                "public_comments" => ["integer", $this->getPublicCommentsEnabled() ? 1 : 0],
                "view_own_records_perm" => ["integer", $this->getViewOwnRecordsPerm()],
                'delete_by_owner' => ['integer', $this->getDeleteByOwner() ? 1 : 0],
                'save_confirmation' => ['integer', $this->getSaveConfirmation() ? 1 : 0],
                'table_order' => ['integer', $this->getOrder()],
            ],
            [
                "id" => ["integer", $this->getId()],
            ]
        );
    }
 
    public function setId(int $a_id): void
    {
        $this->id = $a_id;
    }
 
    public function getId(): int
    {
        return $this->id;
    }
 
    public function setObjId(int $a_id): void
    {
        $this->objId = $a_id;
    }
 
    public function getObjId(): ?int
    {
        return $this->objId;
    }
 
    public function setTitle(string $a_title): void
    {
        $this->title = $a_title;
    }
 
    public function getTitle(): string
    {
        return $this->title;
    }
 
    public function getCollectionObject(): ilObjDataCollection
    {
        $this->loadObj();
 
        return $this->obj;
    }
 
    protected function loadObj(): void
    {
        if ($this->obj == null) {
            $this->obj = new ilObjDataCollection($this->objId, false);
        }
    }
 
    public function getRecords(): array
    {
        if ($this->records == null) {
            $this->loadRecords();
        }
 
        return $this->records;
    }
 
    public function loadRecords(): void
    {
        $records = [];
        $query = "SELECT id FROM il_dcl_record WHERE table_id = " . $this->db->quote($this->id, "integer");
        $set = $this->db->query($query);
 
        while ($rec = $this->db->fetchAssoc($set)) {
            $records[$rec['id']] = ilDclCache::getRecordCache($rec['id']);
        }
 
        $this->records = $records;
    }
 
    public function deleteField(int $field_id): void
    {
        $field = ilDclCache::getFieldCache($field_id);
        $records = $this->getRecords();
 
        foreach ($records as $record) {
            $record->deleteField($field_id);
        }
 
        $field->doDelete();
    }
 
    public function getField(string $field_id): ?ilDclBaseFieldModel
    {
        $fields = $this->getFields();
        $field = null;
        foreach ($fields as $field_1) {
            if ($field_1->getId() == $field_id) {
                $field = $field_1;
            }
        }
 
        return $field;
    }
 
    public function getFieldIds(): array
    {
        $field_ids = [];
        foreach ($this->getFields() as $field) {
            if ($field->getId()) {
                $field_ids[] = $field->getId();
            }
        }
 
        return $field_ids;
    }
 
    protected function loadCustomFields(): void
    {
        if (!$this->fields) {
            $query
                = "SELECT DISTINCT il_dcl_field.*, il_dcl_tfield_set.field_order
                                                    FROM il_dcl_field
                                                         INNER JOIN il_dcl_tfield_set
                                                            ON (    il_dcl_tfield_set.field NOT IN ('owner',
                                                                                                    'last_update',
                                                                                                    'last_edit_by',
                                                                                                    'id',
                                                                                                    'create_date')
                                                                AND il_dcl_tfield_set.table_id = il_dcl_field.table_id
                                                                AND il_dcl_tfield_set.field = " . $this->db->cast("il_dcl_field.id", "text") . ")
                                                   WHERE il_dcl_field.table_id = %s
                                                ORDER BY il_dcl_tfield_set.field_order ASC";
 
            $set = $this->db->queryF($query, ['integer'], [$this->getId()]);
            $fields = [];
            while ($rec = $this->db->fetchAssoc($set)) {
                $field = ilDclCache::buildFieldFromRecord($rec);
                if ($this->show_invalid || in_array($field->getDatatypeId(), array_keys(ilDclDatatype::getAllDatatype()))) {
                    $fields[] = $field;
                }
            }
            $this->fields = $fields;
 
            ilDclCache::preloadFieldProperties($fields);
        }
    }
 
    public function getCustomFields(): array
    {
        if (!$this->fields) {
            $this->loadCustomFields();
        }
 
        return $this->fields;
    }
 
    public function getNewFieldOrder(): int
    {
        $fields = $this->getFields();
        $place = 0;
        foreach ($fields as $field) {
            if (!$field->isStandardField()) {
                $place = $field->getOrder() + 1;
            }
        }
 
        return $place;
    }
 
    public function getNewTableviewOrder(): int
    {
        return (ilDclTableView::getCountForTableId($this->getId()) + 1) * 10;
    }
 
    public function sortTableViews(?array $tableviews = null): void
    {
        if ($tableviews == null) {
            $tableviews = $this->getTableViews();
        }
 
        $order = 10;
        foreach ($tableviews as $tableview) {
            $tableview->setTableviewOrder($order);
            $tableview->update();
            $order += 10;
        }
    }
 
    public function getFields(): array
    {
        if ($this->all_fields == null) {
            $this->reloadFields();
        }
 
        return $this->all_fields;
    }
 
    public function reloadFields(): void
    {
        $this->loadCustomFields();
        $this->stdFields = $this->getStandardFields();
        $fields = array_merge($this->fields, $this->stdFields);
 
        $this->sortByOrder($fields);
 
        $this->all_fields = $fields;
    }
 
    public function getTableViews(): array
    {
        return ilDclTableView::getAllForTableId($this->getId());
    }
 
    public function getVisibleTableViews(int $user_id = 0, bool $with_active_detailedview = false): array
    {
        if (ilObjDataCollectionAccess::hasWriteAccess($this->getCollectionObject()->getRefId(), $user_id) && !$with_active_detailedview) {
            return $this->getTableViews();
        }
 
        $visible_views = [];
        foreach ($this->getTableViews() as $tableView) {
            if (ilObjDataCollectionAccess::hasAccessToTableView($tableView, $user_id)) {
                $page = new ilDclDetailedViewDefinitionGUI($tableView->getId());
                if (!$with_active_detailedview || $page->getPageObject()->isActive()) {
                    $visible_views[] = $tableView;
                }
            }
        }
 
        return $visible_views;
    }
 
    public function getFirstTableViewId(int $user_id = 0, bool $with_detailed_view = false): ?int
    {
        $array = $this->getVisibleTableViews($user_id, $with_detailed_view);
        $tableview = array_shift($array);
 
        return $tableview?->getId();
    }
 
    public function getFieldsForFormula(): array
    {
        $syntax_chars = array_merge(
            array_map(static fn(Operators $function): string => $function->value, Operators::cases()),
            array_map(static fn(Functions $function): string => $function->value, Functions::cases()),
            ['(', ')', ',']
        );
        foreach ($this->getFields() as $field) {
            if (in_array($field->getDatatypeId(), ilDclFormulaFieldModel::SUPPORTED_FIELDS)) {
                foreach ($syntax_chars as $element) {
                    if (str_contains($field->getTitle(), $element)) {
                        continue 2;
                    }
                }
                $return[] = $field;
            }
        }
 
        return $return;
    }
 
    public function getStandardFields(): array
    {
        if ($this->stdFields == null) {
            $this->stdFields = ilDclStandardField::_getStandardFields($this->id);
            // Don't return comments as field if this feature is not activated in the settings
            if (!$this->getPublicCommentsEnabled()) {
                foreach ($this->stdFields as $k => $field) {
                    if ($field->getId() == 'comments') {
                        unset($this->stdFields[$k]);
                        break;
                    }
                }
            }
        }
 
        return $this->stdFields;
    }
 
    public function getRecordFields(): array
    {
        $this->loadCustomFields();
 
        return $this->fields;
    }
 
    public function getEditableFields(bool $creation_mode): array
    {
        $fields = $this->getRecordFields();
        $editableFields = [];
 
        foreach ($fields as $field) {
            $tableview_id = $this->http->wrapper()->post()->retrieve(
                'tableview_id',
                $this->refinery->kindlyTo()->int()
            );
            if (!$field->getViewSetting($tableview_id)->isLocked($creation_mode)) {
                $editableFields[] = $field;
            }
        }
 
        return $editableFields;
    }
 
    public function getExportableFields(): array
    {
        $fields = $this->getFields();
        $exportableFields = [];
        foreach ($fields as $field) {
            if ($field->getExportable()) {
                $exportableFields[] = $field;
            }
        }
 
        return $exportableFields;
    }
 
    public function hasPermissionToEditRecord(int $ref_id, ilDclBaseRecordModel $record): bool
    {
        if ($this->getObjId() != ilObjDataCollection::_lookupObjectId($ref_id)) {
            return false;
        }
        if (ilObjDataCollectionAccess::hasWriteAccess($ref_id)) {
            return true;
        }
        if (!ilObjDataCollectionAccess::hasAddRecordAccess($ref_id)) {
            return false;
        }
        if ($this->getEditByOwner()) {
            return $this->doesRecordBelongToUser($record);
        }
        if (!$this->checkLimit()) {
            return false;
        }
        if (ilObjDataCollectionAccess::hasEditAccess($ref_id)) {
            return true;
        }
        if ($this->getEditPerm() && !$this->getEditByOwner()) {
            return true;
        }
 
        return false;
    }
 
    public function hasPermissionToDeleteRecord(int $ref_id, ilDclBaseRecordModel $record): bool
    {
        if ($this->getObjId() != ilObjDataCollection::_lookupObjectId($ref_id)) {
            return false;
        }
        if (ilObjDataCollectionAccess::hasWriteAccess($ref_id)) {
            return true;
        }
        if (!ilObjDataCollectionAccess::hasAddRecordAccess($ref_id)) {
            return false;
        }
        if (!$this->checkLimit()) {
            return false;
        }
        if ($this->getDeletePerm() && !$this->getDeleteByOwner()) {
            return true;
        }
        if ($this->getDeleteByOwner()) {
            return $this->doesRecordBelongToUser($record);
        }
 
        return false;
    }
 
    public function hasPermissionToDeleteRecords(int $ref_id): bool
    {
        if ($this->getObjId() != ilObjDataCollection::_lookupObjectId($ref_id)) {
            return false;
        }
 
        return ((ilObjDataCollectionAccess::hasAddRecordAccess($ref_id) && $this->getDeletePerm())
            || ilObjDataCollectionAccess::hasWriteAccess($ref_id));
    }
 
    public function hasPermissionToViewRecord(int $ref_id, ilDclBaseRecordModel $record, int $user_id = 0): bool
    {
        if ($this->getObjId() != ilObjDataCollection::_lookupObjectId($ref_id)) {
            return false;
        }
        if (ilObjDataCollectionAccess::hasWriteAccess(
            $ref_id,
            $user_id
        ) || ilObjDataCollectionAccess::hasEditAccess($ref_id, $user_id)) {
            return true;
        }
        if (ilObjDataCollectionAccess::hasReadAccess($ref_id)) {
            // Check for view only own entries setting
            if ($this->getViewOwnRecordsPerm() && ($user_id ?: $this->user->getId()) != $record->getOwner()) {
                return false;
            }
 
            return true;
        }
 
        return false;
    }
 
    protected function doesRecordBelongToUser(ilDclBaseRecordModel $record): bool
    {
        return ($this->user->getId() == $record->getOwner());
    }
 
    public function checkLimit(): bool
    {
        if ($this->getLimited()) {
            $from = null;
            $to = null;
            $now = new ilDateTime(date("Y-m-d H:i:s"), IL_CAL_DATE);
 
            if ($this->getLimitStart() != "") {
                $from = new ilDateTime($this->getLimitStart(), IL_CAL_DATE);
            }
            if ($this->getLimitEnd() != "") {
                $to = new ilDateTime($this->getLimitEnd(), IL_CAL_DATE);
            }
 
            if ($from == null && $to == null) {
                return true;
            }
            if ($from <= $now && $now <= $to) {
                return true;
            }
            if ($from <= $now && $to == null) {
                return true;
            }
            if ($from == null && $now <= $to) {
                return true;
            }
 
            return ($from <= $now && $now <= $to);
        }
 
        return true;
    }
 
    public function updateFields(): void
    {
        foreach ($this->getFields() as $field) {
            $field->doUpdate();
        }
    }
 
    public function sortFields(array &$fields): void
    {
        $this->sortByOrder($fields);
        //After sorting the array loses it's keys respectivly their keys are set form $field->id to 1,2,3... so we reset the keys.
        $named = [];
        foreach ($fields as $field) {
            $named[$field->getId()] = $field;
        }
 
        $fields = $named;
    }
 
    protected function sortByOrder(array &$array): void
    {
        // php-bug: https://bugs.php.net/bug.php?id=50688
        // fixed in php 7 but for now we need the @ a workaround
        usort($array, [$this, "compareOrder"]);
    }
 
    public function buildOrderFields(): void
    {
        $fields = $this->getFields();
        $this->sortByOrder($fields);
        $count = 10;
        $offset = 10;
        foreach ($fields as $field) {
            if (!is_null($field->getOrder())) {
                $field->setOrder($count);
                $count = $count + $offset;
                $field->doUpdate();
            }
        }
    }
 
    public function getFieldByTitle(string $title): ?ilDclBaseFieldModel
    {
        $return = null;
        foreach ($this->getFields() as $field) {
            if ($field->getTitle() == $title) {
                $return = $field;
                break;
            }
        }
 
        return $return;
    }
 
    public function setAddPerm(bool $add_perm): void
    {
        $this->add_perm = $add_perm;
    }
 
    public function getAddPerm(): bool
    {
        return $this->add_perm;
    }
 
    public function setDeletePerm(bool $delete_perm): void
    {
        $this->delete_perm = $delete_perm;
        if (!$delete_perm) {
            $this->setDeleteByOwner(false);
        }
    }
 
    public function getDeletePerm(): bool
    {
        return $this->delete_perm;
    }
 
    public function setEditByOwner(bool $edit_by_owner): void
    {
        $this->edit_by_owner = $edit_by_owner;
        if ($edit_by_owner) {
            $this->setEditPerm(true);
        }
    }
 
    public function getEditByOwner(): bool
    {
        return $this->edit_by_owner;
    }
 
    public function getDeleteByOwner(): bool
    {
        return $this->delete_by_owner;
    }
 
    public function setDeleteByOwner(bool $delete_by_owner): void
    {
        $this->delete_by_owner = $delete_by_owner;
        if ($delete_by_owner) {
            $this->setDeletePerm(true);
        }
    }
 
    public function setEditPerm(bool $edit_perm): void
    {
        $this->edit_perm = $edit_perm;
        if (!$edit_perm) {
            $this->setEditByOwner(false);
        }
    }
 
    public function getEditPerm(): bool
    {
        return $this->edit_perm;
    }
 
    public function setLimited(bool $limited): void
    {
        $this->limited = $limited;
    }
 
    public function getLimited(): bool
    {
        return $this->limited;
    }
 
    public function setLimitEnd(string $limit_end): void
    {
        $this->limit_end = $limit_end;
    }
 
    public function getLimitEnd(): string
    {
        return $this->limit_end;
    }
 
    public function setLimitStart(string $limit_start): void
    {
        $this->limit_start = $limit_start;
    }
 
    public function getLimitStart(): string
    {
        return $this->limit_start;
    }
 
    public function setIsVisible(bool $is_visible): void
    {
        $this->is_visible = $is_visible;
    }
 
    public function getIsVisible(): bool
    {
        return $this->is_visible;
    }
 
    public function setDescription(string $description): void
    {
        $this->description = $description;
    }
 
    public function getDescription(): string
    {
        return $this->description;
    }
 
    public function setDefaultSortField(string $default_sort_field): void
    {
        $default_sort_field = ($default_sort_field) ?: ""; // Change null or empty strings to zero
        $this->default_sort_field = $default_sort_field;
    }
 
    public function getDefaultSortField(): string
    {
        return $this->default_sort_field;
    }
 
    public function setDefaultSortFieldOrder(string $default_sort_field_order): void
    {
        if (!in_array($default_sort_field_order, ['asc', 'desc'])) {
            $default_sort_field_order = 'asc';
        }
        $this->default_sort_field_order = $default_sort_field_order;
    }
 
    public function getDefaultSortFieldOrder(): string
    {
        return $this->default_sort_field_order;
    }
 
    public function setPublicCommentsEnabled(bool $public_comments): void
    {
        $this->public_comments = $public_comments;
    }
 
    public function getPublicCommentsEnabled(): bool
    {
        return $this->public_comments;
    }
 
    public function setViewOwnRecordsPerm(bool $view_own_perm): void
    {
        $this->view_own_records_perm = (int) $view_own_perm;
    }
 
    public function getViewOwnRecordsPerm(): bool
    {
        return (bool) $this->view_own_records_perm;
    }
 
    public function getSaveConfirmation(): bool
    {
        return $this->save_confirmation;
    }
 
    public function setSaveConfirmation(bool $save_confirmation): void
    {
        $this->save_confirmation = $save_confirmation;
    }
 
    public function hasCustomFields(): bool
    {
        $this->loadCustomFields();
 
        return count($this->fields) > 0;
    }
 
    public function compareOrder(ilDclBaseFieldModel $a, ilDclBaseFieldModel $b): int
    {
        if (is_null($a->getOrder() == null) && is_null($b->getOrder() == null)) {
            return 0;
        }
        if (is_null($a->getOrder())) {
            return 1;
        }
        if (is_null($b->getOrder())) {
            return -1;
        }
 
        return $a->getOrder() < $b->getOrder() ? -1 : 1;
    }
 
    public function cloneStructure(ilDclTable $original): void
    {
        $this->setTitle($original->getTitle());
        $this->setDescription($original->getDescription());
        $this->setIsVisible($original->getIsVisible());
        $this->setEditByOwner($original->getEditByOwner());
        $this->setAddPerm($original->getAddPerm());
        $this->setEditPerm($original->getEditPerm());
        $this->setDeleteByOwner($original->getDeleteByOwner());
        $this->setSaveConfirmation($original->getSaveConfirmation());
        $this->setDeletePerm($original->getDeletePerm());
        $this->setLimited($original->getLimited());
        $this->setLimitStart($original->getLimitStart());
        $this->setLimitEnd($original->getLimitEnd());
        $this->setViewOwnRecordsPerm($original->getViewOwnRecordsPerm());
        $this->setExportEnabled($original->getExportEnabled());
        $this->setImportEnabled($original->getImportEnabled());
        $this->setPublicCommentsEnabled($original->getPublicCommentsEnabled());
        $this->setDefaultSortFieldOrder($original->getDefaultSortFieldOrder());
        $this->setOrder($original->getOrder());
 
        $this->doCreate(true, false);
        // reset stdFields to get new for the created object
 
        $default_sort_field = 0;
        // Clone standard-fields
        $org_std_fields = $original->getStandardFields();
        foreach ($this->getStandardFields() as $element_key => $std_field) {
            $std_field->clone($org_std_fields[$element_key]);
            if ($std_field->getId() === $original->getDefaultSortField()) {
                $default_sort_field = $std_field->getId();
            }
        }
 
        // Clone fields
        $new_fields = [];
        foreach ($original->getFields() as $orig_field) {
            if (!$orig_field->isStandardField()) {
                $class_name = get_class($orig_field);
                $new_field = new $class_name();
                $new_field->setTableId($this->getId());
                $new_field->cloneStructure((int) $orig_field->getId());
                $new_fields[$orig_field->getId()] = $new_field;
 
                if ($orig_field->getId() === $original->getDefaultSortField()) {
                    $default_sort_field = $new_field->getId();
                }
            }
        }
 
        $this->setDefaultSortField((string) $default_sort_field);
        $this->doUpdate();
 
        // Clone Records with recordfields
        foreach ($original->getRecords() as $orig_record) {
            $new_record = new ilDclBaseRecordModel();
            $new_record->setTableId($this->getId());
            $new_record->cloneStructure($orig_record->getId(), $new_fields);
        }
 
        //clone tableviews (includes pageobjects)
        foreach ($original->getTableViews() as $orig_tableview) {
            $new_tableview = new ilDclTableView();
            $new_tableview->setTableId($this->getId());
            $new_tableview->cloneStructure($orig_tableview, $new_fields);
        }
 
        // mandatory for all cloning functions
        ilDclCache::setCloneOf($original->getId(), $this->getId(), ilDclCache::TYPE_TABLE);
    }
 
    public function afterClone(): void
    {
        foreach ($this->getFields() as $field) {
            $field->afterClone($this->getRecords());
        }
    }
 
    public function _hasRecords(): bool
    {
        return count($this->getRecords()) > 0;
    }
 
    public function addField(ilDclBaseFieldModel $field): void
    {
        $this->all_fields[$field->getId()] = $field;
    }
 
    public static function _tableExists(int $table_id): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM il_dcl_table WHERE id = " . $table_id;
        $result = $ilDB->query($query);
 
        return $result->numRows() != 0;
    }
 
    public static function _getTableIdByTitle(string $title, int $obj_id): int
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $result = $ilDB->query(
            'SELECT id FROM il_dcl_table WHERE title = ' . $ilDB->quote($title, 'text') . ' AND obj_id = '
            . $ilDB->quote($obj_id, 'integer')
        );
        $id = 0;
        while ($rec = $ilDB->fetchAssoc($result)) {
            $id = $rec['id'];
        }
 
        return $id;
    }
 
    public function setExportEnabled(bool $export_enabled): void
    {
        $this->export_enabled = $export_enabled;
    }
 
    public function getExportEnabled(): bool
    {
        return $this->export_enabled;
    }
 
    public function getOrder(): int
    {
        if (!$this->table_order) {
            $this->updateOrder();
        }
 
        return $this->table_order;
    }
 
    public function updateOrder(): void
    {
        $result = $this->db->query('SELECT MAX(table_order) AS table_order FROM il_dcl_table WHERE obj_id = ' . $this->db->quote(
            $this->getCollectionObject()->getId(),
            'integer'
        ));
        $this->table_order = $this->db->fetchObject($result)->table_order + 10;
        $this->db->query('UPDATE il_dcl_table SET table_order = ' . $this->db->quote(
            $this->table_order,
            'integer'
        ) . ' WHERE id = ' . $this->db->quote($this->getId(), 'integer'));
    }
 
    public function setOrder(int $table_order): void
    {
        $this->table_order = $table_order;
    }
 
    public function setImportEnabled(bool $import_enabled): void
    {
        $this->import_enabled = $import_enabled;
    }
 
    public function getImportEnabled(): bool
    {
        return $this->import_enabled;
    }
 
    public static function _hasFieldByTitle(string $title, int $obj_id): bool
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $result = $ilDB->query(
            'SELECT * FROM il_dcl_field WHERE table_id = ' . $ilDB->quote($obj_id, 'integer') . ' AND title = '
            . $ilDB->quote($title, 'text')
        );
 
        return (bool) $ilDB->numRows($result);
    }
 
    public function getPartialRecords(
        string $ref_id,
        string $sort,
        string $direction,
        ?int $limit,
        int $offset,
        array $filter = []
    ): array {
        $sort_field = $this->getFieldByTitle($sort);
        $direction = strtolower($direction);
        $direction = (in_array($direction, ['desc', 'asc'])) ? $direction : 'asc';
 
        // Sorting by a status from an ILIAS Ref field. This column is added dynamically to the table, there is no field model
        $sort_by_status = false;
        if (substr($sort, 0, 8) == '_status_') {
            $sort_by_status = true;
            $sort_field = $this->getFieldByTitle(substr($sort, 8));
        }
 
        if (is_null($sort_field)) {
            $sort_field = $this->getField('id');
        }
 
        $sort_query_object = $sort_field->getRecordQuerySortObject($direction, $sort_by_status);
 
        $select_str = ($sort_query_object != null) ? $sort_query_object->getSelectStatement() : '';
        $join_str = ($sort_query_object != null) ? $sort_query_object->getJoinStatement() : '';
        $where_str = ($sort_query_object != null) ? $sort_query_object->getWhereStatement() : '';
        $order_str = ($sort_query_object != null) ? $sort_query_object->getOrderStatement() : '';
        $group_str = ($sort_query_object != null) ? $sort_query_object->getGroupStatement() : '';
 
        if (count($filter)) {
            foreach ($filter as $key => $filter_value) {
                $filter_field_id = substr($key, 7);
                $filter_field = $this->getField($filter_field_id);
                $filter_record_query_object = $filter_field->getRecordQueryFilterObject($filter_value, $sort_field);
 
                if ($filter_record_query_object) {
                    $select_str .= $filter_record_query_object->getSelectStatement();
                    $join_str .= $filter_record_query_object->getJoinStatement();
                    $where_str .= $filter_record_query_object->getWhereStatement();
                    $group_str .= $filter_record_query_object->getGroupStatement();
                }
            }
        }
 
        // Build the query string
        $sql = "SELECT DISTINCT record.id, record.owner";
        if ($select_str) {
            $sql .= ', ';
        }
 
        $as = ' AS ';
 
        $sql .= rtrim($select_str, ',') . " FROM il_dcl_record $as record ";
        $sql .= $join_str;
        $sql .= " WHERE record.table_id = " . $this->db->quote($this->getId(), 'integer');
 
        if (strlen($where_str) > 0) {
            $sql .= $where_str;
        }
 
        if (strlen($group_str) > 0) {
            $sql .= " GROUP BY " . $group_str;
        }
 
        if (strlen($order_str) > 0) {
            $sql .= " ORDER BY " . $order_str;
        }
 
        $set = $this->db->query($sql);
        $total_record_ids = [];
 
        $is_allowed_to_view = (ilObjDataCollectionAccess::hasWriteAccess((int) $ref_id) || ilObjDataCollectionAccess::hasEditAccess((int) $ref_id));
        while ($rec = $this->db->fetchAssoc($set)) {
            // Quick check if the current user is allowed to view the record
            if (!$is_allowed_to_view && ($this->getViewOwnRecordsPerm() && $this->user->getId() != $rec['owner'])) {
                continue;
            }
            $total_record_ids[] = $rec['id'];
        }
        // Save record-ids in session to enable prev/next links in detail view
        ilSession::set('dcl_table_id', $this->getId());
        ilSession::set('dcl_record_ids', $total_record_ids);
 
        if ($sort_query_object != null) {
            $total_record_ids = $sort_query_object->applyCustomSorting($sort_field, $total_record_ids, $direction);
        }
 
        if ($sort === 'n_comments') {
            global $DIC;
            $comments_nr = [];
            foreach ($total_record_ids as $id) {
                $comments_nr[$id] = $DIC->notes()->domain()->getNrOfCommentsForContext($DIC->notes()->data()->context($this->getObjId(), $id, 'dcl'));
            }
            uasort($comments_nr, static fn($a, $b) => ($direction === 'asc' ? 1 : -1) * ($a <=> $b));
            $total_record_ids = array_keys($comments_nr);
        }
 
        // Now slice the array to load only the needed records in memory
        $record_ids = array_slice($total_record_ids, $offset, $limit);
 
        $records = [];
        foreach ($record_ids as $id) {
            $records[] = ilDclCache::getRecordCache($id);
        }
 
        return ['records' => $records, 'total' => count($total_record_ids)];
    }
 
    public function showInvalidFields(bool $value): void
    {
        $this->show_invalid = $value;
    }
}