private function loadFields() { if ($this->fields == NULL) { global $ilDB; $query = "SELECT field.id, field.table_id, field.title, field.description, field.datatype_id, field.required, field.is_unique, field.is_locked FROM il_dcl_field field INNER JOIN il_dcl_view view ON view.table_id = field.table_id INNER JOIN il_dcl_viewdefinition 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); // $field = new ilDataCollectionField(); // $field->buildFromDBRecord($rec); $fields[$field->getId()] = $field; } $this->sortByOrder($fields); $this->fields = $fields; } }
protected function loadFields() { if ($this->fields == NULL) { global $ilDB; $query = "SELECT DISTINCT field.* FROM il_dcl_field AS field\n\t\t\t INNER JOIN il_dcl_view AS view ON view.table_id = field.table_id\n\t\t\t INNER JOIN il_dcl_viewdefinition AS def ON def.view_id = view.id\n\t\t\t WHERE field.table_id =" . $ilDB->quote($this->getId(), "integer") . "\n\t\t\t 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; } }