public function up()
{
$table = Base::table('pages');
$table2 = Base::table('posts');
if ($this->has_table_column($table, 'content')) {
$sql = 'ALTER TABLE `' . $table . '` ';
$sql .= 'CHANGE `content` `markdown` TEXT';
DB::ask($sql);
}
if (!$this->has_table_column($table, 'html') && $this->has_table_column($table, 'markdown')) {
$sql = 'ALTER TABLE `' . $table . '` ';
$sql .= 'ADD `html` TEXT NOT NULL AFTER `markdown`';
DB::ask($sql);
$pages = Page::sort('menu_order', 'desc')->get();
foreach ($pages as $page) {
Page::update($page->id, array('html' => parse($page->markdown)));
}
}
if (!$this->has_table_column($table2, 'markdown') && $this->has_table_column($table2, 'html')) {
$sql = 'ALTER TABLE `' . $table2 . '` ';
$sql .= 'ADD `markdown` TEXT NOT NULL AFTER `description`';
DB::ask($sql);
$migrate_data_sql = 'update `' . $table2 . '` set `markdown` = `html`, `html` = "";';
DB::ask($migrate_data_sql);
$posts = Post::sort('created', 'desc')->get();
foreach ($posts as $post) {
Post::update($post->id, array('html' => parse($post->markdown)));
}
}
}
<?php
Route::collection(array('before' => 'auth,csrf'), function () {
/*
List Pages
*/
Route::get(array('admin/pages', 'admin/pages/(:num)'), function ($page = 1) {
$perpage = Config::meta('posts_per_page');
$total = Page::count();
$pages = Page::sort('title')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/pages');
$pagination = new Paginator($pages, $total, $page, $perpage, $url);
$vars['messages'] = Notify::read();
$vars['pages'] = $pagination;
$vars['status'] = 'all';
return View::create('pages/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
});
/*
List pages by status and paginate through them
*/
Route::get(array('admin/pages/status/(:any)', 'admin/pages/status/(:any)/(:num)'), function ($status, $page = 1) {
$query = Page::where('status', '=', $status);
$perpage = Config::meta('posts_per_page');
$total = $query->count();
$pages = $query->sort('title')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/pages/status');
$pagination = new Paginator($pages, $total, $page, $perpage, $url);
$vars['messages'] = Notify::read();
$vars['pages'] = $pagination;
$vars['status'] = $status;
return View::create('pages/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
public function testSort()
{
$site = $this->siteInstance();
$page = new Page($site, '2-b');
$this->assertEquals('2', $page->num());
$this->assertEquals($page->num(), $page->sort());
$this->assertTrue(true, $page->sort(3));
$this->assertEquals('3', $page->num());
$this->assertEquals($page->num(), $page->sort());
$this->assertTrue(true, $page->sort(2));
$this->assertEquals('2', $page->num());
$this->assertEquals($page->num(), $page->sort());
}
<?php
Route::collection(array('before' => 'auth,csrf,install_exists'), function () {
/*
List Pages
*/
Route::get(array('admin/pages', 'admin/pages/(:num)'), function ($page = 1) {
$perpage = Config::get('admin.posts_per_page');
$total = Page::where(Base::table('pages.parent'), '=', '0')->count();
$pages = Page::sort('title')->where(Base::table('pages.parent'), '=', '0')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/pages');
$pagination = new Paginator($pages, $total, $page, $perpage, $url);
$vars['pages'] = $pagination;
$vars['status'] = 'all';
return View::create('pages/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
});
/*
List pages by status and paginate through them
*/
Route::get(array('admin/pages/status/(:any)', 'admin/pages/status/(:any)/(:num)'), function ($status, $page = 1) {
$query = Page::where('status', '=', $status);
$perpage = Config::get('admin.posts_per_page');
$total = $query->count();
$pages = $query->sort('title')->take($perpage)->skip(($page - 1) * $perpage)->get();
$url = Uri::to('admin/pages/status');
$pagination = new Paginator($pages, $total, $page, $perpage, $url);
$vars['pages'] = $pagination;
$vars['status'] = $status;
return View::create('pages/index', $vars)->partial('header', 'partials/header')->partial('footer', 'partials/footer');
});
/*
