switch ($report->reporttype) { case 'frm': $output = BuildForm($report, $delivery_method); if ($output === true) { $error = true; } break; case 'rpt': $ReportData = ''; $success = BuildSQL($report); if ($success['level'] == 'success') { // Generate the output data array $sql = $success['data']; $report->page->filter->text = $success['description']; // fetch the filter message if (!($ReportData = BuildDataArray($sql, $report))) { $messageStack->add(PHREEFORM_NODATA . ' The sql was: ' . $sql, 'caution'); $error = true; break; } // Check for the report returning with data if (!$ReportData) { $messageStack->add(PHREEFORM_NODATA . ' The failing sql= ' . $sql, 'caution'); $error = true; } else { if ($_REQUEST['action'] == 'exp_csv') { $output = GenerateCSVFile($ReportData, $report, $delivery_method); } if ($_REQUEST['action'] == 'exp_xml') { $output = GenerateXMLFile($ReportData, $report, $delivery_method); }
break; case RPT_BTN_EXPCSV: case RPT_BTN_EXPPDF: $Prefs = ReadPostData($ReportID, $Prefs); // include the necessary files to build report require $PathPrefix . 'includes/tcpdf/tcpdf.php'; // TCPDF class to generate reports require 'WriteReport.inc'; $ReportData = ''; $success = BuildSQL($Prefs); if ($success['level'] == 'success') { // Generate the output data array $sql = $success['data']; $Prefs['filterdesc'] = $success['filterdesc']; // fetch the filter message $ReportData = BuildDataArray($ReportID, $sql, $Prefs); // Check for the report returning with data if (!$ReportData) { $usrMsg[] = array('message' => RPT_NODATA . ' The failing sql=' . $sql, 'level' => 'warn'); } } else { // Houston, we have a problem, sql build failed $usrMsg[] = array('message' => $success['message'], 'level' => $success['level']); } if ($usrMsg) { // then we have a message to display and no report to show if ($_POST['FilterForm']) { // return to the filter form $Title = RPT_CRITERIA; $IncludePage = 'forms/ReportsFilter.html'; } else {
$GraphUpdate; $interval = 500; $npoints = 25; $maxIterations = 200; $niters = 0; $GraphData = array(); $x = 0; $y = rand(10, 100) * 10; for ($i = 0; $i < $npoints; $i++) { $x += rand(10, 100) * 5; $y += (rand(10, 100) - 0.5) * 10; $GraphData[$i] = array($x, $y); } return $GraphData; } $GraphData = BuildDataArray(); $pc = new C_PhpChartX(array($GraphData), 'Graph'); $pc->add_plugins(array('canvasTextRenderer', 'canvasAxisTickRenderer', 'canvasAxisLabelRenderer', 'highlighter', 'canvasOverlay', 'cursor', 'pointLabels'), true); $pc->set_title(array('text' => 'Test Data Run')); $pc->set_cursor(array('show' => false)); $pc->set_point_labels(array('show' => false)); $pc->set_highlighter(array('show' => false)); $pc->set_axes_default(array('pad' => 0.05, 'labelRenderer' => 'plugin::CanvasAxisLabelRenderer', 'tickRenderer' => 'plugin::CanvasAxisTickRenderer', 'labelOptions' => array('fontSize' => '13pt'))); $pc->set_axes(array('xaxis' => array('label' => 'Number'), 'yaxis' => array('label' => 'Value'))); // should be the last method to call $pc->draw(800, 500); ?> <script type="text/javascript" lang="javascript"> var Graph; var GraphUpdate;