public function modifyWebDispatcher($di)
{
$dispatcher = $di->get('aura/web-kernel:dispatcher');
$dispatcher->setObject('hello', function () use($di) {
$response = $di->get('aura/web-kernel:response');
$response->content->set('Hello World!');
});
$dispatcher->setObject('about', function () use($di) {
$view_factory = new \Aura\View\ViewFactory();
$view = $view_factory->newInstance();
$layout_registry = $view->getLayoutRegistry();
$layout_registry->set('default', './../src/templates/default.layout.php');
$view_registry = $view->getViewRegistry();
$view_registry->set('about', './../src/templates/about.php');
$view->setView('about');
$view->setLayout('default');
$response = $di->get('aura/web-kernel:response');
$response->content->set($view());
});
$dispatcher->setObject('data-view-sales', function () use($di) {
$view_factory = new \Aura\View\ViewFactory();
$view = $view_factory->newInstance();
$pdo = new ExtendedPdo('sqlite:./../db/database.sqlite');
$extended_pdo = new ExtendedPdo($pdo);
$stm = '
SELECT t.TrackId, sum(il.unitprice) as "TotalSales", t.Name as "TrackName", g.Name as Genre, a.Title as "AlbumTitle", at.Name as "ArtistName"
from InvoiceLine il
inner join track t on (t.TrackId = il.TrackId)
INNER JOIN genre g on (g.GenreId = t.GenreId)
inner join album a on (a.AlbumId = t.AlbumId)
INNER JOIN artist at on (at.ArtistId = a.ArtistId)
WHERE g.Name like :genre
group by t.TrackId
HAVING at.Name = :artist_name
order by sum(il.UnitPrice) desc, t.Name asc
';
$bind = array('genre' => 'TV%', 'artist_name' => 'Lost');
$sth = $pdo->prepare($stm);
$sth->execute($bind);
$layout_registry = $view->getLayoutRegistry();
$layout_registry->set('default', './../src/templates/sales.layout.php');
$view_registry = $view->getViewRegistry();
$view_registry->set('sales-data', './../src/templates/data/sales/view.php');
$view->setView('sales-data');
$view->setLayout('default');
// the "sub" template
$view_registry->set('_result', './../src/templates/data/sales/result.php');
$view->setData(['results' => $pdo->fetchObjects($stm, $bind, '\\DatabaseObjects\\Entity\\SalesData')]);
$response = $di->get('aura/web-kernel:response');
$response->content->set($view());
});
}
