[ 'layout' => [ 'basic' => [ 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_PROSPECT_LIST_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'current_user_only' => [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', ], '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' => 'prospectlists_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_prospectlists', '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, ], ], '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' => false, 'readonly' => false, ], ], 'list_type' => [ 'name' => 'list_type', 'width' => '', 'label' => 'LBL_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], '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', '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', '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' => 'modified_user_id_users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'required' => false, 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', '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' => 'created_by', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'created_by_users', 'isnull' => 'false', 'dbType' => 'id', 'required' => false, '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, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_CREATED_BY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_CREATED_BY', 'type' => 'bool', 'required' => false, 'reportable' => 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', 'required' => false, 'readonly' => false, ], ], 'domain_name' => [ 'name' => 'domain_name', 'width' => '', 'label' => 'LBL_DOMAIN_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'domain_name', 'vname' => 'LBL_DOMAIN_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, 'readonly' => false, ], ], 'entry_count' => [ 'name' => 'entry_count', 'width' => '', 'label' => 'LBL_LIST_ENTRIES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'entry_count', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_ENTRIES', 'required' => false, 'readonly' => false, ], ], 'prospects' => [ 'name' => 'prospects', 'width' => '', 'label' => 'LBL_PROSPECTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'prospects', 'vname' => 'LBL_PROSPECTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_prospects', 'source' => 'non-db', 'required' => false, 'module' => 'Prospects', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'contacts' => [ 'name' => 'contacts', 'width' => '', 'label' => 'LBL_CONTACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_contacts', 'source' => 'non-db', 'required' => false, 'module' => 'Contacts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'leads' => [ 'name' => 'leads', 'width' => '', 'label' => 'LBL_LEADS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'leads', 'vname' => 'LBL_LEADS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_leads', 'source' => 'non-db', 'required' => false, 'module' => 'Leads', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'width' => '', 'label' => 'LBL_ACCOUNTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_accounts', 'source' => 'non-db', 'required' => false, 'module' => 'Accounts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'campaigns' => [ 'name' => 'campaigns', 'width' => '', 'label' => 'LBL_CAMPAIGNS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'campaigns', 'vname' => 'LBL_CAMPAIGNS', 'type' => 'link', 'relationship' => 'prospect_list_campaigns', 'source' => 'non-db', 'required' => false, 'module' => 'Campaigns', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'campaign_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'users' => [ 'name' => 'users', 'width' => '', 'label' => 'LBL_USERS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'users', 'vname' => 'LBL_USERS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_users', 'source' => 'non-db', 'required' => false, 'module' => 'Users', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'email_marketing' => [ 'name' => 'email_marketing', 'width' => '', 'label' => 'LBL_EMAIL_MARKETING', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'email_marketing', 'vname' => 'LBL_EMAIL_MARKETING', 'type' => 'link', 'relationship' => 'email_marketing_prospect_lists', 'source' => 'non-db', 'required' => false, 'module' => 'EmailMarketing', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_marketing_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'width' => '', 'label' => 'LBL_MARKETING_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'type' => 'varchar', 'len' => '36', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], ], 'marketing_name' => [ 'name' => 'marketing_name', 'width' => '', 'label' => 'LBL_MARKETING_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_name', 'vname' => 'LBL_MARKETING_NAME', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], ], ], 'advanced' => [ 'name' => [ 'name' => 'name', 'width' => '', 'label' => 'LBL_PROSPECT_LIST_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => false, 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'list_type' => [ 'name' => 'list_type', 'width' => '', 'label' => 'LBL_LIST_TYPE', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SuiteCRMEmptyString__', 'labelKey' => 'LBL_EMPTY', ], ], ], 'readonly' => false, ], 'vardefBased' => false, 'readonly' => false, ], 'current_user_only' => [ 'name' => 'current_user_only', 'label' => 'LBL_CURRENT_USER_FILTER', 'type' => 'bool', 'fieldDefinition' => [ 'displayType' => 'checkbox', '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' => 'prospectlists_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_prospectlists', '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, ], ], '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' => 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', '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', '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' => 'modified_user_id_users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'required' => false, 'readonly' => false, ], ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'width' => '', 'label' => 'LBL_MODIFIED', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'relate', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', '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' => 'created_by', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'created_by_users', 'isnull' => 'false', 'dbType' => 'id', 'required' => false, '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, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, 'readonly' => false, ], ], 'deleted' => [ 'name' => 'deleted', 'width' => '', 'label' => 'LBL_CREATED_BY', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'bool', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'deleted', 'vname' => 'LBL_CREATED_BY', 'type' => 'bool', 'required' => false, 'reportable' => 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', 'required' => false, 'readonly' => false, ], ], 'domain_name' => [ 'name' => 'domain_name', 'width' => '', 'label' => 'LBL_DOMAIN_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'domain_name', 'vname' => 'LBL_DOMAIN_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, 'readonly' => false, ], ], 'entry_count' => [ 'name' => 'entry_count', 'width' => '', 'label' => 'LBL_LIST_ENTRIES', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'int', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'entry_count', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_ENTRIES', 'required' => false, 'readonly' => false, ], ], 'prospects' => [ 'name' => 'prospects', 'width' => '', 'label' => 'LBL_PROSPECTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'prospects', 'vname' => 'LBL_PROSPECTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_prospects', 'source' => 'non-db', 'required' => false, 'module' => 'Prospects', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'contacts' => [ 'name' => 'contacts', 'width' => '', 'label' => 'LBL_CONTACTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_contacts', 'source' => 'non-db', 'required' => false, 'module' => 'Contacts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'leads' => [ 'name' => 'leads', 'width' => '', 'label' => 'LBL_LEADS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'leads', 'vname' => 'LBL_LEADS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_leads', 'source' => 'non-db', 'required' => false, 'module' => 'Leads', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'accounts' => [ 'name' => 'accounts', 'width' => '', 'label' => 'LBL_ACCOUNTS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_accounts', 'source' => 'non-db', 'required' => false, 'module' => 'Accounts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'campaigns' => [ 'name' => 'campaigns', 'width' => '', 'label' => 'LBL_CAMPAIGNS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'campaigns', 'vname' => 'LBL_CAMPAIGNS', 'type' => 'link', 'relationship' => 'prospect_list_campaigns', 'source' => 'non-db', 'required' => false, 'module' => 'Campaigns', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'campaign_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'users' => [ 'name' => 'users', 'width' => '', 'label' => 'LBL_USERS', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'users', 'vname' => 'LBL_USERS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_users', 'source' => 'non-db', 'required' => false, 'module' => 'Users', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'email_marketing' => [ 'name' => 'email_marketing', 'width' => '', 'label' => 'LBL_EMAIL_MARKETING', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'link', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'email_marketing', 'vname' => 'LBL_EMAIL_MARKETING', 'type' => 'link', 'relationship' => 'email_marketing_prospect_lists', 'source' => 'non-db', 'required' => false, 'module' => 'EmailMarketing', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_marketing_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], 'readonly' => false, ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'width' => '', 'label' => 'LBL_MARKETING_ID', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'type' => 'varchar', 'len' => '36', 'source' => 'non-db', 'required' => false, 'readonly' => false, ], ], 'marketing_name' => [ 'name' => 'marketing_name', 'width' => '', 'label' => 'LBL_MARKETING_NAME', 'link' => false, 'default' => false, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'vardefBased' => true, 'display' => 'none', 'readonly' => true, 'fieldDefinition' => [ 'name' => 'marketing_name', 'vname' => 'LBL_MARKETING_NAME', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, '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', ], [ 'name' => 'list_type', 'label' => 'LBL_TYPE', 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, ], 'type' => 'enum', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SugarMassUpdateClearField__', 'labelKey' => 'LBL_EMPTY', ], ], ], ], [ 'name' => 'created_by_name', 'label' => 'LBL_CREATED', 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], 'listview' => [ 'columns' => [ [ 'name' => 'name', 'width' => '25', 'label' => 'LBL_LIST_PROSPECT_LIST_NAME', 'link' => true, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'varchar', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => false, ], ], [ 'name' => 'list_type', 'width' => '15', 'label' => 'LBL_LIST_TYPE_LIST_NAME', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'enum', 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, ], ], [ 'name' => 'description', 'width' => '40', 'label' => 'LBL_LIST_DESCRIPTION', 'link' => false, 'default' => true, 'module' => '', 'id' => '', 'sortable' => true, 'type' => 'text', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'required' => false, ], ], [ 'name' => 'assigned_user_name', 'width' => '10', 'label' => 'LBL_LIST_ASSIGNED_USER', '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, ], ], [ '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', '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, 'confirmationMessages' => [ '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', ], [ 'name' => 'list_type', 'label' => 'LBL_TYPE', 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, ], 'type' => 'enum', 'metadata' => [ 'extraOptions' => [ [ 'value' => '__SugarMassUpdateClearField__', 'labelKey' => 'LBL_EMPTY', ], ], ], ], [ 'name' => 'created_by_name', 'label' => 'LBL_CREATED', 'fieldDefinition' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'type' => 'relate', ], ], ], ], 'acl' => [ 'massupdate', ], 'availability' => [ 'acls', 'massupdate', ], ], ], 'lineActions' => [], 'tableActions' => [ 'select-columns' => [ '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' => [ 'prospects' => [ 'order' => 10, 'sort_by' => 'last_name', 'sort_order' => 'asc', 'module' => 'prospects', 'subpanel_name' => 'default', 'get_subpanel_data' => 'prospects', 'title_key' => 'LBL_PROSPECTS_SUBPANEL_TITLE', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'prospectlist_id' => 'id', 'prospect_list_id' => 'id', 'prospectlist_name' => 'name', 'return_name' => 'name', 'prospect_list_prospects_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'prospects', 'return_module' => 'ProspectLists', 'return_relationship' => 'prospect_list_prospects', 'parent_type' => 'ProspectLists', ], 'widget_class' => 'SubPanelTopButtonQuickCreate', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Prospects', 'name' => 'prospects', 'legacyModule' => 'Prospects', 'headerModule' => 'prospects', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Prospects', ], [ 'labelKey' => 'LBL_PROSPECTS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'prospects', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'prospects', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'full_name', 'label' => 'LBL_LIST_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '40%', 'sort_by' => 'last_name', 'link' => true, 'fieldDefinition' => [ 'name' => 'full_name', 'rname' => 'full_name', 'vname' => 'LBL_NAME', 'type' => 'grouped-field', 'fields' => [ 'first_name', 'last_name', ], 'sort_on' => 'last_name', 'source' => 'non-db', 'group' => 'last_name', 'len' => '510', 'db_concat_fields' => [ 'first_name', 'last_name', ], 'studio' => [ 'listview' => false, ], 'required' => false, 'layout' => [ 'salutation', 'first_name', 'last_name', ], 'display' => 'inline', 'showLabel' => [ 'edit' => [ 'first_name', 'last_name', ], 'filter' => [ '*', ], ], 'groupFields' => [ 'salutation' => [ 'name' => 'salutation', 'vname' => 'LBL_SALUTATION', 'type' => 'enum', 'options' => 'salutation_dom', 'massupdate' => false, 'len' => '255', 'comment' => 'Contact salutation (e.g., Mr, Ms)', 'required' => false, ], 'first_name' => [ 'name' => 'first_name', 'vname' => 'LBL_FIRST_NAME', 'type' => 'varchar', 'len' => '100', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'comment' => 'First name of the contact', 'merge_filter' => 'selected', 'required' => false, ], 'last_name' => [ 'name' => 'last_name', 'vname' => 'LBL_LAST_NAME', 'type' => 'varchar', 'len' => '100', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'comment' => 'Last name of the contact', 'merge_filter' => 'selected', 'required' => true, 'importable' => 'required', ], ], ], 'type' => 'grouped-field', ], [ 'name' => 'title', 'label' => 'LBL_LIST_TITLE', 'sortable' => true, 'vname' => 'LBL_LIST_TITLE', 'width' => '25%', 'fieldDefinition' => [ 'name' => 'title', 'vname' => 'LBL_TITLE', 'type' => 'varchar', 'len' => '100', 'comment' => 'The title of the contact', 'required' => false, ], 'type' => 'varchar', ], [ 'name' => 'email1', 'label' => 'LBL_LIST_EMAIL_ADDRESS', 'sortable' => false, 'vname' => 'LBL_LIST_EMAIL_ADDRESS', 'width' => '15%', 'widget_class' => 'SubPanelEmailLink', 'fieldDefinition' => [ 'name' => 'email1', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => [ 'name' => 'getEmailAddressWidget', 'returns' => 'html', ], 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled', 'studio' => [ 'editview' => true, 'editField' => true, 'searchview' => false, 'popupsearch' => false, ], 'full_text_search' => [ 'boost' => 3, 'analyzer' => 'whitespace', ], 'required' => false, ], 'type' => 'email', ], [ 'name' => 'phone_work', 'label' => 'LBL_LIST_PHONE', 'sortable' => true, 'vname' => 'LBL_LIST_PHONE', 'width' => '10%', 'fieldDefinition' => [ 'name' => 'phone_work', 'vname' => 'LBL_OFFICE_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'len' => 100, 'audited' => true, 'unified_search' => true, 'full_text_search' => [ 'boost' => 1, ], 'comment' => 'Work phone number of the contact', 'merge_filter' => 'enabled', 'required' => false, ], 'type' => 'phone', ], ], ], 'contacts' => [ 'order' => 20, 'module' => 'contacts', 'sort_by' => 'last_name, first_name', 'sort_order' => 'asc', 'subpanel_name' => 'default', 'get_subpanel_data' => 'contacts', 'title_key' => 'LBL_CONTACTS_SUBPANEL_TITLE', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'prospectlist_id' => 'id', 'prospect_list_id' => 'id', 'prospectlist_name' => 'name', 'return_name' => 'name', 'prospect_list_contacts_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'contacts', 'return_module' => 'ProspectLists', 'return_relationship' => 'prospect_list_contacts', 'parent_type' => 'ProspectLists', ], 'widget_class' => 'SubPanelTopButtonQuickCreate', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Contacts', 'name' => 'contacts', 'legacyModule' => 'Contacts', 'headerModule' => 'contacts', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Contacts', ], [ 'labelKey' => 'LBL_CONTACTS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'contacts', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'contacts', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'name', 'label' => 'LBL_LIST_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_NAME', 'sort_by' => 'last_name', 'sort_order' => 'asc', 'widget_class' => 'SubPanelDetailViewLink', 'module' => 'Contacts', 'width' => '23%', 'link' => true, 'fieldDefinition' => [ 'name' => 'name', 'rname' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'fields' => [ 'first_name', 'last_name', ], 'sort_on' => 'last_name', 'source' => 'non-db', 'group' => 'last_name', 'len' => '255', 'db_concat_fields' => [ 'first_name', 'last_name', ], 'importable' => 'false', 'required' => false, ], 'type' => 'name', ], [ 'name' => 'account_name', 'label' => 'LBL_LIST_ACCOUNT_NAME', 'sortable' => true, 'module' => 'Accounts', 'target_record_key' => 'account_id', 'target_module' => 'Accounts', 'widget_class' => 'SubPanelDetailViewLink', 'vname' => 'LBL_LIST_ACCOUNT_NAME', 'width' => '22%', 'link' => true, 'fieldDefinition' => [ 'name' => 'account_name', 'rname' => 'name', 'id_name' => 'account_id', 'vname' => 'LBL_ACCOUNT_NAME', 'join_name' => 'accounts', 'type' => 'relate', 'link' => 'accounts', 'table' => 'accounts', 'isnull' => 'true', 'module' => 'Accounts', 'dbType' => 'varchar', 'len' => '255', 'source' => 'non-db', 'unified_search' => true, 'required' => false, ], 'type' => 'relate', ], [ 'name' => 'email1', 'label' => 'LBL_LIST_EMAIL', 'sortable' => true, 'vname' => 'LBL_LIST_EMAIL', 'widget_class' => 'SubPanelEmailLink', 'width' => '30%', 'fieldDefinition' => [ 'name' => 'email1', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => [ 'name' => 'getEmailAddressWidget', 'returns' => 'html', ], 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'disabled', 'studio' => [ 'editview' => true, 'editField' => true, 'searchview' => false, 'popupsearch' => false, ], 'full_text_search' => [ 'boost' => 3, 'analyzer' => 'whitespace', ], 'required' => true, 'inline_edit' => true, ], 'type' => 'email', ], [ 'name' => 'phone_work', 'label' => 'LBL_LIST_PHONE', 'sortable' => true, 'vname' => 'LBL_LIST_PHONE', 'width' => '15%', 'fieldDefinition' => [ 'name' => 'phone_work', 'vname' => 'LBL_OFFICE_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'len' => 100, 'audited' => true, 'unified_search' => true, 'full_text_search' => [ 'boost' => 1, ], 'comment' => 'Work phone number of the contact', 'merge_filter' => 'disabled', 'required' => true, 'inline_edit' => true, 'comments' => 'Work phone number of the contact', ], 'type' => 'phone', ], ], ], 'leads' => [ 'order' => 30, 'module' => 'leads', 'sort_by' => 'last_name, first_name', 'sort_order' => 'asc', 'subpanel_name' => 'default', 'get_subpanel_data' => 'leads', 'title_key' => 'LBL_LEADS_SUBPANEL_TITLE', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'prospectlist_id' => 'id', 'prospect_list_id' => 'id', 'prospectlist_name' => 'name', 'return_name' => 'name', 'prospect_list_leads_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'leads', 'return_module' => 'ProspectLists', 'return_relationship' => 'prospect_list_leads', 'parent_type' => 'ProspectLists', ], 'widget_class' => 'SubPanelTopButtonQuickCreate', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Leads', 'name' => 'leads', 'legacyModule' => 'Leads', 'headerModule' => 'leads', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Leads', ], [ 'labelKey' => 'LBL_LEADS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'leads', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'leads', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'name', 'label' => 'LBL_LIST_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'sort_order' => 'asc', 'sort_by' => 'last_name', 'module' => 'Leads', 'width' => '20%', 'link' => true, 'fieldDefinition' => [ 'name' => 'name', 'rname' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'fields' => [ 'first_name', 'last_name', ], 'sort_on' => 'last_name', 'source' => 'non-db', 'group' => 'last_name', 'len' => '255', 'db_concat_fields' => [ 'first_name', 'last_name', ], 'importable' => 'false', 'required' => false, ], 'type' => 'name', ], [ 'name' => 'refered_by', 'label' => 'LBL_LIST_REFERED_BY', 'sortable' => true, 'vname' => 'LBL_LIST_REFERED_BY', 'width' => '13%', 'fieldDefinition' => [ 'name' => 'refered_by', 'vname' => 'LBL_REFERED_BY', 'type' => 'varchar', 'len' => '100', 'comment' => 'Identifies who refered the lead', 'merge_filter' => 'enabled', 'required' => false, ], 'type' => 'varchar', ], [ 'name' => 'lead_source', 'label' => 'LBL_LIST_LEAD_SOURCE', 'sortable' => true, 'vname' => 'LBL_LIST_LEAD_SOURCE', 'width' => '13%', 'fieldDefinition' => [ 'name' => 'lead_source', 'vname' => 'LBL_LEAD_SOURCE', 'type' => 'enum', 'options' => 'lead_source_dom', 'len' => '100', 'audited' => true, 'comment' => 'Lead source (ex: Web, print)', 'merge_filter' => 'enabled', 'required' => false, 'legacyGroup' => true, 'groupFields' => [ 'lead_source_description' => [ 'name' => 'lead_source_description', 'vname' => 'LBL_LEAD_SOURCE_DESCRIPTION', 'type' => 'text', 'group' => 'lead_source', 'comment' => 'Description of the lead source', 'required' => false, ], ], ], 'type' => 'enum', ], [ 'name' => 'phone_work', 'label' => 'LBL_LIST_PHONE', 'sortable' => true, 'vname' => 'LBL_LIST_PHONE', 'width' => '10%', 'fieldDefinition' => [ 'name' => 'phone_work', 'vname' => 'LBL_OFFICE_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'len' => 100, 'audited' => true, 'unified_search' => true, 'full_text_search' => [ 'boost' => 1, ], 'comment' => 'Work phone number of the contact', 'merge_filter' => 'enabled', 'required' => false, ], 'type' => 'phone', ], [ 'name' => 'email1', 'label' => 'LBL_LIST_EMAIL_ADDRESS', 'sortable' => false, 'vname' => 'LBL_LIST_EMAIL_ADDRESS', 'width' => '10%', 'widget_class' => 'SubPanelEmailLink', 'fieldDefinition' => [ 'name' => 'email1', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => [ 'name' => 'getEmailAddressWidget', 'returns' => 'html', ], 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled', 'studio' => [ 'editview' => true, 'editField' => true, 'searchview' => false, 'popupsearch' => false, ], 'full_text_search' => [ 'boost' => 3, 'analyzer' => 'whitespace', ], 'required' => false, ], 'type' => 'email', ], [ 'name' => 'lead_source_description', 'label' => 'LBL_LIST_LEAD_SOURCE_DESCRIPTION', 'sortable' => false, 'vname' => 'LBL_LIST_LEAD_SOURCE_DESCRIPTION', 'width' => '26%', 'fieldDefinition' => [ 'name' => 'lead_source_description', 'vname' => 'LBL_LEAD_SOURCE_DESCRIPTION', 'type' => 'text', 'group' => 'lead_source', 'comment' => 'Description of the lead source', 'required' => false, ], 'type' => 'text', ], [ 'name' => 'assigned_user_name', 'label' => 'LBL_LIST_ASSIGNED_TO_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_ASSIGNED_TO_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'target_record_key' => 'assigned_user_id', 'target_module' => 'Employees', 'link' => 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, ], 'type' => 'relate', ], ], ], 'users' => [ 'order' => 40, 'module' => 'users', 'sort_by' => 'name', 'sort_order' => 'asc', 'subpanel_name' => 'ForProspectLists', 'get_subpanel_data' => 'users', 'title_key' => 'LBL_USERS_SUBPANEL_TITLE', 'top_buttons' => [ [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Users', 'name' => 'users', 'legacyModule' => 'Users', 'headerModule' => 'users', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Users', ], [ 'labelKey' => 'LBL_USERS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'users', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'name', 'label' => 'LBL_LIST_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_NAME', 'target_module' => 'Employees', 'module' => 'Users', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '35%', 'link' => true, 'fieldDefinition' => [ 'name' => 'name', 'rname' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'source' => 'non-db', 'len' => '510', 'db_concat_fields' => [ 'first_name', 'last_name', ], 'importable' => 'false', 'required' => false, ], 'type' => 'varchar', ], [ 'name' => 'email1', 'label' => 'LBL_LIST_EMAIL', 'sortable' => true, 'vname' => 'LBL_LIST_EMAIL', 'widget_class' => 'SubPanelEmailLink', 'width' => '35%', 'fieldDefinition' => [ 'name' => 'email1', 'vname' => 'LBL_EMAIL', 'type' => 'varchar', 'function' => [ 'name' => 'getEmailAddressWidget', 'returns' => 'html', ], 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled', 'required' => true, ], 'type' => 'email', ], [ 'name' => 'phone_work', 'label' => 'LBL_LIST_PHONE', 'sortable' => true, 'vname' => 'LBL_LIST_PHONE', 'width' => '26%', 'fieldDefinition' => [ 'name' => 'phone_work', 'vname' => 'LBL_WORK_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'len' => '50', 'required' => false, ], 'type' => 'phone', ], ], ], 'accounts' => [ 'order' => 40, 'module' => 'accounts', 'sort_order' => 'asc', 'sort_by' => 'name', 'subpanel_name' => 'ForProspectLists', 'get_subpanel_data' => 'accounts', 'add_subpanel_data' => 'account_id', 'title_key' => 'LBL_ACCOUNTS_SUBPANEL_TITLE', 'top_buttons' => [ [ 'key' => 'create', 'labelKey' => 'LBL_QUICK_CREATE', 'action' => 'create', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [ 'prospectlist_id' => 'id', 'prospect_list_id' => 'id', 'prospectlist_name' => 'name', 'return_name' => 'name', 'prospect_list_accounts_name' => 'name', 'return_id' => 'id', 'parent_name' => 'name', 'parent_id' => 'id', ], 'extraParams' => [ 'target_module' => 'accounts', 'return_module' => 'ProspectLists', 'return_relationship' => 'prospect_list_accounts', 'parent_type' => 'ProspectLists', ], 'widget_class' => 'SubPanelTopButtonQuickCreate', 'relateFields' => [], ], [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'icon' => 'Accounts', 'name' => 'accounts', 'legacyModule' => 'Accounts', 'headerModule' => 'accounts', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'Accounts', ], [ 'labelKey' => 'LBL_ACCOUNTS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT_RECORD', 'action' => 'edit', 'icon' => 'edit', 'asyncProcess' => true, 'routing' => true, 'params' => null, 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'accounts', ], [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'accounts', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'name', 'label' => 'LBL_LIST_NAME', 'sortable' => true, 'vname' => 'LBL_LIST_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '25%', 'link' => true, 'fieldDefinition' => [ 'name' => 'name', 'type' => 'name', 'dbType' => 'varchar', 'vname' => 'LBL_NAME', 'len' => 150, 'comment' => 'Name of the Company', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'audited' => true, 'required' => true, 'importable' => 'required', 'merge_filter' => 'selected', ], 'type' => 'name', ], [ 'name' => 'phone_office', 'label' => 'LBL_LIST_PHONE', 'sortable' => true, 'vname' => 'LBL_LIST_PHONE', 'width' => '20%', 'fieldDefinition' => [ 'name' => 'phone_office', 'vname' => 'LBL_PHONE_OFFICE', 'type' => 'phone', 'dbType' => 'varchar', 'len' => '100', 'audited' => true, 'unified_search' => true, 'full_text_search' => [ 'boost' => 1, ], 'comment' => 'The office phone number', 'merge_filter' => 'disabled', 'required' => true, 'inline_edit' => true, 'comments' => 'The office phone number', 'legacyGroup' => true, 'groupFields' => [ 'phone_alternate' => [ 'name' => 'phone_alternate', 'vname' => 'LBL_PHONE_ALT', 'type' => 'phone', 'group' => 'phone_office', 'dbType' => 'varchar', 'len' => 100, 'unified_search' => true, 'full_text_search' => [ 'boost' => 1, ], 'comment' => 'An alternate phone number', 'merge_filter' => 'enabled', 'required' => false, ], ], ], 'type' => 'phone', ], [ 'name' => 'email1', 'label' => 'LBL_LIST_EMAIL', 'sortable' => true, 'vname' => 'LBL_LIST_EMAIL', 'widget_class' => 'SubPanelEmailLink', 'width' => '20%', 'fieldDefinition' => [ 'name' => 'email1', 'vname' => 'LBL_EMAIL', 'group' => 'email1', 'type' => 'varchar', 'function' => [ 'name' => 'getEmailAddressWidget', 'returns' => 'html', ], 'source' => 'non-db', 'studio' => [ 'editField' => true, 'searchview' => false, ], 'full_text_search' => [ 'boost' => 3, 'analyzer' => 'whitespace', ], 'required' => true, 'inline_edit' => true, 'merge_filter' => 'disabled', 'unified_search' => true, ], 'type' => 'email', ], [ 'name' => 'assigned_user_name', 'label' => 'LBL_ASSIGNED_TO', 'sortable' => true, 'vname' => 'LBL_ASSIGNED_TO', 'width' => '20%', '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', ], ], ], 'securitygroups' => [ 'top_buttons' => [ [ 'key' => 'select', 'labelKey' => 'LBL_LINK_UNLINK', 'action' => 'select', 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'additionalFields' => [], 'extraParams' => [], 'widget_class' => 'SubPanelTopSelectButton', ], ], 'order' => 900, 'sort_by' => 'name', 'sort_order' => 'asc', 'module' => 'security-groups', 'refresh_page' => 1, 'subpanel_name' => 'default', 'get_subpanel_data' => 'SecurityGroups', 'add_subpanel_data' => 'securitygroup_id', 'title_key' => 'LBL_SECURITYGROUPS_SUBPANEL_TITLE', 'icon' => 'SecurityGroups', 'name' => 'securitygroups', 'legacyModule' => 'SecurityGroups', 'headerModule' => 'security-groups', 'subpanelWidget' => [ 'type' => 'statistics', 'options' => [ 'subpanelWidget' => [ 'rows' => [ [ 'justify' => 'end', 'cols' => [ [ 'icon' => 'SecurityGroups', ], [ 'labelKey' => 'LBL_SECURITYGROUPS_SUBPANEL_TITLE', 'class' => 'sub-panel-banner-button-title', 'bold' => true, ], [ 'statistic' => 'default', 'class' => 'sub-panel-banner-value', 'bold' => true, ], ], ], ], ], ], ], 'lineActions' => [ [ 'key' => 'unlink', 'labelKey' => 'LBL_UNLINK_RECORD', 'action' => 'unlink', 'icon' => 'unlink', 'asyncProcess' => true, 'routing' => false, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'LBL_UNLINK_RELATIONSHIP_CONFIRM', ], 'modes' => [ 'list', ], 'acl' => [ 'edit', ], 'module' => 'security-groups', ], ], 'searchdefs' => null, 'columns' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', 'sortable' => true, 'vname' => 'LBL_NAME', 'widget_class' => 'SubPanelDetailViewLink', 'width' => '9999%', 'link' => true, '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' => 'description', 'label' => 'LBL_DESCRIPTION', 'sortable' => false, 'vname' => 'LBL_DESCRIPTION', 'width' => '9999%', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, 'required' => false, ], 'type' => 'text', ], ], ], ], 'recordview' => [ 'header' => [ 'backButton' => [ 'display' => true, ], ], 'templateMeta' => [ 'maxColumns' => '2', 'useTabs' => true, 'tabDefs' => [], 'colClasses' => [], ], 'topWidget' => [ 'refreshOn' => 'data-update', ], 'sidebarWidgets' => [], 'bottomWidgets' => [], 'headerWidgets' => [], 'actions' => [ [ 'key' => 'edit', 'labelKey' => 'LBL_EDIT', 'priority' => 100, 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', ], 'acl' => [ 'edit', ], ], [ 'key' => 'save', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'priority' => 100, 'params' => [ 'expanded' => true, 'disableOnRun' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveNew', 'labelKey' => 'LBL_SAVE_BUTTON_LABEL', 'priority' => 100, 'params' => [ 'expanded' => true, 'disableOnRun' => true, ], 'modes' => [ 'create', ], 'acl' => [ 'edit', ], ], [ 'key' => 'saveContinue', 'labelKey' => 'LBL_SAVE_CONTINUE_LABEL', 'priority' => 150, 'params' => [ 'expanded' => true, 'collapsedMobile' => true, ], 'modes' => [ 'edit', ], 'acl' => [ 'edit', ], ], [ 'key' => 'cancel', 'priority' => 200, 'labelKey' => 'LBL_CANCEL', 'params' => [ 'expanded' => true, ], 'modes' => [ 'edit', ], ], [ 'key' => 'cancelCreate', 'labelKey' => 'LBL_CANCEL', 'priority' => 200, 'params' => [ 'expanded' => true, ], 'modes' => [ 'create', ], ], [ 'key' => 'duplicate', 'labelKey' => 'LBL_DUPLICATE_BUTTON', 'priority' => 1900, 'asyncProcess' => true, 'params' => null, 'modes' => [ 'detail', ], 'acl' => [ 'export', 'edit', ], ], [ 'key' => 'delete', 'labelKey' => 'LBL_DELETE', 'priority' => 2000, 'asyncProcess' => true, 'params' => [ 'displayConfirmation' => true, 'confirmationLabel' => 'NTC_DELETE_CONFIRMATION', ], 'modes' => [ 'detail', ], 'acl' => [ 'delete', ], ], [ 'key' => 'toggle-widgets', 'labelKey' => 'LBL_INSIGHTS', 'priority' => 5000, 'params' => [ 'expanded' => true, ], 'modes' => [ 'detail', 'edit', ], 'acl' => [], ], ], 'panels' => [ [ 'key' => 'default', 'rows' => [ [ 'cols' => [ [ 'name' => 'name', 'label' => 'LBL_NAME', 'fieldDefinition' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => true, ], 'type' => 'varchar', ], [ 'name' => 'entry_count', 'label' => 'LBL_ENTRIES', 'fieldDefinition' => [ 'name' => 'entry_count', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_ENTRIES', 'required' => false, ], 'type' => 'int', ], ], ], [ 'cols' => [ [ 'name' => 'list_type', 'label' => 'LBL_TYPE', 'fieldDefinition' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => true, ], 'type' => 'enum', ], [ 'name' => 'domain_name', 'label' => 'LBL_DOMAIN_NAME', 'fieldDefinition' => [ 'name' => 'domain_name', 'vname' => 'LBL_DOMAIN_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, ], 'type' => 'varchar', ], ], ], [ 'cols' => [ [ 'name' => 'description', 'label' => 'LBL_DESCRIPTION', 'fieldDefinition' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'required' => false, ], 'type' => 'text', ], [ 'name' => '', 'fieldDefinition' => [], ], ], ], ], ], [ 'key' => 'LBL_PANEL_ASSIGNMENT', 'rows' => [ [ 'cols' => [ [ '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', ], [ 'name' => 'date_modified', 'label' => 'LBL_DATE_MODIFIED', 'customCode' => '{$fields.date_modified.value} {$APP.LBL_BY} {$fields.modified_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => false, ], 'type' => 'datetime', 'readonly' => true, ], ], ], [ 'cols' => [ [ 'name' => 'date_entered', 'label' => 'LBL_DATE_ENTERED', 'customCode' => '{$fields.date_entered.value} {$APP.LBL_BY} {$fields.created_by_name.value}', 'fieldDefinition' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => false, ], 'type' => 'datetime', 'readonly' => true, ], [ 'name' => '', 'fieldDefinition' => [], ], ], ], ], ], ], 'summaryTemplates' => [ 'create' => 'LBL_CREATE', 'edit' => 'LBL_SUMMARY_DEFAULT', 'detail' => 'LBL_SUMMARY_DEFAULT', ], 'vardefs' => [ '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' => 'prospectlists_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_prospectlists', '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', ], ], 'id' => [ 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => false, ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'importable' => 'required', 'unified_search' => true, 'full_text_search' => [ 'boost' => 3, ], 'required' => false, ], 'list_type' => [ 'name' => 'list_type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'prospect_list_type_dom', 'len' => 100, 'importable' => 'required', 'required' => false, ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => false, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', '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' => 'modified_user_id_users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'required' => false, ], 'modified_by_name' => [ 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'created_by', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'created_by_users', 'isnull' => 'false', 'dbType' => 'id', 'required' => false, ], 'created_by_name' => [ 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'required' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_CREATED_BY', 'type' => 'bool', 'required' => false, 'reportable' => false, ], 'description' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'required' => false, ], 'domain_name' => [ 'name' => 'domain_name', 'vname' => 'LBL_DOMAIN_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, ], 'entry_count' => [ 'name' => 'entry_count', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_ENTRIES', 'required' => false, ], 'prospects' => [ 'name' => 'prospects', 'vname' => 'LBL_PROSPECTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_prospects', 'source' => 'non-db', 'required' => false, 'module' => 'Prospects', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'contacts' => [ 'name' => 'contacts', 'vname' => 'LBL_CONTACTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_contacts', 'source' => 'non-db', 'required' => false, 'module' => 'Contacts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'leads' => [ 'name' => 'leads', 'vname' => 'LBL_LEADS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_leads', 'source' => 'non-db', 'required' => false, 'module' => 'Leads', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'accounts' => [ 'name' => 'accounts', 'vname' => 'LBL_ACCOUNTS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_accounts', 'source' => 'non-db', 'required' => false, 'module' => 'Accounts', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'campaigns' => [ 'name' => 'campaigns', 'vname' => 'LBL_CAMPAIGNS', 'type' => 'link', 'relationship' => 'prospect_list_campaigns', 'source' => 'non-db', 'required' => false, 'module' => 'Campaigns', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'campaign_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'users' => [ 'name' => 'users', 'vname' => 'LBL_USERS', 'type' => 'link', 'metadata' => [ 'member' => true, ], 'relationship' => 'prospect_list_users', 'source' => 'non-db', 'required' => false, 'module' => 'Users', 'relationshipMetadata' => [ 'side' => 'rhs', 'related_id' => 'related_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'email_marketing' => [ 'name' => 'email_marketing', 'vname' => 'LBL_EMAIL_MARKETING', 'type' => 'link', 'relationship' => 'email_marketing_prospect_lists', 'source' => 'non-db', 'required' => false, 'module' => 'EmailMarketing', 'relationshipMetadata' => [ 'side' => 'lhs', 'related_id' => 'email_marketing_id', 'type' => 'many-to-many', 'parent_id' => 'prospect_list_id', ], ], 'marketing_id' => [ 'name' => 'marketing_id', 'vname' => 'LBL_MARKETING_ID', 'type' => 'varchar', 'len' => '36', 'source' => 'non-db', 'required' => false, ], 'marketing_name' => [ 'name' => 'marketing_name', 'vname' => 'LBL_MARKETING_NAME', 'type' => 'varchar', 'len' => '255', 'source' => 'non-db', 'required' => false, ], ], 'metadata' => [], 'sections' => [], ], 'recordmodal' => [], 'extra' => [], ]];