";
}
return $str;
}
function _get_normal_column_select($layout_def)
{
if ( isset($this->reporter->all_fields) ) {
$field_def = $this->reporter->all_fields[$layout_def['column_key']];
} else {
$field_def = array();
}
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
if ( ! empty($layout_def['table_alias'])) {
$alias = $this->reporter->db->concat($layout_def['table_alias'], $field_def['fields']);
} elseif (! empty($layout_def['name'])) {
$alias = $layout_def['name'];
} else {
$alias = "*";
}
return $alias;
}
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 concat 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 queryFilterIs($layout_def)
{
require_once('include/generic/SugarWidgets/SugarWidgetFieldid.php');
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
$input_name0 = $layout_def['input_name0'];
if ( is_array($layout_def['input_name0']))
{
$input_name0 = $layout_def['input_name0'][0];
}
if ($input_name0 == 'Current User') {
global $current_user;
$input_name0 = $current_user->id;
}
return SugarWidgetFieldid::_get_column_select($layout_def)."="
.$this->reporter->db->quoted($input_name0)."\n";
}
function queryFilteris_not($layout_def)
{
require_once('include/generic/SugarWidgets/SugarWidgetFieldid.php');
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
$input_name0 = $layout_def['input_name0'];
if ( is_array($layout_def['input_name0']))
{
$input_name0 = $layout_def['input_name0'][0];
}
if ($input_name0 == 'Current User') {
global $current_user;
$input_name0 = $current_user->id;
}
return SugarWidgetFieldid::_get_column_select($layout_def)."<>"
.$this->reporter->db->quoted($input_name0)."\n";
}
// $rename_columns, if true then you're coming from reports
function queryFilterone_of($layout_def, $rename_columns = true)
{
require_once('include/generic/SugarWidgets/SugarWidgetFieldid.php');
if($rename_columns) { // this was a hack to get reports working, sugarwidgets should not be renaming $name!
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
}
$arr = array();
foreach($layout_def['input_name0'] as $value)
{
if ($value == 'Current User') {
global $current_user;
array_push($arr,$this->reporter->db->quoted($current_user->id));
}
else
array_push($arr,$this->reporter->db->quoted($value));
}
$str = implode(",",$arr);
return SugarWidgetFieldid::_get_column_select($layout_def)." IN (".$str.")\n";
}
// $rename_columns, if true then you're coming from reports
function queryFilternot_one_of($layout_def, $rename_columns = true)
{
require_once('include/generic/SugarWidgets/SugarWidgetFieldid.php');
if($rename_columns) { // this was a hack to get reports working, sugarwidgets should not be renaming $name!
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
}
$arr = array();
foreach($layout_def['input_name0'] as $value)
{
if ($value == 'Current User') {
global $current_user;
array_push($arr,$this->reporter->db->quoted($current_user->id));
}
else
array_push($arr,$this->reporter->db->quoted($value));
}
$str = implode(",",$arr);
return SugarWidgetFieldid::_get_column_select($layout_def)." NOT IN (".$str.")\n";
}
function &queryGroupBy($layout_def)
{
if($layout_def['name'] == 'full_name') {
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
require_once('include/generic/SugarWidgets/SugarWidgetFieldid.php');
$group_by = SugarWidgetFieldid::_get_column_select($layout_def)."\n";
} else {
// group by clause for user name passes through here.
$group_by = $this->_get_column_select($layout_def)."\n";
}
return $group_by;
}
}
?>