How can I natsort my data?

Given that you're sorting episodes, couldn't you just sort on release date instead of a serial number?

I don't think it will be easy to implement a natsort method for Eloquent as it will be dependent on the database that's used.

I don't see that option actually.

I store these serial numbers as varchar in DB: 1.01, 2.20 etc.

Maybe something like this :

public function episodes()
{
    return $this->hasMany('Episode')->orderBy(DB::raw('LENGTH(serial_no), serial_no'));
}

Never tried that ^^

Thanks bestmomo Solved it with that code...

The best solution is probably to use the sort(callable $callback) method inside the Collection class. Just call the method ->sort('natsort') once you got the Eloquent Collection (normally after the ->get() call).

Sorry for digging but this is the best solution: http://laravel.at.jeffsbox.eu/laravel-5-eloquent-collection-methods-sortby

 sortBy('key', SORT_NATURAL, true)

Others maybe waste time too

It is working for me: Create a helper class SortHelper and use it whereever you want.

Note: $myItemsArray should be type of -> Illuminate\Support\Collection

Usage: $items = SortHelper::alphaNumericSort($myItemsArray, 'code');

SortHelper:

namespace App\Helpers;

use Illuminate\Support\Collection;

class SortHelper
{
    public static function alphaNumericSort($items, $column)
    {
        if (!($items instanceof Collection)) {
            return $items;
        }

        return $items->sortBy(function ($item) use ($column) {
            $value = $item->$column;

            if (is_numeric($value)) {
                return sprintf('%012d', $value);
            } else {
                return $value;
            }
        });
    }
}```