The above example shows you how to create LineChart using D3 package. In this example, for purpose of chart demonstration only, we do use mock-up data from array. As you can see, the KoolReport's widget in general support dataSource could be DataStore, Process, DataSource or even simple array.
The example show how to create line chart and convert it to bar chart.
For example:
...
"options" => array(
"data" => array(
"types" => array(
"data1" => 'bar'
)
)
)
<?php
if (session_status() !== PHP_SESSION_ACTIVE) session_start();
require_once "../../../../load.koolreport.php";
require_once "MyReport.php";
$report = new MyReport;
$report->run();
// $report->render();
?>
<?php
if (isset($_POST['command'])) {
?>
<div id="report_render">
<?php
$report->render();
?>
</div>
<?php
exit;
}
?>
<?php
if (!isset($_POST['command'])) {
?>
<div id="report_render">
<?php
$report->render();
?>
</div>
<?php
}
?>
<script>
setTimeout(function() {
$.ajax({
type: "POST",
url: 'run.php',
data: {
command: "second"
},
success: function(response) {
$('#report_render').html(response);
},
});
}, 1000)
setTimeout(function() {
$.ajax({
type: "POST",
url: 'run.php',
data: {
command: "third"
},
success: function(response) {
$('#report_render').html(response);
},
});
}, 2000)
setTimeout(function() {
$.ajax({
type: "POST",
url: 'run.php',
data: {
command: "fourth"
},
success: function(response) {
$('#report_render').html(response);
},
});
}, 3000)
setTimeout(function() {
$.ajax({
type: "POST",
url: 'run.php',
data: {
command: "fifth"
},
success: function(response) {
$('#report_render').html(response);
},
});
}, 4000)
</script>
<?php
class MyReport extends \koolreport\KoolReport
{
}
<h1 class='title'>To Bar Chart</h1>
<?php
$data = [
['data1' => 30, 'data2' => 130],
['data1' => 200, 'data2' => 100],
['data1' => 100, 'data2' => 140],
['data1' => 400, 'data2' => 200],
['data1' => 150, 'data2' => 150],
['data1' => 250, 'data2' => 50]
];
if (!isset($_POST['command'])) {
$_SESSION['types'] = array();
}
if (isset($_POST['command']) && $_POST['command'] === 'second') {
$_SESSION['types'] = array(
"data1" => 'bar'
);
}
if (isset($_POST['command']) && $_POST['command'] === 'third') {
$_SESSION['types'] = array(
"data1" => 'bar',
"data2" => 'bar'
);
}
if (isset($_POST['command']) && $_POST['command'] === 'fourth') {
$_SESSION['types'] = array();
}
if (isset($_POST['command']) && $_POST['command'] === 'fifth') {
$_SESSION['types'] = array(
"data1" => 'bar',
"data2" => 'bar'
);
}
\koolreport\d3\LineChart::create(array(
"dataSource" => $data,
"columns" => array(
'data1',
'data2',
),
"options" => array(
"data" => array(
"types" => $_SESSION['types']
)
)
));
