public static function getReportChart($reportid, $chartType)
{
global $log, $adb;
$oReportRun = new ReportRun($reportid);
$groupBy = $oReportRun->getGroupingList($reportid);
foreach ($groupBy as $key => $value) {
// $groupByConditon = explode(" ",$value);
//$groupByNew = explode("'",$groupByConditon[0]);
list($tablename, $colname, $module_field, $fieldname, $single) = explode(":", $key);
list($module, $field) = explode("_", $module_field);
$fieldDetails = $key;
break;
}
$queryReports = self::getCustomReportsQuery($reportid);
$queryResult = $adb->pquery($queryReports, array());
//ChartUtils::generateChartDataFromReports($queryResult, strtolower($groupByNew[1]));
if ($chartType == 'horizontalbarchart') {
$Chart = ChartUtils::getReportBarChart($queryResult, strtolower($module_field), $fieldDetails, $reportid);
} else {
if ($chartType == 'verticalbarchart') {
$Chart = ChartUtils::getReportBarChart($queryResult, strtolower($module_field), $fieldDetails, $reportid, 'vertical');
} else {
if ($chartType == 'piechart') {
$Chart = ChartUtils::getReportPieChart($queryResult, strtolower($module_field), $fieldDetails, $reportid);
}
}
}
return $Chart;
}
$groupBy = $oReportRun->getGroupingList($reportid);
if (!empty($groupBy)) {
foreach ($groupBy as $key => $value) {
//$groupByConditon = explode(" ",$value);
//$groupByNew = explode("'",$groupByConditon[0]);
list($tablename, $colname, $module_field, $fieldname, $single) = explode(":", $key);
list($module, $field) = explode("_", $module_field);
$fieldDetails = $key;
break;
}
//$groupByField = $oReportRun->GetFirstSortByField($reportid);
$queryReports = CustomReportUtils::getCustomReportsQuery($Report_ID, $filtersql);
$queryResult = $adb->pquery($queryReports, array());
//ChartUtils::generateChartDataFromReports($queryResult, strtolower($groupByNew[1]));
if ($adb->num_rows($queryResult)) {
$pieChart = ChartUtils::getReportPieChart($queryResult, strtolower($module_field), $fieldDetails, $reportid);
$barChart = ChartUtils::getReportBarChart($queryResult, strtolower($module_field), $fieldDetails, $reportid);
$list_report_form->assign("PIECHART", $pieChart);
$list_report_form->assign("BARCHART", $barChart);
} else {
$showCharts = false;
}
} else {
$showCharts = false;
}
$list_report_form->assign("SHOWCHARTS", $showCharts);
}
//Monolithic Changes Ends
// Performance Optimization: Direct output of the report result
if ($_REQUEST['submode'] == 'generateReport' && empty($advft_criteria)) {
$filtersql = '';
