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;
}
