ilDataCollectionTable Class Reference

Class ilDataCollectionField. More...

Collaboration diagram for ilDataCollectionTable:

Public Member Functions
	__construct ($a_id=0)
	doRead ()
	Read table. More...
	doCreate ($create_views=true)
	doUpdate ()
	setId ($a_id)
	Set table id. More...
	getId ()
	Get table id. More...
	setObjId ($a_id)
	getObjId ()
	setTitle ($a_title)
	getTitle ()
	getCollectionObject ()
	getRecords ()
	getRecordsByFilter (array $filter=array())
	getRecordsByFilter More...
	getAll ($a_id)
	deleteField ($field_id)
	getField ($field_id)
	getFieldIds ()
	getNewOrder ()
	getNewOrder More...
	getFields ()
	Returns all fields of this table including the standard fields. More...
	getRecordFields ()
	Returns all fields of this table which are NOT standard fields. More...
	getVisibleFields ()
	Returns all fields of this table who have set their visibility to true, including standard fields. More...
	getEditableFields ()
	getFilterableFields ()
	getFilterableFields Returns all fields of this table who have set their filterable to true, including standard fields. More...
	getExportableFields ()
	Return all the fields that are marked as exportable. More...
	hasPermissionToFields ($ref_id)
	hasPermissionToAddTable ($ref_id)
	hasPermissionToAddRecord ($ref_id)
	hasPermissionToEditRecord ($ref_id, ilDataCollectionRecord $record)
	hasPermissionToDeleteRecord ($ref_id, ilDataCollectionRecord $record)
	hasPermissionToDeleteRecords ($ref_id)
	updateFields ()
	Update fields. More...
	sortFields (&$fields)
	sortFields More...
	buildOrderFields ()
	buildOrderFields orders the fields. More...
	getFieldByTitle ($title)
	Get a field by title. More...
	setAddPerm ($add_perm)
	getAddPerm ()
	setDeletePerm ($delete_perm)
	getDeletePerm ()
	setEditByOwner ($edit_by_owner)
	getEditByOwner ()
	getDeleteByOwner ()
	setDeleteByOwner ($delete_by_owner)
	setEditPerm ($edit_perm)
	getEditPerm ()
	setLimited ($limited)
	getLimited ()
	setLimitEnd ($limit_end)
	getLimitEnd ()
	setLimitStart ($limit_start)
	getLimitStart ()
	setIsVisible ($is_visible)
	getIsVisible ()
	setDescription ($description)
	getDescription ()
	setDefaultSortField ($default_sort_field)
	/** More...
	getDefaultSortField ()
	setDefaultSortFieldOrder ($default_sort_field_order)
	getDefaultSortFieldOrder ()
	setPublicCommentsEnabled ($public_comments)
	getPublicCommentsEnabled ()
	setViewOwnRecordsPerm ($view_own_perm)
	getViewOwnRecordsPerm ()
	hasCustomFields ()
	hasCustomFields More...
	compareOrder ($a, $b)
	cloneStructure (ilDataCollectionTable $original)
	_hasRecords ()
	_hasRecords More...
	addField ($field)
	setExportEnabled ($export_enabled)
	getExportEnabled ()
	getPartialRecords ($sort, $direction, $limit, $offset, array $filter=array())
	Return only the needed subset of record objects for the table, according to sorting, paging and filters. More...

Static Public Member Functions
static	_tableExists ($table_id)
static	_getTableIdByTitle ($title, $obj_id)
static	_hasFieldByTitle ($title, $obj_id)
	Checks if a table has a field with the given title. More...

Protected Member Functions
	loadObj ()
	loadRecords ()
	loadFields ()
	doesRecordBelongToUser (ilDataCollectionRecord $record)
	checkLimit ()
	sortByOrder (&$array)

Protected Attributes
	$id = 0
	$objId
	$obj
	$title
	$fields
	$stdFields
	$records
	$is_visible
	$add_perm
	$edit_perm
	$delete_perm
	$edit_by_owner
	$delete_by_owner
	$limited
	$limit_start
	$limit_end
	$export_enabled
	$default_sort_field = 0
	$default_sort_field_order = 'asc'
	$description = ''
	$public_comments = 0
	$view_own_records_perm = 0

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

Stefan Wanzenried sw@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Version

$Id:

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

Constructor & Destructor Documentation

__construct()

ilDataCollectionTable::__construct

(

$a_id = 0

)

Parameters

int

$a_id

Definition at line 125 of file class.ilDataCollectionTable.php.

                                               {
                if ($a_id != 0) {
                        $this->id = $a_id;
                        $this->doRead();
                }
        }

References doRead().

Here is the call graph for this function:

Member Function Documentation

_getTableIdByTitle()

static ilDataCollectionTable::_getTableIdByTitle (   $title,   $obj_id  )

static

Parameters

$title	Title of table
$obj_id	DataCollection object ID where the table belongs to

Returns

int

Definition at line 1290 of file class.ilDataCollectionTable.php.

                                                                   {
                global $ilDB;
                $result = $ilDB->query('SELECT id FROM il_dcl_table WHERE title = ' . $ilDB->quote($title, 'text') . ' AND obj_id = '
                        . $ilDB->quote($obj_id, 'integer'));
                $id = 0;
                while ($rec = $ilDB->fetchAssoc($result)) {
                        $id = $rec['id'];
                }
 
                return $id;
        }

References $id, $ilDB, $result, and $title.

Referenced by ilObjDataCollection\cloneStructure().

Here is the caller graph for this function:

_hasFieldByTitle()

static ilDataCollectionTable::_hasFieldByTitle (   $title,   $obj_id  )

static

Checks if a table has a field with the given title.

Parameters

$title	Title of field
$obj_id	Obj-ID of the table

Returns

bool

Definition at line 1327 of file class.ilDataCollectionTable.php.

                                                                 {
                global $ilDB;
                $result = $ilDB->query('SELECT * FROM il_dcl_field WHERE table_id = ' . $ilDB->quote($obj_id, 'integer') . ' AND title = '
                        . $ilDB->quote($title, 'text'));
 
                return ($ilDB->numRows($result)) ? true : false;
        }

References $ilDB, $result, and $title.

Referenced by ilDataCollectionFieldEditGUI\checkInput().

Here is the caller graph for this function:

_hasRecords()

ilDataCollectionTable::_hasRecords

(

)

_hasRecords

Returns

boolean

Definition at line 1257 of file class.ilDataCollectionTable.php.

                                      {
                return (count($this->getRecords()) > 0) ? true : false;
        }

References getRecords().

Here is the call graph for this function:

_tableExists()

static ilDataCollectionTable::_tableExists (   $table_id )

static

Parameters

$table_id

int

Returns

bool returns true iff there exists a table with id $table_id

Definition at line 1275 of file class.ilDataCollectionTable.php.

                                                       {
                global $ilDB;
                $query = "SELECT * FROM il_dcl_table WHERE id = " . $table_id;
                $result = $ilDB->query($query);
 
                return $result->numRows() != 0;
        }

References $ilDB, $query, and $result.

Referenced by ilDataCollectionField\doCreate(), and ilDataCollectionRecord\doCreate().

Here is the caller graph for this function:

addField()

ilDataCollectionTable::addField

(

$field

)

Parameters

$field

ilDataCollectionField add an already created field for eg. ordering.

Definition at line 1265 of file class.ilDataCollectionTable.php.

                                         {
                $this->fields[$field->getId()] = $field;
        }

References fields.

buildOrderFields()

ilDataCollectionTable::buildOrderFields

(

)

buildOrderFields orders the fields.

Definition at line 875 of file class.ilDataCollectionTable.php.

                                           {
                $fields = $this->getFields();
                $this->sortByOrder($fields);
                $count = 10;
                $offset = 10;
                foreach ($fields as $field) {
                        if (! is_null($field->getOrder())) {
                                $field->setOrder($count);
                                $count = $count + $offset;
                                $field->doUpdate();
                        }
                }
        }

References $fields, getFields(), and sortByOrder().

Referenced by doCreate().

Here is the call graph for this function:

Here is the caller graph for this function:

checkLimit()

ilDataCollectionTable::checkLimit ( )

protected

Returns

bool

Definition at line 823 of file class.ilDataCollectionTable.php.

                                        {
                if ($this->getLimited()) {
                        $now = new ilDateTime(date("Y-m-d H:i:s"), IL_CAL_DATE);
                        $from = new ilDateTime($this->getLimitStart(), IL_CAL_DATE);
                        $to = new ilDateTime($this->getLimitEnd(), IL_CAL_DATE);
                        return ($from <= $now && $now <= $to);
                }
 
                return true;
        }

References getLimited(), getLimitEnd(), getLimitStart(), and IL_CAL_DATE.

Referenced by hasPermissionToAddRecord(), hasPermissionToDeleteRecord(), and hasPermissionToEditRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

cloneStructure()

ilDataCollectionTable::cloneStructure

(

ilDataCollectionTable

$original

)

Parameters

ilDataCollectionTable

$original

Definition at line 1185 of file class.ilDataCollectionTable.php.

                                                                        {
                $this->setTitle($original->getTitle());
                $this->setDescription($original->getDescription());
                $this->setIsVisible($original->getIsVisible());
                $this->setEditByOwner($original->getEditByOwner());
                $this->setAddPerm($original->getAddPerm());
                $this->setEditPerm($original->getEditPerm());
                $this->setDeleteByOwner($original->getDeleteByOwner());
                $this->setDeletePerm($original->getDeletePerm());
                $this->setLimited($original->getLimited());
                $this->setLimitStart($original->getLimitStart());
                $this->setLimitEnd($original->getLimitEnd());
                $this->setViewOwnRecordsPerm($original->getViewOwnRecordsPerm());
                $this->setExportEnabled($original->getExportEnabled());
                $this->setPublicCommentsEnabled($original->getPublicCommentsEnabled());
                $this->setDefaultSortFieldOrder($original->getDefaultSortFieldOrder());
 
                $this->doCreate();
                // reset stdFields to get new for the created object
 
                $default_sort_field = 0;
                // Clone standard-fields
                $org_std_fields = $original->getStandardFields();
                foreach ($this->getStandardFields() as $element_key => $std_field) {
                        $std_field->cloneStructure($org_std_fields[$element_key]);
                        if ($std_field->getId() === $original->getDefaultSortField()) {
                                $default_sort_field = $std_field->getId();
                        }
                }
 
                // Clone fields
                $new_fields = array();
                foreach ($original->getFields() as $orig_field) {
                        if (! $orig_field->isStandardField()) {
                                $new_field = new ilDataCollectionField();
                                $new_field->setTableId($this->getId());
                                $new_field->cloneStructure($orig_field->getId());
                                $new_fields[$orig_field->getId()] = $new_field;
 
                                if ($orig_field->getId() == $original->getDefaultSortField()) {
                                        $default_sort_field = $new_field->getId();
                                }
                        }
                }
 
                $this->setDefaultSortField($default_sort_field);
                $this->doUpdate();
 
                //TODO: Find better way to copy data (include referenced data)
                // Clone Records with recordfields
                /*foreach($original->getRecords() as $orig_record){
                        $new_record = new ilDataCollectionRecord();
                        $new_record->setTableId($this->getId());
                        $new_record->cloneStructure($orig_record->getId(), $new_fields);
                }*/
 
                if ($old_view_id = ilDataCollectionRecordViewViewdefinition::getIdByTableId($original->getId())) {
                        $old_view = new ilDataCollectionRecordViewViewdefinition($old_view_id);
                        $old_view->setTableId($original->getId());
                        $viewdef = new ilDataCollectionRecordViewViewdefinition();
                        $viewdef->setTableId($this->id);
                        $viewdef->setXMLContent($old_view->getXMLContent(false));
                        $viewdef->create();
                }
        }

References $default_sort_field, cloneStructure(), doCreate(), doUpdate(), getAddPerm(), getDefaultSortField(), getDefaultSortFieldOrder(), getDeleteByOwner(), getDeletePerm(), getDescription(), getEditByOwner(), getEditPerm(), getExportEnabled(), getFields(), getId(), ilDataCollectionRecordViewViewdefinition\getIdByTableId(), getIsVisible(), getLimited(), getLimitEnd(), getLimitStart(), getPublicCommentsEnabled(), getTitle(), getViewOwnRecordsPerm(), setAddPerm(), setDefaultSortField(), setDefaultSortFieldOrder(), setDeleteByOwner(), setDeletePerm(), setDescription(), setEditByOwner(), setEditPerm(), setExportEnabled(), setIsVisible(), setLimited(), setLimitEnd(), setLimitStart(), setPublicCommentsEnabled(), setTitle(), and setViewOwnRecordsPerm().

Referenced by cloneStructure().

Here is the call graph for this function:

Here is the caller graph for this function:

compareOrder()

ilDataCollectionTable::compareOrder	(		$a,
			$b
	)

Definition at line 1167 of file class.ilDataCollectionTable.php.

                                      {
                if (is_null($a->getOrder() == NULL) && is_null($b->getOrder() == NULL)) {
                        return 0;
                }
                if (is_null($a->getOrder())) {
                        return 1;
                }
                if (is_null($b->getOrder())) {
                        return - 1;
                }
 
                return $a->getOrder() < $b->getOrder() ? - 1 : 1;
        }

deleteField()

ilDataCollectionTable::deleteField

(

$field_id

)

Parameters

$field_id

Definition at line 445 of file class.ilDataCollectionTable.php.

                                               {
                $field = ilDataCollectionCache::getFieldCache($field_id);
                $records = $this->getRecords();
 
                foreach ($records as $record) {
                        $record->deleteField($field_id);
                }
 
                $field->doDelete();
        }

References $records, ilDataCollectionCache\getFieldCache(), and getRecords().

Here is the call graph for this function:

doCreate()

ilDataCollectionTable::doCreate

(

$create_views = true

)

Parameters

bool

$create_views

Definition at line 213 of file class.ilDataCollectionTable.php.

                                                       {
                global $ilDB;
 
                $id = $ilDB->nextId("il_dcl_table");
                $this->setId($id);
                $query = "INSERT INTO il_dcl_table (" . "id" . ", obj_id" . ", title" . ", add_perm" . ", edit_perm" . ", delete_perm" . ", edit_by_owner"
                        . ", limited" . ", limit_start" . ", limit_end" . ", is_visible" . ", export_enabled" . ", default_sort_field_id"
                        . ", default_sort_field_order" . ", description" . ", public_comments" . ", view_own_records_perm" . ", delete_by_owner ) VALUES ("
                        . $ilDB->quote($this->getId(), "integer") . "," . $ilDB->quote($this->getObjId(), "integer") . ","
                        . $ilDB->quote($this->getTitle(), "text") . "," . $ilDB->quote($this->getAddPerm() ? 1 : 0, "integer") . ","
                        . $ilDB->quote($this->getEditPerm() ? 1 : 0, "integer") . "," . $ilDB->quote($this->getDeletePerm() ? 1 : 0, "integer") . ","
                        . $ilDB->quote($this->getEditByOwner() ? 1 : 0, "integer") . "," . $ilDB->quote($this->getLimited() ? 1 : 0, "integer") . ","
                        . $ilDB->quote($this->getLimitStart(), "timestamp") . "," . $ilDB->quote($this->getLimitEnd(), "timestamp") . ","
                        . $ilDB->quote($this->getIsVisible() ? 1 : 0, "integer") . "," . $ilDB->quote($this->getExportEnabled() ? 1 : 0, "integer") . ","
                        . $ilDB->quote($this->getDefaultSortField(), "text") . "," . $ilDB->quote($this->getDefaultSortFieldOrder(), "text") . ","
                        . $ilDB->quote($this->getDescription(), "text") . "," . $ilDB->quote($this->getPublicCommentsEnabled(), "integer") . ","
                        . $ilDB->quote($this->getViewOwnRecordsPerm(), "integer") . "," . $ilDB->quote($this->getDeleteByOwner() ? 1 : 0, 'integer') . ")";
 
                $ilDB->manipulate($query);
 
                if ($create_views) {
                        //add view definition
                        $view_id = $ilDB->nextId("il_dcl_view");
                        $query = "INSERT INTO il_dcl_view (id, table_id, type, formtype) VALUES (" . $ilDB->quote($view_id, "integer") . ", "
                                . $ilDB->quote($this->id, "integer") . ", " . $ilDB->quote(ilDataCollectionField::VIEW_VIEW, "integer") . ", "
                                . $ilDB->quote(1, "integer") . ")";
                        $ilDB->manipulate($query);
 
                        //add edit definition
                        $view_id = $ilDB->nextId("il_dcl_view");
                        $query = "INSERT INTO il_dcl_view (id, table_id, type, formtype) VALUES (" . $ilDB->quote($view_id, "integer") . ", "
                                . $ilDB->quote($this->id, "integer") . ", " . $ilDB->quote(ilDataCollectionField::EDIT_VIEW, "integer") . ", "
                                . $ilDB->quote(1, "integer") . ")";
                        $ilDB->manipulate($query);
 
                        //add filter definition
                        $view_id = $ilDB->nextId("il_dcl_view");
                        $query = "INSERT INTO il_dcl_view (id, table_id, type, formtype) VALUES (" . $ilDB->quote($view_id, "integer") . ", "
                                . $ilDB->quote($this->id, "integer") . ", " . $ilDB->quote(ilDataCollectionField::FILTER_VIEW, "integer") . ", "
                                . $ilDB->quote(1, "integer") . ")";
                        $ilDB->manipulate($query);
 
                        //add filter definition
                        $view_id = $ilDB->nextId("il_dcl_view");
                        $query = "INSERT INTO il_dcl_view (id, table_id, type, formtype) VALUES (" . $ilDB->quote($view_id, "integer") . ", "
                                . $ilDB->quote($this->id, "integer") . ", " . $ilDB->quote(ilDataCollectionField::EXPORTABLE_VIEW, "integer") . ", "
                                . $ilDB->quote(1, "integer") . ")";
                        $ilDB->manipulate($query);
 
                        $this->buildOrderFields();
                }
        }

References $id, $ilDB, $query, buildOrderFields(), ilDataCollectionField\EDIT_VIEW, ilDataCollectionField\EXPORTABLE_VIEW, ilDataCollectionField\FILTER_VIEW, getAddPerm(), getDefaultSortField(), getDefaultSortFieldOrder(), getDeleteByOwner(), getDeletePerm(), getDescription(), getEditByOwner(), getEditPerm(), getExportEnabled(), getId(), getIsVisible(), getLimited(), getLimitEnd(), getLimitStart(), getObjId(), getPublicCommentsEnabled(), getTitle(), getViewOwnRecordsPerm(), setId(), and ilDataCollectionField\VIEW_VIEW.

Referenced by cloneStructure().

Here is the call graph for this function:

Here is the caller graph for this function:

doesRecordBelongToUser()

ilDataCollectionTable::doesRecordBelongToUser ( ilDataCollectionRecord  $record )

protected

Parameters

ilDataCollectionRecord

$record

Returns

bool

Definition at line 813 of file class.ilDataCollectionTable.php.

                                                                                  {
                global $ilUser;
 
                return ($ilUser->getId() == $record->getOwner());
        }

References $ilUser, and ilDataCollectionRecord\getOwner().

Referenced by hasPermissionToDeleteRecord(), and hasPermissionToEditRecord().

Here is the call graph for this function:

Here is the caller graph for this function:

doRead()

ilDataCollectionTable::doRead

(

)

Read table.

Definition at line 136 of file class.ilDataCollectionTable.php.

                                 {
                global $ilDB;
 
                $query = "SELECT * FROM il_dcl_table WHERE id = " . $ilDB->quote($this->getId(), "integer");
                $set = $ilDB->query($query);
                $rec = $ilDB->fetchAssoc($set);
 
                $this->setObjId($rec["obj_id"]);
                $this->setTitle($rec["title"]);
                $this->setAddPerm($rec["add_perm"]);
                $this->setEditPerm($rec["edit_perm"]);
                $this->setDeletePerm($rec["delete_perm"]);
                $this->setEditByOwner($rec["edit_by_owner"]);
                $this->setExportEnabled($rec["export_enabled"]);
                $this->setLimited($rec["limited"]);
                $this->setLimitStart($rec["limit_start"]);
                $this->setLimitEnd($rec["limit_end"]);
                $this->setIsVisible($rec["is_visible"]);
                $this->setDescription($rec['description']);
                $this->setDefaultSortField($rec['default_sort_field_id']);
                $this->setDefaultSortFieldOrder($rec['default_sort_field_order']);
                $this->setPublicCommentsEnabled($rec['public_comments']);
                $this->setViewOwnRecordsPerm($rec['view_own_records_perm']);
                $this->setDeleteByOwner($rec['delete_by_owner']);
        }

References $ilDB, $query, getId(), setAddPerm(), setDefaultSortField(), setDefaultSortFieldOrder(), setDeleteByOwner(), setDeletePerm(), setDescription(), setEditByOwner(), setEditPerm(), setExportEnabled(), setIsVisible(), setLimited(), setLimitEnd(), setLimitStart(), setObjId(), setPublicCommentsEnabled(), setTitle(), and setViewOwnRecordsPerm().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

doUpdate()

ilDataCollectionTable::doUpdate

(

)

Definition at line 270 of file class.ilDataCollectionTable.php.

                                   {
                global $ilDB;
 
                $ilDB->update("il_dcl_table", array(
                        "obj_id" => array( "integer", $this->getObjId() ),
                        "title" => array( "text", $this->getTitle() ),
                        "add_perm" => array( "integer", (int) $this->getAddPerm() ),
                        "edit_perm" => array( "integer", (int) $this->getEditPerm() ),
                        "delete_perm" => array( "integer", (int) $this->getDeletePerm() ),
                        "edit_by_owner" => array( "integer", (int) $this->getEditByOwner() ),
                        "limited" => array( "integer", $this->getLimited() ),
                        "limit_start" => array( "timestamp", $this->getLimitStart() ),
                        "limit_end" => array( "timestamp", $this->getLimitEnd() ),
                        "is_visible" => array( "integer", $this->getIsVisible() ? 1 : 0 ),
                        "export_enabled" => array( "integer", $this->getExportEnabled() ? 1 : 0 ),
                        "description" => array( "text", $this->getDescription() ),
                        "default_sort_field_id" => array( "text", $this->getDefaultSortField() ),
                        "default_sort_field_order" => array( "text", $this->getDefaultSortFieldOrder() ),
                        "public_comments" => array( "integer", $this->getPublicCommentsEnabled() ? 1 : 0 ),
                        "view_own_records_perm" => array( "integer", $this->getViewOwnRecordsPerm() ),
                        'delete_by_owner' => array('integer', $this->getDeleteByOwner() ? 1 : 0),
                ), array(
                        "id" => array( "integer", $this->getId() )
                ));
        }

References $ilDB, getAddPerm(), getDefaultSortField(), getDefaultSortFieldOrder(), getDeleteByOwner(), getDeletePerm(), getDescription(), getEditByOwner(), getEditPerm(), getExportEnabled(), getId(), getIsVisible(), getLimited(), getLimitEnd(), getLimitStart(), getObjId(), getPublicCommentsEnabled(), getTitle(), and getViewOwnRecordsPerm().

Referenced by cloneStructure().

Here is the call graph for this function:

Here is the caller graph for this function:

getAddPerm()

ilDataCollectionTable::getAddPerm

(

)

Returns

boolean

Definition at line 921 of file class.ilDataCollectionTable.php.

                                     {
                return (bool) $this->add_perm;
        }

References $add_perm.

Referenced by cloneStructure(), doCreate(), doUpdate(), and hasPermissionToAddRecord().

Here is the caller graph for this function:

getAll()

ilDataCollectionTable::getAll

(

$a_id

)

Parameters

$a_id

Returns

array

Definition at line 426 of file class.ilDataCollectionTable.php.

                                      {
                global $ilDB;
 
                // build query
                $query = "SELECT * FROM il_dcl_table WHERE obj_id = " . $ilDB->quote($a_id, "integer");
                $set = $ilDB->query($query);
 
                $all = array();
                while ($rec = $ilDB->fetchAssoc($set)) {
                        $all[$rec['id']] = $rec;
                }
 
                return $all;
        }

References $ilDB, and $query.

Referenced by ilDataCollectionRecordListViewdefinitionGUI\initForm().

Here is the caller graph for this function:

getCollectionObject()

ilDataCollectionTable::getCollectionObject

(

)

Returns

ilObjDataCollection

Definition at line 352 of file class.ilDataCollectionTable.php.

                                              {
                $this->loadObj();
 
                return $this->obj;
        }

References $obj, and loadObj().

Here is the call graph for this function:

getDefaultSortField()

ilDataCollectionTable::getDefaultSortField

(

)

Returns

string

Definition at line 1099 of file class.ilDataCollectionTable.php.

                                              {
                return $this->default_sort_field;
        }

References $default_sort_field.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getDefaultSortFieldOrder()

ilDataCollectionTable::getDefaultSortFieldOrder

(

)

Returns

string

Definition at line 1118 of file class.ilDataCollectionTable.php.

                                                   {
                return $this->default_sort_field_order;
        }

References $default_sort_field_order.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getDeleteByOwner()

ilDataCollectionTable::getDeleteByOwner

(

)

Returns

boolean

Definition at line 968 of file class.ilDataCollectionTable.php.

        {
                return (bool) $this->delete_by_owner;
        }

References $delete_by_owner.

Referenced by cloneStructure(), doCreate(), doUpdate(), and hasPermissionToDeleteRecord().

Here is the caller graph for this function:

getDeletePerm()

ilDataCollectionTable::getDeletePerm

(

)

Returns

boolean

Definition at line 940 of file class.ilDataCollectionTable.php.

                                        {
 
                return (bool) $this->delete_perm;
        }

References $delete_perm.

Referenced by cloneStructure(), doCreate(), doUpdate(), hasPermissionToDeleteRecord(), and hasPermissionToDeleteRecords().

Here is the caller graph for this function:

getDescription()

ilDataCollectionTable::getDescription

(

)

Returns

string

Definition at line 1080 of file class.ilDataCollectionTable.php.

                                         {
                return $this->description;
        }

References $description.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getEditableFields()

ilDataCollectionTable::getEditableFields

(

)

Returns

array

Definition at line 629 of file class.ilDataCollectionTable.php.

                                            {
                $fields = $this->getRecordFields();
                $editableFields = array();
 
                foreach ($fields as $field) {
                        if (! $field->getLocked()) {
                                $editableFields[] = $field;
                        }
                }
 
                return $editableFields;
        }

References $fields, and getRecordFields().

Here is the call graph for this function:

getEditByOwner()

ilDataCollectionTable::getEditByOwner

(

)

Returns

boolean

Definition at line 960 of file class.ilDataCollectionTable.php.

                                         {
                return (bool) $this->edit_by_owner;
        }

References $edit_by_owner.

Referenced by cloneStructure(), doCreate(), doUpdate(), and hasPermissionToEditRecord().

Here is the caller graph for this function:

getEditPerm()

ilDataCollectionTable::getEditPerm

(

)

Returns

boolean

Definition at line 1000 of file class.ilDataCollectionTable.php.

                                      {
                return (bool) $this->edit_perm;
        }

References $edit_perm.

Referenced by cloneStructure(), doCreate(), doUpdate(), and hasPermissionToEditRecord().

Here is the caller graph for this function:

getExportableFields()

ilDataCollectionTable::getExportableFields

(

)

Return all the fields that are marked as exportable.

Returns

array ilDataCollectionField

Definition at line 668 of file class.ilDataCollectionTable.php.

                                              {
                $fields = $this->getFields();
                $exportableFields = array();
                foreach ($fields as $field) {
                        if ($field->getExportable()) {
                                $exportableFields[] = $field;
                        }
                }
 
                return $exportableFields;
        }

References $fields, and getFields().

Here is the call graph for this function:

getExportEnabled()

ilDataCollectionTable::getExportEnabled

(

)

Returns

boolean

Definition at line 1314 of file class.ilDataCollectionTable.php.

                                           {
                return $this->export_enabled;
        }

References $export_enabled.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getField()

ilDataCollectionTable::getField

(

$field_id

)

Parameters

$field_id

Returns

ilDataCollectionField|null

Definition at line 462 of file class.ilDataCollectionTable.php.

                                            {
                $fields = $this->getFields();
                $field = NULL;
                foreach ($fields as $field_1) {
                        if ($field_1->getId() == $field_id) {
                                $field = $field_1;
                        }
                }
 
                return $field;
        }

References $fields, and getFields().

Referenced by getPartialRecords().

Here is the call graph for this function:

Here is the caller graph for this function:

getFieldByTitle()

ilDataCollectionTable::getFieldByTitle

(

$title

)

Get a field by title.

Parameters

$title

Returns

ilDataCollectionField

Definition at line 897 of file class.ilDataCollectionTable.php.

                                                {
                $return = NULL;
                foreach ($this->getFields() as $field) {
                        if ($field->getTitle() == $title) {
                                $return = $field;
                                break;
                        }
                }
 
                return $return;
        }

References $title, and getFields().

Referenced by getPartialRecords().

Here is the call graph for this function:

Here is the caller graph for this function:

getFieldIds()

ilDataCollectionTable::getFieldIds

(

)

Returns

array

Definition at line 478 of file class.ilDataCollectionTable.php.

                                      {
                return array_keys($this->getFields());
        }

References getFields().

Here is the call graph for this function:

getFields()

ilDataCollectionTable::getFields

(

)

Returns all fields of this table including the standard fields.

Returns

ilDataCollectionField[]

Definition at line 528 of file class.ilDataCollectionTable.php.

                                    {
                $this->loadFields();
                $this->stdFields = $this->getStandardFields();
                $fields = array_merge($this->fields, $this->stdFields);
                $this->sortByOrder($fields);
 
                return $fields;
        }

References $fields, fields, loadFields(), and sortByOrder().

Referenced by buildOrderFields(), cloneStructure(), getExportableFields(), getField(), getFieldByTitle(), getFieldIds(), getFilterableFields(), getNewOrder(), getVisibleFields(), and updateFields().

Here is the call graph for this function:

Here is the caller graph for this function:

getFilterableFields()

ilDataCollectionTable::getFilterableFields

(

)

getFilterableFields Returns all fields of this table who have set their filterable to true, including standard fields.

Returns

ilDataCollectionField[]

Definition at line 649 of file class.ilDataCollectionTable.php.

                                              {
                $fields = $this->getFields();
                $filterableFields = array();
 
                foreach ($fields as $field) {
                        if ($field->isFilterable()) {
                                $filterableFields[] = $field;
                        }
                }
 
                return $filterableFields;
        }

References $fields, and getFields().

Here is the call graph for this function:

getId()

ilDataCollectionTable::getId

(

)

Get table id.

Returns

int

Definition at line 312 of file class.ilDataCollectionTable.php.

                                {
                return $this->id;
        }

References $id.

Referenced by cloneStructure(), doCreate(), doRead(), doUpdate(), getPartialRecords(), and loadFields().

Here is the caller graph for this function:

getIsVisible()

ilDataCollectionTable::getIsVisible

(

)

Returns

boolean

Definition at line 1064 of file class.ilDataCollectionTable.php.

                                       {
                return $this->is_visible;
        }

References $is_visible.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getLimited()

ilDataCollectionTable::getLimited

(

)

Returns

boolean

Definition at line 1016 of file class.ilDataCollectionTable.php.

                                     {
                return $this->limited;
        }

References $limited.

Referenced by checkLimit(), cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getLimitEnd()

ilDataCollectionTable::getLimitEnd

(

)

Returns

string

Definition at line 1032 of file class.ilDataCollectionTable.php.

                                      {
                return $this->limit_end;
        }

References $limit_end.

Referenced by checkLimit(), cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getLimitStart()

ilDataCollectionTable::getLimitStart

(

)

Returns

string

Definition at line 1048 of file class.ilDataCollectionTable.php.

                                        {
                return $this->limit_start;
        }

References $limit_start.

Referenced by checkLimit(), cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getNewOrder()

ilDataCollectionTable::getNewOrder

(

)

getNewOrder

Returns

int returns the place where a new field should be placed.

Definition at line 510 of file class.ilDataCollectionTable.php.

                                      {
                $fields = $this->getFields();
                $place = 0;
                foreach ($fields as $field) {
                        if (! $field->isStandardField()) {
                                $place = $field->getOrder() + 1;
                        }
                }
 
                return $place;
        }

References $fields, and getFields().

Here is the call graph for this function:

getObjId()

ilDataCollectionTable::getObjId

(

)

Returns

int

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

                                   {
                return $this->objId;
        }

References $objId.

Referenced by doCreate(), doUpdate(), and getPartialRecords().

Here is the caller graph for this function:

getPartialRecords()

ilDataCollectionTable::getPartialRecords	(		$sort,
			$direction,
			$limit,
			$offset,
		array	$filter = array()
	)

Return only the needed subset of record objects for the table, according to sorting, paging and filters.

Parameters

string	$sort	Title of a field where the ilTable2GUI is sorted
string	$direction	'desc' or 'asc'
int	$limit	Limit of records
int	$offset	Offset from records
array	$filter	Containing the filter values

Returns

array Array with two keys: 'record' => Contains the record objects, 'total' => Number of total records (without slicing)

Definition at line 1347 of file class.ilDataCollectionTable.php.

                                                                                                       {
                global $ilDB, $ilUser, $rbacreview;
 
                $sort_field = ($sort) ? $this->getFieldByTitle($sort) : $this->getField('id');
                $direction = strtolower($direction);
                $direction = (in_array($direction, array( 'desc', 'asc' ))) ? $direction : 'asc';
 
                // Sorting by a status from an ILIAS Ref field. This column is added dynamically to the table, there is no field model
                $sort_by_status = false;
                if (substr($sort, 0, 8) == '_status_') {
                        $sort_by_status = true;
                        $sort_field = $this->getFieldByTitle(substr($sort, 8));
                }
 
                if (is_null($sort_field)) {
                        $sort_field = $this->getField('id');
                }
 
                $id = $sort_field->getId();
                $stl = $sort_field->getStorageLocation();
                $select_str = '';
                $join_str = '';
                $where_additions = '';
                $has_nref = false;
 
                if ($sort_field->isStandardField() && $id != 'comments') {
                        if ($id == 'owner' || $id == 'last_edit_by') {
                                $join_str .= "LEFT JOIN usr_data AS sort_usr_data_{$id} ON (sort_usr_data_{$id}.usr_id = record.{$id})";
                                $select_str .= " sort_usr_data_{$id}.login AS field_{$id},";
                        } else {
                                $select_str .= " record.{$id} AS field_{$id},";
                        }
                } else {
                        switch ($sort_field->getDatatypeId()) {
                                case ilDataCollectionDatatype::INPUTFORMAT_RATING:
                                        $rating_joined = true;
                                        // FSX Bugfix 0015735: The average is multiplied with 10000 and added to the amount of votes
                                        $join_str .= "LEFT JOIN (SELECT (ROUND(AVG(rating), 1) * 10000 + COUNT(rating)) as rating, obj_id FROM il_rating GROUP BY obj_id) AS average ON average.obj_id = record.id";
                                        $select_str .= " average.rating AS field_{$id},";
                                        break;
                                case ilDataCollectionDatatype::INPUTFORMAT_ILIAS_REF:
                                        $join_str .=
                                                "LEFT JOIN il_dcl_record_field AS sort_record_field_{$id} ON (sort_record_field_{$id}.record_id = record.id AND sort_record_field_{$id}.field_id = "
                                                . $ilDB->quote($sort_field->getId(), 'integer') . ") ";
                                        $join_str .= "LEFT JOIN il_dcl_stloc{$stl}_value AS sort_stloc_{$id} ON (sort_stloc_{$id}.record_field_id = sort_record_field_{$id}.id) ";
                                        $join_str .= "LEFT JOIN object_reference AS sort_object_reference_{$id} ON (sort_object_reference_{$id}.ref_id = sort_stloc_{$id}.value AND sort_object_reference_{$id}.deleted IS NULL)";
                                        $join_str .= "LEFT JOIN object_data AS sort_object_data_{$id} ON (sort_object_data_{$id}.obj_id = sort_object_reference_{$id}.obj_id)";
                                        if ($sort_by_status) {
                                                global $ilUser;
                                                $join_str .= "LEFT JOIN ut_lp_marks AS ut ON (ut.obj_id = sort_object_data_{$id}.obj_id AND ut.usr_id = "
                                                        . $ilDB->quote($ilUser->getId(), 'integer') . ") ";
                                        }
                                        $select_str .= (! $sort_by_status) ? " sort_object_data_{$id}.title AS field_{$id}," : " ut.status AS field_{$id}";
                                        break;
                                case ilDataCollectionDatatype::INPUTFORMAT_FILE:
                                case ilDataCollectionDatatype::INPUTFORMAT_MOB:
                                        $join_str .=
                                                "LEFT JOIN il_dcl_record_field AS sort_record_field_{$id} ON (sort_record_field_{$id}.record_id = record.id AND sort_record_field_{$id}.field_id = "
                                                . $ilDB->quote($sort_field->getId(), 'integer') . ") ";
                                        $join_str .= "LEFT JOIN il_dcl_stloc{$stl}_value AS sort_stloc_{$id} ON (sort_stloc_{$id}.record_field_id = sort_record_field_{$id}.id) ";
                                        $join_str .= "LEFT JOIN object_data AS sort_object_data_{$id} ON (sort_object_data_{$id}.obj_id = sort_stloc_{$id}.value) ";
                                        $select_str .= " sort_object_data_{$id}.title AS field_{$id},";
                                        break;
                                case ilDataCollectionDatatype::INPUTFORMAT_REFERENCE:
                                        $prop = $sort_field->getPropertyvalues();
                                        $ref_field = ilDataCollectionCache::getFieldCache($sort_field->getFieldRef());
                                        $n_ref = $prop[ilDataCollectionField::PROPERTYID_N_REFERENCE];
                                        if ($n_ref) {
                                                $has_nref = true;
                                        }
                                        $select_str .= ($n_ref) ? " GROUP_CONCAT(stloc_{$id}_joined.value) AS field_{$id}" : "stloc_{$id}_joined.value AS field_{$id},";
                                        $join_str .=
                                                "LEFT JOIN il_dcl_record_field AS record_field_{$id} ON (record_field_{$id}.record_id = record.id AND record_field_{$id}.field_id = "
                                                . $ilDB->quote($sort_field->getId(), 'integer') . ") ";
                                        $join_str .= "LEFT JOIN il_dcl_stloc{$stl}_value AS stloc_{$id} ON (stloc_{$id}.record_field_id = record_field_{$id}.id) ";
                                        $join_str .=
                                                "LEFT JOIN il_dcl_record_field AS record_field_{$id}_joined ON (record_field_{$id}_joined.record_id = stloc_{$id}.value AND record_field_{$id}_joined.field_id = "
                                                . $ilDB->quote($ref_field->getId(), 'integer') . ") ";
                                        $join_str .= "LEFT JOIN il_dcl_stloc{$ref_field->getStorageLocation()}_value AS stloc_{$id}_joined ON (stloc_{$id}_joined.record_field_id = record_field_{$id}_joined.id) ";
                                        break;
                                case ilDataCollectionDatatype::INPUTFORMAT_DATETIME:
                                case ilDataCollectionDatatype::INPUTFORMAT_TEXT:
                                case ilDataCollectionDatatype::INPUTFORMAT_BOOLEAN:
                                case ilDataCollectionDatatype::INPUTFORMAT_NUMBER:
                                        $select_str .= " sort_stloc_{$id}.value AS field_{$id},";
                                        $join_str .=
                                                "LEFT JOIN il_dcl_record_field AS sort_record_field_{$id} ON (sort_record_field_{$id}.record_id = record.id AND sort_record_field_{$id}.field_id = "
                                                . $ilDB->quote($sort_field->getId(), 'integer') . ") ";
                                        $join_str .= "LEFT JOIN il_dcl_stloc{$stl}_value AS sort_stloc_{$id} ON (sort_stloc_{$id}.record_field_id = sort_record_field_{$id}.id) ";
                                        break;
                        }
                }
 
                if (count($filter)) {
                        foreach ($filter as $key => $filter_value) {
                                $filter_field_id = substr($key, 7);
                                $filter_field = $this->getField($filter_field_id);
                                switch ($filter_field->getDatatypeId()) {
                                        case ilDataCollectionDatatype::INPUTFORMAT_RATING:
                                                if(!$rating_joined) {
                                                        $join_str .= "LEFT JOIN (SELECT (ROUND(AVG(rating), 1) * 10000 + COUNT(rating)) as rating, obj_id FROM il_rating GROUP BY obj_id) AS average ON average.obj_id = record.id";
                                                }
                                                // FSX Bugfix 0015735: The average is multiplied with 10000 and added to the amount of votes
                                                $where_additions .= " AND average.rating >= " . $ilDB->quote($filter_value * 10000, 'integer');
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_ILIAS_REF:
                                                $join_str .=
                                                        " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                        . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                $join_str .= " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id) ";
                                                $join_str .= " INNER JOIN object_reference AS filter_object_reference_{$filter_field_id} ON (filter_object_reference_{$filter_field_id}.ref_id = filter_stloc_{$filter_field_id}.value ) ";
                                                $join_str .=
                                                        " INNER JOIN object_data AS filter_object_data_{$filter_field_id} ON (filter_object_data_{$filter_field_id}.obj_id = filter_object_reference_{$filter_field_id}.obj_id AND filter_object_data_{$filter_field_id}.title LIKE "
                                                        . $ilDB->quote("%$filter_value%", 'text') . ") ";
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_MOB:
                                        case ilDataCollectionDatatype::INPUTFORMAT_FILE:
                                                $join_str .=
                                                        " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                        . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                $join_str .= " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id) ";
                                                $join_str .=
                                                        " INNER JOIN object_data AS filter_object_data_{$filter_field_id} ON (filter_object_data_{$filter_field_id}.obj_id = filter_stloc_{$filter_field_id}.value AND filter_object_data_{$filter_field_id}.title LIKE "
                                                        . $ilDB->quote("%$filter_value%", 'text') . ") ";
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_DATETIME:
                                                $date_from = (isset($filter_value['from']) && is_object($filter_value['from'])) ? $filter_value['from'] : NULL;
                                                $date_to = (isset($filter_value['to']) && is_object($filter_value['to'])) ? $filter_value['to'] : NULL;
                                                if ($filter_field->isStandardField()) {
                                                        if ($date_from) {
                                                                $where_additions .= " AND (record.{$filter_field_id} >= " . $ilDB->quote($date_from, 'date') . ")";
                                                        }
                                                        if ($date_to) {
                                                                $where_additions .= " AND (record.{$filter_field_id} <= " . $ilDB->quote($date_to, 'date') . ")";
                                                        }
                                                } else {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                                . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                        $join_str .= " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id ";
                                                        if ($date_from) {
                                                                $join_str .= "AND filter_stloc_{$filter_field_id}.value >= " . $ilDB->quote($date_from, 'date') . " ";
                                                        }
                                                        if ($date_to) {
                                                                $join_str .= "AND filter_stloc_{$filter_field_id}.value <= " . $ilDB->quote($date_to, 'date') . " ";
                                                        }
                                                        $join_str .= ") ";
                                                }
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_NUMBER:
                                                $from = (isset($filter_value['from'])) ? (int)$filter_value['from'] : NULL;
                                                $to = (isset($filter_value['to'])) ? (int)$filter_value['to'] : NULL;
                                                if ($filter_field->isStandardField()) {
                                                        if (! is_null($from)) {
                                                                $where_additions .= " AND record.{$filter_field_id} >= " . $ilDB->quote($from, 'integer');
                                                        }
                                                        if (! is_null($to)) {
                                                                $where_additions .= " AND record.{$filter_field_id} <= " . $ilDB->quote($to, 'integer');
                                                        }
                                                } else {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                                . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                        $join_str .= " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id";
                                                        if (! is_null($from)) {
                                                                $join_str .= " AND filter_stloc_{$filter_field_id}.value >= " . $ilDB->quote($from, 'integer');
                                                        }
                                                        if (! is_null($to)) {
                                                                $join_str .= " AND filter_stloc_{$filter_field_id}.value <= " . $ilDB->quote($to, 'integer');
                                                        }
                                                        $join_str .= ") ";
                                                }
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_BOOLEAN:
                                                if ($filter_value == "checked") {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                                . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                        $join_str .= " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id";
                                                        $join_str .= " AND filter_stloc_{$filter_field_id}.value = " . $ilDB->quote(1, 'integer');
                                                } else {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                                . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                        $join_str .= "LEFT JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id";
                                                        $where_additions .= " AND (filter_stloc_{$filter_field_id}.value <> " . $ilDB->quote(1, 'integer')
                                                                . " OR filter_stloc_{$filter_field_id}.value is NULL)";
                                                }
                                                $join_str .= " ) ";
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_TEXT:
                                                if ($filter_field->isStandardField()) {
                                                        $join_str .=
                                                                " INNER JOIN usr_data AS filter_usr_data_{$filter_field_id} ON (filter_usr_data_{$filter_field_id}.usr_id = record.{$filter_field_id} AND filter_usr_data_{$filter_field_id}.login LIKE "
                                                                . $ilDB->quote("%$filter_value%", 'text') . ") ";
                                                } else {
                                                        $join_str .=
                                                                "  INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                                . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id AND filter_stloc_{$filter_field_id}.value LIKE "
                                                                . $ilDB->quote("%$filter_value%", 'text') . ") ";
                                                }
                                                break;
                                        case ilDataCollectionDatatype::INPUTFORMAT_REFERENCE:
                                                $join_str .=
                                                        " INNER JOIN il_dcl_record_field AS filter_record_field_{$filter_field_id} ON (filter_record_field_{$filter_field_id}.record_id = record.id AND filter_record_field_{$filter_field_id}.field_id = "
                                                        . $ilDB->quote($filter_field_id, 'integer') . ") ";
                                                $prop = $filter_field->getPropertyvalues();
                                                $n_ref = $prop[ilDataCollectionField::PROPERTYID_N_REFERENCE];
                                                if ($n_ref) {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id AND filter_stloc_{$filter_field_id}.value LIKE "
                                                                . $ilDB->quote("%$filter_value%", 'text') . ") ";
                                                } else {
                                                        $join_str .=
                                                                " INNER JOIN il_dcl_stloc{$filter_field->getStorageLocation()}_value AS filter_stloc_{$filter_field_id} ON (filter_stloc_{$filter_field_id}.record_field_id = filter_record_field_{$filter_field_id}.id AND filter_stloc_{$filter_field_id}.value = "
                                                                . $ilDB->quote($filter_value, 'integer') . ") ";
                                                }
                                                break;
                                }
                        }
                }
 
                // Build the query string
                $sql = "SELECT DISTINCT record.id, record.owner";
                if($select_str) {
                        $sql .= ', ';
                }               $sql .= rtrim($select_str, ',') . " FROM il_dcl_record AS record ";
                $sql .= $join_str;
                $sql .= " WHERE record.table_id = " . $ilDB->quote($this->getId(), 'integer') . $where_additions;
                if ($has_nref) {
                        $sql .= " GROUP BY record.id, record.owner";
                }
                $props = $sort_field->getProperties();
                if($id != 'comments' && $sort_field->getDatatypeId() != ilDataCollectionDatatype::INPUTFORMAT_FORMULA && !$props[ilDataCollectionField::PROPERTYID_URL]) {
                        $sql .= " ORDER BY field_{$id} {$direction}";
                }
                $set = $ilDB->query($sql);
                $total_record_ids = array();
                // Save record-ids in session to enable prev/next links in detail view
                $_SESSION['dcl_record_ids'] = array();
        $_SESSION['dcl_table_id'] = $this->getId();
                $is_allowed_to_view = ilObjDataCollectionAccess::hasWriteAccess(array_pop(ilObject::_getAllReferences($this->getObjId())));
                while ($rec = $ilDB->fetchAssoc($set)) {
                        // Quick check if the current user is allowed to view the record
                        if (!$is_allowed_to_view && ($this->getViewOwnRecordsPerm() && $ilUser->getId() != $rec['owner'])) {
                                continue;
                        }
                        $total_record_ids[] = $rec['id'];
                        $_SESSION['dcl_record_ids'][] = $rec['id'];
                }
                // Sort by formula
                if ($sort_field->getDatatypeId() == ilDataCollectionDatatype::INPUTFORMAT_FORMULA) {
                        $sort_array = array();
                        foreach ($total_record_ids as $id) {
                                $formula_field = ilDataCollectionCache::getRecordFieldCache(new ilDataCollectionRecord($id), $sort_field);
                                $sort_array[$id] = $formula_field->getValue();
                        }
                        switch ($direction) {
                                case 'asc':
                                case 'ASC':
                                        asort($sort_array);
                                        break;
                                case 'desc':
                                case 'DESC':
                                        arsort($sort_array);
                                        break;
                        }
                        $total_record_ids = array_keys($sort_array);
                }
                //Sort by URL-title if existent
                if ($props[ilDataCollectionField::PROPERTYID_URL]) {
                        $sort_array = array();
                        foreach ($total_record_ids as $id) {
                                $url_field = ilDataCollectionCache::getRecordFieldCache(new ilDataCollectionRecord($id), $sort_field);
                                $sort_array[$id] = $url_field->getSortingValue();
                        }
                        switch ($direction) {
                                case 'asc':
                                case 'ASC':
                                        asort($sort_array);
                                        break;
                                case 'desc':
                                case 'DESC':
                                        arsort($sort_array);
                                        break;
                        }
                        $total_record_ids = array_keys($sort_array);
                }
                // Now slice the array to load only the needed records in memory
                $record_ids = array_slice($total_record_ids, $offset, $limit);
                $records = array();
                foreach ($record_ids as $id) {
                        $records[] = ilDataCollectionCache::getRecordCache($id);
                }
 
                return array( 'records' => $records, 'total' => count($total_record_ids) );
        }

References $_SESSION, $id, $ilDB, $ilUser, $records, ilObject\_getAllReferences(), getField(), getFieldByTitle(), ilDataCollectionCache\getFieldCache(), getId(), getObjId(), ilDataCollectionCache\getRecordCache(), ilDataCollectionCache\getRecordFieldCache(), getViewOwnRecordsPerm(), ilObjDataCollectionAccess\hasWriteAccess(), ilDataCollectionDatatype\INPUTFORMAT_BOOLEAN, ilDataCollectionDatatype\INPUTFORMAT_DATETIME, ilDataCollectionDatatype\INPUTFORMAT_FILE, ilDataCollectionDatatype\INPUTFORMAT_FORMULA, ilDataCollectionDatatype\INPUTFORMAT_ILIAS_REF, ilDataCollectionDatatype\INPUTFORMAT_MOB, ilDataCollectionDatatype\INPUTFORMAT_NUMBER, ilDataCollectionDatatype\INPUTFORMAT_RATING, ilDataCollectionDatatype\INPUTFORMAT_REFERENCE, ilDataCollectionDatatype\INPUTFORMAT_TEXT, ilDataCollectionField\PROPERTYID_N_REFERENCE, and ilDataCollectionField\PROPERTYID_URL.

Here is the call graph for this function:

getPublicCommentsEnabled()

ilDataCollectionTable::getPublicCommentsEnabled

(

)

Returns

boolean

Definition at line 1134 of file class.ilDataCollectionTable.php.

                                                   {
                return $this->public_comments;
        }

References $public_comments.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getRecordFields()

ilDataCollectionTable::getRecordFields

(

)

Returns all fields of this table which are NOT standard fields.

Returns

ilDataCollectionField[]

Definition at line 599 of file class.ilDataCollectionTable.php.

                                          {
                $this->loadFields();
 
                return $this->fields;
        }

References $fields, and loadFields().

Referenced by getEditableFields().

Here is the call graph for this function:

Here is the caller graph for this function:

getRecords()

ilDataCollectionTable::getRecords

(

)

Returns

ilDataCollectionRecord[]

Definition at line 369 of file class.ilDataCollectionTable.php.

                                     {
                $this->loadRecords();
 
                return $this->records;
        }

References $records, and loadRecords().

Referenced by _hasRecords(), deleteField(), and getRecordsByFilter().

Here is the call graph for this function:

Here is the caller graph for this function:

getRecordsByFilter()

ilDataCollectionTable::getRecordsByFilter

(

array

$filter = array()

)

getRecordsByFilter

Parameters

$filter

filter is of the form array("filter_{field_id}" => filter); For dates and integers this filter must be of the form array("from" => from, "to" => to). In case of dates from and to have to be ilDateTime objects in case of integers they have to be integers as well.

Returns

ilDataCollectionRecord[]

Definition at line 387 of file class.ilDataCollectionTable.php.

                                                                    {
                $this->loadRecords();
                // Only pass records trough filter if there is filtering required #performance-improvements
                if (! count($filter)) {
                        return $this->records;
                }
                $filtered = array();
                foreach ($this->getRecords() as $record) {
                        if ($record->passThroughFilter($filter)) {
                                $filtered[] = $record;
                        }
                }
 
                return $filtered;
        }

References $records, getRecords(), and loadRecords().

Here is the call graph for this function:

getTitle()

ilDataCollectionTable::getTitle

(

)

Returns

string

Definition at line 344 of file class.ilDataCollectionTable.php.

                                   {
                return $this->title;
        }

References $title.

Referenced by cloneStructure(), doCreate(), and doUpdate().

Here is the caller graph for this function:

getViewOwnRecordsPerm()

ilDataCollectionTable::getViewOwnRecordsPerm

(

)

Returns

boolean

Definition at line 1150 of file class.ilDataCollectionTable.php.

                                                {
                return (bool)$this->view_own_records_perm;
        }

References $view_own_records_perm.

Referenced by cloneStructure(), doCreate(), doUpdate(), and getPartialRecords().

Here is the caller graph for this function:

getVisibleFields()

ilDataCollectionTable::getVisibleFields

(

)

Returns all fields of this table who have set their visibility to true, including standard fields.

Returns

ilDataCollectionField[]

Definition at line 611 of file class.ilDataCollectionTable.php.

                                           {
                $fields = $this->getFields();
 
                $visibleFields = array();
 
                foreach ($fields as $field) {
                        if ($field->isVisible()) {
                                $visibleFields[] = $field;
                        }
                }
 
                return $visibleFields;
        }

References $fields, and getFields().

Here is the call graph for this function:

hasCustomFields()

ilDataCollectionTable::hasCustomFields

(

)

hasCustomFields

Returns

boolean

Definition at line 1160 of file class.ilDataCollectionTable.php.

                                          {
                $this->loadFields();
 
                return (count($this->fields) > 0) ? true : false;
        }

References fields, and loadFields().

Here is the call graph for this function:

hasPermissionToAddRecord()

ilDataCollectionTable::hasPermissionToAddRecord

(

$ref_id

)

Parameters

int

$ref_id

y

Returns

bool

Definition at line 707 of file class.ilDataCollectionTable.php.

                                                          {
                if (ilObjDataCollectionAccess::hasWriteAccess($ref_id)) {
                        return true;
                }
                if (!ilObjDataCollectionAccess::hasAddRecordAccess($ref_id)) {
                        return false;
                }
 
                return ($this->getAddPerm() AND $this->checkLimit());
        }

References $ref_id, checkLimit(), getAddPerm(), ilObjDataCollectionAccess\hasAddRecordAccess(), and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

hasPermissionToAddTable()

ilDataCollectionTable::hasPermissionToAddTable

(

$ref_id

)

Parameters

int

$ref_id

Returns

bool

Definition at line 696 of file class.ilDataCollectionTable.php.

                                                         {
                return ilObjDataCollectionAccess::hasWriteAccess($ref_id);
        }

References $ref_id, and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

hasPermissionToDeleteRecord()

ilDataCollectionTable::hasPermissionToDeleteRecord	(		$ref_id,
		ilDataCollectionRecord	$record
	)

Parameters

$ref_id	int the reference id of the current datacollection object
$record	ilDataCollectionRecord the record which will be deleted

Returns

bool

Definition at line 752 of file class.ilDataCollectionTable.php.

                                                                                             {
                if (ilObjDataCollectionAccess::hasWriteAccess($ref_id)) {
                        return true;
                }
                if (!ilObjDataCollectionAccess::hasAddRecordAccess($ref_id)) {
                        return false;
                }
                if (!$this->checkLimit()) {
                        return false;
                }
                if ($this->getDeletePerm() && !$this->getDeleteByOwner()) {
                        return true;
                }
                if ($this->getDeleteByOwner()) {
                        return $this->doesRecordBelongToUser($record);
                }
 
                return false;
        }

References $ref_id, checkLimit(), doesRecordBelongToUser(), getDeleteByOwner(), getDeletePerm(), ilObjDataCollectionAccess\hasAddRecordAccess(), and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

hasPermissionToDeleteRecords()

ilDataCollectionTable::hasPermissionToDeleteRecords

(

$ref_id

)

Parameters

$ref_id

Returns

bool

Definition at line 778 of file class.ilDataCollectionTable.php.

                                                              {
                return ($this->getDeletePerm() AND ilObjDataCollectionAccess::hasWriteAccess($ref_id));
        }

References $ref_id, getDeletePerm(), and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

hasPermissionToEditRecord()

ilDataCollectionTable::hasPermissionToEditRecord	(		$ref_id,
		ilDataCollectionRecord	$record
	)

Parameters

$ref_id	int the reference id of the current datacollection object
$record	ilDataCollectionRecord the record which will be edited

Returns

bool

Definition at line 725 of file class.ilDataCollectionTable.php.

                                                                                           {
                if (ilObjDataCollectionAccess::hasWriteAccess($ref_id)) {
                        return true;
                }
                if (!ilObjDataCollectionAccess::hasAddRecordAccess($ref_id)) {
                        return false;
                }
                if (!$this->checkLimit()) {
                        return false;
                }
                if ($this->getEditPerm() && !$this->getEditByOwner()) {
                        return true;
                }
                if ($this->getEditByOwner()) {
                        return $this->doesRecordBelongToUser($record);
                }
 
                return false;
        }

References $ref_id, checkLimit(), doesRecordBelongToUser(), getEditByOwner(), getEditPerm(), ilObjDataCollectionAccess\hasAddRecordAccess(), and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

hasPermissionToFields()

ilDataCollectionTable::hasPermissionToFields

(

$ref_id

)

Parameters

int

$ref_id

Returns

bool

Definition at line 686 of file class.ilDataCollectionTable.php.

                                                       {
                return ilObjDataCollectionAccess::hasWriteAccess($ref_id);
        }

References $ref_id, and ilObjDataCollectionAccess\hasWriteAccess().

Here is the call graph for this function:

loadFields()

ilDataCollectionTable::loadFields ( )

protected

Definition at line 483 of file class.ilDataCollectionTable.php.

                                        {
                if ($this->fields === NULL) {
                        global $ilDB;
 
                        $query = "SELECT DISTINCT field.* FROM il_dcl_field AS field 
                                  INNER JOIN il_dcl_view AS view ON view.table_id = field.table_id 
                                  INNER JOIN il_dcl_viewdefinition AS def ON def.view_id = view.id 
                                  WHERE field.table_id =" . $ilDB->quote($this->getId(), "integer") . "
                                  ORDER BY def.field_order DESC";
                        $fields = array();
                        $set = $ilDB->query($query);
 
                        while ($rec = $ilDB->fetchAssoc($set)) {
                                $field = ilDataCollectionCache::buildFieldFromRecord($rec);
                                $fields[$field->getId()] = $field;
                        }
                        $this->sortByOrder($fields);
                        $this->fields = $fields;
                }
        }

References $fields, $ilDB, $query, ilDataCollectionCache\buildFieldFromRecord(), fields, getId(), and sortByOrder().

Referenced by getFields(), getRecordFields(), and hasCustomFields().

Here is the call graph for this function:

Here is the caller graph for this function:

loadObj()

ilDataCollectionTable::loadObj ( )

protected

Definition at line 359 of file class.ilDataCollectionTable.php.

                                     {
                if ($this->obj == NULL) {
                        $this->obj = new ilObjDataCollection($this->objId, false);
                }
        }

Referenced by getCollectionObject().

Here is the caller graph for this function:

loadRecords()

ilDataCollectionTable::loadRecords ( )

protected

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

                                         {
                if ($this->records == NULL) {
                        global $ilDB;
 
                        $records = array();
                        $query = "SELECT id FROM il_dcl_record WHERE table_id = " . $ilDB->quote($this->id, "integer");
                        $set = $ilDB->query($query);
 
                        while ($rec = $ilDB->fetchAssoc($set)) {
                                $records[$rec['id']] = ilDataCollectionCache::getRecordCache($rec['id']);
                        }
 
                        $this->records = $records;
                }
        }

References $ilDB, $query, $records, and ilDataCollectionCache\getRecordCache().

Referenced by getRecords(), and getRecordsByFilter().

Here is the call graph for this function:

Here is the caller graph for this function:

setAddPerm()

ilDataCollectionTable::setAddPerm

(

$add_perm

)

Parameters

boolean

$add_perm

Definition at line 913 of file class.ilDataCollectionTable.php.

                                              {
                $this->add_perm = $add_perm;
        }

References $add_perm.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setDefaultSortField()

ilDataCollectionTable::setDefaultSortField

(

$default_sort_field

)

/**

Parameters

string

$default_sort_field

Definition at line 1090 of file class.ilDataCollectionTable.php.

                                                                 {
                $default_sort_field = ($default_sort_field) ? $default_sort_field : 0; // Change null or empty strings to zero
                $this->default_sort_field = $default_sort_field;
        }

References $default_sort_field.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setDefaultSortFieldOrder()

ilDataCollectionTable::setDefaultSortFieldOrder

(

$default_sort_field_order

)

Parameters

string

$default_sort_field_order

Definition at line 1107 of file class.ilDataCollectionTable.php.

                                                                            {
                if (! in_array($default_sort_field_order, array( 'asc', 'desc' ))) {
                        $default_sort_field_order = 'asc';
                }
                $this->default_sort_field_order = $default_sort_field_order;
        }

References $default_sort_field_order.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setDeleteByOwner()

ilDataCollectionTable::setDeleteByOwner

(

$delete_by_owner

)

Parameters

boolean

$delete_by_owner

Definition at line 977 of file class.ilDataCollectionTable.php.

        {
                $this->delete_by_owner = $delete_by_owner;
                if ($delete_by_owner) {
                        $this->setDeletePerm(true);
                }
        }

References $delete_by_owner, and setDeletePerm().

Referenced by cloneStructure(), doRead(), and setDeletePerm().

Here is the call graph for this function:

Here is the caller graph for this function:

setDeletePerm()

ilDataCollectionTable::setDeletePerm

(

$delete_perm

)

Parameters

boolean

$delete_perm

Definition at line 929 of file class.ilDataCollectionTable.php.

                                                    {
                $this->delete_perm = $delete_perm;
                if (!$delete_perm) {
                        $this->setDeleteByOwner(false);
                }
        }

References $delete_perm, and setDeleteByOwner().

Referenced by cloneStructure(), doRead(), and setDeleteByOwner().

Here is the call graph for this function:

Here is the caller graph for this function:

setDescription()

ilDataCollectionTable::setDescription

(

$description

)

Parameters

string

$description

Definition at line 1072 of file class.ilDataCollectionTable.php.

                                                     {
                $this->description = $description;
        }

References $description.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setEditByOwner()

ilDataCollectionTable::setEditByOwner

(

$edit_by_owner

)

Parameters

boolean

$edit_by_owner

Definition at line 949 of file class.ilDataCollectionTable.php.

                                                       {
                $this->edit_by_owner = $edit_by_owner;
                if ($edit_by_owner) {
                        $this->setEditPerm(true);
                }
        }

References $edit_by_owner, and setEditPerm().

Referenced by cloneStructure(), doRead(), and setEditPerm().

Here is the call graph for this function:

Here is the caller graph for this function:

setEditPerm()

ilDataCollectionTable::setEditPerm

(

$edit_perm

)

Parameters

boolean

$edit_perm

Definition at line 989 of file class.ilDataCollectionTable.php.

                                                {
                $this->edit_perm = $edit_perm;
                if (!$edit_perm) {
                        $this->setEditByOwner(false);
                }
        }

References $edit_perm, and setEditByOwner().

Referenced by cloneStructure(), doRead(), and setEditByOwner().

Here is the call graph for this function:

Here is the caller graph for this function:

setExportEnabled()

ilDataCollectionTable::setExportEnabled

(

$export_enabled

)

Parameters

boolean

$export_enabled

Definition at line 1306 of file class.ilDataCollectionTable.php.

                                                          {
                $this->export_enabled = $export_enabled;
        }

References $export_enabled.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setId()

ilDataCollectionTable::setId

(

$a_id

)

Set table id.

Parameters

int

$a_id

Definition at line 302 of file class.ilDataCollectionTable.php.

                                     {
                $this->id = $a_id;
        }

Referenced by doCreate().

Here is the caller graph for this function:

setIsVisible()

ilDataCollectionTable::setIsVisible

(

$is_visible

)

Parameters

boolean

$is_visible

Definition at line 1056 of file class.ilDataCollectionTable.php.

                                                  {
                $this->is_visible = $is_visible;
        }

References $is_visible.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setLimited()

ilDataCollectionTable::setLimited

(

$limited

)

Parameters

boolean

$limited

Definition at line 1008 of file class.ilDataCollectionTable.php.

                                             {
                $this->limited = $limited;
        }

References $limited.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setLimitEnd()

ilDataCollectionTable::setLimitEnd

(

$limit_end

)

Parameters

string

$limit_end

Definition at line 1024 of file class.ilDataCollectionTable.php.

                                                {
                $this->limit_end = $limit_end;
        }

References $limit_end.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setLimitStart()

ilDataCollectionTable::setLimitStart

(

$limit_start

)

Parameters

string

$limit_start

Definition at line 1040 of file class.ilDataCollectionTable.php.

                                                    {
                $this->limit_start = $limit_start;
        }

References $limit_start.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setObjId()

ilDataCollectionTable::setObjId

(

$a_id

)

Parameters

$a_id

Definition at line 320 of file class.ilDataCollectionTable.php.

                                        {
                $this->objId = $a_id;
        }

Referenced by doRead().

Here is the caller graph for this function:

setPublicCommentsEnabled()

ilDataCollectionTable::setPublicCommentsEnabled

(

$public_comments

)

Parameters

boolean

$public_comments

Definition at line 1126 of file class.ilDataCollectionTable.php.

                                                                   {
                $this->public_comments = $public_comments;
        }

References $public_comments.

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setTitle()

ilDataCollectionTable::setTitle

(

$a_title

)

Parameters

$a_title

Definition at line 336 of file class.ilDataCollectionTable.php.

                                           {
                $this->title = $a_title;
        }

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

setViewOwnRecordsPerm()

ilDataCollectionTable::setViewOwnRecordsPerm

(

$view_own_perm

)

Parameters

boolean

$view_own_perm

Definition at line 1142 of file class.ilDataCollectionTable.php.

                                                              {
                $this->view_own_records_perm = (int)$view_own_perm;
        }

Referenced by cloneStructure(), and doRead().

Here is the caller graph for this function:

sortByOrder()

ilDataCollectionTable::sortByOrder ( &  $array )

protected

Parameters

$array

ilDataCollectionField[] the array to sort

Definition at line 866 of file class.ilDataCollectionTable.php.

                                                {
                usort($array, array( $this, "compareOrder" ));
        }

Referenced by buildOrderFields(), getFields(), loadFields(), and sortFields().

Here is the caller graph for this function:

sortFields()

ilDataCollectionTable::sortFields

(

&

$fields

)

sortFields

Parameters

$fields

ilDataCollectionField[]

Definition at line 850 of file class.ilDataCollectionTable.php.

                                             {
                $this->sortByOrder($fields);
                //After sorting the array loses it's keys respectivly their keys are set form $field->id to 1,2,3... so we reset the keys.
                $named = array();
                foreach ($fields as $field) {
                        $named[$field->getId()] = $field;
                }
 
                $fields = $named;
        }

References $fields, and sortByOrder().

Here is the call graph for this function:

updateFields()

ilDataCollectionTable::updateFields

(

)

Update fields.

Definition at line 838 of file class.ilDataCollectionTable.php.

                                       {
                foreach ($this->getFields() as $field) {
                        $field->doUpdate();
                }
        }

References getFields().

Here is the call graph for this function:

Field Documentation

$add_perm

ilDataCollectionTable::$add_perm

protected

Definition at line 57 of file class.ilDataCollectionTable.php.

Referenced by getAddPerm(), and setAddPerm().

$default_sort_field

ilDataCollectionTable::$default_sort_field = 0

protected

Definition at line 95 of file class.ilDataCollectionTable.php.

Referenced by cloneStructure(), getDefaultSortField(), and setDefaultSortField().

$default_sort_field_order

ilDataCollectionTable::$default_sort_field_order = 'asc'

protected

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

Referenced by getDefaultSortFieldOrder(), and setDefaultSortFieldOrder().

$delete_by_owner

ilDataCollectionTable::$delete_by_owner

protected

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

Referenced by getDeleteByOwner(), and setDeleteByOwner().

$delete_perm

ilDataCollectionTable::$delete_perm

protected

Definition at line 65 of file class.ilDataCollectionTable.php.

Referenced by getDeletePerm(), and setDeletePerm().

$description

ilDataCollectionTable::$description = ''

protected

Definition at line 107 of file class.ilDataCollectionTable.php.

Referenced by getDescription(), and setDescription().

$edit_by_owner

ilDataCollectionTable::$edit_by_owner

protected

Definition at line 69 of file class.ilDataCollectionTable.php.

Referenced by getEditByOwner(), and setEditByOwner().

$edit_perm

ilDataCollectionTable::$edit_perm

protected

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

Referenced by getEditPerm(), and setEditPerm().

$export_enabled

ilDataCollectionTable::$export_enabled

protected

Definition at line 89 of file class.ilDataCollectionTable.php.

Referenced by getExportEnabled(), and setExportEnabled().

$fields

ilDataCollectionTable::$fields

protected

Definition at line 41 of file class.ilDataCollectionTable.php.

Referenced by buildOrderFields(), getEditableFields(), getExportableFields(), getField(), getFields(), getFilterableFields(), getNewOrder(), getRecordFields(), getVisibleFields(), loadFields(), and sortFields().

$id

ilDataCollectionTable::$id = 0

protected

Definition at line 25 of file class.ilDataCollectionTable.php.

Referenced by _getTableIdByTitle(), doCreate(), getId(), and getPartialRecords().

$is_visible

ilDataCollectionTable::$is_visible

protected

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

Referenced by getIsVisible(), and setIsVisible().

$limit_end

ilDataCollectionTable::$limit_end

protected

Definition at line 85 of file class.ilDataCollectionTable.php.

Referenced by getLimitEnd(), and setLimitEnd().

$limit_start

ilDataCollectionTable::$limit_start

protected

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

Referenced by getLimitStart(), and setLimitStart().

$limited

ilDataCollectionTable::$limited

protected

Definition at line 77 of file class.ilDataCollectionTable.php.

Referenced by getLimited(), and setLimited().

$obj

ilDataCollectionTable::$obj

protected

Definition at line 33 of file class.ilDataCollectionTable.php.

Referenced by getCollectionObject().

$objId

ilDataCollectionTable::$objId

protected

Definition at line 29 of file class.ilDataCollectionTable.php.

Referenced by getObjId().

$public_comments

ilDataCollectionTable::$public_comments = 0

protected

Definition at line 113 of file class.ilDataCollectionTable.php.

Referenced by getPublicCommentsEnabled(), and setPublicCommentsEnabled().

$records

ilDataCollectionTable::$records

protected

Definition at line 49 of file class.ilDataCollectionTable.php.

Referenced by deleteField(), getPartialRecords(), getRecords(), getRecordsByFilter(), and loadRecords().

$stdFields

ilDataCollectionTable::$stdFields

protected

Definition at line 45 of file class.ilDataCollectionTable.php.

$title

ilDataCollectionTable::$title

protected

Definition at line 37 of file class.ilDataCollectionTable.php.

Referenced by _getTableIdByTitle(), _hasFieldByTitle(), getFieldByTitle(), and getTitle().

$view_own_records_perm

ilDataCollectionTable::$view_own_records_perm = 0

protected

Definition at line 119 of file class.ilDataCollectionTable.php.

Referenced by getViewOwnRecordsPerm().

---

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

• Modules/DataCollection/classes/class.ilDataCollectionTable.php