Beispiel #1
0
<?php

$data[0] = array('company', 'region', 'district', 'store', 'sales');
$data[1] = array('Foo, Inc.', 'Region A', 'District X', 'Store #1', 1500.0);
$data[2] = array('Foo, Inc.', 'Region A', 'District X', 'Store #2', 1300.0);
$data[3] = array('Foo, Inc.', 'Region A', 'District Y', 'Store #3', 2000.0);
$data[4] = array('Foo, Inc.', 'Region A', 'District Y', 'Store #4', 1800.0);
$data[5] = array('Foo, Inc.', 'Region B', 'District M', 'Store #11', 2500.0);
$data[6] = array('Foo, Inc.', 'Region B', 'District M', 'Store #12', 2300.0);
$data[7] = array('Foo, Inc.', 'Region B', 'District N', 'Store #13', 3000.0);
$data[8] = array('Foo, Inc.', 'Region B', 'District N', 'Store #14', 2800.0);
$rlib = rlib_init();
rlib_version();
rlib_add_datasource_array($rlib, "local_array");
rlib_add_query_as($rlib, "local_array", "data", "data");
$output_format = 'xml';
if (isset($argv[1])) {
    $output_format = $argv[1];
}
rlib_add_report($rlib, "breaks.xml");
rlib_set_output_format_from_text($rlib, $output_format);
rlib_set_output_parameter($rlib, "debugging", "yes");
rlib_set_output_parameter($rlib, "only_quote_strings", "yes");
rlib_set_locale($rlib, "en_US");
rlib_execute($rlib);
// header(rlib_get_content_type($rlib));
rlib_spool($rlib);
rlib_free($rlib);
Beispiel #2
0
$data[6][1] = "13";
$data[6][2] = "18";
$data[6][3] = "Task B";
$data[6][4] = "B'";
$data[6][5] = "red";
$data[6][6] = "white";
$data[7][0] = "3";
$data[7][1] = "13";
$data[7][2] = "22";
$data[7][3] = "Task C";
$data[7][4] = "C'";
$data[7][5] = "red";
$data[7][6] = "white";
$data[8][0] = "4";
$data[8][1] = "13";
$data[8][2] = "23";
$data[8][3] = "Task D";
$data[8][4] = "D'";
$data[8][5] = "red";
$data[8][6] = "white";
$rlib = rlib_init();
rlib_add_datasource_array($rlib, "local_array");
rlib_add_query_as($rlib, "local_array", "header_data", "header_data");
rlib_add_query_as($rlib, "local_array", "data", "data");
rlib_set_output_parameter($rlib, "html_image_directory", "/tmp");
rlib_set_output_parameter($rlib, "trim_links", "1");
rlib_add_report($rlib, "gantt.xml");
rlib_set_output_format_from_text($rlib, "html");
rlib_execute($rlib);
rlib_spool($rlib);
rlib_free($rlib);
Beispiel #3
0
$moredata[39][0] = "39";
$moredata[40][0] = "40";
$moredata[41][0] = "41";
$moredata[42][0] = "42";
$moredata[43][0] = "43";
$moredata[44][0] = "44";
$moredata[45][0] = "45";
$moredata[46][0] = "46";
$moredata[47][0] = "47";
$moredata[48][0] = "48";
$moredata[49][0] = "49";
$moredata[50][0] = "50";
$moredata[51][0] = "51";
$moredata[52][0] = "52";
$moredata[53][0] = "53";
$moredata[54][0] = "54";
$moredata[55][0] = "55";
$moredata[56][0] = "56";
$moredata[57][0] = "57";
$moredata[58][0] = "58";
$moredata[59][0] = "59";
$rlib = rlib_init();
rlib_add_datasource_array($rlib, "local_array");
rlib_add_query_as($rlib, "local_array", "data", "data");
rlib_add_query_as($rlib, "local_array", "moredata", "moredata");
rlib_add_report($rlib, "flow_part.xml");
rlib_set_output_format_from_text($rlib, "pdf");
rlib_execute($rlib);
header(rlib_get_content_type($rlib));
rlib_spool($rlib);
rlib_free($rlib);
Beispiel #4
0
 protected function GenerateReport_Rlib($param, $format, $query, $params = NULL)
 {
     freemed::acl_enforce('reporting', 'write');
     switch ($format) {
         case 'html':
             $outformat = 'html';
             $ext = 'html';
             break;
         case 'csv':
             $outformat = 'csv';
             $ext = 'csv';
             break;
         case 'text':
             $outformat = 'text';
             $ext = 'txt';
             break;
         case 'pdf':
             $outformat = 'pdf';
             $ext = 'pdf';
             break;
         default:
             $outformat = 'pdf';
             $ext = 'pdf';
             break;
     }
     // end switch format
     @dl("rlib.so");
     if (!function_exists('rlib_init')) {
         syslog(LOG_ERR, get_class($this) . "| rlib PHP extension not found");
     }
     // Global scope things to be passed into m.* namespace
     $GLOBALS['installation'] = INSTALLATION;
     $GLOBALS['generated_on'] = date('r');
     $rlib = rlib_init();
     rlib_add_datasource_mysql($rlib, "local_mysql", DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
     rlib_add_query_as($rlib, "local_mysql", $query, "result");
     rlib_add_report_from_buffer($rlib, $param['report_formatting']);
     rlib_set_output_format_from_text($rlib, $outformat);
     rlib_execute($rlib);
     switch ($outformat) {
         case 'pdf':
             Header('Content-type: application/pdf');
             break;
         default:
             Header(rlib_get_content_type($rlib));
             break;
     }
     Header("Content-Disposition: inline; filename=\"" . mktime() . ".{$ext}\"");
     rlib_spool($rlib);
     rlib_free($rlib);
     die;
 }
Beispiel #5
0
<?php

dl("rlib.so");
$hostname = "localhost";
$username = "******";
$password = "******";
$database = "rlib";
$rlib = rlib_init();
rlib_add_datasource_odbc($rlib, "local_mysql", "test", "user", "password");
rlib_add_query_as($rlib, "local_mysql", "select * FROM plu", "products");
rlib_add_report($rlib, "products.xml");
rlib_set_output_format_from_text($rlib, "txt");
rlib_execute($rlib);
header(rlib_get_content_type($rlib));
rlib_spool($rlib);
rlib_free($rlib);
Beispiel #6
0
<?php

$rlib = rlib_init();
rlib_add_datasource_csv($rlib, "local_csv");
rlib_add_query_as($rlib, "local_csv", "data.csv", "data");
rlib_add_report($rlib, "csv.xml");
rlib_set_output_format_from_text($rlib, "json");
rlib_set_output_parameter($rlib, "debugging", "yes");
rlib_execute($rlib);
header(rlib_get_content_type($rlib));
rlib_spool($rlib);
rlib_free($rlib);