$this->setDashboardTitle('KPI');
$this->addComponent($kpi);
}
}
class SampleDashboard extends TabbedDashboard
{
public function buildDashboard()
{
$drill = new Drill();
$column = new Column();
$this->addDashboardTab($drill);
$this->addDashboardTab($column);
}
}
global $razorflow_assets;
$db = new SampleDashboard();
?>
<!doctype html>
<html>
<head>
<?php
// Replace this block with your own CSS/JS Includes
echo $razorflow_assets;
?>
</head>
<body>
<h1>Here's an embedded tabbed dashboard</h1>
<?php
$db->renderEmbedded();
?>
</body>
<?php
class SampleDashboard extends StandaloneDashboard
{
public function buildDashboard()
{
$table = new TableComponent('table1');
$table->setCaption("Table 1");
$table->setDimensions(6, 6);
$table->setRowsPerPage(8);
$table->addColumn('colA', "Column A");
$table->addColumn('colB', "Column B");
for ($i = 0; $i < 10; $i++) {
// Single Row
$table->addRow(array('colA' => $i * 2, 'colB' => $i * 2 + 1));
}
$table->cellConditionalFormat("colA", "value>300", array("cellBackgroundColor" => "#000", "cellTextColor" => "#fff"));
$this->addComponent($table);
}
}
$db = new SampleDashboard();
$db->renderStandalone();
if ($pos) {
$yearData = $this->pdo->query('Select c.Id as id, SUM(UnitsInStock)as Quantity, CategoryName from Product as p, Category as c where c.Id = p.CategoryId group by CategoryName order by Quantity DESC LIMIT 3;');
} else {
$yearData = $this->pdo->query('Select c.Id as id, SUM(UnitsInStock)as Quantity, CategoryName from Product as p, Category as c where c.Id = p.CategoryId group by CategoryName order by Quantity LIMIT 3;');
}
return $yearData->fetchAll(PDO::FETCH_ASSOC);
}
public function get_stock()
{
$yearData = $this->pdo->query('Select Product.Id, ProductName, CategoryName, UnitPrice, UnitsInStock from Product, Category where Product.Categoryid = Category.Id and Product.UnitsInStock > 0;');
return $yearData->fetchAll(PDO::FETCH_ASSOC);
}
public function get_category()
{
$yearData = $this->pdo->query('Select CategoryName from Category group by CategoryName;');
return $yearData->fetchAll(PDO::FETCH_ASSOC);
}
}
class SampleDashboard extends TabbedDashboard
{
public function buildDashboard()
{
$sales = new SalesDashboard();
$stock = new StockDashboard();
$this->addDashboardTab($sales);
$this->addDashboardTab($stock);
}
}
$tabbed = new SampleDashboard();
$tabbed->setStaticRoot("razorflow_php/static/rf/");
$tabbed->renderStandalone();
<?php
require 'sample_dashboards.php';
class SampleDashboard extends TabbedDashboard
{
public function buildDashboard()
{
$a = new A();
$b = new B();
$c = new C();
$b->setActive();
$this->addDashboardTab($a);
$this->addDashboardTab($b);
$this->addDashboardTab($c);
}
}
$tabbed = new SampleDashboard();
$tabbed->renderStandalone();
$kpi2->setCaption("Sales in last 24h");
$kpi2->setDimensions(3, 2);
$kpi2->setValue(rand(10, 50), array('numberPrefix' => '$'));
$this->addComponent($kpi2);
$kpi3 = new KPIComponent("kpi3");
$kpi3->setCaption("Number of checkouts this week");
$kpi3->setDimensions(3, 2);
$kpi3->setValue(rand(600, 1000));
$this->addComponent($kpi3);
$kpi4 = new KPIComponent("kpi4");
$kpi4->setCaption("Total sales this week");
$kpi4->setDimensions(3, 2);
$kpi4->setValue(rand(100, 300), array('numberPrefix' => '$'));
$this->addComponent($kpi4);
$chart3 = new ChartComponent("chart3");
$chart3->setCaption("Gender distribution of shoppers");
$chart3->setDimensions(6, 6);
$chart3->setLabels(['Female', 'Male']);
$chart3->addSeries('gender', 'Gender', array(rand(0, 100), rand(0, 100)), array('seriesDisplayType' => 'pie'));
$this->addComponent($chart3);
$chart4 = new ChartComponent("chart4");
$chart4->setCaption("Age group of shoppers");
$chart4->setDimensions(6, 6);
$chart4->setLabels(['Under 15', '15-30', '30-45', '45-60', '60+']);
$chart4->addSeries('age', 'Age', array(rand(1, 10), rand(20, 30), rand(30, 40), rand(20, 30), rand(1, 10)), array('seriesDisplayType' => 'column'));
$this->addComponent($chart4);
}
}
$db = new SampleDashboard();
$db->setDashboardRefreshDelay(5000);
$db->renderStandalone();
public function dashboardAction()
{
$db = new SampleDashboard();
return new CakeResponse(array('body' => $db->getJSONForAction()));
// return new CakeResponse (array('body' => $db->getJSONForAction ()));
}
public function dashboardAction()
{
$db = new SampleDashboard();
echo $db->getJSONForAction();
}
