* @author Anton Shevchuk
* @created 14.11.13 10:45
*/
namespace Application;
use Bluz\Db\Relations;
use Bluz\Proxy\Db;
use Bluz\Proxy\Layout;
return function () use($view) {
/**
* @var Bootstrap $this
* @var \Bluz\View\View $view
*/
Layout::breadCrumbs([$view->ahref('Test', ['test', 'index']), 'DB Relations']);
/* @var Pages\Row */
$page = Pages\Table::findRow(5);
$user = $page->getRelation('Users');
echo "<h2>Page Owner</h2>";
var_dump($user);
$pages = $user->getRelations('Pages');
echo "<h2>User pages</h2>";
var_dump(sizeof($pages));
$roles = $user->getRelations('Roles');
echo "<h2>User roles</h2>";
var_dump($roles);
echo "<h2>User with all relations</h2>";
var_dump($user);
$result = Db::fetchRelations("SELECT '__users', u.*, '__pages', p.* FROM users u LEFT JOIN pages p ON p.userId = u.id");
echo "<h2>User - Page relation</h2>";
var_dump($result);
return false;
* @author Anton Shevchuk
* @created 06.08.12 10:08
*/
namespace Application;
use Bluz\Application\Exception\NotFoundException;
use Bluz\Proxy\HttpCacheControl;
use Bluz\Proxy\Layout;
use Bluz\View\View;
return function ($alias) use($view) {
/**
* @var Bootstrap $this
* @var View $view
* @var Pages\Row $page
*/
$page = Pages\Table::getInstance()->getByAlias($alias);
if (!$page) {
// throw NOT FOUND exception
// all logic of error scenario you can found in default error controller
// see /application/modules/error/controllers/index.php
throw new NotFoundException();
} else {
// setup HTML layout data
Layout::title(esc($page->title), View::POS_PREPEND);
Layout::meta('keywords', esc($page->keywords));
Layout::meta('description', esc($page->description));
// setup HTTP cache
HttpCacheControl::setPublic();
HttpCacheControl::setLastModified($page->updated);
// assign page to view
$view->page = $page;
