/**
* Test asserts that for group functions order by is alias instead of table.field
*
* @dataProvider dataProvider
* @group 57902
* @return void
*/
public function testQueryOrderBy($layout_def, $expected)
{
$layoutManager = new LayoutManager();
$sugarWidgetReportField = new SugarWidgetReportField($layoutManager);
$actual = $sugarWidgetReportField->queryOrderBy($layout_def);
$this->assertEquals($expected, $actual, 'ORDER BY string is incorrect');
}
/**
* Test asserts that for group functions order by is alias instead of table.field
*
* @dataProvider dataProvider
* @group 57902
* @return void
*/
public function testQueryOrderBy($layout_def, $expected)
{
$layoutManager = new LayoutManager();
$db = new stdClass();
$db->db = $GLOBALS['db'];
$layoutManager->setAttributePtr('reporter', $db);
$sugarWidgetReportField = new SugarWidgetReportField($layoutManager);
$actual = $sugarWidgetReportField->queryOrderBy($layout_def);
$this->assertContains($expected, $actual, 'ORDER BY statement uses wrong field');
}
/**
* Compose GROUP BY expression for boolean field
*
* @param array $layout_def
* @return string
*/
public function queryGroupBy($layout_def)
{
$db = $this->reporter->db;
// explicitly cast NULL to empty value which depends on field type for proper grouping
$alias = parent::queryGroupBy($layout_def);
$alias = $db->convert($alias, 'IFNULL', array($db->emptyValue($layout_def['type'])));
return $alias;
}
function display($layout_def)
{
//Bug40995
if (isset($obj->layout_manager->defs['reporter']->focus->field_name_map[$layout_def['name']]['precision'])) {
$precision = $obj->layout_manager->defs['reporter']->focus->field_name_map[$layout_def['name']]['precision'];
$layout_def['precision'] = $precision;
}
//Bug40995
return parent::display($layout_def);
}
function &displayListyear(&$layout_def)
{
global $app_list_strings;
$value = parent::displayListPlain($layout_def);
return $value;
}
public function SugarWidgetFieldEnum(&$layout_manager)
{
parent::SugarWidgetReportField($layout_manager);
$this->reporter = $this->layout_manager->getAttribute('reporter');
}
/**
* Returns an OrderBy query for multi-select. We treat multi-select the same as a normal field because
* the values stored in the database are in the format ^A^,^B^,^C^ though not necessarily in that order.
* @param $layout_def
* @return string
*/
public function queryOrderBy($layout_def)
{
return SugarWidgetReportField::queryOrderBy($layout_def);
}
public function SugarWidgetFieldEnum($layout_manager)
{
parent::SugarWidgetReportField($layout_manager);
}
function &displayListyear(&$layout_def)
{
global $app_list_strings;
//if ($this->reporter->db->dbType == 'oci8' || $this->reporter->db->dbType == 'mssql') {
return parent::displayListPlain($layout_def);
//}
/*else{
$match = array();
if (preg_match('/(\d{4})/', $this->displayListPlain($layout_def), $match)) {
return $match[1];
}
$temp = null; // avoid notices
return $temp;
}*/
}
function SugarWidgetFieldVarchar(&$layout_manager)
{
parent::SugarWidgetReportField($layout_manager);
}
function __construct(&$layout_manager)
{
parent::__construct($layout_manager);
}
function querySelect(&$layout_def)
{
// i guess qualifier and column_function are the same..
if (!empty($layout_def['column_function'])) {
$func_name = 'querySelect' . $layout_def['column_function'];
if (method_exists($this, $func_name)) {
return $this->{$func_name}($layout_def) . " \n";
}
}
return parent::querySelect($layout_def) . " \n";
}
/**
* Returns the value to be displayed for the group by
*
* @param $layout_def - group by layout def
* @return string - string for display
*/
public function displayListfiscalYear($layout_def)
{
global $app_list_strings;
$value = parent::displayListPlain($layout_def);
return $value;
}
