/
var
/
www
/
html
/
sugardemo
/
modules
/
DataSets
/
Upload File
HOME
<?php /* * Your installation or use of this SugarCRM file is subject to the applicable * terms available at * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/. * If you do not agree to all of the applicable terms or do not have the * authority to bind the entity as an authorized representative, then do not * install or use this SugarCRM file. * * Copyright (C) SugarCRM Inc. All rights reserved. */ $dictionary['DataSet'] = ['table' => 'data_sets' , 'fields' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', ], 'parent_id' => [ 'name' => 'parent_id', 'type' => 'id', 'reportable' => false, ], 'parent_name' => [ 'name' => 'parent_name', 'vname' => 'LBL_PARENT_DATASET', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'data_sets', 'id_name' => 'parent_id', 'rname' => 'name', 'module' => 'DataSets', 'duplicate_merge' => 'disabled', 'comment' => 'Parent data sets for the data set (Meta-data only)', ], 'report_id' => [ 'name' => 'report_id', 'type' => 'id', 'required' => false, 'reportable' => false, ], 'report_name' => [ 'name' => 'report_name', 'vname' => 'LBL_REPORT_NAME', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db', 'duplicate_merge' => 'disabled', 'comment' => 'Custom Queries for the data sets (Meta-data only)', ], 'query_id' => [ 'name' => 'query_id', 'vname' => 'LBL_QUERY_NAME', 'type' => 'id', 'required' => true, 'importable' => 'required', ], 'query_name' => [ 'name' => 'query_name', 'vname' => 'LBL_QUERY_NAME', 'type' => 'relate', 'reportable' => false, 'required' => true, 'source' => 'non-db', 'table' => 'custom_queries', 'id_name' => 'query_id', 'rname' => 'name', 'module' => 'CustomQueries', 'duplicate_merge' => 'disabled', 'comment' => 'Custom Queries for the data sets (Meta-data only)', ], 'name' => [ 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '50', 'importable' => 'required', ], 'list_order_y' => [ 'name' => 'list_order_y', 'vname' => 'LBL_LISTORDER_Y', 'type' => 'int', 'len' => '3', 'default' => '0', 'importable' => 'required', ], 'exportable' => [ 'name' => 'exportable', 'vname' => 'LBL_EXPORTABLE', 'dbType' => 'varchar', 'type' => 'bool', 'len' => '3', 'default' => '0', ], 'header' => [ 'name' => 'header', 'vname' => 'LBL_HEADER', 'dbType' => 'varchar', 'type' => 'bool', 'len' => '3', 'default' => '0', ], 'description' => [ 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', ], 'table_width' => [ 'name' => 'table_width', 'vname' => 'LBL_TABLE_WIDTH', 'type' => 'varchar', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ], 'font_size' => [ 'name' => 'font_size', 'vname' => 'LBL_FONT_SIZE', 'type' => 'enum', 'options' => 'font_size_dom', 'len' => 8, 'default' => '0', ], 'output_default' => [ 'name' => 'output_default', 'vname' => 'LBL_OUTPUT_DEFAULT', 'type' => 'enum', 'options' => 'dataset_output_default_dom', 'len' => 100, ], 'prespace_y' => [ 'name' => 'prespace_y', 'vname' => 'LBL_PRESPACE_Y', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ], 'use_prev_header' => [ 'name' => 'use_prev_header', 'vname' => 'LBL_USE_PREV_HEADER', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ], 'header_back_color' => [ 'name' => 'header_back_color', 'vname' => 'LBL_HEADER_BACK_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ], 'body_back_color' => [ 'name' => 'body_back_color', 'vname' => 'LBL_BODY_BACK_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ], 'header_text_color' => [ 'name' => 'header_text_color', 'vname' => 'LBL_HEADER_TEXT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ], 'body_text_color' => [ 'name' => 'body_text_color', 'vname' => 'LBL_BODY_TEXT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ], 'table_width_type' => [ 'name' => 'table_width_type', 'vname' => 'LBL_TABLE_WIDTH_TYPE', 'type' => 'enum', 'options' => 'width_type_dom', 'len' => 3, ], 'custom_layout' => [ 'name' => 'custom_layout', 'vname' => 'LBL_CUSTOM_LAYOUT', 'type' => 'enum', 'options' => 'custom_layout_dom', 'len' => 10, ], ], 'acls' => ['SugarACLAdminOnly' => ['allowUserRead' => true]], 'indices' => [ ['name' => 'dataset_k', 'type' => 'primary', 'fields' => ['id']], ['name' => 'idx_dataset', 'type' => 'index', 'fields' => ['name', 'deleted']], ], ]; VardefManager::createVardef('DataSets', 'DataSet', [ 'team_security', ]); $dictionary['DataSet_Layout'] = [ 'table' => 'dataset_layouts', 'fields' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', ], 'parent_value' => [ 'name' => 'parent_value', 'vname' => 'LBL_PARENT_VALUE', 'type' => 'varchar', 'len' => '50', ], 'layout_type' => [ 'name' => 'layout_type', 'vname' => 'LBL_LAYOUT_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_layout_type_dom', 'len' => 25, ], 'parent_id' => [ 'name' => 'parent_id', 'type' => 'id', 'required' => false, 'reportable' => false, ], 'list_order_x' => [ 'name' => 'list_order_x', 'vname' => 'LBL_LIST_ORDER_X', 'type' => 'int', 'len' => '4', ], 'list_order_z' => [ 'name' => 'list_order_z', 'vname' => 'LBL_LIST_ORDER_Z', 'type' => 'int', 'len' => '4', ], 'row_header_id' => [ 'name' => 'row_header_id', 'vname' => 'LBL_ROW_HEADER_ID', 'type' => 'id', ], 'hide_column' => [ 'name' => 'hide_column', 'vname' => 'LBL_HIDE_COLUMN', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', ], ], 'indices' => [ [ 'name' => 'datasetlayout_k', 'type' => 'primary', 'fields' => ['id'], ], [ 'name' => 'idx_datasetlayout', 'type' => 'index', 'fields' => ['parent_value', 'deleted'], ], ], ]; $dictionary['DataSet_Attribute'] = [ 'table' => 'dataset_attributes', 'fields' => [ 'id' => [ 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false, ], 'deleted' => [ 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, ], 'date_entered' => [ 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ], 'date_modified' => [ 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ], 'modified_user_id' => [ 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, ], 'created_by' => [ 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', ], 'display_type' => [ 'name' => 'display_type', 'vname' => 'LBL_DISPLAY_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_att_display_type_dom', 'len' => 25, ], 'display_name' => [ 'name' => 'display_name', 'vname' => 'LBL_DISPLAY_NAME', 'type' => 'varchar', 'len' => '50', ], 'attribute_type' => [ 'name' => 'attribute_type', 'vname' => 'LBL_ATT_TYPE', 'type' => 'varchar', 'required' => true, 'len' => 8, ], 'parent_id' => [ 'name' => 'parent_id', 'type' => 'id', 'required' => false, 'reportable' => false, ], 'font_size' => [ 'name' => 'font_size', 'vname' => 'LBL_FONT_SIZE', 'type' => 'enum', 'options' => 'font_size_dom', 'len' => 8, 'default' => '0', ], 'cell_size' => [ 'name' => 'cell_size', 'vname' => 'LBL_CELL_SIZE', 'type' => 'varchar', 'len' => '3', ], 'size_type' => [ 'name' => 'size_type', 'vname' => 'LBL_SIZE_TYPE', 'type' => 'enum', 'options' => 'width_type_dom', 'len' => 3, ], 'bg_color' => [ 'name' => 'bg_color', 'vname' => 'LBL_BG_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 25, ], 'font_color' => [ 'name' => 'font_color', 'vname' => 'LBL_FONT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 25, ], 'wrap' => [ 'name' => 'wrap', 'vname' => 'LBL_WRAP', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', ], 'style' => [ 'name' => 'style', 'vname' => 'LBL_STYLE', 'type' => 'enum', 'options' => 'dataset_style_dom', 'len' => 25, ], 'format_type' => [ 'name' => 'format_type', 'vname' => 'LBL_FORMAT_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_att_format_type_dom', 'len' => 25, ], ], 'indices' => [ [ 'name' => 'datasetatt_k', 'type' => 'primary', 'fields' => ['id'], ], [ 'name' => 'idx_datasetatt', 'type' => 'index', 'fields' => ['parent_id', 'deleted'], ], ], ];