public function listContact() { if (!Request::ajax()) { return App::abort(404); } $start = Input::has('start') ? (int) Input::get('start') : 0; $length = Input::has('length') ? Input::get('length') : 10; $search = Input::has('search') ? Input::get('search') : []; $contacts = Contact::select('id', 'contact_name', 'contact_phone', 'contact_email', 'contact_message', 'read', 'created_at')->orderBy('read')->orderBy('created_at'); if (!empty($search)) { foreach ($search as $key => $value) { if (empty($value)) { continue; } if ($key == 'read') { if ($value == 'yes') { $value = 1; } else { $value = 0; } $contacts->where($key, $value); } else { $value = ltrim(rtrim($value)); $contacts->where($key, 'like', '%' . $value . '%'); } } } $order = Input::has('order') ? Input::get('order') : []; if (!empty($order)) { $columns = Input::has('columns') ? Input::get('columns') : []; foreach ($order as $value) { $column = $value['column']; if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) { continue; } $contacts->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc'); } } $count = $contacts->count(); if ($length > 0) { $contacts = $contacts->skip($start)->take($length); } $arrcontacts = $contacts->get()->toArray(); $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Page::count(), 'recordsFiltered' => $count, 'data' => []]; if (!empty($arrcontacts)) { foreach ($arrcontacts as $contact) { $image = ''; if (!empty($contact['images'])) { $image = reset($contact['images']); $image = $image['path']; } $arrReturn['data'][] = array(++$start, $contact['id'], $contact['contact_name'], $contact['contact_phone'], $contact['contact_email'], htmlentities($contact['contact_message']), $contact['read'], $contact['created_at'], htmlentities(nl2br($contact['contact_message']))); } } $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; }
/** * Display a listing of the resource. * * @return Response */ public function index() { $counts = array(); $counts['article_total'] = \Article::count(); $counts['category_total'] = \Category::count(); $counts['user_total'] = \User::count(); $counts['page_total'] = \Page::count(); return View::make('admin.index.index')->with('counts', $counts); }
public function get_pages($action = null, $id = null) { if (!is_null($action)) { $fn = 'get_' . $action; return $this->{$fn}($id); } $pages = Page::latest()->paginate(10); $pages_count = Page::count(); $title = 'Administrayon Paj (' . $pages_count . ')'; return View::make('admin.pages.index')->withTitle($title)->withPages($pages)->withPagesCount($pages_count); }
public function run() { $model = new Page(); //条件 $criteria = new CDbCriteria(); $title = Yii::app()->request->getParam('title'); $titleAlias = Yii::app()->request->getParam('titleAlias'); $title && $criteria->addSearchCondition('title', $title); $titleAlias && $criteria->addSearchCondition('title_alias', $titleAlias); $criteria->order = 't.id DESC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); $this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages)); }
public function actionIndex() { $model = new Page(); $criteria = new CDbCriteria(); $condition = '1'; $title = $this->_request->getParam('title'); $titleAlias = $this->_request->getParam('titleAlias'); $title && ($condition .= ' AND title LIKE \'%' . $title . '%\''); $titleAlias && ($condition .= ' AND title_alias LIKE \'%' . $titleAlias . '%\''); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; $pageParams = $this->buildCondition($_GET, array('page_name_alias', 'page_name')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('index', array('datalist' => $result, 'pagebar' => $pages)); }
<?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');
<?php include '../../inc/init.inc'; isset($conditions) ? $args['conditions'] = $conditions : ''; $res->total = isset($args) ? Page::count($args) : Page::count(); $res->currentPage = isset($currentPage) ? $currentPage : 1; $res->limit = $args['limit'] = isset($limit) ? $limit : 7; $args['offset'] = ($res->currentPage - 1) * $args['limit']; $args['order'] = isset($order) ? $order : 'created_at desc'; $res->pages = Page::all($args); $res->search_opts = array(0 => array('label' => 'Quel article cherchez vous ?', 'field' => 'title', 'type' => 'text', 'class' => 'xxlarge')); $res->useTemplate("Wiki");
/** * Предзагрузка всех страниц и кеширование */ public static function preload() { $cache_key = self::$cache_key; $cache_pages_limit = Config::get('pages.preload_pages_limit'); if ($cache_pages_limit === NULL) { Config::set('pages.not_cached', TRUE); return; } if (Cache::has($cache_key) && !Input::get('drop_pages_cache')) { ## From cache $pages = Cache::get($cache_key); } elseif ($cache_pages_limit === 0 || $cache_pages_limit > 0 && Page::count() <= $cache_pages_limit) { #echo "LOAD PAGES FROM DB!"; ## From DB $pages = (new Page())->where('publication', 1)->where('version_of', NULL)->with(['metas', 'blocks.metas', 'seos', 'blocks.meta', 'meta', 'seo'])->get(); if (isset($pages) && is_object($pages) && count($pages)) { $pages_by_slug = new Collection(); $pages_by_sysname = new Collection(); $pages_by_id = new Collection(); foreach ($pages as $p => $page) { #Helper::ta($page); $page->extract(1); #Helper::tad($page); $pages_by_slug[$page->start_page ? '/' : $page->slug] = $page; $pages_by_sysname[$page->sysname] = $page; $pages_by_id[$page->id] = $page; } $pages = ['by_slug' => $pages_by_slug, 'by_sysname' => $pages_by_sysname, 'by_id' => $pages_by_id]; } } ## Save cache $cache_lifetime = Config::get('pages.preload_cache_lifetime') ?: NULL; if ($cache_lifetime) { $expiresAt = Carbon::now()->addMinutes($cache_lifetime); Cache::put($cache_key, $pages, $expiresAt); } Config::set($cache_key, $pages); #Helper::tad($pages); }
public function listPage() { if (!Request::ajax()) { return App::abort(404); } $start = Input::has('start') ? (int) Input::get('start') : 0; $length = Input::has('length') ? Input::get('length') : 10; $search = Input::has('search') ? Input::get('search') : []; $pages = Page::select('id', 'name', 'menu_id', 'active', 'type'); if (!empty($search)) { foreach ($search as $key => $value) { if (empty($value)) { continue; } if ($key == 'active' || $key == 'on_menu') { if ($value == 'yes') { $value = 1; } else { $value = 0; } if ($key == 'active') { $pages->where($key, $value); } else { $pages->where('menu_id', '>', 0); } } else { $value = ltrim(rtrim($value)); $pages->where($key, 'like', '%' . $value . '%'); } } } $order = Input::has('order') ? Input::get('order') : []; if (!empty($order)) { $columns = Input::has('columns') ? Input::get('columns') : []; foreach ($order as $value) { $column = $value['column']; if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) { continue; } $pages->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc'); } } $count = $pages->count(); if ($length > 0) { $pages = $pages->skip($start)->take($length); } $arrPages = $pages->get()->toArray(); $arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Page::count(), 'recordsFiltered' => $count, 'data' => []]; if (!empty($arrPages)) { foreach ($arrPages as $page) { $image = ''; if (!empty($page['images'])) { $image = reset($page['images']); $image = $image['path']; } $arrReturn['data'][] = array(++$start, $page['id'], $page['name'], ucfirst($page['type']), $page['menu_id'] ? 1 : 0, $page['active']); } } $response = Response::json($arrReturn); $response->header('Content-Type', 'application/json'); return $response; }
} if ($errors = $validator->errors()) { Input::flash(); // Notify::error($errors); return Response::json(array('id' => $id, 'errors' => array_flatten($errors, array()))); } if (empty($input['name'])) { $input['name'] = $input['title']; } $input['show_in_menu'] = is_null($input['show_in_menu']) || empty($input['show_in_menu']) ? 0 : 1; $input['html'] = parse($input['markdown']); $page = Page::create($input); $id = $page->id; Extend::process('page', $id); // Notify::success(__('pages.created')); return Response::json(array('id' => $id, 'notification' => __('pages.created'), 'redirect' => Uri::to('admin/pages/edit/' . $id))); }); /* Delete Page */ Route::get('admin/pages/delete/(:num)', function ($id) { if (Page::count() > 1) { Page::find($id)->delete(); Query::table(Base::table('page_meta'))->where('page', '=', $id)->delete(); Notify::success(__('pages.deleted')); } else { Notify::error('Unable to delete page, you must have at least 1 page.'); } return Response::redirect('admin/pages'); }); });
function tools_check_library() { $type = $this->input->post('type'); if ($type != 'page' && $type != 'chapter') { show_404(); } $page = $this->input->post('page'); if (!is_numeric($page)) { show_404(); } $repair = FALSE; if ($this->input->post('repair') == 'repair') { $repair = TRUE; } if ($type == 'page') { $count = 300; if ($repair) { $count = 50; } $items = new Page(); } if ($type == 'chapter') { $count = 15; if ($repair) { $count = 2; } $items = new Chapter(); } $offset = $page * $count - $count; $items->limit($count, $offset)->get_iterated(); if ($items->result_count() == 0) { if ($type == 'chapter') { $pages = new Page(); $pages_count = $pages->count(); $this->output->set_output(json_encode(array('status' => 'done', 'pages_count' => $pages_count))); } else { $this->output->set_output(json_encode(array('status' => 'done'))); } return TRUE; } foreach ($items as $item) { $item->check($repair); } $warnings = array(); foreach ($this->notices as $notice) { if ($notice['type'] == 'error') { if (!$this->input->is_cli_request()) { $this->output->set_output(json_encode(array('status' => 'error', 'message' => $notice['message']))); } return FALSE; } if ($notice['type'] == 'warning') { $warnings[] = $notice['message']; } } $this->output->set_output(json_encode(array('status' => count($warnings) > 0 ? 'warning' : 'success', 'messages' => $warnings, 'processed' => $items->result_count()))); }