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; }
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 = ''; }