* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['sel_Selkirk_Activity'] = array('table' => 'sel_selkirk_activity', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('contact_date' => array('required' => true, 'name' => 'contact_date', 'vname' => 'LBL_CONTACT_DATE', 'type' => 'date', 'massupdate' => 0, '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', 'enable_range_search' => false, 'display_default' => 'now'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'name', 'type' => 'relate', 'reportable' => true, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => '', 'duplicate_merge' => 'disabled', 'required' => false, 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'ext2' => '', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => '255', 'unified_search' => false, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'disabled', 'merge_filter' => 'disabled', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'user_id_c' => array('required' => false, 'name' => 'user_id_c', 'vname' => 'LBL_CONTACTED_BY_USER_ID', 'type' => 'id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20'), 'contacted_by' => array('required' => true, 'source' => 'non-db', 'name' => 'contacted_by', 'vname' => 'LBL_CONTACTED_BY', 'type' => 'relate', 'massupdate' => 0, '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', 'id_name' => 'user_id_c', 'ext2' => 'Users', 'module' => 'Users', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('sel_Selkirk_Activity', 'sel_Selkirk_Activity', array('basic', 'assignable'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['My_Custom_File'] = array('table' => 'my_custom_file', 'audited' => true, 'inline_edit' => true, 'fields' => array(), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('My_Custom_File', 'My_Custom_File', array('basic', 'assignable', 'security_groups', 'file'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['Call'] = array('table' => 'calls', 'comment' => 'A Call is an activity representing a phone call', 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'fields' => array('name' => array('name' => 'name', 'vname' => 'LBL_SUBJECT', 'dbType' => 'varchar', 'type' => 'name', 'len' => '50', 'comment' => 'Brief description of the call', 'unified_search' => true, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required'), 'duration_hours' => array('name' => 'duration_hours', 'vname' => 'LBL_DURATION_HOURS', 'type' => 'int', 'len' => '2', 'comment' => 'Call duration, hours portion', 'required' => true), 'duration_minutes' => array('name' => 'duration_minutes', 'vname' => 'LBL_DURATION_MINUTES', 'type' => 'int', 'function' => array('name' => 'getDurationMinutesOptions', 'returns' => 'html', 'include' => 'modules/Calls/CallHelper.php'), 'len' => '2', 'group' => 'duration_hours', 'importable' => 'required', 'comment' => 'Call duration, minutes portion'), 'date_start' => array('name' => 'date_start', 'vname' => 'LBL_DATE', 'type' => 'datetimecombo', 'dbType' => 'datetime', 'comment' => 'Date in which call is schedule to (or did) start', 'importable' => 'required', 'required' => true, 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_end' => array('name' => 'date_end', 'vname' => 'LBL_DATE_END', 'type' => 'datetimecombo', 'dbType' => 'datetime', 'massupdate' => false, 'comment' => 'Date is which call is scheduled to (or did) end', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'parent_type' => array('name' => 'parent_type', 'vname' => 'LBL_PARENT_TYPE', 'type' => 'parent_type', 'dbType' => 'varchar', 'required' => false, 'group' => 'parent_name', 'options' => 'parent_type_display', 'len' => 255, 'comment' => 'The Sugar object to which the call is related'), 'parent_name' => array('name' => 'parent_name', 'parent_type' => 'record_type_display', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'vname' => 'LBL_LIST_RELATED_TO', 'type' => 'parent', 'group' => 'parent_name', 'source' => 'non-db', 'options' => 'parent_type_display'), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'len' => 100, 'options' => 'call_status_dom', 'comment' => 'The status of the call (Held, Not Held, etc.)', 'required' => true, 'importable' => 'required', 'default' => 'Planned', 'studio' => array('detailview' => false)), 'direction' => array('name' => 'direction', 'vname' => 'LBL_DIRECTION', 'type' => 'enum', 'len' => 100, 'options' => 'call_direction_dom', 'comment' => 'Indicates whether call is inbound or outbound'), 'parent_id' => array('name' => 'parent_id', 'vname' => 'LBL_LIST_RELATED_TO_ID', 'type' => 'id', 'group' => 'parent_name', 'reportable' => false, 'comment' => 'The ID of the parent Sugar object identified by parent_type'), 'reminder_checked' => array('name' => 'reminder_checked', 'vname' => 'LBL_REMINDER', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'checkbox indicating whether or not the reminder value is set (Meta-data only)', 'massupdate' => false), 'reminder_time' => array('name' => 'reminder_time', 'vname' => 'LBL_REMINDER_TIME', 'type' => 'enum', 'dbType' => 'int', 'options' => 'reminder_time_options', 'reportable' => false, 'massupdate' => false, 'default' => -1, 'comment' => 'Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start'), 'email_reminder_checked' => array('name' => 'email_reminder_checked', 'vname' => 'LBL_EMAIL_REMINDER', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'checkbox indicating whether or not the email reminder value is set (Meta-data only)', 'massupdate' => false), 'email_reminder_time' => array('name' => 'email_reminder_time', 'vname' => 'LBL_EMAIL_REMINDER_TIME', 'type' => 'enum', 'dbType' => 'int', 'options' => 'reminder_time_options', 'reportable' => false, 'massupdate' => false, 'default' => -1, 'comment' => 'Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start'), 'email_reminder_sent' => array('name' => 'email_reminder_sent', 'vname' => 'LBL_EMAIL_REMINDER_SENT', 'default' => 0, 'type' => 'bool', 'comment' => 'Whether email reminder is already sent', 'studio' => false, 'massupdate' => false), 'outlook_id' => array('name' => 'outlook_id', 'vname' => 'LBL_OUTLOOK_ID', 'type' => 'varchar', 'len' => '255', 'reportable' => false, 'comment' => 'When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID'), 'accept_status' => array('name' => 'accept_status', 'vname' => 'LBL_ACCEPT_STATUS', 'dbType' => 'varchar', 'type' => 'varchar', 'len' => '20', 'source' => 'non-db'), 'set_accept_links' => array('name' => 'accept_status', 'vname' => 'LBL_ACCEPT_LINK', 'dbType' => 'varchar', 'type' => 'varchar', 'len' => '20', 'source' => 'non-db'), 'contact_name' => array('name' => 'contact_name', 'rname' => 'last_name', 'db_concat_fields' => array(0 => 'first_name', 1 => 'last_name'), 'id_name' => 'contact_id', 'massupdate' => false, 'vname' => 'LBL_CONTACT_NAME', 'type' => 'relate', 'link' => 'contacts', 'table' => 'contacts', 'isnull' => 'true', 'module' => 'Contacts', 'join_name' => 'contacts', 'dbType' => 'varchar', 'source' => 'non-db', 'len' => 36, 'importable' => 'false', 'studio' => array('required' => false, 'listview' => true, 'visible' => false)), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'opportunity_calls', 'source' => 'non-db', 'link_type' => 'one', 'vname' => 'LBL_OPPORTUNITY'), 'leads' => array('name' => 'leads', 'type' => 'link', 'relationship' => 'calls_leads', 'source' => 'non-db', 'vname' => 'LBL_LEADS'), 'project' => array('name' => 'project', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS'), 'case' => array('name' => 'case', 'type' => 'link', 'relationship' => 'case_calls', 'source' => 'non-db', 'link_type' => 'one', 'vname' => 'LBL_CASE'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'account_calls', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNT'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'calls_contacts', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS'), 'users' => array('name' => 'users', 'type' => 'link', 'relationship' => 'calls_users', 'source' => 'non-db', 'vname' => 'LBL_USERS'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'calls_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'calls_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'calls_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'calls_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'contact_id' => array('name' => 'contact_id', 'type' => 'id', 'source' => 'non-db'), 'repeat_type' => array('name' => 'repeat_type', 'vname' => 'LBL_REPEAT_TYPE', 'type' => 'enum', 'len' => 36, 'options' => 'repeat_type_dom', 'comment' => 'Type of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_interval' => array('name' => 'repeat_interval', 'vname' => 'LBL_REPEAT_INTERVAL', 'type' => 'int', 'len' => 3, 'default' => 1, 'comment' => 'Interval of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_dow' => array('name' => 'repeat_dow', 'vname' => 'LBL_REPEAT_DOW', 'type' => 'varchar', 'len' => 7, 'comment' => 'Days of week in recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_until' => array('name' => 'repeat_until', 'vname' => 'LBL_REPEAT_UNTIL', 'type' => 'date', 'comment' => 'Repeat until specified date', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_count' => array('name' => 'repeat_count', 'vname' => 'LBL_REPEAT_COUNT', 'type' => 'int', 'len' => 7, 'comment' => 'Number of recurrence', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'repeat_parent_id' => array('name' => 'repeat_parent_id', 'vname' => 'LBL_REPEAT_PARENT_ID', 'type' => 'id', 'len' => 36, 'comment' => 'Id of the first element of recurring records', 'importable' => 'false', 'massupdate' => false, 'reportable' => false, 'studio' => 'false'), 'recurring_source' => array('name' => 'recurring_source', 'vname' => 'LBL_RECURRING_SOURCE', 'type' => 'varchar', 'len' => 36, 'comment' => 'Source of recurring call', 'importable' => false, 'massupdate' => false, 'reportable' => false, 'studio' => false)), 'indices' => array(array('name' => 'idx_call_name', 'type' => 'index', 'fields' => array('name')), array('name' => 'idx_status', 'type' => 'index', 'fields' => array('status')), array('name' => 'idx_calls_date_start', 'type' => 'index', 'fields' => array('date_start')), array('name' => 'idx_calls_par_del', 'type' => 'index', 'fields' => array('parent_id', 'parent_type', 'deleted')), array('name' => 'idx_calls_assigned_del', 'type' => 'index', 'fields' => array('deleted', 'assigned_user_id'))), 'relationships' => array('calls_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'calls_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'calls_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many'), 'calls_notes' => array('lhs_module' => 'Calls', 'lhs_table' => 'calls', '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' => 'Calls')), 'optimistic_locking' => true);
VardefManager::createVardef('Calls', 'Call', array('default', 'assignable'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['jjwg_Areas'] = array('table' => 'jjwg_areas', 'audited' => true, 'fields' => array('city' => array('required' => false, 'name' => 'city', 'vname' => 'LBL_CITY', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'City', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'state' => array('required' => false, 'name' => 'state', 'vname' => 'LBL_STATE', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'State', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'country' => array('required' => false, 'name' => 'country', 'vname' => 'LBL_COUNTRY', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => 'Country', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'coordinates' => array('required' => false, 'name' => 'coordinates', 'vname' => 'LBL_COORDINATES', 'type' => 'text', 'massupdate' => 0, 'comments' => '', 'help' => 'Coordinates Format: Lng, Lat, Elv', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'studio' => 'visible', 'rows' => '6', 'cols' => '80'), 'jjwg_maps_jjwg_areas' => array('name' => 'jjwg_maps_jjwg_areas', 'type' => 'link', 'relationship' => 'jjwg_maps_jjwg_areas', 'source' => 'non-db', 'vname' => 'LBL_JJWG_MAPS_JJWG_AREAS_FROM_JJWG_MAPS_TITLE')), 'relationships' => array(), 'optimistic_locking' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('jjwg_Areas', 'jjwg_Areas', array('basic', 'assignable', 'security_groups'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['SchedulersJob'] = array('table' => 'job_queue', 'comment' => 'Job queue keeps the list of the jobs executed by this instance', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'len' => '36', 'required' => true, 'reportable' => false), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'required' => true), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true), 'scheduler_id' => array('name' => 'scheduler_id', 'vname' => 'LBL_SCHEDULER', 'type' => 'id', 'required' => false, 'reportable' => false), 'execute_time' => array('name' => 'execute_time', 'vname' => 'LBL_EXECUTE_TIME', 'type' => 'datetime', 'required' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'schedulers_times_dom', 'len' => 20, 'required' => true, 'reportable' => true, 'readonly' => true), 'resolution' => array('name' => 'resolution', 'vname' => 'LBL_RESOLUTION', 'type' => 'enum', 'options' => 'schedulers_resolution_dom', 'len' => 20, 'required' => true, 'reportable' => true, 'readonly' => true), 'message' => array('name' => 'message', 'vname' => 'LBL_MESSAGE', 'type' => 'text', 'required' => false, 'reportable' => false), 'target' => array('name' => 'target', 'vname' => 'LBL_TARGET', 'type' => 'varchar', 'len' => 255, 'required' => true, 'reportable' => true), 'data' => array('name' => 'data', 'vname' => 'LBL_DATA', 'type' => 'text', 'required' => false, 'reportable' => true), 'requeue' => array('name' => 'requeue', 'vname' => 'LBL_REQUEUE', 'type' => 'bool', 'default' => 0, 'required' => false, 'reportable' => true), 'retry_count' => array('name' => 'retry_count', 'vname' => 'LBL_RETRY_COUNT', 'type' => 'tinyint', 'required' => false, 'reportable' => true), 'failure_count' => array('name' => 'failure_count', 'vname' => 'LBL_FAIL_COUNT', 'type' => 'tinyint', 'required' => false, 'reportable' => true, 'readonly' => true), 'job_delay' => array('name' => 'job_delay', 'vname' => 'LBL_INTERVAL', 'type' => 'int', 'required' => false, 'reportable' => false), 'client' => array('name' => 'client', 'vname' => 'LBL_CLIENT', 'type' => 'varchar', 'len' => 255, 'required' => true, 'reportable' => true), 'percent_complete' => array('name' => 'percent_complete', 'vname' => 'LBL_PERCENT', 'type' => 'int', 'required' => false), 'schedulers' => array('name' => 'schedulers', 'vname' => 'LBL_SCHEDULER_ID', 'type' => 'link', 'relationship' => 'schedulers_jobs_rel', 'source' => 'non-db', 'link_type' => 'one')), 'indices' => array(array('name' => 'job_queuepk', 'type' => 'primary', 'fields' => array('id')), array('name' => 'idx_status_scheduler', 'type' => 'index', 'fields' => array('status', 'scheduler_id')), array('name' => 'idx_status_time', 'type' => 'index', 'fields' => array('status', 'execute_time', 'date_entered')), array('name' => 'idx_status_entered', 'type' => 'index', 'fields' => array('status', 'date_entered')), array('name' => 'idx_status_modified', 'type' => 'index', 'fields' => array('status', 'date_modified'))));
VardefManager::createVardef('SchedulersJobs', 'SchedulersJob', array('assignable'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['Project'] = array('table' => 'project', 'unified_search' => true, 'unified_search_default_enabled' => false, 'comment' => 'Project', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'required' => true, 'type' => 'id', 'reportable' => true, 'comment' => 'Unique identifier'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'type' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_USER_ID', 'required' => false, 'len' => 36, 'dbType' => 'id', 'table' => 'users', 'isnull' => false, 'reportable' => true, 'comment' => 'User assigned to this record'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), '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'), 'created_by' => array('name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED_BY', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User who created record'), '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'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'required' => true, 'dbType' => 'varchar', 'type' => 'name', 'len' => 50, 'unified_search' => true, 'comment' => 'Project name', 'importable' => 'required', 'required' => true), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'required' => false, 'type' => 'text', 'comment' => 'Project description'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'default' => '0', 'comment' => 'Record deletion indicator'), 'estimated_start_date' => array('name' => 'estimated_start_date', 'vname' => 'LBL_DATE_START', 'required' => true, 'validation' => array('type' => 'isbefore', 'compareto' => 'estimated_end_date', 'blank' => true), 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'estimated_end_date' => array('name' => 'estimated_end_date', 'vname' => 'LBL_DATE_END', 'required' => true, 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'project_status_dom'), 'priority' => array('name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'projects_priority_options'), 'total_estimated_effort' => array('name' => 'total_estimated_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ESTIMATED_EFFORT'), 'total_actual_effort' => array('name' => 'total_actual_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ACTUAL_EFFORT'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'projects_accounts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_ACCOUNTS'), 'quotes' => array('name' => 'quotes', 'type' => 'link', 'relationship' => 'projects_quotes', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_QUOTES'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'projects_contacts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_CONTACTS'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'projects_opportunities', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_OPPORTUNITIES'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'projects_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'projects_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'projects_meetings', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_projects_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'projecttask' => array('name' => 'projecttask', 'type' => 'link', 'relationship' => 'projects_project_tasks', 'source' => 'non-db', 'vname' => 'LBL_PROJECT_TASKS'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'projects_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'projects_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'projects_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_USER_NAME', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'dbType' => 'varchar', 'link' => 'users', 'len' => '255', 'source' => 'non-db'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'projects_cases', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'bugs' => array('name' => 'bugs', 'type' => 'link', 'relationship' => 'projects_bugs', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_BUGS'), 'products' => array('name' => 'products', 'type' => 'link', 'relationship' => 'projects_products', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_PRODUCTS')), 'indices' => array(array('name' => 'projects_primary_key_index', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('projects_notes' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_meetings' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_calls' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_emails' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_project_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'ProjectTask', 'rhs_table' => 'project_task', 'rhs_key' => 'project_id', 'relationship_type' => 'one-to-many'), 'projects_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'projects_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'projects_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many')));
VardefManager::createVardef('Project', 'Project', array());
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$module = 'Realty';
$dictionary['Realty'] = array('table' => 'realty', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('request' => array('name' => 'request', 'vname' => 'LBL_REQUEST', 'type' => 'varchar', 'source' => 'non-db'), 'code_inc' => array('name' => 'code_inc', 'vname' => 'LBL_CODE', 'type' => 'int', 'auto_increment' => true, 'massupdate' => 0, 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'reportable' => 0), 'presentation_text' => array('name' => 'presentation_text', 'vname' => 'LBL_PRESENTATION_TEXT', 'type' => 'varchar', 'required' => false), 'presentation_checked' => array('name' => 'presentation_checked', 'vname' => 'LBL_PRESENTATION_CHECKED', 'type' => 'varchar', 'required' => false, 'source' => 'non-db'), 'reserved' => array('name' => 'reserved', 'vname' => 'LBL_RESERVED', 'type' => 'bool'), 'last_contact' => array('name' => 'last_contact', 'vname' => 'LBL_LAST_CONTACT', 'type' => 'date'), 'd_text' => array('name' => 'd_text', 'vname' => 'LBL_D_TEXT', 'type' => 'text'), 'd_name' => array('name' => 'd_name', 'vname' => 'LBL_D_NAME', 'type' => 'varchar'), 'room_layout' => array('name' => 'room_layout', 'vname' => 'LBL_ROOM_LAYOUT', 'type' => 'enum', 'options' => 'room_layout_list'), 'for_office' => array('name' => 'for_office', 'vname' => 'LBL_FOR_OFFICE', 'type' => 'bool'), 'balcon' => array('name' => 'balcon', 'vname' => 'LBL_BALCON', 'type' => 'bool'), 'phone_bool' => array('name' => 'phone_bool', 'vname' => 'LBL_PHONE_BOOL', 'type' => 'bool'), 'boiler' => array('name' => 'boiler', 'vname' => 'LBL_BOILER', 'type' => 'bool'), 'tv' => array('name' => 'tv', 'vname' => 'LBL_TV', 'type' => 'bool'), 'fridge' => array('name' => 'fridge', 'vname' => 'LBL_FRIDGE', 'type' => 'bool'), 'washing_m' => array('name' => 'washing_m', 'vname' => 'LBL_WASHING_M', 'type' => 'bool'), 'conditioning' => array('name' => 'conditioning', 'vname' => 'LBL_CONDITIONING', 'type' => 'bool'), 'internet' => array('name' => 'internet', 'vname' => 'LBL_INTERNET', 'type' => 'bool'), 'parking' => array('name' => 'parking', 'vname' => 'LBL_PARKING', 'type' => 'bool'), 'gaz' => array('name' => 'gaz', 'vname' => 'LBL_GAZ', 'type' => 'enum', 'options' => 'gaz_list'), 'gaz_add' => array('name' => 'gaz_add', 'vname' => 'LBL_GAZ_P', 'type' => 'enum', 'options' => 'gaz_add_list'), 'h2o' => array('name' => 'h2o', 'vname' => 'LBL_H2O', 'type' => 'enum', 'options' => 'h2o_list'), 'h2o_add' => array('name' => 'h2o_add', 'vname' => 'LBL_H2O_P', 'type' => 'enum', 'options' => 'h2o_add_list'), 'owner_last_name' => array('name' => 'owner_last_name', 'vname' => 'LBL_OWNER_LAST_NAME', 'type' => 'varchar', 'required' => true), 'owner_first_name' => array('name' => 'owner_first_name', 'vname' => 'LBL_OWNER_FIRST_NAME', 'type' => 'varchar'), 'owner_phone' => array('name' => 'owner_phone', 'vname' => 'LBL_OWNER_PHONE', 'type' => 'phone', 'dbType' => 'varchar', 'required' => true), 'realty_status' => array('name' => 'realty_status', 'vname' => 'LBL_REALTY_STATUS', 'type' => 'enum', 'options' => 'realty_status_list'), 'activity_status' => array('name' => 'activity_status', 'vname' => 'LBL_ACTIVITY_STATUS', 'type' => 'enum', 'options' => 'activity_status_list'), 'source_of_income_object' => array('name' => 'source_of_income_object', 'vname' => 'LBL_SOURCE_OF_INCOME_OBJECT', 'type' => 'enum', 'options' => 'source_of_income_object_list'), 'operation' => array('name' => 'operation', 'vname' => 'LBL_OPERATION', 'type' => 'enum', 'options' => 'operation_realty_list'), 'operation_status' => array('name' => 'operation_status', 'vname' => 'LBL_OPERATION_STATUS', 'type' => 'enum', 'options' => 'operation_status_realty_list'), 'type_of_realty' => array('name' => 'type_of_realty', 'vname' => 'LBL_TYPE_OF_REALTY', 'type' => 'enum', 'options' => 'type_of_realty_list'), 'kind_of_realty' => array('name' => 'kind_of_realty', 'vname' => 'LBL_KIND_OF_REALTY', 'type' => 'enum', 'options' => 'kind_of_realty_list'), 'square' => array('name' => 'square', 'vname' => 'LBL_SQUARE', 'type' => 'float', 'required' => true), 'living_square' => array('name' => 'living_square', 'vname' => 'LBL_LIVING_SQUARE', 'type' => 'float'), 'kitchen_square' => array('name' => 'kitchen_square', 'vname' => 'LBL_KITCHEN_SQUARE', 'type' => 'float'), 'square_unit' => array('name' => 'square_unit', 'vname' => 'LBL_SQUARE_UNIT', 'type' => 'enum', 'options' => 'square_unit_list'), 'rooms_quantity' => array('name' => 'rooms_quantity', 'vname' => 'LBL_ROOMS_QUANTITY', 'type' => 'int'), 'floor' => array('name' => 'floor', 'vname' => 'LBL_FLOOR', 'type' => 'int'), 'number_of_floors' => array('name' => 'number_of_floors', 'vname' => 'LBL_NUMBER_OF_FLOORS', 'type' => 'int'), 'currency' => array('name' => 'currency', 'vname' => 'LBL_CURRENCY', 'type' => 'enum', 'options' => 'realty_currency_list'), 'cost' => array('name' => 'cost', 'vname' => 'LBL_COST', 'type' => 'int', 'required' => true), 'period' => array('name' => 'period', 'vname' => 'LBL_PERIOD', 'type' => 'enum', 'options' => 'realty_period_list'), 'totalcost' => array('name' => 'totalcost', 'vname' => 'LBL_TOTALCOST', 'type' => 'int'), 'currency_uah' => array('name' => 'currency_uah', 'vname' => 'LBL_TOTALCOST_UAH', 'type' => 'int'), 'video_youtube' => array('name' => 'video_youtube', 'vname' => 'LBL_VIDEO_YOUTUBE', 'type' => 'varchar'), 'state_of_object' => array('name' => 'state_of_object', 'vname' => 'LBL_STATE_OF_OBJECT', 'type' => 'enum', 'options' => 'state_of_object_list'), 'longitude' => array('name' => 'longitude', 'vname' => 'LBL_LONGITUDE', 'type' => 'varchar'), 'latitude' => array('name' => 'latitude', 'vname' => 'LBL_LATITUDE', 'type' => 'varchar'), 'map_in_editview' => array('name' => 'map_in_editview', 'type' => 'varchar', 'vname' => 'LBL_MAP_IN_EDITVIEW'), 'metro' => array('name' => 'metro', 'vname' => 'LBL_METRO', 'type' => 'varchar'), 'way_to_get' => array('name' => 'way_to_get', 'vname' => 'LBL_WAY_TO_GET', 'type' => 'enum', 'options' => 'way_to_get_list'), 'address_city' => array('name' => 'address_city', 'vname' => 'LBL_ADDRESS_CITY', 'type' => 'varchar'), 'address_country' => array('name' => 'address_country', 'vname' => 'LBL_ADDRESS_COUNTRY', 'type' => 'varchar'), 'address_street' => array('name' => 'address_street', 'vname' => 'LBL_ADDRESS_STREET', 'type' => 'varchar'), 'address_house' => array('name' => 'address_house', 'vname' => 'LBL_ADDRESS_HOUSE', 'type' => 'varchar'), 'address_apartment' => array('name' => 'address_apartment', 'vname' => 'LBL_ADDRESS_APARTMENT', 'type' => 'varchar'), 'address_region' => array('name' => 'address_region', 'vname' => 'LBL_ADDRESS_REGION', 'type' => 'varchar'), 'address_district' => array('name' => 'address_district', 'vname' => 'LBL_ADDRESS_DISTRICT', 'type' => 'varchar'), 'sections_exist' => array('name' => 'sections_exist', 'vname' => 'LBL_SECTIONS_EXIST', 'type' => 'enum', 'options' => 'sections_exist_list'), "email1" => array('name' => 'email1', 'vname' => 'LBL_EMAIL', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled', 'studio' => 'visible'), 'email_addresses_primary' => array('name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => strtolower($module) . '_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled'), 'email_addresses' => array('name' => 'email_addresses', 'type' => 'link', 'relationship' => strtolower($module) . '_email_addresses', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'unified_search' => true, 'rel_fields' => array('primary_address' => array('type' => 'bool'))), 'contact_id' => array('required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'contact_name' => array('required' => false, 'source' => 'non-db', 'name' => 'contact_name', 'vname' => 'LBL_CONTACT_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'rname' => 'name', 'studio' => 'visible'), 'account_id' => array('required' => false, 'name' => 'account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'account_name' => array('required' => false, 'source' => 'non-db', 'name' => 'account_name', 'vname' => 'LBL_ACCOUNT_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'rname' => 'name', 'studio' => 'visible'), 'building_id' => array('required' => false, 'name' => 'building_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'building_name' => array('required' => false, 'source' => 'non-db', 'name' => 'building_name', 'vname' => 'LBL_BUILDING_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'building_id', 'ext2' => 'Buildings', 'module' => 'Buildings', 'rname' => 'name', 'studio' => 'visible'), 'section_id' => array('required' => false, 'name' => 'section_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'importable' => 'true', 'audited' => 0, 'len' => 36), 'section_name' => array('required' => false, 'source' => 'non-db', 'name' => 'section_name', 'vname' => 'LBL_SECTION_NAME', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'audited' => 1, 'len' => '100', 'id_name' => 'section_id', 'ext2' => 'Sections', 'module' => 'Sections', 'rname' => 'name', 'studio' => 'visible'), "realty_calls" => array('name' => 'realty_calls', 'type' => 'link', 'relationship' => 'realty_calls', 'module' => 'Calls', 'bean_name' => 'Calls', 'source' => 'non-db', 'vname' => 'LBL_REALTY_CALLS'), "realty_meetings" => array('name' => 'realty_meetings', 'type' => 'link', 'relationship' => 'realty_meetings', 'module' => 'Meetings', 'bean_name' => 'Meetings', 'source' => 'non-db', 'vname' => 'LBL_REALTY_MEETINGS'), "realty_tasks" => array('name' => 'realty_tasks', 'type' => 'link', 'relationship' => 'realty_tasks', 'module' => 'Tasks', 'bean_name' => 'Tasks', 'source' => 'non-db', 'vname' => 'LBL_REALTY_TASKS')), 'relationships' => array(strtolower($module) . '_email_addresses' => array('lhs_module' => $module, 'lhs_table' => strtolower($module), 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => $module), strtolower($module) . '_email_addresses_primary' => array('lhs_module' => $module, 'lhs_table' => strtolower($module), 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'primary_address', 'relationship_role_column_value' => '1'), 'realty_calls' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Calls', 'rhs_table' => 'calls', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many'), 'realty_meetings' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many'), 'realty_tasks' => array('lhs_module' => 'Realty', 'lhs_table' => 'realty', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'realty_id', 'relationship_type' => 'one-to-many')), 'indices' => array(array('name' => 'code_inc', 'type' => 'unique', 'fields' => array('code_inc'))), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('Realty', 'Realty', array('basic', 'assignable'));
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
/*
* Your installation or use of this SugarCRM file is subject to the applicable
* terms available at
* http://support.sugarcrm.com/06_Customer_Center/10_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['pmse_BpmNotes'] = array('table' => 'pmse_bpm_notes', 'audited' => false, 'activity_enabled' => false, 'duplicate_merge' => true, 'reassignable' => false, 'fields' => array('cas_id' => array('required' => true, 'name' => 'cas_id', 'vname' => 'Unique Identifier for this Case', 'type' => 'varchar', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '36', 'size' => '36'), 'cas_index' => array('required' => true, 'name' => 'cas_index', 'vname' => 'Case flow index a sequential number relative to each case', 'type' => 'int', 'massupdate' => false, 'default' => null, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '4', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '', 'min' => false, 'max' => false), 'not_user_id' => array('required' => true, 'name' => 'not_user_id', 'vname' => 'User Identifier for who wrote this note', 'type' => 'varchar', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '40', 'size' => '40'), 'not_user_recipient_id' => array('required' => true, 'name' => 'not_user_recipient_id', 'vname' => 'User Identifier for recipient this note', 'type' => 'varchar', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '40', 'size' => '40'), 'not_type' => array('required' => true, 'name' => 'not_type', 'vname' => 'Note type', 'type' => 'varchar', 'massupdate' => false, 'default' => 'GENERAL', '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '32', 'size' => '32'), 'not_date' => array('required' => false, 'name' => 'not_date', 'vname' => 'when the note was was sent', 'type' => 'datetimecombo', 'massupdate' => true, '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', 'calculated' => false, 'size' => '20', 'enable_range_search' => false, 'dbType' => 'datetime'), 'not_status' => array('required' => true, 'name' => 'not_status', 'vname' => 'Thread status', 'type' => 'varchar', 'massupdate' => false, 'default' => 'ACTIVE', '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '10', 'size' => '10'), 'not_availability' => array('required' => true, 'name' => 'not_availability', 'vname' => 'Thread status', 'type' => 'varchar', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'len' => '32', 'size' => '32'), 'not_content' => array('required' => true, 'name' => 'not_content', 'vname' => 'Case flow index', 'type' => 'text', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'size' => '20', 'rows' => '4', 'cols' => '20'), 'not_recipients' => array('required' => true, 'name' => 'not_recipients', 'vname' => 'tokens evaluated in this thread', 'type' => 'text', 'massupdate' => false, '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', 'full_text_search' => array('boost' => '0'), 'calculated' => false, 'size' => '20', 'rows' => '4', 'cols' => '20')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('pmse_BpmNotes', 'pmse_BpmNotes', array('basic', 'assignable'));
<?php
/**
* Products, Quotations & Invoices modules.
* Extensions to SugarCRM
* @package Advanced OpenSales for SugarCRM
* @subpackage Products
* @copyright SalesAgility Ltd http://www.salesagility.com
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE
* along with this program; if not, see http://www.gnu.org/licenses
* or write to the Free Software Foundation,Inc., 51 Franklin Street,
* Fifth Floor, Boston, MA 02110-1301 USA
*
* @author Salesagility Ltd <*****@*****.**>
*/
$dictionary['AOS_Invoices'] = array('table' => 'aos_invoices', 'audited' => true, 'fields' => array('billing_account_id' => array('required' => false, 'name' => 'billing_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'billing_account' => array('required' => false, 'source' => 'non-db', 'name' => 'billing_account', 'vname' => 'LBL_BILLING_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 1, 'len' => '255', 'id_name' => 'billing_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'billing_contact_id' => array('required' => false, 'name' => 'billing_contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'billing_contact' => array('required' => false, 'source' => 'non-db', 'name' => 'billing_contact', 'vname' => 'LBL_BILLING_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 1, 'len' => '255', 'id_name' => 'billing_contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'billing_address_street' => array('name' => 'billing_address_street', 'vname' => 'LBL_BILLING_ADDRESS_STREET', 'type' => 'varchar', 'len' => '150', 'comment' => 'The street address used for billing address', 'group' => 'billing_address', 'merge_filter' => 'enabled'), 'billing_address_city' => array('name' => 'billing_address_city', 'vname' => 'LBL_BILLING_ADDRESS_CITY', 'type' => 'varchar', 'len' => '100', 'comment' => 'The city used for billing address', 'group' => 'billing_address', 'merge_filter' => 'enabled'), 'billing_address_state' => array('name' => 'billing_address_state', 'vname' => 'LBL_BILLING_ADDRESS_STATE', 'type' => 'varchar', 'len' => '100', 'group' => 'billing_address', 'comment' => 'The state used for billing address', 'merge_filter' => 'enabled'), 'billing_address_postalcode' => array('name' => 'billing_address_postalcode', 'vname' => 'LBL_BILLING_ADDRESS_POSTALCODE', 'type' => 'varchar', 'len' => '20', 'group' => 'billing_address', 'comment' => 'The postal code used for billing address', 'merge_filter' => 'enabled'), 'billing_address_country' => array('name' => 'billing_address_country', 'vname' => 'LBL_BILLING_ADDRESS_COUNTRY', 'type' => 'varchar', 'group' => 'billing_address', 'comment' => 'The country used for the billing address', 'merge_filter' => 'enabled'), 'shipping_address_street' => array('name' => 'shipping_address_street', 'vname' => 'LBL_SHIPPING_ADDRESS_STREET', 'type' => 'varchar', 'len' => 150, 'group' => 'shipping_address', 'comment' => 'The street address used for for shipping purposes', 'merge_filter' => 'enabled'), 'shipping_address_city' => array('name' => 'shipping_address_city', 'vname' => 'LBL_SHIPPING_ADDRESS_CITY', 'type' => 'varchar', 'len' => 100, 'group' => 'shipping_address', 'comment' => 'The city used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_state' => array('name' => 'shipping_address_state', 'vname' => 'LBL_SHIPPING_ADDRESS_STATE', 'type' => 'varchar', 'len' => 100, 'group' => 'shipping_address', 'comment' => 'The state used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_postalcode' => array('name' => 'shipping_address_postalcode', 'vname' => 'LBL_SHIPPING_ADDRESS_POSTALCODE', 'type' => 'varchar', 'len' => 20, 'group' => 'shipping_address', 'comment' => 'The zip code used for the shipping address', 'merge_filter' => 'enabled'), 'shipping_address_country' => array('name' => 'shipping_address_country', 'vname' => 'LBL_SHIPPING_ADDRESS_COUNTRY', 'type' => 'varchar', 'group' => 'shipping_address', 'comment' => 'The country used for the shipping address', 'merge_filter' => 'enabled'), 'number' => array('required' => true, 'name' => 'number', 'vname' => 'LBL_INVOICE_NUMBER', 'type' => 'int', 'len' => 11, 'isnull' => 'false', 'unified_search' => true, 'comments' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'reportable' => true, 'disable_num_format' => true), 'line_items' => array('required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => array('name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'total_amt' => array('required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'subtotal_amount' => array('required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'discount_amount' => array('required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'tax_amount' => array('required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'shipping_amount' => array('required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6'), 'shipping_tax' => array('required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible'), 'shipping_tax_amt' => array('required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => array('name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'total_amount' => array('required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom'), 'currency_id' => array('required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html')), 'quote_number' => array('required' => false, 'name' => 'quote_number', 'vname' => 'LBL_QUOTE_NUMBER', 'type' => 'int', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '11', 'disable_num_format' => ''), 'quote_date' => array('required' => false, 'name' => 'quote_date', 'vname' => 'LBL_QUOTE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'display_default' => 'now', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'invoice_date' => array('required' => false, 'name' => 'invoice_date', 'vname' => 'LBL_INVOICE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'display_default' => 'now', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'due_date' => array('required' => false, 'name' => 'due_date', 'vname' => 'LBL_DUE_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'status' => array('required' => false, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'invoice_status_dom', 'studio' => 'visible'), 'template_ddown_c' => array('required' => '0', 'name' => 'template_ddown_c', 'vname' => 'LBL_TEMPLATE_DDOWN_C', 'type' => 'multienum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'options' => 'template_ddown_c_list', 'studio' => 'visible', 'isMultiSelect' => true), 'subtotal_tax_amount' => array('required' => false, 'name' => 'subtotal_tax_amount', 'vname' => 'LBL_SUBTOTAL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'aos_quotes_aos_invoices' => array('name' => 'aos_quotes_aos_invoices', 'type' => 'link', 'relationship' => 'aos_quotes_aos_invoices', 'source' => 'non-db', 'module' => 'AOS_Quotes'), 'aos_products_quotes' => array('name' => 'aos_products_quotes', 'type' => 'link', 'relationship' => 'aos_invoices_aos_product_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db')), 'relationships' => array('aos_invoices_aos_product_quotes' => array('lhs_module' => 'AOS_Invoices', 'lhs_table' => 'aos_invoices', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Products_Quotes', 'rhs_table' => 'aos_products_quotes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many')), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('AOS_Invoices', 'AOS_Invoices', array('basic', 'assignable'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['SavedSearch'] = array('table' => 'saved_search', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false), 'name' => array('name' => 'name', 'type' => 'varchar', 'vname' => 'LBL_NAME', 'len' => 150), 'search_module' => array('name' => 'search_module', 'type' => 'varchar', 'vname' => 'LBL_MODULE', 'len' => 150), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_CREATED_BY', 'type' => 'bool', 'required' => true, 'reportable' => false), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'massupdate' => false), 'assigned_user_name' => array('name' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'type' => 'varchar', 'reportable' => false, 'massupdate' => false, 'source' => 'non-db', 'table' => 'users'), 'contents' => array('name' => 'contents', 'type' => 'text', 'vname' => 'LBL_DESCRIPTION', 'isnull' => true), 'description' => array('name' => 'description', 'type' => 'text', 'vname' => 'LBL_DESCRIPTION', 'isnull' => true), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'saved_search_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db')), 'relationships' => array('saved_search_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'SavedSearch', 'rhs_table' => 'saved_search', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many')), 'indices' => array(array('name' => 'savedsearchpk', 'type' => 'primary', 'fields' => array('id')), array('name' => 'idx_desc', 'type' => 'index', 'fields' => array('name', 'deleted'))));
VardefManager::createVardef('SavedSearch', 'SavedSearch', array());
<?php
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
$dictionary['Services'] = array('audited' => true, 'comment' => '', 'table' => 'services', 'unified_search' => true, 'fields' => array('code' => array('name' => 'code', 'vname' => 'LBL_RES_CODE', 'type' => 'varchar', 'len' => 50, 'comment' => 'id of one restaurant'), 'autocode' => array('required' => '1', 'name' => 'autocode', 'vname' => '', 'type' => 'int', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => '25'), 'tel' => array('name' => 'tel', 'vname' => 'LBL_RES_TEL', 'type' => 'phone', 'dbType' => 'varchar', 'len' => 50, 'comment' => 'tel of service company', 'audited' => true), 'address' => array('name' => 'address', 'vname' => 'LBL_RES_ADDRESS', 'type' => 'text', 'len' => 250, 'comment' => 'address of restaurant'), 'service_type' => array('name' => 'service_type', 'vname' => 'LBL_SERVICE_TYPE', 'type' => 'enum', 'options' => 'service_company_dom'), 'giathamkhao' => array('name' => 'giathamkhao', 'vname' => 'LBL_GIATHAMKHAO', 'type' => 'currency', 'dbType' => 'double'), 'ngaythamkhaogia' => array('name' => 'ngaythamkhaogia', 'vname' => 'LBL_NGAYTHAMKHAOGIA', 'type' => 'date'), 'area' => array('name' => 'area', 'vname' => 'LBL_AREA', 'type' => 'enum', 'options' => 'khachsan_area'), 'email1' => array('name' => 'email1', 'vname' => 'LBL_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email1', 'merge_filter' => 'enabled'), 'email2' => array('name' => 'email2', 'vname' => 'LBL_OTHER_EMAIL_ADDRESS', 'type' => 'varchar', 'function' => array('name' => 'getEmailAddressWidget', 'returns' => 'html'), 'source' => 'non-db', 'group' => 'email2', 'merge_filter' => 'enabled'), 'email_addresses' => array('name' => 'email_addresses', 'type' => 'link', 'relationship' => 'service_email_addresses', 'module' => 'EmailAddress', 'bean_name' => 'EmailAddress', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'required' => true), 'email_addresses_primary' => array('name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => 'service_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled', 'required' => true)), 'indices' => array(array('name' => 'idx_service_id_del', 'type' => 'index', 'fields' => array('id', 'deleted')), array('name' => 'autocode', 'type' => 'unique', 'fields' => array('autocode')), array('name' => 'code', 'type' => 'unique', 'fields' => array('code'))), 'relationship' => array('service_email_addresses' => array('lhs_module' => "Services", 'lhs_table' => 'services', 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'bean_module', 'relationship_role_column_value' => "Services"), 'service_email_addresses_primary' => array('lhs_module' => "Services", 'lhs_table' => 'services', 'lhs_key' => 'id', 'rhs_module' => 'EmailAddresses', 'rhs_table' => 'email_addresses', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'email_addr_bean_rel', 'join_key_lhs' => 'bean_id', 'join_key_rhs' => 'email_address_id', 'relationship_role_column' => 'primary_address', 'relationship_role_column_value' => '1')), 'optimistic_lock' => true);
VardefManager::createVardef('Services', 'Services', array('default', 'assignable'));
*
* You should have received a copy of the GNU General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU General Public License version 3.
*
* In accordance with Section 7(b) of the GNU General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['oqc_TextBlock'] = array('table' => 'oqc_textblock', 'audited' => true, 'fields' => array('is_default' => array('required' => false, 'name' => 'is_default', 'vname' => 'LBL_IS_DEFAULT', 'type' => 'bool', 'massupdate' => 0, 'comments' => 'Soll dieser Textbaustein für neue Verträge automatisch selektiert werden?', 'help' => 'Beim erstellen neuer Verträge können Textbausteine automatisch vorselektiert werden. Geben Sie hier bitte an ob dieser Textbaustein vorselektiert werden soll?', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 1, 'reportable' => 0), 'description' => array('required' => false, 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'massupdate' => 0, 'comments' => 'comment', 'help' => 'help', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 1, 'reportable' => 0, 'studio' => 'false'), 'oqc_textblockedit' => array('required' => false, 'name' => 'oqc_textblockedit', 'vname' => 'LBL_DESCRIPTION', 'type' => 'varchar', 'source' => 'non-db', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'function' => array('name' => 'getSingleTextblockHtml', 'returns' => 'html', 'include' => 'include/oqc/Textblocks/Textblocks.php'))), 'relationships' => array(), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('oqc_TextBlock', 'oqc_TextBlock', array('basic', 'issue'));
// additional issue fields beside *_number are not neccessary
unset($dictionary['oqc_TextBlock']['fields']['type']);
unset($dictionary['oqc_TextBlock']['fields']['status']);
unset($dictionary['oqc_TextBlock']['fields']['priority']);
unset($dictionary['oqc_TextBlock']['fields']['resolution']);
unset($dictionary['oqc_TextBlock']['fields']['work_log']);
// repair the name field
$dictionary['oqc_TextBlock']['fields']['name']['required'] = true;
$dictionary['oqc_TextBlock']['fields']['name']['comment'] = 'Short description';
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['Project'] = array('table' => 'project', 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => false, 'comment' => 'Project', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'required' => true, 'type' => 'id', 'reportable' => true, 'comment' => 'Unique identifier'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'type' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_USER_ID', 'required' => false, 'len' => 36, 'dbType' => 'id', 'table' => 'users', 'isnull' => false, 'reportable' => true, 'comment' => 'User assigned to this record'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_USER_ID', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), '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'), 'created_by' => array('name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED_BY', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'comment' => 'User who created record'), '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'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'required' => true, 'dbType' => 'varchar', 'type' => 'name', 'len' => 50, 'unified_search' => true, 'full_text_search' => array('boost' => 3), 'comment' => 'Project name', 'importable' => 'required', 'required' => true), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'required' => false, 'type' => 'text', 'comment' => 'Project description'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'default' => '0', 'comment' => 'Record deletion indicator'), 'estimated_start_date' => array('name' => 'estimated_start_date', 'vname' => 'LBL_DATE_START', 'required' => true, 'validation' => array('type' => 'isbefore', 'compareto' => 'estimated_end_date', 'blank' => true), 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'estimated_end_date' => array('name' => 'estimated_end_date', 'vname' => 'LBL_DATE_END', 'required' => true, 'type' => 'date', 'importable' => 'required', 'required' => true, 'enable_range_search' => true), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'project_status_dom'), 'priority' => array('name' => 'priority', 'vname' => 'LBL_PRIORITY', 'type' => 'enum', 'options' => 'projects_priority_options'), 'total_estimated_effort' => array('name' => 'total_estimated_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ESTIMATED_EFFORT'), 'total_actual_effort' => array('name' => 'total_actual_effort', 'type' => 'int', 'source' => 'non-db', 'vname' => 'LBL_LIST_TOTAL_ACTUAL_EFFORT'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'projects_accounts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_ACCOUNTS'), 'quotes' => array('name' => 'quotes', 'type' => 'link', 'relationship' => 'projects_quotes', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_QUOTES'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'projects_contacts', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_CONTACTS'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'projects_opportunities', 'source' => 'non-db', 'ignore_role' => true, 'vname' => 'LBL_OPPORTUNITIES'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'projects_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'projects_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'projects_meetings', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'projects_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_projects_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'projecttask' => array('name' => 'projecttask', 'type' => 'link', 'relationship' => 'projects_project_tasks', 'source' => 'non-db', 'vname' => 'LBL_PROJECT_TASKS'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'projects_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'projects_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'projects_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_USER_NAME', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'dbType' => 'varchar', 'link' => 'users', 'len' => '255', 'source' => 'non-db'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'projects_cases', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'bugs' => array('name' => 'bugs', 'type' => 'link', 'relationship' => 'projects_bugs', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_BUGS'), 'products' => array('name' => 'products', 'type' => 'link', 'relationship' => 'projects_products', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_PRODUCTS'), 'project_users_1' => array('name' => 'project_users_1', 'type' => 'link', 'relationship' => 'project_users_1', 'source' => 'non-db', 'module' => 'Users', 'bean_name' => 'User', 'vname' => 'LBL_PROJECT_USERS_1_FROM_USERS_TITLE'), 'am_projecttemplates_project_1' => array('name' => 'am_projecttemplates_project_1', 'type' => 'link', 'relationship' => 'am_projecttemplates_project_1', 'source' => 'non-db', 'module' => 'AM_ProjectTemplates', 'bean_name' => 'AM_ProjectTemplates', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_AM_PROJECTTEMPLATES_TITLE', 'id_name' => 'am_projecttemplates_project_1am_projecttemplates_ida'), 'am_projecttemplates_project_1_name' => array('name' => 'am_projecttemplates_project_1_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_AM_PROJECTTEMPLATES_TITLE', 'save' => true, 'id_name' => 'am_projecttemplates_project_1am_projecttemplates_ida', 'link' => 'am_projecttemplates_project_1', 'table' => 'am_projecttemplates', 'module' => 'AM_ProjectTemplates', 'rname' => 'name'), 'am_projecttemplates_project_1am_projecttemplates_ida' => array('name' => 'am_projecttemplates_project_1am_projecttemplates_ida', 'type' => 'link', 'relationship' => 'am_projecttemplates_project_1', 'source' => 'non-db', 'reportable' => false, 'side' => 'right', 'vname' => 'LBL_AM_PROJECTTEMPLATES_PROJECT_1_FROM_PROJECT_TITLE'), 'project_contacts_1' => array('name' => 'project_contacts_1', 'type' => 'link', 'relationship' => 'project_contacts_1', 'source' => 'non-db', 'module' => 'Contacts', 'bean_name' => 'Contact', 'vname' => 'LBL_PROJECT_CONTACTS_1_FROM_CONTACTS_TITLE'), 'aos_quotes_project' => array('name' => 'aos_quotes_project', 'type' => 'link', 'relationship' => 'aos_quotes_project', 'source' => 'non-db')), 'indices' => array(array('name' => 'projects_primary_key_index', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('projects_notes' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_meetings' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_calls' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_emails' => array('lhs_module' => 'Project', 'lhs_table' => 'project', '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' => 'Project'), 'projects_project_tasks' => array('lhs_module' => 'Project', 'lhs_table' => 'project', 'lhs_key' => 'id', 'rhs_module' => 'ProjectTask', 'rhs_table' => 'project_task', 'rhs_key' => 'project_id', 'relationship_type' => 'one-to-many'), 'projects_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'projects_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'projects_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Project', 'rhs_table' => 'project', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many')));
VardefManager::createVardef('Project', 'Project', array('security_groups'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['opalo_cotizacion'] = array('table' => 'opalo_cotizacion', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('consecutivo' => array('required' => false, 'name' => 'consecutivo', 'vname' => 'LBL_CONSECUTIVO', 'type' => 'int', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '1', 'min' => false, 'max' => false), 'total' => array('required' => false, 'name' => 'total', 'vname' => 'LBL_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'currency_id' => array('required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'currency_id', 'massupdate' => 0, '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' => 36, 'size' => '20', 'dbType' => 'id', 'studio' => 'visible', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html')), 'subtotal' => array('required' => false, 'name' => 'subtotal', 'vname' => 'LBL_SUBTOTAL', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'impuestos' => array('required' => false, 'name' => 'impuestos', 'vname' => 'LBL_IMPUESTOS', 'type' => 'currency', 'massupdate' => 0, 'default' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 26, 'size' => '20', 'enable_range_search' => false, 'precision' => 6), 'proximo_seguimiento' => array('required' => true, 'name' => 'proximo_seguimiento', 'vname' => 'LBL_PROXIMO_SEGUIMIENTO', 'type' => 'date', 'massupdate' => '1', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'size' => '20', 'enable_range_search' => false, 'display_default' => '+1 week'), 'descuento' => array('required' => false, 'name' => 'descuento', 'vname' => 'LBL_DESCUENTO', 'type' => 'decimal', 'massupdate' => 0, 'default' => '0.00000', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '10', 'size' => '20', 'enable_range_search' => false, 'precision' => '5')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('opalo_cotizacion', 'opalo_cotizacion', array('basic', 'assignable'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['InboundEmail'] = array('table' => 'inbound_email', 'comment' => 'Inbound email parameters', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'dbType' => 'varchar', 'len' => 36, 'required' => true, 'reportable' => false, 'comment' => 'Unique identifier'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'default' => '0', 'reportable' => false, 'comment' => 'Record deltion indicator'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record created'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record last modified'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_BY', 'type' => 'modified_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record'), 'modified_user_id_link' => array('name' => 'modified_user_id_link', 'type' => 'link', 'relationship' => 'inbound_email_modified_user_id', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'created_by' => array('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', 'comment' => 'User who created record'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'inbound_email_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '255', 'required' => false, 'reportable' => false, 'comment' => 'Name given to the inbound email mailbox'), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'varchar', 'len' => 100, 'default' => 'Active', 'required' => true, 'reportable' => false, 'comment' => 'Status of the inbound email mailbox (ex: Active or Inactive)'), 'server_url' => array('name' => 'server_url', 'vname' => 'LBL_SERVER_URL', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'Mail server URL', 'importable' => 'required'), 'email_user' => array('name' => 'email_user', 'vname' => 'LBL_LOGIN', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'User name allowed access to mail server'), 'email_password' => array('name' => 'email_password', 'vname' => 'LBL_PASSWORD', 'type' => 'varchar', 'len' => '100', 'required' => true, 'reportable' => false, 'comment' => 'Password of user identified by email_user'), 'port' => array('name' => 'port', 'vname' => 'LBL_SERVER_TYPE', 'type' => 'int', 'len' => '5', 'required' => true, 'reportable' => false, 'validation' => array('type' => 'range', 'min' => '110', 'max' => '65535'), 'comment' => 'Port used to access mail server'), 'service' => array('name' => 'service', 'vname' => 'LBL_SERVICE', 'type' => 'varchar', 'len' => '50', 'required' => true, 'reportable' => false, 'comment' => '', 'importable' => 'required'), 'mailbox' => array('name' => 'mailbox', 'vname' => 'LBL_MAILBOX', 'type' => 'text', 'required' => true, 'reportable' => false, 'comment' => ''), 'delete_seen' => array('name' => 'delete_seen', 'vname' => 'LBL_DELETE_SEEN', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'massupdate' => '', 'comment' => 'Delete email from server once read (seen)'), 'mailbox_type' => array('name' => 'mailbox_type', 'vname' => 'LBL_MAILBOX_TYPE', 'type' => 'varchar', 'len' => '10', 'reportable' => false, 'comment' => ''), 'template_id' => array('name' => 'template_id', 'vname' => 'LBL_AUTOREPLY', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'Template used for auto-reply'), 'stored_options' => array('name' => 'stored_options', 'vname' => 'LBL_STORED_OPTIONS', 'type' => 'text', 'reportable' => false, 'comment' => ''), 'group_id' => array('name' => 'group_id', 'vname' => 'LBL_GROUP_ID', 'type' => 'id', 'reportable' => false, 'comment' => 'Group ID (unused)'), 'is_personal' => array('name' => 'is_personal', 'vname' => 'LBL_IS_PERSONAL', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, 'massupdate' => '', 'comment' => 'Personal account flag'), 'groupfolder_id' => array('name' => 'groupfolder_id', 'vname' => 'LBL_GROUPFOLDER_ID', 'type' => 'id', 'required' => false, 'reportable' => false, 'comment' => 'Unique identifier')), 'indices' => array(array('name' => 'inbound_emailpk', 'type' => 'primary', 'fields' => array('id'))), 'relationships' => array('inbound_email_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'InboundEmail', 'rhs_table' => 'inbound_email', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-one'), 'inbound_email_modified_user_id' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'InboundEmail', 'rhs_table' => 'inbound_email', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-one')));
VardefManager::createVardef('InboundEmail', 'InboundEmail', array());
<?php
/*
* Your installation or use of this SugarCRM file is subject to the applicable
* terms available at
* http://support.sugarcrm.com/06_Customer_Center/10_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['EAPM'] = array('table' => 'eapm', 'audited' => false, 'fields' => array('password' => array('required' => true, 'name' => 'password', 'vname' => 'LBL_PASSWORD', 'type' => 'encrypt', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => false, 'len' => '255', 'size' => '20', 'write_only' => true), 'url' => array('required' => true, 'name' => 'url', 'vname' => 'LBL_URL', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'application' => array('required' => true, 'name' => 'application', 'vname' => 'LBL_APPLICATION', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'function' => 'getEAPMExternalApiDropDown', 'studio' => 'visible', 'default' => 'webex'), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'full_text_search' => array('enabled' => true, 'boost' => 3), 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'api_data' => array('name' => 'api_data', 'vname' => 'LBL_API_DATA', 'type' => 'text', 'comment' => 'Any API data that the external API may wish to store on a per-user basis', 'rows' => 6, 'cols' => 80), 'consumer_key' => array('name' => 'consumer_key', 'type' => 'varchar', 'vname' => 'LBL_API_CONSKEY', 'importable' => 'required', 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'studio' => 'hidden'), 'consumer_secret' => array('name' => 'consumer_secret', 'type' => 'varchar', 'vname' => 'LBL_API_CONSSECRET', 'importable' => 'required', 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'studio' => 'hidden'), 'oauth_token' => array('name' => 'oauth_token', 'type' => 'varchar', 'vname' => 'LBL_API_OAUTHTOKEN', 'importable' => false, 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'required' => false, 'studio' => 'hidden'), 'oauth_secret' => array('name' => 'oauth_secret', 'type' => 'varchar', 'vname' => 'LBL_API_OAUTHSECRET', 'importable' => false, 'massupdate' => 0, 'audited' => false, 'reportable' => false, 'required' => false, 'studio' => 'hidden'), 'validated' => array('required' => false, 'name' => 'validated', 'vname' => 'LBL_VALIDATED', 'type' => 'bool', 'default' => false), 'note' => array('name' => 'note', 'vname' => 'LBL_NOTE', 'required' => false, 'reportable' => false, 'importable' => false, 'massupdate' => false, 'studio' => 'hidden', 'type' => 'varchar', 'source' => 'non-db')), 'relationships' => array(), 'indices' => array(array('name' => 'idx_app_active', 'type' => 'index', 'fields' => array('assigned_user_id', 'application', 'validated')), array('name' => 'idx_eapm_name', 'type' => 'index', 'fields' => array('name'))), 'optimistic_locking' => true, 'visibility' => array('OwnerOrAdminVisibility' => true));
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('EAPM', 'EAPM', array('basic', 'assignable'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['glam_Glam_Envio_Informacion'] = array('table' => 'glam_glam_envio_informacion', 'audited' => true, 'inline_edit' => true, 'duplicate_merge' => true, 'fields' => array('estado' => array('required' => false, 'name' => 'estado', 'vname' => 'LBL_ESTADO', 'type' => 'varchar', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20'), 'ciudad' => array('required' => false, 'name' => 'ciudad', 'vname' => 'LBL_CIUDAD', 'type' => 'varchar', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20'), 'codigopostal' => array('required' => false, 'name' => 'codigopostal', 'vname' => 'LBL_CODIGOPOSTAL', 'type' => 'varchar', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20'), 'direccion' => array('required' => true, 'name' => 'direccion', 'vname' => 'LBL_DIRECCION', 'type' => 'varchar', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20'), 'lead_id_c' => array('required' => false, 'name' => 'lead_id_c', 'vname' => 'LBL_CLIENTESPOTENCIALES_LEAD_ID', 'type' => 'id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'inline_edit' => true, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20'), 'clientespotenciales' => array('required' => false, 'source' => 'non-db', 'name' => 'clientespotenciales', 'vname' => 'LBL_CLIENTESPOTENCIALES', 'type' => 'relate', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20', 'id_name' => 'lead_id_c', 'ext2' => 'Leads', 'module' => 'Leads', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'fechadecreacion' => array('required' => false, 'name' => 'fechadecreacion', 'vname' => 'LBL_FECHADECREACION', 'type' => 'date', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'size' => '20', 'enable_range_search' => false), 'metododeenvio' => array('required' => true, 'name' => 'metododeenvio', 'vname' => 'LBL_METODODEENVIO', 'type' => 'dynamicenum', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'metododeenvio_list', 'studio' => 'visible', 'dbType' => 'enum', 'parentenum' => ''), 'estatus' => array('required' => false, 'name' => 'estatus', 'vname' => 'LBL_ESTATUS', 'type' => 'dynamicenum', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'estatus_list', 'studio' => 'visible', 'dbType' => 'enum', 'parentenum' => ''), 'tipo' => array('required' => false, 'name' => 'tipo', 'vname' => 'LBL_TIPO', 'type' => 'dynamicenum', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'tipo_list', 'studio' => 'visible', 'dbType' => 'enum', 'parentenum' => ''), 'tracking' => array('required' => false, 'name' => 'tracking', 'vname' => 'LBL_TRACKING', 'type' => 'varchar', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => '255', 'size' => '20')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('glam_Glam_Envio_Informacion', 'glam_Glam_Envio_Informacion', array('basic', 'assignable'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['Campaign'] = array('audited' => true, 'comment' => 'Campaigns are a series of operations undertaken to accomplish a purpose, usually acquiring leads', 'table' => 'campaigns', 'unified_search' => true, 'full_text_search' => true, 'fields' => array('tracker_key' => array('name' => 'tracker_key', 'vname' => 'LBL_TRACKER_KEY', 'type' => 'int', 'required' => true, 'studio' => array('editview' => false), 'len' => '11', 'auto_increment' => true, 'comment' => 'The internal ID of the tracker used in a campaign; no longer used as of 4.2 (see campaign_trkrs)'), 'tracker_count' => array('name' => 'tracker_count', 'vname' => 'LBL_TRACKER_COUNT', 'type' => 'int', 'len' => '11', 'default' => '0', 'comment' => 'The number of accesses made to the tracker URL; no longer used as of 4.2 (see campaign_trkrs)'), 'name' => array('name' => 'name', 'vname' => 'LBL_CAMPAIGN_NAME', 'dbType' => 'varchar', 'type' => 'name', 'len' => '50', 'comment' => 'The name of the campaign', 'importable' => 'required', 'required' => true, 'unified_search' => true, 'full_text_search' => array('boost' => 3)), 'refer_url' => array('name' => 'refer_url', 'vname' => 'LBL_REFER_URL', 'type' => 'varchar', 'len' => '255', 'default' => 'http://', 'comment' => 'The URL referenced in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)'), 'description' => array('name' => 'description', 'type' => 'none', 'comment' => 'inhertied but not used', 'source' => 'non-db'), 'tracker_text' => array('name' => 'tracker_text', 'vname' => 'LBL_TRACKER_TEXT', 'type' => 'varchar', 'len' => '255', 'comment' => 'The text that appears in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)'), 'start_date' => array('name' => 'start_date', 'vname' => 'LBL_CAMPAIGN_START_DATE', 'type' => 'date', 'audited' => true, 'comment' => 'Starting date of the campaign', 'validation' => array('type' => 'isbefore', 'compareto' => 'end_date'), 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'end_date' => array('name' => 'end_date', 'vname' => 'LBL_CAMPAIGN_END_DATE', 'type' => 'date', 'audited' => true, 'comment' => 'Ending date of the campaign', 'importable' => 'required', 'required' => true, 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'status' => array('name' => 'status', 'vname' => 'LBL_CAMPAIGN_STATUS', 'type' => 'enum', 'options' => 'campaign_status_dom', 'len' => 100, 'audited' => true, 'comment' => 'Status of the campaign', 'importable' => 'required', 'required' => true), 'impressions' => array('name' => 'impressions', 'vname' => 'LBL_CAMPAIGN_IMPRESSIONS', 'type' => 'int', 'default' => 0, 'reportable' => true, 'comment' => 'Expected Click throughs manually entered by Campaign Manager'), 'currency_id' => array('name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'group' => 'currency_id', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html'), 'required' => false, 'do_report' => false, 'reportable' => false, 'comment' => 'Currency in use for the campaign'), 'budget' => array('name' => 'budget', 'vname' => 'LBL_CAMPAIGN_BUDGET', 'type' => 'currency', 'dbType' => 'double', 'comment' => 'Budgeted amount for the campaign'), 'expected_cost' => array('name' => 'expected_cost', 'vname' => 'LBL_CAMPAIGN_EXPECTED_COST', 'type' => 'currency', 'dbType' => 'double', 'comment' => 'Expected cost of the campaign'), 'actual_cost' => array('name' => 'actual_cost', 'vname' => 'LBL_CAMPAIGN_ACTUAL_COST', 'type' => 'currency', 'dbType' => 'double', 'comment' => 'Actual cost of the campaign'), 'expected_revenue' => array('name' => 'expected_revenue', 'vname' => 'LBL_CAMPAIGN_EXPECTED_REVENUE', 'type' => 'currency', 'dbType' => 'double', 'comment' => 'Expected revenue stemming from the campaign'), 'campaign_type' => array('name' => 'campaign_type', 'vname' => 'LBL_CAMPAIGN_TYPE', 'type' => 'enum', 'options' => 'campaign_type_dom', 'len' => 100, 'audited' => true, 'comment' => 'The type of campaign', 'importable' => 'required', 'required' => true), 'objective' => array('name' => 'objective', 'vname' => 'LBL_CAMPAIGN_OBJECTIVE', 'type' => 'text', 'comment' => 'The objective of the campaign'), 'content' => array('name' => 'content', 'vname' => 'LBL_CAMPAIGN_CONTENT', 'type' => 'text', 'comment' => 'The campaign description'), 'prospectlists' => array('name' => 'prospectlists', 'type' => 'link', 'relationship' => 'prospect_list_campaigns', 'source' => 'non-db'), 'emailmarketing' => array('name' => 'emailmarketing', 'type' => 'link', 'relationship' => 'campaign_email_marketing', 'source' => 'non-db'), 'queueitems' => array('name' => 'queueitems', 'type' => 'link', 'relationship' => 'campaign_emailman', 'source' => 'non-db'), 'log_entries' => array('name' => 'log_entries', 'type' => 'link', 'relationship' => 'campaign_campaignlog', 'source' => 'non-db', 'vname' => 'LBL_LOG_ENTRIES'), 'tracked_urls' => array('name' => 'tracked_urls', 'type' => 'link', 'relationship' => 'campaign_campaigntrakers', 'source' => 'non-db', 'vname' => 'LBL_TRACKED_URLS'), 'frequency' => array('name' => 'frequency', 'vname' => 'LBL_CAMPAIGN_FREQUENCY', 'type' => 'enum', 'len' => 100, 'comment' => 'Frequency of the campaign', 'options' => 'newsletter_frequency_dom', 'len' => 100), 'leads' => array('name' => 'leads', 'type' => 'link', 'relationship' => 'campaign_leads', 'source' => 'non-db', 'vname' => 'LBL_LEADS', 'link_class' => 'ProspectLink', 'link_file' => 'modules/Campaigns/ProspectLink.php'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'campaign_opportunities', 'source' => 'non-db', 'vname' => 'LBL_OPPORTUNITIES'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'campaign_contacts', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS', 'link_class' => 'ProspectLink', 'link_file' => 'modules/Campaigns/ProspectLink.php'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'campaign_accounts', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNTS', 'link_class' => 'ProspectLink', 'link_file' => 'modules/Campaigns/ProspectLink.php')), 'indices' => array(array('name' => 'camp_auto_tracker_key', 'type' => 'index', 'fields' => array('tracker_key')), array('name' => 'idx_campaign_name', 'type' => 'index', 'fields' => array('name'))), 'relationships' => array('campaign_accounts' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'Accounts', 'rhs_table' => 'accounts', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_contacts' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'Contacts', 'rhs_table' => 'contacts', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_leads' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_prospects' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'Prospects', 'rhs_table' => 'prospects', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_opportunities' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'Opportunities', 'rhs_table' => 'opportunities', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_email_marketing' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'EmailMarketing', 'rhs_table' => 'email_marketing', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_emailman' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'EmailMan', 'rhs_table' => 'emailman', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_campaignlog' => array('lhs_module' => 'Campaigns', 'lhs_table' => 'campaigns', 'lhs_key' => 'id', 'rhs_module' => 'CampaignLog', 'rhs_table' => 'campaign_log', 'rhs_key' => 'campaign_id', 'relationship_type' => 'one-to-many'), 'campaign_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Campaigns', 'rhs_table' => 'campaigns', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'campaign_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Campaigns', 'rhs_table' => 'campaigns', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many')));
VardefManager::createVardef('Campaigns', 'Campaign', array('default', 'assignable'));
<?php
$dictionary['jjwg_Maps'] = array('table' => 'jjwg_maps', 'audited' => true, 'fields' => array('distance' => array('required' => true, 'name' => 'distance', 'vname' => 'LBL_DISTANCE', 'type' => 'float', 'massupdate' => 0, 'comments' => '', 'help' => 'Distance', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'len' => '9', 'size' => '20', 'precision' => '4'), 'unit_type' => array('required' => true, 'name' => 'unit_type', 'vname' => 'LBL_UNIT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'mi', 'comments' => '', 'help' => 'Unit Type (mi/km)', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'map_unit_type_list', 'studio' => 'visible', 'dependency' => false), 'module_type' => array('required' => true, 'name' => 'module_type', 'vname' => 'LBL_MODULE_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Accounts', 'comments' => '', 'help' => 'Module Type to Display', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'map_module_type_list', 'studio' => 'visible', 'dependency' => false), 'parent_name' => array('required' => true, 'source' => 'non-db', 'name' => 'parent_name', 'vname' => 'LBL_FLEX_RELATE', 'type' => 'parent', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'len' => 25, 'size' => '20', 'options' => 'map_relate_type_list', 'studio' => 'visible', 'type_name' => 'parent_type', 'id_name' => 'parent_id', 'parent_type' => 'record_type_display'), 'parent_type' => array('required' => false, 'name' => 'parent_type', 'vname' => 'LBL_PARENT_TYPE', 'type' => 'parent_type', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 255, 'size' => '20', 'dbType' => 'varchar', 'studio' => 'hidden'), 'parent_id' => array('required' => false, 'name' => 'parent_id', 'vname' => 'LBL_PARENT_ID', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20')), 'relationships' => array(), 'optimistic_locking' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('jjwg_Maps', 'jjwg_Maps', array('basic', 'assignable'));
<?php
/*********************************************************************************
* By installing or using this file, you are confirming on behalf of the entity
* subscribed to the SugarCRM Inc. product ("Company") that Company is bound by
* the SugarCRM Inc. Master Subscription Agreement (“MSA”), which is viewable at:
* http://www.sugarcrm.com/master-subscription-agreement
*
* If Company is not bound by the MSA, then by installing or using this file
* you are agreeing unconditionally that Company will be bound by the MSA and
* certifying that you have authority to bind Company accordingly.
*
* Copyright (C) 2004-2013 SugarCRM Inc. All rights reserved.
********************************************************************************/
$dictionary['NEPO_DEMO'] = array('table' => 'nepo_demo', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('webservice_id' => array('required' => false, 'name' => 'webservice_id', 'vname' => 'LBL_WEBSERVICE_ID', 'type' => 'int', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'calculated' => false, 'len' => '255', 'size' => '20', 'enable_range_search' => false, 'disable_num_format' => '1', 'min' => false, 'max' => false), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'options' => 'case_status_dom', 'len' => 100, 'audited' => true, 'comment' => 'The status of the case', 'merge_filter' => 'enabled')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('NEPO_DEMO', 'NEPO_DEMO', array('basic', 'assignable'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['AOS_Contracts'] = array('table' => 'aos_contracts', 'audited' => true, 'fields' => array('reference_code' => array('required' => false, 'name' => 'reference_code', 'vname' => 'LBL_REFERENCE_CODE ', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '255', 'size' => '20'), 'start_date' => array('required' => false, 'name' => 'start_date', 'vname' => 'LBL_START_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => 'now'), 'end_date' => array('required' => false, 'name' => 'end_date', 'vname' => 'LBL_END_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'display_default' => '+1 year'), 'total_contract_value' => array('required' => false, 'name' => 'total_contract_value', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom'), 'total_contract_value_usdollar' => array('name' => 'total_contract_value_usdollar', 'vname' => 'LBL_TOTAL_CONTRACT_VALUE_USDOLLAR', 'type' => 'currency', 'group' => 'amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'currency_id' => array('required' => false, 'name' => 'currency_id', 'vname' => 'LBL_CURRENCY', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => true, 'len' => 36, 'size' => '20', 'studio' => 'visible', 'function' => array('name' => 'getCurrencyDropDown', 'returns' => 'html')), 'status' => array('required' => true, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Not Started', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_status_list', 'studio' => 'visible', 'dependency' => false), 'customer_signed_date' => array('required' => false, 'name' => 'customer_signed_date', 'vname' => 'LBL_CUSTOMER_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false), 'company_signed_date' => array('required' => false, 'name' => 'company_signed_date', 'vname' => 'LBL_COMPANY_SIGNED_DATE', 'type' => 'date', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => false), 'renewal_reminder_date' => array('required' => false, 'name' => 'renewal_reminder_date', 'vname' => 'LBL_RENEWAL_REMINDER_DATE', 'dbType' => 'datetime', 'type' => 'datetimecombo', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'enable_range_search' => true, 'options' => 'date_range_search_dom'), 'contract_type' => array('required' => false, 'name' => 'contract_type', 'vname' => 'LBL_CONTRACT_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Type', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => 100, 'size' => '20', 'options' => 'contract_type_list', 'studio' => 'visible', 'dependency' => false), 'contract_account_id' => array('required' => false, 'name' => 'contract_account_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'contract_account' => array('required' => true, 'source' => 'non-db', 'name' => 'contract_account', 'vname' => 'LBL_CONTRACT_ACCOUNT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'relationship' => 'account_aos_contracts', 'len' => '255', 'id_name' => 'contract_account_id', 'ext2' => 'Accounts', 'module' => 'Accounts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'opportunity_id' => array('required' => false, 'name' => 'opportunity_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'opportunity' => array('required' => false, 'source' => 'non-db', 'name' => 'opportunity', 'vname' => 'LBL_OPPORTUNITY', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'opportunity_id', 'ext2' => 'Opportunities', 'module' => 'Opportunities', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'contact_id' => array('required' => false, 'name' => 'contact_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'contact' => array('required' => false, 'source' => 'non-db', 'name' => 'contact', 'vname' => 'LBL_CONTACT', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '255', 'id_name' => 'contact_id', 'ext2' => 'Contacts', 'module' => 'Contacts', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'call_id' => array('required' => false, 'name' => 'call_id', 'vname' => '', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36), 'name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'dbType' => 'varchar', 'len' => '255', 'unified_search' => true, 'required' => true, 'importable' => 'required', 'massupdate' => 0, 'comments' => '', 'help' => '', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'line_items' => array('required' => false, 'name' => 'line_items', 'vname' => 'LBL_LINE_ITEMS', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'function' => array('name' => 'display_lines', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'total_amt' => array('required' => false, 'name' => 'total_amt', 'vname' => 'LBL_TOTAL_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'total_amt_usdollar' => array('name' => 'total_amt_usdollar', 'vname' => 'LBL_TOTAL_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'total_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'subtotal_amount' => array('required' => false, 'name' => 'subtotal_amount', 'vname' => 'LBL_SUBTOTAL_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'subtotal_amount_usdollar' => array('name' => 'subtotal_amount_usdollar', 'vname' => 'LBL_SUBTOTAL_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'subtotal_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'discount_amount' => array('required' => false, 'name' => 'discount_amount', 'vname' => 'LBL_DISCOUNT_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'discount_amount_usdollar' => array('name' => 'discount_amount_usdollar', 'vname' => 'LBL_DISCOUNT_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'discount_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'tax_amount' => array('required' => false, 'name' => 'tax_amount', 'vname' => 'LBL_TAX_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => true, 'len' => '26,6'), 'tax_amount_usdollar' => array('name' => 'tax_amount_usdollar', 'vname' => 'LBL_TAX_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'tax_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'shipping_amount' => array('required' => false, 'name' => 'shipping_amount', 'vname' => 'LBL_SHIPPING_AMOUNT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6'), 'shipping_amount_usdollar' => array('name' => 'shipping_amount_usdollar', 'vname' => 'LBL_SHIPPING_AMOUNT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'shipping_tax' => array('required' => false, 'name' => 'shipping_tax', 'vname' => 'LBL_SHIPPING_TAX', 'type' => 'enum', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => 100, 'options' => 'vat_list', 'studio' => 'visible'), 'shipping_tax_amt' => array('required' => false, 'name' => 'shipping_tax_amt', 'vname' => 'LBL_SHIPPING_TAX_AMT', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => true, 'len' => '26,6', 'size' => '10', 'enable_range_search' => false, 'function' => array('name' => 'display_shipping_vat', 'returns' => 'html', 'include' => 'modules/AOS_Products_Quotes/Line_Items.php')), 'shipping_tax_amt_usdollar' => array('name' => 'shipping_tax_amt_usdollar', 'vname' => 'LBL_SHIPPING_TAX_AMT_USDOLLAR', 'type' => 'currency', 'group' => 'shipping_tax_amt', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'total_amount' => array('required' => false, 'name' => 'total_amount', 'vname' => 'LBL_GRAND_TOTAL', 'type' => 'currency', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'len' => '26,6', 'enable_range_search' => true, 'options' => 'numeric_range_search_dom'), 'total_amount_usdollar' => array('name' => 'total_amount_usdollar', 'vname' => 'LBL_GRAND_TOTAL_USDOLLAR', 'type' => 'currency', 'group' => 'total_amount', 'disable_num_format' => true, 'duplicate_merge' => '0', 'audited' => true, 'comment' => '', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false), 'len' => '26,6'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'account_aos_contracts', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'contact_aos_contracts', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'aos_contracts_tasks', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'aos_contracts_notes', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'aos_contracts_meetings', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'aos_contracts_calls', 'module' => 'Calls', 'bean_name' => 'Call', 'source' => 'non-db'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_aos_contracts_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'aos_quotes_aos_contracts' => array('name' => 'aos_quotes_aos_contracts', 'type' => 'link', 'relationship' => 'aos_quotes_aos_contracts', 'source' => 'non-db', 'module' => 'AOS_Quotes'), "documents" => array('name' => 'documents', 'type' => 'link', 'relationship' => 'aos_contracts_documents', 'source' => 'non-db', 'module' => 'Documents'), "aos_products_quotes" => array('name' => 'aos_products_quotes', 'type' => 'link', 'relationship' => 'aos_contracts_aos_products_quotes', 'module' => 'AOS_Products_Quotes', 'bean_name' => 'AOS_Products_Quotes', 'source' => 'non-db'), 'aos_line_item_groups' => array('name' => 'aos_line_item_groups', 'type' => 'link', 'relationship' => 'aos_contracts_aos_line_item_groups', 'module' => 'AOS_Line_Item_Groups', 'bean_name' => 'AOS_Line_Item_Groups', 'source' => 'non-db')), 'relationships' => array('aos_contracts_tasks' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', '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' => 'AOS_Contracts'), 'aos_contracts_notes' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', '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' => 'AOS_Contracts'), 'aos_contracts_meetings' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', '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' => 'AOS_Contracts'), 'aos_contracts_calls' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', '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' => 'AOS_Contracts'), 'aos_contracts_aos_products_quotes' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Products_Quotes', 'rhs_table' => 'aos_products_quotes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many'), 'aos_contracts_aos_line_item_groups' => array('lhs_module' => 'AOS_Contracts', 'lhs_table' => 'aos_contracts', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Line_Item_Groups', 'rhs_table' => 'aos_line_item_groups', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many')), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('AOS_Contracts', 'AOS_Contracts', array('basic', 'assignable', 'security_groups'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['Email'] = array('table' => 'emails', 'acl_fields' => false, 'comment' => 'Contains a record of emails sent to and from the Sugar application', 'fields' => array('id' => array('name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier'), 'date_entered' => array('name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record created'), 'date_modified' => array('name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, 'comment' => 'Date record last modified'), 'assigned_user_id' => array('name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'reportable' => true, 'dbType' => 'id', 'comment' => 'User ID that last modified record'), 'assigned_user_name' => array('name' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db', 'table' => 'users'), 'modified_user_id' => array('name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED_BY', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'reportable' => true, 'dbType' => 'id', 'comment' => 'User ID that last modified record'), 'created_by' => array('name' => 'created_by', 'vname' => 'LBL_CREATED_BY', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'User name who created record'), 'deleted' => array('name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'comment' => 'Record deletion indicator'), 'from_addr_name' => array('name' => 'from_addr_name', 'type' => 'varchar', 'vname' => 'from_addr_name', 'source' => 'non-db'), 'reply_to_addr' => array('name' => 'reply_to_addr', 'type' => 'varchar', 'vname' => 'reply_to_addr', 'source' => 'non-db'), 'to_addrs_names' => array('name' => 'to_addrs_names', 'type' => 'varchar', 'vname' => 'to_addrs_names', 'source' => 'non-db'), 'cc_addrs_names' => array('name' => 'cc_addrs_names', 'type' => 'varchar', 'vname' => 'cc_addrs_names', 'source' => 'non-db'), 'bcc_addrs_names' => array('name' => 'bcc_addrs_names', 'type' => 'varchar', 'vname' => 'bcc_addrs_names', 'source' => 'non-db'), 'raw_source' => array('name' => 'raw_source', 'type' => 'varchar', 'vname' => 'raw_source', 'source' => 'non-db'), 'description_html' => array('name' => 'description_html', 'type' => 'varchar', 'vname' => 'description_html', 'source' => 'non-db'), 'description' => array('name' => 'description', 'type' => 'varchar', 'vname' => 'description', 'source' => 'non-db'), 'date_sent' => array('name' => 'date_sent', 'vname' => 'LBL_DATE_SENT', 'type' => 'datetime', 'type' => 'datetime'), 'message_id' => array('name' => 'message_id', 'vname' => 'LBL_MESSAGE_ID', 'type' => 'varchar', 'len' => 255, 'comment' => 'ID of the email item obtained from the email transport system'), 'name' => array('name' => 'name', 'vname' => 'LBL_SUBJECT', 'type' => 'varchar', 'required' => false, 'len' => '255', 'comment' => 'The subject of the email'), 'type' => array('name' => 'type', 'vname' => 'LBL_LIST_TYPE', 'type' => 'enum', 'options' => 'dom_email_types', 'len' => 100, 'massupdate' => false, 'comment' => 'Type of email (ex: draft)'), 'status' => array('name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'len' => 100, 'options' => 'dom_email_status'), 'flagged' => array('name' => 'flagged', 'vname' => 'LBL_EMAIL_FLAGGED', 'type' => 'bool', 'required' => false, 'reportable' => false, 'comment' => 'flagged status'), 'reply_to_status' => array('name' => 'reply_to_status', 'vname' => 'LBL_EMAIL_REPLY_TO_STATUS', 'type' => 'bool', 'required' => false, 'reportable' => false, 'comment' => 'I you reply to an email then reply to status of original email is set'), 'intent' => array('name' => 'intent', 'vname' => 'LBL_INTENT', 'type' => 'varchar', 'len' => 100, 'default' => 'pick', 'comment' => 'Target of action used in Inbound Email assignment'), 'mailbox_id' => array('name' => 'mailbox_id', 'vname' => 'LBL_MAILBOX_ID', 'type' => 'id', 'len' => '36', 'reportable' => false), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'emails_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'emails_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'emails_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'parent_name' => array('name' => 'parent_name', 'type' => 'varchar', 'reportable' => false, 'source' => 'non-db'), 'parent_type' => array('name' => 'parent_type', 'type' => 'varchar', 'reportable' => false, 'len' => 100, 'comment' => 'Identifier of Sugar module to which this email is associated (deprecated as of 4.2)'), 'parent_id' => array('name' => 'parent_id', 'type' => 'id', 'len' => '36', 'reportable' => false, 'comment' => 'ID of Sugar object referenced by parent_type (deprecated as of 4.2)'), 'accounts' => array('name' => 'accounts', 'vname' => 'LBL_EMAILS_ACCOUNTS_REL', 'type' => 'link', 'relationship' => 'emails_accounts_rel', 'module' => 'Accounts', 'bean_name' => 'Account', 'source' => 'non-db'), 'bugs' => array('name' => 'bugs', 'vname' => 'LBL_EMAILS_BUGS_REL', 'type' => 'link', 'relationship' => 'emails_bugs_rel', 'module' => 'Bugs', 'bean_name' => 'Bug', 'source' => 'non-db'), 'cases' => array('name' => 'cases', 'vname' => 'LBL_EMAILS_CASES_REL', 'type' => 'link', 'relationship' => 'emails_cases_rel', 'module' => 'Cases', 'bean_name' => 'Case', 'source' => 'non-db'), 'contacts' => array('name' => 'contacts', 'vname' => 'LBL_EMAILS_CONTACTS_REL', 'type' => 'link', 'relationship' => 'emails_contacts_rel', 'module' => 'Contacts', 'bean_name' => 'Contact', 'source' => 'non-db'), 'leads' => array('name' => 'leads', 'vname' => 'LBL_EMAILS_LEADS_REL', 'type' => 'link', 'relationship' => 'emails_leads_rel', 'module' => 'Leads', 'bean_name' => 'Lead', 'source' => 'non-db'), 'opportunities' => array('name' => 'opportunities', 'vname' => 'LBL_EMAILS_OPPORTUNITIES_REL', 'type' => 'link', 'relationship' => 'emails_opportunities_rel', 'module' => 'Opportunities', 'bean_name' => 'Opportunity', 'source' => 'non-db'), 'project' => array('name' => 'project', 'vname' => 'LBL_EMAILS_PROJECT_REL', 'type' => 'link', 'relationship' => 'emails_projects_rel', 'module' => 'Project', 'bean_name' => 'Project', 'source' => 'non-db'), 'projecttask' => array('name' => 'projecttask', 'vname' => 'LBL_EMAILS_PROJECT_TASK_REL', 'type' => 'link', 'relationship' => 'emails_project_task_rel', 'module' => 'ProjectTask', 'bean_name' => 'ProjectTask', 'source' => 'non-db'), 'prospects' => array('name' => 'prospects', 'vname' => 'LBL_EMAILS_PROSPECT_REL', 'type' => 'link', 'relationship' => 'emails_prospects_rel', 'module' => 'Prospects', 'bean_name' => 'Prospect', 'source' => 'non-db'), 'tasks' => array('name' => 'tasks', 'vname' => 'LBL_EMAILS_TASKS_REL', 'type' => 'link', 'relationship' => 'emails_tasks_rel', 'module' => 'Tasks', 'bean_name' => 'Task', 'source' => 'non-db'), 'users' => array('name' => 'users', 'vname' => 'LBL_EMAILS_USERS_REL', 'type' => 'link', 'relationship' => 'emails_users_rel', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'notes' => array('name' => 'notes', 'vname' => 'LBL_EMAILS_NOTES_REL', 'type' => 'link', 'relationship' => 'emails_notes_rel', 'module' => 'Notes', 'bean_name' => 'Note', 'source' => 'non-db'), 'meetings' => array('name' => 'meetings', 'vname' => 'LBL_EMAILS_MEETINGS_REL', 'type' => 'link', 'relationship' => 'emails_meetings_rel', 'module' => 'Meetings', 'bean_name' => 'Meeting', 'source' => 'non-db')), 'relationships' => array('emails_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'emails_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'emails_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Emails', 'rhs_table' => 'emails', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many'), 'emails_notes_rel' => array('lhs_module' => 'Emails', 'lhs_table' => 'emails', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many'), 'emails_meetings_rel' => array('lhs_module' => 'Emails', 'lhs_table' => 'emails', 'lhs_key' => 'id', 'rhs_module' => 'Meetings', 'rhs_table' => 'meetings', 'rhs_key' => 'parent_id', 'relationship_type' => 'one-to-many')), 'indices' => array(array('name' => 'emailspk', 'type' => 'primary', 'fields' => array('id')), array('name' => 'idx_email_name', 'type' => 'index', 'fields' => array('name')), array('name' => 'idx_message_id', 'type' => 'index', 'fields' => array('message_id')), array('name' => 'idx_email_parent_id', 'type' => 'index', 'fields' => array('parent_id')), array('name' => 'idx_email_assigned', 'type' => 'index', 'fields' => array('assigned_user_id', 'type', 'status'))));
VardefManager::createVardef('Emails', 'Email', array());
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['anmol_marketing_campaigns'] = array('table' => 'anmol_marketing_campaigns', 'audited' => true, 'inline_edit' => true, 'duplicate_merge' => true, 'fields' => array(), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('anmol_marketing_campaigns', 'anmol_marketing_campaigns', array('basic', 'assignable'));
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['Bug'] = array('table' => 'bugs', 'audited' => true, 'comment' => 'Bugs are defects in products and services', 'duplicate_merge' => true, 'unified_search' => true, 'fields' => array('found_in_release' => array('name' => 'found_in_release', 'type' => 'enum', 'function' => 'getReleaseDropDown', 'vname' => 'LBL_FOUND_IN_RELEASE', 'reportable' => false, 'comment' => 'The software or service release that manifested the bug', 'duplicate_merge' => 'disabled', 'audited' => true, 'studio' => array('fields' => 'false', 'listview' => false), 'massupdate' => true), 'release_name' => array('name' => 'release_name', 'rname' => 'name', 'vname' => 'LBL_FOUND_IN_RELEASE', 'type' => 'relate', 'dbType' => 'varchar', 'group' => 'found_in_release', 'reportable' => false, 'source' => 'non-db', 'table' => 'releases', 'merge_filter' => 'enabled', 'id_name' => 'found_in_release', 'module' => 'Releases', 'link' => 'release_link', 'massupdate' => false, 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false, 'basic_search' => false, 'advanced_search' => false)), 'fixed_in_release' => array('name' => 'fixed_in_release', 'type' => 'enum', 'function' => 'getReleaseDropDown', 'vname' => 'LBL_FIXED_IN_RELEASE', 'reportable' => false, 'comment' => 'The software or service release that corrected the bug', 'duplicate_merge' => 'disabled', 'audited' => true, 'studio' => array('fields' => 'false', 'listview' => false), 'massupdate' => true), 'fixed_in_release_name' => array('name' => 'fixed_in_release_name', 'rname' => 'name', 'group' => 'fixed_in_release', 'id_name' => 'fixed_in_release', 'vname' => 'LBL_FIXED_IN_RELEASE', 'type' => 'relate', 'table' => 'releases', 'isnull' => 'false', 'massupdate' => false, 'module' => 'Releases', 'dbType' => 'varchar', 'len' => 36, 'source' => 'non-db', 'link' => 'fixed_in_release_link', 'studio' => array('editview' => false, 'detailview' => false, 'quickcreate' => false, 'basic_search' => false, 'advanced_search' => false)), 'source' => array('name' => 'source', 'vname' => 'LBL_SOURCE', 'type' => 'enum', 'options' => 'source_dom', 'len' => 255, 'comment' => 'An indicator of how the bug was entered (ex: via web, email, etc.)'), 'product_category' => array('name' => 'product_category', 'vname' => 'LBL_PRODUCT_CATEGORY', 'type' => 'enum', 'options' => 'product_category_dom', 'len' => 255, 'comment' => 'Where the bug was discovered (ex: Accounts, Contacts, Leads)'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'bug_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'bug_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'bug_meetings', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'bug_calls', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_bugs_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'documents' => array('name' => 'documents', 'type' => 'link', 'relationship' => 'documents_bugs', 'source' => 'non-db', 'vname' => 'LBL_DOCUMENTS_SUBPANEL_TITLE'), 'contacts' => array('name' => 'contacts', 'type' => 'link', 'relationship' => 'contacts_bugs', 'source' => 'non-db', 'vname' => 'LBL_CONTACTS'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'accounts_bugs', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNTS'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'cases_bugs', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'project' => array('name' => 'project', 'type' => 'link', 'relationship' => 'projects_bugs', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS'), 'release_link' => array('name' => 'release_link', 'type' => 'link', 'relationship' => 'bugs_release', 'vname' => 'LBL_FOUND_IN_RELEASE', 'link_type' => 'one', 'module' => 'Releases', 'bean_name' => 'Release', 'source' => 'non-db'), 'fixed_in_release_link' => array('name' => 'fixed_in_release_link', 'type' => 'link', 'relationship' => 'bugs_fixed_in_release', 'vname' => 'LBL_FIXED_IN_RELEASE', 'link_type' => 'one', 'module' => 'Releases', 'bean_name' => 'Release', 'source' => 'non-db')), 'indices' => array(array('name' => 'bug_number', 'type' => 'index', 'fields' => array('bug_number')), array('name' => 'idx_bug_name', 'type' => 'index', 'fields' => array('name')), array('name' => 'idx_bugs_assigned_user', 'type' => 'index', 'fields' => array('assigned_user_id'))), 'relationships' => array('bug_tasks' => array('lhs_module' => 'Bugs', 'lhs_table' => 'bugs', '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' => 'Bugs'), 'bug_meetings' => array('lhs_module' => 'Bugs', 'lhs_table' => 'bugs', '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' => 'Bugs'), 'bug_calls' => array('lhs_module' => 'Bugs', 'lhs_table' => 'bugs', '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' => 'Bugs'), 'bug_emails' => array('lhs_module' => 'Bugs', 'lhs_table' => 'bugs', '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' => 'Bugs'), 'bug_notes' => array('lhs_module' => 'Bugs', 'lhs_table' => 'bugs', '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' => 'Bugs'), 'bugs_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'bugs_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'bugs_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many'), 'bugs_release' => array('lhs_module' => 'Releases', 'lhs_table' => 'releases', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'found_in_release', 'relationship_type' => 'one-to-many'), 'bugs_fixed_in_release' => array('lhs_module' => 'Releases', 'lhs_table' => 'releases', 'lhs_key' => 'id', 'rhs_module' => 'Bugs', 'rhs_table' => 'bugs', 'rhs_key' => 'fixed_in_release', 'relationship_type' => 'one-to-many')), 'optimistic_locking' => true);
VardefManager::createVardef('Bugs', 'Bug', array('default', 'assignable', 'issue'));
//jc - adding for refactor for import to not use the required_fields array
//defined in the field_arrays.php file
$dictionary['Bug']['fields']['name']['importable'] = 'required';
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
$dictionary['sel_Selkirk_Approvals_01'] = array('table' => 'sel_selkirk_approvals_01', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => '255', 'unified_search' => false, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'disabled', 'merge_filter' => 'disabled', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'duplicate_merge_dom_value' => '0', 'audited' => true, 'reportable' => true, 'size' => '20'), 'date_approved' => array('required' => false, 'name' => 'date_approved', 'vname' => 'LBL_DATE_APPROVED', 'type' => 'date', 'massupdate' => 0, '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', 'enable_range_search' => false, 'display_default' => 'now'), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => '6', 'cols' => '80', 'required' => false, 'massupdate' => 0, 'no_default' => false, 'comments' => 'Full text of the note', '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'), 'title' => array('required' => false, 'name' => 'title', 'vname' => 'LBL_TITLE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'president_CEO', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'selkirk_person_title_list', 'studio' => 'visible', 'dependency' => false)), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('sel_Selkirk_Approvals_01', 'sel_Selkirk_Approvals_01', array('basic', 'assignable'));
<?php
$dictionary['acl_fields'] = array('table' => 'acl_fields', 'audited' => true, 'fields' => array('category' => array('required' => '1', 'name' => 'category', 'vname' => 'LBL_CATEGORY', 'type' => 'varchar', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => 0, 'len' => '25', 'options' => 'moduleList'), 'aclaccess' => array('required' => false, 'name' => 'aclaccess', 'vname' => 'LBL_ACLACCESS', 'type' => 'enum', 'dbType' => 'int', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => 0, 'len' => '3', 'disable_num_format' => '', 'required' => '1', 'options' => 'fields_access_list'), 'role_id' => array('required' => false, 'name' => 'role_id', 'vname' => 'LBL_ROLE', 'type' => 'id', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => 0, 'reportable' => 0, 'len' => 36, 'options' => 'roles_list', 'required' => '1'), 'role' => array('required' => false, 'source' => 'non-db', 'name' => 'role', 'vname' => 'LBL_ROLE', 'type' => 'relate', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 0, 'reportable' => 0, 'len' => '255', 'id_name' => 'role_id', 'ext2' => 'roles', 'module' => 'ACLRoles', 'quicksearch' => 'enabled', 'studio' => 'visible')), 'relationships' => array(), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('acl_fields', 'acl_fields', array('basic'));
<?php
/**
* Products, Quotations & Invoices modules.
* Extensions to SugarCRM
* @package Advanced OpenSales for SugarCRM
* @subpackage Products
* @copyright SalesAgility Ltd http://www.salesagility.com
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE as published by
* the Free Software Foundation; either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU AFFERO GENERAL PUBLIC LICENSE
* along with this program; if not, see http://www.gnu.org/licenses
* or write to the Free Software Foundation,Inc., 51 Franklin Street,
* Fifth Floor, Boston, MA 02110-1301 USA
*
* @author Salesagility Ltd <*****@*****.**>
*/
$dictionary['AOS_PDF_Templates'] = array('table' => 'aos_pdf_templates', 'audited' => true, 'fields' => array('type' => array('required' => '1', 'name' => 'type', 'vname' => 'LBL_TYPE', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Quotes', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 0, 'len' => 100, 'options' => 'pdf_template_type_dom', 'studio' => 'visible'), 'sample' => array('required' => '0', 'name' => 'sample', 'vname' => 'LBL_SAMPLE', 'source' => 'non-db', 'type' => 'enum', 'massupdate' => 0, 'default' => '', 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => 1, 'reportable' => 0, 'len' => 100, 'options' => 'pdf_template_sample_dom', 'studio' => 'visible'), 'pdfheader' => array('required' => false, 'name' => 'pdfheader', 'vname' => 'LBL_HEADER', 'type' => 'text', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'studio' => 'visible', 'rows' => '4', 'cols' => '20'), 'pdffooter' => array('required' => false, 'name' => 'pdffooter', 'vname' => 'LBL_FOOTER', 'type' => 'text', 'massupdate' => 0, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20', 'studio' => 'visible', 'rows' => '4', 'cols' => '20')), 'relationships' => array(), 'optimistic_lock' => true);
require_once 'include/SugarObjects/VardefManager.php';
VardefManager::createVardef('AOS_PDF_Templates', 'AOS_PDF_Templates', array('basic', 'assignable'));
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['Contact'] = array('table' => 'contacts', 'audited' => true, 'unified_search' => true, 'full_text_search' => true, 'unified_search_default_enabled' => true, 'duplicate_merge' => true, 'fields' => array('email_and_name1' => array('name' => 'email_and_name1', 'rname' => 'email_and_name1', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'source' => 'non-db', 'len' => '510', 'importable' => 'false'), 'lead_source' => array('name' => 'lead_source', 'vname' => 'LBL_LEAD_SOURCE', 'type' => 'enum', 'options' => 'lead_source_dom', 'len' => '255', 'comment' => 'How did the contact come about'), 'account_name' => array('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), 'account_id' => array('name' => 'account_id', 'rname' => 'id', 'id_name' => 'account_id', 'vname' => 'LBL_ACCOUNT_ID', 'type' => 'relate', 'table' => 'accounts', 'isnull' => 'true', 'module' => 'Accounts', 'dbType' => 'id', 'reportable' => false, 'source' => 'non-db', 'massupdate' => false, 'duplicate_merge' => 'disabled', 'hideacl' => true), 'opportunity_role_fields' => array('name' => 'opportunity_role_fields', 'rname' => 'id', 'relationship_fields' => array('id' => 'opportunity_role_id', 'contact_role' => 'opportunity_role'), 'vname' => 'LBL_ACCOUNT_NAME', 'type' => 'relate', 'link' => 'opportunities', 'link_type' => 'relationship_info', 'join_link_name' => 'opportunities_contacts', 'source' => 'non-db', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'studio' => false), 'opportunity_role_id' => array('name' => 'opportunity_role_id', 'type' => 'varchar', 'source' => 'non-db', 'vname' => 'LBL_OPPORTUNITY_ROLE_ID', 'studio' => array('listview' => false)), 'opportunity_role' => array('name' => 'opportunity_role', 'type' => 'enum', 'source' => 'non-db', 'vname' => 'LBL_OPPORTUNITY_ROLE', 'options' => 'opportunity_relationship_type_dom'), 'reports_to_id' => array('name' => 'reports_to_id', 'vname' => 'LBL_REPORTS_TO_ID', 'type' => 'id', 'required' => false, 'reportable' => false, 'comment' => 'The contact this contact reports to'), 'report_to_name' => array('name' => 'report_to_name', 'rname' => 'last_name', 'id_name' => 'reports_to_id', 'vname' => 'LBL_REPORTS_TO', 'type' => 'relate', 'link' => 'reports_to_link', 'table' => 'contacts', 'isnull' => 'true', 'module' => 'Contacts', 'dbType' => 'varchar', 'len' => 'id', 'reportable' => false, 'source' => 'non-db'), 'birthdate' => array('name' => 'birthdate', 'vname' => 'LBL_BIRTHDATE', 'massupdate' => false, 'type' => 'date', 'comment' => 'The birthdate of the contact'), 'accounts' => array('name' => 'accounts', 'type' => 'link', 'relationship' => 'accounts_contacts', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_ACCOUNT', 'duplicate_merge' => 'disabled'), 'reports_to_link' => array('name' => 'reports_to_link', 'type' => 'link', 'relationship' => 'contact_direct_reports', 'link_type' => 'one', 'side' => 'right', 'source' => 'non-db', 'vname' => 'LBL_REPORTS_TO'), 'opportunities' => array('name' => 'opportunities', 'type' => 'link', 'relationship' => 'opportunities_contacts', 'source' => 'non-db', 'module' => 'Opportunities', 'bean_name' => 'Opportunity', 'vname' => 'LBL_OPPORTUNITIES'), 'email_addresses' => array('name' => 'email_addresses', 'type' => 'link', 'relationship' => 'contacts_email_addresses', 'module' => 'EmailAddress', 'bean_name' => 'EmailAddress', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESSES', 'reportable' => false, 'rel_fields' => array('primary_address' => array('type' => 'bool')), 'unified_search' => true), 'email_addresses_primary' => array('name' => 'email_addresses_primary', 'type' => 'link', 'relationship' => 'contacts_email_addresses_primary', 'source' => 'non-db', 'vname' => 'LBL_EMAIL_ADDRESS_PRIMARY', 'duplicate_merge' => 'disabled'), 'bugs' => array('name' => 'bugs', 'type' => 'link', 'relationship' => 'contacts_bugs', 'source' => 'non-db', 'vname' => 'LBL_BUGS'), 'calls' => array('name' => 'calls', 'type' => 'link', 'relationship' => 'calls_contacts', 'source' => 'non-db', 'vname' => 'LBL_CALLS'), 'cases' => array('name' => 'cases', 'type' => 'link', 'relationship' => 'contacts_cases', 'source' => 'non-db', 'vname' => 'LBL_CASES'), 'direct_reports' => array('name' => 'direct_reports', 'type' => 'link', 'relationship' => 'contact_direct_reports', 'source' => 'non-db', 'vname' => 'LBL_DIRECT_REPORTS'), 'emails' => array('name' => 'emails', 'type' => 'link', 'relationship' => 'emails_contacts_rel', 'source' => 'non-db', 'vname' => 'LBL_EMAILS'), 'documents' => array('name' => 'documents', 'type' => 'link', 'relationship' => 'documents_contacts', 'source' => 'non-db', 'vname' => 'LBL_DOCUMENTS_SUBPANEL_TITLE'), 'leads' => array('name' => 'leads', 'type' => 'link', 'relationship' => 'contact_leads', 'source' => 'non-db', 'vname' => 'LBL_LEADS'), 'meetings' => array('name' => 'meetings', 'type' => 'link', 'relationship' => 'meetings_contacts', 'source' => 'non-db', 'vname' => 'LBL_MEETINGS'), 'notes' => array('name' => 'notes', 'type' => 'link', 'relationship' => 'contact_notes', 'source' => 'non-db', 'vname' => 'LBL_NOTES'), 'project' => array('name' => 'project', 'type' => 'link', 'relationship' => 'projects_contacts', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS'), 'project_resource' => array('name' => 'project_resource', 'type' => 'link', 'relationship' => 'projects_contacts_resources', 'source' => 'non-db', 'vname' => 'LBL_PROJECTS_RESOURCES'), 'tasks' => array('name' => 'tasks', 'type' => 'link', 'relationship' => 'contact_tasks', 'source' => 'non-db', 'vname' => 'LBL_TASKS'), 'tasks_parent' => array('name' => 'tasks_parent', 'type' => 'link', 'relationship' => 'contact_tasks_parent', 'source' => 'non-db', 'vname' => 'LBL_TASKS', 'reportable' => false), 'notes_parent' => array('name' => 'notes_parent', 'type' => 'link', 'relationship' => 'contact_notes_parent', 'source' => 'non-db', 'vname' => 'LBL_TASKS', 'reportable' => false), 'user_sync' => array('name' => 'user_sync', 'type' => 'link', 'relationship' => 'contacts_users', 'source' => 'non-db', 'vname' => 'LBL_USER_SYNC'), 'created_by_link' => array('name' => 'created_by_link', 'type' => 'link', 'relationship' => 'contacts_created_by', 'vname' => 'LBL_CREATED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'modified_user_link' => array('name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'contacts_modified_user', 'vname' => 'LBL_MODIFIED_BY_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db'), 'assigned_user_link' => array('name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'contacts_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users', 'duplicate_merge' => 'enabled'), 'campaign_id' => array('name' => 'campaign_id', 'comment' => 'Campaign that generated lead', 'vname' => 'LBL_CAMPAIGN_ID', 'rname' => 'id', 'id_name' => 'campaign_id', 'type' => 'id', 'table' => 'campaigns', 'isnull' => 'true', 'module' => 'Campaigns', 'massupdate' => false, 'duplicate_merge' => 'disabled'), 'campaign_name' => array('name' => 'campaign_name', 'rname' => 'name', 'vname' => 'LBL_CAMPAIGN', 'type' => 'relate', 'link' => 'campaign_contacts', 'isnull' => 'true', 'reportable' => false, 'source' => 'non-db', 'table' => 'campaigns', 'id_name' => 'campaign_id', 'module' => 'Campaigns', 'duplicate_merge' => 'disabled', 'comment' => 'The first campaign name for Contact (Meta-data only)'), 'campaigns' => array('name' => 'campaigns', 'type' => 'link', 'relationship' => 'contact_campaign_log', 'module' => 'CampaignLog', 'bean_name' => 'CampaignLog', 'source' => 'non-db', 'vname' => 'LBL_CAMPAIGNLOG'), 'campaign_contacts' => array('name' => 'campaign_contacts', 'type' => 'link', 'vname' => 'LBL_CAMPAIGN_CONTACT', 'relationship' => 'campaign_contacts', 'source' => 'non-db'), 'c_accept_status_fields' => array('name' => 'c_accept_status_fields', 'rname' => 'id', 'relationship_fields' => array('id' => 'accept_status_id', 'accept_status' => 'accept_status_name'), 'vname' => 'LBL_LIST_ACCEPT_STATUS', 'type' => 'relate', 'link' => 'calls', 'link_type' => 'relationship_info', 'source' => 'non-db', 'importable' => 'false', 'duplicate_merge' => 'disabled', 'studio' => false), 'm_accept_status_fields' => array('name' => 'm_accept_status_fields', 'rname' => 'id', 'relationship_fields' => array('id' => 'accept_status_id', 'accept_status' => 'accept_status_name'), 'vname' => 'LBL_LIST_ACCEPT_STATUS', 'type' => 'relate', 'link' => 'meetings', 'link_type' => 'relationship_info', 'source' => 'non-db', 'importable' => 'false', 'hideacl' => true, 'duplicate_merge' => 'disabled', 'studio' => false), 'accept_status_id' => array('name' => 'accept_status_id', 'type' => 'varchar', 'source' => 'non-db', 'vname' => 'LBL_LIST_ACCEPT_STATUS', 'studio' => array('listview' => false)), 'accept_status_name' => array('massupdate' => false, 'name' => 'accept_status_name', 'type' => 'enum', 'studio' => 'false', 'source' => 'non-db', 'vname' => 'LBL_LIST_ACCEPT_STATUS', 'options' => 'dom_meeting_accept_status', 'importable' => 'false'), 'prospect_lists' => array('name' => 'prospect_lists', 'type' => 'link', 'relationship' => 'prospect_list_contacts', 'module' => 'ProspectLists', 'source' => 'non-db', 'vname' => 'LBL_PROSPECT_LIST'), 'sync_contact' => array('massupdate' => false, 'name' => 'sync_contact', 'vname' => 'LBL_SYNC_CONTACT', 'type' => 'bool', 'source' => 'non-db', 'comment' => 'Synch to outlook? (Meta-Data only)', 'studio' => 'true')), 'indices' => array(array('name' => 'idx_cont_last_first', 'type' => 'index', 'fields' => array('last_name', 'first_name', 'deleted')), array('name' => 'idx_contacts_del_last', 'type' => 'index', 'fields' => array('deleted', 'last_name')), array('name' => 'idx_cont_del_reports', 'type' => 'index', 'fields' => array('deleted', 'reports_to_id', 'last_name')), array('name' => 'idx_reports_to_id', 'type' => 'index', 'fields' => array('reports_to_id')), array('name' => 'idx_del_id_user', 'type' => 'index', 'fields' => array('deleted', 'id', 'assigned_user_id')), array('name' => 'idx_cont_assigned', 'type' => 'index', 'fields' => array('assigned_user_id'))), 'relationships' => array('contact_direct_reports' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Contacts', 'rhs_table' => 'contacts', 'rhs_key' => 'reports_to_id', 'relationship_type' => 'one-to-many'), 'contact_leads' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Leads', 'rhs_table' => 'leads', 'rhs_key' => 'contact_id', 'relationship_type' => 'one-to-many'), 'contact_notes' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Notes', 'rhs_table' => 'notes', 'rhs_key' => 'contact_id', 'relationship_type' => 'one-to-many'), 'contact_tasks' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'Tasks', 'rhs_table' => 'tasks', 'rhs_key' => 'contact_id', 'relationship_type' => 'one-to-many'), 'contact_tasks_parent' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', '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' => 'Contacts'), 'contact_notes_parent' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', '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' => 'Contacts'), 'contacts_assigned_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Contacts', 'rhs_table' => 'contacts', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many'), 'contacts_modified_user' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Contacts', 'rhs_table' => 'contacts', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many'), 'contacts_created_by' => array('lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Contacts', 'rhs_table' => 'contacts', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many'), 'contact_campaign_log' => array('lhs_module' => 'Contacts', 'lhs_table' => 'contacts', 'lhs_key' => 'id', 'rhs_module' => 'CampaignLog', 'rhs_table' => 'campaign_log', 'rhs_key' => 'target_id', 'relationship_type' => 'one-to-many', 'relationship_role_column' => 'target_type', 'relationship_role_column_value' => 'Contacts')), 'optimistic_locking' => true);
VardefManager::createVardef('Contacts', 'Contact', array('default', 'assignable', 'person'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['AOK_KnowledgeBase'] = array('table' => 'aok_knowledgebase', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('name' => array('name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => '255', 'unified_search' => false, 'full_text_search' => array('boost' => 3), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'disabled', 'merge_filter' => 'disabled', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'size' => '20'), 'status' => array('required' => false, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Draft', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'aok_status_list', 'studio' => 'visible', 'dependency' => false), 'revision' => array('required' => false, 'name' => 'revision', 'vname' => 'LBL_REVISION', 'type' => 'varchar', 'massupdate' => 0, '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'), 'description' => array('name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => '6', 'cols' => '80', 'required' => false, 'massupdate' => 0, 'no_default' => false, 'comments' => 'Full text of the note', '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'), 'additional_info' => array('name' => 'additional_info', 'vname' => 'LBL_ADDITIONAL_INFO', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => '6', 'cols' => '80', 'required' => false, 'massupdate' => 0, 'no_default' => false, 'comments' => 'Full text of the note', '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'), 'user_id_c' => array('required' => false, 'name' => 'user_id_c', 'vname' => 'LBL_AUTHOR_USER_ID', 'type' => 'id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20'), 'author' => array('required' => true, 'source' => 'non-db', 'name' => 'author', 'vname' => 'LBL_AUTHOR', 'type' => 'relate', 'massupdate' => 0, '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', 'id_name' => 'user_id_c', 'ext2' => 'Users', 'module' => 'Users', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'user_id1_c' => array('required' => false, 'name' => 'user_id1_c', 'vname' => 'LBL_APPROVER_USER_ID', 'type' => 'id', 'massupdate' => 0, 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 36, 'size' => '20'), 'approver' => array('required' => false, 'source' => 'non-db', 'name' => 'approver', 'vname' => 'LBL_APPROVER', 'type' => 'relate', 'massupdate' => 0, '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', 'id_name' => 'user_id1_c', 'ext2' => 'Users', 'module' => 'Users', 'rname' => 'name', 'quicksearch' => 'enabled', 'studio' => 'visible'), 'aok_knowledgebase_categories' => array('name' => 'aok_knowledgebase_categories', 'type' => 'link', 'relationship' => 'aok_knowledgebase_categories', 'source' => 'non-db', 'module' => 'AOK_Knowledge_Base_Categories', 'bean_name' => false, 'vname' => 'LBL_AOK_KB_CATEGORIES_TITLE')), 'relationships' => array(), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('AOK_KnowledgeBase', 'AOK_KnowledgeBase', array('basic', 'assignable', 'security_groups'));
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
********************************************************************************/
$dictionary['AOS_Product_Categories'] = array('table' => 'aos_product_categories', 'audited' => true, 'duplicate_merge' => true, 'fields' => array('is_parent' => array('required' => false, 'name' => 'is_parent', 'vname' => 'LBL_IS_PARENT', 'type' => 'bool', 'massupdate' => '0', 'default' => '0', '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', 'id' => 'AOS_Product_Categoriesis_parent'), "aos_products" => array('name' => 'aos_products', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'product_categories', 'side' => 'right', 'vname' => 'LBL_AOS_PRODUCT_CATEGORIES_AOS_PRODUCTS_FROM_AOS_PRODUCTS_TITLE'), "sub_categories" => array('name' => 'sub_categories', 'type' => 'link', 'source' => 'non-db', 'relationship' => 'sub_product_categories', 'vname' => 'LBL_SUB_CATEGORIES', 'id_name' => 'parent_category_id'), 'parent_category' => array('name' => 'parent_category', 'type' => 'link', 'relationship' => 'sub_product_categories', 'module' => 'AOS_Product_Categories', 'bean_name' => 'AOS_Product_Categories', 'link_type' => 'one', 'source' => 'non-db', 'vname' => 'LBL_PARENT_CATEGORY', 'side' => 'right'), "parent_category_name" => array('name' => 'parent_category_name', 'type' => 'relate', 'source' => 'non-db', 'vname' => 'LBL_PRODUCT_CATEGORYS_NAME', 'save' => true, 'id_name' => 'parent_category_id', 'link' => 'sub_product_categories', 'table' => 'aos_product_categories', 'module' => 'AOS_Product_Categories', 'rname' => 'name'), "parent_category_id" => array('name' => 'parent_category_id', 'type' => 'id', 'reportable' => false, 'vname' => 'LBL_PARENT_CATEGORY_ID')), 'relationships' => array("sub_product_categories" => array('lhs_module' => 'AOS_Product_Categories', 'lhs_table' => 'aos_product_categories', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Product_Categories', 'rhs_table' => 'aos_product_categories', 'rhs_key' => 'parent_category_id', 'relationship_type' => 'one-to-many'), "products" => array('lhs_module' => 'AOS_Product_Categories', 'lhs_table' => 'aos_product_categories', 'lhs_key' => 'id', 'rhs_module' => 'AOS_Product', 'rhs_table' => 'aos_product', 'rhs_key' => 'aos_product_category_id', 'relationship_type' => 'one-to-many')), 'optimistic_locking' => true, 'unified_search' => true);
if (!class_exists('VardefManager')) {
require_once 'include/SugarObjects/VardefManager.php';
}
VardefManager::createVardef('AOS_Product_Categories', 'AOS_Product_Categories', array('basic', 'assignable'));
