class.ilDataCollectionNReferenceField.php

Go to the documentation of this file.

<?php
require_once('./Modules/DataCollection/classes/Field/NReference/class.ilDataCollectionNReferenceFieldGUI.php');
class ilDataCollectionNReferenceField extends ilDataCollectionReferenceField {
 
        protected $max_reference_length = 20;
 
 
        public function getMaxReferenceLength() {
                return $this->max_reference_length;
        }
 
 
        public function setMaxReferenceLength($max_reference_length) {
                $this->max_reference_length = $max_reference_length;
        }
 
 
 
 
        public function doUpdate() {
                global $ilDB;
 
                $values = $this->getValue();
                if (!is_array($values)) {
                        $values = array( $values );
                }
                $datatype = $this->field->getDatatype();
 
                $query = "DELETE FROM il_dcl_stloc" . $datatype->getStorageLocation() . "_value WHERE record_field_id = "
                        . $ilDB->quote($this->id, "integer");
                $ilDB->manipulate($query);
 
                if (!count($values) || $values[0] == 0) {
                        return;
                }
 
                $query = "INSERT INTO il_dcl_stloc" . $datatype->getStorageLocation() . "_value (value, record_field_id, id) VALUES";
                foreach ($values as $value) {
                        $next_id = $ilDB->nextId("il_dcl_stloc" . $datatype->getStorageLocation() . "_value");
                        $query .= " (" . $ilDB->quote($value, $datatype->getDbType()) . ", " . $ilDB->quote($this->getId(), "integer") . ", "
                                . $ilDB->quote($next_id, "integer") . "),";
                }
                $query = substr($query, 0, - 1);
                $ilDB->manipulate($query);
        }
 
 
        public function getValue() {
                $this->loadValue();
 
                return $this->value;
        }
 
 
        protected function loadValueSorted() {
                if ($this->value === NULL) {
 
                        global $ilDB;
                        $datatype = $this->field->getDatatype();
                        $refField = ilDataCollectionCache::getFieldCache($this->getField()->getFieldRef());
 
                        $supported_internal_types = array(
                                ilDataCollectionDatatype::INPUTFORMAT_ILIAS_REF,
                                ilDataCollectionDatatype::INPUTFORMAT_MOB,
                                ilDataCollectionDatatype::INPUTFORMAT_FILE,
                        );
 
                        $supported_types = array_merge(array(
                                ilDataCollectionDatatype::INPUTFORMAT_TEXT,
                                ilDataCollectionDatatype::INPUTFORMAT_NUMBER,
                                ilDataCollectionDatatype::INPUTFORMAT_BOOLEAN,
                        ), $supported_internal_types);
                        $datatypeId = $refField->getDatatypeId();
                        if (in_array($datatypeId, $supported_types)) {
                                if (in_array($datatypeId, $supported_internal_types)) {
                                        $query = "SELECT stlocOrig.value AS value,  ilias_object.title AS value_ref ";
                                } else {
                                        $query = "SELECT stlocOrig.value AS value,  stlocRef.value AS value_ref ";
                                }
                                $query .= "FROM il_dcl_stloc" . $datatype->getStorageLocation() . "_value AS stlocOrig  ";
 
                                $query .= " INNER JOIN il_dcl_record_field AS refField ON stlocOrig.value = refField.record_id AND refField.field_id = "
                                        . $ilDB->quote($refField->getId(), "integer");
                                $query .= " INNER JOIN il_dcl_stloc" . $refField->getStorageLocation()
                                        . "_value AS stlocRef ON stlocRef.record_field_id = refField.id ";
                        } else {
                                $query = "SELECT stlocOrig.value AS value ";
                                $query .= "FROM il_dcl_stloc" . $datatype->getStorageLocation() . "_value AS stlocOrig  ";
                        }
 
                        switch ($datatypeId) {
                                case ilDataCollectionDatatype::INPUTFORMAT_ILIAS_REF:
                                        $query .= " INNER JOIN object_reference AS ilias_ref ON ilias_ref.ref_id = stlocRef.value ";
                                        $query .= " INNER JOIN object_data AS ilias_object ON ilias_object.obj_id = ilias_ref.obj_id ";
                                        break;
                                case ilDataCollectionDatatype::INPUTFORMAT_MOB:
                                case ilDataCollectionDatatype::INPUTFORMAT_FILE:
                                        $query .= " INNER JOIN object_data AS ilias_object ON ilias_object.obj_id =  stlocRef.value ";
                                        break;
                        }
                        $query .= " WHERE stlocOrig.record_field_id = " . $ilDB->quote($this->id, "integer");
                        if (in_array($datatypeId, $supported_types)) {
                                $query .= " ORDER BY value_ref ASC";
                        }
 
                        $set = $ilDB->query($query);
 
                        $this->value = array();
                        while ($rec = $ilDB->fetchAssoc($set)) {
                                $this->value[] = $rec['value'];
                        }
                }
        }
 
 
        protected function loadValue() {
                if ($this->value === NULL) {
                        global $ilDB;
                        $datatype = $this->field->getDatatype();
                        $query = "SELECT * FROM il_dcl_stloc" . $datatype->getStorageLocation() . "_value WHERE record_field_id = "
                                . $ilDB->quote($this->id, "integer");
                        $set = $ilDB->query($query);
                        $this->value = array();
                        while ($rec = $ilDB->fetchAssoc($set)) {
                                $this->value[] = $rec['value'];
                        }
                }
        }
 
 
        public function getSingleHTML($options = NULL) {
                $ilDataCollectionNReferenceFieldGUI = new ilDataCollectionNReferenceFieldGUI($this);
                return $ilDataCollectionNReferenceFieldGUI->getSingleHTML($options);
        }
 
 
 
        public function getLinkHTML($link, $value) {
                if ($link == "[" . $this->getField()->getTitle() . "]") {
                        $link = NULL;
                }
 
                return parent::getLinkHTML($link, $value);
        }
 
 
        public function getHTML() {
                $ilDataCollectionNReferenceFieldGUI = new ilDataCollectionNReferenceFieldGUI($this);
                return $ilDataCollectionNReferenceFieldGUI->getHTML();
        }
 
        public function getValueFromExcel($excel, $row, $col){
                global $lng;
                $stringValue = $excel->val($row, $col);
                $this->getReferencesFromString($stringValue);
                $referenceIds = $this->getReferencesFromString($stringValue);
                if (!count($referenceIds)) {
                        $warning = "(" . $col . ", " . ilDataCollectionImporter::getExcelCharForInteger($col) . ") " . $lng->txt("dcl_no_such_reference") . " "
                                . $stringValue;
                        return array('warning' => $warning);
                }
 
                return $referenceIds;
        }
 
        public function getExportValue() {
                $values = $this->getValue();
                $names = array();
                foreach ($values as $value) {
                        if ($value) {
                                $ref_rec = ilDataCollectionCache::getRecordCache($value);
                                $names[] = $ref_rec->getRecordField($this->getField()->getFieldRef())->getValue();
                        }
                }
                $string = "";
                foreach ($names as $name) {
                        $string .= $name . ", ";
                }
                if (!count($names)) {
                        return "";
                }
                $string = substr($string, 0, - 2);
 
                return $string;
        }
 
        protected function getReferencesFromString($stringValues) {
                $slicedStrings = explode(", ", $stringValues);
                $slicedReferences = array();
                $resolved = 0;
                for($i = 0; $i < count($slicedStrings); $i++) {
                        //try to find a reference since the last resolved value separated by a comma.
                        // $i = 1; $resolved = 0; $string = "hello, world, gaga" -> try to match "hello, world".
                        $searchString = implode(array_slice($slicedStrings, $resolved, $i - $resolved + 1));
                        if($ref = $this->getReferenceFromValue($searchString)){
                                $slicedReferences[] = $ref;
                                $resolved = $i;
                                continue;
                        }
 
                        //try to find a reference with the current index.
                        // $i = 1; $resolved = 0; $string = "hello, world, gaga" -> try to match "world".
                        $searchString = $slicedStrings[$i];
                        if($ref = $this->getReferenceFromValue($searchString)){
                                $slicedReferences[] = $ref;
                                $resolved = $i;
                                continue;
                        }
                }
                return $slicedReferences;
        }
}
 
?>