function fetch($ac = false)
{
$fv = new FieldViewer();
if (empty($_REQUEST['field']) && !empty($_REQUEST['name'])) {
$_REQUEST['field'] = $_REQUEST['name'];
}
$field_name = '';
if (!empty($this->view_object_map['field_name'])) {
$field_name = $this->view_object_map['field_name'];
} elseif (!empty($_REQUEST['field'])) {
$field_name = $_REQUEST['field'];
}
// If this is a new field mark it as such
$isNew = empty($field_name) || !empty($_REQUEST['is_new']);
$action = 'saveField';
// tyoung bug 17606: default action is to save as a dynamic field; but for standard OOB
// fields we override this so don't create a new dynamic field instead of updating the existing field
$isClone = false;
if (!empty($this->view_object_map['is_clone']) && $this->view_object_map['is_clone'] && strcmp($field_name, "name") != 0) {
$isClone = true;
}
/*
$field_types = array('varchar'=>'YourField', 'int'=>'Integer', 'float'=>'Decimal','bool'=>'Checkbox','enum'=>'DropDown',
'date'=>'Date', 'phone' => 'Phone', 'currency' => 'Currency', 'html' => 'HTML', 'radioenum' => 'Radio',
'relate' => 'Relate', 'address' => 'Address', 'text' => 'TextArea', 'url' => 'Link');
*/
$field_types = $GLOBALS['mod_strings']['fieldTypes'];
//bug 22264: Field name must not be an SQL keyword.
$field_name_exceptions = array_merge(array_keys($GLOBALS['db']->getReservedWords()), array('ID', 'ID_C', 'PARENT_NAME', 'PARENT_ID'));
//C.L. - Add support to mark related module id columns as reserved keywords
require_once 'modules/ModuleBuilder/parsers/relationships/DeployedRelationships.php';
$relatedModules = array_keys(DeployedRelationships::findRelatableModules());
global $beanList, $current_language;
foreach ($relatedModules as $relModule) {
if (isset($beanList[$relModule])) {
$field_name_exceptions[] = strtoupper($beanList[$relModule]) . '_ID';
}
}
if (empty($_REQUEST['view_package']) || $_REQUEST['view_package'] == 'studio') {
$moduleName = $_REQUEST['view_module'];
$objectName = BeanFactory::getObjectName($moduleName);
$module = BeanFactory::getBean($moduleName);
VardefManager::loadVardef($moduleName, $objectName, true);
global $dictionary;
if (empty($module->mbvardefs)) {
$module->mbvardefs = new stdClass();
}
$module->mbvardefs->vardefs = $dictionary[$objectName];
$module->name = $moduleName;
if (!$ac) {
$ac = new AjaxCompose();
}
$vardef = !empty($module->mbvardefs->vardefs['fields'][$field_name]) ? $module->mbvardefs->vardefs['fields'][$field_name] : array();
if ($isClone) {
unset($vardef['name']);
}
// If this is a new field but we are loading this form a second time,
// like from coming back from a dropdown create on a new field, then
// keep the 'name' field open to allow the create field process to
// continue like normal
if (empty($vardef['name']) || $isNew) {
if (!empty($_REQUEST['type'])) {
$vardef['type'] = $_REQUEST['type'];
}
$fv->ss->assign('hideLevel', 0);
} elseif (isset($vardef['custom_module'])) {
$fv->ss->assign('hideLevel', 2);
} else {
$action = 'saveSugarField';
// tyoung - for OOB fields we currently only support modifying the label
$fv->ss->assign('hideLevel', 3);
}
if ($isClone && isset($vardef['type']) && $vardef['type'] == 'datetime') {
$vardef['type'] = 'datetimecombo';
}
require_once 'modules/DynamicFields/FieldCases.php';
$tf = get_widget(empty($vardef['type']) ? "" : $vardef['type']);
$tf->module = $module;
$tf->populateFromRow($vardef);
$vardef = array_merge($vardef, $tf->get_field_def());
// $GLOBALS['log']->debug('vardefs after loading = '.print_r($vardef,true));
//Check if autoincrement fields are allowed
$allowAutoInc = true;
$enumFields = array();
foreach ($module->field_defs as $field => $def) {
if (!empty($def['type']) && $def['type'] == "int" && !empty($def['auto_increment'])) {
$allowAutoInc = false;
continue;
}
if (!empty($def['type']) && $def['type'] == "enum" && $field != $vardef['name']) {
if (!empty($def['studio']) && $def['studio'] == "false") {
continue;
}
//bug51866
$enumFields[$field] = translate($def['vname'], $moduleName);
if (substr($enumFields[$field], -1) == ":") {
$enumFields[$field] = substr($enumFields[$field], 0, strlen($enumFields[$field]) - 1);
}
}
}
$fv->ss->assign('allowAutoInc', $allowAutoInc);
$GLOBALS['log']->warn('view.modulefield: hidelevel ' . $fv->ss->get_template_vars('hideLevel') . " " . print_r($vardef, true));
if (!empty($vardef['vname'])) {
$fv->ss->assign('lbl_value', htmlentities(translate($vardef['vname'], $moduleName), ENT_QUOTES, 'UTF-8'));
}
$fv->ss->assign('module', $module);
if (empty($module->mbvardefs->vardefs['fields']['parent_name']) || isset($vardef['type']) && $vardef['type'] == 'parent') {
$field_types['parent'] = $GLOBALS['mod_strings']['parent'];
}
$edit_or_add = 'editField';
} else {
require_once 'modules/ModuleBuilder/MB/ModuleBuilder.php';
$mb = new ModuleBuilder();
$moduleName = $_REQUEST['view_module'];
$module =& $mb->getPackageModule($_REQUEST['view_package'], $moduleName);
$package =& $mb->packages[$_REQUEST['view_package']];
$module->getVardefs();
if (!$ac) {
$ac = new AjaxCompose();
}
$vardef = !empty($module->mbvardefs->vardefs['fields'][$field_name]) ? $module->mbvardefs->vardefs['fields'][$field_name] : array();
if ($isClone) {
unset($vardef['name']);
}
if (empty($vardef['name'])) {
if (!empty($_REQUEST['type'])) {
$vardef['type'] = $_REQUEST['type'];
}
$fv->ss->assign('hideLevel', 0);
} else {
if (!empty($module->mbvardefs->vardef['fields'][$vardef['name']])) {
$fv->ss->assign('hideLevel', 1);
} elseif (isset($vardef['custom_module'])) {
$fv->ss->assign('hideLevel', 2);
} else {
$fv->ss->assign('hideLevel', 3);
// tyoung bug 17350 - effectively mark template derived fields as readonly
}
}
require_once 'modules/DynamicFields/FieldCases.php';
$tf = get_widget(empty($vardef['type']) ? "" : $vardef['type']);
$tf->module = $module;
$tf->populateFromRow($vardef);
$vardef = array_merge($vardef, $tf->get_field_def());
$fv->ss->assign('module', $module);
$fv->ss->assign('package', $package);
$fv->ss->assign('MB', '1');
if (isset($vardef['vname'])) {
$fv->ss->assign('lbl_value', htmlentities($module->getLabel('en_us', $vardef['vname']), ENT_QUOTES, 'UTF-8'));
}
if (empty($module->mbvardefs->vardefs['fields']['parent_name']) || isset($vardef['type']) && $vardef['type'] == 'parent') {
$field_types['parent'] = $GLOBALS['mod_strings']['parent'];
}
$enumFields = array();
if (!empty($module->mbvardefs->vardefs['fields'])) {
foreach ($module->mbvardefs->vardefs['fields'] as $field => $def) {
if (!empty($def['type']) && $def['type'] == "enum" && $field != $vardef['name']) {
$enumFields[$field] = isset($module->mblanguage->strings[$current_language][$def['vname']]) ? $this->mbModule->mblanguage->strings[$current_language][$def['vname']] : translate($field);
if (substr($enumFields[$field], -1) == ":") {
$enumFields[$field] = substr($enumFields[$field], 0, strlen($enumFields[$field]) - 1);
}
}
}
}
$edit_or_add = 'mbeditField';
}
if ($_REQUEST['action'] == 'RefreshField') {
require_once 'modules/DynamicFields/FieldCases.php';
$field = get_widget($_POST['type']);
$field->populateFromPost();
$vardef = $field->get_field_def();
$vardef['options'] = $_REQUEST['new_dropdown'];
$fv->ss->assign('lbl_value', htmlentities($_REQUEST['labelValue'], ENT_QUOTES, 'UTF-8'));
}
foreach (array("formula", "default", "comments", "help", "visiblityGrid") as $toEscape) {
if (!empty($vardef[$toEscape]) && is_string($vardef[$toEscape])) {
$vardef[$toEscape] = htmlentities($vardef[$toEscape], ENT_QUOTES, 'UTF-8');
}
}
if (!empty($vardef['studio']['no_duplicate']) || $field_name === 'name' || $field_name === 'parent_type' || $field_name === 'parent_id' || $field_name === 'parent_name' || isset($vardef['type']) && $vardef['type'] === 'name') {
$fv->ss->assign('no_duplicate', true);
}
$fv->ss->assign('action', $action);
$fv->ss->assign('isClone', $isClone ? 1 : 0);
$fv->ss->assign('isNew', $isNew);
$fv->ss->assign("module_dd_fields", $enumFields);
$json = getJSONobj();
$fv->ss->assign('field_name_exceptions', $json->encode($field_name_exceptions));
ksort($field_types);
$fv->ss->assign('field_types', $field_types);
$ftsEngineType = getFTSEngineType();
$usa = new UnifiedSearchAdvanced();
if (SugarSearchEngineFactory::getInstance()->isTypeFtsEnabled($vardef['type']) && (!empty($_REQUEST['view_package']) && $_REQUEST['view_package'] != 'studio' || $usa->shouldShowModule($moduleName))) {
$ftsBoostOptions = getFTSBoostOptions($ftsEngineType . '_boost_options');
$fv->ss->assign('fts_options', $ftsBoostOptions);
$fv->ss->assign('show_fts', true);
} else {
$fv->ss->assign('show_fts', false);
}
//Ensure certain field types always have correct formula return types for validation.
if (!empty($vardef['type'])) {
switch ($vardef['type']) {
case 'date':
case 'datetime':
$fv->ss->assign('calcFieldType', 'date');
break;
case 'bool':
$fv->ss->assign('calcFieldType', 'boolean');
break;
default:
$fv->ss->assign('calcFieldType', '');
break;
}
}
$fv->ss->assign('importable_options', $GLOBALS['app_list_strings']['custom_fields_importable_dom']);
$fv->ss->assign('duplicate_merge_options', $GLOBALS['app_list_strings']['custom_fields_merge_dup_dom']);
$triggers = array();
$existing_field_names = array();
foreach ($module->mbvardefs->vardefs['fields'] as $field) {
if ($field['type'] == 'enum' || $field['type'] == 'multienum') {
$triggers[] = $field['name'];
}
if (!isset($field['source']) || $field['source'] != 'non-db') {
if (preg_match('/^(.*?)(_c)?$/', $field['name'], $matches)) {
$existing_field_names[] = strtoupper($matches[1]);
}
}
}
$fv->ss->assign('triggers', $triggers);
$fv->ss->assign('existing_field_names', $json->encode($existing_field_names));
$fv->ss->assign('mod_strings', $GLOBALS['mod_strings']);
// jchi #24880
if (!isset($vardef['reportable'])) {
$vardef['reportable'] = 1;
}
// end
$layout = $fv->getLayout($vardef);
$fv->ss->assign('fieldLayout', $layout);
if (empty($vardef['type'])) {
$vardef['type'] = 'varchar';
}
$fv->ss->assign('vardef', $vardef);
if (empty($_REQUEST['field'])) {
$edit_or_add = 'addField';
}
$fv->ss->assign('help_group', $edit_or_add);
$body = $this->fetchTemplate($fv, 'modules/ModuleBuilder/tpls/MBModule/field.tpl');
$ac->addSection('east', translate('LBL_SECTION_FIELDEDITOR', 'ModuleBuilder'), $body);
return $ac;
}
