Collaboration diagram for ilDataCollectionRecordListViewdefinition:

Public Member Functions
	__construct ($a_table_id)
	Constructor @access 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 @access 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.

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

References 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.

        {
                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);
                }
        }

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

Here is the call graph for this function:

◆ doRead()

ilDataCollectionRecordListViewdefinition::doRead ( )

Read.

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

        {
                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']);
                        }
                }
        }

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

Referenced by __construct().

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.

        {
                return $this->arrfieldorder;
        }

Referenced by doCreate().

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.

        {
                return $this->formtype;
        }

References $formtype.

Referenced by doCreate(), and doRead().

Here is the caller graph for this function:

◆ getId()

ilDataCollectionRecordListViewdefinition::getId ( )

Get id.

Returns: int

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

        {
                return $this->id;
        }

References $id.

Referenced by doCreate().

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.

        {
                return $this->table_id;
        }

References $table_id.

Referenced by doCreate(), and doRead().

Here is the caller graph for this function:

◆ getType()

ilDataCollectionRecordListViewdefinition::getType ( )

Get type.

Returns: int

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

        {
                return $this->type;
        }

References $type.

Referenced by doCreate(), and doRead().

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.

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

Referenced by doRead().

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.

        {
                $this->id = $a_id;
        }

Referenced by doCreate().

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.

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

Referenced by doRead().

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.

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

Referenced by doRead().

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