4require_once
"Services/ADT/classes/class.ilADTFactory.php";
47 $this->
read($a_field_id);
62 $set =
$ilDB->query(
"SELECT field_type" .
63 " FROM adv_mdf_definition" .
64 " WHERE field_id = " .
$ilDB->quote($a_field_id,
"integer"));
69 if (self::isValidType(
$a_type)) {
71 require_once
"Services/AdvancedMetaData/classes/Types/class." . $class .
".php";
72 return new $class($a_field_id);
88 self::TYPE_TEXT =>
"Text",
89 self::TYPE_SELECT =>
"Select",
90 self::TYPE_DATE =>
"Date",
91 self::TYPE_DATETIME =>
"DateTime",
92 self::TYPE_FLOAT =>
"Float",
93 self::TYPE_LOCATION =>
"Location",
94 self::TYPE_INTEGER =>
"Integer",
95 self::TYPE_SELECT_MULTI =>
"SelectMulti" ,
96 self::TYPE_EXTERNAL_LINK =>
'ExternalLink',
97 self::TYPE_INTERNAL_LINK =>
'InternalLink'
99 $map = array_flip($map);
100 if (array_key_exists(
$a_type, $map)) {
118 $query =
"SELECT * FROM adv_mdf_definition" .
119 " WHERE record_id = " .
$ilDB->quote($a_record_id,
"integer");
120 if ($a_only_searchable) {
121 $query .=
" AND searchable = " .
$ilDB->quote(1,
"integer");
123 $query .=
" ORDER BY position";
127 $field->import(
$row);
128 $defs[
$row[
"field_id"]] = $field;
140 $query =
"SELECT amf.* FROM adv_md_record_objs aro" .
141 " JOIN adv_md_record amr ON aro.record_id = amr.record_id" .
142 " JOIN adv_mdf_definition amf ON aro.record_id = amf.record_id" .
143 " WHERE obj_type = " .
$ilDB->quote($a_obj_type,
'text');
144 if ((
bool) $a_active_only) {
145 $query .=
" AND active = " .
$ilDB->quote(1,
"integer");
147 $query .=
" ORDER BY aro.record_id,position";
151 $field->import(
$row);
152 $defs[
$row[
"field_id"]] = $field;
167 $query =
"SELECT field_id, field_type FROM adv_mdf_definition" .
168 " WHERE import_id = " .
$ilDB->quote($a_import_id,
'text');
170 if (
$ilDB->numRows($set)) {
185 $field_ids = array();
187 $query =
"SELECT field_id FROM adv_md_record amr" .
188 " JOIN adv_mdf_definition amfd ON (amr.record_id = amfd.record_id)" .
189 " WHERE active = " .
$ilDB->quote(1,
"integer") .
190 " AND searchable = " .
$ilDB->quote(1,
"integer");
193 $field_ids[] =
$row[
"field_id"];
207 $group_def =
$factory->getDefinitionInstanceByType(
"Group");
208 foreach ($a_defs as
$def) {
209 $group_def->addElement(
$def->getFieldId(),
$def->getADTDefinition());
211 $group =
$factory->getInstanceByDefinition($group_def);
214 foreach ($group->getElements() as $element_id => $element) {
215 $a_defs[$element_id]->setADT($element);
250 self::TYPE_SELECT_MULTI,
251 self::TYPE_EXTERNAL_LINK,
252 self::TYPE_INTERNAL_LINK
264 return in_array((
int)
$a_type, self::getValidTypes());
282 if (self::isValidType(
$a_type)) {
284 self::TYPE_TEXT =>
"Text",
285 self::TYPE_SELECT =>
"Select",
286 self::TYPE_DATE =>
"Date",
287 self::TYPE_DATETIME =>
"DateTime",
288 self::TYPE_FLOAT =>
"Float",
289 self::TYPE_LOCATION =>
"Location",
290 self::TYPE_INTEGER =>
"Integer",
291 self::TYPE_SELECT_MULTI =>
"SelectMulti" ,
292 self::TYPE_EXTERNAL_LINK =>
'ExternalLink',
293 self::TYPE_INTERNAL_LINK =>
'InternalLink'
307 return "udf_type_" . strtolower(self::getTypeString($this->
getType()));
343 if (!$this->adt instanceof
ilADT) {
357 if (!$this->adt instanceof
ilADT) {
373 $this->field_id = (int) $a_id;
393 $this->record_id = (int) $a_id;
413 if ($a_id_string !==
null) {
414 $a_id_string = trim($a_id_string);
416 $this->import_id = $a_id_string;
436 $this->position = (int) $a_pos;
456 if ($a_title !==
null) {
457 $a_title = trim($a_title);
459 $this->title = $a_title;
479 if ($a_desc !==
null) {
480 $a_desc = trim($a_desc);
482 $this->description = $a_desc;
526 $this->searchable = (bool) $a_status;
546 $this->required = (bool) $a_status;
634 $title->setRequired(
true);
638 $title->setDisabled(
true);
649 $desc->setDisabled(
true);
660 $check->setDisabled(
true);
731 if ($a_form->
getInput(
"searchable")) {
733 $hidden->setValue(1);
754 $sql =
"SELECT max(position) pos" .
755 " FROM adv_mdf_definition" .
757 $set =
$ilDB->query($sql);
758 if (
$ilDB->numRows($set)) {
759 $pos =
$ilDB->fetchAssoc($set);
760 return (
int) $pos[
"pos"];
774 return 'il_' . IL_INST_ID .
'_adv_md_field_' . $a_field_id;
785 "field_type" => array(
"integer", $this->
getType()),
786 "record_id" => array(
"integer", $this->
getRecordId()),
787 "import_id" => array(
"text", $this->
getImportId()),
788 "title" => array(
"text", $this->
getTitle()),
790 "position" => array(
"integer", $this->
getPosition()),
791 "searchable" => array(
"integer", $this->
isSearchable()),
792 "required" => array(
"integer", $this->
isRequired())
796 if (is_array(
$def)) {
797 $fields[
"field_values"] = array(
"text", serialize(
$def));
808 protected function import(array $a_data)
819 if ($a_data[
"field_values"]) {
827 protected function read($a_field_id)
831 if (!(
int) $a_field_id) {
835 $sql =
"SELECT * FROM adv_mdf_definition" .
836 " WHERE field_id = " .
$ilDB->quote($a_field_id,
"integer");
837 $set =
$ilDB->query($sql);
838 if (
$ilDB->numRows($set)) {
847 public function save($a_keep_pos =
false)
855 $next_id =
$ilDB->nextId(
"adv_mdf_definition");
868 $fields[
"field_id"] = array(
"integer", $next_id);
870 $ilDB->insert(
"adv_mdf_definition", $fields);
883 return $this->
save();
887 "adv_mdf_definition",
889 array(
"field_id"=>array(
"integer", $this->
getFieldId()))
896 public function delete()
905 include_once(
"Services/AdvancedMetaData/classes/class.ilAdvancedMDValues.php");
908 $query =
"DELETE FROM adv_mdf_definition" .
909 " WHERE field_id = " . $ilDB->quote($this->
getFieldId(),
"integer");
910 $ilDB->manipulate(
$query);
930 'fieldType' => self::getTypeString($this->
getType())));
1056 foreach ($a_records as $record) {
1057 if ($record[
"sub_type"] ==
"-") {
1058 $obj_ids[] = $record[
"obj_id"];
1062 $sql =
"SELECT obj_id,type" .
1063 " FROM object_data" .
1064 " WHERE " .
$ilDB->in(
"obj_id", $obj_ids,
"",
"integer") .
1065 " AND " .
$ilDB->in(
"type", $a_object_types,
"",
"text");
1066 $set =
$ilDB->query($sql);
1067 while (
$row =
$ilDB->fetchAssoc($set)) {
1076 include_once(
'Services/ADT/classes/ActiveRecord/class.ilADTActiveRecordByType.php');
1081 $element_id =
"loc";
1087 if (
sizeof($objects)) {
1089 foreach ($objects as $item) {
1090 if ($item[
"obj_id"] == $a_obj_id &&
1091 $item[
"sub_type"] == $sub_obj_type) {
1092 $res[] = $item[
"sub_id"];
1116 include_once(
'Services/ADT/classes/ActiveRecord/class.ilADTActiveRecordByType.php');
1120 if (
sizeof($objects)) {
1156 $class = get_class($this);
1157 $obj =
new $class();
1158 $obj->setRecordId($a_new_record_id);
An exception for terminatinating execution or to throw for unit testing.
static find($a_table, $a_type, $a_field_id, $a_condition, $a_additional_fields=null)
Find entries.
ADT definition base class.
static getInstance()
Get singleton.
ADT search bridge base class.
setSerializedValue($a_value)
Set current value(s) in serialized form (for easy persisting)
getSQLCondition($a_element_id)
Get SQL condition for current value(s)
getSerializedValue()
Get current value(s) in serialized form (for easy persisting)
AMD field abstract base class.
getLuceneSearchString($a_value)
Get search string in lucene syntax.
getLastPosition()
Get last position of record.
getImportId()
Get import id.
update()
Update field entry.
importXMLProperty($a_key, $a_value)
Import property from XML.
setRecordId($a_id)
Set record id.
setImportId($a_id_string)
Set import id.
static getInstanceByTypeString($a_type)
Get instance by type string (used by import)
importFromECS($a_ecs_type, $a_value, $a_sub_id)
Import meta data from ECS.
static getInstanceByImportId($a_import_id)
Get definition instance by import id.
isRequired()
Is required field.
addPropertiesToXML(ilXmlWriter $a_writer)
Add (type-specific) properties to xml export.
importFieldDefinition(array $a_def)
Import (type-specific) field definition from DB.
getSearchValueSerialized(ilADTSearchBridge $a_adt_search)
Get value for search persistence.
setTitle($a_title)
Get title.
static getInstance($a_field_id, $a_type=null)
Get definition instance by type.
static getADTGroupForDefinitions(array $a_defs)
Init ADTGroup for definitions.
setRequired($a_status)
Toggle required.
initADTDefinition()
Init adt instance.
setADT(ilADT $a_adt)
Set ADT instance.
static getInstancesByObjType($a_obj_type, $a_active_only=true)
isSearchSupported()
Is search supported at all.
parseSearchObjects(array $a_records, array $a_object_types)
Add object-data needed for global search to AMD search results.
getSearchQueryParserValue(ilADTSearchBridge $a_adt_search)
Get value for search query parser.
getFieldId()
Get field_id.
getDescription()
Get description.
getADTDefinition()
Get ADT definition instance.
getRecordId()
Get record id.
toXML(ilXmlWriter $a_writer)
To Xml.
importDefinitionFormPostValues(ilPropertyFormGUI $a_form, ilAdvancedMDPermissionHelper $a_permissions)
Import post values from definition form.
static getValidTypes()
Get all valid types.
getFieldDefinition()
Get (type-specific) field definition.
setFieldId($a_id)
Set field_id.
read($a_field_id)
Read field definition.
addToFieldDefinitionForm(ilPropertyFormGUI $a_form, ilAdvancedMDPermissionHelper $a_permissions)
Add input elements to definition form.
getFieldDefinitionForTableGUI()
Parse properties for table gui.
setDescription($a_desc)
Set description.
getDBProperties()
Get all definition properties for DB.
searchSubObjects(ilADTSearchBridge $a_adt_search, $a_obj_id, $sub_obj_type)
setSearchValueSerialized(ilADTSearchBridge $a_adt_search, $a_value)
Set value from search persistence.
static getTypeString($a_type)
Get type string.
setSearchable($a_status)
Toggle searchable.
generateImportId($a_field_id)
Generate unique record id.
getPosition()
Get position.
_clone($a_new_record_id)
Clone field definition.
importValueFromXML($a_cdata)
Import value from xml.
prepareElementForSearch(ilADTSearchBridge $a_bridge)
Prepare search form elements.
static getSearchableDefinitionIds()
Get searchable definition ids (performance is key)
getADT()
Get ADT instance.
isFilterSupported()
Is search by filter supported.
importDefinitionFormPostValuesNeedsConfirmation()
searchObjects(ilADTSearchBridge $a_adt_search, ilQueryParser $a_parser, array $a_object_types, $a_locate, $a_search_type)
Search objects.
prepareElementForEditor(ilADTFormBridge $a_bridge)
Prepare editor form elements.
prepareDefinitionFormConfirmation(ilPropertyFormGUI $a_form)
isSearchable()
Is searchable.
static getInstancesByRecordId($a_record_id, $a_only_searchable=false)
Get definitions by record id.
prepareCustomDefinitionFormConfirmation(ilPropertyFormGUI $a_form)
setPosition($a_pos)
Set position.
__construct($a_field_id=null)
Constructor.
save($a_keep_pos=false)
Create new field entry.
getValueForXML(ilADT $element)
Parse ADT value for xml (export)
static isValidType($a_type)
Is given type valid.
getTypeTitle()
Get type title (lang id)
addCustomFieldToDefinitionForm(ilPropertyFormGUI $a_form, $a_disabled=false)
Add custom input elements to definition form.
importCustomDefinitionFormPostValues(ilPropertyFormGUI $a_form)
Import custom post values from definition form.
Advanced metadata permission helper.
const SUBACTION_FIELD_SEARCHABLE
const SUBACTION_FIELD_DESCRIPTION
const ACTION_FIELD_EDIT_PROPERTY
const SUBACTION_FIELD_PROPERTIES
const SUBACTION_FIELD_TITLE
static _deleteByFieldId($a_field_id, ilADT $a_adt)
Delete values by field_id.
hasPermission($a_context_type, $a_context_id, $a_action_id, $a_action_sub_id=null)
Check permission.
hasPermissions($a_context_type, $a_context_id, array $a_action_ids)
Check permissions.
Base class for ILIAS Exception handling.
This class represents a text area property in a property form.
This class represents a text property in a property form.
xmlEndTag($tag)
Writes an endtag.
xmlElement($tag, $attrs=null, $data=null, $encode=true, $escape=true)
Writes a basic element (no children, just textual content)
xmlStartTag($tag, $attrs=null, $empty=false, $encode=true, $escape=true)
Writes a starttag.
foreach($_POST as $key=> $value) $res