protected function renderView($view)
{
$view_factory = new \Aura\View\ViewFactory();
$this->view = $view_factory->newInstance();
$this->view->setView($view);
$this->response->withBody($this->view->__invoke());
}
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());
});
}
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/
require __DIR__ . '/vendor/autoload.php';
/**
* Set up the various view objects needed
* and add the templates/layouts
*/
$factory = new \Aura\Html\HelperLocatorFactory();
$helpers = $factory->newInstance();
$view_factory = new \Aura\View\ViewFactory();
$view = $view_factory->newInstance($helpers);
$view_registry = $view->getViewRegistry();
$view_registry->set('access_log', __DIR__ . '/templates/views/access_log.php');
$layout_registry = $view->getLayoutRegistry();
$layout_registry->set('default', __DIR__ . '/templates/layouts/default.php');
/*
* Connect to Database
*/
$dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8";
try {
$pdo = new PDO($dsn, DB_USER, DB_PASS);
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die;
}
