class.ilDclTableView.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilDclTableView extends ActiveRecord
{
    protected ?int $id;
    protected int $table_id = 0;
    protected string $title = "";
    protected array $roles = [];
    protected bool $role_limitation = false;
    protected string $description = '';
    protected int $tableview_order = 0;
    protected array $visible_fields_cache = [];
 
    public static function returnDbTableName(): string
    {
        return "il_dcl_tableview";
    }
 
    public function getId(): ?int
    {
        return $this->id;
    }
 
    public function setId(int $id): void
    {
        $this->id = $id;
    }
 
    public function getTableId(): int
    {
        return $this->table_id;
    }
 
    public function setTableId(int $table_id): void
    {
        $this->table_id = $table_id;
    }
 
    public function getTitle(): string
    {
        return $this->title;
    }
 
    public function setTitle(string $title): void
    {
        $this->title = $title;
    }
 
    public function getOrder(): int
    {
        return $this->tableview_order;
    }
 
    public function setOrder(int $order): void
    {
        $this->tableview_order = $order;
    }
 
    public function getDescription(): string
    {
        return $this->description;
    }
 
    public function setDescription(string $description): void
    {
        $this->description = $description;
    }
 
    public function getTableviewOrder(): int
    {
        return $this->tableview_order;
    }
 
    public function setTableviewOrder(int $tableview_order): void
    {
        $this->tableview_order = $tableview_order;
    }
 
    public function getRoles(): array
    {
        return $this->roles;
    }
 
    public function setRoles(array $roles): void
    {
        $this->roles = $roles;
    }
 
    public function getRoleLimitation(): bool
    {
        return $this->role_limitation;
    }
 
    public function setRoleLimitation(bool $role_limitation): void
    {
        $this->role_limitation = $role_limitation;
    }
 
    public function sleep($field_name): ?string
    {
        if ($field_name == 'roles') {
            return json_encode($this->roles);
        }
 
        return null;
    }
 
    public function wakeUp($field_name, $field_value): ?array
    {
        if ($field_name == 'roles') {
            return json_decode($field_value);
        }
 
        return null;
    }
 
    public function delete(): void
    {
        //Delete settings
        foreach ($this->getFieldSettings() as $setting) {
            $setting->delete();
        }
        parent::delete();
    }
 
    public function getTable(): ilDclTable
    {
        return ilDclCache::getTableCache($this->table_id);
    }
 
    public static function findOrGetInstance($primary_key, array $add_constructor_args = []): ActiveRecord
    {
        return parent::findOrGetInstance($primary_key, $add_constructor_args);
    }
 
    public function getFilterableFieldSettings(): array
    {
        return ilDclTableViewFieldSetting::where(
            [
                "tableview_id" => $this->id,
                'in_filter' => 1,
                'il_dcl_tfield_set.table_id' => $this->getTableId(),
            ]
        )->innerjoin('il_dcl_tfield_set', 'field', 'field', [])
                                         ->orderBy('il_dcl_tfield_set.field_order')
                                         ->get();
    }
 
    public function getVisibleFields(): array
    {
        if (!$this->visible_fields_cache) {
            $visible = ilDclTableViewFieldSetting::where(
                [
                    "tableview_id" => $this->id,
                    'visible' => true,
                    'il_dcl_tfield_set.table_id' => $this->getTableId(),
                ]
            )->innerjoin(
                'il_dcl_tfield_set',
                'field',
                'field',
                []
            )->orderBy('il_dcl_tfield_set.field_order')->get();
            $fields = [];
            foreach ($visible as $field_rec) {
                $fields[] = $field_rec->getFieldObject();
            }
            $this->visible_fields_cache = $fields;
        }
 
        return $this->visible_fields_cache;
    }
 
    public function getFieldSettings(): array
    {
        $settings = ilDclTableViewFieldSetting::where(
            [
                'tableview_id' => $this->getId(),
                'il_dcl_tfield_set.table_id' => $this->getTableId(),
            ]
        )->innerjoin('il_dcl_tfield_set', 'field', 'field', [])->orderBy('il_dcl_tfield_set.field_order')->get();
 
        $result = [];
        foreach ($settings as $setting) {
            $datatype = $setting->getFieldObject()->getDatatypeId();
            if ($datatype === null || in_array($datatype, array_keys(ilDclDatatype::getAllDatatype()))) {
                $result[] = $setting;
            }
        }
 
        return $result;
    }
 
    public function getFieldSetting($field_id): ActiveRecord
    {
        return ilDclTableViewFieldSetting::where([
            'tableview_id' => $this->getId(),
            'field' => $field_id
        ])->first();
    }
 
    public function create(bool $create_default_settings = true): void
    {
        parent::create();
        if ($create_default_settings) {
            $this->createDefaultSettings();
        }
    }
 
    public function createDefaultSettings(): void
    {
        $table = ilDclCache::getTableCache($this->table_id);
 
        foreach ($table->getFieldIds() as $field_id) {
            $this->createFieldSetting($field_id);
        }
 
        //ilDclTable->getFieldIds won't reuturn comments if they are disabled,
        //still we have to create a fieldsetting for this field
        if (!$table->getPublicCommentsEnabled()) {
            $this->createFieldSetting('comments');
        }
    }
 
    public function createFieldSetting($field_id): void
    {
        if (!ilDclTableViewFieldSetting::where(
            [
                'tableview_id' => $this->id,
                'field' => $field_id,
            ]
        )->get()
        ) {
            $field_set = new ilDclTableViewFieldSetting();
            $field_set->setTableviewId($this->id);
            $field_set->setField($field_id);
            $field_set->setVisible(!ilDclStandardField::_isStandardField($field_id));
            $field_set->setFilterChangeable(true);
            $field_set->setLockedCreate(false);
            $field_set->setLockedEdit(false);
            $field_set->setRequiredCreate(false);
            $field_set->setRequiredEdit(false);
            $field_set->setVisibleCreate(true);
            $field_set->setVisibleEdit(true);
            $field_set->create();
        }
    }
 
    public function cloneStructure(ilDclTableView $orig, array $new_fields): void
    {
        global $DIC;
        //clone structure
        $this->setTitle($orig->getTitle() . ' ' . $DIC->language()->txt('copy_of_suffix'));
        $this->setOrder($orig->getOrder());
        $this->setDescription($orig->getDescription());
        $this->setRoles($orig->getRoles());
        $this->setRoleLimitation($orig->getRoleLimitation());
        $this->create(false); //create default setting, adjust them later
 
        //clone default values
        $f = new ilDclDefaultValueFactory();
 
        //clone fieldsettings
        foreach ($orig->getFieldSettings() as $orig_fieldsetting) {
            $new_fieldsetting = new ilDclTableViewFieldSetting();
            $new_fieldsetting->setTableviewId($this->getId());
            if ($new_fields[$orig_fieldsetting->getField()] ?? null) {
                //normal fields
                $new_fieldsetting->setField($new_fields[$orig_fieldsetting->getField()]->getId());
            } else {
                //standard fields
                $new_fieldsetting->setField($orig_fieldsetting->getField());
            }
            $new_field_id = $new_fieldsetting->cloneStructure($orig_fieldsetting);
 
            //clone default value
            $datatype = $orig_fieldsetting->getFieldObject()->getDatatypeId();
            $match = ilDclTableViewBaseDefaultValue::findSingle($datatype, $orig_fieldsetting->getId());
 
            if (!is_null($match)) {
                $new_default_value = $f->create($datatype);
                $new_default_value->setTviewSetId($new_field_id);
                $new_default_value->setValue($match->getValue());
                $new_default_value->create();
            }
        }
        $this->createFieldSetting('comments');
 
        //clone pageobject
        if (ilDclDetailedViewDefinition::exists($orig->getId())) {
            $orig_pageobject = new ilDclDetailedViewDefinition($orig->getId());
            $orig_pageobject->copy($this->getId());
        }
 
        // mandatory for all cloning functions
        ilDclCache::setCloneOf($orig->getId(), $this->getId(), ilDclCache::TYPE_TABLEVIEW);
    }
 
    public static function getAllForTableId(int $table_id): array
    {
        return self::where(['table_id' => $table_id])->orderBy('title')->get();
    }
 
    public static function getCountForTableId(int $table_id): int
    {
        return self::where(['table_id' => $table_id])->orderBy('tableview_order')->count();
    }
 
    public static function createOrGetStandardView(int $table_id): ActiveRecord
    {
        if ($standardview = self::where(['table_id' => $table_id])->orderBy('tableview_order')->first()) {
            return $standardview;
        }
 
        global $DIC;
        $rbacreview = $DIC['rbacreview'];
        $http = $DIC->http();
        $refinery = $DIC->refinery();
 
        $roles = [];
 
        $ref_id = $http->wrapper()->query()->retrieve('ref_id', $refinery->kindlyTo()->int());
        foreach ($rbacreview->getParentRoleIds($ref_id) as $role_array) {
            $roles[] = $role_array['obj_id'];
        }
 
        $view = new self();
 
        $hasRefId = $http->wrapper()->query()->has('ref_id');
 
        if ($hasRefId) {
            global $DIC;
            $rbacreview = $DIC['rbacreview'];
 
            $ref_id = $http->wrapper()->query()->retrieve('ref_id', $refinery->kindlyTo()->int());
 
            $roles = [];
            foreach ($rbacreview->getParentRoleIds($ref_id) as $role_array) {
                $roles[] = $role_array['obj_id'];
            }
            $view->setRoles(array_merge($roles, $rbacreview->getLocalRoles($ref_id)));
        }
        $view->setTableId($table_id);
        // bugfix mantis 0023307
        $lng = $DIC['lng'];
        $view->setTitle($lng->txt('dcl_title_standardview'));
        $view->setTableviewOrder(10);
        $view->create();
 
        return $view;
    }
}