protected function constructSmarty()
{
$smarty = new Sugar_Smarty();
$smarty->assign('translate', true);
$smarty->assign('language', "Leads");
$smarty->assign('view_module', "Leads");
$smarty->assign('module', "Leads");
$smarty->assign('helpName', 'listViewEditor');
$smarty->assign('helpDefault', 'modify');
$smarty->assign('title', 'Convert Layout');
$modules = $this->getModulesFromDefs();
$smarty->assign('modules', $this->jsonHelper->encode($modules));
require_once 'modules/ModuleBuilder/parsers/relationships/DeployedRelationships.php';
$relatableModules = DeployedRelationships::findRelatableModules();
//pull out modules that have already been chosen
foreach ($modules as $mDef) {
if (isset($relatableModules[$mDef['module']])) {
unset($relatableModules[$mDef['module']]);
}
}
$displayModules = array();
$moduleDefaults = array();
foreach ($relatableModules as $mod => $def) {
if ($this->parser->isModuleAllowedInConvert($mod)) {
$displayModules[$mod] = translate($mod);
$moduleDefaults[$mod] = $this->parser->getDefaultDefForModule($mod);
}
}
$smarty->assign('availableModules', $displayModules);
$smarty->assign('moduleDefaults', $this->jsonHelper->encode($moduleDefaults));
return $smarty;
}
function get_body(&$ss, $vardef)
{
$modules = array();
require_once 'modules/ModuleBuilder/parsers/relationships/DeployedRelationships.php';
$relatableModules = array_keys(DeployedRelationships::findRelatableModules());
foreach ($relatableModules as $module) {
$modules[$module] = translate('LBL_MODULE_NAME', $module);
}
foreach (ACLController::disabledModuleList($modules, false, 'list') as $disabled_parent_type) {
unset($modules[$disabled_parent_type]);
}
unset($modules[""]);
unset($modules['Activities']);
// cannot relate to Activities as only Activities' submodules have records; use a Flex Relate instead!
// tyoung bug 18631 - reduce potential confusion when creating a relate custom field for Products - actually points to the Product Catalog, so label it that way in the drop down list
if (isset($modules['ProductTemplates']) && $modules['ProductTemplates'] == 'Product') {
$modules['ProductTemplates'] = translate('LBL_MODULE_NAME', 'ProductTemplates');
}
$ss->assign('modules', $modules);
return $ss->fetch('modules/DynamicFields/templates/Fields/Forms/relate.tpl');
}
function display()
{
$selected_lang = !empty($_REQUEST['relationship_lang']) ? $_REQUEST['relationship_lang'] : $_SESSION['authenticated_user_language'];
$this->smarty = new Sugar_Smarty();
$ac = new AjaxCompose();
$this->fromModuleBuilder = isset($_REQUEST['MB']) || !empty($_REQUEST['view_package']) && $_REQUEST['view_package'] != 'studio';
$this->smarty->assign('fromModuleBuilder', $this->fromModuleBuilder);
if (!$this->fromModuleBuilder) {
$module = StudioModuleFactory::getStudioModule($_REQUEST['view_module']);
$moduleName = $_REQUEST['view_module'];
$fields = $module->fields;
require_once 'modules/ModuleBuilder/parsers/relationships/DeployedRelationships.php';
$relatableModules = DeployedRelationships::findRelatableModules();
$appStrings = return_app_list_strings_language($selected_lang);
$modStrings = return_module_language($selected_lang, $_REQUEST['view_module'], true);
$appStrings = $appStrings['moduleList'];
} else {
$mb = new ModuleBuilder();
$mb->getPackages();
//display the latest module name rather than what is in or not in the loaded app_list_strings.
$mb->getPackage($_REQUEST['view_package'])->loadModuleTitles();
$module = $mb->getPackageModule($_REQUEST['view_package'], $_REQUEST['view_module']);
$moduleName = empty($module->key_name) ? $module->getModuleName() : $module->key_name;
$this->smarty->assign('view_package', $_REQUEST['view_package']);
$mbvardefs = $module->getVardefs();
$fields = $mbvardefs['fields'];
require_once 'modules/ModuleBuilder/parsers/relationships/UndeployedRelationships.php';
$relatableModules = UndeployedRelationships::findRelatableModules();
$appStrings = $module->getModStrings($selected_lang);
}
ksort($relatableModules);
$lhs_subpanels = $module->getProvidedSubpanels();
// Fix to re-add sorting of the subpanel names so that the 'default' subpanel always appears first in the list.
// This assumes that subpanels are usually named ForXYZ which is the case currently, and hence 'default' will be sorted first.
//I f this assumption is incorrect, then a better solution would be to remove 'default' from the subpanel list, then sort, and finally array_unshift it back on.
natcasesort($lhs_subpanels);
$cardinality = array(MB_ONETOONE => translate('LBL_ONETOONE'), MB_ONETOMANY => translate('LBL_ONETOMANY'), MB_MANYTOONE => translate('LBL_MANYTOONE'), MB_MANYTOMANY => translate('LBL_MANYTOMANY'));
if (!$this->fromModuleBuilder) {
unset($cardinality[MB_MANYTOONE]);
}
$relationships = $module->getRelationships();
// if a description for this relationship already exists, then load it so it can be modified
if (!empty($_REQUEST['relationship_name'])) {
$relationship = $relationships->get($_REQUEST['relationship_name']);
$relationship->setName($_REQUEST['relationship_name']);
$definition = $relationship->getDefinition();
if (!$this->fromModuleBuilder) {
$modStrings = return_module_language($selected_lang, $relationship->rhs_module, true);
$definition['lhs_label'] = isset($modStrings[$relationship->getTitleKey()]) ? $modStrings[$relationship->getTitleKey()] : $relationship->lhs_module;
$modStrings = return_module_language($selected_lang, $relationship->lhs_module, true);
$definition['rhs_label'] = isset($modStrings[$relationship->getTitleKey(true)]) ? $modStrings[$relationship->getTitleKey(true)] : $relationship->rhs_module;
} else {
#30624
if (!empty($_REQUEST['rhs_module'])) {
$definition['rhs_label'] = $_REQUEST['rhs_module'];
}
}
} else {
$definition = array();
$firstModuleDefinition = each($relatableModules);
$definition['rhs_module'] = $firstModuleDefinition['key'];
$definition['lhs_module'] = $moduleName;
$definition['lhs_label'] = translate($moduleName);
$definition['relationship_type'] = MB_MANYTOMANY;
}
// load the relationship from post - required as we can call view.relationship.php from Ajax when changing the rhs_module for example
$definition = $this->overrideDefinitionFromPOST($definition);
if (empty($definition['rhs_label'])) {
$definition['rhs_label'] = translate($definition['rhs_module']);
}
if (empty($definition['lhs_label'])) {
$definition['lhs_label'] = translate($definition['lhs_module']);
}
$relationship = RelationshipFactory::newRelationship($definition);
$rhs_subpanels = $relatableModules[$relationship->rhs_module];
// Fix to re-add sorting of the subpanel names so that the 'default' subpanel always appears first in the list. This assumes that subpanels are usually named ForXYZ which is the case currently, and hence 'default' will be sorted first. If this assumption is incorrect, then a better solution would be to remove 'default' from the subpanel list, then sort, and finally array_unshift it back on.
natcasesort($rhs_subpanels);
if (empty($_REQUEST['relationship_name'])) {
// tidy up the options for the view based on the modules participating in the relationship and the cardinality
// some modules (e.g., Knowledge Base/KBDocuments) lack subpanels. That means they can't be the lhs of a 1-many or many-many, or the rhs of a many-many for example
// fix up the available cardinality options
$relationship_type = $relationship->getType();
if (count($lhs_subpanels) == 0 || count($rhs_subpanels) == 0) {
unset($cardinality[MB_MANYTOMANY]);
}
if (count($rhs_subpanels) == 0) {
unset($cardinality[MB_ONETOMANY]);
}
if (isset($definition['rhs_module']) && $definition['rhs_module'] == 'Activities') {
$cardinality = array(MB_ONETOMANY => translate('LBL_ONETOMANY'));
}
//Bug 23139, Campaigns module current cannot display custom subpanels, so we need to ban it from any
//relationships that would require a new subpanel to be shown in Campaigns.
if (isset($definition['lhs_module']) && $definition['lhs_module'] == 'Campaigns') {
unset($cardinality[MB_MANYTOMANY]);
unset($cardinality[MB_ONETOMANY]);
}
if (isset($definition['rhs_module']) && $definition['rhs_module'] == 'Campaigns' && isset($cardinality[MB_MANYTOMANY])) {
unset($cardinality[MB_MANYTOMANY]);
unset($cardinality[MB_MANYTOONE]);
}
if (!isset($cardinality[$relationship->getType()])) {
end($cardinality);
$definition['relationship_type'] = key($cardinality);
$relationship = RelationshipFactory::newRelationship($definition);
}
$this->smarty->assign('is_new', true);
} else {
$this->smarty->assign('is_new', false);
}
//Remove Activities if one-to-many is not availible
if (!isset($cardinality[MB_ONETOMANY]) && isset($relatableModules['Activities'])) {
unset($relatableModules['Activities']);
}
// now enforce the relationship_only requirement - that is, only construct the underlying relationship and link fields, and not the UI, if the subpanel code will have troubles displaying the UI
$relationships->enforceRelationshipOnly($relationship);
$this->smarty->assign('view_module', $_REQUEST['view_module']);
$this->smarty->assign('rel', $relationship->getDefinition());
$this->smarty->assign('mod_strings', $GLOBALS['mod_strings']);
$this->smarty->assign('module_key', $relationship->lhs_module);
$this->smarty->assign('cardinality', array_keys($cardinality));
$this->smarty->assign('translated_cardinality', $cardinality);
$this->smarty->assign('selected_cardinality', translate($relationship->getType()));
$relatable = array();
foreach ($relatableModules as $name => $dummy) {
$relatable[$name] = translate($name);
}
unset($relatable['KBDocuments']);
natcasesort($relatable);
$this->smarty->assign('relatable', array_keys($relatable));
$this->smarty->assign('translated_relatable', $relatable);
$this->smarty->assign('rhspanels', $rhs_subpanels);
$this->smarty->assign('lhspanels', $lhs_subpanels);
$this->smarty->assign('selected_lang', $selected_lang);
$this->smarty->assign('available_languages', get_languages());
switch ($relationship->relationship_type) {
case MB_ONETOONE:
break;
case MB_ONETOMANY:
if (empty($relationship->relationship_column_name)) {
$validRoleColumnFields = array();
foreach ($fields as $field) {
$validRoleColumnFields[] = $field;
}
$this->smarty->assign('relationship_role_column_enum', $validRoleColumnFields);
}
if (!empty($relationship->relationship_role_column_value)) {
$this->smarty->assign('relationship_role_column_value', $relationship->relationship_role_column_value);
}
break;
case MB_MANYTOMANY:
if (!empty($relationship->relationship_role_column_value)) {
$this->smarty->assign('relationship_role_column_value', $relationship->relationship_role_column_value);
}
break;
}
//see if we use the new system
if (isset($_REQUEST['json']) && $_REQUEST['json'] == 'false') {
echo $this->smarty->fetch('modules/ModuleBuilder/tpls/studioRelationship.tpl');
} else {
$ac->addSection('east', $module->name . ' ' . $GLOBALS['mod_strings']['LBL_RELATIONSHIPS'], $this->smarty->fetch('modules/ModuleBuilder/tpls/studioRelationship.tpl'));
echo $ac->getJavascript();
}
}
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'];
} else {
$field_name = '';
}
$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'];
if (isset($field_types['encrypt'])) {
unset($field_types['encrypt']);
}
$field_name_exceptions = array('ADD', 'EXCEPT', 'PERCENT', 'ALL', 'EXEC', 'PLAN', 'ALTER', 'EXECUTE', 'PRECISION', 'AND', 'EXISTS', 'PRIMARY', 'ANY', 'EXIT', 'PRINT', 'AS', 'FETCH', 'PROC', 'ASC', 'FILE', 'PROCEDURE', 'AUTHORIZATION', 'FILLFACTOR', 'PUBLIC', 'BACKUP', 'FOR', 'RAISERROR', 'BEGIN', 'FOREIGN', 'READ', 'BETWEEN', 'FREETEXT', 'READTEXT', 'BREAK', 'FREETEXTTABLE', 'RECONFIGURE', 'BROWSE', 'FROM', 'REFERENCES', 'BULK', 'FULL', 'REPLICATION', 'BY', 'FUNCTION', 'RESTORE', 'CASCADE', 'GOTO', 'RESTRICT', 'CASE', 'GRANT', 'RETURN', 'CHECK', 'GROUP', 'REVOKE', 'CHECKPOINT', 'HAVING', 'RIGHT', 'CLOSE', 'HOLDLOCK', 'ROLLBACK', 'CLUSTERED', 'IDENTITY', 'ROWCOUNT', 'COALESCE', 'IDENTITY_INSERT', 'ROWGUIDCOL', 'COLLATE', 'IDENTITYCOL', 'RULE', 'COLUMN', 'IF', 'SAVE', 'COMMIT', 'IN', 'SCHEMA', 'COMPUTE', 'INDEX', 'SELECT', 'CONSTRAINT', 'INNER', 'SESSION_USER', 'CONTAINS', 'INSERT', 'SET', 'CONTAINSTABLE', 'INTERSECT', 'SETUSER', 'CONTINUE', 'INTO', 'SHUTDOWN', 'CONVERT', 'IS', 'SOME', 'CREATE', 'JOIN', 'STATISTICS', 'CROSS', 'KEY', 'SYSTEM_USER', 'CURRENT', 'KILL', 'TABLE', 'CURRENT_DATE', 'LEFT', 'TEXTSIZE', 'CURRENT_TIME', 'LIKE', 'THEN', 'CURRENT_TIMESTAMP', 'LINENO', 'TO', 'CURRENT_USER', 'LOAD', 'TOP', 'CURSOR', 'NATIONAL', 'TRAN', 'DATABASE', 'NOCHECK', 'TRANSACTION', 'DBCC', 'NONCLUSTERED', 'TRIGGER', 'DEALLOCATE', 'NOT', 'TRUNCATE', 'DECLARE', 'NULL', 'TSEQUAL', 'DEFAULT', 'NULLIF', 'UNION', 'DELETE', 'OF', 'UNIQUE', 'DENY', 'OFF', 'UPDATE', 'DESC', 'OFFSETS', 'UPDATETEXT', 'DISK', 'ON', 'USE', 'DISTINCT', 'OPEN', 'USER', 'DISTRIBUTED', 'OPENCONNECTOR', 'VALUES', 'DOUBLE', 'OPENQUERY', 'VARYING', 'DROP', 'OPENROWSET', 'VIEW', 'DUMMY', 'OPENXML', 'WAITFOR', 'DUMP', 'OPTION', 'WHEN', 'ELSE', 'OR', 'WHERE', 'END', 'ORDER', 'WHILE', 'ERRLVL', 'OUTER', 'WITH', 'ESCAPE', 'OVER', 'WRITETEXT', 'ANALYZE', 'ASENSITIVE', 'BEFORE', 'BIGINT', 'BINARY', 'BOTH', 'CALL', 'CHANGE', 'CHARACTER', 'CONDITION', 'DATABASES', 'DAY_HOUR', 'DAY_MICROSECOND', 'DAY_MINUTE', 'DAY_SECOND', 'DEC', 'DECIMAL', 'DELAYED', 'DESCRIBE', 'DETERMINISTIC', 'DISTINCTROW', 'DIV', 'DUAL', 'EACH', 'ELSEIF', 'ENCLOSED', 'ESCAPED', 'EXPLAIN', 'FALSE', 'FLOAT', 'FLOAT4', 'FLOAT8', 'FORCE', 'FULLTEXT', 'HIGH_PRIORITY', 'HOUR_MICROSECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'IGNORE', 'INFILE', 'INOUT', 'INSENSITIVE', 'INT', 'INT1', 'INT2', 'INT3', 'INT4', 'INT8', 'INTEGER', 'ITERATE', 'KEYS', 'LEADING', 'LEAVE', 'LIMIT', 'LINES', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCK', 'LONGBLOB', 'LONGTEXT', 'LOOP', 'LOW_PRIORITY', 'MATCH', 'MEDIUMBLOB', 'MEDIUMINT', 'MEDIUMTEXT', 'MIDDLEINT', 'MINUTE_MICROSECOND', 'MINUTE_SECOND', 'MOD', 'MODIFIES', 'NATURAL', 'NO_WRITE_TO_BINLOG', 'NUMERIC', 'OPTIMIZE', 'OPTIONALLY', 'OUT', 'OUTFILE', 'PURGE', 'READS', 'REAL', 'REGEXP', 'RELEASE', 'RENAME', 'REPEAT', 'REPLACE', 'REQUIRE', 'RLIKE', 'SCHEMAS', 'SECOND_MICROSECOND', 'SENSITIVE', 'SEPARATOR', 'SHOW', 'SMALLINT', 'SONAME', 'SPATIAL', 'SPECIFIC', 'SQL', 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'SQL_BIG_RESULT', 'SQL_CALC_FOUND_ROWS', 'SQL_SMALL_RESULT', 'SSL', 'STARTING', 'STRAIGHT_JOIN', 'TERMINATED', 'TINYBLOB', 'TINYINT', 'TINYTEXT', 'TRAILING', 'TRUE', 'UNDO', 'UNLOCK', 'UNSIGNED', 'USAGE', 'USING', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', 'VARBINARY', 'VARCHARACTER', 'WRITE', 'XOR', 'YEAR_MONTH', 'ZEROFILL', 'CONNECTION', 'LABEL', 'UPGRADE', 'DATE', 'VARCHAR', 'VARCHAR2', 'NVARCHAR2', 'CHAR', 'NCHAR', 'NUMBER', 'PLS_INTEGER', 'BINARY_INTEGER', 'LONG', 'TIMESTAMP', 'INTERVAL', 'RAW', 'ROWID', 'UROWID', 'MLSLABEL', 'CLOB', 'NCLOB', 'BLOB', 'BFILE', 'XMLTYPE', '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;
// Fix for issue #1177 - when trying to add or edit fields in a module an error message is shown:
// "Warning: Creating default object from empty value"
if (!isset($module->mbvardefs) || is_null($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 (empty($vardef['name'])) {
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']) && is_array($vardef['studio']) && !empty($vardef['studio']['no_duplicate']) && $vardef['studio']['no_duplicate'] == true || strcmp($field_name, "name") == 0 || 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("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);
$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
// 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;
}
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;
}
