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'); }); /*