Collaboration diagram for ilDataCollectionRecordListViewdefinition:

Public Member Functions
	__construct ($a_table_id)
	Constructor public. More...

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

	getId ()
	Get id. More...

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

	getTableId ()
	Get table ID. More...

	setType ($a_type)
	Set type. More...

	getType ()
	Get type. More...

	setFormType ($a_formtype)
	Set formtype. More...

	getFormType ()
	Get formtype. More...

	setArrFieldOrder ($a_order, $a_key)
	Set field order. More...

	getArrFieldOrder ()
	Get field order. More...

	setTabledefinition ($title, $a_key)
	Set table definition. More...

	getArrTabledefinition ()
	Get table definition. More...

	setRecordfield ($storage_location, $a_key)
	Set record fields. More...

	getArrRecordfield ()
	Get table definition. More...

	doRead ()
	Read. More...

	doCreate ()
	Create. More...

Protected Attributes
	$id

	$table_id

	$type

	$formtype

	$arr_fieldorder

Detailed Description

Class ilDataCollectionField.

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

Version: $Id:

Definition at line 16 of file class.ilDataCollectionRecordListViewdefinition.php.

Constructor & Destructor Documentation

◆ __construct()

ilDataCollectionRecordListViewdefinition::__construct ( $a_table_id )

Constructor public.

Parameters

integer table_id

At the moment we have one view per table. If we will have more than one view, we should work additional with the view_id

Definition at line 34 of file class.ilDataCollectionRecordListViewdefinition.php.

References doRead().

         {
                 $this->type = 1; //Type list
                 $this->formtype = 1; //FieldOrder-Formular
 
                 if($a_table_id != 0)
                 {
                         $this->table_id = $a_table_id;
                         $this->doRead();
                 }
         }

Here is the call graph for this function:

Member Function Documentation

◆ doCreate()

ilDataCollectionRecordListViewdefinition::doCreate ( )

Create.

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

References $id, $ilDB, $query, getArrFieldOrder(), getFormType(), getId(), getTableId(), getType(), and setId().

         {
                 global $ilDB;
 
                 $ilDB->manipulate('DELETE FROM il_dcl_view
                         WHERE table_id = '.$ilDB->quote($this->getTableId(), "integer").' 
                         AND type = '.$ilDB->quote($this->getType(), "integer").' 
                         AND formtype = '.$ilDB->quote($this->getFormType(), "integer"));
 
                 $id = $ilDB->nextId("il_dcl_view");
                 $this->setId($id);
                 $query = "INSERT INTO il_dcl_view (".
                         "id".
                         ", table_id".
                         ", type".
                         ", formtype".
                         " ) VALUES (".
                         $ilDB->quote($this->getId(), "integer")
                         .",".$ilDB->quote($this->getTableId(), "integer")
                         .",".$ilDB->quote($this->getType(), "integer")
                         .",".$ilDB->quote($this->getFormType(), "integer")
                         .")";
                 $ilDB->manipulate($query);
 
                 foreach($this->getArrFieldOrder() as $key => $order) 
                 {
                         $viewdefinitionid = $ilDB->nextId("il_dcl_viewdefinition");
 
                         $query = "INSERT INTO il_dcl_viewdefinition (".
                                 "id".
                                 ", view_id".
                                 ", field".
                                 ", field_order".
                                 " ) VALUES (".
                                 $ilDB->quote($viewdefinitionid, "integer")
                                 .",".$ilDB->quote($this->getId(), "integer")
                                 .",".$ilDB->quote($key, "text")
                                 .",".$ilDB->quote($order, "integer")
                                 .")";
                         $ilDB->manipulate($query);
                 }
         }

Here is the call graph for this function:

◆ doRead()

ilDataCollectionRecordListViewdefinition::doRead ( )

Read.

Definition at line 195 of file class.ilDataCollectionRecordListViewdefinition.php.

References $ilDB, $query, getFormType(), getTableId(), getType(), setArrFieldOrder(), setRecordfield(), and setTabledefinition().

Referenced by __construct().

         {
                 global $ilDB;
 
                 $query = "SELECT        il_dcl_viewdefinition.field field,
                                                                                 il_dcl_viewdefinition.field_order fieldorder,
                                                                                 CASE il_dcl_viewdefinition.field
                                                                                         WHEN il_dcl_field.id THEN  il_dcl_field.title
                                                                                         ELSE il_dcl_viewdefinition.field
                                                                                 END title,
                                                                                 il_dcl_datatype.storage_location storage_location
                                                         FROM il_dcl_view
                                                         LEFT JOIN il_dcl_viewdefinition ON il_dcl_viewdefinition.view_id = il_dcl_view.id 
                                                         LEFT JOIN il_dcl_field ON il_dcl_viewdefinition.field = il_dcl_field.id 
                                                         LEFT JOIN il_dcl_datatype ON  il_dcl_field.datatype_id = il_dcl_datatype.id
                                                         WHERE il_dcl_view.table_id = ".$ilDB->quote($this->getTableId(),"integer")." 
                                                         AND il_dcl_view.type = ".$ilDB->quote($this->getType(),"integer")."
                                                         AND il_dcl_view.formtype = ".$ilDB->quote($this->getFormType(),"integer")."
                                                         ORDER by il_dcl_viewdefinition.field_order";
 
 
                 $set = $ilDB->query($query);
         
                 $all = array();
                 while($rec = $ilDB->fetchAssoc($set))
                 {
                         $this->setArrFieldOrder($rec['fieldorder'], $rec['field']);
 
                         $this->setTabledefinition($rec['title'], $rec['field']);
                         if($rec['storage_location']) 
                         {
                                 $this->setRecordfield($rec['storage_location'],$rec['field']);
                         }
                 }
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getArrFieldOrder()

ilDataCollectionRecordListViewdefinition::getArrFieldOrder ( )

Get field order.

Returns: array

Definition at line 143 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by doCreate().

         {
                 return $this->arrfieldorder;
         }

Here is the caller graph for this function:

◆ getArrRecordfield()

ilDataCollectionRecordListViewdefinition::getArrRecordfield ( )

Get table definition.

Returns: array

Definition at line 187 of file class.ilDataCollectionRecordListViewdefinition.php.

         {
                 return $this->arrrecordfield;
         }

◆ getArrTabledefinition()

ilDataCollectionRecordListViewdefinition::getArrTabledefinition ( )

Get table definition.

Returns: array

Definition at line 165 of file class.ilDataCollectionRecordListViewdefinition.php.

         {
                 return $this->arrtabledefinition;
         }

◆ getFormType()

ilDataCollectionRecordListViewdefinition::getFormType ( )

Get formtype.

Returns: int

Definition at line 121 of file class.ilDataCollectionRecordListViewdefinition.php.

References $formtype.

Referenced by doCreate(), and doRead().

         {
                 return $this->formtype;
         }

Here is the caller graph for this function:

◆ getId()

ilDataCollectionRecordListViewdefinition::getId ( )

Get id.

Returns: int

Definition at line 61 of file class.ilDataCollectionRecordListViewdefinition.php.

References $id.

Referenced by doCreate().

         {
                 return $this->id;
         }

Here is the caller graph for this function:

◆ getTableId()

ilDataCollectionRecordListViewdefinition::getTableId ( )

Get table ID.

Returns: int

Definition at line 81 of file class.ilDataCollectionRecordListViewdefinition.php.

References $table_id.

Referenced by doCreate(), and doRead().

         {
                 return $this->table_id;
         }

Here is the caller graph for this function:

◆ getType()

ilDataCollectionRecordListViewdefinition::getType ( )

Get type.

Returns: int

Definition at line 101 of file class.ilDataCollectionRecordListViewdefinition.php.

References $type.

Referenced by doCreate(), and doRead().

         {
                 return $this->type;
         }

Here is the caller graph for this function:

◆ setArrFieldOrder()

ilDataCollectionRecordListViewdefinition::setArrFieldOrder	(	$a_order,
		$a_key
	)

Set field order.

Parameters

string	$a_order
string	$a_key

Definition at line 133 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by doRead().

         {
                 $this->arrfieldorder[$a_key] = $a_order;
         }

Here is the caller graph for this function:

◆ setFormType()

ilDataCollectionRecordListViewdefinition::setFormType ( $a_formtype )

Set formtype.

Parameters

int $a_formtype

Definition at line 111 of file class.ilDataCollectionRecordListViewdefinition.php.

         {
                 $this->formtype = $a_formtype;
         }

◆ setId()

ilDataCollectionRecordListViewdefinition::setId ( $a_id )

Set id.

Parameters

int $a_id

Definition at line 51 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by doCreate().

         {
                 $this->id = $a_id;
         }

Here is the caller graph for this function:

◆ setRecordfield()

ilDataCollectionRecordListViewdefinition::setRecordfield	(	$storage_location,
		$a_key
	)

Set record fields.

Parameters

string	$storage_location
string	$a_key

Definition at line 176 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by doRead().

         {
                 $this->arrrecordfield[$a_key]['id'] = $a_key;
                 $this->arrrecordfield[$a_key]['storage_location'] = $storage_location;
         }

Here is the caller graph for this function:

◆ setTabledefinition()

ilDataCollectionRecordListViewdefinition::setTabledefinition	(	$title,
		$a_key
	)

Set table definition.

Parameters

string	$title
string	$a_key

Definition at line 155 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by doRead().

         {
                 $this->arrtabledefinition[$a_key]['title'] = $title;
         }

Here is the caller graph for this function:

◆ setTableId()

ilDataCollectionRecordListViewdefinition::setTableId ( $a_id )

Set table ID.

Parameters

int $a_id

Definition at line 71 of file class.ilDataCollectionRecordListViewdefinition.php.

         {
                 $this->table_id = $a_id;
         }

◆ setType()

ilDataCollectionRecordListViewdefinition::setType ( $a_type )

Set type.

Parameters

int $a_type

Definition at line 91 of file class.ilDataCollectionRecordListViewdefinition.php.

         {
                 $this->type = $a_type;
         }

Field Documentation

◆ $arr_fieldorder

ilDataCollectionRecordListViewdefinition::$arr_fieldorder

protected

Definition at line 23 of file class.ilDataCollectionRecordListViewdefinition.php.

◆ $formtype

ilDataCollectionRecordListViewdefinition::$formtype

protected

Definition at line 21 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by getFormType().

◆ $id

ilDataCollectionRecordListViewdefinition::$id

protected

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

Referenced by doCreate(), and getId().

◆ $table_id

ilDataCollectionRecordListViewdefinition::$table_id

protected

Definition at line 19 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by getTableId().

◆ $type

ilDataCollectionRecordListViewdefinition::$type

protected

Definition at line 20 of file class.ilDataCollectionRecordListViewdefinition.php.

Referenced by getType().

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

Modules/DataCollection/classes/class.ilDataCollectionRecordListViewdefinition.php

Public Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ doCreate()

◆ doRead()

◆ getArrFieldOrder()

◆ getArrRecordfield()

◆ getArrTabledefinition()

◆ getFormType()

◆ getId()

◆ getTableId()

◆ getType()

◆ setArrFieldOrder()

◆ setFormType()

◆ setId()

◆ setRecordfield()

◆ setTabledefinition()

◆ setTableId()

◆ setType()

Field Documentation

◆ $arr_fieldorder

◆ $formtype

◆ $id

◆ $table_id

◆ $type