function _get_column_select($layout_def)
{
global $sugar_config;
// if $this->db->dbytpe is empty, then grab dbtype value from global array "$sugar_config[dbconfig]"
if (empty($this->db->dbType)) {
$this->db->dbType = $sugar_config['dbconfig']['db_type'];
}
$field_def = $this->reporter->all_fields[$layout_def['column_key']];
if (empty($field_def['fields']) || empty($field_def['fields'][0]) || empty($field_def['fields'][1])) {
return parent::_get_column_select($layout_def);
}
// 'fields' are the two fields to concat to create the name
$alias = '';
$endalias = '';
if (!empty($layout_def['table_alias'])) {
if ($this->db->dbType == 'mysql') {
$alias .= "CONCAT(CONCAT(IFNULL(" . $layout_def['table_alias'] . "." . $field_def['fields'][0] . ",''),' ')," . $layout_def['table_alias'] . "." . $field_def['fields'][1] . ")";
} elseif ($this->db->dbType == 'mssql') {
$alias .= $layout_def['table_alias'] . '.' . $field_def['fields'][0] . " + ' ' + " . $layout_def['table_alias'] . '.' . $field_def['fields'][1] . "";
}
} elseif (!empty($layout_def['name'])) {
$alias = $layout_def['name'];
} else {
$alias .= "*";
}
$alias .= $endalias;
return $alias;
}
/**
* Gets the lowercase version of the name of the field for use in queries
*
* @param array $def
* @return string
*/
protected function getLowercaseColumnSelect($def)
{
// Copied to ensure that references don't get clobbered after this point
$hold = $def;
$hold['name'] .= '_lower';
return parent::_get_column_select($hold);
}
function queryFilterEmpty(&$layout_def)
{
if ($this->reporter->db->dbType == 'mysql') {
return parent::queryFilterEmpty($layout_def);
} elseif ($this->reporter->db->dbType == 'mssql') {
return '( ' . $this->_get_column_select($layout_def) . ' IS NULL OR DATALENGTH(' . $this->_get_column_select($layout_def) . ") = 0)\n";
}
}
function SugarWidgetFieldText(&$layout_manager)
{
parent::SugarWidgetFieldVarchar($layout_manager);
}
function _get_column_select($layout_def)
{
global $locale, $current_user;
if (isset($this->reporter->all_fields)) {
$field_def = $this->reporter->all_fields[$layout_def['column_key']];
} else {
$field_def = array();
}
// 'fields' are the two fields to concatenate to create the name
if (!isset($field_def['fields'])) {
return $this->_get_normal_column_select($layout_def);
}
$localeNameFormat = $locale->getLocaleFormatMacro($current_user);
$localeNameFormat = trim(preg_replace('/s/i', '', $localeNameFormat));
if (empty($field_def['fields']) || empty($field_def['fields'][0]) || empty($field_def['fields'][1])) {
return parent::_get_column_select($layout_def);
}
if (!empty($layout_def['table_alias'])) {
$comps = preg_split("/([fl])/", $localeNameFormat, null, PREG_SPLIT_DELIM_CAPTURE);
$name = array();
foreach ($comps as $val) {
if ($val == 'f') {
$name[] = $this->reporter->db->convert($layout_def['table_alias'] . "." . $field_def['fields'][0], 'IFNULL', array("''"));
} elseif ($val == 'l') {
$name[] = $this->reporter->db->convert($layout_def['table_alias'] . "." . $field_def['fields'][1], 'IFNULL', array("''"));
} else {
if (!empty($val)) {
$name[] = $this->reporter->db->quoted($val);
}
}
}
$alias = $this->reporter->db->convert($name, "CONCAT");
} elseif (!empty($layout_def['name'])) {
$alias = $layout_def['name'];
} else {
$alias = "*";
}
return $alias;
}
function displayList($layout_def)
{
return nl2br(parent::displayListPlain($layout_def));
}
public function __construct($layout_manager)
{
parent::__construct($layout_manager);
}
function _get_column_select($layout_def)
{
global $sugar_config;
global $locale, $current_user;
// if $this->db->dbytpe is empty, then grab dbtype value from global array "$sugar_config[dbconfig]"
if (empty($this->db->dbType)) {
$this->db->dbType = $sugar_config['dbconfig']['db_type'];
}
if (isset($this->reporter->all_fields)) {
$field_def = $this->reporter->all_fields[$layout_def['column_key']];
} else {
$field_def = array();
}
// 'fields' are the two fields to concat to create the name
$alias = '';
$endalias = '';
if (!isset($field_def['fields'])) {
$alias = $this->_get_normal_column_select($layout_def);
return $alias;
}
$localeNameFormat = $locale->getLocaleFormatMacro($current_user);
$localeNameFormat = trim(preg_replace('/s/i', '', $localeNameFormat));
$names = array();
$names['f'] = db_convert($layout_def['table_alias'] . '.' . $field_def['fields'][0] . ",''", "IFNULL");
$names['l'] = $layout_def['table_alias'] . '.' . $field_def['fields'][1];
if (empty($field_def['fields']) || empty($field_def['fields'][0]) || empty($field_def['fields'][1])) {
return parent::_get_column_select($layout_def);
}
if (!empty($layout_def['table_alias'])) {
if ($this->db->dbType == 'mysql') {
for ($i = 0; $i < strlen($localeNameFormat); $i++) {
$alias .= array_key_exists($localeNameFormat[$i], $names) ? $names[$localeNameFormat[$i]] : '\'' . $localeNameFormat[$i] . '\'';
if ($i < strlen($localeNameFormat) - 1) {
$alias .= ',';
}
}
if (strlen($localeNameFormat) > 1) {
$alias = 'concat(' . $alias . ')';
}
} elseif ($this->db->dbType == 'mssql') {
for ($i = 0; $i < strlen($localeNameFormat); $i++) {
$alias .= array_key_exists($localeNameFormat[$i], $names) ? $names[$localeNameFormat[$i]] : '\'' . $localeNameFormat[$i] . '\'';
if ($i < strlen($localeNameFormat) - 1) {
$alias .= ' + ';
}
}
}
} elseif (!empty($layout_def['name'])) {
$alias = $layout_def['name'];
} else {
$alias .= "*";
}
$alias .= $endalias;
return $alias;
}
public function SugarWidgetFieldCronSchedule($layout_manager)
{
parent::SugarWidgetFieldText($layout_manager);
}
