Edit file

File name : Casevardefs.php

Content :<?php $GLOBALS["dictionary"]["Case"]=array ( 'table' => 'cases', 'audited' => true, 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'duplicate_merge' => true, 'comment' => 'Cases are issues or problems that a customer asks a support representative to resolve', 'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_SUBJECT', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'audited' => true, 'unified_search' => true, 'full_text_search' => array ( 'boost' => 3, ), 'comment' => 'The short description of the bug', 'merge_filter' => 'selected', 'required' => true, 'importable' => 'required', ), 'date_entered' => array ( '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, ), 'date_modified' => array ( '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, ), 'modified_user_id' => array ( '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, ), 'modified_by_name' => array ( '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, ), 'created_by' => array ( '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, ), 'created_by_name' => array ( '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, ), 'description' => array ( 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'editor' => 'html', 'comment' => 'Full text of the description', 'rows' => 6, 'cols' => 80, ), 'deleted' => array ( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', ), 'created_by_link' => array ( 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'cases_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', ), 'modified_user_link' => array ( 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'cases_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', ), 'assigned_user_id' => array ( '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', ), 'assigned_user_name' => array ( 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'user_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', ), 'assigned_user_link' => array ( 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'cases_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', ), 'SecurityGroups' => array ( 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_cases', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', ), 'case_number' => array ( 'name' => 'case_number', 'vname' => 'LBL_NUMBER', 'type' => 'int', 'readonly' => true, 'len' => 11, 'required' => true, 'auto_increment' => true, 'unified_search' => true, 'full_text_search' => array ( 'boost' => 3, ), 'comment' => 'Visual unique identifier', 'duplicate_merge' => 'disabled', 'disable_num_format' => true, 'studio' => array ( 'quickcreate' => false, ), 'inline_edit' => false, ), 'type' => array ( 'name' => 'type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'options' => 'case_type_dom', 'len' => 100, 'comment' => 'The type of issue (ex: issue, feature)', 'merge_filter' => 'disabled', 'inline_edit' => true, 'massupdate' => '1', 'comments' => 'The type of issue (ex: issue, feature)', ), 'status' => array ( 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'dynamicenum', 'options' => 'case_status_dom', 'len' => 100, 'audited' => true, 'comment' => 'The status of the case', 'dbtype' => 'enum', 'parentenum' => 'state', ), 'priority' => array ( 'name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'case_priority_dom', 'len' => 100, 'audited' => false, 'comment' => 'The priority of the case', 'inline_edit' => true, 'massupdate' => '1', 'comments' => 'The priority of the case', 'merge_filter' => 'disabled', ), 'resolution' => array ( 'name' => 'resolution', 'vname' => 'LBL_RESOLUTION', 'type' => 'text', 'comment' => 'The resolution of the case', 'rows' => 6, 'cols' => 80, ), 'work_log' => array ( 'name' => 'work_log', 'vname' => 'LBL_WORK_LOG', 'type' => 'text', 'comment' => 'Free-form text used to denote activities of interest', ), 'suggestion_box' => array ( 'name' => 'suggestion_box', 'vname' => 'LBL_SUGGESTION_BOX', 'type' => 'readonly', 'source' => 'non-db', ), 'account_name' => array ( 'name' => 'account_name', 'rname' => 'name', 'id_name' => 'account_id', 'vname' => 'LBL_ACCOUNT_NAME', 'type' => 'relate', 'link' => 'accounts', 'table' => 'accounts', 'join_name' => 'accounts', 'isnull' => 'true', 'module' => 'Accounts', 'dbType' => 'varchar', 'len' => 100, 'source' => 'non-db', 'unified_search' => true, 'comment' => 'The name of the account represented by the account_id field', 'required' => true, 'importable' => 'required', ), 'account_name1' => array ( 'name' => 'account_name1', 'source' => 'non-db', 'type' => 'text', 'len' => 100, 'importable' => 'false', 'studio' => array ( 'formula' => false, ), ), 'account_id' => array ( 'name' => 'account_id', 'type' => 'relate', 'dbType' => 'id', 'rname' => 'id', 'module' => 'Accounts', 'id_name' => 'account_id', 'reportable' => false, 'vname' => 'LBL_ACCOUNT_ID', 'audited' => true, 'massupdate' => false, 'comment' => 'The account to which the case is associated', ), 'state' => array ( 'name' => 'state', 'vname' => 'LBL_STATE', 'type' => 'enum', 'options' => 'case_state_dom', 'len' => 100, 'audited' => true, 'comment' => 'The state of the case (i.e. open/closed)', 'default' => 'Open', 'parentenum' => 'status', 'merge_filter' => 'disabled', ), 'case_attachments_display' => array ( 'required' => false, 'name' => 'case_attachments_display', 'vname' => 'LBL_CASE_ATTACHMENTS_DISPLAY', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'studio' => 'visible', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => array ( 'name' => 'display_case_attachments', 'returns' => 'html', 'include' => 'modules/AOP_Case_Updates/Case_Updates.php', ), ), 'case_update_form' => array ( 'required' => false, 'name' => 'case_update_form', 'vname' => 'LBL_CASE_UPDATE_FORM', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'studio' => 'visible', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => array ( 'name' => 'display_update_form', 'returns' => 'html', 'include' => 'modules/AOP_Case_Updates/Case_Updates.php', ), ), 'contact_created_by' => array ( 'name' => 'contact_created_by', 'type' => 'link', 'relationship' => 'cases_created_contact', 'module' => 'Contacts', 'bean_name' => 'Contact', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_CONTACT_CREATED_BY', 'side' => 'left', 'id_name' => 'contact_created_by_id', ), 'contact_created_by_name' => array ( 'name' => 'contact_created_by_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_CONTACT_CREATED_BY_NAME', 'save' => true, 'id_name' => 'contact_created_by_id', 'link' => 'cases_created_contact', 'table' => 'Contacts', 'module' => 'Contacts', 'rname' => 'name', ), 'contact_created_by_id' => array ( 'name' => 'contact_created_by_id', 'type' => 'id', 'reportable' => false, 'vname' => 'LBL_CONTACT_CREATED_BY_ID', ), 'tasks' => array ( 'name' => 'tasks', 'type' => 'link', 'relationship' => 'case_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS', ), 'notes' => array ( 'name' => 'notes', 'type' => 'link', 'relationship' => 'case_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES', ), 'meetings' => array ( 'name' => 'meetings', 'type' => 'link', 'relationship' => 'case_meetings', 'bean_name' => 'Meeting', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS', ), 'emails' => array ( 'name' => 'emails', 'type' => 'link', 'relationship' => 'emails_cases_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS', ), 'documents' => array ( 'name' => 'documents', 'type' => 'link', 'relationship' => 'documents_cases', 'source' => 'non-db', 'vname' => 'LBL_DOCUMENTS_SUBPANEL_TITLE', ), 'calls' => array ( 'name' => 'calls', 'type' => 'link', 'relationship' => 'case_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS', ), 'bugs' => array ( 'name' => 'bugs', 'type' => 'link', 'relationship' => 'cases_bugs', 'source' => 'non-db', 'vname' => 'LBL_BUGS', ), 'contacts' => array ( 'name' => 'contacts', 'type' => 'link', 'relationship' => 'contacts_cases', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS', ), 'accounts' => array ( 'name' => 'accounts', 'type' => 'link', 'relationship' => 'account_cases', 'link_type' => 'one', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNT', ), 'project' => array ( 'name' => 'project', 'type' => 'link', 'relationship' => 'projects_cases', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS', ), 'update_text' => array ( 'required' => false, 'name' => 'update_text', 'vname' => 'LBL_UPDATE_TEXT', 'source' => 'non-db', 'type' => 'text', 'editor' => 'html', 'massupdate' => '0', 'default' => '', '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', 'size' => '20', 'studio' => 'visible', 'rows' => 6, 'cols' => 80, 'id' => 'Casesupdate_text', ), 'internal' => array ( 'name' => 'internal', 'source' => 'non-db', 'vname' => 'LBL_INTERNAL', 'type' => 'bool', 'studio' => 'visible', ), 'aop_case_updates_threaded' => array ( 'required' => false, 'name' => 'aop_case_updates_threaded', 'vname' => 'LBL_AOP_CASE_UPDATES_THREADED', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'studio' => 'visible', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'inline_edit' => 0, 'function' => array ( 'name' => 'display_updates', 'returns' => 'html', 'include' => 'modules/AOP_Case_Updates/Case_Updates.php', ), ), 'aop_case_updates' => array ( 'name' => 'aop_case_updates', 'type' => 'link', 'relationship' => 'cases_aop_case_updates', 'source' => 'non-db', 'id_name' => 'case_id', 'vname' => 'LBL_AOP_CASE_UPDATES', ), 'aop_case_events' => array ( 'name' => 'aop_case_events', 'type' => 'link', 'relationship' => 'cases_aop_case_events', 'source' => 'non-db', 'id_name' => 'case_id', 'vname' => 'LBL_AOP_CASE_EVENTS', ), 'jjwg_maps_lat_c' => array ( 'inline_edit' => 1, 'required' => false, 'source' => 'custom_fields', 'name' => 'jjwg_maps_lat_c', 'vname' => 'LBL_JJWG_MAPS_LAT', 'type' => 'float', 'massupdate' => '0', 'default' => '0.00000000', 'no_default' => false, 'comments' => '', 'help' => 'Latitude', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '10', 'size' => '20', 'enable_range_search' => false, 'precision' => '8', 'id' => 'Casesjjwg_maps_lat_c', 'custom_module' => 'Cases', ), 'cases_accounts_1' => array ( 'name' => 'cases_accounts_1', 'type' => 'link', 'relationship' => 'cases_accounts_1', 'source' => 'non-db', 'module' => 'Accounts', 'bean_name' => 'Account', 'vname' => 'LBL_CASES_ACCOUNTS_1_FROM_ACCOUNTS_TITLE', ), 'jjwg_maps_lng_c' => array ( 'inline_edit' => 1, 'required' => false, 'source' => 'custom_fields', 'name' => 'jjwg_maps_lng_c', 'vname' => 'LBL_JJWG_MAPS_LNG', 'type' => 'float', 'massupdate' => '0', 'default' => '0.00000000', 'no_default' => false, 'comments' => '', 'help' => 'Longitude', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '11', 'size' => '20', 'enable_range_search' => false, 'precision' => '8', 'id' => 'Casesjjwg_maps_lng_c', 'custom_module' => 'Cases', ), 'jjwg_maps_geocode_status_c' => array ( 'inline_edit' => 1, 'required' => false, 'source' => 'custom_fields', 'name' => 'jjwg_maps_geocode_status_c', 'vname' => 'LBL_JJWG_MAPS_GEOCODE_STATUS', 'type' => 'varchar', 'massupdate' => '0', 'default' => NULL, 'no_default' => false, 'comments' => 'Geocode Status', 'help' => 'Geocode Status', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id' => 'Casesjjwg_maps_geocode_status_c', 'custom_module' => 'Cases', ), 'jjwg_maps_address_c' => array ( 'inline_edit' => 1, 'required' => false, 'source' => 'custom_fields', 'name' => 'jjwg_maps_address_c', 'vname' => 'LBL_JJWG_MAPS_ADDRESS', 'type' => 'varchar', 'massupdate' => '0', 'default' => NULL, 'no_default' => false, 'comments' => 'Address', 'help' => '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', 'id' => 'Casesjjwg_maps_address_c', 'custom_module' => 'Cases', ), 'google_doc_link_c' => array ( 'inline_edit' => '1', 'labelValue' => 'Google Doc Link', 'required' => false, 'source' => 'custom_fields', 'name' => 'google_doc_link_c', 'vname' => 'LBL_GOOGLE_DOC_LINK', 'type' => 'url', 'massupdate' => '0', 'default' => '', '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' => '255', 'size' => '20', 'dbType' => 'varchar', 'gen' => '', 'link_target' => '_self', 'id' => 'Casesgoogle_doc_link_c', 'custom_module' => 'Cases', ), ), 'indices' => array ( 'id' => array ( 'name' => 'casespk', 'type' => 'primary', 'fields' => array ( 0 => 'id', ), ), 'number' => array ( 'name' => 'casesnumk', 'type' => 'unique', 'fields' => array ( 0 => 'case_number', ), ), 0 => array ( 'name' => 'case_number', 'type' => 'index', 'fields' => array ( 0 => 'case_number', ), ), 1 => array ( 'name' => 'idx_case_name', 'type' => 'index', 'fields' => array ( 0 => 'name', ), ), 2 => array ( 'name' => 'idx_account_id', 'type' => 'index', 'fields' => array ( 0 => 'account_id', ), ), 3 => array ( 'name' => 'idx_cases_stat_del', 'type' => 'index', 'fields' => array ( 0 => 'assigned_user_id', 1 => 'status', 2 => 'deleted', ), ), ), 'relationships' => array ( 'cases_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many', ), 'cases_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many', ), 'cases_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many', ), 'securitygroups_cases' => array ( 'lhs_module' => 'SecurityGroups', 'lhs_table' => 'securitygroups', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'securitygroups_records', 'join_key_lhs' => 'securitygroup_id', 'join_key_rhs' => 'record_id', 'relationship_role_column' => 'module', 'relationship_role_column_value' => 'Cases', ), 'case_calls' => array ( 'lhs_module' => 'Cases', 'lhs_table' => 'cases', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Cases', ), 'case_tasks' => array ( 'lhs_module' => 'Cases', 'lhs_table' => 'cases', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Cases', ), 'case_notes' => array ( 'lhs_module' => 'Cases', 'lhs_table' => 'cases', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Cases', ), 'case_meetings' => array ( 'lhs_module' => 'Cases', 'lhs_table' => 'cases', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Cases', ), 'case_emails' => array ( 'lhs_module' => 'Cases', 'lhs_table' => 'cases', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'parent_type', 'relationship_role_column_value' => 'Cases', ), 'cases_created_contact' => array ( 'lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Cases', 'rhs_table' => 'cases', 'rhs_key' => 'contact_created_by_id', 'relationship_type' => 'one-to-many', ), ), 'optimistic_locking' => true, 'templates' => array ( 'issue' => 'issue', 'security_groups' => 'security_groups', 'assignable' => 'assignable', 'basic' => 'basic', ), 'custom_fields' => true, );

Save