1048 lines
41 KiB
PHP
Executable File
1048 lines
41 KiB
PHP
Executable File
<?php
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* 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".
|
|
*/
|
|
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
|
|
function getModuleFields(
|
|
$module,
|
|
$view = 'EditView',
|
|
$value = '',
|
|
$valid = array(),
|
|
$override = array()
|
|
) {
|
|
global $app_strings, $beanList, $current_user;
|
|
|
|
$blockedModuleFields = array(
|
|
// module = array( ... fields )
|
|
'Users' => array(
|
|
'id',
|
|
'is_admin',
|
|
'name',
|
|
'user_hash',
|
|
'user_name',
|
|
'system_generated_password',
|
|
'pwd_last_changed',
|
|
'authenticate_id',
|
|
'sugar_login',
|
|
'external_auth_only',
|
|
'deleted',
|
|
'is_group',
|
|
)
|
|
);
|
|
|
|
$fields = array('' => $app_strings['LBL_NONE']);
|
|
$unset = array();
|
|
|
|
if ($module !== '') {
|
|
if (isset($beanList[$module]) && $beanList[$module]) {
|
|
$mod = new $beanList[$module]();
|
|
foreach ($mod->field_defs as $name => $arr) {
|
|
if (ACLController::checkAccess($mod->module_dir, 'list', true)) {
|
|
if (array_key_exists($mod->module_dir, $blockedModuleFields)) {
|
|
if (in_array(
|
|
$arr['name'],
|
|
$blockedModuleFields[$mod->module_dir]
|
|
) && !$current_user->isAdmin()
|
|
) {
|
|
$GLOBALS['log']->debug('hiding ' . $arr['name'] . ' field from ' . $current_user->name);
|
|
continue;
|
|
}
|
|
}
|
|
|
|
if ($arr['type'] !== 'link'
|
|
&& $name !== 'currency_name'
|
|
&& $name !== 'currency_symbol'
|
|
&& (empty($valid) || in_array($arr['type'], $valid))
|
|
&& ((!isset($arr['source']) || $arr['source'] !== 'non-db')
|
|
|| ($arr['type'] === 'relate' && isset($arr['id_name']))
|
|
|| in_array($name, $override))
|
|
) {
|
|
if (isset($arr['vname']) && $arr['vname'] !== '') {
|
|
$fields[$name] = rtrim(translate($arr['vname'], $mod->module_dir), ':');
|
|
} else {
|
|
$fields[$name] = $name;
|
|
}
|
|
if ($arr['type'] === 'relate' && isset($arr['id_name']) && $arr['id_name'] !== '') {
|
|
$unset[] = $arr['id_name'];
|
|
}
|
|
}
|
|
}
|
|
} //End loop.
|
|
|
|
foreach ($unset as $name) {
|
|
if (isset($fields[$name])) {
|
|
unset($fields[$name]);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
asort($fields);
|
|
if ($view == 'JSON') {
|
|
return json_encode($fields);
|
|
}
|
|
if ($view == 'EditView') {
|
|
return get_select_options_with_id($fields, $value);
|
|
}
|
|
return $fields[$value];
|
|
}
|
|
|
|
function getRelModuleFields($module, $rel_field, $view='EditView', $value = '')
|
|
{
|
|
global $beanList;
|
|
|
|
if ($module == $rel_field) {
|
|
return getModuleFields($module, $view, $value);
|
|
}
|
|
|
|
$mod = new $beanList[$module]();
|
|
$data = $mod->field_defs[$rel_field];
|
|
|
|
if (isset($data['module']) && $data['module'] != '') {
|
|
return getModuleFields($data['module'], $view, $value);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* @param string $module
|
|
* @param string $linkFields
|
|
* @return string
|
|
*/
|
|
function getRelatedModule($module, $linkFields)
|
|
{
|
|
$linkField = explode(':', $linkFields, 2);
|
|
|
|
$link = $linkField[0];
|
|
$relatedModule = $module;
|
|
|
|
if ($module === $link) {
|
|
$relatedModule = $module;
|
|
} else {
|
|
$bean = BeanFactory::newBean($module);
|
|
if ($bean && $bean->load_relationship($link)) {
|
|
$relatedModule = $bean->$link->getRelatedModuleName();
|
|
}
|
|
}
|
|
|
|
if (!empty($linkField[1])) {
|
|
return getRelatedModule($relatedModule, $linkField[1]);
|
|
}
|
|
|
|
return $relatedModule;
|
|
}
|
|
|
|
function getModuleTreeData($module)
|
|
{
|
|
global $beanList, $app_list_strings;
|
|
|
|
$sort_fields = array();
|
|
$module_label = isset($app_list_strings['moduleList'][$module]) ? $app_list_strings['moduleList'][$module] : $module;
|
|
$fields = array(
|
|
$module => array('label' => $module_label,
|
|
'type' => 'module',
|
|
'module' => $module,
|
|
'module_label'=> $module_label)
|
|
);
|
|
|
|
if ($module != '' && ACLController::checkAccess($module, 'list', true)) {
|
|
if (isset($beanList[$module]) && $beanList[$module]) {
|
|
$mod = new $beanList[$module]();
|
|
|
|
foreach ($mod->get_linked_fields() as $name => $arr) {
|
|
if (isset($arr['module']) && $arr['module'] != '') {
|
|
$rel_module = $arr['module'];
|
|
} elseif ($mod->load_relationship($name)) {
|
|
$rel_module = $mod->$name->getRelatedModuleName();
|
|
}
|
|
|
|
if (!ACLController::checkAccess($rel_module, 'list', true)) {
|
|
continue;
|
|
}
|
|
|
|
$rel_module_label = isset($app_list_strings['moduleList'][$rel_module]) ? $app_list_strings['moduleList'][$rel_module] : $rel_module;
|
|
if (isset($arr['vname']) && $arr['vname'] != '') {
|
|
$label = $rel_module_label . ' : ' . translate($arr['vname'], $mod->module_dir);
|
|
$module_label = trim(translate($arr['vname'], $mod->module_dir), ':');
|
|
} else {
|
|
$label = $rel_module_label . ' : '. $name;
|
|
$module_label = $name;
|
|
}
|
|
$sort_fields[$name] = array('label'=>$label,'type'=>'relationship','module' => $rel_module,'module_label'=>$module_label);
|
|
if ($arr['type'] == 'relate' && isset($arr['id_name']) && $arr['id_name'] != '') {
|
|
if (isset($fields[$arr['id_name']])) {
|
|
unset($fields[$arr['id_name']]);
|
|
}
|
|
}
|
|
} //End loop.
|
|
uasort($sort_fields, function ($a, $b) {
|
|
return strcmp($a['label'], $b['label']);
|
|
});
|
|
|
|
$fields = array_merge($fields, $sort_fields);
|
|
}
|
|
}
|
|
|
|
return json_encode($fields);
|
|
}
|
|
|
|
function getModuleRelationships($module, $view='EditView', $value = '')
|
|
{
|
|
global $beanList, $app_list_strings;
|
|
|
|
$fields = array($module=>$app_list_strings['moduleList'][$module]);
|
|
$sort_fields = array();
|
|
$invalid_modules = array();
|
|
|
|
if ($module != '') {
|
|
if (isset($beanList[$module]) && $beanList[$module]) {
|
|
$mod = new $beanList[$module]();
|
|
|
|
/*if($mod->is_AuditEnabled()){
|
|
$fields['Audit'] = translate('LBL_AUDIT_TABLE','AOR_Fields');
|
|
}*/
|
|
foreach ($mod->get_linked_fields() as $name => $arr) {
|
|
if (isset($arr['module']) && $arr['module'] != '') {
|
|
$rel_module = $arr['module'];
|
|
} elseif ($mod->load_relationship($name)) {
|
|
$rel_module = $mod->$name->getRelatedModuleName();
|
|
}
|
|
if (!in_array($rel_module, $invalid_modules)) {
|
|
$relModuleName = isset($app_list_strings['moduleList'][$rel_module]) ? $app_list_strings['moduleList'][$rel_module] : $rel_module;
|
|
if (isset($arr['vname']) && $arr['vname'] != '') {
|
|
$sort_fields[$name] = $relModuleName.' : '.translate($arr['vname'], $mod->module_dir);
|
|
} else {
|
|
$sort_fields[$name] = $relModuleName.' : '. $name;
|
|
}
|
|
if ($arr['type'] == 'relate' && isset($arr['id_name']) && $arr['id_name'] != '') {
|
|
if (isset($fields[$arr['id_name']])) {
|
|
unset($fields[$arr['id_name']]);
|
|
}
|
|
}
|
|
}
|
|
} //End loop.
|
|
array_multisort($sort_fields, SORT_ASC, $sort_fields);
|
|
$fields = array_merge($fields, $sort_fields);
|
|
}
|
|
}
|
|
if ($view == 'EditView') {
|
|
return get_select_options_with_id($fields, $value);
|
|
}
|
|
return $fields[$value];
|
|
}
|
|
|
|
function getValidFieldsTypes($module, $field)
|
|
{
|
|
global $beanFiles, $beanList;
|
|
|
|
require_once($beanFiles[$beanList[$module]]);
|
|
$focus = new $beanList[$module];
|
|
$vardef = $focus->getFieldDefinition($field);
|
|
|
|
$vardefType = $vardef['type'] ?? '';
|
|
|
|
switch ($vardefType) {
|
|
case 'double':
|
|
case 'decimal':
|
|
case 'float':
|
|
case 'currency':
|
|
$valid_type = array('double','decimal','float','currency');
|
|
break;
|
|
case 'uint':
|
|
case 'ulong':
|
|
case 'long':
|
|
case 'short':
|
|
case 'tinyint':
|
|
case 'int':
|
|
$valid_type = array('uint','ulong','long','short','tinyint','int');
|
|
break;
|
|
case 'date':
|
|
case 'datetime':
|
|
case 'datetimecombo':
|
|
$valid_type = array('date','datetime', 'datetimecombo');
|
|
break;
|
|
case 'id':
|
|
case 'relate':
|
|
case 'link':
|
|
$valid_type = array('relate', 'id');
|
|
//if($vardef['module'] == 'Users') $valid_type = array();
|
|
break;
|
|
default:
|
|
$valid_type = array();
|
|
break;
|
|
}
|
|
|
|
return $valid_type;
|
|
}
|
|
|
|
|
|
function getModuleField(
|
|
$module,
|
|
$fieldname,
|
|
$aow_field,
|
|
$view='EditView',
|
|
$value = '',
|
|
$alt_type = '',
|
|
$currency_id = '',
|
|
$params= array()
|
|
) {
|
|
global $current_language;
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
global $current_user;
|
|
global $beanFiles;
|
|
global $beanList;
|
|
|
|
// use the mod_strings for this module
|
|
$mod_strings = return_module_language($current_language, $module);
|
|
|
|
// if aor condition
|
|
if (strstr((string) $aow_field, 'aor_conditions_value') !== false) {
|
|
// get aor condition row
|
|
$aor_row = str_replace('aor_conditions_value', '', (string) $aow_field);
|
|
$aor_row = str_replace('[', '', $aor_row);
|
|
$aor_row = str_replace(']', '', $aor_row);
|
|
// set the filename for this control
|
|
$file = create_cache_directory('modules/AOW_WorkFlow/')
|
|
. $module
|
|
. $view
|
|
. $alt_type
|
|
. $fieldname
|
|
. $aor_row
|
|
. '.tpl';
|
|
} else {
|
|
// its probably result of the report
|
|
// set the filename for this control
|
|
$file = create_cache_directory('modules/AOW_WorkFlow/')
|
|
. $module
|
|
. $view
|
|
. $alt_type
|
|
. $fieldname
|
|
. '.tpl';
|
|
}
|
|
|
|
$displayParams = array();
|
|
|
|
if (!is_file($file)
|
|
|| $view === 'EditView'
|
|
|| inDeveloperMode()
|
|
|| !empty($_SESSION['developerMode'])) {
|
|
if (!isset($vardef)) {
|
|
require_once($beanFiles[$beanList[$module]]);
|
|
$focus = new $beanList[$module];
|
|
$vardef = $focus->getFieldDefinition($fieldname);
|
|
}
|
|
|
|
// Bug: check for AOR value SecurityGroups value missing
|
|
if (stristr((string) $fieldname, 'securitygroups') != false && empty($vardef)) {
|
|
require_once($beanFiles[$beanList['SecurityGroups']]);
|
|
$module = 'SecurityGroups';
|
|
$focus = new $beanList[$module];
|
|
$vardef = $focus->getFieldDefinition($fieldname);
|
|
}
|
|
|
|
|
|
//$displayParams['formName'] = 'EditView';
|
|
|
|
// if this is the id relation field, then don't have a pop-up selector.
|
|
if ($vardef['type'] == 'relate' && $vardef['id_name'] == $vardef['name']) {
|
|
$vardef['type'] = 'varchar';
|
|
}
|
|
|
|
//$vardef['precision'] = $locale->getPrecedentPreference('default_currency_significant_digits', $current_user);
|
|
|
|
if ($vardef['type'] == 'datetime') {
|
|
$vardef['type'] = 'datetimecombo';
|
|
}
|
|
if ($vardef['type'] == 'datetimecombo') {
|
|
$displayParams['originalFieldName'] = $aow_field;
|
|
// Replace the square brackets by a deliberately complex alias to avoid JS conflicts
|
|
$displayParams['idName'] = createBracketVariableAlias($aow_field);
|
|
}
|
|
|
|
// trim down textbox display
|
|
if ($vardef['type'] == 'text') {
|
|
$vardef['rows'] = 2;
|
|
$vardef['cols'] = 32;
|
|
}
|
|
|
|
// create the dropdowns for the parent type fields
|
|
if ($vardef['type'] == 'parent_type') {
|
|
$vardef['type'] = 'enum';
|
|
}
|
|
|
|
if ($vardef['type'] == 'link') {
|
|
$vardef['type'] = 'relate';
|
|
$vardef['rname'] = 'name';
|
|
$vardef['id_name'] = $vardef['name'].'_id';
|
|
if ((!isset($vardef['module']) || $vardef['module'] == '') && $focus->load_relationship($vardef['name'])) {
|
|
$relName = $vardef['name'];
|
|
$vardef['module'] = $focus->$relName->getRelatedModuleName();
|
|
}
|
|
}
|
|
|
|
//check for $alt_type
|
|
if ($alt_type != '') {
|
|
$vardef['type'] = $alt_type;
|
|
}
|
|
|
|
// remove the special text entry field function 'getEmailAddressWidget'
|
|
if (isset($vardef['function'])
|
|
&& ($vardef['function'] == 'getEmailAddressWidget'
|
|
|| $vardef['function']['name'] == 'getEmailAddressWidget')) {
|
|
unset($vardef['function']);
|
|
}
|
|
|
|
if (isset($vardef['name']) && ($vardef['name'] == 'date_entered' || $vardef['name'] == 'date_modified')) {
|
|
$vardef['name'] = 'aow_temp_date';
|
|
}
|
|
|
|
// load SugarFieldHandler to render the field tpl file
|
|
static $sfh;
|
|
|
|
if (!isset($sfh)) {
|
|
require_once('include/SugarFields/SugarFieldHandler.php');
|
|
$sfh = new SugarFieldHandler();
|
|
}
|
|
|
|
$contents = $sfh->displaySmarty('fields', $vardef, $view, $displayParams);
|
|
|
|
// Remove all the copyright comments
|
|
$contents = preg_replace('/\{\*[^\}]*?\*\}/', '', (string) $contents);
|
|
|
|
if ($view == 'EditView' && ($vardef['type'] == 'relate' || $vardef['type'] == 'parent')) {
|
|
$contents = str_replace(
|
|
'"' . $vardef['id_name'] . '"',
|
|
'{/literal}"{$fields.' . $vardef['name'] . '.id_name}"{literal}',
|
|
$contents
|
|
);
|
|
$contents = str_replace(
|
|
'"' . $vardef['name'] . '"',
|
|
'{/literal}"{$fields.' . $vardef['name'] . '.name}"{literal}',
|
|
$contents
|
|
);
|
|
}
|
|
if ($view == 'DetailView' && $vardef['type'] == 'image') {
|
|
// Because TCPDF could not read image from download entryPoint, we need change entryPoint link to image path to resolved issue Image is not showing in PDF report
|
|
if ($_REQUEST['module'] == 'AOR_Reports' && $_REQUEST['action'] == 'DownloadPDF') {
|
|
global $sugar_config;
|
|
$upload_dir = isset($sugar_config['upload_dir']) ? $sugar_config['upload_dir'] : 'upload/';
|
|
$contents = str_replace('index.php?entryPoint=download&id=', $upload_dir, $contents);
|
|
$contents = str_replace('&type={$module}', '', $contents);
|
|
}
|
|
$contents = str_replace('{$fields.id.value}', '{$record_id}', $contents);
|
|
}
|
|
// hack to disable one of the js calls in this control
|
|
if (isset($vardef['function']) && ($vardef['function'] == 'getCurrencyDropDown' || $vardef['function']['name'] == 'getCurrencyDropDown')) {
|
|
$contents .= "{literal}<script>function CurrencyConvertAll() { return; }</script>{/literal}";
|
|
}
|
|
|
|
// Save it to the cache file
|
|
if ($fh = @sugar_fopen($file, 'w')) {
|
|
fwrite($fh, $contents);
|
|
fclose($fh);
|
|
}
|
|
}
|
|
|
|
// Now render the template we received
|
|
$ss = new Sugar_Smarty();
|
|
|
|
// Create Smarty variables for the Calendar picker widget
|
|
global $timedate;
|
|
$time_format = $timedate->get_user_time_format();
|
|
$date_format = $timedate->get_cal_date_format();
|
|
$ss->assign('USER_DATEFORMAT', $timedate->get_user_date_format());
|
|
$ss->assign('TIME_FORMAT', $time_format);
|
|
$time_separator = ":";
|
|
$match = array();
|
|
if (preg_match('/\d+([^\d])\d+([^\d]*)/s', (string) $time_format, $match)) {
|
|
$time_separator = $match[1];
|
|
}
|
|
$t23 = strpos((string) $time_format, '23') !== false ? '%H' : '%I';
|
|
if (!isset($match[2]) || $match[2] == '') {
|
|
$ss->assign('CALENDAR_FORMAT', $date_format . ' ' . $t23 . $time_separator . "%M");
|
|
} else {
|
|
$pm = $match[2] == "pm" ? "%P" : "%p";
|
|
$ss->assign('CALENDAR_FORMAT', $date_format . ' ' . $t23 . $time_separator . "%M" . $pm);
|
|
}
|
|
|
|
$ss->assign('CALENDAR_FDOW', $current_user->get_first_day_of_week());
|
|
|
|
// populate the fieldlist from the vardefs
|
|
$fieldlist = array();
|
|
if (!isset($focus) || !($focus instanceof SugarBean)) {
|
|
require_once($beanFiles[$beanList[$module]]);
|
|
}
|
|
$focus = new $beanList[$module];
|
|
// create the dropdowns for the parent type fields
|
|
$vardefFields = $focus->getFieldDefinitions();
|
|
if (isset($vardefFields[$fieldname]['type']) && $vardefFields[$fieldname]['type'] == 'parent_type') {
|
|
$focus->field_defs[$fieldname]['options'] = $focus->field_defs[$vardefFields[$fieldname]['group']]['options'];
|
|
}
|
|
foreach ($vardefFields as $name => $properties) {
|
|
$fieldlist[$name] = $properties;
|
|
// fill in enums
|
|
if (isset($fieldlist[$name]['options']) && is_string($fieldlist[$name]['options']) && isset($app_list_strings[$fieldlist[$name]['options']])) {
|
|
$fieldlist[$name]['options'] = $app_list_strings[$fieldlist[$name]['options']];
|
|
} // Bug 32626: fall back on checking the mod_strings if not in the app_list_strings
|
|
elseif (isset($fieldlist[$name]['options']) && is_string($fieldlist[$name]['options']) && isset($mod_strings[$fieldlist[$name]['options']])) {
|
|
$fieldlist[$name]['options'] = $mod_strings[$fieldlist[$name]['options']];
|
|
}
|
|
// Bug 22730: make sure all enums have the ability to select blank as the default value.
|
|
// Make sure the enum has an 'options' array to append a new value to.
|
|
if (isset($fieldlist[$name]['options']) && is_array($fieldlist[$name]['options']) && !isset($fieldlist[$name]['options'][''])) {
|
|
$fieldlist[$name]['options'][''] = '';
|
|
}
|
|
// Fix #9435 - The editview of a workflow is built using a Smarty template. When editing an existing workflow with an action
|
|
// that sets to blank an enum field which has a not blank default value, the template does not show the blank value (as expected)
|
|
// but the default value. In order to properly show the expected blank value, we hack the vardef definition overriding default value
|
|
// with blank value when the stored workflow value (now in $value) is blank.
|
|
if ($fieldlist[$name]['type'] == 'enum' || $fieldlist[$name]['type'] == 'multienum' || $fieldlist[$name]['type'] == 'dynamicenum') {
|
|
$fieldlist[$name]['default'] = $value === "" ? $value : $fieldlist[$name]['default'];
|
|
}
|
|
}
|
|
|
|
// fill in function return values
|
|
if (!in_array($fieldname, array('email1','email2'))) {
|
|
if (!empty($fieldlist[$fieldname]['function']['returns']) && $fieldlist[$fieldname]['function']['returns'] == 'html') {
|
|
$function = $fieldlist[$fieldname]['function']['name'];
|
|
// include various functions required in the various vardefs
|
|
if (isset($fieldlist[$fieldname]['function']['include']) && is_file($fieldlist[$fieldname]['function']['include'])) {
|
|
require_once($fieldlist[$fieldname]['function']['include']);
|
|
}
|
|
$_REQUEST[$fieldname] = $value;
|
|
$value = $function($focus, $fieldname, $value, $view);
|
|
|
|
$value = str_ireplace((string) $fieldname, (string) $aow_field, (string) $value);
|
|
}
|
|
}
|
|
|
|
if (isset($fieldlist[$fieldname]['type']) && $fieldlist[$fieldname]['type'] == 'link') {
|
|
$fieldlist[$fieldname]['id_name'] = $fieldlist[$fieldname]['name'].'_id';
|
|
|
|
if ((!isset($fieldlist[$fieldname]['module']) || $fieldlist[$fieldname]['module'] == '') && $focus->load_relationship($fieldlist[$fieldname]['name'])) {
|
|
$relName = $fieldlist[$fieldname]['name'];
|
|
$fieldlist[$fieldname]['module'] = $focus->$relName->getRelatedModuleName();
|
|
}
|
|
}
|
|
|
|
if (isset($fieldlist[$fieldname]['name']) && ($fieldlist[$fieldname]['name'] == 'date_entered' || $fieldlist[$fieldname]['name'] == 'date_modified')) {
|
|
$fieldlist[$fieldname]['name'] = 'aow_temp_date';
|
|
$fieldlist['aow_temp_date'] = $fieldlist[$fieldname];
|
|
$fieldname = 'aow_temp_date';
|
|
}
|
|
|
|
$quicksearch_js = '';
|
|
if (isset($fieldlist[$fieldname]['id_name']) && $fieldlist[$fieldname]['id_name'] != '' && $fieldlist[$fieldname]['id_name'] != $fieldlist[$fieldname]['name']) {
|
|
$rel_value = $value;
|
|
|
|
// avoid printing js content in CLI commands for example cron
|
|
$sapi_type = php_sapi_name();
|
|
if (substr($sapi_type, 0, 3) != 'cli') {
|
|
require_once("include/TemplateHandler/TemplateHandler.php");
|
|
$template_handler = new TemplateHandler();
|
|
$quicksearch_js = $template_handler->createQuickSearchCode($fieldlist, $fieldlist, $view);
|
|
$quicksearch_js = str_replace($fieldname, $aow_field.'_display', (string) $quicksearch_js);
|
|
$quicksearch_js = str_replace($fieldlist[$fieldname]['id_name'], $aow_field, $quicksearch_js);
|
|
|
|
echo $quicksearch_js;
|
|
}
|
|
|
|
if (isset($fieldlist[$fieldname]['module']) && $fieldlist[$fieldname]['module'] == 'Users') {
|
|
$rel_value = get_assigned_user_name($value);
|
|
} elseif (isset($fieldlist[$fieldname]['module'])) {
|
|
require_once($beanFiles[$beanList[$fieldlist[$fieldname]['module']]]);
|
|
$rel_focus = new $beanList[$fieldlist[$fieldname]['module']];
|
|
$rel_focus->retrieve($value);
|
|
if (isset($fieldlist[$fieldname]['rname']) && $fieldlist[$fieldname]['rname'] != '') {
|
|
$relDisplayField = $fieldlist[$fieldname]['rname'];
|
|
} else {
|
|
$relDisplayField = 'name';
|
|
}
|
|
$rel_value = $rel_focus->$relDisplayField;
|
|
}
|
|
|
|
$fieldlist[$fieldlist[$fieldname]['id_name']]['value'] = $value;
|
|
$fieldlist[$fieldname]['value'] = $rel_value;
|
|
$fieldlist[$fieldname]['id_name'] = $aow_field;
|
|
$fieldlist[$fieldlist[$fieldname]['id_name']]['name'] = $aow_field;
|
|
$fieldlist[$fieldname]['name'] = $aow_field.'_display';
|
|
} elseif (isset($fieldlist[$fieldname]['type']) && $view == 'DetailView' && ($fieldlist[$fieldname]['type'] == 'datetimecombo' || $fieldlist[$fieldname]['type'] == 'datetime' || $fieldlist[$fieldname]['type'] == 'date')) {
|
|
$value = $focus->convertField($value, $fieldlist[$fieldname]);
|
|
if (!empty($params['date_format']) && isset($params['date_format'])) {
|
|
$convert_format = "Y-m-d H:i:s";
|
|
if ($fieldlist[$fieldname]['type'] == 'date') {
|
|
$convert_format = "Y-m-d";
|
|
}
|
|
$fieldlist[$fieldname]['value'] = $timedate->to_display($value, $convert_format, $params['date_format']);
|
|
} else {
|
|
if ($fieldlist[$fieldname]['type'] == 'date') {
|
|
$fieldlist[$fieldname]['value'] = $timedate->to_display_date($value, false);
|
|
} else {
|
|
$fieldlist[$fieldname]['value'] = $timedate->to_display_date_time($value, true, true);
|
|
}
|
|
}
|
|
$fieldlist[$fieldname]['name'] = $aow_field;
|
|
} elseif (isset($fieldlist[$fieldname]['type']) && ($fieldlist[$fieldname]['type'] == 'datetimecombo' || $fieldlist[$fieldname]['type'] == 'datetime' || $fieldlist[$fieldname]['type'] == 'date')) {
|
|
$value = $focus->convertField($value, $fieldlist[$fieldname]);
|
|
if($fieldlist[$fieldname]['type'] === "date"){
|
|
$displayValue = $timedate->to_display_date($value);
|
|
}else{
|
|
$displayValue = $timedate->to_display_date_time($value);
|
|
}
|
|
$fieldlist[$fieldname]['value'] = $fieldlist[$aow_field]['value'] = $displayValue;
|
|
$fieldlist[$fieldname]['name'] = $aow_field;
|
|
} else {
|
|
$fieldlist[$fieldname]['value'] = $value;
|
|
$fieldlist[$fieldname]['name'] = $aow_field;
|
|
}
|
|
|
|
if (isset($fieldlist[$fieldname]['type']) && $fieldlist[$fieldname]['type'] == 'datetimecombo' || $fieldlist[$fieldname]['type'] == 'datetime') {
|
|
$fieldlist[$aow_field]['aliasId'] = createBracketVariableAlias($aow_field);
|
|
$fieldlist[$aow_field]['originalId'] = $aow_field;
|
|
}
|
|
|
|
$parentfieldlist = [];
|
|
|
|
if (isset($fieldlist[$fieldname]['type']) && $fieldlist[$fieldname]['type'] == 'currency' && $view != 'EditView') {
|
|
static $sfh;
|
|
|
|
if (!isset($sfh)) {
|
|
require_once('include/SugarFields/SugarFieldHandler.php');
|
|
$sfh = new SugarFieldHandler();
|
|
}
|
|
|
|
if ($currency_id != '' && !stripos((string) $fieldname, '_USD')) {
|
|
$userCurrencyId = $current_user->getPreference('currency');
|
|
if ($currency_id != $userCurrencyId) {
|
|
$currency = BeanFactory::newBean('Currencies');
|
|
$currency->retrieve($currency_id);
|
|
$value = $currency->convertToDollar($value);
|
|
$currency->retrieve($userCurrencyId);
|
|
$value = $currency->convertFromDollar($value);
|
|
}
|
|
}
|
|
|
|
$parentfieldlist[strtoupper($fieldname)] = $value;
|
|
|
|
return($sfh->displaySmarty($parentfieldlist, $fieldlist[$fieldname], 'ListView', $displayParams));
|
|
}
|
|
|
|
$ss->assign("QS_JS", $quicksearch_js);
|
|
$ss->assign("fields", $fieldlist);
|
|
$ss->assign("form_name", $view);
|
|
$ss->assign("bean", $focus);
|
|
|
|
// Add in any additional strings
|
|
$ss->assign("MOD", $mod_strings);
|
|
$ss->assign("APP", $app_strings);
|
|
$ss->assign("module", $module);
|
|
if (!empty($params['record_id'])) {
|
|
$ss->assign("record_id", $params['record_id']);
|
|
}
|
|
|
|
return $ss->fetch($file);
|
|
}
|
|
|
|
/**
|
|
* Convert a bracketed variable into a string that can become a JS variable
|
|
*
|
|
* @param string $variable
|
|
* @return string
|
|
*/
|
|
function createBracketVariableAlias($variable)
|
|
{
|
|
$replaceRightBracket = str_replace(']', '', $variable);
|
|
$replaceLeftBracket = str_replace('[', '', $replaceRightBracket);
|
|
return $replaceLeftBracket;
|
|
}
|
|
|
|
/**
|
|
* @param string $module
|
|
* @param string $aow_field
|
|
* @param string $view
|
|
* @param $value
|
|
* @param bool $field_option
|
|
* @return string
|
|
*/
|
|
function getDateField($module, $aow_field, $view, $value = null, $field_option = true)
|
|
{
|
|
global $app_list_strings;
|
|
|
|
// set $view = 'EditView' as default
|
|
if (!$view) {
|
|
$view = 'EditView';
|
|
}
|
|
|
|
$value = json_decode((string) html_entity_decode_utf8($value), true);
|
|
|
|
if (!file_exists('modules/AOBH_BusinessHours/AOBH_BusinessHours.php')) {
|
|
unset($app_list_strings['aow_date_type_list']['business_hours']);
|
|
}
|
|
|
|
$field = '';
|
|
|
|
$valueZero = $value[0] ?? '';
|
|
$valueOne = $value[1] ?? '';
|
|
$valueTwo = $value[2] ?? '';
|
|
$valueThree = $value[3] ?? '';
|
|
|
|
if ($view == 'EditView') {
|
|
$field .= "<select type='text' name='$aow_field".'[0]'."' id='$aow_field".'[0]'."' title='' tabindex='116'>". getDateFields($module, $view, $valueZero, $field_option) ."</select> ";
|
|
$field .= "<select type='text' name='$aow_field".'[1]'."' id='$aow_field".'[1]'."' onchange='date_field_change(\"$aow_field\")' title='' tabindex='116'>". get_select_options_with_id($app_list_strings['aow_date_operator'], $valueOne) ."</select> ";
|
|
$display = 'none';
|
|
|
|
if ($valueOne == 'plus' || $valueOne == 'minus') {
|
|
$display = '';
|
|
}
|
|
|
|
$field .= "<input type='text' style='display:$display' name='$aow_field".'[2]'."' id='$aow_field".'[2]'."' title='' value='$valueTwo' tabindex='116'> ";
|
|
$field .= "<select type='text' style='display:$display' name='$aow_field".'[3]'."' id='$aow_field".'[3]'."' title='' tabindex='116'>". get_select_options_with_id($app_list_strings['aow_date_type_list'], $valueThree) ."</select>";
|
|
} else {
|
|
$field = getDateFields($module, $view, $valueZero, $field_option).' '.$app_list_strings['aow_date_operator'][$valueOne];
|
|
|
|
if ($valueOne == 'plus' || $valueOne == 'minus') {
|
|
$field .= ' '.$valueTwo.' '.$app_list_strings['aow_date_type_list'][$valueThree];
|
|
}
|
|
}
|
|
return $field;
|
|
}
|
|
|
|
function getDateFields($module, $view='EditView', $value = '', $field_option = true)
|
|
{
|
|
global $beanList, $app_list_strings;
|
|
|
|
$fields = $app_list_strings['aow_date_options'];
|
|
|
|
if (!$field_option) {
|
|
unset($fields['field']);
|
|
}
|
|
|
|
if ($module != '') {
|
|
if (isset($beanList[$module]) && $beanList[$module]) {
|
|
$mod = new $beanList[$module]();
|
|
foreach ($mod->field_defs as $name => $arr) {
|
|
if ($arr['type'] == 'date' || $arr['type'] == 'datetime' || $arr['type'] == 'datetimecombo') {
|
|
if (isset($arr['vname']) && $arr['vname'] != '') {
|
|
$fields[$name] = translate($arr['vname'], $mod->module_dir);
|
|
} else {
|
|
$fields[$name] = $name;
|
|
}
|
|
}
|
|
} //End loop.
|
|
}
|
|
}
|
|
if ($view == 'EditView') {
|
|
return get_select_options_with_id($fields, $value);
|
|
}
|
|
return $fields[$value];
|
|
}
|
|
|
|
function getAssignField($aow_field, $view, $value)
|
|
{
|
|
|
|
global $app_list_strings;
|
|
|
|
$value = json_decode(html_entity_decode_utf8($value), true);
|
|
|
|
$value = $value ?? [];
|
|
|
|
$roles = get_bean_select_array(true, 'ACLRole', 'name', '', 'name', true);
|
|
|
|
$securityGroups = [];
|
|
|
|
if (!file_exists('modules/SecurityGroups/SecurityGroup.php')) {
|
|
unset($app_list_strings['aow_assign_options']['security_group']);
|
|
} else {
|
|
$securityGroups = get_bean_select_array(true, 'SecurityGroup', 'name', '', 'name', true);
|
|
}
|
|
|
|
$field = '';
|
|
|
|
if ($view == 'EditView') {
|
|
$field .= "<select type='text' name='$aow_field".'[0]'."' id='$aow_field".'[0]'."' onchange='assign_field_change(\"$aow_field\")' title='' tabindex='116'>". get_select_options_with_id($app_list_strings['aow_assign_options'] ?? '', $value[0] ?? '') ."</select> ";
|
|
if (!file_exists('modules/SecurityGroups/SecurityGroup.php')) {
|
|
$field .= "<input type='hidden' name='$aow_field".'[1]'."' id='$aow_field".'[1]'."' value='' />";
|
|
} else {
|
|
$display = 'none';
|
|
if (($value[0] ?? '') === 'security_group') {
|
|
$display = '';
|
|
}
|
|
$field .= "<select type='text' style='display:$display' name='$aow_field".'[1]'."' id='$aow_field".'[1]'."' title='' tabindex='116'>". get_select_options_with_id($securityGroups, $value[1] ?? '') ."</select> ";
|
|
}
|
|
$display = 'none';
|
|
if (($value[0] ?? '') === 'role' || ($value[0] ?? '') === 'security_group') {
|
|
$display = '';
|
|
}
|
|
$field .= "<select type='text' style='display:$display' name='$aow_field".'[2]'."' id='$aow_field".'[2]'."' title='' tabindex='116'>". get_select_options_with_id($roles, $value[2] ?? '') ."</select> ";
|
|
} else {
|
|
$field = $app_list_strings['aow_assign_options'][($value[1] ?? '')];
|
|
}
|
|
return $field;
|
|
}
|
|
|
|
function getDropdownList($list_id, $selected_value)
|
|
{
|
|
global $app_list_strings;
|
|
$option = '';
|
|
foreach ($app_list_strings[$list_id] as $key => $value) {
|
|
if (base64_decode($selected_value) == $key) {
|
|
$option .= '<option value="'.$key.'" selected>'.$value.'</option>';
|
|
} elseif ($selected_value == $key) {
|
|
$option .= '<option value="'.$key.'" selected>'.$value.'</option>';
|
|
} else {
|
|
$option .= '<option value="'.$key.'">'.$value.'</option>';
|
|
}
|
|
}
|
|
return $option;
|
|
}
|
|
function getLeastBusyUser($users, $field, SugarBean $bean)
|
|
{
|
|
$counts = array();
|
|
foreach ($users as $id) {
|
|
$c = $bean->db->getOne("SELECT count(*) AS c FROM ".$bean->table_name." WHERE $field = '$id' AND deleted = 0");
|
|
$counts[$id] = $c;
|
|
}
|
|
asort($counts);
|
|
$countsKeys = array_flip($counts);
|
|
return array_shift($countsKeys);
|
|
}
|
|
|
|
function getRoundRobinUser($users, $id)
|
|
{
|
|
$lastUser = [];
|
|
$file = create_cache_directory('modules/AOW_WorkFlow/Users/') . $id . 'lastUser.cache.php';
|
|
|
|
if (isset($_SESSION['lastuser'][$id]) && $_SESSION['lastuser'][$id] != '') {
|
|
$users_by_key = array_flip($users); // now keys are values
|
|
$key = $users_by_key[$_SESSION['lastuser'][$id]] + 1;
|
|
if (!empty($users[$key])) {
|
|
return $users[$key];
|
|
}
|
|
} elseif (is_file($file)) {
|
|
require_once($file);
|
|
if (isset($lastUser['User']) && $lastUser['User'] != '') {
|
|
$users_by_key = array_flip($users); // now keys are values
|
|
$key = $users_by_key[$lastUser['User']] + 1;
|
|
if (!empty($users[$key])) {
|
|
return $users[$key];
|
|
}
|
|
}
|
|
}
|
|
|
|
return $users[0];
|
|
}
|
|
|
|
function setLastUser($user_id, $id)
|
|
{
|
|
$_SESSION['lastuser'][$id] = $user_id;
|
|
|
|
$file = create_cache_directory('modules/AOW_WorkFlow/Users/') . $id . 'lastUser.cache.php';
|
|
|
|
$arrayString = var_export_helper(array('User' => $user_id));
|
|
|
|
$content =<<<eoq
|
|
<?php
|
|
\$lastUser = {$arrayString};
|
|
?>
|
|
eoq;
|
|
|
|
if ($fh = @sugar_fopen($file, 'w')) {
|
|
fwrite($fh, $content);
|
|
fclose($fh);
|
|
}
|
|
return true;
|
|
}
|
|
|
|
function getEmailableModules()
|
|
{
|
|
global $beanFiles, $beanList, $app_list_strings;
|
|
$emailableModules = array();
|
|
foreach ($app_list_strings['aow_moduleList'] as $bean_name => $bean_dis) {
|
|
if (isset($beanList[$bean_name]) && isset($beanFiles[$beanList[$bean_name]])) {
|
|
require_once($beanFiles[$beanList[$bean_name]]);
|
|
$obj = new $beanList[$bean_name];
|
|
if ($obj instanceof Person || $obj instanceof Company) {
|
|
$emailableModules[] = $bean_name;
|
|
}
|
|
}
|
|
}
|
|
asort($emailableModules);
|
|
return $emailableModules;
|
|
}
|
|
|
|
function getRelatedEmailableFields($module)
|
|
{
|
|
global $beanList, $app_list_strings;
|
|
$relEmailFields = array();
|
|
$checked_link = array();
|
|
$emailableModules = getEmailableModules();
|
|
if ($module != '') {
|
|
if (isset($beanList[$module]) && $beanList[$module]) {
|
|
$mod = new $beanList[$module]();
|
|
|
|
foreach ($mod->get_related_fields() as $field) {
|
|
if (isset($field['link'])) {
|
|
$checked_link[] = $field['link'];
|
|
}
|
|
if (!isset($field['module']) || !in_array($field['module'], $emailableModules) || (isset($field['dbType']) && $field['dbType'] == "id")) {
|
|
continue;
|
|
}
|
|
$relEmailFields[$field['name']] = translate($field['module']) . ": "
|
|
. trim(translate($field['vname'], $mod->module_name), ":");
|
|
}
|
|
|
|
foreach ($mod->get_linked_fields() as $field) {
|
|
if (!in_array($field['name'], $checked_link) && !in_array($field['relationship'], $checked_link)) {
|
|
if (isset($field['module']) && $field['module'] != '') {
|
|
$rel_module = $field['module'];
|
|
} elseif ($mod->load_relationship($field['name'])) {
|
|
$relField = $field['name'];
|
|
$rel_module = $mod->$relField->getRelatedModuleName();
|
|
}
|
|
|
|
if (in_array($rel_module, $emailableModules)) {
|
|
if (isset($field['vname']) && $field['vname'] != '') {
|
|
$relEmailFields[$field['name']] = $app_list_strings['moduleList'][$rel_module] . ' : ' . translate($field['vname'], $mod->module_dir);
|
|
} else {
|
|
$relEmailFields[$field['name']] = $app_list_strings['moduleList'][$rel_module] . ' : ' . $field['name'];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
array_multisort($relEmailFields, SORT_ASC, $relEmailFields);
|
|
}
|
|
}
|
|
return $relEmailFields;
|
|
}
|
|
|
|
function fixUpFormatting($module, $field, $value)
|
|
{
|
|
global $timedate, $beanFiles, $beanList;
|
|
|
|
require_once($beanFiles[$beanList[$module]]);
|
|
$bean = new $beanList[$module];
|
|
|
|
static $boolean_false_values = array('off', 'false', '0', 'no');
|
|
|
|
$defsFieldType = $bean->field_defs[$field]['type'] ?? '';
|
|
switch ($defsFieldType) {
|
|
case 'datetime':
|
|
case 'datetimecombo':
|
|
// If value is array, don't attempt to convert to DB format
|
|
if (empty($value) || is_array($value)) {
|
|
break;
|
|
}
|
|
if ($value == 'NULL') {
|
|
$value = '';
|
|
break;
|
|
}
|
|
if (! preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}$/', (string) $value)) {
|
|
// This appears to be formatted in user date/time
|
|
$value = $timedate->to_db($value);
|
|
}
|
|
break;
|
|
case 'date':
|
|
// If value is array, don't attempt to convert to DB format
|
|
if (empty($value) || is_array($value)) {
|
|
break;
|
|
}
|
|
if ($value == 'NULL') {
|
|
$value = '';
|
|
break;
|
|
}
|
|
if (! preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', (string) $value)) {
|
|
// This date appears to be formatted in the user's format
|
|
$value = $timedate->to_db_date($value, false);
|
|
}
|
|
break;
|
|
case 'time':
|
|
if (empty($value)) {
|
|
break;
|
|
}
|
|
if ($value == 'NULL') {
|
|
$value = '';
|
|
break;
|
|
}
|
|
if (preg_match('/(am|pm)/i', (string) $value)) {
|
|
// This time appears to be formatted in the user's format
|
|
$value = $timedate->fromUserTime($value)->format(TimeDate::DB_TIME_FORMAT);
|
|
}
|
|
break;
|
|
case 'double':
|
|
case 'decimal':
|
|
case 'currency':
|
|
case 'float':
|
|
if ($value === '' || $value == null || $value == 'NULL') {
|
|
break;
|
|
}
|
|
if (is_string($value)) {
|
|
$value = (float)unformat_number($value);
|
|
}
|
|
break;
|
|
case 'uint':
|
|
case 'ulong':
|
|
case 'long':
|
|
case 'short':
|
|
case 'tinyint':
|
|
case 'int':
|
|
if ($value === '' || $value == null || $value == 'NULL') {
|
|
break;
|
|
}
|
|
if (is_string($value)) {
|
|
$value = (int)unformat_number($value);
|
|
}
|
|
break;
|
|
case 'bool':
|
|
if (empty($value)) {
|
|
$value = false;
|
|
} elseif (true === $value || 1 == $value) {
|
|
$value = true;
|
|
} elseif (in_array((string)$value, $boolean_false_values)) {
|
|
$value = false;
|
|
} else {
|
|
$value = true;
|
|
}
|
|
break;
|
|
}
|
|
return $value;
|
|
}
|