logo
down
shadow

Laravel, how to sort and paginate of loop array


Laravel, how to sort and paginate of loop array

Content Index :

Laravel, how to sort and paginate of loop array
Tag : php , By : John Q.
Date : November 26 2020, 12:01 PM

Does that help I have this code in controller, so I need to paginate and sort by using distance, I dont know how to do this, Im new to laravel , thanks in advance , First, I would create a collection instance of your $stores array:
$stores = collect([]);
$stores->push($store);
use Illuminate\Support\Collection;
use Illuminate\Pagination\Paginator; 
use Illuminate\Pagination\LengthAwarePaginator;

...

if (!Collection::hasMacro('paginate')) {
    Collection::macro('paginate', function ($perPage = 25, $page = null, $options = []) {
        $options['path'] = $options['path'] ?? request()->path();
        $page = $page ?: (Paginator::resolveCurrentPage() ?: 1);
        return new LengthAwarePaginator(
            $this->forPage($page, $perPage)->values(),
            $this->count(),
            $perPage,
            $page,
            $options
        );
    });
}
$stores->paginate(15);
$stores->paginate(15, 1, ['path' => 'your/custom/path']);
$sorted = $collection->sortBy('price');
$sorted = $collection->sortBy(function ($product, $key) {
    return count($product['colors']);
});

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Laravel 4.x Paginate Array


Tag : arrays , By : S. Fenz
Date : March 29 2020, 07:55 AM
will be helpful for those in need I ended up using the following code. You have to pass the items per page manually. $matches is the array of data being passed to the paginator.
$perPage = 2;
$currentPage = Input::get('page') - 1;
$pagedData = array_slice($matches, $currentPage * $perPage, $perPage);
$matches = Paginator::make($pagedData, count($matches), $perPage);

Laravel loop through query result, then paginate


Tag : php , By : user178709
Date : March 29 2020, 07:55 AM
seems to work fine You can manually create a paginator
You could use Illuminate\Pagination\LengthAwarePaginator like this:
use \Illuminate\Pagination\LengthAwarePaginator;

...

$page = $request->get('page', 1);
$limit = 10;
$paginator = new LengthAwarePaginator(
    $availableEvents->forPage($page, $limit), $availableEvents->count(), $limit, $page, ['path' => $request->path()]
);

How to paginate and sort results in Laravel?


Tag : laravel , By : user118656
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results. , I've solved the problem with this solution:
$sorted = Model::get()
    ->sortBy('example_function')  //appended attribute
    ->pluck('id')
    ->toArray();

$orderedIds = implode(',', $sorted);

$result = DB::table('model')
    ->orderByRaw(\DB::raw("FIELD(id, ".$orderedIds." )"))
    ->paginate(10);

Merge two sets of data and then sort and paginate in laravel


Tag : laravel , By : Robby
Date : March 29 2020, 07:55 AM
With these it helps I am running two sets of queries. But the problem is I can't sort and paginate on them. My code is given below. , yes you can also update into single query.
$orderhenkans = Orderhenkan::where('kokyakubango',Auth::guard('web')->user()->bango)
                               ->where('kokyakuorderbango',4)
                               ->get()->pluck('bango'); 

$orderhenkans_2 = Orderhenkan::where('kokyakubango',Auth::guard('web')->user()->bango)
                              ->get()->pluck('bango');

$misyukkos = Misyukko::where(function($query) use ($orderhenkans, $orderhenkans_2){
    return $query->where(function($query_2) use ($orderhenkans){
        return $query_2->whereIn('orderbango',$orderhenkans)
                       ->whereNotNull('yoyakubi');
    })
    ->orWhere(function($query_2) use ($orderhenkans_2){
        return $query_2->whereIn('orderbango',$orderhenkans_2)
                        ->whereNotNull('yoyakubi')
                        ->whereDate('hanbaibukacd','<',date('Y-m-d'));
    });
})->orderBy('orderbango', 'desc')->paginate(15);
$orderhenkans = Orderhenkan::where('kokyakubango',Auth::guard('web')->user()->bango)
                                   ->where('kokyakuorderbango',4)
                                   ->get()->pluck('bango'); 

    $orderhenkans_2 = Orderhenkan::where('kokyakubango',Auth::guard('web')->user()->bango)
                                  ->get()->pluck('bango');

    $misyukkos = Misyukko::where(function($query) use ($orderhenkans, $orderhenkans_2){
        return $query->where(function($query_2) use ($orderhenkans){
            return $query_2->whereIn('orderbango',$orderhenkans);
        })
        ->orWhere(function($query_2) use ($orderhenkans_2){
            return $query_2->whereIn('orderbango',$orderhenkans_2)                            
                            ->whereDate('hanbaibukacd','<',date('Y-m-d'));
        });
    })->whereNotNull('yoyakubi')->orderBy('orderbango', 'desc')->paginate(15);

how to paginate after a sort by in laravel


Tag : php , By : Matt
Date : March 29 2020, 07:55 AM
wish help you to fix your issue sort by has already take datas from db, so use pagination is not really helpful.
So I recommend to change your code like this, this will reduce IO cost:
Food::select('*', 
             DB::raw('(price - round((price * discount) / 100)) AS cost')
            )->orderBy('cost')
             ->paginate(12)
Related Posts Related QUESTIONS :
  • Getting error "Unknown column 'text' in 'field list'"
  • How to properly get onedrive access token via php and curl
  • How to add spell check to a php function
  • Is it posible to create css rules with php?
  • Pretty URL with $_GET method
  • Wordpress always load same page - index.php
  • Find value in array and return with new from different array
  • PHP multiple file upload with different keys
  • Can't modify times one a time without weird errors
  • Get size of scraped image with domcrawler (Goutte)
  • Laravel - Ordering a collection of models
  • PHP Fatal error: Uncaught Error: Call to a member function setFetchMode() on boolean
  • Strict Standards: Only variables should be passed by reference in /main_dir/sub_dir/backup.php
  • Uncaught Google_Exception: (update) unknown parameter: 'copyRequiresWriterPermission'
  • Laravel 5 form does not redirect with old input
  • How to get values greater than or equal to in Mysql database sql when its a value like 1:00 PM?
  • PHP datediff overday issue
  • Masking an auto incrementing primary key
  • How to grab a String BEFORE a certain word
  • ZF2 Routing Multiple Controllers based on route constraints
  • How to deregister/dequeue jquery.sticky.js in Elementor (Pro)?
  • How to fix errors counting words in text plain with PHP?
  • How to get View data in Laravel in custom helper or directive
  • Creating a new data entry into a database with eloquent and trying to access the variable in the url
  • How to test authentication using Laravel Dusk?
  • PHP parse_str not getting all $_GET variables
  • Variable issues in php class
  • Get orders between dates in Codeigniter
  • Eloquent Special Chars Issue
  • Keeping leading zeros column Mysql
  • Current level navigation in Wordpress
  • Add a custom text to WooCommerce cart items if the product has a specific shipping class
  • Error connecting to CommissionJunction Token : [60] SSL certificate problem: unable to get local issuer certificate
  • How do I add a new key value pair to an object in PHP?
  • Http post request to php with dart
  • How to add a route in with blade into parameters of a component
  • How can i get the source of a 777 - CHMOD php file?
  • Convert 2010-04-16 16:30:00 to "Tomorrow Afternoon"
  • How can I hide a $_GET variable to be more secured in PHP?
  • Login to Gmail Inbox using Curl?
  • Upload Excel or CSV file to MySQL with PHP
  • Outlook Marking Email as Junk Email
  • Upload an image using class.upload.php via AJAX, display image in form using jQuery
  • mysql_connect() causes page to not display (WAMP)
  • How to limit a users uploaded image size using PHP
  • What's the difference whether or not to run PHP in safe mode?
  • Logging in to a website cURL
  • Using php to create a password system with chinese characters
  • PHP is not called properly in IE using set interval function in Javascript
  • How to read pdf, ppt, xl, doc files content into a string in php/python
  • php script for currency conversion
  • In PHP... best way to turn string representation of a folder structure into nested array
  • PayPal for Indian Rupees (INR) any solution
  • PHP Deployment to Live Server
  • Ideal Multi-Developer Lamp Stack?
  • How can I save an image from a file input field using PHP & MySQL?
  • Warning: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in
  • Connecting to external MySQL DB from a web server not running MySQL
  • Is it possible to add custom fields to a Drupal taxonomy term?
  • PHP 6.0 - Roadmap?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com