Support for PHP Reports

[jdorn]

A PHP report will look like the following:

<?php
//NAME: This is my report
//DESCRIPTION: This is a description

$rows = array();

...

echo json_encode($rows);

Macro values will be available in the $_REQUEST object.

<?php
//My Report
//VARIABLE: startdate, Start Date

$start_date = $_REQUEST['startdate'];

Like MongoDB, these reports will output JSON.

The report will either be run from the shell or with an include. I haven't decided yet.

[jdorn]

Added. Macros are accessed as variables instead of through $_REQUEST.

<?php
//My Report
//VARIABLE: startdate, Start Date

echo $startdate;

Php reports should echo json_encoded rows.

<?php

$rows = array(
    array(
        'col1'=>'value 1',
        'col2'=>'value 2'
    ),
    array(
        'col1'=>'value 3',
        'col2'=>'value 4'
    )
);

echo json_encode($rows);