function show()
{
// dd(Page::all()->toArray());
$page = Page::orWhere(function ($query) {
$query->where('url', '=', Request::path());
})->orWhere(function ($query) {
$query->where('url', '=', '/' . Request::path());
})->orWhere(function ($query) {
$query->where('url', '=', Request::url());
})->orWhere(function ($query) {
$query->where('url', '=', Request::route()->getPath());
})->orWhere(function ($query) {
$query->where('url', '=', '/' . Request::route()->getPath());
})->get()->first();
$ps = Post::where('page_id', '=', $page->id)->orderBy('sort', 'ASC')->orderBy('id', 'ASC')->get();
$posts = [];
foreach ($page->template()->first()->sections() as $sec) {
$posts[$sec->name] = [];
}
foreach ($ps as $p) {
$posts[$p->section()->first()->name][] = $p;
}
$pages = [];
foreach (Page::all() as $pi) {
$pages[$pi->name] = $pi;
}
$fn = str_replace('.blade.php', '', $page->template()->first()->filename);
return View::make("aui/templates/" . $fn)->with('posts', $posts)->with('pages', $pages)->with('page', $page);
}
