Inheritance diagram for ilDclIliasReferenceFieldModel:

Collaboration diagram for ilDclIliasReferenceFieldModel:

Public Member Functions
	getRecordQuerySortObject ($direction="asc", $sort_by_status=false)
	Returns a query-object for building the record-loader-sql-query. More...

	getRecordQueryFilterObject ($filter_value="", ilDclBaseFieldModel $sort_field=null)
	Returns a query-object for building the record-loader-sql-query. More...

	getValidFieldProperties ()

Public Member Functions inherited from ilDclBaseFieldModel
	__construct ($a_id=0)

	setId ($a_id)
	Set field id. More...

	getId ()
	Get field id. More...

	setTableId ($a_id)
	Set table id. More...

	getTableId ()
	Get table id. More...

	setTitle ($a_title)
	Set title. More...

	getTitle ()
	Get title. More...

	setDescription ($a_desc)
	Set description. More...

	getDescription ()
	Get description. More...

	setDatatypeId ($a_id)
	Set datatype id. More...

	getDatatypeId ()
	Get datatype_id. More...

	setRequired ($a_required)
	Set Required. More...

	getRequired ()
	Get Required Required. More...

	isUnique ()

	setUnique ($unique)

	getDatatype ()

	getDatatypeTitle ()

	getStorageLocation ()
	Get storage location for the model. More...

	getExportable ()

	toArray ()

	isStandardField ()

	doRead ()
	Read field. More...

	buildFromDBRecord ($rec)
	Builds model from db record. More...

	doCreate ()
	Create new field. More...

	doUpdate ()
	Update field. More...

	updateProperties ()
	Update properties of this field in Database. More...

	doDelete ()
	Remove field and properties. More...

	getFieldSettings ()

	getOrder ()

	setOrder ($order)

	hasProperty ($key)
	Checks if a certain property for a field is set. More...

	getProperty ($key)
	Returns a certain property of a field. More...

	getPropertyInstance ($key)
	Return ActiveRecord of property. More...

	setProperty ($key, $value)
	Set a property for a field (does not save) More...

	getValidFieldProperties ()
	Returns all valid properties for a field-type. More...

	setLocked ($locked)

	getLocked ()

	checkValidityFromForm (ilPropertyFormGUI &$form, $record_id=NULL)

	checkValidity ($value, $record_id=NULL)
	Check if input is valid. More...

	cloneStructure ($original_id)

	afterClone ($records)

	cloneProperties (ilDclBaseFieldModel $originalField)

	setExportable ($exportable)

	allowFilterInListView ()

	getRecordQuerySortObject ($direction="asc", $sort_by_status=false)
	Returns a query-object for building the record-loader-sql-query. More...

	getRecordQueryFilterObject ($filter_value="", ilDclBaseFieldModel $sort_field=null)
	Returns a query-object for building the record-loader-sql-query. More...

	getSortField ()
	Returns the sort-field id. More...

	hasNumericSorting ()
	Set to true, when the sorting should be handled numerical. More...

	checkFieldCreationInput (ilPropertyFormGUI $form)
	Checks input of specific fields befor saving. More...

	getStorageLocationOverride ()

	setStorageLocationOverride ($storage_location_override)

	fillHeaderExcel (ilExcel $worksheet, &$row, &$col)

	checkTitlesForImport (array &$titles, array &$import_fields)

Additional Inherited Members
Static Public Member Functions inherited from ilDclBaseFieldModel
static	_getTitleInvalidChars ($a_as_regex=true)
	All valid chars for filed titles. More...

static	_getFieldIdByTitle ($title, $table_id)

Data Fields inherited from ilDclBaseFieldModel
const	PROP_LENGTH = "lenght"
	General properties. More...

const	PROP_REGEX = "regex"

const	PROP_REFERENCE = "table_id"

const	PROP_URL = "url"

const	PROP_TEXTAREA = "text_area"

const	PROP_REFERENCE_LINK = "reference_link"

const	PROP_WIDTH = "width"

const	PROP_HEIGHT = "height"

const	PROP_LEARNING_PROGRESS = "learning_progress"

const	PROP_ILIAS_REFERENCE_LINK = "ILIAS_reference_link"

const	PROP_N_REFERENCE = "multiple_selection"

const	PROP_FORMULA_EXPRESSION = "expression"

const	PROP_DISPLAY_COPY_LINK_ACTION_MENU = "display_action_menu"

const	PROP_LINK_DETAIL_PAGE_TEXT = "link_detail_page"

const	PROP_SUPPORTED_FILE_TYPES = "supported_file_types"

const	PROP_PLUGIN_HOOK_NAME = "plugin_hook_name"

const	EDIT_VIEW = 2

const	EXPORTABLE_VIEW = 4

Protected Member Functions inherited from ilDclBaseFieldModel
	loadDatatype ()
	Load datatype for model. More...

	loadTableFieldSetting ()
	loadTableFieldSetting More...

	addToTableViews ()
	create ilDclTableViewFieldSettings for this field in each tableview More...

	updateTableFieldSetting ()
	update exportable and fieldorder More...

	loadProperties ()
	Get all properties of a field. More...

	normalizeValue ($value)

Protected Attributes inherited from ilDclBaseFieldModel
	$id

	$table_id

	$title

	$description

	$datatypeId

	$required

	$order

	$unique

	$locked

	$property = array()

	$exportable

	$datatype

	$storage_location_override = null

Detailed Description

Class ilDclBooleanFieldModel.

Author: Michael Herren mh@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Version: 1.0.0

Definition at line 11 of file class.ilDclIliasReferenceFieldModel.php.

Member Function Documentation

◆ getRecordQueryFilterObject()

ilDclIliasReferenceFieldModel::getRecordQueryFilterObject	(		$filter_value = `""`,
		ilDclBaseFieldModel	$sort_field = `null`
	)

Returns a query-object for building the record-loader-sql-query.

Parameters

string $filter_value

Returns: null|ilDclRecordQueryObject

Definition at line 53 of file class.ilDclIliasReferenceFieldModel.php.

References $DIC, $ilDB, and ilDclBaseFieldModel\getId().

                                                                                                                {
                 global $DIC;
                 $ilDB = $DIC['ilDB'];
 
                 $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') . ") ";
                 $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) ";
                 $join_str .= "INNER JOIN object_reference AS filter_object_reference_{$this->getId()} ON (filter_object_reference_{$this->getId()}.ref_id = filter_stloc_{$this->getId()}.value ) ";
                 $join_str .= "INNER JOIN object_data AS filter_object_data_{$this->getId()} ON (filter_object_data_{$this->getId()}.obj_id = filter_object_reference_{$this->getId()}.obj_id AND filter_object_data_{$this->getId()}.title LIKE "
                         . $ilDB->quote("%$filter_value%", 'text') . ") ";
 
                 $sql_obj = new ilDclRecordQueryObject();
                 $sql_obj->setJoinStatement($join_str);
 
                 return $sql_obj;
         }

Here is the call graph for this function:

◆ getRecordQuerySortObject()

ilDclIliasReferenceFieldModel::getRecordQuerySortObject	(	$direction = `"asc"`,
		$sort_by_status = `false`
	)

Returns a query-object for building the record-loader-sql-query.

Returns: null|ilDclRecordQueryObject

Definition at line 18 of file class.ilDclIliasReferenceFieldModel.php.

References $DIC, $ilDB, $ilUser, and ilDclBaseFieldModel\getId().

                                                                                              {
                 global $DIC;
                 $ilDB = $DIC['ilDB'];
 
                 $join_str = "LEFT JOIN il_dcl_record_field AS sort_record_field_{$this->getId()} ON (sort_record_field_{$this->getId()}.record_id = record.id AND sort_record_field_{$this->getId()}.field_id = "
                         . $ilDB->quote($this->getId(), 'integer') . ") ";
                 $join_str .= "LEFT JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS sort_stloc_{$this->getId()} ON (sort_stloc_{$this->getId()}.record_field_id = sort_record_field_{$this->getId()}.id) ";
                 $join_str .= "LEFT JOIN object_reference AS sort_object_reference_{$this->getId()} ON (sort_object_reference_{$this->getId()}.ref_id = sort_stloc_{$this->getId()}.value AND sort_object_reference_{$this->getId()}.deleted IS NULL)";
                 $join_str .= "LEFT JOIN object_data AS sort_object_data_{$this->getId()} ON (sort_object_data_{$this->getId()}.obj_id = sort_object_reference_{$this->getId()}.obj_id)";
 
                 if ($sort_by_status) {
                         global $DIC;
                         $ilUser = $DIC['ilUser'];
                         $join_str .= "LEFT JOIN ut_lp_marks AS ut ON (ut.obj_id = sort_object_data_{$this->getId()}.obj_id AND ut.usr_id = "
                                 . $ilDB->quote($ilUser->getId(), 'integer') . ") ";
                 }
 
                 $select_str = (! $sort_by_status) ? " sort_object_data_{$this->getId()}.title AS field_{$this->getId()}," : " ut.status AS field_{$this->getId()}";
 
                 $sql_obj = new ilDclRecordQueryObject();
                 $sql_obj->setSelectStatement($select_str);
                 $sql_obj->setJoinStatement($join_str);
                 $sql_obj->setOrderStatement("field_{$this->getId()} ".$direction);
 
                 return $sql_obj;
         }

Here is the call graph for this function:

◆ getValidFieldProperties()

ilDclIliasReferenceFieldModel::getValidFieldProperties ( )

Definition at line 73 of file class.ilDclIliasReferenceFieldModel.php.

References array, ilDclBaseFieldModel\PROP_DISPLAY_COPY_LINK_ACTION_MENU, ilDclBaseFieldModel\PROP_ILIAS_REFERENCE_LINK, and ilDclBaseFieldModel\PROP_LEARNING_PROGRESS.

                                                   {
                 return array(ilDclBaseFieldModel::PROP_LEARNING_PROGRESS, ilDclBaseFieldModel::PROP_ILIAS_REFERENCE_LINK, ilDclBaseFieldModel::PROP_DISPLAY_COPY_LINK_ACTION_MENU);
         }

The documentation for this class was generated from the following file:

Modules/DataCollection/classes/Fields/IliasReference/class.ilDclIliasReferenceFieldModel.php

Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ getRecordQueryFilterObject()

◆ getRecordQuerySortObject()

◆ getValidFieldProperties()