class.ilDclReferenceFieldModel.php

Go to the documentation of this file.

<?php
require_once("./Modules/DataCollection/classes/Fields/Fileupload/class.ilDclFileuploadFieldModel.php");
require_once("./Modules/DataCollection/classes/Helpers/class.ilDclRecordQueryObject.php");

class ilDclReferenceFieldModel extends ilDclBaseFieldModel {
        const PROP_REFERENCE = 'table_id';
        const PROP_N_REFERENCE = 'multiple_selection';

        public function getRecordQuerySortObject($direction = "asc", $sort_by_status = false){
                global $DIC;
                $ilDB = $DIC['ilDB'];

                $ref_field = ilDclCache::getFieldCache($this->getProperty(self::PROP_REFERENCE));
                if($this->hasProperty(self::PROP_N_REFERENCE)) {
                        $n_ref = true;
                }

                $select_str = ($n_ref) ? " ". $ilDB->groupConcat("stloc_{$this->getId()}_joined.value") . " AS field_{$this->getId()}" : "stloc_{$this->getId()}_joined.value AS field_{$this->getId()},";
                $join_str = "LEFT JOIN il_dcl_record_field AS record_field_{$this->getId()} ON (record_field_{$this->getId()}.record_id = record.id AND record_field_{$this->getId()}.field_id = "
                        . $ilDB->quote($this->getId(), 'integer') . ") ";
                $join_str .= "LEFT JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS stloc_{$this->getId()} ON (stloc_{$this->getId()}.record_field_id = record_field_{$this->getId()}.id) ";
                $join_str .= "LEFT JOIN il_dcl_record_field AS record_field_{$this->getId()}_joined ON (record_field_{$this->getId()}_joined.record_id = stloc_{$this->getId()}.value AND record_field_{$this->getId()}_joined.field_id = "
                        . $ilDB->quote($ref_field->getId(), 'integer') . ") ";
                $join_str .= "LEFT JOIN il_dcl_stloc{$ref_field->getStorageLocation()}_value AS stloc_{$this->getId()}_joined ON (stloc_{$this->getId()}_joined.record_field_id = record_field_{$this->getId()}_joined.id) ";

                $sql_obj = new ilDclRecordQueryObject();
                $sql_obj->setSelectStatement($select_str);
                $sql_obj->setJoinStatement($join_str);
                $sql_obj->setOrderStatement("field_{$this->getId()} ".$direction);

                if($n_ref) {
                        $sql_obj->setGroupStatement("record.id, record.owner");
                }

                return $sql_obj;
        }


        public function getRecordQueryFilterObject($filter_value = "", ilDclBaseFieldModel $sort_field = null) {
                global $DIC;
                $ilDB = $DIC['ilDB'];

                $n_ref = $this->getProperty(ilDclBaseFieldModel::PROP_N_REFERENCE);

                $join_str =
                        " INNER JOIN il_dcl_record_field AS filter_record_field_{$this->getId()} ON (filter_record_field_{$this->getId()}.record_id = record.id AND filter_record_field_{$this->getId()}.field_id = "
                        . $ilDB->quote($this->getId(), 'integer') . ") ";

                if ($n_ref) {
                        $join_str .=
                                " INNER JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS filter_stloc_{$this->getId()} ON (filter_stloc_{$this->getId()}.record_field_id = filter_record_field_{$this->getId()}.id AND filter_stloc_{$this->getId()}.value LIKE "
                                . $ilDB->quote("%$filter_value%", 'text') . ") ";
                } else {
                        $join_str .=
                                " INNER JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS filter_stloc_{$this->getId()} ON (filter_stloc_{$this->getId()}.record_field_id = filter_record_field_{$this->getId()}.id AND filter_stloc_{$this->getId()}.value = "
                                . $ilDB->quote($filter_value, 'integer') . ") ";
                }

                $sql_obj = new ilDclRecordQueryObject();
                $sql_obj->setJoinStatement($join_str);

                return $sql_obj;
        }

        public function getValidFieldProperties() {
                return array(ilDclBaseFieldModel::PROP_REFERENCE, ilDclBaseFieldModel::PROP_REFERENCE_LINK, ilDclBaseFieldModel::PROP_N_REFERENCE);
        }

        public function allowFilterInListView() {
                //A reference-field is not filterable if the referenced field is of datatype MOB or File
                $ref_field = $this->getFieldRef();
                return ! ($ref_field->getDatatypeId() == ilDclDatatype::INPUTFORMAT_MOB
                        || $ref_field->getDatatypeId() == ilDclDatatype::INPUTFORMAT_FILE);
        }
        
        public function getFieldRef() {
                return ilDclCache::getFieldCache((int)$this->getProperty(ilDclBaseFieldModel::PROP_REFERENCE));
        }


        public function afterClone($records) {
                $clone = ilDclCache::getCloneOf($this->getId(), ilDclCache::TYPE_FIELD);
                $reference_clone = ilDclCache::getCloneOf((int)$clone->getProperty(ilDclBaseFieldModel::PROP_REFERENCE), ilDclCache::TYPE_FIELD);
                if ($reference_clone) {
                        $this->setProperty(ilDclBaseFieldModel::PROP_REFERENCE, $reference_clone->getId());
                        $this->updateProperties();
                }
                parent::afterClone($records);
        }
}