/** * 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; }