static function list($number, $page) { Paginator::currentPageResolver(function () use($page) { return $page; }); return self::show("*")->paginate($number); }
public static function readLog($deviceId, $page) { Paginator::currentPageResolver(function () use($page) { return $page; }); return LocationLog::where('device_id', $deviceId)->orderBy('location_time', 'DESC')->simplePaginate(config('custom.item_per_page'))->all(); }
public function validateQuery(Request $request) { $modelClass = $this->model; $queryBuilder = new $modelClass(); if (count($parameters = $request->all()) > 0) { $handledRequestParameters = $this->handleRequestParameters($parameters); if (isset($handledRequestParameters['queries'])) { foreach ($handledRequestParameters['queries'] as $query) { $queryBuilder = $this->handleQuery($queryBuilder, $query); } } if (isset($handledRequestParameters['take'])) { $queryBuilder = $queryBuilder->take($handledRequestParameters['take']); } else { if (isset($handledRequestParameters['pagination'])) { $currentPage = $handledRequestParameters['pagination']['page']; Paginator::currentPageResolver(function () use($currentPage) { return $currentPage; }); return $queryBuilder = $queryBuilder->paginate($handledRequestParameters['pagination']['paginate'])->setPath($this->getUrlParameters($request)); } } } return $queryBuilder->get(); }
/** * Set the current page based on the page route parameter before the route's action is executed. * * @return \Illuminate\Http\Request */ public function handle($request, Closure $next) { Paginator::currentPageResolver(function () { return app('paginateroute')->currentPage(); }); return $next($request); }
/** * Set the current page based on the page route parameter before the route's action is executed. * * @return \Illuminate\Http\Request */ public function handle($request, Closure $next) { $page = Route::getCurrentRoute()->parameter('page', 1); Paginator::currentPageResolver(function () use($page) { return $page; }); return $next($request); }
/** * Register the service provider. * * @return void */ public function register() { Paginator::currentPathResolver(function () { return $this->app['request']->url(); }); Paginator::currentPageResolver(function () { return $this->app['request']->input('page'); }); }
public function __construct($transformer, $castTransformer, $merge, PaginationRequest $request, $defaultSort = false) { parent::__construct($transformer, $castTransformer, $merge); $this->request = $request; $this->defaultSort = $defaultSort; Paginator::currentPageResolver(function () { return $this->request->input(join('.', [$this->pageName, $this->pageNumber]), 1); }); }
/** * Register the service provider. * * @return void */ public function register() { Paginator::currentPathResolver(function () { return $this->app['slim']->request->getResourceUri(); }); Paginator::currentPageResolver(function ($pageName = 'page') { return $this->app['slim']->request->params($pageName); }); }
public function list(Request $request) { $number = $request->has('request') ? $request->number : 15; $page = $request->has('page') ? $request->page : 1; Paginator::currentPageResolver(function () use($page) { return $page; }); return self::show("*", new Authorization())->paginate($number); }
private function parseRequestPagination($query) { $page = (int) $this->getHttp()->getInput('page', 1); $offset = (int) $this->getHttp()->getInput('offset', 2); \Illuminate\Pagination\Paginator::currentPageResolver(function () use($page) { return $page; }); return $query->paginate($offset); }
/** * Setup the pagination service. * * @param \Slim\Slim $app The application instance. */ public static function setup(Slim $app) { $key = $app->config('pagination.key'); if (empty($key)) { $key = 'page'; } Paginator::currentPageResolver(function () use($app, $key) { return $app->request->get($key); }); }
public function getRepliesWithLimit($limit = 30) { Paginator::currentPageResolver(function ($pageName) use($limit) { $page = app('request')->input($pageName); if (filter_var($page, FILTER_VALIDATE_INT) !== false && (int) $page >= 1) { return $page; } return ceil($this->reply_count / $limit); }); return $this->replies()->orderBy('created_at', 'asc')->with('user')->paginate($limit); }
/** * 设置分页对象的当前页 */ protected function setCurrentPage() { $page = Input::get(self::getParameterKeyPage()); $pageSize = Input::get(self::getParameterKeyPageSize()); // validate parameters self::validatePaginationParameters($page, $pageSize); Paginator::currentPageResolver(function () use($page) { return $page; }); return $pageSize; }
public function index(Request $request) { if (!($limit = $request->get('limit'))) { $limit = 25; } if ($currentPage = $request->get('page')) { Paginator::currentPageResolver(function () use($currentPage) { return $currentPage; }); } $users = User::paginate($limit); return $this->response->paginator($users, new UserTransformer()); }
/** * server 运行状态 * @param Request $request * @return \Symfony\Component\HttpFoundation\Response * * @api {get} /status 查询运行状态 * @apiName PostRegister * @apiGroup Status */ public function index(Request $request) { $currentPage = 1; if ($request->has('page')) { $currentPage = $request->input('page'); Paginator::currentPageResolver(function () use($currentPage) { return $currentPage; }); } $per_page = $request->has('per_page') ? $request->input('per_page') : 20; $result = Notice::orderBy('id', 'DESC')->paginate($per_page)->toArray(); return view('status', ['notice' => $result['data'], 'current_page' => $currentPage, 'last_page' => $result['last_page']]); }
/** * Register the service provider. * * @return void */ public static function register() { Paginator::currentPathResolver(function () { return $GLOBALS['APPLICATION']->getCurPage(); }); Paginator::currentPageResolver(function ($pageName = 'page') { $page = $_GET[$pageName]; if (filter_var($page, FILTER_VALIDATE_INT) !== false && (int) $page >= 1) { return $page; } return 1; }); }
/** * Register the service provider. * * @return void */ public function register() { Paginator::currentPathResolver(function () { return $this->app['request']->url(); }); Paginator::currentPageResolver(function ($pageName = 'page') { $page = $this->app['request']->input($pageName); if (filter_var($page, FILTER_VALIDATE_INT) !== false && (int) $page >= 1) { return $page; } return 1; }); }
/** * Register the application services. * * @return void */ public function register() { Paginator::currentPageResolver(function ($pageName = 'page') { $keeper = $this->app->make('keeper', [$this->app['request']->path()]); if ($this->app['request']->has($pageName)) { $currentPage = $this->app['request']->input($pageName); //Persisto o pagina corrente $keeper->keep([$pageName => $currentPage]); return $currentPage; } //Utilizo o pagina persistida em algum momento anterior. $currentPage = $keeper->get($pageName); //Ou retorno 1 return $currentPage ?: 1; }); }
public function __construct($transformer, $object, PaginationRequest $request, $merge = false) { parent::__construct($transformer, $object, $merge); $this->responseBody = new Collection(['jsonapi' => '1.0']); $this->setTransformer($transformer); $this->request = $request; if ($object) { Paginator::currentPageResolver(function () { return $this->request->input(join('.', [$this->pageName, $this->pageNumberAttr]), 1); }); $this->model = $this->parseSort($object); $this->initIncludes(); if ($request->getPagination()) { $this->pagination = $this->model->paginate($request->input(join('.', [$this->pageName, $this->pageSizeAttr]), 10)); } $this->model = $request->getPagination() ? $this->pagination->getCollection() : $this->model->get(); } }
public function getAll($params = array()) { $paging = array_get($params, 'paging', []); $page_index = null; $page_size = null; if (count($paging) > 0) { $page_index = count($paging) == 2 ? $paging[0] : 1; $page_size = count($paging) == 2 ? $paging[1] : $paging[0]; } $query = $this->model->query(); $this->extendQuery($query, $params); if ($page_index != null || $page_size != null) { Paginator::currentPageResolver(function () use($page_index) { return $page_index; }); $items = $query->paginate($page_size); } else { $items = $query->get(); } return $items; }
/** * Register the service provider. * * @return void */ public function register() { $this->mergeConfigFrom(static::confPath(), 'press'); $this->app->bindShared('press', function ($app) { //@todo use back laravel config loader $conf = config('press'); $service = new PressService($app, $conf); $service->loadThemes(); return $service; }); $this->app->bindShared('press.index', function ($app) { return new PressIndex(); }); $this->app->bindShared('press.cache', function ($app) { return new PressCache($app->request); }); $this->app->bind('press.seo', config('press.seo_generator')); Paginator::currentPageResolver(function () { return $this->app['request']->route()->parameter('page') ?: $this->app['request']->input('page'); }); }
protected function initRoute($req, $res) { $this->request = $req; $this->response = $res; $s = $req->getAttribute('route')->getName(); $this->data['current_route_name'] = $s; $this->containerSlim->get('logger')->addInfo("Run admin page: ", [Session::get('user')['login']]); $this->containerSlim->get('logger')->addInfo("Get route: ", [$s]); $model = ModelsFactory::getModel('UserViewsSettings'); $result = $model->where('user_id', Session::get('user')['id'])->where('group', 'last.page.' . basename($req->getUri()->getPath()))->where('code', 'page')->first(); if ($result) { $current_page = $result->value; } Paginator::currentPageResolver(function () use($current_page) { return $current_page; }); $result = $model->where('user_id', Session::get('user')['id'])->where('group', 'items.perpage.' . basename($req->getUri()->getPath()))->where('code', 'count_page')->first(); if ($result) { $this->pagecount = $result->value; $this->data['page_count'] = $this->pagecount; } $result = $model->where('user_id', Session::get('user')['id'])->where('group', 'order.type.' . basename($req->getUri()->getPath()))->where('code', 'order_by')->first(); $this->pageOrderBy = "id"; if ($result) { $this->pageOrderBy = $result->value; } $this->data['page_order_by'] = $this->pageOrderBy; $result = $model->where('user_id', Session::get('user')['id'])->where('group', 'order.type.' . basename($req->getUri()->getPath()))->where('code', 'order_type')->first(); $this->pageOrderType = "asc"; if ($result) { $this->pageOrderType = $result->value; } $this->data['page_order_type'] = $this->pageOrderType; if (!$this->controllerName) { $this->controllerName = substr($s, strpos($s, '.') + 1); } $this->init(); $this->csrf($req); }
/** * Determine if the user is authorized to make this request. * * @return bool */ public function authorize() { $pageKey = Constants::getParameterKeyPage(); $pageSizeKey = Constants::getParameterKeyPageSize(); $page = $this->get($pageKey); $pageSize = $this->get($pageSizeKey); $page = intval($page); $pageSize = intval($pageSize); if ($page < 1) { $page = Constants::getDefaultPage(); $this->query->set($pageKey, $page); } if ($pageSize <= 0) { $pageSize = Constants::getDefaultLimit(); $this->query->set($pageSizeKey, $pageSize); } // force current page to $page Paginator::currentPageResolver(function () use($page) { return $page; }); return true; }
/** * 设置分页对象的当前页 */ public function setCurrentPage() { $start = Input::get('start'); $length = Input::get('length'); $page = $start / $length + 1; Paginator::currentPageResolver(function () use($page) { return $page; }); }
/** * Get elements * @param array $attributes * @param int $perPage * @param int $page * @return \StdClass * @internal param int $limit * @internal param array $filter */ public function get($attributes = [], $perPage = 20, $page = 0) { // Set pagination page manually if ($page) { Paginator::currentPageResolver(function () use($page) { return $page; }); } // Generate query $query = $this->queryByAttributes($attributes); // If limit exist - use it if ($limitAttribute = array_get($attributes, 'limit', 0)) { $perPage = intval($limitAttribute); } // Execute query return $query->paginate($perPage); }
// This route demonstrates an example of using the paginator with the illuminate\database component $app->get('/database', function () { // Set up the database connection--see the database component for more info $capsule = new Capsule(); $capsule->addConnection(['driver' => 'mysql', 'host' => 'localhost', 'database' => 'illuminate_non_laravel', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']); $capsule->setEventDispatcher(new Dispatcher(new Container())); $capsule->setAsGlobal(); $capsule->bootEloquent(); // End of database setup // Set up a current path resolver so the paginator can generate proper links Paginator::currentPathResolver(function () { return isset($_SERVER['REQUEST_URI']) ? strtok($_SERVER['REQUEST_URI'], '?') : '/'; }); // Set up a current page resolver Paginator::currentPageResolver(function ($pageName = 'page') { $page = isset($_REQUEST[$pageName]) ? $_REQUEST[$pageName] : 1; return $page; }); $perPage = 5; // results per page $columns = ['*']; // (optional, defaults to *) array of columns to retrieve from database $pageName = 'page'; // (optional, defaults to 'page') query string parameter name for the page number if (User::all()->count() <= $perPage) { exit("Need more than <strong>{$perPage}</strong> users in your <i>illuminate_non_laravel</i> database to see this work"); } // Set $page (optional, defaults to null) to the current page; // if this is not set, the currentPageResolver will be used $page = isset($_REQUEST[$pageName]) ? $_REQUEST[$pageName] : null; // Query and paginate the results $results = User::orderBy('id')->paginate($perPage, $columns, $pageName, $page);
/** * @param array $where * @param bool|false $paginate * @param int $nbItemsPerPage * @param int $page * * @return Collection | Paginator */ public function where(array $where, $paginate = false, $nbItemsPerPage = 15, $page = 1) { if ($nbItemsPerPage < 1 || $nbItemsPerPage > 100) { $nbItemsPerPage = 15; } if ($page < 1) { $page = 1; } $query = $this->applyCriterias($this->makeQuery()); if ($paginate) { Paginator::currentPageResolver(function () use($page) { return $page; }); return $query->where($where)->paginate($nbItemsPerPage); } return $query->where($where)->get(); }
protected function setupPaginationForReading() { Paginator::currentPageResolver(function () { return Input::get("{$this->input_key}.page", 1); }); }
protected function resetPagination(DataProvider $provider) { if (version_compare(Application::VERSION, '5.0.0', '<')) { $provider->getPaginationFactory()->setPageName('page_unused'); } else { Paginator::currentPageResolver(function () { return 1; }); } $provider->setPageSize($this->getRowsLimit()); $provider->setCurrentPage(1); }
public function getDetailsServiciosAtraccion($catalogo_servicios, $page_now, $page_stoped, $pagination) { $orderkey = "prioridad"; $ordervalue = "desc"; $catalogo = null; if ($catalogo_servicios != null) { $array = array(); foreach ($catalogo_servicios as $visitado) { $catalogo = $visitado->id_catalogo_servicio; $imagenes = DB::table('images')->join('usuario_servicios', 'usuario_servicios.id', '=', 'images.id_usuario_servicio')->where('id_auxiliar', '=', $visitado->id)->where('estado_fotografia', '=', '1')->select('images.id')->orderBy('id_auxiliar', 'desc')->first(); if ($imagenes != null) { foreach ($imagenes as $imagen) { $array[] = $imagen; } } } if ($page_now != null) { $currentPage = $page_now - $page_stoped; // You can set this to any page you want to paginate to // Make sure that you call the static method currentPageResolver() // before querying users Paginator::currentPageResolver(function () use($currentPage) { return $currentPage; }); } $imagenesF = DB::table('images')->join('usuario_servicios', 'usuario_servicios.id', '=', 'images.id_usuario_servicio')->leftJoin('satisfechos_usuario_servicio', 'usuario_servicios.id', '=', 'satisfechos_usuario_servicio.id_usuario_servicio')->whereIn('images.id', $array)->where('estado_fotografia', '=', '1')->where('usuario_servicios.id_catalogo_servicio', '=', $catalogo)->select(array('usuario_servicios.id as id_usr_serv', 'satisfechos_usuario_servicio.id_usuario_servicio', 'usuario_servicios.*', 'images.*', DB::raw('COUNT(satisfechos_usuario_servicio.id_usuario_servicio) as satisfechos')))->groupby('usuario_servicios.id')->orderBy($orderkey, $ordervalue)->paginate($pagination); } else { $imagenesF = DB::table('images')->join('usuario_servicios', 'usuario_servicios.id', '=', 'images.id_usuario_servicio')->leftJoin('satisfechos_usuario_servicio', 'usuario_servicios.id', '=', 'satisfechos_usuario_servicio.id_usuario_servicio')->where('estado_fotografia', '=', '1')->where('usuario_servicios.id_catalogo_servicio', '=', $catalogo)->select(array('usuario_servicios.id as id_usr_serv', 'satisfechos_usuario_servicio.id_usuario_servicio', 'usuario_servicios.*', 'images.*', DB::raw('COUNT(satisfechos_usuario_servicio.id_usuario_servicio) as satisfechos')))->groupby('usuario_servicios.id')->orderBy($orderkey, $ordervalue)->paginate($pagination); } return $imagenesF; }