class.ilDataCollectionReferenceField.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
require_once 'class.ilDataCollectionRecordField.php';
require_once 'class.ilDataCollectionRecord.php';
require_once 'class.ilDataCollectionField.php';
require_once 'class.ilDataCollectionRecordViewGUI.php';
require_once("./Services/Link/classes/class.ilLink.php");
require_once("./Modules/DataCollection/classes/class.ilDataCollectionImporter.php");
 
class ilDataCollectionReferenceField extends ilDataCollectionRecordField {
 
        protected $dcl_obj_id;
        protected $properties = array();
 
 
        public function __construct(ilDataCollectionRecord $record, ilDataCollectionField $field) {
                parent::__construct($record, $field);
                $dclTable = ilDataCollectionCache::getTableCache($this->getField()->getTableId());
                $this->dcl_obj_id = $dclTable->getCollectionObject()->getId();
                $this->properties = $this->field->getProperties();
        }
 
 
        public function getHTML() {
                $value = $this->getValue();
                $record_field = $this;
 
                if (!$value || $value == "-") {
                        return "";
                }
 
                $ref_record = ilDataCollectionCache::getRecordCache($value);
                $html = "";
                if (!$ref_record->getTableId() || !$record_field->getField() || !$record_field->getField()->getTableId()) {
                        //the referenced record_field does not seem to exist.
                        $record_field->setValue(NULL);
                        $record_field->doUpdate();
                } else {
                        if ($this->properties[ilDataCollectionField::PROPERTYID_REFERENCE_LINK]) {
                                global $ilDB;
                                $ref_record = ilDataCollectionCache::getRecordCache($value);
                                $ref_table = $ref_record->getTableId();
                                // Checks if a view exists
                                $query = "SELECT table_id FROM il_dcl_view WHERE table_id = " . $ref_table . " AND type = " . $ilDB->quote(0, "integer")
                                        . " AND formtype = " . $ilDB->quote(0, "integer");
                                $set = $ilDB->query($query);
                                if ($ilDB->numRows($set)) {
                                        $html = $this->getLinkHTML(NULL, $this->getValue());
                                } else {
                                        $html = $ref_record->getRecordFieldHTML($record_field->getField()->getFieldRef());
                                }
                        } else {
                                $html = $ref_record->getRecordFieldHTML($record_field->getField()->getFieldRef());
                        }
                }
 
                return $html;
        }
 
 
        protected function getLinkHTML($link_name = NULL, $value) {
                global $ilCtrl;
 
                if (!$value || $value == "-") {
                        return "";
                }
                $record_field = $this;
                $ref_record = ilDataCollectionCache::getRecordCache($value);
                if (!$link_name) {
                        $link_name = $ref_record->getRecordFieldHTML($record_field->getField()->getFieldRef());
                }
                $ilCtrl->setParameterByClass("ildatacollectionrecordviewgui", "record_id", $ref_record->getId());
                $html = "<a href='" . $ilCtrl->getLinkTargetByClass("ilDataCollectionRecordViewGUI", "renderRecord") . "&disable_paging=1'>" . $link_name
                        . "</a>";
 
                return $html;
        }
 
 
        public function getExportValue() {
                if ($this->getValue()) {
                        $ref_rec = ilDataCollectionCache::getRecordCache($this->getValue());
                        $exp_value = $ref_rec->getRecordField($this->getField()->getFieldRef())->getExportValue();
                        if ($exp_value instanceof stdClass) {
                                return json_encode($exp_value);
                        }
                        return $exp_value;
                } else {
                        return "";
                }
        }
 
        public function getValueFromExcel($excel, $row, $col){
                global $lng;
                $value = $excel->val($row, $col);
                $old = $value;
                $value = $this->getReferenceFromValue($value);
                if (!$value) {
                        $warning = "(" . $col . ", " . ilDataCollectionImporter::getExcelCharForInteger($col) . ") " . $lng->txt("dcl_no_such_reference") . " "
                                . $old;
                        return array('warning' => $warning);
                }
 
                return $value;
        }
 
        public function getReferenceFromValue($value) {
                $field = ilDataCollectionCache::getFieldCache($this->field->getFieldRef());
                $table = ilDataCollectionCache::getTableCache($field->getTableId());
                $record_id = 0;
                foreach ($table->getRecords() as $record) {
                        $record_value = $record->getRecordField($field->getId())->getValue();
                        // in case of a url-field
                        if ($json = json_decode($record_value,true)) {
                                $record_value = array_shift($json);
                        }
                        if ($record_value == $value) {
                                $record_id = $record->getId();
                        }
                }
 
                return $record_id;
        }
}
 
?>