[ 'layout' => [ 'basic' => [ 'name', [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, 'readonly' => false, ], ], 'date_entered' => [ 'name' => 'date_entered', 'width' => '', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'created_by_name' => [ 'name' => 'created_by_name', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'date_modified' => [ 'name' => 'date_modified', 'width' => '', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'created_by' => [ 'name' => 'created_by', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'description' => [ 'name' => 'description', 'width' => '', 'label' => 'LBL_DESCRIPTION', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'text', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_DELETED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, 'readonly' => false, ], ], 'created_by_link' => [ 'name' => 'created_by_link', 'width' => '', 'label' => 'LBL_CREATED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'fp_event_locations_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'width' => '', 'label' => 'LBL_MODIFIED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'width' => '', 'label' => 'LBL_SECURITYGROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_fp_event_locations', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], 'readonly' => false, ], ], 'fp_event_locations_fp_events_1' => [ 'name' => 'fp_event_locations_fp_events_1', 'width' => '', 'label' => 'LBL_FP_EVENT_LOCATIONS_FP_EVENTS_1_FROM_FP_EVENTS_TITLE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'fp_event_locations_fp_events_1', 'type' => 'link', 'relationship' => 'fp_event_locations_fp_events_1', 'source' => 'non-db', 'side' => 'right', 'vname' => 'LBL_FP_EVENT_LOCATIONS_FP_EVENTS_1_FROM_FP_EVENTS_TITLE', 'required' => false, 'module' => 'FP_events', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'fp_event_locations_fp_events_1fp_events_idb', 'type' => 'many-to-many', 'parent_id' => 'fp_event_locations_fp_events_1fp_event_locations_ida', ], 'readonly' => false, ], ], 'address' => [ 'name' => 'address', 'width' => '', 'label' => 'LBL_ADDRESS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address', 'vname' => 'LBL_ADDRESS', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => 'Location address', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'address_city' => [ 'name' => 'address_city', 'width' => '', 'label' => 'LBL_ADDRESS_CITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'address_country' => [ 'name' => 'address_country', 'width' => '', 'label' => 'LBL_ADDRESS_COUNTRY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'address_postalcode' => [ 'name' => 'address_postalcode', 'width' => '', 'label' => 'LBL_ADDRESS_POSTALCODE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address_postalcode', 'vname' => 'LBL_ADDRESS_POSTALCODE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '20', 'size' => '20', 'readonly' => false, ], ], 'address_state' => [ 'name' => 'address_state', 'width' => '', 'label' => 'LBL_ADDRESS_STATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'address_state', 'vname' => 'LBL_ADDRESS_STATE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'capacity' => [ 'name' => 'capacity', 'width' => '', 'label' => 'LBL_CAPACITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'capacity', 'vname' => 'LBL_CAPACITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => 'The maximum amount of people the location can cater for.', 'help' => 'The capacity of the event location', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], ], 'advanced' => [ 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'assigned_user_id-group' => [ 'name' => 'assigned_user_id-group', 'label' => 'LBL_ASSIGNED_TO', 'type' => 'grouped-field', 'function' => [ 'name' => 'get_user_array', 'params' => [ false, ], ], 'fieldDefinition' => [ 'layout' => [ 'assigned_user_name', ], 'display' => 'inline', 'type' => 'grouped-field', 'groupKey' => 'assigned_user', 'groupFields' => [ 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user', 'type' => 'id', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, 'showLabel' => [], 'display' => 'none', ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'showLabel' => [ '*', ], 'display' => 'inline', 'group' => 'assigned_user', ], ], 'readonly' => false, ], ], 'id' => [ 'name' => 'id', 'width' => '', 'label' => 'LBL_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'id', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, 'readonly' => false, ], ], 'date_entered' => [ 'name' => 'date_entered', 'width' => '', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'created_by_name' => [ 'name' => 'created_by_name', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'date_modified' => [ 'name' => 'date_modified', 'width' => '', 'label' => 'LBL_DATE_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'created_by' => [ 'name' => 'created_by', 'width' => '', 'label' => 'LBL_CREATED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'assigned_user_name', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, 'readonly' => false, ], ], 'description' => [ 'name' => 'description', 'width' => '', 'label' => 'LBL_DESCRIPTION', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'text', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_DELETED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, 'readonly' => false, ], ], 'created_by_link' => [ 'name' => 'created_by_link', 'width' => '', 'label' => 'LBL_CREATED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'fp_event_locations_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'width' => '', 'label' => 'LBL_MODIFIED_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'width' => '', 'label' => 'LBL_ASSIGNED_TO_USER', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], 'readonly' => false, ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'width' => '', 'label' => 'LBL_SECURITYGROUPS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_fp_event_locations', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], 'readonly' => false, ], ], 'fp_event_locations_fp_events_1' => [ 'name' => 'fp_event_locations_fp_events_1', 'width' => '', 'label' => 'LBL_FP_EVENT_LOCATIONS_FP_EVENTS_1_FROM_FP_EVENTS_TITLE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'fp_event_locations_fp_events_1', 'type' => 'link', 'relationship' => 'fp_event_locations_fp_events_1', 'source' => 'non-db', 'side' => 'right', 'vname' => 'LBL_FP_EVENT_LOCATIONS_FP_EVENTS_1_FROM_FP_EVENTS_TITLE', 'required' => false, 'module' => 'FP_events', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'fp_event_locations_fp_events_1fp_events_idb', 'type' => 'many-to-many', 'parent_id' => 'fp_event_locations_fp_events_1fp_event_locations_ida', ], 'readonly' => false, ], ], 'address' => [ 'name' => 'address', 'width' => '', 'label' => 'LBL_ADDRESS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address', 'vname' => 'LBL_ADDRESS', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => 'Location address', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'address_city' => [ 'name' => 'address_city', 'width' => '', 'label' => 'LBL_ADDRESS_CITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'address_country' => [ 'name' => 'address_country', 'width' => '', 'label' => 'LBL_ADDRESS_COUNTRY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'address_postalcode' => [ 'name' => 'address_postalcode', 'width' => '', 'label' => 'LBL_ADDRESS_POSTALCODE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => true, 'name' => 'address_postalcode', 'vname' => 'LBL_ADDRESS_POSTALCODE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '20', 'size' => '20', 'readonly' => false, ], ], 'address_state' => [ 'name' => 'address_state', 'width' => '', 'label' => 'LBL_ADDRESS_STATE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'address_state', 'vname' => 'LBL_ADDRESS_STATE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', 'readonly' => false, ], ], 'capacity' => [ 'name' => 'capacity', 'width' => '', 'label' => 'LBL_CAPACITY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'required' => false, 'name' => 'capacity', 'vname' => 'LBL_CAPACITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => 'The maximum amount of people the location can cater for.', 'help' => 'The capacity of the event location', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'readonly' => false, ], ], 'current_user_only' => [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', 'fieldDefinition' => [ 'displayType' => 'checkbox', 'readonly' => false, ], ], ], ], ], 'mass_update' => [ 'fields' => [ [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], 'listview' => [ 'columns' => [ [ 'name' => 'date_entered', 'width' => '10%', 'label' => 'LBL_DATE_ENTERED', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'datetime', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], ], [ 'name' => 'name', 'width' => '32%', 'label' => 'LBL_NAME', 'link' => true, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'name', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ], ], [ 'name' => 'capacity', 'width' => '10%', 'label' => 'LBL_CAPACITY', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'required' => false, 'name' => 'capacity', 'vname' => 'LBL_CAPACITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => 'The maximum amount of people the location can cater for.', 'help' => 'The capacity of the event location', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', ], ], [ 'name' => 'assigned_user_name', 'width' => '9%', 'label' => 'LBL_ASSIGNED_TO_NAME', 'link' => false, 'default' => true, 'module' => 'Employees', 'id' => 'ASSIGNED_USER_ID', 'sortable' => true, 'type' => 'relate', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], ], ], 'bulkActions' => [ 'delete' => [ 'key' => 'delete', 'labelKey' => 'LBL_DELETE', 'params' => [ 'min' => 1, 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_DELETE_CONFIRMATION_MULTIPLE', ], 'acl' => [ 'delete', ], ], 'export' => [ 'key' => 'export', 'labelKey' => 'LBL_EXPORT', 'params' => [ 'min' => 1, ], 'acl' => [ 'export', ], ], 'merge' => [ 'key' => 'merge', 'labelKey' => 'LBL_MERGE_DUPLICATES', 'params' => [ 'min' => 2, 'max' => 5, ], 'acl' => [ 'edit', 'delete', ], ], 'massupdate' => [ 'key' => 'massupdate', 'labelKey' => 'LBL_MASS_UPDATE', 'params' => [ 'allowAll' => false, 'min' => 2, 'max' => 200, 'recordPanel' => [ 'title' => 'LBL_MASS_UPDATE', 'mode' => 'massupdate', 'actions' => [ [ 'key' => 'cancel', 'labelKey' => 'LBL_CANCEL', 'modes' => [ 'massupdate', ], ], [ 'key' => 'bulk-action', 'labelKey' => 'LBL_SUBMIT_BUTTON_LABEL', 'modes' => [ 'massupdate', ], 'klass' => [ 'btn', 'btn-danger', 'btn-sm', ], 'params' => [ 'allowAll' => false, 'min' => 2, 'max' => 200, 'bulkAction' => 'massupdate', 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_BULK_ACTION_MASS_UPDATE_CONFIRMATION', ], ], ], 'fields' => [ [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO_NAME', 'fieldDefinition' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], ], 'acl' => [ 'massupdate', ], 'availability' => [ 'acls', 'massupdate', ], ], ], 'lineActions' => [], 'tableActions' => [ [ 'key' => 'select-columns', 'icon' => 'column_chooser', 'titleKey' => 'LBL_COLUMNS', 'params' => [ 'expanded' => true, ], 'modes' => [ 'list', ], 'klass' => [ 'column-chooser-button', ], ], ], 'availableFilters' => [], 'sidebarWidgets' => [], 'paginationType' => null, 'maxHeight' => null, ], 'subpanel' => [], 'recordview' => [ 'templateMeta' => [ 'maxColumns' => '2', 'useTabs' => false, 'tabDefs' => [ 'DEFAULT' => [ 'newTab' => false, 'panelDefault' => 'expanded', ], 'LBL_EDITVIEW_PANEL1' => [ 'newTab' => false, 'panelDefault' => 'expanded', ], ], ], 'topWidget' => [ 'refreshOn' => 'data-update', ], 'sidebarWidgets' => [], 'bottomWidgets' => [], 'actions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT', 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', ], 'acl' => [ 'edit', ], ], [ 'key' => 'save', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveNew', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], 'acl' => [ 'edit', ], ], [ 'key' => 'cancel', 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], ], [ 'key' => 'cancelCreate', 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], ], [ 'key' => 'saveContinue', 'labelKey' => 'LBL_SAVE_CONTINUE_LABEL', 'params' => [ 'expanded' => true, 'collapsedMobile' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'delete', 'labelKey' => 'LBL_DELETE', 'asyncProcess' => true, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_DELETE_CONFIRMATION', ], 'modes' => [ 'detail', ], 'acl' => [ 'delete', ], ], [ 'key' => 'duplicate', 'labelKey' => 'LBL_DUPLICATE_BUTTON', 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', ], 'acl' => [ 'export', 'edit', ], ], [ 'key' => 'audit', 'labelKey' => 'LNK_VIEW_CHANGE_LOG', 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', 'edit', ], 'availability' => [ 'audited', 'acls', ], ], [ 'key' => 'duplicate-merge', 'labelKey' => 'LBL_DUP_MERGE', 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', 'edit', ], 'availability' => [ 'duplicate-merge', 'acls', ], 'acl' => [ 'edit', 'delete', ], ], ], 'panels' => [ [ 'key' => 'default', 'rows' => [ [ 'cols' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ], 'type' => 'name', ], [ 'name' => 'date_entered', 'label' => 'LBL_DATE_ENTERED', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'type' => 'datetime', ], ], ], [ 'cols' => [ [ 'name' => 'description', 'label' => 'LBL_DESCRIPTION', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'type' => 'text', ], [ 'name' => 'capacity', 'label' => 'LBL_CAPACITY', 'fieldDefinition' => [ 'required' => false, 'name' => 'capacity', 'vname' => 'LBL_CAPACITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => 'The maximum amount of people the location can cater for.', 'help' => 'The capacity of the event location', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', ], 'type' => 'varchar', ], ], ], ], ], [ 'key' => 'lbl_editview_panel1', 'rows' => [ [ 'cols' => [ [ 'name' => 'address', 'label' => 'LBL_ADDRESS', 'fieldDefinition' => [ 'required' => true, 'name' => 'address', 'vname' => 'LBL_ADDRESS', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => 'Location address', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'address_city', 'label' => 'LBL_ADDRESS_CITY', 'fieldDefinition' => [ 'required' => true, 'name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'address_postalcode', 'label' => 'LBL_ADDRESS_POSTALCODE', 'fieldDefinition' => [ 'required' => true, 'name' => 'address_postalcode', 'vname' => 'LBL_ADDRESS_POSTALCODE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '20', 'size' => '20', ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'address_state', 'label' => 'LBL_ADDRESS_STATE', 'fieldDefinition' => [ 'required' => false, 'name' => 'address_state', 'vname' => 'LBL_ADDRESS_STATE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'address_country', 'label' => 'LBL_ADDRESS_COUNTRY', 'fieldDefinition' => [ 'required' => false, 'name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'type' => 'varchar', ], ], ], ], ], ], 'summaryTemplates' => [ 'create' => 'LBL_CREATE', 'edit' => 'LBL_SUMMARY_DEFAULT', 'detail' => 'LBL_SUMMARY_DEFAULT', ], 'vardefs' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'created_by_name' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, 'required' => false, ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, 'required' => false, ], 'description' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', 'required' => false, ], 'created_by_link' => [ 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'fp_event_locations_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'modified_user_link' => [ 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'assigned_user_id' => [ 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_name' => [ 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'full_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'assigned_user_link' => [ 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'fp_event_locations_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => '', 'type' => 'one-to-many', 'parent_id' => '', ], ], 'SecurityGroups' => [ 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_fp_event_locations', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', 'required' => false, 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'securitygroup_id', 'type' => 'many-to-many', 'parent_id' => 'record_id', ], ], 'fp_event_locations_fp_events_1' => [ 'name' => 'fp_event_locations_fp_events_1', 'type' => 'link', 'relationship' => 'fp_event_locations_fp_events_1', 'source' => 'non-db', 'side' => 'right', 'vname' => 'LBL_FP_EVENT_LOCATIONS_FP_EVENTS_1_FROM_FP_EVENTS_TITLE', 'required' => false, 'module' => 'FP_events', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'fp_event_locations_fp_events_1fp_events_idb', 'type' => 'many-to-many', 'parent_id' => 'fp_event_locations_fp_events_1fp_event_locations_ida', ], ], 'address' => [ 'required' => true, 'name' => 'address', 'vname' => 'LBL_ADDRESS', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => '', 'help' => 'Location address', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', ], 'address_city' => [ 'required' => true, 'name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'address_country' => [ 'required' => false, 'name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'address_postalcode' => [ 'required' => true, 'name' => 'address_postalcode', 'vname' => 'LBL_ADDRESS_POSTALCODE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '20', 'size' => '20', ], 'address_state' => [ 'required' => false, 'name' => 'address_state', 'vname' => 'LBL_ADDRESS_STATE', 'type' => 'varchar', 'massupdate' => '0', 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '100', 'size' => '20', ], 'capacity' => [ 'required' => false, 'name' => 'capacity', 'vname' => 'LBL_CAPACITY', 'type' => 'varchar', 'massupdate' => '0', 'default' => '', 'no_default' => false, 'comments' => 'The maximum amount of people the location can cater for.', 'help' => 'The capacity of the event location', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', ], ], 'metadata' => [], ], ]];