Inheritance diagram for ilDclBaseRecordFieldModel:

Collaboration diagram for ilDclBaseRecordFieldModel:

Public Member Functions
	__construct (ilDclBaseRecordModel $record, ilDclBaseFieldModel $field)

	doCreate ()
	Creates an Id and a database entry. More...

	doUpdate ()
	Update object in database. More...

	delete ()
	Delete record field in database. More...

	getValue ()

	getValueForRepresentation ()

	serializeData ($value)
	Serialize data before storing to db. More...

	deserializeData ($value)
	Deserialize data before applying to field. More...

	setValue ($value, $omit_parsing=false)
	Set value for record field. More...

	setValueFromForm ($form)

	parseExportValue ($value)
	Function to parse incoming data from form input value $value. More...

	getValueFromExcel ($excel, $row, $col)

	parseValue ($value)
	Function to parse incoming data from form input value $value. More...

	getExportValue ()

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

	getPlainText ()

	getSortingValue ($link=true)

	addHiddenItemsToConfirmation (ilConfirmationGUI &$confirmation)

	parseSortingValue ($value, $link=true)
	Returns sortable value for the specific field-types. More...

	cloneStructure (ilDclBaseRecordFieldModel $old_record_field)

	afterClone ()

	getField ()

	getId ()

	getRecord ()

	getRecordRepresentation ()

	setRecordRepresentation ($record_representation)

	getFieldRepresentation ()

	setFieldRepresentation ($field_representation)

Protected Member Functions
	doRead ()
	Read object data from database. More...

	loadValue ()
	Load the value. More...

Protected Attributes
	$id

	$field

	$record

	$record_representation

	$field_representation

	$value

	$user

	$ctrl

	$db

	$lng

Detailed Description

Class ilDclBaseFieldModel.

Author: Martin Studer ms@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch; Marcel Raimann mr@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch; Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch; Oskar Truffer ot@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch; Stefan Wanzenried sw@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Version: $Id:

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

Constructor & Destructor Documentation

◆ __construct()

ilDclBaseRecordFieldModel::__construct	(	ilDclBaseRecordModel	$record,
		ilDclBaseFieldModel	$field
	)

Parameters

ilDclBaseRecordModel	$record
ilDclBaseFieldModel	$field

Reimplemented in ilDclFormulaRecordFieldModel, ilDclIliasReferenceRecordFieldModel, ilDclRatingRecordFieldModel, and ilDclReferenceRecordFieldModel.

Definition at line 68 of file class.ilDclBaseRecordFieldModel.php.

                                                                                              {
                global $DIC;
                $ilCtrl = $DIC['ilCtrl'];
                $ilUser = $DIC['ilUser'];
                $ilDB = $DIC['ilDB'];
                $lng = $DIC['lng'];
                $this->record = $record;
                $this->field = $field;
                $this->ctrl = $ilCtrl;
                $this->user = $ilUser;
                $this->db = $ilDB;
                $this->lng = $lng;
                $this->doRead();
        }

References $DIC, $field, $ilCtrl, $ilDB, $ilUser, $lng, $record, doRead(), and user().

Here is the call graph for this function:

Member Function Documentation

◆ addHiddenItemsToConfirmation()

ilDclBaseRecordFieldModel::addHiddenItemsToConfirmation ( ilConfirmationGUI & $confirmation )

Parameters

ilConfirmationGUI $confirmation

Reimplemented in ilDclFileuploadRecordFieldModel, ilDclFormulaRecordFieldModel, ilDclMobRecordFieldModel, ilDclRatingRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 309 of file class.ilDclBaseRecordFieldModel.php.

                                                                                       {;
                if (!is_array($this->getValue())) {
                        $confirmation->addHiddenItem('field_'.$this->field->getId(), $this->getValue());
                } else {
                        foreach ($this->getValue() as $key => $value) {
                                $confirmation->addHiddenItem('field_'.$this->field->getId() . "[$key]", $value);
                        }
                }
        }

References $value, ilConfirmationGUI\addHiddenItem(), and getValue().

Here is the call graph for this function:

◆ afterClone()

ilDclBaseRecordFieldModel::afterClone ( )

Reimplemented in ilDclFileuploadRecordFieldModel, ilDclMobRecordFieldModel, and ilDclReferenceRecordFieldModel.

Definition at line 365 of file class.ilDclBaseRecordFieldModel.php.

                                    {
 
        }

◆ cloneStructure()

ilDclBaseRecordFieldModel::cloneStructure ( ilDclBaseRecordFieldModel $old_record_field )

Parameters

ilDclBaseRecordFieldModel $old_record_field

Definition at line 356 of file class.ilDclBaseRecordFieldModel.php.

                                                                                    {
                $this->setValue($old_record_field->getValue());
                $this->doUpdate();
        }

References doUpdate(), getValue(), and setValue().

Here is the call graph for this function:

◆ delete()

ilDclBaseRecordFieldModel::delete ( )

Delete record field in database.

Reimplemented in ilDclFormulaRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 153 of file class.ilDclBaseRecordFieldModel.php.

                                 {
                $datatype = $this->getField()->getDatatype();
                $storage_location = ($this->getField()->getStorageLocationOverride() !== null)? $this->getField()->getStorageLocationOverride() : $datatype->getStorageLocation();
 
                if($storage_location != 0) {
                        $query = "DELETE FROM il_dcl_stloc" . $storage_location . "_value WHERE record_field_id = "
                                . $this->db->quote($this->id, "integer");
                        $this->db->manipulate($query);
                }
 
                $query2 = "DELETE FROM il_dcl_record_field WHERE id = " . $this->db->quote($this->id, "integer");
                $this->db->manipulate($query2);
        }

References $query, and getField().

Here is the call graph for this function:

◆ deserializeData()

ilDclBaseRecordFieldModel::deserializeData ( $value )

Deserialize data before applying to field.

Parameters

$value mixed

Returns: mixed

Definition at line 205 of file class.ilDclBaseRecordFieldModel.php.

                                                {
                $deserialize = json_decode($value, true);
                if(is_array($deserialize)) {
                        return $deserialize;
                }
                return $value;
        }

References $value.

Referenced by loadValue().

Here is the caller graph for this function:

◆ doCreate()

ilDclBaseRecordFieldModel::doCreate ( )

Creates an Id and a database entry.

Definition at line 104 of file class.ilDclBaseRecordFieldModel.php.

                                   {
                $id = $this->db->nextId("il_dcl_record_field");
                $query = "INSERT INTO il_dcl_record_field (id, record_id, field_id) VALUES (" . $this->db->quote($id, "integer") . ", "
                        . $this->db->quote($this->getRecord()->getId(), "integer") . ", " . $this->db->quote($this->getField()->getId(), "text") . ")";
                $this->db->manipulate($query);
                $this->id = $id;
        }

References $id, $query, getField(), getId(), and getRecord().

Referenced by doUpdate().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ doRead()

ilDclBaseRecordFieldModel::doRead ( )

protected

Read object data from database.

Reimplemented in ilDclFormulaRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 87 of file class.ilDclBaseRecordFieldModel.php.

                                    {
                if(!$this->getRecord()->getId())
                        return;
 
                $query = "SELECT * FROM il_dcl_record_field WHERE field_id = " . $this->db->quote($this->getField()->getId(), "integer") . " AND record_id = "
                        . $this->db->quote($this->getRecord()->getId(), "integer");
                $set = $this->db->query($query);
                $rec = $this->db->fetchAssoc($set);
                $this->id = $rec['id'];
                
                $this->loadValue();
        }

References $query, getField(), getId(), getRecord(), and loadValue().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ doUpdate()

ilDclBaseRecordFieldModel::doUpdate ( )

Update object in database.

Reimplemented in ilDclFormulaRecordFieldModel, ilDclNReferenceRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 116 of file class.ilDclBaseRecordFieldModel.php.

                                   {
                //$this->loadValue(); //Removed Mantis #0011799
                $datatype = $this->getField()->getDatatype();
                $storage_location = ($this->getField()->getStorageLocationOverride() !== null)? $this->getField()->getStorageLocationOverride() : $datatype->getStorageLocation();
 
                if($storage_location != 0) {
                        $query = "DELETE FROM il_dcl_stloc" . $storage_location . "_value WHERE record_field_id = "
                                . $this->db->quote($this->id, "integer");
                        $this->db->manipulate($query);
 
                        $next_id = $this->db->nextId("il_dcl_stloc" . $storage_location . "_value");
 
                        // This is a workaround to ensure that date values in stloc3 are never stored as NULL, which is not allowed
                        if ($storage_location == 3 && (is_null($this->value) || empty($this->value))) {
                                $this->value = '0000-00-00 00:00:00';
                        }
 
                        $value = $this->serializeData($this->value);
 
                        if($this->getId() == 0) {
                                $this->doCreate();
                        }
 
                        $insert_params = array(
                                "value" => array( $datatype->getDbType(), $value),
                                "record_field_id" => array( "integer", $this->getId()),
                                "id" => array( "integer", $next_id )
                        );
 
                        $this->db->insert("il_dcl_stloc" . $storage_location . "_value", $insert_params);
                }
        }

References $query, $value, doCreate(), getField(), getId(), and serializeData().

Referenced by ilDclFileuploadRecordFieldModel\afterClone(), ilDclMobRecordFieldModel\afterClone(), ilDclReferenceRecordFieldModel\afterClone(), and cloneStructure().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ fillExcelExport()

ilDclBaseRecordFieldModel::fillExcelExport	(	ilExcel	$worksheet,
		&	$row,
		&	$col
	)

Parameters

$worksheet
$row
$col

Reimplemented in ilDclTextRecordFieldModel.

Definition at line 289 of file class.ilDclBaseRecordFieldModel.php.

                                                                          {
                $worksheet->setCell($row, $col, $this->getExportValue());
                $col ++;
        }

References $row, $worksheet, and getExportValue().

Here is the call graph for this function:

◆ getExportValue()

ilDclBaseRecordFieldModel::getExportValue ( )

Returns: int|string

Reimplemented in ilDclFormulaRecordFieldModel, ilDclIliasReferenceRecordFieldModel, ilDclNReferenceRecordFieldModel, ilDclRatingRecordFieldModel, ilDclReferenceRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 280 of file class.ilDclBaseRecordFieldModel.php.

                                         {
                return $this->parseExportValue($this->getValue());
        }

References getValue(), and parseExportValue().

Referenced by fillExcelExport(), and getPlainText().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getField()

ilDclBaseRecordFieldModel::getField ( )

Returns: ilDclBaseFieldModel

Definition at line 373 of file class.ilDclBaseRecordFieldModel.php.

                                   {
                return $this->field;
        }

References $field.

Here is the caller graph for this function:

◆ getFieldRepresentation()

ilDclBaseRecordFieldModel::getFieldRepresentation ( )

Returns: ilDclBaseFieldRepresentation

Definition at line 412 of file class.ilDclBaseRecordFieldModel.php.

                                                 {
                return $this->field_representation;
        }

References $field_representation.

◆ getId()

ilDclBaseRecordFieldModel::getId ( )

Returns: int

Definition at line 381 of file class.ilDclBaseRecordFieldModel.php.

                                {
                return $this->id;
        }

References $id.

Referenced by ilDclFileuploadRecordFieldModel\afterClone(), ilDclMobRecordFieldModel\afterClone(), ilDclReferenceRecordFieldModel\afterClone(), ilDclRatingRecordFieldModel\delete(), doCreate(), doRead(), doUpdate(), ilDclNReferenceRecordFieldModel\doUpdate(), ilDclRatingRecordFieldModel\getExportValue(), ilDclCache\getRecordRepresentation(), ilDclFieldFactory\getRecordRepresentationInstance(), ilDclRatingRecordFieldModel\getValue(), ilDclFileuploadRecordFieldModel\parseValue(), ilDclMobRecordFieldModel\parseValue(), setValueFromForm(), ilDclFileuploadRecordFieldModel\setValueFromForm(), ilDclMobRecordFieldModel\setValueFromForm(), and ilDclTextRecordFieldModel\setValueFromForm().

Here is the caller graph for this function:

◆ getPlainText()

ilDclBaseRecordFieldModel::getPlainText ( )

Returns: mixed used for the sorting.

Reimplemented in ilDclTextRecordFieldModel.

Definition at line 297 of file class.ilDclBaseRecordFieldModel.php.

                                       {
                return $this->getExportValue();
        }

References getExportValue().

Here is the call graph for this function:

◆ getRecord()

ilDclBaseRecordFieldModel::getRecord ( )

Returns: ilDclBaseRecordModel

Definition at line 389 of file class.ilDclBaseRecordFieldModel.php.

                                    {
                return $this->record;
        }

References $record.

Referenced by ilDclFileuploadRecordFieldModel\afterClone(), ilDclMobRecordFieldModel\afterClone(), ilDclReferenceRecordFieldModel\afterClone(), doCreate(), doRead(), ilDclRatingRecordFieldModel\getExportValue(), ilDclRatingRecordFieldModel\getValue(), ilDclFormulaRecordFieldModel\parse(), ilDclFileuploadRecordFieldModel\parseValue(), ilDclMobRecordFieldModel\parseValue(), and ilDclFileuploadRecordFieldModel\setValue().

Here is the caller graph for this function:

◆ getRecordRepresentation()

ilDclBaseRecordFieldModel::getRecordRepresentation ( )

Returns: ilDclBaseRecordRepresentation

Definition at line 396 of file class.ilDclBaseRecordFieldModel.php.

                                                  {
                return $this->record_representation;
        }

References $record_representation.

◆ getSortingValue()

ilDclBaseRecordFieldModel::getSortingValue ( $link = true )

Definition at line 301 of file class.ilDclBaseRecordFieldModel.php.

                                                      {
                return $this->parseSortingValue($this->getValue(), $this, $link);
        }

References getValue(), and parseSortingValue().

Here is the call graph for this function:

◆ getValue()

ilDclBaseRecordFieldModel::getValue ( )

Returns: string|array

Reimplemented in ilDclFormulaRecordFieldModel, ilDclNReferenceRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 171 of file class.ilDclBaseRecordFieldModel.php.

                                   {
                $this->loadValue();
 
                return $this->value;
        }

References $value, and loadValue().

Referenced by addHiddenItemsToConfirmation(), ilDclFileuploadRecordFieldModel\addHiddenItemsToConfirmation(), ilDclMobRecordFieldModel\addHiddenItemsToConfirmation(), ilDclTextRecordFieldModel\addHiddenItemsToConfirmation(), cloneStructure(), getExportValue(), ilDclIliasReferenceRecordFieldModel\getExportValue(), ilDclReferenceRecordFieldModel\getExportValue(), ilDclTextRecordFieldModel\getExportValue(), ilDclTextRecordFieldModel\getPlainText(), getSortingValue(), ilDclIliasReferenceRecordFieldModel\getStatus(), getValueForRepresentation(), ilDclIliasReferenceRecordFieldModel\getValueForRepresentation(), ilDclFileuploadRecordFieldModel\parseValue(), and ilDclMobRecordFieldModel\parseValue().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getValueForRepresentation()

ilDclBaseRecordFieldModel::getValueForRepresentation ( )

Returns: array|string

Reimplemented in ilDclIliasReferenceRecordFieldModel.

Definition at line 181 of file class.ilDclBaseRecordFieldModel.php.

                                                    {
                return $this->getValue();
        }

References getValue().

Here is the call graph for this function:

◆ getValueFromExcel()

ilDclBaseRecordFieldModel::getValueFromExcel	(	$excel,
		$row,
		$col
	)

Parameters

$excel
$row
$col

Returns: array|string

Reimplemented in ilDclDatetimeRecordFieldModel, ilDclNReferenceRecordFieldModel, ilDclReferenceRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 259 of file class.ilDclBaseRecordFieldModel.php.

                                                              {
                $value = $excel->getCell($row, $col);
 
                return $value;
        }

References $row, and $value.

◆ loadValue()

ilDclBaseRecordFieldModel::loadValue ( )

protected

Load the value.

Reimplemented in ilDclFormulaRecordFieldModel, ilDclNReferenceRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 335 of file class.ilDclBaseRecordFieldModel.php.

                                       {
                if ($this->value === NULL) {
                        $datatype = $this->getField()->getDatatype();
 
                        $storage_location = ($this->getField()->getStorageLocationOverride() !== null)? $this->getField()->getStorageLocationOverride() : $datatype->getStorageLocation();
                        if($storage_location != 0) {
                                $query = "SELECT * FROM il_dcl_stloc" . $storage_location . "_value WHERE record_field_id = "
                                        . $this->db->quote($this->id, "integer");
 
                                $set = $this->db->query($query);
                                $rec = $this->db->fetchAssoc($set);
                                $value = $this->deserializeData($rec['value']);
                                $this->value = $value;
                        }
                }
        }

References $query, $value, deserializeData(), and getField().

Referenced by doRead(), getValue(), setValue(), and ilDclFileuploadRecordFieldModel\setValue().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parseExportValue()

ilDclBaseRecordFieldModel::parseExportValue ( $value )

Function to parse incoming data from form input value $value.

returns the string/number/etc. to store in the database.

Parameters

mixed $value

Returns: mixed

Reimplemented in ilDclBooleanRecordFieldModel, ilDclDatetimeRecordFieldModel, ilDclFileuploadRecordFieldModel, and ilDclMobRecordFieldModel.

Definition at line 249 of file class.ilDclBaseRecordFieldModel.php.

                                                 {
                return $value;
        }

References $value.

Referenced by getExportValue().

Here is the caller graph for this function:

◆ parseSortingValue()

ilDclBaseRecordFieldModel::parseSortingValue	(	$value,
		$link = `true`
	)

Returns sortable value for the specific field-types.

Parameters

	$value
ilDclBaseRecordFieldModel	$record_field
bool \| true	$link

Returns: int|string

Reimplemented in ilDclDatetimeRecordFieldModel, ilDclFileuploadRecordFieldModel, ilDclMobRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 328 of file class.ilDclBaseRecordFieldModel.php.

                                                                {
                return $value;
        }

References $value.

Referenced by getSortingValue().

Here is the caller graph for this function:

◆ parseValue()

ilDclBaseRecordFieldModel::parseValue ( $value )

Function to parse incoming data from form input value $value.

returns the string/number/etc. to store in the database.

Parameters

$value

Returns: int|string

Reimplemented in ilDclBooleanRecordFieldModel, ilDclDatetimeRecordFieldModel, ilDclFileuploadRecordFieldModel, ilDclMobRecordFieldModel, ilDclNumberRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 272 of file class.ilDclBaseRecordFieldModel.php.

                                           {
                return $value;
        }

References $value.

Referenced by setValue().

Here is the caller graph for this function:

◆ serializeData()

ilDclBaseRecordFieldModel::serializeData ( $value )

Serialize data before storing to db.

Parameters

$value mixed

Returns: mixed

Definition at line 191 of file class.ilDclBaseRecordFieldModel.php.

                                              {
                if(is_array($value)) {
                        $value = json_encode($value);
                }
                return $value;
        }

References $value.

Referenced by doUpdate().

Here is the caller graph for this function:

◆ setFieldRepresentation()

ilDclBaseRecordFieldModel::setFieldRepresentation ( $field_representation )

Parameters

ilDclBaseFieldRepresentation $field_representation

Definition at line 420 of file class.ilDclBaseRecordFieldModel.php.

                                                                      {
                $this->field_representation = $field_representation;
        }

References $field_representation.

◆ setRecordRepresentation()

ilDclBaseRecordFieldModel::setRecordRepresentation ( $record_representation )

Parameters

ilDclBaseRecordRepresentation $record_representation

Definition at line 404 of file class.ilDclBaseRecordFieldModel.php.

                                                                        {
                $this->record_representation = $record_representation;
        }

References $record_representation.

◆ setValue()

ilDclBaseRecordFieldModel::setValue	(	$value,
		$omit_parsing = `false`
	)

Set value for record field.

Parameters

mixed	$value
bool	$omit_parsing	If true, does not parse the value and stores it in the given format

Reimplemented in ilDclFileuploadRecordFieldModel, ilDclFormulaRecordFieldModel, and ilDclRatingRecordFieldModel.

Definition at line 219 of file class.ilDclBaseRecordFieldModel.php.

                                                                {
                $this->loadValue();
                if (! $omit_parsing) {
                        $tmp = $this->parseValue($value, $this);
                        $old = $this->value;
                        //if parse value fails keep the old value
                        if ($tmp !== false) {
                                $this->value = $tmp;
                        }
                } else {
                        $this->value = $value;
                }
        }

References $old, $value, loadValue(), and parseValue().

Referenced by ilDclMobRecordFieldModel\afterClone(), ilDclReferenceRecordFieldModel\afterClone(), ilDclNReferenceFieldGUI\buildTemplate(), cloneStructure(), setValueFromForm(), ilDclMobRecordFieldModel\setValueFromForm(), and ilDclTextRecordFieldModel\setValueFromForm().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setValueFromForm()

ilDclBaseRecordFieldModel::setValueFromForm ( $form )

Parameters

$form ilPropertyFormGUI

Reimplemented in ilDclFileuploadRecordFieldModel, ilDclMobRecordFieldModel, and ilDclTextRecordFieldModel.

Definition at line 236 of file class.ilDclBaseRecordFieldModel.php.

                                                {
                $value = $form->getInput("field_" . $this->getField()->getId());
 
                $this->setValue($value);
        }