public function queryFilteris_not($layout_def)
{
$input_name0 = $this->getInputValue($layout_def);
if ($input_name0 == 'current') {
$name = array_keys(TimePeriod::getCurrentName());
$name = !empty($name) ? $name[0] : '';
return SugarWidgetFieldid::_get_column_select($layout_def) . " NOT IN ('" . $name . "')\n";
}
return parent::queryFilteris_not($layout_def);
}
function &queryGroupBy($layout_def)
{
if ($layout_def['name'] == 'full_name') {
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
$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;
}
function &queryGroupBy($layout_def)
{
if ($this->reporter->db->dbType == 'mysql') {
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.
// $layout_def['name'] = 'name';
// $layout_def['type'] = 'name';
$group_by = $this->_get_column_select($layout_def) . "\n";
}
} elseif ($this->reporter->db->dbType == 'mssql') {
$group_by = $this->_get_column_select($layout_def);
}
return $group_by;
}
function &queryGroupBy($layout_def)
{
if ($this->reporter->db->dbType == 'mysql') {
require_once 'include/generic/SugarWidgets/SugarWidgetFieldid.php';
$layout_def['name'] = 'id';
$layout_def['type'] = 'id';
$group_by = SugarWidgetFieldid::_get_column_select($layout_def) . "\n";
return $group_by;
} else {
$group_by = SugarWidgetFieldvarchar::_get_column_select($layout_def) . "\n";
return $group_by;
}
}
