class.ilDataCollectionNReferenceField.php

Go to the documentation of this file.

<?php
 
class ilDataCollectionNReferenceField extends ilDataCollectionReferenceField {
 
        protected $max_reference_length = 20;
 
 
        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);
        }
 
 
        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) {
 
                // if we are in a record view and the n-ref should be displayed as a link to it's reference
                $values = $this->getValue();
                $record_field = $this;
 
                if (!$values || !count($values)) {
                        return "";
                }
 
                $tpl = $this->buildTemplate($record_field, $values, $options);
 
                return $tpl->get();
        }
 
 
        public function buildTemplate($record_field, $values, $options) {
                $tpl = new ilTemplate("tpl.reference_list.html", true, true, "Modules/DataCollection");
                $tpl->setCurrentBlock("reference_list");
                foreach ($values as $value) {
                        $ref_record = ilDataCollectionCache::getRecordCache($value);
                        if (!$ref_record->getTableId() || !$record_field->getField() || !$record_field->getField()->getTableId()) {
                                //the referenced record_field does not seem to exist.
                                $record_field->setValue(0);
                                $record_field->doUpdate();
                        } else {
                                $tpl->setCurrentBlock("reference");
                                if (!$options) {
                                        $tpl->setVariable("CONTENT", $ref_record->getRecordFieldHTML($this->getField()->getFieldRef()));
                                } else {
                                        $tpl->setVariable("CONTENT", $this->getLinkHTML($options['link']['name'], $value));
                                }
                                $tpl->parseCurrentBlock();
                        }
                }
                $tpl->parseCurrentBlock();
 
                return $tpl;
        }
 
 
        protected function getLinkHTML($link, $value) {
                if ($link == "[" . $this->getField()->getTitle() . "]") {
                        $link = NULL;
                }
 
                return parent::getLinkHTML($link, $value);
        }
 
 
        public function getHTML() {
                $values = $this->getValue();
                $record_field = $this;
 
                if (!$values OR !count($values)) {
                        return "";
                }
 
                $html = "";
                $cut = false;
                $tpl = new ilTemplate("tpl.reference_hover.html", true, true, "Modules/DataCollection");
                $tpl->setCurrentBlock("reference_list");
                $elements = array();
                foreach ($values as $value) {
                        $ref_record = ilDataCollectionCache::getRecordCache($value);
                        if (!$ref_record->getTableId() OR !$record_field->getField() OR !$record_field->getField()->getTableId()) {
                                //the referenced record_field does not seem to exist.
                                $record_field->setValue(NULL);
                                $record_field->doUpdate();
                        } else {
                                $elements[] = array('value' => $ref_record->getRecordFieldHTML($this->getField()->getFieldRef()),
                                                                        'sort' => $ref_record->getRecordFieldSortingValue($this->getField()->getFieldRef()));
                        }
                }
 
                //sort fetched elements
                $is_numeric = false;
                $ref_field = new ilDataCollectionField($record_field->getField()->getFieldRef());
                switch ($ref_field->getDatatypeId()) {
                        case ilDataCollectionDatatype::INPUTFORMAT_DATETIME:
                        case ilDataCollectionDatatype::INPUTFORMAT_NUMBER:
                                $is_numeric = true;
                                break;
                }
                $elements = ilUtil::sortArray($elements, 'sort', 'asc', $is_numeric);
 
                //concat
                foreach($elements as $element) {
                        if ((strlen($html) < $this->max_reference_length)) {
                                $html .= $element['value'] . ", ";
                        } else {
                                $cut = true;
                        }
                        $tpl->setCurrentBlock("reference");
                        $tpl->setVariable("CONTENT", $element['value']);
                        $tpl->parseCurrentBlock();
                }
 
                $html = substr($html, 0, - 2);
                if ($cut) {
                        $html .= "...";
                }
                $tpl->setVariable("RECORD_ID", $this->getRecord()->getId());
                $tpl->setVariable("ALL", $html);
                $tpl->parseCurrentBlock();
 
                return $tpl->get();
        }
 
 
        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;
        }
}
 
?>