class.ilDclTableView.php

Go to the documentation of this file.

<?php
 
class ilDclTableView extends ActiveRecord
{
 
    protected $id;
    protected $table_id;
    protected $title;
    protected $roles = array();
    protected $description;
    protected $tableview_order;
    protected $step_vs;
    protected $step_c;
    protected $step_e;
    protected $step_o;
    protected $step_s;
    protected $visible_fields_cache;
 
 
    public static function returnDbTableName()
    {
        return "il_dcl_tableview";
    }
 
 
    public function getId()
    {
        return $this->id;
    }
 
 
    public function setId($id)
    {
        $this->id = $id;
    }
 
 
    public function getTableId()
    {
        return $this->table_id;
    }
 
 
    public function setTableId($table_id)
    {
        $this->table_id = $table_id;
    }
 
 
    public function getTitle()
    {
        return $this->title;
    }
 
 
    public function setTitle($title)
    {
        $this->title = $title;
    }
 
 
    public function getOrder()
    {
        return $this->tableview_order;
    }
 
 
    public function setOrder($order)
    {
        $this->tableview_order = $order;
    }
 
 
    public function getDescription()
    {
        return $this->description;
    }
 
 
    public function setDescription($description)
    {
        $this->description = $description;
    }
 
 
    public function getTableviewOrder()
    {
        return $this->tableview_order;
    }
 
 
    public function setTableviewOrder($tableview_order)
    {
        $this->tableview_order = $tableview_order;
    }
 
 
    public function isStepVs()
    {
        return $this->step_vs;
    }
 
 
    public function setStepVs($step_vs)
    {
        $this->step_vs = $step_vs;
    }
 
 
    public function isStepC()
    {
        return $this->step_c;
    }
 
 
    public function setStepC($step_c)
    {
        $this->step_c = $step_c;
    }
 
 
    public function isStepE()
    {
        return $this->step_e;
    }
 
 
    public function setStepE($step_e)
    {
        $this->step_e = $step_e;
    }
 
 
    public function isStepO()
    {
        return $this->step_o;
    }
 
 
    public function setStepO($step_o)
    {
        $this->step_o = $step_o;
    }
 
 
    public function isStepS()
    {
        return $this->step_s;
    }
 
 
    public function setStepS($step_s)
    {
        $this->step_s = $step_s;
    }
 
 
    public function getRoles()
    {
        return (array) $this->roles;
    }
 
 
    public function setRoles(array $roles)
    {
        $this->roles = $roles;
    }
 
 
    public function sleep($field_name)
    {
        if ($field_name == 'roles') {
            return json_encode($this->roles);
        }
 
        return null;
    }
 
 
    public function wakeUp($field_name, $field_value)
    {
        if ($field_name == 'roles') {
            return json_decode($field_value);
        }
 
        return null;
    }
 
 
    public function delete()
    {
        //Delete settings
        foreach ($this->getFieldSettings() as $setting) {
            $setting->delete();
        }
        parent::delete();
    }
 
 
    public function getTable()
    {
        return ilDclCache::getTableCache($this->table_id);
    }
 
 
    public function getFilterableFieldSettings()
    {
        return ilDclTableViewFieldSetting::where(
            array(
                "tableview_id" => $this->id,
                'in_filter' => 1,
                'il_dcl_tfield_set.table_id' => $this->getTableId(),
            )
        )->innerjoin('il_dcl_tfield_set', 'field', 'field', array())
            ->orderBy('il_dcl_tfield_set.field_order')
            ->get();
    }
 
 
    public function getVisibleFields()
    {
        if (!$this->visible_fields_cache) {
            $visible = ilDclTableViewFieldSetting::
            where(
                array(
                    "tableview_id" => $this->id,
                    'visible' => true,
                    'il_dcl_tfield_set.table_id' => $this->getTableId(),
                )
            )->innerjoin('il_dcl_tfield_set', 'field', 'field', array())->orderBy('il_dcl_tfield_set.field_order')->get();
            $fields = array();
            foreach ($visible as $field_rec) {
                $fields[] = $field_rec->getFieldObject();
            }
            $this->visible_fields_cache = $fields;
        }
 
        return $this->visible_fields_cache;
    }
 
    public function getFieldSettings() : array
    {
        return ilDclTableViewFieldSetting::where(
            array(
                'tableview_id' => $this->getId(),
                'il_dcl_tfield_set.table_id' => $this->getTableId(),
            )
        )->innerjoin('il_dcl_tfield_set', 'field', 'field', array('field_order'))->orderBy('field_order')->get();
    }
 
    public function getFieldSetting($field_id) : ilDclTableViewFieldSetting
    {
        return ilDclTableViewFieldSetting::where([
            'tableview_id' => $this->getId(),
            'field' => $field_id
        ])->first();
    }
 
    public function create($create_default_settings = true)
    {
        parent::create();
        if ($create_default_settings) {
            $this->createDefaultSettings();
        }
    }
 
 
    public function createDefaultSettings()
    {
        $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)
    {
        if (!ilDclTableViewFieldSetting::where(
            array(
                '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)
    {
        //clone structure
        $this->setTitle($orig->getTitle());
        $this->setOrder($orig->getOrder());
        $this->setDescription($orig->getDescription());
        $this->setRoles($orig->getRoles());
        $this->setStepVs($orig->isStepVs());
        $this->setStepC($orig->isStepC());
        $this->setStepE($orig->isStepE());
        $this->setStepO($orig->isStepO());
        $this->setStepS($orig->isStepS());
        $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()]) {
                //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();
            }
        }
 
        //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($table_id)
    {
        return self::where(array('table_id' => $table_id))->orderBy('tableview_order')->get();
    }
 
 
    public static function getCountForTableId($table_id)
    {
        return self::where(array('table_id' => $table_id))->orderBy('tableview_order')->count();
    }
 
 
    public static function createOrGetStandardView($table_id, $create_default_settings = true)
    {
        if ($standardview = self::where(array('table_id' => $table_id))->orderBy('tableview_order')->first()) {
            return $standardview;
        }
 
        global $DIC;
        $rbacreview = $DIC['rbacreview'];
        $roles = array();
        foreach ($rbacreview->getParentRoleIds($_GET['ref_id']) as $role_array) {
            $roles[] = $role_array['obj_id'];
        }
 
        $view = new self();
 
        if ($_GET['ref_id']) {
            global $DIC;
            $rbacreview = $DIC['rbacreview'];
            $roles = array();
            foreach ($rbacreview->getParentRoleIds($_GET['ref_id']) as $role_array) {
                $roles[] = $role_array['obj_id'];
            }
            $view->setRoles(array_merge($roles, $rbacreview->getLocalRoles($_GET['ref_id'])));
        }
        $view->setTableId($table_id);
        // bugfix mantis 0023307
        $lng = $DIC['lng'];
        $view->setTitle($lng->txt('dcl_title_standardview'));
        $view->setTableviewOrder(10);
        $view->setStepVs(true);
        $view->setStepC(false);
        $view->setStepE(false);
        $view->setStepO(false);
        $view->setStepS(false);
        $view->create($create_default_settings);
 
        return $view;
    }
 
 
    public function validateConfigCompletion()
    {
        return $this->step_vs && $this->step_c && $this->step_e && $this->step_o;
    }
}