<?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();
$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();
