The above example shows you how to create AreaChart using ChartJs 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.
This example shows you how to build an area chart using stacked property.
For example:
...
"options" => array(
...
"scales" => array(
...
"yAxes" => array(
array(
"stacked" => true,
"scaleLabel" => array(
"display" => true,
"labelString" => 'Value'
)
)
)
)
)
...
<?php
if (session_status() !== PHP_SESSION_ACTIVE) session_start();
require_once "../../../load.koolreport.php";
require_once "MyReport.php";
$report = new MyReport;
$report->run();
?>
<?php
if ( isset($_POST['command'])) {
?>
<div id='report_render'>
<?php
$report->render();
?>
</div>
<?php
exit;
}
?>
<?php
if (isset($_GET)) {
?>
<div id='report_render'>
<?php
$report->render();
?>
</div>
<?php
}
?>
<html>
<head>
<title>
Line Chart
</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
</head>
<body>
<button id="randomizeData" class="btn">Randomize Data</button>
<button id="addDataset" class="btn">Add Dataset</button>
<button id="removeDataset" class="btn">Remove Dataset</button>
<button id="addData" class="btn">Add Data</button>
<button id="removeData" class="btn">Remove Data</button>
<script>
$(document).ready(function() {
$('#randomizeData').click(function(e) {
e.preventDefault();
$.ajax({
type: "POST",
url:"run.php",
data: {
command: 'randomizeData',
},
success: function(response) {
$('#report_render').html(response);
}
})
})
$('#addDataset').click(function(e) {
e.preventDefault();
$.ajax({
type: "POST",
url:"run.php",
data: {
command: 'addDataset'
},
success: function(response) {
$('#report_render').html(response);
}
})
})
$('#removeDataset').click(function(e) {
e.preventDefault();
$.ajax({
type: "POST",
url:"run.php",
data: {
command: 'removeDataset'
},
success: function(response) {
$('#report_render').html(response);
}
})
})
$('#addData').click(function(e) {
e.preventDefault();
$.ajax({
type: "POST",
url:"run.php",
data: {
command: 'addData'
},
success: function(response) {
$('#report_render').html(response);
}
})
})
$('#removeData').click(function(e) {
e.preventDefault();
$.ajax({
type: "POST",
url:"run.php",
data: {
command: 'removeData'
},
success: function(response) {
$('#report_render').html(response);
}
})
})
})
</script>
<div>
<div id='report_render'>
</div>
</div>
</body>
</html><?php
class MyReport extends \koolreport\KoolReport
{
}<div id="report_render">
<?php
function randomScalingFactor()
{
return mt_rand(-100, 100);
}
$color = [
'rgb(255, 99, 132)',
'rgb(54, 162, 235)',
'rgb(75, 192, 192)',
'rgb(255, 205, 86)',
'rgb(255, 159, 64)',
'rgb(153, 102, 255)',
'rgb(201, 203, 207)'
];
$month = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'];
$data = [
['month' => 'January', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'February', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'March', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'April', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'May', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'June', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
['month' => 'July', 'series1' => randomScalingFactor(), 'series2' => randomScalingFactor(), 'series3' => randomScalingFactor(), 'series4' => randomScalingFactor()],
];
$series = array('month');
$seriesString = '';
if (!isset($_POST['command'])) {
$_SESSION["finalSerialNumber"] = 4;
$_SESSION["toSeriesDelete"] = 3;
$_SESSION["colorIndex"] = 0;
$_SESSION['data'] = $data;
for ($i = 1; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, "series" . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
if (isset($_POST['command']) && $_POST['command'] === 'randomizeData') {
$valueI = $_SESSION['finalSerialNumber'] - $_SESSION['toSeriesDelete'];
foreach ($_SESSION['data'] as &$entry) {
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
$entry['series' . $i] = randomScalingFactor();
}
}
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, 'series' . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
if (isset($_POST['command']) && $_POST['command'] === 'addDataset') {
$_SESSION['finalSerialNumber'] = $_SESSION['finalSerialNumber'] + 1;
$_SESSION["toSeriesDelete"] = $_SESSION["toSeriesDelete"] + 1;
$seriesString = 'series' . $_SESSION['finalSerialNumber'];
foreach ($_SESSION['data'] as &$entry) {
$entry[$seriesString] = randomScalingFactor();
}
$valueI = $_SESSION['finalSerialNumber'] - $_SESSION['toSeriesDelete'];
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, 'series' . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
if (isset($_POST['command']) && $_POST['command'] === 'removeDataset') {
if (count($_SESSION['data'][0]) > 1) {
$_SESSION['colorIndex'] = $_SESSION['colorIndex'] + 1;
foreach ($_SESSION['data'] as &$item) {
array_splice($item, 1, 1);
}
$_SESSION['toSeriesDelete'] = $_SESSION['toSeriesDelete'] - 1;
$valueI = $_SESSION['finalSerialNumber'] - $_SESSION['toSeriesDelete'];
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, 'series' . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
}
if (isset($_POST['command']) && $_POST['command'] === 'addData') {
$valueI = $_SESSION['finalSerialNumber'] - $_SESSION['toSeriesDelete'];
$lastEntry = array();
if (count($_SESSION['data']) > 0) {
$lastEntry = end($_SESSION['data']);
} else {
$lastEntry = $data[0];
}
$index = array_search($lastEntry['month'], $month);
$nextMonth = '';
if ($index !== false) {
$nextIndex = ($index + 1) % count($month);
$nextMonth = $month[$nextIndex];
$newData = ['month' => $nextMonth];
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
$newData['series' . $i] = randomScalingFactor();
}
array_push($_SESSION['data'], $newData);
} else {
array_push($_SESSION['data'], $_SESSION['temporaryData']);
}
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, 'series' . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
if (isset($_POST['command']) && $_POST['command'] == 'removeData') {
$valueI = $_SESSION['finalSerialNumber'] - $_SESSION['toSeriesDelete'];
array_pop($_SESSION['data']);
for ($i = $valueI; $i <= $_SESSION['finalSerialNumber']; $i++) {
array_push($series, 'series' . $i);
}
$colorIndex = $_SESSION['colorIndex'];
foreach ($series as $key => $seri) {
if ($key > 0) {
$series[$seri] = [
'backgroundColor' => $color[$colorIndex],
'borderColor' => $color[$colorIndex]
];
$colorIndex = ($colorIndex + 1) % count($color);
}
}
}
\koolreport\chartjs\AreaChart::create(array(
'dataSource' => $_SESSION['data'],
'columns' => $series,
"options" => array(
"responsive" => true,
"title" => array(
"display" => true,
"text" => 'Chart.js Line Chart - Stacked Area'
),
"tooltips" => array(
"mode" => 'index',
),
"hover" => array(
"mode" => 'index',
),
"scales" => array(
"xAxes" => array(
array(
"scaleLabel" => array(
"display" => true,
"labelString" => 'Month'
)
)
),
"yAxes" => array(
array(
"stacked" => true,
"scaleLabel" => array(
"display" => true,
"labelString" => 'Value'
)
)
)
),
)
));
?>
</div>What People Are Saying
"KoolReport helps me very much in creating data report for my corporate! Keep up your good work!"
--
Alain Melsens
"The first use of your product. I was impressed by its easiness and powerfulness. This product is a great and amazing."
--
Dr. Lew Choy Onn
"Fantastic framework for reporting!"
--
Greg Schneider